Situation: Sales reps use an external quoting tool. It tells them the total amount of all products (product1 and product2) and the separate amount of 1 product (product 2). Rather than them needing to get a calculator out and potentially have errors I'm trying to allow them to put in the total amount in the field for product 1 and the known amount for the field in product 2 and then press a recalculate button that will take what is in the amount for Product 1, subtract Product 2 and either replace the input for product 1 or just show it on the screen.
I am able to do this if the numbers are already saved. So if they save the VF page and then hit recalculate it works fine. However, if they put in a new number for Product 1 on the page it won't take the updated number.
I've tried two things: having the method first do and update to the list being called and then have the recalculation after that AND having the action button directly call the method to save and use oncomplete to call a javascript button to then call the recalulate method. Both continue to use the previously saved amount instead of the new amount. I know the amount is saving because if I go to the Opportunity record and refresh the new amount that I used is there...so the save works, just the calculation continues to use the prior data. How do I get it to use the updated data? Here's what I have and what I've tried. Thanks
VF Page:
<apex:page standardController="Opportunity" extensions="OLIController" > <apex:form > <apex:pageBlock title="Opportunity Products"> <apex:pageBlockTable var="OLI" value="{!OLIs}" id="newProduct"> <apex:column value="{!OLI.product2ID}"/> <apex:column headerValue="Amount"> <apex:inputfield id="UnitPrice" value="{!OLI.UnitPrice}"/> </apex:column> </apex:pageBlockTable> <apex:outputLabel id="oId">Gross Total: {!grossTotal}</apex:outputLabel> <br/> </apex:pageBlock> <apex:commandButton value="ReCalculate Product Amount" action="{!recalcesave}" oncomplete="recalculate();"/> <br/><br/> <apex:outputLabel id="oIdthree">NewProductAmount: {!NewProductAmount}</apex:outputLabel> <br/> <apex:outputLabel id="oIdfour">ProductAmount: {!productAmount}</apex:outputLabel> <br/> <apex:outputLabel id="oIdfive">PDAmount: {!pdAmount}</apex:outputLabel> <br/> <apex:actionFunction action="{!recalculate}" name="recalculateAF"/> <script> function recalculate() { recalculateAF(); return null; } </script> </apex:form> </apex:page> Class Controller:
public with sharing class OLIController { public ApexPages.StandardController sc; public Opportunity Opp {get;set;} public List<OpportunityLineItem> OLIs {get ;set;} public String recordTypeName { get; set; } public String profilename { get; set; } public Integer total {get; set;} public Decimal PDAmount {get; set;} public Decimal ProductAmount {get; set;} public Decimal NewProductAmount {get; set;} public OLIController(ApexPages.StandardController sc) { this.Opp = (Opportunity)sc.getRecord(); OLIs = [Select Name, TotalPrice, ID, Product2ID, UnitPrice, Product2.Name, OpportunityId FROM OpportunityLineItem WHERE OpportunityId =:Opp.Id]; recordTypeName = [Select Name from RecordType where Id=:this.Opp.recordTypeId][0].name; Id profileId=userinfo.getProfileId(); profileName=[Select Id,Name from Profile where Id=:profileId].Name; } public List<OpportunityLineItem> getOLIs() { List<OpportunityLineItem> OLIs = [Select Name, TotalPrice, Product2ID, ID, UnitPrice, OpportunityId FROM OpportunityLineItem WHERE OpportunityId =:Opp.Id]; return OLIs; } // controller method to get gross total of products public Decimal getGrossTotal(){ Decimal grossTotal = 0; for(OpportunityLineItem pw : OLIs) { grossTotal += (pw.unitPrice * pw.quantity); } return grossTotal; } // controller method to recalculate product total public PageReference recalculate(){ for(OpportunityLineItem pw : OLIs) { if(pw.Name.Contains('PD')) { pdAmount = pw.TOTALPRICE; } else { productAmount = pw.TOTALPRICE; } } if(PDAmount!=0){ NewProductAmount = ProductAmount-PDAmount; } return null; } //Save before recalculate public PageReference recalcesave() { update OLIs; return null; } } The other version I have tried of recalcsave is:
public PageReference recalcsave(){ update OLIs; for(OpportunityLineItem pw : OLIs) { if(pw.Name.Contains('PD')) { pdAmount = pw.TOTALPRICE; } else { productAmount = pw.TOTALPRICE; } } if(PDAmount!=0){ NewProductAmount = ProductAmount-PDAmount; } return null; } 
