YNU_JEUS/app_home/himed/webapps/mis/humtrafactmngtweb/xrw/SMRPB12100_직급별 부서별 현황조회.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>
						<datalist/>
					</main>
					<init/>
					<send>
						<psndd/>
						<psninstcd/>
						<flag>1</flag>
						<nursall/>
					</send>
					<hidden/>
					<grid>
						<targetgrid/>
					</grid>
					<bakgrid>
						<targetgrid/>
					</bakgrid>
					<temp>
						<source/>
					</temp>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					misfMsterDetailSet(grd_psndatalist, null, "TRRPB12101" ,"N"); 
					
					misfGridInit(grd_psndatalist);
					
//					misfComboComCdList("Z0007", cmb_psninstcd);
//					addGridComboItem("cmb_psninstcd", "전체", "","above");			
					
					model.setValue("/root/send/psndd",	 getCurrentDate());
					
					misfComboInstCdListMulti("cmb_psninstcd", ipt_psndd.value,"","Y","N");
					model.setValue("/root/send/psninstcd", getUserInfo("dutplceinstcd")); // 기관 설정
					
					misfGetAndSetUserInfo();
					misfGetUserAuth();
					if(PSN_INST_YN != "Y") {
						cmb_psninstcd.disabled = true;
					}
					
					// 간호부일때는 간호부전체 체크박스를 풀수없도록 한다
					if ( DUT_DEPT_CD == "3040200000" ) {
						chk_nursall.value = 'Y'
						chk_nursall.disabled = true;
					}
					
					model.refresh();
				]]>
			</script>
			<submission id="TRRPB12101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/datalist"/>
		</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/stringHelper.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 fDelGridData()
				{
					//Start  그리드 초기화 작업. 노드고 뭐고 싹~!!! 다지워~!! 
					for (var i = grd_psndatalist.cols - 1; i > 6 ; i--) 
					{
						grd_psndatalist.removeColumn(false);
					}
					
					model.removenode("/root/main");
					model.removenode("/root/grid");
					model.removenode("/root/bakgrid");
					model.makeNode("/root/main/datalist");
					model.makeNode("/root/grid/targetgrid");
					model.makeNode("/root/bakgrid/targetgrid");
					
					misfGridInit(grd_psndatalist);					
					//End 그리드 초기화 작업. 노드고 뭐고 싹~!!! 다지워~!!
				}
				
				function fSetGrid()
				{
					var colC = model.getValue("/root/main/psndatalist5/colcount");
					var rowC = model.getValue("/root/main/psndatalist5/rowcount");
					var dataC1 = model.getValue("/root/main/psndatalist5/datacount1");
					var dataC2 = model.getValue("/root/main/psndatalist5/datacount2");
					var colRefTemp = '';
					var tempcaption = '';
					var fcolwidth = "100, 100, 100, 100, 0, 0";
					var totalpostion = 0;
					
					if(rdo_flag.value == '1')
					{
						tempcaption = "Sumflag^Flag^직군^직위^직군^직위";	
					}else if(rdo_flag.value == '2'){
						tempcaption = "Sumflag^Flag^직군^직종^직군^직종";	
					}
					
					//col 추가
					for(var i = 1; i <= colC; i++)
					{
						//노드 명칭이 숫자는 맨앞으로 올 수 없음으로 인해 x라는 임시노드명을 붙여준다.
						colRefTemp = "x" + model.getValue("/root/main/psndatalist3["+ i +"]/cdnm") + model.getValue("/root/main/psndatalist3["+ i +"]/instcd");
						
						if( model.getValue("/root/main/psndatalist3["+ i +"]/cdnm") == '총계'){
							totalpostion = i;
						}
						
						
						grd_psndatalist.addColumn("ref:" + colRefTemp+  ";" + "format:#,###; " + " style:" + "text-align:right;");
						
						model.makeValue("/root/bakgrid/targetgrid/" + colRefTemp, model.getValue("/root/main/psndatalist3["+ i +"]/cdid"));
						
						tempcaption += "^" + model.getValue("/root/main/psndatalist3["+ i +"]/cdnm");
					}
					
					for(var i=1; i <= colC; i++)
					{
						if(totalpostion > i )
						{
							grd_psndatalist.colwidth( (6+i) ) = 30;
						}else{							
							grd_psndatalist.colwidth( (6+i) ) = 60;
						}
					}
										
					
					grd_psndatalist.caption = tempcaption;					
					grd_psndatalist.frozenCols = totalpostion+6;					
					grd_psndatalist.rowHeight(0) = '100';
									
					
					
					//row 추가 
					//직급별 데이터 설정.
					var rowCheck = true;

					grd_psndatalist.addRow(false);
					
					grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("sumflag")) = model.getValue("/root/main/psndatalist1[1]/sumflag");
					grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("flag")) = model.getValue("/root/main/psndatalist1[1]/flag");
					grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("grupjoblnnm")) = model.getValue("/root/main/psndatalist1[1]/grupjoblnnm");
					grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("jobposnm")) = model.getValue("/root/main/psndatalist1[1]/jobposnm");
					grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("grupjoblncd")) = model.getValue("/root/main/psndatalist1[1]/grupjoblncd");
					grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("jobposcd")) = model.getValue("/root/main/psndatalist1[1]/jobposcd");
					
					
					for(var s = 1; s <= dataC1; s++)
					{
						//row 추가 여부 설정 temp.
						rowCheck = true;
						
						//직군 직위 중복시 데이터 설정...중복 데이터가 없을시 row 추가.
						for(var i = grd_psndatalist.fixedRows; i < grd_psndatalist.rows; i++)
						{
							
							if( (grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef("sumflag")) == model.getValue("/root/main/psndatalist1["+ s +"]/sumflag")) &&
							  (grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef("grupjoblnnm")) == model.getValue("/root/main/psndatalist1["+ s +"]/grupjoblnnm")) &&
							  (grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef("jobposnm")) == model.getValue("/root/main/psndatalist1["+ s +"]/jobposnm")) )
							  {
							  	colRefTemp = "x" + model.getValue("/root/main/psndatalist1["+ s +"]/jobgradnm");							  	
								grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef(colRefTemp)) = parseInt(grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef(colRefTemp)) == "" ? 0 : grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef(colRefTemp)) ) +  parseInt(model.getValue("/root/main/psndatalist1["+ s +"]/cnt") == "" ? 0 : model.getValue("/root/main/psndatalist1["+ s +"]/cnt") );

							  	rowCheck = false;
							  	break;							  	
							  }
						}
						
						if(rowCheck)
						{
							grd_psndatalist.addRow(false);
							
							grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("grupjoblnnm")) = model.getValue("/root/main/psndatalist1["+ s +"]/grupjoblnnm");
							grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("jobposnm")) = model.getValue("/root/main/psndatalist1["+ s +"]/jobposnm");
							
							grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("grupjoblncd")) = model.getValue("/root/main/psndatalist1["+ s +"]/grupjoblncd");
							grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef("jobposcd")) = model.getValue("/root/main/psndatalist1["+ s +"]/jobposcd");
							
							//flag 설정.
						  	grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("flag")) = model.getValue("/root/main/psndatalist1["+ s +"]/flag");
						  	grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("sumflag")) = model.getValue("/root/main/psndatalist1["+ s +"]/sumflag");
							
							colRefTemp = "x" + model.getValue("/root/main/psndatalist1["+ s +"]/jobgradnm");
							grd_psndatalist.valueMatrix( grd_psndatalist.row, grd_psndatalist.colRef(colRefTemp)) = parseInt( model.getValue("/root/main/psndatalist1["+ s +"]/cnt") == "" ? 0 : model.getValue("/root/main/psndatalist1["+ s +"]/cnt") );
						}
					}					
					
					//부서별 데이터 설정
					for(var s = 1; s <= dataC2; s++)
					{						
						for(var i = grd_psndatalist.fixedRows; i < grd_psndatalist.rows; i++)
						{
							if((grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef("sumflag")) == model.getValue("/root/main/psndatalist2["+ s +"]/sumflag")) &&
							  (grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef("grupjoblnnm")) == model.getValue("/root/main/psndatalist2["+ s +"]/grupjoblnnm")) &&
							  (grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef("jobposnm")) == model.getValue("/root/main/psndatalist2["+ s +"]/jobposnm")) )
							  {
							  	colRefTemp = "x" + model.getValue("/root/main/psndatalist2["+ s +"]/deptnm") + model.getValue("/root/main/psndatalist2["+ s +"]/dutplceinst");
							  	grd_psndatalist.valueMatrix(i, grd_psndatalist.colRef( colRefTemp )) = parseInt( model.getValue("/root/main/psndatalist2["+ s +"]/cnt") == "" ? 0 : model.getValue("/root/main/psndatalist2["+ s +"]/cnt") );
							  	break;
							  }
						}
					}
					
					grd_psndatalist.selectionMode = "byrow";
					grd_psndatalist.refresh();
					
					fSetTotal();
					
				}
				
				function fSetTotal()
				{
					grd_psndatalist.subtotal("clear", 0, 0);					
					
					for(var i = 7; i < grd_psndatalist.cols; i++)
					{						
						grd_psndatalist.subTotal("sum", 1, i, "format:#,###; ", "background-color:#f99999; font-weight:bold; ", 4, "합계");
					}
					
					for(var i = 7; i < grd_psndatalist.cols; i++)
					{						
						grd_psndatalist.subTotal("sum", 3, i, "format:#,###; ", "background-color:#fff999; font-weight:bold; ", 4, "소계");
					}
					
					
					for(var i = 7; i < grd_psndatalist.cols; i++)
					{						
						grd_psndatalist.subTotal("sum", -1, i, "format:#,###; ", "background-color:#999999; font-weight:bold; ", 4, "총계");
					}
				}
			]]>
		</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[
						
						//그리드 관련 data 초기화.
						fDelGridData();
					
						//현황조회 select
						submit("TRRPB12101");

						//data 설정.
						fSetGrid();
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1120px; y1:10px; x2:1120px; y2:44px; "/>
			<caption id="cap_psninstcd" class="search_name" style="left:8px; top:19px; width:86px; height:17px; ">기    관 :</caption>
			<select1 id="cmb_psninstcd" ref="/root/send/psninstcd" class="combo_s_essential" 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_psndd" ref="/root/send/psndd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:410px; top:18px; width:135px; height:19px; text-align:center; vertical-align:middle; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var instcd = cmb_psninstcd.value;
						if( getStringLength(ipt_psndd.value) == "8" ) {
							model.removeNodeset(cmb_psninstcd.attribute("ref"));
							model.makeNode("/root/send/psninstcd");
							misfComboInstCdListMulti("cmb_psninstcd",ipt_psndd.value,"","Y","N");
							cmb_psninstcd.value = instcd;
							model.refresh();
						}
					]]>
				</script>
			</input>
			<caption id="caption28" class="tit_2" style="left:5px; top:58px; width:144px; height:14px; ">현황조회 List</caption>
			<line id="line193" class="line_1" style="x1:2px; y1:71px; x2:1192px; y2:71px; "/>
			<datagrid id="grd_psndatalist" nodeset="/root/grid/targetgrid" caption="^^^" colsep="^" colwidth="100, 100, 100, 100" extendlastcol="scroll" frozencols="2" mergecellsfixedrows="byrow" rowheader="seq" rowsep="|" selectionmode="byrow" subtotalposition="below" style="left:0px; top:76px; width:1195px; height:659px; text-align:center; ">
				<col ref="sumflag" visibility="hidden"/>
				<col ref="flag" visibility="hidden"/>
				<col ref="grupjoblnnm"/>
				<col ref="jobposnm"/>
				<col ref="grupjoblncd" visibility="hidden"/>
				<col ref="jobposcd" visibility="hidden"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
