- Author
- Lluis TurrĂ³ Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g
Definition at line 41 of file DWIssueModel.java.
◆ getAssistantsId()
List org.turro.dossier.dw.DWIssueModel.getAssistantsId |
( |
| ) |
|
Definition at line 158 of file DWIssueModel.java.
159 WhereClause wc =
new WhereClause();
160 wc.addClause(
"select distinct participantId, count(distinct issueId)");
161 wc.addClause(
",(select count(distinct i2.issueId) from DWIssue i2 where i2.participantId = i.participantId and i2.status <> :status2 and i2.participantRole = :participantRole2)");
162 wc.addNamedValue(
"status2", IssueStatus.STATUS_CLOSED);
163 wc.addNamedValue(
"participantRole2", IssueParticipantRole.ISSUE_ASSISTANT);
164 wc.addClause(
"from DWIssue i");
165 wc.addClause(
"where participantRole = :participantRole");
166 wc.addNamedValue(
"participantRole", IssueParticipantRole.ISSUE_ASSISTANT);
167 addCriteriaParticipantExists(wc);
168 wc.addClause(
"group by participantId");
169 wc.addClause(
"order by 2 desc");
170 return getDao().getResultList(wc);
◆ getByResolution()
List org.turro.dossier.dw.DWIssueModel.getByResolution |
( |
| ) |
|
Definition at line 110 of file DWIssueModel.java.
111 WhereClause wc =
new WhereClause();
112 wc.addClause(
"select resolution, count(distinct issueId)");
113 wc.addClause(
"from DWIssue");
114 wc.addClause(
"where 1=1");
116 wc.addClause(
"group by resolution");
117 return getDao().getResultList(wc);
◆ getByStatus()
List org.turro.dossier.dw.DWIssueModel.getByStatus |
( |
| ) |
|
Definition at line 100 of file DWIssueModel.java.
101 WhereClause wc =
new WhereClause();
102 wc.addClause(
"select status, count(distinct issueId)");
103 wc.addClause(
"from DWIssue");
104 wc.addClause(
"where 1=1");
106 wc.addClause(
"group by status");
107 return getDao().getResultList(wc);
◆ getByType()
List org.turro.dossier.dw.DWIssueModel.getByType |
( |
| ) |
|
Definition at line 90 of file DWIssueModel.java.
91 WhereClause wc =
new WhereClause();
92 wc.addClause(
"select type, count(distinct issueId)");
93 wc.addClause(
"from DWIssue");
94 wc.addClause(
"where 1=1");
96 wc.addClause(
"group by type");
97 return getDao().getResultList(wc);
◆ getCategoryPath()
String org.turro.dossier.dw.DWIssueModel.getCategoryPath |
( |
| ) |
|
◆ getCommentCount()
Long org.turro.dossier.dw.DWIssueModel.getCommentCount |
( |
| ) |
|
Definition at line 81 of file DWIssueModel.java.
82 WhereClause wc =
new WhereClause();
83 wc.addClause(
"select sum(commentCount)");
84 wc.addClause(
"from DWIssue");
85 wc.addClause(
"where 1=1");
Object getSingleResultOrNull(SqlClause sc)
◆ getCount()
Long org.turro.dossier.dw.DWIssueModel.getCount |
( |
| ) |
|
Definition at line 53 of file DWIssueModel.java.
54 WhereClause wc =
new WhereClause();
55 wc.addClause(
"select count(distinct issueId)");
56 wc.addClause(
"from DWIssue");
57 wc.addClause(
"where 1=1");
◆ getDossier()
DWDossier org.turro.dossier.dw.DWIssueModel.getDossier |
( |
Long |
dossierId | ) |
|
Definition at line 194 of file DWIssueModel.java.
195 return getDao().find(DWDossier.class, dossierId);
◆ getDossierId()
Long org.turro.dossier.dw.DWIssueModel.getDossierId |
( |
| ) |
|
◆ getDossiersId()
Collection<Long> org.turro.dossier.dw.DWIssueModel.getDossiersId |
( |
| ) |
|
Definition at line 120 of file DWIssueModel.java.
121 WhereClause wc =
new WhereClause();
122 wc.addClause(
"select distinct dossierId");
123 wc.addClause(
"from DWIssue i");
125 return getDao().getResultList(wc);
◆ getEndDate()
Date org.turro.dossier.dw.DWIssueModel.getEndDate |
( |
| ) |
|
◆ getIContact()
IContact org.turro.dossier.dw.DWIssueModel.getIContact |
( |
String |
contactId | ) |
|
◆ getIParticipant()
IContact org.turro.dossier.dw.DWIssueModel.getIParticipant |
( |
| ) |
|
Definition at line 358 of file DWIssueModel.java.
359 if(_contact ==
null) {
360 _contact = Contacts.getContactById(participantId);
◆ getIssue()
DWIssue org.turro.dossier.dw.DWIssueModel.getIssue |
( |
Long |
issueId | ) |
|
◆ getOpenedCount()
Long org.turro.dossier.dw.DWIssueModel.getOpenedCount |
( |
| ) |
|
Definition at line 62 of file DWIssueModel.java.
63 WhereClause wc =
new WhereClause();
64 wc.addClause(
"select count(distinct issueId)");
65 wc.addClause(
"from DWIssue");
66 wc.addClause(
"where status <> :status");
67 wc.addNamedValue(
"status", IssueStatus.STATUS_CLOSED);
◆ getParticipantId()
String org.turro.dossier.dw.DWIssueModel.getParticipantId |
( |
| ) |
|
◆ getParticipantRole()
◆ getParticipantsCount()
Long org.turro.dossier.dw.DWIssueModel.getParticipantsCount |
( |
| ) |
|
Definition at line 72 of file DWIssueModel.java.
73 WhereClause wc =
new WhereClause();
74 wc.addClause(
"select count(participantId)");
75 wc.addClause(
"from DWIssue");
76 wc.addClause(
"where 1=1");
◆ getPriority()
◆ getQAsId()
List org.turro.dossier.dw.DWIssueModel.getQAsId |
( |
| ) |
|
Definition at line 173 of file DWIssueModel.java.
174 WhereClause wc =
new WhereClause();
175 wc.addClause(
"select distinct participantId, count(distinct issueId)");
176 wc.addClause(
",(select count(distinct i2.issueId) from DWIssue i2 where i2.participantId = i.participantId and i2.status <> :status2 and i2.participantRole = :participantRole2)");
177 wc.addNamedValue(
"status2", IssueStatus.STATUS_CLOSED);
178 wc.addNamedValue(
"participantRole2", IssueParticipantRole.ISSUE_QA);
179 wc.addClause(
"from DWIssue i");
180 wc.addClause(
"where participantRole = :participantRole");
181 wc.addNamedValue(
"participantRole", IssueParticipantRole.ISSUE_QA);
182 addCriteriaParticipantExists(wc);
183 wc.addClause(
"group by participantId");
184 wc.addClause(
"order by 2 desc");
185 return getDao().getResultList(wc);
◆ getReportersId()
List org.turro.dossier.dw.DWIssueModel.getReportersId |
( |
| ) |
|
Definition at line 143 of file DWIssueModel.java.
144 WhereClause wc =
new WhereClause();
145 wc.addClause(
"select distinct participantId, count(distinct issueId)");
146 wc.addClause(
",(select count(distinct i2.issueId) from DWIssue i2 where i2.participantId = i.participantId and i2.status <> :status2 and i2.participantRole = :participantRole2)");
147 wc.addNamedValue(
"status2", IssueStatus.STATUS_CLOSED);
148 wc.addNamedValue(
"participantRole2", IssueParticipantRole.ISSUE_REPORTER);
149 wc.addClause(
"from DWIssue i");
150 wc.addClause(
"where participantRole = :participantRole");
151 wc.addNamedValue(
"participantRole", IssueParticipantRole.ISSUE_REPORTER);
152 addCriteriaParticipantExists(wc);
153 wc.addClause(
"group by participantId");
154 wc.addClause(
"order by 2 desc");
155 return getDao().getResultList(wc);
◆ getResolution()
◆ getResponsiblesId()
List org.turro.dossier.dw.DWIssueModel.getResponsiblesId |
( |
| ) |
|
Definition at line 128 of file DWIssueModel.java.
129 WhereClause wc =
new WhereClause();
130 wc.addClause(
"select distinct participantId, count(distinct issueId)");
131 wc.addClause(
",(select count(distinct i2.issueId) from DWIssue i2 where i2.participantId = i.participantId and i2.status <> :status2 and i2.participantRole = :participantRole2)");
132 wc.addNamedValue(
"status2", IssueStatus.STATUS_CLOSED);
133 wc.addNamedValue(
"participantRole2", IssueParticipantRole.ISSUE_RESPONSIBLE);
134 wc.addClause(
"from DWIssue i");
135 wc.addClause(
"where participantRole = :participantRole");
136 wc.addNamedValue(
"participantRole", IssueParticipantRole.ISSUE_RESPONSIBLE);
137 addCriteriaParticipantExists(wc);
138 wc.addClause(
"group by participantId");
139 wc.addClause(
"order by 2 desc");
140 return getDao().getResultList(wc);
◆ getStartDate()
Date org.turro.dossier.dw.DWIssueModel.getStartDate |
( |
| ) |
|
◆ getStatus()
IssueStatus org.turro.dossier.dw.DWIssueModel.getStatus |
( |
| ) |
|
◆ getType()
IssueType org.turro.dossier.dw.DWIssueModel.getType |
( |
| ) |
|
◆ getVersionId()
Long org.turro.dossier.dw.DWIssueModel.getVersionId |
( |
| ) |
|
◆ setCategoryPath()
void org.turro.dossier.dw.DWIssueModel.setCategoryPath |
( |
String |
categoryPath | ) |
|
◆ setDossierId()
void org.turro.dossier.dw.DWIssueModel.setDossierId |
( |
Long |
dossierId | ) |
|
◆ setEndDate()
void org.turro.dossier.dw.DWIssueModel.setEndDate |
( |
Date |
endDate | ) |
|
◆ setIParticipant()
void org.turro.dossier.dw.DWIssueModel.setIParticipant |
( |
IContact |
contact | ) |
|
◆ setParticipantId()
void org.turro.dossier.dw.DWIssueModel.setParticipantId |
( |
String |
participantId | ) |
|
◆ setParticipantRole()
void org.turro.dossier.dw.DWIssueModel.setParticipantRole |
( |
ParticipantRole |
participantRole | ) |
|
◆ setPriority()
void org.turro.dossier.dw.DWIssueModel.setPriority |
( |
IssuePriority |
priority | ) |
|
◆ setResolution()
void org.turro.dossier.dw.DWIssueModel.setResolution |
( |
IssueResolution |
resolution | ) |
|
◆ setStartDate()
void org.turro.dossier.dw.DWIssueModel.setStartDate |
( |
Date |
startDate | ) |
|
◆ setStatus()
void org.turro.dossier.dw.DWIssueModel.setStatus |
( |
IssueStatus |
status | ) |
|
◆ setType()
void org.turro.dossier.dw.DWIssueModel.setType |
( |
IssueType |
type | ) |
|
◆ setVersionId()
void org.turro.dossier.dw.DWIssueModel.setVersionId |
( |
Long |
versionId | ) |
|
The documentation for this class was generated from the following file: