[% IF trange_f %]

            <h2>Older transactions</h2>

            <table id="past_sales" class="past_sales_table">

                <thead>

                    <th>

                        ID

                    </th>

                    <th>

                        DATA

                    </th>

                    <th>

                        Transaction

                    </th>

                    <th>

                        Description

                    </th>

                    <th>

                        Price

                    </th>

                    <th>

                        Total

                    </th>

                    <th>

                        Actions

                    </th>

                </thead>

                <tbody>

                    [% FOREACH accountline IN past_accountlines %]

                        [% IF accountline.is_credit %]

                            [% FOREACH credit IN accountline.credit_offsets %]

                            [% IF credit.debit %]

                            <tr>

                                <td>[% accountline.accountlines_id %]</td>

                                <td>{ "type": "credit", "description": "[%- PROCESS account_type_description account=accountline -%] ([% accountline.payment_type | html %])", "amount": "[% accountline.amount * -1 | $Price %]" }</td>

                                <td></td>

                                <td>[%- PROCESS account_type_description account=credit.debit -%]

                                    [%- IF credit.debit.description -%] ([% credit.debit.description | html %])[%- END -%]

                                    [%- IF ( credit.debit.itemnumber ) -%] (<a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% credit.debit.item.biblionumber | uri %]&amp;itemnumber=[% credit.debit.itemnumber | uri %]">[% credit.debit.item.biblio.title | html %]</a>)[%- END -%]

                                </td>

                                <td>[% credit.debit.amount | $Price %]</td>

                                <td></td>

                                <td>

                                    [% IF CAN_user_cash_management_refund_cash_registers && !(credit.debit.status == 'REFUNDED' ) %]

                                    <button type="button" class="btn btn-default btn-xs" data-toggle="modal" data-target="#issueRefundModal" data-item="[%- PROCESS account_type_description account=credit.debit -%]" data-accountline="[% credit.debit.accountlines_id | html %]" data-amount="[% credit.debit.amount | $Price %]" data-quantity="[% credit.debit.note | html %]"><i class="fa fa-money"></i> Issue refund</button>

                                    [% END %]

                                </td>

                            </tr>

                            [% END %]

                            [% END %]

                        [% ELSE %]

                            [% FOREACH debit IN accountline.debit_offsets %]

                            [% IF debit.credit %]

                            <tr>

                                <td>[% accountline.accountlines_id %]</td>

                                <td>{ "type": "debit", "description": "[%- PROCESS account_type_description account=accountline -%] ([% accountline.payment_type | html %])", "amount": "[% accountline.amount * -1 | $Price %]" }</td>

                                <td></td>

                                <td>[%- PROCESS account_type_description account=debit.credit -%]</td>

                                <td>[%- IF debit.credit.description %][% debit.credit.description | html %][% END %]

        &nbsp;[% IF ( debit.credit.itemnumber ) %]<a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% debit.credit.item.biblionumber | uri %]&amp;itemnumber=[% debit.credit.itemnumber | uri %]">[% debit.credit.item.biblio.title | html %]</a>[% END %]</td>

                                <td>[% debit.credit.amount | $Price %]</td>

                                <td></td>

                            </tr>

                            [% END %]

                            [% END %]

                        [% END %]

                    [% END %]

                </tbody>

                <tfoot>

                    <tr>

                        <td colspan="5">Total income: </td>

                        <td>[% past_accountlines.total * -1 | $Price %]</td>

                        <td></td>

                    </tr>

                </tfoot>

            </table>

            [% ELSE %]

            [% IF register.cashups %]

            <h2>Older transactions</h2>

            <form method="GET" action="/cgi-bin/koha/pos/register.pl">

			<fieldset class="rows">

                            Please select a date range to display transactions for:

                            <ol>

                                <li>

                                    <label for="trange_f">From: </label>

                                    <input type="text" size="10" id="from" name="trange_f" />

                                    <label class="inline" for="trange_t">To: </label>

                                    <input size="10" id="to" name="trange_t" value="[% trange_t | html %]" type="text" />

                                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span>

                                </li>

                            </ol>

			</fieldset>

	            <input type="submit" value="Display" />

            </form>

            [% END %]

            [% END %]

    [% INCLUDE 'calendar.inc' %]

        var past_sales_table = $("#past_sales").dataTable($.extend(true, {}, dataTablesDefaults, {

            orderFixed: [ 0, 'asc'],

            columnDefs: [ {

                targets: [ 0, 1 ],

                visible: false

            }],

            rowGroup: {

                dataSrc: 0,

                startRender: function ( rows, group ) {

                    var details = JSON.parse(rows.data().pluck(1).pop());

                    return $('<tr class="'+details.type+'"/>')

                        .append( '<td>'+group+'</td>' )

                        .append( '<td colspan="2">'+details.description+'</td>' )

                        .append( '<td>'+details.amount+'</td>' )

                        .append( '<td><button class="printReceipt btn btn-default btn-xs" data-accountline="'+group+'"><i class="fa fa-print"></i> Print receipt</button></td>');

                },

                endRender: null,

            }

        }));

        $(document).ready(function() {

            // http://jqueryui.com/demos/datepicker/#date-range

            var dates = $( "#from, #to" ).datepicker({

                changeMonth: true,

                numberOfMonths: 1,

                onSelect: function( selectedDate ) {

                    var option = this.id == "from" ? "minDate" : "maxDate",

                        instance = $( this ).data( "datepicker" );

                        date = $.datepicker.parseDate(

                            instance.settings.dateFormat ||

                            $.datepicker._defaults.dateFormat,

                            selectedDate, instance.settings );

                    dates.not( this ).datepicker( "option", option, date );

                }

            });

        });

use Koha::Account::Lines;

use Koha::DateUtils;

    my $transactions_range_from = $input->param('trange_f');

    my $last_cashup             = $cash_register->last_cashup;

    my $transactions_range_to =

        $input->param('trange_t') ? $input->param('trange_t')

      : $last_cashup              ? $last_cashup->timestamp

      :                             '';

    $template->param( trange_t => $transactions_range_to );

    if ($transactions_range_from) {

        $template->param( trange_f => $transactions_range_from );

        my $dtf               = $schema->storage->datetime_parser;

        my $start             = dt_from_string($transactions_range_from);

        my $end               = dt_from_string($transactions_range_to);

        my $past_accountlines = Koha::Account::Lines->search(

            {

                register_id => $registerid,

                timestamp   => {

                    -between => [

                        $dtf->format_datetime($start),

                        $dtf->format_datetime($end)

                    ]

                }

            }

        );

        $template->param( past_accountlines => $past_accountlines );

    }