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 | 194 ++++++++++++++++++++++++++++++++++++------------ 1 files changed, 144 insertions(+), 50 deletions(-) diff --git a/force-app/main/default/classes/ProRegisterHandler.cls b/force-app/main/default/classes/ProRegisterHandler.cls index 2875d82..65515f8 100644 --- a/force-app/main/default/classes/ProRegisterHandler.cls +++ b/force-app/main/default/classes/ProRegisterHandler.cls @@ -113,92 +113,186 @@ 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 + 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>(); - if (prlList.size()>0) { - for (Product_Register_Link__c prl: prlList) { + 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 (prSteMap.containsKey(prl.Product2__r.Id)) { - if (prSteMap.get(prl.Product2__r.Id) > prl.Product_Register__r.Stelsedag__c) { - prSteMap.remove(prl.Product2__r.Id); + + 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); } - }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>(); - List<ID> pr2Idlsit = new List<ID>(); - if (pro2Map.size()>0 && prSteMap.size()>0) { - for (Product_Register_Link__c pr: prlList) { - if (pro2Map.containsKey(pr.Product2__r.Id) && prSteMap.containsKey(pr.Product2__r.Id)) { - pr2Idlsit.add(pr.Product2__r.Id); - //鐢熶骇鏃ュぇ浜庣淮鎶ゆ棩,鍏ュ簱鏃ュぇ浜庣淮鎶ゆ棩 - if (pr.Product2__r.demoteer_Sap__c <= prSteMap.get(pr.Product2__r.Id) && - pr.Product2__r.Diedatvanink__c <= prSteMap.get(pr.Product2__r.Id)) { - if (pro2Map.get(pr.Product2__r.Id).contains('1') || - pro2Map.get(pr.Product2__r.Id).contains('2') || - pro2Map.get(pr.Product2__r.Id).contains('3')) { - prlMap.put(pr.Product2__r.Id, '浜岀被'); - }else { - prlMap.put(pr.Product2__r.Id, '闈炵洃绠�'); - } - }else { - //鍏ュ簱鏃ュぇ浜庣淮鎶ゆ棩 - if (pr.Product2__r.Diedatvanink__c > prSteMap.get(pr.Product2__r.Id)) { - //鐢熶骇鏃ュぇ浜庣淮鎶ゆ棩 - if (pr.Product2__r.demoteer_Sap__c > prSteMap.get(pr.Product2__r.Id)) { - prlMap.put(pr.Product2__r.Id, '涓�绫�'); - }else { - //鐢熶骇鏃ュ皬浜庣淮鎶ゆ棩 - if (pro2Map.get(pr.Product2__r.Id).contains('1')) { - prlMap.put(pr.Product2__r.Id, '涓�绫�'); - }else if (!pro2Map.get(pr.Product2__r.Id).contains('1') && - (pro2Map.get(pr.Product2__r.Id).contains('2') || - pro2Map.get(pr.Product2__r.Id).contains('3'))) { - prlMap.put(pr.Product2__r.Id, '浜岀被'); - }else { - prlMap.put(pr.Product2__r.Id, '闈炵洃绠�'); - } - } - } + 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 from Product2 where Id in : pr2Idlsit]; + 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)) { - pr2.Level_Category__c = prlMap.get(pr2.Id); - prt2Map.put(pr2.Id,pr2); - }else { - pr2.Level_Category__c = null; - prt2Map.put(pr2.Id,pr2); - } + 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); + } } } - if (prlMap.size() > 0) { + System.debug('prt2Map='+prt2Map); + if (prt2Map.size() > 0) { update prt2Map.values(); } } -- Gitblit v1.9.1