Fix content as footer data but show only last page in Customer Statement print

<#if statement.lines?has_content>
<#assign maxLines = 0>
<#list statement.lines as line><#if line.balance?string != "$0.00"><#assign maxLines = maxLines+1 ></#if></#list>
<#assign nextIndex = 0>
<#list [1,2,3,4,5,6,7,8,9,10] as pageCnt>
  	<#assign lineCnt = 0>
	<#if maxLines gt nextIndex>
	<#if pageCnt gt 1><pbr/></#if>
	<div align="left" style="height: 435px;">
		<table class="itemtable" style="width: 100%; margin-top: 10px;">
			<!-- start items -->
			<#list statement.lines as line>
				<#if line?counter gte nextIndex>
                  <#if line?counter == 1><#assign nextIndex += 1></#if>
					<#if line?counter==nextIndex>
					<thead>
						<tr>
					<th colspan="3">TYPE</th>
					<th colspan="3">INV. DATE</th>
					<th colspan="3">DUE DATE</th>
					<th colspan="4">INV. NO.</th>
					<th colspan="4">P/O NO.</th>
					<th align="right" colspan="3">AMOUNT</th>
					<th align="right" colspan="3">BALANCE OWING</th>
						</tr>
					</thead>
					</#if>
					<#if lineCnt == 20>
						<#assign nextIndex = line?counter>
						<#break>
					<#else>
			<#assign rec_type = "" ><#assign rec_num = "" ><#if line.description?substring(0,7) == "Invoice"><#assign rec_type = "Invoice" ><#assign rec_num = line.description?substring(9)><#elseif line.description?substring(0,6) == "Credit"><#assign rec_type = "Credit Memo" ><#assign rec_num = line.description?substring(13)><#elseif line.description?substring(0,7) == "Payment"><#assign rec_type = "Payment" ><#assign rec_num = line.description?substring(9)><#elseif line.description == "Balance Forward"><#assign rec_type = "Balance Forward" ><#elseif line.description?substring(0,5) == "th_TH"><#else></#if><#assign countLineCharge = line.charge?length><#assign countLineRemaining = line.amountremaining?length><#if countLineCharge gt 1 && countLineRemaining gt 1><#assign amtPaid = line.charge - line.amountremaining><#else><#assign amtPaid = ""></#if>
			<#if line.balance?string != "$0.00">
			    <tr>
			   <td colspan="3">${rec_type}</td>
			   <td colspan="3">${line.datecol}</td>
			   <td colspan="3">${line.duedate}</td>
			   <td colspan="4">${rec_num}</td>
			   <td colspan="4">${line.otherrefnum}</td>
			   <td align="right" colspan="3">${line.charge}${line.payment}</td>
			  <td align="right" colspan="3">${line.balance}</td>
		         </tr>
                          <#assign nextIndex = line?counter>
				<#assign lineCnt = lineCnt+1>
			</#if>
			</#if>
			</#if>
			</#list>
			<!-- end items -->
		</table>
	</div>
	</#if>
</#list>

<#assign nowMonth = statement.trandate?string["M"]><#assign aging2Month = ""><#assign aging3Month = ""><#if nowMonth == "1"><#assign aging2Month = "DEC"><#assign aging3Month = "NOV"><#elseif nowMonth == "2"><#assign aging2Month = "JAN"><#assign aging3Month = "DEC"><#elseif nowMonth == "3"><#assign aging2Month = "FEB"><#assign aging3Month = "JAN"><#elseif nowMonth == "4"><#assign aging2Month = "MAR"><#assign aging3Month = "FEB"><#elseif nowMonth == "5"><#assign aging2Month = "APR"><#assign aging3Month = "MAR"><#elseif nowMonth == "6"><#assign aging2Month = "MAY"><#assign aging3Month = "APR"><#elseif nowMonth == "7"><#assign aging2Month = "JUN"><#assign aging3Month = "MAY"><#elseif nowMonth == "8"><#assign aging2Month = "JUL"><#assign aging3Month = "JUN"><#elseif nowMonth == "9"><#assign aging2Month = "AUG"><#assign aging3Month = "JUL"><#elseif nowMonth == "10"><#assign aging2Month = "SEP"><#assign aging3Month = "AUG"><#elseif nowMonth == "11"><#assign aging2Month = "OCT"><#assign aging3Month = "SEP"><#else><#assign aging2Month = "NOV"><#assign aging3Month = "OCT"></#if>

