/* --------------------------------------------------------------------- SMRSC03801_물품코드 Master Excel등록.xrw (SMRSC03801.xfm - JScript ) - Version : 1) : Ver.1.00.01 : Create By Francis Choi : 2015.05.02 ---------------------------------------------------------------------- */ // -------------------------------------------------- // 화면 open시와 초기화 버튼 클릭시 화면 초기화 기능을 수행한다. // -------------------------------------------------- function fInitialize() { model.resetInstanceNode("/root/send"); misfGridInit(grd_instexcellist); // misfGridInit(grd_excelmaplist); // misfGridInit(grd_rscdexcellist); // Spec 일괄 변경에서 사용하는 기존 명칭과 현 명칭을 비교하기 위한 구분으로 // premodel 등.. 기존 데이터를 갖고 있는 변수 설정이 반드시 필요하다. model.makeNode("/root/send/save/setautoins/setyn"); model.setValue("/root/send/save/setautoins/setyn","N"); // rszfUserGoodFlagList(cmb_goodflag,getUserInfo("userid")); rszfGoodFlagListByPgmGubn(cmb_goodflag,"2","N"); rszfUserInstList(cmb_instcd,getUserInfo("userid")); //기관코드 읽어오는 부분 넣기 var instcd = getUserInfo("dutplceinstcd"); var instnm = getUserInfo("dutplceinstnm"); if(instcd.length > 0)model.setValue(cmb_instcd.attribute("ref"), instcd); else { if(cmb_instcd.length> 0) cmb_instcd.selectedindex= 0; } //물품구분일 경우 첫번째 index 자동 설정 if(cmb_goodflag.length> 0) cmb_goodflag.selectedindex= 0; // 초기 저장구분 : 2 (미저장) rdo_saveyn.selectedindex = 2; // misfMsterDetailSet(grd_excelmaplist,null, "TRRSC00601" ,"Y"); /********************************** * GOODFLAG 물품구분 R0025 * ASETFLAG 자산구분 R0043 * PRODDRUGSETFLAG 제제약 SET 구분 R0068 * STOCMNGTFLAG 재고관리기준 R0069 * REQMTHD 청구방법 R0092 * REQPRID 청구주기 R0093 * PRODPLCE 제조국 R0035 * CONFLAG 계약구분 R0095 * CURNCYUNIT 화폐단위 R0047 * PURCFLAG 구매구분 R0111 * SETPLCEORDFLAG SET 발주구분 R0110 * PLCEORDBASE 발주기준 R0107 * PLCEORDQTYCRETFLAG 발주량생성구분 R0106 * MNGTFLAG 관리구분 R0094 * IOPSNFLAG 내외자구분 * KEEPMTHD 보관방법 1:실온 2:냉소 3:냉장 4:냉동 * GNRLSPCL 일반-전문 1:전문 2:일반 3:공산품 4:의약외품 5:기타 ***********************************/ misfComboComCdListMulti("Z0007,R0025,R0043,R0068,R0069,R0092,R0093,R0035,R0095,R0047,R0111,R0110,R0107,R0106,R0094", "grd_excelmaplist.instcd,grd_excelmaplist.goodflag,grd_excelmaplist.asetflag,grd_excelmaplist.proddrugsetflag,grd_excelmaplist.stocmngtflag,grd_excelmaplist.reqmthd,grd_excelmaplist.reqprid,grd_excelmaplist.prodplce,grd_excelmaplist.conflag,grd_excelmaplist.curncyunit,grd_excelmaplist.purcflag,grd_excelmaplist.setplceordflag,grd_excelmaplist.plceordbase,grd_excelmaplist.plceordqtycretflag,grd_excelmaplist.mngtflag"); rszfComboUnitList (cmb_purcunit, model.getValue(cmb_instcd.attribute("ref")), model.getValue(cmb_goodflag.attribute("ref"))); // 포장단위 misfComboCopyItemSet(cmb_purcunit, "", grd_rscdexcellist, "purcunit" ); //규격단위 misfComboCopyItemSet(cmb_purcunit, "", grd_rscdexcellist, "specunit" ); //규격단위 misfComboCopyItemSet(cmb_purcunit, "", grd_rscdexcellist, "cntsunit" ); //함량단위 misfComboCopyItemSet(cmb_purcunit, "", grd_rscdexcellist, "deliveunit" ); //수불단위 misfComboCopyItemSet(cmb_purcunit, "", grd_excelmaplist, "purcunit" ); //규격단위 misfComboCopyItemSet(cmb_purcunit, "", grd_excelmaplist, "specunit" ); //규격단위 misfComboCopyItemSet(cmb_purcunit, "", grd_excelmaplist, "cntsunit" ); //함량단위 misfComboCopyItemSet(cmb_purcunit, "", grd_excelmaplist, "deliveunit" ); //수불단위 rszfComboUnitList (cmb_prcpunit,model.getValue(cmb_instcd.attribute("ref")),"D"); // 처방단위 misfComboCopyItemSet(cmb_purcunit, "", grd_rscdexcellist, "prcpunit" ); //처방단위 misfComboCopyItemSet(cmb_purcunit, "", grd_excelmaplist, "prcpunit" ); //처방단위 // misfMsterDetailSet(grd_rscdexcellist,null, "TRRSC03801" ,"Y"); misfMsterDetailSet(grd_excelmaplist,null, "TRRSC03801" ,"Y"); // fSetGoodFlagAuth(); grd_excelmaplist.explorerbar = "sortshow"; grd_excelmaplist.selectionmode = "list"; model.setFocus("ipt_lrgcd_search"); model.refresh(); } // -------------------------------------------------- // Excel 자료와 입력 자료 비교 // -------------------------------------------------- function fGoodDataCampare(pIdx){ var sPath = "/root/main/ExlMasterLists/exlmasterlist"; var tPath = "/root/init/CompareData"; model.setValue(tPath + "/goodcd" , model.getValue(sPath + "["+pIdx+"]/goodcd" )); model.setValue(tPath + "/goodflag" , model.getValue(sPath + "["+pIdx+"]/goodflag" )); model.setValue(tPath + "/goodnm" , model.getValue(sPath + "["+pIdx+"]/goodnm" )); model.setValue(tPath + "/goodhngnm" , model.getValue(sPath + "["+pIdx+"]/goodhngnm" )); model.setValue(tPath + "/goodengnm" , model.getValue(sPath + "["+pIdx+"]/goodengnm" )); model.setValue(tPath + "/goodspec" , model.getValue(sPath + "["+pIdx+"]/goodspec" )); model.setValue(tPath + "/goodmodel" , model.getValue(sPath + "["+pIdx+"]/goodmodel" )); model.setValue(tPath + "/asetflag" , model.getValue(sPath + "["+pIdx+"]/asetflag" )); model.setValue(tPath + "/lrgcd" , model.getValue(sPath + "["+pIdx+"]/lrgcd" )); model.setValue(tPath + "/lrgnm" , model.getValue(sPath + "["+pIdx+"]/lrgnm" )); model.setValue(tPath + "/mdlcd" , model.getValue(sPath + "["+pIdx+"]/mdlcd" )); model.setValue(tPath + "/mdlnm" , model.getValue(sPath + "["+pIdx+"]/mdlnm" )); model.setValue(tPath + "/smlcd" , model.getValue(sPath + "["+pIdx+"]/smlcd" )); model.setValue(tPath + "/smlnm" , model.getValue(sPath + "["+pIdx+"]/smlnm" )); model.setValue(tPath + "/edicd" , model.getValue(sPath + "["+pIdx+"]/edicd" )); model.setValue(tPath + "/prodcmpycd" , model.getValue(sPath + "["+pIdx+"]/prodcmpycd" )); model.setValue(tPath + "/prodcmpynm" , model.getValue(sPath + "["+pIdx+"]/prodcmpynm" )); model.setValue(tPath + "/cmt" , model.getValue(sPath + "["+pIdx+"]/cmt" )); model.setValue(tPath + "/goodcd_2" , model.getValue(sPath + "["+pIdx+"]/goodcd_2" )); model.setValue(tPath + "/goodflag_2" , model.getValue(sPath + "["+pIdx+"]/goodflag_2" )); model.setValue(tPath + "/goodnm_2" , model.getValue(sPath + "["+pIdx+"]/goodnm_2" )); model.setValue(tPath + "/goodhngnm_2" , model.getValue(sPath + "["+pIdx+"]/goodhngnm_2" )); model.setValue(tPath + "/goodengnm_2" , model.getValue(sPath + "["+pIdx+"]/goodengnm_2" )); model.setValue(tPath + "/goodspec_2" , model.getValue(sPath + "["+pIdx+"]/goodspec_2" )); model.setValue(tPath + "/goodmodel_2" , model.getValue(sPath + "["+pIdx+"]/goodmodel_2" )); model.setValue(tPath + "/asetflag_2" , model.getValue(sPath + "["+pIdx+"]/asetflag_2" )); model.setValue(tPath + "/lrgcd_2" , model.getValue(sPath + "["+pIdx+"]/lrgcd_2" )); model.setValue(tPath + "/lrgnm_2" , model.getValue(sPath + "["+pIdx+"]/lrgnm_2" )); model.setValue(tPath + "/mdlcd_2" , model.getValue(sPath + "["+pIdx+"]/mdlcd_2" )); model.setValue(tPath + "/mdlnm_2" , model.getValue(sPath + "["+pIdx+"]/mdlnm_2" )); model.setValue(tPath + "/smlcd_2" , model.getValue(sPath + "["+pIdx+"]/smlcd_2" )); model.setValue(tPath + "/smlnm_2" , model.getValue(sPath + "["+pIdx+"]/smlnm_2" )); model.setValue(tPath + "/edicd_2" , model.getValue(sPath + "["+pIdx+"]/edicd_2" )); model.setValue(tPath + "/prodcmpycd_2" , model.getValue(sPath + "["+pIdx+"]/prodcmpycd_2" )); model.setValue(tPath + "/prodcmpynm_2" , model.getValue(sPath + "["+pIdx+"]/prodcmpynm_2" )); model.setValue(tPath + "/cmt_2" , model.getValue(sPath + "["+pIdx+"]/cmt_2" )); grp_disp.attribute("visibility") ="visible" ; opt_goodcd.dispatch("xforms-value-changed"); grp_disp.refresh(); } // -------------------------------------------------- // Excel File를 Load한다. // -------------------------------------------------- function fOldCodeAllSizeRead() { if (grd_ogoodcd.attribute("visibility") == "visible") { grd_ogoodcd.attribute("visibility") ="hidden" ; grd_allsize.attribute("visibility") ="hidden" ; return; } model.setValue("/root/send/selectcond/goodcd",model.getValue(opt_goodcd.attribute("ref"))); model.setValue("/root/send/selectcond/instcd",model.getValue(cmb_instcd.attribute("ref"))); submit("TRRSC03805"); submit("TRRSC03806"); grd_ogoodcd.attribute("visibility") ="visible" ; grd_ogoodcd.refresh(); // grd_allsize.refresh(); if (grd_allsize.rows < 2) { grd_allsize.attribute("visibility") ="hidden" ; } else { grd_allsize.attribute("visibility") ="visible" ; } grd_allsize.refresh(); } // -------------------------------------------------- // Excel File를 Load한다. // -------------------------------------------------- function fLoadExcel(pCls) { if (model.getValue(cmb_instcd.attribute("ref")).length== 0 ) { messageBox("기관코드를 " ,"C002"); model.setFocus("cmb_instcd"); return false; } var fileName = window.fileDialog("open", ",", false, "", "xls", "All Files (*.*)|*.*|Excel Files(*.xls)|*.xls"); if (pCls == "1") { grd_instexcellist.loadExcel(fileName, 1); //misfGridIUD(grd_instexcellist, "D"); //misfGridIUD(grd_instexcellist, "D"); } else { grd_rscdexcellist.loadExcel(fileName, 1); // fGridInsertChanged(); //misfGridIUD(grd_rscdexcellist, "D"); //misfGridIUD(grd_instexcellist, "D"); } model.refresh(); } // -------------------------------------------------- // Excel 자료를 임시 물품 Master에 생성한다. // -------------------------------------------------- var CondData = "" ; var OldnewData = "" ; var MasterData = "" ; var AllsizeData = "" ; // var CondHeader = "" ; // var OldnewHeader = "" ; // var MasterHeader = "" ; // var AllsizeHeader = "" ; function fExcel2GoodMasterSave() { var cPath = "/root/init/CopyGoodList"; var sPath = "/root/main/ExcelLists/ExcelList"; var tPath = "/root/CopyData/CopyGoodLists/CopyGoodList"; var mPath = "/root/init/CopySizeList"; var aPath = "/root/CopyData/CopySizeLists/CopySizeList"; var oPath = "/root/init/CopyMapList"; var nPath = "/root/CopyData/CopyMapLists/CopyMapList"; var pRow = 1 ; var aRow = 1 ; var nRow = 1 ; var GoodCd = ""; var sRowCnt = grd_rscdexcellist.rows - grd_rscdexcellist.fixedrows; fExcelGoodHeader(); var vInstcd = model.getValue("/root/send/searchlist/instcd" ); CondData += model.getValue("/root/send/searchlist/instcd" ) + "▦" // 01 기관코드 + model.getValue("/root/CopyData/CopyCond/mastercls" ) + "▦" // 02 Master 생성 구분 + model.getValue("/root/CopyData/CopyCond/allsizecls") + "▦" // 03 All Size 생성 구분 + model.getValue("/root/CopyData/CopyCond/oldnewcls" ) + "▩"; // 04 신구코드 생성 model.removeNode(tPath); model.removeNode(aPath); model.removeNode(nPath); for (var i=1; i<= sRowCnt; i++) { GoodCd = model.getValue(sPath + "["+i+"]/ngood"); if (model.getValue(tPath +"[goodcd='"+ GoodCd + "']/goodcd") == "") { vGoodFlag = model.getValue(sPath + "["+i+"]/ngood").substr(0,1) ; model.setValue(cPath+ "/goodcd" , model.getValue(sPath + "["+i+"]/ngood" )); model.setValue(cPath+ "/goodflag" , vGoodFlag ); model.setValue(cPath+ "/goodnm" , model.getValue(sPath + "["+i+"]/goodnm" )); model.setValue(cPath+ "/goodspec" , model.getValue(sPath + "["+i+"]/goodspec" )); model.setValue(cPath+ "/goodmodel" , model.getValue(sPath + "["+i+"]/goodmodel" )); model.setValue(cPath+ "/asetflag" , "1" ); model.setValue(cPath+ "/lrgcd" , model.getValue(sPath + "["+i+"]/lrgcd" )); model.setValue(cPath+ "/mdlcd" , model.getValue(sPath + "["+i+"]/mdlcd" )); model.setValue(cPath+ "/smlcd" , "" ); model.setValue(cPath+ "/edicd" , model.getValue(sPath + "["+i+"]/edicode" )); model.setValue(cPath+ "/prodcmpycd", "" ); model.setValue(cPath+ "/prodcmpynm", model.getValue(sPath + "["+i+"]/prodcmpycd")); model.makeNode(tPath + "["+pRow+"]" ); model.copyNode(tPath + "["+pRow+"]", cPath ); MasterData += model.getValue(sPath + "["+i+"]/ngood" ) + "▦" // 01 물품코드 + vGoodFlag + "▦" // 02 물품구분 + model.getValue(sPath + "["+i+"]/goodnm" ) + "▦" // 03 물품명 + model.getValue(sPath + "["+i+"]/goodspec" ) + "▦" // 04 물품규격 + model.getValue(sPath + "["+i+"]/goodmodel" ) + "▦" // 05 모델 + "1" + "▦" // 06 자산구분 + model.getValue(sPath + "["+i+"]/lrgcd" ) + "▦" // 07 대분류코드 + model.getValue(sPath + "["+i+"]/mdlcd" ) + "▦" // 08 중분류코드 + "" + "▦" // 09 소분류코드 + model.getValue(sPath + "["+i+"]/edicode" ) + "▦" // 10 EDI코드 + "" + "▦" // 11 제조회사코드 + model.getValue(sPath + "["+i+"]/prodcmpycd") + "▩"; // 12 제조회사명칭 pRow++; } if (model.getValue(sPath + "["+i+"]/allsizeid")!="") { model.setValue(mPath+ "/goodcd" , model.getValue(sPath + "["+i+"]/ngood" )); model.setValue(mPath+ "/goodnm" , model.getValue(sPath + "["+i+"]/goodnm" )); model.setValue(mPath+ "/allsizespecid" , model.getValue(sPath + "["+i+"]/allsizeid" )); model.setValue(mPath+ "/goodspec" , model.getValue(sPath + "["+i+"]/goodspec" )); model.makeNode(aPath + "["+aRow+"]" ); model.copyNode(aPath + "["+aRow+"]", mPath ); AllsizeData += vInstcd + "▦" // 01 기관코드 + model.getValue(sPath + "["+i+"]/ngood" ) + "▦" // 02 물품코드 + model.getValue(sPath + "["+i+"]/goodnm" ) + "▦" // 03 물품명 + model.getValue(sPath + "["+i+"]/allsizeid" ) + "▦" // 04 규격ID + model.getValue(sPath + "["+i+"]/goodspec" ) + "▩"; // 05 물품규격 aRow++; } oGoodCd = model.getValue(sPath + "["+i+"]/ogood"); if ((model.getValue(sPath + "["+i+"]/ogood") != "") && (model.getValue(nPath +"[ogoodcd='"+ oGoodCd + "']/ogoodcd") == "")) { model.setValue(oPath+ "/ngoodcd" , model.getValue(sPath + "["+i+"]/ngood" )); model.setValue(oPath+ "/ogoodcd" , model.getValue(sPath + "["+i+"]/ogood" )); model.setValue(oPath+ "/goodnm" , model.getValue(sPath + "["+i+"]/goodnm" )); model.makeNode(nPath + "["+nRow+"]" ); model.copyNode(nPath + "["+nRow+"]", oPath ); OldnewData += model.getValue(sPath + "["+i+"]/ngood" ) + "▦" // 01 물품코드 + model.getValue(sPath + "["+i+"]/ogood" ) + "▦" // 02 물품코드 + model.getValue(sPath + "["+i+"]/goodnm" ) + "▩"; // 03 물품명 nRow++; } } goodoldnew.refresh(); allsizecopy.refresh(); mgoodcopy.refresh(); model.removenode("/root/send/copydata" ); // 조건자료 model.makeValue("/root/send/copydata/copycond" ,CondData ); // 조건자료 model.makeValue("/root/send/copydata/exlmasterlist" ,MasterData ); // 물품마스터 model.makeValue("/root/send/copydata/exlallsizelist",AllsizeData); // All Size model.makeValue("/root/send/copydata/exloldnewlist" ,OldnewData ); // 신구물품 submit("TXRSC03804"); // if (model.getValue(gvErrorMsgPath + "/type") != "error") // { // misfGridInit(grd_rscdexcellist); // btn_cost.dispatch("DOMActivate"); // btn_cost.selected="true"; // btn_search.dispatch("DOMActivate"); // } } // -------------------------------------------------- // Excel 자료 Header 구성 // -------------------------------------------------- function fExcelGoodHeader(){ CondData = "instcd" + "▦" // 01 기관코드 + "mastercls" + "▦" // 02 Master 생성 구분 + "allsizecls" + "▦" // 03 All Size 생성 구분 + "oldnewcls" + "▩"; // 04 신구코드 생성 MasterData = "goodcd" + "▦" // 01 물품코드 + "goodflag" + "▦" // 02 물품구분 + "goodnm" + "▦" // 03 물품명 + "goodspec" + "▦" // 04 물품규격 + "goodmodel" + "▦" // 05 모델 + "asetflag" + "▦" // 06 자산구분 + "lrgcd" + "▦" // 07 대분류코드 + "mdlcd" + "▦" // 08 중분류코드 + "smlcd" + "▦" // 09 소분류코드 + "edicd" + "▦" // 10 EDI코드 + "prodcmpycd" + "▦" // 11 제조회사코드 + "prodcmpynm" + "▩"; // 12 제조회사명칭 AllsizeData = "instcd" + "▦" // 01 기관코드 + "goodcd" + "▦" // 02 물품코드 + "goodnm" + "▦" // 03 물품명 + "allsizespecid" + "▦" // 04 규격ID + "goodspec" + "▩"; // 05 물품규격 OldnewData = "ngoodcd" + "▦" // 01 물품코드 + "ogoodcd" + "▦" // 02 물품코드 + "goodnm" + "▩"; // 03 물품명 } // -------------------------------------------------- // Excel File를 Load한다. // -------------------------------------------------- function fGridInsertChanged() { for(var fRow = grd_rscdexcellist.fixedRows; fRow < grd_rscdexcellist.rows; fRow++) { grd_rscdexcellist.addStatus(fRow, "insert"); grd_rscdexcellist.valueMatrix(fRow, grd_rscdexcellist.colRef("instcd")) = model.getValue(cmb_instcd.attribute("ref")); grd_rscdexcellist.valueMatrix(fRow, grd_rscdexcellist.colRef("goodflag")) = model.getValue(cmb_goodflag.attribute("ref")); grd_rscdexcellist.valueMatrix(fRow, grd_rscdexcellist.colRef("ifflag")) = "E"; // Interface 구분 : E (excel 입력) } } function fSetGoodSpec() { model.setValue(opt_poptitle.attribute("ref"), "물품 규격을 입력해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd","SMRSC03801" ,"title","opt_poptitle"); model.refresh(); fSetAllApply(grd_excelmaplist,"goodspec", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetGoodModel() { model.setValue(opt_poptitle.attribute("ref"), "물품 모델을 입력해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd","SMRSC03801" ,"title","opt_poptitle"); model.refresh(); fSetAllApply(grd_excelmaplist,"goodmodel", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetGoodnm() { model.setValue(opt_poptitle.attribute("ref"), "물품명 입력해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd","SMRSC03801" ,"title","opt_poptitle"); model.refresh(); fSetAllApply(grd_excelmaplist,"goodnm", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetGoodUnitCost() { model.setValue(opt_poptitle.attribute("ref"), "제품 단가를 입력해 주세요"); model.setValue(opt_popformat.attribute("ref"), "#,###"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd","SMRSC03801" ,"title,format","opt_poptitle,opt_popformat"); model.refresh(); fSetAllApply(grd_excelmaplist,"goodunitcost", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetExchQty() { model.setValue(opt_poptitle.attribute("ref"), "환산수량을 입력해 주세요"); model.setValue(opt_popformat.attribute("ref"), "#,###"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd","SMRSC03801" ,"title,format","opt_poptitle,opt_popformat"); model.refresh(); fSetAllApply(grd_excelmaplist,"exchqty", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetMainCustLastSuplplce() { model.setValue(opt_popcond.attribute("ref"),"custom"); model.setValue(opt_poptitle.attribute("ref"), "주거래처를 선택해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd,popinputnm","SMRSC03801" ,"title,cond,instcd","opt_poptitle,opt_popcond,cmb_instcd"); model.refresh(); fSetAllApply(grd_excelmaplist,"maincustlastsuplplce,maincustlastsuplplcenm", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetSuppCustCd() { model.setValue(opt_popcond.attribute("ref"),"custom"); model.setValue(opt_poptitle.attribute("ref"), "보조 거래처를 선택해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd,popinputnm","SMRSC03801" ,"title,cond,instcd","opt_poptitle,opt_popcond,cmb_instcd"); model.refresh(); fSetAllApply(grd_excelmaplist,"suppcustcd,suppcustnm", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetGoodProdCmpy() { model.setValue(opt_popcond.attribute("ref"),"prodcmpy"); model.setValue(opt_poptitle.attribute("ref"), "제조회사를 선택해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd,popinputnm","SMRSC03801" ,"title,cond,instcd","opt_poptitle,opt_popcond,cmb_instcd"); model.refresh(); fSetAllApply(grd_excelmaplist,"prodcmpycd,prodcmpynm", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetPurcUnit() { model.setValue(opt_popcond.attribute("ref"),"purcunit"); model.setValue(opt_poptitle.attribute("ref"), "포장단위를 선택해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd","SMRSC03801" ,"title,cond","opt_poptitle,opt_popcond"); model.refresh(); fSetAllApply(grd_excelmaplist,"purcunit", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetDeliveUnit() { model.setValue(opt_popcond.attribute("ref"),"deliveunit"); model.setValue(opt_poptitle.attribute("ref"), "수불단위를 선택해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd","SMRSC03801" ,"title,cond","opt_poptitle,opt_popcond"); model.refresh(); fSetAllApply(grd_excelmaplist,"deliveunit", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetLargeCd() { model.setValue(opt_popcond.attribute("ref"),"lrgnm"); model.setValue(opt_poptitle.attribute("ref"), "분류코드를 선택해 주세요"); rszfOpenPopUpListByWndName(opt_popinputcd,"","popinputcd,popinputnm","SMRSC03801" ,"title,cond,instcd,goodflag","opt_poptitle,opt_popcond,cmb_instcd,cmb_goodflag"); fSetAllApply(grd_excelmaplist,"lrgcd,lrgnm,mdlcd,mdlnm,smlcd,smlnm", model.getValue(opt_popinputcd.attribute("ref"))); } function fSetAllApply(f_grid, f_id , f_value) { if(f_id == null || f_id.length == 0 || f_value == null || f_value.length == 0 )return; var f_selid = f_id.split(","); var f_selvalue = f_value.split(","); for(currow = 0 ; currow < f_grid.selectedRows; currow++) { for (var k = 0; k < f_selid.length; k++) { if(f_grid.colRef(f_selid[k]) != -1) { if(model.getValue(f_grid.nodeset + "[" + (f_grid.selectedRow(currow)- f_grid.fixedRows + 1) + "]/" + f_selid[k]) != f_selvalue[k]) { if(f_grid.valueMatrix( (f_grid.selectedRow(currow)- f_grid.fixedRows + 1) , f_grid.colRef("saveyn")) == "N") { // alert ( currow + " 번째 행의 " + f_grid.colRef("saveyn") + "번째 항목의 값 " + f_grid.valueMatrix( , f_grid.colRef("saveyn")) ); model.setValue(f_grid.nodeset + "[" + (f_grid.selectedRow(currow)- f_grid.fixedRows + 1) + "]/" + f_selid[k] ,f_selvalue[k]); if(f_grid.rowStatus(f_grid.selectedRow(currow)) == "0") { f_grid.rowStatus(f_grid.selectedRow(currow)) = "2"; // Update } if ( f_selid[k] == "lrgcd" || f_selid[k] == "lrgnm" || f_selid[k] == "mdlcd" || f_selid[k] == "mdlnm" || f_selid[k] == "smlcd" || f_selid[k] == "smlnm") { // 분류코드 변경시만 변경 model.setValue(f_grid.nodeset + "[" + (f_grid.selectedRow(currow)- f_grid.fixedRows + 1) + "]/" + "getgubunchk", "0*0*0"); // 대, 중, 소분류 값이 수정이 되면 오류 값을 수정처리 한다. fMapListValid(f_grid, (f_grid.selectedRow(currow)- f_grid.fixedRows), (f_grid.selectedRow(currow)- f_grid.fixedRows +1) ); // 오류 수정에 따른 색상 수정 } } } } } } } function fCheckRetrieveData() { if(model.getValue(cmb_instcd.attribute("ref")).length== 0 ) { messageBox("기관코드를 " ,"C002"); model.setFocus("cmb_instcd"); return false; } if(model.getValue(cmb_goodflag.attribute("ref")).length== 0 ) { messageBox("물품구분을 " ,"C002"); model.setFocus("cmb_goodflag"); return false; } /* if(model.getValue(ipt_lrgcd_search.attribute("ref")).length== 0 ) { messageBox("대분류코드를 " ,"C002"); model.setFocus("ipt_lrgcd_search"); return false; } if(model.getValue(ipt_goodcd.attribute("ref")).length < 3 && model.getValue(ipt_goodnm.attribute("ref")).length < 3) { messageBox("물품코드 또는 물품명에 최소 2자리를" ,"C001"); model.setFocus("ipt_goodcd_search"); return false; } */ return true; } // 물품구분별 권한체크. function fSetGoodFlagAuth() { btn_save.disabled=true; rszfGetPurcGoodFlagAuthInfo(cmb_instcd.value , cmb_goodflag.value, getUserInfo("userid"), "%"); if(rszfGetGoodFlagAuthInfoByCond("goodflagauth") =="Y") { btn_save.disabled=false; } } /****************************************** * 대, 중, 소분류에 대한 valid check에 대한 err 시 색상 변화 * pGrd = 대상이 되는 테이블 * pFromRow = Grid 시작 위치 * pToRow = Grid 종료 위치 * getgubunchk 항목에서 유효성 값 반환 = 0 : 이상 없음, 9 : 에러 * ex) 0*0*0 : 대, 중, 소분류 유효한 값 * 0*9*9 : 중, 소분류 오류 * 상위 분류 에러 발생시 하위 분류에 대한 유효성은 보장 할 수 없기 때문에 err 처리 ******************************************/ function fMapListValid(pGrd, pFromRow, pToRow) { var temValidItem = new Array("lrgcd","mdlcd","smlcd"); var rowcnt = 0; if(pFromRow != "" || pFromRow != null) { rowcnt = pGrd.fixedRows; } else { rowcnt = pFromRow; } if(pToRow != "" || pToRow != null) { grdRow = pGrd.rows; } else { grdRow = pToRow; } for ( rowcnt ; rowcnt 0 ) { var currow = 0; for(currow = grd_id.fixedRows ; currow < grd_id.rows ; currow++) { if ( grd_id.colRef("getgubunchk") != -1 ) { // var temValidItem = new Array("대분류","중분류","소분류","lgrnm","mdlnm","smlnm"); var temValidItem = new Array("대분류","중분류","소분류"); var tmp_getgubunchk = grd_id.valueMatrix(currow , grd_id.colRef("getgubunchk")).split("*"); for( cnt = 0; cnt < tmp_getgubunchk.length; cnt++ ) { if ( tmp_getgubunchk[cnt] != "0" ) { messageBox( grd_id.valueMatrix(currow , grd_id.colRef("no")) + " 번째 " + temValidItem[cnt] + "가 유효하지", "I004"); grd_id.row = currow; return false; // grd_id.col = grd_id.colRef( temValidItem[cnt+3] ); } } } if(grd_id.valueMatrix(currow, grd_id.colRef("lrgcd")).length == 0) { messageBox(currow + " 번째 대분류코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("lrgcd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("mdlcd")).length == 0) { messageBox(currow + " 번째 중분류코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("mdlcd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("smlcd")).length == 0) { messageBox(currow + " 번째 소분류코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("smlcd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("welfprt")).length == 0) { messageBox(currow + " 번째 복지부분류코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("welfprt"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("goodcd")).length == 0) { messageBox(currow + " 번째 신약품코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("goodcd"); grd_id.editCell(); return false; } else { for(srcrow = currow + 1 ; srcrow < grd_id.rows ; srcrow++) { if(grd_id.valueMatrix(currow , grd_id.colRef("goodcd")) == grd_id.valueMatrix(srcrow , grd_id.colRef("goodcd")) ) { messageBox("동일 물품코드가 [" + grd_id.valueMatrix(currow , grd_id.colRef("no")) + ", " + grd_id.valueMatrix(srcrow , grd_id.colRef("no")) + "->" + grd_id.valueMatrix(currow , grd_id.colRef("goodcd")) + "] 존재하여 저장 " ,"E001"); return false; } } } if(grd_id.valueMatrix(currow, grd_id.colRef("oldcd")).length == 0) { messageBox(currow + " 번째 구코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("oldcd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("bnscd")).length == 0) { messageBox(currow + " 번째 보나에스코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("bnscd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("edicd")).length == 0) { messageBox(currow + " 번째 EDI코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("edicd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("prodcmpycd")).length == 0) { messageBox(currow + " 번째 제조회사코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("prodcmpycd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("suppcustcd")).length == 0) { messageBox(currow + " 번째 판매회사코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("suppcustcd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("goodnm")).length == 0) { messageBox(currow + " 번째 품명을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("goodnm "); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("com")).length == 0) { messageBox(currow + " 번째 성분(코드)를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("com"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("comnm")).length == 0) { messageBox(currow + " 번째 성분(명)을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("comnm"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("cntsqty")).length == 0) { messageBox(currow + " 번째 함량을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("cntsqty"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("cntsunit")).length == 0) { messageBox(currow + " 번째 함량단위를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("cntsunit"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("specvol")).length == 0) { messageBox(currow + " 번째 규격을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("specvol"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("specunit")).length == 0) { messageBox(currow + " 번째 규격단위를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("specunit"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("prcpqty")).length == 0) { messageBox(currow + " 번째 처방수량을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("prcpqty"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("prcpunit")).length == 0) { messageBox(currow + " 번째 처방단위를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("prcpunit"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("prcpexchqty")).length == 0) { messageBox(currow + " 번째 처방환산을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("prcpexchqty "); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("exchqty")).length == 0) { messageBox(currow + " 번째 포장환산을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("exchqty"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("deliveunit")).length == 0) { messageBox(currow + " 번째 낱개단위를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("deliveunit"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("purcunit")).length == 0) { messageBox(currow + " 번째 포장단위를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("purcunit"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("gnrlspcl")).length == 0) { messageBox(currow + " 번째 일반/전문코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("gnrlspcl"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("winacnt")).length == 0) { messageBox(currow + " 번째 입고계정코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("winacnt"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("amtacnt")).length == 0) { messageBox(currow + " 번째 비용계정코드를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("amtacnt "); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("keepmthd")).length == 0) { messageBox(currow + " 번째 보관법을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("keepmthd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("pemtkeepmthd")).length == 0) { messageBox(currow + " 번째 보관법 설명을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("pemtkeepmthd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("fromdd")).length == 0) { messageBox(currow + " 번째 적용일자를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("fromdd"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("insucost")).length == 0) { messageBox(currow + " 번째 보험단가를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("insucost"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("estmamt")).length == 0) { messageBox(currow + " 번째 처방단가를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("estmamt"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("goodunitcost")).length == 0) { messageBox(currow + " 번째 구입단가를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("goodunitcost"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("goodpurccost")).length == 0) { messageBox(currow + " 번째 구입가를 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("goodpurccost"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("reqflag")).length == 0) { messageBox(currow + " 번째 청구구분을 " ,"C001"); grd_id.row = currow; grd_id.col = grd_id.colRef("reqflag"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("workvalid")) == "N") { messageBox(currow + " 번째 신규/변경 구분이","E016"); grd_id.row = currow; grd_id.col = grd_id.colRef("workflag"); grd_id.editCell(); return false; } if(grd_id.valueMatrix(currow, grd_id.colRef("fromdd")) < grd_id.valueMatrix(currow, grd_id.colRef("prefromdd"))) { messageBox(currow + " 번째 적용일자가","E016"); grd_id.row = currow; grd_id.col = grd_id.colRef("fromdd"); grd_id.editCell(); return false; } } } else { messageBox("저장 데이터가","I004"); return false; } } function fSetSaveData( grd_id ) { if ( getGridUpdateData(grd_id) != "" ) { messageBox("변경 데이터 저장 후 Master 적용이","I006"); return false; } var currow = 0; for(currow = grd_id.fixedRows ; currow < grd_id.rows ; currow++) { if(grd_id.valueMatrix(currow, grd_id.colRef("saveyn")) == "N") { if(grd_id.valueMatrix(currow, grd_id.colRef("workflag")) == "I") grd_id.rowStatus(currow) = "1"; else if (grd_id.valueMatrix(currow, grd_id.colRef("workflag")) == "U") grd_id.rowStatus(currow) = "2"; } } } /* ------------------------------------------------- */ /* ------End Of List ------------------------------- */ /* -------------------------------------------------- */