| | |
| | | |
| | | //存放查找的soql文 |
| | | List<Product_Register_Link__c> pro2List = new List<Product_Register_Link__c>(); |
| | | pro2List = [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 |
| | | pro2List = [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,Product_Register__c,Product2__c |
| | | from Product_Register_Link__c |
| | | where Product2__r.Id in : p2ids]; |
| | | System.debug('pro2List='+pro2List); |
| | |
| | | for (Product_Register_Link__c pr: pro2List) { |
| | | 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); |
| | | if (newMap.get(pr.Product2__r.Id).demoteer_Sap__c <> null && pr.Product2__r.Diedatvanink__c <> null) { |
| | | if (newMap.get(pr.Product2__r.Id).demoteer_Sap__c <> null && newMap.get(pr.Product2__r.Id).Diedatvanink__c <> null) { |
| | | if (pr.Product_Register__r.Stelsedag__c <> null) { |
| | | if (pr.Product2__r.Diedatvanink__c <= stedate) { |
| | | if (newMap.get(pr.Product2__r.Id).Diedatvanink__c <= stedate) { |
| | | if (newMap.get(pr.Product2__r.Id).demoteer_Sap__c <= pr.Product_Register__r.ValidTo__c && newMap.get(pr.Product2__r.Id).demoteer_Sap__c >= pr.Product_Register__r.ValidFrom__c |
| | | && pr.Product_Register__r.MedPrdClass__c == '2' || pr.Product_Register__r.MedPrdClass__c == '3') { |
| | | System.debug('2'); |
| | |
| | | prlMap.put(pr.Product2__r.Id, Lins); |
| | | } |
| | | } |
| | | }else if (pr.Product2__r.Diedatvanink__c > stedate) { |
| | | }else if (newMap.get(pr.Product2__r.Id).Diedatvanink__c > stedate) { |
| | | if (newMap.get(pr.Product2__r.Id).demoteer_Sap__c <= pr.Product_Register__r.ValidTo__c && newMap.get(pr.Product2__r.Id).demoteer_Sap__c >= pr.Product_Register__r.ValidFrom__c |
| | | && pr.Product_Register__r.MedPrdClass__c == '1') { |
| | | if (prl1Map.get(pr.Product2__r.Id) == null) { |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | System.debug('stedate='+stedate); |
| | | System.debug('prlMap='+prlMap); |
| | | System.debug('prl1Map='+prl1Map); |
| | | |