YNU_JEUS/app_home/himed/webapps/mis/addtaxweb/xrw/SMRAT00800_근로소득조회및저장.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>Untitle</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<list>
							<orchlist/>
						</list>
						<sumlist>
							<orchsumlist/>
						</sumlist>
						<printlist>
							<fstpage/>
							<secpage/>
						</printlist>
					</main>
					<send>
						<retrparams>
							<instcd/>
							<payinst/>
							<frdd/>
							<todd/>
							<rrgstno/>
							<name/>
							<emplno/>
							<emplnm/>
							<profflag>7</profflag>
						</retrparams>
						<printparams>
							<payTotAmt/>
							<incmTax/>
							<resdnTax/>
						</printparams>
						<emplcheck>
							<instcd/>
							<emplno/>
						</emplcheck>
						<payappparams>
							<instcd/>
							<payym/>
							<payfromdd/>
							<paytodd/>
							<payitemcd>70260</payitemcd>
							<cancelyn/>
						</payappparams>
					</send>
					<init/>
					<temp/>
					<hidden>
						<prntlist>
							<dayworkerprntlist/>
						</prntlist>
						<checkedcnt/>
						<exceluploadlist>
							<excelupload/>
						</exceluploadlist>
						<emplcntcheck>
							<emplcnt/>
						</emplcntcheck>
					</hidden>
				</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/stringHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
			<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript" src="../../../mis/acntcommonweb/js/RAD001.js"/>
			<bind id="bindPayTotAmt" ref="/root/send/printparams/payTotAmt" calculate="sum(/root/main/list/orchlist/paytotamt)"/>
			<bind id="bindIncmTax" ref="/root/send/printparams/incmTax" calculate="sum(/root/main/list/orchlist/incmtax)"/>
			<bind id="bindResdnTax" ref="/root/send/printparams/resdnTax" calculate="sum(/root/main/list/orchlist/resdntax)"/>
			<submission id="TXRAT00601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/main/list/orchlist" resultref="/root/temp"/>
			<submission id="TRRAT00601" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[

					fInitialize();

				]]>
			</script>
			<script type="javascript">
				<![CDATA[

					function fInitialize()
					{
						model.removenode("/root/main/list/orchlist");

						misfMsterDetailSet(grd_orchlist, null, "TRRAT00601", "Y");

						misfComboComCdList("Z0007", cmb_instcd);
						misfGridComboComCdList("Z0007", grd_orchlist, "payinst");
						misfComboComCdListMulti("Z0007", "cmb_payinst", null, "Y");

						model.setValue("/root/send/retrparams/instcd",   		getUserInfo("dutplceinstcd"));						
						model.setValue("/root/send/retrparams/frdd",     		getCurrentDate().substr(0, 8));
						model.setValue("/root/send/retrparams/todd",     		getCurrentDate().substr(0, 8));
						model.setValue("/root/send/payappparams/instcd",   		getUserInfo("dutplceinstcd"));	
						model.setValue("/root/send/payappparams/payym",     	getCurrentDate().substr(0, 6));
						model.refresh();
						
						//fRetrieve();

					}
					
					function fRetrieve()
					{
						model.removeNodeset("/root/main/list/orchlist");
						grd_orchlist.refresh();
						
						submit("TRRAT00601");
						
						submit("TRRAT00602");

						for(var i=1; i<grd_orchlist.rows; i++)
						{
							if(model.getValue(grd_orchlist.nodeset + "[" + i + "]/slipyn") == "Y")
							{
								grd_orchlist.rowStyle(i, "all", "background-color") = "#EAEAEA";
								misfSetReadOnlyCol(grd_orchlist, "posyear,payinst,emplno,emplnm,paytotamt,cmt", true, i);
							}
							else if(model.getValue(grd_orchlist.nodeset + "[" + i + "]/payapplyn") == "Y")
							{
								grd_orchlist.rowStyle(i, "all", "background-color") = "#cc99ff";
								misfSetReadOnlyCol(grd_orchlist, "posyear,payinst,emplno,emplnm,paytotamt,cmt", true, i);
							}
							else
							{
								grd_orchlist.rowStyle(i, "all", "background-color") = "#ffffff";
								misfSetReadOnlyCol(grd_orchlist, "posyear,payinst,emplno,emplnm", true, i);
							}
						}

						fSetPrintNodeList();

						model.recalculate();
						
					}

					function fSave()
					{
						for(var i=1; i<grd_orchlist.rows; i++)
						{
//							var sPosyear    	= grd_orchlist.valueMatrix(i, grd_orchlist.colRef("posyear"));
							var sEmplno    		= grd_orchlist.valueMatrix(i, grd_orchlist.colRef("emplno"));
							var sPayTotAmt 	= grd_orchlist.valueMatrix(i, grd_orchlist.colRef("paytotamt"));
							var sCmt       		= grd_orchlist.valueMatrix(i, grd_orchlist.colRef("cmt"));
							
//							if(!isValidDateTime(sPosyear, "YYYYMMDD"))
//							{	messageBox("귀속 일자가 유효하지 않습니다.", "I000");	return;	}	
							if(sPayTotAmt == "")	{	messageBox("사원번호를", "C001");	return;	}
							if(sPayTotAmt == "")	{	messagBox("지급액을", "C001");	return;	}
							if(sCmt == "")		{	messageBox("적요를", "C001");		return;	}
						}

						misfSave("TXRAT00601");

						fRetrieve();
					}

					function fPrint()
					{
						var iCheckedCnt = parseInt(model.getValue("/root/hidden/checkedcnt"), 10);
						var dlgRslt = 0;

						if(iCheckedCnt > 0)
						{
							dlgRslt = messageBox("선택된 소득만 출력하시겠습니까\n\nYes(선택자료) / No(전체)", "Q000");
						}

						if(dlgRslt == 6)
						{
						    	var iCnt = 0;
						    	var sYn = "";

							model.removenode("/root/hidden/prntlist");
							model.makeNode("/root/hidden/prntlist");

							for(var i=1; i<grd_orchlist.rows; i++)
							{
								sYn = model.getValue(grd_orchlist.nodeset + "[" + i + "]/chk");
								
								if(sYn == "Y")
								{
									iCnt = instance1.selectNodes("/root/hidden/prntlist/dayworkerprntlist").length;

									model.makeNode("/root/hidden/prntlist/dayworkerprntlist[" + (iCnt + 1) + "]");
									model.copyNode("/root/hidden/prntlist/dayworkerprntlist[" + (iCnt + 1) + "]", "/root/main/list/orchlist[" + i + "]");
								}
							}
						}
						else
						{
							var iLength = instance1.selectNodes("/root/main/list/orchlist").length;

							model.removenode("/root/hidden/prntlist");
							model.makeNode("/root/hidden/prntlist");

							for(var i=1; i<=iLength; i++)
							{
								model.makeNode("/root/hidden/prntlist/dayworkerprntlist[" + i + "]");
								model.copyNode("/root/hidden/prntlist/dayworkerprntlist[" + i + "]", "/root/main/list/orchlist[" + i + "]");
							}
						}

						exeReportPreview("RPRAD00205", "XMLSTR");

					}
					
					function fSetPrintNodeList()
					{
						var iLength = instance1.selectNodes("/root/main/list/orchlist").length;

						model.removenode("/root/hidden/prntlist");
						model.makeNode("/root/hidden/prntlist");

						for(var i=1; i<=iLength; i++)
						{
							model.makeNode("/root/hidden/prntlist/dayworkerprntlist[" + i + "]");
							model.copyNode("/root/hidden/prntlist/dayworkerprntlist[" + i + "]", "/root/main/list/orchlist[" + i + "]");
						}
					}
					
					//========================================================================================
					//엑셀입력(excel file을 그리드에 입력)
					//========================================================================================
					function fInputExcel(pGrid) {
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						
						if(fileName != "") {
							pGrid.loadExcel(fileName, 1, true);
						
							pGrid.deleteRow(1);
//							
//							for(i = 1; i < pGrid.rows; i++) {
//								pGrid.rowStatus(i) = 1;
//							}
							pGrid.rebuild();
							return true;
						}
						return false;
					}
					
					//========================================================================================
					//엑셀입력 후 값 유효성 검사
					//========================================================================================
					function fValidCheck()
					{
						var vRows = instance1.selectNodes(excel_upload.nodeset).length;
						var vFirstRows = 1;
						
						for(var i = vFirstRows ; i <= vRows ; i++)
						{
							var vPosYear = model.getValue(excel_upload.nodeset + "[" + i + "]/posyear");
							if(vPosYear == "")
							{
								messageBox("귀속일자는", "I003");
								return false;
							}
							
							var vSanctSlipDD = model.getValue(excel_upload.nodeset + "[" + i + "]/sanctslipdd");
							if(vSanctSlipDD == "")
							{
								messageBox("지급일자는", "I003");
								return false;
							}
							
							var vEmplNo = (model.getValue(excel_upload.nodeset + "[" + i + "]/emplno"));
							if(vEmplNo == "")
							{
								messageBox("사원번호는", "I003");
								return false;
							}
							
							var vName = (model.getValue(excel_upload.nodeset + "[" + i + "]/name"));
							if(vName == "")
							{
								messageBox("이름은", "I003");
								return false;
							}
							
							model.setValue("/root/send/emplcheck/instcd", cmb_instcd.value);
							model.setValue("/root/send/emplcheck/emplno", vEmplNo);
							
							submit("TRRAZ00002");
							
							if(model.getValue("/root/hidden/emplcntcheck/emplcnt") == "0")
							{
								messageBox("사원번호 [ " + vEmplNo + " ] 는 잘못된 데이터 입니다.", "");
								return false;
							}
							
							var vPayTotAmt = (model.getValue(excel_upload.nodeset + "[" + i + "]/paytotamt"));
							if(parseInt(vPayTotAmt) <= 0)
							{
								messageBox("지급액은", "I003");
								return false;
							}
							
							var vCmt = (model.getValue(excel_upload.nodeset + "[" + i + "]/cmt"));
							if(vCmt == "")
							{
								messageBox("적요는", "I003");
								return false;
							}	
						}	
						return true;				
					}
					
					
					//========================================================================================
					//엑실 업로드 자료 그리드에 복사
					//========================================================================================
					function fCopyExcelGrid()
					{
						var vIntanceRows = instance1.selectNodes(excel_upload.nodeset).length;
						var vIntanceFirstRows = 1;
						
						var vDayWorkerRows = instance1.selectNodes(grd_orchlist.nodeset).length;
						
						var vDayWorkerStartRows = vDayWorkerRows + grd_orchlist.fixedRows;
						var vDayWorkerEndRows = vDayWorkerStartRows + vIntanceRows;
						
						for(var i = vIntanceFirstRows ; i <= vIntanceRows ; i++)
						{
							vDayWorkerRows++;
							
							//alert(vDayWorkerRows);
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/instcd", cmb_instcd.value);
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/chrgflag", "7");
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/posyear", model.getValue(excel_upload.nodeset + "[" + i + "]/posyear"));
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/sanctslipdd", model.getValue(excel_upload.nodeset + "[" + i + "]/sanctslipdd"));
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/emplno", model.getValue(excel_upload.nodeset + "[" + i + "]/emplno"));
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/emplnm", model.getValue(excel_upload.nodeset + "[" + i + "]/name"));
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/name", model.getValue(excel_upload.nodeset + "[" + i + "]/name"));
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/paytotamt", model.getValue(excel_upload.nodeset + "[" + i + "]/paytotamt"));
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/cmt", model.getValue(excel_upload.nodeset + "[" + i + "]/cmt"));						
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/dayno", "0");
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/dypay", "0");
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/taxrate", "0");
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/incmtax", "0");
							model.makeValue(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/resdntax", "0");
																					
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/seqno");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/detlseqno");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/unsldd");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/unslno");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/unslseqno");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/sanctslipno");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/sanctslipseqno");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/payinst");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/dutunitcd");
							model.makeNode(grd_orchlist.nodeset + "[" + vDayWorkerRows + "]/dutunitnm");


						}
						grd_orchlist.refresh();
						
						for(var i = vDayWorkerStartRows ; i <= vDayWorkerEndRows ; i++)
						{
							grd_orchlist.rowStatus(i) = 3;										
						}
					}
						
					function fGridStatusCheck()
					{
						var grd_rows = grd_orchlist.rows;
						var grd_fixedRows = grd_orchlist.fixedRows;
						
						for(var i = grd_fixedRows ; i <= grd_rows ; i++)
						{
							if(grd_orchlist.rowStatus(i) != 0)
							{
								messageBox("작업중인 데이터가 있습니다. \n 작업완료 후 작업하세요", "");
								return false;
							}
						}						
						return true;
					}
					
						
						
						
						
						
						
						
						
						
						
						
						
						
						
						

					

				]]>
			</script>
			<bind id="bindChkCnt" ref="/root/hidden/checkedcnt" calculate="count(/root/main/list/orchlist[chk = 'Y']/chk)"/>
			<submission id="TRRAZ00002" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/emplcheck" resultref="/root/hidden/emplcntcheck"/>
			<submission id="TRRAT00602" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/sumlist"/>
			<submission id="TXRWZ00303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payappparams" resultref="/root/temp"/>
		</model>
	</xhtml:head>
	<xhtml:body pagewidth="1211" pageheight="784" guideline="1,1193;" style="margin-left:8; margin-top:0; margin-right:8; margin-bottom:0; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:293px; height:14px; ">근로소득 조회/수정</caption>
			<caption id="caption4" class="patient_text_black" style="left:922px; top:0px; width:272px; "/>
		</group>
		<group id="group3" scroll="auto" style="left:0px; top:13px; width:1195px; height:762px; ">
			<group id="grp_sea" style="left:0px; top:35px; width:1195px; height:60px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:60px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line5" class="line_4" style="x1:1107px; y1:6px; x2:1107px; y2:54px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption1" class="search_name" style="left:575px; top:9px; width:90px; height:17px; ">지 급 일 :</caption>
				<input id="ipt_frdd" ref="/root/send/retrparams/frdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:680px; top:8px; width:95px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							//fRetrieve();

						]]>
					</script>
				</input>
				<caption id="caption2" style="left:777px; top:11px; width:15px; height:20px; ">~</caption>
				<select1 id="cmb_instcd" ref="/root/send/retrparams/instcd" class="combo_s_essential" disabled="true" navindex="-1" appearance="minimal" style="left:99px; top:8px; width:146px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption3" class="search_name" style="left:9px; top:9px; width:91px; height:17px; ">기관구분 :</caption>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1123px; top:19px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							fRetrieve();

						]]>
					</script>
				</button>
				<input id="ipt_todd" ref="/root/send/retrparams/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:790px; top:8px; width:95px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							//fRetrieve();

						]]>
					</script>
				</input>
				<caption id="caption8" class="search_name" style="left:260px; top:35px; width:90px; height:17px; ">소 득 자 :</caption>
				<input id="ipt_emplno" ref="/root/send/retrparams/emplno" class="input_search" navindex="5" style="left:346px; top:34px; width:70px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[

							if(event.keyCode == 13)
							{
								model.setFocus("ipt_name");
							}

						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							rpbfValidationCheck("EMPLNO", "emplno,emplnm,payinst");
							model.refresh();				

							fRetrieve();

						]]>
					</script>
				</input>
				<input id="ipt_emplnm" ref="/root/send/retrparams/emplnm" class="input_search" navindex="6" imemode="hangul" style="left:440px; top:34px; width:91px; height:19px; ">
					<script type="javascript" ev:event="onkeypress">
						<![CDATA[

							if(event.keyCode == 13)
							{
								model.setFocus("btn_search");
							}

						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[

							rpbfValidationCheck("EMPLNM", "emplno,emplnm,payinst");
							model.refresh();				

							fRetrieve();

						]]>
					</script>
				</input>
				<button id="btn_emplhelp" class="icon_search" style="left:420px; top:35px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							rpbfOpenPopUpList("SPRPB00101", ipt_emplno, "emplno,emplnm,payinst", "", "N");
							model.refresh();

						]]>
					</script>
				</button>
				<select1 id="cmb_payinst" ref="/root/send/retrparams/payinst" class="combo_s_essential" navindex="-1" appearance="minimal" style="left:345px; top:8px; width:146px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption3999" class="search_name" style="left:260px; top:9px; width:112px; height:17px; ">급여기관 :</caption>
				<caption id="caption5" class="search_name" style="left:575px; top:34px; width:110px; height:17px; ">급여반영 월 :</caption>
				<input id="ipt_payym" ref="/root/send/payappparams/payym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:680px; top:33px; width:95px; height:19px; text-align:center; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						
							var toYY 		= model.getValue(ipt_payym.attribute("ref")).substr(0,4);
							var toMM 		= model.getValue(ipt_payym.attribute("ref")).substr(4,2);
							
							var fromYY 	= "";
							var fromMM 	= "";
							
							if(toMM == "01")
							{
								fromYY = parseInt(toYY) - 1;
								fromMM = "12";							
							}
							else
							{
								fromYY = toYY;
								fromMM = (parseInt(toMM, 10) - 1)  + "";
								fromMM = fromMM.getLeftPad(2,"0");
							}
							
							model.setValue(ipt_frdd.attribute("ref"), fromYY + fromMM + "21");
							model.setValue(ipt_todd.attribute("ref"), toYY + toMM + "20");
							ipt_frdd.refresh();
							ipt_todd.refresh();
							
							btn_search.dispatch("DOMActivate");
							
						]]>
					</script>
				</input>
				<button id="button4" class="btn4_letter6" disabled="false" visibility="visible" style="left:875px; top:33px; width:104px; height:22px; ">
					<caption>급여반영취소</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
							ipt_payym.dispatch("xforms-value-changed");
							
							if (messageBox(model.getValue(ipt_frdd.attribute("ref")).substr(0,4) + "년 " + model.getValue(ipt_frdd.attribute("ref")).substr(4,2) + "월 " + model.getValue(ipt_frdd.attribute("ref")).substr(6,2) + "일 ~ " + 
							                       model.getValue(ipt_todd.attribute("ref")).substr(0,4) + "년 " + model.getValue(ipt_todd.attribute("ref")).substr(4,2) + "월 " + model.getValue(ipt_todd.attribute("ref")).substr(6,2) + "일까지 [급여반영]을 [취소] 하시겠습니까?", "Q000") == "6")
							{
								model.setValue("/root/send/payappparams/cancelyn", "Y");
								model.setValue("/root/send/payappparams/payfromdd", 	model.getValue(ipt_frdd.attribute("ref")));
								model.setValue("/root/send/payappparams/paytodd", 	model.getValue(ipt_todd.attribute("ref")));
								submit("TXRWZ00303");
							}
							btn_search.dispatch("DOMActivate");

						]]>
					</script>
				</button>
				<button id="btn_print1" class="btn4_letter4" disabled="false" visibility="visible" style="left:790px; top:33px; width:80px; height:22px; ">
					<caption>급여반영</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							
							ipt_payym.dispatch("xforms-value-changed");
							
							if (messageBox(model.getValue(ipt_frdd.attribute("ref")).substr(0,4) + "년 " + model.getValue(ipt_frdd.attribute("ref")).substr(4,2) + "월 " + model.getValue(ipt_frdd.attribute("ref")).substr(6,2) + "일 ~ " + 
							                       model.getValue(ipt_todd.attribute("ref")).substr(0,4) + "년 " + model.getValue(ipt_todd.attribute("ref")).substr(4,2) + "월 " + model.getValue(ipt_todd.attribute("ref")).substr(6,2) + "일까지 [급여반영]하시겠습니까?", "Q000") == "6")
							{
								model.setValue("/root/send/payappparams/cancelyn", "N");
								model.setValue("/root/send/payappparams/payfromdd", 	model.getValue(ipt_frdd.attribute("ref")));
								model.setValue("/root/send/payappparams/paytodd", 	model.getValue(ipt_todd.attribute("ref")));
								submit("TXRWZ00303");
							}
							btn_search.dispatch("DOMActivate");

						]]>
					</script>
				</button>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:118px; x2:1195px; y2:118px; "/>
			<caption id="caption21" class="tit_2" style="left:5px; top:103px; width:139px; height:13px; ">근로소득자 목록</caption>
			<group id="group2" scroll="auto" style="left:0px; top:0px; width:1195px; height:27px; ">
				<line id="line1" class="line_6" style="x1:0px; y1:25px; x2:1194px; y2:25px; "/>
				<button id="btn_save" class="btn4_letter2" style="left:1137px; top:3px; width:56px; height:22px; ">
					<caption>저장</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							fSave();
	
						]]>
					</script>
				</button>
				<button id="btn_print" class="btn4_letter2" visibility="hidden" style="left:1078px; top:3px; width:56px; height:22px; ">
					<caption>출력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							fPrint();

						]]>
					</script>
				</button>
			</group>
			<button id="btn_addrow" class="btn2_letter3" style="left:807px; top:98px; width:53px; height:19px; text-align:left; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						misfGridIUD(grd_orchlist, "A", "N");
						
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("instcd"))    		= getUserInfo("dutplceinstcd");
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("chrgflag"))    	= "7";
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("posyear"))     	= getCurrentDate();
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("sanctslipdd")) 	= getCurrentDate();

						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("dayno"))       	= 0;
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("dypay"))       	= 0;
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("taxrate"))     	= 0;
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("incmtax"))     	= 0;
						grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("resdntax"))    	= 0;
						
						if(grd_orchlist.row > grd_orchlist.fixedRows)
						{					
							grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("cmt")) = grd_orchlist.valueMatrix(grd_orchlist.row - 1, grd_orchlist.colRef("cmt"));
						}

						misfSetReadOnlyCol(grd_orchlist, "payinst", true, grd_orchlist.row);

					]]>
				</script>
			</button>
			<button id="btn_delrow" class="btn2_letter3" style="left:864px; top:98px; width:53px; height:19px; text-align:left; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						var iLength = grd_orchlist.selectedCells.length;
						
						for(var i=0; i<iLength; i++)
						{
							var iRowIdx = grd_orchlist.selectedCells.item(i).row;
							
							if(model.getValue(grd_orchlist.nodeset + "[" + iRowIdx + "]/slipyn") != "Y")
							{
								if(grd_orchlist.rowStatus(iRowIdx) == 4 || grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("payapplyn")) == "Y")
								{
									grd_orchlist.rowStatus(iRowIdx) = 0;
								}
								else if(grd_orchlist.rowStatus(iRowIdx) == 1 && grd_orchlist.rowStatus(iRowIdx) == 3)
								{
									grd_orchlist.deleteRow(iRowIdx, false);
								}
								else
								{
									grd_orchlist.addStatus(iRowIdx, "delete");
								}
							}
						}

					]]>
				</script>
			</button>
			<output id="opt_temp" ref="/root/hidden/incmpsn/name" visibility="hidden" style="left:784px; top:98px; width:20px; height:19px; "/>
			<caption id="caption10" style="left:180px; top:102px; width:15px; height:15px; background-color:#c0c0c0; "/>
			<caption id="caption11" style="left:198px; top:103px; width:202px; height:14px; ">일용근로소득 삭제 및 수정 불가</caption>
			<button id="btn_excel" class="btn2_letter4" style="left:1057px; top:98px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if(fGridStatusCheck())
						{					
							var sTitle = "근로소득 " + model.getValue("/root/send/retrparams/frdd").substr(2, 2) + "-" + model.getValue("/root/send/retrparams/frdd").substr(4, 2) + "-" + model.getValue("/root/send/retrparams/frdd").substr(6, 2) + " ~ " + model.getValue("/root/send/retrparams/todd").substr(2, 2) + "-" + model.getValue("/root/send/retrparams/todd").substr(4, 2) + "-" + model.getValue("/root/send/retrparams/todd").substr(6, 2);							
//							misfSaveExcel(grd_orchlist, sTitle);
							
							radfSaveExcel(grd_orchlist, sTitle);
						}
					]]>
				</script>
			</button>
			<datagrid id="grd_orchlist" nodeset="/root/main/list/orchlist" backcoloralternate="#ffffff" caption="v^기관코드^일련번호^세부일련번호^징수구분^급여반영여부^급여반영일자^귀속년도^지급일자^전표번호^일련번호^전표일자^전표번호^일련번호^급여기관^unit코드^소속unit^사원번호^성명^성명^직종/직급^일수^일급^지급액^세율^주민세^소득세^적  요" colwidth="25, 0, 0, 0, 0, 0, 100, 80, 80, 0, 0, 100, 80, 80, 120, 0, 100, 100, 0, 90, 90, 30, 30, 110, 0, 35, 36, 420" dataheight="25" ellipsis="true" frozencols="9" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:170px; width:1193px; height:589px; ">
				<col checkvalue="Y,N" ref="chk" type="checkbox"/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="seqno" visibility="hidden"/>
				<col ref="detlseqno" visibility="hidden"/>
				<col ref="chrgflag" visibility="hidden"/>
				<col ref="payapplyn" visibility="hidden"/>
				<col ref="payappldd" type="inputdate" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="posyear" type="inputdate" format="yyyy" style="text-align:center; "/>
				<col ref="sanctslipdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="sanctslipno" visibility="hidden" style="text-align:center; "/>
				<col ref="sanctslipseqno" visibility="hidden" style="text-align:center; "/>
				<col ref="unsldd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="unslno" style="text-align:center; "/>
				<col ref="unslseqno" style="text-align:center; "/>
				<col disabled="true" ref="payinst" type="combo">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="dutunitcd" visibility="hidden" style="text-align:center; "/>
				<col ref="dutunitnm" style="text-align:center; "/>
				<col ref="emplno" type="inputbutton" style="text-align:center; "/>
				<col ref="name" type="input"/>
				<col imemode="hangul" ref="emplnm" type="input" style="text-align:left; padding-left:2; "/>
				<col ref="jobnm" style="text-align:center; "/>
				<col ref="dayno" visibility="hidden"/>
				<col ref="dypay" visibility="hidden"/>
				<col ref="paytotamt" type="input" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="taxrate" visibility="hidden"/>
				<col ref="incmtax" visibility="hidden"/>
				<col ref="resdntax" visibility="hidden"/>
				<col ref="cmt" type="input" style="text-align:left; padding-left:2; "/>
				<script type="javascript" ev:event="onbuttonclick">
					<![CDATA[

						if(grd_orchlist.col == grd_orchlist.colRef("emplno"))
						{
							rpbfOpenPopUpList("SPRPB00101", grd_orchlist, "emplno,emplnm,payinst", "", "N");
							model.setValue(grd_orchlist.nodeset + "[" + grd_orchlist.row + "]/name", model.getValue(grd_orchlist.nodeset + "[" + grd_orchlist.row + "]/emplnm"));
						}

						model.refresh();

					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[

						if(grd_orchlist.col == grd_orchlist.colRef("emplno"))
						{
							rpbfValidationCheck("EMPLNO", "emplno,emplnm,payinst");
							model.setValue(grd_orchlist.nodeset + "[" + grd_orchlist.row + "]/name", model.getValue(grd_orchlist.nodeset + "[" + grd_orchlist.row + "]/emplnm"));
						}
						else if(grd_orchlist.col == grd_orchlist.colRef("emplnm"))
						{
							rpbfValidationCheck("EMPLNM", "emplno,emplnm,payinst");
							model.setValue(grd_orchlist.nodeset + "[" + grd_orchlist.row + "]/name", model.getValue(grd_orchlist.nodeset + "[" + grd_orchlist.row + "]/emplnm"));
						}
						
						model.refresh();

					]]>
				</script>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
						if (grd_orchlist.isCell(event.target) && grd_orchlist.row > 0 && grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("unsldd")) != "" && grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("unslno")) != "") {
							model.makeValue("/root/source/slipinfo/instcd", model.getValue("/root/main/list/orchlist["+grd_orchlist.row+"]/instcd"));
							model.makeValue("/root/source/slipinfo/slipdt", model.getValue("/root/main/list/orchlist["+grd_orchlist.row+"]/unsldd"));
							model.makeValue("/root/source/slipinfo/slipno", model.getValue("/root/main/list/orchlist["+grd_orchlist.row+"]/unslno"));
							
//							alert(model.getValue("/root/source/slipinfo/instcd"));
//							alert(model.getValue("/root/source/slipinfo/slipdt"));
//							alert(model.getValue("/root/source/slipinfo/slipno"));
							
							model.refresh();
							modal("SMRAD00100","","","","","/root/source", "/root/target" );
						}	
					
					]]>
				</script>
			</datagrid>
			<output id="output8" ref="/root/send/printparams/payTotAmt" format="(-)#,###" style="left:1037px; top:147px; width:127px; height:19px; text-align:right; margin-right:1; "/>
			<line id="line11" class="line_3" style="x1:1035px; y1:123px; x2:1035px; y2:167px; "/>
			<line id="line13" class="line_3" style="x1:1165px; y1:123px; x2:1165px; y2:167px; "/>
			<caption id="caption18" class="cell_1" style="left:1037px; top:123px; width:127px; height:23px; text-align:center; vertical-align:middle; ">총지급액</caption>
			<caption id="caption19" class="cell_1" style="left:947px; top:145px; width:87px; height:21px; text-align:center; vertical-align:middle; ">계</caption>
			<output id="opt_zipcd" ref="/root/hidden/zipcd/zipcd1" navindex="-1" visibility="hidden" style="left:765px; top:98px; width:20px; height:19px; text-align:left; "/>
			<output id="output2" ref="/root/hidden/checkedcnt" visibility="hidden" style="left:105px; top:130px; width:25px; height:19px; "/>
			<button id="btn_excadd" class="btn2_letter4" visibility="visible" style="left:989px; top:98px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
					
						if(fGridStatusCheck() && fInputExcel(excel_upload))
						{							
							if(fValidCheck())
							{
								fCopyExcelGrid();							
							}
							else
							{
								model.removenode("/root/main/list/orchlist");
							}	
							
						}						

					]]>
				</script>
			</button>
			<datagrid id="grd_orchsumlist" nodeset="/root/main/sumlist/orchsumlist" visibility="hidden" backcoloralternate="#ffffff" caption="급여기관명^unit코드^소속unit^사원번호^성명^지급액" colwidth="100, 100, 100, 100, 100, 100" dataheight="25" ellipsis="true" frozencols="9" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:330px; top:240px; width:528px; height:489px; ">
				<col ref="payinstnm" style="text-align:center; "/>
				<col ref="dutunitcd" style="text-align:center; "/>
				<col ref="dutunitnm" style="text-align:center; "/>
				<col ref="emplno" style="text-align:center; "/>
				<col ref="name"/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
			</datagrid>
			<button id="button1" class="btn2_letter4" style="left:1125px; top:98px; width:64px; height:19px; text-align:left; ">
				<caption>합산출력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if(fGridStatusCheck())
						{					
							var sTitle = "근로소득(개인별 합산) " + model.getValue("/root/send/retrparams/frdd").substr(2, 2) + "-" + model.getValue("/root/send/retrparams/frdd").substr(4, 2) + "-" + model.getValue("/root/send/retrparams/frdd").substr(6, 2) + " ~ " + model.getValue("/root/send/retrparams/todd").substr(2, 2) + "-" + model.getValue("/root/send/retrparams/todd").substr(4, 2) + "-" + model.getValue("/root/send/retrparams/todd").substr(6, 2);	
							misfSaveExcel(grd_orchsumlist, sTitle);
						}
					]]>
				</script>
			</button>
			<datagrid id="excel_upload" nodeset="/root/hidden/exceluploadlist/excelupload" visibility="hidden" backcoloralternate="#ffffff" caption="귀속일자^지급일자^사원번호^이름^지급액^적요" colwidth="100, 100, 100, 100, 100, 100" dataheight="25" ellipsis="true" frozencols="9" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:275px; top:340px; width:660px; height:312px; ">
				<col ref="posyear" format="yyyy-mm-dd" style="text-align:left; padding-left:2; "/>
				<col ref="sanctslipdd" format="yyyy-mm-dd" style="text-align:left; padding-left:2; "/>
				<col ref="emplno" style="text-align:left; "/>
				<col ref="name" style="text-align:left; "/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="cmt" style="text-align:left; padding-left:2; "/>
			</datagrid>
			<button id="button2" class="btn2_letter4" visibility="visible" style="left:921px; top:98px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀양식</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
					
						misfSaveExcel(excel_upload);

					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>