SMAHS02000_선수금수납현황.xrw 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
  3. <xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
  4. <xhtml:head>
  5. <xhtml:title>Untitle</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <dyrcptlst>
  11. <item>
  12. <healexamkind/>
  13. <seqno/>
  14. <pid/>
  15. <hngnm/>
  16. <cmpynm/>
  17. <totamt/>
  18. <discamt/>
  19. <cmpyamt/>
  20. <ownuncoamt/>
  21. <cardamt/>
  22. <cashamt/>
  23. <mdlrcptamt/>
  24. <rcptrid/>
  25. <remfact/>
  26. <groupflag/>
  27. <pkgcd/>
  28. <rcptexecdd/>
  29. </item>
  30. <itemch>
  31. <healexamdetlflag/>
  32. <rowcnt/>
  33. <rcptid/>
  34. <hopedd/>
  35. <rcptexecdd/>
  36. <cmpynm/>
  37. <pkgcd/>
  38. <bogjcashamt/>
  39. <bogjcardamt/>
  40. <rebobjamt/>
  41. <rcptrestamt/>
  42. </itemch>
  43. <itemcase>
  44. <healexamdetlflag/>
  45. <rcptid/>
  46. <hngnm/>
  47. <pkgnm/>
  48. <rcptexecdd/>
  49. <rcptamt/>
  50. <mdlrcptamt/>
  51. </itemcase>
  52. </dyrcptlst>
  53. <export/>
  54. </main>
  55. <send>
  56. <srchfdd/>
  57. <srchinstcd/>
  58. <srchpid/>
  59. <srchtdd/>
  60. <srchgubun>1</srchgubun>
  61. <srchhealexamflag/>
  62. </send>
  63. <init>
  64. <baseinfo>
  65. <healexamflaglist/>
  66. <healexamdetlflaglist/>
  67. <healexamdetlflaglist2/>
  68. <healexamdetlflaglst>
  69. <item/>
  70. </healexamdetlflaglst>
  71. <srchhealexamflag/>
  72. </baseinfo>
  73. </init>
  74. </root>
  75. </instance>
  76. <script type="javascript" ev:event="xforms-ready">
  77. <![CDATA[
  78. // 일자초기화
  79. model.setValue("/root/send/srchfdd" , getCurrentDate());
  80. model.setValue("/root/send/srchtdd" , getCurrentDate());
  81. // 기관코드 초기화
  82. model.setValue("/root/send/srchinstcd" , getUserInfo("posinstcd"));
  83. // 공통코드 조회
  84. zbcfGetCodeList( new Array("A0068", "A0069" ,"A0070", "A0068" ),
  85. new Array("/root/init/baseinfo/healexamflaglist", "/root/init/baseinfo/healexamdetlflaglist" , "/root/init/baseinfo/healexamdetlflaglist2", "/root/init/baseinfo/srchhealexamflag") );
  86. addComboItem("cmb_healexamflag","전체","","above");
  87. copyNodesetType("/root/init/baseinfo/healexamdetlflaglst/item","/root/init/baseinfo/healexamdetlflaglist/A0069", "after");
  88. copyNodesetType("/root/init/baseinfo/healexamdetlflaglst/item","/root/init/baseinfo/healexamdetlflaglist2/A0070", "after");
  89. model.refresh();
  90. model.toggle("rcptcase");
  91. ]]>
  92. </script>
  93. <submission id="TRZBC00101"/>
  94. <script type="javascript">
  95. <![CDATA[
  96. /*
  97. * 건진종류 소계 및 총계를 생성한다.
  98. */
  99. function fSetRcptSum() {
  100. // 그리드 merge 및 합계 초기화
  101. grd_dyrcptlst.autoMerge = false;
  102. grd_dyrcptlst.mergeCells = "bycolrec";
  103. grd_dyrcptlst.subtotalPosition = "below";
  104. grd_dyrcptlst.multiTotals = true;
  105. grd_dyrcptlst.subtotal("clear", 0, 0);
  106. for(var i =0; i < grd_dyrcptlst.cols ; i++) {
  107. // 소계
  108. if(i >= grd_dyrcptlst.colRef("rcptamt") && i <= grd_dyrcptlst.colRef("cashamt")) {
  109. grd_dyrcptlst.subtotal("sum", grd_dyrcptlst.colRef("healexamkind") , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold ", grd_dyrcptlst.colRef("healexamkind") , "소계" );
  110. // grd_dyrcptlst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_dyrcptlst.colRef("healexamkind") , "총계" );
  111. }
  112. // 화면 merge
  113. if( i == grd_dyrcptlst.colRef("healexamkind")) {
  114. grd_dyrcptlst.mergeCol(i) = true;
  115. }else{
  116. grd_dyrcptlst.mergeCol(i) = false;
  117. }
  118. }
  119. grd_dyrcptlst.merge();
  120. // 그리드 merge 및 합계 초기화
  121. datagrid1.autoMerge = false;
  122. datagrid1.mergeCells = "bycolrec";
  123. datagrid1.subtotalPosition = "below";
  124. datagrid1.multiTotals = true;
  125. datagrid1.subtotal("clear", 0, 0);
  126. for(var i =0; i < datagrid1.cols ; i++) {
  127. // 소계
  128. if(i >= datagrid1.colRef("bogjcashamt") && i <= datagrid1.colRef("rcptrestamt")) {
  129. datagrid1.subtotal("sum", datagrid1.colRef("healexamdetlflag") , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold ", datagrid1.colRef("healexamkind") , "소계" );
  130. // grd_dyrcptlst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_dyrcptlst.colRef("healexamkind") , "총계" );
  131. }
  132. // 화면 merge
  133. if( i == datagrid1.colRef("healexamdetlflag")) {
  134. datagrid1.mergeCol(i) = true;
  135. }else{
  136. datagrid1.mergeCol(i) = false;
  137. }
  138. }
  139. datagrid1.merge();
  140. // 그리드 merge 및 합계 초기화
  141. datagrid2.autoMerge = false;
  142. datagrid2.mergeCells = "bycolrec";
  143. datagrid2.subtotalPosition = "below";
  144. datagrid2.multiTotals = true;
  145. datagrid2.subtotal("clear", 0, 0);
  146. for(var i =0; i < datagrid1.cols ; i++) {
  147. // 소계
  148. if(i >= datagrid2.colRef("rcptamt") && i <= datagrid2.colRef("mdlrcptamt")) {
  149. datagrid2.subtotal("sum", datagrid2.colRef("healexamdetlflag") , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold ", datagrid2.colRef("healexamdetlflag") , "소계" );
  150. // grd_dyrcptlst.subtotal("sum", -1 , i ,"format:(-,+)#,###; roundmode:round; roundpostion:2", "background-color:#808080; color:#ffffff; font-weight:bold ", grd_dyrcptlst.colRef("healexamkind") , "총계" );
  151. }
  152. // 화면 merge
  153. if( i == datagrid2.colRef("healexamdetlflag")) {
  154. datagrid2.mergeCol(i) = true;
  155. }else{
  156. datagrid2.mergeCol(i) = false;
  157. }
  158. }
  159. datagrid2.merge();
  160. }
  161. ]]>
  162. </script>
  163. <submission id="TRAHS01801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/dyrcptlst"/>
  164. </model>
  165. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  166. <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
  167. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  168. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  169. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  170. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  171. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  172. <script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
  173. </xhtml:head>
  174. <xhtml:body>
  175. <col ref="cmpyamt" format="(-,+)#,###"/>
  176. <col ref="ownuncoamt" format="(-,+)#,###"/>
  177. <col ref="cardamt" format="(-,+)#,###"/>
  178. <col ref="cashamt" format="(-,+)#,###"/>
  179. <col ref="mdlrcptamt" format="(-,+)#,###"/>
  180. <col ref="healexamkind" style="text-align:center; "/>
  181. <col ref="restamt" format="(-,+)#,###"/>
  182. <col ref="seqno"/>
  183. <col ref="rcptrid"/>
  184. <col ref="pid"/>
  185. <col ref="remfact"/>
  186. <col ref="hngnm"/>
  187. <col ref="groupflag" visibility="hidden"/>
  188. <col ref="cmpynm"/>
  189. <col ref="totamt" format="(-,+)#,###"/>
  190. <col ref="discamt" format="(-,+)#,###"/>
  191. <group id="group2" style="left:4px; top:23px; width:1203px; height:35px; ">
  192. <shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1202px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  193. <caption id="caption2" class="search_name" style="left:10px; top:9px; width:73px; height:17px; ">일자 :</caption>
  194. <line id="line2" class="line_4" style="x1:1132px; y1:7px; x2:1132px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
  195. <button id="btn_search" class="btn1_letter2" style="left:1139px; top:7px; width:56px; height:22px; ">
  196. <caption>조회</caption>
  197. <script type="javascript" ev:event="DOMActivate">
  198. <![CDATA[
  199. var ret = submit("TRAHS01801");
  200. if(ret) {
  201. fSetRcptSum();
  202. model.refresh();
  203. }
  204. ]]>
  205. </script>
  206. </button>
  207. <input id="ipt_fromdd" ref="/root/send/srchfdd" class="input_search" navindex="7" inputtype="date" style="left:77px; top:8px; width:105px; height:19px; ">
  208. <script type="javascript" ev:event="onkeydown">
  209. <![CDATA[
  210. /* if( event.keyCode == 13 ) {
  211. var pCurTargetObj = event.ptarget.parent;
  212. if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
  213. event.keyCode = 9;
  214. pCurTargetObj.dispatch("onkeydown");
  215. }
  216. else {
  217. event.keyCode = 9;
  218. }
  219. }
  220. event.stopPropagation(); */
  221. ]]>
  222. </script>
  223. </input>
  224. <button id="btn_excelsave" class="btn6_letter4" visibility="visible" style="left:976px; top:7px; width:80px; height:22px; ">
  225. <caption>액셀저장</caption>
  226. <script type="javascript" ev:event="DOMActivate">
  227. <![CDATA[
  228. if (model.getValue("/root/send/srchgubun")=="1") {
  229. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  230. grd_dyrcptlst.saveExcel(fileName, "SheetName", true, true, "", "", false);
  231. }
  232. if (model.getValue("/root/send/srchgubun")=="2") {
  233. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  234. datagrid1.saveExcel(fileName, "SheetName", true, true, "", "", false);
  235. }
  236. if (model.getValue("/root/send/srchgubun")=="3") {
  237. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  238. datagrid2.saveExcel(fileName, "SheetName", true, true, "", "", false);
  239. }
  240. ]]>
  241. </script>
  242. </button>
  243. <button id="btn_prt" class="btn6_letter2" style="left:1070px; top:7px; width:56px; height:22px; ">
  244. <caption>출력</caption>
  245. <script type="javascript" ev:event="DOMActivate">
  246. <![CDATA[
  247. // 매개변수
  248. for(var i = 1; i <= datagrid1.rows - 3; i++)
  249. {
  250. model.makeValue("/root/main/dyrcptlst/itemch[" + i + "]/healexamdetlflagnm", datagrid1.labelMatrix(i + 1, 0));
  251. }
  252. if(model.getValue("/root/send/srchgubun")=="1") {
  253. model.makeValue("/root/main/export/weeknm" , model.getValue("/root/send/srchdd").toDate("YYYYMMDD").getDayOfWeek("k"));
  254. model.makeValue("/root/main/export/srchdd" , model.getValue("/root/send/srchdd").toDate("YYYYMMDD").getDateFormat("YYYY/MM/DD"));
  255. exeReportPreview("RPAHS01801", "XMLSTR", "/root/main/export","", "false","","","","","false");
  256. } else {
  257. model.makeValue("/root/main/export/weeknm" , model.getValue("/root/send/srchdd").toDate("YYYYMMDD").getDayOfWeek("k"));
  258. model.makeValue("/root/main/export/srchdd" , model.getValue("/root/send/srchdd").toDate("YYYYMMDD").getDateFormat("YYYY/MM/DD"));
  259. exeReportPreview("RPAHS01802", "XMLSTR", "/root/main/export","", "false","","","","","false");
  260. }
  261. ]]>
  262. </script>
  263. </button>
  264. <line id="line3" class="line_4" visibility="hidden" style="x1:1063px; y1:7px; x2:1063px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
  265. <input id="input1" ref="/root/send/srchtdd" class="input_search" navindex="7" inputtype="date" style="left:200px; top:8px; width:105px; height:19px; ">
  266. <script type="javascript" ev:event="onkeydown">
  267. <![CDATA[
  268. /* if( event.keyCode == 13 ) {
  269. var pCurTargetObj = event.ptarget.parent;
  270. if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
  271. event.keyCode = 9;
  272. pCurTargetObj.dispatch("onkeydown");
  273. }
  274. else {
  275. event.keyCode = 9;
  276. }
  277. }
  278. event.stopPropagation(); */
  279. ]]>
  280. </script>
  281. </input>
  282. <caption id="caption19" class="search_n_b" style="left:186px; top:9px; width:12px; height:17px; font-weight:bolder; ">~</caption>
  283. <select1 id="radio1" ref="/root/send/srchgubun" visibility="visible" appearance="full" cols="3" overflow="hidden" style="left:315px; top:10px; width:350px; height:20px; border-style:none; ">
  284. <choices>
  285. <item>
  286. <label>선수금 수납내역</label>
  287. <value>1</value>
  288. </item>
  289. <item>
  290. <label>선수금 미대체 현황</label>
  291. <value>2</value>
  292. </item>
  293. <item>
  294. <label>선수금대체현황</label>
  295. <value>3</value>
  296. </item>
  297. </choices>
  298. <script type="javascript" ev:event="onclick">
  299. <![CDATA[
  300. caption7.visible = false;
  301. cmb_healexamflag.visible = false;
  302. if (model.getValue("/root/send/srchgubun")=="1") {
  303. model.toggle("rcptcase");
  304. model.removeNodeset("/root/main/dyrcptlst/itemch");
  305. model.removeNodeset("/root/main/dyrcptlst/itemcase");
  306. }
  307. if (model.getValue("/root/send/srchgubun")=="2") {
  308. model.toggle("changecase");
  309. model.removeNodeset("/root/main/dyrcptlst/item");
  310. model.removeNodeset("/root/main/dyrcptlst/itemcase");
  311. }
  312. if (model.getValue("/root/send/srchgubun")=="3") {
  313. model.toggle("case1");
  314. model.removeNodeset("/root/main/dyrcptlst/item");
  315. model.removeNodeset("/root/main/dyrcptlst/itemch");
  316. caption7.visible = true;
  317. cmb_healexamflag.visible = true;
  318. }
  319. ]]>
  320. </script>
  321. </select1>
  322. <select1 id="cmb_healexamflag" ref="/root/send/srchhealexamflag" visibility="hidden" appearance="minimal" style="left:755px; top:8px; width:100px; height:19px; ">
  323. <choices>
  324. <itemset nodeset="/root/init/baseinfo/srchhealexamflag/A0068">
  325. <label ref="cdnm"/>
  326. <value ref="cdid"/>
  327. </itemset>
  328. </choices>
  329. <script type="javascript" ev:event="xforms-value-changed">
  330. <![CDATA[
  331. submit("TRAHS01801");
  332. fSetRcptSum();
  333. ]]>
  334. </script>
  335. </select1>
  336. <caption id="caption7" class="search_name" visibility="hidden" style="left:665px; top:9px; width:87px; height:17px; ">건진구분 :</caption>
  337. </group>
  338. <group id="group3" style="left:0px; top:0px; width:1211px; height:13px; ">
  339. <caption id="caption60" class="tit_1" style="left:0px; top:0px; width:183px; height:14px; font-family:돋움; vertical-align:middle; ">선수금 수납현황</caption>
  340. </group>
  341. <switch id="switch1" style="left:5px; top:65px; width:1200px; height:705px; ">
  342. <case id="rcptcase">
  343. <datagrid id="grd_dyrcptlst" nodeset="/root/main/dyrcptlst/item" caption="건진종류^순번^등록번호^성명^수납일자^단체명(계정명)^건진코드^선수금^선수반환^선수대체^실수납액^실수납액^비고|건진종류^순번^등록번호^성명^수납일자^단체명(계정명)^건진코드^선수금^선수반환^선수대체^카드금액^현금^비고" colsep="^" colwidth="90, 30, 80, 80, 100, 146, 80, 80, 87, 87, 87, 87, 223" mergecellsfixedcols="bycol" mergecellsfixedrows="byrowrec" multitotal="true" rowsep="|" subtotalposition="below" style="left:5px; top:5px; width:1188px; height:692px; text-align:center; ">
  344. <col ref="healexamkind" type="combo" style="text-align:center; ">
  345. <choices>
  346. <itemset nodeset="/root/init/baseinfo/healexamflaglist/A0068">
  347. <label ref="cdnm"/>
  348. <value ref="cdid"/>
  349. </itemset>
  350. </choices>
  351. </col>
  352. <col ref="seqno"/>
  353. <col ref="pid"/>
  354. <col ref="hngnm"/>
  355. <col ref="rcptdd"/>
  356. <col ref="cmpynm"/>
  357. <col ref="pkgcd" format="(-,+)#,###"/>
  358. <col ref="rcptamt" format="(-,+)#,###"/>
  359. <col ref="reamt" visibility="hidden" format="(-,+)#,###"/>
  360. <col ref="mdlamt" visibility="hidden" format="(-,+)#,###"/>
  361. <col ref="cardamt" format="(-,+)#,###"/>
  362. <col ref="cashamt" format="(-,+)#,###"/>
  363. <col ref="remfact"/>
  364. </datagrid>
  365. </case>
  366. <case id="changecase">
  367. <datagrid id="datagrid1" nodeset="/root/main/dyrcptlst/itemch" caption="건진구분^순번^등록번호^성명^건진일^최종수납일^단체명^패키지코드^선수금 총액^선수금 총액^선수대체금^선수잔액^caption1|건진구분^순번^등록번호^성명^건진일^최종수납일^단체명^패키지코드^현금^카드^선수대체금^선수잔액^caption1" colsep="^" colwidth="90, 30, 90, 100, 111, 115, 166, 123, 87, 87, 87, 100, 100" mergecellsfixedcols="bycol" mergecellsfixedrows="byrowrec" multitotal="true" rowsep="|" subtotalposition="below" style="left:5px; top:5px; width:1188px; height:692px; text-align:center; ">
  368. <col ref="healexamdetlflag" type="combo" style="text-align:center; ">
  369. <choices>
  370. <itemset nodeset="/root/init/baseinfo/healexamdetlflaglst/item">
  371. <label ref="cdnm"/>
  372. <value ref="cdid"/>
  373. </itemset>
  374. </choices>
  375. </col>
  376. <col ref="rowcnt"/>
  377. <col ref="rcptid"/>
  378. <col ref="hngnm"/>
  379. <col ref="hopedd"/>
  380. <col ref="rcptexecdd"/>
  381. <col ref="cmpynm"/>
  382. <col ref="pkgcd"/>
  383. <col ref="bogjcashamt" format="(-,+)#,###" style="text-align:right; "/>
  384. <col ref="bogjcardamt" format="(-,+)#,###" style="text-align:right; "/>
  385. <col ref="rebobjamt" format="(-,+)#,###" style="text-align:right; "/>
  386. <col ref="rcptrestamt" format="(-,+)#,###" style="text-align:right; "/>
  387. <col ref="healexamdetlflagnm"/>
  388. </datagrid>
  389. </case>
  390. <case id="case1" selected="true">
  391. <datagrid id="datagrid2" nodeset="/root/main/dyrcptlst/itemcase" caption="건진상세구분^환자번호^이름^패키지명^수납수행일자^수납금액^중간금" colsep="^" colwidth="100, 100, 100, 270, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:5px; top:5px; width:1187px; height:691px; ">
  392. <col ref="healexamdetlflag" visibility="hidden" style="text-align:center; "/>
  393. <col ref="rcptid" style="text-align:center; "/>
  394. <col ref="hngnm" style="text-align:center; "/>
  395. <col ref="pkgnm" style="text-align:center; "/>
  396. <col ref="rcptexecdd" format="yyyy-mm-dd" style="text-align:center; "/>
  397. <col ref="rcptamt" format="(-,+)#,###" style="text-align:right; "/>
  398. <col ref="mdlrcptamt" format="(-,+)#,###" style="text-align:right; "/>
  399. </datagrid>
  400. </case>
  401. </switch>
  402. </xhtml:body>
  403. </xhtml:html>