YNU_JEUS/app_home/himed/webapps/mis/retireamtmngtweb/xrw/SMRWR00400_퇴직금추계액계산.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>퇴직금추계액계산</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<retireamtcalclist/>
						<psnretireamtcalclist/>
					</main>
					<send>
						<instcd/>
						<prfshipflag/>
						<yymmdd/>
						<req>
							<emplno/>
							<yymmdd/>
						</req>
						<save>
							<retireamtcalclist/>
						</save>
					</send>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfGridInit(grd_retireamtcalclist);
					misfGridInit(grd_psnretireamtcalclist);
					
					misfMsterDetailSet(grd_retireamtcalclist, null, "TRRWR00401" ,"Y"); 
					
					var curdate = getCurrentDate();
					model.setValue("/root/send/yymmdd" , curdate);

					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
					misfComboComCdListMulti("R0058","cmb_prfshipflag");
					
					addComboItem( "cmb_prfshipflag", " 전체", "", "above");
					cmb_instcd.value = getUserInfo("dutplceinstcd");		
					
					grd_retireamtcalclist.subtotalPosition = "below"
					
					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y" ) {
						cmb_instcd.disabled = false;
					}
					else {
						cmb_instcd.disabled = true;
					}
					
					model.refresh();
				]]>
			</script>
			<submission id="TRRWR00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/retireamtcalclist"/>
			<submission id="TRRWR00402" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/req" resultref="/root/main/psnretireamtcalclist"/>
			<submission id="TXRWR00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" 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:204px; height:14px; ">퇴직금 추계액 계산 대상자 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:33; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="btn_search" class="btn1_letter2" navindex="4" style="left:1124px; top:6; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							submit("TRRWR00401");
							ipt_yymmdd.value = ipt_yymmdd_search.value;
							ipt_yymmdd.refresh();
							
							// 컬럼이 늘어나면 i 값도 변경해야함
							for(var i=10 ; i <23 ; i++){
								grd_retireamtcalclist.subtotal("sum", 1, i, "format:#,###; ", "background-color:#ffff00; font-weight:bold; ", 0 , "합계");
							}
						]]>
					</script>
				</button>
				<line id="line5" class="line_4" style="x1:1109px; y1:1px; x2:1109px; y2:33; border-color:#ffe4bb; border-left-style:solid; "/>
				<select1 id="cmb_instcd" ref="/root/send/instcd" class="combo_s_essential" appearance="minimal" style="left:105px; top:7px; width:140px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_instcd" class="search_name" style="left:23px; top:8px; width:80px; height:17px; ">기     관:</caption>
				<caption id="caption1" class="search_name" style="left:350px; top:8px; width:128px; height:17px; ">기  준  일:</caption>
				<select1 id="cmb_prfshipflag" ref="/root/send/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>
				<input id="ipt_yymmdd_search" ref="/root/send/yymmdd" inputtype="date" style="left:440px; top:7px; width:135px; height:19px; "/>
				<input id="ipt_emplno" ref="/root/send/req/emplno" visibility="hidden" style="left:290px; top:35px; width:100px; height:20px; "/>
				<input id="ipt_yymmdd" ref="/root/send/req/yymmdd" visibility="hidden" style="left:395px; top:35px; width:100px; height:19px; "/>
			</group>
			<datagrid id="grd_retireamtcalclist" nodeset="/root/main/retireamtcalclist" caption="기관^급여분류^직원구분^사번^성명^부서^입사일^적용일^근속년월^기타금액^3개월급여^3개월평균급여^상여^상여/12^정근수당^정근수당/12^휴가보상비^휴가보상비/12^명절수당^명절수당/12^총금액^퇴직금^기준일^기준입력여부" colsep="^" colwidth="100, 100, 100, 85, 80, 93, 92, 94, 100, 100, 90, 95, 85, 91, 100, 100, 100, 100, 100, 100, 100, 100, 35, 31" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:93px; width:1195px; height:450; ">
				<col ref="dutplceinst"/>
				<col ref="prfshipflag"/>
				<col ref="holyordflag"/>
				<col ref="emplno"/>
				<col ref="name"/>
				<col ref="unitcd"/>
				<col ref="entcodd" format="yyyy-mm-dd" style="text-align:center; vertical-align:middle; "/>
				<col ref="appdd" type="inputdate" format="yyyy-mm-dd" style="text-align:center; vertical-align:middle; "/>
				<col ref="dutyym" format="mm-dd" style="text-align:center; vertical-align:middle; "/>
				<col ref="baseamt" type="input" format="(-)#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="pay3" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="avg_pay3" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="pay12_1" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="avg_pay12_1" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="pay12_2" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="avg_pay12_2" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="pay12_3" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="avg_pay12_3" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="pay12_4" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="avg_pay12_4" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="totamt" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="tamt" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="basedd" visibility="hidden"/>
				<col ref="inputyn" visibility="hidden"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
						ipt_emplno.value = grd_retireamtcalclist.valueMatrix(grd_retireamtcalclist.row, grd_retireamtcalclist.colRef("emplno"));
						ipt_emplno.refresh();
						submit("TRRWR00402");
						model.refresh();
					]]>
				</script>
			</datagrid>
			<line id="line1" class="line_1" style="x1:0px; y1:582px; x2:1193px; y2:582px; "/>
			<caption id="caption2" class="tit_2" style="left:5px; top:565px; width:186px; height:13px; ">개인 퇴직금 추계액 계산</caption>
			<datagrid id="grd_psnretireamtcalclist" nodeset="/root/main/psnretireamtcalclist" caption="년월^급여^상여^정근^휴가보상비^명절" colsep="^" colwidth="100, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowsep="|" style="left:0px; top:585px; width:1195; height:155; ">
				<col ref="payym" format="yyyy-mm"/>
				<col ref="pay3" format="#,###"/>
				<col ref="pay12_1" format="#,###"/>
				<col ref="pay12_2" format="#,###"/>
				<col ref="pay12_3" format="#,###"/>
				<col ref="pay12_4" format="#,###"/>
			</datagrid>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1127px; top:68px; 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_retireamtcalclist.saveExcel(fileName);
						}			
					]]>
				</script>
			</button>
			<button id="btn_delgrdretireamtcalclist" class="btn2_letter4" style="left:1060px; top:68px; width:64px; height:19px; ">
				<caption>자료삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_retireamtcalclist, "D");		
					]]>
				</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_letter2" style="left:1134px; top:2px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfSave("TXRWR00401");
						
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>