Search the Community
Showing results for tags 'paid invoice'.
Found 1 result
-
Dear All, I want display some fix virtual account for payment when client view invoice & on PDF. This Virtual Account is consist of 5 digits our Bank Unique Number + 4 digits customer code from Custom Client fields + 7 digits Proforma Invoice Number I've succesfully create the custom code in viewinvoice.tpl & invoicepdf.tpl under template folder. The result is fine if the status still Unpaid because the Proforma Invoice number show as is. But when this Invoice has been Paid the Invoice Number value from Database is change with sequential Invoice Number, so the custom code that I created didn't show the previous Invoice Number which is a Proforma Invoice Number. Is there any idea how to get the Proforma Invoice Number after Invoice has been Paid ? Here's my code: invoicepdf.tpl #Start - Payment Method $pdf->SetFont($pdfFont,'',9); $paymethhtml = '<table width:"100%" bgcolor="#ccc" cellspacing="1" cellpadding="2" border="0"> <tr height="30" bgcolor="#efefef" style="font-weight:bold;text-align:left;"> <td width="100%" colspan="2" align="left"> <h3 class="panel-title"><strong>Special Notes and Instructions</strong></h3> </td> </tr>'; $paymethhtml .= ' <tr bgcolor="#fff"> <td width="15%" align="left">Bank</td> <td width="85%" align="left">: BCA KCP Permata Buana</td> </tr>'; if ($status == 'Paid') { $paymethhtml .= ' <tr bgcolor="#fff"> <td width="15%" align="left">A/C Number</td> <td width="85%" align="left">: '.$clientsdetails["customfields2"].''.substr($clientsdetails["customfields1"],3).''.$invoicenum.'</td> </tr>'; } else { $paymethhtml .= ' <tr bgcolor="#fff"> <td width="15%" align="left">A/C</td> <td width="85%" align="left">: '.$clientsdetails["customfields2"].''.substr($clientsdetails["customfields1"],3).''.$invoicenum.'</td> </tr>'; } $paymethhtml .= ' <tr bgcolor="#fff"> <td width="15%" align="left">Account Name</td> <td width="85%" align="left">: '.$clientsdetails["companyname"].'</td> </tr> </table>'; $pdf->writeHTML($paymethhtml, true, false, false, false, ''); #End - Payment Method viewinvoice.tpl <!--Start - How to Payment--> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title"><strong>Special Notes and Instructions</strong></h3> </div> <div class="panel-body"> <div class="table-responsive"> <table class="table table-condensed" width="100%"> <thead> <tr> <td>Bank</td> <td>: BCA KCP Permata Buana</td> </tr> </thead> {if $status eq "Paid"} <tr> <td>A/C</td> <td>: {$clientsdetails["customfields2"]}{$clientsdetails["customfields1"]|substr:3}{$invoicenum}</td> </tr> {else} <tr> <td>A/C</td> <td>: {$clientsdetails["customfields2"]}{$clientsdetails["customfields1"]|substr:3}{$invoicenum}</td> </tr> {/if} <tr> <td>Account Name</td> <td>: {$clientsdetails.companyname}</td> </tr> </table> </div> </div> </div> <!--End - How to Payment-->