-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
2Questions
-
3Replies
Get Name of Opportunity Line Item without Opportunity Name
Hi all,
I've done some APEX based on an idea of Deepak Anand (https://success.salesforce.com/answers?id=90630000000hTXHAA2).
Actually everything works, but on the generated .pdf the name of the Opportunity is shown in the line of the product name.
I only want to have the name of the product. What am I missing? THANKS FOR ANY ADVICE!
My APEX Class:
public class OpptyGenPDFExtension { public List<OpportunityLineItem > OLI {get; set;} public OpptyGenPDFExtension(ApexPages.StandardController controller) { String oliIDs = ApexPages.currentPage().getParameters().get('oliid'); if(!String.isBlank(oliIDs)){ Set<Id> oliIdSet = new Set<Id>(); for(String oliId : oliIDs.split(',')){ oliIdSet.add(oliId); } OLI = [ SELECT Name,ProductCode,Quantity FROM OpportunityLineItem WHERE Id IN :oliIdSet ]; } } }
My VF:
<apex:page standardController="Opportunity" extensions="OpptyGenPDFExtension" renderAs="pdf"> <table width="100%" style="font-family: Arial, Helvetica, sans-serif; border-collapse: collapse;" cellpadding="5"> <tr> <td colspan="4"> Hardware Anforderungen für neues System </td> <td> Printed on: {!DAY(TODAY())}.{!MONTH(TODAY())}.{!YEAR(TODAY())} </td> </tr> <tr> <td colspan="4" style="font-size: x-large; font-weight: bold"> Opportunity Name: {!Opportunity.Name} </td> </tr> <tr> <td align="left" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> <td align="left" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> </tr> <tr> <td align="left" style="color: #808080; border-right-style: solid; border-right-width: thin; border-right-color: #ddb929;"> Opportunity Number </td> <td style="font-weight: bold"> {!Opportunity.Opportunity_Nummer__c} </td> </tr> <tr> <td align="left" style="color: #808080; border-right-style: solid; border-right-width: thin; border-right-color: #ddb929;"> Hardware configured by </td> <td style="font-weight: bold"> {!Opportunity.System_konfiguriert_von__c} </td> </tr> <tr> <td align="left" style="color: #808080; border-right-style: solid; border-right-width: thin; border-right-color: #ddb929;"> Account Name </td> <td style="font-weight: bold"> {!Opportunity.Account.Name} </td> </tr> <tr> <td colspan="4"> </td> </tr> <tr> </tr> <tr> <td style="font-weight: bold"> </td> <td align="right" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> </tr> <tr> <td align="right" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> <td align="right" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> </tr> </table> <br/><br/> <apex:outputPanel rendered="{!OLI != NULL}"> <table width="100%" style="font-family: Arial, Helvetica, sans-serif; border-collapse: collapse;" cellpadding="5"> <tr> <td colspan="6" style="font-weight: bold; border-bottom-style: solid; border-bottom-width: thick; border-bottom-color: #ddb929;"> Line Item </td> </tr> <tr> <td style="font-weight: bold; background-color: #FFFFCC;"> Product Name </td> <td style="font-weight: bold; background-color: #FFFFCC;"> Product Code </td> <td style="font-weight: bold; background-color: #FFFFCC;"> Quantity </td> </tr> <apex:repeat value="{!OLI}" var="opl"> <tr id="{!opl.Id}"> <td> {!opl.Name} </td> <td> {!opl.ProductCode} </td> <td> {!opl.Quantity} </td> </tr> </apex:repeat> </table> </apex:outputPanel> </apex:page>
- Daniel Khan 21
- September 08, 2017
- Like
- 0
- Continue reading or reply
How to create pdf on opportunity object ?
There is already a similiar case which was solved by Deepak Anand, but as I have not much understanding of APEX Classes etc yet, please can someone help me? THANKS.
https://success.salesforce.com/answers?id=90630000000hTXHAA2
- Daniel Khan 21
- September 01, 2017
- Like
- 0
- Continue reading or reply
Get Name of Opportunity Line Item without Opportunity Name
Hi all,
I've done some APEX based on an idea of Deepak Anand (https://success.salesforce.com/answers?id=90630000000hTXHAA2).
Actually everything works, but on the generated .pdf the name of the Opportunity is shown in the line of the product name.
I only want to have the name of the product. What am I missing? THANKS FOR ANY ADVICE!
My APEX Class:
public class OpptyGenPDFExtension { public List<OpportunityLineItem > OLI {get; set;} public OpptyGenPDFExtension(ApexPages.StandardController controller) { String oliIDs = ApexPages.currentPage().getParameters().get('oliid'); if(!String.isBlank(oliIDs)){ Set<Id> oliIdSet = new Set<Id>(); for(String oliId : oliIDs.split(',')){ oliIdSet.add(oliId); } OLI = [ SELECT Name,ProductCode,Quantity FROM OpportunityLineItem WHERE Id IN :oliIdSet ]; } } }
My VF:
<apex:page standardController="Opportunity" extensions="OpptyGenPDFExtension" renderAs="pdf"> <table width="100%" style="font-family: Arial, Helvetica, sans-serif; border-collapse: collapse;" cellpadding="5"> <tr> <td colspan="4"> Hardware Anforderungen für neues System </td> <td> Printed on: {!DAY(TODAY())}.{!MONTH(TODAY())}.{!YEAR(TODAY())} </td> </tr> <tr> <td colspan="4" style="font-size: x-large; font-weight: bold"> Opportunity Name: {!Opportunity.Name} </td> </tr> <tr> <td align="left" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> <td align="left" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> </tr> <tr> <td align="left" style="color: #808080; border-right-style: solid; border-right-width: thin; border-right-color: #ddb929;"> Opportunity Number </td> <td style="font-weight: bold"> {!Opportunity.Opportunity_Nummer__c} </td> </tr> <tr> <td align="left" style="color: #808080; border-right-style: solid; border-right-width: thin; border-right-color: #ddb929;"> Hardware configured by </td> <td style="font-weight: bold"> {!Opportunity.System_konfiguriert_von__c} </td> </tr> <tr> <td align="left" style="color: #808080; border-right-style: solid; border-right-width: thin; border-right-color: #ddb929;"> Account Name </td> <td style="font-weight: bold"> {!Opportunity.Account.Name} </td> </tr> <tr> <td colspan="4"> </td> </tr> <tr> </tr> <tr> <td style="font-weight: bold"> </td> <td align="right" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> </tr> <tr> <td align="right" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> <td align="right" style="color: #808080; "> </td> <td style="font-weight: bold"> </td> </tr> </table> <br/><br/> <apex:outputPanel rendered="{!OLI != NULL}"> <table width="100%" style="font-family: Arial, Helvetica, sans-serif; border-collapse: collapse;" cellpadding="5"> <tr> <td colspan="6" style="font-weight: bold; border-bottom-style: solid; border-bottom-width: thick; border-bottom-color: #ddb929;"> Line Item </td> </tr> <tr> <td style="font-weight: bold; background-color: #FFFFCC;"> Product Name </td> <td style="font-weight: bold; background-color: #FFFFCC;"> Product Code </td> <td style="font-weight: bold; background-color: #FFFFCC;"> Quantity </td> </tr> <apex:repeat value="{!OLI}" var="opl"> <tr id="{!opl.Id}"> <td> {!opl.Name} </td> <td> {!opl.ProductCode} </td> <td> {!opl.Quantity} </td> </tr> </apex:repeat> </table> </apex:outputPanel> </apex:page>
- Daniel Khan 21
- September 08, 2017
- Like
- 0
- Continue reading or reply
How to create pdf on opportunity object ?
There is already a similiar case which was solved by Deepak Anand, but as I have not much understanding of APEX Classes etc yet, please can someone help me? THANKS.
https://success.salesforce.com/answers?id=90630000000hTXHAA2
- Daniel Khan 21
- September 01, 2017
- Like
- 0
- Continue reading or reply
ISO Week Calculation
In Sweden and some other parts of Europe the week numbering is often using the ISO 8601 standard that says that the first week of the year is the first week with at least 4 days in the new year. Some consequences of this is that the final dates of one year can be week 52, 53 or even week 1( in the following year). The same goes for the first dates of a year.
To be able to do weekly comparison report Year-to-Year with this weeknumbering it is necessary to create custom fields for the opportunity that calculates the Year and Week number for a given close date. Here is one solution using three custom formula fields.
Field: Global Sales Report Weekday
Description: Day 1 = Sunday, 2 = Monday....., 7=Saturday
Formula: MOD( CloseDate - DATE(1900, 1, 7), 7)+1
Field: Global Sales Report Week Year
Formula: YEAR(CloseDate + (MOD(8- Global_Sales_Report_Weekday__c ,7)-3))
Field: Global Sales Report Week
Formula:
FLOOR((CloseDate - DATE( Global_Sales_Report_Week_Year__c ,1,1) +
MOD(
(MOD( DATE(Global_Sales_Report_Week_Year__c,1,1) - DATE(1900, 1, 7), 7)+1)
+1,7)-3) / 7 + 1)
Hope this can be of use for anyone else
Peter Baeza
InfoAction AB, Sweden
- pbaeza
- March 15, 2010
- Like
- 3
- Continue reading or reply