YNU_JEUS/app_home/himed/webapps/mis/paydedufactmngtweb/xrw/SMRWD00300_공제항목별금액등록.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>
						<deduitem>
							<deduitemlist/>
							<instpaydedulist/>
							<appinstpaydedulist/>
						</deduitem>
						<deduitemamt>
							<deduitemamtlist/>
						</deduitemamt>
						<fixdeduitemamt>
							<fixdeduitemamtlist/>
						</fixdeduitemamt>
						<titlelist>
							<deduitemnm/>
							<dedumm/>
						</titlelist>
					</main>
					<send>
						<deduitem>
							<instcd/>
							<dedumm/>
							<payitemcd/>
							<payitemnm/>
							<endyn/>
							<saldfrayflag>1</saldfrayflag>
						</deduitem>
						<deduitemamt>
							<instcd/>
							<deduitemcd/>
							<dedumm/>
							<payitemcd/>
						</deduitemamt>
						<save>
							<deduitemamtlist/>
							<deduitemlist/>
							<fixdeduitemamtlist/>
							<instpaydedulist/>
						</save>
						<fixdeduitemamt>
							<instcd/>
							<deduitemcd/>
							<payitemcd/>
						</fixdeduitemamt>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfGridInit(grd_deduitemlist);
					misfGridInit(grd_deduitemamtlist);
					misfGridInit(grd_fixdeduitemamtlist);
					misfGridInit(grd_instpaydedulist);
					misfGridInit(grd_appinstpaydedulist);
					
					misfMsterDetailSet(grd_deduitemlist,null, "TRRWD00301" ,"Y"); 
					misfMsterDetailSet(grd_instpaydedulist,null, "TRRWD00301" ,"Y"); 
					misfMsterDetailSet(grd_appinstpaydedulist,null, "TRRWD00301" ,"N"); 
					misfMsterDetailSet(grd_deduitemamtlist,grd_deduitemlist, "TRRWD00302" ,"Y"); 
					misfMsterDetailSet(grd_fixdeduitemamtlist,grd_deduitemlist, "TRRWD00303" ,"Y"); 
					
					var curdate = getCurrentDate();
					
					model.setValue(ipt_dedumm.attribute("ref") , curdate.substr(0,6));
					model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
					
					//misfComboComCdList("Z0007", cmb_instcd);
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
					model.refresh();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[
					//개인별 공제 금액 출력물 기본 Data 설정.
					function fPrintDataSet()
					{
						//공제항목 title set
						model.setValue("/root/main/titlelist/deduitemnm", grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("deduitemnm")));						
						
						//공제월 set
						model.setValue("/root/main/titlelist/dedumm", ipt_dedumm.value);
						
						model.refresh();
					}
				]]>
			</script>
			<submission id="TRRWD00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/deduitem" resultref="/root/main/deduitem"/>
			<submission id="TRRWD00302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/deduitemamt" resultref="/root/main/deduitemamt"/>
			<submission id="TXRWD00301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/hidden/temp"/>
			<submission id="TRRWD00303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/fixdeduitemamt" resultref="/root/main/fixdeduitemamt"/>
			<submission id="TXRWD00302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/deduitem" resultref="/root/hidden/temp"/>
		</model>
		<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="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/paybaseinfomngtweb/js/RWC001.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
	</xhtml:head>
	<xhtml:body guideline="1,580;">
		<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; ">
			<switch id="switch1" style="left:385px; top:395px; width:805px; height:345px; ">
				<case id="case1" selected="true">
					<button id="btn_monthcopy" class="btn5_letter4" style="left:470px; top:5px; width:64px; height:19px; ">
						<caption>월별복사</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						var monthemplno = "";
						var emplno = "";
						var emplname = "";
						var frommm = "";
						var tomm = "";
						var dedumm = ipt_dedumm.value;
						var inputcheck = "N";
						
						
								
						for (var i = grd_fixdeduitemamtlist.fixedRows ; i < grd_fixdeduitemamtlist.rows; i++) {
							emplno = grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("emplno"));
							frommm = grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("dedufrommm"));
							tomm = grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("dedutomm"));
							for (var j = grd_deduitemamtlist.fixedRows; j < grd_deduitemamtlist.rows; j++) {
								monthemplno = grd_deduitemamtlist.valueMatrix(j, grd_deduitemamtlist.colRef("emplno"));
								
								if (emplno != null && monthemplno != null && monthemplno == emplno) {
									emplname = grd_deduitemamtlist.valueMatrix(j, grd_deduitemamtlist.colRef("emplnm"));
									messageBox(emplname + "는 이미 입력 되어있어서 복사 ", "E001");
									inputcheck = "Y";
								}
							}
							
							
							if (dedumm >= frommm && dedumm <= tomm && inputcheck != "Y" ) {
															
								grd_deduitemamtlist.subtotal("clear", 0, 0);
								grd_deduitemamtlist.refresh();	
								
								misfGridIUD(grd_deduitemamtlist, "A");
								
								var emplnm = grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("emplnm"));
								var deduamt = grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("deduamt"));
								
								grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("emplno")) = emplno;
								grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("emplnm")) = emplnm;
								grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("deduamt")) = deduamt;
							}
							
							inputcheck = "N";
						}

					]]>
						</script>
					</button>
					<button id="button1" class="btn2_letter4" style="left:735px; top:5px; 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_fixdeduitemamtlist.saveExcel(fileName);
						}			
					]]>
						</script>
					</button>
					<button id="btn_grdaddfixdeduitemamtlist" class="btn2_letter3" style="left:557px; top:5px; width:53px; height:19px; ">
						<caption>행추가</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						misfGridIUD(grd_fixdeduitemamtlist, "A");
					]]>
						</script>
					</button>
					<caption id="caption5" class="tit_2" style="left:10px; top:10px; width:198px; height:13px; ">개인별 고정 공제 금액 List</caption>
					<button id="btn_saveexcel2" class="btn2_letter4" style="left:669px; top:5px; width:64px; height:19px; ">
						<caption>엑셀입력</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[

						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						grd_fixdeduitemamtlist.loadExcel(fileName, 1, true);
						//grd_paydedulist.deleteRow(grd_paydedulist.fixedRows);
						grd_fixdeduitemamtlist.refresh();	
						
						var dedumm = grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("dedumm"));
						var instcd = grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("instcd"));
						var deduitemcd = grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("deduitemcd"));
						var payitemcd =  grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("payitemcd"));
						
						for (var i = grd_fixdeduitemamtlist.fixedRows; i < grd_fixdeduitemamtlist.rows; i++) {
							grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("dedumm")) = dedumm;
							grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("instcd")) = instcd;
							grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("deduitemcd")) = deduitemcd;
							grd_fixdeduitemamtlist.valueMatrix(i, grd_fixdeduitemamtlist.colRef("payitemcd")) = payitemcd;
							grd_fixdeduitemamtlist.rowStatus(i) = 1;
						}
						
						model.refresh();
					]]>
						</script>
					</button>
					<line id="line2" class="line_1" style="x1:3px; y1:25px; x2:801px; y2:25px; "/>
					<datagrid id="grd_fixdeduitemamtlist" nodeset="/root/main/fixdeduitemamt/fixdeduitemamtlist" caption="사원번호^성명^공제금액^공제기간^공제기간^비고^기관코드^공제항목코드^최초등록자ID^최초등록일시^최종수정자ID^최종수정일시|사원번호^성명^공제금액^시작월^종료월^비고^기관코드^공제항목코드^최초등록자ID^최초등록일시^최종수정자ID^최종수정일시" colsep="^" colwidth="85, 104, 112, 97, 96, 275, 25, 32, 34, 35, 26, 28" dataheight="25" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:3px; top:30px; width:800px; height:305px; ">
						<col ref="emplno" type="inputbutton"/>
						<col ref="emplnm"/>
						<col ref="deduamt" type="input" format="#,###" style="text-align:right; vertical-align:middle; "/>
						<col ref="dedufrommm" type="inputdate" format="yyyy-mm"/>
						<col ref="dedutomm" type="inputdate" format="yyyy-mm"/>
						<col ref="cmt" type="input"/>
						<col ref="instcd" visibility="hidden"/>
						<col ref="deduitemcd" visibility="hidden"/>
						<col ref="fstrgstrid" visibility="hidden"/>
						<col ref="fstrgstdt" visibility="hidden"/>
						<col ref="lastupdtrid" visibility="hidden"/>
						<col ref="lastupdtdt" visibility="hidden"/>
						<col ref="payitemcd" type="output" visibility="hidden"/>
						<script type="javascript" ev:event="onbuttonclick">
							<![CDATA[
						 if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							 	
							rpbfOpenPopUpList("SPRPB00101", grd_fixdeduitemamtlist, recv_list,"","N");
							model.refresh();
						 }			
					]]>
						</script>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
						if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							misfValidationCheck("01-1", "", recv_list);
							model.refresh();
						}
						
						if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "dedufrommm" ) { //계산기준코드
							var dedufrommm = grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedufrommm"));
							
							if (dedufrommm.length  > 6 ) {
								grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedufrommm")) = dedufrommm.substr(0,6);
							}
							model.refresh();
						}	
						
						if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "dedutomm" ) { //계산기준코드
							var dedutomm = grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedutomm"));
							
							if (dedutomm.length  > 6 ) {
								grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedutomm")) = dedutomm.substr(0,6);
							}
							model.refresh();
						}	
					]]>
						</script>
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
						grd_fixdeduitemamtlist.gridToInstance();	
					]]>
						</script>
					</datagrid>
					<button id="btn_grddelfixdeduitemamtlist" class="btn2_letter3" style="left:613px; top:5px; width:53px; height:19px; ">
						<caption>행삭제</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
						misfGridIUD(grd_fixdeduitemamtlist, "D");		
					]]>
						</script>
					</button>
				</case>
				<case id="case2">
					<button id="button4" class="btn2_letter4" style="left:735px; top:5px; 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_instpaydedulist.saveExcel(fileName);
						}			
					]]>
						</script>
					</button>
					<button id="btn_addinstpaydedulist" class="btn2_letter3" style="left:623px; top:5px; width:53px; height:19px; ">
						<caption>행추가</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								misfGridIUD(grd_instpaydedulist, "A");
							]]>
						</script>
					</button>
					<caption id="caption2" class="tit_2" style="left:10px; top:10px; width:198px; height:14px; ">타기관 신청 List</caption>
					<line id="line3" class="line_1" style="x1:3px; y1:25px; x2:801px; y2:25px; "/>
					<datagrid id="grd_instpaydedulist" nodeset="/root/main/deduitem/instpaydedulist" caption="신청기관^공제항목^공제항목^사원번호^성명^공제금액^비고^기관코드^공제월^확정여부^신청기관^공제항목old^사원번호old|신청기관^공제항목^공제항목^사원번호^성명^공제금액^비고^기관코드^공제월^확정여부^신청기관^공제항목old^사원번호old" colsep="^" colwidth="120, 100, 20, 89, 80, 100, 247, 25, 35, 28, 30, 33, 38" dataheight="25" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:3px; top:30px; width:800px; height:305px; ">
						<col ref="appinstnm" type="output"/>
						<col ref="deduitemnm"/>
						<col ref="deduitemcd" type="inputbutton"/>
						<col ref="emplno" type="inputbutton" style="text-align:right; vertical-align:middle; "/>
						<col ref="emplnm" type="output"/>
						<col ref="deduamt" type="input" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
						<col ref="cmt" type="input"/>
						<col ref="instcd" visibility="hidden"/>
						<col ref="dedumm" visibility="hidden"/>
						<col ref="endyn" visibility="hidden"/>
						<col ref="appinstcd" visibility="hidden"/>
						<col ref="olddeduitemcd" visibility="hidden"/>
						<col ref="oldemplno" visibility="hidden"/>
						<script type="javascript" ev:event="onbuttonclick">
							<![CDATA[
								 if (grd_instpaydedulist.colAttribute(grd_instpaydedulist.col,"ref") == "emplno" ) { //계산기준코드
									var recv_list = "emplno,emplnm";
										
									rpbfOpenPopUpList("SPRPB00101", grd_instpaydedulist, recv_list,"","N");
									model.refresh();
								 }			
								
								if (grd_instpaydedulist.col == grd_instpaydedulist.colRef("deduitemcd")) {
									misfOpenPopUpList("13", grd_instpaydedulist,"", "deduitemcd,deduitemnm","ipt_saldfrayflag") ;
									model.refresh();
								}
							]]>
						</script>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
								if (grd_instpaydedulist.colAttribute(grd_instpaydedulist.col,"ref") == "emplno" ) { //계산기준코드
									var recv_list = "emplno,emplnm";
									misfValidationCheck("01-1", "", recv_list);
									model.refresh();
								}
							]]>
						</script>
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
								grd_instpaydedulist.gridToInstance();	
							]]>
						</script>
					</datagrid>
					<button id="btn_delinstpaydedulist" class="btn2_letter3" style="left:679px; top:5px; width:53px; height:19px; ">
						<caption>행삭제</caption>
						<script type="javascript" ev:event="DOMActivate">
							<![CDATA[
								misfGridIUD(grd_instpaydedulist, "D");		
							]]>
						</script>
					</button>
				</case>
				<case id="case3">
					<button id="button7" class="btn2_letter4" style="left:735px; top:5px; 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_appinstpaydedulist.saveExcel(fileName);
								}			
							]]>
						</script>
					</button>
					<caption id="caption3" class="tit_2" style="left:10px; top:10px; width:198px; height:14px; ">타기관 신청 List</caption>
					<line id="line4" class="line_1" style="x1:3px; y1:25px; x2:801px; y2:25px; "/>
					<datagrid id="grd_appinstpaydedulist" nodeset="/root/main/deduitem/appinstpaydedulist" caption="요청기관^공제항목^사원번호^성명^공제금액^비고^기관코드^공제월^확정여부^신청기관^공제항목old^사원번호old|요청기관^공제항목^사원번호^성명^공제금액^비고^기관코드^공제월^확정여부^신청기관^공제항목old^사원번호old" colsep="^" colwidth="120, 100, 89, 80, 100, 247, 25, 35, 28, 30, 33, 38" dataheight="25" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:3px; top:30px; width:800px; height:305px; ">
						<col ref="instnm" type="output"/>
						<col ref="deduitemnm"/>
						<col ref="emplno" type="output" style="text-align:right; vertical-align:middle; "/>
						<col ref="emplnm" type="output"/>
						<col ref="deduamt" type="output" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
						<col ref="cmt" type="output"/>
						<col ref="instcd" visibility="hidden"/>
						<col ref="dedumm" visibility="hidden"/>
						<col ref="endyn" visibility="hidden"/>
						<col ref="appinstcd" visibility="hidden"/>
						<col ref="olddeduitemcd" visibility="hidden"/>
						<col ref="oldemplno" visibility="hidden"/>
						<script type="javascript" ev:event="onbuttonclick">
							<![CDATA[
						 if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							 	
							rpbfOpenPopUpList("SPRPB00101", grd_fixdeduitemamtlist, recv_list,"","N");
							model.refresh();
						 }			
					]]>
						</script>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
						if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							misfValidationCheck("01-1", "", recv_list);
							model.refresh();
						}
						
						if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "dedufrommm" ) { //계산기준코드
							var dedufrommm = grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedufrommm"));
							
							if (dedufrommm.length  > 6 ) {
								grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedufrommm")) = dedufrommm.substr(0,6);
							}
							model.refresh();
						}	
						
						if (grd_fixdeduitemamtlist.colAttribute(grd_fixdeduitemamtlist.col,"ref") == "dedutomm" ) { //계산기준코드
							var dedutomm = grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedutomm"));
							
							if (dedutomm.length  > 6 ) {
								grd_fixdeduitemamtlist.valueMatrix(grd_fixdeduitemamtlist.row,  grd_fixdeduitemamtlist.colRef("dedutomm")) = dedutomm.substr(0,6);
							}
							model.refresh();
						}	
					]]>
						</script>
						<script type="javascript" ev:event="onaftersort">
							<![CDATA[
						grd_fixdeduitemamtlist.gridToInstance();	
					]]>
						</script>
					</datagrid>
				</case>
			</switch>
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1130px; top:16px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if ( !isRequiredControls("cmb_instcd" , "ipt_dedumm", "ipt_payitemcd") ) {
							return false;
						}
						
						misfMsterDetailRetrieve();
						
						
						if (grd_deduitemlist.rows - grd_deduitemlist.fixedRows > 0 && 	grd_deduitemlist.valueMatrix(grd_deduitemlist.fixedRows, grd_deduitemlist.colRef("endyn")) == "Y") {
							btn_confirm.disabled = true;
							btn_cancle.disabled = false;
							
							btn_grdadddeduitemamtlist.disabled = true;
							btn_grddeldeduitemamtlist.disabled = true;
							btn_inputexcel.disabled = true;
							
							btn_save.disabled = true;
						}
						
						if (grd_deduitemlist.rows - grd_deduitemlist.fixedRows > 0 && 	grd_deduitemlist.valueMatrix(grd_deduitemlist.fixedRows,grd_deduitemlist.colRef("endyn")) != "Y" ) {
							btn_confirm.disabled = false;
							btn_cancle.disabled = true;
							
							btn_grdadddeduitemamtlist.disabled = false;
							btn_grddeldeduitemamtlist.disabled = false;
							btn_inputexcel.disabled = false;
							
							btn_save.disabled = false;
						}
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1110px; y1:16px; x2:1110px; y2:38px; "/>
			<caption id="caption278" class="tit_2" style="left:5px; top:55px; width:157px; height:14px; ">공제항목List</caption>
			<line id="line207" class="line_1" style="x1:0px; y1:70px; x2:380px; y2:70px; "/>
			<line id="line1" class="line_1" style="x1:385px; y1:70px; x2:1195px; y2:70px; "/>
			<caption id="caption1" class="tit_2" style="left:385px; top:55px; width:198px; height:13px; ">개인별 공제 금액 List</caption>
			<button id="btn_grdadddeduitemamtlist" class="btn2_letter3" style="left:951px; top:50px; width:53px; height:19px; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						if ( !isRequiredControls("cmb_instcd" , "ipt_dedumm", "ipt_payitemcd") ) {
							return false;
						}
						
						grd_deduitemamtlist.subtotal("clear", 0, 0);
						grd_deduitemamtlist.refresh();
						
						misfGridIUD(grd_deduitemamtlist, "A");
					]]>
				</script>
			</button>
			<button id="btn_inputexcel" class="btn2_letter4" style="left:1063px; top:50px; width:64px; height:19px; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						if ( !isRequiredControls("cmb_instcd" , "ipt_dedumm", "ipt_payitemcd") ) {
							return false;
						}
						
						grd_deduitemamtlist.subtotal("clear", 0, 0);
						grd_deduitemamtlist.refresh();
						
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						grd_deduitemamtlist.loadExcel(fileName, 1, true);
						//grd_paydedulist.deleteRow(grd_paydedulist.fixedRows);
						grd_deduitemamtlist.refresh();	
						
						var dedumm = grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("dedumm"));
						var instcd = grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("instcd"));
						var deduitemcd = grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("deduitemcd"));
						var payitemcd =  grd_deduitemlist.valueMatrix(grd_deduitemlist.row, grd_deduitemlist.colRef("payitemcd"));
						
						for (var i = grd_deduitemamtlist.fixedRows; i < grd_deduitemamtlist.rows; i++) {
							grd_deduitemamtlist.valueMatrix(i, grd_deduitemamtlist.colRef("dedumm")) = dedumm;
							grd_deduitemamtlist.valueMatrix(i, grd_deduitemamtlist.colRef("instcd")) = instcd;
							grd_deduitemamtlist.valueMatrix(i, grd_deduitemamtlist.colRef("deduitemcd")) = deduitemcd;
							grd_deduitemamtlist.valueMatrix(i, grd_deduitemamtlist.colRef("payitemcd")) = payitemcd;
							grd_deduitemamtlist.rowStatus(i) = 1;
						}
						
						model.refresh();
					]]>
				</script>
			</button>
			<button id="btn_grddeldeduitemamtlist" class="btn2_letter3" style="left:1007px; top:50px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if (grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("endyn")) == "Y") {
							messageBox("마감이 되어서 삭제 ", "E001");
							return;
						}
						
