YNU_JEUS/app_home/himed/webapps/mis/paybnusmngtweb/xrw/SMRWP21900_개인별소급합계금액조회.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:my="http://www.comsquare.co.kr/example" xmlns:ms="urn:schemas-microsoft-com:xslt" 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" xmlns:cs="http://www.comsquare.co.kr/xforms">
	<xhtml:head>
		<xhtml:title>개인별급여소급합계금액조회</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<payspecdata>
							<payamtlist/>
							<paytitlelist/>
							<payitemmap/>
						</payspecdata>
						<payspecexcel>
							<payamtexcellist/>
						</payspecexcel>
					</main>
					<init>
						<temp/>
					</init>
					<send>
						<payspec>
							<emplno/>
							<emplnm/>
							<saldfrayflag>3</saldfrayflag>
							<payfromym/>
							<dutdeptcd/>
							<instcd/>
							<payclsprfshipflag/>
							<chkyn/>
							<teamflag>3</teamflag>
							<paytotexceptyn/>
							<holyordflag/>
							<payddtype>D</payddtype>
						</payspec>
						<prtdata>
							<instnm/>
							<prtuser/>
							<payym/>
						</prtdata>
						<payamtlist/>
						<payitlist/>
					</send>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					var curdate = getCurrentDate();
					
					model.setValue(ipt_payfromym.attribute("ref") , curdate);
					model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));

					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
					misfGetUserAuth();
				]]>
			</script>
			<submission id="TRRWP21901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecdata"/>
			<submission id="TXRWP21901" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/init/temp"/>
			<submission id="TXRWP21902" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/init/temp"/>
		</model>
		<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/dateHelper.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:40px; width:1195px; height:740px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1193px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<button id="btn_search" class="btn1_letter2" navindex="5" style="left:760px; top:17px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						if (grd_payamtlist.nodeset.length> 0) {
							
							model.removeNodeset("/root/main/payspecdata/payamtlist");
							model.removeNodeset("/root/main/griddata/payspecdata/payamtlist");
							
							grd_payamtlist.nodeset = "/root/init/temp";
							
							for (var i = grd_payamtlist.cols - 1; i >= 1 ; i--) {
								grd_payamtlist.removeColumn(false);
							}
							grd_payamtlist.caption = "";
							
							model.refresh();
							grd_payamtlist.rebuild();
						}
						
						submit("TRRWP21901");

						var node = instance1.selectNodes("/root/main/payspecdata/payamtlist[1]/*");
						var payitemmapnode = instance1.selectNodes("/root/main/payspecdata/payitemmap[*]/payitemmap");
						
						var payitemcnt = model.getValue("/root/main/payspecdata/paytitlelist/payitemcnt") ;
						var payitemcnt2 = model.getValue("/root/main/payspecdata/paytitlelist/payitemcnt2") ;
						var primykeycnt = 4; //필수컬럼수
						//필수컬럼 생성
						if (node.length > 0 ) {
							
							for(i=0;i<primykeycnt;i++) {
								if (node.item(i).nodeName == 'saldfrayflag' || node.item(i).nodeName == 'payfromym') {	
									grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " style:" + "text-align:center; visibility:hidden;  ", false);
								} else if (node.item(i).nodeName == 'payym' ) {
									grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "yyyy-mm;" + " style:" + "text-align:center; ", false);	
								} else {
									grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " style:" + "text-align:center; ", false);	
								}
							}
						}
						grd_payamtlist.colwidth(1) = 55;
						grd_payamtlist.colwidth(2) = 50;
						grd_payamtlist.colwidth(3) = 60;
						//급여출력마스터순서로 컬럼생성
						if (payitemmapnode.length > 0 ) {
							for(i=0;i<payitemmapnode.length;i++) {
								grd_payamtlist.addColumn("ref:" + payitemmapnode.item(i).value + "; type:output;" + " format:" + "(-)#,###;" + "savetype:" + "digit;" + " style:" + "text-align:right; ", false);
								grd_payamtlist.colwidth(i + (primykeycnt + 1)) = 80;
							}
						}	
						
						grd_payamtlist.caption = model.getValue("/root/main/payspecdata/paytitlelist/paytitle") + "|" + model.getValue("/root/main/payspecdata/paytitlelist/paytitle");
						grd_payamtlist.nodeset = "/root/main/payspecdata/payamtlist";
						grd_payamtlist.frozenCols = 3;
						grd_payamtlist.rebuild();
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:745px; y1:15px; x2:745px; y2:39px; "/>
			<button id="btn_emplno" class="icon_search" navindex="4" style="left:607px; top:18px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						var recv_list = "emplno,emplnm" ;
						rpbfOpenPopUpList("SPRPB00101", ipt_emplnos, recv_list,"","N");	
						
						model.refresh();
					        
					        if (model.getValue(ipt_emplnos.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}	
					]]>
				</script>
			</button>
			<input id="ipt_emplnos" ref="/root/send/payspec/emplno" class="input_default" navindex="3" style="left:530px; top:18px; width:72px; height:19px; ">
				<script type="javascript" ev:event="onkeyup">
					<![CDATA[
						if (ipt_emplnos.currentText != null && ipt_emplnos.currentText != "" ) {
							inputEnterKey("ipt_emplnos", "xforms-value-changed");	
						}
					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					
						var recv_list = "emplno,emplnm" ;
						rpbfValidationCheck("EMPLNO", recv_list);
						model.refresh();
						
						if (model.getValue(ipt_emplnos.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}
						
					]]>
				</script>
			</input>
			<input id="ipt_emplnms" ref="/root/send/payspec/emplnm" class="input_default" style="left:626px; top:18px; width:74px; height:19px; ">
				<script type="javascript" ev:event="onkeyup">
					<![CDATA[
						if (ipt_emplnms.currentText != null && ipt_emplnms.currentText != "" ) {
							inputEnterKey("ipt_emplnms", "xforms-value-changed");	
						}
					]]>
				</script>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					
						var recv_list = "emplno,emplnm" ;
						rpbfValidationCheck("EMPLNM", recv_list);
						
						model.refresh();
						
						if (model.getValue(ipt_emplnos.attribute("ref")).length > 0) {
							btn_search.dispatch("DOMActivate");
						}		
					]]>
				</script>
			</input>
			<line id="line9" class="line_1" style="x1:0px; y1:74px; x2:1190px; y2:74px; "/>
			<caption id="caption34" class="tit_2" style="left:3px; top:59px; width:215px; height:13px; ">개인별급여소급합계금액 List</caption>
			<caption id="caption22" class="search_name" style="left:271px; top:19px; width:69px; height:17px; ">지급월</caption>
			<input id="ipt_payfromym" ref="/root/send/payspec/payfromym" class="input_default" navindex="2" inputtype="date" format="yyyy-mm-dd" style="left:340px; top:18px; width:100px; height:19px; text-align:center; vertical-align:middle; "/>
			<datagrid id="grd_payamtlist" colsep="^" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" navindex="6" style="left:0px; top:79px; width:1190px; height:640px; "/>
			<button id="btn_saveexcel" class="btn2_letter4" navindex="10" style="left:1125px; top:53px; 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_payamtlist.saveExcel(fileName, "SheetName:sheet1");
						}

					]]>
				</script>
			</button>
			<select1 id="cmb_instcd" ref="/root/send/payspec/instcd" class="combo_s_essential" disabled="true" navindex="1" appearance="minimal" style="left:104px; top:18px; width:139px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption3" class="search_name" style="left:47px; top:18px; width:61px; height:17px; ">기관</caption>
			<caption id="caption5" class="search_name" style="left:474px; top:18px; width:63px; height:17px; ">사번</caption>
			<select1 id="radio1" ref="/root/send/payspec/payddtype" visibility="hidden" appearance="full" cols="3" overflow="visible" style="left:445px; top:50px; width:145px; height:20px; text-align:center; border-style:none; ">
				<choices>
					<item>
						<label>년별</label>
						<value>Y</value>
					</item>
					<item>
						<label>월별</label>
						<value>M</value>
					</item>
					<item>
						<label>일자</label>
						<value>D</value>
					</item>
				</choices>
			</select1>
			<caption id="caption1" class="search_name" visibility="hidden" style="left:375px; top:50px; width:63px; height:17px; ">조건 :</caption>
			<button id="btn_inputexcel" class="btn2_letter4" navindex="9" style="left:1058px; top:53px; width:64px; height:19px; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						grd_payamtlist.loadExcel(fileName, 1, true);
