YNU_JEUS/app_home/himed/webapps/mis/yyendtaxadstweb/xrw/SMRWY01900_년간급여자료조회.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>
						<ponyemplform>
							<yyendcalcmanbaselist>
								<emplno/>
								<calcyy/>
								<emplnm/>
								<calcinst/>
								<entcodd/>
								<grupjoblnnm/>
								<deptnm/>
								<jobposnm/>
								<jobgradnm/>
								<payclsnm/>
							</yyendcalcmanbaselist>
						</ponyemplform>
						<yypaysum>
							<yypaysumlist>
								<emplno/>
								<emplnm/>
								<totpayitemamt/>
								<payitemnm/>
								<payitemcd/>
								<calcyy/>
							</yypaysumlist>
						</yypaysum>
						<yypaydetail>
							<yypaydetaillist>
								<paymm/>
								<payitemnm/>
								<payitemamt/>
								<payitemadjamt/>
								<payitemcd/>
								<emplno/>
								<calcyy/>
							</yypaydetaillist>
						</yypaydetail>
					</main>
					<send>
						<searchlist>
							<calcyy/>
							<instcd/>
							<dutplcedeptcd/>
							<actndeptqualyn/>
							<workym/>
							<retireyn/>
							<emplno/>
							<dutplcedeptnm/>
							<emplnm/>
						</searchlist>
						<ponyemplform>
							<emplno/>
							<calcyy/>
						</ponyemplform>
						<savelist>
							<yypaydetaillist/>
						</savelist>
						<yypaysum>
							<emplno/>
							<calcyy/>
							<payitemcd/>
						</yypaysum>
					</send>
					<init/>
					<temp>
					</temp>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					 fInitialize();
					/* Grid 초기화 */
					misfGridInit(grd_yyendcalcmanbaselist);  
					misfGridInit(grd_yypaydetaillist);
					misfGridInit(grd_yypaysumlist);
					/* Grid의 Mater, Detail관계 설정 
					    misfMsterDetailSet(관계설정할 Grid, Mater가 될 Grid, submit ID, 저장여부) */
					misfMsterDetailSet(grd_yyendcalcmanbaselist, null, "TRRWY00401" ,"N"); 
					misfMsterDetailSet(grd_yypaydetaillist, grd_yyendcalcmanbaselist, "TRRWY01901" ,"Y"); 
					misfMsterDetailSet(grd_yypaysumlist, grd_yyendcalcmanbaselist, "TRRWY01902" ,"N"); 

					btn_save.disabled = !(checkAuth("X"));
					//misfMsterDetailSet(grd_clubempllist,grd_clubcodelist, "TRRPA00401","N" ); 
					// 공통코드 바인딩   silver					
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
					var instcd = getUserInfo("dutplceinstcd");
					cmb_instcd.value=instcd;
					
					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y" ) {
						cmb_instcd.disabled = false;
					}
					else {
						//cmb_instcd.disabled = true;
					}
				]]>
			</script>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript">
				<![CDATA[

					// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
					function fInitialize() {
						model.removeNodeset("/root/main/ponyemplform/yyendcalcmanbaselist");
						model.removeNodeset("/root/main/yypaysum/yypaysumlist");
						model.removeNodeset("/root/main/yypaysum/yypaydetaillist");
						model.resetInstanceNode("/root/send");
						model.refresh();
						var nowdate = getCurrentDate();
				    	       var yy = nowdate.substring(0,4);
						 ipt_calcyy.value = yy;
						// ipt_paymm.value = getday.substring(0,6);
						 var instcd = getUserInfo("dutplceinstcd");
				       		cmb_instcd.value=instcd;
					}		
				]]>
			</script>
			<submission id="TRRWY00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/main/ponyemplform"/>
			<submission id="TRRWY01901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/ponyemplform" resultref="/root/main/yypaysum"/>
			<submission id="TXRWY01901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/savelist" resultref="/root/temp"/>
			<submission id="TRRWY01902" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/yypaysum" resultref="/root/main/yypaydetail"/>
		</model>
	</xhtml:head>
	<xhtml:body>
		<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:38px; width:1195; height:744px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<button id="btn_search" class="btn1_letter2" style="left:1123px; top:17px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if(ipt_calcyy.value==""){
						messageBox("정산년도는","I003");
						return;
						}
						if(cmb_instcd.value==""){
						messageBox("기관은","I003");
						return;
						}
						misfMsterDetailRetrieve(); 	
							
					]]>
				</script>
			</button>
			<caption id="cap_calcyy" class="search_name" style="left:15px; top:19px; width:86px; height:17px; ">정산년도 :</caption>
			<caption id="caption3" class="search_name" style="left:425px; top:19px; width:99px; height:17px; ">근무부서 :</caption>
			<caption id="caption4" class="search_name" style="left:745px; top:19px; width:86px; height:17px; ">사원번호 :</caption>
			<line id="line3" class="line_4" style="x1:1107px; y1:16px; x2:1107px; y2:38px; border-color:#ffe4bb; border-left-style:solid; "/>
			<line id="line4" class="line_1" style="x1:0px; y1:268px; x2:547px; y2:269px; "/>
			<input id="ipt_calcyy" ref="/root/send/searchlist/calcyy" class="input_default" inputtype="date" format="yyyy" style="left:100px; top:18px; width:90px; height:19px; "/>
			<datagrid id="grd_yyendcalcmanbaselist" nodeset="/root/main/ponyemplform/yyendcalcmanbaselist" caption="사원번호^사원명^부서^직군^직위^직급^호봉^입사일" colsep="^" colwidth="100, 100, 150, 150, 150, 150,150, 150" dataheight="25" ellipsis="true" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" tooltip="true" style="left:0px; top:73px; width:1195px; height:298px; ">
				<col ref="emplno" style="text-align:center; "/>
				<col ref="emplnm" style="text-align:center; "/>
				<col ref="deptnm"/>
				<col ref="grupjoblnnm" style="text-align:center; "/>
				<col ref="jobposnm" style="text-align:center; "/>
				<col ref="jobgradnm" style="text-align:center; "/>
				<col ref="payclsnm" style="text-align:center; "/>
				<col ref="entcodd" format="yyyy-mm-dd" style="text-align:center; "/>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
					misfMsterDetailRetrieve(); 
					]]>
				</script>
			</datagrid>
			<select1 id="cmb_instcd" ref="/root/send/searchlist/instcd" class="combo_s_essential" appearance="minimal" style="left:299px; top:18px; width:100px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</select1>
			<input id="ipt_dutdeptnm" ref="/root/send/searchlist/dutplcedeptnm" class="input_search" disabled="true" navindex="3" style="left:605px; top:18px; width:115px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
							misfValidationCheck("02", "", "dutplcedeptcd,dutdeptnm_s" );
							model.refresh();				
						]]>
				</script>
			</input>
			<input id="ipt_dutdeptcd" ref="/root/send/searchlist/dutplcedeptcd" class="input_search" navindex="2" style="left:510px; top:18px; width:70px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
							misfValidationCheck("02", "", "dutplcedeptcd,dutplcedeptnm" );
							model.refresh();				
						]]>
				</script>
			</input>
			<caption id="cap_instcd" class="search_name" style="left:215px; top:19px; width:85px; height:17px; ">기     관 :</caption>
			<button id="btn_dutdept" class="icon_search" style="left:585px; top:20px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
							var recv_list = "dutplcedeptcd,dutplcedeptnm";
							misfOpenPopUpList("02", ipt_dutdeptcd,"",recv_list);
							model.refresh();
						]]>
				</script>
			</button>
			<caption id="caption18" class="tit_2" style="left:5px; top:381px; width:157px; height:13px; ">급여지급내역</caption>
			<datagrid id="grd_yypaydetaillist" nodeset="/root/main/yypaydetail/yypaydetaillist" caption="수당구분^지급월^지급금액^조정금액^수당구분코드^사원번호^정산년도" colsep="^" colwidth="223, 75, 131, 143, 100, 100, 100" ellipsis="true" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" tooltip="true" style="left:580px; top:402px; width:615px; height:332px; ">
				<col ref="payitemnm" style="text-align:center; "/>
				<col ref="paymm" style="text-align:center; "/>
				<col ref="payitemamt" type="output" format="#,###" maxlength="12" style="text-align:right; padding-right:5; "/>
				<col ref="payitemadjamt" type="input" format="#,###" maxlength="12" style="text-align:right; padding-right:5; "/>
				<col ref="payitemcd" visibility="hidden"/>
				<col ref="emplno" visibility="hidden"/>
				<col ref="calcyy" visibility="hidden"/>
			</datagrid>
			<line id="line6" class="line_1" style="x1:580px; y1:398px; x2:1195px; y2:399px; "/>
			<caption id="caption8" class="tit_2" style="left:585px; top:380px; width:157px; height:13px; ">월별지급내역</caption>
			<input id="ipt_emplnm" ref="/root/send/searchlist/emplnm" class="input_search" navindex="21" imemode="hangul" style="left:928px; top:18px; width:115px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
			       	  		 var recv_list = "emplno,emplnm";
						rpbfValidationCheck("EMPLNM", recv_list);
						model.refresh();
					]]>
				</script>
			</input>
			<input id="ipt_emplno" ref="/root/send/searchlist/emplno" class="input_search" navindex="20" style="left:833px; top:18px; width:70px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						 var recv_list = "emplno,emplnm"; 
						rpbfValidationCheck("EMPLNO", recv_list);
						model.refresh();
					]]>
				</script>
			</input>
			<button id="btn_emplsearch" class="icon_search" style="left:908px; top:20px; 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();
					]]>
				</script>
			</button>
			<button id="btn_exceldetail" class="btn2_letter4" style="left:1131px; top:376px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
						if (fileName != "")
						{
							grd_yypaydetaillist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
			<button id="btn_excelmaster" class="btn2_letter4" style="left:1131px; top:47px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
						if (fileName != "")
						{
							grd_yyendcalcmanbaselist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
			<line id="line22" class="line_1" style="x1:0px; y1:68px; x2:1195px; y2:68px; "/>
			<caption id="caption46" class="tit_2" style="left:5px; top:54px; width:157px; height:13px; ">사원정보</caption>
			<datagrid id="grd_yypaysumlist" nodeset="/root/main/yypaysum/yypaysumlist" caption="사원번호^사원명^수당구분^금액^수당구분코드^정산년도" colsep="^" colwidth="100, 87, 200, 144, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:402px; width:575px; height:332px; ">
				<col ref="emplno" style="text-align:center; "/>
				<col ref="emplnm" style="text-align:center; "/>
				<col ref="payitemnm" style="text-align:center; "/>
				<col ref="totpayitemamt" format="#,###" style="text-align:right; padding-right:5; "/>
				<col ref="payitemcd" visibility="hidden"/>
				<col ref="calcyy" visibility="hidden"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
					var cur_row=grd_yypaysumlist.row;
					model.setValue("/root/send/yypaysum/payitemcd",model.getValue("/root/main/yypaysum/yypaysumlist["+cur_row+"]/payitemcd"));
					submit("TRRWY01902");
					grd_yypaydetaillist.mergecol(2) = false;
					grd_yypaydetaillist.mergecol(3) = false;
					grd_yypaydetaillist.mergecol(4) = false;
					grd_yypaydetaillist.mergecells = "bycol";			
					]]>
				</script>
			</datagrid>
			<line id="line2" class="line_1" style="x1:0px; y1:397px; x2:575px; y2:397px; "/>
			<button id="button1" class="btn2_letter4" style="left:511px; top:376px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
					
						if (fileName != "")
						{
							grd_yypaysumlist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<line id="line1" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_init" class="btn4_letter3" style="left:1069px; top:3px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_yypaydetaillist);

					if (updtdata != "") {
						var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
						if (ret != 6) { // not OK
							return;
						}
					}
					fInitialize();	
					]]>
				</script>
			</button>
			<button id="btn_save" class="btn4_letter2" style="left:1139px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_yypaydetaillist);
						if (updtdata == "" ) {
							messageBox("변경된 데이터가","I004");
							return;
						}
						misfSave("TXRWY01901");
						
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>