YNU_JEUS/app_home/himed/webapps/mis/appointmentmngtweb/xrw/SMRPE00400_점수등록및합격자처리.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:ex="http://www.comsquare.co.kr/xforms/excel" 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>SMRPE00400_점수등록및합격자처리</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<tab1>
							<one/>
						</tab1>
						<tab2>
							<two/>
						</tab2>
						<tab3>
							<three/>
						</tab3>
						<tab4>
							<four/>
						</tab4>
						<loadexcel>
							<loadone/>
							<loadtwo/>
							<loadthree/>
							<loadfour/>
						</loadexcel>
						<apntinfo>
							<apntinfolist/>
						</apntinfo>
					</main>
					<send>
						<save>
							<info>
							</info>
							<emplist/>
						</save>
						<apntinfo>
							<instcd/>
							<prfshipflag/>
							<apntfromdd/>
							<apnttodd/>
							<name/>
							<appjobkindnm/>
							<appjobkindcd/>
							<examno/>
							<recufildcd/>
							<recufildnm/>
							<hopedeptcd/>
							<hopedeptnm/>
							<passyn/>
							<scrngdg/>
							<apntinfono/>
							<apntyy/>
							<scor/>
							<grupjoblncd/>
						</apntinfo>
						<req>
							<instcd/>
							<prfshipflag/>
							<apntfromdd/>
							<apnttodd/>
							<appjobkindcd/>
							<recufildcd/>
							<hopedeptcd/>
							<apntinfono/>
							<scrngdg/>
						</req>
						<volntref>
							<name/>
							<rregno/>
							<apntinfono/>
						</volntref>
					</send>
					<temp>
						<hidden/>
					</temp>
					<init>
						<gender>
							<label>여</label>
							<value>F</value>
						</gender>
						<gender>
							<label>남</label>
							<value>M</value>
						</gender>
					</init>
					<save>
						<save/>
					</save>
					<apntinfolist/>
				</root>
			</instance>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize() ;
				]]>
			</script>
			<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/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/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript" src="../../../mis/appointmentmngtweb/js/RPE001.js"/>
			<submission id="TRRPE00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/apntinfo" resultref="/root/main/tab1"/>
			<submission id="TRRPE00402" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/apntinfo" resultref="/root/main/tab2"/>
			<submission id="TRRPE00403" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/apntinfo" resultref="/root/main/tab3"/>
			<submission id="TRRPE00404" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/apntinfo" resultref="/root/main/tab4"/>
			<submission id="TXRPE00401" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/save/save" resultref="/root/temp"/>
			<submission id="TRRPE01011" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/apntinfo" resultref="/root/main/apntinfo"/>
			<submission id="TXRPE00103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/apntinfolist" resultref="/root/hidden/temp"/>
			<submission id="TRRPE00303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save/info" resultref="/root/send/save/emplist"/>
		</model>
		<script type="javascript">
			<![CDATA[
				/* 
					</xhtml:body> 앞의 오브젝트 tfexcel이 없으면 TFExcel기능을 사용할수 없다. 
					맨위에서 두번째줄에 xmlns:ex="http://www.comsquare.co.kr/xforms/excel" 를 넣어주어야 한다.
					여러개의 그리드내용을 하나의 엑셀파일로 저장하려면 꼭 필요한 기능!!
				*/
				function fInitialize() 
				{
					//그리드 초기화 작업
					model.removenode("/root/main");
					model.makeNode("/root/main/tab1");
					model.makeNode("/root/main/apntinfo/apntinfono");
					
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","Y");
					misfComboComCdListMulti("R0058,R0059","cmb_prfshipflag,cmb_grupjoblncd");
//					addGridComboItem("cmb_instcd", "- 전체 -", "","above");										// 기관 콤보박스에 '전체'를 추가
					addGridComboItem("cmb_prfshipflag", "- 전체 -", "","above");										// 교직구분 콤보박스에 '전체'를 추가
					
					if( getUserInfo("dutplceinstcd") != '001' ) {
						model.setValue("/root/send/apntinfo/instcd", getUserInfo("dutplceinstcd") );
						model.refresh();
						cmb_instcd.disabled = true;
					}
					
					if( tab_1.selected ) {
						ipt_scrngdg.value = "1";
					}
					else if( tab_2.selected ) {
						ipt_scrngdg.value = "1";			// 이전차수의 합격자를 조회해야 하므로..
					}
					else if( tab_3.selected ) {
						ipt_scrngdg.value = "2";
					}
					else if( tab_4.selected ) {
						ipt_scrngdg.value = "3";
					}
					
					fTitle();
				}
				
				function fTitle() {
					var nowyy = new Date();
					model.setValue("/root/send/apntinfo/apntyy",nowyy.getYear());
					model.setValue("/root/send/apntinfo/apntfromdd",nowyy.getYear() + '0101');
					model.setValue("/root/send/apntinfo/apnttodd", nowyy.getYear() + '1231');
					
					model.refresh();
					
					submit("TRRPE01011");
				}
				
				function fSearch() {
					model.removeNodeset("/root/main/tab1");
					model.makeNode("/root/main/tab1");
					ipt_scrngdg.value = "1";
					submit("TRRPE00401");
					
					model.removeNodeset("/root/main/tab2");
					model.makeNode("/root/main/tab2");
					ipt_scrngdg.value = "2";
					submit("TRRPE00402");
					
					model.removeNodeset("/root/main/tab3");
					model.makeNode("/root/main/tab3");
					ipt_scrngdg.value = "3";
					submit("TRRPE00403");
					
					model.removeNodeset("/root/main/tab4");
					model.makeNode("/root/main/tab4");
					ipt_scrngdg.value = "4";
					submit("TRRPE00404");
					
					model.refresh();
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="1,1195;1,1209;" 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; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:61px; background-color:#fffbf2; border-color:#ffd799; "/>
			<caption id="caption2" class="search_name" style="left:12px; top:18px; width:85px; height:17px; ">기     관 :</caption>
			<select1 id="cmb_instcd" ref="/root/send/apntinfo/instcd" class="combo_s_essential" appearance="minimal" style="left:100px; top:18px; width:155px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</select1>
			<caption id="caption3" class="search_name" visibility="hidden" style="left:272px; top:18px; width:86px; height:17px; ">직원분류 :</caption>
			<select1 id="cmb_prfshipflag" ref="/root/send/apntinfo/prfshipflag" class="combo_search" visibility="hidden" appearance="minimal" style="left:362px; top:18px; width:105px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</select1>
			<caption id="caption7" class="search_name" style="left:578px; top:18px; width:115px; height:17px; ">부     서 :</caption>
			<input id="ipt_hopedeptcd" ref="/root/send/apntinfo/hopedeptcd" class="input_search" visibility="visible" style="left:667px; top:18px; width:65px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</input>
			<button id="btn_hopedeptcdhelp" class="icon_search" style="left:734px; top:18px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "hopedeptcd,hopedeptnm";
						rpbfOpenDeptCdHelp(ipt_hopedeptcd,recv_list);
						model.refresh();
					]]>
				</script>
			</button>
			<input id="hopedeptnm" ref="/root/send/apntinfo/hopedeptnm" class="input_search" appearance="input" style="left:751px; top:18px; width:105px; height:19px; "/>
			<caption id="caption4" class="search_name" style="left:867px; top:18px; width:110px; height:17px; ">직     종 :</caption>
			<input id="ipt_appjobkind" ref="/root/send/apntinfo/appjobkindcd" class="input_search" style="left:955px; top:18px; width:40px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</input>
			<button id="btn_appjobkindhelp" class="icon_search" style="left:997px; top:18px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "appjobkindcd,appjobkindnm";
						rpbfOpenComCdHelp(ipt_appjobkind,"R0061", recv_list);
						model.refresh();		
					]]>
				</script>
			</button>
			<input id="ipt_appjobkindnm" ref="/root/send/apntinfo/appjobkindnm" class="input_search" appearance="input" style="left:1015px; top:18px; width:79px; height:19px; "/>
			<caption id="caption11" class="search_name" style="left:12px; top:44px; width:86px; height:17px; ">모집분야 :</caption>
			<input id="ipt_recufildcd" ref="/root/send/apntinfo/recufildcd" class="input_search" visibility="visible" style="left:101px; top:44px; width:40px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</input>
			<input id="ipt_recufildnm" ref="/root/send/apntinfo/recufildnm" class="input_search" appearance="input" style="left:160px; top:44px; width:95px; height:19px; "/>
			<button id="button1" class="icon_search" style="left:143px; top:44px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "recufildcd,recufildnm";
						rpbfOpenComCdHelp(ipt_recufildnm,"R0061", recv_list);
						
						if( ipt_recufildcd.value == "0320" ) {
							cmb_prfshipflag.value  = "21";
							ipt_appjobkind.value  = "0320";
							ipt_appjobkindnm.value= "임상강사";
							ipt_hopedeptcd.value  = "1000000000";
							hopedeptnm.value  = "병원";
						}
						model.refresh();
						ipt_recufildcd.dispatch("xforms-value-changed");
					]]>
				</script>
			</button>
			<caption id="caption1" class="search_name" style="left:272px; top:44px; width:85px; height:17px; ">기     간 :</caption>
			<input id="ipt_apnttodd" ref="/root/send/apntinfo/apnttodd" class="input_s_essential" inputtype="date" style="left:467px; top:44px; width:90px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</input>
			<input id="ipt_apntfromdd" ref="/root/send/apntinfo/apntfromdd" class="input_s_essential" inputtype="date" style="left:362px; top:44px; width:90px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var instcd = cmb_instcd.value;
						if( getStringLength(ipt_apntfromdd.value) == "8" ) {
							model.removeNodeset(cmb_instcd.attribute("ref"));
							model.makeNode("/root/send/apntinfo/instcd");
							misfComboInstCdListMulti("cmb_instcd",ipt_apntfromdd.value,"","Y");
							cmb_instcd.value = instcd;
							cmb_instcd.refresh();
						}
						submit("TRRPE01011");
					]]>
				</script>
			</input>
			<caption id="caption8" class="search_n_b" style="left:453px; top:44px; width:14px; height:17px; font-weight:bolder; ">~</caption>
			<input id="ipt_scrngdg" ref="/root/send/apntinfo/scrngdg" visibility="hidden" style="left:505px; top:75px; width:105px; height:20px; "/>
			<caption id="caption5" class="search_name" style="left:578px; top:44px; width:90px; height:17px; ">제     목 :</caption>
			<caption id="caption9" class="search_name" style="left:867px; top:44px; width:88px; height:17px; ">성     명 :</caption>
			<input id="ipt_name" ref="/root/send/volntref/name" class="input_search" appearance="input" style="left:955px; top:44px; width:80px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						btn_search.dispatch("DOMActivate");
					]]>
				</script>
			</input>
			<button id="button2" class="icon_search" style="left:1037px; top:44px; width:16px; height:16px; ">
				<caption/>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var recv_list = "name,examno";
						rpefOpenPopUpList("01",ipt_name,"",recv_list);
						model.setValue("/root/send/apntinfo/name",model.getValue("/root/send/volntref/name"));
						var rregno = model.getValue("/root/send/volntref/rregno");
						model.refresh();
					]]>
				</script>
			</button>
			<input id="ipt_examno" ref="/root/send/volntref/rregno" class="input_search" visibility="hidden" style="left:955px; top:65px; width:70px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</input>
			<line id="line3" class="line_4" style="x1:1110px; y1:15px; x2:1110px; y2:65px; border-color:#ffe4bb; border-left-style:solid; "/>
			<button id="btn_search" class="btn1_letter2" navindex="8" style="left:1125px; top:31px; width:56px; height:22px; text-align:left; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						chk_pass.value = '';
						ipt_scor.value = '';
						model.refresh();
						
						if( cmb_apntinfono.value == "" ) {
							messageBox("채용제목을 선택해 주세요." , "I999");
							model.setFocus("cmb_apntinfono");
						}
						else {
							fSearch();
						}
					]]>
				</script>
			</button>
			<button id="btn_7" class="btn2_letter4" style="left:1040px; top:80px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						ipt_scrngdg.value = "1";
						submit("TRRPE00401");
						ipt_scrngdg.value = "2";
						submit("TRRPE00402");
						ipt_scrngdg.value = "3";
						submit("TRRPE00403");
						ipt_scrngdg.value = "4";
						submit("TRRPE00404");
						
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
						if (fileName != "")
						{
							//1. 그리드 파일 CSV파일로 임시저장   => CSV로 저장하는 이유는 여러개의 시트에 저장이 가능하기 때문입니다.(xls파일은 여러개의 시트에 저장 불가능)
							grd_one.saveExcel("C:\\Temp\\sheet1.xls","colhiddenextend:true");
							grd_two.saveExcel("C:\\Temp\\sheet2.xls","colhiddenextend:true");
							grd_three.saveExcel("C:\\Temp\\sheet3.xls","colhiddenextend:true");
							grd_four.saveExcel("C:\\Temp\\sheet4.xls","colhiddenextend:true");
							
							//2. 임시로 저장된 엑셀파일을 하나로 합치는 과정
							// excel application 실행함
							tfexcel.launchnewinstance(0);
							//실행된 excel application에서 새로운 workbook을 생성
							tfexcel.createworkbook();
							//1번째에 시트를 추가하고 시트 이름을 "1차전형"으로 한다.
							var nResult1 = tfexcel.addsheet(1, "1차전형");
							nResult1 = tfexcel.activatesheet(1);
							if(nResult1 <0)	{
								alert("오류발생");
								return;
							}
							//로딩
							tfexcel.loadCSV("C:\\Temp\\sheet1.xls");
							
							//2번째에 시트를 추가하고 시트 이름을 "2차전형"으로 한다.
							var nResult2 = tfexcel.addsheet(2, "2차전형");
							nResult2 = tfexcel.activatesheet(2);
							if(nResult2 <0) {
								alert("오류발생");
								return;
							}
							//로딩
							tfexcel.loadCSV("C:\\Temp\\sheet2.xls");
							
							//3번째에 시트를 추가하고 시트 이름을 "3차전형"으로 한다.
							var nResult2 = tfexcel.addsheet(3, "3차전형");
							nResult2 = tfexcel.activatesheet(3);
							if(nResult2 <0) {
								alert("오류발생");
								return;
							}
							//로딩
							tfexcel.loadCSV("C:\\Temp\\sheet3.xls");
							
							//2번째에 시트를 추가하고 시트 이름을 "4차전형"으로 한다.
							var nResult2 = tfexcel.addsheet(4, "4차전형");
							nResult2 = tfexcel.activatesheet(4);
							if(nResult2 <0) {
								alert("오류발생");
								return;
							}
							//로딩
							tfexcel.loadCSV("C:\\Temp\\sheet4.xls");
							
							//workbook을 저장.
							tfexcel.save(fileName);
							//엑셀 종료(필수)
							tfexcel.close();
						}
					]]>
				</script>
			</button>
			<switch id="switch1" style="left:0px; top:100px; width:1190px; height:595px; ">
				<case id="case1" selected="true" style="left:0px; top:0px; width:1188px; height:593px; ">
					<datagrid id="grd_one" nodeset="/root/main/tab1/one" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사     유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사     유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 95, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 45, 45, 40, 125, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:25px; width:1185px; height:540px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col disabled="true" ref="gndr" type="combo" style="text-align:center; ">
							<choices>
								<itemset nodeset="/root/init/gender">
									<label ref="label"/>
									<value ref="value"/>
								</itemset>
							</choices>
						</col>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno" style="text-align:center; "/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn" type="input" maxlength="50"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
								var scorsum = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scorsum"));
								var scoravg = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scoravg"));
								var count = 0;
								var scor1 = 0;
								var scor2 = 0;
								var scor3 = 0;
								var scor4 = 0;
								var scor5 = 0;
								var scor6 = 0;
								var scor7 = 0;
								var scor8 = 0;
								var scor9 = 0;
								var scor10 = 0;
								
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor1")) != "0") {
									scor1 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor1"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor2")) != "0" ) {
									scor2 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor2"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor3")) != "0") {
									scor3 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor3"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor4")) != "0" ) {
									scor4 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor4"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor5")) != "0") {
									scor5 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor5"));
									count++
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor6")) != "0" ) {
									scor6 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor6"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor7")) != "0") {
									scor7 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor7"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor8")) != "0" ) {
									scor8 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor8"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor9")) != "0") {
									scor9 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor9"));
									count++;
								}
								if( grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor10")) != "0" ) {
									scor10 = grd_one.valueMatrix(grd_one.row, grd_one.colRef("scor10"));
									count++;
								}
								
								scorsum = parseInt(scor1) + parseInt(scor2) + parseInt(scor3) + parseInt(scor4) + parseInt(scor5)
												+ parseInt(scor6) + parseInt(scor7) + parseInt(scor8) + parseInt(scor9) + parseInt(scor10);
								
								grd_one.valueMatrix(grd_one.row, grd_one.colRef("scoravg")) = parseInt(scorsum/count);
									
								grd_one.valueMatrix(grd_one.row, grd_one.colRef("scorsum")) = parseInt(scorsum);
								model.refresh();
							]]>
						</script>
						<script type="javascript" ev:event="ondblclick">
							<![CDATA[
								var col = grd_one.col;
								if( col == grd_one.colRef("scor1") || col == grd_one.colRef("scor2") || col == grd_one.colRef("scor3") || col == grd_one.colRef("scor4") ||
								    col == grd_one.colRef("scor5") || col == grd_one.colRef("scor6") || col == grd_one.colRef("scor7") || col == grd_one.colRef("scor8") ||
									col == grd_one.colRef("scor9") || col == grd_one.colRef("scor10")  || col == grd_one.colRef("resn") ) {
										;
								}
								else {
									model.removenode("/root/send/save/info");
									model.makeNode("/root/send/save/info/examno");
									model.makeNode("/root/send/save/info/apntinfono");
									model.makeNode("/root/send/save/info/nursdept");
									
									model.setValue("/root/send/save/info/examno",grd_one.valueMatrix(grd_one.row, grd_one.colRef("examno")) );
									model.setValue("/root/send/save/info/apntinfono",grd_one.valueMatrix(grd_one.row, grd_one.colRef("apntinfono")) );
									
									var index = cmb_apntinfono.focusIndex + 1 ;
									model.setValue("/root/send/save/info/nursdept",model.getValue("/root/main/apntinfo/apntinfolist[" + index + "]/nursdept") );						
									
									submit("TRRPE00303");
									
									if( model.getValue("/root/send/save/info/nursdept") == "Y" ) {
										exeReportPreview("RPRPE00301", "XMLSTR");
									}
									else {
										exeReportPreview("RPRPE00300", "XMLSTR");
									}
								}
							]]>
						</script>
					</datagrid>
					<caption id="caption15" class="tit_2" style="left:5px; top:5px; width:157px; height:13px; ">1차</caption>
					<line id="line6" class="line_1" style="x1:1px; y1:20px; x2:1186px; y2:20px; "/>
					<datagrid id="grd_loadone" nodeset="/root/main/loadexcel/loadone" visibility="hidden" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 100, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 60, 60, 40, 100, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:345px; width:1185px; height:220px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col ref="gndr" style="text-align:center; "/>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno"/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
					</datagrid>
				</case>
				<case id="case2">
					<line id="line5" class="line_1" style="x1:0px; y1:20px; x2:1185px; y2:20px; "/>
					<caption id="caption14" class="tit_2" style="left:5px; top:5px; width:157px; height:14px; ">2차</caption>
					<datagrid id="grd_two" nodeset="/root/main/tab2/two" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사     유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사     유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 95, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 45, 45, 40, 125, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:25px; width:1185px; height:540px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col disabled="true" ref="gndr" type="combo" style="text-align:center; ">
							<choices>
								<itemset nodeset="/root/init/gender">
									<label ref="label"/>
									<value ref="value"/>
								</itemset>
							</choices>
						</col>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno"/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" type="output" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn" type="input" maxlength="50"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
								var scorsum = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scorsum"));
								var scoravg = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scoravg"));
								var count = 0;
								var scor1 = 0;
								var scor2 = 0;
								var scor3 = 0;
								var scor4 = 0;
								var scor5 = 0;
								var scor6 = 0;
								var scor7 = 0;
								var scor8 = 0;
								var scor9 = 0;
								var scor10 = 0;
								
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor1")) != "0") {
									scor1 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor1"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor2")) != "0" ) {
									scor2 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor2"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor3")) != "0") {
									scor3 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor3"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor4")) != "0" ) {
									scor4 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor4"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor5")) != "0") {
									scor5 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor5"));
									count++
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor6")) != "0" ) {
									scor6 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor6"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor7")) != "0") {
									scor7 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor7"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor8")) != "0" ) {
									scor8 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor8"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor9")) != "0") {
									scor9 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor9"));
									count++;
								}
								if( grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor10")) != "0" ) {
									scor10 = grd_two.valueMatrix(grd_two.row, grd_two.colRef("scor10"));
									count++;
								}
								
								scorsum = parseInt(scor1) + parseInt(scor2) + parseInt(scor3) + parseInt(scor4) + parseInt(scor5)
												+ parseInt(scor6) + parseInt(scor7) + parseInt(scor8) + parseInt(scor9) + parseInt(scor10);
								
								grd_two.valueMatrix(grd_two.row, grd_two.colRef("scoravg")) = parseInt(scorsum/count);
									
								grd_two.valueMatrix(grd_two.row, grd_two.colRef("scorsum")) = scorsum;
								model.refresh();
							]]>
						</script>
						<script type="javascript" ev:event="ondblclick">
							<![CDATA[
								var col = grd_two.col;
								if( col == grd_two.colRef("scor1") || col == grd_two.colRef("scor2") || col == grd_two.colRef("scor3") || col == grd_two.colRef("scor4") ||
								    col == grd_two.colRef("scor5") || col == grd_two.colRef("scor6") || col == grd_two.colRef("scor7") || col == grd_two.colRef("scor8") ||
									col == grd_two.colRef("scor9") || col == grd_two.colRef("scor10")  || col == grd_two.colRef("resn") ) {
										;
								}
								else {
									model.removenode("/root/send/save/info");
									model.makeNode("/root/send/save/info/examno");
									model.makeNode("/root/send/save/info/apntinfono");
									model.makeNode("/root/send/save/info/nursdept");
									
									model.setValue("/root/send/save/info/examno",grd_two.valueMatrix(grd_two.row, grd_two.colRef("examno")) );
									model.setValue("/root/send/save/info/apntinfono",grd_two.valueMatrix(grd_two.row, grd_two.colRef("apntinfono")) );
									
									var index = cmb_apntinfono.focusIndex + 1 ;
									model.setValue("/root/send/save/info/nursdept",model.getValue("/root/main/apntinfo/apntinfolist[" + index + "]/nursdept") );						
									
									submit("TRRPE00303");
									
									if( model.getValue("/root/send/save/info/nursdept") == "Y" ) {
										exeReportPreview("RPRPE00301", "XMLSTR");
									}
									else {
										exeReportPreview("RPRPE00300", "XMLSTR");
									}
								}
							]]>
						</script>
					</datagrid>
					<datagrid id="grd_loadtwo" nodeset="/root/main/loadexcel/loadtwo" visibility="hidden" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 100, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 60, 60, 40, 100, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:335px; width:1185px; height:245px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col ref="gndr" style="text-align:center; "/>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno"/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" type="output" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
					</datagrid>
				</case>
				<case id="case3">
					<caption id="caption13" class="tit_2" style="left:5px; top:5px; width:157px; height:13px; ">3차</caption>
					<line id="line4" class="line_1" style="x1:0px; y1:20px; x2:1185px; y2:20px; "/>
					<datagrid id="grd_three" nodeset="/root/main/tab3/three" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사     유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사     유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 95, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 45, 45, 40, 125, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:25px; width:1185px; height:540px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col disabled="true" ref="gndr" type="combo" style="text-align:center; ">
							<choices>
								<itemset nodeset="/root/init/gender">
									<label ref="label"/>
									<value ref="value"/>
								</itemset>
							</choices>
						</col>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno"/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" type="output" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn" type="input" maxlength="50"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
								var scorsum = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scorsum"));
								var scoravg = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scoravg"));
								var count = 0;
								var scor1 = 0;
								var scor2 = 0;
								var scor3 = 0;
								var scor4 = 0;
								var scor5 = 0;
								var scor6 = 0;
								var scor7 = 0;
								var scor8 = 0;
								var scor9 = 0;
								var scor10 = 0;
								
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor1")) != "0") {
									scor1 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor1"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor2")) != "0" ) {
									scor2 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor2"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor3")) != "0") {
									scor3 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor3"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor4")) != "0" ) {
									scor4 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor4"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor5")) != "0") {
									scor5 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor5"));
									count++
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor6")) != "0" ) {
									scor6 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor6"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor7")) != "0") {
									scor7 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor7"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor8")) != "0" ) {
									scor8 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor8"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor9")) != "0") {
									scor9 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor9"));
									count++;
								}
								if( grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor10")) != "0" ) {
									scor10 = grd_three.valueMatrix(grd_three.row, grd_three.colRef("scor10"));
									count++;
								}
								
								scorsum = parseInt(scor1) + parseInt(scor2) + parseInt(scor3) + parseInt(scor4) + parseInt(scor5)
												+ parseInt(scor6) + parseInt(scor7) + parseInt(scor8) + parseInt(scor9) + parseInt(scor10);
								
								grd_three.valueMatrix(grd_three.row, grd_three.colRef("scoravg")) = parseInt(scorsum/count);
								grd_three.valueMatrix(grd_three.row, grd_three.colRef("scorsum")) = scorsum;
								model.refresh();
							]]>
						</script>
						<script type="javascript" ev:event="ondblclick">
							<![CDATA[
								var col = grd_three.col;
								if( col == grd_three.colRef("scor1") || col == grd_three.colRef("scor2") || col == grd_three.colRef("scor3") || col == grd_three.colRef("scor4") ||
								    col == grd_three.colRef("scor5") || col == grd_three.colRef("scor6") || col == grd_three.colRef("scor7") || col == grd_three.colRef("scor8") ||
									col == grd_three.colRef("scor9") || col == grd_three.colRef("scor10")  || col == grd_three.colRef("resn")  ) {
										;
								}
								else {
									model.removenode("/root/send/save/info");
									model.makeNode("/root/send/save/info/examno");
									model.makeNode("/root/send/save/info/apntinfono");
									model.makeNode("/root/send/save/info/nursdept");
									
									model.setValue("/root/send/save/info/examno",grd_three.valueMatrix(grd_three.row, grd_three.colRef("examno")) );
									model.setValue("/root/send/save/info/apntinfono",grd_three.valueMatrix(grd_three.row, grd_three.colRef("apntinfono")) );
									
									
									var index = cmb_apntinfono.focusIndex + 1 ;
									model.setValue("/root/send/save/info/nursdept",model.getValue("/root/main/apntinfo/apntinfolist[" + index + "]/nursdept") );						
									
									submit("TRRPE00303");
									
									if( model.getValue("/root/send/save/info/nursdept") == "Y" ) {
										exeReportPreview("RPRPE00301", "XMLSTR");
									}
									else {
										exeReportPreview("RPRPE00300", "XMLSTR");
									}
								}
							]]>
						</script>
					</datagrid>
					<datagrid id="grd_loadthree" nodeset="/root/main/loadexcel/loadthree" visibility="hidden" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 100, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 60, 60, 40, 100, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:350px; width:1185px; height:220px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col ref="gndr" style="text-align:center; "/>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno"/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" type="output" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
					</datagrid>
				</case>
				<case id="case4">
					<line id="line1" class="line_1" style="x1:0px; y1:20px; x2:1185px; y2:20px; "/>
					<caption id="caption12" class="tit_2" style="left:5px; top:5px; width:157px; height:14px; ">4차</caption>
					<datagrid id="grd_four" nodeset="/root/main/tab4/four" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사     유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사     유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 95, 40, 40, 40, 40, 40, 40, 40, 40, 40, 40, 45, 45, 40, 125, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:25px; width:1185px; height:540px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col disabled="true" ref="gndr" type="combo" style="text-align:center; ">
							<choices>
								<itemset nodeset="/root/init/gender">
									<label ref="label"/>
									<value ref="value"/>
								</itemset>
							</choices>
						</col>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno"/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" type="output" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn" type="input" maxlength="50"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
						<script type="javascript" ev:event="xforms-value-changed">
							<![CDATA[
								var scorsum = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scorsum"));
								var scoravg = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scoravg"));
								var count = 0;
								var scor1 = 0;
								var scor2 = 0;
								var scor3 = 0;
								var scor4 = 0;
								var scor5 = 0;
								var scor6 = 0;
								var scor7 = 0;
								var scor8 = 0;
								var scor9 = 0;
								var scor10 = 0;
								
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor1")) != "0") {
									scor1 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor1"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor2")) != "0" ) {
									scor2 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor2"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor3")) != "0") {
									scor3 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor3"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor4")) != "0" ) {
									scor4 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor4"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor5")) != "0") {
									scor5 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor5"));
									count++
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor6")) != "0" ) {
									scor6 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor6"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor7")) != "0") {
									scor7 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor7"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor8")) != "0" ) {
									scor8 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor8"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor9")) != "0") {
									scor9 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor9"));
									count++;
								}
								if( grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor10")) != "0" ) {
									scor10 = grd_four.valueMatrix(grd_four.row, grd_four.colRef("scor10"));
									count++;
								}
								
								scorsum = parseInt(scor1) + parseInt(scor2) + parseInt(scor3) + parseInt(scor4) + parseInt(scor5)
												+ parseInt(scor6) + parseInt(scor7) + parseInt(scor8) + parseInt(scor9) + parseInt(scor10);
								
								grd_four.valueMatrix(grd_four.row, grd_four.colRef("scoravg")) = parseInt(scorsum/count);
								grd_four.valueMatrix(grd_four.row, grd_four.colRef("scorsum")) = scorsum;
								model.refresh();
							]]>
						</script>
						<script type="javascript" ev:event="ondblclick">
							<![CDATA[
								var col = grd_four.col;
								if( col == grd_four.colRef("scor1") || col == grd_four.colRef("scor2") || col == grd_four.colRef("scor3") || col == grd_four.colRef("scor4") ||
								    col == grd_four.colRef("scor5") || col == grd_four.colRef("scor6") || col == grd_four.colRef("scor7") || col == grd_four.colRef("scor8") ||
									col == grd_four.colRef("scor9") || col == grd_four.colRef("scor10")  || col == grd_four.colRef("resn")  ) {
										;
								}
								else {
									model.removenode("/root/send/save/info");
									model.makeNode("/root/send/save/info/examno");
									model.makeNode("/root/send/save/info/apntinfono");
									model.makeNode("/root/send/save/info/nursdept");
									
									model.setValue("/root/send/save/info/examno",grd_four.valueMatrix(grd_four.row, grd_four.colRef("examno")) );
									model.setValue("/root/send/save/info/apntinfono",grd_four.valueMatrix(grd_four.row, grd_four.colRef("apntinfono")) );
									
									var index = cmb_apntinfono.focusIndex + 1 ;
									model.setValue("/root/send/save/info/nursdept",model.getValue("/root/main/apntinfo/apntinfolist[" + index + "]/nursdept") );						
									
									submit("TRRPE00303");
									
									if( model.getValue("/root/send/save/info/nursdept") == "Y" ) {
										exeReportPreview("RPRPE00301", "XMLSTR");
									}
									else {
										exeReportPreview("RPRPE00300", "XMLSTR");
									}
								}
							]]>
						</script>
					</datagrid>
					<datagrid id="grd_loadfour" nodeset="/root/main/loadexcel/loadfour" visibility="hidden" autoresize="true" caption="순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^점수^합격여부^사유^이메일^핸드폰^flag|순번^채용정보번호^전형차수^수험번호^성명^성별^나이^주민등록번호^1^2^3^4^5^6^7^8^9^10^계^평균^합격여부^사유^이메일^핸드폰^flag" colsep="^" colwidth="31, 55, 50, 60, 50, 30, 30, 100, 50, 50, 50, 50, 50, 50, 50, 50, 50, 50, 60, 60, 40, 100, 130, 100, 42" dataheight="25" explorerbar="sort" frozencols="8" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:0px; top:400px; width:1185px; height:180px; ">
						<col ref="seq" visibility="hidden" style="text-align:center; "/>
						<col ref="apntinfono" visibility="hidden"/>
						<col ref="scrngdg" visibility="hidden"/>
						<col ref="examno" style="text-align:center; "/>
						<col ref="name" type="output" style="text-align:center; "/>
						<col ref="gndr" style="text-align:center; "/>
						<col ref="age" style="text-align:center; "/>
						<col ref="rregno"/>
						<col ref="scor1" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor2" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor3" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor4" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor5" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor6" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor7" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor8" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor9" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scor10" type="input" format="###" maxlength="3" style="text-align:center; "/>
						<col ref="scorsum" type="output" maxlength="4" style="text-align:center; "/>
						<col ref="scoravg" maxlength="4" style="text-align:center; "/>
						<col checkvalue="Y,N" ref="passyn" type="checkbox"/>
						<col ref="resn"/>
						<col ref="emailaddr"/>
						<col ref="supppsnmpphonno"/>
						<col ref="flag" visibility="hidden"/>
					</datagrid>
				</case>
			</switch>
			<button id="tab_1" class="btn_sw" group="tab1" selected="true" style="left:0px; top:79px; width:105px; height:22px; ">
				<caption>1차</caption>
				<toggle case="case1" ev:event="onclick"/>
			</button>
			<button id="tab_2" class="btn_sw" group="tab1" selected="false" style="left:105px; top:79px; width:105px; height:22px; ">
				<caption>2차</caption>
				<toggle case="case2" ev:event="onclick"/>
			</button>
			<button id="tab_3" class="btn_sw" group="tab1" selected="false" style="left:210px; top:79px; width:105px; height:22px; ">
				<caption>3차</caption>
				<toggle case="case3" ev:event="onclick"/>
			</button>
			<button id="tab_4" class="btn_sw" group="tab1" selected="false" style="left:315px; top:79px; width:105px; height:22px; ">
				<caption>4차</caption>
				<toggle case="case4" ev:event="onclick"/>
			</button>
			<button id="button8" class="btn2_letter6" style="left:1105px; top:80px; width:86px; height:19px; ">
				<caption>엑셀UpLoad</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls");
						
						grd_loadone.loadExcel(fileName,1);
						
						model.removeNodeset("root/main/tab1");
						model.refresh();
						for ( var idx1 = grd_loadone.fixedRows, a = grd_one.fixedRows; idx1 <= grd_loadone.rows; idx1++ ) {
							if( grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scrngdg")) == '1' ) {
								grd_one.addRow(false);
								
								grd_one.valueMatrix(a, grd_one.colRef("apntinfono")) = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("apntinfono"));
								grd_one.valueMatrix(a, grd_one.colRef("scrngdg"))    = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scrngdg"));
								grd_one.valueMatrix(a, grd_one.colRef("examno"))     = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("examno"));
								grd_one.valueMatrix(a, grd_one.colRef("name"))    = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("name"));
								grd_one.valueMatrix(a, grd_one.colRef("gndr"))     = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("gndr"));
								grd_one.valueMatrix(a, grd_one.colRef("age"))    = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("age"));
								grd_one.valueMatrix(a, grd_one.colRef("scor1"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor1"));
								grd_one.valueMatrix(a, grd_one.colRef("scor2"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor2"));
								grd_one.valueMatrix(a, grd_one.colRef("scor3"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor3"));
								grd_one.valueMatrix(a, grd_one.colRef("scor4"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor4"));
								grd_one.valueMatrix(a, grd_one.colRef("scor5"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor5"));
								grd_one.valueMatrix(a, grd_one.colRef("scor6"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor6"));
								grd_one.valueMatrix(a, grd_one.colRef("scor7"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor7"));
								grd_one.valueMatrix(a, grd_one.colRef("scor8"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor8"));
								grd_one.valueMatrix(a, grd_one.colRef("scor9"))      = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor9"));
								grd_one.valueMatrix(a, grd_one.colRef("scor10")) 	= grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scor10"));
								grd_one.valueMatrix(a, grd_one.colRef("scorsum"))	= grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scorsum"));
								grd_one.valueMatrix(a, grd_one.colRef("scoravg"))	= grd_loadone.valueMatrix(idx1, grd_loadone.colRef("scoravg"));
								grd_one.valueMatrix(a, grd_one.colRef("passyn"))    = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("passyn"));
								grd_one.valueMatrix(a, grd_one.colRef("resn"))    	= grd_loadone.valueMatrix(idx1, grd_loadone.colRef("resn"));
								grd_one.valueMatrix(a, grd_one.colRef("emailaddr")) = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("emailaddr"));
								grd_one.valueMatrix(a, grd_one.colRef("supppsnmpphonno"))    = grd_loadone.valueMatrix(idx1, grd_loadone.colRef("supppsnmpphonno"));
								
								a++;
							}
						}
						model.refresh();
						
						grd_loadtwo.loadExcel(fileName,2);
						model.removeNodeset("root/main/tab2");
						model.refresh();
						for ( var idx2 = grd_loadtwo.fixedRows, b = grd_two.fixedRows; idx2 <= grd_loadtwo.rows; idx2++ ) {                             
							if( grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scrngdg")) == '2' ) {                                                
								grd_two.addRow(false);                                                                                                      
								
								grd_two.valueMatrix(b, grd_two.colRef("apntinfono")) = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("apntinfono"));
								grd_two.valueMatrix(b, grd_two.colRef("scrngdg"))    = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scrngdg"));   
								grd_two.valueMatrix(b, grd_two.colRef("examno"))     = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("examno"));    
								grd_two.valueMatrix(b, grd_two.colRef("name"))     = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("name"));    
								grd_two.valueMatrix(b, grd_two.colRef("scor1"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor1"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor2"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor2"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor3"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor3"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor4"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor4"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor5"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor5"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor6"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor6"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor7"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor7"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor8"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor8"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor9"))      = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor9"));     
								grd_two.valueMatrix(b, grd_two.colRef("scor10"))     = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scor10"));    
								grd_two.valueMatrix(b, grd_two.colRef("scorsum"))    = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scorsum"));   
								grd_two.valueMatrix(b, grd_two.colRef("scoravg"))    = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("scoravg"));   
								grd_two.valueMatrix(b, grd_two.colRef("passyn"))    = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("passyn"));   
								grd_two.valueMatrix(b, grd_two.colRef("gndr"))     = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("gndr"));
								grd_two.valueMatrix(b, grd_two.colRef("age"))    	= grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("age"));
								grd_two.valueMatrix(b, grd_two.colRef("resn"))    	= grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("resn"));
								grd_two.valueMatrix(b, grd_two.colRef("emailaddr"))    = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("emailaddr"));
								grd_two.valueMatrix(b, grd_two.colRef("supppsnmpphonno"))    = grd_loadtwo.valueMatrix(idx2, grd_loadtwo.colRef("supppsnmpphonno"));
								
								b++;
							}
						}
						model.refresh();
						
						grd_loadthree.loadExcel(fileName,3);
						model.removeNodeset("root/main/tab3");
						model.refresh();
						for ( var idx3 = grd_loadthree.fixedRows, c = grd_three.fixedRows; idx3 <= grd_loadthree.rows; idx3++ ) {
							if( grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scrngdg")) == '3' ) {
								grd_three.addRow(false);
								
								grd_three.valueMatrix(c, grd_three.colRef("apntinfono")) = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("apntinfono"));
								grd_three.valueMatrix(c, grd_three.colRef("scrngdg"))    = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scrngdg"));
								grd_three.valueMatrix(c, grd_three.colRef("examno"))     = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("examno"));
								grd_three.valueMatrix(c, grd_three.colRef("name"))    = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("name"));
								grd_three.valueMatrix(c, grd_three.colRef("scor1"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor1"));
								grd_three.valueMatrix(c, grd_three.colRef("scor2"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor2"));
								grd_three.valueMatrix(c, grd_three.colRef("scor3"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor3"));
								grd_three.valueMatrix(c, grd_three.colRef("scor4"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor4"));
								grd_three.valueMatrix(c, grd_three.colRef("scor5"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor5"));
								grd_three.valueMatrix(c, grd_three.colRef("scor6"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor6"));
								grd_three.valueMatrix(c, grd_three.colRef("scor7"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor7"));
								grd_three.valueMatrix(c, grd_three.colRef("scor8"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor8"));
								grd_three.valueMatrix(c, grd_three.colRef("scor9"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor9"));
								grd_three.valueMatrix(c, grd_three.colRef("scor9"))      = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor9"));
								grd_three.valueMatrix(c, grd_three.colRef("scor10"))    	= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scor10"));    
								grd_three.valueMatrix(c, grd_three.colRef("scorsum"))	= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scorsum"));   
								grd_three.valueMatrix(c, grd_three.colRef("scoravg")) 	= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("scoravg"));   
								grd_three.valueMatrix(c, grd_three.colRef("passyn"))   	= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("passyn"));   
								grd_three.valueMatrix(c, grd_three.colRef("gndr"))     	= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("gndr"));                   
								grd_three.valueMatrix(c, grd_three.colRef("age"))    		= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("age"));   
								grd_three.valueMatrix(c, grd_three.colRef("resn"))    	= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("resn"));                      
								grd_three.valueMatrix(c, grd_three.colRef("emailaddr"))	= grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("emailaddr"));             
								grd_three.valueMatrix(c, grd_three.colRef("supppsnmpphonno"))    = grd_loadthree.valueMatrix(idx3, grd_loadthree.colRef("supppsnmpphonno")); 
								
								c++;
							}
						}
						model.refresh();
						
						grd_loadfour.loadExcel(fileName,4);
						model.removeNodeset("root/main/tab4");
						model.refresh();
						for ( var idx4 = grd_loadfour.fixedRows, d = grd_four.fixedRows; idx4 <= grd_loadfour.rows; idx4++ ) {
							if( grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scrngdg")) == '4' ) {
								grd_four.addRow(false);
								
								grd_four.valueMatrix(d, grd_four.colRef("apntinfono")) = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("apntinfono"));
								grd_four.valueMatrix(d, grd_four.colRef("scrngdg"))    = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scrngdg"));
								grd_four.valueMatrix(d, grd_four.colRef("examno"))     = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("examno"));
								grd_four.valueMatrix(d, grd_four.colRef("name"))     = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("name"));
								grd_four.valueMatrix(d, grd_four.colRef("scor1"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor1"));
								grd_four.valueMatrix(d, grd_four.colRef("scor2"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor2"));
								grd_four.valueMatrix(d, grd_four.colRef("scor3"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor3"));
								grd_four.valueMatrix(d, grd_four.colRef("scor4"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor4"));
								grd_four.valueMatrix(d, grd_four.colRef("scor5"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor5"));
								grd_four.valueMatrix(d, grd_four.colRef("scor6"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor6"));
								grd_four.valueMatrix(d, grd_four.colRef("scor7"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor7"));
								grd_four.valueMatrix(d, grd_four.colRef("scor8"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor8"));
								grd_four.valueMatrix(d, grd_four.colRef("scor9"))      = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor9"));
								grd_four.valueMatrix(d, grd_four.colRef("scor10"))  	= grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scor10"));
								grd_four.valueMatrix(d, grd_four.colRef("scorsum"))	 = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scorsum"));
								grd_four.valueMatrix(d, grd_four.colRef("scoravg"))	= grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("scoravg"));
								grd_four.valueMatrix(d, grd_four.colRef("passyn"))    = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("passyn"));
								grd_four.valueMatrix(d, grd_four.colRef("gndr"))     	= grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("gndr"));                       
								grd_four.valueMatrix(d, grd_four.colRef("age"))    	= grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("age"));      
								grd_four.valueMatrix(d, grd_four.colRef("resn"))   	= grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("resn"));                              
								grd_four.valueMatrix(d, grd_four.colRef("emailaddr"))    = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("emailaddr"));              
								grd_four.valueMatrix(d, grd_four.colRef("supppsnmpphonno"))    = grd_loadfour.valueMatrix(idx4, grd_loadfour.colRef("supppsnmpphonno"));  
								
								d++;
							}
						}
						model.refresh();
					]]>
				</script>
			</button>
			<select id="chk_pass" ref="/root/send/apntinfo/passyn" visibility="visible" overflow="visible" appearance="full" style="left:755px; top:83px; width:105px; height:15px; border-style:none; ">
				<choices>
					<item>
						<label>불합격자Check</label>
						<value>N</value>
					</item>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if( chk_pass.value == 'N' ) {
							if( tab_1.selected ) {
								grd_one.clearStatus();
								for( var idx = grd_one.fixedRows; idx <= grd_one.rows; idx++) {
									if( grd_one.valueMatrix(idx, grd_one.colRef("passyn")) == 'A' ) {
										grd_one.valueMatrix(idx, grd_one.colRef("passyn")) = 'N' 
										grd_one.addStatus(idx, "update");
									}
								}
							}
							else if( tab_2.selected ) {
								grd_two.clearStatus();
								for( var idx = grd_two.fixedRows; idx <= grd_two.rows; idx++) {
									if( grd_two.valueMatrix(idx, grd_two.colRef("passyn"))== 'A' ) {
										grd_two.valueMatrix(idx, grd_two.colRef("passyn")) = 'N' 
										grd_two.addStatus(idx, "update");
									}
								}
							}
							else if( tab_3.selected ) {
								grd_three.clearStatus();
								for( var idx = grd_three.fixedRows; idx <= grd_three.rows; idx++) {
									if( grd_three.valueMatrix(idx, grd_three.colRef("passyn")) == 'A' ) {
										grd_three.valueMatrix(idx, grd_three.colRef("passyn")) = 'N' 
										grd_three.addStatus(idx, "update");
									}
								}
							}
							else if( tab_4.selected ) {
								grd_four.clearStatus();
								for( var idx = grd_four.fixedRows; idx <= grd_four.rows; idx++) {
									if( grd_four.valueMatrix(idx, grd_four.colRef("passyn")) == 'A' ) {
										grd_four.valueMatrix(idx, grd_four.colRef("passyn")) = 'N' 
										grd_four.addStatus(idx, "update");
									}
								}
							}
						}
						else if( chk_pass.value == '' ) {
							if( tab_1.selected ) {
								grd_one.clearStatus();
							}
							else if( tab_2.selected ) {
								grd_two.clearStatus();
							}
							else if( tab_3.selected ) {
								grd_three.clearStatus();
							}
							else if( tab_4.selected ) {
								grd_four.clearStatus();
							}
						}
						
						model.refresh();
					]]>
				</script>
			</select>
			<button id="button9" class="btn2_letter7" style="left:939px; top:80px; width:97px; height:19px; ">
				<caption>Mail/SMS발송</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[	
						// data를 팝업창으로 넘겨 자동으로 조회하기위해 ...
						model.setValue("/root/send/req/instcd", cmb_instcd.value);
						model.setValue("/root/send/req/prfshipflag", cmb_prfshipflag.value);
						model.setValue("/root/send/req/apntfromdd", ipt_apntfromdd.value);
						model.setValue("/root/send/req/apnttodd", ipt_apnttodd.value);
						model.setValue("/root/send/req/appjobkindcd", ipt_appjobkind.value);
						model.setValue("/root/send/req/recufildcd", ipt_recufildcd.value);
						model.setValue("/root/send/req/hopedeptcd",ipt_hopedeptcd.value); 
						model.setValue("/root/send/req/apntinfono",cmb_apntinfono.value);
						
						if( tab_1.selected ) {
							model.setValue("/root/send/req/scrngdg","1");
						}
						else if( tab_2.selected ) {
							model.setValue("/root/send/req/scrngdg","2");
						}
						else if( tab_3.selected ) {
							model.setValue("/root/send/req/scrngdg","3");
						}
						else if( tab_4.selected ) {
							model.setValue("/root/send/req/scrngdg","4");
						}
							
						// commonWeb-common.js 에 open함수 있음.
						open("SPRPE11000","","20","20","popup", "/root/send/req" ,"/root/temp/req");
					]]>
				</script>
			</button>
			<select1 id="cmb_apntinfono" ref="/root/send/apntinfo/apntinfono" class="combo_search" navindex="2" appearance="minimal" style="left:666px; top:44px; width:190px; height:19px; ">
				<choices>
					<itemset nodeset="/root/main/apntinfo/apntinfolist">
						<label ref="titl"/>
						<value ref="apntinfono"/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						var index = cmb_apntinfono.focusIndex + 1 ;
						var scrngdg = model.getValue("/root/main/apntinfo/apntinfolist[" + index + "]/scrngdg");
						switch( scrngdg ) {
							case '1':
								tab_1.visible = true;
								tab_2.visible = false;
								tab_3.visible = false;
								tab_4.visible = false;
								break;
							case '2':
								tab_1.visible = true;
								tab_2.visible = true;
								tab_3.visible = false;
								tab_4.visible = false;
								break;
							case '3':
								tab_1.visible = true;
								tab_2.visible = true;
								tab_3.visible = true;
								tab_4.visible = false;
								break;
							case '4':
								tab_1.visible = true;
								tab_2.visible = true;
								tab_3.visible = true;
								tab_4.visible = true;
								break;
						}
					]]>
				</script>
			</select1>
			<input id="input1" ref="/root/send/apntinfo/apntyy" class="input_s_essential" visibility="hidden" inputtype="date" style="left:435px; top:70px; width:90px; height:19px; "/>
			<input id="ipt_scor" ref="/root/send/apntinfo/scor" visibility="visible" style="left:863px; top:80px; width:50px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						if( ipt_scor.value != '' ) {
							if( tab_1.selected ) {
								for( var idx = grd_one.fixedRows; idx <= grd_one.rows; idx++) {
									if( grd_one.valueMatrix(idx, grd_one.colRef("passyn")) != 'Y' && grd_one.rowStatus(idx) == '2' ) {
										grd_one.valueMatrix(idx, grd_one.colRef("scor1")) = ipt_scor.value;
										grd_one.valueMatrix(idx, grd_one.colRef("scorsum")) = ipt_scor.value;
										grd_one.valueMatrix(idx, grd_one.colRef("scoravg")) = ipt_scor.value;
									}
								}
							}
							else if( tab_2.selected ) {
								for( var idx = grd_two.fixedRows; idx <= grd_two.rows; idx++) {
									if( grd_two.valueMatrix(idx, grd_two.colRef("passyn")) != 'Y' && grd_two.rowStatus(idx) == '2' ) {
										grd_two.valueMatrix(idx, grd_two.colRef("scor1")) = ipt_scor.value;
										grd_two.valueMatrix(idx, grd_two.colRef("scorsum")) = ipt_scor.value;
										grd_two.valueMatrix(idx, grd_two.colRef("scoravg")) = ipt_scor.value;
									}
								}
							}
							else if( tab_3.selected ) {
								for( var idx = grd_three.fixedRows; idx <= grd_three.rows; idx++) {
									if( grd_three.valueMatrix(idx, grd_three.colRef("passyn")) != 'Y' && grd_three.rowStatus(idx) == '2' ) {
										grd_three.valueMatrix(idx, grd_three.colRef("scor1")) = ipt_scor.value;
										grd_three.valueMatrix(idx, grd_three.colRef("scorsum")) = ipt_scor.value;
										grd_three.valueMatrix(idx, grd_three.colRef("scoravg")) = ipt_scor.value;
									}
								}
							}
							else if( tab_4.selected ) {
								for( var idx = grd_four.fixedRows; idx <= grd_four.rows; idx++) {
									if( grd_four.valueMatrix(idx, grd_four.colRef("passyn")) != 'Y' && grd_four.rowStatus(idx) == '2' ) {
										grd_four.valueMatrix(idx, grd_four.colRef("scor1")) = ipt_scor.value;
										grd_four.valueMatrix(idx, grd_four.colRef("scorsum")) = ipt_scor.value;
										grd_four.valueMatrix(idx, grd_four.colRef("scoravg")) = ipt_scor.value;
									}
								}
							}
						}
						
						model.refresh();
					]]>
				</script>
			</input>
			<datagrid id="grd_lastpass" nodeset="/root/temp/hidden" visibility="hidden" caption="채용정보번호^수험번호^차수^년도" colsep="^" colwidth="100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="update" rowsep="|" style="left:440px; top:325px; width:505px; height:190px; ">
				<col ref="apntinfono"/>
				<col ref="scrngdg"/>
				<col ref="apntyy"/>
				<col ref="examno"/>
			</datagrid>
			<select1 id="cmb_grupjoblncd" ref="/root/send/apntinfo/grupjoblncd" class="combo_search" appearance="minimal" style="left:362px; top:18px; width:105px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						submit("TRRPE01011");
					]]>
				</script>
			</select1>
			<caption id="caption10" class="search_name" style="left:272px; top:18px; width:86px; height:17px; ">직     군 :</caption>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<button id="btn_save" class="btn4_letter2" style="left:1139px; top:2px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if( tab_1.selected ) {
							model.setValue("/root/save/save",grd_one.getUpdateData());
						}
						else if( tab_2.selected ) {
							model.setValue("/root/save/save",grd_two.getUpdateData());   
						}
						else if( tab_3.selected ) {
							model.setValue("/root/save/save",grd_three.getUpdateData());
						}
						else if( tab_4.selected ) {
							model.setValue("/root/save/save",grd_four.getUpdateData());
						}
						
						// "저장하시겠습니까?" 확인 클릭시 저장 submit..
						if( messageBox("","Q002") == "6" )	{
							submit("TXRPE00401");
							fSearch();
						}
						
						model.refresh();
						
						
					]]>
				</script>
			</button>
			<line id="line2" class="line_6" style="x1:0px; y1:25; x2:1195px; y2:25; "/>
			<button id="btn_lastpassyn" class="btn4_letter7" style="left:1020px; top:2px; width:116px; height:22px; ">
				<caption>최종합격자처리</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var nowyy = new Date();
						
						model.removeNodeset("/root/temp");
						model.refresh();
						
						var index = cmb_apntinfono.focusIndex + 1 ;
						var scrngdg = model.getValue("/root/main/apntinfo/apntinfolist[" + index + "]/scrngdg");
						switch( scrngdg ) {
							case '1':
								for(var idx = grd_one.fixedRows; idx < grd_one.rows; idx++) {
									if( grd_one.valueMatrix(idx,grd_one.colRef("passyn")) == "Y") {
										grd_lastpass.addRow();
										grd_lastpass.rowStatus(grd_lastpass.row) = 2;
										
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntinfono")) = grd_one.valueMatrix(idx,grd_one.colRef("apntinfono"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("scrngdg")) = grd_one.valueMatrix(idx,grd_one.colRef("scrngdg"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("examno")) = grd_one.valueMatrix(idx,grd_one.colRef("examno"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntyy")) = nowyy.getYear();
									}
								}
								model.setValue("/root/apntinfolist",grd_lastpass.getUpdateData());
								break;
							case '2':
								for(var idx = grd_two.fixedRows; idx < grd_two.rows; idx++) {
									if( grd_two.valueMatrix(idx,grd_two.colRef("passyn")) == "Y") {
										grd_lastpass.addRow();
										grd_lastpass.rowStatus(grd_lastpass.row) = 2;
										
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntinfono")) = grd_two.valueMatrix(idx,grd_two.colRef("apntinfono"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("scrngdg")) = grd_two.valueMatrix(idx,grd_two.colRef("scrngdg"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("examno")) = grd_two.valueMatrix(idx,grd_two.colRef("examno"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntyy")) = nowyy.getYear();
									}
								}
								model.setValue("/root/apntinfolist",grd_lastpass.getUpdateData());
								break;
							case '3':
								for(var idx = grd_three.fixedRows; idx < grd_three.rows; idx++) {
									if( grd_three.valueMatrix(idx,grd_three.colRef("passyn")) == "Y") {
										grd_lastpass.addRow();
										grd_lastpass.rowStatus(grd_lastpass.row) = 2;
										
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntinfono")) = grd_three.valueMatrix(idx,grd_three.colRef("apntinfono"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("scrngdg")) = grd_three.valueMatrix(idx,grd_three.colRef("scrngdg"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("examno")) = grd_three.valueMatrix(idx,grd_three.colRef("examno"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntyy")) = nowyy.getYear();
									}
								}
								model.setValue("/root/apntinfolist",grd_lastpass.getUpdateData());
								break;
							case '4':
								for(var idx = grd_four.fixedRows; idx < grd_four.rows; idx++) {
									if( grd_four.valueMatrix(idx,grd_four.colRef("passyn")) == "Y") {
										grd_lastpass.addRow();
										grd_lastpass.rowStatus(grd_lastpass.row) = 2;
										
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntinfono")) = grd_four.valueMatrix(idx,grd_four.colRef("apntinfono"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("scrngdg")) = grd_four.valueMatrix(idx,grd_four.colRef("scrngdg"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("examno")) = grd_four.valueMatrix(idx,grd_four.colRef("examno"));
										grd_lastpass.valueMatrix(grd_lastpass.row,grd_lastpass.colRef("apntyy")) = nowyy.getYear();
									}
								}
								model.setValue("/root/apntinfolist",grd_lastpass.getUpdateData());
								break;
						}
						
						// "저장하시겠습니까?" 확인 클릭시 저장 submit..
						if( messageBox("최종합격자 처리를 하시겠습니까?","Q999") == "6" )	{
							model.setValue("/root/apntinfolist",grd_lastpass.getUpdateData() );
							if(submit("TXRPE00103")) messageBox("처리되었습니다.","I999");
							fSearch();
						}
						
						model.refresh();
						
					]]>
				</script>
			</button>
		</group>
		<object id="tfexcel" clsid="{fe8d1001-6a9d-424d-ae2a-301493bb12da}" style="left:0px; top:0px; width:0px; height:0px; "/>
	</xhtml:body>
</xhtml:html>