public without sharing class Product2TriggerHandler {
|
|
public static void upsertProductSearch(List<Product2> newList, Map<Id, Product2> newMap, List<Product2> oldList, Map<Id, Product2> oldMap)
|
{
|
if(Trigger.isAfter && (Trigger.isInsert || Trigger.isUpdate))
|
{
|
List<String> p2ids = new List<String>();
|
for(Product2 p2 : newList)
|
{
|
p2ids.add(p2.id);
|
}
|
|
List<Product_Search__c> ps = [select Id,Name,CurrencyIsoCode,Product__c From Product_Search__c Where Product__c in: p2ids];
|
Map <String,Product_Search__c> psmap = new Map<String,Product_Search__c>();
|
List<Product_Search__c> pss = new List<Product_Search__c>();
|
for(Product_Search__c p : ps)
|
{
|
psmap.put(p.Product__c,p);
|
}
|
|
for(Product2 p2 : newList)
|
{
|
Product_Search__c p2s;
|
if(psmap.containsKey(p2.id))
|
{
|
p2s = psmap.get(p2.id);
|
}
|
else
|
{
|
p2s = new Product_Search__c();
|
}
|
|
p2s.Name = p2.Name;
|
p2s.Product__c = p2.id;
|
p2s.CurrencyIsoCode = p2.CurrencyIsoCode;
|
pss.add(p2s);
|
}
|
System.debug('psssize' + pss.size());
|
upsert(pss);
|
}else if(Trigger.isDelete)
|
{
|
for(Product2 en : newList)
|
{
|
en.addError('此数据不能删除');
|
}
|
}
|
}
|
|
public static void checkProduct2Level(List<Product2> newList, Map<Id, Product2> newMap, List<Product2> oldList, Map<Id, Product2> oldMap) {
|
List<String> p2ids = new List<String>();
|
for(Product2 p2 : newList)
|
{
|
p2ids.add(p2.id);
|
}
|
|
//存放查找的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
|
from Product_Register_Link__c
|
where Product2__r.Id in : p2ids];
|
System.debug('pro2List='+pro2List);
|
//存放产品的id和等级类别字段的值的集合
|
Map<Id,List<String>> pro2Map = new Map<Id,List<String>>();
|
//存放注册证上最前的维护日,一类证优先,否则二类证。
|
Map<Id,Date> prSteMap = new Map<Id,Date>();
|
if (pro2List.size()>0) {
|
for (Product_Register_Link__c prl: pro2List) {
|
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') {
|
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);
|
}
|
}
|
}
|
|
for (Product_Register_Link__c prl: pro2List) {
|
if (prSteMap.get(prl.Product2__r.Id) == null) {
|
if (prSteMap.containsKey(prl.Product2__r.Id) && (prl.Product_Register__r.MedPrdClass__c == '2' || prl.Product_Register__r.MedPrdClass__c == '3')) {
|
if (prSteMap.containsKey(prl.Product2__r.Id) && prl.Product_Register__r.Stelsedag__c != null) {
|
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);
|
}
|
}
|
}
|
}
|
}
|
|
//存放产品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>();
|
System.debug('pro2Map='+pro2Map);
|
System.debug('prSteMap='+prSteMap);
|
|
//通过上面的循环，把关系表过获取的数据读出来，传给map
|
if (pro2Map.size()>0) {
|
for (Product_Register_Link__c pr: pro2List) {
|
if (pro2Map.containsKey(pr.Product2__r.Id) && prSteMap.containsKey(pr.Product2__r.Id)) {
|
if (newMap.get(pr.Product2__r.Id).demoteer_Sap__c <> null && pr.Product2__r.Diedatvanink__c <> null) {
|
if (pr.Product_Register__r.Stelsedag__c <> null) {
|
if (pr.Product2__r.Diedatvanink__c <= pr.Product_Register__r.Stelsedag__c) {
|
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');
|
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 (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')) {
|
System.debug('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 {
|
System.debug('非');
|
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 > pr.Product_Register__r.Stelsedag__c) {
|
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) {
|
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 (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') {
|
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);
|
|
//给产品上的等级类别字段赋值
|
for (Product2 pr2: newList) {
|
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 = '二类';
|
}else if (prlMap.get(pr2.Id).contains('一类') && !prlMap.get(pr2.Id).contains('二类')) {
|
pr2.Level_Category__c = '一类';
|
}else if (prlMap.get(pr2.Id).contains('非监管') && !prl2Map.containsKey(pr2.Id)) {
|
pr2.Level_Category__c = '非监管';
|
}else {
|
pr2.Level_Category__c = null;
|
}
|
}
|
if (prl1Map.containsKey(pr2.Id)) {
|
if (prl1Map.get(pr2.Id).contains('一类')) {
|
pr2.Level_Category__c = '一类';
|
}else if (prl1Map.get(pr2.Id).contains('二类') && !prl1Map.get(pr2.Id).contains('一类')) {
|
pr2.Level_Category__c = '二类';
|
}else if (prl1Map.get(pr2.Id).contains('非监管') && !prl2Map.containsKey(pr2.Id)) {
|
pr2.Level_Category__c = '非监管';
|
}else {
|
pr2.Level_Category__c = null;
|
}
|
}
|
if (pr2.demoteer_Sap__c == null || pr2.Diedatvanink__c == null) {
|
pr2.Level_Category__c = null;
|
}
|
System.debug('pr2.Level_Category__c='+pr2.Level_Category__c);
|
}
|
}
|
}
|
