/*2022-05-13 you * 更新产品咨询单 * 没有确认的，确认天数=今天-创建日----自动 batch * 有确认的（存在最小日期） 确认天数=最小日期-创建日-----触发器 * ocm管理省中对应的GI，SP助理变化，产品咨询单也变 */ global class UpdateInquiryFormConfirmationBatch implements Database.Batchable { public String query; public String inqid; private BatchIF_Log__c iflog; private String stb_Flag;//20220614 WLIG-CER9NQ you global UpdateInquiryFormConfirmationBatch() { this.query = query; iflog = new BatchIF_Log__c(); iflog.Type__c = 'PushNotification'; iflog.Is_Error__c = 0; iflog.Log__c = 'UpdateInquiryFormConfirmationBatch start\n'; iflog.ErrorLog__c = ''; insert iflog; stb_Flag=System.label.SetPersonalTargetBatch_Flag; } global UpdateInquiryFormConfirmationBatch(String inqid) { this.inqid = inqid; this.query = query; iflog = new BatchIF_Log__c(); iflog.Type__c = 'PushNotification'; iflog.Is_Error__c = 0; iflog.Log__c = 'UpdateInquiryFormConfirmationBatch start\n'; iflog.ErrorLog__c = ''; insert iflog; stb_Flag=System.label.SetPersonalTargetBatch_Flag; } global Database.QueryLocator start(Database.BatchableContext BC) { query = 'select TimeoutDays__c, Id,CreateDate__c from Inquiry_form__c where CreateDate__c != null and MinimumDate__c =null'; if (inqid != null && inqid !='') { query += ' and id = :inqid '; } return Database.getQueryLocator(query); } global void execute(Database.BatchableContext BC, list inquiryList) { system.debug('==='+inquiryList.size()); updateTimeoutDays(inquiryList,iflog); //20220518 you SWAG-CBUB2W start Map mpMap = new Map(); List ocmList = [select id, Name, GI_assistant__c,SP_assistant__c from OCM_Management_Province__c]; system.debug('==ocmList='+ocmList.size()); // 取得OCSM管理省的GI,SP 助理 for (OCM_Management_Province__c mp : ocmList) { mpMap.put(mp.Name, mp); } updateGISPAssistant(mpMap, iflog); //20220518 you SWAG-CBUB2W end } //确认天数赋值 public static void updateTimeoutDays(List inquiryList, BatchIF_Log__c iflog) { String dateToday = String.valueOf(Date.today()); for(Inquiry_form__c inq:inquiryList){ String crdate = String.valueOf(inq.CreateDate__c); String confdate=calendarUtil.getWorkDayNum(crdate,dateToday); if(Integer.valueOf(confdate) > 5){ inq.TimeoutDays__c = Integer.valueOf(confdate)-5; }else{ inq.TimeoutDays__c = null; } inq.Confirmation_days__c =null; //inq.Confirmation_days__c =Integer.valueOf(confdate); system.debug(inq.id+'=相差几天=='+confdate +'==创建日=='+crdate+'==今天=='+dateToday); } Integer indexCon = 0; if(null!=inquiryList && inquiryList.size()>0){ system.debug('inquiryList==='+inquiryList); Database.SaveResult[] lsrUpdateCon = Database.update(inquiryList, false); for (Database.SaveResult lsrChild : lsrUpdateCon) { if (!lsrChild.isSuccess()) { iflog.Is_Error__c = 3; Database.Error emsg = lsrChild.getErrors()[0]; iflog.ErrorLog__c += 'confdays: ' + inquiryList.get(indexCon).TimeoutDays__c + ' \n' + 'inquiryID: ' + inquiryList.get(indexCon).Id + '\n ConLog:' + emsg.getMessage() + '\n'; system.debug('lsrChild.isSuccess()=='+iflog.ErrorLog__c); } indexCon ++ ; } } } public static void updateGISPAssistant(Map mpMap, BatchIF_Log__c iflog) { List updateInquiryFormList = [select id, GI_assistant__c, SP_assistant__c,OCM_man_province_cus__c,IfGotoDepartment__c from Inquiry_form__c where (GI_assistant__c !=null or SP_assistant__c !=null) and IfGotoDepartment__c = false ]; //还没有转移科室的，说明助理还需要操作，这个时候如果ocsm助理改变，这边也跟着改变 system.debug('==updateInquiryFormList='+updateInquiryFormList.size()); for (Inquiry_form__c ifo : updateInquiryFormList) { system.debug('==mpMap='+mpMap+'==ifo.OCM_man_province_cus__c=='+ifo.OCM_man_province_cus__c); if(null!=mpMap && mpMap.containsKey(ifo.OCM_man_province_cus__c)){ OCM_Management_Province__c omp = mpMap.get(ifo.OCM_man_province_cus__c); if (omp != null) { if(ifo.GI_assistant__c != omp.GI_assistant__c){ ifo.GI_assistant__c = omp.GI_assistant__c; } if(ifo.SP_assistant__c != omp.SP_assistant__c){ ifo.SP_assistant__c = omp.SP_assistant__c; } } } } Integer indexCon = 0; Database.SaveResult[] lsrUpdateInq = Database.update(updateInquiryFormList, false); for (Database.SaveResult lsrChild : lsrUpdateInq) { if (!lsrChild.isSuccess()) { iflog.Is_Error__c = 3; Database.Error emsg = lsrChild.getErrors()[0]; iflog.ErrorLog__c += 'GI助理: ' + updateInquiryFormList.get(indexCon).GI_assistant__c + ' \n' +'SP助理: ' + updateInquiryFormList.get(indexCon).SP_assistant__c + ' \n' + 'InquiryFormID: ' + updateInquiryFormList.get(indexCon).Id + '\n ConLog:' + emsg.getMessage() + '\n'; } indexCon ++ ; } } global void finish(Database.BatchableContext BC) { system.debug('=====iflog:' + iflog.id+'==='+iflog.ErrorLog__c); iflog.Log__c += 'UpdateInquiryFormConfirmationBatch finish()\n'; iflog.Log__c += '\nUpdateInquiryFormConfirmationBatch end'; String tmp = iflog.ErrorLog__c; if (tmp.length() > 65000) { tmp = tmp.substring(0, 65000); tmp += ' ...have more lines...'; iflog.ErrorLog__c = tmp; } String tmp2 = iflog.Log__c; if (tmp2.length() > 65000) { tmp2 = tmp2.substring(0, 65000); tmp2 += ' ...have more lines...'; iflog.Log__c = tmp2; } if (System.Label.Log_IO_Flag == 'Keep') { system.debug('jinlaile'); update iflog; } else if (System.Label.Log_IO_Flag == 'Auto') { system.debug('jinlaile1'); if (iflog.Is_Error__c > 0) { update iflog; } } //20220614 WLIG-CER9NQ you if (stb_Flag=='true') { Database.executeBatch(new SetPersonalTargetBatch(), 20); } } @TestVisible private static void test() { Integer i = 0; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++; i++;//可以多写点 } }