<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; "/>/> <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>

교원공제