YNU_JEUS/app_home/himed/webapps/mis/paybnusmngtweb/xrw/SMRWP03110_기간별급여합산조회.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>
						<payspecdata>
							<payamtlist/>
							<paytitlelist/>
						</payspecdata>
						<payamtexcel>
							<payamtexcellist/>
						</payamtexcel>
					</main>
					<init>
						<temp/>
					</init>
					<send>
						<payspec>
							<emplno/>
							<emplnm/>
							<saldfrayflag/>
							<payfromym/>
							<instcd/>
							<payclsprfshipflag/>
							<paytoym/>
						</payspec>
						<prtdata>
							<instnm/>
							<prtuser/>
							<payym/>
						</prtdata>
					</send>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
			
					/* Combo Data Setting
					    misfComboComCdListMulti(공통코드군, Combo)  */
					var curdate = getCurrentDate();
					
					model.setValue(ipt_payfromym.attribute("ref") , curdate.substr(0,6));
					model.setValue(ipt_paytoym.attribute("ref") , curdate.substr(0,6));

					model.setValue(cmb_SalDfrayFlag.attribute("ref"), "1");
					
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
					misfComboComCdListMulti("R0112,R0097","cmb_SalDfrayFlag,cmb_payclsprfshipflag");
					
					addComboItem( "cmb_payclsprfshipflag", "[-- 전체 --]", "%", "above");
					addComboItem( "cmb_SalDfrayFlag", "[-- 전체 --]", "%", "above");
					//addComboItem( "cmb_SalDfrayFlag", "[-- 전체 --]", "%", "above");
					addComboItem("cmb_instcd","[-- 전체 --]","%","above");
					model.setValue(cmb_payclsprfshipflag.attribute("ref"), "%");
					cmb_payclsprfshipflag.refresh();
					
					model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));					
					
					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y" ) {
						cmb_instcd.disabled = false;
					}
					else {
						cmb_instcd.disabled = true;
					}
					
					model.setFocus("cmb_instcd");
				]]>
			</script>
			<submission id="TRRWP03111" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecdata"/>
			<submission id="TRRWP03102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payamtexcel"/>
		</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="9" style="left:1130px; top:17px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					
						if (grd_payamtlist.nodeset.length> 0) {
							//model.removeNodeset(grd_payamtlist.nodeset);
							model.removeNodeset(grd_payamtlist.nodeset);
							grd_payamtlist.nodeset = "/root/init/temp";

							//"/root/main/payspecdata/payamtlist"
							
							for (var i = grd_payamtlist.cols - 1; i >= 1 ; i--) {
								grd_payamtlist.removeColumn(false);
							}

							grd_payamtlist.caption = "";
							model.refresh();
							grd_payamtlist.rebuild();
						}
						submit("TRRWP03111");
						
						
						var node = instance1.selectNodes("/root/main/payspecdata/payamtlist[1]/*");
						
						var payitemcnt = model.getValue("/root/main/payspecdata/paytitlelist/payitemcnt") ;
						
						
						for(i=0;i<payitemcnt;i++) {
							if (i < 22 ) {
								grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" , false);
							}
							else if (i == 138) {
								grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" , false);
							}
							else {
								
								grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + " style:" + "text-align:right; ", false);
							}
						}
						grd_payamtlist.colAttribute(grd_payamtlist.colRef("payitem151"), "format") = "";
						var saldfrayflag = model.getValue("/root/send/payspec/saldfrayflag");
						
						if (saldfrayflag == "3") {
							grd_payamtlist.colwidth(18) = 60;
							grd_payamtlist.colwidth(19) = 60;
							grd_payamtlist.colwidth(20) = 100;
							grd_payamtlist.colwidth(21) = 100;
							grd_payamtlist.colwidth(22) = 100;
						}
						else {
							grd_payamtlist.colwidth(18) = 0;
							grd_payamtlist.colwidth(19) = 0;
							grd_payamtlist.colwidth(20) = 0;
							grd_payamtlist.colwidth(21) = 0;
							grd_payamtlist.colwidth(22) = 0;
						}
								
						grd_payamtlist.frozenCols = 2;

						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.rebuild();
						
						grd_payamtlist.subtotalposition = "below";
						for(i=0;i<payitemcnt;i++) {
							if (i >= 22 && i <= 142) {
								grd_payamtlist.subtotal("sum",-1 , grd_payamtlist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
							}
						}
						
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1120px; y1:10px; x2:1120px; y2:44px; "/>
			<button id="btn_emplno" class="icon_search" navindex="7" style="left:1011px; 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>
			<caption id="caption1" class="search_name" style="left:890px; top:18px; width:63px; height:17px; ">사번 :</caption>
			<input id="ipt_emplnos" ref="/root/send/payspec/emplno" class="input_default" navindex="6" style="left:951px; top:18px; width:57px; 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" navindex="8" style="left:1030px; top:18px; width:71px; 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:2px; y1:69px; x2:1192px; y2:69px; "/>
			<caption id="caption34" class="tit_2" style="left:3px; top:54px; width:144px; height:14px; ">급여 합산 내역 List</caption>
			<caption id="caption21" class="search_name" style="left:205px; top:18px; width:86px; height:17px; ">급여종류:</caption>
			<select1 id="cmb_SalDfrayFlag" ref="/root/send/payspec/saldfrayflag" class="combo_s_essential" navindex="2" appearance="minimal" style="left:286px; top:17px; width:95px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						/*
						if (DUTY_PAY_YN == "Y" || cmb_SalDfrayFlag.value == "2") {
							cmb_instcd.disabled = false;
							misfComboComCdListMulti("Z0007,R0112,R0097","cmb_instcd,cmb_SalDfrayFlag,cmb_payclsprfshipflag");
						}
						else {
							cmb_instcd.disabled = true;
							misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
							
							model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
							
						}
						model.refresh();
						*/
					]]>
				</script>
			</select1>
			<caption id="caption22" class="search_name" style="left:400px; top:18px; width:55px; height:17px; ">기간:</caption>
			<input id="ipt_payfromym" ref="/root/send/payspec/payfromym" class="input_default" navindex="3" inputtype="date" format="yyyy-mm" style="left:455px; top:17px; width:106px; height:19px; text-align:center; vertical-align:middle; "/>
			<datagrid id="grd_payamtlist" colsep="^" explorerbar="sort" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:2px; top:75px; width:1190px; height:660px; "/>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1125px; top:48px; 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");
						  var param  =  "&instcd=" + model.getValue("/root/send/payspec/instcd");   
								param += "&saldfrayflag=" + model.getValue("/root/send/payspec/saldfrayflag");  
								param += "&payfromym=" + model.getValue("/root/send/payspec/payfromym");       
								param += "&emplno=" + model.getValue("/root/send/payspec/emplno");      
								param += "&payclsprfshipflag=" + model.getValue("/root/send/payspec/payclsprfshipflag");    
								param += "&paytoym=" + model.getValue("/root/send/payspec/paytoym"); 


							//model.download(getActionURL("TRRWP02102")+"&param=live",fileName);
							//alert(getActionURL("TRRWP02103") );
							model.download(getActionURL("TRRWP03102") + param, fileName, true);
							
							window.exec(fileName);
							//submit("TRRWP02102");
						}			
						*/
						var fileName = window.fileDialog ("save", ",", false, "excel", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");

						if (fileName != "")
						{
							grd_payamtlist.saveExcel(fileName, "sheetname:savetype");
						}			

					]]>
				</script>
			</button>
			<select1 id="cmb_instcd" ref="/root/send/payspec/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:61px; top:17px; width:129px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption3" class="search_name" style="left:5px; top:18px; width:56px; height:17px; ">기관:</caption>
			<select1 id="cmb_payclsprfshipflag" ref="/root/send/payspec/payclsprfshipflag" class="combo_s_essential" navindex="5" appearance="minimal" style="left:779px; top:18px; width:100px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption4" class="search_name" style="left:692px; top:19px; width:92px; height:17px; ">호봉구분 :</caption>
			<input id="ipt_paytoym" ref="/root/send/payspec/paytoym" class="input_default" navindex="4" inputtype="date" format="yyyy-mm" style="left:580px; top:17px; width:106px; height:19px; text-align:center; vertical-align:middle; "/>
			<caption id="caption2" style="left:565px; top:17px; width:10px; height:20px; ">-</caption>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
	</xhtml:body>
</xhtml:html>