YNU_JEUS/app_home/himed/webapps/mis/slipweb/xrw/SPRAD00104_근로소득자료관리.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>
						<list>
							<orchlist>
								<instcd/>
								<seqno/>
								<detlseqno/>
								<chrgflag/>
								<emplno/>
								<name/>
								<entrregno/>
								<rrgstno/>
								<custnm/>
								<zipcd/>
								<zipcd1/>
								<zipcd2/>
								<zipcdseqno/>
								<supaddr/>
								<infaddr/>
								<induflag/>
								<incmflag/>
								<dayno/>
								<dypay/>
								<paytotamt/>
								<taxrate/>
								<incmtax/>
								<resdntax/>
								<cmt/>
							</orchlist>
							<orch>
								<instcd/>
								<seqno/>
								<chrgflag/>
								<unsldd/>
								<unslno/>
								<undeciseqno/>
								<paydd/>
								<status/>
							</orch>
						</list>
						<orch_one>
							<instcd/>
							<seqno/>
							<detlseqno/>
							<chrgflag/>
							<emplno/>
							<name/>
							<entrregno/>
							<rrgstno/>
							<custnm/>
							<zipcd/>
							<zipcd1/>
							<zipcd2/>
							<zipcdseqno/>
							<supaddr/>
							<infaddr/>
							<induflag/>
							<incmflag/>
							<dayno/>
							<dypay/>
							<paytotamt/>
							<taxrate/>
							<incmtax/>
							<resdntax/>
							<cmt/>
						</orch_one>
					</main>
					<send>
						<retrparams>
							<instcd/>
							<seqno/>
							<chrgflag/>
							<detlseqno/>
						</retrparams>
						<list>
							<orchlist/>
							<orch/>
						</list>
					</send>
					<hidden>
						<incmpsn/>
						<totamt/>
						<maxdetlseqno>0000</maxdetlseqno>
						<orch_one>
							<instcd/>
							<seqno/>
							<detlseqno/>
							<chrgflag/>
							<emplno/>
							<name/>
							<entrregno/>
							<rrgstno/>
							<custnm/>
							<zipcd/>
							<zipcd1/>
							<zipcd2/>
							<zipcdseqno/>
							<supaddr/>
							<infaddr/>
							<induflag/>
							<incmflag/>
							<dayno/>
							<dypay/>
							<paytotamt/>
							<taxrate/>
							<incmtax/>
							<resdntax/>
							<cmt/>
						</orch_one>
						<orchreturn>
							<amt/>
							<etcnotefact/>
							<incmtax/>
							<resdntax/>
						</orchreturn>
					</hidden>
					<init>
					</init>
					<temp>
						<seqno>
							<seqno/>
						</seqno>
						<orchlist/>
					</temp>
					<target/>
				</root>
			</instance>
			<submission id="TRRAD00105" 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>
			<submission id="TXRAD00105" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/list" resultref="/root/temp"/>
			<bind id="bind_amt" ref="/root/hidden/orchreturn/amt" calculate="sum(/root/main/list/orchlist/paytotamt)"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/RAC001.js"/>
		<script type="javascript">
			<![CDATA[
				function fInitialize() {
					
					model.removenode("/root/main/list/orchlist");
					var instcd = getUserInfo("dutplceinstcd");
					
					if (model.getValue("/root/target/slipinfo/profflag") == "8") {
						document.title = "비과세 근로소득자료관리";
						cpt_title.text = "비과세 근로소득자료관리";
					}
					
					if (model.getValue("/root/target/slipinfo/seqno") != "") {
						model.setValue("/root/send/retrparams/instcd",     model.getValue("/root/target/slipinfo/instcd"));
						model.setValue("/root/send/retrparams/seqno",      model.getValue("/root/target/slipinfo/seqno"));
						model.setValue("/root/send/retrparams/chrgflag",     model.getValue("/root/target/slipinfo/profflag"));
						model.refresh();
						fSearch();
					} else {
						model.setValue("/root/main/list/orch/instcd",      model.getValue("/root/target/slipinfo/instcd"));
						model.setValue("/root/main/list/orch/unsldd",      model.getValue("/root/target/slipinfo/unsldd"));
						model.setValue("/root/main/list/orch/unslno",      model.getValue("/root/target/slipinfo/unslno"));
						model.setValue("/root/main/list/orch/undeciseqno", model.getValue("/root/target/slipinfo/unslseqno"));
						model.setValue("/root/main/list/orch/chrgflag",    model.getValue("/root/target/slipinfo/profflag"));
						model.setValue("/root/main/orch_one/instcd",      model.getValue("/root/target/slipinfo/instcd"));
						model.setValue("/root/main/orch_one/chrgflag",    model.getValue("/root/target/slipinfo/profflag"));
						model.setValue("/root/main/orch_one/detlseqno", "0001");
						
						model.setValue("/root/hidden/maxdetlseqno", "0000");
						model.setValue("/root/main/list/orch/status",  "i");
						
						model.setValue("/root/main/orch_one/emplno", model.getValue("/root/target/slipinfo/emplno"));
						ipt_emplno.refresh();
						ipt_emplno.dispatch("xforms-value-changed");		
						
						model.makeValue("/root/main/orch_one/cmt", model.getValue("/root/target/slipinfo/cmt"));
					}
					
					
					
					model.refresh();
					
					if (model.getValue("/root/target/slipinfo/readonly") == "Y") {
						btn_grdadd.disabled = true;
						btn_save.disabled = true;
						btn_delete.disabled = true;
					}					
					
					model.setFocus("ipt_name");
				}
				
				function fSearch() {
					submit("TRRAD00105");
					if(instance1.selectNodes("/root/main/list/orchlist").length == 0)
					{
						model.makeValue("/root/main/list/orch/instcd",      model.getValue("/root/target/slipinfo/instcd"));
						model.makeValue("/root/main/list/orch/unsldd",      model.getValue("/root/target/slipinfo/unsldd"));
						model.makeValue("/root/main/list/orch/unslno",      model.getValue("/root/target/slipinfo/unslno"));
						model.makeValue("/root/main/list/orch/undeciseqno", model.getValue("/root/target/slipinfo/unslseqno"));
						model.makeValue("/root/main/list/orch/chrgflag",    model.getValue("/root/target/slipinfo/profflag"));
						model.makeValue("/root/main/list/orch/status",  "i");
						model.setValue("/root/main/orch_one/instcd",      model.getValue("/root/target/slipinfo/instcd"));
						model.setValue("/root/main/orch_one/chrgflag",    model.getValue("/root/target/slipinfo/profflag"));
						model.setValue("/root/main/orch_one/detlseqno", "0001");
						model.setValue("/root/hidden/maxdetlseqno", "0000");
					}
					else
					{
						var rowCnt = grd_orchlist.rows - 1;

						model.setValue("/root/hidden/maxdetlseqno",model.getValue("/root/main/list/orchlist["+ rowCnt +"]/detlseqno"));
						model.setValue("/root/main/list/orch/status",  "u");
						fIncreSeqno("/root/main/orch_one/detlseqno");
						model.setValue("/root/main/orch_one/instcd", model.getValue("/root/main/list/orch/instcd"));
						model.setValue("/root/main/orch_one/seqno", model.getValue("/root/main/list/orch/seqno"));
						model.setValue("/root/main/orch_one/chrgflag", model.getValue("/root/main/list/orch/chrgflag"));
					}
					model.refresh();
				}

				function fSave() {
					var updtdata = getGridUpdateData(grd_orchlist);
					if (updtdata == "") {
						messageBox("변경된 데이터가","I004");
						return;
					}
					
					model.setValue("/root/send/list/orchlist", grd_orchlist.getUpdateData());
					model.copyNode("/root/send/list/orch", "/root/main/list/orch");
					if (submit("TXRAD00105")) {
						model.setValue("/root/send/list/orchlist","");
						if (model.getValue("/root/temp/seqno/seqno") != "") {
							model.setValue("/root/send/retrparams/instcd",     model.getValue("/root/main/list/orch/instcd"));
							model.setValue("/root/send/retrparams/seqno",      model.getValue("/root/temp/seqno/seqno"));
							model.setValue("/root/send/retrparams/chrgflag",     model.getValue("/root/main/list/orch/chrgflag"));
							model.refresh();
							fSearch();
						} else {
							model.removeNodeset("/root/main/list/orchlist");
							
							model.setValue("/root/main/list/orch/instcd",      model.getValue("/root/target/slipinfo/instcd"));
							model.setValue("/root/main/list/orch/seqno",       "");
							model.setValue("/root/main/list/orch/unsldd",      model.getValue("/root/target/slipinfo/unsldd"));
							model.setValue("/root/main/list/orch/unslno",      model.getValue("/root/target/slipinfo/unslno"));
							model.setValue("/root/main/list/orch/undeciseqno", model.getValue("/root/target/slipinfo/unslseqno"));
							model.setValue("/root/main/list/orch/chrgflag",    model.getValue("/root/target/slipinfo/profflag"));
							model.setValue("/root/main/list/orch/status",  "i");
							model.setValue("/root/hidden/maxdetlseqno", "0000");
							fRowClearClick();
						}
						
						var rowcnt = grd_orchlist.rows - 1;
						
						if (rowcnt > 0) {
							if (rowcnt > 1) {
								var cmt = model.getValue("/root/main/list/orchlist[1]/cmt") + " (" + model.getValue("/root/main/list/orchlist[1]/name") + " 외 " + (rowcnt - 1) + "명)";
								model.setValue("/root/hidden/orchreturn/etcnotefact", cmt);
							} else {
								model.setValue("/root/hidden/orchreturn/etcnotefact", model.getValue("/root/main/list/orchlist[1]/cmt"));
							}
						} else {
							model.setValue("/root/hidden/orchreturn/etcnotefact", "");
						}
						model.refresh();
						
						var receiveref = model.getValue("/root/target/receiveref");
						if (checkOpener())
						{
						    opener.model.setValue(receiveref + "/seqno", model.getValue("/root/temp/seqno/seqno"));
						    opener.model.setValue(receiveref + "/amt", model.getValue("/root/hidden/orchreturn/amt"));
						    opener.model.setValue(receiveref + "/etcnotefact", model.getValue("/root/hidden/orchreturn/etcnotefact"));
						    opener.model.setValue(receiveref + "/incmtax", model.getValue("/root/hidden/orchreturn/incmtax"));
						    opener.model.setValue(receiveref + "/resdntax", model.getValue("/root/hidden/orchreturn/resdntax"));
						    messageBox("저장이 " ,"I002");
						}
						else
						{
						    messagebox("상위화면이 변경되어 데이터를 전달할 수 ", "I004");
						}						
					}
					model.setFocus("ipt_name");
				}

				function fDelete() {
					if (messageBox("전체 내역을","Q001") == "6") {
						var rowCnt = grd_orchlist.rows;
						for (i=1; i<rowCnt; i++) {							
							grd_orchlist.addStatus(i,"delete");
						}
						model.setValue("/root/main/list/orch/status","d");
						model.refresh();
						fSave();						
					}
				}
				
				//========================================================================================
				//not null check
				//========================================================================================
				function fNotNullCheck() {
					if(model.getValue("/root/main/orch_one/emplno").length== 0)
					{
						messageBox("사원번호는" ,"I003");
						model.setFocus("ipt_emplno");
						return false;
					}
					
					if(model.getValue("/root/main/orch_one/name").length== 0 )
					{
						messageBox("성명은" ,"I003");
						model.setFocus("ipt_name");
						return false;
					}
					
					if(model.getValue("/root/main/orch_one/paytotamt").length== 0 )
					{
						messageBox("지급액은" ,"I003");
						model.setFocus("ipt_paytotamt");
						return false;
					}
				}
				
				function fGridRowAddClick() {
					var detlseq = model.getValue("/root/main/orch_one/detlseqno");
					var detlseqno = model.getValue("/root/main/list/orchlist[detlseqno='"+ detlseq +"']/detlseqno");
					var cur_row = grd_orchlist.row;
					
					if(fNotNullCheck() == false) {
						return;
					}
					
					if (detlseqno == "") {
						grd_orchlist.addRow(false);
					} else {
						grd_orchlist.addStatus(cur_row,"update");
					}
					
					model.copyNode("/root/main/list/orchlist["+grd_orchlist.row+"]","/root/main/orch_one");
					
					var maxdetlseqno = model.getValue("/root/hidden/maxdetlseqno");
					if (parseInt(maxdetlseqno,10) < parseInt(detlseq,10)) {
						model.setValue("/root/hidden/maxdetlseqno", detlseq);
					}
					fRowClearClick();  //행정리
				}
				
				function fGridRowDelClick() {
					var rowstat;
					var i, j=0;
					//grd_orchlist.addStatus(grd_orchlist.row,"delete");
					misfGridIUD(grd_orchlist, "D");
					
					for (i=1; i<grd_orchlist.rows; i++) {
						rowstat = parseInt(grd_orchlist.rowStatus(i),10);
						if (rowstat >= 4) {
							j++;
						}
					}
					
					if (j == grd_orchlist.rows - 1) {
						model.setValue("/root/main/list/orch/status","d");
					} else {
						model.setValue("/root/main/list/orch/status","u");
					}
					model.refresh();
					
					fRowClearClick();
				}
				
				function fGridRowClick() {
					var cur_row = grd_orchlist.row;
					
					model.removenode("/root/main/orch_one");
					model.makeNode("/root/main/orch_one");
					model.copyNode("/root/main/orch_one","/root/main/list/orchlist["+cur_row+"]");
					model.recalculate();
					model.refresh();
					
					btn_grddel.disabled = false;
					model.setFocus("ipt_paytotamt");
				}
				
				function fRowClearClick() {
					var cmt = model.getValue("/root/main/orch_one/cmt");
					model.removenode("/root/main/orch_one");
					model.makeNode("/root/main/orch_one");
					model.copyNode("/root/main/orch_one","/root/hidden/orch_one");
					
					fIncreSeqno("/root/main/orch_one/detlseqno");
					model.setValue("/root/main/orch_one/instcd", model.getValue("/root/main/list/orch/instcd"));
					model.setValue("/root/main/orch_one/seqno", model.getValue("/root/main/list/orch/seqno"));
					model.setValue("/root/main/orch_one/chrgflag", model.getValue("/root/main/list/orch/chrgflag"));
					model.setValue("/root/main/orch_one/cmt", cmt);
					model.recalculate();
					model.refresh();
					
					btn_grddel.disabled = true;
					model.setFocus("ipt_name");
				}
				
				//========================================================================================
				//행번 증가
				//========================================================================================
				function fIncreSeqno(pRef) {
					var detlseqno = model.getValue("/root/hidden/maxdetlseqno");
					var seqno = parseInt(detlseqno, 10);
					
					seqno++;
					model.setValue(pRef, seqno.toString().getLeftPad(4,"0"));
				}
				
				//========================================================================================
				//엑셀입력(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.refresh();
					}
				}
				
				function fExcelGetfSeqno()
				{
					var detlseqno = model.getValue("/root/hidden/maxdetlseqno");
					var seqno = parseInt(detlseqno, 10);
			
					seqno++;
					model.setValue("/root/hidden/maxdetlseqno", seqno.toString().getLeftPad(4,"0"));						
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body pagewidth="800" pageheight="600" style="margin-left:8; margin-top:8; margin-right:8; margin-bottom:8; ">
		<group id="group1" style="left:0px; top:0px; width:765px; height:13px; ">
			<caption id="cpt_title" class="tit_1" style="left:0px; top:0px; width:190px; height:14px; ">근로소득자료관리</caption>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:12px; width:765px; height:548px; ">
			<line id="line4" class="line_2" style="x1:0px; y1:61px; x2:543px; y2:61px; "/>
			<line id="line3" class="line_2" style="x1:0px; y1:36px; x2:765px; y2:36px; "/>
			<line id="line9" class="line_3" style="x1:0px; y1:85px; x2:765px; y2:85px; "/>
			<caption id="caption47" class="cell_1" style="left:0px; top:14px; width:100px; height:23px; vertical-align:middle; ">사원번호</caption>
			<line id="line2" class="line_1" style="x1:0px; y1:9px; x2:765px; y2:9px; "/>
			<caption id="caption7" class="cell_1" style="left:0px; top:63px; width:100px; height:23px; vertical-align:middle; ">적요</caption>
			<caption id="caption10" class="cell_1" style="left:0px; top:38px; width:100px; height:23px; vertical-align:middle; ">지급액</caption>
			<caption id="caption13" class="cell_1" visibility="hidden" style="left:491px; top:14px; width:100px; height:23px; vertical-align:middle; ">지급일자</caption>
			<input id="ipt_paytotamt" ref="/root/main/orch_one/paytotamt" class="input_s_essential" navindex="2" format="(-)#,###" style="left:103px; top:39px; width:150px; height:19px; text-align:right; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
						if (event.keyCode == "13") {
							model.setFocus("ipt_cmt");
						}		
					]]>
				</script>
			</input>
			<input id="ipt_cmt" ref="/root/main/orch_one/cmt" class="input_default" navindex="3" style="left:103px; top:64px; width:662px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
						if (event.keyCode == "13") {
							model.setFocus("btn_grdadd");
						}		
					]]>
				</script>
			</input>
			<line id="line10" class="line_2" style="x1:0px; y1:61px; x2:765px; y2:61px; "/>
			<input id="ipt_paydd" ref="/root/main/list/orch/paydd" class="input_default" disabled="true" navindex="-1" visibility="hidden" style="left:594px; top:15px; width:171px; height:19px; text-align:center; "/>
			<datagrid id="grd_orchlist" nodeset="/root/main/list/orchlist" caption="기관코드^일련번호^세부일련번호^징수구분^사원번호^주민등록번호^성명^사업자등록번호^상호^일용근로일수^일용근로일급^지급액^세율^소득세^주민세^비고^우편번호^우편번호1^우편번호2^우편번호일련번호^주소^상세주소^업종구분^소득구분" colwidth="0, 0, 0, 0, 97, 0, 91, 0, 0, 0, 0, 106, 0, 0, 0, 449, 0, 0, 0, 0, 0, 0, 0, 0" dataheight="25" ellipsis="true" extendlastcol="scroll" frozencols="9" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:114px; width:765px; height:409px; ">
				<col ref="instcd" visibility="hidden"/>
				<col ref="seqno" visibility="hidden"/>
				<col ref="detlseqno" visibility="hidden"/>
				<col ref="chrgflag" visibility="hidden"/>
				<col ref="emplno"/>
				<col ref="rrgstno" visibility="hidden" format="999999-9999999"/>
				<col ref="name"/>
				<col ref="entrregno" visibility="hidden" format="999-99-99999"/>
				<col ref="custnm" visibility="hidden"/>
				<col ref="dayno" visibility="hidden"/>
				<col ref="dypay" visibility="hidden"/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="taxrate" visibility="hidden"/>
				<col ref="incmtax" visibility="hidden" format="(-)#,###" style="text-align:right; "/>
				<col ref="resdntax" visibility="hidden" format="(-)#,###" style="text-align:right; "/>
				<col ref="cmt"/>
				<col ref="zipcd" visibility="hidden"/>
				<col ref="zipcd1" visibility="hidden"/>
				<col ref="zipcd2" visibility="hidden"/>
				<col ref="zipcdseqno" visibility="hidden"/>
				<col ref="supaddr" visibility="hidden"/>
				<col ref="infaddr" visibility="hidden"/>
				<col disabled="true" ref="induflag" type="combo" visibility="hidden">
					<choices>
						<itemset nodeset="/root/init/R0278list/R0278">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</col>
				<col ref="incmflag" type="combo" visibility="hidden">
					<choices>
						<itemset nodeset="/root/init/R0279list/R0279">
							<label ref="cdnm"/>
							<value ref="cdid"/>
						</itemset>
					</choices>
				</col>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						if(grd_orchlist.isCell(event.target) && grd_orchlist.row >= grd_orchlist.fixedRows) {
					   		fGridRowClick();
						}		
					]]>
				</script>
			</datagrid>
			<input id="input1" ref="/root/main/list/orch/instcd" class="input_s_essential" visibility="hidden" style="left:185px; top:90px; width:30px; height:19px; "/>
			<input id="input2" ref="/root/main/list/orch/seqno" class="input_s_essential" visibility="hidden" style="left:220px; top:90px; width:30px; height:19px; "/>
			<input id="input3" ref="/root/main/list/orch/chrgflag" class="input_s_essential" visibility="hidden" style="left:255px; top:90px; width:30px; height:19px; "/>
			<input id="input4" ref="/root/main/list/orch/unsldd" class="input_s_essential" visibility="hidden" style="left:290px; top:90px; width:30px; height:19px; "/>
			<input id="input5" ref="/root/main/list/orch/unslno" class="input_s_essential" visibility="hidden" style="left:325px; top:90px; width:30px; height:19px; "/>
			<input id="input6" ref="/root/main/list/orch/undeciseqno" class="input_s_essential" visibility="hidden" style="left:360px; top:90px; width:30px; height:19px; "/>
			<input id="ipt_taxrate" ref="/root/main/orch_one/taxrate" class="input_default" navindex="-1" visibility="hidden" maxlength="10" format="(-)#,###%" style="left:396px; top:91px; width:54px; height:19px; text-align:right; "/>
			<button id="btn_grddel" class="btn2_letter3" disabled="true" navindex="-1" style="left:712px; top:91px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fGridRowDelClick();
					]]>
				</script>
			</button>
			<button id="btn_grdadd" class="btn2_letter3" navindex="4" style="left:657px; top:91px; width:53px; height:19px; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fGridRowAddClick();	
					]]>
				</script>
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
						if (event.keyCode == "13") {
							model.setFocus("btn_save");
						}		
					]]>
				</script>
			</button>
			<output id="output1" ref="/root/hidden/orchreturn/amt" navindex="-1" format="(-)#,###" style="left:654px; top:526px; width:110px; height:19px; text-align:right; "/>
			<caption id="caption15" style="left:593px; top:526px; width:60px; height:20px; ">지급합액 :</caption>
			<input id="ipt_name" ref="/root/main/orch_one/name" class="input_essential" navindex="1" style="left:225px; top:15px; width:225px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[

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

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

						misfValidationCheck("49", "", "emplno,name","","","name","");
						model.refresh();

					]]>
				</script>
			</input>
			<button id="btn_userhelp" class="icon_search" navindex="-1" style="left:205px; top:16px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						misfOpenPopUpList("49", ipt_paytotamt, "", "emplno,name");
						model.refresh();
						if(event.keyCode == 13)
						{
							model.setFocus("ipt_paytotamt");
						}

					]]>
				</script>
			</button>
			<input id="ipt_emplno" ref="/root/main/orch_one/emplno" class="input_essential" style="left:103px; top:15px; width:97px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[

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

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

						misfValidationCheck("49", "", "emplno,name", "", "", "code","");
						model.refresh();

					]]>
				</script>
			</input>
			<button id="btn_excadd" class="btn2_letter4" style="left:585px; top:91px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
					
