/************************************************************************************************** @Author: 黄千龙 @Name: EquipmentCoverageTargetBatch @CreateDate: 22/03/2022 @Description: 是否续签率目标(分母) @Version 1.0 *****************************************************************************************************/ global class EquipmentRenewTargetBatch implements Database.Batchable,Database.Stateful { public String query; public Date toDayTime = Date.today(); public String OCSM_Period_half; public String OCSM_Period = 'FY'+toDayTime.year(); private BatchIF_Log__c iflog; public Date egdTime; public List < String > mcList; global EquipmentRenewTargetBatch() { this.query = query; } global EquipmentRenewTargetBatch(List < String > mcList) { this.query = query; this.mcList = mcList; } global Database.QueryLocator start(Database.BatchableContext bc) { iflog = new BatchIF_Log__c(); iflog.Type__c = 'PushNotification'; iflog.Log__c = 'EquipmentRenewTargetBatch start\n'; iflog.ErrorLog__c = ''; insert iflog; if (toDayTime.month() >= 4 && toDayTime.month() <= 9) { OCSM_Period_half = '1H'; }else{ OCSM_Period_half = '2H'; } egdTime = Date.newInstance(toDayTime.year()+1,3,1); if (mcList != null && mcList.size() > 0) { // 保有设备不为零件停产 query ='select id,Asset__c,Asset__r.Hospital__c,Asset__r.Product2.ServiceCategory__c ' +' from Maintenance_Contract_Asset__c where IF_NA_MCA__c = \'1\'' + ' and Asset__r.Product2.ServiceCategory__c != null ' +' and Asset__r.IF_StopParts_production__c != \'1\' and Maintenance_Contract__c in :mcList' +' and (Asset__r.Product2.Maintenance_Price_Year__c != 0 and Asset__r.Product2.Maintenance_Price_Year__c != null)'; }else{ query = 'select id,Asset__c,Asset__r.Hospital__c,Asset__r.Product2.ServiceCategory__c ' +' from Maintenance_Contract_Asset__c where IF_NA_MCA__c = \'1\'' + ' and Asset__r.Product2.ServiceCategory__c != null ' +'and Asset__r.IF_StopParts_production__c != \'1\'' +' and (Asset__r.Product2.Maintenance_Price_Year__c != 0 and Asset__r.Product2.Maintenance_Price_Year__c != null)'; } return Database.getQueryLocator(query); } global void execute(Database.BatchableContext BC, list mcaList) { List asots = new List(); List accIds = new List(); List AssetsTarget = new List(); for (Maintenance_Contract_Asset__c mca : mcaList) { if (!accIds.contains(mca.Asset__r.hospital__c)) { accIds.add(mca.Asset__r.hospital__c); } } Map targetMap = new Map(); for(Account_Service_Of_Target__c target:[SELECT Id ,Target_Rigid_Mirror_2__c,Target_Soft_Mirror_2__c,Target_Correlation_Lightsource__c,Account_HP__c,OCSM_Period_half__c FROM Account_Service_Of_Target__c WHERE OCSM_Period_half__c = :OCSM_Period_half AND OCSM_Period__c = :OCSM_Period AND Account_HP__c IN:accIds]){ targetMap.put(target.Account_HP__c,target); } Set accIdSet = new Set(); for (Maintenance_Contract_Asset__c mca : mcaList) { if(!accIdSet.contains(mca.Asset__r.hospital__c)){ if(targetMap.containskey(mca.Asset__r.hospital__c)){ Account_Service_Of_Target__c asot = targetMap.get(mca.Asset__r.hospital__c); asot.Target_Rigid_Mirror_2__c = 0; asot.Target_Soft_Mirror_2__c = 0; asot.Target_Correlation_Lightsource__c = 0; }else{ Account_Service_Of_Target__c asot = new Account_Service_Of_Target__c(); asot.Account_HP__c = mca.Asset__r.hospital__c; asot.Coverage_Target_Account__c = true; asot.Target_Rigid_Mirror_2__c = 0; asot.Target_Soft_Mirror_2__c = 0; asot.Target_Correlation_Lightsource__c = 0; asot.OCSM_Period__c = OCSM_Period; asot.OCSM_Period_half__c = OCSM_Period_half; targetMap.put(mca.Asset__r.hospital__c,asot); } accIdSet.add(mca.Asset__r.hospital__c); } mca.Asset__r.IF_Renewalrate_Target_Asset__c = '1'; if (!AssetsTarget.contains(mca.Asset__r)) { AssetsTarget.add(mca.Asset__r); } if (mca.Asset__r.Product2.ServiceCategory__c == '硬性镜') { targetMap.get(mca.Asset__r.hospital__c).Target_Rigid_Mirror_2__c ++; } if(mca.Asset__r.Product2.ServiceCategory__c =='软性镜'){ targetMap.get(mca.Asset__r.hospital__c).Target_Soft_Mirror_2__c ++; } if (mca.Asset__r.Product2.ServiceCategory__c == '周边') { targetMap.get(mca.Asset__r.hospital__c).Target_Correlation_Lightsource__c ++; } } Oly_TriggerHandler.bypass('AssetTrigger'); Oly_TriggerHandler.bypass('AssetHandlerCheck'); update AssetsTarget; Oly_TriggerHandler.bypass('NFM701ControllerHandler'); Oly_TriggerHandler.bypass('UpdateContractAimAmountHandler'); UpSert targetMap.values(); } global void finish(Database.BatchableContext BC) { iflog.Log__c += '\nEquipmentRenewTargetBatch end'; String tmp = iflog.ErrorLog__c; if (tmp.length() > 65000) { tmp = tmp.substring(0, 65000); tmp += ' ...have more lines...'; iflog.ErrorLog__c = tmp; } update iflog; } }