YNU_JEUS/app_home/himed/webapps/mis/tistrngeducplanmngtweb/xrw/SMRTS00100_인턴수련계획관리.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet href="../../../com/commonweb/css/common.css" type="text/css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>인턴 수련계획 관리</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<intntrnghospplanlist/>
					</main>
					<send>
						<condition>
							<yy/>
							<supinfqurtyyflag>1</supinfqurtyyflag>
							<emplno/>
							<firstinstcd/>
							<secondinstcd/>
							<name/>
							<posinstcd/>
							<apprtcdrflag/>
						</condition>
						<save>
							<intntrnghospplanlist/>
						</save>
						<intntrnghospplanlist>
							<emplno/>
							<yy/>
							<supinfqurtyyflag/>
						</intntrnghospplanlist>
					</send>
					<init/>
					<hidden>
						<excelloadyn/>
					</hidden>
					<temp>
						<prcpmsg/>
						<tretmsg/>
						<tretcnt/>
						<tretdouyn/>
					</temp>
				</root>
			</instance>
			<submission id="TRRTS00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/main/intntrnghospplanlist"/>
			<submission id="TXRTS00101" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/save" resultref="/root/temp"/>
			<submission id="TXRTS00102" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/temp"/>
			<submission id="TXRTS00103" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/condition" resultref="/root/temp"/>
		</model>
		<script type="javascript" src="../../../com/commonweb/js/common.js"/>
		<script type="javascript" src="../../../com/commonweb/js/tfHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
		<script type="javascript" src="../../../com/commonweb/js/dateHelper.js"/>
		<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
		<script type="javascript" src="../../../mis/tistrngeducbaseinfomngtweb/js/RTC001.js"/>
		<script type="javascript" ev:event="xforms-ready">
			<![CDATA[
				//사용자 권한
				fCheckAuth();
				
				// 그리드 초기화
				misfGridInit(grd_intntrnghospplanlist);
				
				misfMsterDetailSet(grd_intntrnghospplanlist, null, "TRRTS00101", "Y");				

				
				misfComboComCdListMulti("R0237,R0305,Z0007,R0305", "cmb_supinfqurtyyflag,cmb_firstinstcd,cmb_posinstcd,combo1");
				
				addComboItem( "cmb_firstinstcd", "", "", "above");
			
				misfComboCopyItemSet(cmb_firstinstcd, "/root/send/condition/firstinstcd", cmb_secondinstcd, "/root/send/condition/secondinstcd");
				misfComboCopyItemSet(combo1, "/root/send/condition/firstinstcd", grd_intntrnghospplanlist, "firstinstcd");
				misfComboCopyItemSet(combo1, "/root/send/condition/firstinstcd", grd_intntrnghospplanlist, "secondinstcd");
				//misfComboCopyItemSet(cmb_posinstcd, "/root/send/condition/posinstcd", grd_intntrnghospplanlist, "posinstcd");
				var curDate = getCurrentDate().toDate().getDateFormat("YYYYMMDD");
				var isDate = curDate.toDate().getAddDate(2,'M').getDateFormat("YYYY");
				var sDate = getNewDate();		
				model.setValue("/root/send/condition/yy", isDate);
				ipt_apprtcdrflag.value="I";
				model.refresh();
			
			]]>
		</script>
		<script type="javascript">
			<![CDATA[
				//========================================================================================
				//버튼에 대한 화면 권한 체크(R : 읽기, X : 입력/수정/삭제, P : 출력)
				//========================================================================================
				function fCheckAuth() {
					btn_search.disabled = !checkAuth("R") ;
					btn_save.disabled = !checkAuth("X") ;
				}
				
				function fShowPrcpMsg()
				{
					var cnt_tot       = getNodesetCount("/root/main/intntrnghospplanlist");
					var cnt_one_empty = getNodesetCount("/root/main/intntrnghospplanlist[(firstinstcd='' and secondinstcd!='') or (firstinstcd!='' and secondinstcd='') ]");
					var cnt_two_empty = getNodesetCount("/root/main/intntrnghospplanlist[firstinstcd='' and secondinstcd='']");
					
					var msg = "조회된 건수 : " + cnt_tot;
					
					if (cnt_one_empty > 0)
					{
						msg += "\n\n";
						msg += "미배정된 건수가 존재합니다.\n\n";
						msg += "하나  미배정된 건수 : " + cnt_one_empty + "\n";
						msg += "모두  미배정된 건수 : " + cnt_two_empty + "\n";
						
						btn_prcphosp.disabled = false;
					}
					else
					{
						btn_prcphosp.disabled = true;
					}
					
					messageBox(msg, "I", "");
				}
			]]>
		</script>
	</xhtml:head>
	<xhtml:body style="margin-left:8; margin-right:8; ">
		<group id="group1" style="left:0px; top:0px; width:1195px; height:13px; ">
			<caption id="caption6" class="tit_1" style="left:0px; top:0px; width:800px; height:14px; ">인턴 수련 계획 관리</caption>
		</group>
		<group id="group2" scroll="auto" style="left:0px; top:38px; width:1195px; height:744px; ">
			<datagrid id="grd_intntrnghospplanlist" nodeset="/root/main/intntrnghospplanlist" caption="순번^이름^사원번호^채용번호^년도^상하반기^전공의구분^년차^주민번호^석차^성별^학교^군보^상반기^하반기^전공^3월^4월^5월^6월^7월^8월^9월^10월^11월^12월^1월^2월^수련계획여부^부서코드^수련년도변경여부^전공의구분^교육년도^임상과코드^소속기관" colsep="^" colwidth="40, 62, 80, 21, 21, 23, 24, 28, 28, 41, 37, 47, 83, 114, 132, 83, 35, 35, 35, 35, 35, 35, 35, 35, 35, 35, 35, 35, 28, 22, 18, 41, 50, 34, 100" dataheight="23" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="23" rowsep="|" style="left:0px; top:91px; width:1195px; height:633px; ">
				<col ref="rowno" style="text-align:center; "/>
				<col ref="name" style="text-align:center; "/>
				<col ref="emplno" type="inputbutton" style="text-align:center; "/>
				<col ref="apntinfono" visibility="hidden" style="text-align:center; "/>
				<col ref="yy" visibility="hidden" style="text-align:center; "/>
				<col ref="supinfqurtyyflag" visibility="hidden" style="text-align:center; "/>
				<col ref="apprtcdrflag" visibility="hidden" style="text-align:center; "/>
				<col ref="anual" visibility="hidden" style="text-align:center; "/>
				<col ref="rregno" visibility="hidden"/>
				<col ref="rank" style="text-align:center; "/>
				<col ref="gndr" style="text-align:center; "/>
				<col ref="schnm" style="text-align:center; "/>
				<col ref="armynm" style="text-align:center; "/>
				<col ref="firstinstcd" type="combo" _required="true">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="secondinstcd" type="combo" _required="true">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="dentyn" style="text-align:center; "/>
				<col imemode="alpha" ref="mardeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="aprdeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="maydeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="jundeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="juldeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="augdeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="sepdeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="octdeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="novdeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="decdeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="jandeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col imemode="alpha" ref="febdeptcd" type="input" format="LL" maxlength="2" style="text-align:center; "/>
				<col ref="dpdatayn" visibility="hidden" style="text-align:center; "/>
				<col ref="posdeptcd" visibility="hidden" style="text-align:center; "/>
				<col ref="trainyychangyn" visibility="hidden" style="text-align:center; "/>
				<col ref="apprtcdrflagnm" visibility="hidden" style="text-align:center; "/>
				<col ref="educyy" visibility="hidden" style="text-align:center; "/>
				<col ref="preststatcd" visibility="hidden" style="text-align:center; "/>
				<col ref="posinstcd" visibility="hidden"/>
				<script type="javascript" ev:event="onbuttonclick">
					<![CDATA[
						if (grd_intntrnghospplanlist.col == 2) {//사원번호 버튼을 눌렀을 때
						var recv_list = "emplno,name,rregno,apprtcdrflagnm,gndr,rank,schnm,armynm,anual,apprtcdrflag";
							misfOpenPopUpList("34", grd_intntrnghospplanlist,"",recv_list);
						}			
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
					 grd_intntrnghospplanlist.gridToInstance();
					]]>
				</script>
			</datagrid>
			<caption id="caption22" class="tit_2" style="left:5px; top:72px; width:157px; height:13px; ">근무병원 및 수련과관리</caption>
			<group id="group6" style="left:0px; top:10px; width:1195px; height:50px; vertical-align:top; ">
				<shape id="roundrect3" class="roundrect_search" appearance="roundrect" style="left:0px; top:10px; width:1195px; height:35px; "/>
				<caption id="cap_yy" class="search_name" style="left:15px; top:21px; width:85px; height:17px; ">년 도 :</caption>
				<caption id="cap_supinfqurtyyflag" class="search_name" style="left:166px; top:21px; width:91px; height:17px; ">상하반기  :</caption>
				<caption id="caption60" class="search_name" style="left:690px; top:20px; width:107px; height:17px; ">First병원 :</caption>
				<caption id="caption61" class="search_name" style="left:885px; top:20px; width:109px; height:17px; ">Second병원 :</caption>
				<select1 id="cmb_firstinstcd" ref="/root/send/condition/firstinstcd" class="combo_s_essential" appearance="minimal" style="left:779px; top:19px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<select1 id="cmb_secondinstcd" ref="/root/send/condition/secondinstcd" class="combo_s_essential" appearance="minimal" style="left:994px; top:19px; width:100px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<input id="ipt_yy" ref="/root/send/condition/yy" class="input_default" inputtype="date" format="yyyy" style="left:80px; top:19px; width:75px; height:19px; ">
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							btn_search.dispatch("DOMActivate");				
						]]>
					</script>
				</input>
				<select1 id="cmb_posinstcd" ref="/root/send/condition/posinstcd" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:1105px; top:10px; width:55px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</select1>
				<caption id="caption3" class="search_name" style="left:535px; top:21px; width:65px; height:17px; ">이 름 :</caption>
				<caption id="caption4" class="search_name" style="left:356px; top:21px; width:106px; height:17px; ">사원번호 :</caption>
				<line id="line3" class="line_4" style="x1:1110px; y1:18px; x2:1110px; y2:40px; border-color:#ffe4bb; border-left-style:solid; "/>
				<select1 id="cmb_supinfqurtyyflag" ref="/root/send/condition/supinfqurtyyflag" class="combo_s_essential" navindex="2" appearance="minimal" style="left:256px; top:19px; width:90px; height:19px; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
					<script type="javascript" ev:event="xforms-value-changed">
						<![CDATA[
							btn_search.dispatch("DOMActivate");				
						]]>
					</script>
				</select1>
				<input id="input3" ref="/root/send/condition/name" class="input_default" imemode="hangul" style="left:600px; top:19px; width:80px; height:19px; "/>
				<input id="input4" ref="/root/send/condition/emplno" class="input_default" style="left:445px; top:19px; width:80px; height:19px; "/>
				<button id="btn_search" class="btn1_letter2" style="left:1125px; top:17px; width:56px; height:22px; ">
					<caption>조회</caption>
					<script type="javascript" ev:event="DOMActivate">
						<![CDATA[
							//필수 입력 항목 체크(공통 ftHelper.js)
							if ( !isRequiredControls("ipt_yy", "cmb_supinfqurtyyflag") ) {
								return false;
							}
							misfMsterDetailRetrieve();
							
							 /* 사원별 rowcolor 표시*/
							     var iYear = 1;
								var sColor = "#ffff99";
					
									icnt = 0;
								for(var i = grd_intntrnghospplanlist.fixedRows ; i < grd_intntrnghospplanlist.rows ; i++ )
								{
										
								     var preststatcd=grd_intntrnghospplanlist.valueMatrix(i, grd_intntrnghospplanlist.colRef("preststatcd"));
								     
									
							      	 	
									
									if(icnt % iYear == 0)
									{
										if(sColor == "#ffff99")
										{
											if(preststatcd=='2'){
												sColor = "#ff9900";	
											}else{
												sColor = "#FFFFFF";
											}
										}
										else
										{    if(preststatcd=='2'){
												sColor = "#ff9900";	
											}else{
												sColor = "#ffff99";
											}
											
										}
									}
	
								grd_intntrnghospplanlist.rowStyle(i, "all", "background-color") = sColor;
							
								icnt ++;
							}
							
							fShowPrcpMsg();
							
							
						]]>
					</script>
				</button>
				<input id="ipt_apprtcdrflag" ref="/root/send/condition/apprtcdrflag" visibility="hidden" style="left:1165px; top:10px; width:25px; height:19px; "/>
			</group>
			<line id="line19" class="line_1" style="x1:0px; y1:86px; x2:1195px; y2:86px; "/>
			<button id="button16" class="btn5_letter8" style="left:1015px; top:65px; width:108px; height:19px; ">
				<caption>수련과ExcelLoad</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[

					var fileName = window.fileDialog("open", "", false);
					grd_intntrnghospplanlist.loadExcel(fileName);
					var header1=model.getValue("/root/main/intntrnghospplanlist[1]/name");
					if(header1=="이름"){
					grd_intntrnghospplanlist.deleteRow(1);
					grd_intntrnghospplanlist.clearStatus();
					}
					model.setValue("/root/hidden/excelloadyn","Y");
					model.refresh();
					]]>
				</script>
			</button>
			<button id="button1" class="btn2_letter4" style="left:1125px; top:65px; width:64px; height:19px; ">
				<caption>엑셀저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var fileName = window.fileDialog("save", ",", false, "excel", "xls", "Excel Files(*.xls)|*.xls|All Files (*.*)|*.*");
			
						if (fileName != "") {				
							grd_intntrnghospplanlist.saveExcel(fileName, "sheetname:sheet1;colhiddenextend:true;rowhiddenextend:false;exportfalsecols:0,0;col_1:value;");		
						}		
					]]>
				</script>
			</button>
			<button id="btn_grddel" class="btn2_letter3" visibility="hidden" style="left:960px; top:65px; width:53px; height:19px; ">
				<caption>행삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						misfGridIUD(grd_intntrnghospplanlist,"D");
						model.refresh();		
					]]>
				</script>
			</button>
			<button id="btn_grdadd" class="btn2_letter3" visibility="hidden" style="left:905px; top:65px; width:53px; height:19px; ">
				<caption>행추가</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					if ( !isRequiredControls("ipt_yy", "cmb_supinfqurtyyflag") ) {
								return false;
							}
						misfGridIUD(grd_intntrnghospplanlist, "A");	
						var cur_row=grd_intntrnghospplanlist.row;
						grd_intntrnghospplanlist.valueMatrix(cur_row, grd_intntrnghospplanlist.colRef("dpdatayn")) ="N";
						
					]]>
				</script>
			</button>
			<select1 id="combo1" visibility="hidden" appearance="minimal" style="left:790px; top:65px; width:100px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<button id="btn_prcphosp" class="btn2_letter10" disabled="true" style="left:481px; top:65px; width:130px; height:19px; ">
				<caption>미배정병원 배정작업</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var node = instance1.selectSingleNode("/root/main/intntrnghospplanlist[firstinstcd='' or secondinstcd='']");
						var srcnode;
						var path;
						var set_instcd;
						var dest_inst;
						var dest_colnm;

						if (node != null)
						{
							var rownum = node.getXPathString("rownum");
							var firstinstcd = node.getXPathString("firstinstcd");
							var secondinstcd = node.getXPathString("secondinstcd");
							var gndr = node.getXPathString("gndr");
							
							if (firstinstcd == "")
							{
								dest_inst = "firstinstcd";
								dest_colnm = "상반기";
								set_instcd = secondinstcd;
							}
							else
							{
								dest_inst = "secondinstcd";
								dest_colnm = "하반기";
								set_instcd = firstinstcd;
							}
								
							path = "/root/main/intntrnghospplanlist[";
							path += "(firstinstcd != '" + set_instcd + "' and secondinstcd != '" + set_instcd + "')";
							path += " and gndr= '"+gndr+"'"
							path += " and rownum <= '"+rownum+"'"
							path += "]";
							
							var max_rownum = model.getXPathValue("max("+ path +"/rownum)");
							
							var colidx = grd_intntrnghospplanlist.colRef("rownum");
							var dest_rowidx;
							for (var i = grd_intntrnghospplanlist.rows; i >= 0; i--)
							{
								if (rownum == grd_intntrnghospplanlist.valueMatrix(i, colidx))
								{
									dest_rowidx = i;
									break;
								}
							}
							var src_rowidx;
							for (var i = grd_intntrnghospplanlist.rows; i >= 0; i--)
							{
								if (max_rownum == grd_intntrnghospplanlist.valueMatrix(i, colidx))
								{
									src_rowidx = i;
									break;
								}
							}
							
							var colidx_name = grd_intntrnghospplanlist.colRef("name");
							var colidxinst = grd_intntrnghospplanlist.colRef( dest_inst );
							var get_instcd = grd_intntrnghospplanlist.valueMatrix(src_rowidx, colidxinst);
							
							var dest_msg = "[대상] " + rownum + ". ";
							dest_msg += grd_intntrnghospplanlist.valueMatrix(dest_rowidx, colidx_name);
							dest_msg += " : ";
							dest_msg += get_instcd;
							
							var src_msg = "[소스] " + max_rownum + ". ";
							src_msg += grd_intntrnghospplanlist.valueMatrix(src_rowidx, colidx_name);
							src_msg += " : ";
							src_msg += set_instcd;
							
							var msg = "아래와 같이 " + dest_colnm + " 배정병원을 입력하려고 합니다.";
							msg += "\n\n";
							
							msg += dest_msg + "\n\n";
							msg += src_msg + "\n\n";
							
							model.setValue("/root/temp/prcpmsg", msg);
							if ( messageBox(msg, "Q004", "") != 6) {
								return;
							}
							else
							{
								grd_intntrnghospplanlist.valueMatrix(dest_rowidx, colidxinst) = get_instcd;
								grd_intntrnghospplanlist.addStatus(dest_rowidx, "update");
								
								grd_intntrnghospplanlist.valueMatrix(src_rowidx, colidxinst) = set_instcd;
								grd_intntrnghospplanlist.addStatus(src_rowidx, "update");
								
								grd_intntrnghospplanlist.refresh();
								
								fShowPrcpMsg();
							}
							
							
						}
					]]>
				</script>
			</button>
			<button id="button2" class="btn2_letter8" style="left:615px; top:65px; width:130px; height:19px; ">
				<caption>이전작업 메세지</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var msg = model.getValue("/root/temp/prcpmsg");
						
						if (msg == "")
							msg = "이전작업 메세지가 없습니다.";
							
							
						messageBox(msg, "I", "");
					]]>
				</script>
			</button>
			<button id="button3" class="btn5_letter10" navindex="99" style="left:347px; top:65px; width:130px; height:19px; ">
				<caption>인턴치과수련계획생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var retMes =  messageBox("인턴 치과 수련계획을 생성 하시겠습니까?", "Q999");
					if ( retMes != 6) {
						return;
					}
					 					
					if ( !isRequiredControls("ipt_yy", "cmb_supinfqurtyyflag") ) {
						return false;
					}													
					submit("TXRTS00102");
					var tretdouyn = model.getValue("/root/temp/tretdouyn");
					var tretmsg = model.getValue("/root/temp/tretmsg");
					var tretcnt = model.getValue("/root/temp/tretcnt");
					if(	tretdouyn =='Y'){
						messageBox(tretmsg,"E006");
                    }else{
						if(tretcnt=='0'){
							var msg="I004";
						}else{
							var msg="I001";
                        }
						messageBox(tretmsg,msg);
                    } 
					]]>
				</script>
			</button>
			<button id="button4" class="btn5_letter10" navindex="99" style="left:212px; top:65px; width:130px; height:19px; ">
				<caption>인턴의과수련계획생성</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var retMes =  messageBox("인턴 의과 수련계획을 생성 하시겠습니까?", "Q999");
					if ( retMes != 6) {
						return;					}
					 					
					if ( !isRequiredControls("ipt_yy", "cmb_supinfqurtyyflag") ) {
						return false;
					}													
					submit("TXRTS00103");
					btn_search.dispatch("DOMActivate");	
					]]>
				</script>
			</button>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12px; width:1195px; height:27px; ">
			<line id="line11" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="btn_save" class="btn4_letter2" style="left:1124px; top:3px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var retMes =  messageBox("저장 하시겠습니까?", "Q999");
					if ( retMes != 6) {
						return;
					}
															
					 if(!checkRequiredColumn("grd_intntrnghospplanlist"))return;
					
					var excelloadyn=model.getValue("/root/hidden/excelloadyn");
					
					 for(var i=grd_intntrnghospplanlist.fixedRows; i<grd_intntrnghospplanlist.rows;i++){
					 	var dpdatayn=grd_intntrnghospplanlist.valueMatrix(i,grd_intntrnghospplanlist.colRef("dpdatayn"));
					 	if(dpdatayn =='N'){
					 		grd_intntrnghospplanlist.addStatus(i,"insert");
					 	}else{
					 		if(excelloadyn == 'Y'){
					 			grd_intntrnghospplanlist.addStatus(i,"update");
					 		}
					 	}
					 }
					misfSave("TXRTS00101");	
					model.setValue("/root/hidden/excelloadyn","N");	
					btn_search.dispatch("DOMActivate");		
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>