OWL ITS + 탐지시스템(인터넷 진흥원)
jhjang
2021-12-08 7b4b71ee33c7a42383d3e6a69885d521fd7b6688
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
package kr.wisestone.owl.mapper;
 
import kr.wisestone.owl.web.condition.WidgetCondition;
import org.springframework.stereotype.Repository;
 
import java.util.List;
import java.util.Map;
 
/**
 * Created by wisestone on 2018-01-11.
 */
@Repository
public interface WidgetMapper {
 
    // 완료된 이슈
    Long countCompleteIssue(WidgetCondition widgetCondition);
 
    //  미할당 이슈
    Long countNoAssigneeIssue(WidgetCondition widgetCondition);
 
    //  내가 등록한 이슈
    List<Map<String, Object>> findRegisterIssue(WidgetCondition widgetCondition);
    //  내가 오늘 등록한 이슈 갯수
    Long countTodayRegisterIssue(WidgetCondition widgetCondition);
    Long countRegisterIssue(WidgetCondition widgetCondition);
 
    //  할당된 이슈
    Long countAssigneeIssue(WidgetCondition widgetCondition);
 
    //  지연된 이슈
    List<Map<String, Object>> findDelayIssue(WidgetCondition widgetCondition);
    Long countDelayIssue(WidgetCondition widgetCondition);
    Long countTodayDelayIssue(WidgetCondition widgetCondition);
 
    //  잔여 이슈
    Long countRemainIssue(WidgetCondition widgetCondition);
 
    //  진행중인 프로젝트 현황(참여중인 프로젝트)
    List<Map<String, Object>> findProjectProgress(WidgetCondition widgetCondition);
 
    //  진행중인 프로젝트 현황(전체)
    List<Map<String, Object>> findProjectProgressAll(WidgetCondition widgetCondition);
 
    //  나에게 할당된 이슈
    List<Map<String, Object>> findMyAssigneeIssue(WidgetCondition widgetCondition);
    //  내가 오늘 할당받은 이슈 갯수
    Long countTodayMyAssigneeIssue(WidgetCondition widgetCondition);
    Long countMyAssigneeIssue(WidgetCondition widgetCondition);
 
    //  멤버별 진행률
    List<Map<String, Object>> findProjectMemberIssue(WidgetCondition widgetCondition);
 
    //  등록한 이슈 중 완료 갯수
    List<Map<String, Object>> findMyRegisterCompleteIssue(WidgetCondition widgetCondition);
    //  등록한 이슈 중 진행 갯수
    List<Map<String, Object>> findMyRegisterRemainIssue(WidgetCondition widgetCondition);
    //  담당한 이슈 중 완료 갯수
    List<Map<String, Object>> findMyAssigneeCompleteIssue(WidgetCondition widgetCondition);
    //  담당한 이슈 중 진행 갯수
    List<Map<String, Object>> findMyAssigneeRemainIssue(WidgetCondition widgetCondition);
 
    //  위험 관리
    List<Map<String, Object>> findRiskIssue(WidgetCondition widgetCondition);
    //Map<String, Object> countChangeStatusAndAssigneeIssue(WidgetCondition widgetCondition);
    Map<String, Object> countChangeStatusAndDepartmentIssue(WidgetCondition widgetCondition);
    Long countRiskIssue(WidgetCondition widgetCondition);
 
    //  전체 이슈 처리 현황
    List<Map<String, Object>> findIssueComplete(WidgetCondition widgetCondition);
    Long countTotalIssue(WidgetCondition widgetCondition);
 
    //  상태별 이슈 현황
    List<Map<String, Object>> findByStandIssueStatus(WidgetCondition widgetCondition);
 
    List<Map<String, Object>> findByStandIssueType(WidgetCondition widgetCondition);
 
    //중요도 별 이슈 갯수
    List<Map<String, Object>> countSeverityIssue(WidgetCondition widgetCondition);
    //중요도 이슈 목록
    List<Map<String, Object>> findSeverityIssues(WidgetCondition widgetCondition);
    //중요도 드롭다운 별 항목 갯수
    Long countSearchIssue(WidgetCondition widgetCondition);
 
    Long countRemainIssueByDepartment(WidgetCondition widgetCondition);
 
    Long countTodayDelayIssueByDepartment(WidgetCondition widgetCondition);
 
    Long countNoAssigneeIssueByDepartment(WidgetCondition widgetCondition);
 
    Long countTodayRegisterIssueByDepartment(WidgetCondition widgetCondition);
 
    Long countAssigneeIssueByDepartment(WidgetCondition widgetCondition);
 
    Long countCompleteIssueByDepartment(WidgetCondition widgetCondition);
 
    List<Map<String, Object>> countSeverityIssueByDepartment(WidgetCondition widgetCondition);
 
    List<Map<String, Object>> findSeverityIssuesByDepartment(WidgetCondition widgetCondition);
 
    Long countSearchIssueByDepartment(WidgetCondition widgetCondition);
 
    List<Map<String, Object>> findProjectMemberIssueByDepartment(WidgetCondition widgetCondition);
 
    List<Map<String, Object>> findMyAssigneeIssueByDepartment(WidgetCondition makeWidgetCondition);
 
    List<Map<String, Object>> findByStandIssueTypeOfDepartment(WidgetCondition widgetCondition);
 
    List<Map<String, Object>> findByStandIssueStatusOfDepartment(WidgetCondition widgetCondition);
}