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