//						grd_deduitemamtlist.subtotal("clear", 0, 0);
//						grd_deduitemamtlist.refresh();
						
						misfGridIUD(grd_deduitemamtlist, "D");		
					]]>
				</script>
			</button>
			<select1 id="cmb_instcd" ref="/root/send/deduitem/instcd" class="combo_s_essential" appearance="minimal" style="left:64px; top:17px; width:125px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="cap_instcd" class="search_name" style="left:5px; top:18px; width:61px; height:17px; ">기관:</caption>
			<datagrid id="grd_deduitemlist" nodeset="/root/main/deduitem/deduitemlist" caption="공제항목코드^공제항목명^급여항목코드^기관코드^최초등록자ID^최초등록일시^최종수정자ID^최종수정일시^공제월^확정여부|공제항목코드^공제항목명^급여항목코드^기관코드^최초등록자ID^최초등록일시^최종수정자ID^최종수정일시^공제월^확정여부" colsep="^" colwidth="104, 228, 41, 35, 39, 49, 43, 47, 36, 35" dataheight="25" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:75px; width:380px; height:665px; ">
				<col ref="deduitemcd" type="input"/>
				<col ref="deduitemnm" type="input"/>
				<col ref="payitemcd" type="output" visibility="hidden"/>
				<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="dedumm" visibility="hidden"/>
				<col ref="endyn" visibility="hidden"/>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
						misfMsterDetailRetrieve();
						
						
						
						grd_deduitemamtlist.subtotal("clear", 0, 0);
						
						grd_deduitemamtlist.subtotal("count",-1 , grd_deduitemamtlist.colRef("emplno"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
						grd_deduitemamtlist.subtotal("sum",-1 , grd_deduitemamtlist.colRef("deduamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
					]]>
				</script>
			</datagrid>
			<datagrid id="grd_deduitemamtlist" nodeset="/root/main/deduitemamt/deduitemamtlist" caption="사원번호^성명^공제금액^비고^퇴사일^급여기관^부서^공제일자^기관코드^공제항목코드^최초등록자ID^최초등록일시^최종수정자ID^최종수정일시^입력금액^차이액^마감|사원번호^성명^공제금액^비고^퇴사일^급여기관^부서^공제일자^기관코드^공제항목코드^최초등록자ID^최초등록일시^최종수정자ID^최종수정일시^입력금액^차이액^마감" colsep="^" colwidth="85, 85, 100, 146, 96, 131, 124, 32, 31, 31, 26, 27, 41, 35, 37, 40, 43, 100" dataheight="25" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:385px; top:75px; width:810px; height:295px; ">
				<col ref="emplno" type="inputbutton"/>
				<col ref="emplnm"/>
				<col ref="deduamt" type="input" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="cmt" type="input"/>
				<col disabled="true" ref="retiredd" type="inputdate"/>
				<col ref="payinstnm"/>
				<col ref="deptnm"/>
				<col ref="dedumm" visibility="hidden"/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="deduitemcd" visibility="hidden"/>
				<col ref="fstrgstrid" visibility="hidden"/>
				<col ref="fstrgstdt" visibility="hidden"/>
				<col ref="lastupdtrid" visibility="hidden"/>
				<col ref="lastupdtdt" visibility="hidden"/>
				<col ref="inputamt" visibility="hidden"/>
				<col ref="termamt" visibility="hidden"/>
				<col ref="payitemcd" type="output" visibility="hidden"/>
				<col ref="endyn" visibility="hidden"/>
				<script type="javascript" ev:event="onbuttonclick">
					<![CDATA[
						 if (grd_deduitemamtlist.colAttribute(grd_deduitemamtlist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							 	
					        	rpbfOpenPopUpList("SPRPB00101", grd_deduitemamtlist, recv_list,"","N");
							model.refresh();
						 }			
					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						 if (grd_deduitemamtlist.colAttribute(grd_deduitemamtlist.col,"ref") == "emplno" ) { //계산기준코드
							var recv_list = "emplno,emplnm";
							misfValidationCheck("01-1", "", recv_list);
							model.refresh();
						}
//						else  if (grd_deduitemamtlist.colAttribute(grd_deduitemamtlist.col,"ref") == "inputamt" ) { //계산기준코드
//							var inputamt = grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("inputamt"));
//							var deduamt = grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("deduamt"));
//							
//							if (deduamt == null) {
//								deduamt = 0;
//							}
//							
//							if (inputamt == null) {
//								inputamt = 0;
//							}
//							
//
//							grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("termamt")) = parseInt(inputamt) - parseInt(deduamt);
//							
//						}
//						else  if (grd_deduitemamtlist.colAttribute(grd_deduitemamtlist.col,"ref") == "deduamt" ) { //계산기준코드
//							var inputamt = grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("inputamt"));
//							var deduamt = grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("deduamt"));
//							
//							if (deduamt == null) {
//								deduamt = 0;
//							}
//							
//							
//							if (inputamt == null) {
//								inputamt = 0;
//							}
//							
//							grd_deduitemamtlist.valueMatrix(grd_deduitemamtlist.row, grd_deduitemamtlist.colRef("termamt")) = parseInt(inputamt) - parseInt(deduamt);
//						}			
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_deduitemamtlist.gridToInstance();	
					]]>
				</script>
			</datagrid>
			<caption id="cap_dedumm" class="search_name" style="left:215px; top:18px; width:75px; height:17px; ">공제월 :</caption>
			<input id="ipt_dedumm" ref="/root/send/deduitem/dedumm" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:290px; top:18px; width:95px; height:19px; "/>
			<button id="btn_grddeldeduitemlist" class="btn2_letter3" style="left:324px; top:49px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_deduitemlist, "D");		
					]]>
				</script>
			</button>
			<button id="btn_grdadddeduitemlist" class="btn2_letter3" style="left:268px; top:49px; width:53px; height:19px; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if ( !isRequiredControls("cmb_instcd" , "ipt_dedumm", "ipt_payitemcd") ) {
							return false;
						}
						
						misfGridIUD(grd_deduitemlist, "A");
					]]>
				</script>
			</button>
			<button id="btn_payitemcd" class="icon_search" style="left:603px; top:18px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "payitemcd,payitemnm";
					 	misfOpenPopUpList("13", ipt_payitemcd, "", recv_list, "ipt_saldfrayflag");
						model.refresh();
					        
					        if (model.getValue(ipt_payitemcd.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}	
					]]>
				</script>
			</button>
			<input id="ipt_payitemcd" ref="/root/send/deduitem/payitemcd" class="input_default" style="left:511px; top:18px; width:87px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var recv_list = "payitemcd,payitemnm";
						var saldfrayflag = "1";
						var paydeduflag = "2";
						rwcfValidationCheck("PAYITEM",saldfrayflag, paydeduflag, recv_list);

						model.refresh();
						
						if (model.getValue(ipt_payitemcd.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}
						
					]]>
				</script>
			</input>
			<input id="ipt_payitemnm" ref="/root/send/deduitem/payitemnm" class="input_default" style="left:622px; top:18px; width:141px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var recv_list = "payitemcd,payitemnm";
						var saldfrayflag = "1";
						var paydeduflag = "2";
						rwcfValidationCheck("PAYITEM",saldfrayflag, paydeduflag, recv_list);

						model.refresh();
						
						if (model.getValue(ipt_payitemcd.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}	
					]]>
				</script>
			</input>
			<caption id="cap_payitemcd" class="search_name" style="left:425px; top:18px; width:86px; height:17px; ">급여항목 :</caption>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1129px; top:50px; 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_deduitemamtlist.saveExcel(fileName);
						}			
					]]>
				</script>
			</button>
			<button id="btn_print" class="btn5_letter2" style="left:221px; top:49px; width:42px; height:19px; ">
				<caption>출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fPrintDataSet();
						exeReportPreview("RPRWD00301", "XMLSTR");
					]]>
				</script>
			</button>
			<button id="button2" class="btn_sw" group="tab" style="left:487px; top:375px; width:100px; height:22px; ">
				<caption>타기관신청</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.toggle("case2");
					]]>
				</script>
			</button>
			<button id="button3" class="btn_sw" group="tab" style="left:589px; top:375px; width:100px; height:22px; ">
				<caption>요청자료</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.toggle("case3");
					]]>
				</script>
			</button>
			<button id="btn_eatsel" class="btn_sw" group="tab" selected="true" style="left:385px; top:375px; width:100px; height:22px; ">
				<caption>고정공제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.toggle("case1");
					]]>
				</script>
			</button>
			<input id="ipt_saldfrayflag" ref="/root/send/deduitem/saldfrayflag" visibility="hidden" style="left:810px; top:15px; width:100px; height:19px; "/>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="btn_save" class="btn4_letter2" style="left:1134px; top:2px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfSave("TXRWD00301");
					]]>
				</script>
			</button>
			<button id="button35" class="btn4_letter3" style="left:1064px; top:2px; width:68px; height:22px; ">
				<caption>초기화</caption>
			</button>
			<line id="line9" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_confirm" class="btn4_letter4" style="left:858px; top:2px; width:80px; height:22px; ">
				<caption>최종확정</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.setValue("/root/send/deduitem/endyn","Y");
						
						submit("TXRWD00302");
						
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</button>
			<button id="btn_cancle" class="btn4_letter6" disabled="true" style="left:941px; top:2px; width:80px; height:22px; ">
				<caption>최종확정취소</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						model.setValue("/root/send/deduitem/endyn","N");
						
						submit("TXRWD00302");
						
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>