Produced by Araxis Merge on 9/11/2017 8:05:40 AM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.
# | Location | File | Last Modified |
---|---|---|---|
1 | MHV_CIF_2017.4.0.0.zip\MHV_CIF_2017.4.0.0\MHV_CIF_2017.4.0.0\sms_main\sms_source\mhv_sms_ng\mhv-sm-domain\src\main\java\gov\va\med\mhv\sm\dao\hibernate | ReportsDaoImpl.java | Sat May 13 00:13:58 2017 UTC |
2 | MHV_CIF_2017.4.0.0.zip\MHV_CIF_2017.4.0.0\MHV_CIF_2017.4.0.0\sms_main\sms_source\mhv_sms_ng\mhv-sm-domain\src\main\java\gov\va\med\mhv\sm\dao\hibernate | ReportsDaoImpl.java | Thu Sep 7 19:19:34 2017 UTC |
Description | Between Files 1 and 2 |
|
---|---|---|
Text Blocks | Lines | |
Unchanged | 2 | 1418 |
Changed | 1 | 2 |
Inserted | 0 | 0 |
Removed | 0 | 0 |
Whitespace | |
---|---|
Character case | Differences in character case are significant |
Line endings | Differences in line endings (CR and LF characters) are ignored |
CR/LF characters | Not shown in the comparison detail |
No regular expressions were active.
1 | package go v.va.med.m hv.sm.dao. hibernate; | |
2 | ||
3 | import gov .va.med.mh v.sm.dao.R eportsDao; | |
4 | import gov .va.med.mh v.sm.servi ce.impl.Re portsServi ceImpl; | |
5 | ||
6 | import jav a.util.Dat e; | |
7 | import jav a.util.Lis t; | |
8 | ||
9 | import org .apache.co mmons.logg ing.Log; | |
10 | import org .apache.co mmons.logg ing.LogFac tory; | |
11 | import org .springfra mework.orm .hibernate 3.support. HibernateD aoSupport; | |
12 | ||
13 | ||
14 | /** | |
15 | * @author DNS MCCARW | |
16 | * | |
17 | */ | |
18 | public cla ss Reports DaoImpl ex tends Hibe rnateDaoSu pport impl ements Rep ortsDao { | |
19 | pr ivate stat ic final L og log = L ogFactory. getLog(Rep ortsDaoImp l.class); | |
20 | ||
21 | pu blic List< Object[]> getCountRe portsDataF orAllTeams ByOneFacil ity(Date s tart,Date end,Long s tationNumb er,String period,Lis t<Long> su bCategorie s){ | |
22 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod", "sub Categories " }; | |
23 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period, s ubCategori es }; | |
24 | logP arameters( paramNames ,paramValu es); | |
25 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
26 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ FOR_ALL_TE AMS_BY_ONE _FACILITY, paramName s, paramVa lues ); | |
27 | retu rn l; | |
28 | } | |
29 | ||
30 | pu blic List< Object[]> getCountRe portsDataF orOneTeamA ndOneFacil ity(Date s tart,Date end,Long s tationNumb er,Long tr iageGroupI d,String p eriod,List <Long> sub Categories ){ | |
31 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period ","subCate gories" }; | |
32 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od, subCa tegories } ; | |
33 | logP arameters( paramNames ,paramValu es); | |
34 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
35 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ FOR_ONE_TE AM_AND_ONE _FACILITY, paramName s, paramVa lues ); | |
36 | retu rn l; | |
37 | } | |
38 | ||
39 | pu blic List< Object[]> getCountRe portsDataF orAllFacil itiesByOne Visn(Date start,Date end,Long visnId,Str ing period ,List subC ategories) { | |
40 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period","s ubCategori es" }; | |
41 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period , subCateg ories }; | |
42 | logP arameters( paramNames ,paramValu es); | |
43 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
44 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ FOR_ALL_FA CILITIES_B Y_ONE_VISN , paramNam es, paramV alues ); | |
45 | retu rn l; | |
46 | } | |
47 | ||
48 | pu blic List< Object[]> getCountRe portsDataF orOneFacil ityAndOneV isn(Date s tart,Date end,Long s tationNumb er,Long vi snId,Strin g period,L ist subCat egories){ | |
49 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod","subC ategories" }; | |
50 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod, sub Categories }; | |
51 | logP arameters( paramNames ,paramValu es); | |
52 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
53 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ FOR_ONE_FA CILITY_AND _ONE_VISN, paramName s, paramVa lues ); | |
54 | retu rn l; | |
55 | } | |
56 | ||
57 | pu blic List< Object[]> getCountRe portsDataF orAllVisns (Date star t,Date end ,String pe riod,List subCategor ies){ | |
58 | Stri ng[] param Names = ne w String[] { "start" , "end", " period","s ubCategori es" }; | |
59 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od, subCat egories }; | |
60 | logP arameters( paramNames ,paramValu es); | |
61 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
62 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ FOR_ALL_VI SNS, param Names, par amValues ) ; | |
63 | retu rn l; | |
64 | } | |
65 | ||
66 | pu blic List< Object[]> getCountRe portsDataF orOneVisn( Date start ,Date end, Long visnI d,String p eriod,List subCatego ries){ | |
67 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period","s ubCategori es" }; | |
68 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period , subCateg ories }; | |
69 | logP arameters( paramNames ,paramValu es); | |
70 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
71 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ FOR_ONE_VI SN, paramN ames, para mValues ); | |
72 | retu rn l; | |
73 | } | |
74 | ||
75 | ||
76 | /* | |
77 | * Counts li ve data se arches beg ins here: Unique Pat ient Sende rs | |
78 | * / | |
79 | pu blic List< Object[]> getCountRe portsDataU niquePatie ntSendersF orAllTeams ByOneFacil ity(Date s tart,Date end,Long s tationNumb er,String period){ | |
80 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod" }; | |
81 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period }; | |
82 | logP arameters( paramNames ,paramValu es); | |
83 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
84 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_PAT IENT_SENDE RS_FOR_ALL _TEAMS_BY_ ONE_FACILI TY, paramN ames, para mValues ); | |
85 | retu rn l; | |
86 | } | |
87 | pu blic List< Object[]> getCountRe portsDataU niquePatie ntSendersF orOneTeamA ndOneFacil ity(Date s tart,Date end,Long s tationNumb er,Long tr iageGroupI d,String p eriod){ | |
88 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period "}; | |
89 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od }; | |
90 | logP arameters( paramNames ,paramValu es); | |
91 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
92 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_PAT IENT_SENDE RS_FOR_ONE _TEAM_AND_ ONE_FACILI TY, paramN ames, para mValues ); | |
93 | retu rn l; | |
94 | } | |
95 | pu blic List< Object[]> getCountRe portsDataU niquePatie ntSendersF orAllFacil itiesByOne Visn(Date start,Date end,Long visnId,Str ing period ){ | |
96 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
97 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
98 | logP arameters( paramNames ,paramValu es); | |
99 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
100 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_PAT IENT_SENDE RS_FOR_ALL _FACILITIE S_BY_ONE_V ISN, param Names, par amValues ) ; | |
101 | retu rn l; | |
102 | } | |
103 | pu blic List< Object[]> getCountRe portsDataU niquePatie ntSendersF orOneFacil ityAndOneV isn(Date s tart,Date end,Long s tationNumb er,Long vi snId,Strin g period){ | |
104 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod" }; | |
105 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod }; | |
106 | logP arameters( paramNames ,paramValu es); | |
107 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
108 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_PAT IENT_SENDE RS_FOR_ONE _FACILITY_ AND_ONE_VI SN, paramN ames, para mValues ); | |
109 | retu rn l; | |
110 | } | |
111 | pu blic List< Object[]> getCountRe portsDataU niquePatie ntSendersF orAllVisns (Date star t,Date end ,String pe riod){ | |
112 | Stri ng[] param Names = ne w String[] { "start" , "end", " period" }; | |
113 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od }; | |
114 | logP arameters( paramNames ,paramValu es); | |
115 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
116 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_PAT IENT_SENDE RS_FOR_ALL _VISNS, pa ramNames, paramValue s ); | |
117 | retu rn l; | |
118 | } | |
119 | pu blic List< Object[]> getCountRe portsDataU niquePatie ntSendersF orOneVisn( Date start ,Date end, Long visnI d,String p eriod){ | |
120 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
121 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
122 | logP arameters( paramNames ,paramValu es); | |
123 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
124 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_PAT IENT_SENDE RS_FOR_ONE _VISN, par amNames, p aramValues ); | |
125 | retu rn l; | |
126 | } | |
127 | /* | |
128 | * Counts li ve data se arches beg ins here: Unique Tea m Member S enders | |
129 | * / | |
130 | pu blic List< Object[]> getCountRe portsDataU niqueMembe rSendersFo rAllTeamsB yOneFacili ty(Date st art,Date e nd,Long st ationNumbe r,String p eriod){ | |
131 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod" }; | |
132 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period }; | |
133 | logP arameters( paramNames ,paramValu es); | |
134 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
135 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_MEM BER_SENDER S_FOR_ALL_ TEAMS_BY_O NE_FACILIT Y, paramNa mes, param Values ); | |
136 | retu rn l; | |
137 | } | |
138 | pu blic List< Object[]> getCountRe portsDataU niqueMembe rSendersFo rOneTeamAn dOneFacili ty(Date st art,Date e nd,Long st ationNumbe r,Long tri ageGroupId ,String pe riod){ | |
139 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period "}; | |
140 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od }; | |
141 | logP arameters( paramNames ,paramValu es); | |
142 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
143 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_MEM BER_SENDER S_FOR_ONE_ TEAM_AND_O NE_FACILIT Y, paramNa mes, param Values ); | |
144 | retu rn l; | |
145 | } | |
146 | pu blic List< Object[]> getCountRe portsDataU niqueMembe rSendersFo rAllFacili tiesByOneV isn(Date s tart,Date end,Long v isnId,Stri ng period) { | |
147 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
148 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
149 | logP arameters( paramNames ,paramValu es); | |
150 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
151 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_MEM BER_SENDER S_FOR_ALL_ FACILITIES _BY_ONE_VI SN, paramN ames, para mValues ); | |
152 | retu rn l; | |
153 | } | |
154 | pu blic List< Object[]> getCountRe portsDataU niqueMembe rSendersFo rOneFacili tyAndOneVi sn(Date st art,Date e nd,Long st ationNumbe r,Long vis nId,String period){ | |
155 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod" }; | |
156 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod }; | |
157 | logP arameters( paramNames ,paramValu es); | |
158 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
159 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_MEM BER_SENDER S_FOR_ONE_ FACILITY_A ND_ONE_VIS N, paramNa mes, param Values ); | |
160 | retu rn l; | |
161 | } | |
162 | pu blic List< Object[]> getCountRe portsDataU niqueMembe rSendersFo rAllVisns( Date start ,Date end, String per iod){ | |
163 | Stri ng[] param Names = ne w String[] { "start" , "end", " period" }; | |
164 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od }; | |
165 | logP arameters( paramNames ,paramValu es); | |
166 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
167 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_MEM BER_SENDER S_FOR_ALL_ VISNS, par amNames, p aramValues ); | |
168 | retu rn l; | |
169 | } | |
170 | pu blic List< Object[]> getCountRe portsDataU niqueMembe rSendersFo rOneVisn(D ate start, Date end,L ong visnId ,String pe riod){ | |
171 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
172 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
173 | logP arameters( paramNames ,paramValu es); | |
174 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
175 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ UNIQUE_MEM BER_SENDER S_FOR_ONE_ VISN, para mNames, pa ramValues ); | |
176 | retu rn l; | |
177 | } | |
178 | ||
179 | /* * | |
180 | * | |
181 | * Counts Li ve Data fo r OptedIn Patients | |
182 | * | |
183 | * / | |
184 | pu blic List< Object[]> getCountRe portsDataO ptedInPati entsForAll TeamsByOne Facility(D ate start, Date end,L ong statio nNumber,St ring perio d){ | |
185 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod" }; | |
186 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period }; | |
187 | logP arameters( paramNames ,paramValu es); | |
188 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
189 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_IN_P ATIENTS_FO R_ALL_TEAM S_BY_ONE_F ACILITY, p aramNames, paramValu es ); | |
190 | retu rn l; | |
191 | ||
192 | } | |
193 | ||
194 | pu blic List< Object[]> getCountRe portsDataO ptedInPati entsForOne TeamAndOne Facility(D ate start, Date end,L ong statio nNumber,Lo ng triageG roupId,Str ing period ){ | |
195 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period " }; | |
196 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od }; | |
197 | logP arameters( paramNames ,paramValu es); | |
198 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
199 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_IN_P ATIENTS_FO R_ONE_TEAM _AND_ONE_F ACILITY, p aramNames, paramValu es ); | |
200 | retu rn l; | |
201 | } | |
202 | ||
203 | ||
204 | pu blic List< Object[]> getCountRe portsDataO ptedInPati entsForAll Facilities ByOneVisn( Date start ,Date end, Long visnI d,String p eriod){ | |
205 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
206 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
207 | logP arameters( paramNames ,paramValu es); | |
208 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
209 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_IN_P ATIENTS_FO R_ALL_FACI LITIES_BY_ ONE_VISN, paramNames , paramVal ues ); | |
210 | retu rn l; | |
211 | ||
212 | } | |
213 | ||
214 | pu blic List< Object[]> getCountRe portsDataO ptedInPati entsForOne FacilityAn dOneVisn(D ate start, Date end,L ong statio nNumber,Lo ng visnId, String per iod){ | |
215 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod" }; | |
216 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod }; | |
217 | logP arameters( paramNames ,paramValu es); | |
218 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
219 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_IN_P ATIENTS_FO R_ONE_FACI LITY_AND_O NE_VISN, p aramNames, paramValu es ); | |
220 | retu rn l; | |
221 | ||
222 | } | |
223 | ||
224 | pu blic List< Object[]> getCountRe portsDataO ptedInPati entsForAll Visns(Date start,Dat e end,Stri ng period) { | |
225 | Stri ng[] param Names = ne w String[] { "start" , "end", " period" }; | |
226 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od }; | |
227 | logP arameters( paramNames ,paramValu es); | |
228 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
229 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_IN_P ATIENTS_FO R_ALL_VISN S, paramNa mes, param Values ); | |
230 | retu rn l; | |
231 | ||
232 | } | |
233 | ||
234 | pu blic List< Object[]> getCountRe portsDataO ptedInPati entsForOne Visn(Date start,Date end,Long visnId,Str ing period ){ | |
235 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
236 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
237 | logP arameters( paramNames ,paramValu es); | |
238 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
239 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_IN_P ATIENTS_FO R_ONE_VISN , paramNam es, paramV alues ); | |
240 | retu rn l; | |
241 | } | |
242 | ||
243 | ||
244 | /* * | |
245 | * | |
246 | * Counts Li ve Data fo r Blocked Patient | |
247 | * | |
248 | * / | |
249 | pu blic List< Object[]> getCountRe portsDataB lockedPati entsForAll TeamsByOne Facility(D ate start, Date end,L ong statio nNumber,St ring perio d){ | |
250 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod" }; | |
251 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period }; | |
252 | logP arameters( paramNames ,paramValu es); | |
253 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
254 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ BLOCKED_PA TIENTS_FOR _ALL_TEAMS _BY_ONE_FA CILITY, pa ramNames, paramValue s ); | |
255 | retu rn l; | |
256 | ||
257 | } | |
258 | ||
259 | pu blic List< Object[]> getCountRe portsDataB lockedPati entsForOne TeamAndOne Facility(D ate start, Date end,L ong statio nNumber,Lo ng triageG roupId,Str ing period ){ | |
260 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period " }; | |
261 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od }; | |
262 | logP arameters( paramNames ,paramValu es); | |
263 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
264 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ BLOCKED_PA TIENTS_FOR _ONE_TEAM_ AND_ONE_FA CILITY, pa ramNames, paramValue s ); | |
265 | retu rn l; | |
266 | } | |
267 | ||
268 | pu blic List< Object[]> getCountRe portsDataB lockedPati entsForAll Facilities ByOneVisn( Date start ,Date end, Long visnI d,String p eriod){ | |
269 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
270 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
271 | logP arameters( paramNames ,paramValu es); | |
272 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
273 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ BLOCKED_PA TIENTS_FOR _ALL_FACIL ITIES_BY_O NE_VISN, p aramNames, paramValu es ); | |
274 | retu rn l; | |
275 | ||
276 | } | |
277 | ||
278 | pu blic List< Object[]> getCountRe portsDataB lockedPati entsForOne FacilityAn dOneVisn(D ate start, Date end,L ong statio nNumber,Lo ng visnId, String per iod){ | |
279 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod" }; | |
280 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod }; | |
281 | logP arameters( paramNames ,paramValu es); | |
282 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
283 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ BLOCKED_PA TIENTS_FOR _ONE_FACIL ITY_AND_ON E_VISN, pa ramNames, paramValue s ); | |
284 | retu rn l; | |
285 | ||
286 | } | |
287 | ||
288 | pu blic List< Object[]> getCountRe portsDataB lockedPati entsForAll Visns(Date start,Dat e end,Stri ng period) { | |
289 | Stri ng[] param Names = ne w String[] { "start" , "end", " period" }; | |
290 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od }; | |
291 | logP arameters( paramNames ,paramValu es); | |
292 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
293 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ BLOCKED_PA TIENTS_FOR _ALL_VISNS , paramNam es, paramV alues ); | |
294 | retu rn l; | |
295 | ||
296 | } | |
297 | ||
298 | pu blic List< Object[]> getCountRe portsDataB lockedPati entsForOne Visn(Date start,Date end,Long visnId,Str ing period ){ | |
299 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
300 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
301 | logP arameters( paramNames ,paramValu es); | |
302 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
303 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ BLOCKED_PA TIENTS_FOR _ONE_VISN, paramName s, paramVa lues ); | |
304 | retu rn l; | |
305 | } | |
306 | ||
307 | /* * | |
308 | * | |
309 | * Counts Li ve Data fo r OptedOut Patients | |
310 | * | |
311 | * / | |
312 | pu blic List< Object[]> getCountRe portsDataO ptedOutPat ientsForAl lTeamsByOn eFacility( Date start ,Date end, Long stati onNumber,S tring peri od){ | |
313 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod" }; | |
314 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period }; | |
315 | logP arameters( paramNames ,paramValu es); | |
316 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
317 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_OUT_ PATIENTS_F OR_ALL_TEA MS_BY_ONE_ FACILITY, paramNames , paramVal ues ); | |
318 | retu rn l; | |
319 | ||
320 | } | |
321 | ||
322 | pu blic List< Object[]> getCountRe portsDataO ptedOutPat ientsForOn eTeamAndOn eFacility( Date start ,Date end, Long stati onNumber,L ong triage GroupId,St ring perio d){ | |
323 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period " }; | |
324 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od }; | |
325 | logP arameters( paramNames ,paramValu es); | |
326 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
327 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_OUT_ PATIENTS_F OR_ONE_TEA M_AND_ONE_ FACILITY, paramNames , paramVal ues ); | |
328 | retu rn l; | |
329 | } | |
330 | ||
331 | ||
332 | pu blic List< Object[]> getCountRe portsDataO ptedOutPat ientsForAl lFacilitie sByOneVisn (Date star t,Date end ,Long visn Id,String period){ | |
333 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
334 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
335 | logP arameters( paramNames ,paramValu es); | |
336 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
337 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_OUT_ PATIENTS_F OR_ALL_FAC ILITIES_BY _ONE_VISN, paramName s, paramVa lues ); | |
338 | retu rn l; | |
339 | ||
340 | } | |
341 | ||
342 | pu blic List< Object[]> getCountRe portsDataO ptedOutPat ientsForOn eFacilityA ndOneVisn( Date start ,Date end, Long stati onNumber,L ong visnId ,String pe riod){ | |
343 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod" }; | |
344 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod }; | |
345 | logP arameters( paramNames ,paramValu es); | |
346 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
347 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_OUT_ PATIENTS_F OR_ONE_FAC ILITY_AND_ ONE_VISN, paramNames , paramVal ues ); | |
348 | retu rn l; | |
349 | ||
350 | } | |
351 | ||
352 | pu blic List< Object[]> getCountRe portsDataO ptedOutPat ientsForAl lVisns(Dat e start,Da te end,Str ing period ){ | |
353 | Stri ng[] param Names = ne w String[] { "start" , "end", " period" }; | |
354 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od }; | |
355 | logP arameters( paramNames ,paramValu es); | |
356 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
357 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_OUT_ PATIENTS_F OR_ALL_VIS NS, paramN ames, para mValues ); | |
358 | retu rn l; | |
359 | ||
360 | } | |
361 | ||
362 | pu blic List< Object[]> getCountRe portsDataO ptedOutPat ientsForOn eVisn(Date start,Dat e end,Long visnId,St ring perio d){ | |
363 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
364 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
365 | logP arameters( paramNames ,paramValu es); | |
366 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
367 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ OPTED_OUT_ PATIENTS_F OR_ONE_VIS N, paramNa mes, param Values ); | |
368 | retu rn l; | |
369 | } | |
370 | ||
371 | ||
372 | /* * | |
373 | * | |
374 | * Counts Li ve Data fo r Action P ending Pat ients | |
375 | * | |
376 | * / | |
377 | pu blic List< Object[]> getCountRe portsDataA ctionPendi ngPatients ForAllTeam sByOneFaci lity(Date start,Date end,Long stationNum ber,String period){ | |
378 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod" }; | |
379 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period }; | |
380 | logP arameters( paramNames ,paramValu es); | |
381 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
382 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ ACTION_PEN DING_PATIE NTS_FOR_AL L_TEAMS_BY _ONE_FACIL ITY, param Names, par amValues ) ; | |
383 | retu rn l; | |
384 | ||
385 | } | |
386 | ||
387 | pu blic List< Object[]> getCountRe portsDataA ctionPendi ngPatients ForOneTeam AndOneFaci lity(Date start,Date end,Long stationNum ber,Long t riageGroup Id,String period){ | |
388 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period " }; | |
389 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od }; | |
390 | logP arameters( paramNames ,paramValu es); | |
391 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
392 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ ACTION_PEN DING_PATIE NTS_FOR_ON E_TEAM_AND _ONE_FACIL ITY, param Names, par amValues ) ; | |
393 | retu rn l; | |
394 | } | |
395 | ||
396 | ||
397 | pu blic List< Object[]> getCountRe portsDataA ctionPendi ngPatients ForAllFaci litiesByOn eVisn(Date start,Dat e end,Long visnId,St ring perio d){ | |
398 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
399 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
400 | logP arameters( paramNames ,paramValu es); | |
401 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
402 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ ACTION_PEN DING_PATIE NTS_FOR_AL L_FACILITI ES_BY_ONE_ VISN, para mNames, pa ramValues ); | |
403 | retu rn l; | |
404 | ||
405 | } | |
406 | ||
407 | pu blic List< Object[]> getCountRe portsDataA ctionPendi ngPatients ForOneFaci lityAndOne Visn(Date start,Date end,Long stationNum ber,Long v isnId,Stri ng period) { | |
408 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod" }; | |
409 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod }; | |
410 | logP arameters( paramNames ,paramValu es); | |
411 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
412 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ ACTION_PEN DING_PATIE NTS_FOR_ON E_FACILITY _AND_ONE_V ISN, param Names, par amValues ) ; | |
413 | retu rn l; | |
414 | ||
415 | } | |
416 | ||
417 | pu blic List< Object[]> getCountRe portsDataA ctionPendi ngPatients ForAllVisn s(Date sta rt,Date en d,String p eriod){ | |
418 | Stri ng[] param Names = ne w String[] { "start" , "end", " period" }; | |
419 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od }; | |
420 | logP arameters( paramNames ,paramValu es); | |
421 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
422 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ ACTION_PEN DING_PATIE NTS_FOR_AL L_VISNS, p aramNames, paramValu es ); | |
423 | retu rn l; | |
424 | ||
425 | } | |
426 | ||
427 | pu blic List< Object[]> getCountRe portsDataA ctionPendi ngPatients ForOneVisn (Date star t,Date end ,Long visn Id,String period){ | |
428 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
429 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
430 | logP arameters( paramNames ,paramValu es); | |
431 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
432 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ ACTION_PEN DING_PATIE NTS_FOR_ON E_VISN, pa ramNames, paramValue s ); | |
433 | retu rn l; | |
434 | } | |
435 | ||
436 | ||
437 | ||
438 | ||
439 | /* * | |
440 | * | |
441 | * Counts Re port Data for Educat ion Catego ry | |
442 | * | |
443 | * / | |
444 | pu blic List< Object[]> getCountRe portsDataE ducationCa tegoryForA llTeamsByO neFacility (Date star t,Date end ,Long stat ionNumber, String per iod){ | |
445 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "per iod" }; | |
446 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, period }; | |
447 | logP arameters( paramNames ,paramValu es); | |
448 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
449 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ EDUCATION_ CATEGORY_F OR_ALL_TEA MS_BY_ONE_ FACILITY, paramNames , paramVal ues ); | |
450 | retu rn l; | |
451 | ||
452 | } | |
453 | ||
454 | pu blic List< Object[]> getCountRe portsDataE ducationCa tegoryForO neTeamAndO neFacility (Date star t,Date end ,Long stat ionNumber, Long triag eGroupId,S tring peri od){ | |
455 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "tri ageGroupId ", "period " }; | |
456 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, triageGro upId, peri od }; | |
457 | logP arameters( paramNames ,paramValu es); | |
458 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
459 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ EDUCATION_ CATEGORY_F OR_ONE_TEA M_AND_ONE_ FACILITY, paramNames , paramVal ues ); | |
460 | retu rn l; | |
461 | } | |
462 | ||
463 | ||
464 | pu blic List< Object[]> getCountRe portsDataE ducationCa tegoryForA llFaciliti esByOneVis n(Date sta rt,Date en d,Long vis nId,String period){ | |
465 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
466 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
467 | logP arameters( paramNames ,paramValu es); | |
468 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
469 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ EDUCATION_ CATEGORY_F OR_ALL_FAC ILITIES_BY _ONE_VISN, paramName s, paramVa lues ); | |
470 | retu rn l; | |
471 | ||
472 | } | |
473 | ||
474 | pu blic List< Object[]> getCountRe portsDataE ducationCa tegoryForO neFacility AndOneVisn (Date star t,Date end ,Long stat ionNumber, Long visnI d,String p eriod){ | |
475 | Stri ng[] param Names = ne w String[] { "start" , "end", " stationNum ber", "vis nId", "per iod" }; | |
476 | Obje ct[] param Values = n ew Object[ ] { start, end, stat ionNumber, visnId, p eriod }; | |
477 | logP arameters( paramNames ,paramValu es); | |
478 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
479 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ EDUCATION_ CATEGORY_F OR_ONE_FAC ILITY_AND_ ONE_VISN, paramNames , paramVal ues ); | |
480 | retu rn l; | |
481 | ||
482 | } | |
483 | ||
484 | pu blic List< Object[]> getCountRe portsDataE ducationCa tegoryForA llVisns(Da te start,D ate end,St ring perio d){ | |
485 | Stri ng[] param Names = ne w String[] { "start" , "end", " period" }; | |
486 | Obje ct[] param Values = n ew Object[ ] { start, end, peri od }; | |
487 | logP arameters( paramNames ,paramValu es); | |
488 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
489 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ EDUCATION_ CATEGORY_F OR_ALL_VIS NS, paramN ames, para mValues ); | |
490 | retu rn l; | |
491 | ||
492 | } | |
493 | ||
494 | pu blic List< Object[]> getCountRe portsDataE ducationCa tegoryForO neVisn(Dat e start,Da te end,Lon g visnId,S tring peri od){ | |
495 | Stri ng[] param Names = ne w String[] { "start" , "end", " visnId", " period" }; | |
496 | Obje ct[] param Values = n ew Object[ ] { start, end, visn Id, period }; | |
497 | logP arameters( paramNames ,paramValu es); | |
498 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
499 | ReportsD ao.QRY_GET _COUNT_REP ORTS_DATA_ EDUCATION_ CATEGORY_F OR_ONE_VIS N, paramNa mes, param Values ); | |
500 | retu rn l; | |
501 | } | |
502 | ||
503 | ||
504 | /* | |
505 | * List Rep orts metho ds Starts here | |
506 | * @see gov. va.med.mhv .sm.dao.Re portsDao#g etListsHea lthcareTea msDataForO neVisn(jav a.lang.Lon g) | |
507 | * / | |
508 | pu blic List< Object[]> getListsHe althcareTe amsDataFor AllFacilit iesByOneVi sn(Long vi snId){ | |
509 | Stri ng[] param Names = ne w String[] { "visnId " }; | |
510 | Obje ct[] param Values = n ew Object[ ] { visnId }; | |
511 | logP arameters( paramNames ,paramValu es); | |
512 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
513 | ReportsD ao.QRY_GET _LISTS_HEA LTHCARE_TE AMS_DATA_F OR_ALL_FAC ILITIES_BY _ONE_VISN, paramName s, paramVa lues ); | |
514 | retu rn l; | |
515 | } | |
516 | ||
517 | pu blic List< Object[]> getListsHe althcareTe amsDataFor OneFacilit y(Long sta tionNumber ){ | |
518 | Stri ng[] param Names = ne w String[] { "statio nNumber" } ; | |
519 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
520 | logP arameters( paramNames ,paramValu es); | |
521 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
522 | ReportsD ao.QRY_GET _LISTS_HEA LTHCARE_TE AMS_DATA_F OR_ONE_FAC ILITY, par amNames, p aramValues ); | |
523 | retu rn l; | |
524 | } | |
525 | ||
526 | /* Facility Level Repo rt */ | |
527 | pu blic List< Object[]> getListsHe althcareTe amsDataFor OneTeam(Lo ng triageG roupId){ | |
528 | Stri ng[] param Names = ne w String[] { "triage GroupId" } ; | |
529 | Obje ct[] param Values = n ew Object[ ] { triage GroupId.to String() } ; | |
530 | logP arameters( paramNames ,paramValu es); | |
531 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
532 | ReportsD ao.QRY_GET _LISTS_HEA LTHCARE_TE AMS_DATA_F OR_ONE_TEA M, paramNa mes, param Values ); | |
533 | retu rn l; | |
534 | } | |
535 | ||
536 | /* Facility Level Repo rt */ | |
537 | pu blic List< Object[]> getListsHe althcareTe amsDataFor AllTeamsBy OneFacilit y(Long sta tionNumber ){ | |
538 | Stri ng[] param Names = ne w String[] { "statio nNumber"}; | |
539 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
540 | logP arameters( paramNames ,paramValu es); | |
541 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
542 | ReportsD ao.QRY_GET _LISTS_HEA LTHCARE_TE AMS_DATA_F OR_ALL_TEA MS_BY_ONE_ FACILITY, paramNames , paramVal ues ); | |
543 | retu rn l; | |
544 | } | |
545 | ||
546 | ||
547 | ||
548 | pu blic List< Object[]> getListsHe althcareTe amMembersD ataForOneT eam(Long t riageGroup Id){ | |
549 | Stri ng[] param Names = ne w String[] { "triage GroupId"}; | |
550 | Obje ct[] param Values = n ew Object[ ] { triage GroupId }; | |
551 | logP arameters( paramNames ,paramValu es); | |
552 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
553 | ReportsD ao.QRY_GET _LISTS_HEA LTHCARE_TE AMMEMBERS_ DATA_FOR_O NE_TEAM, p aramNames, paramValu es ); | |
554 | retu rn l; | |
555 | } | |
556 | ||
557 | ||
558 | pu blic List< Object[]> getListsHe althcareTe amMembersD ataForAllT eamsByOneF acility(Lo ng station Number){ | |
559 | Stri ng[] param Names = ne w String[] { "statio nNumber"}; | |
560 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
561 | logP arameters( paramNames ,paramValu es); | |
562 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
563 | ReportsD ao.QRY_GET _LISTS_HEA LTHCARE_TE AMMEMBERS_ DATA_FOR_A LL_TEAMS_B Y_ONE_FACI LITY, para mNames, pa ramValues ); | |
564 | retu rn l; | |
565 | } | |
566 | ||
567 | pu blic List< Object[]> getListsBl ockedPatie ntsDataFor OneTeam(Lo ng triageG roupId){ | |
568 | Stri ng[] param Names = ne w String[] { "triage GroupId"}; | |
569 | Obje ct[] param Values = n ew Object[ ] { triage GroupId }; | |
570 | logP arameters( paramNames ,paramValu es); | |
571 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
572 | ReportsD ao.QRY_GET _LISTS_BLO CKED_PATIE NTS_DATA_F OR_ONE_TEA M, paramNa mes, param Values ); | |
573 | retu rn l; | |
574 | } | |
575 | ||
576 | pu blic List< Object[]> getListsBl ockedPatie ntsDataFor AllTeamsBy OneFacilit y(Long sta tionNumber ){ | |
577 | Stri ng[] param Names = ne w String[] { "statio nNumber"}; | |
578 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String()}; | |
579 | logP arameters( paramNames ,paramValu es); | |
580 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
581 | ReportsD ao.QRY_GET _LISTS_BLO CKED_PATIE NTS_DATA_F OR_ALL_TEA MS_BY_ONE_ FACILITY, paramNames , paramVal ues ); | |
582 | retu rn l; | |
583 | } | |
584 | ||
585 | pu blic List< Object[]> getListsBl ockedPatie ntsDataFor OneFacilit y(Long sta tionNumber ){ | |
586 | Stri ng[] param Names = ne w String[] { "statio nNumber"}; | |
587 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
588 | logP arameters( paramNames ,paramValu es); | |
589 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
590 | ReportsD ao.QRY_GET _LISTS_BLO CKED_PATIE NTS_DATA_F OR_ONE_FAC ILITY, par amNames, p aramValues ); | |
591 | retu rn l; | |
592 | } | |
593 | ||
594 | pu blic List< Object[]> getListsBl ockedPatie ntsDataFor AllFacilit iesByOneVi sn(Long vi snId){ | |
595 | Stri ng[] param Names = ne w String[] { "visnId "}; | |
596 | Obje ct[] param Values = n ew Object[ ] { visnId }; | |
597 | logP arameters( paramNames ,paramValu es); | |
598 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
599 | ReportsD ao.QRY_GET _LISTS_BLO CKED_PATIE NTS_DATA_F OR_ALL_FAC ILTIES_BY_ ONE_VISN, paramNames , paramVal ues ); | |
600 | retu rn l; | |
601 | } | |
602 | ||
603 | pu blic List< Object[]> getListsOp tedInPatie ntsDataFor OneTeam(Lo ng triageG roupId){ | |
604 | Stri ng[] param Names = ne w String[] { "triage GroupId"}; | |
605 | Obje ct[] param Values = n ew Object[ ] { triage GroupId}; | |
606 | logP arameters( paramNames ,paramValu es); | |
607 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
608 | ReportsD ao.QRY_GET _LISTS_OPT ED_IN_PATI ENTS_DATA_ FOR_ONE_TE AM, paramN ames, para mValues ); | |
609 | retu rn l; | |
610 | } | |
611 | ||
612 | pu blic List< Object[]> getListsOp tedInPatie ntsDataFor AllTeamsBy OneFacilit y(Long sta tionNumber ){ | |
613 | Stri ng[] param Names = ne w String[] { "statio nNumber"}; | |
614 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String()}; | |
615 | logP arameters( paramNames ,paramValu es); | |
616 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
617 | ReportsD ao.QRY_GET _LISTS_OPT ED_IN_PATI ENTS_DATA_ FOR_ALL_TE AMS_BY_ONE _FACILITY, paramName s, paramVa lues ); | |
618 | retu rn l; | |
619 | } | |
620 | ||
621 | pu blic List< Object[]> getListsOp tedOutPati entsDataFo rOneTeam(L ong triage GroupId){ | |
622 | Stri ng[] param Names = ne w String[] { "triage GroupId"}; | |
623 | Obje ct[] param Values = n ew Object[ ] { triage GroupId }; | |
624 | logP arameters( paramNames ,paramValu es); | |
625 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
626 | ReportsD ao.QRY_GET _LISTS_OPT ED_OUT_PAT IENTS_DATA _FOR_ONE_T EAM, param Names, par amValues ) ; | |
627 | retu rn l; | |
628 | } | |
629 | ||
630 | pu blic List< Object[]> getListsOp tedOutPati entsDataFo rAllTeamsB yOneFacili ty(Long st ationNumbe r){ | |
631 | Stri ng[] param Names = ne w String[] { "statio nNumber" } ; | |
632 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
633 | logP arameters( paramNames ,paramValu es); | |
634 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
635 | ReportsD ao.QRY_GET _LISTS_OPT ED_OUT_PAT IENTS_DATA _FOR_ALL_T EAMS_BY_ON E_FACILITY , paramNam es, paramV alues ); | |
636 | retu rn l; | |
637 | } | |
638 | ||
639 | pu blic List< Object[]> getListsAc tionPendin gPatientsD ataForOneT eam(Long t riageGroup Id){ | |
640 | Stri ng[] param Names = ne w String[] { "triage GroupId" } ; | |
641 | Obje ct[] param Values = n ew Object[ ] { triage GroupId }; | |
642 | logP arameters( paramNames ,paramValu es); | |
643 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
644 | ReportsD ao.QRY_GET _LISTS_ACT ION_PENDIN G_PATIENTS _DATA_FOR_ ONE_TEAM, paramNames , paramVal ues ); | |
645 | retu rn l; | |
646 | } | |
647 | ||
648 | pu blic List< Object[]> getListsAc tionPendin gPatientsD ataForAllT eamsByOneF acility(Lo ng station Number){ | |
649 | Stri ng[] param Names = ne w String[] { "statio nNumber" } ; | |
650 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
651 | logP arameters( paramNames ,paramValu es); | |
652 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
653 | ReportsD ao.QRY_GET _LISTS_ACT ION_PENDIN G_PATIENTS _DATA_FOR_ ALL_TEAMS_ BY_ONE_FAC ILITY, par amNames, p aramValues ); | |
654 | retu rn l; | |
655 | } | |
656 | ||
657 | pu blic List< Object[]> getListsAs sociatedPa tientsData ForOneTeam (Long tria geGroupId) { | |
658 | Stri ng[] param Names = ne w String[] { "triage GroupId" } ; | |
659 | Obje ct[] param Values = n ew Object[ ] { triage GroupId }; | |
660 | logP arameters( paramNames ,paramValu es); | |
661 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
662 | ReportsD ao.QRY_GET _LISTS_ASS OCIATED_PA TIENTS_DAT A_FOR_ONE_ TEAM, para mNames, pa ramValues ); | |
663 | retu rn l; | |
664 | } | |
665 | ||
666 | pu blic List< Object[]> getListsAs sociatedPa tientsData ForAllTeam sByOneFaci lity(Long stationNum ber){ | |
667 | Stri ng[] param Names = ne w String[] { "statio nNumber" } ; | |
668 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
669 | logP arameters( paramNames ,paramValu es); | |
670 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
671 | ReportsD ao.QRY_GET _LISTS_ASS OCIATED_PA TIENTS_DAT A_FOR_ALL_ TEAMS_BY_O NE_FACILIT Y, paramNa mes, param Values ); | |
672 | retu rn l; | |
673 | } | |
674 | ||
675 | pu blic List< Object[]> getListsCP RSTiuFailu reDataForO neTeam(Lon g triageGr oupId){ | |
676 | Stri ng[] param Names = ne w String[] { "triage GroupId" } ; | |
677 | Obje ct[] param Values = n ew Object[ ] { triage GroupId }; | |
678 | logP arameters( paramNames ,paramValu es); | |
679 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
680 | ReportsD ao.QRY_GET _LISTS_CPR S_TIU_FAIL URE_DATA_F OR_ONE_TEA M, paramNa mes, param Values ); | |
681 | retu rn l; | |
682 | } | |
683 | ||
684 | pu blic List< Object[]> getListsCP RSTiuFailu reDataForA llTeamsByO neFacility (Long stat ionNumber) { | |
685 | Stri ng[] param Names = ne w String[] { "statio nNumber" } ; | |
686 | Obje ct[] param Values = n ew Object[ ] { statio nNumber.to String() } ; | |
687 | logP arameters( paramNames ,paramValu es); | |
688 | List <Object[]> l = getHi bernateTem plate().fi ndByNamedQ ueryAndNam edParam( | |
689 | ReportsD ao.QRY_GET _LISTS_CPR S_TIU_FAIL URE_DATA_F OR_ALL_TEA MS_BY_ONE_ FACILITY, paramNames , paramVal ues ); | |
690 | retu rn l; | |
691 | } | |
692 | ||
693 | ||
694 | ||
695 | pu blic List getLastRep ortDataRef reshDate() { | |
696 | List l = getHi bernateTem plate().fi ndByNamedQ uery(Repor tsDao.QRY_ GET_LAST_R EPORT_REFR ESH_DATE); | |
697 | retu rn l; | |
698 | } | |
699 | ||
700 | pr ivate void logParame ters(Strin g[] paramN ames, Obje ct[] param Values) { | |
701 | if(l og.isInfoE nabled()) { | |
702 | for(in t i=0;i<pa ramNames.l ength;i++) { | |
703 | log.info ("Param: " +paramName s[i]+", va lue: '"+St ring.value Of(paramVa lues[i]) + "'"); | |
704 | } | |
705 | } | |
706 | } | |
707 | ||
708 | ||
709 | ||
710 | } |
Araxis Merge (but not the data content of this report) is Copyright © 1993-2016 Araxis Ltd (www.araxis.com). All rights reserved.