SMAHA01100_검사실현황.xfdl 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMAHA01100" position="absolute 0 0 1196 750" titletext="검사실현황 집계표" oninit="SMAHA01100_oninit" onload="SMAHA01100_onload">
  5. <Layouts>
  6. <Layout>
  7. <Tab id="switch1" taborder="5" tabindex="0" position="absolute 0 67 1195 749" anchor="all">
  8. <Tabpages>
  9. <Tabpage id="case1" text="검사실현황">
  10. <Layouts>
  11. <Layout>
  12. <Grid id="grd_mainlist" taborder="0" binddataset="ds_main_mainlist_item" useinputpanel="false" position="absolute 0 0 1195 655" autoenter="select" autofittype="col" cellsizingtype="col" anchor="all" oncelldblclick="switch1_case1_grd_mainlist_oncelldblclick">
  13. <Formats>
  14. <Format id="default">
  15. <Columns>
  16. <Column size="0"/>
  17. <Column size="120"/>
  18. <Column size="33"/>
  19. <Column size="33"/>
  20. <Column size="33"/>
  21. <Column size="33"/>
  22. <Column size="33"/>
  23. <Column size="33"/>
  24. <Column size="33"/>
  25. <Column size="33"/>
  26. <Column size="33"/>
  27. <Column size="33"/>
  28. <Column size="33"/>
  29. <Column size="33"/>
  30. <Column size="33"/>
  31. <Column size="33"/>
  32. <Column size="33"/>
  33. <Column size="33"/>
  34. <Column size="33"/>
  35. <Column size="33"/>
  36. <Column size="33"/>
  37. <Column size="33"/>
  38. <Column size="33"/>
  39. <Column size="33"/>
  40. <Column size="33"/>
  41. <Column size="33"/>
  42. <Column size="33"/>
  43. <Column size="33"/>
  44. <Column size="33"/>
  45. <Column size="33"/>
  46. <Column size="33"/>
  47. <Column size="33"/>
  48. <Column size="33"/>
  49. </Columns>
  50. <Rows>
  51. <Row size="24" band="head"/>
  52. <Row size="24"/>
  53. </Rows>
  54. <Band id="head">
  55. <Cell text="검사실코드"/>
  56. <Cell col="1" text="검사실명"/>
  57. <Cell col="2" text="01일"/>
  58. <Cell col="3" text="02일"/>
  59. <Cell col="4" text="03일"/>
  60. <Cell col="5" text="04일"/>
  61. <Cell col="6" text="05일"/>
  62. <Cell col="7" text="06일"/>
  63. <Cell col="8" text="07일"/>
  64. <Cell col="9" text="08일"/>
  65. <Cell col="10" text="09일"/>
  66. <Cell col="11" text="10일"/>
  67. <Cell col="12" text="11일"/>
  68. <Cell col="13" text="12일"/>
  69. <Cell col="14" text="13일"/>
  70. <Cell col="15" text="14일"/>
  71. <Cell col="16" text="15일"/>
  72. <Cell col="17" text="16일"/>
  73. <Cell col="18" text="17일"/>
  74. <Cell col="19" text="18일"/>
  75. <Cell col="20" text="19일"/>
  76. <Cell col="21" text="20일"/>
  77. <Cell col="22" text="21일"/>
  78. <Cell col="23" text="22일"/>
  79. <Cell col="24" text="23일"/>
  80. <Cell col="25" text="24일"/>
  81. <Cell col="26" text="25일"/>
  82. <Cell col="27" text="26일"/>
  83. <Cell col="28" text="27일"/>
  84. <Cell col="29" text="28일"/>
  85. <Cell col="30" text="29일"/>
  86. <Cell col="31" text="30일"/>
  87. <Cell col="32" text="31일"/>
  88. </Band>
  89. <Band id="body">
  90. <Cell text="bind:testroomcd"/>
  91. <Cell col="1" style="align:left middle;padding:0 0 0 3;background:EXPR(bg1);background2:EXPR(bg1);" text="bind:testroomnm"/>
  92. <Cell col="2" style="background:EXPR(holiy_day01);background2:EXPR(holiy_day01);" text="bind:day01"/>
  93. <Cell col="3" style="background:EXPR(holiy_day02);background2:EXPR(holiy_day02);" text="bind:day02"/>
  94. <Cell col="4" style="background:EXPR(holiy_day03);background2:EXPR(holiy_day03);" text="bind:day03"/>
  95. <Cell col="5" style="background:EXPR(holiy_day04);background2:EXPR(holiy_day04);" text="bind:day04"/>
  96. <Cell col="6" style="background:EXPR(holiy_day05);background2:EXPR(holiy_day05);" text="bind:day05"/>
  97. <Cell col="7" style="background:EXPR(holiy_day06);background2:EXPR(holiy_day06);" text="bind:day06"/>
  98. <Cell col="8" style="background:EXPR(holiy_day07);background2:EXPR(holiy_day07);" text="bind:day07"/>
  99. <Cell col="9" style="background:EXPR(holiy_day08);background2:EXPR(holiy_day08);" text="bind:day08"/>
  100. <Cell col="10" style="background:EXPR(holiy_day09);background2:EXPR(holiy_day09);" text="bind:day09"/>
  101. <Cell col="11" style="background:EXPR(holiy_day10);background2:EXPR(holiy_day10);" text="bind:day10"/>
  102. <Cell col="12" style="background:EXPR(holiy_day11);background2:EXPR(holiy_day11);" text="bind:day11"/>
  103. <Cell col="13" style="background:EXPR(holiy_day12);background2:EXPR(holiy_day12);" text="bind:day12"/>
  104. <Cell col="14" style="background:EXPR(holiy_day13);background2:EXPR(holiy_day13);" text="bind:day13"/>
  105. <Cell col="15" style="background:EXPR(holiy_day14);background2:EXPR(holiy_day14);" text="bind:day14"/>
  106. <Cell col="16" style="background:EXPR(holiy_day15);background2:EXPR(holiy_day15);" text="bind:day15"/>
  107. <Cell col="17" style="background:EXPR(holiy_day16);background2:EXPR(holiy_day16);" text="bind:day16"/>
  108. <Cell col="18" style="background:EXPR(holiy_day17);background2:EXPR(holiy_day17);" text="bind:day17"/>
  109. <Cell col="19" style="background:EXPR(holiy_day18);background2:EXPR(holiy_day18);" text="bind:day18"/>
  110. <Cell col="20" style="background:EXPR(holiy_day19);background2:EXPR(holiy_day19);" text="bind:day19"/>
  111. <Cell col="21" style="background:EXPR(holiy_day20);background2:EXPR(holiy_day20);" text="bind:day20"/>
  112. <Cell col="22" style="background:EXPR(holiy_day21);background2:EXPR(holiy_day21);" text="bind:day21"/>
  113. <Cell col="23" style="background:EXPR(holiy_day22);background2:EXPR(holiy_day22);" text="bind:day22"/>
  114. <Cell col="24" style="background:EXPR(holiy_day23);background2:EXPR(holiy_day23);" text="bind:day23"/>
  115. <Cell col="25" style="background:EXPR(holiy_day24);background2:EXPR(holiy_day24);" text="bind:day24"/>
  116. <Cell col="26" style="background:EXPR(holiy_day25);background2:EXPR(holiy_day25);" text="bind:day25"/>
  117. <Cell col="27" style="background:EXPR(holiy_day26);background2:EXPR(holiy_day26);" text="bind:day26"/>
  118. <Cell col="28" style="background:EXPR(holiy_day27);background2:EXPR(holiy_day27);" text="bind:day27"/>
  119. <Cell col="29" style="background:EXPR(holiy_day28);background2:EXPR(holiy_day28);" text="bind:day28"/>
  120. <Cell col="30" style="background:EXPR(holiy_day29);background2:EXPR(holiy_day29);" text="bind:day29"/>
  121. <Cell col="31" style="background:EXPR(holiy_day30);background2:EXPR(holiy_day30);" text="bind:day30"/>
  122. <Cell col="32" style="background:EXPR(holiy_day31);background2:EXPR(holiy_day31);" text="bind:day31"/>
  123. </Band>
  124. </Format>
  125. </Formats>
  126. </Grid>
  127. </Layout>
  128. </Layouts>
  129. </Tabpage>
  130. <Tabpage id="case2" text="실별 처방내역">
  131. <Layouts>
  132. <Layout>
  133. <Grid id="grd_sublist" taborder="0" binddataset="ds_main_sublist_item" useinputpanel="false" position="absolute 0 0 1195 655" autoenter="select" autofittype="none" cellsizingtype="col" anchor="all">
  134. <Formats>
  135. <Format id="default">
  136. <Columns>
  137. <Column size="25" band="left"/>
  138. <Column size="70"/>
  139. <Column size="75"/>
  140. <Column size="94"/>
  141. <Column size="81"/>
  142. <Column size="75"/>
  143. <Column size="98"/>
  144. <Column size="88"/>
  145. <Column size="81"/>
  146. <Column size="103"/>
  147. <Column size="110"/>
  148. <Column size="115"/>
  149. <Column size="85"/>
  150. <Column size="80"/>
  151. </Columns>
  152. <Rows>
  153. <Row size="24" band="head"/>
  154. <Row size="24"/>
  155. </Rows>
  156. <Band id="head">
  157. <Cell/>
  158. <Cell col="1" text="등록번호"/>
  159. <Cell col="2" text="처방코드"/>
  160. <Cell col="3" text="처방명"/>
  161. <Cell col="4" text="환자명"/>
  162. <Cell col="5" text="상태"/>
  163. <Cell col="6" text="주민번호"/>
  164. <Cell col="7" text="처방일자"/>
  165. <Cell col="8" text="종합검진일"/>
  166. <Cell col="9" text="연락처"/>
  167. <Cell col="10" text="휴대번호"/>
  168. <Cell col="11" text="단체명"/>
  169. <Cell col="12" text="비고"/>
  170. <Cell col="13" text="E-Mail"/>
  171. </Band>
  172. <Band id="body">
  173. <Cell celltype="head" text="expr:currow+1"/>
  174. <Cell col="1" text="bind:pid"/>
  175. <Cell col="2" text="bind:testcd"/>
  176. <Cell col="3" style="align:left top;padding:0 0 0 3;" text="bind:testnm" wordwrap="word"/>
  177. <Cell col="4" text="bind:hngnm"/>
  178. <Cell col="5" displaytype="combo" style="align:center middle;" text="bind:statflag" combodataset="ds_init_baseinfo_statflag_A0107" combocodecol="cdid" combodatacol="cdnm" enable="false"/>
  179. <Cell col="6" text="bind:rrgstno" mask="######-#######" maskchar=" "/>
  180. <Cell col="7" displaytype="date" text="bind:rsrvdd" calendardisplaynulltype="nulltext"/>
  181. <Cell col="8" displaytype="date" text="bind:acptdd" calendardisplaynulltype="nulltext"/>
  182. <Cell col="9" text="bind:hometel"/>
  183. <Cell col="10" text="bind:mpphontel"/>
  184. <Cell col="11" style="align:left top;" text="bind:cmpynm" wordwrap="char"/>
  185. <Cell col="12" style="align:left top;padding:3 0 0 3;" text="bind:remcnts" wordwrap="word"/>
  186. <Cell col="13" text="bind:email"/>
  187. </Band>
  188. </Format>
  189. </Formats>
  190. </Grid>
  191. </Layout>
  192. </Layouts>
  193. </Tabpage>
  194. </Tabpages>
  195. </Tab>
  196. <Static text="검사실현황 집계표" position="absolute 0 0 189 25" id="caption6" class="tit_1"/>
  197. <Div id="grp_sea" taborder="1" class="div_SA" position="absolute 0 25 1195 65" anchor="left top right">
  198. <Layouts>
  199. <Layout>
  200. <Static id="caption21" text="기간 :" class="search_name" position="absolute 7 14 68 31" anchor="default"/>
  201. <Static id="caption1" text="건진장소 :" class="search_name" position="absolute 190 13 276 30" anchor="default"/>
  202. <Calendar id="ipt_srchfromdd" taborder="1" class="input_essential" position="absolute 63 11 168 30" autoselect="true" autoskip="true" anchor="default"/>
  203. <Combo id="cmb_place" taborder="2" innerdataset="@ds_init_baseinfo_healexamplacelst_S600" codecolumn="cdid" datacolumn="cdnm" class="combo_essential" position="absolute 278 11 363 30" anchor="default"/>
  204. <Button id="btn_search" taborder="3" text="조회" class="btn1" position="absolute 395 10 451 32" anchor="default" onclick="grp_sea_btn_search_onclick"/>
  205. <Shape id="line18" linetype="vertical" class="line_4" position="absolute 382 10 388 32" anchor="default"/>
  206. <Static id="caption2" text="일자별비고 :" class="search_name" position="absolute 460 13 559 30" anchor="default"/>
  207. <Calendar id="ipt_remdd" taborder="4" position="absolute 551 11 659 30" autoselect="true" autoskip="true" anchor="default" onchanged="grp_sea_ipt_remdd_onchanged"/>
  208. <TextArea id="tar_remcnts" taborder="5" position="absolute 665 6 1185 36" autoselect="true" anchor="default" wordwrap="word" autoskip="true"/>
  209. </Layout>
  210. </Layouts>
  211. </Div>
  212. <Combo id="cmb_year" taborder="2" innerdataset="@ds_init_baseinfo_yearlst_P0167" codecolumn="cdid" datacolumn="cdnm" visible="false" position="absolute 204 70 304 89" onitemchanged="cmb_year_onitemchanged"/>
  213. <Combo id="cmb_month" taborder="3" innerdataset="@ds_init_baseinfo_monthlst_R0009" codecolumn="cdid" datacolumn="cdnm" visible="false" position="absolute 309 70 409 89"/>
  214. <Button id="btn_srch_dayb" taborder="4" text="조회" class="btn2" visible="false" position="absolute 479 67 523 89" onclick="btn_srch_dayb_onclick"/>
  215. <Button id="button1" taborder="6" text="엑셀저장" class="btn7" position="absolute 1114 67 1194 89" onclick="button1_onclick"/>
  216. </Layout>
  217. </Layouts>
  218. <Objects>
  219. <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  220. <ColumnInfo>
  221. <Column id="srchhealexamflag" type="STRING" size="256"/>
  222. <Column id="srchfromdd" type="STRING" size="256"/>
  223. <Column id="srchtodd" type="STRING" size="256"/>
  224. <Column id="srchinstcd" type="STRING" size="256"/>
  225. <Column id="srchprescond" type="STRING" size="256"/>
  226. <Column id="srchyear" type="STRING" size="256"/>
  227. <Column id="srchmoth" type="STRING" size="256"/>
  228. <Column id="srchtestroomcd" type="STRING" size="256"/>
  229. <Column id="srchplacecd" type="STRING" size="256"/>
  230. <Column id="srchlastdd" type="STRING" size="256"/>
  231. </ColumnInfo>
  232. <Rows>
  233. <Row>
  234. <Col id="srchhealexamflag"/>
  235. <Col id="srchfromdd"/>
  236. <Col id="srchtodd"/>
  237. <Col id="srchinstcd"/>
  238. <Col id="srchprescond"/>
  239. <Col id="srchyear"/>
  240. <Col id="srchmoth"/>
  241. <Col id="srchtestroomcd"/>
  242. <Col id="srchplacecd">S</Col>
  243. <Col id="srchlastdd"/>
  244. </Row>
  245. </Rows>
  246. </Dataset>
  247. <Dataset id="ds_main_dayblist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  248. <ColumnInfo>
  249. <Column id="remdd" type="STRING" size="256"/>
  250. <Column id="remcnts" type="STRING" size="256"/>
  251. <Column id="instcd" type="STRING" size="256"/>
  252. </ColumnInfo>
  253. <Rows>
  254. <Row>
  255. <Col id="remdd"/>
  256. <Col id="remcnts"/>
  257. <Col id="instcd"/>
  258. </Row>
  259. </Rows>
  260. </Dataset>
  261. <Dataset id="ds_init_baseinfo_healexamplacelst_S600" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  262. <Dataset id="ds_init_baseinfo_yearlst_P0167" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  263. <Dataset id="ds_init_baseinfo_monthlst_R0009" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  264. <Dataset id="ds_main_mainlist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  265. <ColumnInfo>
  266. <Column id="testroomcd" type="STRING" size="256" sumtext="검사실코드"/>
  267. <Column id="testroomnm" type="STRING" size="256" sumtext="검사실명"/>
  268. <Column id="day01" type="INT" size="256" sumtext="검사실명"/>
  269. <Column id="day02" type="INT" size="256" sumtext="검사실명"/>
  270. <Column id="day03" type="INT" size="256" sumtext="검사실명"/>
  271. <Column id="day04" type="INT" size="256" sumtext="검사실명"/>
  272. <Column id="day05" type="INT" size="256" sumtext="검사실명"/>
  273. <Column id="day06" type="INT" size="256" sumtext="검사실명"/>
  274. <Column id="day07" type="INT" size="256" sumtext="검사실명"/>
  275. <Column id="day08" type="INT" size="256" sumtext="검사실명"/>
  276. <Column id="day09" type="INT" size="256" sumtext="검사실명"/>
  277. <Column id="day10" type="INT" size="256" sumtext="검사실명"/>
  278. <Column id="day11" type="INT" size="256" sumtext="검사실명"/>
  279. <Column id="day12" type="INT" size="256" sumtext="검사실명"/>
  280. <Column id="day13" type="INT" size="256" sumtext="검사실명"/>
  281. <Column id="day14" type="INT" size="256" sumtext="검사실명"/>
  282. <Column id="day15" type="INT" size="256" sumtext="검사실명"/>
  283. <Column id="day16" type="INT" size="256" sumtext="검사실명"/>
  284. <Column id="day17" type="INT" size="256" sumtext="검사실명"/>
  285. <Column id="day18" type="INT" size="256" sumtext="검사실명"/>
  286. <Column id="day19" type="INT" size="256" sumtext="검사실명"/>
  287. <Column id="day20" type="INT" size="256" sumtext="검사실명"/>
  288. <Column id="day21" type="INT" size="256" sumtext="검사실명"/>
  289. <Column id="day22" type="INT" size="256" sumtext="검사실명"/>
  290. <Column id="day23" type="INT" size="256" sumtext="검사실명"/>
  291. <Column id="day24" type="INT" size="256" sumtext="검사실명"/>
  292. <Column id="day25" type="INT" size="256" sumtext="검사실명"/>
  293. <Column id="day26" type="INT" size="256" sumtext="검사실명"/>
  294. <Column id="day27" type="INT" size="256" sumtext="검사실명"/>
  295. <Column id="day28" type="INT" size="256" sumtext="검사실명"/>
  296. <Column id="day29" type="INT" size="256" sumtext="검사실명"/>
  297. <Column id="day30" type="INT" size="256" sumtext="검사실명"/>
  298. <Column id="day31" type="INT" size="256" sumtext="검사실명"/>
  299. </ColumnInfo>
  300. </Dataset>
  301. <Dataset id="ds_main_sublist_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  302. <ColumnInfo>
  303. <Column id="pid" type="STRING" size="256" sumtext="검사실코드"/>
  304. <Column id="testcd" type="STRING" size="256" sumtext="검사실코드"/>
  305. <Column id="testnm" type="STRING" size="256" sumtext="검사실코드"/>
  306. <Column id="hngnm" type="STRING" size="256" sumtext="검사실명"/>
  307. <Column id="rsrvdd" type="STRING" size="256" sumtext="예약건수"/>
  308. <Column id="acptdd" type="STRING" size="256" sumtext="접수건수"/>
  309. <Column id="mpphontel" type="STRING" size="256" sumtext="휴대번호"/>
  310. <Column id="statflag" type="STRING" size="256" sumtext="접수구분"/>
  311. <Column id="hometel" type="STRING" size="256" sumtext="집전화번호"/>
  312. <Column id="rrgstno" type="STRING" size="256" sumtext="주민번호"/>
  313. <Column id="email" type="STRING" size="256" sumtext="이메일"/>
  314. <Column id="cmpynm" type="STRING" size="256" sumtext="단체명"/>
  315. <Column id="remcnts" type="STRING" size="256" sumtext="비고"/>
  316. </ColumnInfo>
  317. </Dataset>
  318. <Dataset id="ds_init_baseinfo_statflag_A0107" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  319. <Dataset id="ds_temp_dayinfo_item" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  320. <ColumnInfo>
  321. <Column id="basedd" type="STRING" size="256" sumtext="날짜"/>
  322. <Column id="dutflag" type="STRING" size="256" sumtext="공휴일"/>
  323. </ColumnInfo>
  324. </Dataset>
  325. <Dataset id="ds_init_G40list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  326. </Objects>
  327. <Bind>
  328. <BindItem id="item0" compid="grp_sea.ipt_srchfromdd" propid="value" datasetid="ds_send" columnid="srchfromdd"/>
  329. <BindItem id="item1" compid="grp_sea.cmb_place" propid="value" datasetid="ds_send" columnid="srchplacecd"/>
  330. <BindItem id="item2" compid="grp_sea.ipt_remdd" propid="value" datasetid="ds_main_dayblist" columnid="remdd"/>
  331. <BindItem id="item3" compid="grp_sea.tar_remcnts" propid="value" datasetid="ds_main_dayblist" columnid=""/>
  332. <BindItem id="item4" compid="cmb_year" propid="value" datasetid="ds_send" columnid="srchyear"/>
  333. <BindItem id="item5" compid="cmb_month" propid="value" datasetid="ds_send" columnid="srchmoth"/>
  334. </Bind>
  335. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  336. * System Name :
  337. * Job Name :
  338. * Creator :
  339. * Make Date : 2015-11-13
  340. * Description :
  341. *---------------------------------------------------------------------------------------
  342. * Modify Date Modifier Modify Description
  343. *---------------------------------------------------------------------------------------
  344. * 2015-11-13 Live Converter TF->XP
  345. *
  346. *---------------------------------------------------------------------------------------
  347. ****************************************************************************************/
  348. include "com_commonxp::comm_main.xjs";
  349. include "ast_healexamxp::AHA001.xjs";
  350. include "ast_healthexambasexp::healcombolist.xjs";
  351. function SMAHA01100_oninit(obj:Form, e:InitEventInfo)
  352. {
  353. frmf_initForm(obj);
  354. }
  355. function SMAHA01100_onload(obj:Form, e:LoadEventInfo)
  356. {
  357. grdf_initGrid(switch1.case1.grd_mainlist);
  358. grdf_initGrid(switch1.case2.grd_sublist);
  359. fGetBasicList();
  360. fInit();
  361. fGetSearch();
  362. }
  363. function fGetBasicList()
  364. {
  365. ds_send.setColumn(0, "srchinstcd",sysf_getUserInfo("dutplceinstcd"));
  366. var arrParam = [{dsNm: "ds_init_baseinfo_healflaglst_A0068", cdGrpId: "A0068"}
  367. ,{dsNm: "ds_init_baseinfo_yearlst_P0167", cdGrpId: "P0167"}
  368. ,{dsNm: "ds_init_baseinfo_monthlst_R0009", cdGrpId: "R0009"}
  369. ,{dsNm: "ds_init_baseinfo_statflag_A0107", cdGrpId: "A0107"}]
  370. appf_getCodeList(arrParam);
  371. var arrParam = [{dsNm: "ds_init_baseinfo_healexamplacelst_S600", cdGrpId: "S600"}];
  372. healGetCodeList(arrParam);
  373. //기본코드 조회추가
  374. fGetAstCodeList();
  375. }
  376. function fInit()
  377. {
  378. ds_send.setColumn(0, "srchyear" , String(utlf_getCurrentDate()).substr(0,4));
  379. ds_send.setColumn(0, "srchmoth" , String(utlf_getCurrentDate()).substr(4,2));
  380. ds_main_mainlist_item.clearData();
  381. ds_main_sublist_item.clearData();
  382. switch1.tabindex = 0;
  383. var vHealExamDetlFg = fGetHealExamDetlFlag();
  384. if( vHealExamDetlFg == "C01" )
  385. {
  386. grp_sea.cmb_place.value = "S";
  387. }
  388. else if (vHealExamDetlFg == "C03")
  389. {
  390. grp_sea.cmb_place.value = "K";
  391. }
  392. var cur_date = utlf_getCurrentDate();
  393. grp_sea.ipt_srchfromdd.value = cur_date;
  394. dsf_makeValue(ds_main_dayblist, "remdd", "string" , utlf_getCurrentDate());
  395. btn_srch_dayb.click();
  396. }
  397. function fGetSearch()
  398. {
  399. var captionString = "";
  400. ds_main_mainlist_item.clearData();
  401. ds_main_sublist_item.clearData();
  402. var year1 = String(ds_send.getColumn(0, "srchfromdd")).substring(0,4);
  403. if (String(ds_send.getColumn(0, "srchfromdd")).substring(4,5) == '0')
  404. {
  405. var month1 = parseInt(String(ds_send.getColumn(0, "srchfromdd")).substring(5,6))-1;
  406. }
  407. else
  408. {
  409. var month1 = parseInt(String(ds_send.getColumn(0, "srchfromdd")).substring(4,6))-1;
  410. }
  411. var date1 = String(ds_send.getColumn(0, "srchfromdd")).substring(6,8);
  412. var strtdd = new Date(year1, month1, date1);
  413. for (var ii = 0 ; ii < 31 ; ii++)
  414. {
  415. var day2 = new Date(strtdd.getFullYear(), strtdd.getMonth(), strtdd.getDate() + ii);
  416. captionString = captionString + '^' + day2.getDate() + '일';
  417. }
  418. captionString = "검사실코드^검사실"+captionString
  419. v_captionString = captionString.split("^");
  420. for(var i = 0; i < v_captionString.length; i++)
  421. {
  422. switch1.case1.grd_mainlist.setCellProperty("Head", i, "text", v_captionString[i]);
  423. }
  424. var oParam = {};
  425. oParam.id = "TRAHA01101";
  426. oParam.service = "healexamstatapp.StatRef";
  427. oParam.method = "reqGetRoomCondMainList";
  428. oParam.inds = "req=ds_send";
  429. oParam.outds = "ds_main_mainlist_item=item";
  430. oParam.async = false;
  431. oParam.callback = "cf_TRAHA01101";
  432. tranf_submit(oParam);
  433. fSubTotal2();
  434. switch1.tabindex = 0;
  435. var month = String(ds_send.getColumn(0, "srchfromdd")).substring(4,6);
  436. var last_day =(year1+month+date1).toDate().getAddDate(+30,"D").getDateFormat("YYYYMMDD"); //마지막날
  437. ds_send.setColumn(0, "srchlastdd", last_day );
  438. var oParam = {};
  439. oParam.id = "TRAHA01103";
  440. oParam.service = "healexamstatapp.StatRef";
  441. oParam.method = "reqGetHoliDayList";
  442. oParam.inds = "req=ds_send";
  443. oParam.outds = "ds_temp_dayinfo_item=item";
  444. oParam.async = false;
  445. //oParam.callback = "cf_TRAHA01103";
  446. tranf_submit(oParam);
  447. for(var i = 1; i <= 30 ; i++)
  448. {
  449. var day = (year1+month+date1).toDate().getAddDate(i,"D").getDateFormat("YYYYMMDD");
  450. var dutflag = ds_temp_dayinfo_item.lookup("basedd", day, "dutflag");
  451. if(dutflag == "4")
  452. {
  453. for(var j = 0; j < ds_main_mainlist_item.rowcount; j++)
  454. {
  455. if(String(i).length < 2)
  456. {
  457. dsf_makeValue(ds_main_mainlist_item, "holiy_day0"+parseInt(i+1), "string", "#85B3FF", j);
  458. }
  459. else
  460. {
  461. dsf_makeValue(ds_main_mainlist_item, "holiy_day"+parseInt(i+1), "string", "#85B3FF", j);
  462. }
  463. }
  464. }
  465. if(dutflag == "8")
  466. {
  467. for(var j = 0; j < ds_main_mainlist_item.rowcount; j++)
  468. {
  469. if(String(i).length < 2)
  470. {
  471. dsf_makeValue(ds_main_mainlist_item, "holiy_day0"+parseInt(i+1), "string", "#FF8888", j);
  472. }
  473. else
  474. {
  475. dsf_makeValue(ds_main_mainlist_item, "holiy_day"+parseInt(i+1), "string", "#FF8888", j);
  476. }
  477. }
  478. }
  479. }
  480. for(var i = 1; i <= 31 ; i++)
  481. {
  482. if(String(i).length < 2)
  483. {
  484. dsf_makeValue(ds_main_mainlist_item, "holiy_day0"+i, "string", "#F9E6C5", parseInt(ds_main_mainlist_item.rowcount)-1);
  485. dsf_makeValue(ds_main_mainlist_item, "holiy_day0"+i, "string", "#87CEFA", parseInt(ds_main_mainlist_item.rowcount)-2);
  486. }
  487. else
  488. {
  489. dsf_makeValue(ds_main_mainlist_item, "holiy_day"+i, "string", "#F9E6C5", parseInt(ds_main_mainlist_item.rowcount)-1);
  490. dsf_makeValue(ds_main_mainlist_item, "holiy_day"+i, "string", "#87CEFA", parseInt(ds_main_mainlist_item.rowcount)-2);
  491. }
  492. }
  493. }
  494. function cf_TRAHA01101(sSvcId, nErrorCode, sErrorMsg) {
  495. if(nErrorCode < 0) return;
  496. dsf_setTypeFormat(ds_main_mainlist_item, "day01:INT^day02:INT^day03:INT^day04:INT^day05:INT^day06:INT^day07:INT^day08:INT^day09:INT^day10:INT"
  497. +"^day11:INT^day12:INT^day13:INT^day14:INT^day15:INT^day16:INT^day17:INT^day18:INT^day19:INT^day20:INT"
  498. +"^day21:INT^day22:INT^day23:INT^day24:INT^day25:INT^day26:INT^day27:INT^day28:INT^day29:INT^day30:INT^day31:INT");
  499. }
  500. function fSubTotal2()
  501. {
  502. var subtotrow = ds_main_mainlist_item.rowcount;
  503. var totrow = parseInt(subtotrow)+1;
  504. for(var k = 1 ; k <= 31 ; k++)
  505. {
  506. var total = 0;
  507. var subtotal = 0;
  508. var colnm = "";
  509. if(k < 10) colnm = "day0" + k;
  510. else colnm = "day" + k;
  511. for(var i = 0; i < subtotrow ; i++)
  512. {
  513. for(var j = 0 ; j < ds_init_G40list.rowcount; j++)
  514. {
  515. if(ds_main_mainlist_item.getColumn(i, "testroomcd") == ds_init_G40list.getColumn(j, "etcdetlcd"))
  516. {
  517. subtotal = subtotal + parseInt(ds_main_mainlist_item.getColumn(i, colnm));
  518. break;
  519. }
  520. }
  521. total = total + parseInt(ds_main_mainlist_item.getColumn(i, colnm));
  522. }
  523. dsf_makeValue(ds_main_mainlist_item, colnm, "string", subtotal, subtotrow);
  524. dsf_makeValue(ds_main_mainlist_item, "testroomnm", "string", "초음파실 합계", subtotrow);
  525. dsf_makeValue(ds_main_mainlist_item, "bg1", "string", "#87CEFA", subtotrow);
  526. dsf_makeValue(ds_main_mainlist_item, colnm, "string", total, totrow);
  527. dsf_makeValue(ds_main_mainlist_item, "testroomnm", "string", "합계", totrow);
  528. dsf_makeValue(ds_main_mainlist_item, "bg1", "string", "#F9E6C5", totrow);
  529. }
  530. ds_main_mainlist_item.rowposition = -1;
  531. ds_main_mainlist_item.clearSelect();
  532. }
  533. function grp_sea_btn_search_onclick(obj:Button, e:ClickEventInfo)
  534. {
  535. fGetSearch();
  536. }
  537. function btn_srch_dayb_onclick(obj:Button, e:ClickEventInfo)
  538. {
  539. dsf_makeValue(ds_main_dayblist, "instcd", "string" , sysf_getUserInfo("dutplceinstcd"));
  540. var tmp_remdd = ds_main_dayblist.getColumn(0, "remdd" );
  541. var oParam = {};
  542. oParam.id = "TRAHB01508";
  543. oParam.service = "healexambaseapp.ScheduleCode";
  544. oParam.method = "reqGetDaybList";
  545. oParam.inds = "req=ds_main_dayblist";
  546. oParam.outds = "ds_main_dayblist=dayblist";
  547. oParam.async = false;
  548. //oParam.callback = "cf_TRAHB01508";
  549. tranf_submit(oParam);
  550. if(utlf_isNull(ds_main_dayblist.getColumn(0, "remdd")))
  551. {
  552. ds_main_dayblist.setColumn(0, "remcnts", "");
  553. dsf_makeValue(ds_main_dayblist, "remdd", "string" , tmp_remdd);
  554. }
  555. }
  556. function cmb_year_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  557. {
  558. fSetDate();
  559. }
  560. function fSetDate()
  561. {
  562. var year = cmb_year.value;
  563. var month = cmb_month.value;
  564. var todd = new Date(year , parseInt(month,10) , '01' );
  565. ds_send.setColumn(0, "srchfromdd" , year + month + "01");
  566. ds_send.setColumn(0, "srchtodd" , new String(todd.getYear()) + new String(todd.getMonth() + 1 ).getLeftPad(2,"0") + new String(todd.getDate()) );
  567. }
  568. function button1_onclick(obj:Button, e:ClickEventInfo)
  569. {
  570. var sIndex = switch1.tabindex;
  571. if(sIndex == 0)
  572. {
  573. grdf_exportExcel(switch1.case1.grd_mainlist, "excel", "검사실현황", "true", "", "");
  574. }
  575. else
  576. {
  577. grdf_exportExcel(switch1.case2.grd_sublist, "excel", "Sheet1", "true", "", "");
  578. }
  579. }
  580. function grp_sea_ipt_remdd_onchanged(obj:Calendar, e:ChangeEventInfo)
  581. {
  582. btn_srch_dayb.click();
  583. }
  584. function switch1_case1_grd_mainlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  585. {
  586. fGetDetailSearch();
  587. switch1.tabindex = 1;
  588. }
  589. function fGetDetailSearch()
  590. {
  591. if(ds_main_mainlist_item.rowposition < 0) return;
  592. ds_main_sublist_item.clearData();
  593. var rowidx = ds_main_mainlist_item.rowposition;
  594. var year1= String(ds_send.getColumn(0, "srchfromdd")).substring(0,4);;
  595. if (String(ds_send.getColumn(0, "srchfromdd")).substring(4,5) == '0')
  596. {
  597. var month1 = parseInt(String(ds_send.getColumn(0, "srchfromdd")).substring(5,6))-1;
  598. }
  599. else
  600. {
  601. var month1 = parseInt(String(ds_send.getColumn(0, "srchfromdd")).substring(4,6))-1;
  602. }
  603. var date1 = String(ds_send.getColumn(0, "srchfromdd")).substring(6,8);
  604. var strtdd = new Date(year1, month1, date1);
  605. var day2 = new Date(strtdd.getFullYear(), strtdd.getMonth(), strtdd.getDate() + switch1.case1.grd_mainlist.currentcol - 2);
  606. var year2 =day2.getFullYear();
  607. if ((day2.getMonth()+1)<10)
  608. {
  609. var month2 = '0'+(day2.getMonth()+1);
  610. }
  611. else
  612. {
  613. var month2 = day2.getMonth()+1;
  614. }
  615. var date2 = day2.getDate();
  616. dsf_makeValue(ds_send,"srchyear", "string", year2);
  617. dsf_makeValue(ds_send,"srchmoth", "string", month2);
  618. dsf_makeValue(ds_send,"srchdd", "string", date2);
  619. dsf_makeValue(ds_send,"srchhealexamplacecd", "string", grp_sea.cmb_place.value);
  620. dsf_makeValue(ds_send,"srchtestroomcd", "string", ds_main_mainlist_item.getColumn(rowidx, "testroomcd"));
  621. var oParam = {};
  622. oParam.id = "TRAHA01102";
  623. oParam.service = "healexamstatapp.StatRef";
  624. oParam.method = "reqGetRoomCondDetailList";
  625. oParam.inds = "req=ds_send";
  626. oParam.outds = "ds_main_sublist_item=item";
  627. oParam.async = false;
  628. //oParam.callback = "cf_TRAHA01102";
  629. tranf_submit(oParam);
  630. switch1.tabindex = 1;
  631. }
  632. /*-**************************************************************************************
  633. * Argument : colnm - 해당컬럼ID
  634. * Description : 초음파실 합계 계산
  635. ****************************************************************************************/
  636. function fEchoSum(colnm) {
  637. var tot = 0;
  638. for(var i = 0 ; i < ds_main_mainlist_item.rowcount ; i++) {
  639. if(ds_init_G40list.findRow("etcdetlcd", ds_main_mainlist_item.getColumn(i, "testroomcd")) > -1) {
  640. tot = tot + parseInt(ds_main_mainlist_item.getColumn(i, colnm));
  641. }
  642. }
  643. return tot;
  644. }
  645. /*-**************************************************************************************
  646. * Argument : N/A
  647. * Description : 종합건진 기본코드 조회 추가(G45 초음파 합계용)
  648. ****************************************************************************************/
  649. function fGetAstCodeList(){
  650. ds_init_G40list.clear();
  651. dsf_createDsRow("ds_req", [
  652. {col:"clscd", type:"STRING", size:256, val:"G"}
  653. , {col:"etccd", type:"STRING", size:256, val:"G40"}
  654. , {col:"etcitemcnts", type:"STRING", size:256, val:""}
  655. ]);
  656. var oParam = {};
  657. oParam.id = "TRAHB00602";
  658. oParam.service = "healexambaseapp.EtcCode";
  659. oParam.method = "reqGetDetlCodeList";
  660. oParam.inds = "req=ds_req";
  661. oParam.outds = "ds_init_G40list=item";
  662. oParam.async = false;
  663. //oParam.callback = "cf_TRAHB00602";
  664. tranf_submit(oParam);
  665. }
  666. ]]></Script>
  667. </Form>
  668. </FDL>