YNU_JEUS/app_home/himed/webapps/mis/educationmngtweb/xrw/SMRPS01300_교육실적통계관리.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>SMRPS01300_교육실적통계관리</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<tableft>
							<educdlist/>
						</tableft>
						<tabright>
							<edudtcdlist/>
						</tabright>
						<grid>
							<rpsdedsflist/>
						</grid>
					</main>
					<send>
						<educcuse>
							<appyy/>
							<mainbdunit/>
							<instcd/>
							<educflag/>
							<educcd/>
							<total>
							</total>
							<chrgdeptcd/>
							<chrgdeptcdnm/>
							<instnm/>
						</educcuse>
						<save>
						</save>
						<dgsend>
							<appyy/>
							<instcd/>
							<educcd/>
							<educdg/>
						</dgsend>
					</send>
					<init>
						<checkbox>
							<label>전체</label>
							<value>Y</value>
						</checkbox>
					</init>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
				    fInitialize();
				]]>
			</script>
			<submission id="TRRPS01306" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/educcuse" resultref="/root/main/tabright"/>
			<submission id="TRRPS01303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/educcuse" resultref="/root/main/tableft"/>
			<submission id="TRRPS01304" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/educcuse" resultref="/root/main/tabright"/>
			<submission id="TRRPS01305" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/educcuse" resultref="/root/main/tabright"/>
			<submission id="TRRPS00203" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/dgsend" resultref="/root/main/grid/rpsdedsflist"/>
			<submission id="TRRPS01307" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/dgsend" resultref="/root/main/grid/rpsdedsflist"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
		<script type="javascript" src="../../../mis/educationmngtweb/js/RPS001.js"/>
		<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
		<script type="javascript">
			<![CDATA[
				function fInitialize() {
					//그리드 초기화 작업
					model.removenode("/root/main");
					model.makeNode("/root/main/tableft");
					model.makeNode("/root/main/tabright");
					model.makeNode("/root/main/grid");
					
					/* Grid 초기화 */
					misfGridInit(grd_educdlist);
					misfGridInit(grd_edudtcdlist);
					misfGridInit(grd_satsfctlist);
					
					var curdate = getCurrentDate();
					
					model.setValue(ipt_appyy.attribute("ref") , curdate.substr(0, 4));
					
					rpsEducSetComboList("M01-001,M01-002","cmb_mainbdunit,cmb_educflag", "Y");
					misfComboComCdListMulti("Z0007","grd_educdlist.instcd");
					misfComboCopyItemSet(cmb_educflag, "", grd_educdlist, "educflag");
					
					model.refresh();
				}
				
				//	쿼리에서 소계까지 계산해서 가져옴.				
				function fSubTotal() {
					grd_edudtcdlist.rebuildStyle() ;
					
					grd_edudtcdlist.rowStyle(grd_edudtcdlist.rows-1,"data","background-color") = "#FFFFCC";
					model.refresh();
				}
			]]>
		</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:20px; width:1195px; height:744px; ">
			<shape id="roundrect" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:5px; width:1190px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<input id="ipt_deptnm" ref="/root/send/educcuse/chrgdeptcdnm" class="input_search" appearance="input" style="left:910px; top:13px; width:140px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if( ipt_deptnm.value.getByteLength() == '0' ) {
							ipt_deptcd.value = "" ;
						}
						model.refresh();
					]]>
				</script>
			</input>
			<button id="button1" class="btn1_letter2" style="left:243px; top:43px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if(model.getValue("/root/send/educcuse/total") == "Y") {
							model.removenode("/root/main/tabright");
							model.makeNode("/root/main/tabright");
							grd_edudtcdlist.rebuildStyle() ;
							
							submit("TRRPS01305");
							
							model.refresh();
						}
					]]>
				</script>
			</button>
			<button id="btn_saveexcel" class="btn2_letter4" style="left:1126px; top:45px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfSaveExcel(grd_edudtcdlist);		
					]]>
				</script>
			</button>
			<select id="chk_total" ref="/root/send/educcuse/total" visibility="visible" appearance="full" style="left:195px; top:46px; width:50px; height:20px; border-style:none; ">
				<choices>
					<itemset nodeset="/root/init/checkbox">
						<label ref="label"/>
						<value ref="value"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="onclick">
					<![CDATA[
						if(model.getValue("/root/send/educcuse/total") == "Y") {
							ipt_educcd.value = "";
							model.setValue("/root/send/educcuse/total",  "Y");	
						}
						else {
							model.setValue("/root/send/educcuse/total",  "");
						}
						model.refresh();
					]]>
				</script>
			</select>
			<select1 id="cmb_mainbdunit" ref="/root/send/educcuse/mainbdunit" class="combo_search" appearance="minimal" style="left:299px; top:13px; width:86px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<button id="button2" class="btn1_letter2" style="left:1125px; top:11px; width:56px; height:22px; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if(ipt_appyy.value == "") {
							messageBox("적용년도는","I003");
							model.setFocus("ipt_appyy");
						}
						else {
							model.removenode("/root/main/tabright");
							model.makeNode("/root/main/tabright");
							submit("TRRPS01303");
						}
					]]>
				</script>
			</button>
			<datagrid id="grd_edudtcdlist" nodeset="/root/main/tabright/edudtcdlist" caption="교육코드^교육명^교육&#xA;차수^교육기간^교육기간^이수&#xA;인원^대상&#xA;인원^참석률^교육시간^교육인시^전체&#xA;만족도^기관별^기관별^기관별^기관별^기관별^기관별^기관별|교육코드^교육명^교육&#xA;차수^from^to^이수&#xA;인원^대상&#xA;인원^참석률^교육시간^교육인시^전체&#xA;만족도^의료원^성의교정^서울^성모^의정부^세종^성바오로" colsep="^" colwidth="71, 249, 40, 98, 96, 52, 50, 65, 40, 40, 55, 60, 60, 60, 60, 60, 60, 60" dataheight="25" explorerbar="sortshow" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:300px; top:70px; width:892px; height:655px; ">
				<col ref="educcd" visibility="hidden" style="text-align:center; "/>
				<col ref="educnm"/>
				<col ref="educdg" style="text-align:center; "/>
				<col disabled="true" ref="educfromdd" type="inputdate" style="text-align:center; "/>
				<col disabled="true" ref="eductodd" type="inputdate" style="text-align:center; "/>
				<col ref="choipsncnt" style="text-align:right; "/>
				<col ref="cntpsn" style="text-align:right; "/>
				<col ref="choipst" format="###.0 %" style="text-align:right; "/>
				<col ref="eductm" maxlength="5" style="text-align:right; "/>
				<col ref="educpsntm" style="text-align:right; "/>
				<col ref="satsfcttotal" style="text-align:right; "/>
				<col ref="inst001" visibility="hidden" style="text-align:center; "/>
				<col ref="inst103" visibility="hidden" style="text-align:center; "/>
				<col ref="inst012" visibility="hidden" style="text-align:center; "/>
				<col ref="inst011" visibility="hidden" style="text-align:center; "/>
				<col ref="inst013" visibility="hidden" style="text-align:center; "/>
				<col ref="inst014" style="text-align:center; "/>
				<col ref="inst015" visibility="hidden" style="text-align:center; "/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
						var row = grd_edudtcdlist.row;
						var col = grd_edudtcdlist.col;
						if(chk_total.value != 'Y') {
							if( col == grd_edudtcdlist.colRef("satsfcttotal") ) {
								//선택된 row의 교육코드와 년도, 차수를 가지고 세부만족도를 조회한다. 구분은 N
								grd_satsfctlist.visible = true;
								grd_edudtcdlist.attribute("style") = "left:300px; top:70px; width:892px; height:400px; ";
								
								model.setValue("/root/send/dgsend/appyy",grd_educdlist.valueMatrix(grd_educdlist.row,grd_educdlist.colRef("appyy")));
								model.setValue("/root/send/dgsend/instcd",grd_educdlist.valueMatrix(grd_educdlist.row,grd_educdlist.colRef("instcd")));
								model.setValue("/root/send/dgsend/educcd",grd_edudtcdlist.valueMatrix(row,grd_edudtcdlist.colRef("educcd")));
								model.setValue("/root/send/dgsend/educdg",grd_edudtcdlist.valueMatrix(row,grd_edudtcdlist.colRef("educdg")));
								
								if(grd_edudtcdlist.rows -1 == row) {				// 차수별 내용이 아닌 소계의 세부만족도..
									model.setValue("/root/send/dgsend/educcd",grd_edudtcdlist.valueMatrix(row-1,grd_edudtcdlist.colRef("educcd")));
									submit("TRRPS01307");
								}
								else {
									submit("TRRPS00203");
								}
							}
						}
						else {
							if( col == grd_edudtcdlist.colRef("satsfcttotal") ) {
								//선택된 row의 교육코드와 년도, 차수를 가지고 세부만족도를 조회한다. 구분은 N
								grd_satsfctlist.visible = true;
								grd_edudtcdlist.attribute("style") = "left:300px; top:70px; width:892px; height:400px; ";
								
								model.setValue("/root/send/dgsend/appyy",ipt_appyy.value);
								model.setValue("/root/send/dgsend/educcd",grd_edudtcdlist.valueMatrix(row,grd_edudtcdlist.colRef("educcd")));
								submit("TRRPS01307");
							}
						}
						model.refresh();
					]]>
				</script>
			</datagrid>
			<input id="ipt_educcd" ref="/root/send/educcuse/educcd" visibility="hidden" style="left:465px; top:45px; width:100px; height:19px; "/>
			<button id="button5" class="icon_search" style="left:1052px; top:13px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "chrgdeptcd,chrgdeptcdnm";
						rpbfOpenDeptCdHelp(ipt_deptcd,recv_list);
						model.refresh();
					]]>
				</script>
			</button>
			<select1 id="cmb_educflag" ref="/root/send/educcuse/educflag" class="combo_search" appearance="minimal" style="left:722px; top:13px; width:88px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<caption id="caption1" class="search_name" style="left:637px; top:13px; width:91px; height:17px; ">교육구분 :</caption>
			<caption id="caption12" class="tit_2" style="left:0px; top:50px; width:169px; height:13px; ">교육과정 List</caption>
			<button id="button9" class="icon_search" style="left:602px; top:13px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "instcd,instnm";
						misfOpenPopUpList("03", ipt_instnm,"Z0007", recv_list, "", "") ;
					    model.refresh();
					]]>
				</script>
			</button>
			<input id="ipt_appyy" ref="/root/send/educcuse/appyy" class="input_s_essential" inputtype="date" format="yyyy" style="left:100px; top:13px; width:95px; height:19px; text-align:center; "/>
			<caption id="caption4" class="search_name" style="left:15px; top:13px; width:90px; height:17px; ">적용년도 :</caption>
			<line id="line1" class="line_4" style="x1:1110px; y1:11px; x2:1110px; y2:33px; "/>
			<caption id="caption5" class="search_name" style="left:214px; top:13px; width:86px; height:17px; ">주체단위 :</caption>
			<caption id="caption14" class="tit_2" style="left:303px; top:50px; width:169px; height:13px; ">교육과정별 이수인원</caption>
			<datagrid id="grd_educdlist" nodeset="/root/main/tableft/educdlist" autoresize="true" caption="주체단위^주체기관^년도^교육구분^교육명^교육코드^교육장소^교육&#xA;소요일수^교육&#xA;소요시간^개인신청&#xA;가능여부^사용&#xA;여부^주관부서^교육코드^비고" colsep="^" colwidth="28, 29, 40, 100, 183, 66" dataheight="25" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="select" rowsep="|" style="left:1px; top:70px; width:298px; height:655px; ">
				<col ref="mainbdunit" type="combo" visibility="hidden">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="instcd" type="combo" visibility="hidden">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="appyy" visibility="hidden"/>
				<col disabled="true" ref="educflag" type="combo">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col disabled="true" ref="educcdnm" type="input"/>
				<col ref="educcd" visibility="hidden"/>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
						if( model.getValue("/root/send/educcuse/total") == "Y" ) {
							model.setValue("/root/send/educcuse/total",  "");
							chk_total.refresh();
						}
						var i = grd_educdlist.row;
						var educcd = model.getValue("/root/main/tableft/educdlist["+i+"]/educcd");
						ipt_educcd.value = educcd;
						model.refresh();
						
						model.removenode("/root/main/tabright");
						model.makeNode("/root/main/tabright");
						
						submit("TRRPS01304");
						
						fSubTotal();
					]]>
				</script>
			</datagrid>
			<input id="ipt_instcd" ref="/root/send/educcuse/instcd" disabled="true" visibility="hidden" style="left:600px; top:35px; width:50px; height:19px; "/>
			<caption id="caption7" class="search_name" style="left:405px; top:13px; width:86px; height:17px; ">주체기관 :</caption>
			<line id="line3" class="line_1" style="x1:1px; y1:65px; x2:298px; y2:65px; "/>
			<caption id="caption8" class="search_name" style="left:825px; top:13px; width:91px; height:17px; ">주관부서 :</caption>
			<input id="ipt_instnm" ref="/root/send/educcuse/instnm" class="input_search" appearance="input" style="left:490px; top:13px; width:110px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if( ipt_instnm.value.getByteLength() == '0' ) {
							ipt_instcd.value = "" ;
						}
						model.refresh();
					]]>
				</script>
			</input>
			<line id="line5" class="line_1" style="x1:301px; y1:65px; x2:1191px; y2:65px; "/>
			<input id="ipt_deptcd" ref="/root/send/educcuse/chrgdeptcd" disabled="true" visibility="hidden" style="left:990px; top:30px; width:50px; height:19px; "/>
			<datagrid id="grd_satsfctlist" nodeset="/root/main/grid/rpsdedsflist" visibility="hidden" caption="만족도명칭^만족도" colsep="^" colwidth="731, 100" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowsep="|" style="left:300px; top:470px; width:892px; height:255px; ">
				<col ref="satsfctnm"/>
				<col ref="satsfctgd"/>
				<script type="javascript" ev:event="ondblclick">
					<![CDATA[
						grd_satsfctlist.visible = false;
						grd_edudtcdlist.attribute("style") = "left:300px; top:70px; width:892px; height:655px; ";						
					]]>
				</script>
			</datagrid>
		</group>
	</xhtml:body>
</xhtml:html>