public with sharing class ProRegisterHandler extends Oly_TriggerHandler { /* 2018-08-31 更新产品内最新产品在注册证 1.根据需要更新的产品注册证找出所有对应的产品-注册证关系 2.根据产品-注册证关系找出所有对应的产品 3.根据产品找出其所需最新产品注册证 */ private Map newMap; private Map oldMap; private List newList; private List oldList; public ProRegisterHandler() { this.newMap = (Map) Trigger.newMap; this.oldMap = (Map) Trigger.oldMap; this.newList = (List) Trigger.new; this.oldList = (List) Trigger.old; } protected override void beforeInsert() { updateLink(); } protected override void beforeUpdate() { updateLink(); } protected override void afterUpdate() { updateProduct(); } //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() { if (System.Label.UpdRegOnly == '1') return; // 产品-注册证关系 中所有 产品ID List Product2_ID_list = new list(); // 现有产品 map Map Exist_ProductMap = new map(); // 需要更新产品 list List UpdateProductlist = new list(); // 根据变更的证ID找到关联的所有的产品 list ExistPRLList = [select Product2__c, Product_Register__c from Product_Register_Link__c where Product_Register__c in: newList ]; for (Product_Register_Link__c PRL : ExistPRLList) { // 产品ID的LIST Product2_ID_list.add(PRL.Product2__c); } // 通过产品ID找到该产品最新注册证ID Exist_ProductMap = new Map ([select ID, Register_Latest__c from Product2 where id in: Product2_ID_list ]); // 通过产品ID找到所有涉及的有效关系 List 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 UpdProMap = new Map(); 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; } // 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; } } } // 20190401 CHAN-BAPCE6 LHJ End } 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(); } }