YNU_JEUS/app_home/himed/webapps/mis/costprofbaseweb/js/SMRSC03801.js

/* ---------------------------------------------------------------------
  
      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<grdRow; rowcnt++ )
        {
          var tmp_getgubunchk = pGrd.valueMatrix(rowcnt , pGrd.colRef("getgubunchk")).split("*");


//          if(pGrd.valueMatrix(rowcnt, pGrd.colRef("saveyn")) != "Y")
//          {
            for( colcnt = 0; colcnt < tmp_getgubunchk.length; colcnt++ ) 
            {   
              if( tmp_getgubunchk[colcnt] == "9" ) 
              {
                pGrd.cellstyle("background-color", rowcnt, pGrd.colRef(temValidItem[colcnt]), rowcnt, pGrd.colRef(temValidItem[colcnt])+1  ) = "yellow";
              }
              else 
              {
                if ( tmp_getgubunchk[colcnt] != "9" && pGrd.cellstyle("background-color", rowcnt, pGrd.colRef(temValidItem[colcnt]), rowcnt, pGrd.colRef(temValidItem[colcnt]) ) != "white" )
                  pGrd.cellstyle("background-color", rowcnt, pGrd.colRef(temValidItem[colcnt]), rowcnt, pGrd.colRef(temValidItem[colcnt])+1  ) = "white";
              }
            }
//          }
        }         
//        pGrd.editCell();
      }
      
      function fCheckSaveData( grd_id ) 
      {   
        if( grd_id.rows - grd_id.fixedRows > 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 -------------------------------  */
 /* -------------------------------------------------- */