YNU_JEUS/app_home/himed/webapps/mis/paybnusmngtweb/xrw/SMRWP02200_부서별급여내역조회.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>
						<payspecdata>
							<payamtlist/>
							<paytitlelist/>
						</payspecdata>
					</main>
					<init>
						<temp/>
					</init>
					<send>
						<payspec>
							<saldfrayflag/>
							<payfromym/>
							<paytoym/>
							<dutdeptcd/>
							<instcd/>
							<payclsprfshipflag/>
							<holyordflag/>
						</payspec>
					</send>
					<hidden/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
			
					/* Combo Data Setting
					    misfComboComCdListMulti(공통코드군, Combo)  */
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
					misfComboComCdListMulti("R0112,R0066,R0097","cmb_SalDfrayFlag,cmb_holyordflag,cmb_payclsprfshipflag");
					var curdate = getCurrentDate();
					var cvtdate = curdate.toDate("YYYYMM");
					
					//model.setValue(ipt_payfromym.attribute("ref") ,  cvtdate.getAddDate(-1,"M").getDateFormat("YYYYMM"));
					model.setValue(ipt_payfromym.attribute("ref") ,  cvtdate.getAddDate(0,"M").getDateFormat("YYYYMM"));
					model.setValue(ipt_paytoym.attribute("ref") , model.getValue(ipt_payfromym.attribute("ref")));
					model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
					model.setValue(cmb_SalDfrayFlag.attribute("ref") , "1");
					
					rszfComboAppendBlankChild("cmb_payclsprfshipflag");
					rszfComboAppendBlankChild("cmb_holyordflag");
					model.setValue(cmb_payclsprfshipflag.attribute("ref") , "");	
					model.setValue(cmb_holyordflag.attribute("ref") , "");	
					
					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y" ) {
						cmb_instcd.disabled = false;
					}
					else {
						cmb_instcd.disabled = true;
					}
					
					model.refresh();

					model.setFocus("cmb_instcd");
				]]>
			</script>
			<submission id="TRRWP02201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payspec" resultref="/root/main/payspecdata"/>
		</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/miscommonweb/js/RSZ001.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="7" 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("/root/main/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("TRRWP02201");

						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 == 0) {
								grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " style:" + "text-align:left; ", false);
							}
							else {
								//grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + " style:" + "text-align:right; ", false);
								grd_payamtlist.addColumn("ref:" + node.item(i).nodeName + "; type:output;" + " format:" + "(-)#,###;" + "savetype:" + "digit;"  + " style:" + "text-align:right; ", false);
							}
						}
						
						if(grd_payamtlist.cols > 3)
					   	{
					   		grd_payamtlist.colwidth(1) = 150;
					   		grd_payamtlist.colwidth(2) = 50;
					   		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";
						if (node.length > 0 ) {
							for(i=0;i<payitemcnt;i++) {
								if (i >= 1) {
									grd_payamtlist.subtotal("sum",-1 , grd_payamtlist.colRef(node.item(i).nodeName), "format:#,###; ", "background-color:#ffff99; font-weight:bold; ", 1, "합계");	
								}
							}
						} 
					   	

					    	

//					   	model.refresh();
//					    grd_payamtlist.refresh();	


					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1120px; y1:10px; x2:1120px; y2:44px; "/>
			<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:157px; height:13px; ">부서별 급여 내역 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:16px; width:125px; 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;
						}
						else {
							cmb_instcd.disabled = true;
							model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
							
						}
						
						if (cmb_SalDfrayFlag.value == "2") {
							misfComboComCdListMulti("R0112,R0097,R0066,Z0007","cmb_SalDfrayFlag,cmb_payclsprfshipflag,cmb_holyordflag,cmb_instcd");
							
							addComboItem( "cmb_instcd", "[-- 전체 --]", " ", "above");
							addComboItem( "cmb_payclsprfshipflag", "[-- 전체 --]", " ", "above");
							rszfComboAppendBlankChild("cmb_holyordflag");
							model.setValue(cmb_instcd.attribute("ref"), " ");
						}
						else {
							misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","N");
							misfComboComCdListMulti("R0112,R0066,R0097","cmb_SalDfrayFlag,cmb_holyordflag,cmb_payclsprfshipflag");

							addComboItem( "cmb_payclsprfshipflag", "[-- 전체 --]", " ", "above");
							rszfComboAppendBlankChild("cmb_holyordflag");
							model.setValue(cmb_payclsprfshipflag.attribute("ref"), " ");
							model.setValue(cmb_holyordflag.attribute("ref"), "");
							model.setValue(cmb_instcd.attribute("ref") , getUserInfo("dutplceinstcd"));
						}	
						model.refresh();
					]]>
				</script>
			</select1>
			<caption id="caption22" class="search_name" style="left:420px; top:18px; width:85px; height:17px; ">지급월:</caption>
			<input id="ipt_payfromym" ref="/root/send/payspec/payfromym" class="input_default" navindex="3" inputtype="date" format="yyyy-mm" style="left:489px; top:16px; 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);
							grd_payamtlist.saveExcel(fileName, "SheetName:sheet1");
						}			
					]]>
				</script>
			</button>
			<select1 id="cmb_instcd" ref="/root/send/payspec/instcd" class="combo_s_essential" navindex="1" appearance="minimal" style="left:69px; top:17px; width:125px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption3" class="search_name" style="left:10px; top:18px; width:61px; height:17px; ">기관:</caption>
			<select1 id="cmb_holyordflag" ref="/root/send/payspec/holyordflag" class="combo_s_essential" navindex="5" appearance="minimal" style="left:805px; top:16px; width:100px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption4" class="search_name" style="left:718px; top:18px; width:87px; height:17px; ">직원구분 :</caption>
			<input id="ipt_paytoym" ref="/root/send/payspec/paytoym" class="input_default" navindex="4" visibility="visible" inputtype="date" format="yyyy-mm" style="left:597px; top:16px; width:106px; height:19px; text-align:center; vertical-align:middle; "/>
			<select1 id="cmb_payclsprfshipflag" ref="/root/send/payspec/payclsprfshipflag" class="combo_s_essential" navindex="6" appearance="minimal" style="left:1005px; top:16px; width:100px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption1" class="search_name" style="left:918px; top:18px; width:87px; height:17px; ">호봉구분 :</caption>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
	</xhtml:body>
</xhtml:html>