◆ getByPhase()
List org.turro.dossier.dw.DWDossierModel.getByPhase |
( |
| ) |
|
Definition at line 85 of file DWDossierModel.java.
86 WhereClause wc =
new WhereClause();
87 wc.addClause(
"select phase, count(distinct dossierId)");
88 wc.addClause(
"from DWDossier");
89 wc.addClause(
"where phase is not null");
91 wc.addClause(
"group by phase");
92 return getDao().getResultList(wc);
◆ getByStatus()
List org.turro.dossier.dw.DWDossierModel.getByStatus |
( |
| ) |
|
Definition at line 75 of file DWDossierModel.java.
76 WhereClause wc =
new WhereClause();
77 wc.addClause(
"select status, count(distinct dossierId)");
78 wc.addClause(
"from DWDossier");
79 wc.addClause(
"where 1=1");
81 wc.addClause(
"group by status");
82 return getDao().getResultList(wc);
◆ getCount()
Long org.turro.dossier.dw.DWDossierModel.getCount |
( |
| ) |
|
Definition at line 46 of file DWDossierModel.java.
47 WhereClause wc =
new WhereClause();
48 wc.addClause(
"select count(distinct dossierId)");
49 wc.addClause(
"from DWDossier");
50 wc.addClause(
"where 1=1");
Object getSingleResultOrNull(SqlClause sc)
◆ getIParticipant()
IContact org.turro.dossier.dw.DWDossierModel.getIParticipant |
( |
| ) |
|
Definition at line 142 of file DWDossierModel.java.
143 if(_contact ==
null) {
144 _contact = Contacts.getContactById(participantId);
◆ getOpenedCount()
Long org.turro.dossier.dw.DWDossierModel.getOpenedCount |
( |
| ) |
|
Definition at line 65 of file DWDossierModel.java.
66 WhereClause wc =
new WhereClause();
67 wc.addClause(
"select count(distinct dossierId)");
68 wc.addClause(
"from DWDossier");
69 wc.addClause(
"where status <> :status");
70 wc.addNamedValue(
"status", DossierStatus.DOSSIER_CLOSED);
◆ getParticipantsCount()
Long org.turro.dossier.dw.DWDossierModel.getParticipantsCount |
( |
| ) |
|
Definition at line 95 of file DWDossierModel.java.
96 WhereClause wc =
new WhereClause();
97 wc.addClause(
"select count(participantId)");
98 wc.addClause(
"from DWDossier");
99 wc.addClause(
"where 1=1");
◆ getProjectCount()
Long org.turro.dossier.dw.DWDossierModel.getProjectCount |
( |
| ) |
|
Definition at line 55 of file DWDossierModel.java.
56 WhereClause wc =
new WhereClause();
57 wc.addClause(
"select count(distinct dossierId)");
58 wc.addClause(
"from DWDossier");
59 wc.addClause(
"where type=:type");
60 wc.addNamedValue(
"type", DossierType.TYPE_PROJECT);
◆ setIParticipant()
void org.turro.dossier.dw.DWDossierModel.setIParticipant |
( |
IContact |
contact | ) |
|
The documentation for this class was generated from the following file: