YNU_JEUS/app_home/himed/webapps/mis/insurancemngtweb/xrw/SMRPA04000_연금부담금내역서.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>
						<disadiffpay>
							<disadiffpayinst>
								<instnm/>
								<cnt/>
								<mancnt/>
								<instcd/>
								<notiym/>
								<emplnm/>
								<infoworkgbn/>
							</disadiffpayinst>
						</disadiffpay>
						<disadiffpayform>
							<insurancelist>
								<notiym/>
								<instnm/>
								<rrgstno/>
								<seqno/>
								<jobgrad/>
								<jobpos/>
								<paycls/>
								<diligent/>
								<pensym/>
								<flag1/>
								<prestmmbamt/>
								<flag2/>
								<enlstmnlayoff/>
								<flag3/>
								<layoff/>
								<sameretc/>
								<difretc/>
								<groupretc/>
								<totno/>
								<totamt/>
								<paytotamt/>
								<fstnotiym/>
								<flag4/>
								<flag5/>
								<bfjobgrad/>
								<bfjobpos/>
								<bfpaycls/>
								<emplno/>
								<instcd/>
							</insurancelist>
						</disadiffpayform>
					</main>
					<send>
						<searchlist>
							<notiym/>
							<rrgstno1/>
							<rrgstno2/>
							<emplnm/>
							<instcd/>
							<infoworkgbn/>
						</searchlist>
						<disadiffpay>
							<instcd/>
							<notiym/>
							<rrgstno1/>
							<rrgstno2/>
							<emplnm/>
							<infoworkgbn/>
						</disadiffpay>
					</send>
					<temp/>
					<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_disadiffpayinst);
					misfGridInit(grd_insurancelist);
					misfMsterDetailSet(grd_disadiffpayinst, null, "TRRPA04001" ,"N"); 
					misfMsterDetailSet(grd_insurancelist, grd_disadiffpayinst, "TRRPA04002" ,"Y"); 
					rpaComboInstBase(cmb_instcd,getUserInfo("dutplceinstcd"));
				     	var instcd = getUserInfo("dutplceinstcd");
				       	cmb_instcd.value=instcd;
				]]>
			</script>
			<submission id="TRRPA04001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/main/disadiffpay"/>
			<submission id="TRRPA04002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/disadiffpay" resultref="/root/main/disadiffpayform"/>
		</model>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
					model.removeNodeset("/root/main/disadiffpay/disadiffpayinst");
					model.removeNodeset("/root/main/disadiffpayform/insurancelist");
					model.resetInstanceNode("/root/send");
					model.refresh();
					var curDate = getCurrentDate().toDate();
					model.setValue("/root/send/searchlist/notiym", curDate.getDateFormat('YYYYMM'));
				}
				function fPrint() {
					exeReportPreview("RPRPA04000", "XMLSTR");
				}

 			]]>
		</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="caption2" class="search_name" style="left:15px; top:19px; 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[
					if(!isRequiredControls("ipt_notiym"))return;	
					model.setValue("/root/send/searchlist/infoworkgbn","M");
					misfMsterDetailRetrieve(); 
					 
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:38px; "/>
			<line id="line207" class="line_1" style="x1:0; y1:69; x2:1195; y2:69px; "/>
			<datagrid id="grd_insurancelist" nodeset="/root/main/disadiffpayform/insurancelist" caption="고지년월^기관명^교직구분^주민등록번호^성명^직급^호봉^당월부담금액^휴직^일반소급^군소급^대  여^합산(반납금)^추가공제금액^합계^기관코드" colsep="^" colwidth="66, 100, 69, 99, 62, 47, 47, 84, 55, 66, 87, 88, 78, 83, 88, 100, 100" dataheight="25" ellipsis="true" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" tooltip="true" style="left:284px; top:74px; width:911px; height:640px; ">
				<col ref="notiym" visibility="hidden" format="yyyy-mm" style="text-align:center; "/>
				<col ref="instnm"/>
				<col ref="jobgradnm"/>
				<col ref="rrgstno" format="999999-9999999" style="text-align:center; "/>
				<col ref="emplnm" style="text-align:center; "/>
				<col ref="jobpos" style="text-align:center; "/>
				<col ref="paycls" style="text-align:center; "/>
				<col ref="prestmmbamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="layoff" format="(-)#,###" style="text-align:right; "/>
				<col ref="totretc" format="(-)#,###" style="text-align:right; "/>
				<col ref="groupretc" format="(-)#,###" style="text-align:right; "/>
				<col ref="loadamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="totamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="adddeduamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="jobgrad" visibility="hidden"/>
			</datagrid>
			<input id="ipt_notiym" ref="/root/send/searchlist/notiym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:100px; top:18px; width:100px; height:19px; "/>
			<caption id="caption9" class="tit_2" style="left:10px; top:54px; width:126px; height:14px; ">연금부담금 내역서</caption>
			<caption id="caption4" class="search_name" style="left:219px; top:20px; width:99px; height:17px; ">주민번호:</caption>
			<caption id="caption309" style="left:372px; top:21px; width:16px; height:17px; font-weight:bold; text-align:center; vertical-align:bottom; ">~</caption>
			<input id="ipt_chldrnresdnrgst1" ref="/root/send/searchlist/rrgstno1" class="input_default" maxlength="6" style="left:300px; top:19px; width:70px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<input id="ipt_chldrnresdnrgst2" ref="/root/send/searchlist/rrgstno2" class="input_default" maxlength="7" style="left:388px; top:19px; width:70px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<caption id="caption5" class="search_name" style="left:466px; top:20px; width:60px; height:17px; ">성명:</caption>
			<input id="ipt_emplnm" ref="/root/send/searchlist/emplnm" imemode="hangul" style="left:526px; top:19px; width:105px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
						inputEnterKey("btn_search", "DOMActivate");			
					]]>
				</script>
			</input>
			<select1 id="cmb_instcd" ref="/root/send/searchlist/instcd" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:675px; top:20px; width:144px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<datagrid id="grd_disadiffpayinst" nodeset="/root/main/disadiffpay/disadiffpayinst" caption="기관^총건수^인원수^기관코드^작업월^caption1^caption2^caption3" colsep="^" colwidth="137, 62, 58, 100, 43" ellipsis="true" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" tooltip="true" style="left:0px; top:74px; width:280px; height:640px; ">
				<col ref="instnm"/>
				<col ref="cnt" format="#,###" style="text-align:right; "/>
				<col ref="mancnt" format="#,###" style="text-align:right; "/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="notiym" visibility="hidden"/>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
						grd_disadiffpayinst.subtotal("clear", 0, 0);
						grd_disadiffpayinst.subtotalPosition = "below";
						grd_disadiffpayinst.multiTotals = true;
						grd_disadiffpayinst.subtotal("sum", -1, 3, "format:#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 1, "총합계", false);			
						grd_disadiffpayinst.subtotal("sum", -1, 2, "format:#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 1, "총합계", false);
						var rrgstno1=model.getValue("/root/send/searchlist/rrgstno1");
						var rrgstno2=model.getValue("/root/send/searchlist/rrgstno2");
						var emplnm=model.getValue("/root/send/searchlist/emplnm");
						model.makeValue("/root/main/disadiffpay/disadiffpayinst/rrgstno1",rrgstno1);
						model.makeValue("/root/main/disadiffpay/disadiffpayinst/rrgstno2",rrgstno2);
						model.makeValue("/root/main/disadiffpay/disadiffpayinst/emplnm",emplnm);
						model.makeValue("/root/main/disadiffpay/disadiffpayinst/infoworkgbn","M");
						
						misfMsterDetailRetrieve(); 
						
						grd_insurancelist.subtotalposition = "below";
						grd_insurancelist.subtotal("clear", 0, 0);     
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("prestmmbamt"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("layoff"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("totretc"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("groupretc"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("loadamt"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("totamt"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("adddeduamt"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("instcd") , grd_insurancelist.colRef("paytotamt"), "format:(-)#,###; ", "background-color:#ffcc99; font-weight:bold; ", 2, "총계");
						
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("prestmmbamt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("layoff"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("totretc"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("groupretc"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("loadamt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("totamt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("adddeduamt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_insurancelist.subtotal("sum",grd_insurancelist.colRef("jobgrad") , grd_insurancelist.colRef("paytotamt"), "format:(-)#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");
				    ]]>
				</script>
			</datagrid>
			<button id="btn_exceldetail" class="btn2_letter4" style="left:1125px; top:48px; 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_insurancelist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
			<button id="button1" class="btn2_letter4" style="left:210px; top:48px; 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_disadiffpayinst.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
		</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:1119px; 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; "/>
			<button id="button2" class="btn4_letter5" style="left:1025px; top:3px; width:92px; height:22px; ">
				<caption>내역서출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						 if(!isRequiredControls("ipt_notiym"))return;
						fPrint();
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>