YNU_JEUS/app_home/himed/webapps/mis/insurancemngtweb/xrw/SMRPA01300_국민연금보험.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>
						<disadiffpay>
							<disadiffpayinst>
								<instnm/>
								<cnt/>
								<mancnt/>
								<instcd/>
								<notiym/>
							</disadiffpayinst>
						</disadiffpay>
						<disadiffpayform>
							<insurancenstilist>
								<emplno/>
								<notiym/>
								<seqno/>
								<rrgstno/>
								<notigbn/>
								<instcd/>
								<grde/>
								<pensinsuamt/>
								<updtresn/>
								<updtdd/>
								<monthno/>
							</insurancenstilist>
						</disadiffpayform>
						<list01>
							<gridsummary/>
						</list01>
					</main>
					<send>
						<attach>
							<file/>
							<notiym/>
						</attach>
						<title/>
						<savelist>
							<insurancenstilist/>
						</savelist>
						<searchlist>
							<notiym/>
							<rrgstno1/>
							<rrgstno2/>
							<emplnm/>
							<instcd/>
							<workgbn/>
						</searchlist>
						<disadiffpay>
							<instcd/>
							<notiym/>
							<rrgstno1/>
							<rrgstno2/>
							<emplnm/>
						</disadiffpay>
					</send>
					<temp>
						<cnt/>
						<doduyn/>
						<medicnfmyn/>
					</temp>
					<init>
						<selectValue>1</selectValue>
					</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="../../../mis/miscommonweb/js/MIS.js"/>
			<script type="javascript" src="../../../mis/insurancemngtweb/js/RPA001.js"/>
			<script type="javascript" ev:event="xforms-ready">
				<![CDATA[
					fInitialize();
					misfGridInit(grd_disadiffpayinst);
					misfGridInit(grd_insurancenstilist);
					misfGridInit(grd_attach);
					misfMsterDetailSet(grd_disadiffpayinst, null, "TRRPA01301" ,"N"); 
					misfMsterDetailSet(grd_insurancenstilist, grd_disadiffpayinst, "TRRPA01303" ,"Y"); 
					rpaComboInstBase(cmb_instcd,getUserInfo("dutplceinstcd"));
					misfComboCopyItemSet(cmb_instcd, "", grd_insurancenstilist, "instcd");
				     	var instcd = getUserInfo("dutplceinstcd");
				       	cmb_instcd.value=instcd;
					//화면 권한 설정
					btn_save.disabled = !(checkAuth("X"));
					btn_save.disabled=true;
					btn_search.dispatch("DOMActivate");
				]]>
			</script>
			<submission id="TRRPA01301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/main/disadiffpay"/>
			<submission id="TXRPA01301" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/savelist" resultref="/root/temp"/>
			<submission id="TRRPA01302" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/temp"/>
			<submission id="TXRPA01302" mediatype="multipart/form-data" method="form-data-post" ref="/root/send" resultref="/root/main/list01"/>
			<submission id="TXRPA01303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/temp"/>
			<submission id="TRRPA01303" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/disadiffpay" resultref="/root/main/disadiffpayform"/>
			<submission id="TRRPA03702" mediatype="application/x-www-form-urlencoded" method="post" ref="/root/send/searchlist" resultref="/root/temp"/>
		</model>
		<script type="javascript">
			<![CDATA[
				// 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다.
				function fInitialize() {
					model.removeNodeset("/root/main/disadiffpay/disadiffpayinst");
					model.removeNodeset("/root/main/disadiffpayform/insurancenstilist");
					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, "excel", "xls", "Excel Files(*.xls)|*.xls|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=1;
						while (!ts.AtEndOfStream) { 
							i++;
							strData = ts.ReadLine();
							if(i==3){
							if(!fIsValidate(strData))return;
							}
							if(i == 3)break;
						} //end of while
						var arr_data = strData.split(",");
						var notiym = arr_data[0];
						model.setValue("/root/send/searchlist/notiym", notiym);*/
						//submit("TRRPA01302");
						if(grd_disadiffpayinst.row>1){
							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("TXRPA01302");	
							closeLoadingBar();
							btn_search.dispatch("DOMActivate");
	  				   }
	  				}
				 }
				//=============================================================================================
				//  전환할 Line의 유효성 검사
				//=============================================================================================
				function fIsValidate(strData) {
				/*	var arr_data = strData.split(",");
					if(arr_data.length == 23) {
						//작업 년월을 비교한다.
						if(arr_data[0] != model.getValue("/root/send/searchlist/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; ">국민연금 보험 파일 Upload</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="cap_notiym" 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;	
					model.makeValue("/root/send/attach/notiym",ipt_notiym.value);
					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:0px; y1:69px; x2:280px; y2:69px; "/>
			<datagrid id="grd_insurancenstilist" nodeset="/root/main/disadiffpayform/insurancenstilist" caption="고지구분^고지년월^일련번호^기관^성명^주민등록번호^등급^연금보험료^변동사유^변동일자^월수" colwidth="92, 62, 55, 140, 74, 104, 48, 78, 77, 76, 59, 100" dataheight="25" ellipsis="true" extendlastcol="scroll" mergecellsfixedrows="bycolrec" rowheader="update" rowheight="25" rowsep="|" tooltip="true" style="left:285px; top:74px; width:910px; height:660px; text-align:center; ">
				<col ref="notigbnnm"/>
				<col ref="notiym" format="yyyy-mm"/>
				<col ref="seqno"/>
				<col id="instcd" ref="instcd" type="combo" style="text-align:left; ">
					<choices>
						<itemset>
							<label/>
							<value/>
						</itemset>
					</choices>
				</col>
				<col ref="emplnm" style="text-align:center; "/>
				<col ref="rrgstno" format="999999-9999999" style="text-align:center; "/>
				<col ref="grde" style="text-align:center; "/>
				<col ref="pensinsuamt" format="#,###" style="text-align:right; "/>
				<col ref="updtresn" style="text-align:center; "/>
				<col ref="updtdd" format="yyyy-mm-dd" style="text-align:center; "/>
				<col ref="monthno" format="yyyy-mm" style="text-align:center; "/>
				<col ref="notigbn" visibility="hidden"/>
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
						  var cur_row = grd_insurancenstilist.row;
						if(grd_insurancenstilist.col == 4){
							for(i=1; i < grd_insurancenstilist.rows ; i++){
								var rrgstno= grd_insurancenstilist.valueMatrix(grd_insurancenstilist.row,6);
								var instcd= grd_insurancenstilist.valueMatrix(grd_insurancenstilist.row,4);
								var rrgstno_ch= model.getValue("/root/main/disadiffpayform/insurancenstilist["+i+"]/rrgstno");
								if(rrgstno == rrgstno_ch){
									grd_insurancenstilist.valueMatrix(i, grd_insurancenstilist.colRef("instcd")) =instcd;	
									grd_insurancenstilist.addStatus(i,"update");
								}
							}	
						}	
					]]>
				</script>
				<script type="javascript" ev:event="onaftersort">
					<![CDATA[
						grd_insurancenstilist.gridToInstance();		
					]]>
				</script>
			</datagrid>
			<input id="ipt_notiym" ref="/root/send/searchlist/notiym" class="input_s_essential" inputtype="date" format="yyyy-mm" style="left:100; top:18; width:100px; height:19px; ">
				<script type="javascript" ev:event="xforms-value-changed">
					<![CDATA[
							btn_search.dispatch("DOMActivate");	
					]]>
				</script>
			</input>
			<caption id="caption9" class="tit_2" style="left:5px; top:54px; width:100px; height:13px; ">기관별건수</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:1054px; 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:224px; top:19; width:99px; height:17px; ">주민번호 :</caption>
			<caption id="caption309" style="left:415px; top:21px; width:16px; height:17px; font-weight:bold; text-align:center; vertical-align:bottom; ">~</caption>
			<input id="ipt_chldrnresdnrgst1" ref="/root/send/searchlist/rrgstno1" class="input_default" maxlength="6" style="left:310px; top:18; width:100px; height:19px; ">
				<script type="javascript" ev:event="onkeypress">
					<![CDATA[
							inputEnterKey("btn_search", "DOMActivate");	
					]]>
				</script>
			</input>
			<input id="ipt_chldrnresdnrgst2" ref="/root/send/searchlist/rrgstno2" class="input_default" maxlength="8" style="left:435px; top:18; 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:561px; top:19; width:85px; height:17px; ">성     명 :</caption>
			<input id="ipt_emplnm" ref="/root/send/searchlist/emplnm" imemode="hangul" style="left:645px; top:18; width:105px; height:19px; "/>
			<select1 id="cmb_instcd" ref="/root/send/searchlist/instcd" class="combo_s_essential" visibility="hidden" appearance="minimal" style="left:753px; top:18; width:144px; 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:1020px; 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:670px; top:535px; width:505px; height:69px; ">
				<col ref="file" style="text-align:center; "/>
				<col ref="filesize" format="#,###" style="text-align:right; "/>
			</datagrid>
			<datagrid id="grd_disadiffpayinst" nodeset="/root/main/disadiffpay/disadiffpayinst" caption="기관^총건수^인원수^기관코드^작업월^caption1^caption2^caption3" colsep="^" colwidth="137, 62, 58, 75, 21" mergecellsfixedrows="bycolrec" rowheader="seq" rowsep="|" style="left:0px; top:74px; width:280px; height:660px; ">
				<col ref="instnm"/>
				<col ref="cnt" format="#,###" style="text-align:right; "/>
				<col ref="mancnt" format="#,###" style="text-align:right; "/>
				<col ref="instcd" visibility="hidden"/>
				<col ref="notiym" visibility="hidden"/>
				<script type="javascript" ev:event="onrowchanged">
					<![CDATA[
					grd_disadiffpayinst.subtotal("clear", 0, 0);
					  grd_disadiffpayinst.subtotalPosition = "below";
					  grd_disadiffpayinst.multiTotals = true;
					  grd_disadiffpayinst.subtotal("sum", -1, 3, "format:#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 1, "총합계", false);			
					  grd_disadiffpayinst.subtotal("sum", -1, 2, "format:#,###; roundmode:round; roundpostion:2", "background-color:#7CBBDD; color:#ffffff; font-weight:bold; ", 1, "총합계", false);
					var rrgstno1=model.getValue("/root/send/searchlist/rrgstno1");
					var rrgstno2=model.getValue("/root/send/searchlist/rrgstno2");
					var emplnm=model.getValue("/root/send/searchlist/emplnm");
					model.makeValue("/root/main/disadiffpay/disadiffpayinst/rrgstno1",rrgstno1);
					model.makeValue("/root/main/disadiffpay/disadiffpayinst/rrgstno2",rrgstno2);
					model.makeValue("/root/main/disadiffpay/disadiffpayinst/emplnm",emplnm);
					var cur_row=grd_disadiffpayinst.rows-1;
					if (grd_disadiffpayinst.row != cur_row){
						var  instcd=grd_disadiffpayinst.valueMatrix(grd_disadiffpayinst.row,4);
						if(instcd ==""){
							btn_save.disabled=false;
						}else{
							btn_save.disabled=true;
						}
						misfMsterDetailRetrieve(); 
					}else{
					 	btn_save.disabled=true;
					}
						 
				     ]]>
				</script>
			</datagrid>
			<line id="line1" class="line_1" style="x1:285px; y1:69px; x2:1195px; y2:69px; "/>
			<caption id="caption1" class="tit_2" style="left:290px; top:54px; width:131px; height:13px; ">국민연금 보험 내역</caption>
			<button id="btn_exceldetail" class="btn2_letter4" style="left:1131px; 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_insurancenstilist.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
			<button id="button1" class="btn2_letter4" style="left:216px; 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_disadiffpayinst.saveExcel(fileName, "SheetName", true, true, "", "");
						}		
					]]>
				</script>
			</button>
		</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:1139px; top:3; width:56px; height:22px; ">
				<caption>저장</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						
					var updtdata = getGridUpdateData(grd_insurancenstilist);
						if (updtdata == "" ) {
							messageBox("변경된 데이터가","I004");
							return;
						}
						var retMes =  messageBox("저장 하시겠습니까?", "Q999");
						if ( retMes != 6) {
							return;
						}
					model.setValue("/root/send/searchlist/workgbn","4");
						submit("TRRPA03702");
						var medicnfmyn=model.getValue("/root/temp/medicnfmyn");
						if(medicnfmyn =='Y'){
							messageBox("의료원확정이 완료된 자료는 수정 ","E001");
							return;
						}	
						misfSave("TXRPA01301");
					]]>
				</script>
			</button>
			<button id="btn_init" class="btn4_letter3" style="left:1069px; top:3; width:68px; height:22px; ">
				<caption>초기화</caption>
				<script type="javascript" ev:event="DOMActivate">
					<![CDATA[
						var updtdata = getGridUpdateData(grd_insurancenstilist);

					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:987px; top:3px; 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;
						}
						model.setValue("/root/send/searchlist/workgbn","4");
						submit("TRRPA03702");
						var medicnfmyn=model.getValue("/root/temp/medicnfmyn");
						if(medicnfmyn =='Y'){
							messageBox("의료원확정이 완료된 자료는 삭제 ","E001");
							return;
						}	
						 submit("TXRPA01303");
						  ipt_doduyn.value="";
						 misfGridInit(grd_disadiffpayinst);
						misfGridInit(grd_insurancenstilist);
					]]>
				</script>
			</button>
		</group>
	</xhtml:body>
</xhtml:html>