From 0f07997d64a3e56afea01c04777c3e6a1954f407 Mon Sep 17 00:00:00 2001
From: GWY <guweiyiscp096@foxmail.com>
Date: 星期三, 16 三月 2022 13:47:41 +0800
Subject: [PATCH] PJ1降类逻辑取最新入库日修改。
---
force-app/main/default/classes/ProRegisterHandler.cls | 279 ++++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 193 insertions(+), 86 deletions(-)
diff --git a/force-app/main/default/classes/ProRegisterHandler.cls b/force-app/main/default/classes/ProRegisterHandler.cls
index d3ab708..65515f8 100644
--- a/force-app/main/default/classes/ProRegisterHandler.cls
+++ b/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鏀惧叆涓�涓狶ist闆嗗悎閲岄潰
- //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>();
- //閫氳繃涔嬪墠瀛樺偍鐨処d鐢ㄤ簬鍏崇郴琛ㄧ殑鏌ヨ銆�
- 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];
-
- //瀛樻斁浜у搧鐨刬d鍜岀瓑绾х被鍒瓧娈电殑鍊肩殑闆嗗悎
- 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>();
- //鏌ュ嚭浜у搧鐨刬d鍜岀瓑绾х被鍒殑瀛楁
- 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鏀惧叆涓�涓狶ist闆嗗悎閲岄潰
+ //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>();
+ //閫氳繃涔嬪墠瀛樺偍鐨処d鐢ㄤ簬鍏崇郴琛ㄧ殑鏌ヨ銆�
+ 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];
+ //鏌ヨ鍑轰骇鍝両D
+ 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>();
+ //鏌ュ嚭浜у搧鐨刬d鍜岀瓑绾х被鍒殑瀛楁
+ 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();
+ }
+ }
}
\ No newline at end of file
--
Gitblit v1.9.1