BuilSheetItemDetails:

<apex:component > <apex:attribute name="ProductCategory" description="High-level product type" type="String" required="false"/> <apex:attribute name="ProductItemIndex" description="Item index on page" type="String" required="false"/> <apex:attribute name="ProductCode" description="Product Code value" type="String" required="false"/> <apex:attribute name="ItemName" description="Name of Asset" type="String" required="true"/> <apex:attribute name="Release" description="Requested release" type="String" required="false"/> <apex:attribute name="Duration" description="Duration of Licenes" type="Integer" required="false"/> <apex:attribute name="ProductName" description="Name of Product" type="String" required="true"/> <apex:attribute name="BaseLicense" description="Type of Base Liencese" type="String" required="false"/> <apex:attribute name="FeatureLicense" description="Add on module licenses" type="String" required="false"/> <div class="PBAVOID"> <table class="ProductList" cellpadding="2" cellspacing="0" border="0" width="100%"> <apex:outputPanel rendered="{!NOT(ISNULL(ProductCategory))}" layout="none"> <tr><td colspan="2" class="OUTLINE_DARK"> <table class="AvoidBorder" width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td width="80%"> <span class="LABEL_LARGE"><apex:outputText value="{!ProductCategory}"/></span></td> <td width="20%" align="right"><span class="LABEL_BOLD">Item {!ProductItemIndex}</span></td> </tr></table> </td></tr> </apex:outputPanel> <tr> <th width="30%">Part Number</th> <td width="90%"><apex:outputText value="{!ProductCode}" />&nbsp;</td> </tr><tr> <th>NickName/Serial Number</th> <td><apex:outputText value="{!ItemName}" />&nbsp;</td> </tr><tr> <th>Software Version</th> <td><apex:outputText value="{!Release}" />&nbsp;</td> </tr><tr> <th>License Duration</th> <td><apex:outputText value="{!Duration}" />&nbsp;</td> </tr><tr> <th>Product Name</th> <td><apex:outputText value="{!ProductName}" />&nbsp;</td> </tr><tr> <th>Model</th> <td><apex:outputText value="{!BaseLicense}" />&nbsp;</td> </tr><tr> <th>Features/Advanced Modules</th> <td><apex:outputText value="{!FeatureLicense}" />&nbsp;</td> </tr> </table> </div> </apex:component>

Extension Controller:

