Can any one help me on this ?RollUp Summary field can be multiplied in a visual force page.Based on the condition ,I need the value of the RollUp summary to get multipled (0.01) in wrapper class .
"Subtotal__c" and "Non_Pick_Total__c" are Roll up summary fields on Opportunity Object.They give the "Sum" of Opportunity Product aggregates on Extension Field.Extension(Extension=qty*1) is a Formula field data type as Currency on Opportunity Product.
The issue I'm having is that the "Extension" field value is getting calculated based on the formula field but it should get calculated as per the changes made in the visual force page and display (Extension = Qty*0.01) on the subtotal.
Condition :
If the product line for the product selected in opportunity items is ‘DIE’ make following changes .
1) unit price should change to $.01.
2)Unit price just change on the PDF display only and with extended amount which will be quantity times .01.
3)Subtotal__c=Non_Pick_Total__c
How do I achieve this?I shall appreciate your help. VF CODE :
<apex:page standardController="Opportunity" renderAs="PDF" applyhtmltag="false" showHeader="false" applyBodyTag="false" extensions="InvoiceController">
<table border="0" cellspacing="0" cellpadding="1" width="100%" >
<tr>
<td class="header-heading">
Ship Date:
</td>
<td class="header-data">
<apex:outputText value="{!opportunity.Sys_today_s_date__c}"></apex:outputText><br/>
</td>
<td class="header-heading">
Special Instructions:
</td>
<td class="header-data">
<apex:outputText value="{!opportunity.Special_Instructions__c}"></apex:outputText>
</td>
</tr>
<tr>
<td><b><f style="color:Black; font-size:14px; font-family:Verdana;"></f></b> <apex:outputText value="{!Opportunity.Customer_VAT_number__c}"></apex:outputText><br/>
</td>
</tr>
</table>
<table>
<tr border="0">
<td class="header-table-heading">CI Invoice Id</td>
<td class="header-table-heading">Ship Date<b/></td>
<!--<td class="header-table-heading">Sales Order#</td>-->
<td class="header-table-heading">Opportunity Name</td>
<td class="header-table-heading">Order Date</td>
<!--<td class="header-table-heading">Customer#</td>-->
<td class="header-table-heading">Customer Name</td>
</tr>
<tr>
<td class="header-table-data"><apex:outputText value="{!Opportunity.Salesorder_number__c}"></apex:outputText></td>
<td class="header-table-data"><apex:outputText value="{!opportunity.Sys_today_s_date__c}"></apex:outputText></td>
<!--<td class="header-table-data"><apex:outputText value="{!Opportunity.Salesorder_number__c}"></apex:outputText></td>-->
<td class="header-table-data"><apex:outputText value="{!Opportunity.Name}"></apex:outputText></td>
<td class="header-table-data"><apex:outputText value="{!Opportunity.Sys_createddate__c}"></apex:outputText></td>
<td class="header-table-data"><apex:outputText value="{!opportunity.account.Name}"></apex:outputText></td>
<!--<td class="header-table-data">{!Opportunity.account.Ebs_Customer_number__c}</td>-->
</tr>
</table>
<br/>
<table >
<tr>
<td class="header-table-heading">LN</td>
<td class="header-table-heading">Item</td>
<!--<td class="header-table-heading">BinItemCode</td>-->
<td class="header-table-heading">Customer Item #<b/></td>
<td class="header-table-heading">COO</td>
<td class="header-table-heading">ECCN #</td>
<td class="header-table-heading">UOM</td>
<td class="header-table-heading">Unit Price</td>
<td class="header-table-heading">Quantity</td>
<td class="header-table-heading">Extension</td>
</tr>
<tr>
<td class="header-table-heading"></td>
<td colspan="8" style="text-align:left" class="header-table-heading">Description</td>
</tr>
<apex:repeat value="{!appointmentList}" var="line">
<apex:outputPanel layout="none" rendered="{!if(line.pick==false, true, false)}">
<tr>
<td class="header-table-data"><apex:outputText value="{!line.LineNumber}"></apex:outputText></td>
<td class="header-table-data"><apex:outputText value="{!line.productname}"></apex:outputText></td>
<!--<td class="header-table-data"><apex:outputText value="{!line.BinItemCode}"></apex:outputText></td>-->
<td class="header-table-data"></td>
<td class="header-table-data"></td>
<td class="header-table-data">8541.40.2000</td>
<td class="header-table-data">EA</td>
<!--<td class="header-table-data">$1</td>-->
<td class="header-table-data">$<apex:outputtext value="{!line.unitprice}"></apex:outputtext></td>
<td class="header-table-data"><apex:outputtext value="{!line.quantity}"></apex:outputtext></td>
<td class="header-table-data"><apex:outputtext value="{!line.extension}"></apex:outputtext></td>
</tr>
<tr>
<td class="header-table-data"></td>
<td colspan="8" style="text-align:left" class="header-table-data"><b>Scheduled Ship Date:</b>
<apex:outputText value="{0,date,MM'/'dd'/'yyyy}">
<apex:param value="{!line.Scheduledshipdate}"/>
</apex:outputText> </td>
</tr>
</apex:outputPanel>
</apex:repeat>
</table>
<br/>
<table>
<tr>
<td class="header-table-heading">Gross Weight</td>
<td class="header-table-heading">Net Weight</td>
<td class="header-table-heading">Shipped Via</td>
<td class="header-table-heading">Tracking #</td>
<td class="header-table-heading">Payment Terms</td>
<td class="header-table-heading">Incoterms </td>
<td class="header-table-heading">Currency </td>
<td rowspan="0" class="header-table-heading">Sub Total <br/>Shipping Charges</td>
<td rowspan="0" class="header-table-data" id="sub"><apex:outputText value="{!opportunity.Non_Pick_Total__c}"></apex:outputText>
<br/><apex:outputText value="{!Opportunity.Shipping_Charges__c}"></apex:outputText><br/></td>
</tr>
<apex:repeat value="{!appointmentList1}" var="line1">
</apex:repeat>
<tr>
<td class="header-table-data"><apex:outputText value="{!Opportunity.Gross_Weight__c}"></apex:outputText></td>
<td class="header-table-data"><apex:outputText value="{!Opportunity.Net_weight__c}"></apex:outputText></td>
<td class="header-table-data"><apex:outputText value="{!Opportunity.Shipped_Via__c}"></apex:outputText></td>
<td class="header-table-data"><apex:outputText value="{!Opportunity.Bill_of_Lading__c}"> </apex:outputText></td>
<td class="header-table-data">Net 30</td>
<td class="header-table-data">EXW</td>
<td class="header-table-data">USD</td>
<td rowspan="0" class="header-table-heading"> Total Amount Due</td>
<td class="header-table-data"><apex:outputText value="{!opportunity.Non_Pick_Total__c + opportunity.Shipping_Charges__c}"></apex:outputText></td>
</tr>
</table>
</body>
</apex:page>
Code :
public with sharing class InvoiceController {
List<wrapperClass> appointmentList {get;set;}
List<wrapperClass> appointmentList1 {get;set;}
public list<string> address{get;set;}
public string address1{get;set;}
public string address2{get;set;}
public string address3{get;set;}
public string address4{get;set;}
public string address5{get;set;}
public string address6{get;set;}
public string address7{get;set;}
public String showaddressonVf{get;set;}
public string wholeaddress{get;set;}
public static wrapperClass tempObj2 ;
//Added by sumit
List<String> stringList ;
public String all{get;set;}
//------------
public InvoiceController(){
list<opportunity> op=[select id,Shipment_Info__c
from opportunity where id=:apexpages.currentpage().getparameters().get('id')];
//opportunity op=[select id,Shipment_Info__c from opportunity where id=:apexpages.currentpage().getparameters().get('id')];
//---------------------Added by sumit----------------------
stringList= new List<String>();
if(op.size()>0)
if(op[0].Shipment_Info__c!=NULL && op[0].Shipment_Info__c!=''){
List<String> stringList=(op[0].Shipment_Info__c).split(',');
for(integer i=0;i<stringList.size();i++){
all=all+stringList[i]+'<br/>';
}
all=all.remove('null');
}
//------------------------------------------------------------
}
public Id OppId{get;set;}
public InvoiceController(ApexPages.StandardController sc) {
oppId=Apexpages.currentPage().getparameters().get('Id');
}
public List<wrapperClass> getappointmentList (){
wrapperClass tempObj;
tempObj = new wrapperClass();
List<wrapperClass> aReList = new List<wrapperClass>();
List<Opportunity> opp=[select id,Name,AccountId from Opportunity where id=:oppid limit 1];
List<opportunity> Opp1=[select id,name,CreatedDate from opportunity where id=:oppid];
//Opportunity opp1=[select id,Name,AccountId from Opportunity where id=:oppid limit 1];
//Opportunity Opp=[select id,name,CreatedDate from opportunity where id=:oppid ];
List<OpportunityLineItem> OPplineitem= [SELECT OpportunityId,Quantity,PricebookEntry.Product2.Name,Sys_total_Amount__c,LN__c,Extension__c,ListPrice
,Pick__c,Schedule_Ship_date__c,Bin_Item_Code__c ,PricebookEntry.Product2.Product_Line__c,OpportunityLineItem.Opportunity.Subtotal__c,OpportunityLineItem.Opportunity.Non_Pick_Total__c
FROM OpportunityLineItem where OpportunityId=:oppId];
system.debug('HHHHHHHHHH'+OPplineitem.size());
tempObj2 =new wrapperClass();
// tempObj1.Subtotal=
for(integer i=0; i < OPplineitem.size(); i++)
{
tempObj = new wrapperClass();
tempObj.productname= OPplineitem[i].PricebookEntry.Product2.Name;
tempObj.BinItemCode=OPplineitem[i].Bin_Item_Code__c;
tempObj.quantity=OPplineitem[i].Quantity;
tempObj.totalamount=OPplineitem[i].Sys_total_Amount__c;
// tempObj.Subtotal =OPplineitem[i].Opportunity.Subtotal__c;
// tempObj.NonPickTotal=OPplineitem[i].Opportunity.Non_Pick_Total__c;
//j=j+OPplineitem[i].Quantity * tempObj.unitprice;
// tempObj.productline=OPplineitem[i].PricebookEntry.Product2.Product_Line__c;
//Add a conditional statement here
if(OPplineitem[i].PricebookEntry.Product2.Product_Line__c=='DIE')
{
tempObj.unitprice=0.01;
tempobj.extension=OPplineitem[i].Quantity * tempObj.unitprice;
tempObj.productname=OPplineitem[i].Bin_Item_Code__c;
//tempObj.Subtotal =j;
if(i==0){
tempObj2.Subtotal=tempobj.extension;
}
else{
tempObj2.Subtotal=tempObj2.Subtotal+tempObj.extension;
}
// tempObj1.Subtotal =tempObj1.Subtotal+tempObj.extension;
system.debug('@@@@@@@@'+tempObj2.Subtotal);
//tempObj.NonPickTotal=OPplineitem[i].Opportunity.Non_Pick_Total__c*tempObj.unitprice;
}
else
{
tempObj.unitprice=1;
//tempObj.unitprice=OPplineitem[i].ListPrice;
tempobj.extension=OPplineitem[i].Extension__c ;
}
tempobj.LineNumber=OPplineitem[i].LN__c;
tempobj.Pick= OPplineitem[i].Pick__c;
tempobj.ScheduledShipDate = Opplineitem[i].schedule_ship_date__c;
if(tempobj!=null){
aReList.add(tempObj);
}
}
return aReList;
}
public List<wrapperClass> getappointmentList1 (){
wrapperClass tempObj1 ;
List<wrapperClass> aReList1 = new List<wrapperClass>();
List<Opportunity> opp=[select id,Name,AccountId,Shipment_Info__c,
Shipping_Address_Line1__c,
Shipping_Address_Line2__c,
Shipping_Address_Line3__c,
Shipping_City__c,
Shipping_State_Province__c,
Shipping_Zipcode__c,
Shipping_Country__c
from Opportunity where id=:oppid];
for(integer i=0; i < opp.size(); i++)
{
tempObj1 = new wrapperClass();
tempObj1.billingAddress= opp[i].Shipment_Info__c;
}
aReList1.add(tempObj1);
/* Below code commented by Kiranmai as Shipment Info field is split into multiple fields
//------- Added by Sumit-----------
stringList= new List<String>();
if(aReList1[0].billingAddress!=NULL && aReList1[0].billingAddress!=''){
List<String> stringList=(aReList1[0].billingAddress).split(',');
for(integer i=0;i<stringList.size();i++){
all=all+stringList[i]+'<br/>';
}
} */
all = all + opp[0].Shipping_Address_Line1__c + '<br/>';
if(opp[0].Shipping_Address_Line2__c!=NULL && opp[0].Shipping_Address_Line2__c!=''){
all = all + opp[0].Shipping_Address_Line2__c + '<br/>';
}
if(opp[0].Shipping_Address_Line3__c!=NULL && opp[0].Shipping_Address_Line3__c!=''){
all = all + opp[0].Shipping_Address_Line3__c + '<br/>';
}
if(opp[0].Shipping_City__c!=NULL && opp[0].Shipping_City__c!=''){
all = all + opp[0].Shipping_City__c + '<br/>';
}
if(opp[0].Shipping_State_Province__c!=NULL && opp[0].Shipping_State_Province__c!=''){
all = all + opp[0].Shipping_State_Province__c + '<br/>';
}
if(opp[0].Shipping_Zipcode__c!=NULL && opp[0].Shipping_Zipcode__c!=''){
all = all + opp[0].Shipping_Zipcode__c + '<br/>';
}
if(opp[0].Shipping_Country__c!=NULL && opp[0].Shipping_Country__c!=''){
all = all + opp[0].Shipping_Country__c + '<br/>';
}
/* all = all + opp[0].Shipping_City__c + ', '+opp[0].Shipping_State_Province__c + ' - ' + opp[0].Shipping_Zipcode__c + '<br/>';
all = all + opp[0].Shipping_Country__c + '<br/>';*/
all=all.remove('null');
/*-----------------------------------*/
return aReList1;
}
public class wrapperClass{
// public String Item{get;private set;}
public String productname{get; set;}
public String BinItemCode{get;set;}
public Decimal Quantity{get;set;}
public Decimal totalamount{get;set;}
public Decimal Subtotal{get;set;}
public Decimal NonPickTotal{get;set;}
public Decimal unitprice{get;set;}
public date todaysdate{get;set;}
public decimal extension{get;set;}
public string LineNumber{get;set;}
public string billingAddress{get;set;}
public string splittedaddress{get;set;}
public string productline{get;set;}
public string wholeaddress{get;set;}
public boolean Pick{get;set;}
public date ScheduledShipDate{get;set;}
public wrapperClass(){}
}
}
When i check in the Debug logs the value gets calculated but it does not get changed in the visual force page.
PFA SCreen Shot :
Any help very much appreciated.
