YNU_JEUS/app_home/himed/webapps/mis/tistrngeducapntmngtweb/xrw/SMRTR00400_채용성적일괄등록.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>
						<apntscorebatrgst/>
					</main>
					<send>
						<apntyy/>
						<supinfqurtyyflag>1</supinfqurtyyflag>
						<fstlattrmflag>1</fstlattrmflag>
						<trngflag/>
						<dentyn>1</dentyn>
						<scrngflag>2</scrngflag>
						<korname/>
						<rregno/>
						<examno/>
						<scorekind/>
						<apntscorebatrgst/>
					</send>
					<init/>
					<hidden>
					</hidden>
					<temp>
					</temp>
				</root>
			</instance>
			<submission id="TRRTR00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/apntscorebatrgst"/>
			<submission id="TXRTR00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/temp"/>
		</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" ev:event="xforms-ready">
			<![CDATA[
				//사용자 권한
				fCheckAuth();
				
				// 그리드 초기화
				misfGridInit(grd_apntscorebatrgst);
				
				misfMsterDetailSet(grd_apntscorebatrgst, null, "TRRTR00401", "Y");				
		
				misfComboComCdListMulti("R0237,R0238,R0151,R0239,R0240,R0274,R0275", "cmb_supinfqurtyyflag,cmb_fstlattrmflag,cmb_trngflag,cmb_dentyn,cmb_scrngflag,cmb_scorekind274,cmb_scorekind275");
						
				
				// 2007-11-16  년도 디폴트설정 acwon수정
				/*var sDate = getNewDate();		

				model.setValue("/root/send/apntyy", sDate.getFullYear());
				model.refresh();*/
				var today = getCurrentDate();
				var cur_mm = parseInt(today.substring(4, 6));
				var cur_yy = parseInt(today.substring(0, 4));
				
				if (cur_mm >= 11)
					cur_yy++;
					
				model.setValue("/root/send/apntyy", cur_yy);
				model.refresh();
				//end
				
			       //그리드의 타이틀을 누르면 sort되는 기능
			       grd_apntscorebatrgst.explorerbar = "sort";	
			       grd_apntscorebatrgst.selectionMode = "byrow"

			]]>
		</script>
		<script type="javascript">
			<![CDATA[
				//========================================================================================
				//버튼에 대한 화면 권한 체크(R : 읽기, X : 입력/수정/삭제, P : 출력)
				//========================================================================================
				function fCheckAuth() {
					btn_search.disabled = !checkAuth("R") ;
					btn_save.disabled = !checkAuth("X") ;
				}
				
				function fGetList() {
					//필수 입력 항목 체크(공통 ftHelper.js)                                                                                  
					if ( !isRequiredControls("ipt_apntyy", "cmb_supinfqurtyyflag", "cmb_fstlattrmflag", "cmb_trngflag", "cmb_dentyn", "cmb_scrngflag", "cmb_scorekind") ) {
						return false;
					}
				
					misfMsterDetailRetrieve();	
					
					fGridReset();
				} // function 
				
				function fGridReset(vFlag) {
					// 총점관련 전체필드를 숨긴다.
					for (var i = 9; i < grd_apntscorebatrgst.cols; i++) {
						grd_apntscorebatrgst.colHidden(i) = true;
					} 
					
					
					var scorekind = cmb_scorekind.value;
					
					if ( vFlag != "EXCEL_SAVE" ) {	
						switch (scorekind) {
							case "I1":  // 인턴 필기총점
								for (var i = 9; i <= 10; i++) {
									grd_apntscorebatrgst.colHidden(i) = false;
								} 
								grd_apntscorebatrgst.caption = "채용번호^성적종류^수험번호^번호^주민등록번호^성명^희망병원^1지망과^필기총점^환산점수^석차^인원^등급^환산점수^영어^전산자격증^USMLE^환산점수^인턴만점^인턴총점^인턴석차^인턴인원^인턴등급^인턴판정^환산점수";						
								break;
							case "I2":  // 인턴 재학성적
								for (var i = 11; i <= 14; i++) {
									grd_apntscorebatrgst.colHidden(i) = false;
								} 
								break;
							case "I3":  // 인턴 선택평가
								for (var i = 15; i <= 18; i++) {
									grd_apntscorebatrgst.colHidden(i) = false;
								} 
								grd_apntscorebatrgst.colHidden(8) = false;
								grd_apntscorebatrgst.caption = "채용번호^성적종류^수험번호^번호^주민등록번호^성명^희망병원^1지망과^사회의료봉사활동^환산점수^석차^인원^등급^환산점수^영어^전산자격증^USMLE^환산점수^인턴만점^인턴총점^인턴석차^인턴인원^인턴등급^인턴판정^환산점수";
								break;																		
							case "R1":  // 레지던트 필기
								for (var i = 9; i <= 10; i++) {
									grd_apntscorebatrgst.colHidden(i) = false;
								} 
								grd_apntscorebatrgst.caption = "채용번호^성적종류^수험번호^번호^주민등록번호^성명^희망병원^1지망과^필기총점^환산점수^석차^인원^등급^환산점수^영어^전산자격증^USMLE^환산점수^인턴만점^인턴총점^인턴석차^인턴인원^인턴등급^인턴판정^환산점수";													
								break;
							case "R2":  // 레지던트 의대성적
								for (var i = 11; i <= 14; i++) {
									grd_apntscorebatrgst.colHidden(i) = false;
								} 
								break;
							case "R4":  // 레지던트 인턴성적
								for (var i = 19; i <= 26; i++) {
									grd_apntscorebatrgst.colHidden(i) = false;
								} 
								break;									
							default:
								// do nothing here
								break;
						} // end switch				
					} else {
						grd_apntscorebatrgst.colHidden(9) = false;
						
						if ( scorekind == "I3") {
							grd_apntscorebatrgst.caption = "채용번호^성적종류^수험번호^번호^주민등록번호^성명^희망병원^희망과^사회의료봉사활동^환산점수^석차^인원^등급^환산점수^영어^전산자격증^USMLE^환산점수^인턴만점^인턴총점^인턴석차^인턴인원^인턴등급^인턴판정^환산점수";
						} else {
							grd_apntscorebatrgst.caption = "채용번호^성적종류^수험번호^번호^주민등록번호^성명^희망병원^희망과^필기총점^환산점수^석차^인원^등급^환산점수^영어^전산자격증^USMLE^환산점수^인턴만점^인턴총점^인턴평점^인턴석차^인턴인원^인턴등급^인턴판정^환산점수";						
						}
					} // end if				
					
					model.refresh();					
				} // end function				
				
				
				
				
				
			]]>
		</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>
		<caption id="caption10" style="left:725px; top:705px; width:350px; height:25px; vertical-align:middle; ">상태 : 가입, 탈퇴, 보임</caption>
		<group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
			<button id="button4" class="btn2_letter4" style="left:1053px; top:78px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
			
						if (fileName != "") {
							grd_apntscorebatrgst.colHidden(1) = false;
							grd_apntscorebatrgst.colHidden(2) = false;							
							//grd_apntscorebatrgst.saveExcel(fileName);
							grd_apntscorebatrgst.saveExcel(fileName, "", false, true);
							//grd_apntscorebatrgst.colHidden(1) = true;
							//grd_apntscorebatrgst.colHidden(2) = true;									
						}		
					]]>
				</script>
			</button>
			<datagrid id="grd_apntscorebatrgst" nodeset="/root/main/apntscorebatrgst" caption="채용번호^성적종류^수험번호^번호^주민등록번호^성명^희망병원^1지망과^필기총점^환산점수^석차^인원^등급^환산점수^영어^전산자격증^USMLE^환산점수^인턴만점^인턴총점^인턴평점^인턴석차^인턴인원^인턴등급^인턴판정^환산점수" colsep="^" colwidth="70, 70, 80, 40, 100, 70, 113, 107, 120, 92, 46, 42, 68, 90, 88, 83, 65, 80, 70, 70, 70, 70, 70, 80, 80, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="23" rowsep="|" style="left:0px; top:103px; width:1195px; height:609px; ">
				<col ref="apntinfono" style="text-align:center; "/>
				<!-- 성적종류 -->
				<col ref="scorekind" visibility="visible" style="text-align:center; "/>
				<col ref="examno" style="text-align:center; "/>
				<col ref="examseq" style="text-align:center; "/>
				<col ref="rregno" style="text-align:center; "/>
				<col ref="korname"/>
				<col ref="hopehospnm"/>
				<col ref="hopedeptnm"/>
				<!--점수 입력 필드, 필기/국시총점, 사회봉사점수-->
				<col ref="inputpnt" type="input" showmask="true" style="text-align:center; "/>
				<!--필기/국시환산점수-->
				<col ref="taknnotechgpnt" style="text-align:center; "/>
				<!--재학석차-->
				<col ref="bngschoolrank" type="input" visibility="hidden" format="####" maxlength="4" showmask="true" style="text-align:center; "/>
				<!--재학인원-->
				<col ref="bngschoolpsnno" type="input" visibility="hidden" format="####" maxlength="4" showmask="true" style="text-align:center; "/>
				<!--재학등급-->
				<col ref="bngschoolgrde" visibility="hidden" style="text-align:center; "/>
				<!--재학성적환산점수-->
				<col ref="bngschoolchgpnt" visibility="hidden" showmask="true" style="text-align:center; "/>
				<!--영어환산점수-->
				<col ref="engchgpnt" visibility="hidden" format="##" showmask="true" style="text-align:center; "/>
				<!--전산자격증환산점수-->
				<col ref="compulincchgpnt" visibility="hidden" format="##" showmask="true" style="text-align:center; "/>
				<!--사회봉사활동환산점수-->
				<!--usmle환산점수-->
				<col ref="usmlechgpnt" visibility="hidden" format="##" showmask="true" style="text-align:center; "/>
				<!--선택평가환산점수-->
				<col ref="choivaluechgpnt" visibility="hidden" format="###.##" maxlength="4.2" showmask="true" style="left:1410px; top:23px; width:81px; height:23px; text-align:center; "/>
				<!--인턴만점-->
				<col ref="intnperscore" type="input" visibility="hidden" style="left:1491px; top:23px; width:73px; height:23px; text-align:center; "/>
				<!--인턴총점-->
				<col ref="intntotpnt" type="input" visibility="hidden" style="text-align:center; "/>
				<!--인턴평점-->
				<col ref="intnavgpnt" visibility="hidden" style="text-align:center; "/>
				<!--인턴석차-->
				<col ref="intnrank" type="input" visibility="hidden" format="####" maxlength="4" showmask="true" style="text-align:center; "/>
				<!--인턴인원-->
				<col ref="intnpsnno" type="input" visibility="hidden" format="####" maxlength="4" showmask="true" style="text-align:center; "/>
				<!--인턴등급-->
				<col imemode="disabled" ref="intngrde" type="input" visibility="hidden" _chartype="upper" style="text-align:center; "/>
				<!--인턴판정-->
				<col ref="intnjudg" visibility="hidden" style="text-align:center; "/>
				<!--인턴판정환산점수-->
				<col ref="intnjudgchgpnt" visibility="hidden" maxlength="4" showmask="####.##" style="text-align:center; "/>
				<!--면접점수-->
				<col ref="intvpnt" visibility="hidden"/>
				<!--실기점수-->
				<col ref="pracpnt" visibility="hidden"/>
				<!--석차-->
				<col ref="rank" visibility="hidden"/>
				<!--영어선택코드-->
				<col ref="engchoicd" visibility="hidden"/>
				<col ref="apntyy" visibility="hidden"/>
				<col ref="supinfqurtyyflag" visibility="hidden"/>
				<col ref="fstlattrmflag" visibility="hidden"/>
				<col ref="trngflag" visibility="hidden"/>
				<col ref="dentyn" visibility="hidden"/>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_apntscorebatrgst.gridToInstance();
					]]>
				</script>
			</datagrid>
			<line id="line3" class="line_1" style="x1:0px; y1:98px; x2:1195px; y2:98px; "/>
			<caption id="caption9" class="tit_2" style="left:10px; top:84px; width:117px; height:13px; ">수험생 목록</caption>
			<group id="group4" style="left:0px; top:5px; width:1195px; height:65px; vertical-align:top; ">
				<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:0px; width:1190px; height:63px; background-color:#fffbf2; border-color:#ffd799; "/>
				<button id="btn_search" class="btn1_letter2" navindex="10" style="left:1125px; top:22px; width:56px; height:22px; text-align:left; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							fGetList();
						]]>
					</script>
				</button>
				<line id="line1" class="line_4" style="x1:1110px; y1:6px; x2:1110px; y2:52px; border-color:#ffe4bb; border-left-style:solid; "/>
				<caption id="cap_scrngflag" class="search_name" style="left:15px; top:39px; width:86px; height:17px; ">전형구분 :</caption>
				<caption id="caption1" class="search_name" style="left:225px; top:39px; width:86px; height:17px; ">이     름 :</caption>
				<input id="ipt_korname" ref="/root/send/korname" class="input_search" navindex="7" style="left:310px; top:38px; width:100px; height:19px; "/>
				<caption id="caption3" class="search_name" style="left:435px; top:40px; width:86px; height:17px; ">수험번호 :</caption>
				<input id="ipt_examno" ref="/root/send/examno" class="input_search" navindex="9" style="left:525px; top:39px; width:100px; height:19px; "/>
				<select1 id="cmb_trngflag" ref="/root/send/trngflag" class="combo_s_essential" navindex="4" appearance="minimal" style="left:775px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[;
							// 전공의 인턴, 레지던트에 따라 성적종류 셋팅
							if ( cmb_trngflag.value == "I" ) {
								misfComboCopyItemSet(cmb_scorekind274, "", cmb_scorekind, "");								
							} else if  ( cmb_trngflag.value == "R" ) {
								misfComboCopyItemSet(cmb_scorekind275, "", cmb_scorekind, "");								
							}				
							]]>
					</script>
				</select1>
				<caption id="cap_trngflag" class="search_name" style="left:660px; top:9px; width:110px; height:17px; ">전공의구분 :</caption>
				<caption id="cap_apntyy" class="search_name" style="left:15px; top:9px; width:86px; height:17px; ">년     도 :</caption>
				<caption id="cap_supinfqurtyyflag" class="search_name" style="left:225px; top:9px; width:86px; height:17px; ">상하반기 :</caption>
				<caption id="cap_fstlattrmflag" class="search_name" style="left:435px; top:9px; width:86px; height:17px; ">전후기 :</caption>
				<select1 id="cmb_dentyn" ref="/root/send/dentyn" class="combo_s_essential" navindex="5" appearance="minimal" style="left:975px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_dentyn" class="search_name" style="left:885px; top:9px; width:96px; height:17px; ">치과여부 :</caption>
				<select1 id="cmb_fstlattrmflag" ref="/root/send/fstlattrmflag" class="combo_s_essential" navindex="3" appearance="minimal" style="left:525px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<select1 id="cmb_supinfqurtyyflag" ref="/root/send/supinfqurtyyflag" class="combo_s_essential" navindex="2" appearance="minimal" style="left:310px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption12" class="search_name" style="left:660px; top:40px; width:115px; height:17px; ">주민등록번호 :</caption>
				<input id="ipt_rregno" ref="/root/send/rregno" class="input_search" navindex="8" style="left:775px; top:39px; width:100px; height:19px; "/>
				<input id="ipt_apntyy" ref="/root/send/apntyy" class="input_s_essential" navindex="1" style="left:100px; top:10px; width:100px; height:19px; "/>
				<select1 id="cmb_scrngflag" ref="/root/send/scrngflag" class="combo_s_essential" navindex="6" appearance="minimal" style="left:100px; top:35px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_scorekind" class="search_name" style="left:885px; top:39px; width:86px; height:17px; ">성적종류 :</caption>
				<select1 id="cmb_scorekind" ref="/root/send/scorekind" class="combo_s_essential" appearance="minimal" style="left:975px; top:35px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
			</group>
			<select1 id="cmb_scorekind274" visibility="hidden" appearance="minimal" style="left:675px; top:190px; width:105px; height:40px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<select1 id="cmb_scorekind275" visibility="hidden" appearance="minimal" style="left:840px; top:190px; width:105px; height:30px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<button id="button5" class="btn2_letter4" style="left:1121px; top:78px; width:64px; height:19px; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var vKind = cmb_scorekind.value;
						
						if (vKind == "I3" || vKind == "R4") {
							messageBox("엑셀입력 할 수 없는 성적종류","E008");
							return;
						}
					
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
				
						if (fileName.length > 0 ) {		
						
							grd_apntscorebatrgst.loadExcel(fileName, 1, true);
							grd_apntscorebatrgst.deleteRow(1);
							grd_apntscorebatrgst.refresh();
							
							var sCnt = grd_apntscorebatrgst.rows;
							grd_apntscorebatrgst.clearStatus();
							grd_apntscorebatrgst.rowStatus(1) = 0;							
							for ( var i = 1; i < sCnt; i++) {
								grd_apntscorebatrgst.rowStatus(i) = 2;
							}
						
						}else{
								return ; 
						}
						
						//fGridReset("EXCEL_SAVE");
						fGridReset();
			
									
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<line id="line75" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_save" class="btn5_letter2" style="left:1139px; top:3; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var retMes =  messageBox("저장 하시겠습니까?", "Q999");
					if ( retMes != 6) {
						return;
					}
					
					var updtdata = getGridUpdateData(grd_apntscorebatrgst);
					if (updtdata == "") {
						messageBox("변경된 데이터가","I004");
						return;
					}
										
					misfSave("TXRTR00401");					
					fGetList();							
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>