YNU_JEUS/app_home/himed/webapps/mis/insurancemngtweb/xrw/SMRPA08500_개인별납부내역조회.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<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">
	<xhtml:head>
		<xhtml:title>개인별 납부내역</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<healthempr>
							<healthempllist>
								<notiym/>
								<instnm/>
								<emplnm/>
								<rrgstno/>
								<deptnm/>
							</healthempllist>
						</healthempr>
						<healthinsur>
							<healthinsulist>
								<month/>
								<reductresnnm/>
								<calcresnnm/>
								<remunrmmamt/>
								<calcamt/>
								<notiamt/>
								<notiymamt/>
								<yyendcalc/>
								<adjtamt/>
								<notiympayamt/>
								<rrgstno/>
								<notiym/>
							</healthinsulist>
						</healthinsur>
						<spclmentfact_txt/>
					</main>
					<send>
						<healthsend>
							<notiym/>
							<rrgstno1/>
							<rrgstno2/>
							<emplnm/>
							<instcd/>
							<emplno/>
						</healthsend>
						<healthempr>
							<notiym/>
							<rrgstno/>
						</healthempr>
					</send>
					<init>
					</init>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/insurancemngtweb/js/RPA001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
					
					misfGridInit(grd_healthempllist);
					misfGridInit(grd_healthinsulist);
					misfMsterDetailSet(grd_healthempllist, null, "TRRPA08501" ,"N"); 
					submit("TRRPA07902");
				]]>
			</script>
			<submission id="TRRPA08501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/healthsend" resultref="/root/main/healthempr"/>
			<submission id="TRRPA07902" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/healthempr" resultref="/root/main/healthinsur"/>
		</model>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
					model.removeNodeset("/root/main/healthempr/healthempllist");
					model.removeNodeset("/root/main/healthinsur/healthinsulist");
					model.resetInstanceNode("/root/send");
					model.refresh();
					var curDate = getCurrentDate().toDate();
					model.setValue("/root/send/healthsend/notiym", curDate.getDateFormat('YYYY'));
					
					model.setValue("/root/send/healthsend/emplnm", getUserInfo("usernm"));
					model.setValue("/root/send/healthsend/emplno", getUserInfo("userid"));
					model.refresh();
				}
				
				function fTotalSum() {
					grd_healthinsulist.addRow();
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mm")) = "합계";
					
					var calcamt = 0;
					var notiamt = 0;
					var yyendcalc = 0;
					var adjtamt = 0;
					var notiympayamt = 0;
					var mtrtcalcamt = 0;
					var mtrtnotiamt = 0;
					var mtrtyyendcalc = 0;
					var mtrtadjtamt = 0;
					var mtrtlndchrgamt = 0;
					var totalamt = 0;
					
					for( var idx = grd_healthinsulist.fixedRows; idx < grd_healthinsulist.rows - 1; idx++ ) {	// 마지막 row는 합계이므로 -1해서 제외시킨다.
						calcamt 		   = parseInt(calcamt) 			+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("calcamt")));
						notiamt 		   = parseInt(notiamt) 			+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("notiamt")));
						yyendcalc 	   = parseInt(yyendcalc) 		+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("yyendcalc")));
						adjtamt 		   = parseInt(adjtamt) 			+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("adjtamt")));
						notiympayamt   = parseInt(notiympayamt)	+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("notiympayamt")));
						mtrtcalcamt 	   = parseInt(mtrtcalcamt) 		+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtcalcamt")));
						mtrtnotiamt 	   = parseInt(mtrtnotiamt) 		+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtnotiamt")));
						mtrtyyendcalc   = parseInt(mtrtyyendcalc)  + parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtyyendcalc")));
						mtrtadjtamt 	   = parseInt(mtrtadjtamt) 		+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtadjtamt")));
						mtrtlndchrgamt = parseInt(mtrtlndchrgamt) 	+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("mtrtlndchrgamt")));
						totalamt 		   = parseInt(totalamt) 			+ parseInt(grd_healthinsulist.valueMatrix(idx,grd_healthinsulist.colRef("totalamt")));
						
					}         
					grd_healthinsulist.rowStyle(grd_healthinsulist.row,"data","background-color") = "#CCFFCC";
					grd_healthinsulist.rowStyle(grd_healthinsulist.row,"data","font-weight") = "bold";
					
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("calcresnnm")) 		= "건강보험료";			// 건강정산사유    
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("calcamt")) 	  		= calcamt;					// 건강정산금액      
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("notiamt"))	  		= notiamt;					// 건강고지금액      
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("yyendcalc"))		= yyendcalc;				// 건강연말정산      
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("adjtamt"))	  		= adjtamt;					// 건강조정금액      
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("notiympayamt")) 	= notiympayamt;		// 건강당월납부액    
					
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtcalcresn"))		= "장기요양보험료";	// 요양정산사유
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtcalcamt")) 	 	= mtrtcalcamt;			// 요양정산금액  
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtnotiamt"))	 	= mtrtnotiamt;			// 요양고지금액  
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtyyendcalc"))	= mtrtyyendcalc;		// 요양연말정산  
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtadjtamt"))	 	= mtrtadjtamt;			// 요양조정금액  
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("mtrtlndchrgamt")) = mtrtlndchrgamt;		// 요양당월납부액
					
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("totalamt")) 			= totalamt;					// 당월납부액계     
					
					grd_healthinsulist.valueMatrix(grd_healthinsulist.row, grd_healthinsulist.colRef("spclmentfact")) 	
						= grd_healthinsulist.valueMatrix(grd_healthinsulist.row-1, grd_healthinsulist.colRef("spclmentfact")) 	;						// 특이사항   
					grd_healthinsulist.dispatch("onrowchanged");
				}
 			]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-right:8; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">개인별 월별 건강보험료 납부 내역</caption>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<caption id="cap_notiym" class="search_name" style="left:35px; top:18px; width:86px; height:17px; ">기준년도:</caption>
			<button id="btn_search" class="btn1_letter2" style="left:1125px; top:16px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridInit(grd_healthempllist);
						misfGridInit(grd_healthinsulist);
						if(!isRequiredControls("ipt_notiym")) return;	
						
						misfMsterDetailRetrieve(); 
						model.refresh();
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:38px; "/>
			<input id="ipt_notiym" ref="/root/send/healthsend/notiym" class="input_s_essential" inputtype="date" format="yyyy" style="left:120px; top:18px; width:80px; height:19px; text-align:center; "/>
			<line id="line207" class="line_1" style="x1:0; y1:69; x2:395; y2:69px; "/>
			<caption id="caption9" class="tit_2" style="left:10px; top:55px; width:219px; height:13px; ">사원 리스트</caption>
			<input id="ipt_emplnm" ref="/root/send/healthsend/emplnm" class="input_search" disabled="true" imemode="hangul" style="left:360px; top:18px; width:100px; height:19px; text-align:center; ">
				<script type="javascript" ev:event="onkeyup">
					<![CDATA[
						inputEnterKey("btn_search", "DOMActivate");
					]]>
				</script>
			</input>
			<caption id="caption37" class="search_name" style="left:300px; top:18px; width:60px; height:17px; ">성명:</caption>
			<button id="btn_exceldetail" class="btn2_letter4" style="left:1127px; top:183px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
						
						if (fileName != "")
						{
							grd_healthinsulist.saveExcel(fileName, "sheetname:savetype", true, true, "", "");
						}		
					]]>
				</script>
			</button>
			<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:111px; text-align:center; ">
				<col ref="notiym" visibility="hidden" format="yyyy-mm"/>
				<col ref="instnm" style="text-align:center; "/>
				<col ref="emplnm" type="input" style="text-align:center; "/>
				<col ref="rrgstno" type="input" format="999999-9999999" style="text-align:center; "/>
				<col ref="acqtdd" format="yyyy-mm-dd"/>
				<col ref="lossdd" format="yyyy-mm-dd"/>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
						grd_healthinsulist.rebuildStyle();
						misfMsterDetailRetrieve(); 	
						
						model.setValue("/root/send/healthempr/notiym",ipt_notiym.value);
						model.setValue("/root/send/healthempr/rrgstno",grd_healthempllist.valueMatrix(grd_healthempllist.row, grd_healthempllist.colRef("rrgstno")));
						submit("TRRPA07902");
						
						model.refresh();
						
						fTotalSum();
					]]>
				</script>
			</datagrid>
			<caption id="caption1" class="tit_2" style="left:10px; top:191px; width:219px; height:13px; ">월별 건강보험료 납부 내역</caption>
			<line id="line1" class="line_1" style="x1:0px; y1:69px; x2:500px; y2:69px; "/>
			<line id="line2" class="line_1" style="x1:0px; y1:205px; x2:1192px; y2:205px; "/>
			<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:210px; width:1192px; height:515px; ">
				<row>
					<col ref="notiym" rowspan="2" visibility="hidden"/>
					<col ref="rrgstno" visibility="hidden"/>
					<col ref="mm" rowspan="2" style="text-align:center; "/>
					<col ref="instnm" rowspan="2"/>
					<col ref="reductresnnm" rowspan="2"/>
					<col ref="jobkindcd" rowspan="2" style="text-align:center; "/>
					<col ref="remunrmmamt" rowspan="2" format="#,###" style="text-align:right; "/>
					<col ref="calcinsuamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="calcresnnm" style="text-align:center; "/>
					<col ref="calcamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="notiamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="yyendcalc" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="adjtamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="notiympayamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="totalamt" rowspan="2" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="spclmentfact" rowspan="2" visibility="hidden"/>
				</row>
				<row>
					<col ref="emplnm" visibility="hidden"/>
					<col ref="mtrtcalcinsuamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="mtrtcalcresn" style="text-align:center; "/>
					<col ref="mtrtcalcamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="mtrtnotiamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="mtrtyyendcalc" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="mtrtadjtamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
					<col ref="mtrtlndchrgamt" savetype="digit" format="(-)#,###" style="text-align:right; "/>
				</row>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
						model.setValue("/root/main/spclmentfact_txt",grd_healthinsulist.valueMatrix(grd_healthinsulist.row,grd_healthinsulist.colRef("spclmentfact")));
						model.refresh();
					]]>
				</script>
			</multilinegrid>
			<input id="ipt_emplno" ref="/root/send/healthsend/emplno" class="input_search" disabled="true" imemode="hangul" style="left:468px; top:18px; width:100px; height:19px; text-align:center; ">
				<script type="javascript" ev:event="onkeyup">
					<![CDATA[
						inputEnterKey("btn_search", "DOMActivate");
					]]>
				</script>
			</input>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="btn_init" class="btn4_letter3" style="left:1122px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fInitialize();	
					]]>
				</script>
			</button>
			<line id="line9" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
		</group>
	</xhtml:body>
</xhtml:html>