public with sharing class VirtualDealerToTmsBatch implements Database.Batchable<sObject>{
|
String query;
|
public VirtualDealerToTmsBatch() {
|
|
}
|
|
public Database.QueryLocator start(Database.BatchableContext BC) {
|
query = 'select id,name,Target_Source__c,CloseDate, Amount, Opportunity_Category__c ,RecordType.DeveloperName,OCM_Target_period_New__c,Objective_Tax__c,Shipping_Date_For_Report__c from Opportunity where Target_category__c = \'省目标\' And OCM_Target_period__c = \'156P\' and Opportunity_Category__c = \'ET\' and RecordType.name = \'目標\'';
|
|
return Database.getQueryLocator(query);
|
}
|
|
|
public void execute(Database.BatchableContext BC, List<Opportunity> OppoList) {
|
List<String> dealerNameList = new List<String>();
|
Map<String,String> dealerlocationList = new Map<String,String>();
|
Map<String,id> dealerNameList2 = new Map<String,id>();
|
Set<String> dealerNamemap = new Set<String>();
|
List<Dealer_ConsumableManage__c> dcmList = new List<Dealer_ConsumableManage__c>();
|
List<Dealer_ConsumableManage__c> dcmList2 = new List<Dealer_ConsumableManage__c>();
|
for (Opportunity opp : OppoList) {
|
// String year = opp.OCM_Target_period_New__c.split('FY')[1];
|
Integer year = opp.Shipping_Date_For_Report__c.year();
|
String OCM;
|
Integer Month = opp.Shipping_Date_For_Report__c.month();
|
if (Month>=1 && Month<4) {
|
|
OCM = 'FY'+year;
|
}else {
|
OCM = 'FY'+(year+1);
|
}
|
if (Double.valueOf(year)>=2023) {
|
system.debug('year:'+year);
|
system.debug('Month:'+Month);
|
integer startIndex = opp.name.indexOf(':');
|
|
String dealerName = opp.name.substring(startIndex+2, startIndex+5);
|
if (!dealerNameList.contains(dealerName)) {
|
dealerNameList.add(dealerName);
|
}
|
String key = dealerName+':'+opp.Opportunity_Category__c+':'+OCM+':'+opp.Objective_Tax__c+':'+Month;
|
dealerNamemap.add(key);
|
}
|
|
}
|
// 虚拟经销商
|
List<account> accList =[select id,name,OCM_man_province_HP__c from Account where ISVirtualDealer__c = true];
|
for (account acc : accList) {
|
for(String deName:dealerNameList)
|
if (acc.name.indexOf(deName) != -1 && !dealerNameList2.containsKey(deName)) {
|
dealerNameList2.put(deName,acc.id);
|
dealerlocationList.put(acc.id,acc.OCM_man_province_HP__c);
|
}
|
}
|
System.debug('dealerNameList='+dealerNameList);
|
System.debug('dealerNameList2='+dealerNameList2);
|
List<Dealer_ConsumableManage__c> dcList = [select id ,ET_ENG__c,FY__c,Dealer_Name__c,Dealer_Name__r.name from Dealer_ConsumableManage__c where Dealer_Name__c in :dealerNameList2.values() ];
|
for (Dealer_ConsumableManage__c dc : dcList) {
|
for (String key : dealerNamemap) {
|
String name = key.split(':')[0];
|
String oc = key.split(':')[1];
|
String otp = key.split(':')[2];
|
String Amount = key.split(':')[3];
|
String Month = key.split(':')[4];
|
if (dc.Dealer_Name__r.name.indexOf(name)!=-1) {
|
if (dc.ET_ENG__c == 'ET' && oc =='ET' && dc.FY__c == otp) {
|
Dealer_ConsumableManage__c dcm = new Dealer_ConsumableManage__c();
|
dcm.id = dc.id;
|
if (Month=='1') {
|
dcm.FY_P_1__c = Double.valueOf(Amount);
|
}
|
if (Month=='10') {
|
dcm.FY_P_10__c = Double.valueOf(Amount);
|
}
|
if (Month=='11') {
|
dcm.FY_P_11__c = Double.valueOf(Amount);
|
}
|
if (Month=='12') {
|
dcm.FY_P_12__c = Double.valueOf(Amount);
|
}
|
if (Month=='2') {
|
dcm.FY_P_2__c = Double.valueOf(Amount);
|
}
|
if (Month=='3') {
|
dcm.FY_P_3__c = Double.valueOf(Amount);
|
}
|
if (Month=='4') {
|
dcm.FY_P_4__c = Double.valueOf(Amount);
|
}
|
if (Month=='5') {
|
dcm.FY_P_5__c = Double.valueOf(Amount);
|
}
|
if (Month=='6') {
|
dcm.FY_P_6__c = Double.valueOf(Amount);
|
}
|
if (Month=='7') {
|
dcm.FY_P_7__c = Double.valueOf(Amount);
|
}
|
if (Month=='8') {
|
dcm.FY_P_8__c = Double.valueOf(Amount);
|
}
|
if (Month=='9') {
|
dcm.FY_P_9__c = Double.valueOf(Amount);
|
}
|
dcmList.add(dcm);
|
dealerNamemap.remove(key);
|
}
|
if (dc.ET_ENG__c == 'ENG2' && oc =='ENG' && dc.FY__c == otp) {
|
Dealer_ConsumableManage__c dcm = new Dealer_ConsumableManage__c();
|
dcm.id = dc.id;
|
if (Month=='1') {
|
dcm.FY_P_1__c = Double.valueOf(Amount);
|
}
|
if (Month=='10') {
|
dcm.FY_P_10__c = Double.valueOf(Amount);
|
}
|
if (Month=='11') {
|
dcm.FY_P_11__c = Double.valueOf(Amount);
|
}
|
if (Month=='12') {
|
dcm.FY_P_12__c = Double.valueOf(Amount);
|
}
|
if (Month=='2') {
|
dcm.FY_P_2__c = Double.valueOf(Amount);
|
}
|
if (Month=='3') {
|
dcm.FY_P_3__c = Double.valueOf(Amount);
|
}
|
if (Month=='4') {
|
dcm.FY_P_4__c = Double.valueOf(Amount);
|
}
|
if (Month=='5') {
|
dcm.FY_P_5__c = Double.valueOf(Amount);
|
}
|
if (Month=='6') {
|
dcm.FY_P_6__c = Double.valueOf(Amount);
|
}
|
if (Month=='7') {
|
dcm.FY_P_7__c = Double.valueOf(Amount);
|
}
|
if (Month=='8') {
|
dcm.FY_P_8__c = Double.valueOf(Amount);
|
}
|
if (Month=='9') {
|
dcm.FY_P_9__c = Double.valueOf(Amount);
|
}
|
dcmList.add(dcm);
|
dealerNamemap.remove(key);
|
}
|
}
|
}
|
}
|
for (String key : dealerNamemap) {
|
String name = key.split(':')[0];
|
String oc = key.split(':')[1];
|
String otp = key.split(':')[2];
|
String Amount = key.split(':')[3];
|
String Month = key.split(':')[4];
|
if (dealerNameList2.get(name) !=null) {
|
Dealer_ConsumableManage__c dcm = new Dealer_ConsumableManage__c();
|
if (oc=='ET') {
|
dcm.ET_ENG__c = oc;
|
}
|
if (oc=='ENG2') {
|
dcm.ET_ENG__c = 'ENG';
|
}
|
if (Month=='1') {
|
dcm.FY_P_1__c = Double.valueOf(Amount);
|
}
|
if (Month=='10') {
|
dcm.FY_P_10__c = Double.valueOf(Amount);
|
}
|
if (Month=='11') {
|
dcm.FY_P_11__c = Double.valueOf(Amount);
|
}
|
if (Month=='12') {
|
dcm.FY_P_12__c = Double.valueOf(Amount);
|
}
|
if (Month=='2') {
|
dcm.FY_P_2__c = Double.valueOf(Amount);
|
}
|
if (Month=='3') {
|
dcm.FY_P_3__c = Double.valueOf(Amount);
|
}
|
if (Month=='4') {
|
dcm.FY_P_4__c = Double.valueOf(Amount);
|
}
|
if (Month=='5') {
|
dcm.FY_P_5__c = Double.valueOf(Amount);
|
}
|
if (Month=='6') {
|
dcm.FY_P_6__c = Double.valueOf(Amount);
|
}
|
if (Month=='7') {
|
dcm.FY_P_7__c = Double.valueOf(Amount);
|
}
|
if (Month=='8') {
|
dcm.FY_P_8__c = Double.valueOf(Amount);
|
}
|
if (Month=='9') {
|
dcm.FY_P_9__c = Double.valueOf(Amount);
|
}
|
dcm.FY__c = otp;
|
String deid = dealerNameList2.get(name);
|
dcm.TMS_Key__c = dealerNameList2.get(name)+'-'+dcm.ET_ENG__c+'-'+dcm.FY__c+'-'+dealerlocationList.get(deid);
|
dcm.Dealer_Name__c = dealerNameList2.get(name);
|
// dcm.Dealer_Name_Account__c = dealerNameList2.get(name);
|
if (!dcmList2.contains(dcm)) {
|
dcmList2.add(dcm);
|
}
|
}
|
|
|
}
|
System.debug('dcmList='+dcmList);
|
System.debug('dcmList2='+dcmList2);
|
if (dcmList.size()>0) {
|
update dcmList;
|
}
|
if (dcmList2.size()>0) {
|
insert dcmList2;
|
}
|
}
|
|
public void finish(Database.BatchableContext BC) {
|
|
}
|
}
|
