| | |
| | | global class InquiryVerifyBatch implements Schedulable, Database.Batchable<sObject>, Database.Stateful { |
| | | global class InquiryVerifyBatch implements Schedulable,Database.Batchable<SObject>,Database.Stateful { |
| | | public String query; |
| | | global InquiryVerifyBatch() { |
| | | |
| | | public Date start_date; |
| | | |
| | | global InquiryVerifyBatch() { |
| | | // if(Test.isRunningTest()){ |
| | | this.query = 'select id,quoteSavedDate__c,Opportunity.Id,Opportunity.Department_Class__c from quote where Quote_No_last2__c = \'01\' and CreatedDate = today'; |
| | | // }else{ |
| | | // this.query = 'select id,quoteSavedDate__c,Opportunity.Id,Opportunity.Department_Class__c from quote where Quote_No__c like \'%01\' and CreatedDate = today'; |
| | | // } |
| | | |
| | | } |
| | | global void execute(SchedulableContext sc){Database.executebatch(this);} |
| | | |
| | | global InquiryVerifyBatch(Integer year, Integer month) { |
| | | if (year == null) { |
| | | year = 2021; |
| | | } |
| | | if (month == null) { |
| | | month = 4; |
| | | } |
| | | start_date = Date.newInstance(year, month, 1); |
| | | |
| | | this.query = 'select id,quoteSavedDate__c,Opportunity.Id,Opportunity.Department_Class__c from quote where Quote_No_last2__c = \'01\' and CreatedDate >= :start_date'; |
| | | } |
| | | |
| | | public void execute(SchedulableContext sc) { |
| | | Database.executeBatch(this); |
| | | } |
| | | // global void execute(SchedulableContext sc){Database.executebatch(this);} |
| | | global Database.QueryLocator start(Database.BatchableContext bc) { |
| | | String quoteLN = '%01'; |
| | | // 获取报价单数据 |
| | | query = 'select id,quoteSavedDate__c,Opportunity.Id,Opportunity.Department_Class__c from quote where Quote_No__c like :quoteLN and CreatedDate = today'; |
| | | return Database.getQueryLocator(query); |
| | | } |
| | | |
| | |
| | | createdDateStr = Date.today(); |
| | | } |
| | | // 获取报价产品数据,获取第四分类 |
| | | List<QuoteLineItem> qlts = [Select Id,Product2.Category4__c from QuoteLineItem where QuoteId = :quo.Id]; |
| | | List<QuoteLineItem> qlts = [Select Id,Product2.Category4__c from QuoteLineItem where QuoteId = :quo.Id and Product2.Important_product__c = true]; |
| | | List<String> c4 = new List<String>(); |
| | | List<String> qdept = new List<String>(); |
| | | // 第四分类放入list |
| | |
| | | |
| | | // 一年前的日期 |
| | | Date createdDateYear = createdDateStr.addYears(-1); |
| | | |
| | | // 获取备品配套一览明细 |
| | | List<Rental_Apply_Equipment_Set_Detail__c> raesdList = [select id, product__c, Bollow_Date__c,Category4__c, Rental_Apply__r.Hospital__c |
| | | from Rental_Apply_Equipment_Set_Detail__c |
| | | where Rental_Apply__r.Strategic_dept__c = : quo.Opportunity.Department_Class__c |
| | | and Category4__c IN :c4 and Key_product__c != null |
| | | and Category4__c IN :c4 |
| | | and Rental_Apply__r.Demo_purpose2__c = '试用(无询价)' |
| | | and Bollow_Date__c >= :createdDateYear order by Bollow_Date__c ]; |
| | | and Bollow_Date__c >= :createdDateYear order by Bollow_Date__c limit 200 ]; |
| | | |
| | | |
| | | for (Rental_Apply_Equipment_Set_Detail__c raesd : raesdList) { |
| | | o.WhetherTrySpareParts_3m__c = false; |
| | |
| | | } |
| | | |
| | | global void finish(Database.BatchableContext BC) { |
| | | |
| | | |
| | | } |
| | | } |