YNU_JEUS/app_home/himed/webapps/mis/paybnusmngtweb/xrw/SMRWP10100_직종별인건비현황.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>
						<payrwpdympylist>
							<payym/>
							<saldfrayflag/>
							<groupflag/>
							<flagnm/>
							<amt/>
							<cnt/>
						</payrwpdympylist>
					</main>
					<init/>
					<send>
						<payym/>
						<payinst/>
						<paytoym/>
						<saldfrayflag/>
					</send>
					<hidden/>
					<grid>
						<targetgrid/>
					</grid>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfMsterDetailSet(datagrid1, null, "TRRWP10101" ,"N"); 
					
					misfGridInit(datagrid1);
//					.deleteRow(grd_payrwpdympylist.fixedRows, false);

					
					misfComboComCdList("Z0007", cmb_payinst);
					misfComboComCdListMulti("R0112","cmb_SalDfrayFlag");
					
					var today = getCurrentDate();
					var cur_yymm = parseInt(today.substring(0, 6));
					
					model.setValue("/root/send/payym", cur_yymm);
					model.setValue("/root/send/paytoym", cur_yymm);
					model.setValue("/root/send/payinst", getUserInfo("dutplceinstcd")); // 기관 설정
					model.setValue("/root/send/saldfrayflag", "1");
					
					misfGetUserAuth();
					
					if (DUTY_PAY_YN == "Y" ) {
						cmb_payinst.disabled = false;
					}
					else {
						cmb_payinst.disabled = true;
					}
					
					model.refresh();
				]]>
			</script>
			<submission id="TRRWP10101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/payrwpdympylist"/>
		</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"/>
		<script type="javascript">
			<![CDATA[
				
				function setGrid()
				{
					//Start  그리드 초기화 작업. 노드고 뭐고 싹~!!! 다지워~!! 
					for (var i = datagrid1.cols - 1; i >= 1 ; i--) 
					{
						datagrid1.removeColumn(false);
					}					
					
					misfGridInit(grd_payrwpdympylist);
					//End 그리드 초기화 작업. 노드고 뭐고 싹~!!! 다지워~!! 
					
					
					
					//그리드 노드,컬럼,로우 설정.
					var node = instance1.selectNodes("/root/main/*");
					
					var rowtemp = model.getValue("/root/main/payrwpdympylist[1]/prntseq");
					var colreftemp ='';
					var tempcaption = '';
					
					//col 추가
					for(var i = 1; i <= node.length; i++)
					{						
						if(rowtemp == model.getValue("/root/main/payrwpdympylist["+ i +"]/prntseq"))
						{
							grd_payrwpdympylist.addColumn("ref:" + model.getValue("/root/main/payrwpdympylist["+ i +"]/flagnm") + "; format:" + "(-)#,###;" + " style:" + "text-align:right;");
							
							tempcaption += "^"+model.getValue("/root/main/payrwpdympylist["+ i +"]/flagnm");
						}else{
							break;
						}
					}
					
					//인원수 1 Row 입력
					grd_payrwpdympylist.addRow(false);
					for(var i = 1; i <= grd_payrwpdympylist.cols; i++ )
					{
						grd_payrwpdympylist.valueMatrix(grd_payrwpdympylist.row, grd_payrwpdympylist.colRef(  model.getValue("/root/main/payrwpdympylist["+ i +"]/flagnm") ) ) = model.getValue("/root/main/payrwpdympylist["+ i +"]/cnt");
					}
					
					//row 추가
					rowtemp = 'x';					
					for(var i = 1; i <= node.length; i++)
					{
						if(rowtemp != model.getValue("/root/main/payrwpdympylist["+ i +"]/prntseq"))
						{
							grd_payrwpdympylist.addRow(false);
							grd_payrwpdympylist.valueMatrix(grd_payrwpdympylist.row, grd_payrwpdympylist.colRef("prntbasenm")) = model.getValue("/root/main/payrwpdympylist["+ i +"]/prntbasenm");
							
							rowtemp = model.getValue("/root/main/payrwpdympylist["+ i +"]/prntseq");
						}
						
						//colreftemp = model.getValue("/root/main/payrwpdympylist["+ i +"]/flagnm");
						grd_payrwpdympylist.valueMatrix(grd_payrwpdympylist.row, grd_payrwpdympylist.colRef(  model.getValue("/root/main/payrwpdympylist["+ i +"]/flagnm") ) ) = model.getValue("/root/main/payrwpdympylist["+ i +"]/amt");
					}
					
					grd_payrwpdympylist.caption = tempcaption;
					
					grd_payrwpdympylist.fixedCols = 1;
					
					//fCalculationSet();
					
					grd_payrwpdympylist.rebuild();
				}
				
				
				//Load Data의 추가 계산 로직...
				function fCalculationSet()
				{					
					//상여금(GR),상여금(NT),건강보험,건강(법정) Row Search
					var fRowGR = null;
					var fRowNT = null;
					var fRowHG = null;
					var fRowHC = null;
					
					var fColGR = grd_payrwpdympylist.fixedCols-1;
					
					for(var i = grd_payrwpdympylist.fixedRows; i < grd_payrwpdympylist.rows; i++)
					{
						if(grd_payrwpdympylist.labelMatrix(i, fColGR) == "상여금(GR)" )
						{
							fRowGR = i;
							
							if( (fRowGR != null) && (fRowNT != null) && (fRowHG != null) && (fRowHC != null) )
							{
								break;
							}
						}
						
						if(grd_payrwpdympylist.labelMatrix(i, fColGR) == "상여금(NT)" )
						{
							fRowNT = i;
							
							if( (fRowGR != null) && (fRowNT != null) && (fRowHG != null) && (fRowHC != null) )
							{
								break;
							}
						}
						
						if(grd_payrwpdympylist.labelMatrix(i, fColGR) == "건강보험" )
						{
							fRowHG = i;
							
							if( (fRowGR != null) && (fRowNT != null) && (fRowHG != null) && (fRowHC != null) )
							{
								break;
							}
						}
						
						if(grd_payrwpdympylist.labelMatrix(i, fColGR) == "건강(법정)" )
						{
							fRowHC = i;
							
							if( (fRowGR != null) && (fRowNT != null) && (fRowHG != null) && (fRowHC != null) )
							{
								break;
							}
						}
						
					}
					
					//데이터 넘겨주기....GR -> NT   [레지던트,인턴,전공의계]
					grd_payrwpdympylist.valueMatrix(fRowNT, grd_payrwpdympylist.colRef("레지던트")) = grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("레지던트"));
					grd_payrwpdympylist.valueMatrix(fRowNT, grd_payrwpdympylist.colRef("인턴")) = grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("인턴"));
					grd_payrwpdympylist.valueMatrix(fRowNT, grd_payrwpdympylist.colRef("전공의계")) = grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("전공의계"));
					//grd_payrwpdympylist.valueMatrix(fRowNT, grd_payrwpdympylist.colRef("수도")) = grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("수도"));
					
					grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("레지던트")) = 0;
					grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("인턴")) = 0;
					grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("전공의계")) = 0;
					//grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("수도")) = 0;
					
					
					//데이터 넘겨주기.....GR -> NT [교환직~비정규직] 
					if( (parseInt(ipt_payym.value.substr(4,2)) == 1) || (parseInt(ipt_payym.value.substr(4,2)) == 2) || (parseInt(ipt_payym.value.substr(4,2)) == 8) )
					{
						for(var i = grd_payrwpdympylist.colRef("사무직"); i <= grd_payrwpdympylist.colRef("비정규직"); i++ )
						{
							grd_payrwpdympylist.valueMatrix(fRowNT, i) = grd_payrwpdympylist.valueMatrix(fRowGR, i);
							grd_payrwpdympylist.valueMatrix(fRowGR, i) = 0;
						}
					}
					
					//데이터 넘겨주기....건강보험의 60%를 건강(법정)으로 계산된 값을 설정......건강보험 -> 건강(법정)
					for(var i = grd_payrwpdympylist.fixedCols; i < grd_payrwpdympylist.cols; i++)
					{
						grd_payrwpdympylist.valueMatrix(fRowHC, i) = (parseInt(grd_payrwpdympylist.valueMatrix(fRowHG, i)) * 0.6);
					}
					
					
					//NT 합계 계산.
					var fTotal = 0;				
					
					for(var i = grd_payrwpdympylist.fixedCols; i < grd_payrwpdympylist.cols; i++)
					{
						if( (grd_payrwpdympylist.colAttribute(i, "ref") == "교원계") || 
						   (grd_payrwpdympylist.colAttribute(i, "ref") == "전공의계") || 
						   (grd_payrwpdympylist.colAttribute(i, "ref") == "직원계") ||
						   (grd_payrwpdympylist.colAttribute(i, "ref") == "합계") )
						   {
							continue;
						   }
						   
						fTotal += parseInt(grd_payrwpdympylist.valueMatrix(fRowNT, i));
					}
					
					// NT,GT 합계 입력
					grd_payrwpdympylist.valueMatrix(fRowNT, grd_payrwpdympylist.colRef("합계")) =  fTotal;
					grd_payrwpdympylist.valueMatrix(fRowGR, grd_payrwpdympylist.colRef("합계")) -= fTotal;
					
				}
					
			]]>
		</script>
	</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" style="left:1130px; top:17px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						submit("TRRWP10101");
						
						//setGrid();
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1120px; y1:10px; x2:1120px; y2:44px; "/>
			<caption id="cap_payinst" class="search_name" style="left:8px; top:19px; width:86px; height:17px; ">기    관 :</caption>
			<select1 id="cmb_payinst" ref="/root/send/payinst" class="combo_s_essential" navindex="1" appearance="minimal" style="left:91px; top:18px; width:169px; height:19px; text-align:center; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption22" class="search_name" style="left:321px; top:19px; width:94px; height:17px; ">조회년월 :</caption>
			<input id="ipt_payym" ref="/root/send/payym" class="input_s_essential" navindex="2" inputtype="date" format="yyyy-mm" style="left:410px; top:18px; width:94px; height:19px; text-align:center; vertical-align:middle; "/>
			<caption id="caption28" class="tit_2" style="left:5px; top:58px; width:144px; height:13px; ">인건비현황</caption>
			<line id="line193" class="line_1" style="x1:2px; y1:71px; x2:1192px; y2:71px; "/>
			<button id="btn_saveexcel" class="btn5_letter4" style="left:1127px; top:51px; 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 != "")
						{
							datagrid1.fixedCols = 0;
							datagrid1.saveExcel(fileName,"sheetname:sheet1");
							datagrid1.fixedCols = 1;
						}			
					]]>
				</script>
			</button>
			<input id="ipt_paytoym" ref="/root/send/paytoym" class="input_s_essential" navindex="3" inputtype="date" format="yyyy-mm" style="left:515px; top:18px; width:94px; height:19px; text-align:center; vertical-align:middle; "/>
			<caption id="caption1" style="left:505px; top:18px; width:10px; height:19px; ">-</caption>
			<caption id="caption21" class="search_name" style="left:665px; top:19px; width:86px; height:17px; ">급여종류:</caption>
			<select1 id="cmb_SalDfrayFlag" ref="/root/send/saldfrayflag" class="combo_s_essential" appearance="minimal" style="left:746px; top:18px; 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"));
							model.refresh();
						}
						*/
					]]>
				</script>
			</select1>
			<datagrid id="datagrid1" nodeset="/root/main/payrwpdympylist" caption="지급년월^급여종류^직종코드^직종명^급여총액^인원수" colsep="^" colwidth="123, 160, 125, 282, 234, 139" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowsep="|" style="left:2px; top:75px; width:1190px; height:662px; ">
				<col ref="payym" format="yyyy-mm" style="text-align:center; "/>
				<col ref="saldfrayflag" style="text-align:left; "/>
				<col ref="groupflag" style="text-align:center; "/>
				<col ref="flagnm" style="text-align:left; "/>
				<col ref="amt" format="(-)#,###" style="text-align:right; "/>
				<col ref="cnt" format="#,###" style="text-align:center; "/>
			</datagrid>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
	</xhtml:body>
</xhtml:html>