//						for (var i = 1; i < grd_payamtlist.rows; i ++){
//							grd_payamtlist.rowStatus(i) = 1;
//							model.setValue("/root/main/grnt/grntlist1[" + i + "]/foodgb", model.getValue("/root/send/paydedu/foodgb"));
//							model.setValue("/root/main/grnt/grntlist1[" + i + "]/payym", model.getValue("/root/send/paydedu/payym"));
//						}
						grd_payamtlist.refresh();	
					]]>
				</script>
			</button>
			<button id="btn_grddelpaydedulist" class="btn2_letter3" navindex="8" style="left:1002px; top:53px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						//grd_dutsumlist.deleteRow(grd_dutsumlist.row);
						deleteSelectedRows(grd_payamtlist, true);
					]]>
				</script>
			</button>
			<button id="btn_grdaddpaydedulist" class="btn2_letter3" navindex="7" style="left:946px; top:53px; width:53px; height:19px; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						grd_payamtlist.addRow();
						model.refresh();
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:27px; ">
			<button id="button1" class="btn4_letter6" navindex="12" style="left:1090px; top:2px; width:104px; height:22px; ">
				<caption>급여차액계산</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						//grd_payamtlist.getUpdateDataAll('u');
						
						model.makeValue("/root/send/payamtlist",grd_payamtlist.getUpdateDataAll('u'));
						
						
						submit("TXRWP21901");
						
						

					]]>
				</script>
			</button>
			<button id="button2" class="btn4_letter8" navindex="11" style="left:960px; top:2px; width:128px; height:22px; ">
				<caption>급여차액총액계산</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
						//grd_payamtlist.getUpdateDataAll('u');
						
						model.makeValue("/root/send/payamtlist",grd_payamtlist.getUpdateDataAll('u'));
						
						
						submit("TXRWP21902");
						
						

					]]>
				</script>
			</button>
			<line id="line19" class="line_6" style="x1:0px; y1:25; x2:1195px; y2:25px; "/>
		</group>
	</xhtml:body>
</xhtml:html>