YNU_JEUS/app_home/himed/webapps/mis/tistrngeducapntmngtweb/xrw/SMRTR00500_면접실기일괄등록.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>면접 실기 일괄 등록</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<intvpracvolntlist/>
					</main>
					<send>
						<apntyy/>
						<supinfqurtyyflag>1</supinfqurtyyflag>
						<fstlattrmflag>1</fstlattrmflag>
						<trngflag>I</trngflag>
						<dentyn>1</dentyn>
						<scrngflag>2</scrngflag>
						<korname/>
						<rregno/>
						<examno/>
						<drlicnsno/>
						<name/>
						<scrngflagnm/>
						<valupsnid/>
						<intvpracvolntlist/>
					</send>
					<init/>
					<hidden>
					</hidden>
					<temp>
					</temp>
				</root>
			</instance>
			<submission id="TRRTR00501" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send" resultref="/root/main/intvpracvolntlist"/>
			<submission id="TXRTR00501" 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_intvpracvolntlist);
				
				misfMsterDetailSet(grd_intvpracvolntlist, null, "TRRTR00501", "Y");				
		
				misfComboComCdListMulti("R0237,R0238,R0151,R0239,R0240", "cmb_supinfqurtyyflag,cmb_fstlattrmflag,cmb_trngflag,cmb_dentyn,cmb_scrngflag");
						
				
				// 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);
				
				grd_intvpracvolntlist.explorerbar = "sort";
				grd_intvpracvolntlist.selectionMode = "byrow"
				
				if (window.document.location.indexOf("C:/CMCProject/application") > -1)
			    {
			    		
			    		model.setValue("/root/send/trngflag", "R");
			    		model.setValue("/root/send/valupsnid", "84015046");
			    		cap_valupsnid.refresh();
			    		
			    		btn_search.dispatch("DOMActivate");
			    }
				
				model.refresh();
				//end

			]]>
		</script>
		<script type="javascript">
			<![CDATA[

				//========================================================================================
				//버튼에 대한 화면 권한 체크(R : 읽기, X : 입력/수정/삭제, P : 출력)
				//========================================================================================
				function fCheckAuth() {
					btn_search.disabled = !checkAuth("R") ;
					btn_save.disabled = !checkAuth("X") ;
				}
				
				function fGetList() {
					misfMsterDetailRetrieve();	
				}
			]]>
		</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:38px; width:1195px; height:744px; ">
			<datagrid id="grd_intvpracvolntlist" nodeset="/root/main/intvpracvolntlist" caption="수험번호^주민등록번호^성명^지원과^결시^인성/품성^사회성^예의범절^윤리관^대화법^의직수행능력^판단력^이해력^표현력^응용력^채용정보번호^평가자ID^전형구분^전공의구분^채용년도^caption1^caption2" colsep="^" colwidth="70, 90, 70, 90, 38, 77, 77, 77, 77, 77, 85, 77, 77, 77, 77, 100, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="23" rowsep="|" style="left:0px; top:105px; width:1185px; height:629px; ">
				<col ref="examno" type="output" style="text-align:center; "/>
				<col ref="rregno" type="output" style="text-align:center; "/>
				<col ref="korname" type="output" style="text-align:center; "/>
				<col ref="hopedeptnm" type="output" style="text-align:center; word-wrap:none; "/>
				<col checkvalue="Y,N" ref="absnexamyn" type="checkbox"/>
				<col autonext="false" imemode="disabled" ref="item0301" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0302" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0303" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0304" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0305" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0401" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0402" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0403" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0404" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col autonext="false" imemode="disabled" ref="item0405" type="input" maxlength="1" _chartype="upper" _required="true" style="text-align:center; "/>
				<col ref="apntinfono" visibility="hidden"/>
				<col ref="valupsnid" visibility="hidden"/>
				<col ref="scrngflag" visibility="hidden"/>
				<col ref="trngflag" visibility="hidden"/>
				<col ref="apntyy" visibility="hidden"/>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					
						if (grd_intvpracvolntlist.col >= grd_intvpracvolntlist.colRef("item0301") && grd_intvpracvolntlist.col <= grd_intvpracvolntlist.colRef("item0405"))
						{
							var pattern =/^[ABC]/;
	
							var inputValue = grd_intvpracvolntlist.valueMatrix( grd_intvpracvolntlist.row, grd_intvpracvolntlist.col);
		
							if( pattern.exec(inputValue) == null ) {
								messageBox("점수는 'A', 'B', 'C' 만", "I006");
								grd_intvpracvolntlist.valueMatrix( grd_intvpracvolntlist.row, grd_intvpracvolntlist.col) = "";
								// 2007-11-12  A,B,C 이외 문자입력제한 acwon수정 
								event.propagate = "stop";
							}
							else {
								if( grd_intvpracvolntlist.row == grd_intvpracvolntlist.rows) {
									grd_intvpracvolntlist.col = grd_intvpracvolntlist.col + 1;
								}
								else {
									
									if (grd_intvpracvolntlist.col >= grd_intvpracvolntlist.colRef("item0405"))
									{
										grd_intvpracvolntlist.row = grd_intvpracvolntlist.row + 1;
										grd_intvpracvolntlist.col = grd_intvpracvolntlist.colRef("item0301");
									}
									else
									{
										grd_intvpracvolntlist.col = grd_intvpracvolntlist.col + 1;
									}
								}
							}
						}
					]]>
				</script>
				<script type="javascript" ev:event="onentercell">
					<![CDATA[
						if (grd_intvpracvolntlist.col == grd_intvpracvolntlist.colRef("examno"))
						{
							grd_intvpracvolntlist.col = grd_intvpracvolntlist.colRef("item0301");
						}
					]]>
				</script>
			</datagrid>
			<line id="line3" class="line_1" style="x1:0px; y1:100px; x2:1185px; y2:100px; "/>
			<caption id="caption9" class="tit_2" style="left:10px; top:85px; width:117px; height:13px; ">지원자 리스트</caption>
			<group id="group4" style="left:0px; top:0px; 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[
						
							//필수 입력 항목 체크(공통 ftHelper.js)
							if ( !isRequiredControls("ipt_apntyy", "cmb_supinfqurtyyflag", "cmb_fstlattrmflag", "cmb_trngflag", "cmb_dentyn", "cnb_scrngflag", "ipt_valupsnid") ) {
								return false;
							}
								
							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:765px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_trngflag" class="search_name" style="left:650px; 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:970px; top:10px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="cap_dentyn" class="search_name" style="left:880px; 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:650px; top:40px; width:115px; height:17px; ">주민등록번호 :</caption>
				<input id="ipt_rregno" ref="/root/send/rregno" class="input_search" navindex="8" style="left:765px; 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>
				<input id="ipt_valupsnid" ref="/root/send/valupsnid" class="output_fix" appearance="minimal" style="left:970px; top:40; width:100px; height:19px; "/>
				<button id="btn_deptcdhelp" class="icon_search" style="left:1081px; top:41px; width:16px; height:16px; ">
					<caption/>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
						
						//필수 입력 항목 체크(공통 ftHelper.js)
						if ( !isRequiredControls("ipt_apntyy", "cmb_supinfqurtyyflag", "cmb_fstlattrmflag", "cmb_trngflag", "cmb_dentyn", "cnb_scrngflag") ) {
							return false;
						}						
						/*
						pwindow_name : Open할 window명
						pcontrol_name : OPEN하는 Control명(Grid,Input.....)
						precv_list: 리턴받을 Instance명 (마지막 Element만 ','로 분리)
						pdefault_value : 부모 윈도우에서 넘어오는 값
						pcheck_yn : 선택형 팝업창인지 아닌지를 체크
						
						function rpbfOpenPopUpList(pwindow_name, pcontrol_name, precv_list, pdefault_value, pcheck_yn) {
						*/			
						rpbfOpenPopUpList("SPRTR00601", ipt_drlicnsno, "scrngflagnm,name,drlicnsno,valupsnid", "ipt_apntyy,cmb_supinfqurtyyflag,cmb_fstlattrmflag,cmb_trngflag,cmb_dentyn,cmb_scrngflag","N");
						model.refresh();		
					]]>
					</script>
				</button>
				<caption id="cap_valupsnid" class="search_name" style="left:880px; top:39px; width:75px; height:17px; ">평가자 :</caption>
			</group>
			<input id="ipt_scrngflagnm" ref="/root/send/scrngflagnm" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:1085px; top:70px; width:100px; height:19px; "/>
			<input id="ipt_name" ref="/root/send/name" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:975px; top:65px; width:100px; height:19px; "/>
			<input id="ipt_drlicnsno" ref="/root/send/drlicnsno" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:865px; top:70px; width:100px; height:19px; "/>
			<button id="btn_excel" class="btn2_letter4" style="left:1050px; top:80px; width:64px; height:19px; vertical-align:middle; ">
				<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_intvpracvolntlist.saveExcel(fileName, "", false, true);
						}		
					]]>
				</script>
			</button>
			<button id="button5" class="btn2_letter4" style="left:1118px; top:80px; width:64px; height:19px; vertical-align:middle; ">
				<caption>엑셀입력</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						if (fileName != "") {
							grd_intvpracvolntlist.loadExcel(fileName, 1, false);
							grd_intvpracvolntlist.deleteRow(1);
							grd_intvpracvolntlist.refresh();
							
							var sCnt = grd_intvpracvolntlist.rows;
							grd_intvpracvolntlist.clearStatus();
							//grd_intvpracvolntlist.rowStatus(1) = 0;							
							for ( var i = 1; i < sCnt; i++) {
								grd_intvpracvolntlist.rowStatus(i) = 2;
							}
						}

						
									
					]]>
				</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 frcolidx = grd_intvpracvolntlist.colRef("item0301");
					var tocolidx = grd_intvpracvolntlist.colRef("item0405");
					var totcnt = tocolidx - frcolidx + 1;
					var valucnt = 0;
					var inputValue;
					var pattern =/^[ABC]/;
					var emptyCellidx = -1;
					
					for (var i=1; i<=grd_intvpracvolntlist.rows; i++)
					{
						valucnt = 0;
						for (var j=frcolidx; j<=tocolidx; j++)
						{
							inputValue = grd_intvpracvolntlist.valueMatrix(i, j).replace(" ", "");
							
							if( inputValue != "")
							{
								valucnt++;
								if (pattern.exec(inputValue) == null)
								{
									var msg = grd_intvpracvolntlist.valueMatrix(0,j) + "\n\n"
									messageBox(msg + "점수는 'A', 'B', 'C' 만", "I006");
									
									model.setFocus("grd_intvpracvolntlist");
									grd_intvpracvolntlist.row = i;
									grd_intvpracvolntlist.col = j;
									return;
								}
							}
							else if (emptyCellidx == -1)
							{
								emptyCellidx = j;
							}
						}
						
						if (valucnt > 0 && valucnt != totcnt)
						{
							var msg = grd_intvpracvolntlist.valueMatrix(0,emptyCellidx) + "\n\n"
							messageBox(msg + "점수입력이 안 된 항목이 있습니다.", "I", "");
							
							model.setFocus("grd_intvpracvolntlist");
							grd_intvpracvolntlist.row = i;
							grd_intvpracvolntlist.col = emptyCellidx;
							return;
						}
					}
																				
					var updtdata = getGridUpdateData(grd_intvpracvolntlist);
					if (updtdata == "") {
						messageBox("변경된 데이터가","I004");
						return;
					}
										
					misfSave("TXRTR00501");				
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>