//					model.removenode(grd_orchlist.nodeset);
//					grd_orchlist.clearStatus();
					
						var grd_orchlist_rows = grd_orchlist.rows
						for(var i = grd_orchlist.fixedRows ; i < grd_orchlist_rows;  i++)
						{
							grd_orchlist.deleteRow(grd_orchlist.fixedRows, false);
						}
						//alert("01");
						
						var bfrows = grd_excelload.rows;
	
						fInputExcel(grd_excelload);
						
						if(grd_excelload.rows == bfrows)
						{
							return;
						}										
	//alert("02");
						var rowlevel = 1;
						var grd_excelload_fixedRows = grd_excelload.fixedRows;
						var grd_excelload_rows = grd_excelload.rows;
						
						//유효한 값을 가지고 있지 않으면 입력되지 않는다.
						//어느 위치든 공백컬럼을 포함하는 row는 입력이 무시되고 다음 라인을 입력하게 된다.(공백값을 포함하는 row는 삭제된다.)
						//alert("0");
						for( i = grd_excelload_fixedRows ; i < grd_excelload_rows ; i++)
						{					
							var valflag = true;
							
							
									
							if(grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("emplno")) == '' || grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("emplno")) == null)
							{	
								//messageBox("사번이" ,"I004");
								//return;
								//alert("0");
								valflag = false;
							}
							if(grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("name")) == '' || grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("name")) == null)
							{
								//messageBox("이름이" ,"I004");
								//return;
								//alert("0");
								valflag = false;
							}							
							if(grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("paytotamt")) == '' || grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("paytotamt")) == null)
							{
								//messageBox("지급액이" ,"I004");
								//return;
								//alert("0");
								valflag = false;
							}
							if(grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("cmt")) == '' || grd_excelload.valueMatrix( rowlevel, grd_excelload.colRef("cmt")) == null)
							{
								//messageBox("비고가" ,"I004");
								//return;
							//	alert("0");
							//	valflag = false;
							}						
							if(valflag == false)
							{
								grd_excelload.deleteRow(rowlevel, false);
							}
							else
							{
								rowlevel += 1;
							}
							
						}
						model.setValue("/root/hidden/maxdetlseqno", "0001");
						
						for(var i=1 ; i < grd_excelload.rows;  i++)
						{							
							misfGridIUD(grd_orchlist, "A", "N")
														
							model.setValue(grd_orchlist.nodeset + "[" + i + "]/instcd",		model.getValue("/root/main/orch_one/instcd"))
							model.setValue(grd_orchlist.nodeset + "[" + i + "]/detlseqno",	model.getValue("/root/hidden/maxdetlseqno"))
							model.setValue(grd_orchlist.nodeset + "[" + i + "]/chrgflag",	model.getValue("/root/main/orch_one/chrgflag"))
				
							model.setValue(grd_orchlist.nodeset + "[" + i + "]/emplno",	model.getValue(grd_excelload.nodeset + "[" + i + "]/emplno"))
							model.setValue(grd_orchlist.nodeset + "[" + i + "]/name", 		model.getValue(grd_excelload.nodeset + "[" + i + "]/name"))
							model.setValue(grd_orchlist.nodeset + "[" + i + "]/paytotamt",    model.getValue(grd_excelload.nodeset + "[" + i + "]/paytotamt"))
							model.setValue(grd_orchlist.nodeset + "[" + i + "]/cmt", 		model.getValue(grd_excelload.nodeset + "[" + i + "]/cmt"))								
							fExcelGetfSeqno();
						}
						
						model.setValue("/root/main/orch_one/detlseqno", model.getValue("/root/hidden/maxdetlseqno"));
						
						var grd_excelload_rows = grd_excelload.rows
						for(var i = grd_excelload.fixedRows ; i < grd_excelload_rows;  i++)
						{
							grd_excelload.deleteRow(grd_excelload.fixedRows, false);
						}
						
						
						
						//grd_orchlist.row = grd_orchlist.rows-1;
						//btn_grdadd.dispatch("DOMActivate");
						
						
					]]>
				</script>
			</button>
			<datagrid id="grd_excelload" nodeset="/root/temp/orchlist" visibility="hidden" caption="사원번호^성명^지급액^비고" colwidth="150, 150, 150, 100" dataheight="25" ellipsis="true" extendlastcol="scroll" frozencols="9" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:200px; top:275px; width:560px; height:138px; ">
				<col ref="emplno"/>
				<col ref="name"/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="cmt"/>
			</datagrid>
			<button id="button2" class="btn2_letter4" visibility="visible" style="left:516px; top:91px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀양식</caption>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
					
						misfSaveExcel(grd_excelload);

					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:562px; width:765px; height:27px; ">
			<line id="line1" class="line_6" style="x1:0px; y1:0px; x2:765px; y2:0px; "/>
			<button id="btn_save" class="btn4_letter2" navindex="5" style="left:592px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[						
						if (event.keyCode == "13") 
						{
							fSave();
							model.setFocus("btn_close");
						}		
					]]>
				</script>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						fSave();
					]]>
				</script>
			</button>
			<button id="btn_delete" class="btn4_letter2" navindex="7" style="left:650px; top:3px; width:56px; height:22px; ">
				<caption>삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

						fDelete();

					]]>
				</script>
			</button>
			<button id="btn_close" class="btn4_letter2" navindex="6" style="left:708px; top:3px; width:56px; height:22px; ">
				<caption>닫기</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
//						var receiveref = model.getValue("/root/target/receiveref");
//						if (checkOpener())
//						{
//						    opener.model.setValue(receiveref + "/seqno", model.getValue("/root/main/list/orch/seqno"));
//						    opener.model.setValue(receiveref + "/amt", model.getValue("/root/hidden/orchreturn/amt"));
//						}
//						else
//						{
//						    messagebox("상위화면이 변경되어 데이터를 전달할 수 ", "I004");
//						}
						window.close();		
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>