YNU_JEUS/app_home/himed/webapps/mis/humtrafactmngtweb/xrw/SMRPB12200_의사인력현황.xrw

<?xml version="1.0" encoding="UTF-8"?>
<?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>
					</main>
					<init/>
					<send>
						<drdd/>
						<drinstcd/>
					</send>
					<hidden/>
					<grid>
						<datalist>
							<drdatalist/>
						</datalist>
					</grid>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize() ;
				]]>
			</script>
			<submission id="TRRPB12201" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/grid/datalist/drdatalist"/>
		</model>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript" src="../../../mis/paybnusmngtweb/js/RWP001.js"/>
		<script type="javascript">
			<![CDATA[
				function fInitialize() 
				{
//					misfComboComCdList("Z0007", cmb_instcd);
//					addGridComboItem("cmb_instcd", "전체", "","above");	// 기관콤보박스에 '전체'를 추가
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","Y","Y");
					
					model.setValue("/root/send/drdd", getCurrentDate());
					model.setValue("/root/send/drinstcd", getUserInfo("dutplceinstcd")); // 사용자 세션에 있는 기관코드로 설정
					
					misfGetUserAuth();
					if(PSN_INST_YN != "Y") {
						cmb_instcd.disabled = true;
					}
					
					misfGridInit(grd_drdatalist);
					fDelGridData();
					model.refresh();
				}
			
				function fDelGridData()
				{
					//그리드 초기화 작업
					model.removeNodeset("/root/grid");
					grd_drdatalist.rowHeight(0) = '50';
					grd_drdatalist.rowHeight(1) = '50';
					model.makeNode("/root/grid/datalist");
					misfGridInit(grd_drdatalist);
				}
				
				var flag = 0;						// flag     0 : 내과가 없는 기관, 1: 내과가 있는 기관(내과소계 생성), 
				function fSetSum()
				{
					var sum = 0;
					var rows = grd_drdatalist.rows;
					var temp = 0;
					for(var i=2; i <=37; i++) {
						for(var j=2 ; j <= rows; j++) {
							temp = model.getValue("/root/grid/datalist/drdatalist["+ j +"]/deptcd");
							if( temp.substr(0,3) == '201' )
							{
								flag++;
								if( flag == 1 ) {
									grd_drdatalist.insertRow(2);
									grd_drdatalist.valueMatrix(2,1) =  "내과소계";
									grd_drdatalist.valueMatrix(2,grd_drdatalist.colRef("deptcd") ) =  "201";
									grd_drdatalist.rowStyle(2, "all","background-color") = "#9966ff";
									flag++;
								}
								flag--;
								var temp = grd_drdatalist.valueMatrix(j+1, i);
								sum = parseInt(sum) + parseInt(temp);
							}
							else {
								if(flag == 0 )
									break;
							}// end if
						}	// end for(j)                 
						if(flag == 0) {
							break;				// 내과가 없는 기관일 경우 내과소계가 필요없으므로 빠져나간다.
						}
						j = 2;
						grd_drdatalist.valueMatrix(2, i) = sum;
						sum = 0;
					}	// end for(i)
				}
					
				function fSetTotal()
				{
					grd_drdatalist.addRow();
					var rows = grd_drdatalist.rows;	
					var sum = 0;
					var temp = 0;
					var j=2;
					for(var i=2; i <= 37; i++) {
						if(flag > 0 )
							j++;										// 내과소계가 있을경우에는 내과소계는 총계에서 제외해야 하므로 j++한다.
						for( ; j < rows-1; j++) {
							var temp = grd_drdatalist.valueMatrix(j, i);
							sum = parseInt(sum) + parseInt(temp);
						}	// end for(j)
						grd_drdatalist.valueMatrix(j, 1) =  "총   계";
						grd_drdatalist.valueMatrix(j, i) = parseInt(sum);
						grd_drdatalist.rowStyle(j, "all","background-color") = "#99ccff";
						sum = 0;
						j = 2;
					}	// end for(i)
				}
			]]>
		</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();
						flag = 0;
						//현황조회 select
						submit("TRRPB12201");
						grd_drdatalist.colStyle(grd_drdatalist.colRef("prfamt"),"data","background-color") = "#ffff99";		// 교수 계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("subprfamt"),"data","background-color") = "#ffff99";		// 부교수 계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("joprfamt"),"data","background-color") = "#ffff99";	// 조교수 계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("reglramt"),"data","background-color") = "#ffff99";	// 전임강사 계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("tchramt"),"data","background-color") = "#ffff99";	// 교원소계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("dramt"),"data","background-color") = "#ffcc99";	// 전문의소계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("residentamt"),"data","background-color") = "#ffff99";	// R소계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("apptcdramt"),"data","background-color") = "#ffcc99";	// 전공의 소계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("assistamt"),"data","background-color") = "#ffcc99";	// 조교 소계
						grd_drdatalist.colStyle(grd_drdatalist.colRef("amt"),"data","background-color") = "#ff9900";	// 총계
						if( grd_drdatalist.rows != grd_drdatalist.fixedRows )	{		// 고정된 행이 두개이므로 조회내역이 없어도 grd_drdatalist.rows는 2이다.
							fSetSum();
							fSetTotal();
								
							grd_drdatalist.refresh();	
						}
						else
							messageBox("조회내역이","I004");
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1120px; y1:12px; x2:1120px; y2:42px; "/>
			<caption id="cap_instcd" class="search_name" style="left:13px; top:19px; width:86px; height:17px; ">기    관 :</caption>
			<select1 id="cmb_instcd" ref="/root/send/drinstcd" class="combo_s_essential" appearance="minimal" style="left:96px; top:18px; width:189px; height:19px; text-align:center; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						flag = 0;
					]]>
				</script>
			</select1>
			<caption id="caption22" class="search_name" style="left:348px; top:19px; width:94px; height:17px; ">조회년월 :</caption>
			<input id="ipt_dtdd" ref="/root/send/drdd" class="input_s_essential" inputtype="date" format="yyyy-mm-dd" style="left:437px; top:18px; width:135px; height:19px; text-align:center; vertical-align:middle; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var instcd = cmb_instcd.value;
						if( getStringLength(ipt_dtdd.value) == "8" ) {
							model.removeNodeset(cmb_instcd.attribute("ref"));
							model.makeNode("/root/send/drinstcd");
							misfComboInstCdListMulti("cmb_instcd",ipt_dtdd.value,"","Y","Y");
							cmb_instcd.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_drdatalist" nodeset="/root/grid/datalist/drdatalist" autoresize="true" caption="구분^교수^교수^교수^교수^부교수^부교수^부교수^부교수^조교수^조교수^조교수^조교수^전임강사^전임강사^전임강사^전임강사^조&#xA;교^교&#xA;원&#xA;소&#xA;계^휴&#xA;직&#xA;자^임&#xA;상&#xA;강&#xA;사^연&#xA;구&#xA;강&#xA;사^연구계약교원^전&#xA;문&#xA;의&#xA;소&#xA;계^전공의^전공의^전공의^전공의^전공의^전공의^임&#xA;의&#xA;수&#xA;련&#xA;의^전&#xA;공&#xA;의&#xA;소&#xA;계^연&#xA;구&#xA;조&#xA;교^교&#xA;육&#xA;연&#xA;구&#xA;조&#xA;교^조&#xA;교&#xA;소&#xA;계^임&#xA;시&#xA;직&#xA;의&#xA;사^총&#xA;계^부서코드|구분^정^임상^연구^계^정^임상^연구^계^정^임상^연구^계^정^부^연구^계^조&#xA;교^교&#xA;원&#xA;소&#xA;계^휴&#xA;직&#xA;자^임&#xA;상&#xA;강&#xA;사^연&#xA;구&#xA;강&#xA;사^연구계약교원^전&#xA;문&#xA;의&#xA;소&#xA;계^인턴^R1^R2^R3^R4^R&#xA;소계^임&#xA;의&#xA;수&#xA;련&#xA;의^전&#xA;공&#xA;의&#xA;소&#xA;계^연&#xA;구&#xA;조&#xA;교^교&#xA;육&#xA;연&#xA;구&#xA;조&#xA;교^조&#xA;교&#xA;소&#xA;계^임&#xA;시&#xA;직&#xA;의&#xA;사^총&#xA;계^부서코드" colsep="^" colwidth="138, 25, 25, 25, 30, 25, 25, 25, 30, 25, 25, 25, 30, 25, 25, 25, 30, 25, 40, 25, 25, 25, 25, 45, 25, 25, 25, 25, 25, 30, 30, 45, 25, 25, 35, 25, 45, 100" extendlastcol="scroll" frozencols="1" mergecellsfixedrows="bycolrec" rowheader="seq" rowheight="200" rowsep="|" selectionmode="byrow" subtotalposition="below" style="left:0px; top:76px; width:1195px; height:659px; text-align:center; ">
				<col ref="label" style="left:20px; top:43px; width:100px; height:23px; text-align:left; "/>
				<col ref="reglprf" format="#,###" style="text-align:right; "/>
				<col ref="clincprf" format="#,###" style="text-align:right; "/>
				<col ref="stdyprf" format="#,###" style="text-align:right; "/>
				<col ref="prfamt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="reglsubprf" format="#,###" style="text-align:right; "/>
				<col ref="clincsubprf" format="#,###" style="text-align:right; "/>
				<col ref="stdysubprf" format="#,###" style="text-align:right; "/>
				<col ref="subprfamt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="regljoprf" format="#,###" style="text-align:right; "/>
				<col ref="clincjoprf" format="#,###" style="text-align:right; "/>
				<col ref="stdyjoprf" format="#,###" style="text-align:right; "/>
				<col ref="joprfamt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="regllr" format="#,###" style="text-align:right; "/>
				<col ref="subreglr" format="#,###" style="text-align:right; "/>
				<col ref="stdyreglr" format="#,###" style="text-align:right; "/>
				<col ref="reglramt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="assist" format="#,###" style="text-align:right; "/>
				<col ref="tchramt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="layoff" format="#,###" style="text-align:right; "/>
				<col ref="clinclr" format="#,###" style="text-align:right; "/>
				<col ref="stdylr" format="#,###" style="text-align:right; "/>
				<col ref="stdyconlr" format="#,###" style="text-align:right; "/>
				<col ref="dramt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="intern" format="#,###" style="text-align:right; "/>
				<col ref="resident1" format="#,###" style="text-align:right; "/>
				<col ref="resident2" format="#,###" style="text-align:right; "/>
				<col ref="resident3" format="#,###" style="text-align:right; "/>
				<col ref="resident4" format="#,###" style="text-align:right; "/>
				<col ref="residentamt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="apprtcdr" format="#,###" style="text-align:right; "/>
				<col ref="apptcdramt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="stdyassist" format="#,###" style="text-align:right; "/>
				<col ref="edustdyassist" format="#,###" style="text-align:right; "/>
				<col ref="assistamt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="tempdramt" format="#,###" style="text-align:right; "/>
				<col ref="amt" format="#,###" style="font-weight:bold; text-align:right; "/>
				<col ref="deptcd" visibility="hidden"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
					
						var deptcd = grd_drdatalist.valueMatrix(grd_drdatalist.row, grd_drdatalist.colRef("deptcd"));
						var prntflag = grd_drdatalist.col - 1;
						
						if (prntflag <= 0) return;
						
						model.removenode("/root/temp/source");
						model.makeNode("/root/temp/source");
						model.makeValue("/root/temp/source/basedd",ipt_dtdd.value);
						model.makeValue("/root/temp/source/instcd", cmb_instcd.value);
						model.makeValue("/root/temp/source/deptcd", deptcd);
						model.makeValue("/root/temp/source/prntflag", prntflag);
						
						modal("SPRPB12201","","","","","/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_drdatalist.fixedCols = 0;
							grd_drdatalist.saveExcel(fileName,"sheetname:sheet1");
							grd_drdatalist.fixedCols = 1;
						}			
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:13px; width:1195px; height:25px; "/>
	</xhtml:body>
</xhtml:html>