TRIGGER

//Case Number 1381 - Provides information about request for Trigger
trigger UpdateOTRev on Opportunity (after insert, after update) {
    Set<id> triggerIds = new Set<id>();
    List<OpportunityLineItem> lstOLIUpdate = new List<OpportunityLineItem>();
    //See if Trigger has only been run once
    if(RecursiveTriggerHandler.isFirstTime){
        RecursiveTriggerHandler.isFirstTime = false;
         //Put all trigger opp ids into a set
         for(Opportunity Opps : Trigger.new){
            triggerIds.add(Opps.Id);
         }//END for (Opportunity Opps)
         //Get all the Opp and Products
         List<Opportunity> lstOpps = [SELECT id, CloseDate, (SELECT id, TotalPrice, One_Time_Revenue__c FROM OpportunityLineItems) FROM Opportunity 
                                      WHERE id in: triggerIds];
             //Loop through Opps
             for(Opportunity opp: lstOpps){
                 //Loop through Products in Opps
                 for(OpportunityLineItem oli : opp.OpportunityLineItems){
                     if(oli.One_Time_Revenue__c == true){
                        //Apply the logic of which fields to update
                        if(opp.CloseDate > Date.valueOf('2017-12-31') && opp.CloseDate < Date.valueOf('2018-04-01')){
                            oli.One_Time_Rev_Q1_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q1
                        if(opp.CloseDate > Date.valueOf('2018-03-31') && opp.CloseDate < Date.valueOf('2018-07-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q2
                        if(opp.CloseDate > Date.valueOf('2018-06-30') && opp.CloseDate < Date.valueOf('2018-10-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q3
                        if(opp.CloseDate > Date.valueOf('2018-09-30') && opp.CloseDate < Date.valueOf('2019-01-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q4
                        if(opp.CloseDate > Date.valueOf('2018-12-31') && opp.CloseDate < Date.valueOf('2019-04-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q1
                        if(opp.CloseDate > Date.valueOf('2019-03-31') && opp.CloseDate < Date.valueOf('2019-07-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q2
                        if(opp.CloseDate > Date.valueOf('2019-06-30') && opp.CloseDate < Date.valueOf('2019-10-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q3
                        if(opp.CloseDate > Date.valueOf('2019-09-30') && opp.CloseDate < Date.valueOf('2020-01-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = oli.TotalPrice;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q4
                        if(opp.CloseDate > Date.valueOf('2019-12-31')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            
                            lstOLIUpdate.add(oli);
                        }
                         
                     }//END if(oli.One_Time_Revenue__c == true)                     
                 }//END For(OpportunityLineItem)
             }//END for(Opportunity)
    //Update Products if there are any to update
    if(lstOLIUpdate.size()>0){
        update lstOLIUpdate;
    }
    }//END if(RecusiveTriggerHandler.isFirstTime)
}//END Class

@isTest
public class UpdateOTRevTest {
    
    public static testMethod void testOppOneTimeRevenue(){
        
        Product2 prod2= new Product2(Name = 'Test Product - OneTime',
                                     Product_Gross_Margin__c = 10,
                                     Delivery_Market__c = 'none' ,
                                     Delivery_Region__c = 'ABCD',
                                     Delivery_Site__c = 'none' ,
                                     Family = 'XTCD',
                                     Description = 'Test Product',
                                     IsActive = true,
                                     Project_Seat_Count__c = 'false',
                                     One_Time_Revenue__c = true);
        insert prod2;
        Id pricebookId = Test.getStandardPricebookId();
        PricebookEntry pbEntry = new PricebookEntry(Pricebook2Id = pricebookId,
                                                    product2Id = prod2.Id,
                                                    isActive = true,
                                                    UnitPrice = 1000);
        insert pbEntry;
       
        Opportunity opp = new Opportunity(Name = 'Test Account - Opportunity',
                                          StageName = '1 - Prospect',
                                          Type = 'New Logo', 
                                          CloseDate = System.Date.today(),
                                          LeadSource = 'BDD/AM/OPS Development',
                                          Referral_Channel__c = 'None',
                                          Auto_Generate_Quarterly_Forecast__c = 'Yes',
                                          Contract_Length_Months__c = 24,
                                          Pricebook2Id = pricebookId,
                                          Amount = 10000000);
        insert opp;
       
        OpportunityLineItem oli = new OpportunityLineItem(OpportunityId = opp.id,
                                                          PricebookEntryId = pbEntry.id,
                                                          Product2Id = prod2.id,
                                                          Quantity = 10, 
                                                          Unit_Price2__c = 20,
                                                          Adjusted_Gross_Margin_Percentage__c = 10,
                                                          Service_Channel__c = 'WIDGET',
                                                          Service_Type__c = 'Care',
                                                          One_Time_Revenue__c = true);
        insert oli;
        
        System.debug('Opportunity Product Total Price '+ oli.TotalPrice);
        System.debug('OpportunityLineItem Id ' +oli.Id);
        System.debug('Product 2 Id '+ oli.Product2Id);
        System.debug('Opportunity Line Item Name : '+ oli.Name);
        System.debug('One Time Revenue : '+oli.One_Time_Revenue__c);
        Date closeDate = System.today();
        opp.CloseDate = Date.newInstance(2018, 01, 25);
       
        update opp;
        System.debug('Opp Close Date : '+opp.CloseDate);
    }//END Method
}//END Class

//https://salesforce.stackexchange.com/questions/72883/how-to-create-opportunity-line-items-in-test-classes

trigger UpdateOTRev on Opportunity (after insert, after update) {
    Set<id> triggerIds = new Set<id>();
    List<OpportunityLineItem> lstOLIUpdate = new List<OpportunityLineItem>();
    for(Opportunity Opps : Trigger.new){
        triggerIds.add(Opps.Id);
    }
    List<Opportunity> lstOpps = [SELECT id, CloseDate, (SELECT id, TotalPrice FROM OpportunityLineItems) FROM Opportunity 
                                 WHERE id in: triggerIds];
    for(Opportunity opp: lstOpps){
        for(OpportunityLineItem oli : opp.OpportunityLineItems){
            
            if(opp.CloseDate > Date.valueOf('2017-12-31') && opp.CloseDate < Date.valueOf('2018-04-01')){
                oli.Test_Q1_2018__c = oli.TotalPrice;
                oli.Test_Q2_2018__c = 0;
                oli.Test_Q3_2018__c = 0;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q1
            if(opp.CloseDate > Date.valueOf('2018-03-31') && opp.CloseDate < Date.valueOf('2018-07-01')){
                oli.Test_Q1_2018__c = 0;
                oli.Test_Q2_2018__c = oli.TotalPrice;
                oli.Test_Q3_2018__c = 0;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q2
            if(opp.CloseDate > Date.valueOf('2018-06-30') && opp.CloseDate < Date.valueOf('2018-10-01')){
                oli.Test_Q1_2018__c = 0;
                oli.Test_Q2_2018__c = 0;
                oli.Test_Q3_2018__c = oli.TotalPrice;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q3
            if(opp.CloseDate > Date.valueOf('2018-09-30') && opp.CloseDate < Date.valueOf('2019-01-01')){
                oli.Test_Q1_2018__c = 0;
                oli.Test_Q2_2018__c = 0;
                oli.Test_Q3_2018__c = oli.TotalPrice;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q4
        }//END For(OpportunityLineItem)
    }//END for(Opportunity)
    if(lstOLIUpdate.size()){
        update lstOLIUpdate;
    }

}

trigger OpportunityLineItemTrigger on OpportunityLineItem (before insert, before update, after update, after insert) {
    List<Opportunity> opps = new List<Opportunity>();
    List<Id> oppIds = new List<Id>();
    Decimal contractLengthMonths = 0;

//---------------BEFORE TRIGGER BELOW----------
    if(trigger.isInsert || trigger.isUpdate && trigger.isBefore) {
        List<OpportunityLineItem> oli = new List<OpportunityLineItem>();
        for (OpportunityLineItem oli2: trigger.new){
            if(oli2.Number_of_Months__c > 0){
                oli2.UnitPrice = ((oli2.Number_of_Months__c / 12) * oli2.Unit_Price2__c);
            } else if (oli2.Number_of_Months__c == null || oli2.Number_of_Months__c == 0 ) {
                oli2.UnitPrice = oli2.Unit_Price2__c;
            }
            if(oli2.Adjusted_Gross_Margin_Percentage__c == 0 && oli2.Product_Gross_Margin_Percent2__c != 0 ) {
                if (oli2.Number_of_Months__c > 0) {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity * (oli2.Number_of_Months__c / 12)) * (oli2.Product_Gross_Margin_Percent2__c/100);
                } else {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity) * (oli2.Product_Gross_Margin_Percent2__c/100);
                }
             } else if (oli2.Adjusted_Gross_Margin_Percentage__c > 0) {
                if (oli2.Number_of_Months__c > 0) {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity * (oli2.Number_of_Months__c / 12)) * (oli2.Adjusted_Gross_Margin_Percentage__c/100);
                } else {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity) * (oli2.Adjusted_Gross_Margin_Percentage__c/100);
                }
            }//END if(oli2.Adjusted_Gross_Margin_Percentage__c == 0 || oli2.Adjusted_Gross_Margin_Percentage__c == null) 
            
        }//END for (OpportunityLineItem oli2: trigger.new)
    }//if(trigger.isInsert || trigger.isUpdate && trigger.isBefore) 

//---------AFTER TRIGGER BELOW--------------

    if(trigger.isAfter) {
        for (OpportunityLineItem oli3: trigger.new){
            oppids.add(oli3.opportunityId);
            
        }//END for (OpportunityLineItem oli3: trigger.new)
        List<OpportunityLineItem> allOLI = [SELECT id, Number_of_Months__c FROM OpportunityLineItem WHERE OpportunityId in: oppids];
        List<Opportunity> oppsToUpdate = [SELECT id, Contract_Length_Months__c FROM Opportunity WHERE id in: oppids];
        if(allOLI.size() > 0){
            for(OpportunityLineItem allOLI2: allOLI){
                if(allOLI2.Number_of_Months__c > contractLengthMonths){
                    contractLengthMonths = allOLI2.Number_of_Months__c;
                } else if (allOLI2.Number_of_Months__c == null) {
                    contractLengthMonths = 12;
                }
            } //END for(OpportunityLineItem allOLI2: allOLI)
            for(Opportunity oppUpdate: oppsToUpdate){
                oppUpdate.Contract_Length_Months__c = contractLengthMonths;
                opps.add(oppUpdate);
            }// END for(Opportunity oppUpdate: oppsToUpdate)
 
        }//END if(allOLI.size() > 0
        update opps;
    }//if(trigger.isAfter)
}//END OpportunityLineItem Class

trigger OpportunityLineItemTrigger on OpportunityLineItem ( after update) {
    List<Id> oppIds = new List<Id>();
    Decimal contractLengthMonths = 0;

    if(trigger.isAfter) {
        for (OpportunityLineItem oli3: trigger.new){
            oppids.add(oli3.opportunityId);
        }//END for (OpportunityLineItem oli3: trigger.new)
        List<OpportunityLineItem> allOLI = [SELECT id, Number_of_Months__c FROM OpportunityLineItem WHERE OpportunityId in: oppids];
        List<Opportunity> oppsToUpdate = [SELECT id, Contract_Length_Months__c FROM Opportunity WHERE id in: oppids];
        if(allOLI.size() > 0){
            for(OpportunityLineItem allOLI2: allOLI){
                if(allOLI2.Number_of_Months__c > contractLengthMonths){
                    contractLengthMonths = allOLI2.Number_of_Months__c;
                }//END if(allOLI2.Number_of_Months__c > contractLengthMonths)
            } //END for(OpportunityLineItem allOLI2: allOLI)
            for(Opportunity oppUpdate: oppsToUpdate){
                oppUpdate.Contract_Length_Months__c = contractLenghtMonths;
            }// END for(Opportunity oppUpdate: oppsToUpdate)
 
        }
    }//if(trigger.isAfter)
}//END OpportunityLineItem Class

oppUpdate.Contract_Length_Months__c = contractLenghtMonths;

({
	navigate : function(component) {
        var action = component.get("c.getOpportunity");
		var idOpp = component.get("v.recordId");
        var SCMAid = component.get("v.aid");
        var SCMFormId = component.get("v.formId");
		if(!$A.util.isEmpty(idOpp))
		{
			action.setParams({opportunityId: idOpp});
		
			// Create a callback that is executed after 
			// the server-side action returns
			action.setCallback(this, function(response) {
				var state = response.getState();
				if (state === "SUCCESS") {
					var opp = response.getReturnValue();
                    /* Here you can access like opp.Id, opp.FTEs__c, opp.Account.Industry and form the URL */
                    var fullTimeEmployees = opp.Total_FTEs__c;
                    var industry = opp.Account.Industry;
                    var programStartDate = $A.localizationService.formatDate(Date(opp.ProgramStartDate__c),"MM/DD/YYYY");  
                    var opportunityId = opp.Id;
                    var opportunityName = opp.Name;                    
					var filePath = '/Accounts/'+ opp.Account.Name + '/Opportunities/&ru=%2Fatlas%2Fbpm%2FWorkList.aspx'
                    var partOneURL = 'https://na123.springcm.com/atlas/Forms/UpdateFormDoc.aspx?';
					
                    var partTwoURL = 'aid='+SCMAid;
                    var formUid = SCMFormId;
                    if(SCMAid == '9999') {
                        //Sandbox URL
                        var partOneURL = 'https://uatna123.springcm.com/atlas/Forms/UpdateFormDoc.aspx?';
                    } else {
                        //Production URL
                        var partOneURL = 'https://na123.springcm.com/atlas/Forms/UpdateFormDoc.aspx?';
                    }
					var finalURL = partOneURL + partTwoURL 
                    var finalURL = finalURL + '&FormUid=' + formUid;
                    var finalURL = finalURL + '&SFFTE=' + fullTimeEmployees;
                    var finalURL = finalURL + '&SFIND=' + industry;
                    var finalURL = finalURL + '&SFPSD=' + programStartDate;
                    var finalURL = finalURL + '&SFID=' + opp.Id;
                    var finalURL = finalURL + '&SFNAME=' + opportunityName;
                    var finalURL = finalURL + '&SFWF=ABC';
                    var finalURL = finalURL + '&SFCAFTYPE=CAAF';
                    var finalURL = finalURL + '&SFTYPE=Salesforce.Opportunity';
                    var finalURL = finalURL + '&SFPATH=' + filePath;
                    var urlEvent=$A.get("e.force:navigateToURL");
                    urlEvent.setParams({"url": finalURL});
					urlEvent.fire();
				}
				else if (state === "ERROR") {
					var errors = response.getError();
					if (errors) {
						if (errors[0] && errors[0].message) {
							console.log("Error message: " + 
									 errors[0].message);
						}
					} else {
						console.log("Unknown error");
					}
				}
			});

			// optionally set storable, abortable, background flag here

			// A client-side action could cause multiple events, 
			// which could trigger other events and 
			// other server-side action calls.
			// $A.enqueueAction adds the server-side action to the queue.
			$A.enqueueAction(action);
		}
		else
		{
			console.log('===Record Id is not present====');
		}
	}
})

<apex:page standardController="Opportunity" extensions="opportunityProductEntryExtension" action="{!priceBookCheck}" >
    <apex:sectionHeader Title="Manage {!$ObjectType.Product2.LabelPlural}" subtitle="{!opportunity.Name}"/>
    <apex:messages style="color:red"/>

    <style>
        .search{
            font-size:14pt;
            margin-right: 20px;    
        }
        .fyi{
            color:red;
            font-style:italic;
        }
        .label{
            margin-right:10px;
            font-weight:bold;
        }
        
    </style>
    
    <script type='text/javascript'>
    
        // This script assists the search bar functionality
        // It will execute a search only after the user has stopped typing for more than 1 second
        // To raise the time between when the user stops typing and the search, edit the following variable:
        
        var waitTime = 1;
        
    
        var countDown = waitTime+1;
        var started = false;
        
        function resetTimer(){
        
            countDown=waitTime+1;
            
            if(started==false){
                started=true;
                runCountDown();
            }
        }
        
        function runCountDown(){
        
            countDown--;
            
            if(countDown<=0){
                fetchResults();
                started=false;
            }
            else{
                window.setTimeout(runCountDown,1000);
            }
        }
        function updateSeats() {
            var totalSeats = document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.seatColumn.Seats}");
            document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.yearOneColumn.pageBlockSectionYearOne.result}").value = totalSeats;
            }

               
    </script>

    <apex:form id="pageform" >
    
        <apex:outputPanel id="mainBody">
        
            <apex:outputLabel styleClass="label">PriceBook: </apex:outputLabel>
            <apex:outputText value="{!theBook.Name}"/>&nbsp;
            <apex:commandLink action="{!changePricebook}" value="change" immediate="true"/>
            <br/>
            <!-- not everyone is using multi-currency, so this section may or may not show -->
            <apex:outputPanel rendered="{!multipleCurrencies}">
                <apex:outputLabel styleClass="label">Currency: </apex:outputLabel>
                <apex:outputText value="{!chosenCurrency}"/>
                <br/>
            </apex:outputPanel>
            <br/>
            
<!-- this is the upper table... a.k.a. the "Shopping Cart"-->

            <!-- notice we use a lot of $ObjectType merge fields... I did that because if you have changed the labels of fields or objects it will reflect your own lingo -->
            <apex:pageBlock title="Selected {!$ObjectType.Product2.LabelPlural}" id="selected">
                       
                <apex:pageblockTable value="{!shoppingCart}" var="s" id="pageblocktable">
                
                    <apex:column >
                        <apex:commandLink value="Remove" action="{!removeFromShoppingCart}" reRender="selected,searchResults" immediate="true">
                            <!-- this param is how we send an argument to the controller, so it knows which row we clicked 'remove' on -->
                            <apex:param value="{!s.PriceBookEntryId}" assignTo="{!toUnselect}" name="toUnselect"/>
                        </apex:commandLink>
                    </apex:column>
                    <apex:column headerValue=" " title="{!$ObjectType.Product2.fields.Name.inlineHelpText}"> 
                        <apex:pageBlockSection >
                        <apex:inputField value="{!s.Program_Start_Date__c}" label="Program Start Date :"
                                                                            rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                                            required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        </apex:pageBlockSection>
                        <apex:outputField value="{!s.PriceBookEntry.Product2.Name}"/><br/>
                        <i>Line Item Description : </i>
                        <apex:inputField value="{!s.Description}" /><br/>
                        
                        
                    </apex:column>
                    <apex:column headerValue="">
                        <br/><br/>
                        # of&nbsp;<apex:outputField value="{!s.PricebookEntry.Product2.Unit_of_Measure_Plural__c}" style="width:180px"/><br/>
                        <apex:outputText value="Svc Channel" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/><br/><br/>
                        <apex:outputText value="Qtrly Seat Ramp :" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/>
                    </apex:column>
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.Quantity.inlineHelpText}" id="yearOneColumn">
                        <br/>
                        <apex:inputField value="{!s.Quantity}" style="width:50px" />
                        <apex:inputField value="{!s.Service_Channel__c}" 
                                         rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                         required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:pageBlockSection id="pageBlockSectionYearOne">
                        
                        <apex:inputField value="{!s.X2018_Q1_Seats__c}" style="width:30px" id="result" 
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2018_Q2_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2018_Q3_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2018_Q4_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        </apex:pageBlockSection> 
                     </apex:column>  
                        <apex:outputText value="2018 Q3" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText>                    
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.Number_of_Months__c.inlineHelpText}">
                        <center>
                        <b>Contract Length (Months)</b>
                        <apex:inputField value="{!s.Number_of_Months__c}" style="width:50px"/>
                        </center>
                    </apex:column>
                    <apex:column headerValue="">
                        price per&nbsp;<apex:outputField value="{!s.PricebookEntry.Product2.Unit_of_Measure_Singular__c}" style="width:160px"/><br/>
                        <apex:outputText value="Service Type" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/><br/><br/>
                        <apex:outputText value="Qtrly Seat Ramp :" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/>
                    </apex:column>
                    
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.UnitPrice.inlineHelpText}">
                        <apex:inputField value="{!s.Unit_Price2__c}" style="width:70px" required="true"  />
                        <apex:inputField value="{!s.Service_Type__c}"
                                         rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                         required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:pageBlockSection >
                        
                        <apex:inputField value="{!s.X2019_Q1_Seats__c}" style="width:30px" 
                                                 rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                 required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2019_Q2_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2019_Q3_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2019_Q4_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        </apex:pageBlockSection>
                    </apex:column>
                    <apex:column headerValue=" " title="Enter Your Specific Margin - Pre-Populated with Avg">
                        <center>
                        <b>Adj GM%</b>
                        <apex:inputField value="{!s.Adjusted_Gross_Margin_Percentage__c}" style="width:30px" />
                        </center>
                    </apex:column>
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.One_Time_Revenue__c.inlineHelpText}">
                        <center>
                        <b>One-Time Rev</b>
                        <apex:inputCheckbox value="{!s.One_Time_Revenue__c}"  />
                        </center>
                    </apex:column>
                    <apex:column headerValue=" " title=" ">
                        <apex:outputLabel rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}" style="width:50px">Total # of Seats&nbsp;</apex:outputLabel>
                        <br/><br/><br/><br/><br/><br/>
                    </apex:column>

                    <apex:column headerValue=" " title="{!$ObjectType.OpportunityLineItem.fields.Seats__c.inlineHelpText}" id="seatColumn">
                        
                        <apex:inputField value="{!s.Seats__c}"  style="width:50px"  onkeyup="refreshTotals();"  id="Seats" onclick="updateSeats()"
                                      rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                      required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <br/><br/><br/><br/><br/><br/>
                    </apex:column>

                </apex:pageblockTable>
            
            
                <apex:pageBlockButtons >
                    <apex:commandButton action="{!onSave}" value="Save"/>
                    <apex:commandButton action="{!onCancel}" value="Cancel" immediate="true"/>
                </apex:pageBlockButtons>
            
            </apex:pageBlock>   
            <apex:pageBlock >
                <apex:outputPanel styleClass="search">
                    Search for {!$ObjectType.Product2.LabelPlural}:
                </apex:outputPanel>
                <apex:actionRegion renderRegionOnly="false" immediate="true">
                    <apex:actionFunction name="fetchResults" action="{!updateAvailableList}" reRender="searchResults" status="searchStatus"/>
                    <apex:selectList value="{!selectedProdFamily}" label="Select Product Family : " multiselect="false" size="1">
                        <apex:actionSupport event="onchange" action="{!updateAvailableList}" />
                        <apex:selectOptions value="{!ProductFamily}"  />
                    </apex:selectList>
                    &nbsp;&nbsp;                 
                    <apex:inputText value="{!searchString}" onkeydown="if(event.keyCode==13){this.blur();}else{resetTimer();}" style="width:300px"/>
                    &nbsp;&nbsp;
                                  <apex:actionStatus id="searchStatus" startText="searching..." stopText=" "/>
                    </i>    
                </apex:actionRegion>
            
                <br/>
                <br/>
            
                <apex:outputPanel id="searchResults">
                    <apex:pageBlockTable value="{!AvailableProducts}" var="a">                       
                        <apex:column headerValue="{!$ObjectType.Product2.Fields.Family.Label} / Company" value="{!a.Product2.Family}"/>
                        <apex:column headerValue="{!$ObjectType.Product2.Fields.Name.Label}" value="{!a.Product2.Name}" />                      
                        <apex:column headerValue="{!$ObjectType.Product2.Fields.Product_Gross_Margin__c.Label}" value="{!a.Product2.Product_Gross_Margin__c}"/>                    
                        <apex:column >
                            <!-- command button in a column... neato -->
                            <apex:commandButton value="Select" action="{!addToShoppingCart}" reRender="selected,searchResults" immediate="true">
                                <!-- again we use apex:param to be able to tell the controller which row we are working with -->
                                <apex:param value="{!a.Id}" assignTo="{!toSelect}" name="toSelect"/>
                            </apex:commandButton>
                        </apex:column>               
                    </apex:pageBlockTable>
                    <!-- We put up a warning if results exceed 100 rows -->
                    <apex:outputPanel styleClass="fyi" rendered="{!overLimit}">
                        <br/>
                        Your search returned over 100 results, use a more specific search string if you do not see the desired {!$ObjectType.Product2.Label}.
                        <br/>
                    </apex:outputPanel>            
                </apex:outputPanel>
            </apex:pageBlock>
        </apex:outputPanel>
    </apex:form>
</apex:page>

<script>
function updateSeats() {
            var totalSeats = document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.seatColumn.Seats}");
            document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.yearOneColumn.pageBlockSectionYearOne.result}").value = totalSeats;
            }
</script>

{!REQUIRESCRIPT("/soap/ajax/10.0/connection.js")} 
{!REQUIRESCRIPT("/soap/ajax/10.0/apex.js")} 

//Should not have to change this at all 
function getEOSInfo(objectid,objecttype,callback) { 

var baseUrl = "{!$Api.Partner_Server_URL_260}".substring(0, "{!$Api.Partner_Server_URL_260}".indexOf("/services")); 
var url = baseUrl +"/services/apexrest/SpringCMEos/eosinfo?objecttype="+objecttype+"&objectid="+objectid; 
var authkey = "Bearer {!$Api.Session_ID}"; 

sforce.connection.remoteFunction({ 
url : url, 
method:"GET",
requestHeaders: {"Authorization":authkey,"Accept":"application/json"}, 
onSuccess : function(response) { 
var eosInfoResponse = JSON.parse(response); 
callback(eosInfoResponse); 
alert(response);
} 
}); 
} 


//Here you write your own code, this is a simple call 
var objectid = "{!Account.Id}"; 
var objecttype = "Account"; 

getEOSInfo(objectid,objecttype,function(eosInfo){ 

var formuid = "ab227d3b-188c-e711-9c0d-3ca82a1e3f41"; 
var url = "https://uatna11.springcm.com/atlas/Forms/UpdateFormDoc.aspx?aid=7284&FormUid=" + formuid + "&SFID=" + eosInfo.SFId + "&SFTYPE=Salesforce.Account&SFPATH=" + eosInfo.FolderPath + "&ru=%2Fatlas%2Fbpm%2FWorkList.aspx"; 

window.open(url); 

});

<aura:component implements="force:lightningQuickAction,force:appHostable,flexipage:availableForAllPageTypes,force:hasRecordId" access="global" 
                controller="CAFController">
    
    <aura:attribute name="recordId" type="Id" />
    
    <div id="aura-page">
        <div class="container">
			<ui:button class="btn" label="CAF Form" press="{!c.navigate}"/> 
        </div>
    </div>
</aura:component>

({
	navigate : function(component, event, helper) {
		helper.navigate(component);
	}
})

({
	navigate : function(component) {
        var action = component.get("c.getOpportunity");
        action.setParams({opportunityId: component.get("v.recordId")});
        var urlEvent=$A.get("e.force:navigateToURL");
        var partOneURL = 'https://XXX21.springcm.com/atlas/Forms/UpdateFormDoc.aspx?aid=9124&FormUid=8beXXXXX-d9b0-e611-bb8d-6c3be5XXXXXXX';
        urlEvent.setParams({"url": partOneURL})
        urlEvent.fire();
	}
})

public class CAFController {

    @AuraEnabled
    public static Opportunity getOpportunity(ID opportunityId){
        if(opportunityId == null) {
            return null;
        }
        List<Opportunity> opps = [SELECT id, 
                                         Opportunity.FTEs__c,
                                         Opportunity.Account.Industry ,
                                         Opportunity.TotalNumberofSeats__c ,
                                         Opportunity.CAPEX_Required__c ,
                                         Opportunity.Amount ,
                                         Opportunity.Annualized_Revenue__c,
                                         Opportunity.ProgramStartDate__c ,
                                         Opportunity.Name
                                  FROM Opportunity
                                  WHERE Id =: opportunityId];
        if(opps.size()>0){
            return opps[0];
        }
        return null;
    }
}

{!REQUIRESCRIPT("/soap/ajax/10.0/connection.js")} 
{!REQUIRESCRIPT("/soap/ajax/10.0/apex.js")} 

//Should not have to change this at all 
function getEOSInfo(objectid,objecttype,callback) { 

var baseUrl = "{!$Api.Partner_Server_URL_260}".substring(0, "{!$Api.Partner_Server_URL_260}".indexOf("/services")); 
var url = baseUrl +"/services/apexrest/SpringCMEos/eosinfo?objecttype="+objecttype+"&objectid="+objectid; 
var authkey = "Bearer {!$Api.Session_ID}"; 

sforce.connection.remoteFunction({ 
url : url, 
requestHeaders: {"Authorization":authkey,"Accept":"application/json"}, 
onSuccess : function(response) { 
var eosInfoResponse = JSON.parse(response); 
callback(eosInfoResponse); 
} 
}); 
} 


//Here you write your own code, this is a simple call 
var objectid = "{!Opportunity.Id}"; 
var objecttype = "Opportunity"; 

getEOSInfo(objectid,objecttype,function(eosInfo){ 


var formuid = "8be07531-XXXX-e611-XXXX-6c3be5a7XXXX"; 
var url = "https://XXX21.springcm.com/atlas/Forms/UpdateFormDoc.aspx?aid=9723&FormUid=" + formuid + "&SFFTE={!Opportunity.FTEs__c}&SFIND={!Account.Industry}&SFPSD={!Opportunity.ProgramStartDate__c}&SFID=" + eosInfo.SFId + "&SFNAME={!Opportunity.Name}&SFWF=ABC&SFCAFTYPE=CAAF&SFTYPE=Salesforce.Opportunity&SFPATH=" + eosInfo.FolderPath + "&ru=%2Fatlas%2Fbpm%2FWorkList.aspx"; 

window.open(url); 

});

public class OpportunityRevenueTrigger2 {

    
    public static void updateOpportuntityRev(List<Opportunity> trig){
         List<ID> opprtnyId = new List<ID>();
         Decimal totRev;
         Decimal totAllottedRev;
         Decimal mRev;
         
         for(Opportunity opp4: trig){
            if(Opp4.Auto_Generate_Quarterly_Forecast__c == 'Yes'){
                opprtnyId.add(opp4.id);
            }
         List<Opportunity_Revenue__c> deleteOR = [SELECT id
                                                 FROM Opportunity_Revenue__c 
                                                 WHERE Opportunity__c in: opprtnyID];
         
        if(deleteOR.size() != 0){
           Delete deleteOR;
         }
        
        List<Opportunity_Revenue__c> oppr = new List<Opportunity_Revenue__c>();
        for(Opportunity opp : trig){
             
             if(opp.amount > 0 && opp.contract_length_Months__c > 0 
               && opp.Auto_Generate_Quarterly_Forecast__c == 'Yes' ){
                   Date sDate = opp.CloseDate;
                   Integer period = opp.Contract_Length_Months__c.intValue();
                   Integer period2 = period / 3;
                   totRev = opp.Amount;
                   mRev = totRev.divide(period2, 2);
                   for(Integer i = 1; i <= period2; i++) {
                   Opportunity_Revenue__c oppr2 = new Opportunity_Revenue__c();
                   oppr2.Account__c = opp.AccountId;
                   oppr2.Opportunity__c = opp.id;
                   System.debug('i '+ i);
                   oppr2.ProjectedRevenue__c = mRev;
                   oppr2.Month__c = sDate;
                       if(sDate.Month()== 1 || sDate.month()==2 || sDate.month() ==3){
                           oppr2.Quarter__c =  'Quarter 1, '+string.valueOf(sDate.Year());   
                       } else if (sDate.Month()== 4 || sDate.month()== 5 || sDate.month() == 6){
                           oppr2.Quarter__c =  'Quarter 2, '+string.valueOf(sDate.Year());
                       } else if (sDate.Month()== 7 || sDate.month()== 8 || sDate.month() == 9){
                           oppr2.Quarter__c =  'Quarter 3, '+string.valueOf(sDate.Year());
                       } else if (sDate.Month()== 10 || sDate.month()==11 || sDate.month() ==12){
                           oppr2.Quarter__c =  'Quarter 4, '+string.valueOf(sDate.Year());
                       }
                   
                   oppr.add(oppr2);
                   sDate = sDate.addMonths(3);
                   }
                  
        
              }
        }
        insert oppr;

    }
}
}

trigger OpportunityRevenueTrigger on Opportunity (after insert, after update) {
  
        
        OpportunityRevenueTrigger2.updateOpportuntityRev(trigger.new);
        
 
  }

trigger OpportunityRevenueTrigger on Opportunity (after insert, after update) {
    if(trigger.isInsert && trigger.isAfter){
        OpportunityRevenueTriggerInsertHandler.OppQuarterlyRevInsert(trigger.new);
        
    }//END is.Insert
    if(trigger.isUpdate && trigger.isAfter){
        OpportunityRevenueTriggerInsertHandler.OppQuarterlyRevDelete(trigger.new);
        OpportunityRevenueTriggerInsertHandler.OppQuarterlyRevInsert(trigger.new); 
    }//END isUpdate
    
}

public class OpportunityRevenueTriggerInsertHandler {

    public static void OppQuarterlyRevInsert(List<Opportunity> trig){
        Date eDate; //this is the date that the projection should run through
        Date sDate; //this is the date that the projection should start
        Integer period; // Opp Contract_Length_Months__c is a decimal need to convert
        Decimal dRev; // Revenue per Day
        Decimal mRev; // Revenue per Month
        Decimal qRev; //Revenue per Quarter
        Integer dayDiff;
        Integer dayDiff2;
        List<Opportunity_Revenue__c> oppr = new List<Opportunity_Revenue__c>();
        for(Opportunity opp : trig){
            
            //Month Count Must be greater than 2
            if(opp.amount > 0 && opp.contract_length_Months__c > 0 
               && opp.Auto_Generate_Quarterly_Forecast__c == 'Yes'){
                             
                sDate = opp.CloseDate;
                period = opp.contract_length_months__c.intValue();
                eDate = opp.CloseDate.addMonths(period);
                dayDiff = sDate.daysBetween(eDate);
                System.debug('dayDiff '+dayDiff);
                dRev = opp.Amount /dayDiff;
                System.debug('dRev '+ dRev);
                mRev = opp.Amount / period;
                System.debug('mRev ' +mRev);
                qRev = mRev * 3;
                while (sDate < eDate){
                    Opportunity_Revenue__c oppr2 = new Opportunity_Revenue__c();
                    oppr2.Account__c = opp.AccountId;
                    oppr2.Opportunity__c = opp.id;
                    oppr2.Opportunity_Projected_Revenue__c = opp.Amount;
                    oppr2.Month__c = sDate;
                    if(opp.Contract_Length_Months__c > 2) {
                        if(sDate.Month()== 1 || sDate.month()==2 || sDate.month() ==3) {
                            dayDiff2 = sDate.daysBetween(eDate);
                            System.debug('dayDiff2 '+ dayDiff2);
                            if(sDate.daysBetween(eDate) < 90 ) {
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 1, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = dRev * sDate.daysBetween(eDate);    
                            } else { //END if(sDate.daysBetween(eDate) <90)
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 1, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = qRev;}
                        }//END if (sDate.month()==Q1)
                        if(sDate.Month()== 4 || sDate.month()==5 || sDate.month() ==6) {
                            dayDiff2 = sDate.daysBetween(eDate);
                            System.debug('dayDiff2 '+ dayDiff2);
                            if(sDate.daysBetween(eDate) < 90 ) {
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 2, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = dRev * sDate.daysBetween(eDate);    
                            } else { //END if(sDate.daysBetween(eDate) <90)
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 2, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = qRev;}
                        }//END if (sDate.month()==Q2)
                        if(sDate.Month()== 7 || sDate.month()==8 || sDate.month() ==9) {
                            dayDiff2 = sDate.daysBetween(eDate);
                            System.debug('dayDiff2 '+ dayDiff2);
                            if(sDate.daysBetween(eDate) < 90 ) {
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 3, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = dRev * sDate.daysBetween(eDate);    
                            } else { //END if(sDate.daysBetween(eDate) <90)
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 3, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = qRev;}
                        }//END if (sDate.month()==Q3)
                        if(sDate.Month()== 10 || sDate.month()==11 || sDate.month() ==12) {
                            dayDiff2 = sDate.daysBetween(eDate);
                            System.debug('dayDiff2 '+ dayDiff2);
                            if(sDate.daysBetween(eDate) < 90 ) {
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 4, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = dRev * sDate.daysBetween(eDate);    
                            } else { //END if(sDate.daysBetween(eDate) <90)
                                dayDiff2 = sDate.daysBetween(eDate);
                                System.debug('dayDiff2 '+ dayDiff2);
                                oppr2.Quarter__c = 'Quarter 4, '+string.valueOf(sDate.Year());
                                oppr2.ProjectedRevenue__c = qRev;}
                        }//END if (sDate.month()==Q4)
                    }//END if(opp.Contract_Length_Months__c > 2)
                    //if the Contract Length is less than a quarter
                    if (opp.contract_length_months__c < 3){
                        if(sDate.Month()== 1 || sDate.month()==2 || sDate.month() ==3) {
                            oppr2.Quarter__c = 'Quarter 1, '+string.valueOf(sDate.Year());
                            oppr2.ProjectedRevenue__c = opp.Amount;
                        }//END if (sDate.month()==Q1)
                        if(sDate.Month()== 4 || sDate.month()==5 || sDate.month() ==6) {
                            oppr2.Quarter__c = 'Quarter 2, '+string.valueOf(sDate.Year());
                            oppr2.ProjectedRevenue__c = opp.Amount;
                        }//END if (sDate.month()==Q2)
                        if(sDate.Month()== 7 || sDate.month()==8 || sDate.month() ==9) {
                            oppr2.Quarter__c = 'Quarter 3, '+string.valueOf(sDate.Year());
                            oppr2.ProjectedRevenue__c = opp.Amount;
                        }//END if (sDate.month()==Q3)
                        if(sDate.Month()== 10 || sDate.month()==11 || sDate.month() ==12) {
                            oppr2.Quarter__c = 'Quarter 4, '+string.valueOf(sDate.Year());
                            oppr2.ProjectedRevenue__c = opp.Amount;
                        }//END if (sDate.month()==Q4)
                    }//END if (opp.contract_length_months__c < 3)   
                    sDate = sDate.addMonths(3);  //increment month / Quarter 
                    oppr.add(oppr2);
                }//END while (sDate < eDate)
            }//END if(opp.amount > 0 && opp.contract_length_Months__c > 0) 
        }//END for(Opportunity opp : trig)
        insert oppr;      
    }//END OppQuarterlyRevInsert

    public static void OppQuarterlyRevDelete(List<Opportunity> trig) {
        
        List<ID> opprtnyId = new List<ID>();
        //Loop through and get all the ids
        for(Opportunity opp: trig){
            //Only put them in the List if you want them to be deleted
            if(Opp.Auto_Generate_Quarterly_Forecast__c == 'Yes'){
                opprtnyId.add(opp.id);
            }//END if
        }//END for(Opportunity opp: trig)
        //Get the Opportunity_Revenue__c records in the table to delete 
        List<Opportunity_Revenue__c> deleteOR = [SELECT id
                                                 FROM Opportunity_Revenue__c 
                                                 WHERE Opportunity__c in: opprtnyID];
        //if there are any records then delete them
        if(deleteOR.size() != 0){
           Delete deleteOR;
        }//END if
    }//END OppQuarterlyRevDelete(List<Opportunity> trig)
    public static void FlipFlag(List<Opportunity> trig){
        List<Opportunity> opp4 = new List<Opportunity>();
        for(Opportunity opp3 : trig){
            opp3.Auto_Generate_Quarterly_Forecast__c ='No';
            opp4.add(opp3);
        }
        update opp4;
    }
}//END OpportunityRevenueTriggerInsertHandler

Public List<Contact> contList;

for(Red_Zone__c rzAcct: [SELECT Account__c, status__c, Escalation__c FROM Red_Zone__c WHERE status__c ='Open' and Escalation__c ='Red Zone']){
    if (rzAcct.Account__c != Null && rzAcct.status__c != Null && rzAcct.Escalation__c != Null){
            System.debug('rzAcct.id '+rzAcct.id);
            System.debug('rzAcct.Account__c '+rzAcct.Account__c);
            System.debug('rzAcct.Status__c '+rzAcct.status__c);
            System.debug('rzAcct.Escalation__c '+rzAcct.Escalation__c);
        for (Contact con: [SELECT account_relationship_status__c, AccountId FROM Contact WHERE AccountId =:rzAcct.Account__c]){
            System.debug('con.id '+con.id);
            System.debug('con.account_relationship_status__c '+con.account_relationship_status__c);
            System.debug('con.AccountID '+con.AccountId);
            
               con.account_relationship_status__c ='Red Zone';
               contList.add(con);
        }
   }
System.debug('contList '+ contList);
Update contList;    
}

SELECT id, Name, Opportunity__r.Name, Opportunity__r.Account.Name FROM EBR_Form__c

<apex:pageBlockTable value="{!myTeam}" var="r">
                 <apex:column >
                    <apex:commandLink value="Edit" action="{!editRecord}">
                        <apex:param name="myParmEdit" value="{!r.id}" assignTo="{!RecordID}"/>
                    </apex:commandLink>
                </apex:column>

public class AcctApexControllerExt {
public List<AccountTeamMember> myTeam { get; set; }
    
    public String acctID {get; set;}
    public String ATMID {get;set;}
    private ApexPages.StandardController stdCtrl {get; set;}
    public String recordID {get; set;}
    
    public AcctApexControllerExt(ApexPages.StandardController controller) {
        stdCtrl= controller;
        setupAccountTeam();
                
    }
    public void setupAccountTeam(){
        myTeam = [SELECT Id,
                         AccountId,
                         TeamMemberRole, 
                         User.Country,
                         UserId, 
                         User.Name, 
                         User.Email, 
                         User.CompanyName, 
                         User.Title, 
                         User.FullPhotoUrl, 
                         User.SmallPhotoUrl 
                  FROM AccountTeamMember 
                  WHERE AccountId =: stdCtrl.getId() LIMIT 200];

    }    
    public PageReference addRedirect(){
        acctID = ApexPages.currentPage().getParameters().get('id');
        PageReference redir = new PageReference('/opp/salesteaminsert.jsp?retURL=%2F'+ acctID + '&id=' +acctID);
        redir.setRedirect(true);
        return redir;
    }
   public PageReference deleteRecord(){
       AccountTeamMember atm1 = new AccountTeamMember(id=ATMId);
       delete atm1;
       setupAccountTeam();
       return null;
    }
    public PageReference editRecord(){
        acctID = ApexPages.currentPage().getParameters().get('id');
        AccountTeamMember u = new AccountTeamMember(id=recordID);
        ID recID = u.id;
        PageReference redir2 = new PageReference('/acc/salesteamedit.jsp?id='+ u.Id + '&retURL='+ acctID);
        redir2.setRedirect(true);
        return redir2;
    }

}

@isTest
public class AcctApexControllerExt_Test {
    
     static testMethod void AcctApexControllerExt_Test1(){
        Account acct = new Account (Name     = 'Test Account',
                                    Industry = 'Retail:Other') ;
        insert acct;
        Profile prof = [select id from profile where name='system Administrator'];
        User usr = new User(alias = 'usr', email='us.name@vmail.com',
                            emailencodingkey='UTF-8', lastname='lstname',
                            timezonesidkey='America/Los_Angeles',
                            languagelocalekey='en_US',
                            localesidkey='en_US', profileid = prof.Id,
                            username='testuser128@testorg.com',MobilePhone='87564231',Phone='451234789');
        insert usr;
        
        PageReference pageRef = Page.tabbedAccount;
        pageRef.getParameters().put('id', acct.id); 
        ApexPages.StandardController stdController = new ApexPages.StandardController(acct);
        AcctApexControllerExt ext = new AcctApexControllerExt(stdController);
        test.setCurrentPage(pageRef);
        ext.addRedirect();
        ext.setupAccountTeam();
        List<AccountTeamMember> results = ext.myTeam;
        system.assertEquals(results.size(), 0);
    }
}

public class MyProfilePageController2 {

    public List<AccountTeamMember> myTeam { get; set; }
    public Account acct {get; set;}
    public String acctID {get; set;}
    public String ATMID {get;set;}
    
    public MyProfilePageController2(ApexPages.StandardController controller) {
        Account acct = (Account) controller.getRecord();
        
        myTeam = [SELECT Id,AccountId,TeamMemberRole, User.Country,UserId, User.Name, User.Email, User.CompanyName, User.Title, User.FullPhotoUrl, User.SmallPhotoUrl FROM AccountTeamMember where AccountId =:acct.Id];
        
    }
    public PageReference addRedirect(){
        
        acctID = ApexPages.currentPage().getParameters().get('id');
       
        PageReference redir = new PageReference('/opp/salesteaminsert.jsp?retURL=%2F'+ acctID + '&id=' +acctID);
        redir.setRedirect(true);
        return redir;
    }
   public PageReference deleteRecord(){
        
       AccountTeamMember atm1 = new AccountTeamMember(id=ATMId);
       
       delete atm1;
       
       return null;
    }

}

<apex:page StandardController="Account" extensions="MyProfilePageController2">

  <apex:tabPanel switchType="client">
   
    <!-- first tab - overview of the account with the standard detail component -->
    <apex:tab label="Overview" name="Overview">
      <apex:detail relatedList="false" /> 
    </apex:tab>
      
    <!-- second tab - iterate the contacts related list-->
    <apex:tab label="Contacts" name="Contacts">
      <apex:repeat value="{!Account.contacts}" var="contact">
        <apex:pageBlock title="{!contact.name}">
          <apex:pageBlockSection >
            <apex:pageBlockSectionItem >
              <apex:outputLabel value="Name"/>
              <apex:outputLink value="{!URLFOR($Action.Contact.View, contact.id)}">
                <apex:outputField value="{!contact.name}" />
              </apex:outputLink>
            </apex:pageBlockSectionItem>
            <apex:pageBlockSectionItem />
            <apex:outputField value="{!contact.Email}" />
            <apex:outputField value="{!contact.HasOptedOutOfEmail}" />
            <apex:outputField value="{!Contact.Phone}" />
            <apex:outputField value="{!Contact.DoNotCall}" />
            <apex:outputField value="{!contact.Fax}" />
            <apex:outputField value="{!contact.HasOptedOutOfFax}" />
          </apex:pageBlockSection>
        </apex:pageBlock>
           
        <!-- include the open activities for the contact via the standard relatedList component -->
        <apex:relatedList subject="{!contact}" list="OpenActivities" />
        <br/>
      </apex:repeat>
    </apex:tab>
      
    <!-- third tab - iterate the opportunities related list -->
    <apex:tab label="Open Opportunities" name="Open Opportunities">
      <apex:repeat value="{!Account.Opportunities}" var="opp">
      
        <!-- only show open opportunities -->
        <apex:outputPanel rendered="{!NOT(opp.IsClosed)}">
          <apex:pageBlock title="{!opp.Name}">
            <apex:pageBlockSection >
              <apex:pageBlockSectionItem >
                <apex:outputLabel value="Name"/>
                <apex:outputLink value="{!URLFOR($Action.Opportunity.View, opp.id)}">
                  <apex:outputField value="{!opp.name}" />
                </apex:outputLink>
              </apex:pageBlockSectionItem>
              <apex:pageBlockSectionItem />
              <apex:outputField value="{!opp.CloseDate}" />
              <apex:outputField value="{!opp.Amount}" />
              <apex:outputField value="{!opp.StageName}" />
              <apex:outputField value="{!opp.Probability}" />
            </apex:pageBlockSection>
          </apex:pageBlock>
           
          <!-- include the line items for the opportunity via the standard relatedList component -->
          <apex:relatedList subject="{!opp}" list="OpportunityLineItems" />
        </apex:outputPanel>
      </apex:repeat>
    </apex:tab>
    

    
  <!--Fourth Panel-->

  <apex:tab label="Account Team Members" name="Account Team">
     
<apex:outputPanel >
       <apex:form >  
        <apex:pageBlock >
            <apex:pageBlockSection >
                <apex:commandButton value="Add" action="{!addRedirect}" />
                
            </apex:pageBlockSection>

            <apex:pageBlockTable value="{!myTeam}" var="r">
                <apex:column >
                    <a href="/acc/salesteamedit.jsp?id={!r.id}&retURL={!r.AccountId}">Edit</a>
                </apex:column>
                <apex:column>
                    <apex:commandLink value="Delete" action="{!deleteRecord}">
                       <apex:param name="myParam" value="{!r.id}" assignTo="{!ATMId}"/>
                    </apex:commandLink>
                </apex:column>
                <apex:column >
                    <apex:image id="profileImage" value="{!r.User.SmallPhotoUrl}" />
                </apex:column>
                <apex:column headerValue="Name">
                   <a href="/_ui/core/userprofile/UserProfilePage?u={!r.User.id}">{!r.User.Name}</a>
                </apex:column>
                <apex:column value="{!r.User.Title}"/>
                <apex:column value="{!r.TeamMemberRole}"/>
                <apex:column value="{!r.User.CompanyName}"/>
                <apex:column value="{!r.User.Email}"/>
                <apex:column value="{!r.User.Country}"/>  
            </apex:pageBlockTable>

      </apex:pageBlock>
      </apex:form>
</apex:outputPanel>
     
</apex:tab>
    </apex:tabPanel>
</apex:page>

<apex:page standardController="AccountTeamMember">
    
    <apex:form>
    
        <apex:pageBlock title="Account Team Members">
            <apex:pageBlockTable value="{!AccountTeamMember}" var="ATM">
                <apex:column headerValue="Account Member Name">
                    <apex:outputField value="{!ATM.User.Name}"/>
                </apex:column>
                <apex:column headerValue="Account Member Title">
                    <apex:outputField value="{!AccountTeamMember.User.Title}" />
                </apex:column>
                <apex:column headerValue="Company Name">
                    <apex:outputField value="{!AccountTeamMember.User.CompanyName}" />
                </apex:column>
                <apex:column headerValue="Account Member Country">
                    <apex:outputField value="{!AccountTeamMember.User.Country}" />
                </apex:column>
                <apex:column headerValue="Account Member Role">
                    <apex:outputField value="{!AccountTeamMember.TeamMemberRole}" />
                </apex:column>
                <apex:column headerValue="Account Member Email">
                    <apex:outputField value="{!AccountTeamMember.User.Email}" />
                </apex:column>
                <apex:column>
                    <apex:image id="profileImage" url="{!AccountTeamMember.User.FullPhotoUrl}" />
                  
                </apex:column>
            </apex:pageBlockTable>
            
        </apex:pageBlock>
    </apex:form>
</apex:page>

public class AccSearchController {
    public List<Account> acc {get; set;}
    public String searchString {get; set;}
    public AccSearchController(ApexPages.StandardController controller) {  
    }
    public void search(){
        String searchQuery= 'SELECT id, name, owner.name, billingStreet, billingState, billingCity, billingCountry, '+
                            'recordtype.name, industry FROM Account WHERE NAME LIKE \'%'+searchString+'%\'' +
                            'ORDER BY name Limit 200';
        acc = Database.query(searchQuery);
            }
    
    public pageReference reset(){
        this.searchString='';
        acc.clear();
        return null;
    }
    
}

@isTest
public class AccSearchController_Test {
   @isTest
    public static void testControllerExtension(){
    List<Account> acctList = [SELECT ID FROM Account];
       
    Test.setCurrentPage(Page.SearchAccountPage);
    ApexPages.StandardSetController stdSetController = new     ApexPages.StandardSetController(acctList);
    
    stdSetController.setSelected(acctList);
    
    AccSearchController ext = new AccSearchController(stdSetController);

    
    }

public class AccountSearch_CC {
    
    public String acctName {get; set;}

    public List<AccountWrapper> accountList {
        get {           
            if (accountList == null) {
                accountList = new List<AccountWrapper>();
                for (Account acct : [SELECT  Name, BillingAddress,  Industry, Vertical_Assignment__c FROM Account WHERE NAME =: acctName ]){
                    accountList.add(new AccountWrapper(acct));
                }
            }
            return accountList;
        }
        set;
    }
    public Map<ID, AccountWrapper> selectedAccounts {
        get {
            if (selectedAccounts ==null) {
                selectedAccounts = new Map<Id, AccountWrapper>();
            }
            return selectedAccounts;
        }
        set;
    }
    public PageReference listAccounts(){
        
        selectedAccounts.clear();
        
        for(AccountWrapper acctWpr : accountList) {
            if(acctWpr.checked) {
                selectedAccounts.put(acctWpr.acct.Id, acctWpr);
            }
        }
        if (selectedAccounts.size()>0){
            return Page.AcctSearch;
        } else {
            ApexPages.addMessage(new ApexPages.Message(ApexPages.Severity.ERROR, 'Please select at least one Account'));
            return null;
        }
        
    }
    
    public List<Account> available{
        get {
            if (available == null) {
                available = new List<Account>([SELECT Name, BillingAddress,  Industry, Vertical_Assignment__c FROM Account
                                              WHERE Id IN : selectedAccounts.keySet()]);
            }
            return available;
        }
        set;
    }
    
    public PageReference newSearch() {
        PageReference newPage = Page.SearchAccountPage;
        newPage.setRedirect(true);
        return NewPage;
    }
    
    public class AccountWrapper {
        public Account acct {get; set;}
        public Boolean checked {get; set;}
        
        public AccountWrapper(Account a){
            acct = a;
            checked = false;
        }
    }

}

<apex:page controller="AccountSearch_CC" tabStyle="Account">
    <apex:form >
        <apex:pageBlock title="Account Search">
            <apex:pageMessages >
            </apex:pageMessages>
            <apex:pageBlockButtons >
                <apex:commandButton action="{!listAccounts}" value="See Available Accounts" />
            </apex:pageBlockButtons>
            <apex:pageBlockTable var="a" value="{!accountList}">
                <apex:column width="25px" headerValue="Select">
                    
                    <apex:inputCheckbox value="{!a.checked}" />
                </apex:column>
                <apex:column value="{!a.acct.Name}"/>
                
            </apex:pageBlockTable>
        </apex:pageBlock>
    </apex:form>
</apex:page>

<apex:page controller="AccountSearch_CC">
    <apex:form >
        <apex:pageBlock title="Search for Accounts">
            <apex:pageMessages />
            <apex:pageBlockButtons >
                <apex:commandButton action="{!newSearch}" value="New Search" />   
                <apex:inputText value="{!acctName}" id="SearchString" maxlength="25" size="30"/>
            </apex:pageBlockButtons>
                <apex:pageBlockTable var="avail" value="{!available}">
                    <apex:column value="{!avail.Name}"/>
            
                </apex:pageBlockTable>
        </apex:pageBlock>
    </apex:form>
</apex:page>

TRIGGER

//Case Number 1381 - Provides information about request for Trigger
trigger UpdateOTRev on Opportunity (after insert, after update) {
    Set<id> triggerIds = new Set<id>();
    List<OpportunityLineItem> lstOLIUpdate = new List<OpportunityLineItem>();
    //See if Trigger has only been run once
    if(RecursiveTriggerHandler.isFirstTime){
        RecursiveTriggerHandler.isFirstTime = false;
         //Put all trigger opp ids into a set
         for(Opportunity Opps : Trigger.new){
            triggerIds.add(Opps.Id);
         }//END for (Opportunity Opps)
         //Get all the Opp and Products
         List<Opportunity> lstOpps = [SELECT id, CloseDate, (SELECT id, TotalPrice, One_Time_Revenue__c FROM OpportunityLineItems) FROM Opportunity 
                                      WHERE id in: triggerIds];
             //Loop through Opps
             for(Opportunity opp: lstOpps){
                 //Loop through Products in Opps
                 for(OpportunityLineItem oli : opp.OpportunityLineItems){
                     if(oli.One_Time_Revenue__c == true){
                        //Apply the logic of which fields to update
                        if(opp.CloseDate > Date.valueOf('2017-12-31') && opp.CloseDate < Date.valueOf('2018-04-01')){
                            oli.One_Time_Rev_Q1_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q1
                        if(opp.CloseDate > Date.valueOf('2018-03-31') && opp.CloseDate < Date.valueOf('2018-07-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q2
                        if(opp.CloseDate > Date.valueOf('2018-06-30') && opp.CloseDate < Date.valueOf('2018-10-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q3
                        if(opp.CloseDate > Date.valueOf('2018-09-30') && opp.CloseDate < Date.valueOf('2019-01-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q4
                        if(opp.CloseDate > Date.valueOf('2018-12-31') && opp.CloseDate < Date.valueOf('2019-04-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q1
                        if(opp.CloseDate > Date.valueOf('2019-03-31') && opp.CloseDate < Date.valueOf('2019-07-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q2
                        if(opp.CloseDate > Date.valueOf('2019-06-30') && opp.CloseDate < Date.valueOf('2019-10-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q3
                        if(opp.CloseDate > Date.valueOf('2019-09-30') && opp.CloseDate < Date.valueOf('2020-01-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = oli.TotalPrice;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q4
                        if(opp.CloseDate > Date.valueOf('2019-12-31')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            
                            lstOLIUpdate.add(oli);
                        }
                         
                     }//END if(oli.One_Time_Revenue__c == true)                     
                 }//END For(OpportunityLineItem)
             }//END for(Opportunity)
    //Update Products if there are any to update
    if(lstOLIUpdate.size()>0){
        update lstOLIUpdate;
    }
    }//END if(RecusiveTriggerHandler.isFirstTime)
}//END Class

@isTest
public class UpdateOTRevTest {
    
    public static testMethod void testOppOneTimeRevenue(){
        
        Product2 prod2= new Product2(Name = 'Test Product - OneTime',
                                     Product_Gross_Margin__c = 10,
                                     Delivery_Market__c = 'none' ,
                                     Delivery_Region__c = 'ABCD',
                                     Delivery_Site__c = 'none' ,
                                     Family = 'XTCD',
                                     Description = 'Test Product',
                                     IsActive = true,
                                     Project_Seat_Count__c = 'false',
                                     One_Time_Revenue__c = true);
        insert prod2;
        Id pricebookId = Test.getStandardPricebookId();
        PricebookEntry pbEntry = new PricebookEntry(Pricebook2Id = pricebookId,
                                                    product2Id = prod2.Id,
                                                    isActive = true,
                                                    UnitPrice = 1000);
        insert pbEntry;
       
        Opportunity opp = new Opportunity(Name = 'Test Account - Opportunity',
                                          StageName = '1 - Prospect',
                                          Type = 'New Logo', 
                                          CloseDate = System.Date.today(),
                                          LeadSource = 'BDD/AM/OPS Development',
                                          Referral_Channel__c = 'None',
                                          Auto_Generate_Quarterly_Forecast__c = 'Yes',
                                          Contract_Length_Months__c = 24,
                                          Pricebook2Id = pricebookId,
                                          Amount = 10000000);
        insert opp;
       
        OpportunityLineItem oli = new OpportunityLineItem(OpportunityId = opp.id,
                                                          PricebookEntryId = pbEntry.id,
                                                          Product2Id = prod2.id,
                                                          Quantity = 10, 
                                                          Unit_Price2__c = 20,
                                                          Adjusted_Gross_Margin_Percentage__c = 10,
                                                          Service_Channel__c = 'WIDGET',
                                                          Service_Type__c = 'Care',
                                                          One_Time_Revenue__c = true);
        insert oli;
        
        System.debug('Opportunity Product Total Price '+ oli.TotalPrice);
        System.debug('OpportunityLineItem Id ' +oli.Id);
        System.debug('Product 2 Id '+ oli.Product2Id);
        System.debug('Opportunity Line Item Name : '+ oli.Name);
        System.debug('One Time Revenue : '+oli.One_Time_Revenue__c);
        Date closeDate = System.today();
        opp.CloseDate = Date.newInstance(2018, 01, 25);
       
        update opp;
        System.debug('Opp Close Date : '+opp.CloseDate);
    }//END Method
}//END Class

//https://salesforce.stackexchange.com/questions/72883/how-to-create-opportunity-line-items-in-test-classes

public class OpportunityRevenueTrigger2 {

    
    public static void updateOpportuntityRev(List<Opportunity> trig){
         List<ID> opprtnyId = new List<ID>();
         Decimal totRev;
         Decimal totAllottedRev;
         Decimal mRev;
         
         for(Opportunity opp4: trig){
            if(Opp4.Auto_Generate_Quarterly_Forecast__c == 'Yes'){
                opprtnyId.add(opp4.id);
            }
         List<Opportunity_Revenue__c> deleteOR = [SELECT id
                                                 FROM Opportunity_Revenue__c 
                                                 WHERE Opportunity__c in: opprtnyID];
         
        if(deleteOR.size() != 0){
           Delete deleteOR;
         }
        
        List<Opportunity_Revenue__c> oppr = new List<Opportunity_Revenue__c>();
        for(Opportunity opp : trig){
             
             if(opp.amount > 0 && opp.contract_length_Months__c > 0 
               && opp.Auto_Generate_Quarterly_Forecast__c == 'Yes' ){
                   Date sDate = opp.CloseDate;
                   Integer period = opp.Contract_Length_Months__c.intValue();
                   Integer period2 = period / 3;
                   totRev = opp.Amount;
                   mRev = totRev.divide(period2, 2);
                   for(Integer i = 1; i <= period2; i++) {
                   Opportunity_Revenue__c oppr2 = new Opportunity_Revenue__c();
                   oppr2.Account__c = opp.AccountId;
                   oppr2.Opportunity__c = opp.id;
                   System.debug('i '+ i);
                   oppr2.ProjectedRevenue__c = mRev;
                   oppr2.Month__c = sDate;
                       if(sDate.Month()== 1 || sDate.month()==2 || sDate.month() ==3){
                           oppr2.Quarter__c =  'Quarter 1, '+string.valueOf(sDate.Year());   
                       } else if (sDate.Month()== 4 || sDate.month()== 5 || sDate.month() == 6){
                           oppr2.Quarter__c =  'Quarter 2, '+string.valueOf(sDate.Year());
                       } else if (sDate.Month()== 7 || sDate.month()== 8 || sDate.month() == 9){
                           oppr2.Quarter__c =  'Quarter 3, '+string.valueOf(sDate.Year());
                       } else if (sDate.Month()== 10 || sDate.month()==11 || sDate.month() ==12){
                           oppr2.Quarter__c =  'Quarter 4, '+string.valueOf(sDate.Year());
                       }
                   
                   oppr.add(oppr2);
                   sDate = sDate.addMonths(3);
                   }
                  
        
              }
        }
        insert oppr;

    }
}
}

trigger OpportunityRevenueTrigger on Opportunity (after insert, after update) {
  
        
        OpportunityRevenueTrigger2.updateOpportuntityRev(trigger.new);
        
 
  }

SELECT id, Name, Opportunity__r.Name, Opportunity__r.Account.Name FROM EBR_Form__c

TRIGGER

//Case Number 1381 - Provides information about request for Trigger
trigger UpdateOTRev on Opportunity (after insert, after update) {
    Set<id> triggerIds = new Set<id>();
    List<OpportunityLineItem> lstOLIUpdate = new List<OpportunityLineItem>();
    //See if Trigger has only been run once
    if(RecursiveTriggerHandler.isFirstTime){
        RecursiveTriggerHandler.isFirstTime = false;
         //Put all trigger opp ids into a set
         for(Opportunity Opps : Trigger.new){
            triggerIds.add(Opps.Id);
         }//END for (Opportunity Opps)
         //Get all the Opp and Products
         List<Opportunity> lstOpps = [SELECT id, CloseDate, (SELECT id, TotalPrice, One_Time_Revenue__c FROM OpportunityLineItems) FROM Opportunity 
                                      WHERE id in: triggerIds];
             //Loop through Opps
             for(Opportunity opp: lstOpps){
                 //Loop through Products in Opps
                 for(OpportunityLineItem oli : opp.OpportunityLineItems){
                     if(oli.One_Time_Revenue__c == true){
                        //Apply the logic of which fields to update
                        if(opp.CloseDate > Date.valueOf('2017-12-31') && opp.CloseDate < Date.valueOf('2018-04-01')){
                            oli.One_Time_Rev_Q1_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q1
                        if(opp.CloseDate > Date.valueOf('2018-03-31') && opp.CloseDate < Date.valueOf('2018-07-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q2
                        if(opp.CloseDate > Date.valueOf('2018-06-30') && opp.CloseDate < Date.valueOf('2018-10-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q3
                        if(opp.CloseDate > Date.valueOf('2018-09-30') && opp.CloseDate < Date.valueOf('2019-01-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q4
                        if(opp.CloseDate > Date.valueOf('2018-12-31') && opp.CloseDate < Date.valueOf('2019-04-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2018 Q1
                        if(opp.CloseDate > Date.valueOf('2019-03-31') && opp.CloseDate < Date.valueOf('2019-07-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q2
                        if(opp.CloseDate > Date.valueOf('2019-06-30') && opp.CloseDate < Date.valueOf('2019-10-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = oli.TotalPrice;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q3
                        if(opp.CloseDate > Date.valueOf('2019-09-30') && opp.CloseDate < Date.valueOf('2020-01-01')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = oli.TotalPrice;
                            lstOLIUpdate.add(oli);              
                        }//END if 2019 Q4
                        if(opp.CloseDate > Date.valueOf('2019-12-31')){
                            oli.One_Time_Rev_Q1_2018__c = 0;
                            oli.One_Time_Rev_Q2_2018__c = 0;
                            oli.One_Time_Rev_Q3_2018__c = 0;
                            oli.One_Time_Rev_Q4_2018__c = 0;
                            oli.One_Time_Rev_Q1_2019__c = 0;
                            oli.One_Time_Rev_Q2_2019__c = 0;
                            oli.One_Time_Rev_Q3_2019__c = 0;
                            oli.One_Time_Rev_Q4_2019__c = 0;
                            
                            lstOLIUpdate.add(oli);
                        }
                         
                     }//END if(oli.One_Time_Revenue__c == true)                     
                 }//END For(OpportunityLineItem)
             }//END for(Opportunity)
    //Update Products if there are any to update
    if(lstOLIUpdate.size()>0){
        update lstOLIUpdate;
    }
    }//END if(RecusiveTriggerHandler.isFirstTime)
}//END Class

@isTest
public class UpdateOTRevTest {
    
    public static testMethod void testOppOneTimeRevenue(){
        
        Product2 prod2= new Product2(Name = 'Test Product - OneTime',
                                     Product_Gross_Margin__c = 10,
                                     Delivery_Market__c = 'none' ,
                                     Delivery_Region__c = 'ABCD',
                                     Delivery_Site__c = 'none' ,
                                     Family = 'XTCD',
                                     Description = 'Test Product',
                                     IsActive = true,
                                     Project_Seat_Count__c = 'false',
                                     One_Time_Revenue__c = true);
        insert prod2;
        Id pricebookId = Test.getStandardPricebookId();
        PricebookEntry pbEntry = new PricebookEntry(Pricebook2Id = pricebookId,
                                                    product2Id = prod2.Id,
                                                    isActive = true,
                                                    UnitPrice = 1000);
        insert pbEntry;
       
        Opportunity opp = new Opportunity(Name = 'Test Account - Opportunity',
                                          StageName = '1 - Prospect',
                                          Type = 'New Logo', 
                                          CloseDate = System.Date.today(),
                                          LeadSource = 'BDD/AM/OPS Development',
                                          Referral_Channel__c = 'None',
                                          Auto_Generate_Quarterly_Forecast__c = 'Yes',
                                          Contract_Length_Months__c = 24,
                                          Pricebook2Id = pricebookId,
                                          Amount = 10000000);
        insert opp;
       
        OpportunityLineItem oli = new OpportunityLineItem(OpportunityId = opp.id,
                                                          PricebookEntryId = pbEntry.id,
                                                          Product2Id = prod2.id,
                                                          Quantity = 10, 
                                                          Unit_Price2__c = 20,
                                                          Adjusted_Gross_Margin_Percentage__c = 10,
                                                          Service_Channel__c = 'WIDGET',
                                                          Service_Type__c = 'Care',
                                                          One_Time_Revenue__c = true);
        insert oli;
        
        System.debug('Opportunity Product Total Price '+ oli.TotalPrice);
        System.debug('OpportunityLineItem Id ' +oli.Id);
        System.debug('Product 2 Id '+ oli.Product2Id);
        System.debug('Opportunity Line Item Name : '+ oli.Name);
        System.debug('One Time Revenue : '+oli.One_Time_Revenue__c);
        Date closeDate = System.today();
        opp.CloseDate = Date.newInstance(2018, 01, 25);
       
        update opp;
        System.debug('Opp Close Date : '+opp.CloseDate);
    }//END Method
}//END Class

//https://salesforce.stackexchange.com/questions/72883/how-to-create-opportunity-line-items-in-test-classes

trigger UpdateOTRev on Opportunity (after insert, after update) {
    Set<id> triggerIds = new Set<id>();
    List<OpportunityLineItem> lstOLIUpdate = new List<OpportunityLineItem>();
    for(Opportunity Opps : Trigger.new){
        triggerIds.add(Opps.Id);
    }
    List<Opportunity> lstOpps = [SELECT id, CloseDate, (SELECT id, TotalPrice FROM OpportunityLineItems) FROM Opportunity 
                                 WHERE id in: triggerIds];
    for(Opportunity opp: lstOpps){
        for(OpportunityLineItem oli : opp.OpportunityLineItems){
            
            if(opp.CloseDate > Date.valueOf('2017-12-31') && opp.CloseDate < Date.valueOf('2018-04-01')){
                oli.Test_Q1_2018__c = oli.TotalPrice;
                oli.Test_Q2_2018__c = 0;
                oli.Test_Q3_2018__c = 0;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q1
            if(opp.CloseDate > Date.valueOf('2018-03-31') && opp.CloseDate < Date.valueOf('2018-07-01')){
                oli.Test_Q1_2018__c = 0;
                oli.Test_Q2_2018__c = oli.TotalPrice;
                oli.Test_Q3_2018__c = 0;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q2
            if(opp.CloseDate > Date.valueOf('2018-06-30') && opp.CloseDate < Date.valueOf('2018-10-01')){
                oli.Test_Q1_2018__c = 0;
                oli.Test_Q2_2018__c = 0;
                oli.Test_Q3_2018__c = oli.TotalPrice;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q3
            if(opp.CloseDate > Date.valueOf('2018-09-30') && opp.CloseDate < Date.valueOf('2019-01-01')){
                oli.Test_Q1_2018__c = 0;
                oli.Test_Q2_2018__c = 0;
                oli.Test_Q3_2018__c = oli.TotalPrice;
                oli.Test_Q4_2018__c = 0;
                oli.Test_Q1_2019__c = 0;
                oli.Test_Q2_2019__c = 0;
                oli.Test_Q3_2019__c = 0;
                oli.Test_Q4_2019__c = 0;
                lstOLIUpdate.add(oli);              
            }//END if 2018 Q4
        }//END For(OpportunityLineItem)
    }//END for(Opportunity)
    if(lstOLIUpdate.size()){
        update lstOLIUpdate;
    }

}

trigger OpportunityLineItemTrigger on OpportunityLineItem (before insert, before update, after update, after insert) {
    List<Opportunity> opps = new List<Opportunity>();
    List<Id> oppIds = new List<Id>();
    Decimal contractLengthMonths = 0;

//---------------BEFORE TRIGGER BELOW----------
    if(trigger.isInsert || trigger.isUpdate && trigger.isBefore) {
        List<OpportunityLineItem> oli = new List<OpportunityLineItem>();
        for (OpportunityLineItem oli2: trigger.new){
            if(oli2.Number_of_Months__c > 0){
                oli2.UnitPrice = ((oli2.Number_of_Months__c / 12) * oli2.Unit_Price2__c);
            } else if (oli2.Number_of_Months__c == null || oli2.Number_of_Months__c == 0 ) {
                oli2.UnitPrice = oli2.Unit_Price2__c;
            }
            if(oli2.Adjusted_Gross_Margin_Percentage__c == 0 && oli2.Product_Gross_Margin_Percent2__c != 0 ) {
                if (oli2.Number_of_Months__c > 0) {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity * (oli2.Number_of_Months__c / 12)) * (oli2.Product_Gross_Margin_Percent2__c/100);
                } else {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity) * (oli2.Product_Gross_Margin_Percent2__c/100);
                }
             } else if (oli2.Adjusted_Gross_Margin_Percentage__c > 0) {
                if (oli2.Number_of_Months__c > 0) {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity * (oli2.Number_of_Months__c / 12)) * (oli2.Adjusted_Gross_Margin_Percentage__c/100);
                } else {
                    oli2.Gross_Margin_Dollars__c = (oli2.Unit_Price2__c * oli2.Quantity) * (oli2.Adjusted_Gross_Margin_Percentage__c/100);
                }
            }//END if(oli2.Adjusted_Gross_Margin_Percentage__c == 0 || oli2.Adjusted_Gross_Margin_Percentage__c == null) 
            
        }//END for (OpportunityLineItem oli2: trigger.new)
    }//if(trigger.isInsert || trigger.isUpdate && trigger.isBefore) 

//---------AFTER TRIGGER BELOW--------------

    if(trigger.isAfter) {
        for (OpportunityLineItem oli3: trigger.new){
            oppids.add(oli3.opportunityId);
            
        }//END for (OpportunityLineItem oli3: trigger.new)
        List<OpportunityLineItem> allOLI = [SELECT id, Number_of_Months__c FROM OpportunityLineItem WHERE OpportunityId in: oppids];
        List<Opportunity> oppsToUpdate = [SELECT id, Contract_Length_Months__c FROM Opportunity WHERE id in: oppids];
        if(allOLI.size() > 0){
            for(OpportunityLineItem allOLI2: allOLI){
                if(allOLI2.Number_of_Months__c > contractLengthMonths){
                    contractLengthMonths = allOLI2.Number_of_Months__c;
                } else if (allOLI2.Number_of_Months__c == null) {
                    contractLengthMonths = 12;
                }
            } //END for(OpportunityLineItem allOLI2: allOLI)
            for(Opportunity oppUpdate: oppsToUpdate){
                oppUpdate.Contract_Length_Months__c = contractLengthMonths;
                opps.add(oppUpdate);
            }// END for(Opportunity oppUpdate: oppsToUpdate)
 
        }//END if(allOLI.size() > 0
        update opps;
    }//if(trigger.isAfter)
}//END OpportunityLineItem Class

trigger OpportunityLineItemTrigger on OpportunityLineItem ( after update) {
    List<Id> oppIds = new List<Id>();
    Decimal contractLengthMonths = 0;

    if(trigger.isAfter) {
        for (OpportunityLineItem oli3: trigger.new){
            oppids.add(oli3.opportunityId);
        }//END for (OpportunityLineItem oli3: trigger.new)
        List<OpportunityLineItem> allOLI = [SELECT id, Number_of_Months__c FROM OpportunityLineItem WHERE OpportunityId in: oppids];
        List<Opportunity> oppsToUpdate = [SELECT id, Contract_Length_Months__c FROM Opportunity WHERE id in: oppids];
        if(allOLI.size() > 0){
            for(OpportunityLineItem allOLI2: allOLI){
                if(allOLI2.Number_of_Months__c > contractLengthMonths){
                    contractLengthMonths = allOLI2.Number_of_Months__c;
                }//END if(allOLI2.Number_of_Months__c > contractLengthMonths)
            } //END for(OpportunityLineItem allOLI2: allOLI)
            for(Opportunity oppUpdate: oppsToUpdate){
                oppUpdate.Contract_Length_Months__c = contractLenghtMonths;
            }// END for(Opportunity oppUpdate: oppsToUpdate)
 
        }
    }//if(trigger.isAfter)
}//END OpportunityLineItem Class

oppUpdate.Contract_Length_Months__c = contractLenghtMonths;

({
	navigate : function(component) {
        var action = component.get("c.getOpportunity");
		var idOpp = component.get("v.recordId");
        var SCMAid = component.get("v.aid");
        var SCMFormId = component.get("v.formId");
		if(!$A.util.isEmpty(idOpp))
		{
			action.setParams({opportunityId: idOpp});
		
			// Create a callback that is executed after 
			// the server-side action returns
			action.setCallback(this, function(response) {
				var state = response.getState();
				if (state === "SUCCESS") {
					var opp = response.getReturnValue();
                    /* Here you can access like opp.Id, opp.FTEs__c, opp.Account.Industry and form the URL */
                    var fullTimeEmployees = opp.Total_FTEs__c;
                    var industry = opp.Account.Industry;
                    var programStartDate = $A.localizationService.formatDate(Date(opp.ProgramStartDate__c),"MM/DD/YYYY");  
                    var opportunityId = opp.Id;
                    var opportunityName = opp.Name;                    
					var filePath = '/Accounts/'+ opp.Account.Name + '/Opportunities/&ru=%2Fatlas%2Fbpm%2FWorkList.aspx'
                    var partOneURL = 'https://na123.springcm.com/atlas/Forms/UpdateFormDoc.aspx?';
					
                    var partTwoURL = 'aid='+SCMAid;
                    var formUid = SCMFormId;
                    if(SCMAid == '9999') {
                        //Sandbox URL
                        var partOneURL = 'https://uatna123.springcm.com/atlas/Forms/UpdateFormDoc.aspx?';
                    } else {
                        //Production URL
                        var partOneURL = 'https://na123.springcm.com/atlas/Forms/UpdateFormDoc.aspx?';
                    }
					var finalURL = partOneURL + partTwoURL 
                    var finalURL = finalURL + '&FormUid=' + formUid;
                    var finalURL = finalURL + '&SFFTE=' + fullTimeEmployees;
                    var finalURL = finalURL + '&SFIND=' + industry;
                    var finalURL = finalURL + '&SFPSD=' + programStartDate;
                    var finalURL = finalURL + '&SFID=' + opp.Id;
                    var finalURL = finalURL + '&SFNAME=' + opportunityName;
                    var finalURL = finalURL + '&SFWF=ABC';
                    var finalURL = finalURL + '&SFCAFTYPE=CAAF';
                    var finalURL = finalURL + '&SFTYPE=Salesforce.Opportunity';
                    var finalURL = finalURL + '&SFPATH=' + filePath;
                    var urlEvent=$A.get("e.force:navigateToURL");
                    urlEvent.setParams({"url": finalURL});
					urlEvent.fire();
				}
				else if (state === "ERROR") {
					var errors = response.getError();
					if (errors) {
						if (errors[0] && errors[0].message) {
							console.log("Error message: " + 
									 errors[0].message);
						}
					} else {
						console.log("Unknown error");
					}
				}
			});

			// optionally set storable, abortable, background flag here

			// A client-side action could cause multiple events, 
			// which could trigger other events and 
			// other server-side action calls.
			// $A.enqueueAction adds the server-side action to the queue.
			$A.enqueueAction(action);
		}
		else
		{
			console.log('===Record Id is not present====');
		}
	}
})

<apex:page standardController="Opportunity" extensions="opportunityProductEntryExtension" action="{!priceBookCheck}" >
    <apex:sectionHeader Title="Manage {!$ObjectType.Product2.LabelPlural}" subtitle="{!opportunity.Name}"/>
    <apex:messages style="color:red"/>

    <style>
        .search{
            font-size:14pt;
            margin-right: 20px;    
        }
        .fyi{
            color:red;
            font-style:italic;
        }
        .label{
            margin-right:10px;
            font-weight:bold;
        }
        
    </style>
    
    <script type='text/javascript'>
    
        // This script assists the search bar functionality
        // It will execute a search only after the user has stopped typing for more than 1 second
        // To raise the time between when the user stops typing and the search, edit the following variable:
        
        var waitTime = 1;
        
    
        var countDown = waitTime+1;
        var started = false;
        
        function resetTimer(){
        
            countDown=waitTime+1;
            
            if(started==false){
                started=true;
                runCountDown();
            }
        }
        
        function runCountDown(){
        
            countDown--;
            
            if(countDown<=0){
                fetchResults();
                started=false;
            }
            else{
                window.setTimeout(runCountDown,1000);
            }
        }
        function updateSeats() {
            var totalSeats = document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.seatColumn.Seats}");
            document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.yearOneColumn.pageBlockSectionYearOne.result}").value = totalSeats;
            }

               
    </script>

    <apex:form id="pageform" >
    
        <apex:outputPanel id="mainBody">
        
            <apex:outputLabel styleClass="label">PriceBook: </apex:outputLabel>
            <apex:outputText value="{!theBook.Name}"/>&nbsp;
            <apex:commandLink action="{!changePricebook}" value="change" immediate="true"/>
            <br/>
            <!-- not everyone is using multi-currency, so this section may or may not show -->
            <apex:outputPanel rendered="{!multipleCurrencies}">
                <apex:outputLabel styleClass="label">Currency: </apex:outputLabel>
                <apex:outputText value="{!chosenCurrency}"/>
                <br/>
            </apex:outputPanel>
            <br/>
            
<!-- this is the upper table... a.k.a. the "Shopping Cart"-->

            <!-- notice we use a lot of $ObjectType merge fields... I did that because if you have changed the labels of fields or objects it will reflect your own lingo -->
            <apex:pageBlock title="Selected {!$ObjectType.Product2.LabelPlural}" id="selected">
                       
                <apex:pageblockTable value="{!shoppingCart}" var="s" id="pageblocktable">
                
                    <apex:column >
                        <apex:commandLink value="Remove" action="{!removeFromShoppingCart}" reRender="selected,searchResults" immediate="true">
                            <!-- this param is how we send an argument to the controller, so it knows which row we clicked 'remove' on -->
                            <apex:param value="{!s.PriceBookEntryId}" assignTo="{!toUnselect}" name="toUnselect"/>
                        </apex:commandLink>
                    </apex:column>
                    <apex:column headerValue=" " title="{!$ObjectType.Product2.fields.Name.inlineHelpText}"> 
                        <apex:pageBlockSection >
                        <apex:inputField value="{!s.Program_Start_Date__c}" label="Program Start Date :"
                                                                            rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                                            required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        </apex:pageBlockSection>
                        <apex:outputField value="{!s.PriceBookEntry.Product2.Name}"/><br/>
                        <i>Line Item Description : </i>
                        <apex:inputField value="{!s.Description}" /><br/>
                        
                        
                    </apex:column>
                    <apex:column headerValue="">
                        <br/><br/>
                        # of&nbsp;<apex:outputField value="{!s.PricebookEntry.Product2.Unit_of_Measure_Plural__c}" style="width:180px"/><br/>
                        <apex:outputText value="Svc Channel" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/><br/><br/>
                        <apex:outputText value="Qtrly Seat Ramp :" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/>
                    </apex:column>
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.Quantity.inlineHelpText}" id="yearOneColumn">
                        <br/>
                        <apex:inputField value="{!s.Quantity}" style="width:50px" />
                        <apex:inputField value="{!s.Service_Channel__c}" 
                                         rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                         required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:pageBlockSection id="pageBlockSectionYearOne">
                        
                        <apex:inputField value="{!s.X2018_Q1_Seats__c}" style="width:30px" id="result" 
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2018_Q2_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2018_Q3_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2018_Q4_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        </apex:pageBlockSection> 
                     </apex:column>  
                        <apex:outputText value="2018 Q3" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText>                    
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.Number_of_Months__c.inlineHelpText}">
                        <center>
                        <b>Contract Length (Months)</b>
                        <apex:inputField value="{!s.Number_of_Months__c}" style="width:50px"/>
                        </center>
                    </apex:column>
                    <apex:column headerValue="">
                        price per&nbsp;<apex:outputField value="{!s.PricebookEntry.Product2.Unit_of_Measure_Singular__c}" style="width:160px"/><br/>
                        <apex:outputText value="Service Type" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/><br/><br/>
                        <apex:outputText value="Qtrly Seat Ramp :" rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"></apex:outputText><br/><br/><br/>
                    </apex:column>
                    
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.UnitPrice.inlineHelpText}">
                        <apex:inputField value="{!s.Unit_Price2__c}" style="width:70px" required="true"  />
                        <apex:inputField value="{!s.Service_Type__c}"
                                         rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                         required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:pageBlockSection >
                        
                        <apex:inputField value="{!s.X2019_Q1_Seats__c}" style="width:30px" 
                                                 rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                 required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2019_Q2_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2019_Q3_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <apex:inputField value="{!s.X2019_Q4_Seats__c}" style="width:30px"
                                                rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                                required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        </apex:pageBlockSection>
                    </apex:column>
                    <apex:column headerValue=" " title="Enter Your Specific Margin - Pre-Populated with Avg">
                        <center>
                        <b>Adj GM%</b>
                        <apex:inputField value="{!s.Adjusted_Gross_Margin_Percentage__c}" style="width:30px" />
                        </center>
                    </apex:column>
                    <apex:column headerValue=" "
                                 title="{!$ObjectType.OpportunityLineItem.fields.One_Time_Revenue__c.inlineHelpText}">
                        <center>
                        <b>One-Time Rev</b>
                        <apex:inputCheckbox value="{!s.One_Time_Revenue__c}"  />
                        </center>
                    </apex:column>
                    <apex:column headerValue=" " title=" ">
                        <apex:outputLabel rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}" style="width:50px">Total # of Seats&nbsp;</apex:outputLabel>
                        <br/><br/><br/><br/><br/><br/>
                    </apex:column>

                    <apex:column headerValue=" " title="{!$ObjectType.OpportunityLineItem.fields.Seats__c.inlineHelpText}" id="seatColumn">
                        
                        <apex:inputField value="{!s.Seats__c}"  style="width:50px"  onkeyup="refreshTotals();"  id="Seats" onclick="updateSeats()"
                                      rendered="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"
                                      required="{!IF(s.PriceBookEntry.Product2.Project_Seat_Count__c == 'TRUE', true, false)}"/>
                        <br/><br/><br/><br/><br/><br/>
                    </apex:column>

                </apex:pageblockTable>
            
            
                <apex:pageBlockButtons >
                    <apex:commandButton action="{!onSave}" value="Save"/>
                    <apex:commandButton action="{!onCancel}" value="Cancel" immediate="true"/>
                </apex:pageBlockButtons>
            
            </apex:pageBlock>   
            <apex:pageBlock >
                <apex:outputPanel styleClass="search">
                    Search for {!$ObjectType.Product2.LabelPlural}:
                </apex:outputPanel>
                <apex:actionRegion renderRegionOnly="false" immediate="true">
                    <apex:actionFunction name="fetchResults" action="{!updateAvailableList}" reRender="searchResults" status="searchStatus"/>
                    <apex:selectList value="{!selectedProdFamily}" label="Select Product Family : " multiselect="false" size="1">
                        <apex:actionSupport event="onchange" action="{!updateAvailableList}" />
                        <apex:selectOptions value="{!ProductFamily}"  />
                    </apex:selectList>
                    &nbsp;&nbsp;                 
                    <apex:inputText value="{!searchString}" onkeydown="if(event.keyCode==13){this.blur();}else{resetTimer();}" style="width:300px"/>
                    &nbsp;&nbsp;
                                  <apex:actionStatus id="searchStatus" startText="searching..." stopText=" "/>
                    </i>    
                </apex:actionRegion>
            
                <br/>
                <br/>
            
                <apex:outputPanel id="searchResults">
                    <apex:pageBlockTable value="{!AvailableProducts}" var="a">                       
                        <apex:column headerValue="{!$ObjectType.Product2.Fields.Family.Label} / Company" value="{!a.Product2.Family}"/>
                        <apex:column headerValue="{!$ObjectType.Product2.Fields.Name.Label}" value="{!a.Product2.Name}" />                      
                        <apex:column headerValue="{!$ObjectType.Product2.Fields.Product_Gross_Margin__c.Label}" value="{!a.Product2.Product_Gross_Margin__c}"/>                    
                        <apex:column >
                            <!-- command button in a column... neato -->
                            <apex:commandButton value="Select" action="{!addToShoppingCart}" reRender="selected,searchResults" immediate="true">
                                <!-- again we use apex:param to be able to tell the controller which row we are working with -->
                                <apex:param value="{!a.Id}" assignTo="{!toSelect}" name="toSelect"/>
                            </apex:commandButton>
                        </apex:column>               
                    </apex:pageBlockTable>
                    <!-- We put up a warning if results exceed 100 rows -->
                    <apex:outputPanel styleClass="fyi" rendered="{!overLimit}">
                        <br/>
                        Your search returned over 100 results, use a more specific search string if you do not see the desired {!$ObjectType.Product2.Label}.
                        <br/>
                    </apex:outputPanel>            
                </apex:outputPanel>
            </apex:pageBlock>
        </apex:outputPanel>
    </apex:form>
</apex:page>

<script>
function updateSeats() {
            var totalSeats = document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.seatColumn.Seats}");
            document.getElementById("{!$Component.pageform.mainBody.selected.pageblocktable.yearOneColumn.pageBlockSectionYearOne.result}").value = totalSeats;
            }
</script>

<aura:component implements="force:lightningQuickAction,force:appHostable,flexipage:availableForAllPageTypes,force:hasRecordId" access="global" 
                controller="CAFController">
    
    <aura:attribute name="recordId" type="Id" />
    
    <div id="aura-page">
        <div class="container">
			<ui:button class="btn" label="CAF Form" press="{!c.navigate}"/> 
        </div>
    </div>
</aura:component>

({
	navigate : function(component, event, helper) {
		helper.navigate(component);
	}
})

({
	navigate : function(component) {
        var action = component.get("c.getOpportunity");
        action.setParams({opportunityId: component.get("v.recordId")});
        var urlEvent=$A.get("e.force:navigateToURL");
        var partOneURL = 'https://XXX21.springcm.com/atlas/Forms/UpdateFormDoc.aspx?aid=9124&FormUid=8beXXXXX-d9b0-e611-bb8d-6c3be5XXXXXXX';
        urlEvent.setParams({"url": partOneURL})
        urlEvent.fire();
	}
})

public class CAFController {

    @AuraEnabled
    public static Opportunity getOpportunity(ID opportunityId){
        if(opportunityId == null) {
            return null;
        }
        List<Opportunity> opps = [SELECT id, 
                                         Opportunity.FTEs__c,
                                         Opportunity.Account.Industry ,
                                         Opportunity.TotalNumberofSeats__c ,
                                         Opportunity.CAPEX_Required__c ,
                                         Opportunity.Amount ,
                                         Opportunity.Annualized_Revenue__c,
                                         Opportunity.ProgramStartDate__c ,
                                         Opportunity.Name
                                  FROM Opportunity
                                  WHERE Id =: opportunityId];
        if(opps.size()>0){
            return opps[0];
        }
        return null;
    }
}

{!REQUIRESCRIPT("/soap/ajax/10.0/connection.js")} 
{!REQUIRESCRIPT("/soap/ajax/10.0/apex.js")} 

//Should not have to change this at all 
function getEOSInfo(objectid,objecttype,callback) { 

var baseUrl = "{!$Api.Partner_Server_URL_260}".substring(0, "{!$Api.Partner_Server_URL_260}".indexOf("/services")); 
var url = baseUrl +"/services/apexrest/SpringCMEos/eosinfo?objecttype="+objecttype+"&objectid="+objectid; 
var authkey = "Bearer {!$Api.Session_ID}"; 

sforce.connection.remoteFunction({ 
url : url, 
requestHeaders: {"Authorization":authkey,"Accept":"application/json"}, 
onSuccess : function(response) { 
var eosInfoResponse = JSON.parse(response); 
callback(eosInfoResponse); 
} 
}); 
} 


//Here you write your own code, this is a simple call 
var objectid = "{!Opportunity.Id}"; 
var objecttype = "Opportunity"; 

getEOSInfo(objectid,objecttype,function(eosInfo){ 


var formuid = "8be07531-XXXX-e611-XXXX-6c3be5a7XXXX"; 
var url = "https://XXX21.springcm.com/atlas/Forms/UpdateFormDoc.aspx?aid=9723&FormUid=" + formuid + "&SFFTE={!Opportunity.FTEs__c}&SFIND={!Account.Industry}&SFPSD={!Opportunity.ProgramStartDate__c}&SFID=" + eosInfo.SFId + "&SFNAME={!Opportunity.Name}&SFWF=ABC&SFCAFTYPE=CAAF&SFTYPE=Salesforce.Opportunity&SFPATH=" + eosInfo.FolderPath + "&ru=%2Fatlas%2Fbpm%2FWorkList.aspx"; 

window.open(url); 

});

public class OpportunityRevenueTrigger2 {

    
    public static void updateOpportuntityRev(List<Opportunity> trig){
         List<ID> opprtnyId = new List<ID>();
         Decimal totRev;
         Decimal totAllottedRev;
         Decimal mRev;
         
         for(Opportunity opp4: trig){
            if(Opp4.Auto_Generate_Quarterly_Forecast__c == 'Yes'){
                opprtnyId.add(opp4.id);
            }
         List<Opportunity_Revenue__c> deleteOR = [SELECT id
                                                 FROM Opportunity_Revenue__c 
                                                 WHERE Opportunity__c in: opprtnyID];
         
        if(deleteOR.size() != 0){
           Delete deleteOR;
         }
        
        List<Opportunity_Revenue__c> oppr = new List<Opportunity_Revenue__c>();
        for(Opportunity opp : trig){
             
             if(opp.amount > 0 && opp.contract_length_Months__c > 0 
               && opp.Auto_Generate_Quarterly_Forecast__c == 'Yes' ){
                   Date sDate = opp.CloseDate;
                   Integer period = opp.Contract_Length_Months__c.intValue();
                   Integer period2 = period / 3;
                   totRev = opp.Amount;
                   mRev = totRev.divide(period2, 2);
                   for(Integer i = 1; i <= period2; i++) {
                   Opportunity_Revenue__c oppr2 = new Opportunity_Revenue__c();
                   oppr2.Account__c = opp.AccountId;
                   oppr2.Opportunity__c = opp.id;
                   System.debug('i '+ i);
                   oppr2.ProjectedRevenue__c = mRev;
                   oppr2.Month__c = sDate;
                       if(sDate.Month()== 1 || sDate.month()==2 || sDate.month() ==3){
                           oppr2.Quarter__c =  'Quarter 1, '+string.valueOf(sDate.Year());   
                       } else if (sDate.Month()== 4 || sDate.month()== 5 || sDate.month() == 6){
                           oppr2.Quarter__c =  'Quarter 2, '+string.valueOf(sDate.Year());
                       } else if (sDate.Month()== 7 || sDate.month()== 8 || sDate.month() == 9){
                           oppr2.Quarter__c =  'Quarter 3, '+string.valueOf(sDate.Year());
                       } else if (sDate.Month()== 10 || sDate.month()==11 || sDate.month() ==12){
                           oppr2.Quarter__c =  'Quarter 4, '+string.valueOf(sDate.Year());
                       }
                   
                   oppr.add(oppr2);
                   sDate = sDate.addMonths(3);
                   }
                  
        
              }
        }
        insert oppr;

    }
}
}

trigger OpportunityRevenueTrigger on Opportunity (after insert, after update) {
  
        
        OpportunityRevenueTrigger2.updateOpportuntityRev(trigger.new);
        
 
  }

Public List<Contact> contList;

for(Red_Zone__c rzAcct: [SELECT Account__c, status__c, Escalation__c FROM Red_Zone__c WHERE status__c ='Open' and Escalation__c ='Red Zone']){
    if (rzAcct.Account__c != Null && rzAcct.status__c != Null && rzAcct.Escalation__c != Null){
            System.debug('rzAcct.id '+rzAcct.id);
            System.debug('rzAcct.Account__c '+rzAcct.Account__c);
            System.debug('rzAcct.Status__c '+rzAcct.status__c);
            System.debug('rzAcct.Escalation__c '+rzAcct.Escalation__c);
        for (Contact con: [SELECT account_relationship_status__c, AccountId FROM Contact WHERE AccountId =:rzAcct.Account__c]){
            System.debug('con.id '+con.id);
            System.debug('con.account_relationship_status__c '+con.account_relationship_status__c);
            System.debug('con.AccountID '+con.AccountId);
            
               con.account_relationship_status__c ='Red Zone';
               contList.add(con);
        }
   }
System.debug('contList '+ contList);
Update contList;    
}

Kindly provide a solution to the following : 

Details

I as a product manager require a custom search page for my salesforce CRM account. I don’t want to use the standard search functionality for this. Here is what I want to be done:

1. On the VF page, create accustom “search” button and a checkbox with the name “limit to accounts I own”
2. I should be able to enter and search on the following fields (these are the search criteria fields):
1. Account name(standard field)
2. Industry (standard field)
3. Rating(standard field)
4. Account  region(custom field)
5. Account priority(custom filed)
6. Account summary(text)
3. The search functionality should be a logical OR of all the above combinations.
4. The correct search results should be displayed ON THE SAME PAGE only after clicking the “submit” button.Display columns should have these fields: account name, industry, rating, account priority.
5. If the checkbox “limit to accounts I Own” is checked before clicking on search the display only those accounts where the owner=current logged in user. 

I have developed the following code:

I am working on a trigger that will sum some of the values from the opportunityLineItems and update a field on the opportunity. These are custom fields that do not automatically sum and our org has already used 100% of available roll-up summary fields and there are existing integration pieces that rely on these fields. 

Currently they are updated via s-control that has to be manually envoked from a link on each record. 

I have some experience with Apex Trigger, but am hoping somebody may be able to help me get started... 

So far I have:

trigger Calculate_Products on OpportunityLineItem (after delete, after insert, after undelete, 
after update) {

	//Set the OpportunityID
	Set<id> Ids = new Set<id>();
     for (OpportunityLineItem oli : Trigger.new) {
         Ids.add(oli.OpportunityId);
        }
        
	//Query the OpportunityLineItems
	List<aggregateResult> results = [select sum(margin__c)m from opportunityLineItem where OpportunityId in :Ids];
   
    for (OpportunityLineItem oli : Trigger.new) 
    {     
   	Opportunity Opp = opptys.get(oli.OpportunityId);
    Opp.Margin_Total__c = results.get('m');
    }    
     
	update opp;
} 

 but I am not quite sure how to I can sum the margin__c field and update the opportunity total_margin__c field... or how to ensure the trigger is bulk friendly. 

Thanks in advance for any help!