SMPAS00110_선수금현황.xrw 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249
  1. <?xml version="1.0" encoding="UTF-16"?>
  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>선수금현황</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <sunsuamtlist>
  11. <sunsuamtstats>
  12. <deptengnm/>
  13. <sunsuname/>
  14. <cont/>
  15. <acumteamt/>
  16. <todysunsu/>
  17. <retrnamt/>
  18. <restamt/>
  19. <orddeptcd/>
  20. </sunsuamtstats>
  21. </sunsuamtlist>
  22. <search>
  23. <fromdata/>
  24. <todata/>
  25. <datagubun>1</datagubun>
  26. <erdata>1</erdata>
  27. <dcgubun>D</dcgubun>
  28. </search>
  29. <sunsusumamtlist>
  30. <sunsusumamtstats>
  31. <deptengnm>총계</deptengnm>
  32. <sunsuname/>
  33. <cont/>
  34. <acumteamt/>
  35. <todysunsu/>
  36. <retrnamt/>
  37. <restamt/>
  38. <orddeptcd/>
  39. </sunsusumamtstats>
  40. </sunsusumamtlist>
  41. <tmpinfo>
  42. <info>
  43. <user/>
  44. </info>
  45. </tmpinfo>
  46. </main>
  47. <send>
  48. <fromdata/>
  49. <todata/>
  50. <datagubun/>
  51. <erdata/>
  52. <dcgubun/>
  53. </send>
  54. <documenttitle>
  55. <title/>
  56. </documenttitle>
  57. </root>
  58. </instance>
  59. <script type="javascript" ev:event="xforms-model-construct-done">
  60. <![CDATA[
  61. submit("TRPAS00001");
  62. var vToday = new Date();
  63. var tmpYear = vToday.getYear();
  64. var tmpMonth = vToday.getMonth()+1;
  65. var tmpDate = vToday.getDate();
  66. if (tmpMonth < 10) { tmpMonth = "0"+tmpMonth; }
  67. if (tmpDate < 10) { tmpDate = "0"+tmpDate; }
  68. model.setValue("/root/main/search/fromdata", tmpYear+""+tmpMonth+""+tmpDate);
  69. model.setValue("/root/main/search/todata", tmpYear+""+tmpMonth+""+tmpDate);
  70. //Rexport에 출력날자를 보여주기위한 데이터 저장
  71. model.makeNode("/root/main/tmp/print/date");
  72. model.copyNode("/root/main/tmp/print/date", "/root/main/search/fromdata");
  73. model.setValue("/root/main/tmp/print/date", model.getValue("/root/main/search/fromdata"));
  74. input7.refresh();
  75. input1.refresh();
  76. datagrid1.explorerbar = "sort";
  77. ]]>
  78. </script>
  79. <bind id="bind1" ref="/root/main/sunsuamtlist/sunsuamtstats" calculate="now() + ."/>
  80. <bind id="bind2" ref="/root/main/sunsusumamtlist/sunsusumamtstats/cont" calculate="sum(/root/main/sunsuamtlist/sunsuamtstats/cont);"/>
  81. <bind id="bind3" ref="/root/main/sunsusumamtlist/sunsusumamtstats/acumteamt" calculate="sum(/root/main/sunsuamtlist/sunsuamtstats/acumteamt);"/>
  82. <bind id="bind4" ref="/root/main/sunsusumamtlist/sunsusumamtstats/todysunsu" calculate="sum(/root/main/sunsuamtlist/sunsuamtstats/todysunsu);"/>
  83. <bind id="bind5" ref="/root/main/sunsusumamtlist/sunsusumamtstats/retrnamt" calculate="sum(/root/main/sunsuamtlist/sunsuamtstats/retrnamt);"/>
  84. <bind id="bind6" ref="/root/main/sunsusumamtlist/sunsusumamtstats/restamt" calculate="sum(/root/main/sunsuamtlist/sunsuamtstats/restamt);"/>
  85. <submission id="TRPAS00001" mediatype="application/x-www-form-urlencoded" method="post" replace="instance" resultref="/root/main/tmpinfo/info/user"/>
  86. <submission id="TRPAS00111" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" replace="instance" resultref="/root/main/data1"/>
  87. </model>
  88. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  89. <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
  90. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  91. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  92. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  93. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  94. <script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
  95. <script type="javascript" src="../../../com/zipcodeweb/js/ZBP001.js"/>
  96. </xhtml:head>
  97. <xhtml:body pagewidth="1211" pageheight="784">
  98. <group id="group3" style="left:0px; top:0px; width:1211px; height:13px; ">
  99. <caption id="caption60" class="tit_1" style="left:0px; top:0px; width:183px; height:14px; font-family:돋움; vertical-align:middle; ">선수금현황</caption>
  100. </group>
  101. <group id="group2" style="left:4px; top:23px; width:1203px; height:35px; ">
  102. <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; "/>
  103. <caption id="caption2" class="search_name" style="left:15px; top:9px; width:198px; height:17px; ">기간 ~</caption>
  104. <line id="line2" class="line_4" style="x1:1132px; y1:7px; x2:1132px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
  105. <button id="btn_search" class="btn1_letter2" style="left:1139px; top:7px; width:56px; height:22px; ">
  106. <caption>조회</caption>
  107. <script type="javascript" ev:event="DOMActivate">
  108. <![CDATA[
  109. var fromdata = model.getValue("/root/main/search/fromdata");
  110. var todata = model.getValue("/root/main/search/todata");
  111. if(fromdata==""||fromdata==null){
  112. messageBox("시작일을 입력","E007");
  113. model.setFocus("input7");
  114. return false;
  115. }
  116. if(todata==""|| todata==null){
  117. messageBox("끝일을 입력","E007");
  118. model.setFocus("input1");
  119. return false;
  120. }
  121. if(fromdata > todata){
  122. messageBox("시작일이 끝일자보다 클수 ", "C001")
  123. return false;
  124. }else{
  125. model.setValue("/root/send/fromdata",model.getValue("/root/main/search/fromdata"));
  126. model.setValue("/root/send/todata",model.getValue("/root/main/search/todata"));
  127. model.setValue("/root/send/datagubun",model.getValue("/root/main/search/datagubun"));
  128. model.removeNodeset("/root/main/sunsuamtlist");
  129. submit("TRPAS00111");
  130. //로드값이 있을때 엑셀저장여부 버튼 생성여부
  131. var nodelist = bind1.nodeset;
  132. if(nodelist.length>0){
  133. line1.visible =true;
  134. button95.visible = true;
  135. }else{
  136. line1.visible =false;
  137. button95.visible = false;
  138. }
  139. copyNodesetType("/root/main/sunsuamtlist/sunsuamtstats","/root/main/sunsusumamtlist/sunsusumamtstats","after");
  140. datagrid1.rebuild();
  141. var sumtotal = instance1.selectNodes("/root/main/sunsuamtlist/sunsuamtstats").length + datagrid1.fixedRows - 1;
  142. datagrid1.mergeByFree(sumtotal,1,sumtotal,2);
  143. }
  144. ]]>
  145. </script>
  146. </button>
  147. <input id="input7" ref="/root/main/search/fromdata" class="input_default" navindex="1" inputtype="date" style="left:70px; top:8px; width:120px; height:19px; ">
  148. <script type="javascript" ev:event="onkeydown">
  149. <![CDATA[
  150. if( event.keyCode == 13 ) {
  151. var pCurTargetObj = event.ptarget.parent;
  152. if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
  153. event.keyCode = 9;
  154. pCurTargetObj.dispatch("onkeydown");
  155. }
  156. else {
  157. event.keyCode = 9;
  158. }
  159. }
  160. event.stopPropagation();
  161. ]]>
  162. </script>
  163. </input>
  164. <input id="input1" ref="/root/main/search/todata" class="input_default" navindex="2" inputtype="date" style="left:215px; top:8px; width:120px; height:19px; ">
  165. <script type="javascript" ev:event="onkeydown">
  166. <![CDATA[
  167. if( event.keyCode == 13 ) {
  168. var pCurTargetObj = event.ptarget.parent;
  169. if( pCurTargetObj.elementName == "xforms:select1" || pCurTargetObj.elementName == "xforms:select") {
  170. event.keyCode = 9;
  171. pCurTargetObj.dispatch("onkeydown");
  172. }
  173. else {
  174. event.keyCode = 9;
  175. }
  176. }
  177. event.stopPropagation();
  178. ]]>
  179. </script>
  180. </input>
  181. <select1 id="combo1" ref="/root/main/search/datagubun" appearance="minimal" style="left:350px; top:8px; width:100px; height:19px; ">
  182. <choices>
  183. <item>
  184. <label>전체</label>
  185. <value>1</value>
  186. </item>
  187. <item>
  188. <label>외래선수금</label>
  189. <value>2</value>
  190. </item>
  191. <item>
  192. <label>가정간호</label>
  193. <value>3</value>
  194. </item>
  195. </choices>
  196. </select1>
  197. <button id="button95" class="btn6_letter4" visibility="hidden" style="left:971px; top:7px; width:80px; height:22px; ">
  198. <caption>액셀저장</caption>
  199. <script type="javascript" ev:event="DOMActivate">
  200. <![CDATA[
  201. var vToday = new Date();
  202. var tmpYear = vToday.getYear();
  203. var tmpMonth = vToday.getMonth()+1;
  204. var tmpDate = vToday.getDate();
  205. model.setValue("/root/documenttitle/title",document.title);
  206. model.refresh();
  207. var subjectTitle = model.getValue("/root/documenttitle/title");
  208. var fileName = window.fileDialog("save", ",", false, "선수금현황"+tmpYear+tmpMonth+tmpDate, "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  209. if (fileName != "")
  210. {
  211. datagrid1.saveExcel(fileName,"선수금현황"+tmpYear+tmpMonth+tmpDate, true, true, "", "", true);
  212. }
  213. ]]>
  214. </script>
  215. </button>
  216. <line id="line1" class="line_4" visibility="hidden" style="x1:1058px; y1:7px; x2:1058px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
  217. <button id="btn_print" class="btn6_letter2" style="left:1066px; top:7px; width:56px; height:22px; ">
  218. <caption>출력</caption>
  219. <script type="javascript" ev:event="DOMActivate">
  220. <![CDATA[
  221. exeReportPreview("RPPAS00111", "XMLSTR", "","", "false","","","","","false");
  222. ]]>
  223. </script>
  224. </button>
  225. </group>
  226. <datagrid id="datagrid1" nodeset="/root/main/sunsuamtlist/sunsuamtstats" caption="진료과^명칭(외래선수금/가정간호)^건수^누적선수금^당일선수금^반환금액^잔액^비교" colsep="^" colwidth="180, 220, 150, 150, 150, 150, 150" rowheader="seq" rowsep="|" selected="true" style="left:4px; top:70px; width:1202px; height:675px; ">
  227. <col ref="deptengnm" style="text-align:center; "/>
  228. <col ref="sunsuname" style="text-align:center; "/>
  229. <col ref="cont" style="text-align:center; "/>
  230. <col ref="acumteamt" format="(-)#,###" style="text-align:right; "/>
  231. <col ref="todysunsu" format="(-)#,###" style="text-align:right; "/>
  232. <col ref="retrnamt" format="(-)#,###" style="text-align:right; "/>
  233. <col ref="restamt" format="(-)#,###" style="text-align:right; "/>
  234. </datagrid>
  235. </xhtml:body>
  236. </xhtml:html>