SMRWD11010_끝전기부금현황.xrw 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259
  1. <?xml version="1.0" encoding="EUC-KR"?>
  2. <?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/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. <cutdonatstate>
  11. <cutdonatstatelist/>
  12. </cutdonatstate>
  13. </main>
  14. <hidden>
  15. </hidden>
  16. <temp>
  17. </temp>
  18. <init>
  19. </init>
  20. <send>
  21. <req>
  22. <payinst/>
  23. <payfromym/>
  24. <paytoym/>
  25. <truncflag>02</truncflag>
  26. </req>
  27. </send>
  28. </root>
  29. </instance>
  30. <script type="javascript" ev:event="xforms-ready">
  31. <![CDATA[
  32. model.removeNodeset(grd_cutdonatstateetclist.nodeset);
  33. model.removeNodeset(grd_cutdonatstate02list.nodeset);
  34. model.refresh();
  35. misfMsterDetailSet(grd_cutdonatstate02list,null, "TRRWD11011" ,"Y");
  36. var curdate = getCurrentDate();
  37. var dutplceinstcd = getUserInfo("dutplceinstcd");
  38. model.setValue(ipt_payfromym.attribute("ref") , curdate.substr(0,6));
  39. model.setValue(ipt_paytoym.attribute("ref") , curdate.substr(0,6));
  40. model.setValue(cmb_payinst.attribute("ref") , dutplceinstcd);
  41. misfComboInstCdListMulti("cmb_payinst",getCurrentDate(),"","N");
  42. if (dutplceinstcd == "001" ) {
  43. cmb_payinst.disabled = false;
  44. }
  45. else {
  46. cmb_payinst.disabled = true;
  47. }
  48. model.refresh();
  49. ]]>
  50. </script>
  51. <!--<bind id="bind1" ref="/root/main/ngdtamt/ngdtamtlist/ngdtamt" calculate="../weekno * 20000 + ../holino * 40000"/>-->
  52. <submission id="TRRWD11011" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/req" resultref="/root/main/cutdonatstate"/>
  53. </model>
  54. <script type="javascript" src="../../../com/commonweb/js/common.js"/>
  55. <script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
  56. <script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
  57. <script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
  58. <script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
  59. <script type="javascript" src="../../../mis/tistrngeducplanmngtweb/js/SMRTS00600.js"/>
  60. <script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
  61. <script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
  62. <script type="javascript">
  63. <![CDATA[
  64. ]]>
  65. </script>
  66. </xhtml:head>
  67. <xhtml:body>
  68. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  69. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">끝전기부금현황</caption>
  70. </group>
  71. <group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  72. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:5px; width:1195px; height:36px; background-color:#fffbf2; border-color:#ffd799; "/>
  73. <caption id="cap_yy" class="search_name" style="left:235px; top:15px; width:94px; height:17px; ">통계년월 :</caption>
  74. <button id="button1" class="btn_sw" group="tab" selected="true" style="left:0px; top:50px; width:100px; height:22px; ">
  75. <caption>100원단위</caption>
  76. <script type="javascript" ev:event="onclick">
  77. <![CDATA[
  78. model.toggle("case1") ;
  79. model.removeNodeset(grd_cutdonatstate02list.nodeset);
  80. grd_cutdonatstate02list.refresh();
  81. model.setValue("/root/send/req/truncflag","02");
  82. ]]>
  83. </script>
  84. </button>
  85. <button id="button7" class="btn_sw" group="tab" selected="false" style="left:103px; top:50px; width:100px; height:22px; ">
  86. <caption>기타끝전</caption>
  87. <script type="javascript" ev:event="onclick">
  88. <![CDATA[
  89. model.toggle("case2") ;
  90. model.removeNodeset(grd_cutdonatstateetclist.nodeset);
  91. grd_cutdonatstateetclist.refresh();
  92. model.setValue("/root/send/req/truncflag","01");
  93. ]]>
  94. </script>
  95. </button>
  96. <switch id="switch1" style="left:0px; top:71px; width:1195px; height:600px; ">
  97. <case id="case1" selected="true" style="left:0px; top:0px; width:1193px; height:598px; ">
  98. <line id="line1" class="line_1" style="x1:0px; y1:0px; x2:1193px; y2:0px; "/>
  99. <datagrid id="grd_cutdonatstate02list" nodeset="/root/main/cutdonatstate/cutdonatstatelist" caption="구분^구분^구분^교원^교원^직군^직군^직군^직군^직군^직군^전공의^임시직^기타^계|구분^구분^구분^전임교원^비전임교원^행정직군^의료기술직군^간호직군^약무직군^일반기술직군^기타^전공의^임시직^기타^계" colsep="^" colwidth="55, 55, 55, 80, 80, 83, 83, 83, 83, 83, 83, 83, 83, 77, 86" dataheight="25" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:5px; width:1193px; height:590px; ">
  100. <col ref="field1" style="left:20px; top:43px; width:55px; height:23px; text-align:center; "/>
  101. <col ref="field2" style="text-align:center; "/>
  102. <col ref="field3" style="text-align:center; "/>
  103. <col ref="field4" format="#,###.###" style="left:185px; top:43px; width:80px; height:23px; text-align:right; "/>
  104. <col ref="field5" format="#,###.###" style="text-align:right; "/>
  105. <col ref="field6" format="#,###.###" style="text-align:right; "/>
  106. <col ref="field7" format="#,###.###" style="text-align:right; "/>
  107. <col ref="field8" format="#,###.###" style="text-align:right; "/>
  108. <col ref="field9" format="#,###.###" style="text-align:right; "/>
  109. <col ref="field10" format="#,###.###" style="text-align:right; "/>
  110. <col ref="field11" format="#,###.###" style="text-align:right; "/>
  111. <col ref="field12" format="#,###.###" style="text-align:right; "/>
  112. <col ref="field13" format="#,###.###" style="text-align:right; "/>
  113. <col ref="field14" format="#,###.###" style="text-align:right; "/>
  114. <col ref="field15" format="#,###.###" style="color:#0000ff; text-align:right; "/>
  115. </datagrid>
  116. </case>
  117. <case id="case2">
  118. <line id="line2" class="line_1" style="x1:0px; y1:0px; x2:1193px; y2:0px; "/>
  119. <datagrid id="grd_cutdonatstateetclist" nodeset="/root/main/cutdonatstate/cutdonatstatelist" caption="구분^구분^구분^교원^교원^직군^직군^직군^직군^직군^직군^전공의^임시직^기타^계|구분^구분^구분^전임교원^비전임교원^행정직군^의료기술직군^간호직군^약무직군^일반기술직군^기타^전공의^임시직^기타^계" colsep="^" colwidth="55, 55, 55, 80, 80, 80, 80, 83, 83, 84, 80, 85, 84, 82, 87" dataheight="25" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:0px; width:1193px; height:590px; ">
  120. <col ref="field1" style="text-align:center; "/>
  121. <col ref="field2" style="text-align:center; "/>
  122. <col ref="field3" style="text-align:center; "/>
  123. <col ref="field4" format="#,###.###" style="text-align:right; "/>
  124. <col ref="field5" format="#,###.###" style="text-align:right; "/>
  125. <col ref="field6" format="#,###.###" style="text-align:right; "/>
  126. <col ref="field7" format="#,###.###" style="text-align:right; "/>
  127. <col ref="field8" format="#,###.###" style="text-align:right; "/>
  128. <col ref="field9" format="#,###.###" style="text-align:right; "/>
  129. <col ref="field10" format="#,###.###" style="text-align:right; "/>
  130. <col ref="field11" format="#,###.###" style="text-align:right; "/>
  131. <col ref="field12" format="#,###.###" style="text-align:right; "/>
  132. <col ref="field13" format="#,###.###" style="text-align:right; "/>
  133. <col ref="field14" format="#,###.###" style="text-align:right; "/>
  134. <col ref="field15" format="#,###.###" style="color:#0000ff; text-align:right; "/>
  135. </datagrid>
  136. </case>
  137. </switch>
  138. <button id="btn_search" class="btn1_letter2" style="left:1130px; top:12px; width:56px; height:22px; text-align:left; ">
  139. <caption>조회</caption>
  140. <script type="javascript" ev:event="DOMActivate">
  141. <![CDATA[
  142. misfMsterDetailRetrieve();
  143. for(i=2; i<grd_cutdonatstate02list.rows; i++){
  144. grd_cutdonatstate02list.rowStyle(i, "all","color") = "#000000";
  145. grd_cutdonatstate02list.rowStyle(i, "all","font-weight") = "nomal";
  146. }
  147. for(i=2; i<grd_cutdonatstateetclist.rows; i++){
  148. grd_cutdonatstateetclist.rowStyle(i, "all","color") = "#000000";
  149. grd_cutdonatstateetclist.rowStyle(i, "all","font-weight") = "nomal";
  150. }
  151. grd_cutdonatstate02list.colStyle(15,"all","color") = "#0000ff";
  152. grd_cutdonatstateetclist.colStyle(15,"all","color") = "#0000ff";
  153. grd_cutdonatstate02list.mergeCol(1) = true;
  154. grd_cutdonatstate02list.mergeCol(2) = true;
  155. grd_cutdonatstate02list.mergeCol(3) = true;
  156. grd_cutdonatstate02list.mergeCol(4) = false;
  157. grd_cutdonatstate02list.mergeCol(5) = false;
  158. grd_cutdonatstate02list.mergeCol(6) = false;
  159. grd_cutdonatstate02list.mergeCol(7) = false;
  160. grd_cutdonatstate02list.mergeCol(8) = false;
  161. grd_cutdonatstate02list.mergeCol(9) = false;
  162. grd_cutdonatstate02list.mergeCol(10) = false;
  163. grd_cutdonatstate02list.mergeCol(11) = false;
  164. grd_cutdonatstate02list.mergeCol(12) = false;
  165. grd_cutdonatstate02list.mergeCol(13) = false;
  166. grd_cutdonatstate02list.mergeCol(14) = false;
  167. grd_cutdonatstate02list.mergeCol(15) = false;
  168. grd_cutdonatstate02list.mergeCells = "bycol";
  169. grd_cutdonatstate02list.merge();
  170. grd_cutdonatstateetclist.mergeCol(1) = true;
  171. grd_cutdonatstateetclist.mergeCol(2) = true;
  172. grd_cutdonatstateetclist.mergeCol(3) = true;
  173. grd_cutdonatstateetclist.mergeCol(4) = false;
  174. grd_cutdonatstateetclist.mergeCol(5) = false;
  175. grd_cutdonatstateetclist.mergeCol(6) = false;
  176. grd_cutdonatstateetclist.mergeCol(7) = false;
  177. grd_cutdonatstateetclist.mergeCol(8) = false;
  178. grd_cutdonatstateetclist.mergeCol(9) = false;
  179. grd_cutdonatstateetclist.mergeCol(10) = false;
  180. grd_cutdonatstateetclist.mergeCol(11) = false;
  181. grd_cutdonatstateetclist.mergeCol(12) = false;
  182. grd_cutdonatstateetclist.mergeCol(13) = false;
  183. grd_cutdonatstateetclist.mergeCol(14) = false;
  184. grd_cutdonatstateetclist.mergeCol(15) = false;
  185. grd_cutdonatstateetclist.mergeCells = "bycol";
  186. grd_cutdonatstateetclist.merge();
  187. grd_cutdonatstate02list.colStyle(15,"all","font-size") = "11pt";
  188. for(i=0; i<grd_cutdonatstate02list.rows; i++){
  189. if(model.getValue(grd_cutdonatstate02list.nodeset +"[" + (i) + "]/payym") == '999901'){
  190. grd_cutdonatstate02list.rowStyle(i+1, "all","color") = "#0000ff";
  191. }
  192. if(model.getValue(grd_cutdonatstate02list.nodeset +"[" + (i) + "]/payym") == '999902'){
  193. grd_cutdonatstate02list.rowStyle(i+1, "all","color") = "#ff0000";
  194. }
  195. if(model.getValue(grd_cutdonatstate02list.nodeset +"[" + (i) + "]/payym") == '999903'){
  196. grd_cutdonatstate02list.rowStyle(i+1, "all","font-weight") = "bold";
  197. grd_cutdonatstate02list.rowStyle(i+1, "all","color") = "#000000";
  198. }
  199. }
  200. grd_cutdonatstateetclist.colStyle(15,"all","font-size") = "11pt";
  201. for(i=0; i<grd_cutdonatstateetclist.rows; i++){
  202. if(model.getValue(grd_cutdonatstateetclist.nodeset +"[" + (i) + "]/payym") == '999901'){
  203. grd_cutdonatstateetclist.rowStyle(i+1, "all","color") = "#0000ff";
  204. }
  205. if(model.getValue(grd_cutdonatstateetclist.nodeset +"[" + (i) + "]/payym") == '999902'){
  206. grd_cutdonatstateetclist.rowStyle(i+1, "all","color") = "#ff0000";
  207. }
  208. if(model.getValue(grd_cutdonatstateetclist.nodeset +"[" + (i) + "]/payym") == '999903'){
  209. grd_cutdonatstateetclist.rowStyle(i+1, "all","font-weight") = "bold";
  210. grd_cutdonatstateetclist.rowStyle(i+1, "all","color") = "#000000";
  211. }
  212. }
  213. ]]>
  214. </script>
  215. </button>
  216. <line id="line82" class="line_4" style="x1:1115px; y1:10px; x2:1115px; y2:36px; border-color:#ffe4bb; border-left-style:solid; "/>
  217. <select1 id="cmb_payinst" ref="/root/send/req/payinst" class="combo_s_essential" disabled="false" appearance="minimal" style="left:75px; top:15px; width:120px; height:19px; ">
  218. <choices>
  219. <itemset>
  220. <label/>
  221. <value/>
  222. </itemset>
  223. </choices>
  224. </select1>
  225. <caption id="cap_instcd" class="search_name" style="left:5px; top:15px; width:94px; height:17px; ">기관 :</caption>
  226. <input id="ipt_payfromym" ref="/root/send/req/payfromym" inputtype="date" format="yyyy-mm" style="left:326px; top:15px; width:80px; height:19px; "/>
  227. <input id="ipt_paytoym" ref="/root/send/req/paytoym" inputtype="date" format="yyyy-mm" style="left:421px; top:15px; width:80px; height:19px; "/>
  228. <caption id="caption3" style="left:409px; top:16px; width:10px; height:20px; ">-</caption>
  229. <button id="btn_saveexcel" class="btn2_letter4" style="left:1125px; top:48px; width:64px; height:19px; ">
  230. <caption>엑셀저장</caption>
  231. <script type="javascript" ev:event="DOMActivate">
  232. <![CDATA[
  233. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  234. if (fileName != "") {
  235. if(switch1.selectedIndex == '0'){
  236. grd_cutdonatstate02list.saveExcel(fileName, "sheetname:sheet1;colhiddenextend:true;rowhiddenextend:false;exportfalsecols:0,0;col_1:value;");
  237. }else if(switch1.selectedIndex == '1'){
  238. grd_cutdonatstateetclist.saveExcel(fileName, "sheetname:sheet1;colhiddenextend:true;rowhiddenextend:false;exportfalsecols:0,0;col_1:value;");
  239. }
  240. }
  241. ]]>
  242. </script>
  243. </button>
  244. </group>
  245. <group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; "/>
  246. </xhtml:body>
  247. </xhtml:html>