//						alert(grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("grupjoblncd")));
//						alert(grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("jobposcd")));
						
//						alert(grd_psndatalist.colAttribute(grd_psndatalist.col, "ref"));
						var grupjoblncd = "";
						var jobposnm = "";
						var jobposcd = "";
						var jobkindcd  = "";
						var ojobgradcd  = "";
						var njobgradcd  = "";
						var deptcd = ""
						var colname = "";
						var sumflag = "";
						var totflag = "";
						var nursall = "";
						
						grupjoblncd = grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("grupjoblncd"));
						jobposnm = grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("jobposnm"));
						sumflag = grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("sumflag"));
//						alert(jobposnm);
						
						if (jobposnm == "소계") {
							grupjoblncd = grd_psndatalist.valueMatrix(grd_psndatalist.row - 1, grd_psndatalist.colRef("grupjoblncd"));
							sumflag = grd_psndatalist.valueMatrix(grd_psndatalist.row - 1, grd_psndatalist.colRef("sumflag"));
						}
						else if (jobposnm == "합계") {
							grupjoblncd = "";
							sumflag = grd_psndatalist.valueMatrix(grd_psndatalist.row - 2, grd_psndatalist.colRef("sumflag"));
							
						}
						else if (jobposnm == "총계") {
							grupjoblncd = "";
							sumflag = "99";
							
						}
						else {
							if (rdo_flag.value == "1") {
								jobposcd = grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("jobposcd"));
								jobkindcd = "";
							}
							else {
								jobposcd = ""
								jobkindcd = grd_psndatalist.valueMatrix(grd_psndatalist.row, grd_psndatalist.colRef("jobposcd"));
							}
							
							
						}
						
						colname = grd_psndatalist.colAttribute(grd_psndatalist.col, "ref");
						if (grd_psndatalist.col >= 7 && grd_psndatalist.col  <= 17 ) {
//							if (grupjoblncd == "00") {
//								ojobgradcd = "";
//								njobgradcd = "";
//							}
//							else {
								if  (rdo_flag.value == "1") {
									ojobgradcd =  model.getValue("/root/bakgrid/targetgrid/" + colname);
									njobgradcd = "";
								}
								else {
									njobgradcd =  model.getValue("/root/bakgrid/targetgrid/" + colname);
									ojobgradcd = "";
								}
//							}
							
							deptcd = "";
						}
						else {
							ojobgradcd =  "";
							njobgradcd = "";
							deptcd = model.getValue("/root/bakgrid/targetgrid/" + colname);
						}
						
						if (jobposnm == "합계" && (ojobgradcd =="TOT" || njobgradcd =="TOT" ) ) {
							totflag = "A";
						}
						else if (jobposnm == "총계" && (ojobgradcd =="TOT" || njobgradcd =="TOT" ) ) {
							totflag = "B";
						}
						else {
							totflag = "C";
						}
						
