YNU_JEUS/app_home/himed/webapps/mis/retireamtmngtweb/xrw/SMRWR00100_퇴직자명단조회.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>
						<retireempl>
							<retireempllist/>
						</retireempl>
					</main>
					<send>
						<retireempl>
							<fromdd/>
							<todd/>
							<instcd/>
							<prfshipflag/>
							<jobgradcd/>
							<unitcd/>
							<emplno/>
							<jobgradnm/>
							<unitnm/>
							<emplnm/>
						</retireempl>
						<save>
							<retireempl>
								<retireempllist/>
							</retireempl>
						</save>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfGridInit(grd_retireempllist);
				
					grd_retireempllist.fixedcellcheckbox(0, 1) = true;
					
					misfMsterDetailSet(grd_retireempllist, null, "TRRWR00101" ,"Y"); 
					
					var curdate = getCurrentDate();
					var dt = new Date(curdate.substr(0, 4), curdate.substr(4, 2)-1, 0);				
					model.setValue(ipt_fromdd.attribute("ref") , curdate.substr(0, 6)-1 + "01");
					model.setValue(ipt_todd.attribute("ref") , (curdate.substr(0, 6)-1) + "" +dt.getDate());
					
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
					misfComboComCdListMulti("R0058","cmb_prfshipflag");
					
					//addComboItem( "cmb_instcd", "[-- 전체 --]", "%", "above");
					model.setValue(cmb_instcd.attribute("ref"), getUserInfo("dutplceinstcd"));
					
					addComboItem( "cmb_prfshipflag", "[-- 전체 --]", "%", "above");
					model.setValue(cmb_prfshipflag.attribute("ref"), "%");
					
					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y" ) {
						cmb_instcd.disabled = false;
					}
					else {
						cmb_instcd.disabled = true;
					}
					
					model.refresh();
					model.setFocus("ipt_fromdd");
				]]>
			</script>
			<submission id="TRRWR00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/retireempl" resultref="/root/main/retireempl"/>
			<submission id="TXRWR00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save/retireempl" resultref="/root/hidden/temp"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript" src="../../../mis/paybnusmngtweb/js/RWP001.js"/>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-right:8; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">퇴직자 명단 조회</caption>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:38; width:1195px; height:744px; ">
			<line id="line9" class="line_1" style="x1:0px; y1:89px; x2:1193px; y2:89px; "/>
			<caption id="caption34" class="tit_2" style="left:6px; top:72px; width:186px; height:13px; ">퇴직자 명단 List</caption>
			<group id="grp_sea" style="left:0px; top:10px; width:1195px; height:55px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1195px; height:55px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1124px; top:17px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							misfMsterDetailRetrieve();	
							
							grd_retireempllist.subtotalPosition = "below";
							
							grd_retireempllist.subtotal("sum",-1 , grd_retireempllist.colRef("paytotamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retireempllist.subtotal("sum",-1 , grd_retireempllist.colRef("adjtpayamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retireempllist.subtotal("sum",-1 , grd_retireempllist.colRef("paynotaxamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retireempllist.subtotal("sum",-1 , grd_retireempllist.colRef("paytaxamt"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							grd_retireempllist.subtotal("sum",-1 , grd_retireempllist.colRef("paytaxamt2"), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 2, "합계");	
							
						]]>
					</script>
				</button>
				<line id="line5" class="line_4" style="x1:1109px; y1:1px; x2:1109px; y2:55px; border-color:#ffe4bb; border-left-style:solid; "/>
				<input id="ipt_fromdd" ref="/root/send/retireempl/fromdd" class="input_default" inputtype="date" format="yyyy-mm-dd" style="left:60px; top:7px; width:101px; height:19px; text-align:center; vertical-align:middle; "/>
				<caption id="cap_payym" class="search_name" style="left:4px; top:8px; width:60px; height:17px; ">기간:</caption>
				<select1 id="cmb_instcd" ref="/root/send/retireempl/instcd" class="combo_s_essential" appearance="minimal" style="left:378px; top:7px; width:237px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_instcd" class="search_name" style="left:321px; top:8px; width:61px; height:17px; ">기관:</caption>
				<input id="ipt_deptnm" ref="/root/send/retireempl/unitnm" class="input_default" style="left:477px; top:30px; width:139px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						misfValidationCheck("02", "", "unitcd,unitnm" );
						model.refresh();
					]]>
					</script>
				</input>
				<button id="btn_deptcd" class="icon_search" style="left:459px; top:30px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var recv_list = "unitcd,unitnm";
						var instcd = cmb_instcd.value;
						rpbfOpenDeptCdHelp(ipt_deptcd,recv_list,instcd,"instcd");
						model.refresh();
					]]>
					</script>
				</button>
				<input id="ipt_deptcd" ref="/root/send/retireempl/unitcd" class="input_default" style="left:378px; top:30px; width:79px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						misfValidationCheck("02", "", "unitcd,unitnm" );
						model.refresh();			
					]]>
					</script>
				</input>
				<caption id="caption1" class="search_name" style="left:321px; top:31px; width:61px; height:17px; ">부서:</caption>
				<input id="ipt_emplnm" ref="/root/send/retireempl/emplnm" class="input_default" style="left:835px; top:30px; width:106px; height:19px; ">
					<script type="javascript" ev:event="onkeyup">
						<![CDATA[
							if (ipt_emplnm.currentText != null && ipt_emplnm.currentText != "" ) {
								inputEnterKey("ipt_emplnm", "xforms-value-changed");	
								inputEnterKey("btn_search", "DOMActivate");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						var recv_list = "emplno,emplnm" ;
						rpbfValidationCheck("EMPLNM", recv_list);
						
						model.refresh();		
					]]>
					</script>
				</input>
				<button id="btn_emplno" class="icon_search" style="left:814px; top:30px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var recv_list = "emplno,emplnm" ;
						rpbfOpenPopUpList("SPRPB00101", ipt_emplno, recv_list,"","N");	
						
						model.refresh();
						
						if (model.getValue(ipt_emplno.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}	
					]]>
					</script>
				</button>
				<input id="ipt_emplno" ref="/root/send/retireempl/emplno" class="input_default" style="left:740px; top:30px; width:70px; height:19px; ">
					<script type="javascript" ev:event="onkeyup">
						<![CDATA[
							if (ipt_emplno.currentText != null && ipt_emplno.currentText != "" ) {
								inputEnterKey("ipt_emplno", "xforms-value-changed");	
								inputEnterKey("btn_search", "DOMActivate");
							}
						]]>
					</script>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						var recv_list = "emplno,emplnm" ;
						rpbfValidationCheck("EMPLNO", recv_list);
						model.refresh();
					]]>
					</script>
				</input>
				<caption id="caption2" class="search_name" style="left:658px; top:31px; width:81px; height:17px; ">사번:</caption>
				<input id="ipt_todd" ref="/root/send/retireempl/todd" class="input_default" inputtype="date" format="yyyy-mm-dd" style="left:180px; top:7px; width:101px; height:19px; text-align:center; vertical-align:middle; "/>
				<caption id="caption3" style="left:165px; top:7px; width:10px; height:19px; ">-</caption>
				<select1 id="cmb_prfshipflag" ref="/root/send/retireempl/prfshipflag" class="combo_s_essential" appearance="minimal" style="left:740px; top:7px; width:200px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption4" class="search_name" style="left:658px; top:8px; width:81px; height:17px; ">급여분류:</caption>
				<caption id="caption5" class="search_name" style="left:4px; top:31px; width:60px; height:17px; ">직급:</caption>
				<input id="ipt_jobgradnm" ref="/root/send/retireempl/jobgradnm" class="input_default" style="left:162px; top:30px; width:118px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						misfValidationCheck("03", "R0064", "jobgradcd,jobgradnm" ); 
						model.refresh();
					]]>
					</script>
				</input>
				<button id="btn_jobgradcd" class="icon_search" style="left:144px; top:30px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						var recv_list = "jobgradcd,jobgradnm";
						rpbfOpenComCdHelp(ipt_jobgradcd,"R0064", recv_list);
						model.refresh();
					]]>
					</script>
				</button>
				<input id="ipt_jobgradcd" ref="/root/send/retireempl/jobgradcd" class="input_default" style="left:60px; top:30px; width:79px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
						misfValidationCheck("03", "R0064", "jobgradcd,jobgradnm" ); 
						model.refresh();			
					]]>
					</script>
				</input>
			</group>
			<datagrid id="grd_retireempllist" nodeset="/root/main/retireempl/retireempllist" caption="^사번^성명^주민번호^기관^부서^직위^직급^입사일^퇴사일^급여액^조정금액^비과세금액^소득세^주민세|^사번^성명^주민번호^기관^부서^직위^직급^입사일^퇴사일^급여액^조정금액^비과세금액^소득세^주민세" colsep="^" colwidth="21, 68, 75, 98, 110, 102, 90, 79, 88, 88, 95, 85, 91, 80, 76, 100" dataheight="25" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="25" rowsep="|" style="left:0px; top:95px; width:1193px; height:645px; ">
				<col checkvalue="Y,N" ref="selyn" type="checkbox"/>
				<col ref="emplno"/>
				<col ref="emplnm"/>
				<col ref="rregno"/>
				<col ref="instnm"/>
				<col ref="unitnm"/>
				<col ref="jobposnm"/>
				<col ref="jobgradnm"/>
				<col disabled="true" ref="entcodd" type="inputdate"/>
				<col disabled="true" ref="retiredd" type="inputdate"/>
				<col ref="paytotamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="adjtpayamt" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="paynotaxamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="paytaxamt" format="(-)#,###" style="text-align:right; "/>
				<col ref="paytaxamt2" format="(-)#,###" style="text-align:right; "/>
				<col ref="sumyn" visibility="hidden"/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_retireempllist.gridToInstance();	
					]]>
				</script>
			</datagrid>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1130px; top:69px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");

						if (fileName != "")
						{
							grd_retireempllist.saveExcel(fileName);
						}			
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0; top:12; width:1195px; height:27px; ">
			<line id="line4" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_save" class="btn4_letter6" visibility="hidden" style="left:1085px; top:2px; width:104px; height:22px; ">
				<caption>급여자료생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						for (var i = grd_retireempllist.fixedRows; i < grd_retireempllist.rows; i++) {
							if (grd_retireempllist.valueMatrix(i, grd_retireempllist.colRef("sumyn")) == "Y" && grd_retireempllist.valueMatrix(i, grd_retireempllist.colRef("selyn")) == "Y") {
								var emplnm = grd_retireempllist.valueMatrix(i, grd_retireempllist.colRef("emplnm"));
								
								var rtn = messageBox("[" + emplnm + "]은(는) 급여자료가 생성 되어 있습니다.재생성", "Q004");
								
								if (rtn != 6) {
									grd_retireempllist.valueMatrix(i, grd_retireempllist.colRef("selyn")) = "N";
								}
								else {
									grd_retireempllist.rowStatus(i) = "2";
								}
							}
							else if  (grd_retireempllist.valueMatrix(i, grd_retireempllist.colRef("sumyn")) == "N" && grd_retireempllist.valueMatrix(i, grd_retireempllist.colRef("selyn")) == "Y") {
								grd_retireempllist.rowStatus(i) = "2";
								
							}
						}
						
						misfSave("TXRWR00101");
						
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>