public class extSalesOrderPrint { /////////////////////////////////////// // Initialize the SalesOrder product // /////////////////////////////////////// public extSalesOrderPrint(ApexPages.StandardController controller) { kaz_salesorder__c tmpSO = (kaz_salesorder__c)controller.getRecord(); if (tmpSO == null) return; if (tmpSO.Id == null) return; this.theSalesOrder = [select id, Total_Items__c, Total_Returned__c, Total_Shipped__c, Status__c, Required_Ship_Date__c, Expected_Delivery_Date__c, PurchaseOrderNumber__c, name, Account__c, RecordType.DeveloperName, Price_Book__c from kaz_salesorder__c where id=:tmpSO.Id]; // Read drop URL param, set remove attribute } public kaz_salesorder__c theSalesOrder {get;set;} public static final String LINE_ITEMS_TYPE_WITH_HW = 'Assets With Hardware'; public static final String LINE_ITEMS_TYPE_WITH_ADDON = 'Addon SW'; public static final String LINE_ITEMS_TYPE_WITH_SW = 'Base SW'; public static final integer MAXIMUM_ASSET_RELATION_DEPTH = 2; // MAP of all SO related Assets // public Map<id, kaz_salesorder_item_asset__c> SoAssetMap{ get{ if(SoAssetMap==null) { //List<id> AssetIdList = new List<id>{}; //for(kaz_salesorder_item_asset__c theIA: [select Asset__c from kaz_salesorder_item_asset__c where Sales_Order_Item__r.SalesOrder__c =:this.theSalesOrder.id]) // AssetIdList.add(theIA.Asset__c); this.SoAssetMap = new Map<id, kaz_salesorder_item_asset__c>{}; for (kaz_salesorder_item_asset__c theItemAsset: [select id, Asset__r.id, Asset__r.Name, Asset__r.Parent_Asset__c, Asset__r.SerialNumber, Sales_Order_Item__c, Sales_Order_Item__r.Product__r.Build_Of_Material__c, Sales_Order_Item__r.Product__r.Base_License__c, Sales_Order_Item__r.Product__r.Addon_Licenses__c, Sales_Order_Item__r.Product__r.ProductCode, Sales_Order_Item__r.Product__r.Name, Sales_Order_Item__r.Product__c, Sales_Order_Item__r.Term__c, Sales_Order_Item__r.License_Duration__c, Sales_Order_Item__r.SalesOrder__r.Expected_Delivery_Date__c from kaz_salesorder_item_asset__c where Sales_Order_Item__r.SalesOrder__c =:this.theSalesOrder.id and Asset__c!=null ]){ this.SoAssetMap.put(theItemAsset.Asset__c, theItemAsset); // Add asset to parent relationship map if applicable if (theItemAsset.Asset__r.Parent_Asset__c!=null) { if (!SoAssetParentChildMap.containsKey(theItemAsset.Asset__r.Parent_Asset__c))SoAssetParentChildMap.put(theItemAsset.Asset__r.Parent_Asset__c, new List<id>{theItemAsset.Asset__r.id}); else SoAssetParentChildMap.get(theItemAsset.Asset__r.Parent_Asset__c).add(theItemAsset.Asset__r.id); } } } return SoAssetMap; } set; } public Map <id, kaz_bom__c> SoBomMap { get { if(this.SoBomMap==null) { List<id> BomIdList = new List<id>{}; for (kaz_salesorder_item_asset__c theItemAsset: SoAssetMap.values()) { BomIdList.add(theItemAsset.Sales_Order_Item__r.Product__r.Build_Of_Material__c); } this.SoBomMap = new Map<id, kaz_bom__c>( [select Name, Maximum_Sequence__c, Description__c, Active__c, ( select Name, Part_Number__c, Description__c, Refrence__c, Only_for_Channel__c from BOM_Parts__r order by Sequence__c) from kaz_bom__c where id in:BomIdList ] ); } return this.SoBomMap; } private set; } ////////////////////////////////////////////////////////////////// // MAP for parent-child relationship between assets within SO // public Map<id, List<id>> SoAssetParentChildMap { get { if (SoAssetParentChildMap==null) this.SoAssetParentChildMap = new Map<id, List<id>>{}; return this.SoAssetParentChildMap; } private set; } ///////////////////////////////// // Hardware Based BASE Items // public LineItems HwBaseItems { get{ if(HwBaseItems==null) HwBaseItems=new LineItems(extSalesOrderPrint.LINE_ITEMS_TYPE_WITH_HW, this.theSalesOrder, this.SoAssetMap,this.SoAssetParentChildMap, this.SoBomMap); return HwBaseItems; } private set; } ///////////////////////////////// // Software Based BASE Items // public LineItems SwBaseItems { get{ if(SwBaseItems==null) SwBaseItems=new LineItems(extSalesOrderPrint.LINE_ITEMS_TYPE_WITH_SW, this.theSalesOrder, this.SoAssetMap,this.SoAssetParentChildMap, this.SoBomMap); return SwBaseItems; } private set; } ///////////////////////////////// // Addon Items // public LineItems AddonItems { get{ if(AddonItems==null) AddonItems=new LineItems(extSalesOrderPrint.LINE_ITEMS_TYPE_WITH_ADDON, this.theSalesOrder, this.SoAssetMap,this.SoAssetParentChildMap, this.SoBomMap); return AddonItems; } private set; } /////////////////////////////////////////// // S T A T I C M E T H O D S /////////////////////////////////////////// // s t a r t /////////////////////////////////////////// public static integer LicenseDuration(Date pExpectedStartDate, double addTermInMonths, double addDays) { Date lExpirationDate; if (pExpectedStartDate==null) pExpectedStartDate=System.today(); if(addTermInMonths!=null) lExpirationDate = pExpectedStartDate.addMonths(addTermInMonths.intValue()); else if (addDays!=null) lExpirationDate = pExpectedStartDate.addDays(addDays.intValue()); //system.debug('Start Date: '+pExpectedStartDate); //system.debug('Expiration Date: '+lExpirationDate); //system.debug('Duration: '+((lExpirationDate!=null) ? pExpectedStartDate.daysBetween(lExpirationDate).format():'n/a')); return (lExpirationDate!=null)?pExpectedStartDate.daysBetween(lExpirationDate):null; } ///////////////////////////////////// // C L A S S E S D E F ///////////////////////////////////// // s t a r t ///////////////////////////////////// public class LineItems { public List<LineItem> items {get{if(this.items==null)this.items=new List<lineItem>{};return this.items;}set;} public integer size { get { if(this.size==null) { this.size=(this.items==null?0:this.items.size()); System.debug('Updated size: '+this.size.format()); } System.debug('Returning size: '+this.size.format()); return this.size; } private set; } public LineItems(String pType, kaz_salesorder__c pSalesOrder, Map<id, kaz_salesorder_item_asset__c> pAssetCollection, Map<id,List<id>> pAssetParentChildMap, Map <id, kaz_bom__c> pSoBomMap){ // Select all line items that include a hardware asset and are base products if(pType==extSalesOrderPrint.LINE_ITEMS_TYPE_WITH_HW) { for(kaz_salesorder_item__c theSoItem: [Select Term__c, SalesOrder__c, ProductName__c, ProductCode__c, Product__r.Includes_Tangible_Component__c, Product__r.Base_License__c, Product__r.Addon_Licenses__c, Product__r.Build_Of_Material__c, PO_Line_Number__c, (Select id, Asset__c From Item_Assets__r) from kaz_salesorder_item__c where Product__r.Has_Hardware_Asset__c=true and Product__r.Allow_Addon_Products__c=1 and SalesOrder__c=:pSalesOrder.id order by PO_Line_Number__c]) { this.items.add(new LineItem(theSoItem,pAssetCollection,pAssetParentChildMap, pSoBomMap)); } // Select all line items that do NOT include a hardware asset and are base products } else if(pType==extSalesOrderPrint.LINE_ITEMS_TYPE_WITH_SW) { for(kaz_salesorder_item__c theSoItem: [Select Term__c, SalesOrder__c, ProductName__c, ProductCode__c, Product__r.Includes_Tangible_Component__c, Product__r.Base_License__c, Product__r.Addon_Licenses__c, Product__r.Build_Of_Material__c, PO_Line_Number__c, (Select id, Asset__c From Item_Assets__r) from kaz_salesorder_item__c where Product__r.Has_Hardware_Asset__c!=true and Product__r.Allow_Addon_Products__c=1 and SalesOrder__c=:pSalesOrder.id order by PO_Line_Number__c]) { this.items.add(new LineItem(theSoItem,pAssetCollection,pAssetParentChildMap, pSoBomMap)); System.debug(theSoItem.ProductCode__c); } // Select all line items that are not base products } else if(pType==extSalesOrderPrint.LINE_ITEMS_TYPE_WITH_ADDON) { for(kaz_salesorder_item__c theSoItem: [Select Term__c, SalesOrder__c, ProductName__c, ProductCode__c, Product__r.Includes_Tangible_Component__c, Product__r.Base_License__c, Product__r.Addon_Licenses__c, Product__r.Build_Of_Material__c, PO_Line_Number__c, (Select id, Asset__c From Item_Assets__r) from kaz_salesorder_item__c where Product__r.Has_Software_License__c=true and Product__r.Allow_Addon_Products__c!=1 and SalesOrder__c=:pSalesOrder.id order by PO_Line_Number__c]) { this.items.add(new LineItem(theSoItem,pAssetCollection,pAssetParentChildMap, pSoBomMap)); } } } } public class LineItem { public kaz_salesorder_item__c item {get;set;} public kaz_bom__c bom {get;set;} public integer size { get {if(this.size==null)this.size=(this.assets==null?0:this.assets.size());return this.size;}private set;} public List<LineItemAsset> assets {get{if(this.assets==null)this.assets=new List<LineItemAsset>{}; return this.assets;}private set;} public LineItem(kaz_salesorder_item__c pLineItem,Map<id, kaz_salesorder_item_asset__c> pAssetCollection, Map<id,List<id>> pAssetParentChildMap, Map <id, kaz_bom__c> pSoBomMap) { this.item = pLineItem; this.bom = pSoBomMap.containsKey(pLineItem.Product__r.Build_Of_Material__c)? pSoBomMap.get(pLineItem.Product__r.Build_Of_Material__c) : null ; // Load the related Assets for(kaz_salesorder_item_asset__c theIA: this.item.Item_Assets__r) { // Add LineItemAsset object if (pAssetCollection.containsKey(theIA.Asset__c)) { this.assets.add(new LineItemAsset(pAssetCollection.get(theIA.Asset__c), pAssetCollection, pAssetParentChildMap, 0, pSoBomMap)); } } } } public class LineItemAsset { public Asset item {get;set;} public kaz_bom__c bom {get;set;} private boolean durationSet = false; public kaz_salesorder_item_asset__c itemasset {get;set;} public boolean HasParent { get { return this.HasParent; } private set; } public integer duration{ get { if (duration==null) { durationSet = true; this.duration = extSalesOrderPrint.LicenseDuration( this.itemasset.Sales_Order_Item__r.SalesOrder__r.Expected_Delivery_Date__c, this.itemasset.Sales_Order_Item__r.Term__c, this.itemasset.Sales_Order_Item__r.License_Duration__c ); } return this.duration; } private set; } public integer size { get {if(this.size==null)this.size=(this.assets==null?0:this.assets.size());return this.size;}private set;} public List<LineItemAsset> assets {get{if(this.assets==null)this.assets=new List<LineItemAsset>{}; return this.assets;}private set;} public LineItemAsset (kaz_salesorder_item_asset__c pItemAsset,Map<id, kaz_salesorder_item_asset__c> pAssetCollection, Map<id,List<id>> pAssetParentChildMap, integer pDepth, Map <id, kaz_bom__c> pSoBomMap) { this.itemasset = pItemAsset; this.item = this.itemasset.Asset__r; this.bom = pSoBomMap.containsKey(pItemAsset.Sales_Order_Item__r.Product__r.Build_Of_Material__c) ? pSoBomMap.get(pItemAsset.Sales_Order_Item__r.Product__r.Build_Of_Material__c) : null; // Load child asset records if (this.item!=null) { if(pAssetParentChildMap.containsKey(this.item.id) && pDepth <= extSalesOrderPrint.MAXIMUM_ASSET_RELATION_DEPTH){ for(id theAssetId: pAssetParentChildMap.get(this.item.id)) { if(pAssetCollection.containsKey(theAssetId)) { this.assets.add(new LineItemAsset(pAssetCollection.get(theAssetId), pAssetCollection, pAssetParentChildMap, pDepth+1, pSoBomMap)); } } } // Set has parent flag this.HasParent = pAssetParentChildMap.containsKey(this.item.Parent_Asset__c); } else { this.HasParent = false; } } } ///////////////////////////////////// // C L A S S E S D E F ///////////////////////////////////// // e n d ///////////////////////////////////// }