SMAES05000_내시경실통합통계.xfdl 56 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SMAES05000" position="absolute 0 0 1225 795" titletext="내시경실통합통계" oninit="model1_oninit" onload="SMAES05000_onload">
  5. <Layouts>
  6. <Layout>
  7. <Tab id="switch1" taborder="2" tabindex="0" position="absolute 0 93 1224 794" anchor="all" positiontype="position" onchanged="switch1_onchanged">
  8. <Tabpages>
  9. <Tabpage id="case1" text="일별" scrollbars="none" style="anchor:default;margin:0 0 0 0;">
  10. <Layouts>
  11. <Layout>
  12. <Grid id="grd_daylist" taborder="0" useinputpanel="false" position="absolute 0 0 1224 677" anchor="all" binddataset="ds_grid_grd_daylist" positiontype="position" cellsizingtype="col" oncolresized="switch1_case1_grd_daylist_oncolresized">
  13. <Formats>
  14. <Format id="default">
  15. <Columns>
  16. <Column size="109" band="left"/>
  17. <Column size="82" band="left"/>
  18. <Column size="268" band="left"/>
  19. <Column size="40"/>
  20. <Column size="40"/>
  21. <Column size="40"/>
  22. <Column size="40"/>
  23. <Column size="38"/>
  24. <Column size="38"/>
  25. <Column size="38"/>
  26. <Column size="38"/>
  27. <Column size="38"/>
  28. <Column size="38"/>
  29. <Column size="38"/>
  30. <Column size="38"/>
  31. <Column size="38"/>
  32. <Column size="38"/>
  33. <Column size="38"/>
  34. <Column size="38"/>
  35. <Column size="38"/>
  36. <Column size="38"/>
  37. <Column size="38"/>
  38. <Column size="38"/>
  39. <Column size="38"/>
  40. <Column size="38"/>
  41. <Column size="38"/>
  42. <Column size="38"/>
  43. <Column size="38"/>
  44. <Column size="38"/>
  45. <Column size="38"/>
  46. <Column size="38"/>
  47. <Column size="38"/>
  48. <Column size="38"/>
  49. <Column size="38"/>
  50. <Column size="38"/>
  51. <Column size="38"/>
  52. <Column size="38"/>
  53. <Column size="38"/>
  54. <Column size="60"/>
  55. </Columns>
  56. <Rows>
  57. <Row size="28" band="head"/>
  58. <Row size="24"/>
  59. <Row size="24" band="summ"/>
  60. </Rows>
  61. <Band id="head">
  62. <Cell text="검사그룹"/>
  63. <Cell col="1" text="코드"/>
  64. <Cell col="2" text="검사명"/>
  65. <Cell col="3"/>
  66. <Cell col="4"/>
  67. <Cell col="5"/>
  68. <Cell col="6"/>
  69. <Cell col="7" text="1일"/>
  70. <Cell col="8" text="2일"/>
  71. <Cell col="9" text="3일"/>
  72. <Cell col="10" text="4일"/>
  73. <Cell col="11" text="5일"/>
  74. <Cell col="12" text="6일"/>
  75. <Cell col="13" text="7일"/>
  76. <Cell col="14" text="8일"/>
  77. <Cell col="15" text="9일"/>
  78. <Cell col="16" text="10일"/>
  79. <Cell col="17" text="11일"/>
  80. <Cell col="18" text="12일"/>
  81. <Cell col="19" text="13일"/>
  82. <Cell col="20" text="14일"/>
  83. <Cell col="21" text="15일"/>
  84. <Cell col="22" text="16일"/>
  85. <Cell col="23" text="17일"/>
  86. <Cell col="24" text="18일"/>
  87. <Cell col="25" text="19일"/>
  88. <Cell col="26" text="20일"/>
  89. <Cell col="27" text="21일"/>
  90. <Cell col="28" text="22일"/>
  91. <Cell col="29" text="23일"/>
  92. <Cell col="30" text="24일"/>
  93. <Cell col="31" text="25일"/>
  94. <Cell col="32" text="26일"/>
  95. <Cell col="33" text="27일"/>
  96. <Cell col="34" text="28일"/>
  97. <Cell col="35" text="29일"/>
  98. <Cell col="36" text="30일"/>
  99. <Cell col="37" text="31일"/>
  100. <Cell col="38" text="합계"/>
  101. </Band>
  102. <Band id="body">
  103. <Cell style="align:left;" text="bind:systkey1" suppress="1"/>
  104. <Cell col="1" style="align:left;" text="bind:systkey2" suppress="1" suppressalign="middle"/>
  105. <Cell col="2" style="align:left;" text="bind:systkey3" subsumtext="소계" suppress="1" suppressalign="middle"/>
  106. <Cell col="3" text="bind:systkey4"/>
  107. <Cell col="4" text="bind:systkey5"/>
  108. <Cell col="5" text="bind:systkey6"/>
  109. <Cell col="6" text="bind:systkey7"/>
  110. <Cell col="7" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item01" mask="#,##0"/>
  111. <Cell col="8" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item02" mask="#,##0"/>
  112. <Cell col="9" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item03" mask="#,##0"/>
  113. <Cell col="10" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item04" mask="#,##0"/>
  114. <Cell col="11" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item05" mask="#,##0"/>
  115. <Cell col="12" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item06" mask="#,##0"/>
  116. <Cell col="13" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item07" mask="#,##0"/>
  117. <Cell col="14" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item08" mask="#,##0"/>
  118. <Cell col="15" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item09" mask="#,##0"/>
  119. <Cell col="16" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item10" mask="#,##0"/>
  120. <Cell col="17" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item11" mask="#,##0"/>
  121. <Cell col="18" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item12" mask="#,##0"/>
  122. <Cell col="19" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item13" mask="#,##0"/>
  123. <Cell col="20" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item14" mask="#,##0"/>
  124. <Cell col="21" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item15" mask="#,##0"/>
  125. <Cell col="22" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item16" mask="#,##0"/>
  126. <Cell col="23" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item17" mask="#,##0"/>
  127. <Cell col="24" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item18" mask="#,##0"/>
  128. <Cell col="25" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item19" mask="#,##0"/>
  129. <Cell col="26" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item20" mask="#,##0"/>
  130. <Cell col="27" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item21" mask="#,##0"/>
  131. <Cell col="28" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item22" mask="#,##0"/>
  132. <Cell col="29" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item23" mask="#,##0"/>
  133. <Cell col="30" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item24" mask="#,##0"/>
  134. <Cell col="31" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item25" mask="#,##0"/>
  135. <Cell col="32" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item26" mask="#,##0"/>
  136. <Cell col="33" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item27" mask="#,##0"/>
  137. <Cell col="34" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item28" mask="#,##0"/>
  138. <Cell col="35" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item29" mask="#,##0"/>
  139. <Cell col="36" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item30" mask="#,##0"/>
  140. <Cell col="37" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item31" mask="#,##0"/>
  141. <Cell col="38" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:total" mask="#,##0"/>
  142. </Band>
  143. <Band id="summary">
  144. <Cell colspan="3" text="총계"/>
  145. <Cell col="3"/>
  146. <Cell col="4"/>
  147. <Cell col="5"/>
  148. <Cell col="6"/>
  149. <Cell col="7" displaytype="number" text="expr:getSum(&quot;item01&quot;)" mask="#,##0"/>
  150. <Cell col="8" displaytype="number" text="expr:getSum(&quot;item02&quot;)" mask="#,##0"/>
  151. <Cell col="9" displaytype="number" text="expr:getSum(&quot;item03&quot;)" mask="#,##0"/>
  152. <Cell col="10" displaytype="number" text="expr:getSum(&quot;item04&quot;)" mask="#,##0"/>
  153. <Cell col="11" displaytype="number" text="expr:getSum(&quot;item05&quot;)" mask="#,##0"/>
  154. <Cell col="12" displaytype="number" text="expr:getSum(&quot;item06&quot;)" mask="#,##0"/>
  155. <Cell col="13" displaytype="number" text="expr:getSum(&quot;item07&quot;)" mask="#,##0"/>
  156. <Cell col="14" displaytype="number" text="expr:getSum(&quot;item08&quot;)" mask="#,##0"/>
  157. <Cell col="15" displaytype="number" text="expr:getSum(&quot;item09&quot;)" mask="#,##0"/>
  158. <Cell col="16" displaytype="number" text="expr:getSum(&quot;item10&quot;)" mask="#,##0"/>
  159. <Cell col="17" displaytype="number" text="expr:getSum(&quot;item11&quot;)" mask="#,##0"/>
  160. <Cell col="18" displaytype="number" text="expr:getSum(&quot;item12&quot;)" mask="#,##0"/>
  161. <Cell col="19" displaytype="number" text="expr:getSum(&quot;item13&quot;)" mask="#,##0"/>
  162. <Cell col="20" displaytype="number" text="expr:getSum(&quot;item14&quot;)" mask="#,##0"/>
  163. <Cell col="21" displaytype="number" text="expr:getSum(&quot;item15&quot;)" mask="#,##0"/>
  164. <Cell col="22" displaytype="number" text="expr:getSum(&quot;item16&quot;)" mask="#,##0"/>
  165. <Cell col="23" displaytype="number" text="expr:getSum(&quot;item17&quot;)" mask="#,##0"/>
  166. <Cell col="24" displaytype="number" text="expr:getSum(&quot;item18&quot;)" mask="#,##0"/>
  167. <Cell col="25" displaytype="number" text="expr:getSum(&quot;item19&quot;)" mask="#,##0"/>
  168. <Cell col="26" displaytype="number" text="expr:getSum(&quot;item20&quot;)" mask="#,##0"/>
  169. <Cell col="27" displaytype="number" text="expr:getSum(&quot;item21&quot;)" mask="#,##0"/>
  170. <Cell col="28" displaytype="number" text="expr:getSum(&quot;item22&quot;)" mask="#,##0"/>
  171. <Cell col="29" displaytype="number" text="expr:getSum(&quot;item23&quot;)" mask="#,##0"/>
  172. <Cell col="30" displaytype="number" text="expr:getSum(&quot;item24&quot;)" mask="#,##0"/>
  173. <Cell col="31" displaytype="number" text="expr:getSum(&quot;item25&quot;)" mask="#,##0"/>
  174. <Cell col="32" displaytype="number" text="expr:getSum(&quot;item26&quot;)" mask="#,##0"/>
  175. <Cell col="33" displaytype="number" text="expr:getSum(&quot;item27&quot;)" mask="#,##0"/>
  176. <Cell col="34" displaytype="number" text="expr:getSum(&quot;item28&quot;)" mask="#,##0"/>
  177. <Cell col="35" displaytype="number" text="expr:getSum(&quot;item29&quot;)" mask="#,##0"/>
  178. <Cell col="36" displaytype="number" text="expr:getSum(&quot;item30&quot;)" mask="#,##0"/>
  179. <Cell col="37" displaytype="number" text="expr:getSum(&quot;item31&quot;)" mask="#,##0"/>
  180. <Cell col="38" displaytype="number" text="expr:getSum(&quot;total&quot;)" mask="#,##0"/>
  181. </Band>
  182. </Format>
  183. </Formats>
  184. </Grid>
  185. </Layout>
  186. </Layouts>
  187. </Tabpage>
  188. <Tabpage id="case3" text="월별" scrollbars="none">
  189. <Layouts>
  190. <Layout>
  191. <Grid id="grd_monthlist" taborder="0" useinputpanel="false" position="absolute 0 0 1256 682" anchor="all" binddataset="ds_grid_grd_monthlist" positiontype="position" autofittype="col" cellsizingtype="col" oncolresized="switch1_case3_grd_monthlist_oncolresized">
  192. <Formats>
  193. <Format id="default">
  194. <Columns>
  195. <Column size="109"/>
  196. <Column size="82"/>
  197. <Column size="268"/>
  198. <Column size="82"/>
  199. <Column size="60"/>
  200. <Column size="82"/>
  201. <Column size="60"/>
  202. <Column size="47"/>
  203. <Column size="47"/>
  204. <Column size="47"/>
  205. <Column size="47"/>
  206. <Column size="47"/>
  207. <Column size="47"/>
  208. <Column size="47"/>
  209. <Column size="47"/>
  210. <Column size="47"/>
  211. <Column size="47"/>
  212. <Column size="47"/>
  213. <Column size="47"/>
  214. <Column size="64"/>
  215. <Column size="64"/>
  216. <Column size="64"/>
  217. </Columns>
  218. <Rows>
  219. <Row size="24" band="head"/>
  220. <Row size="24" band="head"/>
  221. <Row size="24"/>
  222. <Row size="24" band="summ"/>
  223. </Rows>
  224. <Band id="head">
  225. <Cell rowspan="2" text="검사그룹"/>
  226. <Cell col="1" rowspan="2" text="검사코드"/>
  227. <Cell col="2" rowspan="2" text="검사명"/>
  228. <Cell col="3" rowspan="2" text="처방과"/>
  229. <Cell col="4" rowspan="2" text="처방의"/>
  230. <Cell col="5" rowspan="2" text="시행과"/>
  231. <Cell col="6" rowspan="2" text="시행의"/>
  232. <Cell col="7" colspan="12" text="2006년"/>
  233. <Cell col="19" rowspan="2" text="합계"/>
  234. <Cell col="20" rowspan="2" text="전년도합계"/>
  235. <Cell col="21" rowspan="2" text="증감율"/>
  236. <Cell row="1" col="7" text="1월"/>
  237. <Cell row="1" col="8" text="2월"/>
  238. <Cell row="1" col="9" text="3월"/>
  239. <Cell row="1" col="10" text="4월"/>
  240. <Cell row="1" col="11" text="5월"/>
  241. <Cell row="1" col="12" text="6월"/>
  242. <Cell row="1" col="13" text="7월"/>
  243. <Cell row="1" col="14" text="8월"/>
  244. <Cell row="1" col="15" text="9월"/>
  245. <Cell row="1" col="16" text="10월"/>
  246. <Cell row="1" col="17" text="11월"/>
  247. <Cell row="1" col="18" text="12월"/>
  248. </Band>
  249. <Band id="body">
  250. <Cell text="bind:systkey1" suppress="1"/>
  251. <Cell col="1" style="align:left;" text="bind:systkey2" suppress="1" suppressalign="middle"/>
  252. <Cell col="2" style="align:left;" text="bind:systkey3" subsumtext="소계" suppress="1" suppressalign="middle"/>
  253. <Cell col="3" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:systkey4" suppress="1" suppressalign="middle"/>
  254. <Cell col="4" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:systkey5" suppress="1" suppressalign="middle"/>
  255. <Cell col="5" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:systkey6"/>
  256. <Cell col="6" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:systkey7"/>
  257. <Cell col="7" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item01" mask="#,##0"/>
  258. <Cell col="8" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item02" mask="#,##0"/>
  259. <Cell col="9" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item03" mask="#,##0"/>
  260. <Cell col="10" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item04" mask="#,##0"/>
  261. <Cell col="11" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item05" mask="#,##0"/>
  262. <Cell col="12" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item06" mask="#,##0"/>
  263. <Cell col="13" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item07" mask="#,##0"/>
  264. <Cell col="14" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item08" mask="#,##0"/>
  265. <Cell col="15" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item09" mask="#,##0"/>
  266. <Cell col="16" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item10" mask="#,##0"/>
  267. <Cell col="17" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item11" mask="#,##0"/>
  268. <Cell col="18" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:item12" mask="#,##0"/>
  269. <Cell col="19" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:total" mask="#,##0"/>
  270. <Cell col="20" displaytype="number" style="background:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');background2:EXPR(getRowLevel(currow)==1 ? '#FFFFCC' : 'white');" text="bind:comparecnt" mask="#,##0"/>
  271. <Cell col="21" displaytype="number" text="bind:comparerate" expr="expr:getRowLevel(currow)==1 ? (total - comparecnt)/comparecnt*100 : comparerate" mask="9,999%"/>
  272. </Band>
  273. <Band id="summary">
  274. <Cell colspan="3" text="총계"/>
  275. <Cell col="3"/>
  276. <Cell col="4"/>
  277. <Cell col="5"/>
  278. <Cell col="6"/>
  279. <Cell col="7" displaytype="number" text="expr:getSum(&quot;item01&quot;)" mask="#,##0"/>
  280. <Cell col="8" displaytype="number" text="expr:getSum(&quot;item02&quot;)" mask="#,##0"/>
  281. <Cell col="9" displaytype="number" text="expr:getSum(&quot;item03&quot;)" mask="#,##0"/>
  282. <Cell col="10" displaytype="number" text="expr:getSum(&quot;item04&quot;)" mask="#,##0"/>
  283. <Cell col="11" displaytype="number" text="expr:getSum(&quot;item05&quot;)" mask="#,##0"/>
  284. <Cell col="12" displaytype="number" text="expr:getSum(&quot;item06&quot;)" mask="#,##0"/>
  285. <Cell col="13" displaytype="number" text="expr:getSum(&quot;item07&quot;)" mask="#,##0"/>
  286. <Cell col="14" displaytype="number" text="expr:getSum(&quot;item08&quot;)" mask="#,##0"/>
  287. <Cell col="15" displaytype="number" text="expr:getSum(&quot;item09&quot;)" mask="#,##0"/>
  288. <Cell col="16" displaytype="number" text="expr:getSum(&quot;item10&quot;)" mask="#,##0"/>
  289. <Cell col="17" displaytype="number" text="expr:getSum(&quot;item11&quot;)" mask="#,##0"/>
  290. <Cell col="18" displaytype="number" text="expr:getSum(&quot;item12&quot;)" mask="#,##0"/>
  291. <Cell col="19" displaytype="number" text="expr:getSum(&quot;total&quot;)" mask="#,##0"/>
  292. <Cell col="20" displaytype="number" text="expr:getSum(&quot;comparecnt&quot;)" mask="#,##0"/>
  293. <Cell col="21" displaytype="number" text="expr:getSum(&quot;comparecnt&quot;)==0?0:(getSum(&quot;total&quot;) - getSum(&quot;comparecnt&quot;)) / getSum(&quot;comparecnt&quot;) *100" mask="#,##0%"/>
  294. </Band>
  295. </Format>
  296. </Formats>
  297. </Grid>
  298. </Layout>
  299. </Layouts>
  300. </Tabpage>
  301. </Tabpages>
  302. </Tab>
  303. <Div id="grp_sea" taborder="0" style="align:center top;" position="absolute 0 22 1224 82" class="div_SA" anchor="left top right" positiontype="position">
  304. <Layouts>
  305. <Layout>
  306. <Static id="caption2" text="기준년월" class="search_name" position="absolute 8 9 82 29" anchor="default" positiontype="position"/>
  307. <Combo id="cmb_orddept" taborder="4" position="absolute 819 9 929 29" anchor="default" class="input_essential" innerdataset="@ds_init_cmb_orddeptcd" codecolumn="cd" datacolumn="nm" onitemchanged="grp_sea_cmb_orddept_onitemchanged" positiontype="position"/>
  308. <Combo id="cmb_orddr" taborder="5" position="absolute 932 9 1023 29" anchor="default" class="input_essential" enable="false" innerdataset="@ds_init_cmb_orddrid" codecolumn="cd" datacolumn="nm" positiontype="position"/>
  309. <Static id="caption3" text="처방과/처방의" class="search_name" position="absolute 713 9 819 29" anchor="default" positiontype="position"/>
  310. <Static id="caption12" text="구분" class="search_name" position="absolute 181 9 229 29" anchor="default" positiontype="position"/>
  311. <Radio id="ioflag" taborder="10" columncount="3" rowcount="0" codecolumn="value" datacolumn="label" position="absolute 229 9 360 29" anchor="default" index="0" value="A" innerdataset="@ds_ioflag" positiontype="position"/>
  312. <Static id="caption5" text="검사코드" class="search_name" position="absolute 384 9 458 29" anchor="default" positiontype="position"/>
  313. <Edit id="prcpcd1" taborder="12" position="absolute 458 9 533 29" anchor="default" class="input_essential" imemode="alpha" positiontype="position"/>
  314. <Edit id="prcpcd2" taborder="13" position="absolute 536 9 611 29" anchor="default" class="input_essential" imemode="alpha" positiontype="position"/>
  315. <Edit id="prcpcd3" taborder="14" position="absolute 614 9 689 29" anchor="default" class="input_essential" imemode="alpha" positiontype="position"/>
  316. <cp_monthCal id="ipt_fromdd" titletext="monthCalendar" taborder="16" text="cp_monthCal00" scrollbars="none" position="absolute 82 9 157 31" anchor="default"/>
  317. <CheckBox id="chk_dispyn" taborder="17" text="표시여부" position="absolute 1042 9 1116 29" onchanged="grp_sea_chk_dispyn_onchanged" anchor="default"/>
  318. <Button id="btn_sea" taborder="18" text="조회" onclick="btn_sea_onclick" onlbuttonup="btn_sea_onlbuttonup" class="btn1" position="absolute 1156 20 1212 40" anchor="top right"/>
  319. <Combo id="cmb_execrid" taborder="19" innerdataset="@ds_init_cmb_orddrid" codecolumn="cd" datacolumn="nm" class="input_essential" enable="false" visible="true" position="absolute 933 33 1024 53" anchor="default"/>
  320. <Static id="caption4" text="시행과/시행의" class="search_name" visible="true" position="absolute 713 33 819 53" anchor="default"/>
  321. <Combo id="cmb_execdeptcd" taborder="20" innerdataset="@ds_init_cmb_orddeptcd" codecolumn="cd" datacolumn="nm" class="input_essential" visible="true" position="absolute 818 33 928 53" anchor="default"/>
  322. <Static id="caption1" text="처방형태" class="search_name" visible="true" position="absolute 8 33 82 53" anchor="default"/>
  323. <Combo id="cmb_prcpcdflag" taborder="21" innerdataset="@ds_cmb_prcpcdflag" codecolumn="value" datacolumn="label" class="input_essential" visible="true" position="absolute 82 33 157 53" anchor="default"/>
  324. <Static id="caption7" text="검사그룹" class="search_name" visible="true" position="absolute 181 33 267 53" anchor="default"/>
  325. <Combo id="cmb_examgrupcd" taborder="22" innerdataset="@ds_init_cmb_initexcuroomgrp" codecolumn="basecdcnts" datacolumn="basecdcnts2" class="input_essential" visible="true" position="absolute 253 33 357 53" anchor="default"/>
  326. <Combo id="cmb_exampartcd" taborder="23" innerdataset="@ds_init_cmb_initexcuroom" codecolumn="basecd" datacolumn="basecdflagdesc" class="input_essential" visible="true" position="absolute 458 33 689 53" anchor="default"/>
  327. <Static id="caption8" text="부위코드" class="search_name" visible="true" position="absolute 384 33 458 53" anchor="default"/>
  328. </Layout>
  329. </Layouts>
  330. </Div>
  331. <Button id="btn_excsave" taborder="1" text="엑셀저장" onlbuttonup="btn_excsave_onlbuttonup" class="btn7" position="absolute 1144 91 1224 113" anchor="top right" visible="true" positiontype="position" onclick="btn_excsave_onclick"/>
  332. <Shape id="line1" class="line_1" position="absolute 0 65 1195 65" linetype="horizontal" positiontype="position"/>
  333. <Static id="caption6" text="내시경실통합통계" class="tit_1" position="absolute 0 0 200 25" positiontype="position"/>
  334. </Layout>
  335. </Layouts>
  336. <Objects>
  337. <Dataset id="ds_grid_grd_daylist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  338. <ColumnInfo>
  339. <Column id="systkey1" type="STRING"/>
  340. <Column id="systkey2" type="STRING"/>
  341. <Column id="systkey3" type="STRING"/>
  342. <Column id="systkey4" type="STRING"/>
  343. <Column id="systkey5" type="STRING"/>
  344. <Column id="systkey6" type="STRING"/>
  345. <Column id="systkey7" type="STRING"/>
  346. <Column id="item01" type="STRING"/>
  347. <Column id="item02" type="STRING"/>
  348. <Column id="item03" type="STRING"/>
  349. <Column id="item04" type="STRING"/>
  350. <Column id="item05" type="STRING"/>
  351. <Column id="item06" type="STRING"/>
  352. <Column id="item07" type="STRING"/>
  353. <Column id="item08" type="STRING"/>
  354. <Column id="item09" type="STRING"/>
  355. <Column id="item10" type="STRING"/>
  356. <Column id="item11" type="STRING"/>
  357. <Column id="item12" type="STRING"/>
  358. <Column id="item13" type="STRING"/>
  359. <Column id="item14" type="STRING"/>
  360. <Column id="item15" type="STRING"/>
  361. <Column id="item16" type="STRING"/>
  362. <Column id="item17" type="STRING"/>
  363. <Column id="item18" type="STRING"/>
  364. <Column id="item19" type="STRING"/>
  365. <Column id="item20" type="STRING"/>
  366. <Column id="item21" type="STRING"/>
  367. <Column id="item22" type="STRING"/>
  368. <Column id="item23" type="STRING"/>
  369. <Column id="item24" type="STRING"/>
  370. <Column id="item25" type="STRING"/>
  371. <Column id="item26" type="STRING"/>
  372. <Column id="item27" type="STRING"/>
  373. <Column id="item28" type="STRING"/>
  374. <Column id="item29" type="STRING"/>
  375. <Column id="item30" type="STRING"/>
  376. <Column id="item31" type="STRING"/>
  377. <Column id="total" type="STRING"/>
  378. </ColumnInfo>
  379. </Dataset>
  380. <Dataset id="ds_grid_grd_monthlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" reversesubsum="false">
  381. <ColumnInfo>
  382. <Column id="systkey1" type="STRING"/>
  383. <Column id="systkey2" type="STRING"/>
  384. <Column id="systkey3" type="STRING"/>
  385. <Column id="systkey4" type="STRING"/>
  386. <Column id="systkey5" type="STRING"/>
  387. <Column id="systkey6" type="STRING"/>
  388. <Column id="systkey7" type="STRING"/>
  389. <Column id="item01" type="STRING"/>
  390. <Column id="item02" type="STRING"/>
  391. <Column id="item03" type="STRING"/>
  392. <Column id="item04" type="STRING"/>
  393. <Column id="item05" type="STRING"/>
  394. <Column id="item06" type="STRING"/>
  395. <Column id="item07" type="STRING"/>
  396. <Column id="item08" type="STRING"/>
  397. <Column id="item09" type="STRING"/>
  398. <Column id="item10" type="STRING"/>
  399. <Column id="item11" type="STRING"/>
  400. <Column id="item12" type="STRING"/>
  401. <Column id="total" type="STRING"/>
  402. <Column id="comparecnt" type="STRING"/>
  403. <Column id="comparerate" type="STRING"/>
  404. </ColumnInfo>
  405. </Dataset>
  406. <Dataset id="ds_init_cmb_orddeptcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  407. <ColumnInfo>
  408. <Column id="cd" type="STRING" size="256"/>
  409. <Column id="nm" type="STRING" size="256"/>
  410. </ColumnInfo>
  411. </Dataset>
  412. <Dataset id="ds_init_cmb_orddrid" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  413. <ColumnInfo>
  414. <Column id="nm" type="STRING" size="256"/>
  415. <Column id="cd" type="STRING" size="256"/>
  416. <Column id="dp" type="STRING" size="256"/>
  417. </ColumnInfo>
  418. </Dataset>
  419. <Dataset id="ds_init_cmb_initexcuroomgrp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  420. <ColumnInfo>
  421. <Column id="basecdcnts" type="STRING" size="256"/>
  422. <Column id="basecdcnts2" type="STRING" size="256"/>
  423. </ColumnInfo>
  424. </Dataset>
  425. <Dataset id="ds_init_cmb_initexcuroom" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  426. <ColumnInfo>
  427. <Column id="basecd" type="STRING" size="256"/>
  428. <Column id="basecdflagdesc" type="STRING" size="256"/>
  429. <Column id="basecdcnts" type="STRING" size="256"/>
  430. <Column id="excuposseqcd" type="STRING" size="256"/>
  431. <Column id="sortno" type="STRING" size="256"/>
  432. </ColumnInfo>
  433. </Dataset>
  434. <Dataset id="ds_ioflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  435. <ColumnInfo>
  436. <Column id="label" type="STRING" size="256"/>
  437. <Column id="value" type="STRING" size="256"/>
  438. </ColumnInfo>
  439. <Rows>
  440. <Row>
  441. <Col id="label">전체</Col>
  442. <Col id="value">A</Col>
  443. </Row>
  444. <Row>
  445. <Col id="label">입원</Col>
  446. <Col id="value">I</Col>
  447. </Row>
  448. <Row>
  449. <Col id="label">외래</Col>
  450. <Col id="value">O</Col>
  451. </Row>
  452. </Rows>
  453. </Dataset>
  454. <Dataset id="ds_cmb_prcpcdflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  455. <ColumnInfo>
  456. <Column id="label" type="STRING" size="256"/>
  457. <Column id="value" type="STRING" size="256"/>
  458. </ColumnInfo>
  459. <Rows>
  460. <Row>
  461. <Col id="label">모코드</Col>
  462. <Col id="value">1</Col>
  463. </Row>
  464. <Row>
  465. <Col id="label">자코드</Col>
  466. <Col id="value">2</Col>
  467. </Row>
  468. </Rows>
  469. </Dataset>
  470. <Dataset id="ds_dispyn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
  471. <Dataset id="ds_req" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  472. <ColumnInfo>
  473. <Column id="srchdate" type="STRING" size="256"/>
  474. <Column id="suppdeptcd" type="STRING" size="256"/>
  475. <Column id="srchprcpcdflag" type="STRING" size="256"/>
  476. <Column id="examgrupcd" type="STRING" size="256"/>
  477. <Column id="exampartcd" type="STRING" size="256"/>
  478. <Column id="orddeptcd" type="STRING" size="256"/>
  479. <Column id="orddrid" type="STRING" size="256"/>
  480. <Column id="execdeptcd" type="STRING" size="256"/>
  481. <Column id="execrid" type="STRING" size="256"/>
  482. <Column id="srchioflag" type="STRING" size="256"/>
  483. <Column id="srchflag" type="STRING" size="256"/>
  484. <Column id="prcpcd" type="STRING" size="256"/>
  485. <Column id="dispyn" type="STRING" size="256"/>
  486. </ColumnInfo>
  487. <Rows>
  488. <Row/>
  489. </Rows>
  490. </Dataset>
  491. </Objects>
  492. <Bind>
  493. <BindItem id="item1" compid="" propid="" datasetid="ds_dispyn" columnid="표시여부"/>
  494. </Bind>
  495. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  496. * System Name : KU2.0
  497. * Job Name :
  498. * File Name :
  499. * Creator :
  500. * Make Date : 2016-03-25
  501. *
  502. * Description :
  503. *
  504. *---------------------------------------------------------------------------------------
  505. ****************************************************************************************/
  506. include "com_commonxp::comm_main.xjs";
  507. include "com_basiccodexp::ZBC001.xjs";
  508. include "ast_examcurexp::AEZ0001.xjs";
  509. //=======================================================================================
  510. // Function
  511. //---------------------------------------------------------------------------------------
  512. // function fSetSubTotal(grd_list:Grid, srchstatsflag, srchflag) {
  513. //
  514. // var colpos = 0;
  515. // var rowCnt = 0;
  516. // var ds_grd_list = grd_list.binddataset;
  517. //
  518. // grd_list.colSort(0) = "asc";
  519. // grd_list.sort(0, 0, grd_list.rows, grd_list.cols) = "usersort";
  520. //
  521. // colpos = grd_list.colRef("systkey2");
  522. //
  523. // for(i=7; i<grd_list.cols; i++) {
  524. // grd_list.subtotal("sum", 1, i, "#,###", "background-color:#FFFFCC; color:#0000ff; font-weight:bold; ", colpos, "소계");
  525. // grd_list.subtotal("sum", -1, i, "#,###", "background-color:#CCFFCC; color:#0000ff; font-weight:bold; ", 1, "총계");
  526. // }
  527. // grd_list.mergeByFree(grd_list.rows-1, 1 , grd_list.rows-1, 3);
  528. //
  529. // rowCnt = grd_list.rows;
  530. //
  531. // // 증감율 구하기
  532. // var colnm = "";
  533. // var subtotal = 0;
  534. // var subcomparecnt = 0;
  535. // var subcomparerate = "";
  536. //
  537. // for (i=0; i<rowCnt; i++) {
  538. //
  539. // colnm = grd_list.valueMatrix(i, colpos);
  540. //
  541. // if (colnm == "소계" ) {
  542. //
  543. // // 소계 합계
  544. // subtotal = grd_list.valueMatrix(i, grd_list.colRef("total"));
  545. // subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("comparecnt"));
  546. // grd_list.valueMatrix(i, grd_list.colRef("comparerate")) = setCompareRate(subtotal, subcomparecnt);
  547. //
  548. // // 분기별일 경우 분기별 증감율 구하기
  549. // if (srchflag == "Q") {
  550. //
  551. // // 1분기
  552. // subtotal = grd_list.valueMatrix(i, grd_list.colRef("item01"));
  553. // subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item09"));
  554. // grd_list.valueMatrix(i, grd_list.colRef("item02")) = setCompareRate(subtotal, subcomparecnt);
  555. //
  556. // // 2분기
  557. // subtotal = grd_list.valueMatrix(i, grd_list.colRef("item03"));
  558. // subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item10"));
  559. // grd_list.valueMatrix(i, grd_list.colRef("item04")) = setCompareRate(subtotal, subcomparecnt);
  560. //
  561. // // 3분기
  562. // subtotal = grd_list.valueMatrix(i, grd_list.colRef("item05"));
  563. // subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item11"));
  564. // grd_list.valueMatrix(i, grd_list.colRef("item06")) = setCompareRate(subtotal, subcomparecnt);
  565. //
  566. // // 4분기
  567. // subtotal = grd_list.valueMatrix(i, grd_list.colRef("item07"));
  568. // subcomparecnt = grd_list.valueMatrix(i, grd_list.colRef("item12"));
  569. // grd_list.valueMatrix(i, grd_list.colRef("item08")) = setCompareRate(subtotal, subcomparecnt);
  570. //
  571. // grd_list.cellformat(i, grd_list.colRef("item02")) = "(-)#,### %";
  572. // grd_list.cellformat(i, grd_list.colRef("item04")) = "(-)#,### %";
  573. // grd_list.cellformat(i, grd_list.colRef("item06")) = "(-)#,### %";
  574. // grd_list.cellformat(i, grd_list.colRef("item08")) = "(-)#,### %";
  575. // } // 분기별일 경우 분기별 증감율 구하기 끝
  576. //
  577. // grd_list.cellformat(i, grd_list.colRef("comparerate")) = "(-)#,### %";
  578. // }
  579. // }
  580. //
  581. //
  582. // }
  583. function f_TRPMOCOM01(){//진료과/진료의 조회
  584. dsf_createDsRow("ds_cmb_req",
  585. [{col:"sess_posinstcd", val:""}//세션에서가져오는값으로 변경해야됨.
  586. ,{col:"dridsorttype", val:""}
  587. ]);
  588. var oParam = new Object();
  589. oParam.id = "TRPMOCOM01";
  590. oParam.service = "pamcomnapp.PamComn";
  591. oParam.method = "reqGetComCD";
  592. oParam.inds = "req=ds_cmb_req";
  593. oParam.outds ="ds_init_cmb_orddeptcd=orddeptcd ds_init_cmb_orddrid=orddrid";
  594. oParam.callback = "cbf_TRPMOCOM01";
  595. tranf_submit(oParam);
  596. }
  597. function cbf_TRPMOCOM01(sSvcId, objErrorCode, objErrorMsg){
  598. frmf_addComboItem("grp_sea.cmb_orddept", "--전체--", "", ""); //처방과
  599. frmf_addComboItem("grp_sea.cmb_orddr", "--전체--", "", ""); //처방의
  600. grp_sea.cmb_orddept.index = 0;
  601. grp_sea.cmb_orddr.index = 0;
  602. grp_sea.cmb_execdeptcd.index = 0;
  603. grp_sea.cmb_execrid.index = 0;
  604. }
  605. function f_TRAES05002(){// 검사그룹/부위코드 조회
  606. dsf_createDsRow("ds_cmb_reqparam",
  607. [{col:"basesuppdeptcd", val:suppdeptcd}
  608. ,{col:"rbasecdflag", val:"H"}
  609. ]);
  610. var oParam = new Object();
  611. oParam.id = "TRAES05002";
  612. oParam.service = "examcurestatsapp.FuntExam";
  613. oParam.method = "reqGetExamRoomInfo";
  614. oParam.inds = "reqparam=ds_cmb_reqparam";
  615. oParam.outds ="ds_init_cmb_initexcuroomgrp=initexcuroomgrp ds_init_cmb_initexcuroom=initexcuroom";
  616. oParam.callback = "cbf_TRAES05002";
  617. tranf_submit(oParam);
  618. }
  619. function cbf_TRAES05002(sSvcId, objErrorCode, objErrorMsg){
  620. grp_sea.cmb_examgrupcd.index = 0;
  621. grp_sea.cmb_exampartcd.index = 0;
  622. }
  623. function f_TRAES05001(){//조회
  624. var prcpcd = grp_sea.prcpcd1.text + grp_sea.prcpcd2.text + grp_sea.prcpcd3.text;
  625. if(utlf_isNull(prcpcd) == false){
  626. prcpcd = grp_sea.prcpcd1.text + "','" + grp_sea.prcpcd2.text + "','" + grp_sea.prcpcd3.text;
  627. }else{
  628. prcpcd = "";
  629. }
  630. if(grp_sea.chk_dispyn.value == true){//표시여부 설정
  631. var diapyn = "Y";
  632. }
  633. else if(grp_sea.chk_dispyn.value == false){
  634. var diapyn = "N";
  635. }
  636. if(diapyn == "Y"){
  637. ds_req.setColumn(0, "srchdate", grp_sea.ipt_fromdd.getData());
  638. ds_req.setColumn(0, "suppdeptcd", suppdeptcd);
  639. ds_req.setColumn(0, "srchprcpcdflag", grp_sea.cmb_prcpcdflag.value);
  640. ds_req.setColumn(0, "examgrupcd", grp_sea.cmb_examgrupcd.value);
  641. ds_req.setColumn(0, "exampartcd", grp_sea.cmb_exampartcd.value);
  642. ds_req.setColumn(0, "orddeptcd", grp_sea.cmb_orddept.value);
  643. ds_req.setColumn(0, "orddrid", grp_sea.cmb_orddr.value);
  644. ds_req.setColumn(0, "execdeptcd", grp_sea.cmb_execdeptcd.value);
  645. ds_req.setColumn(0, "execrid", grp_sea.cmb_execrid.value);
  646. ds_req.setColumn(0, "srchioflag", grp_sea.ioflag.value);
  647. ds_req.setColumn(0, "prcpcd", prcpcd);
  648. ds_req.setColumn(0, "dispyn", "Y");
  649. }else{
  650. ds_req.setColumn(0, "srchdate", grp_sea.ipt_fromdd.getData());
  651. ds_req.setColumn(0, "suppdeptcd", suppdeptcd);
  652. ds_req.setColumn(0, "srchprcpcdflag", grp_sea.cmb_prcpcdflag.value);
  653. ds_req.setColumn(0, "examgrupcd", grp_sea.cmb_examgrupcd.value);
  654. ds_req.setColumn(0, "exampartcd", grp_sea.cmb_exampartcd.value);
  655. ds_req.setColumn(0, "orddeptcd", grp_sea.cmb_orddept.value);
  656. ds_req.setColumn(0, "orddrid", grp_sea.cmb_orddr.value);
  657. ds_req.setColumn(0, "execdeptcd", grp_sea.cmb_execdeptcd.value);
  658. ds_req.setColumn(0, "execrid", grp_sea.cmb_execrid.value);
  659. ds_req.setColumn(0, "srchioflag", grp_sea.ioflag.value);
  660. ds_req.setColumn(0, "prcpcd", prcpcd);
  661. ds_req.setColumn(0, "dispyn", "");
  662. }
  663. if(switch1.tabindex == 0){//일별
  664. ds_req.setColumn(0, "srchflag", "D");
  665. var oParam = new Object();
  666. oParam.id = "TRAES05001";
  667. oParam.service = "examcurestatsapp.FuntExam";
  668. oParam.method = "reqGetEscopeSytsStatsCaseList";
  669. oParam.inds = "req=ds_req";
  670. oParam.outds ="ds_grid_grd_daylist=item";
  671. oParam.callback = "cbf_TRAES05001";
  672. tranf_submit(oParam);
  673. }
  674. // 월별
  675. else if(switch1.tabindex == 1){
  676. ds_req.setColumn(0, "srchflag", "M");
  677. var oParam = new Object();
  678. oParam.id = "TRAES05001";
  679. oParam.service = "examcurestatsapp.FuntExam";
  680. oParam.method = "reqGetEscopeSytsStatsCaseList";
  681. oParam.inds = "req=ds_req";
  682. oParam.outds ="ds_grid_grd_monthlist=item";
  683. oParam.callback = "cbf_TRAES05001";
  684. tranf_submit(oParam);
  685. }
  686. }
  687. function cbf_TRAES05001(sSvcId, objErrorCode, objErrorMsg){
  688. // 소계 및 합계 구하는 함수 호출 - grid Object, 통계구분, 탭구분)
  689. if(switch1.tabindex == 0)
  690. {
  691. ds_grid_grd_daylist.addColumn("systkey0","int");
  692. for(var i=0; i< ds_grid_grd_daylist.rowcount;i++)
  693. {
  694. if(utlf_isNull(ds_grid_grd_daylist.getColumn(i,"systkey1")))
  695. {
  696. ds_grid_grd_daylist.setColumn(i,"systkey0",2);
  697. }
  698. else
  699. {
  700. ds_grid_grd_daylist.setColumn(i,"systkey0",1);
  701. }
  702. }
  703. //fSetSubTotal(switch1.case1.grd_daylist, "" , "D");
  704. ds_grid_grd_daylist.keystring = "G:+systkey0+systkey1";
  705. }
  706. else if(switch1.tabindex == 1){
  707. ds_grid_grd_monthlist.addColumn("systkey0","int");
  708. for(var i=0; i< ds_grid_grd_monthlist.rowcount;i++)
  709. {
  710. if(utlf_isNull(ds_grid_grd_monthlist.getColumn(i,"systkey1")))
  711. {
  712. ds_grid_grd_monthlist.setColumn(i,"systkey0",2);
  713. }
  714. else
  715. {
  716. ds_grid_grd_monthlist.setColumn(i,"systkey0",1);
  717. }
  718. }
  719. //fSetSubTotal(switch1.case1.grd_daylist, "" , "D");
  720. ds_grid_grd_monthlist.keystring = "G:+systkey0+systkey1";
  721. }
  722. }
  723. /* @group : 통합 통계
  724. * @ver :
  725. * @by :
  726. * @-----------------------------------
  727. * @type : function
  728. * @access : public
  729. * @desc : 내시경실 통합통계 조회
  730. */
  731. function f_getEscopeSytsStatsCaseList(){
  732. f_TRAES05001();//조회
  733. }
  734. /* @group : 통합 통계
  735. * @ver :
  736. * @by :
  737. * @-----------------------------------
  738. * @type : function
  739. * @access : public
  740. * @desc : 통계 구분별 그리드 header를 정의하는 함수
  741. */
  742. function f_setYear() {//그리드 헤더 년도 설정
  743. var tempYear = grp_sea.ipt_fromdd.getData();
  744. var tempYear1 = tempYear.substr(0,4) + "년";
  745. switch1.case3.grd_monthlist.setCellProperty("head",7,"text", tempYear1);
  746. }
  747. function f_setGridDate(){//월에따른 일자수 그리드 설정
  748. var temp3 = grp_sea.ipt_fromdd.getData();
  749. var temp4 = temp3.substr(4,2);
  750. //switch1.case1.grd_daylist.setFormatColProperty(35, "size", 30);
  751. //switch1.case1.grd_daylist.setFormatColProperty(36, "size", 30);
  752. //switch1.case1.grd_daylist.setFormatColProperty(37, "size", 30);
  753. if(temp4 == "02"){
  754. switch1.case1.grd_daylist.setFormatColProperty(35, "size", 0);
  755. switch1.case1.grd_daylist.setFormatColProperty(36, "size", 0);
  756. switch1.case1.grd_daylist.setFormatColProperty(37, "size", 0);
  757. }else if(temp4 == "04"){
  758. switch1.case1.grd_daylist.setFormatColProperty(37, "size", 0);
  759. }else if(temp4 == "06"){
  760. switch1.case1.grd_daylist.setFormatColProperty(37, "size", 0);
  761. }else if(temp4 == "09"){
  762. switch1.case1.grd_daylist.setFormatColProperty(37, "size", 0);
  763. }else if(temp4 == "11"){
  764. switch1.case1.grd_daylist.setFormatColProperty(37, "size", 0);
  765. }
  766. }
  767. function cbf_fromdd(){//달력 정보가 바뀔때 그리드 셋팅
  768. f_setGridDate();
  769. f_setYear();
  770. }
  771. function f_dispyn(){//표시여부에 따른 그리드 설정
  772. if(grp_sea.chk_dispyn.value == true){
  773. switch1.case1.grd_daylist.setFormatColProperty(3, "size", 80);
  774. switch1.case1.grd_daylist.setFormatColProperty(4, "size", 60);
  775. switch1.case1.grd_daylist.setFormatColProperty(5, "size", 0);
  776. switch1.case1.grd_daylist.setFormatColProperty(6, "size", 0);
  777. switch1.case3.grd_monthlist.setFormatColProperty(3, "size", 80);
  778. switch1.case3.grd_monthlist.setFormatColProperty(4, "size", 60);
  779. switch1.case3.grd_monthlist.setFormatColProperty(5, "size", 0);
  780. switch1.case3.grd_monthlist.setFormatColProperty(6, "size", 0);
  781. }
  782. else if(grp_sea.chk_dispyn.value == false){
  783. switch1.case1.grd_daylist.setFormatColProperty(3, "size", 0);
  784. switch1.case1.grd_daylist.setFormatColProperty(4, "size", 0);
  785. switch1.case1.grd_daylist.setFormatColProperty(5, "size", 0);
  786. switch1.case1.grd_daylist.setFormatColProperty(6, "size", 0);
  787. switch1.case3.grd_monthlist.setFormatColProperty(3, "size", 0);
  788. switch1.case3.grd_monthlist.setFormatColProperty(4, "size", 0);
  789. switch1.case3.grd_monthlist.setFormatColProperty(5, "size", 0);
  790. switch1.case3.grd_monthlist.setFormatColProperty(6, "size", 0);
  791. }
  792. }
  793. //=======================================================================================
  794. // Event
  795. //---------------------------------------------------------------------------------------
  796. /****************************************************************************************
  797. * Components :
  798. * Components ID : SMAES05000
  799. * Event : onload
  800. * Argument : 01.obj : Object Event has occurred
  801. * : 02.e : Event Object
  802. * Description :
  803. ****************************************************************************************/
  804. function SMAES05000_onload(obj:Form, e:LoadEventInfo)
  805. {
  806. frmf_initForm(obj); // 화면공통
  807. lf_aezfSetSuppDeptcd();
  808. // 진료과/진료의 조회
  809. f_TRPMOCOM01();
  810. // 검사그룹/부위코드 조회
  811. f_TRAES05002();
  812. //grp_sea.cmb_prcpcdflag.index = 0;
  813. grp_sea.ioflag.index = 0;
  814. //기준년월설정
  815. grp_sea.ipt_fromdd.setData(utlf_getCurrentDate().substr(0,6));
  816. grp_sea.ipt_fromdd.setCallEvent("cbf_fromdd");
  817. //표시여부
  818. grp_sea.chk_dispyn.value = false;
  819. switch1.case1.grd_daylist.setFormatColProperty(3, "size", 0);
  820. switch1.case1.grd_daylist.setFormatColProperty(4, "size", 0);
  821. switch1.case1.grd_daylist.setFormatColProperty(5, "size", 0);
  822. switch1.case1.grd_daylist.setFormatColProperty(6, "size", 0);
  823. switch1.case3.grd_monthlist.setFormatColProperty(3, "size", 0);
  824. switch1.case3.grd_monthlist.setFormatColProperty(4, "size", 0);
  825. switch1.case3.grd_monthlist.setFormatColProperty(5, "size", 0);
  826. switch1.case3.grd_monthlist.setFormatColProperty(6, "size", 0);
  827. f_setGridDate();
  828. f_setYear();
  829. }
  830. /****************************************************************************************
  831. * Components :
  832. * Components ID : btn_sea
  833. * Event : onclick
  834. * Argument : 01.obj : Object Event has occurred
  835. * : 02.e : Event Object
  836. * Description :
  837. ****************************************************************************************/
  838. function btn_sea_onclick(obj:Button, e:ClickEventInfo)
  839. {
  840. // 내시경실 통합통계 조회
  841. f_getEscopeSytsStatsCaseList();
  842. }
  843. /****************************************************************************************
  844. * Components :
  845. * Components ID : btn_excsave
  846. * Event : onclick
  847. * Argument : 01.obj : Object Event has occurred
  848. * : 02.e : Event Object
  849. * Description :
  850. ****************************************************************************************/
  851. function btn_excsave_onclick(obj:Button, e:ClickEventInfo)
  852. {
  853. if(switch1.tabindex == 0){
  854. if(ds_grid_grd_daylist.rowcount <= 0){
  855. sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
  856. return;
  857. }else{
  858. grdf_exportExcel(switch1.case1.grd_daylist, "내시경실통합통계(일별)", "sheet1");
  859. }
  860. }else if(switch1.tabindex == 1){
  861. if(ds_grid_grd_monthlist.rowcount <= 0){
  862. sysf_messageBox("엑셀파일로 저장할 리스트 내역이", "I004");
  863. return;
  864. }else{
  865. grdf_exportExcel(switch1.case3.grd_monthlist, "내시경실통합통계(월별)", "sheet1");
  866. }
  867. }
  868. }
  869. //탭선택시 조회
  870. function switch1_onchanged(obj:Tab, e:TabIndexChangeEventInfo)
  871. {
  872. f_getEscopeSytsStatsCaseList();
  873. }
  874. function grp_sea_chk_dispyn_onchanged(obj:CheckBox, e:CheckBoxChangeEventInfo)//표시여부 변경시 그리드 설정
  875. {
  876. f_dispyn();
  877. btn_sea_onclick();
  878. }
  879. function switch1_case1_grd_daylist_oncolresized(obj:Grid, e:GridSizeChangedEventInfo)
  880. {
  881. if(e.newvalue == 0){
  882. obj.setRealColSize(e.subindex, 1);
  883. }
  884. }
  885. function switch1_case3_grd_monthlist_oncolresized(obj:Grid, e:GridSizeChangedEventInfo)
  886. {
  887. if(e.newvalue == 0){
  888. obj.setRealColSize(e.subindex, 1);
  889. }
  890. }
  891. function grp_sea_cmb_orddept_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
  892. {
  893. if(utlf_isNull(grp_sea.cmb_orddept.value)){
  894. grp_sea.cmb_orddr.enable = false;
  895. }else{
  896. grp_sea.cmb_orddr.enable = true;
  897. }
  898. var vorddrid = grp_sea.cmb_orddept.value;
  899. ds_init_cmb_orddrid.filter("dp == '" + vorddrid + "'");
  900. frmf_addComboItem( "grp_sea.cmb_orddr", "--전체--", "", "");
  901. grp_sea.cmb_orddr.value = "";
  902. }
  903. ]]></Script>
  904. </Form>
  905. </FDL>