Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2015
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.05 KB | None | 0 0
  1. global Database.QueryLocator start(Database.BatchableContext BC){    
  2.         emailList = new List<Messaging.SingleEmailMessage>();
  3.         owea = [Select Id From OrgWideEmailAddress Where Address = :Constants.SUPPORT_SF_EMAIL];
  4.         dummyContact = [select id, Email from Contact where email != null limit 1];
  5.         exceptionList = new List<Exception>();
  6.        
  7.         String chargeStatus = 'Invoiced';
  8.         String orderStatus = 'Active';
  9.         string squery = 'Select Order_number__c, invoiceit_s__Order__r.Name, invoiceit_s__Order__r.invoiceit_s__Status__c,' +
  10.                                             '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,' +
  11.                                             'invoiceit_s__Tax__c, invoiceit_s__Tax_Percentage__c, invoiceit_s__Tax_Code__c, invoiceit_s__Status__c, invoiceit_s__Service_End_Date__c, ' +
  12.                                             'invoiceit_s__Service_Activation_Date__c, invoiceit_s__Sequence_No__c, invoiceit_s__Row_Total__c, invoiceit_s__Remaining_Quantity__c, ' +
  13.                                             'invoiceit_s__Recurring_Period__c, invoiceit_s__Quantity_to_Dispatch__c, invoiceit_s__Quantity__c, invoiceit_s__Quantity_Already_Dispatched__c, ' +
  14.                                             '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, ' +
  15.                                             '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, ' +
  16.                                             '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, ' +
  17.                                             '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, ' +
  18.                                             'invoiceit_s__Is_Product_Editable__c, invoiceit_s__Grouping__c, invoiceit_s__Exempted_From_VAT__c, invoiceit_s__Dispatch__c, ' +
  19.                                             'invoiceit_s__Discount_Value__c, invoiceit_s__Discount_Type__c, invoiceit_s__Discount_Percent__c, invoiceit_s__CurrencyL__c, ' +
  20.                                             'invoiceit_s__Cost__c, invoiceit_s__Cost_Price__c, invoiceit_s__Committed_Quantity__c, invoiceit_s__Charge_Date__c, ' +
  21.                                             'invoiceit_s__Charge_Code__c, invoiceit_s__Accounting_Code__c, Term__c, SystemModstamp, Subscription_Item__c, ' +
  22.                                             'Start_date_handling__c, Renewed__c, Renew_the_charge__c, Owner_Email__c, Order_product__c, Order_level_status__c, ' +
  23.                                             'Order_level_partner_manager__c, Order_level_end_date__c, Name, LastModifiedDate, LastModifiedById, Is_order_owner_a_partner_user__c, IsDeleted, ' +
  24.                                             '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, ' +
  25.                                             'Estimated_Daily_Rate_Without_Tax__c, Estimated_Aggregate_Period_Total__c, Delivered_Item__c, Days_to_end_date__c, CurrencyIsoCode, CreatedDate, CreatedById, ' +
  26.                                             'Contract_Value__c, Charge_Name__c, Annual_charge__c, Aggregated_Period__c From invoiceit_s__Job_Rate_Plan_Charge__c ' +
  27.                 'Where Renew_the_charge__c = true ' +
  28.                 'AND Annual_charge__c = true ' +
  29.                 'AND Renewed__c = false ' +
  30.                 'AND invoiceit_s__Status__c = \'' + chargeStatus  +'\'' +
  31.                 'AND invoiceit_s__Order__r.invoiceit_s__Status__c = \'' + orderStatus  +'\'' +
  32.                 'AND invoiceit_s__Order__r.Auto_renew_subscription__c = true ' +
  33.                 'AND (invoiceit_s__Order__r.invoiceit_s__Service_End_Date__c = null ' +
  34.                     'OR (not invoiceit_s__Order__r.invoiceit_s__Service_End_Date__c = ' + Datetime.now().format('yyyy-MM-dd') + ')' +
  35.                     ' OR (not invoiceit_s__Order__r.invoiceit_s__Service_End_Date__c = ' + Datetime.now().addDays(-1).format('yyyy-MM-dd') + '))' +
  36.                 ' AND invoiceit_s__Service_End_Date__c = ' + Datetime.now().addDays(1).format('yyyy-MM-dd');
  37.         if(test.isRunningtest())
  38.             squery = squery + ' LIMIT 1';
  39.         System.debug('==== In squery ====' + squery);
  40.         return Database.getQueryLocator(squery);
  41.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement