SPSTP00700_종합수익일보(건진제외).xfdl 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <FDL version="1.5">
  3. <TypeDefinition url="..\..\..\default_typedef.xml"/>
  4. <Form id="SPSTP00700" position="absolute 0 0 1204 805" titletext="종합수익일보(건진제외)" oninit="SPSTP00700_oninit" onload="SPSTP00700_onload">
  5. <Layouts>
  6. <Layout>
  7. <Grid id="grd_upco" taborder="43" binddataset="ds_grdlist_list03" useinputpanel="false" position="absolute 521 536 1195 630" autoenter="select" cellsizingtype="col" anchor="left right bottom">
  8. <Formats>
  9. <Format id="default">
  10. <Columns>
  11. <Column size="91"/>
  12. <Column size="82"/>
  13. <Column size="82"/>
  14. <Column size="82"/>
  15. <Column size="91"/>
  16. <Column size="82"/>
  17. <Column size="82"/>
  18. <Column size="82"/>
  19. </Columns>
  20. <Rows>
  21. <Row size="24" band="head"/>
  22. <Row size="24"/>
  23. </Rows>
  24. <Band id="head">
  25. <Cell text="계정"/>
  26. <Cell col="1" text="발생"/>
  27. <Cell col="2" text="대체"/>
  28. <Cell col="3" text="합계"/>
  29. <Cell col="4" text="계정"/>
  30. <Cell col="5" text="발생"/>
  31. <Cell col="6" text="대체"/>
  32. <Cell col="7" text="합계"/>
  33. </Band>
  34. <Band id="body">
  35. <Cell style="align:left middle;padding:0 0 0 3;" text="bind:smlnm1"/>
  36. <Cell col="1" displaytype="number" text="bind:addamt1"/>
  37. <Cell col="2" displaytype="number" text="bind:downamt1"/>
  38. <Cell col="3" displaytype="number" text="bind:totamt1"/>
  39. <Cell col="4" style="align:left middle;padding:0 0 0 3;" text="bind:smlnm2"/>
  40. <Cell col="5" displaytype="number" text="bind:addamt2"/>
  41. <Cell col="6" displaytype="number" text="bind:downamt2"/>
  42. <Cell col="7" displaytype="number" text="bind:totamt2"/>
  43. </Band>
  44. </Format>
  45. </Formats>
  46. </Grid>
  47. <Grid id="grd_unco" taborder="40" binddataset="ds_grdlist_list02" useinputpanel="false" position="absolute 522 108 1195 511" autoenter="select" cellsizingtype="col" anchor="all" autofittype="col">
  48. <Formats>
  49. <Format id="default">
  50. <Columns>
  51. <Column size="0"/>
  52. <Column size="140"/>
  53. <Column size="0"/>
  54. <Column size="105"/>
  55. <Column size="105"/>
  56. <Column size="105"/>
  57. <Column size="105"/>
  58. <Column size="115"/>
  59. </Columns>
  60. <Rows>
  61. <Row size="24" band="head"/>
  62. <Row size="24" band="head"/>
  63. <Row size="24"/>
  64. </Rows>
  65. <Band id="head">
  66. <Cell text="±"/>
  67. <Cell col="1" rowspan="2" text="계정" taborder="undefined"/>
  68. <Cell col="2"/>
  69. <Cell col="3" colspan="2" text="입원" taborder="undefined"/>
  70. <Cell col="5" colspan="2" text="외래" taborder="undefined"/>
  71. <Cell col="7" rowspan="2" text="합계" taborder="undefined"/>
  72. <Cell row="1" text="±"/>
  73. <Cell row="1" col="2"/>
  74. <Cell row="1" col="3" text="발생"/>
  75. <Cell row="1" col="4" text="입금(대체)"/>
  76. <Cell row="1" col="5" text="발생"/>
  77. <Cell row="1" col="6" text="입금(대체)"/>
  78. </Band>
  79. <Band id="body">
  80. <Cell text="bind:dpt"/>
  81. <Cell col="1" displaytype="tree" edittype="tree" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:lrgnm"/>
  82. <Cell col="2" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:smlnm"/>
  83. <Cell col="3" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:inuncoamt"/>
  84. <Cell col="4" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:inrcptamt"/>
  85. <Cell col="5" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:outuncoamt"/>
  86. <Cell col="6" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:outrcptamt"/>
  87. <Cell col="7" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:totamt"/>
  88. </Band>
  89. </Format>
  90. </Formats>
  91. </Grid>
  92. <Static id="caption5" text="수입" class="tit_2" position="absolute 0 448 65 469"/>
  93. <Shape id="line5" class="line_10" position="absolute 0 464 520 470"/>
  94. <Grid id="grd_incm" taborder="41" binddataset="ds_grdlist_list05" useinputpanel="false" position="absolute 0 469 520 655" autoenter="select" cellsizingtype="col" oncelldblclick="grd_incm_oncelldblclick">
  95. <Formats>
  96. <Format id="default">
  97. <Columns>
  98. <Column size="150"/>
  99. <Column size="120"/>
  100. <Column size="120"/>
  101. <Column size="120"/>
  102. </Columns>
  103. <Rows>
  104. <Row size="24" band="head"/>
  105. <Row size="24"/>
  106. </Rows>
  107. <Band id="head">
  108. <Cell text="계정"/>
  109. <Cell col="1" text="입원"/>
  110. <Cell col="2" text="외래"/>
  111. <Cell col="3" text="합계"/>
  112. </Band>
  113. <Band id="body">
  114. <Cell style="align:left middle;padding:0 0 0 3;background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:earnclsnm"/>
  115. <Cell col="1" displaytype="number" style="background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:inamt"/>
  116. <Cell col="2" displaytype="number" style="background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:outamt"/>
  117. <Cell col="3" displaytype="number" style="background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:totamt"/>
  118. </Band>
  119. </Format>
  120. </Formats>
  121. </Grid>
  122. <Grid id="grd_ordearn" class="datagrid2" taborder="39" binddataset="ds_grdlist_list01" useinputpanel="false" position="absolute 0 108 520 442" autoenter="select" cellsizingtype="col" treeuseimage="false" treeusecheckbox="false" autofittype="col">
  123. <Formats>
  124. <Format id="default">
  125. <Columns>
  126. <Column size="0"/>
  127. <Column size="150"/>
  128. <Column size="0"/>
  129. <Column size="0"/>
  130. <Column size="0"/>
  131. <Column size="120"/>
  132. <Column size="0"/>
  133. <Column size="120"/>
  134. <Column size="130"/>
  135. </Columns>
  136. <Rows>
  137. <Row size="24" band="head"/>
  138. <Row size="24"/>
  139. </Rows>
  140. <Band id="head">
  141. <Cell text="±"/>
  142. <Cell col="1" text="계정"/>
  143. <Cell col="2"/>
  144. <Cell col="3"/>
  145. <Cell col="4" text="입원"/>
  146. <Cell col="5" text="입원"/>
  147. <Cell col="6" text="외래"/>
  148. <Cell col="7" text="외래"/>
  149. <Cell col="8" text="합계"/>
  150. </Band>
  151. <Band id="body">
  152. <Cell text="bind:dpt"/>
  153. <Cell col="1" displaytype="tree" edittype="tree" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:lrgnm" treestartlevel="1" treelevel="bind:dpt"/>
  154. <Cell col="2" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:mdlnm"/>
  155. <Cell col="3" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:smlnm"/>
  156. <Cell col="4" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:inaccntcd"/>
  157. <Cell col="5" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:inamt"/>
  158. <Cell col="6" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:outaccntcd"/>
  159. <Cell col="7" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:outamt"/>
  160. <Cell col="8" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:totamt"/>
  161. </Band>
  162. </Format>
  163. </Formats>
  164. </Grid>
  165. <Div id="grp_sea" taborder="31" position="absolute 0 24 1195 64" class="div_SA" anchor="left top right">
  166. <Layouts>
  167. <Layout>
  168. <Static id="caption21" text="조회기간" class="search_name" position="absolute 11 11 97 28"/>
  169. <Calendar id="ipt_fromdd" taborder="1" class="input_search" position="absolute 88 10 191 29" autoselect="true" autoskip="true"/>
  170. <Static id="caption6" text="~" position="absolute 195 13 220 28"/>
  171. <Calendar id="ipt_todd" taborder="2" class="input_search" position="absolute 208 10 311 29" autoselect="true"/>
  172. <CheckBox id="checkbox1" taborder="3" position="absolute 326 12 521 27" text="중간청구 및 삭감환수 포함" truevalue="Y" onclick="grp_sea_checkbox1_onclick"/>
  173. </Layout>
  174. </Layouts>
  175. </Div>
  176. <Shape position="absolute 985 30 991 57" linetype="vertical" id="line13" class="line_4" anchor="top right"/>
  177. <Button position="absolute 1002 32 1058 54" id="btn_search" class="btn1" taborder="3" text="조회" anchor="top right" onclick="btn_search_onclick"/>
  178. <Button position="absolute 1120 32 1176 54" id="button1" class="btn6" taborder="26" text="출력" anchor="top right" onclick="button1_onclick"/>
  179. <Button position="absolute 1061 32 1117 54" id="btn_clear" class="btn7" taborder="30" text="엑셀" anchor="top right" onclick="btn_clear_onclick"/>
  180. <Static text="※ 입원/외래수익일보의 [순수입원,순수외래] 기준입니다." position="absolute 533 36 908 50" id="caption7" style="color:#ff0000ff;font:Dotum,9,bold;"/>
  181. <Static id="caption60" text="종합수익일보(건진제외)" class="tit_1" position="absolute 0 0 183 24"/>
  182. <Static id="caption1" text="진료수익&#13;&#10; fChangeDspl(group1);&#13;&#10; " class="tit_2" position="absolute 0 87 80 108"/>
  183. <Shape id="line1" class="line_10" position="absolute 0 103 520 109"/>
  184. <Static id="caption2" text="미수&#13;&#10; fChangeDspl(group2);&#13;&#10; " class="tit_2" position="absolute 522 87 607 108"/>
  185. <Shape id="line2" class="line_10" position="absolute 522 103 1195 109" anchor="left top right"/>
  186. <Static id="caption8" text="가수금" class="tit_2" position="absolute 0 663 65 685"/>
  187. <Shape id="line6" linetype="horizontal" class="line_10" position="absolute 0 679 520 685"/>
  188. <Grid id="grd_incm2" taborder="42" binddataset="ds_grdlist_list06" useinputpanel="false" position="absolute 0 684 520 801" autoenter="select" cellsizingtype="col" anchor="left top bottom">
  189. <Formats>
  190. <Format id="default">
  191. <Columns>
  192. <Column size="150"/>
  193. <Column size="120"/>
  194. <Column size="120"/>
  195. <Column size="120"/>
  196. </Columns>
  197. <Rows>
  198. <Row size="24" band="head"/>
  199. <Row size="24"/>
  200. </Rows>
  201. <Band id="head">
  202. <Cell text="계정"/>
  203. <Cell col="1" text="입원"/>
  204. <Cell col="2" text="외래"/>
  205. <Cell col="3" text="합계"/>
  206. </Band>
  207. <Band id="body">
  208. <Cell style="background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:earnclsnm"/>
  209. <Cell col="1" displaytype="number" style="background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:inamt"/>
  210. <Cell col="2" displaytype="number" style="background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:outamt"/>
  211. <Cell col="3" displaytype="number" style="background:EXPR(currow == 0 ? '#ffff99' : '');background2:EXPR(currow == 0 ? '#ffff99' : '');font:EXPR(currow == 0 ? 'arial,9,bold' : '');" text="bind:totamt"/>
  212. </Band>
  213. </Format>
  214. </Formats>
  215. </Grid>
  216. <Static id="caption3" text="선수" class="tit_2" position="absolute 521 515 576 536" anchor="left bottom"/>
  217. <Shape id="line3" linetype="horizontal" class="line_10" position="absolute 521 531 1195 537" anchor="left right bottom"/>
  218. <Static id="caption4" text="기타" class="tit_2" position="absolute 522 640 577 661" anchor="left bottom"/>
  219. <Shape id="line4" linetype="horizontal" class="line_10" position="absolute 522 656 1195 662" anchor="left right bottom"/>
  220. <Grid id="grd_etc" taborder="44" binddataset="ds_grdlist_list04" useinputpanel="false" position="absolute 521 661 1195 801" autoenter="select" cellsizingtype="col" anchor="left right bottom">
  221. <Formats>
  222. <Format id="default">
  223. <Columns>
  224. <Column size="91"/>
  225. <Column size="82"/>
  226. <Column size="82"/>
  227. <Column size="82"/>
  228. <Column size="91"/>
  229. <Column size="82"/>
  230. <Column size="82"/>
  231. <Column size="82"/>
  232. </Columns>
  233. <Rows>
  234. <Row size="24" band="head"/>
  235. <Row size="24"/>
  236. </Rows>
  237. <Band id="head">
  238. <Cell text="계정"/>
  239. <Cell col="1" text="입원"/>
  240. <Cell col="2" text="외래"/>
  241. <Cell col="3" text="합계"/>
  242. <Cell col="4" text="계정"/>
  243. <Cell col="5" text="입원"/>
  244. <Cell col="6" text="외래"/>
  245. <Cell col="7" text="합계"/>
  246. </Band>
  247. <Band id="body">
  248. <Cell style="align:left middle;padding:0 0 0 3;" text="bind:smlnm1"/>
  249. <Cell col="1" displaytype="number" text="bind:inamt1"/>
  250. <Cell col="2" displaytype="number" text="bind:outamt1"/>
  251. <Cell col="3" displaytype="number" text="bind:totamt1"/>
  252. <Cell col="4" style="align:left middle;padding:0 0 0 3;" text="bind:smlnm2"/>
  253. <Cell col="5" displaytype="number" text="bind:inamt2"/>
  254. <Cell col="6" displaytype="number" text="bind:outamt2"/>
  255. <Cell col="7" displaytype="number" text="bind:totamt2"/>
  256. </Band>
  257. </Format>
  258. </Formats>
  259. </Grid>
  260. <Grid id="grd_ordearnexcel" class="datagrid2" taborder="45" binddataset="ds_grdlist_list01" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" treeusecheckbox="false" treeuseimage="false" position="absolute 8 116 272 346" visible="false">
  261. <Formats>
  262. <Format id="default">
  263. <Columns>
  264. <Column size="100"/>
  265. <Column size="150"/>
  266. <Column size="100"/>
  267. <Column size="100"/>
  268. <Column size="100"/>
  269. <Column size="120"/>
  270. <Column size="100"/>
  271. <Column size="120"/>
  272. <Column size="130"/>
  273. </Columns>
  274. <Rows>
  275. <Row size="24" band="head"/>
  276. <Row size="24"/>
  277. </Rows>
  278. <Band id="head">
  279. <Cell text="±"/>
  280. <Cell col="1" text="계정"/>
  281. <Cell col="2" colspan="2" taborder="undefined"/>
  282. <Cell col="4" colspan="2" text="입원" taborder="undefined"/>
  283. <Cell col="6" colspan="2" text="외래" taborder="undefined"/>
  284. <Cell col="8" text="합계"/>
  285. </Band>
  286. <Band id="body">
  287. <Cell text="bind:dpt"/>
  288. <Cell col="1" displaytype="tree" edittype="tree" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:lrgnm" treestartlevel="1" treelevel="bind:dpt"/>
  289. <Cell col="2" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:mdlnm"/>
  290. <Cell col="3" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:smlnm"/>
  291. <Cell col="4" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:inaccntcd"/>
  292. <Cell col="5" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:inamt"/>
  293. <Cell col="6" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:outaccntcd"/>
  294. <Cell col="7" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:outamt"/>
  295. <Cell col="8" displaytype="number" style="background:EXPR(dpt == '1' ? '#ffff99' : '');background2:EXPR(dpt == '1' ? '#ffff99' : '');font:EXPR(dpt == '1' ? 'arial,9,bold' : '');" text="bind:totamt"/>
  296. </Band>
  297. </Format>
  298. </Formats>
  299. </Grid>
  300. </Layout>
  301. </Layouts>
  302. <Objects>
  303. <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  304. <ColumnInfo>
  305. <Column id="fromdd" type="STRING" size="256"/>
  306. <Column id="todd" type="STRING" size="256"/>
  307. <Column id="srchflag" type="STRING" size="256"/>
  308. </ColumnInfo>
  309. <Rows>
  310. <Row>
  311. <Col id="fromdd"/>
  312. <Col id="todd"/>
  313. <Col id="srchflag"/>
  314. </Row>
  315. </Rows>
  316. </Dataset>
  317. <Dataset id="ds_grdlist_list01" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  318. <ColumnInfo>
  319. <Column id="dpt" type="STRING" size="256" sumtext=""/>
  320. <Column id="dpt2" type="STRING" size="256" sumtext=""/>
  321. <Column id="prtseq" type="STRING" size="256" sumtext=""/>
  322. <Column id="lrgcd" type="STRING" size="256" sumtext=""/>
  323. <Column id="mdlcd" type="STRING" size="256" sumtext=""/>
  324. <Column id="smlcd" type="STRING" size="256" sumtext=""/>
  325. <Column id="prtseq2" type="STRING" size="256" sumtext=""/>
  326. <Column id="lrgnm" type="STRING" size="256" sumtext=""/>
  327. <Column id="mdlnm" type="STRING" size="256" sumtext=""/>
  328. <Column id="smlnm" type="STRING" size="256" sumtext=""/>
  329. <Column id="inaccntcd" type="STRING" size="256" sumtext=""/>
  330. <Column id="inamt" type="STRING" size="256" sumtext=""/>
  331. <Column id="outaccntcd" type="STRING" size="256" sumtext=""/>
  332. <Column id="outamt" type="STRING" size="256" sumtext=""/>
  333. <Column id="totamt" type="STRING" size="256" sumtext=""/>
  334. </ColumnInfo>
  335. </Dataset>
  336. <Dataset id="ds_grdlist_list02" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  337. <ColumnInfo>
  338. <Column id="dpt" type="STRING" size="256" sumtext=""/>
  339. <Column id="mdlcd" type="STRING" size="256" sumtext=""/>
  340. <Column id="lrgnm" type="STRING" size="256" sumtext=""/>
  341. <Column id="smlnm" type="STRING" size="256" sumtext=""/>
  342. <Column id="inuncoamt" type="STRING" size="256" sumtext=""/>
  343. <Column id="inrcptamt" type="STRING" size="256" sumtext=""/>
  344. <Column id="outuncoamt" type="STRING" size="256" sumtext=""/>
  345. <Column id="outrcptamt" type="STRING" size="256" sumtext=""/>
  346. <Column id="totamt" type="STRING" size="256" sumtext=""/>
  347. </ColumnInfo>
  348. </Dataset>
  349. <Dataset id="ds_grdlist_list05" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  350. <ColumnInfo>
  351. <Column id="earncls" type="STRING" size="256" sumtext=""/>
  352. <Column id="earnclsnm" type="STRING" size="256" sumtext=""/>
  353. <Column id="outamt" type="STRING" size="256" sumtext=""/>
  354. <Column id="inamt" type="STRING" size="256" sumtext=""/>
  355. <Column id="totamt" type="STRING" size="256" sumtext=""/>
  356. </ColumnInfo>
  357. </Dataset>
  358. <Dataset id="ds_grdlist_list03" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  359. <ColumnInfo>
  360. <Column id="smlnm1" type="STRING" size="256" sumtext=""/>
  361. <Column id="addamt1" type="STRING" size="256" sumtext=""/>
  362. <Column id="downamt1" type="STRING" size="256" sumtext=""/>
  363. <Column id="totamt1" type="STRING" size="256" sumtext=""/>
  364. <Column id="smlnm2" type="STRING" size="256" sumtext=""/>
  365. <Column id="addamt2" type="STRING" size="256" sumtext=""/>
  366. <Column id="downamt2" type="STRING" size="256" sumtext=""/>
  367. <Column id="totamt2" type="STRING" size="256" sumtext=""/>
  368. </ColumnInfo>
  369. </Dataset>
  370. <Dataset id="ds_grdlist_list06" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  371. <ColumnInfo>
  372. <Column id="earncls" type="STRING" size="256" sumtext=""/>
  373. <Column id="earnclsnm" type="STRING" size="256" sumtext=""/>
  374. <Column id="outamt" type="STRING" size="256" sumtext=""/>
  375. <Column id="inamt" type="STRING" size="256" sumtext=""/>
  376. <Column id="totamt" type="STRING" size="256" sumtext=""/>
  377. </ColumnInfo>
  378. </Dataset>
  379. <Dataset id="ds_grdlist_list04" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
  380. <ColumnInfo>
  381. <Column id="smlnm1" type="STRING" size="256" sumtext=""/>
  382. <Column id="inamt1" type="STRING" size="256" sumtext=""/>
  383. <Column id="outamt1" type="STRING" size="256" sumtext=""/>
  384. <Column id="totamt1" type="STRING" size="256" sumtext=""/>
  385. <Column id="smlnm2" type="STRING" size="256" sumtext=""/>
  386. <Column id="inamt2" type="STRING" size="256" sumtext=""/>
  387. <Column id="outamt2" type="STRING" size="256" sumtext=""/>
  388. <Column id="totamt2" type="STRING" size="256" sumtext=""/>
  389. </ColumnInfo>
  390. </Dataset>
  391. </Objects>
  392. <Bind>
  393. <BindItem id="item0" compid="grp_sea.ipt_fromdd" propid="value" datasetid="ds_cond" columnid="fromdd"/>
  394. <BindItem id="item1" compid="grp_sea.ipt_todd" propid="value" datasetid="ds_cond" columnid="todd"/>
  395. <BindItem id="item2" compid="grp_sea.checkbox1" propid="value" datasetid="ds_cond" columnid="srchflag"/>
  396. </Bind>
  397. <Script type="xscript4.0"><![CDATA[/***************************************************************************************
  398. * System Name :
  399. * Job Name :
  400. * Creator :
  401. * Make Date : 2016-05-24
  402. * Description :
  403. *---------------------------------------------------------------------------------------
  404. * Modify Date Modifier Modify Description
  405. *---------------------------------------------------------------------------------------
  406. * 2016-05-24 Live Converter TF->XP
  407. *
  408. *---------------------------------------------------------------------------------------
  409. ****************************************************************************************/
  410. include "com_commonxp::comm_main.xjs";
  411. var arErrorCode = new HashArray();
  412. function SPSTP00700_oninit(obj:Form, e:InitEventInfo)
  413. {
  414. frmf_initForm(obj);
  415. }
  416. function SPSTP00700_onload(obj:Form, e:LoadEventInfo)
  417. {
  418. grdf_initGrid(grd_ordearn);
  419. grdf_initGrid(grd_unco);
  420. grdf_initGrid(grd_incm);
  421. grdf_initGrid(grd_upco);
  422. grdf_initGrid(grd_incm2);
  423. grdf_initGrid(grd_etc);
  424. fInitialize();
  425. }
  426. function fInitialize()
  427. {
  428. ds_cond.setColumn(0, "fromdd", utlf_getCurrentDate()-1);
  429. ds_cond.setColumn(0, "todd", utlf_getCurrentDate()-1);
  430. }
  431. function grp_sea_checkbox1_onclick(obj:CheckBox, e:ClickEventInfo)
  432. {
  433. if(obj.value == "Y")
  434. {}
  435. else
  436. {
  437. ds_cond.setColumn(0, "srchflag", "");
  438. }
  439. }
  440. function btn_search_onclick(obj:Button, e:ClickEventInfo)
  441. {
  442. if(utlf_isNull(ds_cond.getColumn(0, "fromdd")))
  443. {
  444. return;
  445. }
  446. //fInitDisp();
  447. ds_grdlist_list01.clearData();
  448. ds_grdlist_list02.clearData();
  449. ds_grdlist_list03.clearData();
  450. ds_grdlist_list04.clearData();
  451. ds_grdlist_list05.clearData();
  452. ds_grdlist_list06.clearData();
  453. var oParam = {};
  454. oParam.id = "TRSTP01601";
  455. oParam.service = "stspamapp.StsPam";
  456. oParam.method = "reqGetEarnDayRept";
  457. oParam.inds = "req=ds_cond";
  458. oParam.outds = "ds_grdlist_list01=list01 ds_grdlist_list02=list02 ds_grdlist_list03=list03 ds_grdlist_list04=list04 ds_grdlist_list05=list05 ds_grdlist_list06=list06";
  459. oParam.async = false;
  460. oParam.callback = "cf_TRSTP01601";
  461. tranf_submit(oParam);
  462. if(arErrorCode.pop("TRSTP01601") > -1)
  463. {
  464. fDispAprvCnclChng(grd_ordearn);
  465. fDispAprvCnclChng(grd_unco);
  466. fDispAprvCnclChng(grd_incm);
  467. fDispAprvCnclChng(grd_incm2);
  468. }
  469. }
  470. function cf_TRSTP01601(sSvcId, nErrorCode, sErrorMsg) {
  471. arErrorCode.push(sSvcId, nErrorCode);
  472. }
  473. function fDispAprvCnclChng(grdObj)
  474. {
  475. var nodePath = eval(grdObj.binddataset);
  476. var chagValue = "";
  477. var mdlcd = "";
  478. var smlcd = "";
  479. if (grdObj.name == "grd_ordearn")
  480. {
  481. for(var i = 0; i < nodePath.rowcount; i++)
  482. {
  483. //진료수익(본인,청구)만 펼쳐지도록(선택진료는 제외)
  484. mdlcd = nodePath.getColumn(i, "mdlcd");
  485. smlcd = nodePath.getColumn(i, "smlcd");
  486. if (smlcd == "12" || mdlcd == "03" || mdlcd == "04")
  487. {
  488. var row = grdObj.getTreeRow(i);
  489. grdObj.setTreeStatus(row, false);
  490. }
  491. else
  492. {
  493. var row = grdObj.getTreeRow(i);
  494. grdObj.setTreeStatus(row, true);
  495. }
  496. }
  497. }
  498. else if (grdObj.name == "grd_unco")
  499. {
  500. //본인부담미수,재원미수(본인,청구),퇴원미수는 펼쳐지게
  501. mdlcd = nodePath.getColumn(i, "mdlcd");
  502. if (mdlcd == "01" || mdlcd == "06" || mdlcd == "07" || mdlcd == "08")
  503. {
  504. var row = grdObj.getTreeRow(i);
  505. grdObj.setTreeStatus(row, true);
  506. }
  507. else
  508. {
  509. var row = grdObj.getTreeRow(i);
  510. grdObj.setTreeStatus(row, false);
  511. }
  512. }
  513. }
  514. function btn_clear_onclick(obj:Button, e:ClickEventInfo)
  515. {
  516. var sGrd = "grd_ordearnexcel,grd_unco,grd_upco,grd_etc,grd_incm";
  517. var sSheet = "text001,text002,text003,text004,text005";
  518. var today = ds_cond.getColumn(0, "fromdd");
  519. grdf_exportExcelMulti(sGrd, "종합수익일보(건진제외)_"+today, sSheet,false,"","",true);
  520. }
  521. function button1_onclick(obj:Button, e:ClickEventInfo)
  522. {
  523. var objDOM = rptf_createDOM();
  524. rptf_setNodeListToDOM(objDOM, "/root/cond", ds_cond);
  525. rptf_setNodeListToDOM(objDOM, "/root/grdlist/list06", ds_grdlist_list06);
  526. rptf_setNodeListToDOM(objDOM, "/root/grdlist/list01", ds_grdlist_list01);
  527. rptf_setNodeListToDOM(objDOM, "/root/grdlist/list02", ds_grdlist_list02);
  528. rptf_setNodeListToDOM(objDOM, "/root/grdlist/list03", ds_grdlist_list03);
  529. rptf_setNodeListToDOM(objDOM, "/root/grdlist/list04", ds_grdlist_list04);
  530. rptf_setNodeListToDOM(objDOM, "/root/grdlist/list05", ds_grdlist_list05);
  531. var objParam = new Object();
  532. objParam.xml_data_XML1 = objDOM.documentElement.source;
  533. objParam.xml_data_XML2 = objDOM.documentElement.source;
  534. var option = null;
  535. rptf_exeReportPreview30(["RPSTP00903"],[objParam], option);
  536. }
  537. function grd_incm_oncelldblclick(obj:Grid, e:GridClickEventInfo)
  538. {
  539. if (ds_grdlist_list05.rowcount == 0)
  540. {
  541. sysf_messageBox("대상자료가 존재하지 않습니다.", "C000");
  542. return;
  543. }
  544. // 수입구분
  545. var earnclsnm = ds_grdlist_list05.getColumn(ds_grdlist_list05.rowposition, "earnclsnm");
  546. var worktype = "all"; // 수납계정(PK021)
  547. var rcpttype = "all"; // 수납방법(cash, card, online)
  548. var ioflag = "A"; // 외래:O, 입원:I, 전체:A
  549. // 수입구분별, 외래/입원 구분별 파라미터 세팅
  550. // 열에 따른 구분
  551. if (e.cell == obj.getBindCellIndex("Body", "outamt"))
  552. {
  553. ioflag = "O";
  554. // 외래수납장표
  555. worktype = "A01";
  556. }
  557. else if (e.cell == obj.getBindCellIndex("Body", "inamt"))
  558. {
  559. ioflag = "I"
  560. // 입원수납장표
  561. worktype = "A02";
  562. }
  563. // 행에 따른 구분
  564. if (earnclsnm == "현금입금액")
  565. {
  566. rcpttype = "cashamt";
  567. }
  568. else if (earnclsnm == "온라인입금액")
  569. {
  570. rcpttype = "onlineamt";
  571. }
  572. else if (earnclsnm == "신용카드미수입금액")
  573. {
  574. worktype = "B03";
  575. rcpttype = "onlineamt";
  576. }
  577. else if (earnclsnm == "산전지원미수입금액")
  578. {
  579. worktype = "B04";
  580. rcpttype = "onlineamt";
  581. }
  582. else if (earnclsnm == "건유비미수입금액")
  583. {
  584. worktype = "B04";
  585. rcpttype = "onlineamt";
  586. }
  587. else if (earnclsnm == "혈액미수입금액")
  588. {
  589. worktype = "B02";
  590. rcpttype = "onlineamt";
  591. }
  592. else if (earnclsnm == "의사소견서미수입금")
  593. {
  594. worktype = "B05";
  595. rcpttype = "onlineamt";
  596. }
  597. else
  598. {
  599. rcpttype = "all";
  600. }
  601. frmf_setParameter("SMPAE00102_WORKTYPE", worktype);
  602. frmf_setParameter("SMPAE00102_RCPTTYPE", rcpttype);
  603. frmf_setParameter("SMPAE00102_IOFLAG", ioflag);
  604. frmf_setParameter("SMPAE00102_FROMDD", ds_cond.getColumn(0, "fromdd"));
  605. frmf_setParameter("SMPAE00102_TODD", ds_cond.getColumn(0, "todd"));
  606. // SMPAE00102_KU일일마감공통장표
  607. frmf_open("SMPAE00102", "SMPAE00102", "", "", "", "", "", "", "", "", "", "", "M");
  608. }
  609. ]]></Script>
  610. </Form>
  611. </FDL>