SMRPA07900_건강보험개인별월별납부내역.xrw 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294
  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. <healthempr>
  11. <healthempllist>
  12. <notiym/>
  13. <instnm/>
  14. <emplnm/>
  15. <rrgstno/>
  16. <deptnm/>
  17. </healthempllist>
  18. </healthempr>
  19. <healthinsur>
  20. <healthinsulist>
  21. <month/>
  22. <reductresnnm/>
  23. <calcresnnm/>
  24. <remunrmmamt/>
  25. <calcamt/>
  26. <notiamt/>
  27. <notiymamt/>
  28. <yyendcalc/>
  29. <adjtamt/>
  30. <notiympayamt/>
  31. <rrgstno/>
  32. <notiym/>
  33. </healthinsulist>
  34. </healthinsur>
  35. <spclmentfact_txt/>
  36. </main>
  37. <send>
  38. <healthsend>
  39. <notiym/>
  40. <rrgstno1/>
  41. <rrgstno2/>
  42. <emplnm/>
  43. <instcd/>
  44. </healthsend>
  45. <healthempr>
  46. <notiym/>
  47. <rrgstno/>
  48. </healthempr>
  49. </send>
  50. <init>
  51. </init>
  52. </root>
  53. </instance>
  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="../../../mis/miscommonweb/js/MIS.js"/>
  58. <script type="javascript" src="../../../mis/insurancemngtweb/js/RPA001.js"/>
  59. <script type="javascript" ev:event="xforms-ready">
  60. <![CDATA[
  61. fInitialize();
  62. misfGridInit(grd_healthempllist);
  63. misfGridInit(grd_healthinsulist);
  64. misfMsterDetailSet(grd_healthempllist, null, "TRRPA07901" ,"N");
  65. // misfMsterDetailSet(grd_healthinsulist, grd_healthempllist, "TRRPA07902","Y");
  66. submit("TRRPA07902");
  67. // rpaComboInstBase(cmb_instcd,getUserInfo("dutplceinstcd"),"Y");
  68. // var instcd = getUserInfo("dutplceinstcd");
  69. // cmb_instcd.value=instcd;
  70. ]]>
  71. </script>
  72. <submission id="TRRPA07901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/healthsend" resultref="/root/main/healthempr"/>
  73. <submission id="TRRPA07902" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/healthempr" resultref="/root/main/healthinsur"/>
  74. </model>
  75. <script type="javascript">
  76. <![CDATA[
  77. // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
  78. function fInitialize() {
  79. model.removeNodeset("/root/main/healthempr/healthempllist");
  80. model.removeNodeset("/root/main/healthinsur/healthinsulist");
  81. model.resetInstanceNode("/root/send");
  82. model.refresh();
  83. var curDate = getCurrentDate().toDate();
  84. model.setValue("/root/send/healthsend/notiym", curDate.getDateFormat('YYYY'));
  85. }
  86. function fTotalSum() {
  87. grd_healthinsulist.addRow();
  88. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mm")) = "합계";
  89. var calcamt = 0;
  90. var notiamt = 0;
  91. var yyendcalc = 0;
  92. var adjtamt = 0;
  93. var notiympayamt = 0;
  94. var mtrtcalcamt = 0;
  95. var mtrtnotiamt = 0;
  96. var mtrtyyendcalc = 0;
  97. var mtrtadjtamt = 0;
  98. var mtrtlndchrgamt = 0;
  99. var totalamt = 0;
  100. for( var idx = grd_healthinsulist.fixedRows; idx < grd_healthinsulist.rows - 1; idx++ ) { // 마지막 row는 합계이므로 -1해서 제외시킨다.
  101. calcamt = parseInt(calcamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("calcamt")));
  102. notiamt = parseInt(notiamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("notiamt")));
  103. yyendcalc = parseInt(yyendcalc) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("yyendcalc")));
  104. adjtamt = parseInt(adjtamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("adjtamt")));
  105. notiympayamt = parseInt(notiympayamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("notiympayamt")));
  106. mtrtcalcamt = parseInt(mtrtcalcamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtcalcamt")));
  107. mtrtnotiamt = parseInt(mtrtnotiamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtnotiamt")));
  108. mtrtyyendcalc = parseInt(mtrtyyendcalc) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtyyendcalc")));
  109. mtrtadjtamt = parseInt(mtrtadjtamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtadjtamt")));
  110. mtrtlndchrgamt = parseInt(mtrtlndchrgamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtlndchrgamt")));
  111. totalamt = parseInt(totalamt) + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("totalamt")));
  112. }
  113. grd_healthinsulist.rowStyle(grd_healthinsulist.row,"data","background-color") = "#CCFFCC";
  114. grd_healthinsulist.rowStyle(grd_healthinsulist.row,"data","font-weight") = "bold";
  115. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("calcresnnm")) = "건강보험료"; // 건강정산사유
  116. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("calcamt")) = calcamt; // 건강정산금액
  117. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("notiamt")) = notiamt; // 건강고지금액
  118. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("yyendcalc")) = yyendcalc; // 건강연말정산
  119. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("adjtamt")) = adjtamt; // 건강조정금액
  120. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("notiympayamt")) = notiympayamt; // 건강당월납부액
  121. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtcalcresn")) = "장기요양보험료"; // 요양정산사유
  122. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtcalcamt")) = mtrtcalcamt; // 요양정산금액
  123. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtnotiamt")) = mtrtnotiamt; // 요양고지금액
  124. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtyyendcalc")) = mtrtyyendcalc; // 요양연말정산
  125. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtadjtamt")) = mtrtadjtamt; // 요양조정금액
  126. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtlndchrgamt")) = mtrtlndchrgamt; // 요양당월납부액
  127. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("totalamt")) = totalamt; // 당월납부액계
  128. grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("spclmentfact"))
  129. = grd_healthinsulist.valueMatrix(grd_healthinsulist.row-1, grd_healthinsulist.colRef("spclmentfact")) ; // 특이사항
  130. grd_healthinsulist.dispatch("onrowchanged");
  131. }
  132. ]]>
  133. </script>
  134. </xhtml:head>
  135. <xhtml:body style="margin-left:8; margin-right:8; ">
  136. <group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
  137. <caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">개인별 월별 건강보험료 납부 내역</caption>
  138. </group>
  139. <group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
  140. <shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
  141. <caption id="cap_notiym" class="search_name" style="left:25px; top:18px; width:86px; height:17px; ">기준년도:</caption>
  142. <button id="btn_search" class="btn1_letter2" style="left:1125px; top:16px; width:56px; height:22px; ">
  143. <caption>조회</caption>
  144. <script type="javascript" ev:event="DOMActivate">
  145. <![CDATA[
  146. misfGridInit(grd_healthempllist);
  147. misfGridInit(grd_healthinsulist);
  148. if(!isRequiredControls("ipt_notiym"))return;
  149. if( ipt_chldrnresdnrgst1.value != '' || ipt_chldrnresdnrgst2.value != '' || ipt_emplnm.value != '' ) {
  150. misfMsterDetailRetrieve();
  151. model.refresh();
  152. }
  153. ]]>
  154. </script>
  155. </button>
  156. <line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:38px; "/>
  157. <input id="ipt_notiym" ref="/root/send/healthsend/notiym" class="input_s_essential" inputtype="date" format="yyyy" style="left:110px; top:18px; width:80px; height:19px; "/>
  158. <line id="line207" class="line_1" style="x1:0; y1:69; x2:395; y2:69px; "/>
  159. <caption id="caption9" class="tit_2" style="left:10px; top:55px; width:219px; height:13px; ">사원 리스트</caption>
  160. <caption id="caption32" style="left:420px; top:18px; width:16px; height:17px; font-weight:bold; text-align:center; vertical-align:bottom; ">~</caption>
  161. <caption id="caption34" class="search_name" style="left:257px; top:18px; width:99px; height:17px; ">주민번호:</caption>
  162. <input id="ipt_emplnm" ref="/root/send/healthsend/emplnm" class="input_search" imemode="hangul" style="left:632px; top:18px; width:100px; height:19px; ">
  163. <script type="javascript" ev:event="onkeyup">
  164. <![CDATA[
  165. inputEnterKey("btn_search", "DOMActivate");
  166. ]]>
  167. </script>
  168. </input>
  169. <input id="ipt_chldrnresdnrgst1" ref="/root/send/healthsend/rrgstno1" class="input_search" maxlength="6" style="left:338px; top:18px; width:80px; height:19px; ">
  170. <script type="javascript" ev:event="onkeypress">
  171. <![CDATA[
  172. inputEnterKey("btn_search", "DOMActivate");
  173. ]]>
  174. </script>
  175. <script type="javascript" ev:event="onkeyup">
  176. <![CDATA[
  177. inputEnterKey("btn_search", "DOMActivate");
  178. ]]>
  179. </script>
  180. </input>
  181. <input id="ipt_chldrnresdnrgst2" ref="/root/send/healthsend/rrgstno2" class="input_search" maxlength="8" style="left:438px; top:18px; width:80px; height:19px; ">
  182. <script type="javascript" ev:event="onkeypress">
  183. <![CDATA[
  184. inputEnterKey("btn_search", "DOMActivate");
  185. ]]>
  186. </script>
  187. <script type="javascript" ev:event="onkeyup">
  188. <![CDATA[
  189. inputEnterKey("btn_search", "DOMActivate");
  190. ]]>
  191. </script>
  192. </input>
  193. <caption id="caption37" class="search_name" style="left:572px; top:18px; width:60px; height:17px; ">성명:</caption>
  194. <button id="btn_exceldetail" class="btn2_letter4" style="left:1127px; top:238px; width:64px; height:19px; ">
  195. <caption>엑셀저장</caption>
  196. <script type="javascript" ev:event="DOMActivate">
  197. <![CDATA[
  198. var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
  199. if (fileName != "")
  200. {
  201. grd_healthinsulist.saveExcel(fileName, "sheetname:savetype", true, true, "", "");
  202. }
  203. ]]>
  204. </script>
  205. </button>
  206. <datagrid id="grd_healthempllist" nodeset="/root/main/healthempr/healthempllist" caption="고지년월^기관^성명^주민등록번호^취득일^상실일" colwidth="11, 125, 65, 100, 80, 80" dataheight="25" ellipsis="true" extendlastcol="scroll" frozencols="4" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:74px; width:500px; height:161px; text-align:center; ">
  207. <col ref="notiym" visibility="hidden" format="yyyy-mm"/>
  208. <col ref="instnm" style="text-align:center; "/>
  209. <col ref="emplnm" type="input" style="text-align:center; "/>
  210. <col ref="rrgstno" type="input" format="999999-9999999" style="text-align:center; "/>
  211. <col ref="acqtdd" format="yyyy-mm-dd"/>
  212. <col ref="lossdd" format="yyyy-mm-dd"/>
  213. <script type="javascript" ev:event="onrowchanged">
  214. <![CDATA[
  215. grd_healthinsulist.rebuildStyle();
  216. misfMsterDetailRetrieve();
  217. model.setValue("/root/send/healthempr/notiym",ipt_notiym.value);
  218. model.setValue("/root/send/healthempr/rrgstno",grd_healthempllist.valueMatrix(grd_healthempllist.row, grd_healthempllist.colRef("rrgstno")));
  219. submit("TRRPA07902");
  220. model.refresh();
  221. fTotalSum();
  222. ]]>
  223. </script>
  224. </datagrid>
  225. <caption id="caption1" class="tit_2" style="left:10px; top:246px; width:219px; height:13px; ">월별 건강보험료 납부 내역</caption>
  226. <line id="line1" class="line_1" style="x1:0px; y1:69px; x2:500px; y2:69px; "/>
  227. <line id="line2" class="line_1" style="x1:0px; y1:260px; x2:1192px; y2:260px; "/>
  228. <multilinegrid id="grd_healthinsulist" nodeset="/root/main/healthinsur/healthinsulist" caption="고지월^주민번호^월^청구기관^감면사유^직종코드^보수월액^건강산출보험료^건강 정산사유^건강 정산금액^건강 고지금액^건강 연말정산^건강 조정금액^건강 당월납부액^당월납부액계^특기사항|^성명^월^청구기관^감면사유^직종코드^보수월액^요양산출보험료^요양 정산사유^요양 정산금액^요양 고지금액^요양 연말정산^요양 조정금액^요양 당월납부액^당월납부액계^특기사항" colsep="^" colwidth="50, 100, 40, 120, 80, 80, 80, 95, 105, 95, 95, 95, 96, 95, 85, 100" extendlastcol="scroll" rowheader="seq" rowsep="|" mergecellsfixedrows="bycolrec" style="left:0px; top:265px; width:1192px; height:460px; ">
  229. <row>
  230. <col ref="notiym" rowspan="2" visibility="hidden"/>
  231. <col ref="rrgstno" visibility="hidden"/>
  232. <col ref="mm" rowspan="2" style="text-align:center; "/>
  233. <col ref="instnm" rowspan="2"/>
  234. <col ref="reductresnnm" rowspan="2"/>
  235. <col ref="jobkindcd" rowspan="2" style="text-align:center; "/>
  236. <col ref="remunrmmamt" rowspan="2" format="#,###" style="text-align:right; "/>
  237. <col ref="calcinsuamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  238. <col ref="calcresnnm" style="text-align:center; "/>
  239. <col ref="calcamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  240. <col ref="notiamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  241. <col ref="yyendcalc" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  242. <col ref="adjtamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  243. <col ref="notiympayamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  244. <col ref="totalamt" rowspan="2" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  245. <col ref="spclmentfact" rowspan="2" visibility="hidden"/>
  246. </row>
  247. <row>
  248. <col ref="emplnm" visibility="hidden"/>
  249. <col ref="mtrtcalcinsuamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  250. <col ref="mtrtcalcresn" style="text-align:center; "/>
  251. <col ref="mtrtcalcamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  252. <col ref="mtrtnotiamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  253. <col ref="mtrtyyendcalc" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  254. <col ref="mtrtadjtamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  255. <col ref="mtrtlndchrgamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
  256. </row>
  257. <script type="javascript" ev:event="onrowchanged">
  258. <![CDATA[
  259. model.setValue("/root/main/spclmentfact_txt",grd_healthinsulist.valueMatrix(grd_healthinsulist.row,grd_healthinsulist.colRef("spclmentfact")));
  260. model.refresh();
  261. ]]>
  262. </script>
  263. </multilinegrid>
  264. <line id="line3" class="line_1" style="x1:506px; y1:70px; x2:1191px; y2:71px; "/>
  265. <caption id="caption2" class="tit_2" style="left:510px; top:55px; width:100px; height:14px; ">특이사항</caption>
  266. <textarea id="tar_spclmentfact" ref="/root/main/spclmentfact_txt" editable="false" style="left:505px; top:74px; width:687px; height:161px; "/>
  267. </group>
  268. <group id="grp_btn" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
  269. <button id="btn_init" class="btn4_letter3" style="left:1122px; top:3px; width:68px; height:22px; ">
  270. <caption>초기화</caption>
  271. <script type="javascript" ev:event="DOMActivate">
  272. <![CDATA[
  273. fInitialize();
  274. ]]>
  275. </script>
  276. </button>
  277. <line id="line9" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
  278. </group>
  279. </xhtml:body>
  280. </xhtml:html>