global class AuthRentalApplyRepairBatch implements Database.Batchable,Database.Stateful { public String repId; private Boolean testCheck = false; private BatchIF_Log__c iflog; global AuthRentalApplyRepairBatch() { } global AuthRentalApplyRepairBatch(String repId) { this.repId = repId; } global AuthRentalApplyRepairBatch(String repId,Boolean testCheck) { this.repId = repId; this.testCheck = true; } global Database.QueryLocator start(Database.BatchableContext bc) { iflog = new BatchIF_Log__c(); iflog.Type__c = 'AuthRentalApplyRepairBatch'; iflog.Log__c = 'AuthRentalApplyRepairBatch start\n'; iflog.ErrorLog__c = ''; insert iflog; String query = 'SELECT Id, Status__c,Delivered_Product__r.Product2.Family,Hospital__c,RepairSource__c,SAP_Transfer_time__c,IfCheckFixture__c,Maintenance_Contract__c,NewProductGuaranteeObject__c,Department_Class__c,Account__c,Incharge_Staff__c,Incharge_Staff__r.Name,Incharge_Staff__r.Email,Delivered_Product__r.Product2.Asset_Model_No__c,QIS_ID__c from Repair__c WHERE Status__c != \'草案中\' AND Status__c != \'取消\' AND Status__c != \'删除\' AND RentalApplyCheck__c = true AND MAINITIAL__c = false AND Repair_Final_Inspection_Date__c = NULL AND Repair_Shipped_Date__c = NULL AND Account__r.Management_Code_Auto__c != \'9999998\''; if (String.isNotBlank(this.repId)) { query += 'AND Id = \''+repId+'\''; System.debug('testzyh===='+query); } // String query = 'SELECT Id, Status__c,Delivered_Product__r.Product2.Family,Hospital__c,RepairSource__c,SAP_Transfer_time__c,IfCheckFixture__c,Maintenance_Contract__c,NewProductGuaranteeObject__c,Department_Class__c,Account__c,Incharge_Staff__c,Delivered_Product__r.Product2.Asset_Model_No__c,QIS_ID__c from Repair__c WHERE Status__c != \'草案中\' AND Status__c != \'取消\' AND Status__c != \'删除\' AND RentalApplyCheck__c = true AND MAINITIAL__c = false'; return Database.getQueryLocator(query); } global void execute(Database.BatchableContext BC, list scope) { try { System.debug('scope====' + scope); List raInList = new List(); List repList = new List(); List repIdList = new List(); List emails = new List(); Map mailMap = new Map(); repList = scope; if (repList.size() > 0) { for (Repair__c rep : repList) { repIdList.add(rep.Id); } System.debug('zyhtest===repIdList===' + repIdList); // 查询该修理是否已申请备品 List raList = [SELECT Id FROM Rental_Apply__c WHERE Repair__c IN :repIdList AND Status__c != '取消' AND Status__c != '删除']; System.debug('zyhtest=====raList:' + raList); // System.debug('zyhtest=====raList:' + raList.size() == 0); System.debug('zyhtest=====raList.size():' + raList.size()); if (raList.size() == 0) { EmailTemplate et=[Select id from EmailTemplate where name =:'修理自动创建备品' limit 1]; for (Repair__c rep : repList) { String Demo_purpose2 = ''; Rental_Apply__c ra = new Rental_Apply__c(); ra.Name = '*'; // ra.Person_In_Charge__c = '00510000001OOSN'; // 备品出借申请 -- 吕世伟,测试用 // ra.Person_In_Charge__c = System.UserInfo.getUserId(); // 备品出借申请 ra.Person_In_Charge__c = rep.Incharge_Staff__c; // 备品出借申请 ra.Loaner_received_staff__c = rep.Incharge_Staff__r.Name; // 收件者姓名 (销售或FSE) ra.applyUser__c = rep.Incharge_Staff__c; // 操作者 2023-11-27：zyh 操作者从Batch改成FSE // ra.applyUser__c = System.UserInfo.getUserId(); // 操作者 ra.Hospital__c = rep.Hospital__c; // 医院 ra.Strategic_dept__c = rep.Department_Class__c; // 战略科室 ra.Account__c = rep.Account__c; // 科室 ra.Is_Auto__c = true; if (rep.Delivered_Product__r.Product2.Family == 'GI') { ra.Product_category__c = 'GI'; } else { ra.Product_category__c = 'SP'; } ra.Product_category__c = rep.Delivered_Product__r.Product2.Family; ra.Demo_purpose1__c = '维修代用'; // 使用目的1 System.debug('zyhtest======QIS转修理+' + rep.RepairSource__c); if (rep.RepairSource__c != 'QIS转修理') { System.debug('zyhtest======rep.NewProductGuaranteeObject__c:' + rep.NewProductGuaranteeObject__c); System.debug('zyhtest======rep.Maintenance_Contract__c:' + rep.Maintenance_Contract__c); System.debug('zyhtest======rep.IfCheckFixture__c:' + rep.IfCheckFixture__c); if (rep.NewProductGuaranteeObject__c == '8: 市场多年保修') { Demo_purpose2 = '市场多年保修'; }else if (String.isNotBlank(rep.Maintenance_Contract__c)) { Demo_purpose2 = '保修用户'; }else if (rep.IfCheckFixture__c) { Demo_purpose2 = '故障排查'; }else{ if (rep.NewProductGuaranteeObject__c == '2: 服务多年保修' && (rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'LTF-190-10-3D' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'LTF-S190-5' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'CYF-VHA' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'CYF-VA2' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'CYF-5A' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'LTF-S190-10' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'OER-AW' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'URF-V' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'URF-V2' || rep.Delivered_Product__r.Product2.Asset_Model_No__c == 'URF-P6')) { Demo_purpose2 = '保修用户'; }else { Demo_purpose2 = '一般用户'; } } }else{ Demo_purpose2 = '索赔QIS'; } System.debug('zyhtest======Demo_purpose2:' + Demo_purpose2); ra.Demo_purpose2__c = Demo_purpose2; // 使用目的2 if (Demo_purpose2 == '索赔QIS' && String.isNotBlank(rep.QIS_ID__c)) { ra.Demo_purpose2__c = '索赔QIS'; // 使用目的2 } ra.Repair__c = rep.Id; System.debug('zyhtest======JinlaiIf'+ra); // if (ra.Demo_purpose2__c == '故障排查' && rep.SAP_Transfer_time__c == null) { if (ra.Demo_purpose2__c == '故障排查' || ra.Demo_purpose2__c == '索赔QIS') { // return '没有上传SAP,不可创建备品,请手动创建'; continue; } raInList.add(ra); mailMap.put(rep.Incharge_Staff__c,rep.Incharge_Staff__r.Email); System.debug('zyhtest111====mailMap'+mailMap); // System.debug(rep.Person_In_Charge__r.Email + '====' + ra.Incharge_Staff__r.Email); } if (raInList.size() > 0) { Insert raInList; for (Rental_Apply__c ra : raInList) { List toAddresses = new List(); // toAddresses.add('zhangyuheng@prec-tech.com'); System.debug('zyhtest111====Incharge_Staff__c'+ra.Person_In_Charge__c); System.debug('zyhtest111====Incharge_Staff__r.Email'+ra.Person_In_Charge__r.Email); if(String.isNotBlank(mailMap.get(ra.Person_In_Charge__c))){ System.debug('zyhtest====Incharge_Staff__r.Email'+ra.Person_In_Charge__r.Email); toAddresses.add(mailMap.get(ra.Person_In_Charge__c)); } //发送邮件 Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); mail = Messaging.renderStoredEmailTemplate(et.Id, null , ra.Id); mail.setToAddresses(toAddresses); // String[] toAddresses1 = System.Label.AssetCountErrorMailAddress.split(','); if (String.isNotBlank(System.Label.AuthRental_Apply_TEST)) { String[] toAddresses1 = System.Label.AuthRental_Apply_TEST.split(','); if(toAddresses1 != null) { mail.setCcAddresses(toAddresses1); } } mail.setSaveAsActivity(false); System.debug('zyhtest=====mail_' + mail); System.debug('zyhtest=====mailMap_' + mailMap); emails.add(mail); } } Messaging.sendEmail(emails); } } } catch (Exception ex) { iflog.ErrorLog__c = ex.getLineNumber()+' 行错误 : '+ex.getMessage(); return; } } global void finish(Database.BatchableContext BC) { iflog.Log__c += '\nAuthRentalApplyRepairBatch 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; // 打插队标识的batch // Database.executeBatch( new AuthRentalApplyQueueRemindBatch(),1); System.debug('2023-12-09zyhxinjianfinish' + DateTime.now()); // 借用机会可视化--批次从数字改成自定义标签--20231212--zyh--start // 自动分单的batch // Database.executeBatch( new AuthRentalApplySplitBatch(),1); // Integer num = Integer.valueOf(System.Label.AutoSplitNum); // if (testCheck == false && !Test.isRunningTest()) { // 2024-1-3 zyh 测试判断 // Database.executeBatch( new AuthRentalApplySplitBatch(System.Label.BeijingEmail),num); // Database.executeBatch( new AuthRentalApplySplitBatch(System.Label.GuangzhouEmail),num); // Database.executeBatch( new AuthRentalApplySplitBatch(System.Label.ShanghaiEmai),num); // } // Database.executeBatch( new AuthRentalApplySplitBatch(),num); // 借用机会可视化--批次从数字改成自定义标签--20231212--zyh--end } }