/* Class Type :- Batch
* Date :- 
* Description :- Creates a new order if Contract Status is Activated after one month and update Next Order Date
* Author :- 
*/ 
global class AutoSubscriptionForOrderCreation implements Database.Batchable<sObject>,schedulable {
    Public void execute(SchedulableContext sc) 
    { 
        database.executebatch(new AutoSubscriptionForOrderCreation());
    }
    global Database.QueryLocator start(Database.BatchableContext bc) {
        Date orderCreationDate = system.today().addDays(3);
        //system.debug('output'+[SELECT Id,Status,Next_Order_Date__c,Service__r.id,AccountId,ShippingAddress,BillingAddress,Insurance__c From Contract Where Status = 'Activated' And Next_Order_Date__c = TODAY]);
        if(Test.isRunningTest()){
            return Database.getQueryLocator([SELECT Id,Status,Next_Order_Date__c,Service__r.id,AccountId,account.PersonContactId,ShippingAddress,BillingAddress,Insurance__c,BillingState,BillingCity,BillingStreet,BillingCountry,BillingPostalCode,BillingLatitude,BillingLongitude,ShippingStreet,ShippingState,ShippingCity,ShippingCountry,ShippingPostalCode,ShippingLatitude,ShippingLongitude,CustomerSignedId From Contract]);
        }else{
           return Database.getQueryLocator([SELECT Id,Status,Next_Order_Date__c,Service__r.id,AccountId,account.PersonContactId,ShippingAddress,BillingAddress,Insurance__c,BillingState,BillingCity,BillingStreet,BillingCountry,BillingPostalCode,BillingLatitude,BillingLongitude,ShippingStreet,ShippingState,ShippingCity,ShippingCountry,ShippingPostalCode,ShippingLatitude,ShippingLongitude,CustomerSignedId From Contract Where Status = 'Activated' And Next_Order_Date__c =: orderCreationDate]); 
        }
    }
    
    global void execute(Database.BatchableContext bc, List<Contract> contractlst) {
        List<Order> orderlsttoinsert = new List<Order>();
        List<OrderItem> orderItemsToInsert = new List<OrderItem>();
        List<Contract> contractupdatelst = new List<Contract>();
        List<Order> ordertoupdate= new List<Order>();
        map<Id, Id> contractProdMap = New map<Id, Id>();
        if(contractlst.size() > 0){
            
            Pricebook2 priceBook = [select id, name from Pricebook2 where isStandard = true limit 1];
            List<PriceBookEntry> priceBookEntryList = [SELECT Product2.Id, Product2.Name, UnitPrice FROM PriceBookEntry WHERE Pricebook2Id =:priceBook.id];            
            //Set <Id> accid  = new set <Id>();
            //List
            for(Contract con: contractlst){
                //Insert Orders
                Order orderObj = new Order();
                orderObj.AccountId = con.AccountId;
                orderObj.Status = 'Draft';
                orderObj.ContractId = con.Id;
                orderObj.EffectiveDate = System.today();
                orderObj.Pricebook2Id =  priceBook.id;
                orderObj.Insurance__c =  con.Insurance__c;
                orderObj.Type = 'Subscription Order';
                orderObj.BillingStreet = con.BillingStreet;
                orderObj.BillingState = con.BillingState;
                orderObj.BillingCity = con.BillingCity;
                orderObj.BillingCountry = con.BillingCountry;
                orderObj.BillingPostalCode = con.BillingPostalCode;
                orderObj.BillingLatitude = con.BillingLatitude;
                orderObj.BillingLongitude = con.BillingLongitude;
                orderObj.ShippingStreet = con.ShippingStreet;
                orderObj.ShippingState = con.ShippingState;
                orderObj.ShippingCity = con.ShippingCity;
                orderObj.ShippingCountry = con.ShippingCountry;
                orderObj.ShippingPostalCode = con.ShippingPostalCode;
                orderObj.ShippingLatitude = con.ShippingLatitude;
                orderObj.ShippingLongitude = con.ShippingLongitude;
                orderObj.ShipToContactId =con.account.PersonContactId; 
                orderObj.BillToContactId = con.account.PersonContactId;
                orderObj.EffectiveDate = con.Next_Order_Date__c;
                orderlsttoinsert.add(orderObj);
                
                //Create Contract and Product Map
                for(PriceBookEntry pBookEntry : priceBookEntryList){
                    if(pBookEntry.Product2.Id == con.Service__r.Id){
                        contractProdMap.put(con.Id, pBookEntry.Id);
                    }
                }
                
                // Update order date to next month's nearest Wednesday
                Date nextOrderDate = ((System.today().addMonths(1)).toStartOfWeek().addDays(3));
                con.Next_Order_Date__c = nextOrderDate;
                contractupdatelst.add(con);
                
            }
            if(orderlsttoinsert.size() > 0){
                insert orderlsttoinsert;  
                           
                for(Order O: orderlsttoinsert){
                    //Insert Order Items
                    OrderItem oi = new OrderItem();
                    oi.OrderId = O.id;
                    oi.Quantity = 1;
                    oi.UnitPrice = 1;
                    oi.Product2id = O.Contract.Service__c;
                    oi.PricebookEntryId = contractProdMap.get(O.ContractId);
                    oi.sstation__Currency_Type__c = 'USD';
                    orderItemsToInsert.add(oi);
                }    
            }
            if(orderItemsToInsert.size() > 0){
                insert orderItemsToInsert;
            }
            if(contractupdatelst.size() > 0){
                update contractupdatelst;
            }
            if(orderlsttoinsert.size() > 0){
            for(Order Or: orderlsttoinsert){
                Or.Status='Order Placed';
                ordertoupdate.add(Or);
            } 
            update ordertoupdate; 
        }   
        }
    }    
    global void finish(Database.BatchableContext bc) {
        
    }
}