YNU_JEUS/app_home/himed/webapps/mis/retireamtmngtweb/xrw/SMRWR00200_건강보험퇴직자등록.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>
						<retirepayamt>
							<retirepayamtlist/>
						</retirepayamt>
						<exceldata/>
					</main>
					<send>
						<retirepayamt>
							<fromdd/>
							<todd/>
							<instcd/>
							<emplno/>
							<emplnm/>
						</retirepayamt>
						<save>
							<retirepayamtlist/>
						</save>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfGridInit(grd_retirepayamtlist);
					misfGridInit(grd_adjtlist);
				
					misfMsterDetailSet(grd_retirepayamtlist, null, "TRRWR00201" ,"Y"); 
					
					grd_retirepayamtlist.fixedcellcheckbox(0, 1) = true;
					
					var curdate = getCurrentDate();
					var dt = new Date(curdate.substr(0, 4), curdate.substr(4, 2)-1, 0);				
					model.setValue(ipt_fromdd.attribute("ref") , curdate.substr(0, 6)-1 + "01");
					model.setValue(ipt_todd.attribute("ref") , (curdate.substr(0, 6)-1) + "" +dt.getDate());
					
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","Y");
					
					addComboItem( "cmb_instcd", "[-- 전체 --]", "%", "above");
					model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
					
					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y"  || getUserInfo("dutplceinstcd") == "001" ) {
						cmb_instcd.disabled = false;
					}
					else {
						cmb_instcd.disabled = true;
					}
					
					model.refresh();
					model.setFocus("ipt_fromdd");
				]]>
			</script>
			<submission id="TXRWR00202" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/hidden/temp"/>
			<submission id="TRRWR00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retirepayamt" resultref="/root/main/retirepayamt"/>
			<submission id="TXRWR00201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/hidden/temp"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript" src="../../../mis/paybnusmngtweb/js/RWP001.js"/>
	</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:38; width:1195px; height:744px; ">
			<datagrid id="grd_adjtlist" nodeset="/root/main/exceldata" visibility="visible" caption="temp^사번^성명^금액" colsep="^" colwidth="100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:515px; top:210px; width:350px; height:150px; ">
				<col ref="temp"/>
				<col ref="emplno"/>
				<col ref="emplnm"/>
				<col ref="adjtamt"/>
			</datagrid>
			<datagrid id="grd_retirepayamtlist" nodeset="/root/main/retirepayamt/retirepayamtlist" caption="^기관^사원번호^성명^주민번호^취득일^입사일^퇴사일^부서^직위^전년도보수총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^월별급여총액^조정금액^급여총액^육아휴직수당^퇴직전3개월평균보수^건강보험정산금액^퇴직처리일자^기관^fstrgstrid^fstrgstdt^lastupdtrid^lastupdtdt|^기관^사원번호^성명^주민번호^취득일^입사일^퇴사일^부서^직위^전년도보수총액^1월^2월^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^조정금액^급여총액^육아휴직수당^퇴직전3개월평균보수^건강보험정산금액^퇴직처리일자^기관^fstrgstrid^fstrgstdt^lastupdtrid^lastupdtdt" colsep="^" colwidth="24, 100, 67, 68, 92, 100, 95, 90, 113, 71, 102, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 80, 91, 88, 85, 86, 82, 100, 16, 19, 16, 17, 34, 100, 100, 100, 100, 100" dataheight="25" explorerbar="sort" frozencols="4" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:75px; width:1193px; height:665px; ">
				<col checkvalue="Y,N" ref="selyn" type="checkbox"/>
				<col ref="instnm"/>
				<col ref="emplno"/>
				<col ref="emplnm"/>
				<col ref="rregno"/>
				<col ref="acqtdd" format="yyyy-mm-dd" style="text-align:center; vertical-align:middle; "/>
				<col disabled="true" ref="entcodd" type="inputdate"/>
				<col disabled="true" ref="retiredd" type="inputdate"/>
				<col ref="deptnm"/>
				<col ref="jobposnm"/>
				<col ref="preyypayamt" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="janpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="febpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="marpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="aprpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="maypayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="junpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="julpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="augpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="seppayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="octpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="novpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="decpayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="adjtpayamt" type="input" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="babypayamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="payavgamt" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="healthcalcamt" type="input" visibility="visible" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="tretdd" format="yyyy-mm-dd" style="text-align:center; vertical-align:middle; "/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="fstrgstrid" visibility="hidden"/>
				<col ref="fstrgstdt" visibility="hidden"/>
				<col ref="lastupdtrid" visibility="hidden"/>
				<col ref="lastupdtdt" visibility="hidden"/>
				<col ref="endyn" visibility="hidden"/>
				<col ref="oldjanpayamt" visibility="hidden"/>
				<col ref="oldfebpayamt" visibility="hidden"/>
				<col ref="oldmarpayamt" visibility="hidden"/>
				<col ref="chkyn" visibility="hidden"/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_retirepayamtlist.gridToInstance();	
						
						grd_retirepayamtlist.subtotalposition = "below";

						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("janpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("febpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("marpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("aprpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("maypayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("junpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("julpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("augpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("seppayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("octpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("novpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("decpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("adjtpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("paytotamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("babypayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("payavgamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("healthcalcamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
					]]>
				</script>
				<script type="javascript" ev:event="onbeforesort">
					<![CDATA[
						grd_retirepayamtlist.subtotal("clear", 0, 0);
					]]>
				</script>
			</datagrid>
			<line id="line9" class="line_1" style="x1:0px; y1:69px; x2:1193px; y2:69px; "/>
			<caption id="caption34" class="tit_2" style="left:6px; top:53px; width:186px; height:13px; ">건강 보험 퇴직자 list</caption>
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:35px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="btn_search" class="btn1_letter2" navindex="6" style="left:1124px; top:7px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							misfMsterDetailRetrieve();	
							
							btn_makedata.disabled = false;
							btn_endyn.disabled = false;
							btn_save.disabled = false;
						    btn_grddelretirepayamtlist.disabled = false;
						    btn_canendyn.disabled = true;
							       
							if (grd_retirepayamtlist.rows - grd_retirepayamtlist.fixedRows > 0) {
								
							       
								if (grd_retirepayamtlist.valueMatrix(grd_retirepayamtlist.fixedRows, grd_retirepayamtlist.colRef("endyn")) == "Y") {
									btn_makedata.disabled = true;
									btn_endyn.disabled = true;
									btn_save.disabled = true;
								       btn_grddelretirepayamtlist.disabled = true;
								       btn_canendyn.disabled = false;
								}
							}
							
							grd_retirepayamtlist.subtotalposition = "below";

							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("janpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("febpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("marpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("aprpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("maypayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("junpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("julpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("augpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("seppayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("octpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("novpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("decpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("adjtpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("paytotamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("babypayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("payavgamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retirepayamtlist.subtotal("sum",-1 , grd_retirepayamtlist.colRef("healthcalcamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
						]]>
					</script>
				</button>
				<line id="line5" class="line_4" style="x1:1109px; y1:1px; x2:1109px; y2:35px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_fromdd" ref="/root/send/retirepayamt/fromdd" class="input_default" navindex="1" inputtype="date" format="yyyy-mm-dd" style="left:60px; top:7px; width:101px; height:19px; text-align:center; vertical-align:middle; "/>
				<caption id="cap_payym" class="search_name" style="left:4px; top:8px; width:60px; height:17px; ">기간:</caption>
				<select1 id="cmb_instcd" ref="/root/send/retirepayamt/instcd" class="combo_s_essential" appearance="minimal" style="left:378px; top:7px; width:237px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_instcd" class="search_name" style="left:321px; top:8px; width:61px; height:17px; ">기관:</caption>
				<input id="ipt_emplnm" ref="/root/send/retirepayamt/emplnm" class="input_default" navindex="5" style="left:810px; top:7px; width:106px; height:19px; ">
					<script type="javascript" ev:event="onkeyup">
						<![CDATA[
							if (ipt_emplnm.currentText != null && ipt_emplnm.currentText != "" ) {
								inputEnterKey("ipt_emplnm", "xforms-value-changed");	
								inputEnterKey("btn_search", "DOMActivate");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						var recv_list = "emplno,emplnm" ;
						rpbfValidationCheck("EMPLNM", recv_list);
						
						model.refresh();		
					]]>
					</script>
				</input>
				<button id="btn_emplno" class="icon_search" navindex="4" style="left:789px; top:7px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var recv_list = "emplno,emplnm" ;
						rpbfOpenPopUpList("SPRPB00101", ipt_emplno, recv_list,"","N");	
						
						model.refresh();
						
						if (model.getValue(ipt_emplno.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}	
					]]>
					</script>
				</button>
				<input id="ipt_emplno" ref="/root/send/retirepayamt/emplno" class="input_default" navindex="3" style="left:715px; top:7px; width:70px; height:19px; ">
					<script type="javascript" ev:event="onkeyup">
						<![CDATA[
							if (ipt_emplno.currentText != null && ipt_emplno.currentText != "" ) {
								inputEnterKey("ipt_emplno", "xforms-value-changed");	
								inputEnterKey("btn_search", "DOMActivate");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						var recv_list = "emplno,emplnm" ;
						rpbfValidationCheck("EMPLNO", recv_list);
						model.refresh();
					]]>
					</script>
				</input>
				<caption id="caption2" class="search_name" style="left:658px; top:8px; width:57px; height:17px; ">사번:</caption>
				<input id="ipt_todd" ref="/root/send/retirepayamt/todd" class="input_default" navindex="2" inputtype="date" format="yyyy-mm-dd" style="left:180px; top:7px; width:101px; height:19px; text-align:center; vertical-align:middle; "/>
				<caption id="caption3" style="left:165px; top:7px; width:10px; height:19px; ">-</caption>
			</group>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1130px; top:48px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");

						if (fileName != "")
						{
							grd_retirepayamtlist.saveExcel(fileName);
						}			
					]]>
				</script>
			</button>
			<button id="btn_grddelretirepayamtlist" class="btn2_letter3" style="left:876px; top:48px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_retirepayamtlist, "D");		
					]]>
				</script>
			</button>
			<button id="btn_inputexcel" class="btn2_letter7" style="left:1031px; top:48px; width:97px; height:19px; ">
				<caption>엑셀입력(조정)</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						grd_retirepayamtlist.subtotal("clear", 0, 0);
						grd_retirepayamtlist.refresh();
						
						misfGridInit(grd_adjtlist);
						
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						grd_adjtlist.loadExcel(fileName, 1, true);
						//grd_paydedulist.deleteRow(grd_paydedulist.fixedRows);
						grd_adjtlist.refresh();	
						var adjtamt  = 0;
						var adjtamt2 = 0;
						var adjttotamt = 0;
						for (var i = grd_adjtlist.fixedRows; i < grd_adjtlist.rows; i++ ) {
							var emplno = grd_adjtlist.valueMatrix(i, grd_adjtlist.colRef("emplno"));
							adjttotamt = 0;
							adjtamt =  parseInt(grd_adjtlist.valueMatrix(i, grd_adjtlist.colRef("adjtamt")));
							
							//alert(adjtamt);
							for (var j = grd_retirepayamtlist.fixedRows; j < grd_retirepayamtlist.rows; j++) {
								
								if (grd_retirepayamtlist.valueMatrix(j, grd_retirepayamtlist.colRef("emplno")) == emplno) {
									adjtamt2 = parseInt(grd_retirepayamtlist.valueMatrix(j, grd_retirepayamtlist.colRef("adjtpayamt")));
									//alert(adjtamt2);
									adjttotamt = adjtamt + adjtamt2;
									
									//alert(adjttotamt);
									
									grd_retirepayamtlist.valueMatrix(j, grd_retirepayamtlist.colRef("adjtpayamt")) = adjttotamt;
									grd_retirepayamtlist.rowStatus(j) = "2";
									
								}
							} 
						}
						
						model.refresh();
					]]>
				</script>
			</button>
			<button id="btn_inputcalcexcel" class="btn2_letter7" style="left:931px; top:48px; width:97px; height:19px; ">
				<caption>엑셀입력(정산)</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						grd_retirepayamtlist.subtotal("clear", 0, 0);
						grd_retirepayamtlist.refresh();
						
						misfGridInit(grd_adjtlist);
						
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						grd_adjtlist.loadExcel(fileName, 1, true);
						//grd_paydedulist.deleteRow(grd_paydedulist.fixedRows);
						grd_adjtlist.refresh();	
						var healthcalcamt  = 0;
						var healthcalcamt2 = 0;
						var healthtotamt = 0;
						for (var i = grd_adjtlist.fixedRows; i < grd_adjtlist.rows; i++ ) {
							var emplno = grd_adjtlist.valueMatrix(i, grd_adjtlist.colRef("emplno"));
							healthtotamt = 0;
							healthcalcamt =  parseInt(grd_adjtlist.valueMatrix(i, grd_adjtlist.colRef("adjtamt")));
							
							//alert(healthcalcamt);
							for (var j = grd_retirepayamtlist.fixedRows; j < grd_retirepayamtlist.rows; j++) {
								
								if (grd_retirepayamtlist.valueMatrix(j, grd_retirepayamtlist.colRef("emplno")) == emplno) {
									healthcalcamt2 = parseInt(grd_retirepayamtlist.valueMatrix(j, grd_retirepayamtlist.colRef("healthcalcamt")));
									//alert(adjtamt2);
									healthtotamt = healthcalcamt + healthcalcamt2;
									
									//alert(adjttotamt);
									
									grd_retirepayamtlist.valueMatrix(j, grd_retirepayamtlist.colRef("healthcalcamt")) = healthtotamt;
									grd_retirepayamtlist.rowStatus(j) = "2";
									
								}
							} 
						}
						
						model.refresh();
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0; top:12; width:1195px; height:27px; ">
			<line id="line4" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_endyn" class="btn4_letter4" visibility="hidden" style="left:1036px; top:3px; width:80px; height:22px; ">
				<caption>최종확정</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						if( messageBox("최종확정 하시겠습니까?", "Q003") != '6') return;
						
						for (var i = grd_retirepayamtlist.fixedRows; i < grd_retirepayamtlist.rows - 1; i++) {
							grd_retirepayamtlist.valueMatrix(i, grd_retirepayamtlist.colRef("endyn")) = "Y";
							grd_retirepayamtlist.rowStatus(i) = 2;
						}
						
						btn_save.dispatch("DOMActivate");
					]]>
				</script>
			</button>
			<button id="btn_canendyn" class="btn4_letter6" disabled="true" visibility="hidden" style="left:931px; top:3px; width:104px; height:22px; ">
				<caption>최종확정취소</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						if( messageBox("최종확정 취소 하시겠습니까?", "Q003") != '6') return;
						
						for (var i = grd_retirepayamtlist.fixedRows; i < grd_retirepayamtlist.rows - 1; i++) {
							grd_retirepayamtlist.valueMatrix(i, grd_retirepayamtlist.colRef("endyn")) = "N";
							grd_retirepayamtlist.rowStatus(i) = 2;
						}
						
						btn_save.dispatch("DOMActivate");
					]]>
				</script>
			</button>
			<button id="btn_save" class="btn4_letter2" style="left:1134px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfSave("TXRWR00201");
						
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</button>
			<button id="btn_makedata" class="btn4_letter6" style="left:816px; top:3px; width:104px; height:22px; ">
				<caption>급여자료생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						if( messageBox("퇴직자 자료생성을 하시겠습니까?", "Q003") != '6') return;
						
						for (var i = grd_retirepayamtlist.fixedRows; i < grd_retirepayamtlist.rows; i++) {
							if (grd_retirepayamtlist.valueMatrix(i, grd_retirepayamtlist.colRef("selyn")) == "Y" &&  grd_retirepayamtlist.valueMatrix(i, grd_retirepayamtlist.colRef("chkyn")) == "Y") {
								var emplnm = grd_retirepayamtlist.valueMatrix(i, grd_retirepayamtlist.colRef("emplnm"));
								
								var rtn = messageBox("[" + emplnm + "]은(는) 급여자료가 생성 되어 있습니다.재생성", "Q004");
								
								if (rtn != 6) {
									grd_retirepayamtlist.valueMatrix(i, grd_retireempllist.colRef("selyn")) = "N";
								}
								else {
									grd_retirepayamtlist.rowStatus(i) = "2";
								}
							}
							else if  (grd_retirepayamtlist.valueMatrix(i, grd_retirepayamtlist.colRef("chkyn")) == "N" && grd_retirepayamtlist.valueMatrix(i, grd_retirepayamtlist.colRef("selyn")) == "Y") {
								grd_retirepayamtlist.rowStatus(i) = "2";
								
							}
						}
						
						misfSave("TXRWR00202");
						
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>