Here I'm trying to display grandchild, child of a parent record. ORDER is the parent, order line is the child and shipment lines is the grandchild. I'm trying to display all of them in a nested table. So far I'm successful in displaying order lines for a single ORDER, but I'm messing up with the related shipment lines.
The controller
public class GE_PW_OrderTrackingList{
public GE_PW_OrderTrackingList(ApexPages.StandardController controller) {
}
public list<wrapgroupwise> singlegroup;
// Map <String, Invoices__c> uniqueInvoices = new Map <String, Invoices__c>();
public List<wrapgroupwise> getStartHere(){
singlegroup= new List<wrapgroupwise>();
List<order_lines__c> temol= [SELECT Id, name,calculated_estimated_delivery_date__c,order_number__c,status__c,planned_ship_date__c,material_name__c,material_no__c, quantity_ordered__c, material_group__c,(SELECT Id,Name,Order_Number__c,Actual_Delivery_Date__c, estimated_delivery_date__c,Shipment_Number__r.name, Shipment_Number__r.carrrier_name__c, Shipment_Number__r.carrier_website__c,Shipment_Number__r.tracking_number__c,quantity_shipped__c, material_group__c,order_lines__c From shipment_lines__r ) From order_lines__c where number_of_order_lines__c=:ApexPages.currentPage().getParameters().get('id')];
List<orders__c> tempacc=[SELECT Orders__c,CreatedBy.FirstName,CreatedDate, number_of_line_items__c, CurrencyIsoCode,account__r.name,contract__r.ContractNumber,customer_order_number__c,invoices__c,my_view__c,order_acknowlegment__c,order_date__c,order_value__c, order_no__c, requested_delivery_date__c,shipments__c,Id,Name,
(SELECT Id, name,calculated_estimated_delivery_date__c,order_number__c,status__c,planned_ship_date__c,material_name__c,material_no__c, quantity_ordered__c, material_group__c From Order_Lines__r),
(SELECT invoices__r.invoice_no__c, CurrencyIsoCode,account__c,due_date__c,invoice_date__c,material_group__c,material_name__c,material_number__c,orders__c, order_lines__c, product_family__c,product_type__c,Id,Name,quantity__c, invoices__r.Name, invoices__r.status__c, invoices__r.invoice_value__c , invoices__r.due_date__c, invoices__r.number_of_days_past_due__c, invoices__r.invoice_date__c From Invoice_Lines__r)
FROM orders__c where id=:ApexPages.currentPage().getParameters().get('id')];
system.debug('-----tempacc-------'+tempacc);
for(Integer i=0; i<tempacc.size() ; i++){
List <order_lines__c> tempOrderLines = tempacc[i].order_lines__r;
List <shipment_lines__c> tempShipmentLines = [SELECT Id,Name,Order_Number__c,Actual_Delivery_Date__c, estimated_delivery_date__c,Shipment_Number__r.name, Shipment_Number__r.carrrier_name__c, Shipment_Number__r.carrier_website__c,Shipment_Number__r.tracking_number__c,quantity_shipped__c, material_group__c,order_lines__c From shipment_lines__c Where order_lines__c IN: tempacc[i].tempOrderLines];
List <invoice_lines__c> tempInvoiceLines = tempacc[i].Invoice_Lines__r;
// uniqueInvoices.put(tempacc[i].id, tempInvoiceLines);
System.debug('temp order '+tempacc.size());
System.debug('temp order lines'+tempOrderLines.size());
System.debug('temp shipment lines'+tempShipmentLines.size());
System.debug('temp invoice lines'+tempInvoiceLines.size());
if(tempOrderLines.size()==0 ){/*&& tempShipmentLines.size()==0 && tempInvoiceLines.size()==0*/
singlegroup.add(new wrapgroupwise(tempacc[i],null,null,null));
}
else{
if(tempShipmentLines.size()==0)
{
if(tempOrderLines[i].status__c=='Open')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempOrderLines[i].planned_ship_date__c;
}
singlegroup.add(new wrapgroupwise(tempacc[i],tempOrderLines,null,null));
}//if condition for tempShipmentLines size check
else
{
//Estimated Delivery Date done
if(tempOrderLines[i].status__c=='Open')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempOrderLines[i].planned_ship_date__c;
}
if(tempOrderLines[i].status__c=='Invoiced')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempShipmentLines[i].estimated_delivery_date__c;
}
if(tempOrderLines[i].status__c=='Shipped but not billed')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempShipmentLines[i].estimated_delivery_date__c;
}
if(tempShipmentLines.size()==0)
{
singlegroup.add( new wrapgroupwise(tempacc[i],tempOrderLines,tempShipmentLines, null));
}
else{
singlegroup.add( new wrapgroupwise(tempacc[i],tempOrderLines,tempShipmentLines, tempInvoiceLines));
}
}//size check of temp shipping order
}
}
return singlegroup;
}
public class wrapgroupwise
{
public List<order_lines__c> con {get;set;}
public orders__c acc {get;set;}
public List<shipment_lines__c> opp {get;set;}
public List<invoice_lines__c> inv {get;set;}
public wrapgroupwise( orders__c a , list<order_lines__c> c,list<shipment_lines__c> o, List<invoice_lines__c> i)
{
acc = a;
con = c;
opp = o;
inv = i;
}
}
}
I'm trying to create an account using actionFunction and display the result in the same page. I have tried successfully the "sayHello" example in http://www.salesforce.com/us/developer/docs/pages/Content/pages_compref_actionFunction.htm . But it's not helping me to build this application. Can anyone guide me through this? Any reference would be helpful. Thanks
Here I'm trying to display grandchild, child of a parent record. ORDER is the parent, order line is the child and shipment lines is the grandchild. I'm trying to display all of them in a nested table. So far I'm successful in displaying order lines for a single ORDER, but I'm messing up with the related shipment lines.
The controller
public class GE_PW_OrderTrackingList{
public GE_PW_OrderTrackingList(ApexPages.StandardController controller) {
}
public list<wrapgroupwise> singlegroup;
// Map <String, Invoices__c> uniqueInvoices = new Map <String, Invoices__c>();
public List<wrapgroupwise> getStartHere(){
singlegroup= new List<wrapgroupwise>();
List<order_lines__c> temol= [SELECT Id, name,calculated_estimated_delivery_date__c,order_number__c,status__c,planned_ship_date__c,material_name__c,material_no__c, quantity_ordered__c, material_group__c,(SELECT Id,Name,Order_Number__c,Actual_Delivery_Date__c, estimated_delivery_date__c,Shipment_Number__r.name, Shipment_Number__r.carrrier_name__c, Shipment_Number__r.carrier_website__c,Shipment_Number__r.tracking_number__c,quantity_shipped__c, material_group__c,order_lines__c From shipment_lines__r ) From order_lines__c where number_of_order_lines__c=:ApexPages.currentPage().getParameters().get('id')];
List<orders__c> tempacc=[SELECT Orders__c,CreatedBy.FirstName,CreatedDate, number_of_line_items__c, CurrencyIsoCode,account__r.name,contract__r.ContractNumber,customer_order_number__c,invoices__c,my_view__c,order_acknowlegment__c,order_date__c,order_value__c, order_no__c, requested_delivery_date__c,shipments__c,Id,Name,
(SELECT Id, name,calculated_estimated_delivery_date__c,order_number__c,status__c,planned_ship_date__c,material_name__c,material_no__c, quantity_ordered__c, material_group__c From Order_Lines__r),
(SELECT invoices__r.invoice_no__c, CurrencyIsoCode,account__c,due_date__c,invoice_date__c,material_group__c,material_name__c,material_number__c,orders__c, order_lines__c, product_family__c,product_type__c,Id,Name,quantity__c, invoices__r.Name, invoices__r.status__c, invoices__r.invoice_value__c , invoices__r.due_date__c, invoices__r.number_of_days_past_due__c, invoices__r.invoice_date__c From Invoice_Lines__r)
FROM orders__c where id=:ApexPages.currentPage().getParameters().get('id')];
system.debug('-----tempacc-------'+tempacc);
for(Integer i=0; i<tempacc.size() ; i++){
List <order_lines__c> tempOrderLines = tempacc[i].order_lines__r;
List <shipment_lines__c> tempShipmentLines = [SELECT Id,Name,Order_Number__c,Actual_Delivery_Date__c, estimated_delivery_date__c,Shipment_Number__r.name, Shipment_Number__r.carrrier_name__c, Shipment_Number__r.carrier_website__c,Shipment_Number__r.tracking_number__c,quantity_shipped__c, material_group__c,order_lines__c From shipment_lines__c Where order_lines__c IN: tempacc[i].tempOrderLines];
List <invoice_lines__c> tempInvoiceLines = tempacc[i].Invoice_Lines__r;
// uniqueInvoices.put(tempacc[i].id, tempInvoiceLines);
System.debug('temp order '+tempacc.size());
System.debug('temp order lines'+tempOrderLines.size());
System.debug('temp shipment lines'+tempShipmentLines.size());
System.debug('temp invoice lines'+tempInvoiceLines.size());
if(tempOrderLines.size()==0 ){/*&& tempShipmentLines.size()==0 && tempInvoiceLines.size()==0*/
singlegroup.add(new wrapgroupwise(tempacc[i],null,null,null));
}
else{
if(tempShipmentLines.size()==0)
{
if(tempOrderLines[i].status__c=='Open')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempOrderLines[i].planned_ship_date__c;
}
singlegroup.add(new wrapgroupwise(tempacc[i],tempOrderLines,null,null));
}//if condition for tempShipmentLines size check
else
{
//Estimated Delivery Date done
if(tempOrderLines[i].status__c=='Open')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempOrderLines[i].planned_ship_date__c;
}
if(tempOrderLines[i].status__c=='Invoiced')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempShipmentLines[i].estimated_delivery_date__c;
}
if(tempOrderLines[i].status__c=='Shipped but not billed')
{
tempOrderLines[i].calculated_estimated_delivery_date__c=tempShipmentLines[i].estimated_delivery_date__c;
}
if(tempShipmentLines.size()==0)
{
singlegroup.add( new wrapgroupwise(tempacc[i],tempOrderLines,tempShipmentLines, null));
}
else{
singlegroup.add( new wrapgroupwise(tempacc[i],tempOrderLines,tempShipmentLines, tempInvoiceLines));
}
}//size check of temp shipping order
}
}
return singlegroup;
}
public class wrapgroupwise
{
public List<order_lines__c> con {get;set;}
public orders__c acc {get;set;}
public List<shipment_lines__c> opp {get;set;}
public List<invoice_lines__c> inv {get;set;}
public wrapgroupwise( orders__c a , list<order_lines__c> c,list<shipment_lines__c> o, List<invoice_lines__c> i)
{
acc = a;
con = c;
opp = o;
inv = i;
}
}
}
I'm trying to create an account using actionFunction and display the result in the same page. I have tried successfully the "sayHello" example in http://www.salesforce.com/us/developer/docs/pages/Content/pages_compref_actionFunction.htm . But it's not helping me to build this application. Can anyone guide me through this? Any reference would be helpful. Thanks
I have following issue: when I create a new Account I first would like to fetch the Account data from an external web service and populate the Account with the result of my web service call. My idea is to add a button (GetAccountData) that would trigger the web service (with a Controller ?), get the response and display the data on the Account Tab. is there a way in Visualforce to add such a functionality ?
