YNU_JEUS/app_home/himed/webapps/mis/insurancemngtweb/xrw/SMRPA03300_교원공제.xrw

<?xml version="1.0" encoding="EUC-KR"?>
<?xml-stylesheet type="text/css" href="../../../com/commonweb/css/common.css" ?>
<xhtml:html xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.w3.org/2002/01/xforms" xmlns:ev="http://www.w3.org/2001/xml-events">
	<xhtml:head>
		<xhtml:title>교원공제</xhtml:title>
		<model id="model1">
			<instance id="instance1">
				<root xmlns="">
					<main>
						<mastteach>
							<teachloadinst>
								<instnm/>
								<cnt/>
								<instcd/>
								<notiym/>
								<rrgstno1/>
								<rrgstno2/>
								<emplnm/>
								<erroryn/>
							</teachloadinst>
						</mastteach>
						<teachloadlist>
							<notiym/>
							<emplno/>
							<rrgstno/>
							<seqno/>
							<name/>
							<instcd/>
							<tchrdeduno/>
							<tchrloadamt/>
							<gbn1/>
							<gbn2/>
						</teachloadlist>
						<list01>
							<gridsummary/>
						</list01>
						<list02>
							<return>
								<jryn/>
							</return>
						</list02>
					</main>
					<send>
						<attach>
							<file/>
						</attach>
						<title/>
						<jobkind/>
						<delflag/>
						<jrflag/>
						<savelist>
							<teachloadlist/>
						</savelist>
						<searchlist>
							<notiym/>
							<rrgstno1/>
							<rrgstno2/>
							<emplnm/>
							<instcd/>
							<erroryn/>
						</searchlist>
						<payappsend>
							<instcd/>
							<payym/>
							<payitemcd/>
						</payappsend>
						<mastteach>
							<instcd/>
							<notiym/>
							<rrgstno1/>
							<rrgstno2/>
							<emplnm/>
							<erroryn/>
						</mastteach>
					</send>
					<temp>
						<cnt/>
						<doduyn/>
						<payappyn/>
						<hidden/>
					</temp>
					<init>
						<checkbox1>
							<label>오류자여부</label>
							<value>Y</value>
						</checkbox1>
					</init>
				</root>
			</instance>
			<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/dateHelper.js"/>
			<script type="javascript" src="../../../com/commonweb/js/stringHelper.js"/>
			<script type="javascript" src="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/pubwelfmngtweb/js/RPS001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
					misfGridInit(grd_teachloadlist);
					misfGridInit(grd_teachloadinst);
					misfGridInit(grd_attach);
					
					misfMsterDetailSet(grd_teachloadinst, null, "TRRPA03303" ,"N"); 
					misfMsterDetailSet(grd_teachloadlist, grd_teachloadinst, "TRRPA03301" ,"Y"); 
					//misfComboComCdList('Z0007', cmb_instcd,"Y");
					misfComboInstCdListMulti("cmb_instcd",getCurrentDate(),"","Y"); 
					misfComboCopyItemSet(cmb_instcd, "", grd_teachloadlist, "instcd");
					misfComboCopyItemSet(cmb_instcd, "", grd_teachloadlist, "payinst");
					
				     	var instcd = getUserInfo("dutplceinstcd");
				       	cmb_instcd.value=instcd;
					//화면 권한 설정
					btn_save.disabled = !(checkAuth("X"));
				//	btn_save.disabled=true;
				]]>
			</script>
			<submission id="TRRPA03301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/mastteach" resultref="/root/main/teachloadlist"/>
			<submission id="TXRPA03301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/savelist" resultref="/root/temp"/>
			<submission id="TRRPA03302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/temp"/>
			<submission id="TXRPA03302" mediatype="multipart/form-data" method="form-data-post" ref="/root/send" resultref="/root/main/list01"/>
			<submission id="TXRPA03303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/temp"/>
			<submission id="TXRWZ00303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/payappsend" resultref="/root/temp/hidden"/>
			<submission id="TRRPA03303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/main/mastteach"/>
		</model>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
					model.removeNodeset("/root/main/teachloadlist");
					model.removeNodeset("/root/main/list/filelist");
					model.resetInstanceNode("/root/send");
					model.refresh();
					var curDate = getCurrentDate().toDate();
					model.setValue("/root/send/searchlist/notiym", curDate.getDateFormat('YYYYMM'));
				}
									/** 왼쪽 공백 제거 */
					function  funcLtrim( str ) {
					
					    var src = new String( str );
					    var tmp = new String();
					    var i,firstnum, len = src.length;
					
					    for(i = 0;i < len ;i++) {
					        tmp = src.substring(i,i+1);
					        if (tmp != ' ' ) {
					            firstnum = i;
					            break;
					        }
					    }
					    tmp = src.substring(firstnum);
					    return tmp;
					
					}

 				var fso=new ActiveXObject("Scripting.FileSystemObject");
				 function fCsvUpload() {
					 	
  				   var maxsize  = upload1.attribute("filesize");
						//var files = window.fileDialog("open", "|", true);
						//var filename = window.fileDialog("open", "|", true,dirPath + fileName, "txt", "All File(*.*)|*.*");
						var filename = window.fileDialog("open", ",", false, "", "gng", "Text Files(*.gng)|*.gng|All Files (*.*)|*.*");
						var filelist = filename.split("|");
							model.removeNodeset("/root/main/list/filelist");
							model.removeNodeset("/root/send/attach");
						//타이틀을 획득한다.
						var s = new String(filelist[filelist.length-1]);
						var ss = s.split("\\");
	  				   if(filename !=""){
					  	 if (!fso.FileExists(filename)) {
				            		fso.CreateTextFile(filename,true);
				        	}
					 	var ts=fso.OpenTextFile(filename,1);
						var i=0;
						while (!ts.AtEndOfStream) { 
							i++;
							strData = ts.ReadLine();
							ts.Close();
							if(!fIsValidate(strData))return;
							if(i == 1)break;
						} //end of while
						//var notiym = strData.substring(3, 6);
						//model.setValue("/root/send/searchlist/notiym", notiym);
						submit("TRRPA03302");
						var doduyn = ipt_doduyn.value;
						if(doduyn =='Y'){
							messageBox("해당월의 자료가 ","E006");
							return;
						}else{
						//작업 전 row를 추가 >파일명 유/무에 따른 분기>
						for(var i = 0 ; i < filelist.length ; i++ ){
							grd_attach.addRow(false);
	
							if(filelist[i] == ""){
								//alert(grd_attach.rows - 1);
								grd_attach.removeRow(false);
								grd_attach.refresh();
							}
							else{
								grd_attach.valueMatrix(grd_attach.rows - 1, 0) = filelist[i];
								//파일크기('tfHelper.checkFileSize' 참조)
								var fileCnt = upload1.getFileCount();
								var lastIndex = fileCnt - 1;
								var fileSize = upload1.getFileSize(lastIndex);
								grd_attach.textmatrix(grd_attach.rows - 1,1) = fileSize;
	
								if (!checkFileSize(upload1)){
									grd_attach.removeItem();
									messageBox("파일 크기가 최대치("+maxsize+"Byte)를", "E003");	
									return;						
								}
							}
						}
						openLoadingBar("파일업로드 작업중입니다...              ") ;	
						submit("TXRPA03302");	
						closeLoadingBar();
						if (model.getValue(gvErrorMsgPath + "/type") != "error"){
							messageBox("작업이","I002");
							btn_search.dispatch("DOMActivate");
						} 
						}
	  				   }
				 }

				//=============================================================================================
				//  전환할 Line의 유효성 검사
				//=============================================================================================
				function fIsValidate(strData) {
					if(lvGetByteSize(strData) == 62) { //레코드길이 100 bytes
					var notiymStr=model.getValue("/root/send/searchlist/notiym");
					var notiym =notiymStr.substring(2,6);
						//작업 년월을 비교한다.
						if(strData.substring(3, 7) != notiym) { 
							messageBox("선택한 파일의 년월과 입력한 년월 값이 ", "E004");
							return false;
						}
						
						return true;
					} else {
						messageBox("파일형태가", "E004");
						return false;
					}
					return true;
				}

				/**
				 * @group  : lvString 확장
				 * @ver    : 2004.07.29 (KUHDEV-0002)
				 * @by     : LeeHJ.
				 * @---------------------------------------------------
				 * @type   : function
				 * @access : public
				 * @desc   : 파라미터 값의 Byte 크기를 리턴
				 * @param  : N/A
				 * @return : 파라미터 값의 Byte 크기
				 * @---------------------------------------------------
				 */
				function lvGetByteSize(strData)
				{
				  var tcount = 0;

				  var tmpStr = new String(strData);
				  var temp = tmpStr.length;
				
				  var onechar;
				  for ( k=0; k<temp; k++ )
				  {
				    onechar = tmpStr.charAt(k);
				    if (escape(onechar).length > 4)
				    {
				      tcount += 2;
				    }
				    else
				    {
				      tcount += 1;
				    }
				  }
				
				  return tcount;

				}
				
 			]]>
		</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; ">
			<shape id="roundrect1" appearance="roundrect" ellipsewidth="10" ellipseheight="10" style="left:0px; top:10px; width:1195px; height:35px; background-color:#fffbf2; border-color:#ffd799; "/>
			<caption id="caption2" class="search_name" style="left:15px; top:19; width:86px; height:17px; ">고지년월 :</caption>
			<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[
					if(!isRequiredControls("ipt_notiym"))return;	
					misfMsterDetailRetrieve(); 
					]]>
				</script>
			</button>
			<line id="line13" class="line_4" style="x1:1110px; y1:17px; x2:1110px; y2:39px; "/>
			<line id="line207" class="line_1" style="x1:300px; y1:70px; x2:1195px; y2:69px; "/>
			<datagrid id="grd_teachloadlist" nodeset="/root/main/teachloadlist" caption="고지년월^사원번호^주민등록번호^일련번호^성명^기관코드^급여기관^교원공제번호^교원공제금액^급여반영^구분1^구분2" colsep="^" colwidth="77, 75, 100, 74, 89, 137, 133, 82, 89, 65, 77, 100" dataheight="25" explorerbar="sortshow" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" style="left:300px; top:74px; width:895px; height:660px; ">
				<col ref="notiym" format="yyyy-mm" style="text-align:center; "/>
				<col ref="emplno" type="input" style="text-align:center; "/>
				<col ref="rrgstno" format="999999-9999999" style="text-align:center; "/>
				<col ref="seqno" visibility="hidden" style="text-align:center; "/>
				<col ref="name" style="text-align:center; "/>
				<col id="instcd" ref="instcd" type="combo" style="text-align:center; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col id="payinst" ref="payinst" type="combo" style="text-align:center; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="tchrdeduno" style="text-align:center; "/>
				<col ref="tchrloadamt" format="#,###" style="text-align:right; "/>
				<col ref="payappyn" style="text-align:center; "/>
				<col ref="gbn1" visibility="hidden"/>
				<col ref="gbn2" visibility="hidden"/>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						  var cur_row = grd_teachloadlist.row;
						//신청일자 및 시간 유효성 체크
						if(grd_teachloadlist.col == 4){
							for(i=1; i < grd_teachloadlist.rows ; i++){
								var rrgstno= grd_teachloadlist.valueMatrix(grd_teachloadlist.row,5);
								var instcd= grd_teachloadlist.valueMatrix(grd_teachloadlist.row,4);
								var rrgstno_ch= model.getValue("/root/main/disadiffpayform/penlentlist["+i+"]/rrgstno");
								if(rrgstno == rrgstno_ch){
									grd_teachloadlist.valueMatrix(i, grd_teachloadlist.colRef("instcd")) =instcd;	
									grd_teachloadlist.addStatus(i,"update");
								}
							}	
						}	
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_teachloadlist.gridToInstance();		
					]]>
				</script>
			</datagrid>
			<input id="ipt_notiym" ref="/root/send/searchlist/notiym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:100px; top:18; width:100px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[	
						var instcd = cmb_instcd.value;
						if( getStringLength(ipt_notiym.value) == "6" ) {
							model.removeNodeset(cmb_instcd.attribute("ref"));
							model.makeNode("/root/send/searchlist/instcd");
							misfComboInstCdListMulti("cmb_instcd",ipt_notiym.value,"","Y");
							cmb_instcd.value = instcd;
							model.refresh();
						}	
					]]>
				</script>
			</input>
			<caption id="caption9" class="tit_2" style="left:5px; top:54px; width:179px; height:14px; ">교원공제 기관별 건수</caption>
			<input id="ipt_cnt" ref="/root/temp/cnt" class="input_search" disabled="true" visibility="hidden" format="#,###" style="left:935px; top:48px; width:81px; height:19px; text-align:right; "/>
			<button id="btn_upload" class="btn2_letter5" style="left:1052px; top:48px; width:75px; height:19px; ">
				<caption>파일업로드</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						fCsvUpload();
						if(!isRequiredControls("ipt_notiym"))return;	
					]]>
				</script>
			</button>
			<caption id="caption4" class="search_name" style="left:219px; top:19px; width:99px; height:17px; ">주민번호 :</caption>
			<caption id="caption309" style="left:405px; top:19px; width:16px; height:17px; font-weight:bold; text-align:center; vertical-align:bottom; ">~</caption>
			<input id="ipt_rrgstno1" ref="/root/send/searchlist/rrgstno1" class="input_search" maxlength="6" style="left:304px; top:18px; width:100px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<input id="ipt_rrgstno2" ref="/root/send/searchlist/rrgstno2" class="input_search" maxlength="7" style="left:422px; top:18px; width:100px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<caption id="caption5" class="search_name" style="left:538px; top:19px; width:85px; height:17px; ">성     명 :</caption>
			<input id="ipt_emplnm" ref="/root/send/searchlist/emplnm" class="input_search" imemode="hangul" style="left:622px; top:18px; width:105px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<select1 id="cmb_instcd" ref="/root/send/searchlist/instcd" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:795px; top:45px; width:130px; height:19px; ">
				<choices>
					<itemset>
						<label/>
						<value/>
					</itemset>
				</choices>
			</select1>
			<input id="ipt_doduyn" ref="/root/temp/doduyn" visibility="hidden"/>
			<upload id="upload1" nodeset="/root/send/attach/file" ext="zip" filecount="5" filesize="41943040" validate="true" style="left:1025px; top:48px; width:25px; height:20px; "/>
			<datagrid id="grd_attach" nodeset="/root/send/attach" class="datagrid1" visibility="hidden" caption="File Name^File Size" colsep="^" colwidth="403, 93" dataheight="23" ellipsis="true" focuscolor="#b9e5fb" mergecellsfixedrows="bycolrec" rowheight="23" rowsep="|" style="left:675px; top:620px; width:505px; height:100px; ">
				<col ref="file" style="text-align:center; "/>
				<col ref="filesize" format="#,###" style="text-align:right; "/>
			</datagrid>
			<button id="btn_exceldetail" class="btn2_letter4" style="left:1130px; top:48px; 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_teachloadlist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
			<select id="ckb_erroryn" ref="/root/send/searchlist/erroryn" class="checkbox_search" overflow="visible" appearance="full" style="left:733px; top:19px; width:125px; height:15px; ">
				<choices>
					<itemset nodeset="/root/init/checkbox1">
						<label ref="label"/>
						<value ref="value"/>
					</itemset>
				</choices>
			</select>
			<caption id="caption3" class="tit_2" style="left:300px; top:55px; width:179px; height:13px; ">교원공제</caption>
			<datagrid id="grd_teachloadinst" nodeset="/root/main/mastteach/teachloadinst" caption="기관명^건수^금액^급여반영건수^급여반영금액^기관코드" colsep="^" colwidth="124, 54, 91, 100, 100, 100, 100" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:74px; width:295px; height:660px; ">
				<col ref="instnm"/>
				<col ref="cnt" format="#,###" style="text-align:center; "/>
				<col ref="tchrloadamt" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="payappcnt" format="#,###" style="text-align:center; "/>/&gt;
				<col ref="payappamt" format="#,###" style="text-align:right; vertical-align:middle; "/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="notiym" visibility="hidden"/>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
					var cur_row=grd_teachloadinst.row;
					var rrgstno1=ipt_rrgstno1.value;
					var rrgstno2=ipt_rrgstno2.value;
					var emplnm=ipt_emplnm.value;
					var erroryn=ckb_erroryn.value;
					model.makeValue("/root/main/mastteach/teachloadinst["+cur_row+"]/rrgstno1",rrgstno1);
					model.makeValue("/root/main/mastteach/teachloadinst["+cur_row+"]/rrgstno2",rrgstno2);
					model.makeValue("/root/main/mastteach/teachloadinst["+cur_row+"]/emplnm",emplnm);
					model.makeValue("/root/main/mastteach/teachloadinst["+cur_row+"]/erroryn",erroryn);
					
					misfMsterDetailRetrieve(); 
					]]>
				</script>
			</datagrid>
			<line id="line1" class="line_1" style="x1:0px; y1:70px; x2:295px; y2:69px; "/>
		</group>
		<group id="grp_btn" scroll="auto" style="left:0px; top:12; width:1195px; height:27px; ">
			<button id="btn_save" class="btn4_letter2" style="left:1135px; top:2px; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
					var updtdata = getGridUpdateData(grd_teachloadlist);
						if (updtdata == "" ) {
							messageBox("변경된 데이터가","I004");
							return;
						}
						misfSave("TXRPA03301");
					]]>
				</script>
			</button>
			<button id="btn_init" class="btn4_letter3" style="left:905px; top:2px; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_teachloadlist);

					if (updtdata != "") {
						var ret = messageBox("그리드에 작업 중인 내용이 있습니다. 초기화 작업을","Q003");
						if (ret != 6) { // not OK
							return;
						}
					}
					fInitialize();	
					]]>
				</script>
			</button>
			<line id="line9" class="line_6" style="x1:0; y1:25; x2:1195; y2:25; "/>
			<button id="button2" class="btn4_letter4" style="left:974px; top:2px; width:80px; height:22px; ">
				<caption>자료삭제</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						 if(!isRequiredControls("ipt_notiym"))return;	
						 var retMes =  messageBox("자료를 삭제하시겠습니까?", "Q999");
						if ( retMes != 6) {
							return;
						}
						 submit("TRRPA03302");
						 var doduyn= model.getValue("/root/temp/doduyn");
						var payappyn =model.getValue("/root/temp/payappyn");
						if(doduyn !='Y'){
							messageBox("삭제할 자료가 ","I004");
							return;
						}
						if(payappyn =='Y'){
							messageBox("급여이체가 완료된 자료는 삭제 할 수 ","I004");
							return;
						}	
						 submit("TXRPA03303");
						  ipt_doduyn.value="";
						misfGridInit(grd_teachloadlist);
					]]>
				</script>
			</button>
			<button id="button1" class="btn4_letter4" style="left:1054px; top:2px; width:80px; height:22px; ">
				<caption>급여이체</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						if(!isRequiredControls("ipt_notiym"))return;	
						var retMes =  messageBox("자료를 급여이체하시겠습니까?", "Q999");
						if ( retMes != 6) {
							return;
						}
						 submit("TRRPA03302");
						 var doduyn= model.getValue("/root/temp/doduyn");
						var payappyn =model.getValue("/root/temp/payappyn");
						
						if(doduyn !='Y'){
							messageBox("이체할 자료가 ","I004");
							return;
						}
						if(payappyn =='Y'){
							messageBox("급여이체 자료가 이미","I001");
							return;
						}	
						var instcd		= getUserInfo("dutplceinstcd");
						var payym	= model.getValue("/root/send/searchlist/notiym");
						var payitemcd	= "60050";
						 model.setValue("/root/send/payappsend/instcd",instcd);
						 model.setValue("/root/send/payappsend/payym",payym);
						 model.setValue("/root/send/payappsend/payitemcd",payitemcd);
						
					  	
					 	submit("TXRWZ00303");
						if (model.getValue(gvErrorMsgPath + "/type") != "error"){
							messageBox("급여이체작업이","I001");
							misfMsterDetailRetrieve(); 
						} 
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>