YNU_JEUS/app_home/himed/webapps/mis/tchrappointmentmngtweb/xrw/SMRCS01400_서류심사전공심사대상.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.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>SMRCS01200_지원결과출력</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<list>
							<volntprescondlist>
							</volntprescondlist>
						</list>
					</main>
					<send>
						<searchinfo>
							<instcd/>
							<eduinstcd/>
							<yy/>
							<term/>
							<step/>
							<sucestatus/>
						</searchinfo>
					</send>
					<init>
						<opnemp>
							<label>충족</label>
							<value>F</value>
							<label>미충족</label>
							<value>N</value>
						</opnemp>
					</init>
				</root>
			</instance>
			<script type="javascript" src="../../../com/commonweb/js/common.js"/>
			<script type="javascript" src="../../../com/basiccodeweb/js/ZBC001.js"/>
			<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
			<script type="javascript" src="../../../mis/humtrafactmngtweb/js/RPB001.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/RSZ001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
				]]>
			</script>
			<submission id="TRRPD02801" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/req" resultref="/root/main/list"/>
			<submission id="TXRPD02801" ref="/root/send/suppcost" resultref="/root/temp"/>
			<submission id="TRZBC00122" mediatype="application/x-www-form-urlencoded" method="post" replace="instance"/>
		</model>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
				}
 			]]>
		</script>
	</xhtml:head>
	<xhtml:body guideline="2,763;2,760;" 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:28px; width:1195px; height:744px; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:61px; "/>
			<line id="line207" class="line_1" style="x1:0px; y1:94px; x2:1195px; y2:94px; "/>
			<caption id="caption9" class="tit_2" style="left:0px; top:79px; width:117px; height:13px; ">지원결과출력</caption>
			<multilinegrid id="grd_volntprescondlist" nodeset="/root/main/list/volntprescondlist" class="datagrid2" caption="교실명^재과/학과^기관명^직할인원^충원인원^초빙분야^성명^주민등록번호^학력^수련경력^임상경력^임상경력^임상경력기간^논문점수^연구실적(1저자)^연구실적(1저자)^논문/필수/학위/경력^논문/필수/학위/경력^논문/필수/학위/경력^논문/필수/학위/경력^^충족여부조교수/전강^충족여부조교수/전강^결과^비고|교실명^재과/학과^기관명^직할인원^충원인원^초빙분야^성명^주민등록번호^학력^수련경력^임상경력^임상경력^임상경력기간^논문점수^SCI원저/증례(종설포함)^국내원저/증례^필수업적^논문점수^학위(석박통합4학기포함)^임상경력충족^부교수^조교수^전임강사^결과^비고" colsep="^" colwidth="83, 84, 100, 50, 50, 100, 100, 100, 110, 128, 100, 100, 100, 100, 136, 100, 100, 100, 139, 141, 100, 100, 100, 100, 100" rowheader="update" rowheight="24" rowsep="|" mergecellsfixedrows="bycolrec" style="left:0px; top:99px; width:1194px; height:615    px; font-weight:normal; text-align:center; ">
				<row>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
					<col rowspan="2"/>
				</row>
				<row>
					<col/>
					<col/>
				</row>
			</multilinegrid>
			<select1 id="cmb_appfrmlrg" ref="/root/send/searchinfo/eduinstcd" navindex="2" appearance="minimal" style="left:90px; top:20px; width:115px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
				    ]]>
				</script>
			</select1>
			<caption id="caption2" class="search_name" style="left:420px; top:20px; width:126px; height:17px; ">학년도 :</caption>
			<caption id="caption5" class="search_name" style="left:15px; top:20px; width:86px; height:17px; ">교실명 :</caption>
			<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" style="left:1125px; top:31px; width:56px; height:22px; text-align:left; ">
				<caption>조회</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[					
					 ]]>
				</script>
			</button>
			<select1 id="cmb_appfrmsml" ref="/root/send/searchinfo/yy" disabled="false" navindex="3" appearance="minimal" style="left:498px; top:20px; width:87px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/opnemp">
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					]]>
				</script>
			</select1>
			<select1 id="combo2" ref="/root/send/searchinfo/instcd" navindex="2" appearance="minimal" style="left:295px; top:20px; width:95px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
				    ]]>
				</script>
			</select1>
			<caption id="caption3" class="search_name" style="left:220px; top:19px; width:93px; height:17px; ">기관명 :</caption>
			<caption id="caption1" class="search_name" style="left:615px; top:20px; width:126px; height:17px; ">학  기 :</caption>
			<select1 id="combo1" ref="/root/send/searchinfo/term" disabled="false" navindex="3" appearance="minimal" style="left:693px; top:20px; width:87px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/opnemp">
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					]]>
				</script>
			</select1>
			<caption id="caption4" class="search_name" style="left:812px; top:20px; width:126px; height:17px; ">모집명 :</caption>
			<select1 id="combo3" ref="/root/send/searchinfo/sucestatus" disabled="false" navindex="3" appearance="minimal" style="left:890px; top:20px; width:87px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/opnemp">
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					]]>
				</script>
			</select1>
			<select1 id="combo4" ref="/root/send/searchinfo/step" disabled="false" navindex="3" appearance="minimal" style="left:103px; top:45px; width:102px; height:19px; ">
				<choices>
					<itemset nodeset="/root/init/opnemp">
						<label/>
						<value/>
					</itemset>
				</choices>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
					]]>
				</script>
			</select1>
			<caption id="caption7" class="search_name" style="left:15px; top:45px; width:126px; height:17px; ">모집분야 :</caption>
			<button id="btn_7" class="btn2_letter4" style="left:1125px; top:74px; 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>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<line id="line7" class="line_6" style="x1:0px; y1:25px; x2:1195px; y2:25px; "/>
		</group>
	</xhtml:body>
</xhtml:html>