YNU_JEUS/app_home/himed/webapps/mis/addtaxweb/xrw/SMRAT01000_퇴직소득조회및저장.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/>
						</list>
					</main>
					<send>
						<retrparams>
							<instcd/>
							<frdd/>
							<todd/>
							<emplno/>
							<name/>
						</retrparams>
					</send>
					<init/>
					<temp/>
					<hidden>
						<prntlist>
							<retrprofprntlist/>
						</prntlist>
						<list>
							<orchlist/>
						</list>
						<orchreturn/>
						<sumvalue>
							<retiresumamt/>
							<incmsumtax/>
							<resdnsumtax/>
							<paysumtax/>
							<paytotsumamt/>
							<totcount/>
						</sumvalue>
					</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)"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
				]]>
			</script>
			<script type="javascript">
				<![CDATA[

					function fInitialize()
					{
						model.removenode("/root/main/list/orchlist");						
						misfComboComCdList("Z0007", cmb_instcd);
						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.refresh();
					}

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

						submit("TRRAT01001");

						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";
							}
							else
							{
								grd_orchlist.rowStyle(i, "all", "background-color") = "#ffffff";
							}
						}
						model.recalculate();
					}


					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/retrprofprntlist").length;

									model.makeNode("/root/hidden/prntlist/retrprofprntlist[" + (iCnt + 1) + "]");
									model.copyNode("/root/hidden/prntlist/retrprofprntlist[" + (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/retrprofprntlist[" + i + "]");
								model.copyNode("/root/hidden/prntlist/retrprofprntlist[" + i + "]", "/root/main/list/orchlist[" + i + "]");
							}
						}

						if(model.instance1.selectNodes("/root/hidden/prntlist/retrprofprntlist").length == 0) return false;

						exeReportPreview("RPRAD00301", "XMLSTR");
					}
					
					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;
					}
					
					//========================================================================================
					//엑셀입력(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 fCalcsumvalue()
					{
						var vRetiresumamt = 0;
						var vIncmsumtax = 0;
						var vResdnsumtax = 0;
						var vPaysumtax = 0;
						var vPaytotsumamt = 0; 
						var vTotcount = 0;
						
						for(i = grd_orchlist.fixedRows ; i < grd_orchlist.rows ; i++)
						{
							vTotcount ++;
							vRetiresumamt 	= vRetiresumamt + parseFloat(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("retireamt"))) + parseFloat(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("earlyretramt")));
							vIncmsumtax 	= vIncmsumtax + parseFloat(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("calcincmtax")));
							vResdnsumtax 	= vResdnsumtax + parseFloat(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("calcresdntax")));
							vPaysumtax 	= vPaysumtax + parseFloat(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("paytax")));	
							vPaytotsumamt = vPaytotsumamt + parseFloat(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("paytotamt")));							
						}
						
						model.setValue("/root/hidden/sumvalue/retiresumamt", 	vRetiresumamt);
						model.setValue("/root/hidden/sumvalue/incmsumtax", 	vIncmsumtax);
						model.setValue("/root/hidden/sumvalue/resdnsumtax", 	vResdnsumtax);
						model.setValue("/root/hidden/sumvalue/paysumtax", 	vPaysumtax);
						model.setValue("/root/hidden/sumvalue/paytotsumamt", 	vPaytotsumamt);
						model.setValue("/root/hidden/sumvalue/totcount", 		vTotcount);			
						
						otp_totcount.refresh();
						otp_retiresumamt.refresh();
						otp_incmsumtax.refresh();
						otp_resdnsumtax.refresh();
						otp_paysumtax.refresh();
						otp_paytotsumamt.refresh();
					}
				
				]]>
			</script>
			<bind id="bindChkCnt" ref="/root/hidden/checkedcnt" calculate="count(/root/main/list/orchlist[chk = 'Y']/chk)"/>
			<submission id="TRRAT01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retrparams" resultref="/root/main/list"/>
			<submission id="TXRAT01001" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/hidden/list/orchlist" 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:35px; vertical-align:top; ">
				<shape id="roundrect1" class="roundrect_search" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
				<line id="line5" class="line_4" style="x1:1107px; y1:6px; x2:1107px; y2:29px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="caption1" class="search_name" style="left:270px; 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:360px; top:8px; width:95px; height:19px; text-align:center; "/>
				<caption id="caption2" style="left:457px; 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:7px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

							fRetrieve();
							
							fCalcsumvalue();

						]]>
					</script>
				</button>
				<input id="ipt_todd" ref="/root/send/retrparams/todd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:470px; top:8px; width:95px; height:19px; text-align:center; "/>
				<caption id="caption8" class="search_name" style="left:599px; top:9px; width:90px; height:17px; ">소 득 자 :</caption>
				<button id="btn_userhelp" class="icon_search" navindex="-1" style="left:790px; top:9px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[

						misfOpenPopUpList("49", ipt_emplno, "", "emplno,name");
						model.refresh();
						

					]]>
					</script>
				</button>
				<input id="ipt_name" ref="/root/send/retrparams/name" class="input_essential" navindex="1" style="left:810px; top:8px; width:225px; 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[

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

					]]>
					</script>
				</input>
				<input id="ipt_emplno" ref="/root/send/retrparams/emplno" class="input_essential" style="left:688px; top:8px; width:97px; 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[

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

					]]>
					</script>
				</input>
			</group>
			<line id="line3" class="line_1" style="x1:0px; y1:93px; x2:1195px; y2:93px; "/>
			<caption id="caption21" class="tit_2" style="left:5px; top:78px; width:139px; height:14px; ">퇴직소득자 목록</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[
							model.makeValue("/root/source/slipinfo/openflag",  		"extra");
							model.makeValue("/root/source/slipinfo/instcd",    		model.getValue("/root/send/retrparams/instcd"));
							model.makeValue("/root/source/slipinfo/seqno",    		"");
							model.makeValue("/root/source/slipinfo/profflag",    	"9");
							model.makeValue("/root/source/receiveref", "/root/hidden/orchreturn");								
							modal("SPRAD00140","","","","","/root/source", "/root/target", "resize:false" );	
						]]>
					</script>
				</button>
				<button id="btn_print" class="btn4_letter2" style="left:5px; top:3px; width:56px; height:22px; ">
					<caption>출력</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fPrint();
						]]>
					</script>
				</button>
				<button id="button3" class="btn4_letter4" style="left:995px; top:3px; width:80px; height:22px; ">
					<caption>파일생성</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							model.setValue(ipt_emplno.attribute("ref"), "");
							model.setValue(ipt_name.attribute("ref"), "");	
	
							var instcd = model.getValue("/root/send/retrparams/instcd");									
						  												
							model.makeValue("/root/source/reportfile/instcd", 		instcd);
							model.makeValue("/root/source/reportfile/frdd", 		ipt_frdd.value);
							model.makeValue("/root/source/reportfile/todd", 		ipt_todd.value);
							model.makeValue("/root/source/reportfile/jobflag", 		"retr");							
							model.refresh();
							
							modal("SPRAT01000","","","","","/root/source", "/root/target" );
							model.refresh();
						]]>
					</script>
				</button>
				<button id="button5" class="btn4_letter2" style="left:1078px; top:3px; width:56px; height:22px; ">
					<caption>저장</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[						
							model.setValue("/root/hidden/list/orchlist", grd_orchlist.getUpdateData());
							
							submit("TXRAT01001");
							
							fRetrieve();
						]]>
					</script>
				</button>
			</group>
			<caption id="caption10" style="left:180px; top:77px; width:15px; height:15px; background-color:#c0c0c0; "/>
			<caption id="caption11" style="left:198px; top:78px; width:202px; height:14px; ">퇴직근로소득 삭제 및 수정 불가</caption>
			<button id="btn_excel" class="btn2_letter4" style="left:1127px; top:73px; 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);
						}
					]]>
				</script>
			</button>
			<datagrid id="grd_orchlist" nodeset="/root/main/list/orchlist" backcoloralternate="#ffffff" caption="v^기관코드^일련번호^세부일련번호^미결전표정보^지급일^징수구분^신고구분^사번^퇴직구분^주민등록번호^이름^시작일^종료일^결재전표정보^근속월수^근속년수^퇴직급여액^명예퇴직수당^퇴직소득공제^근속년수별공제^퇴직소득공제합^과세표준^연평균과세표준^연평균산출세액^산출세액^세액공제^결정세액^기납부세액^소득세(절사전)^주민세(절사전)^소득세^주민세^납부세액^총지급액^비고^기표여부" colwidth="25, 0, 0, 0, 150, 100, 100, 60, 100, 100, 100, 80, 80, 80, 80, 150, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0" dataheight="25" ellipsis="true" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:0px; top:145px; width:1193px; height:617px; ">
				<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="unslinfo" format="99999999-9999-999" style="text-align:center; "/>
				<col ref="paydd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="chrgflag" visibility="hidden"/>
				<col checkvalue="Y,N" ref="reptyn" type="checkbox"/>
				<col ref="emplno" style="text-align:center; "/>
				<col ref="retrflag" type="combo" style="text-align:center; ">
					<choices>
						<item>
							<label>정년퇴직</label>
							<value>1</value>
						</item>
						<item>
							<label>정리해고</label>
							<value>2</value>
						</item>
						<item>
							<label>자발적퇴직</label>
							<value>3</value>
						</item>
						<item>
							<label>임원퇴직</label>
							<value>4</value>
						</item>
						<item>
							<label>중간정산</label>
							<value>5</value>
						</item>
						<item>
							<label>기타</label>
							<value>6</value>
						</item>
					</choices>
				</col>
				<col ref="rrgstno" format="999999-9999999" style="text-align:center; "/>
				<col ref="name" style="text-align:center; "/>
				<col ref="fromdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="todd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="sanctinfo" visibility="hidden" format="99999999-9999-999" style="text-align:center; "/>
				<col ref="servedmonths" style="text-align:center; "/>
				<col ref="servedyears" style="text-align:center; "/>
				<col ref="retireamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="earlyretramt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="deductamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="yearsdeductamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="sumretrdeductamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="taxstandard" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="avetaxstandard" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="avecalctax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="calctax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="taxdeduct" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="determtax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="paymenttax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="incmtax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="resdntax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="calcincmtax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="calcresdntax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="paytax" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; padding-right:2; "/>
				<col ref="cmt"/>
				<col ref="slipyn" visibility="hidden"/>
				<col ref="deployeeentrregno" visibility="hidden"/>
				<col ref="deployeecustnm" visibility="hidden"/>
				<col ref="deployeeprsdnm" visibility="hidden"/>
				<col ref="supaddr" visibility="hidden"/>
				<col ref="infaddr" visibility="hidden"/>
				<col ref="deployeeaddress" visibility="hidden"/>
				<col ref="deployeerrgstno" visibility="hidden"/>
				<col ref="resdnrgstareazipcd" visibility="hidden"/>
				<col ref="residnczipcd" visibility="hidden"/>
				<col ref="residncaddr" visibility="hidden"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[

					if(grd_orchlist.isCell(event.target) && grd_orchlist.row >= grd_orchlist.fixedRows && grd_orchlist.rowStatus(grd_orchlist.row) == 0)
					{
						if(grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("unslinfo")) == "")
						{
							model.makeValue("/root/source/slipinfo/openflag",  		"modify");
							model.makeValue("/root/source/slipinfo/instcd",    		grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("instcd")));
							model.makeValue("/root/source/slipinfo/seqno",     		grd_orchlist.valueMatrix(grd_orchlist.row, grd_orchlist.colRef("seqno")));
							model.makeValue("/root/source/slipinfo/profflag",    	"9");
							//model.makeValue("/root/source/receiveref", "/root/hidden/orchreturn");
							modal("SPRAD00140","","","","","/root/source", "/root/target", "resize:false" );
						}
						else
						{
							model.makeValue("/root/source/slipinfo/instcd", model.getValue("/root/main/list/orchlist["+grd_orchlist.row+"]/instcd"));
							var unslinfo = model.getValue("/root/main/list/orchlist["+grd_orchlist.row+"]/unslinfo");
							
							model.makeValue("/root/source/slipinfo/slipdt", unslinfo.substr(0,8));
							model.makeValue("/root/source/slipinfo/slipno", unslinfo.substr(8,4));
							model.refresh();
							modal("SMRAD00100","","","","","/root/source", "/root/target" );
						}

						fRetrieve();

					}	

					]]>
				</script>
			</datagrid>
			<output id="otp_paytotsumamt" ref="/root/hidden/sumvalue/paytotsumamt" format="(-)#,###" style="left:1065px; top:123px; width:127px; height:19px; text-align:right; margin-right:1; "/>
			<line id="line11" class="line_3" style="x1:1065px; y1:98px; x2:1065px; y2:142px; "/>
			<line id="line13" class="line_3" style="x1:1192px; y1:98px; x2:1192px; y2:142px; "/>
			<caption id="caption18" class="cell_1" style="left:1065px; top:99px; width:127px; height:23px; text-align:center; vertical-align:middle; ">총지급액</caption>
			<caption id="caption19" class="cell_1" style="left:325px; top:123px; width:87px; height:21px; text-align:center; vertical-align:middle; ">계</caption>
			<button id="button1" class="btn2_letter4" visibility="hidden" style="left:3px; top:121px; width:64px; height:19px; text-align:left; ">
				<caption>전체선택</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
					]]>
				</script>
			</button>
			<button id="button2" class="btn2_letter4" visibility="hidden" style="left:70px; top:121px; width:64px; height:19px; text-align:left; ">
				<caption>전체해제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
					]]>
				</script>
			</button>
			<button id="button4" class="btn2_letter4" style="left:1060px; top:73px; width:64px; height:19px; text-align:left; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						model.removeNodeset(grd_orchlist.nodeset);
						grd_orchlist.refresh();
						
						if(fGridStatusCheck())
						{
							fInputExcel(grd_orchlist)							
						}
						
						
						var bInsertValidFlag = true;
						var bEmplnoError = false;
						var bRrgstnoError = false;						
						
						for(var i = grd_orchlist.fixedRows ; i < grd_orchlist.rows ; i++)
						{
							vEmplno  	= grd_orchlist.valueMatrix(i, grd_orchlist.colRef("emplno"));
							vRrgstno  	= grd_orchlist.valueMatrix(i, grd_orchlist.colRef("rrgstno"));
							
							vInstCd	= getUserInfo("dutplceinstcd");
							bInsertValidFlag = true;
							bEmplnoError = false;
							bRrgstnoError = false;		
							
							if(vEmplno != "-" && radfcheckEmplExist(vEmplno) == "")
							{								
								bEmplnoError = true;								
							}
							
							if(vEmplno == "" && vRrgstno != "" && radfGetIcpncd(vInstCd, vRrgstno) == "")
							{
								bRrgstnoError = true;								
							}							
														
							if(bEmplnoError == true && vEmplno != "")
							{								
								bInsertValidFalg = false;
								model.setValue(grd_orchlist.nodeset + "[" + i + "]/cmt", grd_orchlist.valueMatrix(i, grd_orchlist.colRef("emplno")) + " 는 없는 사번입니다.");
								messageBox(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("emplno")) + " 는 없는 사번입니다.", "I000");
								grd_orchlist.rowStyle(i, "data", "background-color") = "#ff99cc";
								
							}
							else if(bRrgstnoError == true && vEmplno == "" && vRrgstno != "")
							{
								bInsertValidFlag = false;							
								model.setValue(grd_orchlist.nodeset + "[" + i + "]/cmt", grd_orchlist.valueMatrix(i, grd_orchlist.colRef("rrgstno")) + " 는 없는 소득자입니다.");
								messageBox(grd_orchlist.valueMatrix(i, grd_orchlist.colRef("rrgstno")) + " 는 없는 소득자입니다.", "I000");
								grd_orchlist.rowStyle(i, "data", "background-color") = "#ff99cc";
							}
							
							
