public without sharing class Product2Handler extends Oly_TriggerHandler {
|
private Map<Id, Product2> newMap;
|
private Map<Id, Product2> oldMap;
|
private List<Product2> newList;
|
private List<Product2> oldList;
|
|
public Product2Handler() {
|
this.newMap = (Map<Id, Product2>) Trigger.newMap;
|
this.oldMap = (Map<Id, Product2>) Trigger.oldMap;
|
this.newList = (List<Product2>) Trigger.new;
|
this.oldList = (List<Product2>) Trigger.old;
|
}
|
|
protected override void beforeInsert() {
|
beforeSetValue();
|
// SWAG-BHE9GK LHJ 竞争对手产品自动编码 Start
|
SetCompetitorCode();
|
// SWAG-BHE9GK LHJ 竞争对手产品自动编码 End
|
// WLIG-CKKA4M xxf 【委托】【产品主数据】注册证更新后部分字段信息未自动代入 Start
|
AutomaticallyBringData();
|
// WLIG-CKKA4M xxf 【委托】【产品主数据】注册证更新后部分字段信息未自动代入 End
|
}
|
protected override void beforeUpdate() {
|
beforeSetValue();
|
//SFDC停止预警 lt 20211015 add start
|
// FlgStopManufacure(this.newList, this.oldMap);
|
//SFDC停止预警 lt 20211015 add end
|
FlgStopManufacure();
|
|
}
|
|
//SFDC停止预警 lt 20210922 add start
|
protected override void afterUpdate(){
|
Calculate_AverageMonthSales(this.newList, this.oldMap);
|
}
|
//SFDC停止预警 lt 20210922 add end
|
|
// SWAG-BHE9GK LHJ 竞争对手产品自动编码 Start
|
private void SetCompetitorCode() {
|
Boolean SelctFlg = False;
|
list<AggregateResult> proList;
|
//带量采购修改 start fy
|
list<AggregateResult> proListsc;
|
//带量采购修改 end fy
|
String strPC = '';
|
//带量采购修改 start fy
|
String strPCsc = '';
|
//带量采购修改 end fy
|
Integer i = 1;
|
|
String ProductRecordTypes = System.Label.ProductRecordTypeID;
|
String[] RecordTypes = String.isNotBlank(ProductRecordTypes) ? ProductRecordTypes.split(',') : null;
|
|
for (Product2 nObj : newList) {
|
//带量采购修改 start fy
|
String RecordTypeString = '';
|
if(nObj.RecordTypeId!=null){
|
RecordTypeString=String.valueof(nObj.RecordTypeId).substring(0,15);
|
}
|
// nObj.Competitor_product_dummy__c=System.Label.ProductRecordTypeID.contains(RecordTypeString);
|
// if (nObj.Competitor_product_dummy__c) {
|
if (System.Label.ProductRecordTypeID.contains(RecordTypeString)) {
|
SelctFlg = True;
|
}
|
//带量采购修改 end fy
|
}
|
if (SelctFlg) {
|
proList = [Select Max(ProductCode) PC From Product2 Where ProductCode Like 'SD%' and ProductCode!='SD999999'];
|
if (proList != null && proList.size() > 0) {
|
strPC = String.valueof(proList[0].get('PC'));
|
}
|
//带量采购 start fy
|
proListsc = [Select Max(ProductCode) PC From Product2 Where ProductCode Like 'SC%'];
|
if (proListsc != null && proListsc.size() > 0) {
|
strPCsc = String.valueof(proListsc[0].get('PC'));
|
}
|
//带量采购 end fy
|
}
|
for (Product2 nObj : newList) {
|
//带量采购 start fy
|
String RecordTypeString = '';
|
if(nObj.RecordTypeId!=null){
|
RecordTypeString=String.valueof(nObj.RecordTypeId).substring(0,15);
|
}
|
// if (nObj.Competitor_product_dummy__c && strPC.length() == 8
|
// if (System.Label.ProductRecordTypeID.contains(RecordTypeString) && strPC.length() == 8
|
if (System.Label.ProductRecordTypeID.contains(RecordTypeString)) {
|
//带量采购 end fy
|
// && proList != null && proList.size() > 0 ) {
|
// Integer num = Integer.valueOf(strPC.SubString(2,strPC.length())) + i;
|
Integer num = String.isNotBlank(strPC) ? Integer.valueOf(strPC.SubString(2,strPC.length())) + i : i;
|
//带量采购 start fy
|
Integer numsc = String.isNotBlank(strPCsc) ? Integer.valueOf(strPCsc.SubString(2,strPCsc.length())) + i : i;
|
// if(RecordTypeString=='0129D000001NacC'){
|
if(RecordTypes != null && RecordTypes.size() > 1 && RecordTypeString == RecordTypes[1]){
|
nObj.ProductCode = 'SC' + String.valueOf(numsc).leftpad(8,'0');
|
}else{
|
nObj.ProductCode = 'SD' + String.valueOf(num).leftpad(6,'0');
|
}
|
//带量采购 end fy
|
// nObj.ProductCode = 'SD' + String.valueOf(num).leftpad(6,'0');
|
i++;
|
}
|
}
|
}
|
// SWAG-BHE9GK LHJ 竞争对手产品自动编码 End
|
|
|
//WLIG-CKKA4M xxf 【委托】【产品主数据】注册证更新后部分字段信息未自动代入 Start
|
private void AutomaticallyBringData() {
|
List<String> noNewList = new List<String>();
|
for(Product2 prd : newList){
|
if (prd.Asset_Model_No__c != null) {
|
noNewList.add(prd.Asset_Model_No__c);
|
}
|
}
|
if (!noNewList.isEmpty()) {
|
|
List<Product2> prdList = [select Id, Name,Asset_Model_No__c,MDM_Name__c,
|
Maintenance_Price_Year__c,Extend_new_product_gurantee_MD__c,
|
Extend_Gurantee_Start_MD__c,Extend_Gurantee_End_MD__c,
|
Entend_gurantee_period_MD__c,Extend_new_product_gurantee__c,
|
Extend_Gurantee_Start__c,Extend_Gurantee_End__c,Entend_gurantee_period__c,
|
CanNotCancelledGurantee__c,Service_Category1__c,
|
Service_Category2__c,Service_Category3__c,
|
Service_Category4__c,Service_Category5__c,
|
Service_Category6__c,Service_Category7__c,
|
Can_Repair__c,RepairListPriceLevelA__c,
|
RepairListPriceLevelB__c,RepairListPriceLevelC__c,
|
PartSupplyFinishDate__c,EndSaleDate__c,ProductClass__c,ProductCategory__c,
|
Period_Filter_Classify1__c,Period_Filter_Classify2__c,Period_Filter_Classify3__c,
|
Intra_Trade_Service_RMB_Date1__c,Intra_Trade_Service_RMB_Date2__c,
|
Intra_Trade_Service_RMB_EndDate1__c,Intra_Trade_Service_RMB_EndDate2__c,
|
Intra_Trade_Service_RMB_1__c,Intra_Trade_Service_RMB_2__c
|
from Product2
|
where Asset_Model_No__c in :noNewList
|
order by CreatedDate desc];
|
if (prdList.isEmpty()) {
|
return;
|
}
|
Map<String, Product2> prdMap = new Map<String, Product2>();
|
for (Product2 pro2 : prdList) {
|
if (!prdMap.isEmpty() && prdMap.containskey(pro2.Asset_Model_No__c)) {
|
} else {
|
prdMap.put(pro2.Asset_Model_No__c, pro2);
|
}
|
}
|
|
for(Product2 prd : newList){
|
if (prdMap.containskey(prd.Asset_Model_No__c)){
|
prd.Maintenance_Price_Year__c = prdMap.get(prd.Asset_Model_No__c).Maintenance_Price_Year__c;//维修合同报价
|
prd.CanNotCancelledGurantee__c = prdMap.get(prd.Asset_Model_No__c).CanNotCancelledGurantee__c;//不可取消多年保修
|
prd.ProductClass__c = prdMap.get(prd.Asset_Model_No__c).ProductClass__c;//市场产品类别
|
prd.ProductCategory__c = prdMap.get(prd.Asset_Model_No__c).ProductCategory__c;//市场区分
|
prd.Extend_new_product_gurantee_MD__c = prdMap.get(prd.Asset_Model_No__c).Extend_new_product_gurantee_MD__c;//市场保修对象
|
prd.Extend_new_product_gurantee__c = prdMap.get(prd.Asset_Model_No__c).Extend_new_product_gurantee__c;//服务保修对象
|
if (prdMap.get(prd.Asset_Model_No__c).Extend_new_product_gurantee_MD__c == true) {//市场保修对象
|
prd.Entend_gurantee_period_MD__c = prdMap.get(prd.Asset_Model_No__c).Entend_gurantee_period_MD__c;//市场保修期(年)
|
}
|
if(prdMap.get(prd.Asset_Model_No__c).Extend_new_product_gurantee__c == true){//服务保修对象
|
prd.Entend_gurantee_period__c = prdMap.get(prd.Asset_Model_No__c).Entend_gurantee_period__c;//服务保修期(年)
|
}
|
prd.Extend_Gurantee_Start_MD__c = prdMap.get(prd.Asset_Model_No__c).Extend_Gurantee_Start_MD__c;//市场保修开始日
|
prd.Extend_Gurantee_End_MD__c = prdMap.get(prd.Asset_Model_No__c).Extend_Gurantee_End_MD__c;//市场保修结束日
|
prd.Extend_Gurantee_Start__c = prdMap.get(prd.Asset_Model_No__c).Extend_Gurantee_Start__c;//服务保修开始日
|
prd.Extend_Gurantee_End__c = prdMap.get(prd.Asset_Model_No__c).Extend_Gurantee_End__c;//服务保修结束日
|
prd.Service_Category1__c = prdMap.get(prd.Asset_Model_No__c).Service_Category1__c;//第1服务分类
|
prd.Service_Category2__c = prdMap.get(prd.Asset_Model_No__c).Service_Category2__c;
|
prd.Service_Category3__c = prdMap.get(prd.Asset_Model_No__c).Service_Category3__c;
|
prd.Service_Category4__c = prdMap.get(prd.Asset_Model_No__c).Service_Category4__c;
|
prd.Service_Category5__c = prdMap.get(prd.Asset_Model_No__c).Service_Category5__c;
|
prd.Service_Category6__c = prdMap.get(prd.Asset_Model_No__c).Service_Category6__c;
|
prd.Service_Category7__c = prdMap.get(prd.Asset_Model_No__c).Service_Category7__c;
|
prd.Can_Repair__c = prdMap.get(prd.Asset_Model_No__c).Can_Repair__c;//是否可维修
|
prd.RepairListPriceLevelA__c = prdMap.get(prd.Asset_Model_No__c).RepairListPriceLevelA__c;//A（W）级维修参考价格
|
prd.RepairListPriceLevelB__c = prdMap.get(prd.Asset_Model_No__c).RepairListPriceLevelB__c;
|
prd.RepairListPriceLevelC__c = prdMap.get(prd.Asset_Model_No__c).RepairListPriceLevelC__c;
|
prd.PartSupplyFinishDate__c = prdMap.get(prd.Asset_Model_No__c).PartSupplyFinishDate__c;//零件停止供应日期
|
prd.EndSaleDate__c = prdMap.get(prd.Asset_Model_No__c).EndSaleDate__c;//停止销售日期
|
prd.Period_Filter_Classify1__c = prdMap.get(prd.Asset_Model_No__c).Period_Filter_Classify1__c;//营业统计分类1
|
prd.Period_Filter_Classify2__c = prdMap.get(prd.Asset_Model_No__c).Period_Filter_Classify2__c;//营业统计分类2
|
prd.Period_Filter_Classify3__c = prdMap.get(prd.Asset_Model_No__c).Period_Filter_Classify3__c;//营业统计分类3
|
prd.Intra_Trade_Service_RMB_Date1__c = prdMap.get(prd.Asset_Model_No__c).Intra_Trade_Service_RMB_Date1__c;//多年保价格有效开始日1
|
prd.Intra_Trade_Service_RMB_Date2__c = prdMap.get(prd.Asset_Model_No__c).Intra_Trade_Service_RMB_Date2__c;//多年保价格有效开始日2
|
prd.Intra_Trade_Service_RMB_EndDate1__c = prdMap.get(prd.Asset_Model_No__c).Intra_Trade_Service_RMB_EndDate1__c;//多年保价格有效结束日1
|
prd.Intra_Trade_Service_RMB_EndDate2__c = prdMap.get(prd.Asset_Model_No__c).Intra_Trade_Service_RMB_EndDate2__c;//多年保价格有效结束日2
|
prd.Intra_Trade_Service_RMB_1__c = prdMap.get(prd.Asset_Model_No__c).Intra_Trade_Service_RMB_1__c;//多年保价格1
|
prd.Intra_Trade_Service_RMB_2__c = prdMap.get(prd.Asset_Model_No__c).Intra_Trade_Service_RMB_2__c;//多年保价格2
|
}
|
}
|
}
|
|
}
|
// WLIG-CKKA4M xxf 【委托】【产品主数据】注册证更新后部分字段信息未自动代入 end
|
|
private void beforeSetValue() {
|
|
for (Product2 nObj : newList) {
|
//CHAN-B8GCBB
|
if (nObj.WhiteSpace__c == true) {
|
nObj.StorageStatus__c = String.valueOf(nObj.StorageStatusNo__c);
|
} else {
|
nObj.StorageStatus__c = '';
|
}
|
//CHAN-B8GCBB
|
|
nObj.Fixture_Model_No_T__c = nObj.Fixture_Model_No_F__c;
|
// CBPR LHJ
|
if (Trigger.isInsert ||
|
(Trigger.isUpdate && nObj.SFDA_Status_New__c != oldMap.get(nObj.id).SFDA_Status_New__c)) {
|
nObj.SFDA_Status__c = nobj.SFDA_Status_New__c;
|
if (nobj.SFDA_Status_New__c == '新製品申請中' || nobj.SFDA_Status_New__c == '準備中') {
|
nObj.SFDA_Status__c = '停止';
|
}
|
}
|
// CBPR LHJ
|
|
// SWAG-BHE9GK LHJ 竞争对手产品自动编码 Start
|
if (Trigger.isInsert) {
|
|
}
|
// SWAG-BHE9GK LHJ 竞争对手产品自动编码 End
|
}
|
}
|
|
//SFDC停止预警 lt 20210914 add start
|
private static void Calculate_AverageMonthSales(List<Product2> newList,Map<Id, Product2> oldMap){
|
|
//符合条件的 旧 产品List
|
List<Id> oproList = new List<Id>();
|
//符合条件的 新旧 产品Id List 作为条件
|
List<Id> conList = new List<Id>();
|
//Map<旧的，新的>对应
|
Map<String,String> matMap = new Map<String,String>();
|
|
//Map<旧Id，预计停止日>
|
Map<String,Date> adateMap = new Map<String,Date>();
|
|
//Map<旧Id, x(平均月销量)>
|
Map<String,Integer> xMap = new Map<String,Integer>();
|
//Map<旧Id, z(天数)>
|
Map<String,Integer> zMap = new Map<String,Integer>();
|
|
for(Product2 term : newList){
|
System.debug('标识'+term.CalMonthSalesFLG__c);
|
System.debug('新库存'+term.StorageStatusNo__c);
|
System.debug('旧库存'+oldMap.get(term.Id).StorageStatusNo__c);
|
if(term.M_BC_Stop_manufacure__c != null && term.SFDA_Status__c != '停止' && (term.StorageStatusNo__c != oldMap.get(term.Id).StorageStatusNo__c || term.CalMonthSalesFLG__c == true)){
|
if(term.Correspond_Code__c != null){
|
matMap.put((String)term.Id,(String)term.Correspond_Code__c);
|
conList.add(term.Correspond_Code__c);
|
}
|
conList.add(term.Id);
|
oproList.add(term.Id);
|
|
adateMap.put(term.Id, term.M_BC_Stop_manufacure__c);
|
}
|
}
|
|
//做 一对多 的 Map<String,List<月销量>>
|
Map<String,List<ProductMonthlySales__c>> msMap = new Map<String,List<ProductMonthlySales__c>>();
|
|
if(conList.size()>0){
|
List<ProductMonthlySales__c> msList = [Select Id, MonthSales__c, CurrentMonth__c, CurrentDate__c,
|
CurrentYear__c, ProductM__c, Product2Model__c,
|
ProductM__r.StorageStatusNo__c,
|
ProductM__r.M_BC_Stop_manufacure__c
|
From ProductMonthlySales__c
|
Where ProductM__c in: conList
|
Order by CurrentDate__c DESC];
|
//双层循环 产品==>月销量
|
for(Id pro : conList){
|
for(ProductMonthlySales__c mms : msList){
|
if(pro == mms.ProductM__c){
|
if(msMap.containsKey(pro)){
|
msMap.get(pro).add(mms);
|
}else{
|
List<ProductMonthlySales__c> pmsaleList = new List<ProductMonthlySales__c>();
|
pmsaleList.add(mms);
|
msMap.put(pro, pmsaleList);
|
}
|
}
|
|
}
|
}
|
|
System.debug('条件List'+conList);
|
System.debug('sql查到的List'+msList);
|
System.debug('产品月销量msMap为'+msMap);
|
System.debug('旧的产品List'+oproList);
|
|
if(msMap.size() > 0){
|
System.debug('产品月销量msMap为'+msMap);
|
for(Id res : oproList){
|
|
//a旧 月销量和 ; b新 月销量和 ; c商(平均月销量) ; x商四舍五入 ;
|
//y 库存/平均月销量天数 ; z 天数 四舍五入
|
Decimal c = 0, y = 0;
|
Integer x = 0, z = 0;
|
|
if(msMap.get(res) != null){
|
//月销量大于12个月
|
if(msMap.get(res).size() >= 12){
|
Decimal a = 0 , b = 0;
|
Integer i;
|
for(i = 0 ; i < 12 ; i++){
|
a += msMap.get(res)[i].MonthSales__c;
|
}
|
if(matMap.get(res) != null){
|
if(msMap.get(matMap.get(res)) != null){
|
if(msMap.get(matMap.get(res)).size() >= 12){
|
for(i = 0 ; i < 12 ; i++){
|
b += msMap.get(matMap.get(res))[i].MonthSales__c;
|
System.debug('新的大于十二'+b);
|
}
|
}
|
else{
|
for(ProductMonthlySales__c nms : msMap.get(matMap.get(res))){
|
b+=nms.MonthSales__c;
|
System.debug('新的小于十二遍历全部'+b);
|
}
|
|
}
|
}
|
}
|
|
//四舍五入
|
c = (a + b) / 12 ;
|
|
if(c > 1){
|
x = Integer.valueOf(c.round(System.RoundingMode.HALF_UP));
|
xMap.put(res,x);
|
}else if(c > 0){
|
x = 1;
|
xMap.put(res,x);
|
}
|
//x = Integer.valueOf(c.round(System.RoundingMode.Up));
|
//x = Integer.valueOf(c.round(System.RoundingMode.HALF_UP));
|
|
System.debug('新'+b);
|
System.debug('旧'+a);
|
System.debug('除法足c'+c);
|
System.debug('四舍五入x'+x);
|
|
}
|
//月销量不足12个月
|
else{
|
Decimal a = 0 , b = 0 ;
|
for(ProductMonthlySales__c oms : msMap.get(res)){
|
a+=oms.MonthSales__c;
|
}
|
if(msMap.get(matMap.get(res)) != null){
|
for(ProductMonthlySales__c nms : msMap.get(matMap.get(res))){
|
b+=nms.MonthSales__c;
|
}
|
}
|
c = (a + b) / msMap.get(res).size();
|
//x = Integer.valueOf(c.round(System.RoundingMode.UP));
|
//x = Integer.valueOf(c.round(System.RoundingMode.HALF_UP));
|
if(c > 1){
|
x = Integer.valueOf(c.round(System.RoundingMode.HALF_UP));
|
xMap.put(res,x);
|
}else if(c > 0){
|
x = 1;
|
xMap.put(res,x);
|
}
|
|
System.debug('除法不足12c'+c);
|
System.debug('四舍五入x'+x);
|
}
|
|
if(x != 0){
|
for(ProductMonthlySales__c dat : msMap.get(res)){
|
Decimal m = 0;
|
if(dat.ProductM__r.StorageStatusNo__c != null){
|
m = dat.ProductM__r.StorageStatusNo__c;
|
}
|
y = m / x;
|
y = y * 30 ;
|
}
|
}
|
//z = Integer.valueOf(y.round(System.RoundingMode.UP));
|
z = Integer.valueOf(y.round(System.RoundingMode.HALF_UP));
|
zMap.put(res,z);
|
System.debug('天数y'+y);
|
System.debug('四舍五入z'+z);
|
|
}
|
}
|
}
|
|
List<Product2> finList = new List<Product2>();
|
for(Id fin : oproList){
|
Product2 fip = new Product2();
|
fip.Id = fin;
|
fip.CalMonthSalesFLG__c = false;
|
|
if(xMap.get(fin) != null){
|
fip.Average_MonthSales__c = xMap.get(fin);
|
}
|
|
//20211020
|
if(zMap.get(fin) != null){
|
if(zMap.get(fin) != 0){
|
fip.Estimated_ConsumptionDueDate__c = Date.today().addDays(zMap.get(fin));
|
}else{
|
if(adateMap != null){
|
Date adate = adateMap.get(fin);
|
fip.Estimated_ConsumptionDueDate__c = adate;
|
}
|
}
|
}else{
|
if(adateMap != null){
|
Date adate = adateMap.get(fin);
|
fip.Estimated_ConsumptionDueDate__c = adate;
|
}
|
}
|
//20211020
|
|
finList.add(fip);
|
}
|
update finList;
|
}
|
|
}
|
//SFDC停止预警 lt 20210914 add end
|
|
//SFDC停止预警 lt 20211015 add start
|
//ProductMonthlySalesFlag__c 12月销量标识 预计停止日期(M_BC_Stop_manufacure__c)变化时
|
// private static void FlgStopManufacure(List<Product2> newList,Map<Id, Product2> oldMap){
|
// if(newList != null){
|
// for(Product2 pts : newList){
|
// if(oldMap != null){
|
// if(pts.M_BC_Stop_manufacure__c != null && oldMap.get(pts.Id).M_BC_Stop_manufacure__c == null){
|
// pts.ProductMonthlySalesFlag__c = true;
|
// }
|
// if(pts.M_BC_Stop_manufacure__c != null && oldMap.get(pts.Id).M_BC_Stop_manufacure__c != null && pts.M_BC_Stop_manufacure__c != oldMap.get(pts.Id).M_BC_Stop_manufacure__c){
|
// pts.ProductMonthlySalesFlag__c = true;
|
// }
|
// if(pts.M_BC_Stop_manufacure__c == null && oldMap.get(pts.Id).M_BC_Stop_manufacure__c != null){
|
// pts.ProductMonthlySalesFlag__c = false;
|
// pts.Estimated_ConsumptionDueDate__c = null;
|
// }
|
// }
|
// }
|
// }
|
|
// }
|
//SFDC停止预警 lt 20211015 add end
|
private void FlgStopManufacure(){
|
for(Product2 pts : newList){
|
|
Product2 oldPts = oldMap.get(pts.Id);
|
|
if(pts.M_BC_Stop_manufacure__c != oldPts.M_BC_Stop_manufacure__c){
|
pts.ProductMonthlySalesFlag__c = true;
|
if (pts.M_BC_Stop_manufacure__c == null) {
|
pts.ProductMonthlySalesFlag__c = false;
|
pts.Estimated_ConsumptionDueDate__c = null;
|
}
|
}
|
|
if(pts.SFDA_Status__c == '停止' && oldPts.SFDA_Status__c != '停止'){
|
pts.Estimated_ConsumptionDueDate__c = null;
|
}
|
}
|
}
|
|
}
|
