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

GWY

2022-03-16 0f07997d64a3e56afea01c04777c3e6a1954f407

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

@@ -1,181 +1,299 @@
public with sharing class ProRegisterHandler extends Oly_TriggerHandler {
    /* 2018-08-31 更新产品内最新产品在注册证
     1.根据需要更新的产品注册证找出所有对应的产品-注册证关系
     2.根据产品-注册证关系找出所有对应的产品
     3.根据产品找出其所需最新产品注册证
    */
    private Map<Id, Product_Register__c> newMap;
    private Map<Id, Product_Register__c> oldMap;
    private List<Product_Register__c> newList;
    private List<Product_Register__c> oldList;
public without sharing class ProRegisterHandler {

    public ProRegisterHandler() {
        this.newMap = (Map<Id, Product_Register__c>) Trigger.newMap;
        this.oldMap = (Map<Id, Product_Register__c>) Trigger.oldMap;
        this.newList = (List<Product_Register__c>) Trigger.new;
        this.oldList = (List<Product_Register__c>) Trigger.old;
    }
   public static void updateProduct(List<Product_Register__c> newList, Map<Id, Product_Register__c> newMap, List<Product_Register__c> oldList, Map<Id, Product_Register__c> oldMap) {

    protected override void beforeInsert() {
        updateLink();
    }
      // 产品-注册证关系 中所有 产品ID
      List<ID> Product2_ID_list = new list<ID>();
      // 现有产品 map
      Map<ID, Product2> Exist_ProductMap = new map<ID, Product2>();
      // 需要更新产品 list
      List<Product2> UpdateProductlist = new list<Product2>();
      // 根据变更的证ID找到关联的所有的产品
      list<Product_Register_Link__c> ExistPRLList = [select Product2__c,
                                     Product_Register__c
                                     from Product_Register_Link__c
                                     where Product_Register__c in: newList
                                                    ];

    protected override void beforeUpdate() {
        updateLink();
    }
      for (Product_Register_Link__c PRL : ExistPRLList) {
         // 产品ID的LIST
         Product2_ID_list.add(PRL.Product2__c);
      }

    protected override void afterUpdate() {
        updateProduct();
    }
      // 通过产品ID找到该产品最新注册证ID
      Exist_ProductMap = new Map<ID, Product2> ([select ID, Register_Latest__c, registrationCode__c, clinical_product_code__c
              from Product2
              where id in: Product2_ID_list
                                                ]);

    //protected override void beforeDelete() {
    //    updateProduct();
    //}
    private void updateLink() {
        for (Product_Register__c reg : newList) {
            system.debug('reg.Name--->'+reg.Name);
            reg.RegisterNoURL__c = EncodingUtil.urlEncode(reg.Name, 'UTF-8');
        }
        
    }
    private void updateProduct() {
      // 通过产品ID找到所有涉及的有效关系
      List<Product_Register_Link__c> allPRLList = [select Product2__c,
                                     Product_Register__c,
                                     Product_Register__r.PrdCompanyAddr__c,
                                     Product_Register__r.ValidFrom__c,
                                     Product_Register__r.ValidTo__c,
                                     Product_Register__r.Name,
                                     Product_Register__r.ValidProductRegister__c,
                                     Product_Register__r.ClinicalProductCode__c
                                     from Product_Register_Link__c
                                     where Product2__c in : Product2_ID_list
                                     order by Product2__c,
                                     LastModifiedDate desc
                                                  ];

        if (System.Label.UpdRegOnly == '1') return;
      String tmpProductID = '';
      Product2 temProduct = new Product2();
      Map<Id, Product2> UpdProMap = new Map<Id, Product2>();

        // 产品-注册证关系 中所有 产品ID
        List<ID> Product2_ID_list = new list<ID>();
        // 现有产品 map
        Map<ID, Product2> Exist_ProductMap = new map<ID, Product2>();
        // 需要更新产品 list
        List<Product2> UpdateProductlist = new list<Product2>();
        // 根据变更的证ID找到关联的所有的产品
        list<Product_Register_Link__c> ExistPRLList = [select Product2__c,
                                                              Product_Register__c
                                                         from Product_Register_Link__c
                                                        where Product_Register__c in: newList
                                                      ];
      for (Product_Register_Link__c temPRL : allPRLList) {

        for (Product_Register_Link__c PRL : ExistPRLList) {
            // 产品ID的LIST
            Product2_ID_list.add(PRL.Product2__c);
         if (!tmpProductID.equals(temPRL.Product2__c)) {

            tmpProductID = temPRL.Product2__c;
            temProduct = Exist_ProductMap.get(tmpProductID);
            temProduct.Register_Latest__c = temPRL.Product_Register__c;                    // 最新注册证ID
            temProduct.registrationCode__c = null;
            temProduct.clinical_product_code__c = null;
         }

         // 如果注册证状态有效,记录有效注册证号
         if (temPRL.Product_Register__r.ValidProductRegister__c ) {
            if (String.isBlank(temProduct.registrationCode__c)) {
               temProduct.registrationCode__c = temPRL.Product_Register__r.Name + '\n';
            } else {
               if (String.isNotBlank(temPRL.Product_Register__r.Name)) {
                  if (temProduct.registrationCode__c.indexOf(temPRL.Product_Register__r.Name) == -1) {
                     temProduct.registrationCode__c += temPRL.Product_Register__r.Name + '\n';
                  }
               }
            }

            String clinicalCode = temPRL.Product_Register__r.ClinicalProductCode__c;
            if (String.isBlank(temProduct.clinical_product_code__c)) {
               temProduct.clinical_product_code__c = clinicalCode;//temPRL.Product_Register__r.ClinicalProductCode__c;
            } else {

               if (String.isNotBlank(clinicalCode)) {

                  Map<String, String> codeMap = new Map<String, String>();
                  for (String code : temProduct.clinical_product_code__c.split('/')) {
                     codeMap.put(code, code);
                  }
                  codeMap.put(clinicalCode, clinicalCode);
                  temProduct.clinical_product_code__c = '';
                  for (String code : codeMap.values()) {
                     if (String.isBlank(temProduct.clinical_product_code__c)) {
                        temProduct.clinical_product_code__c = code;
                     } else {
                        temProduct.clinical_product_code__c += '/' + code;
                     }
                  }
						
               }

            }
         }
         UpdProMap.put(tmpProductID, temProduct);
      }
      if (UpdProMap.keySet().size() > 0)  update UpdProMap.values();
   }

   //产品降类,只要注册证更新了,就检查一遍，重新给产品上的等级类别字段赋值。
   //可以找出需要的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) {
      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);
        }

        // 通过产品ID找到该产品最新注册证ID
        Exist_ProductMap = new Map<ID, Product2> ([select ID, Register_Latest__c
                from Product2
                where id in: Product2_ID_list
                                                  ]);
        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找到所有涉及的有效关系
        List<Product_Register_Link__c> allPRLList = [select Product2__c,
                                                         Product_Register__c,
                                                         Product_Register__r.PrdCompanyAddr__c,
                                                         Product_Register__r.PrdCompanyAddr2__c,
                                                         Product_Register__r.PrdCompanyAddr3__c,
                                                         Product_Register__r.ValidFrom__c,
                                                         Product_Register__r.ValidTo__c,
                                                         Product_Register__r.Name,
                                                         // 20190401 CHAN-BAPCE6 LHJ Start
                                                         Product_Register__r.BusinessScopeKey__c,
                                                         // 20190401 CHAN-BAPCE6 LHJ End
                                                         Product_Register__r.RegisterNoStatus__c
                                                   from Product_Register_Link__c
                                                   where Product2__c in : Product2_ID_list
                                                  // and If_Delete__c = false
                                                   order by Product2__c,
                                                   Product_Register__r.RegisterNoStatusCode__c,
                                                   LastModifiedDate desc
                                                    ];

        String tmpProductID = '';
        String temAllProdStatus = '';
        String temAllProdStatus2 = '';
        String temAllProdStatusAll = '';
        // 20190401 CHAN-BAPCE6 LHJ Start
        String temAllScopeKey = '';
        // 20190401 CHAN-BAPCE6 LHJ End
        Product2 temProduct = new Product2();
        Map<Id, Product2> UpdProMap = new Map<Id, Product2>();

        for (Product_Register_Link__c temPRL : allPRLList) {

            if (!tmpProductID.equals(temPRL.Product2__c)) {
                tmpProductID = temPRL.Product2__c;
                temProduct = Exist_ProductMap.get(tmpProductID);
                temAllProdStatus = '';
                temAllProdStatus2 = '';
                temAllProdStatusAll = '';
                // 20190401 CHAN-BAPCE6 LHJ Start
                temAllScopeKey = '';
                // 20190401 CHAN-BAPCE6 LHJ End
                temProduct.Register_Latest__c = temPRL.Product_Register__c;                    // 最新注册证ID
                temProduct.SFDA_Approbation_No__c = temPRL.Product_Register__r.Name;           // CFDA注册号
                temProduct.SFDA_Approbated_Date__c = temPRL.Product_Register__r.ValidFrom__c;  // CFDA注册日
                temProduct.SFDA_Expiration_Date__c = temPRL.Product_Register__r.ValidTo__c;    // CFDA有效期限
                if(temPRL.Product_Register__r.Name != 'FYL') {
                    temProduct.ProduceCompany__c = temPRL.Product_Register__r.PrdCompanyAddr__c;   // 生产企业
                    //CHAN-C4X63A 【委托】NFM204字段“生产企业地址”优化 XHL 20210716 Start
                    temProduct.ProduceCompany2__c = temPRL.Product_Register__r.PrdCompanyAddr2__c;
                    temProduct.ProduceCompany3__c = temPRL.Product_Register__r.PrdCompanyAddr3__c;
                    //CHAN-C4X63A 【委托】NFM204字段“生产企业地址”优化 XHL 20210716 End
                }
                temProduct.SFDA_Approbated_Status__c = temPRL.Product_Register__r.RegisterNoStatus__c;    // CFDA注册证状态
            }

            // 如果注册证状态有效,记录有效注册证号
            if (temPRL.Product_Register__r.RegisterNoStatus__c == '有效') {
                // LHJ 20190809 
                String productRegisterName = temPRL.Product_Register__r.Name;
                if (temAllProdStatus.length() + productRegisterName.length() <= 240) {
                    if (!temAllProdStatusAll.contains(productRegisterName)) {
                        temAllProdStatus += ';' + productRegisterName;
                        temAllProdStatusAll += ';' + productRegisterName;
                    }
                    
                } else {
                    if (!temAllProdStatusAll.contains(productRegisterName)) {
                        temAllProdStatus2 += ';' + productRegisterName;
                        temAllProdStatusAll += ';' + productRegisterName;
                    }
                    //temAllProdStatus2 += ';' + productRegisterName;
        //根据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);
                }

                // 20190401 CHAN-BAPCE6 LHJ Start
                //if (String.isNotBlank(temPRL.Product_Register__r.BusinessScopeKey__c)  &&
                //      (!temAllScopeKey.contains(temPRL.Product_Register__r.BusinessScopeKey__c))) {
                //  temAllScopeKey += ';' + temPRL.Product_Register__r.BusinessScopeKey__c;
                //}
                String  businessScopeKey = temPRL.Product_Register__r.BusinessScopeKey__c;
                if (String.isNotBlank(businessScopeKey)) {
                    for(String scopeKey:businessScopeKey.split(';')){
                        if (!temAllScopeKey.contains(scopeKey)) {
                            temAllScopeKey += ';' + scopeKey;
                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);
                    }
                    
                    
                }
                // 20190401 CHAN-BAPCE6 LHJ End

                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);
                    }
                }
            }
            if (temAllProdStatus != '') {
                temProduct.RegisterNo_ALL__c = temAllProdStatus.substring(1, temAllProdStatus.length());
            } else {
                temProduct.RegisterNo_ALL__c = '';
            }
            if (temAllProdStatus2 != '') {
                temProduct.RegisterNo_ALL2__c = temAllProdStatus2.substring(1, temAllProdStatus2.length());
            } else {
                temProduct.RegisterNo_ALL2__c = '';
            }
            // 20190401 CHAN-BAPCE6 LHJ Start
            if (temAllScopeKey != '') {
                temProduct.RegScopeKeyAll__c = temAllScopeKey.substring(1, temAllScopeKey.length());
            } else {
                temProduct.RegScopeKeyAll__c = '';
            }
            // 20190401 CHAN-BAPCE6 LHJ End
            UpdProMap.put(tmpProductID, temProduct);
        }
        if (UpdProMap.keySet().size() > 0)  update UpdProMap.values();
    }
        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(); 
        } 
   }
}