Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form method="post" action="/?module=accounts&controller=reports&action=r1" id="save_form" enctype="multipart/form-data">
- <table class="formgrid" width="100%">
- <tr>
- <td colspan="2"> </td>
- <td class="label" width="100%">End date</td>
- <td class="value"><input type="text" class="datepicker" name="date" id="date" value="{$date}"/></td>
- </tr>
- <tr>
- <td align="center" colspan="2"> </td>
- <td class="buttonbar" colspan="2">
- <input type="submit" name="search" value="Search"/>
- </td>
- </tr>
- </table>
- </form>
- <div id="tabs">
- <ul>
- <li><a href="#tabs-ov">Overview</a></li>
- <li><a href="#tabs-o">Occupier</a></li>
- <li><a href="#tabs-t">Tenant Invoice</a></li>
- </ul>
- <div id="tabs-ov">
- <table class="display" id="ov" style="display:none;">
- <thead>
- <tr>
- <th>Overview</th>
- <th>{$quarters.0.period}</th>
- <th>{$quarters.1.period}</th>
- <th>{$quarters.2.period}</th>
- <th>{$quarters.3.period}</th>
- <th>{$quarters.4.period}</th>
- <th>{$quarters.5.period}</th>
- <th>{$quarters.6.period}</th>
- <th>{$quarters.7.period}</th>
- <th>{$quarters.8.period}</th>
- <th>Total</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>Occupier Billed</td>
- <td>{$totals.o.0.billed|pricify}</td>
- <td>{$totals.o.1.billed|pricify}</td>
- <td>{$totals.o.2.billed|pricify}</td>
- <td>{$totals.o.3.billed|pricify}</td>
- <td>{$totals.o.4.billed|pricify}</td>
- <td>{$totals.o.5.billed|pricify}</td>
- <td>{$totals.o.6.billed|pricify}</td>
- <td>{$totals.o.7.billed|pricify}</td>
- <td>{$totals.o.8.billed|pricify}</td>
- <td>{$totals.o.total.billed|pricify}</td>
- </tr>
- <tr>
- <td>Occupier Paid</td>
- <td>{$totals.o.0.paid|pricify}</td>
- <td>{$totals.o.1.paid|pricify}</td>
- <td>{$totals.o.2.paid|pricify}</td>
- <td>{$totals.o.3.paid|pricify}</td>
- <td>{$totals.o.4.paid|pricify}</td>
- <td>{$totals.o.5.paid|pricify}</td>
- <td>{$totals.o.6.paid|pricify}</td>
- <td>{$totals.o.7.paid|pricify}</td>
- <td>{$totals.o.8.paid|pricify}</td>
- <td>{$totals.o.total.paid|pricify}</td>
- </tr>
- <tr class="odd">
- <td class="dtblue">Occupier Balance</td>
- <td class="dtblue">{$totals.o.0.balance|pricify}</td>
- <td class="dtblue">{$totals.o.1.balance|pricify}</td>
- <td class="dtblue">{$totals.o.2.balance|pricify}</td>
- <td class="dtblue">{$totals.o.3.balance|pricify}</td>
- <td class="dtblue">{$totals.o.4.balance|pricify}</td>
- <td class="dtblue">{$totals.o.5.balance|pricify}</td>
- <td class="dtblue">{$totals.o.6.balance|pricify}</td>
- <td class="dtblue">{$totals.o.7.balance|pricify}</td>
- <td class="dtblue">{$totals.o.8.balance|pricify}</td>
- <td class="dtblue">{$totals.o.total.balance|pricify}</td>
- </tr>
- <tr>
- <td>Tenant Billed</td>
- <td>{$totals.t.0.billed|pricify}</td>
- <td>{$totals.t.1.billed|pricify}</td>
- <td>{$totals.t.2.billed|pricify}</td>
- <td>{$totals.t.3.billed|pricify}</td>
- <td>{$totals.t.4.billed|pricify}</td>
- <td>{$totals.t.5.billed|pricify}</td>
- <td>{$totals.t.6.billed|pricify}</td>
- <td>{$totals.t.7.billed|pricify}</td>
- <td>{$totals.t.8.billed|pricify}</td>
- <td>{$totals.t.total.billed|pricify}</td>
- </tr>
- <tr>
- <td>Tenant Paid</td>
- <td>{$totals.t.0.paid|pricify}</td>
- <td>{$totals.t.1.paid|pricify}</td>
- <td>{$totals.t.2.paid|pricify}</td>
- <td>{$totals.t.3.paid|pricify}</td>
- <td>{$totals.t.4.paid|pricify}</td>
- <td>{$totals.t.5.paid|pricify}</td>
- <td>{$totals.t.6.paid|pricify}</td>
- <td>{$totals.t.7.paid|pricify}</td>
- <td>{$totals.t.8.paid|pricify}</td>
- <td>{$totals.t.total.paid|pricify}</td>
- </tr>
- <tr class="odd">
- <td class="dtblue">Tenant Balance</td>
- <td class="dtblue">{$totals.t.0.balance|pricify}</td>
- <td class="dtblue">{$totals.t.1.balance|pricify}</td>
- <td class="dtblue">{$totals.t.2.balance|pricify}</td>
- <td class="dtblue">{$totals.t.3.balance|pricify}</td>
- <td class="dtblue">{$totals.t.4.balance|pricify}</td>
- <td class="dtblue">{$totals.t.5.balance|pricify}</td>
- <td class="dtblue">{$totals.t.6.balance|pricify}</td>
- <td class="dtblue">{$totals.t.7.balance|pricify}</td>
- <td class="dtblue">{$totals.t.8.balance|pricify}</td>
- <td class="dtblue">{$totals.t.total.balance|pricify}</td>
- </tr>
- </tbody>
- <tfoot>
- </tfoot>
- </table>
-
- </div>
- <div id="tabs-o">
- <table class="display" id="otable" style="display:none;">
- <thead>
- <tr>
- <th>ID</th>
- <th>Address</th>
- <th>Postcode</th>
- <th>{$quarters.0.period} Billed</th>
- <th>{$quarters.0.period} Paid</th>
- <th>{$quarters.1.period} Billed</th>
- <th>{$quarters.1.period} Paid</th>
- <th>{$quarters.2.period} Billed</th>
- <th>{$quarters.2.period} Paid</th>
- <th>{$quarters.3.period} Billed</th>
- <th>{$quarters.3.period} Paid</th>
- <th>{$quarters.4.period} Billed</th>
- <th>{$quarters.4.period} Paid</th>
- <th>{$quarters.5.period} Billed</th>
- <th>{$quarters.5.period} Paid</th>
- <th>{$quarters.6.period} Billed</th>
- <th>{$quarters.6.period} Paid</th>
- <th>{$quarters.7.period} Billed</th>
- <th>{$quarters.7.period} Paid</th>
- <th>{$quarters.8.period} Billed</th>
- <th>{$quarters.8.period} Paid</th>
- <th>Total Billed</th>
- <th>Total Paid</th>
- <th>Balance</th>
- </tr>
- </thead>
- <tbody>
- {foreach from=$ohouses key=id item=house}
- <tr>
- <td><a href="/?module=glide&controller=houses&action=view&id={$id}">{$id}</a></td>
- <td><a href="/?module=glide&controller=houses&action=view&id={$id}">{$house.address1}</a></td>
- <td>{$house.postcode}</td>
- <td>{$house.0.billed|pricify}</td>
- <td>{$house.0.paid|pricify}</td>
- <td>{$house.1.billed|pricify}</td>
- <td>{$house.1.paid|pricify}</td>
- <td>{$house.2.billed|pricify}</td>
- <td>{$house.2.paid|pricify}</td>
- <td>{$house.3.billed|pricify}</td>
- <td>{$house.3.paid|pricify}</td>
- <td>{$house.4.billed|pricify}</td>
- <td>{$house.4.paid|pricify}</td>
- <td>{$house.5.billed|pricify}</td>
- <td>{$house.5.paid|pricify}</td>
- <td>{$house.6.billed|pricify}</td>
- <td>{$house.6.paid|pricify}</td>
- <td>{$house.7.billed|pricify}</td>
- <td>{$house.7.paid|pricify}</td>
- <td>{$house.8.billed|pricify}</td>
- <td>{$house.8.paid|pricify}</td>
- <td>{$house.total.billed|pricify}</td>
- <td>{$house.total.paid|pricify}</td>
- <td>{$house.total.balance|pricify}</td>
- </tr>
- {/foreach}
- </tbody>
- <tfoot>
- <tr>
- <th>Total</th>
- <th></th>
- <th></th>
- <th>{$totals.o.0.billed|pricify}</th>
- <th>{$totals.o.0.paid|pricify}</th>
- <th>{$totals.o.1.billed|pricify}</th>
- <th>{$totals.o.1.paid|pricify}</th>
- <th>{$totals.o.2.billed|pricify}</th>
- <th>{$totals.o.2.paid|pricify}</th>
- <th>{$totals.o.3.billed|pricify}</th>
- <th>{$totals.o.3.paid|pricify}</th>
- <th>{$totals.o.4.billed|pricify}</th>
- <th>{$totals.o.4.paid|pricify}</th>
- <th>{$totals.o.5.billed|pricify}</th>
- <th>{$totals.o.5.paid|pricify}</th>
- <th>{$totals.o.6.billed|pricify}</th>
- <th>{$totals.o.6.paid|pricify}</th>
- <th>{$totals.o.7.billed|pricify}</th>
- <th>{$totals.o.7.paid|pricify}</th>
- <th>{$totals.o.8.billed|pricify}</th>
- <th>{$totals.o.8.paid|pricify}</th>
- <th>{$totals.o.total.billed|pricify}</th>
- <th>{$totals.o.total.paid|pricify}</th>
- <th>{$totals.o.total.balance|pricify}</th>
- </tr>
- </tfoot>
- </table>
-
- </div>
- <div id="tabs-t">
- <table class="display" id="ttable" style="display:none;">
- <thead>
- <tr>
- <th>ID</th>
- <th>Address</th>
- <th>Postcode</th>
- <th>{$quarters.0.period} Billed</th>
- <th>{$quarters.0.period} Paid</th>
- <th>{$quarters.1.period} Billed</th>
- <th>{$quarters.1.period} Paid</th>
- <th>{$quarters.2.period} Billed</th>
- <th>{$quarters.2.period} Paid</th>
- <th>{$quarters.3.period} Billed</th>
- <th>{$quarters.3.period} Paid</th>
- <th>{$quarters.4.period} Billed</th>
- <th>{$quarters.4.period} Paid</th>
- <th>{$quarters.5.period} Billed</th>
- <th>{$quarters.5.period} Paid</th>
- <th>{$quarters.6.period} Billed</th>
- <th>{$quarters.6.period} Paid</th>
- <th>{$quarters.7.period} Billed</th>
- <th>{$quarters.7.period} Paid</th>
- <th>{$quarters.8.period} Billed</th>
- <th>{$quarters.8.period} Paid</th>
- <th>Total Billed</th>
- <th>Total Paid</th>
- <th>Balance</th>
- </tr>
- </thead>
- <tbody>
- {foreach from=$thouses key=id item=house}
- <tr>
- <td><a href="/?module=glide&controller=houses&action=view&id={$id}">{$id}</a></td>
- <td><a href="/?module=glide&controller=houses&action=view&id={$id}">{$house.address1}</a></td>
- <td>{$house.postcode}</td>
- <td>{$house.0.billed|pricify}</td>
- <td>{$house.0.paid|pricify}</td>
- <td>{$house.1.billed|pricify}</td>
- <td>{$house.1.paid|pricify}</td>
- <td>{$house.2.billed|pricify}</td>
- <td>{$house.2.paid|pricify}</td>
- <td>{$house.3.billed|pricify}</td>
- <td>{$house.3.paid|pricify}</td>
- <td>{$house.4.billed|pricify}</td>
- <td>{$house.4.paid|pricify}</td>
- <td>{$house.5.billed|pricify}</td>
- <td>{$house.5.paid|pricify}</td>
- <td>{$house.6.billed|pricify}</td>
- <td>{$house.6.paid|pricify}</td>
- <td>{$house.7.billed|pricify}</td>
- <td>{$house.7.paid|pricify}</td>
- <td>{$house.8.billed|pricify}</td>
- <td>{$house.8.paid|pricify}</td>
- <td>{$house.total.billed|pricify}</td>
- <td>{$house.total.paid|pricify}</td>
- <td>{$house.total.balance|pricify}</td>
- </tr>
- {/foreach}
- </tbody>
- <tfoot>
- <tr>
- <th>Total</th>
- <th></th>
- <th></th>
- <th>{$totals.t.0.billed|pricify}</th>
- <th>{$totals.t.0.paid|pricify}</th>
- <th>{$totals.t.1.billed|pricify}</th>
- <th>{$totals.t.1.paid|pricify}</th>
- <th>{$totals.t.2.billed|pricify}</th>
- <th>{$totals.t.2.paid|pricify}</th>
- <th>{$totals.t.3.billed|pricify}</th>
- <th>{$totals.t.3.paid|pricify}</th>
- <th>{$totals.t.4.billed|pricify}</th>
- <th>{$totals.t.4.paid|pricify}</th>
- <th>{$totals.t.5.billed|pricify}</th>
- <th>{$totals.t.5.paid|pricify}</th>
- <th>{$totals.t.6.billed|pricify}</th>
- <th>{$totals.t.6.paid|pricify}</th>
- <th>{$totals.t.7.billed|pricify}</th>
- <th>{$totals.t.7.paid|pricify}</th>
- <th>{$totals.t.8.billed|pricify}</th>
- <th>{$totals.t.8.paid|pricify}</th>
- <th>{$totals.t.total.billed|pricify}</th>
- <th>{$totals.t.total.paid|pricify}</th>
- <th>{$totals.o.total.balance|pricify}</th>
- </tr>
- </tfoot>
- </table>
-
- </div>
- </div>
- <div style="clear:both;"></div>
- {literal}
- <script type="text/javascript">
- ( function($) {
- $(document).ready(function() {
- $.rloader([
- {type:'js',src:'/app/js/lib/jquery/dataTables-1.7/media/js/jquery.dataTables.min.js'},
- {type:'js',src:'/app/js/lib/jquery/dataTables-1.7/media/js/jquery.dataTables.extensions.js'},
- {type:'js',src:'/app/js/lib/jquery/dataTables-1.7/media/js/TableTools.min.js'},
- {type:'css',src:'/app/js/lib/jquery/dataTables-1.7/media/css/TableTools.css'}
- ]);
- $("#tabs").tabs();
- // apply DataTables plugin to tables
- $('#ov').dataTable({
- "bJQueryUI": true,
- "bProcessing": false,
- "bPaginate": false,
- "bFilter": false,
- "bSort": false,
- "oLanguage": {
- "sInfo": "",
- "sLengthMenu": ""
- },
- "aoColumns": [
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false},
- {"bSortable": false}
- ],
- "sDom": 'T<"clear"><"H"lfr>t<"F"ip>',
- "oTableTools": {
- "sSwfPath": "/app/js/lib/jquery/dataTables-1.7/media/swf/copy_cvs_xls_pdf.swf"
- }
- });
- $('#ov').show();
- $('#otable').dataTable({
- "bJQueryUI": true,
- "sPaginationType": "full_numbers",
- "bProcessing": true,
- "iDisplayLength": 10,
- "oLanguage": {
- "sInfo": "Showing _START_ to _END_ of _TOTAL_ houses.",
- "sLengthMenu": 'Display <select>{/literal}{$menuoptions.o}{literal}</select> houses'
- },
- "aoColumns": [
- {"bSortable": true},
- {"bSortable": true},
- {"bSortable": true},
- {"bSortable": true, "sType": "uk_date"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"}
- ],
- "sDom": 'T<"clear"><"H"lfr>t<"F"ip>',
- "oTableTools": {
- "sSwfPath": "/app/js/lib/jquery/dataTables-1.7/media/swf/copy_cvs_xls_pdf.swf"
- }
- });
- $('#otable').show();
- $('#ttable').dataTable({
- "bJQueryUI": true,
- "sPaginationType": "full_numbers",
- "bProcessing": true,
- "iDisplayLength": 10,
- "oLanguage": {
- "sInfo": "Showing _START_ to _END_ of _TOTAL_ houses.",
- "sLengthMenu": 'Display <select>{/literal}{$menuoptions.t}{literal}</select> houses'
- },
- "aoColumns": [
- {"bSortable": true},
- {"bSortable": true},
- {"bSortable": true},
- {"bSortable": true, "sType": "uk_date"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"},
- {"bSortable": true, "sType": "currency"}
- ],
- "sDom": 'T<"clear"><"H"lfr>t<"F"ip>',
- "oTableTools": {
- "sSwfPath": "/app/js/lib/jquery/dataTables-1.7/media/swf/copy_cvs_xls_pdf.swf"
- }
- });
- $('#ttable').show();
- });
- } ) ( jQuery );
- </script>
- {/literal}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement