Sign Up ›
  • Admin 2467
  • NEWBIE
  • 10 Points
  • Member since 2019
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 2
    Replies
1 replies

How to create custom controller on custom object?

i have a custom object "program" and there have a custom object "Receipt" under the "program". (For the customer register the program)

Now i am create a VF page that gain the "program" and "receiprt" data and generate the PDF Form.

At the begining, i use the standard controller and everything fine. But after i found a logic bug that the standard controller is get all data on "Program" and "Receipt" Tablet. 

The problem is "Receipt" table have the status field to decide the receiprt status "Normal" and "Cancel". And the standard controller will 
get all the data whihc is no matter is cancel status.

Please advise how to create an custom controller with condition contorl. Thanks.

2 replies

PDF paginate second page missing border

Hi everyone, any idea for missing border when using  -fs-table-paginate: paginate?

First page border is existing .User-added image
Second page is missing borderUser-added image

Here is my code 
<apex:page standardController="Program__c" renderAs="pdf" applyBodyTag="false">

          <apex:variable var="rowIndex" value="{!1}"/>
          
        <head>
            <style> 
               @page {@bottom-center {content: "Page " counter(page) " of " counter(pages);}}
                body { font-family: 'Arial Unicode MS';} 
                 table{
                -fs-table-paginate: paginate;
                border-collapse: collapse;
                border-spacing: 0;
                border:0px
          }
            </style>            
        </head>

<apex:datatable style="width:720px;border-collapse:collapse" value="{!Program__c.Registration__r}" var="Registration">    
<apex:facet name="header">

  <table style="width:720px;border-collapse:collapse" >
            <tr>
            <td style="width:20px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">No</td>
            <td style="width:50px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">姓名</td>
            <td style="width:55px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">會員編號</td>
            <td style="width:55px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">收據編號</td>   
            <td style="text-align:center;border:1px solid #000;font-size: 10px" colspan="12">出席日期</td>
            <td style="width:70px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2" >備註</td> 
        </tr>
        <tr>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
        </tr>
    </table>
</apex:facet>

 
SOLVED
2 replies

apex:datatable width

hi all
i am newbie for vf
below image as my vf pdf report and i can't adjust the column width. Any idea? I tried set to width = % and width = px but still not working Thanks.
User-added image 
<apex:datatable width="100%"  style="border-collapse:collapse" value="{!Program__c.Registration__r}" var="Registration" >    
<apex:facet name="header">

  <table width ="100%" style="border-collapse:collapse" >
            <tr>
            <td width="4%" style="text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">A</td>
            <td width="8%" rowspan="2" style = "text-align:center;border:1px solid #000" >B</td>
            <td width="10%" rowspan="2" style="text-align:center;border:1px solid #000">C</td>
            <td width="10%" rowspan="2" style="text-align:center;border:1px solid #000">D</td>   
            <td colspan="12" style="text-align:center;border:1px solid #000">E</td>
            <td width="5%" rowspan="2" style="text-align:right;border:1px solid #000">F</td> 
        </tr>
        <tr>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
        </tr>
    </table>

</apex:facet>
    <apex:column width="4%" style="text-align:center;border:1px solid #000;font-size: 10px" >{!rowIndex} <apex:variable var="rowIndex" value="{!rowIndex+1}" /></apex:column>
    <apex:column width="7%" style="text-align:center;border:1px solid #000;font-size: 10px"> <apex:outputText value="{!Registration.Calc_Partial_Refund_Amount__c}"/></apex:column>
    <apex:column width="9%" style="text-align:center;border:1px solid #000;font-size: 10px"><apex:outputText value="{!Registration.Membership_Number__c}"/></apex:column>
    <apex:column width="9%" style="text-align:center;border:1px solid #000;font-size: 10px"><apex:outputText value="{!Registration.Name}"/></apex:column>
    <apex:column style="width:5%;text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>    
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column> 
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>    
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>   
</apex:datatable>

 
2 replies

PDF paginate second page missing border

Hi everyone, any idea for missing border when using  -fs-table-paginate: paginate?

First page border is existing .User-added image
Second page is missing borderUser-added image

Here is my code 
<apex:page standardController="Program__c" renderAs="pdf" applyBodyTag="false">

          <apex:variable var="rowIndex" value="{!1}"/>
          
        <head>
            <style> 
               @page {@bottom-center {content: "Page " counter(page) " of " counter(pages);}}
                body { font-family: 'Arial Unicode MS';} 
                 table{
                -fs-table-paginate: paginate;
                border-collapse: collapse;
                border-spacing: 0;
                border:0px
          }
            </style>            
        </head>

<apex:datatable style="width:720px;border-collapse:collapse" value="{!Program__c.Registration__r}" var="Registration">    
<apex:facet name="header">

  <table style="width:720px;border-collapse:collapse" >
            <tr>
            <td style="width:20px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">No</td>
            <td style="width:50px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">姓名</td>
            <td style="width:55px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">會員編號</td>
            <td style="width:55px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">收據編號</td>   
            <td style="text-align:center;border:1px solid #000;font-size: 10px" colspan="12">出席日期</td>
            <td style="width:70px;text-align:center;border:1px solid #000;font-size: 10px" rowspan="2" >備註</td> 
        </tr>
        <tr>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td style="text-align:right;border:1px solid #000">&nbsp;</td>
        </tr>
    </table>
</apex:facet>

 
SOLVED
2 replies

apex:datatable width

hi all
i am newbie for vf
below image as my vf pdf report and i can't adjust the column width. Any idea? I tried set to width = % and width = px but still not working Thanks.
User-added image 
<apex:datatable width="100%"  style="border-collapse:collapse" value="{!Program__c.Registration__r}" var="Registration" >    
<apex:facet name="header">

  <table width ="100%" style="border-collapse:collapse" >
            <tr>
            <td width="4%" style="text-align:center;border:1px solid #000;font-size: 10px" rowspan="2">A</td>
            <td width="8%" rowspan="2" style = "text-align:center;border:1px solid #000" >B</td>
            <td width="10%" rowspan="2" style="text-align:center;border:1px solid #000">C</td>
            <td width="10%" rowspan="2" style="text-align:center;border:1px solid #000">D</td>   
            <td colspan="12" style="text-align:center;border:1px solid #000">E</td>
            <td width="5%" rowspan="2" style="text-align:right;border:1px solid #000">F</td> 
        </tr>
        <tr>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
            <td width="5%" style="text-align:right;border:1px solid #000">&nbsp;</td>
        </tr>
    </table>

</apex:facet>
    <apex:column width="4%" style="text-align:center;border:1px solid #000;font-size: 10px" >{!rowIndex} <apex:variable var="rowIndex" value="{!rowIndex+1}" /></apex:column>
    <apex:column width="7%" style="text-align:center;border:1px solid #000;font-size: 10px"> <apex:outputText value="{!Registration.Calc_Partial_Refund_Amount__c}"/></apex:column>
    <apex:column width="9%" style="text-align:center;border:1px solid #000;font-size: 10px"><apex:outputText value="{!Registration.Membership_Number__c}"/></apex:column>
    <apex:column width="9%" style="text-align:center;border:1px solid #000;font-size: 10px"><apex:outputText value="{!Registration.Name}"/></apex:column>
    <apex:column style="width:5%;text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>    
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column> 
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>    
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>
    <apex:column width="5%" style="text-align:center;border:1px solid #000"><apex:outputText value=""/></apex:column>   
</apex:datatable>