<table style="width: 100%; margin-top: 10px;"><tr>
<td style="width:60%;">
<table class="aging" style="width: 100%; border: 1px solid #999999; corner-radius: 5px;"><tr>
	<th align="center" style="border-right: 1px solid #999999;">
	<p class="agingname">PRE-${aging3Month}</p>
	</th>
	<th align="center" style="border-right: 1px solid #999999;">
	<p class="agingname">${aging3Month}</p>
	</th>
	<th align="center" style="border-right: 1px solid #999999;">
	<p class="agingname">${aging2Month}</p>
	</th>
	<th align="center">
	<p class="agingname">CURRENT</p>
	</th>
	</tr>
	<tr>
	<td align="center" style="border-right: 1px solid #999999;border-top: 1px solid #999999;">
	<p class="agingdetail">${nsformat_rate(statement.aging4+statement.aging5)}</p>
	</td>
	<td align="center" style="border-right: 1px solid #999999;border-top: 1px solid #999999;"><p class="agingdetail">${statement.aging3}</p>
		</td>
		<td align="center" style="border-right: 1px solid #999999;border-top: 1px solid #999999;">
		<p class="agingdetail">${statement.aging2}</p>
		</td>
		<td align="center" style="border-top: 1px solid #999999;">
		<p class="agingdetail">${statement.aging1}</p>
		</td>
		</tr></table>
      
	</td>
	<td style="width:40%;">
	<table class="aging" style="width: 100%; border: 1px solid #999999; corner-radius: 5px;"><tr>
		<th align="center">
		<p class="agingname">AMOUNT DUE</p>
		</th>
		<td align="left">
		<p class="agingdetail">${statement.agingbal}</p>
		</td>
		</tr>
		<tr>
		<th align="center" style="border-top: 1px solid #999999;">
		<p class="agingname">TOTAL OVERDUE</p>
		</th>
		<td align="left" style="border-top: 1px solid #999999;">
		<p class="agingdetail">${customer.overduebalance}</p>
		</td>
		</tr></table>
	</td>
	</tr></table>
</#if>

<hr />
<p class="po-label">PAYMENT DETAILS</p>
<!--<hr style="margin-top: 2px;"/>-->

<table style="width: 100%; margin-top: 0px;"><tr>
	<td style="width:25%; border-top: 1px solid #999999;">
	<p class="contact_info" style="font-weight:bold;">POST TO:</p>

	<p class="contact_info"><#if subsidiary.addr1?has_content >${subsidiary.addr1}</#if><br /><#if subsidiary.city?has_content >${subsidiary.city},</#if> <#if subsidiary.state?has_content >${subsidiary.state},</#if> <#if subsidiary.zip?has_content >${subsidiary.zip}</#if></p>
	</td>
	<td style="width:25%; border-top: 1px solid #999999;">
	<p class="contact_info" style="font-weight:bold;">ACCOUNT:</p>

	<p class="contact_info">${statement.billaddress}</p>
	</td>
	<td style="width:30%; border-top: 1px solid #999999;">
	<p class="contact_info" style="font-weight:bold;">STATEMENT DATE:</p>

	<p class="contact_info" style="font-weight:bold;">CREDIT TERMS:</p>

	<p class="contact_info" style="font-weight:bold;">ACCOUNT NUMBER:</p>

	<p class="contact_info" style="font-weight:bold;">STATEMENT BALANCE:</p>
	</td>
	<td style="width:20%; border-top: 1px solid #999999;">
	<p class="contact_info">${statement.trandate}</p>

	<p class="contact_info">${statement.terms}</p>

	<p class="contact_info">${customer.externalid}&nbsp;</p>

	<p class="contact_info">${statement.agingbal}</p>
	</td>
	</tr></table>
</body></pdf></#list>

Leave a comment

Your email address will not be published. Required fields are marked *