SMRAD00340_약품구매지급내역집계표.xrw 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295
  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>약품구매지급내역</xhtml:title>
  6. <model id="model1">
  7. <instance id="instance1">
  8. <root xmlns="">
  9. <main>
  10. <deptacntpaymentsheet/>
  11. </main>
  12. <send>
  13. <condition>
  14. <instcd/>
  15. <acntcd4/>
  16. <acntcd/>
  17. <balamtflag>Y</balamtflag>
  18. <slipdeptcd/>
  19. <slipdepthngnm/>
  20. <ymdd/>
  21. </condition>
  22. <data>
  23. <instcd/>
  24. <mngtcd/>
  25. </data>
  26. <retrparams>
  27. <ymdd/>
  28. </retrparams>
  29. </send>
  30. <init>
  31. <code>
  32. <code>
  33. <acnt4/>
  34. </code>
  35. </code>
  36. </init>
  37. <temp/>
  38. <hidden>
  39. <deptacntpaymentsheet/>
  40. </hidden>
  41. </root>
  42. </instance>
  43. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  44. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  45. <script type="javascript" src="../../../com/commonweb/js/numericHelper.js"/>
  46. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  47. <script type="javascript" src="../../../com/commonweb/js/utilHelper.js"/>
  48. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  49. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  50. <script type="javascript" src="../../../mis/miscommonweb/js/RAM001.js"/>
  51. <script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
  52. <script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
  53. <script type="javascript" ev:event="xforms-ready">
  54. <![CDATA[
  55. fInitialize();
  56. ]]>
  57. </script>
  58. <script type="javascript">
  59. <![CDATA[
  60. function fInitialize()
  61. {
  62. model.removenode(grd_deptacntpaymentsheet.nodeset);
  63. grd_deptacntpaymentsheet.refresh();
  64. var instcd = getUserInfo("dutplceinstcd");
  65. model.setValue("/root/send/condition/instcd", instcd);
  66. model.setValue(ipt_ymdd.attribute("ref"), getCurrentDate().toString());
  67. model.setValue("/root/send/data/instcd", instcd);
  68. model.setValue("/root/send/data/mngtcd", "%");
  69. submit("TRRAZ00001");
  70. model.makeNode("/root/init/code/code/acnt4");
  71. model.makeValue("/root/init/code/code/acnt4[1]/cdnm", "전 체");
  72. model.makeValue("/root/init/code/code/acnt4[1]/cdid", "");
  73. // model.makeValue("/root/init/code/code/acnt4[1]/cdgbn", "R0010");
  74. var seq = 1;
  75. for (i=1; i<= instance1.selectNodes("root/init/code/code/codelist").length; i++)
  76. {
  77. cdgbn = model.getValue("/root/init/code/code/codelist[" + i + "]/cdgbn");
  78. seq++;
  79. //alert(i + " " + cdgbn)
  80. if (cdgbn == "R0010")
  81. {
  82. //alert(i + " " + cdgbn + " " + seq)
  83. model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
  84. model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdid", model.getValue("/root/init/code/code/codelist[" + i + "]/cdid"));
  85. model.makeNode( "/root/init/code/code/acnt4[" + seq + "]");
  86. model.makeValue( "/root/init/code/code/acnt4[" + seq + "]/cdnm", model.getValue("/root/init/code/code/codelist[" + i + "]/cdnm"));
  87. }
  88. }
  89. cmb_supacntcd4.dispatch("xforms-value-changed");
  90. cmb_supacntcd4.select(0);
  91. }
  92. function fCheckAuth()
  93. {
  94. btn_search.disabled = !checkAuth("R");
  95. }
  96. //========================================================================================
  97. // 부서코드 조회
  98. //========================================================================================
  99. function fOpenPopupDeptHelp(pControl, pInstance)
  100. {
  101. misfOpenPopUpList("02", pControl, "", pInstance);
  102. model.refresh();
  103. }
  104. ]]>
  105. </script>
  106. <submission id="TRRAD00341" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/balancesheet"/>
  107. <submission id="TRRAZ00001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/data" resultref="/root/init/code/codelist"/>
  108. </model>
  109. </xhtml:head>
  110. <xhtml:body guideline="1,1194;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
  111. <group id="grp_1" style="left:0px; top:0px; width:1195px; height:13px; ">
  112. <caption id="cap_title" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">약품구매지급내역</caption>
  113. <caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
  114. </group>
  115. <group id="grp_3" scroll="auto" style="left:0px; top:40; width:1195px; height:744px; ">
  116. <group id="grp_sea" style="left:0px; top:10px; width:1195px; height:60px; vertical-align:top; ">
  117. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
  118. <button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:8px; width:56px; height:22px; text-align:left; ">
  119. <caption>조회</caption>
  120. <script type="javascript" ev:event="DOMActivate">
  121. <![CDATA[
  122. radfRenewalBebtClos(getUserInfo("dutplceinstcd"), '', model.getValue(ipt_ymdd.attribute("ref")));
  123. model.removeNodeset(grd_deptacntpaymentsheet.nodeset);
  124. grd_deptacntpaymentsheet.refresh();
  125. submit("TRRAD00341");
  126. grd_deptacntpaymentsheet.subtotalposition = "below";
  127. grd_deptacntpaymentsheet.multitotals = true;
  128. grd_deptacntpaymentsheet.subtotal("sum", 1, 7, "format:#,###; roundmode:round; roundpostion:2", "background-color:#00ffff; color:#000000; ", 4, "합 계", true);
  129. grd_deptacntpaymentsheet.subtotal("sum", 1, 8, "format:#,###; roundmode:round; roundpostion:2", "background-color:#00ffff; color:#000000; ", 4, "합 계", true);
  130. grd_deptacntpaymentsheet.subtotal("sum", 1, 9, "format:#,###; roundmode:round; roundpostion:2", "background-color:#00ffff; color:#000000; ", 4, "합 계", true);
  131. grd_deptacntpaymentsheet.subtotal("sum", 1, 10, "format:#,###; roundmode:round; roundpostion:2", "background-color:#00ffff; color:#000000; ", 4, "합 계", true);
  132. grd_deptacntpaymentsheet.refresh();
  133. ]]>
  134. </script>
  135. </button>
  136. <line id="lin_5" class="line_4" style="x1:1107px; y1:8px; x2:1107px; y2:30px; border-color:#ffe4bb; border-left-style:solid; "/>
  137. <button id="btn_slipdepthelp" class="icon_search" navindex="-1" style="left:614px; top:9px; width:16px; height:16px; ">
  138. <caption/>
  139. <script type="javascript" ev:event="DOMActivate">
  140. <![CDATA[
  141. fOpenPopupDeptHelp(ipt_slipdeptcd, "slipdeptcd,slipdepthngnm"); //전체부서
  142. ]]>
  143. </script>
  144. </button>
  145. <select1 id="cmb_acntcd" ref="/root/send/condition/acntcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:270px; top:9px; width:160px; height:19px; ">
  146. <choices>
  147. <itemset>
  148. <label/>
  149. <value/>
  150. </itemset>
  151. </choices>
  152. </select1>
  153. <caption id="caption1" class="search_name" style="left:790px; top:10px; width:90px; height:17px; ">일 자 :</caption>
  154. <input id="ipt_slipdeptcd" ref="/root/send/condition/slipdeptcd" class="input_essential" navindex="-1" maxlength="11" style="left:535px; top:8px; width:74px; height:19px; ">
  155. <script type="javascript" ev:event="xforms-value-changed">
  156. <![CDATA[
  157. racfDeptValidCheck("slipdeptcd,slipdepthngnm"); // 전체부서
  158. ]]>
  159. </script>
  160. <script type="javascript" ev:event="onkeypress">
  161. <![CDATA[
  162. if(event.keyCode == 13)
  163. {
  164. model.setFocus("btn_search");
  165. }
  166. ]]>
  167. </script>
  168. </input>
  169. <caption id="caption12" class="search_name" style="left:445px; top:10px; width:107px; height:17px; ">발의부서 :</caption>
  170. <caption id="caption3" class="search_name" style="left:790px; top:35px; width:90px; height:17px; ">잔액없음 :</caption>
  171. <select1 id="cmb_supacntcd4" ref="/root/send/condition/acntcd4" class="combo_s_essential" navindex="1" appearance="minimal" style="left:156px; top:9px; width:109px; height:19px; ">
  172. <choices>
  173. <itemset nodeset="/root/init/code/code/acnt4">
  174. <label ref="cdnm"/>
  175. <value ref="cdid"/>
  176. </itemset>
  177. </choices>
  178. <script type="javascript" ev:event="xforms-value-changed">
  179. <![CDATA[
  180. racfGetSupAcntPrAcntListCombo(model.getValue("/root/send/condition/acntcd4"), cmb_acntcd, "Y");
  181. model.setValue(cmb_acntcd.choices.itemset.attribute("nodeset") + "[1]/acntnm", "전 체");
  182. cmb_acntcd.refresh();
  183. cmb_acntcd.select(0);
  184. ]]>
  185. </script>
  186. </select1>
  187. <caption id="caption37" class="search_name" style="left:55px; top:10px; width:100px; height:17px; ">계정과목 :</caption>
  188. <select1 id="rdo_balamtflag" ref="/root/send/condition/balamtflag" disabled="false" navindex="-1" appearance="full" cellspacing="75" cols="2" style="left:885px; top:35px; width:163px; height:17px; border-style:none; ">
  189. <choices>
  190. <item>
  191. <label>포함</label>
  192. <value>Y</value>
  193. </item>
  194. <item>
  195. <label>제외</label>
  196. <value>N</value>
  197. </item>
  198. </choices>
  199. </select1>
  200. <input id="ipt_slipdepthngnm" ref="/root/send/condition/slipdepthngnm" class="input_essential" style="left:634px; top:8px; width:135px; height:19px; ">
  201. <script type="javascript" ev:event="xforms-value-changed">
  202. <![CDATA[
  203. racfDeptValidCheck("slipdeptcd,slipdepthngnm"); // 전체부서
  204. ]]>
  205. </script>
  206. <script type="javascript" ev:event="onkeypress">
  207. <![CDATA[
  208. if(event.keyCode == 13)
  209. {
  210. model.setFocus("btn_search");
  211. }
  212. ]]>
  213. </script>
  214. </input>
  215. <input id="ipt_ymdd" ref="/root/send/condition/ymdd" class="input_s_essential" inputtype="date" style="left:885px; top:10px; width:125px; height:19px; ">
  216. <script type="javascript" ev:event="xforms-value-changed">
  217. <![CDATA[
  218. ]]>
  219. </script>
  220. </input>
  221. </group>
  222. <datagrid id="grd_deptacntpaymentsheet" nodeset="/root/main/deptacntpaymentsheet" backcoloralternate="#ffffff" caption="FLAG^기관코드^부서코드^발의부서명^계정코드^계정명^청구액^전월결재액^결재액^잔액" colsep="^" colwidth="0, 0, 0, 280, 0, 190, 150, 150, 150, 150" mergecells="byrestriccol" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="16" rowsep="|" style="left:1px; top:95px; width:1193px; height:645px; font-size:10pt; ">
  223. <col ref="flag" visibility="hidden"/>
  224. <col ref="instcd" visibility="hidden"/>
  225. <col ref="slipdeptcd" visibility="hidden"/>
  226. <col ref="slipdeptnm"/>
  227. <col ref="acntcd" visibility="hidden"/>
  228. <col ref="acntnm"/>
  229. <col ref="expectpayamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  230. <col ref="prevpayamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  231. <col ref="payamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  232. <col ref="balamt" format="(-)#,###" style="text-align:right; padding-right:1; "/>
  233. </datagrid>
  234. <caption id="caption2" class="tit_2" style="left:5px; top:76px; width:215px; height:13px; ">약품구매지급내역</caption>
  235. </group>
  236. <group id="grp_4" scroll="auto" style="left:0px; top:13; width:1195px; height:27px; ">
  237. <line id="lin_2" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
  238. <button id="btn_11" class="btn6_letter2" visibility="visible" style="left:0px; top:3px; width:56px; height:22px; ">
  239. <caption>출력</caption>
  240. <script type="javascript" ev:event="DOMActivate">
  241. <![CDATA[
  242. radfRenewalBebtClos(getUserInfo("dutplceinstcd"), '', model.getValue(ipt_ymdd.attribute("ref")));
  243. model.removeNodeset(grd_deptacntpaymentsheet.nodeset);
  244. grd_deptacntpaymentsheet.refresh();
  245. submit("TRRAD00341");
  246. if(grd_deptacntpaymentsheet.rows == grd_deptacntpaymentsheet.fixedRows)
  247. {
  248. messageBox("출력할 내용이" ,"I004");
  249. return;
  250. }
  251. else
  252. {
  253. model.setValue("/root/send/retrparams/ymdd", ipt_ymdd.value);
  254. exeReportPreview("RPRAD00340", "XMLSTR", "/root/send/retrparams");
  255. btn_search.dispatch("DOMActivate");
  256. }
  257. ]]>
  258. </script>
  259. </button>
  260. </group>
  261. <button id="btn_9" class="btn2_letter4" style="left:1130px; top:113px; width:64px; height:19px; text-align:left; ">
  262. <caption>엑셀출력</caption>
  263. <script type="javascript" ev:event="DOMActivate">
  264. <![CDATA[
  265. radfSaveExcel(grd_deptacntpaymentsheet);
  266. ]]>
  267. </script>
  268. </button>
  269. </xhtml:body>
  270. </xhtml:html>