//							if(vEmplno != "-" && vRrgstno != "")
//							{
//								bInsertValidFlag = false;
//								messageBox("사번과 주민등록번호를 함께 입력할 수 없습니다.", "I000");
//							}
							
							if((vEmplno == "-" && vRrgstno == "") || (vEmplno == "" && vRrgstno == ""))
							{
								bInsertValidFlag = false;
								messageBox("사번이나 주민등록번호를 입력하세요", "I000");
							}							
						}
						
						if(bInsertValidFlag == false)
						{
							grd_orchlist.clearStatus();
							messageBox("사번 / 데이터 오류 입니다. 엑셀출력을 하여 확인하여 주십시요", "I000");
						}
						
						
						
					]]>
				</script>
			</button>
			<output id="otp_paysumtax" ref="/root/hidden/sumvalue/paysumtax" format="(-)#,###" style="left:935px; top:123px; width:127px; height:19px; text-align:right; margin-right:1; "/>
			<caption id="caption5" class="cell_1" style="left:935px; top:99px; width:127px; height:23px; text-align:center; vertical-align:middle; ">납부세액</caption>
			<caption id="caption7" class="cell_1" style="left:805px; top:99px; width:127px; height:23px; text-align:center; vertical-align:middle; ">주민세</caption>
			<output id="otp_resdnsumtax" ref="/root/hidden/sumvalue/resdnsumtax" format="(-)#,###" style="left:805px; top:123px; width:127px; height:19px; text-align:right; margin-right:1; "/>
			<caption id="caption9" class="cell_1" style="left:675px; top:99px; width:127px; height:23px; text-align:center; vertical-align:middle; ">소득세</caption>
			<output id="otp_incmsumtax" ref="/root/hidden/sumvalue/incmsumtax" format="(-)#,###" style="left:675px; top:123px; width:127px; height:19px; text-align:right; margin-right:1; "/>
			<caption id="caption12" class="cell_1" style="left:545px; top:99px; width:127px; height:23px; text-align:center; vertical-align:middle; ">퇴직금여총액</caption>
			<output id="otp_retiresumamt" ref="/root/hidden/sumvalue/retiresumamt" format="(-)#,###" style="left:545px; top:123px; width:127px; height:19px; text-align:right; margin-right:1; "/>
			<output id="otp_totcount" ref="/root/hidden/sumvalue/totcount" format="(-)#,###" style="left:415px; top:123px; width:127px; height:19px; text-align:right; margin-right:1; "/>
			<caption id="caption13" class="cell_1" style="left:415px; top:99px; width:127px; height:23px; text-align:center; vertical-align:middle; ">총지급건수</caption>
		</group>
	</xhtml:body>
</xhtml:html>