Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- global Database.QueryLocator start(Database.BatchableContext BC){
- emailList = new List<Messaging.SingleEmailMessage>();
- owea = [Select Id From OrgWideEmailAddress Where Address = :Constants.SUPPORT_SF_EMAIL];
- dummyContact = [select id, Email from Contact where email != null limit 1];
- exceptionList = new List<Exception>();
- String chargeStatus = 'Invoiced';
- String orderStatus = 'Active';
- string squery = 'Select Order_number__c, invoiceit_s__Order__r.Name, invoiceit_s__Order__r.invoiceit_s__Status__c,' +
- 'invoiceit_s__Order__r.Auto_renew_subscription__c, invoiceit_s__VAT__c, invoiceit_s__VAT_Percentage__c, invoiceit_s__Unit_Price__c, invoiceit_s__Unit_Of_Measurement__c,' +
- 'invoiceit_s__Tax__c, invoiceit_s__Tax_Percentage__c, invoiceit_s__Tax_Code__c, invoiceit_s__Status__c, invoiceit_s__Service_End_Date__c, ' +
- 'invoiceit_s__Service_Activation_Date__c, invoiceit_s__Sequence_No__c, invoiceit_s__Row_Total__c, invoiceit_s__Remaining_Quantity__c, ' +
- 'invoiceit_s__Recurring_Period__c, invoiceit_s__Quantity_to_Dispatch__c, invoiceit_s__Quantity__c, invoiceit_s__Quantity_Already_Dispatched__c, ' +
- 'invoiceit_s__Profit__c, invoiceit_s__Product_Rate_Plan_Charge__c, invoiceit_s__Product_Charge_Category__c, invoiceit_s__Price__c, invoiceit_s__Price_Type__c, ' +
- 'invoiceit_s__Price_Format__c, invoiceit_s__Previous_Mid_Term_Adjustment__c, invoiceit_s__Previous_Charge_Date__c, invoiceit_s__Percentage_of_other_Charges__c, ' +
- 'invoiceit_s__Order__c, invoiceit_s__Next_Charge_Date__c, invoiceit_s__Net_Total__c, invoiceit_s__Min_Customer_Spend__c, invoiceit_s__Mid_Term_Status__c, ' +
- 'invoiceit_s__Mid_Term_Adjustment__c, invoiceit_s__Max_Customer_Spend__c, invoiceit_s__Master_Order_Rate_Plan_Charge__c, invoiceit_s__Job_Rate_Plan__c, ' +
- 'invoiceit_s__Is_Product_Editable__c, invoiceit_s__Grouping__c, invoiceit_s__Exempted_From_VAT__c, invoiceit_s__Dispatch__c, ' +
- 'invoiceit_s__Discount_Value__c, invoiceit_s__Discount_Type__c, invoiceit_s__Discount_Percent__c, invoiceit_s__CurrencyL__c, ' +
- 'invoiceit_s__Cost__c, invoiceit_s__Cost_Price__c, invoiceit_s__Committed_Quantity__c, invoiceit_s__Charge_Date__c, ' +
- 'invoiceit_s__Charge_Code__c, invoiceit_s__Accounting_Code__c, Term__c, SystemModstamp, Subscription_Item__c, ' +
- 'Start_date_handling__c, Renewed__c, Renew_the_charge__c, Owner_Email__c, Order_product__c, Order_level_status__c, ' +
- 'Order_level_partner_manager__c, Order_level_end_date__c, Name, LastModifiedDate, LastModifiedById, Is_order_owner_a_partner_user__c, IsDeleted, ' +
- 'Id, Helper_Start_date_set__c, HON_Unit__c, HELPER_Order_create_date__c, Fixed_Length__c, Estimated_Next_Invoice_Date__c, Estimated_Next_Charge_Amount__c, ' +
- 'Estimated_Daily_Rate_Without_Tax__c, Estimated_Aggregate_Period_Total__c, Delivered_Item__c, Days_to_end_date__c, CurrencyIsoCode, CreatedDate, CreatedById, ' +
- 'Contract_Value__c, Charge_Name__c, Annual_charge__c, Aggregated_Period__c From invoiceit_s__Job_Rate_Plan_Charge__c ' +
- 'Where Renew_the_charge__c = true ' +
- 'AND Annual_charge__c = true ' +
- 'AND Renewed__c = false ' +
- 'AND invoiceit_s__Status__c = \'' + chargeStatus +'\'' +
- 'AND invoiceit_s__Order__r.invoiceit_s__Status__c = \'' + orderStatus +'\'' +
- 'AND invoiceit_s__Order__r.Auto_renew_subscription__c = true ' +
- 'AND (invoiceit_s__Order__r.invoiceit_s__Service_End_Date__c = null ' +
- 'OR (not invoiceit_s__Order__r.invoiceit_s__Service_End_Date__c = ' + Datetime.now().format('yyyy-MM-dd') + ')' +
- ' OR (not invoiceit_s__Order__r.invoiceit_s__Service_End_Date__c = ' + Datetime.now().addDays(-1).format('yyyy-MM-dd') + '))' +
- ' AND invoiceit_s__Service_End_Date__c = ' + Datetime.now().addDays(1).format('yyyy-MM-dd');
- if(test.isRunningtest())
- squery = squery + ' LIMIT 1';
- System.debug('==== In squery ====' + squery);
- return Database.getQueryLocator(squery);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement