PJ1降类逻辑取最新入库日修改。

GWY

2022-03-16 0f07997d64a3e56afea01c04777c3e6a1954f407

 force-app/main/default/classes/ProRegisterHandler.cls

@@ -101,92 +101,199 @@
   //产品降类,只要注册证更新了,就检查一遍，重新给产品上的等级类别字段赋值。
   //可以找出需要的Id,然后调用方法。
   public static void checkRegistervervaldatum(List<Product_Register__c> newList, Map<Id, Product_Register__c> newMap, List<Product_Register__c> oldList, Map<Id, Product_Register__c> oldMap) {
      if (Trigger.isAfter && Trigger.isUpdate) {
         List<String> prcList = new List<String>();
         for (Product_Register__c pr : newList) {
            Product_Register__c oldpr = oldMap.get(pr.Id);
            //有效期的始与终变了,就把这个产品注册证的id放入一个List集合里面
            //if (pr.ValidTo__c != oldpr.ValidTo__c || pr.ValidFrom__c != oldpr.ValidFrom__c) {
                prcList.add(pr.id);
            //}
         }
         //放到Map里，用于感觉注册证更新产品
         Map<Id,Product2> prt2Map = new Map<Id,Product2>();
         //通过之前存储的Id用于关系表的查询。
         List<Product_Register_Link__c> prlList = new List<Product_Register_Link__c>();
         prlList = [select Product2__r.id,Product2__r.demoteer_Sap__c,Product_Register__r.MedPrdClass__c,Product_Register__r.ValidTo__c,Product_Register__r.ValidFrom__c 
         from Product_Register_Link__c 
           where Product_Register__r.Id in : prcList];

           //存放产品的id和等级类别字段的值的集合
           Map<Id,List<String>> pro2Map = new Map<Id,List<String>>();
           if (prlList.size()>0) {
               for (Product_Register_Link__c prl: prlList) {
                   if (pro2Map.containsKey(prl.Product2__r.Id)) {
                       pro2Map.get(prl.Product2__r.Id).add(prl.Product_Register__r.MedPrdClass__c);
                   }else {
                       pro2Map.put(prl.Product2__r.Id, new List<String>());
                       pro2Map.get(prl.Product2__r.Id).add(prl.Product_Register__r.MedPrdClass__c);
                   }
               }
           }
	        
           //存放产品id和字符串值
           Map<Id,String> prlMap = new Map<Id,String>();
           System.debug('pro2Map='+pro2Map);

           List<Id> pidList = new List<Id>();
           //通过上面的循环，把关系表过获取的数据读出来，传给map
           if (pro2Map.size()>0) {
               for (Product_Register_Link__c pr: prlList) {
                  // && (oldMap.get(pr.Product_Register__r.Id).ValidTo__c != newMap.get(pr.Product_Register__r.Id).ValidTo__c || oldMap.get(pr.Product_Register__r.Id).ValidFrom__c != newMap.get(pr.Product_Register__r.Id).ValidFrom__c)
                   if (pro2Map.containsKey(pr.Product2__r.Id)) {
                      pidList.add(pr.Product2__r.Id);
                       //生产日期在注册证有效期内的是二类，生产日期在备案证有效期的是一类，前提为有效期
                       // System.debug('pr.Product_Register__r.ValidTo__c='+ pr.Product_Register__r.ValidTo__c);
                       // System.debug('pr.Product_Register__r.Level_Category__c='+pr.Product_Register__r.MedPrdClass__c);
                       // System.debug('pr.Product2__r.demoteer_Sap__c='+ pr.Product2__r.demoteer_Sap__c);
                        if (pr.Product2__r.demoteer_Sap__c <= newMap.get(pr.Product_Register__r.Id).ValidTo__c && pr.Product2__r.demoteer_Sap__c >= newMap.get(pr.Product_Register__r.Id).ValidFrom__c
                           && (pr.Product_Register__r.MedPrdClass__c == '1')) {
                           prlMap.put(pr.Product2__r.Id, '一类');
                       }
                       else if (pr.Product2__r.demoteer_Sap__c <= newMap.get(pr.Product_Register__r.Id).ValidTo__c && pr.Product2__r.demoteer_Sap__c >= newMap.get(pr.Product_Register__r.Id).ValidFrom__c
                           && pr.Product_Register__r.MedPrdClass__c == '2' || pr.Product_Register__r.MedPrdClass__c == '3') {
                          if (!'一类'.equals(prlMap.get(pr.Product2__r.Id))){
                           prlMap.put(pr.Product2__r.Id, '二类');
                          }
                       } 
                   }
                   //System.debug('prlMap='+prlMap);
               }
           }

           List<Product2> por2Lsit = new List<Product2>();
           //查出产品的id和等级类别的字段 
           por2Lsit = [select Id,Level_Category__c from Product2 where Id in : pidList];

           //List<Product2> ppr2List = new List<Product2>();
           //给产品上的等级类别字段赋值
           for (Product2 pr2: por2Lsit) {
              //Product2 ppr2;
               if (!pro2Map.containsKey(pr2.Id)) {
                   pr2.Level_Category__c = '非监管';
               }else if (prlMap.containsKey(pr2.Id)) {
                   pr2.Level_Category__c = prlMap.get(pr2.Id);
               }else {
                   pr2.Level_Category__c = null;
               }
               if (pr2.Level_Category__c != null) {
                   prt2Map.put(pr2.Id, pr2);
               }
               //prt2.Id = pr2.Id;
               //prt2.Level_Category__c = pr2.Level_Category__c;
               //ppr2List.add(ppr2);
               //System.debug('ppr2List='+ppr2List);
               //System.debug('pr2.Level_Category__c='+pr2.Level_Category__c);
           }
           update prt2Map.values(); 
      List<String> prcList = new List<String>();
      for (Product_Register__c pr : newList) {
         Product_Register__c oldpr = oldMap.get(pr.Id);
         //有效期的始与终变了,就把这个产品注册证的id放入一个List集合里面
         //if (pr.ValidTo__c != oldpr.ValidTo__c || pr.ValidFrom__c != oldpr.ValidFrom__c) {
             prcList.add(pr.id);
         //}
      }
   }
      //放到Map里，用于注册证更新产品
      Map<Id,Product2> prt2Map = new Map<Id,Product2>();
      //通过之前存储的Id用于关系表的查询。
      List<Product_Register_Link__c> prlList = new List<Product_Register_Link__c>();
      prlList = [select Product2__r.id,Product2__r.demoteer_Sap__c,Product2__r.Diedatvanink__c,Product_Register__r.MedPrdClass__c,Product_Register__r.Stelsedag__c,Product_Register__r.ValidTo__c,Product_Register__r.ValidFrom__c 
      from Product_Register_Link__c 
        where Product_Register__r.Id in : prcList];
        //查询出产品ID
        List<Id> pro2IdList = new  List<Id>();
        for (Product_Register_Link__c prl1: prlList) {
           pro2IdList.add(prl1.Product2__r.id);
        }

        List<Product_Register_Link__c> prl1List = new List<Product_Register_Link__c>();
        prl1List = [select Product2__r.id,Product2__r.demoteer_Sap__c,Product2__r.Diedatvanink__c,Product_Register__r.Stelsedag__c,Product_Register__r.MedPrdClass__c,Product_Register__r.ValidTo__c,Product_Register__r.ValidFrom__c 
        from Product_Register_Link__c 
        where Product2__r.Id in : pro2IdList];

        //根据Id存放产品所属的所有注册证下的器械分类。
        Map<Id,List<String>> pro2Map = new Map<Id,List<String>>();
        //存放注册证上最前的维护日
        Map<Id,Date> prSteMap = new Map<Id,Date>();
        Map<Id,Date> prSte1Map = new Map<Id,Date>();
        if (prl1List.size()>0) {
            for (Product_Register_Link__c prl: prl1List) {
                if (pro2Map.containsKey(prl.Product2__r.Id)) {
                    pro2Map.get(prl.Product2__r.Id).add(prl.Product_Register__r.MedPrdClass__c);
                }else {
                    pro2Map.put(prl.Product2__r.Id, new List<String>());
                    pro2Map.get(prl.Product2__r.Id).add(prl.Product_Register__r.MedPrdClass__c);
                }

                if (prl.Product_Register__r.MedPrdClass__c == '1' && prl.Product_Register__r.Stelsedag__c <> null) {
                    if (prSteMap.containsKey(prl.Product2__r.Id)) {
                        if (prSteMap.get(prl.Product2__r.Id) > prl.Product_Register__r.Stelsedag__c) {
                            prSteMap.put(prl.Product2__r.Id,prl.Product_Register__r.Stelsedag__c);
                        }
                    }else {
                        prSteMap.put(prl.Product2__r.Id,prl.Product_Register__r.Stelsedag__c);
                    }
                }

                if ((prl.Product_Register__r.MedPrdClass__c == '2' || prl.Product_Register__r.MedPrdClass__c == '2') && prl.Product_Register__r.Stelsedag__c <> null) {
                    if (prSte1Map.containsKey(prl.Product2__r.Id)) {
                        if (prSte1Map.get(prl.Product2__r.Id) > prl.Product_Register__r.Stelsedag__c) {
                            prSte1Map.put(prl.Product2__r.Id,prl.Product_Register__r.Stelsedag__c);
                        }
                    }else {
                        prSte1Map.put(prl.Product2__r.Id,prl.Product_Register__r.Stelsedag__c);
                    }
                }
            }
        }
        System.debug('pro2Map='+pro2Map);
        System.debug('prSteMap='+prSteMap);
        System.debug('prSte1Map='+prSte1Map);
        //产品Id与等级类别
        Map<Id,String> prlMap = new Map<Id,String>();
        Map<Id,String> prl1Map = new Map<Id,String>();
        Map<Id,String> prl2Map = new Map<Id,String>();
        List<ID> pidList = new List<ID>();
        Date stedate;

        if (pro2Map.size()>0) {
            for (Product_Register_Link__c pr: prl1List) {
                if (pro2Map.containsKey(pr.Product2__r.Id) && (prSteMap.containsKey(pr.Product2__r.Id) || prSte1Map.containsKey(pr.Product2__r.Id))) {
                   stedate = prSteMap.get(pr.Product2__r.Id)==null?prSte1Map.get(pr.Product2__r.Id)==null?null:prSte1Map.get(pr.Product2__r.Id):prSte1Map.get(pr.Product2__r.Id);
                   pidList.add(pr.Product2__r.Id);
                    if (pr.Product2__r.demoteer_Sap__c <> null && pr.Product2__r.Diedatvanink__c <> null) {
                       if (pr.Product_Register__r.Stelsedag__c <> null) {
                           if (pr.Product2__r.Diedatvanink__c <= stedate) {
                              if (pr.Product2__r.demoteer_Sap__c <= pr.Product_Register__r.ValidTo__c && pr.Product2__r.demoteer_Sap__c >= pr.Product_Register__r.ValidFrom__c
                                   && pr.Product_Register__r.MedPrdClass__c == '2' || pr.Product_Register__r.MedPrdClass__c == '3') {
                                   if (prlMap.get(pr.Product2__r.Id) == null) {
                                       prlMap.put(pr.Product2__r.Id, '二类');
                                   }else {
                                       String Lins = prlMap.get(pr.Product2__r.Id);
                                       Lins += '二类';
                                       prlMap.put(pr.Product2__r.Id, Lins);
                                   }
                               }
                               else if (pr.Product2__r.demoteer_Sap__c <= pr.Product_Register__r.ValidTo__c && pr.Product2__r.demoteer_Sap__c >= pr.Product_Register__r.ValidFrom__c
                                   && (pr.Product_Register__r.MedPrdClass__c == '1')) {
                                       if (prlMap.get(pr.Product2__r.Id) == null) {
                                           prlMap.put(pr.Product2__r.Id, '一类');
                                       }else {
                                           String Lins = prlMap.get(pr.Product2__r.Id);
                                       Lins += '一类';
                                       prlMap.put(pr.Product2__r.Id, Lins);
                                       }
                               }else {
                                   if (prlMap.get(pr.Product2__r.Id) == null) {
                                       prlMap.put(pr.Product2__r.Id, '非监管');
                                   }else {
                                       String Lins = prlMap.get(pr.Product2__r.Id);
                                       Lins += '非监管';
                                       prlMap.put(pr.Product2__r.Id, Lins);
                                   }
                               }
                           }else if (pr.Product2__r.Diedatvanink__c > stedate) {
                               if (pr.Product2__r.demoteer_Sap__c <= pr.Product_Register__r.ValidTo__c && pr.Product2__r.demoteer_Sap__c >= pr.Product_Register__r.ValidFrom__c
                                   && pr.Product_Register__r.MedPrdClass__c == '1') {
                                   if (prl1Map.get(pr.Product2__r.Id) == null) {
                                       prl1Map.put(pr.Product2__r.Id, '一类');
                                   }else {
                                       String Lins = prl1Map.get(pr.Product2__r.Id);
                                       Lins += '一类';
                                       prl1Map.put(pr.Product2__r.Id, Lins);
                                   }
                               }else if (pr.Product2__r.demoteer_Sap__c <= pr.Product_Register__r.ValidTo__c && pr.Product2__r.demoteer_Sap__c >= pr.Product_Register__r.ValidFrom__c
                                   && pr.Product_Register__r.MedPrdClass__c == '2' || pr.Product_Register__r.MedPrdClass__c == '3') {
                                   if (prl1Map.get(pr.Product2__r.Id) == null) {
                                       prl1Map.put(pr.Product2__r.Id, '二类');
                                   }else {
                                       String Lins = prl1Map.get(pr.Product2__r.Id);
                                       Lins += '二类';
                                       prl1Map.put(pr.Product2__r.Id, Lins);
                                   }
                               }else {
                                   if (prlMap.get(pr.Product2__r.Id) == null) {
                                       prlMap.put(pr.Product2__r.Id, '非监管');
                                   }else {
                                       String Lins = prlMap.get(pr.Product2__r.Id);
                                       Lins += '非监管';
                                       prlMap.put(pr.Product2__r.Id, Lins);
                                   }
                               }
                           }
                       }else {
                          prl2Map.put(pr.Product2__r.Id, '空');
                       }
                    }
                }
            }
        }
        System.debug('prlMap='+prlMap);
        System.debug('prl1Map='+prl1Map);
        System.debug('prl2Map='+prl2Map);

        List<Product2> por2Lsit = new List<Product2>();
       //查出产品的id和等级类别的字段 
       por2Lsit = [select Id,Level_Category__c,demoteer_Sap__c,Diedatvanink__c from Product2 where Id in : pidList];
       if (por2Lsit.size() > 0) {
           for (Product2 pr2: por2Lsit) {
              if (prlMap.containsKey(pr2.Id)) {
                   if ((prlMap.get(pr2.Id).contains('二类') && prlMap.get(pr2.Id).contains('一类')) || 
                       (!prlMap.get(pr2.Id).contains('一类') && prlMap.get(pr2.Id).contains('二类'))){
                      pr2.Level_Category__c = '二类';
                       prt2Map.put(pr2.Id, pr2);
                   }else if (prlMap.get(pr2.Id).contains('一类') && !prlMap.get(pr2.Id).contains('二类')) {
                      pr2.Level_Category__c = '一类';
                       prt2Map.put(pr2.Id, pr2);
                   }else if (prlMap.get(pr2.Id).contains('非监管') && !prl2Map.containsKey(pr2.Id)) {
                       pr2.Level_Category__c = '非监管';
                       prt2Map.put(pr2.Id, pr2);
                   }else {
                      pr2.Level_Category__c = null;
                       prt2Map.put(pr2.Id, pr2);
                   }
               }
               if (prl1Map.containsKey(pr2.Id)) {
                   if (prl1Map.get(pr2.Id).contains('一类')) {
                       pr2.Level_Category__c = '一类';
                       prt2Map.put(pr2.Id, pr2);
                   }else if (prl1Map.get(pr2.Id).contains('二类') && !prl1Map.get(pr2.Id).contains('一类')) {
                       pr2.Level_Category__c = '二类';
                       prt2Map.put(pr2.Id, pr2);
                   }else if (prl1Map.get(pr2.Id).contains('非监管') && !prl2Map.containsKey(pr2.Id)) {
                       pr2.Level_Category__c = '非监管';
                       prt2Map.put(pr2.Id, pr2);
                   }else {
                      pr2.Level_Category__c = null;
                       prt2Map.put(pr2.Id, pr2);
                   }
               }
               if (pr2.demoteer_Sap__c == null || pr2.Diedatvanink__c == null) {
                   pr2.Level_Category__c = null;
                   prt2Map.put(pr2.Id, pr2);
               }
          }
       }
	    
       System.debug('prt2Map='+prt2Map);
        if (prt2Map.size() > 0) {
           update prt2Map.values(); 
        } 
   }
}