/** * wangweipeng 20210723 * 每天赋值给 备品借出申请表的 询价状态辅助（申请时）和 询价状态辅助（现在） 值 * */ global class EnquiryBoostTypeBatch implements Database.Batchable { public String query; private String errStr; private BatchIF_Log__c iflog; private final List TEST_ID = null; global EnquiryBoostTypeBatch() { iflog = new BatchIF_Log__c(); iflog.Type__c = 'PushNotification'; iflog.Is_Error__c = 0; iflog.Log__c = 'EnquiryBoostTypeBatch start1\n'; iflog.ErrorLog__c = ''; insert iflog; } global EnquiryBoostTypeBatch(List testId) { iflog = new BatchIF_Log__c(); iflog.Type__c = 'PushNotification'; iflog.Is_Error__c = 0; iflog.Log__c = 'EnquiryBoostTypeBatch start1\n'; iflog.ErrorLog__c = ''; insert iflog; TEST_ID = testId; } global Database.QueryLocator start(Database.BatchableContext bc) { query = 'select id,name,Follow_pcl_status2_Text__c,Follow_pcl_status2__c,Follow_UP_Opp__r.StageName,Follow_UP_Opp__r.Status_Formula__c,Inquiry_Status_History__c,Inquiry_Status_Now__c from Rental_Apply__c ' + 'where Bollow_Date__c != null and demo_purpose2__c = \'试用（有询价）\' '; if (TEST_ID <> null) { query += ' and Id IN: TEST_ID'; } iflog.Log__c += query+'\n'; update iflog; return Database.getQueryLocator(query); } global void execute(Database.BatchableContext BC, list scope) { if(scope != null && scope.size() > 0){ List addListRentalApply = new List(); // 20221129 ljh DB202211366462 询价状态2 start String InquiryStatusMapping = System.Label.Inquiry_Status_Mapping; Map mapping = (Map) JSON.deserializeUntyped(InquiryStatusMapping); // 20221129 ljh DB202211366462 询价状态2 end for(Rental_Apply__c ra : scope){ String newFollowPclStatus2Text = ra.Follow_pcl_status2_Text__c; String newFollowPclStatus2 = ra.Follow_pcl_status2__c; Rental_Apply__c raData = new Rental_Apply__c(); raData.id = ra.id; if(newFollowPclStatus2Text != null){ // 20221129 ljh DB202211366462 询价状态2 start //跟进中 // if(newFollowPclStatus2Text == '引合 : -' || newFollowPclStatus2Text == '引合 : 00 还没更新' || newFollowPclStatus2Text == '引合 : 01 还没拜访' || newFollowPclStatus2Text == '引合 : 02 跟进中'){ // raData.Inquiry_Status_History__c = 1; // }else if(newFollowPclStatus2Text == '引合 : 03 已授权'){//已授权 // raData.Inquiry_Status_History__c = 2; // }else if(newFollowPclStatus2Text == '引合 : 04 已中标' || newFollowPclStatus2Text == '引合 : 05 价格申请中' || newFollowPclStatus2Text == '引合 : 06 用户未签约' || newFollowPclStatus2Text == '引合 : 07 用户已签约' // || newFollowPclStatus2Text == '引合 : 08 已签约'){//准备签约 // raData.Inquiry_Status_History__c = 3; // }else if(newFollowPclStatus2Text == '出荷 : -' || newFollowPclStatus2Text == '完了 : -' || newFollowPclStatus2Text == '注残 : -' || newFollowPclStatus2Text == '完了 : 08 已签约'){//已订货 // raData.Inquiry_Status_History__c = 4; // }else if(newFollowPclStatus2Text == '削除 : 17 取消' || newFollowPclStatus2Text == '敗戦 : 18 失单'){//0.取消 0.失单 // raData.Inquiry_Status_History__c = 0; // } raData.Inquiry_Status_History__c = mapping.get(newFollowPclStatus2Text) != null ? Integer.valueOf(mapping.get(newFollowPclStatus2Text)) : null; // System.debug('zheli00:'+mapping.get(newFollowPclStatus2Text)); // 20221129 ljh DB202211366462 询价状态2 end } if(newFollowPclStatus2 != null){ // 20221129 ljh DB202211366462 询价状态2 start //跟进中 // if(newFollowPclStatus2 == '引合 : -' || newFollowPclStatus2 == '引合 : 00 还没更新' || newFollowPclStatus2 == '引合 : 01 还没拜访' || newFollowPclStatus2 == '引合 : 02 跟进中'){ // raData.Inquiry_Status_Now__c = 1; // }else if(newFollowPclStatus2 == '引合 : 03 已授权'){//已授权 // raData.Inquiry_Status_Now__c = 2; // }else if(newFollowPclStatus2 == '引合 : 04 已中标' || newFollowPclStatus2 == '引合 : 05 价格申请中' || newFollowPclStatus2 == '引合 : 06 用户未签约' || newFollowPclStatus2 == '引合 : 07 用户已签约' // || newFollowPclStatus2 == '引合 : 08 已签约'){//准备签约 // raData.Inquiry_Status_Now__c = 3; // }else if(newFollowPclStatus2 == '出荷 : -' || newFollowPclStatus2 == '完了 : -' || newFollowPclStatus2 == '注残 : -' || newFollowPclStatus2 == '完了 : 08 已签约'){//已订货 // raData.Inquiry_Status_Now__c = 4; // }else if(newFollowPclStatus2 == '削除 : 17 取消' || newFollowPclStatus2 == '敗戦 : 18 失单'){//0.取消 0.失单 // raData.Inquiry_Status_Now__c = 0; // } raData.Inquiry_Status_Now__c = mapping.get(newFollowPclStatus2) != null ? Integer.valueOf(mapping.get(newFollowPclStatus2)) : null; // System.debug('zheli01:'+mapping.get(newFollowPclStatus2)); // 20221129 ljh DB202211366462 询价状态2 end } // Boolean aa = raData.Inquiry_Status_Now__c != ra.Inquiry_Status_Now__c; // System.debug('zheli03:'+aa+raData.Inquiry_Status_Now__c +'~~'+ ra.Inquiry_Status_Now__c); //为了减少update，如果值没有发生变化，那么不需要更新 if((raData.Inquiry_Status_Now__c != ra.Inquiry_Status_Now__c) || (raData.Inquiry_Status_History__c != ra.Inquiry_Status_History__c)){ addListRentalApply.add(raData); } } Savepoint sp = Database.setSavepoint(); try{ // System.debug('zheli05:'); update addListRentalApply; }catch(exception e){ // System.debug('zheli04:'+e.getMessage()); errStr = e.getMessage()+'\n'; errStr += e.getLineNumber()+'\n'; Database.rollback(sp); } } } global void finish(Database.BatchableContext BC) { String tmp = ''; if (String.isNotBlank(errStr)) { tmp = errStr; } iflog.Log__c += 'OPDStrategyPersonShareBatch finish()\n'; iflog.Log__c += '\nOPDStrategyPersonShareBatch end'; tmp += iflog.ErrorLog__c; if (tmp.length() > 60000) { tmp = tmp.substring(0, 60000); tmp += ' ...have more lines...'; iflog.ErrorLog__c = tmp; } String tmp2 = iflog.Log__c; if (tmp2.length() > 60000) { tmp2 = tmp2.substring(0, 60000); tmp2 += ' ...have more lines...'; iflog.Log__c = tmp2; } if (System.Label.Log_IO_Flag == 'Keep') { update iflog; } else if (System.Label.Log_IO_Flag == 'Auto') { if (iflog.Is_Error__c > 0) { update iflog; } } 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 ++; } }