/************************************************************************************************** @Author: 黄千龙 @Name: EquipmentCoverageTargetBatch @CreateDate: 22/03/2022 @Description: 是否覆盖率实际(分子) @Version 1.0 *****************************************************************************************************/ global class EquipmentRealCoverageRealBatch implements Database.Batchable,Database.Stateful { public String query; public Date start_dateH1 ; public Date end_dateH1 ; public Date toDayTime = Date.today(); private BatchIF_Log__c iflog; public String OCSM_Period_half; public String OCSM_Period = 'FY'+toDayTime.year(); public List < String > accountIdList; global EquipmentRealCoverageRealBatch() { this.query = query; } global EquipmentRealCoverageRealBatch(List < String > accountIdList) { this.query = query; this.accountIdList = accountIdList; } global Database.QueryLocator start(Database.BatchableContext bc) { system.debug('执行start'); iflog = new BatchIF_Log__c(); iflog.Type__c = 'PushNotification'; iflog.Log__c = 'EquipmentRealCoverageBatch start\n'; iflog.ErrorLog__c = ''; insert iflog; if (toDayTime.month() >= 4 && toDayTime.month() <= 9) { OCSM_Period_half = '1H'; }else{ OCSM_Period_half = '2H'; } if (accountIdList != null && accountIdList.size() > 0) { query = 'select id,Hospital__c,IF_Coverage_Target_Asset__c,IF_Coverage_Real_Asset__c,CurrentContract__r.Contract_End_Date__c,CurrentContract__r.Contract_Conclusion_Date__c,Product2.Category4__c,Product2.ServiceCategory__c,Product2.Category3__c from Asset where ' +' IF_StopParts_production__c != \'1\' and CurrentContract__c != null and Hospital__c in :accountIdList' +' and (CurrentContract__r.Contract_End_Date__c >= :start_dateH1 and CurrentContract__r.Contract_Conclusion_Date__c <= :end_dateH1) order by hospital__c'; }else{ query = 'select id,Hospital__c,IF_Coverage_Target_Asset__c,IF_Coverage_Real_Asset__c,CurrentContract__r.Contract_End_Date__c,CurrentContract__r.Contract_Conclusion_Date__c,Product2.Category4__c,Product2.ServiceCategory__c,Product2.Category3__c from Asset where ' +' IF_StopParts_production__c != \'1\' and CurrentContract__c != null' +' and (CurrentContract__r.Contract_End_Date__c >= :start_dateH1 and CurrentContract__r.Contract_Conclusion_Date__c <= :end_dateH1) order by hospital__c'; } // 实际设备合同时间区间1H(4,9);2H(10,3) if (toDayTime.month() >= 4 && toDayTime.month() <= 9) { start_dateH1 = Date.newInstance(toDayTime.year(),9,1); end_dateH1 = Date.newInstance(toDayTime.year(),9,30); }else{ start_dateH1 = Date.newInstance(toDayTime.year(),3,1); end_dateH1 = Date.newInstance(toDayTime.year(),3,31); } return Database.getQueryLocator(query); } global void execute(Database.BatchableContext BC, list Assets) { List asots = new List(); // List asotsIN = new List(); List accIds = new List(); Map asotMap = new Map(); for (Asset ass : Assets) { accIds.add(ass.Hospital__c); } List asotList = [select Id,Finish_Rigid_Mirror_2__c,Finish_Correlation_Lightsource__c,Finish_Rigid_Mirror_1__c,Account_HP__c,OCSM_Period_half__c from Account_Service_Of_Target__c where Account_HP__c in :accIds and OCSM_Period_half__c = :OCSM_Period_half and OCSM_Period__c = :OCSM_Period]; if (asotList != null) { for (Account_Service_Of_Target__c asot : asotList) { for (Id accid : accIds) { if (asot.Account_HP__c == accid) { asotMap.put(accid,asot); } } } } List AssetsReal = new List(); for (Asset ass1 : Assets) { // 实际覆盖数(硬) Integer mirror_4 = 0; // 实际覆盖数(周边) Integer mirror_6 = 0; // 实际覆盖数(软) Integer mirror_7 = 0; // 标记是否覆盖率实际设备 ass1.IF_Coverage_Real_Asset__c = '1'; AssetsReal.add(ass1); if (ass1.Product2.ServiceCategory__c == '硬性镜') { mirror_4++; } if (ass1.Product2.ServiceCategory__c == '周边') { mirror_6++; } if (ass1.Product2.ServiceCategory__c =='软性镜') { mirror_7++; } if (asotMap.containsKey(ass1.hospital__c)) { Account_Service_Of_Target__c asotOne = new Account_Service_Of_Target__c(); asotOne = asotMap.get(ass1.hospital__c); asotOne.Finish_Rigid_Mirror_2__c += mirror_4; asotOne.Finish_Correlation_Lightsource__c += mirror_6; asotOne.Finish_Rigid_Mirror_1__c += mirror_7; if (!asots.contains(asotOne)) { asots.add(asotOne); } }else{ Account_Service_Of_Target__c asot1 = new Account_Service_Of_Target__c(); asot1.Account_HP__c = ass1.hospital__c; asot1.Finish_Rigid_Mirror_2__c = mirror_4; asot1.Finish_Correlation_Lightsource__c = mirror_6; asot1.Finish_Rigid_Mirror_1__c = mirror_7; asot1.OCSM_Period__c = OCSM_Period; asot1.OCSM_Period_half__c = OCSM_Period_half; asotMap.put(ass1.hospital__c,asot1); if (!asots.contains(asot1)) { asots.add(asot1); } } } upsert asots; system.debug('这个集合:AssetsReal ==='+AssetsReal); if (AssetsReal!=null) { try { Oly_TriggerHandler.bypass('AssetTrigger'); update AssetsReal; } catch (Exception e) { iflog.ErrorLog__c += 'ERROR'+'['+'update AssetsReal:'+']'+e.getMessage()+'\n'; } } } global void finish(Database.BatchableContext BC) { iflog.Log__c += '\nEquipmentRealCoverageBatch 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; } }