textarea<!-- {#template MAIN} {#foreach $T.Data as record} {#include ROW root=$T.record} {#/for} <tr class="totals"> {#foreach $T.Totals as record} {#include ROWFOOTER root=$T.record} {#/for} </tr> {#/template MAIN} {#template ROW} <tr class="{#cycle values=['alt','']}"> <td class="left"> {#if $T.Directoratecode != '' && $T.Directoratecode != null} <a href='#' title='Filter by {$T.Directoratecode}'>{$T.Directoratecode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Directorate != '' && $T.Directorate != null} <a href='#' title='Filter by {$T.Directorate}'>{$T.Directorate}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Servicecode != '' && $T.Servicecode != null} <a href='#' title='Filter by {$T.Servicecode}'>{$T.Servicecode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Service != '' && $T.Service != null} <a href='#' title='Filter by {$T.Service}'>{$T.Service}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Revenueorcapitalcode != '' && $T.Revenueorcapitalcode != null} <a href='#' title='Filter by {$T.Revenueorcapitalcode}'>{$T.Revenueorcapitalcode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Revenuecapital != '' && $T.Revenuecapital != null} <a href='#' title='Filter by {$T.Revenuecapital}'>{$T.Revenuecapital}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Costcentre != '' && $T.Costcentre != null} <a href='#' title='Filter by {$T.Costcentre}'>{$T.Costcentre}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Costcentredescription != '' && $T.Costcentredescription != null} <a href='#' title='Filter by {$T.Costcentredescription}'>{$T.Costcentredescription}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.BvsubCategory != '' && $T.BvsubCategory != null} <a href='#' title='Filter by {$T.BvsubCategory}'>{$T.BvsubCategory}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Bvsubdescription != '' && $T.Bvsubdescription != null} <a href='#' title='Filter by {$T.Bvsubdescription}'>{$T.Bvsubdescription}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Bvsumcode != '' && $T.Bvsumcode != null} <a href='#' title='Filter by {$T.Bvsumcode}'>{$T.Bvsumcode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Bvsumdescription != '' && $T.Bvsumdescription != null} <a href='#' title='Filter by {$T.Bvsumdescription}'>{$T.Bvsumdescription}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Accountcode != '' && $T.Accountcode != null} <a href='#' title='Filter by {$T.Accountcode}'>{$T.Accountcode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Accountdescription != '' && $T.Accountdescription != null} <a href='#' title='Filter by {$T.Accountdescription}'>{$T.Accountdescription}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.TransactionNo != '' && $T.TransactionNo != null} <a href='#' title='Filter by {$T.TransactionNo}'>{$T.TransactionNo}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Period != '' && $T.Period != null} <a href='#' title='Filter by {$T.Period}'>{$T.Period}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class=""> {#if $T.TransactionDate != '' && $T.TransactionDate != null} <a href='#' title='Filter by {$T.TransactionDate}'>{$T.TransactionDate}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class=""> {#if $T.Amount != '' && $T.Amount != null || $T.Amount=='0' } <a href='#' title='Filter by {$T.Amount}'>{formatNumber($T.Amount,'.',',')}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Classificationcode != '' && $T.Classificationcode != null} <a href='#' title='Filter by {$T.Classificationcode}'>{$T.Classificationcode}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Classificationdescription != '' && $T.Classificationdescription != null} <a href='#' title='Filter by {$T.Classificationdescription}'>{$T.Classificationdescription}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.SupplierID != '' && $T.SupplierID != null} <a href='#' title='Filter by {$T.SupplierID}'>{$T.SupplierID}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Supplierdescription != '' && $T.Supplierdescription != null} <a href='#' title='Filter by {$T.Supplierdescription}'>{$T.Supplierdescription}</a> {#else} <span class="empty">N/A</span> {#/if} </td> <td class="left"> {#if $T.Companyregistrationnumber != '' && $T.Companyregistrationnumber != null} <a href='#' title='Filter by {$T.Companyregistrationnumber}'>{$T.Companyregistrationnumber}</a> {#else} <span class="empty">N/A</span> {#/if} {#if $T.Companyregistrationnumber != '' && $T.Companyregistrationnumber != null} <a href="#" onclick="openLinkedData('http://opencorporates.com/companies/gb/#Data#','{$T.Companyregistrationnumber}'); return false;" title="View linked information for {$T.Companyregistrationnumber} (external link)" class="externallink float_left">linked data</a>{#/if} </td> <td class="left"> {#if $T.VATregistrationnumber != '' && $T.VATregistrationnumber != null} <a href='#' title='Filter by {$T.VATregistrationnumber}'>{$T.VATregistrationnumber}</a> {#else} <span class="empty">N/A</span> {#/if} </td> </tr> {#/template ROW} {#template ROWFOOTER} <td> {#if $T.Directoratecode != null} {$T.Directoratecode} {#/if} </td> <td> {#if $T.Directorate != null} {$T.Directorate} {#/if} </td> <td> {#if $T.Servicecode != null} {$T.Servicecode} {#/if} </td> <td> {#if $T.Service != null} {$T.Service} {#/if} </td> <td> {#if $T.Revenueorcapitalcode != null} {$T.Revenueorcapitalcode} {#/if} </td> <td> {#if $T.Revenuecapital != null} {$T.Revenuecapital} {#/if} </td> <td> {#if $T.Costcentre != null} {$T.Costcentre} {#/if} </td> <td> {#if $T.Costcentredescription != null} {$T.Costcentredescription} {#/if} </td> <td> {#if $T.BvsubCategory != null} {$T.BvsubCategory} {#/if} </td> <td> {#if $T.Bvsubdescription != null} {$T.Bvsubdescription} {#/if} </td> <td> {#if $T.Bvsumcode != null} {$T.Bvsumcode} {#/if} </td> <td> {#if $T.Bvsumdescription != null} {$T.Bvsumdescription} {#/if} </td> <td> {#if $T.Accountcode != null} {$T.Accountcode} {#/if} </td> <td> {#if $T.Accountdescription != null} {$T.Accountdescription} {#/if} </td> <td> {#if $T.TransactionNo != null} {$T.TransactionNo} {#/if} </td> <td> {#if $T.Period != null} {$T.Period} {#/if} </td> <td> {#if $T.TransactionDate != null} {$T.TransactionDate} {#/if} </td> <td> {#if $T.Amount != null} {formatNumber($T.Amount, '.', ',')} {#/if} </td> <td> {#if $T.Classificationcode != null} {$T.Classificationcode} {#/if} </td> <td> {#if $T.Classificationdescription != null} {$T.Classificationdescription} {#/if} </td> <td> {#if $T.SupplierID != null} {$T.SupplierID} {#/if} </td> <td> {#if $T.Supplierdescription != null} {$T.Supplierdescription} {#/if} </td> <td> {#if $T.Companyregistrationnumber != null} {$T.Companyregistrationnumber} {#/if} </td> <td> {#if $T.VATregistrationnumber != null} {$T.VATregistrationnumber} {#/if} </td> {#/template ROWFOOTER} -->
Filter Template<!-- {#template MAIN} <div class="FilterHolder" style="display:none;"> <div class="optioncontainer"> <label for="ColumnToSearch{$T}" class="sr-only">Search by</label> <select id="ColumnToSearch{$T}" name="filter[{$T}].ColumnToSearch" class="ColumnToSearch selectbox small"> <option value="Accountcode" class="text">Account code</option> <option value="Accountdescription" class="text">Account description</option> <option value="Amount" class="number">Amount</option> <option value="BvsubCategory" class="text">Bvsub Category</option> <option value="Bvsubdescription" class="text">Bvsub description</option> <option value="Bvsumcode" class="text">Bvsum code</option> <option value="Bvsumdescription" class="text">Bvsum description</option> <option value="Classificationcode" class="text">Classification code</option> <option value="Classificationdescription" class="text">Classification description</option> <option value="Companyregistrationnumber" class="text">Company registration number</option> <option value="Costcentre" class="text">Cost centre</option> <option value="Costcentredescription" class="text">Cost centre description</option> <option value="Directorate" class="text">Directorate</option> <option value="Directoratecode" class="text">Directorate code</option> <option value="Period" class="text">Period</option> <option value="Revenuecapital" class="text">Revenue capital</option> <option value="Revenueorcapitalcode" class="text">Revenue or capital code</option> <option value="Service" class="text">Service</option> <option value="Servicecode" class="text">Service code</option> <option value="Supplierdescription" class="text">Supplier description</option> <option value="SupplierID" class="text">Supplier ID</option> <option value="TransactionDate" class="datetime">Transaction Date</option> <option value="TransactionNo" class="text">Transaction No</option> <option value="VATregistrationnumber" class="text">VAT registration number</option> </select> </div> <div class="searchByText optioncontainer"> <label for="SearchOperator{$T}" class="sr-only">Search parameters</label> <select id="SearchOperator{$T}" name="filter[{$T}].SearchOperator" class="SearchOperator selectbox small"> <option value="contains">contains</option> <option value="isequalto">is equal to</option> </select> <label for="SearchText{$T}" class="sr-only">Please enter text to search by</label> <input type="text" id="SearchText{$T}" name="filter[{$T}].SearchText" class="text-box searchText"/> </div> <div class="searchByNumber optioncontainer" style="display:none;"> <label for="SearchOperatorNumber{$T}" class="sr-only">Please select</label> <select id="SearchOperatorNumber{$T}" name="filter[{$T}].SearchOperatorNumber" class="SearchOperatorNumber selectbox small"> <option value="greaterthan">greater than</option> <option value="greaterthanequalto">greater than or equal to</option> <option value="lessthan">less than</option> <option value="lessthanequalto">less than or equal to</option> <option value="isequalto">is equal to</option> </select> <label for="SearchNumber{$T}" class="sr-only">Search</label> <input type="text" id="SearchNumber{$T}" name="filter[{$T}].SearchNumber" class="text-box searchNumber number"/> </div> <div class="searchByDate optioncontainer" style="display:none;"> <label for="From{$T}">from</label> <input type="text" id="From{$T}" name="filter[{$T}].From" class="text-box datebox searchDate from date"/> <label for="To{$T}">to</label> <input type="text" id="To{$T}" name="filter[{$T}].To" class="text-box datebox searchDate to date"/> </div> <input type="button" value="-" title="Remove filter" class="button btn-secondary small removeFilter" /> <input id="AddFilter" type="button" title="Add another filter" value="+" class="button btn-secondary small" /> <input id="Filter" type="submit" value="Filter" class="button btn-secondary" /> <input id="ClearFilter" type="button" value="Clear" class="button btn-secondary" /> </div> {#/template MAIN} -->