//						alert(model.getValue("/root/bakgrid/targetgrid/" + colname));
//						alert(ojobgradcd);
//						alert(njobgradcd);
//						alert(deptcd);
						
						
						model.removenode("/root/temp/source");
						model.makeNode("/root/temp/source");
						model.makeValue("/root/temp/source/psndd",          ipt_psndd.value);
						model.makeValue("/root/temp/source/grupjoblncd",      grupjoblncd);
						model.makeValue("/root/temp/source/jobposcd",      jobposcd);
						model.makeValue("/root/temp/source/jobkindcd", jobkindcd);
						model.makeValue("/root/temp/source/psninstcd", cmb_psninstcd.value); 
						model.makeValue("/root/temp/source/ojobgradcd", ojobgradcd); 
						model.makeValue("/root/temp/source/njobgradcd", njobgradcd); 
						model.makeValue("/root/temp/source/deptcd", deptcd); 
						model.makeValue("/root/temp/source/sumflag", sumflag); 
						model.makeValue("/root/temp/source/totflag", totflag); 
						model.makeValue("/root/temp/source/nursall", chk_nursall.value); 
						
						
						modal("SPRPB12101","","","","","/root/temp/source", "/root/target" );
						
						
					]]>
				</script>
			</datagrid>
			<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 != "")
						{
							grd_psndatalist.fixedCols = 0;
							grd_psndatalist.saveExcel(fileName,"sheetname:sheet1");
							grd_psndatalist.fixedCols = 1;
						}			
					]]>
				</script>
			</button>
			<select1 id="rdo_flag" ref="/root/send/flag" appearance="full" cellspacing="30" cols="2" overflow="visible" style="left:727px; top:18px; width:165px; height:20px; border-style:none; ">
				<choices>
					<item>
						<label>구직급</label>
						<value>1</value>
					</item>
					<item>
						<label>신직급</label>
						<value>2</value>
					</item>
				</choices>
			</select1>
			<caption id="caption1" class="search_name" style="left:630px; top:19px; width:94px; height:17px; ">직급 구분 :</caption>
			<select id="chk_nursall" ref="/root/send/nursall" overflow="visible" appearance="full" style="left:950px; top:18px; width:85px; height:20px; border-style:none; ">
				<choices>
					<item>
						<label>간호부전체</label>
						<value>Y</value>
					</item>
				</choices>
			</select>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
	</xhtml:body>
</xhtml:html>