Attachment #92776 for bug #15219

View | Details | Raw Unified | Return to bug 15219
Collapse All | Expand All




    moremember:
      issues-table:
        -
          columnname: group_order
          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1

          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1
        -
          columnname: due_date_unformatted
          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1
        -
          columnname: due_date
        -

          columnname: location
        -
          columnname: homebranch
        -
          columnname: checkout_on_unformatted
          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1
        -
          columnname: checkout_on
        -

          columnname: export
          cannot_be_toggled: 1
          cannot_be_modified: 1
      relatives-issues-table:
        -
          columnname: due_date
        -
          columnname: title
        -
          columnname: item_type
        -
          columnname: location
        -
          columnname: checkout_on
        -
          columnname: checkout_from
        -
          columnname: callno
        -
          columnname: charge
        -
          columnname: fine
        -
          columnname: price
        -
          columnname: patron

    holdshistory:
      holdshistory-table:

    circulation:
      issues-table:
        -
          columnname: group_order
          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1

          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1
        -
          columnname: due_date_unformatted
          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1
        -
          columnname: due_date
        -

          columnname: location
        -
          columnname: homebranch
        -
          columnname: checkout_on_unformatted
          cannot_be_toggled: 1
          cannot_be_modified: 1
          is_hidden: 1
        -
          columnname: checkout_on
        -

          columnname: export
          cannot_be_toggled: 1
          cannot_be_modified: 1
      relatives-issues-table:
        -
          columnname: due_date
        -
          columnname: title
        -
          columnname: item_type
        -
          columnname: location
        -
          columnname: checkout_on
        -
          columnname: checkout_from
        -
          columnname: callno
        -
          columnname: charge
        -
          columnname: fine
        -
          columnname: price
        -
          columnname: patron
      table_borrowers:
        -
          columnname: name

        -
          columnname: phone
          is_hidden: 1

    returns:
      checkedintable:
        -

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_15219.sql (+2 lines)
	1	INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type)
	2	VALUES ('ServerSideCheckoutsTables','0',NULL,'If enabled, use the "server-side processing" feature for checkouts tables. Can improve performance when there is a big number of checkouts to display.','YesNo');

Lines 548-553 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
548	('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','free'),	548	('SendAllEmailsTo','',NULL,'All emails will be redirected to this email if it is not empty','free'),
549	('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),	549	('SeparateHoldings','0',NULL,'Separate current branch holdings from other holdings','YesNo'),
550	('SeparateHoldingsBranch','homebranch','homebranch\|holdingbranch','Branch used to separate holdings','Choice'),	550	('SeparateHoldingsBranch','homebranch','homebranch\|holdingbranch','Branch used to separate holdings','Choice'),
		551	('ServerSideCheckoutsTables','0',NULL,'If enabled, use the "server-side processing" feature for checkouts tables. Can improve performance when there is a big number of checkouts per patron.','YesNo'),
551	('SessionRestrictionByIP','1','Check for change in remote IP address for session security. Disable only when remote IP address changes frequently.','','YesNo'),	552	('SessionRestrictionByIP','1','Check for change in remote IP address for session security. Disable only when remote IP address changes frequently.','','YesNo'),
552	('SessionStorage','mysql','mysql\|Pg\|tmp','Use database or a temporary file for storing session data','Choice'),	553	('SessionStorage','mysql','mysql\|Pg\|tmp','Use database or a temporary file for storing session data','Choice'),
553	('ShelfBrowserUsesCcode','1','0','Use the item collection code when finding items for the shelf browser.','YesNo'),	554	('ShelfBrowserUsesCcode','1','0','Use the item collection code when finding items for the shelf browser.','YesNo'),





                      }

            oTable.fnSetColumnVis(properties.iGroupingColumnIndex, !properties.bHideGroupingColumn, false);
            if (properties.bCustomColumnOrdering) {
                oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex, !properties.bHideGroupingOrderByColumn, false);
            }
            if (properties.iGroupingColumnIndex2 != -1) {
                oTable.fnSetColumnVis(properties.iGroupingColumnIndex2, !properties.bHideGroupingColumn2, false);
            }
            if (properties.bCustomColumnOrdering2) {
                oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex2, !properties.bHideGroupingOrderByColumn2, false);
            }
            oTable.fnSettings().aoDrawCallback.push({
                "fn": _fnDrawCallBackWithGrouping,


        });
    };
})(jQuery);

Lines 1-6 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table-footer.inc (-1 / +1 lines)
1	<tfoot>	1	<tfoot>
2	<tr>	2	<tr>
3	<td colspan="13" style="text-align: right; font-weight:bold;">Totals:</td>	3	<td colspan="11" style="text-align: right; font-weight:bold;">Totals:</td>
4	<td id="totaldue" style="text-align: right;"></td>	4	<td id="totaldue" style="text-align: right;"></td>
5	<td id="totalfine" style="text-align: right;"></td>	5	<td id="totalfine" style="text-align: right;"></td>
6	<td id="totalprice" style="text-align: right;"></td>	6	<td id="totalprice" style="text-align: right;"></td>




                        <th scope="col">&nbsp;</th>
                        <th scope="col">&nbsp;</th>
                        <th scope="col">Due date</th>
                        <th scope="col">Due date</th>
                        <th scope="col">Title</th>
                        <th scope="col">Item type</th>
                        <th scope="col">Collection</th>
                        <th scope="col">Location</th>
                        <th scope="col">Home library</th>
                        <th scope="col">&nbsp;</th>
                        <th scope="col">Checked out on</th>
                        <th scope="col">Checked out from</th>
                        <th scope="col">Call no</th>




[% USE Asset %]
[% USE Koha %]
[% USE raw %]

<script>
  [% IF Koha.Preference('ServerSideCheckoutsTables') %]
    var ServerSideCheckoutsTables = true;
  [% ELSE %]
    var ServerSideCheckoutsTables = false;
  [% END %]
  var AllowCirculate = [% (CAN_user_circulate_circulate_remaining_permissions)? 1 : 0 | $raw %];
  var AllowRenewalLimitOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalLimitOverride'))? 1 : 0 | $raw %];
  var AllowRenewalOnHoldOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalOnHoldOverride') )? 1: 0 | $raw %];

  var MSG_DT_LOADING_RECORDS = _("Loading... you may continue scanning.");

  var borrowernumber = "[% borrowernumber | $raw %]";
  var relatives_borrowernumbers = new Array();
  [% FOREACH b IN relatives_borrowernumbers %]
    relatives_borrowernumbers.push("[% b | $raw %]");
  [% END %]

  var columns_settings_issues_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'issues-table', 'json' ) | $raw %];
  var relatives_columns_settings = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'relatives-issues-table', 'json' ) | $raw %];
</script>

[% Asset.js('js/checkouts.js') | $raw %]




        <table id="relatives-issues-table" style="width: 100% !Important;">
            <thead>
                <tr>
                    <th scope="col">Due date (unformatted, hidden)</th>
                    <th scope="col">Due date</th>
                    <th scope="col">Title</th>
                    <th scope="col">Item type</th>
                    <th scope="col">Collection code</th>
                    <th scope="col">Location</th>
                    <th scope="col">Checked out on (hidden, unformatted)</th>
                    <th scope="col">Checked out on</th>
                    <th scope="col">Checked out from</th>
                    <th scope="col">Call no</th>

Lines 46-49 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/strings.inc (+1 lines)
46	var CURRENT = _(" (current) ");	46	var CURRENT = _(" (current) ");
47	var MSG_NO_ITEMTYPE = _("No itemtype");	47	var MSG_NO_ITEMTYPE = _("No itemtype");
48	var MSG_CHECKOUTS_BY_ITEMTYPE = _("Number of checkouts by item type");	48	var MSG_CHECKOUTS_BY_ITEMTYPE = _("Number of checkouts by item type");
		49	var GROUP_TODAYS_CHECKOUTS = _("Group today's checkouts");
49	</script>	50	</script>

Lines 52-57 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (+6 lines)
52	asc: earliest to latest	52	asc: earliest to latest
53	desc: latest to earliest	53	desc: latest to earliest
54	- due date.	54	- due date.
		55	-
		56	- pref: ServerSideCheckoutsTables
		57	choices:
		58	yes: Enable
		59	no: Do not enable
		60	- server-side processing on checkouts tables. It can improve performance when there is a big number of checkouts to display.
55	-	61	-
56	- pref: SpecifyDueDate	62	- pref: SpecifyDueDate
57	choices:	63	choices:




    [% INCLUDE 'timepicker.inc' %]
    [% Asset.js("lib/jquery/plugins/jquery.dataTables.rowGrouping.js") | $raw %]
    [% Asset.js("js/pages/circulation.js") | $raw %]
    [% INCLUDE 'checkouts.js.inc' %]
    [% Asset.js("js/holds.js") | $raw %]
    [% Asset.js("js/circ-patron-search-results.js") | $raw %]
    <script type="text/javascript">
        /* Set some variable needed in circulation.js */
        var MSG_DT_LOADING_RECORDS = _("Loading... you may continue scanning.");
        var interface = "[% interface | html %]";
        var theme = "[% theme | html %]";
        var borrowernumber = "[% patron.borrowernumber | html %]";
        var branchcode = "[% branch | html %]";
        var exports_enabled = "[% Koha.Preference('ExportCircHistory') | html %]";
        var AllowRenewalLimitOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalLimitOverride') )? 1: 0 | html %];
        var AllowRenewalOnHoldOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalOnHoldOverride') )? 1: 0 | html %];
        var AllowCirculate = [% (CAN_user_circulate_circulate_remaining_permissions)? 1 : 0 | html %];
        var script = "circulation";
        var relatives_borrowernumbers = new Array();
        [% FOREACH b IN relatives_borrowernumbers %]
            relatives_borrowernumbers.push("[% b | html %]");
        [% END %]

        var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");
        var MSG_CONFIRM_DELETE_MESSAGE = _("Are you sure you want to delete this message? This cannot be undone.");

        columns_settings_issues_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'issues-table', 'json' ) | $raw %]
        columns_settings_borrowers_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'table_borrowers', 'json' ) | $raw %]

        [% IF borrowernumber and patron %]




    [% INCLUDE 'timepicker.inc' %]
    [% Asset.js("lib/jquery/plugins/jquery.dataTables.rowGrouping.js") | $raw %]
    [% Asset.js("js/pages/circulation.js") | $raw %]
    [% INCLUDE 'checkouts.js.inc' %]
    [% Asset.js("js/holds.js") | $raw %]
    [% INCLUDE 'str/members-menu.inc' %]
    [% Asset.js("js/members-menu.js") | $raw %]

        /* Set some variable needed in circulation.js */
        var interface = "[% interface | html %]";
        var theme = "[% theme | html %]";
        var borrowernumber = "[% patron.borrowernumber | html %]";
        var branchcode = "[% Branches.GetLoggedInBranchcode() | html %]";
        var exports_enabled = "[% Koha.Preference('ExportCircHistory') | html %]";
        var AllowCirculate = [% (CAN_user_circulate_circulate_remaining_permissions)? 1 : 0 | html %]
        var AllowRenewalLimitOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalLimitOverride') )? 1: 0 | html %];
        var AllowRenewalOnHoldOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalOnHoldOverride') )? 1: 0 | html %];
        var script = "moremember";
        var relatives_borrowernumbers = new Array();
        [% FOREACH b IN relatives_borrowernumbers %]
            relatives_borrowernumbers.push("[% b | html %]");
        [% END %]

        var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");
        var MSG_CONFIRM_DELETE_MESSAGE = _("Are you sure you want to delete this message? This cannot be undone.");

        columns_settings_issues_table = [% ColumnsSettings.GetColumns( 'members', 'moremember', 'issues-table', 'json' ) | $raw %]

        $(document).ready(function() {
            if ( $('#clubs-tab').length ) {
                $('#clubs-tab-link').on('click', function() {




(function($) {

var ymd = $.datepicker.formatDate('yy-mm-dd', new Date());

function enableGrouping(datatable) {
    datatable.rowGrouping({
        iGroupingColumnIndex: 1,
        iGroupingOrderByColumnIndex: 0,
        sGroupingColumnSortDirection: "desc"
    });
}

function disableGrouping(datatable) {
    var oSettings = datatable.fnSettings();
    for (f = 0; f < oSettings.aoDrawCallback.length; f++) {
        if (oSettings.aoDrawCallback[f].sName == 'fnRowGrouping') {
            oSettings.aoDrawCallback.splice(f, 1);
            oSettings.aaSortingFixed = null;
            datatable.fnDraw();
            break;
        }
    }
}

var mRenders = {
    groupOrder: function (oData, sType, oObj) {
        if ( oObj.issued_today ) {
            return "1";
        } else {
            return "0";
        }
    },
    groupName: function (oData, sType, oObj) {
        if (oObj.issued_today) {
            return "<strong>" + TODAYS_CHECKOUTS + "</strong>";
        } else {
            return "<strong>" + PREVIOUS_CHECKOUTS + "</strong>";
        }
    },
    dateDueFormatted: function (oData, sType, oObj) {
        var due = oObj.date_due_formatted;

        if ( oObj.date_due_overdue ) {
            due = "<span class='overdue'>" + due + "</span>";
        }

        due = "<span id='date_due_" + oObj.itemnumber + "' class='date_due'>" + due + "</span>";

        if ( oObj.lost ) {
            due += "<span class='lost'>" + oObj.lost.escapeHtml() + "</span>";
        }

        if ( oObj.damaged ) {
            due += "<span class='dmg'>" + oObj.damaged.escapeHtml() + "</span>";
        }

        return due;
    },
    title: function (oData, sType, oObj) {
        var title = "<span id='title_" + oObj.itemnumber + "' class='strong'><a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
              + oObj.biblionumber
              + "'>"
              + oObj.title.escapeHtml();

        $.each(oObj.subtitle, function( index, value ) {
                  title += " " + value.escapeHtml();
        });

        title += " " + oObj.part_number + " " + oObj.part_name;

        if ( oObj.enumchron ) {
            title += " (" + oObj.enumchron.escapeHtml() + ")";
        }

        title += "</a></span>";

        if ( oObj.author ) {
            title += " " + BY.replace( "_AUTHOR_",  " " + oObj.author.escapeHtml() );
        }

        if ( oObj.itemnotes ) {
            var span_class = "text-muted";
            if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                span_class = "circ-hlt";
            }
            title += " - <span class='" + span_class + " item-note-public'>" + oObj.itemnotes.escapeHtml() + "</span>";
        }

        if ( oObj.itemnotes_nonpublic ) {
            var span_class = "text-danger";
            if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                span_class = "circ-hlt";
            }
            title += " - <span class='" + span_class + " item-note-nonpublic'>" + oObj.itemnotes_nonpublic.escapeHtml() + "</span>";
        }

        var onsite_checkout = '';
        if ( oObj.onsite_checkout == 1 ) {
            onsite_checkout += " <span class='onsite_checkout'>(" + INHOUSE_USE + ")</span>";
        }

        title += " "
              + "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
              + oObj.biblionumber
              + "&itemnumber="
              + oObj.itemnumber
              + "#"
              + oObj.itemnumber
              + "'>"
              + oObj.barcode.escapeHtml()
              + "</a>"
              + onsite_checkout

        return title;
    },
    itemtype: function (oData, sType, oObj) {
        return oObj.itemtype_description.escapeHtml();
    },
    collection: function (oData, sType, oObj) {
        return oObj.collection ? oObj.collection.escapeHtml() : '';
    },
    location: function (oData, sType, oObj) {
        return oObj.location ? oObj.location.escapeHtml() : '';
    },
    homebranch: function (oData, sType, oObj) {
        return oObj.homebranch.escapeHtml();
    },
    issuedate: function (oData, sType, oObj) {
        return oObj.issuedate_formatted;
    },
    branch: function (oData, sType, oObj) {
        return oObj.branchname.escapeHtml();
    },
    itemcallnumber: function (oData, sType, oObj) {
        return oObj.itemcallnumber ? oObj.itemcallnumber.escapeHtml() : '';
    },
    charge: function (oData, sType, oObj) {
        if (!oObj.charge) oObj.charge = 0;
        return '<span style="text-align: right; display: block;">' + parseFloat(oObj.charge).toFixed(2) + '<span>';
    },
    fine: function (oData, sType, oObj) {
        if (!oObj.fine) oObj.fine = 0;
        return '<span style="text-align: right; display: block;">' + parseFloat(oObj.fine).toFixed(2)  + '<span>';
    },
    price: function (oData, sType, oObj) {
        if (!oObj.price) oObj.price = 0;
        return parseFloat(oObj.price).toFixed(2);
    },
    renew: function (oData, sType, oObj) {
        var content = "";
        var msg = "";
        var span_style = "";
        var span_class = "";

        if ( oObj.can_renew ) {
            // Do nothing
        } else if ( oObj.can_renew_error == "on_reserve" ) {
            msg += "<span>"
                    + "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + ON_HOLD + "</a>"
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed-on_reserve";
        } else if ( oObj.can_renew_error == "too_many" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "restriction" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_RESTRICTION
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "overdue" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_OVERDUE
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "too_soon" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_TOO_SOON.format( oObj.can_renew_date )
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "auto_too_soon" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_AUTO_TOO_SOON
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "auto_too_late" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_AUTO_TOO_LATE
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "auto_too_much_oweing" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_AUTO_TOO_MUCH_OWEING
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "auto_account_expired" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_AUTO_ACCOUNT_EXPIRED
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "auto_renew" ) {
            msg += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_AUTO_RENEW
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else if ( oObj.can_renew_error == "onsite_checkout" ) {
            // Don't display something if it's an onsite checkout
        } else if ( oObj.can_renew_error == "item_denied_renewal" ) {
            content += "<span class='renewals-disabled'>"
                    + NOT_RENEWABLE_DENIED
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        } else {
            msg += "<span class='renewals-disabled'>"
                    + oObj.can_renew_error
                    + "</span>";

            span_style = "display: none";
            span_class = "renewals-allowed";
        }

        var can_force_renew = ( oObj.onsite_checkout == 0 ) &&
            ( oObj.can_renew_error != "on_reserve" || (oObj.can_renew_error == "on_reserve" && AllowRenewalOnHoldOverride))
            ? true : false;
        var can_renew = ( oObj.renewals_remaining > 0  && !oObj.can_renew_error );
        content += '<span>';
        if ( can_renew || can_force_renew ) {
            content += "<span style='padding: 0 1em;'>" + oObj.renewals_count + "</span>";
            content += "<span class='" + span_class + "' style='" + span_style + "'>"
                    +  "<input type='checkbox' ";
            if ( oObj.date_due_overdue && can_renew ) {
                content += "checked='checked' ";
            }
            if (oObj.can_renew_error == "on_reserve") {
                content += "data-on-reserve ";
            }
            content += "class='renew' id='renew_" + oObj.itemnumber + "' name='renew' value='" + oObj.itemnumber +"'/>"
                    +  "</span>";
        }
        content += msg;
        if ( can_renew || can_force_renew ) {
            content += "<span class='renewals'>("
                    + RENEWALS_REMAINING.format( oObj.renewals_remaining, oObj.renewals_allowed )
                    + ")</span>";
        }

        content += "</span>";

        return content;
    },
    checkin: function (oData, sType, oObj) {
        if (oObj.can_renew_error == "on_reserve") {
            return "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + ON_HOLD + "</a>";
        } else {
            return "<input type='checkbox' class='checkin' id='checkin_" + oObj.itemnumber + "' name='checkin' value='" + oObj.itemnumber +"'></input>";
        }
    },
    export: function (oData, sType, oObj) {
        var s = "<input type='checkbox' name='itemnumbers' value='" + oObj.itemnumber + "' style='visibility:hidden;' />";

        s += "<input type='checkbox' class='export' id='export_" + oObj.biblionumber + "' name='biblionumbers' value='" + oObj.biblionumber + "' />";
        return s;
    },
    patron: function (oData, sType, oObj) {
        return "<a href='/cgi-bin/koha/members/moremember.pl?borrowernumber=" + oObj.borrowernumber + "'>"
             + oObj.borrower.firstname.escapeHtml()
             + " "
             + oObj.borrower.surname.escapeHtml()
             + " (" + oObj.borrower.cardnumber.escapeHtml() + ")</a>"
    }
};

$(document).ready(function() {
    $.ajaxSetup ({ cache: false });


        return false;
    });

    var ymd = $.datepicker.formatDate('yy-mm-dd', new Date());

    $('#issues-table').hide();
    $('#issues-table-actions').hide();
    $('#issues-table-load-immediately').change(function(){

                "sProcessing": MSG_DT_LOADING_RECORDS,
            },
            "bAutoWidth": false,
            "bProcessing": true,
            "bServerSide": ServerSideCheckoutsTables,
            "sAjaxSource": "/cgi-bin/koha/svc/checkouts",
            "fnServerParams": function (aoData) {
                aoData.push({ "name": "borrowernumber", "value": borrowernumber });
            },
            "fnInitComplete": function(oSettings, json) {
                // Build a summary of checkouts grouped by itemtype
                var checkoutsByItype = json.aaData.reduce(function (obj, row) {
                    obj[row.itemtype_description] = (obj[row.itemtype_description] || 0) + 1;
                    return obj;
                }, {});
                var ul = $('<ul>');
                Object.keys(checkoutsByItype).sort().forEach(function (itype) {
                    var li = $('<li>')
                        .append($('<strong>').html(itype || MSG_NO_ITEMTYPE))
                        .append(': ' + checkoutsByItype[itype]);
                    ul.append(li);
                })
                $('<details>')
                    .addClass('checkouts-by-itemtype')
                    .append($('<summary>').html(MSG_CHECKOUTS_BY_ITEMTYPE))
                    .append(ul)
                    .insertBefore(oSettings.nTableWrapper)
            },
            "bPaginate": true,
            "sPaginationType": "full",
            "dom": 'B<"clearfix"><"top pager"ilp>rt',
            "aaSorting": [],
            "aoColumns": [
                {
                    "mData": "issued_today",
                    "mRender": mRenders.groupOrder
                    }
                },
                {
                    "mData": function (oObj) {
                        if (oObj.issued_today) {
                            return "<strong>" + TODAYS_CHECKOUTS + "</strong>";
                        } else {
                            return "<strong>" + PREVIOUS_CHECKOUTS + "</strong>";

                    }
                },
                {
                    "mData": "date_due",
                    "mRender": mRenders.dateDueFormatted
                },
                {
                    "iDataSort": 2, // Sort on hidden unformatted date due column
                    "mDataProp": function( oObj ) {
                        var due = oObj.date_due_formatted;

                        if ( oObj.date_due_overdue ) {
                            due = "<span class='overdue'>" + due + "</span>";
                        }

                        due = "<span id='date_due_" + oObj.itemnumber + "' class='date_due'>" + due + "</span>";

                        if ( oObj.lost ) {
                            due += "<span class='lost'>" + oObj.lost.escapeHtml() + "</span>";
                        }

                        if ( oObj.damaged ) {
                            due += "<span class='dmg'>" + oObj.damaged.escapeHtml() + "</span>";
                        }

                        var patron_note = " <span class='patron_note_" + oObj.itemnumber + "'></span>";
                        due +="<br>" + patron_note;

                        return due;
                    }
                },
                {
                    "mDataProp": function ( oObj ) {
                        title = "<span id='title_" + oObj.itemnumber + "' class='strong'><a href='/cgi-bin/koha/catalogue/detail.pl?biblionumber="
                              + oObj.biblionumber
                              + "'>"
                              + oObj.title.escapeHtml();

                        $.each(oObj.subtitle, function( index, value ) {
                                  title += " " + value.escapeHtml();
                        });

                        title += " " + oObj.part_number + " " + oObj.part_name;

                        if ( oObj.enumchron ) {
                            title += " (" + oObj.enumchron.escapeHtml() + ")";
                        }

                        title += "</a></span>";

                        if ( oObj.author ) {
                            title += " " + BY.replace( "_AUTHOR_",  " " + oObj.author.escapeHtml() );
                        }

                        if ( oObj.itemnotes ) {
                            var span_class = "text-muted";
                            if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                                span_class = "circ-hlt";
                            }
                            title += " - <span class='" + span_class + " item-note-public'>" + oObj.itemnotes.escapeHtml() + "</span>";
                        }

                        if ( oObj.itemnotes_nonpublic ) {
                            var span_class = "text-danger";
                            if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                                span_class = "circ-hlt";
                            }
                            title += " - <span class='" + span_class + " item-note-nonpublic'>" + oObj.itemnotes_nonpublic.escapeHtml() + "</span>";
                        }

                        var onsite_checkout = '';
                        if ( oObj.onsite_checkout == 1 ) {
                            onsite_checkout += " <span class='onsite_checkout'>(" + INHOUSE_USE + ")</span>";
                        }

                        title += " "
                              + "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
                              + oObj.biblionumber
                              + "&itemnumber="
                              + oObj.itemnumber
                              + "#"
                              + oObj.itemnumber
                              + "'>"
                              + oObj.barcode.escapeHtml()
                              + "</a>"
                              + onsite_checkout

                        return title;
                    },
                    "sType": "anti-the"
                },
                {
                    "mData": "title",
                    "mRender": mRenders.title
                    }
                },
                {
                    "mData": "itemtype",
                    "mRender": mRenders.itemtype
                    }
                },
                {
                    "mData": "ccode",
                    "mRender": mRenders.collection
                    }
                },
                {
                    "mData": "location",
                    "mRender": mRenders.location
                    }
                },
                {
                    "mData": "homebranch",
                    "mRender": mRenders.homebranch
                },
                {
                    "mData": "issuedate",
                    "mRender": mRenders.issuedate
                },
                {
                    "mData": "branchcode",
                    "mRender": mRenders.branch
                    }
                },
                {
                    "mData": "itemcallnumber",
                    "mRender": mRender.itemcallnumber
                    }
                },
                {
                    "mData": "charge",
                    "mRender": mRenders.charge,
                    "bSortable": ServerSideCheckoutsTables ? false : true
                    }
                },
                {
                    "mData": "fine",
                    "mRender": mRenders.fine,
                    "bSortable": ServerSideCheckoutsTables ? false : true
                    }
                },
                {
                    "mData": "replacementprice",
                    "mRender": mRenders.price,
                    "bSortable": ServerSideCheckoutsTables ? false : true
                    }
                },
                {
                    "bSortable": false,
                    "bVisible": AllowCirculate ? true : false,
                    "mRender": mRenders.renew,
                    "bSortable": false
                        var msg = "";
                        var span_style = "";
                        var span_class = "";

                        if ( oObj.can_renew ) {
                            // Do nothing
                        } else if ( oObj.can_renew_error == "on_reserve" ) {
                            msg += "<span>"
                                    + "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + ON_HOLD + "</a>"
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed-on_reserve";
                        } else if ( oObj.can_renew_error == "too_many" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "restriction" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_RESTRICTION
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "overdue" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_OVERDUE
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "too_soon" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_TOO_SOON.format( oObj.can_renew_date )
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "auto_too_soon" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_AUTO_TOO_SOON
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "auto_too_late" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_AUTO_TOO_LATE
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "auto_too_much_oweing" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_AUTO_TOO_MUCH_OWEING
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "auto_account_expired" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_AUTO_ACCOUNT_EXPIRED
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "auto_renew" ) {
                            msg += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_AUTO_RENEW
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else if ( oObj.can_renew_error == "onsite_checkout" ) {
                            // Don't display something if it's an onsite checkout
                        } else if ( oObj.can_renew_error == "item_denied_renewal" ) {
                            content += "<span class='renewals-disabled'>"
                                    + NOT_RENEWABLE_DENIED
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        } else {
                            msg += "<span class='renewals-disabled'>"
                                    + oObj.can_renew_error
                                    + "</span>";

                            span_style = "display: none";
                            span_class = "renewals-allowed";
                        }

                        var can_force_renew = ( oObj.onsite_checkout == 0 ) &&
                            ( oObj.can_renew_error != "on_reserve" || (oObj.can_renew_error == "on_reserve" && AllowRenewalOnHoldOverride))
                            ? true : false;
                        var can_renew = ( oObj.renewals_remaining > 0  && !oObj.can_renew_error );
                        content += "<span>";
                        if ( can_renew || can_force_renew ) {
                            content += "<span style='padding: 0 1em;'>" + oObj.renewals_count + "</span>";
                            content += "<span class='" + span_class + "' style='" + span_style + "'>"
                                    +  "<input type='checkbox' ";
                            if ( oObj.date_due_overdue && can_renew ) {
                                content += "checked='checked' ";
                            }
                            if (oObj.can_renew_error == "on_reserve") {
                                content += "data-on-reserve ";
                            }
                            content += "class='renew' id='renew_" + oObj.itemnumber + "' name='renew' value='" + oObj.itemnumber +"'/>"
                                    +  "</span>";
                        }
                        content += msg;
                        if ( can_renew || can_force_renew ) {
                            content += "<span class='renewals'>("
                                    + RENEWALS_REMAINING.format( oObj.renewals_remaining, oObj.renewals_allowed )
                                    + ")</span>";
                        }

                        content += "</span>";

                        return content;
                    }
                },
                {
                    "bSortable": false,
                    "bVisible": AllowCirculate ? true : false,
                    "mRender": mRenders.checkin,
                    "bSortable": false
                            return "<a href='/cgi-bin/koha/reserve/request.pl?biblionumber=" + oObj.biblionumber + "'>" + ON_HOLD + "</a>";
                        } else {
                            return "<input type='checkbox' class='checkin' id='checkin_" + oObj.itemnumber + "' name='checkin' value='" + oObj.itemnumber +"'></input>";
                        }
                    }
                },
                {
                    "bVisible": exports_enabled == 1 ? true : false,
                    "bSortable": false,
                    "mRender": mRenders.export
                        var s = "<input type='checkbox' name='itemnumbers' value='" + oObj.itemnumber + "' style='visibility:hidden;' />";

                        s += "<input type='checkbox' class='export' id='export_" + oObj.biblionumber + "' name='biblionumbers' value='" + oObj.biblionumber + "' />";
                        return s;
                    }
                }
            ],
            "fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) {

                $("#totaldue").html(total_charge.toFixed(2));
                $("#totalfine").html(total_fine.toFixed(2));
                $("#totalprice").html(total_price.toFixed(2));
            },
            "bPaginate": false,
            "bProcessing": true,
            "bServerSide": false,
            "sAjaxSource": '/cgi-bin/koha/svc/checkouts',
            "fnServerData": function ( sSource, aoData, fnCallback ) {
                aoData.push( { "name": "borrowernumber", "value": borrowernumber } );

                $.getJSON( sSource, aoData, function (json) {
                    fnCallback(json)
                } );
            },
            "fnInitComplete": function(oSettings, json) {
                // Disable rowGrouping plugin after first use
                // so any sorting on the table doesn't use it
                var oSettings = issuesTable.fnSettings();

                for (f = 0; f < oSettings.aoDrawCallback.length; f++) {
                    if (oSettings.aoDrawCallback[f].sName == 'fnRowGrouping') {
                        oSettings.aoDrawCallback.splice(f, 1);
                        break;
                    }
                }

                oSettings.aaSortingFixed = null;

                // Build a summary of checkouts grouped by itemtype
                var checkoutsByItype = json.aaData.reduce(function (obj, row) {
                    obj[row.itemtype_description] = (obj[row.itemtype_description] || 0) + 1;
                    return obj;
                }, {});
                var ul = $('<ul>');
                Object.keys(checkoutsByItype).sort().forEach(function (itype) {
                    var li = $('<li>')
                        .append($('<strong>').html(itype || MSG_NO_ITEMTYPE))
                        .append(': ' + checkoutsByItype[itype]);
                    ul.append(li);
                })
                $('<details>')
                    .addClass('checkouts-by-itemtype')
                    .append($('<summary>').html(MSG_CHECKOUTS_BY_ITEMTYPE))
                    .append(ul)
                    .insertBefore(oSettings.nTableWrapper)
            },
        }, columns_settings_issues_table).rowGrouping(
            {
                iGroupingColumnIndex: 1,
                iGroupingOrderByColumnIndex: 0,
                sGroupingColumnSortDirection: "asc"
            }
        }, columns_settings_issues_table);

        enableGrouping(issuesTable);

        var groupingSwitch = $('<input type="checkbox">')
          .attr('id', 'issues-table-row-grouping-switch')
          .attr('checked', 'checked')
          .css('vertical-align', 'middle')
          .change(function() {
              if ($(this).is(':checked')) {
                  enableGrouping(issuesTable);
              } else {
                  disableGrouping(issuesTable);
              }
          });
        $('<div></div>')
          .css('float', 'left')
          .css('padding', '0.3em 0.5em')
          .css('line-height', '1.9em')
          .append(groupingSwitch)
          .append('&nbsp;')
          .append('<label for="issues-table-row-grouping-switch">' + GROUP_TODAYS_CHECKOUTS + '</label>')
          .appendTo('#issues-table_wrapper .top.pager');

        if ( $("#issues-table").length ) {
            $("#issues-table_processing").position({

    var relativesIssuesTable;
    $("#relatives-issues-tab").click( function() {
        if ( ! relativesIssuesTable ) {
            relativesIssuesTable = KohaTable("#relatives-issues-table", {
                "bAutoWidth": false,
                "sDom": 'C<"top pager"ilp>rt',
                "aaSorting": [[4, "desc"]],
                "bProcessing": true,
                "bServerSide": ServerSideCheckoutsTables,
                "sAjaxSource": "/cgi-bin/koha/svc/checkouts",
                "fnServerParams": function (aoData) {
                    for (i in relatives_borrowernumbers) {
                        var borrowernumber = relatives_borrowernumbers[i];
                        aoData.push({ "name": "borrowernumber", "value": borrowernumber });
                    }
                },
                "bPaginate": true,
                "sPaginationType": "full",
                "aoColumns": [
                    {
                        "mData": "date_due",
                        "mRender": mRenders.dateDueFormatted
                    },
                    {
                        "mData": "title",
                        "mRender": mRenders.title,
                            var today = new Date();
                            var due = new Date( oObj.date_due );
                            if ( today > due ) {
                                return "<span class='overdue'>" + oObj.date_due_formatted + "</span>";
                            } else {
                                return oObj.date_due_formatted;
                            }
                        }
                    },
                    {
                        "mData": "itemtype",
                        "mRender": mRenders.itemtype
                                  + oObj.biblionumber
                                  + "'>"
                                  + oObj.title.escapeHtml();

                            $.each(oObj.subtitle, function( index, value ) {
                                      title += " " + value.escapeHtml();
                            });

                            title += " " + oObj.part_number + " " + oObj.part_name;

                            if ( oObj.enumchron ) {
                                title += " (" + oObj.enumchron.escapeHtml() + ")";
                            }

                            title += "</a></span>";

                            if ( oObj.author ) {
                                title += " " + BY.replace( "_AUTHOR_", " " + oObj.author.escapeHtml() );
                            }

                            if ( oObj.itemnotes ) {
                                var span_class = "";
                                if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                                    span_class = "circ-hlt";
                                }
                                title += " - <span class='" + span_class + "'>" + oObj.itemnotes.escapeHtml() + "</span>"
                            }

                            if ( oObj.itemnotes_nonpublic ) {
                                var span_class = "";
                                if ( $.datepicker.formatDate('yy-mm-dd', new Date(oObj.issuedate) ) == ymd ) {
                                    span_class = "circ-hlt";
                                }
                                title += " - <span class='" + span_class + "'>" + oObj.itemnotes_nonpublic.escapeHtml() + "</span>"
                            }

                            var onsite_checkout = '';
                            if ( oObj.onsite_checkout == 1 ) {
                                onsite_checkout += " <span class='onsite_checkout'>(" + INHOUSE_USE + ")</span>";
                            }

                            title += " "
                                  + "<a href='/cgi-bin/koha/catalogue/moredetail.pl?biblionumber="
                                  + oObj.biblionumber
                                  + "&itemnumber="
                                  + oObj.itemnumber
                                  + "#"
                                  + oObj.itemnumber
                                  + "'>"
                                  + oObj.barcode.escapeHtml()
                                  + "</a>"
                                  + onsite_checkout;

                            return title;
                        },
                        "sType": "anti-the"
                    },
                    {
                        "mData": "ccode",
                        "mRender": mRenders.collection
                        }
                    },
                    {
                        "mData": "location",
                        "mRender": mRenders.location
                        }
                    },
                    {
                        "mData": "issuedate",
                        "mRender": mRenders.issuedate
                        }
                    },
                    {
                        "mData": "branchcode",
                        "mRender": mRenders.branch
                    },
                    {
                        "iDataSort": 7, // Sort on hidden unformatted issuedate column
                        "mDataProp": "issuedate_formatted",
                    },
                    {
                        "mDataProp": function ( oObj ) {
                            return oObj.branchname.escapeHtml();
                        }
                    },
                    {
                        "mData": "itemcallnumber",
                        "mRender": mRenders.itemcallnumber
                        }
                    },
                    {
                        "mData": "charge",
                        "mRender": mRenders.charge,
                        "bSortable": ServerSideCheckoutsTables ? false : true
                        }
                    },
                    {
                        "mData": "fine",
                        "mRender": mRenders.fine,
                        "bSortable": ServerSideCheckoutsTables ? false : true
                        }
                    },
                    {
                        "mData": "replacementprice",
                        "mRender": mRenders.price,
                        "bSortable": ServerSideCheckoutsTables ? false : true
                        }
                    },
                    {
                        "mData": "borrowernumber",
                        "mRender": mRenders.patron,
                        "bSortable": ServerSideCheckoutsTables ? false : true
                    }
                ]
            }, relatives_columns_settings);
                        }
                    },
                ],
                "bPaginate": false,
                "bProcessing": true,
                "bServerSide": false,
                "sAjaxSource": '/cgi-bin/koha/svc/checkouts',
                "fnServerData": function ( sSource, aoData, fnCallback ) {
                    $.each(relatives_borrowernumbers, function( index, value ) {
                        aoData.push( { "name": "borrowernumber", "value": value } );
                    });

                    $.getJSON( sSource, aoData, function (json) {
                        fnCallback(json)
                    } );
                },
            });
        }
    });


            }
        } ).prop('checked', false);
    }
});

})(jQuery);




use C4::Circulation qw(GetIssuingCharges CanBookBeRenewed GetRenewCount GetSoonestRenewDate);
use C4::Overdues qw(GetFine);
use C4::Context;
use C4::Utils::DataTables;

use Koha::AuthorisedValues;
use Koha::DateUtils;

    exit 0;
}

my @sort_columns = qw/date_due title itype issuedate branchcode itemcallnumber/;

my @borrowernumber   = $input->multi_param('borrowernumber');
my $offset = $input->param('iDisplayStart');
my $count = $input->param('iDisplayLength');

my %params = dt_get_params($input);
my $orderby = dt_build_orderby(\%params);

my $todaysIssuesDefaultSortOrder =
  C4::Context->preference('todaysIssuesDefaultSortOrder');
my $previousIssuesDefaultSortOrder =
  C4::Context->preference('previousIssuesDefaultSortOrder');

# Default sort when user hasn't clicked on a column header yet.
# When row grouping is enabled, DataTables ask to sort on issued_today column,
# so we need to treat this case the same as the "no sorting" case
if (!$orderby || $orderby =~ m/ORDER BY issued_today desc\s*$/) {
    $orderby = qq{
        ORDER BY
        issued_today DESC,
        CASE WHEN issued_today = 0 THEN date_due END $previousIssuesDefaultSortOrder,
        CASE WHEN issued_today != 0 THEN date_due END $todaysIssuesDefaultSortOrder
    };
}

my @parameters;
my $sql = '
    SELECT SQL_CALC_FOUND_ROWS
        issuedate,
        date_due,
        date_due < now() as date_due_overdue,

        location,
        items.enumchron,

        DATEDIFF( issuedate, CURRENT_DATE() ) = 0 AS issued_today
    FROM issues
        LEFT JOIN items USING ( itemnumber )
        LEFT JOIN biblio USING ( biblionumber )

        LEFT JOIN borrowers USING ( borrowernumber )
        LEFT JOIN branches ON ( issues.branchcode = branches.branchcode )
        LEFT JOIN branches branches2 ON ( items.homebranch = branches2.branchcode )
    WHERE
';

my $borrowernumber_sql = 'borrowernumber';
if ( @borrowernumber == 1 ) {
    $borrowernumber_sql .= ' = ?';
} else {
    $borrowernumber_sql .= ' IN (' . join( ',', ('?') x @borrowernumber ) . ') ';
    $sql .= ' IN (' . join( ',', ('?') x @borrowernumber ) . ') ';
}
$sql .= $borrowernumber_sql;
push( @parameters, @borrowernumber );

$sql .= " $orderby";

if ($count && $count > 0) {
    $sql .= " LIMIT ?,?";
    push @parameters, $offset, $count;
}

my $dbh = C4::Context->dbh();
my $sth = $dbh->prepare($sql);
$sth->execute(@parameters);
my ($iTotalDisplayRecords) = $dbh->selectrow_array('SELECT FOUND_ROWS()');

my $item_level_itypes = C4::Context->preference('item-level_itypes');

my @checkouts;
my @checkouts_previous;
while ( my $c = $sth->fetchrow_hashref() ) {
    my ($charge) = GetIssuingCharges( $c->{itemnumber}, $c->{borrowernumber} );
    my $fine = GetFine( $c->{itemnumber}, $c->{borrowernumber} );

            firstname  => $c->{firstname},
            cardnumber => $c->{cardnumber},
        },
        issued_today => $c->{issued_today} ? JSON::true : JSON::false,
    };

    push @checkouts, $checkout;
        push( @checkouts_previous, $checkout );
    }
    else {
        push( @checkouts_today, $checkout );
    }
}

binmode STDOUT, ":encoding(UTF-8)";
print $input->header( -type => 'application/json', -charset => 'UTF-8' );

my $sEcho = $input->param('sEcho');
my ($iTotalRecords) = $dbh->selectrow_array(
    "SELECT COUNT(*) FROM issues WHERE $borrowernumber_sql", undef,
    @borrowernumber);
@checkouts_previous = sort { $a->{date_due} cmp $b->{date_due} } @checkouts_previous;
@checkouts_previous = reverse(@checkouts_previous)
  if ( C4::Context->preference('previousIssuesDefaultSortOrder') eq 'desc' );

my @checkouts = ( @checkouts_today, @checkouts_previous );

my $i = 1;
map { $_->{sort_order} = $i++ } @checkouts;


my $response = {
    iTotalRecords => $iTotalRecords,
    iTotalDisplayRecords => $iTotalDisplayRecords,
    sEcho => $sEcho,
    aaData => \@checkouts,
};

print to_json($response);
- 

Return to bug 15219

Lines 531-537 modules: Link Here

(-)a/admin/columns_settings.yml (-22 / +49 lines)
531	moremember:	531	moremember:
532	issues-table:	532	issues-table:
533	-	533	-
534	columnname: sort_order	534	columnname: group_order
535	cannot_be_toggled: 1	535	cannot_be_toggled: 1
536	cannot_be_modified: 1	536	cannot_be_modified: 1
537	is_hidden: 1	537	is_hidden: 1
Lines 540-550 modules: Link Here
540	cannot_be_toggled: 1	540	cannot_be_toggled: 1
541	cannot_be_modified: 1	541	cannot_be_modified: 1
542	is_hidden: 1	542	is_hidden: 1
543	-
544	columnname: due_date_unformatted
545	cannot_be_toggled: 1
546	cannot_be_modified: 1
547	is_hidden: 1
548	-	543	-
549	columnname: due_date	544	columnname: due_date
550	-	545	-
Lines 557-567 modules: Link Here
557	columnname: location	552	columnname: location
558	-	553	-
559	columnname: homebranch	554	columnname: homebranch
560	-
561	columnname: checkout_on_unformatted
562	cannot_be_toggled: 1
563	cannot_be_modified: 1
564	is_hidden: 1
565	-	555	-
566	columnname: checkout_on	556	columnname: checkout_on
567	-	557	-
Lines 584-589 modules: Link Here
584	columnname: export	574	columnname: export
585	cannot_be_toggled: 1	575	cannot_be_toggled: 1
586	cannot_be_modified: 1	576	cannot_be_modified: 1
		577	relatives-issues-table:
		578	-
		579	columnname: due_date
		580	-
		581	columnname: title
		582	-
		583	columnname: item_type
		584	-
		585	columnname: location
		586	-
		587	columnname: checkout_on
		588	-
		589	columnname: checkout_from
		590	-
		591	columnname: callno
		592	-
		593	columnname: charge
		594	-
		595	columnname: fine
		596	-
		597	columnname: price
		598	-
		599	columnname: patron
587		600
588	holdshistory:	601	holdshistory:
589	holdshistory-table:	602	holdshistory-table:
Lines 744-750 modules: Link Here
744	circulation:	757	circulation:
745	issues-table:	758	issues-table:
746	-	759	-
747	columnname: sort_order	760	columnname: group_order
748	cannot_be_toggled: 1	761	cannot_be_toggled: 1
749	cannot_be_modified: 1	762	cannot_be_modified: 1
750	is_hidden: 1	763	is_hidden: 1
Lines 753-763 modules: Link Here
753	cannot_be_toggled: 1	766	cannot_be_toggled: 1
754	cannot_be_modified: 1	767	cannot_be_modified: 1
755	is_hidden: 1	768	is_hidden: 1
756	-
757	columnname: due_date_unformatted
758	cannot_be_toggled: 1
759	cannot_be_modified: 1
760	is_hidden: 1
761	-	769	-
762	columnname: due_date	770	columnname: due_date
763	-	771	-
Lines 770-780 modules: Link Here
770	columnname: location	778	columnname: location
771	-	779	-
772	columnname: homebranch	780	columnname: homebranch
773	-
774	columnname: checkout_on_unformatted
775	cannot_be_toggled: 1
776	cannot_be_modified: 1
777	is_hidden: 1
778	-	781	-
779	columnname: checkout_on	782	columnname: checkout_on
780	-	783	-
Lines 797-802 modules: Link Here
797	columnname: export	800	columnname: export
798	cannot_be_toggled: 1	801	cannot_be_toggled: 1
799	cannot_be_modified: 1	802	cannot_be_modified: 1
		803	relatives-issues-table:
		804	-
		805	columnname: due_date
		806	-
		807	columnname: title
		808	-
		809	columnname: item_type
		810	-
		811	columnname: location
		812	-
		813	columnname: checkout_on
		814	-
		815	columnname: checkout_from
		816	-
		817	columnname: callno
		818	-
		819	columnname: charge
		820	-
		821	columnname: fine
		822	-
		823	columnname: price
		824	-
		825	columnname: patron
800	table_borrowers:	826	table_borrowers:
801	-	827	-
802	columnname: name	828	columnname: name
Lines 815-820 modules: Link Here
815	-	841	-
816	columnname: phone	842	columnname: phone
817	is_hidden: 1	843	is_hidden: 1
		844
818	returns:	845	returns:
819	checkedintable:	846	checkedintable:
820	-	847	-

Lines 608-622 Link Here

(-)a/koha-tmpl/intranet-tmpl/lib/jquery/plugins/jquery.dataTables.rowGrouping.js (-5 / +5 lines)
608		608
609	}	609	}
610		610
611	oTable.fnSetColumnVis(properties.iGroupingColumnIndex, !properties.bHideGroupingColumn);	611	oTable.fnSetColumnVis(properties.iGroupingColumnIndex, !properties.bHideGroupingColumn, false);
612	if (properties.bCustomColumnOrdering) {	612	if (properties.bCustomColumnOrdering) {
613	oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex, !properties.bHideGroupingOrderByColumn);	613	oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex, !properties.bHideGroupingOrderByColumn, false);
614	}	614	}
615	if (properties.iGroupingColumnIndex2 != -1) {	615	if (properties.iGroupingColumnIndex2 != -1) {
616	oTable.fnSetColumnVis(properties.iGroupingColumnIndex2, !properties.bHideGroupingColumn2);	616	oTable.fnSetColumnVis(properties.iGroupingColumnIndex2, !properties.bHideGroupingColumn2, false);
617	}	617	}
618	if (properties.bCustomColumnOrdering2) {	618	if (properties.bCustomColumnOrdering2) {
619	oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex2, !properties.bHideGroupingOrderByColumn2);	619	oTable.fnSetColumnVis(properties.iGroupingOrderByColumnIndex2, !properties.bHideGroupingOrderByColumn2, false);
620	}	620	}
621	oTable.fnSettings().aoDrawCallback.push({	621	oTable.fnSettings().aoDrawCallback.push({
622	"fn": _fnDrawCallBackWithGrouping,	622	"fn": _fnDrawCallBackWithGrouping,
Lines 687-690 Link Here
687		687
688	});	688	});
689	};	689	};
690	})(jQuery);	690	})(jQuery);

Lines 986-1015 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt (-11 / +1 lines)
986	[% INCLUDE 'timepicker.inc' %]	986	[% INCLUDE 'timepicker.inc' %]
987	[% Asset.js("lib/jquery/plugins/jquery.dataTables.rowGrouping.js") \| $raw %]	987	[% Asset.js("lib/jquery/plugins/jquery.dataTables.rowGrouping.js") \| $raw %]
988	[% Asset.js("js/pages/circulation.js") \| $raw %]	988	[% Asset.js("js/pages/circulation.js") \| $raw %]
989	[% Asset.js("js/checkouts.js") \| $raw %]	989	[% INCLUDE 'checkouts.js.inc' %]
990	[% Asset.js("js/holds.js") \| $raw %]	990	[% Asset.js("js/holds.js") \| $raw %]
991	[% Asset.js("js/circ-patron-search-results.js") \| $raw %]	991	[% Asset.js("js/circ-patron-search-results.js") \| $raw %]
992	<script type="text/javascript">	992	<script type="text/javascript">
993	/* Set some variable needed in circulation.js */	993	/* Set some variable needed in circulation.js */
994	var MSG_DT_LOADING_RECORDS = _("Loading... you may continue scanning.");
995	var interface = "[% interface \| html %]";	994	var interface = "[% interface \| html %]";
996	var theme = "[% theme \| html %]";	995	var theme = "[% theme \| html %]";
997	var borrowernumber = "[% patron.borrowernumber \| html %]";
998	var branchcode = "[% branch \| html %]";	996	var branchcode = "[% branch \| html %]";
999	var exports_enabled = "[% Koha.Preference('ExportCircHistory') \| html %]";	997	var exports_enabled = "[% Koha.Preference('ExportCircHistory') \| html %]";
1000	var AllowRenewalLimitOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalLimitOverride') )? 1: 0 \| html %];
1001	var AllowRenewalOnHoldOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalOnHoldOverride') )? 1: 0 \| html %];
1002	var AllowCirculate = [% (CAN_user_circulate_circulate_remaining_permissions)? 1 : 0 \| html %];
1003	var script = "circulation";	998	var script = "circulation";
1004	var relatives_borrowernumbers = new Array();
1005	[% FOREACH b IN relatives_borrowernumbers %]
1006	relatives_borrowernumbers.push("[% b \| html %]");
1007	[% END %]
1008		999
1009	var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");	1000	var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");
1010	var MSG_CONFIRM_DELETE_MESSAGE = _("Are you sure you want to delete this message? This cannot be undone.");	1001	var MSG_CONFIRM_DELETE_MESSAGE = _("Are you sure you want to delete this message? This cannot be undone.");
1011		1002
1012	columns_settings_issues_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'issues-table', 'json' ) \| $raw %]
1013	columns_settings_borrowers_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'table_borrowers', 'json' ) \| $raw %]	1003	columns_settings_borrowers_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'table_borrowers', 'json' ) \| $raw %]
1014		1004
1015	[% IF borrowernumber and patron %]	1005	[% IF borrowernumber and patron %]

Lines 840-846 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/members/moremember.tt (-11 / +1 lines)
840	[% INCLUDE 'timepicker.inc' %]	840	[% INCLUDE 'timepicker.inc' %]
841	[% Asset.js("lib/jquery/plugins/jquery.dataTables.rowGrouping.js") \| $raw %]	841	[% Asset.js("lib/jquery/plugins/jquery.dataTables.rowGrouping.js") \| $raw %]
842	[% Asset.js("js/pages/circulation.js") \| $raw %]	842	[% Asset.js("js/pages/circulation.js") \| $raw %]
843	[% Asset.js("js/checkouts.js") \| $raw %]	843	[% INCLUDE 'checkouts.js.inc' %]
844	[% Asset.js("js/holds.js") \| $raw %]	844	[% Asset.js("js/holds.js") \| $raw %]
845	[% INCLUDE 'str/members-menu.inc' %]	845	[% INCLUDE 'str/members-menu.inc' %]
846	[% Asset.js("js/members-menu.js") \| $raw %]	846	[% Asset.js("js/members-menu.js") \| $raw %]
Lines 849-871 Link Here
849	/* Set some variable needed in circulation.js */	849	/* Set some variable needed in circulation.js */
850	var interface = "[% interface \| html %]";	850	var interface = "[% interface \| html %]";
851	var theme = "[% theme \| html %]";	851	var theme = "[% theme \| html %]";
852	var borrowernumber = "[% patron.borrowernumber \| html %]";
853	var branchcode = "[% Branches.GetLoggedInBranchcode() \| html %]";	852	var branchcode = "[% Branches.GetLoggedInBranchcode() \| html %]";
854	var exports_enabled = "[% Koha.Preference('ExportCircHistory') \| html %]";	853	var exports_enabled = "[% Koha.Preference('ExportCircHistory') \| html %]";
855	var AllowCirculate = [% (CAN_user_circulate_circulate_remaining_permissions)? 1 : 0 \| html %]
856	var AllowRenewalLimitOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalLimitOverride') )? 1: 0 \| html %];
857	var AllowRenewalOnHoldOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalOnHoldOverride') )? 1: 0 \| html %];
858	var script = "moremember";	854	var script = "moremember";
859	var relatives_borrowernumbers = new Array();
860	[% FOREACH b IN relatives_borrowernumbers %]
861	relatives_borrowernumbers.push("[% b \| html %]");
862	[% END %]
863		855
864	var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");	856	var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");
865	var MSG_CONFIRM_DELETE_MESSAGE = _("Are you sure you want to delete this message? This cannot be undone.");	857	var MSG_CONFIRM_DELETE_MESSAGE = _("Are you sure you want to delete this message? This cannot be undone.");
866		858
867	columns_settings_issues_table = [% ColumnsSettings.GetColumns( 'members', 'moremember', 'issues-table', 'json' ) \| $raw %]
868
869	$(document).ready(function() {	859	$(document).ready(function() {
870	if ( $('#clubs-tab').length ) {	860	if ( $('#clubs-tab').length ) {
871	$('#clubs-tab-link').on('click', function() {	861	$('#clubs-tab-link').on('click', function() {

Lines 26-31 use C4::Auth qw(check_cookie_auth haspermission get_session); Link Here

(-)a/svc/checkouts (-52 / +54 lines)
26	use C4::Circulation qw(GetIssuingCharges CanBookBeRenewed GetRenewCount GetSoonestRenewDate);	26	use C4::Circulation qw(GetIssuingCharges CanBookBeRenewed GetRenewCount GetSoonestRenewDate);
27	use C4::Overdues qw(GetFine);	27	use C4::Overdues qw(GetFine);
28	use C4::Context;	28	use C4::Context;
		29	use C4::Utils::DataTables;
29		30
30	use Koha::AuthorisedValues;	31	use Koha::AuthorisedValues;
31	use Koha::DateUtils;	32	use Koha::DateUtils;
Lines 44-69 unless (haspermission($userid, { circulate => 'circulate_remaining_permissions' Link Here
44	exit 0;	45	exit 0;
45	}	46	}
46		47
47	my @sort_columns = qw/date_due title itype issuedate branchcode itemcallnumber/;
48
49	my @borrowernumber = $input->multi_param('borrowernumber');	48	my @borrowernumber = $input->multi_param('borrowernumber');
50	my $offset = $input->param('iDisplayStart');	49	my $offset = $input->param('iDisplayStart');
51	my $results_per_page = $input->param('iDisplayLength') \|\| -1;	50	my $count = $input->param('iDisplayLength');
52		51
53	my $sorting_column = $input->param('iSortCol_0') \|\| q{};	52	my %params = dt_get_params($input);
54	$sorting_column = ( $sorting_column && $sort_columns[$sorting_column] ) ? $sort_columns[$sorting_column] : 'issuedate';	53	my $orderby = dt_build_orderby(\%params);
55		54
56	my $sorting_direction = $input->param('sSortDir_0') \|\| q{};	55	my $todaysIssuesDefaultSortOrder =
57	$sorting_direction = $sorting_direction eq 'asc' ? 'asc' : 'desc';	56	C4::Context->preference('todaysIssuesDefaultSortOrder');
58		57	my $previousIssuesDefaultSortOrder =
59	$results_per_page = undef if ( $results_per_page == -1 );	58	C4::Context->preference('previousIssuesDefaultSortOrder');
60		59
61	binmode STDOUT, ":encoding(UTF-8)";	60	# Default sort when user hasn't clicked on a column header yet.
62	print $input->header( -type => 'text/plain', -charset => 'UTF-8' );	61	# When row grouping is enabled, DataTables ask to sort on issued_today column,
		62	# so we need to treat this case the same as the "no sorting" case
		63	if (!$orderby \|\| $orderby =~ m/ORDER BY issued_today desc\s*$/) {
		64	$orderby = qq{
		65	ORDER BY
		66	issued_today DESC,
		67	CASE WHEN issued_today = 0 THEN date_due END $previousIssuesDefaultSortOrder,
		68	CASE WHEN issued_today != 0 THEN date_due END $todaysIssuesDefaultSortOrder
		69	};
		70	}
63		71
64	my @parameters;	72	my @parameters;
65	my $sql = '	73	my $sql = '
66	SELECT	74	SELECT SQL_CALC_FOUND_ROWS
67	issuedate,	75	issuedate,
68	date_due,	76	date_due,
69	date_due < now() as date_due_overdue,	77	date_due < now() as date_due_overdue,
Lines 105-111 my $sql = ' Link Here
105	location,	113	location,
106	items.enumchron,	114	items.enumchron,
107		115
108	DATEDIFF( issuedate, CURRENT_DATE() ) AS not_issued_today	116	DATEDIFF( issuedate, CURRENT_DATE() ) = 0 AS issued_today
109	FROM issues	117	FROM issues
110	LEFT JOIN items USING ( itemnumber )	118	LEFT JOIN items USING ( itemnumber )
111	LEFT JOIN biblio USING ( biblionumber )	119	LEFT JOIN biblio USING ( biblionumber )
Lines 113-139 my $sql = ' Link Here
113	LEFT JOIN borrowers USING ( borrowernumber )	121	LEFT JOIN borrowers USING ( borrowernumber )
114	LEFT JOIN branches ON ( issues.branchcode = branches.branchcode )	122	LEFT JOIN branches ON ( issues.branchcode = branches.branchcode )
115	LEFT JOIN branches branches2 ON ( items.homebranch = branches2.branchcode )	123	LEFT JOIN branches branches2 ON ( items.homebranch = branches2.branchcode )
116	WHERE borrowernumber	124	WHERE
117	';	125	';
118		126
		127	my $borrowernumber_sql = 'borrowernumber';
119	if ( @borrowernumber == 1 ) {	128	if ( @borrowernumber == 1 ) {
120	$sql .= '= ?';	129	$borrowernumber_sql .= ' = ?';
121	}	130	} else {
122	else {	131	$borrowernumber_sql .= ' IN (' . join( ',', ('?') x @borrowernumber ) . ') ';
123	$sql .= ' IN (' . join( ',', ('?') x @borrowernumber ) . ') ';
124	}	132	}
		133	$sql .= $borrowernumber_sql;
125	push( @parameters, @borrowernumber );	134	push( @parameters, @borrowernumber );
126		135
127	$sql .= " ORDER BY $sorting_column $sorting_direction ";	136	$sql .= " $orderby";
		137
		138	if ($count && $count > 0) {
		139	$sql .= " LIMIT ?,?";
		140	push @parameters, $offset, $count;
		141	}
128		142
129	my $dbh = C4::Context->dbh();	143	my $dbh = C4::Context->dbh();
130	my $sth = $dbh->prepare($sql);	144	my $sth = $dbh->prepare($sql);
131	$sth->execute(@parameters);	145	$sth->execute(@parameters);
		146	my ($iTotalDisplayRecords) = $dbh->selectrow_array('SELECT FOUND_ROWS()');
132		147
133	my $item_level_itypes = C4::Context->preference('item-level_itypes');	148	my $item_level_itypes = C4::Context->preference('item-level_itypes');
134		149
135	my @checkouts_today;	150	my @checkouts;
136	my @checkouts_previous;
137	while ( my $c = $sth->fetchrow_hashref() ) {	151	while ( my $c = $sth->fetchrow_hashref() ) {
138	my ($charge) = GetIssuingCharges( $c->{itemnumber}, $c->{borrowernumber} );	152	my ($charge) = GetIssuingCharges( $c->{itemnumber}, $c->{borrowernumber} );
139	my $fine = GetFine( $c->{itemnumber}, $c->{borrowernumber} );	153	my $fine = GetFine( $c->{itemnumber}, $c->{borrowernumber} );
Lines 231-266 while ( my $c = $sth->fetchrow_hashref() ) { Link Here
231	firstname => $c->{firstname},	245	firstname => $c->{firstname},
232	cardnumber => $c->{cardnumber},	246	cardnumber => $c->{cardnumber},
233	},	247	},
234	issued_today => !$c->{not_issued_today},	248	issued_today => $c->{issued_today} ? JSON::true : JSON::false,
235	};	249	};
236		250
237	if ( $c->{not_issued_today} ) {	251	push @checkouts, $checkout;
238	push( @checkouts_previous, $checkout );
239	}
240	else {
241	push( @checkouts_today, $checkout );
242	}
243	}	252	}
244		253
		254	binmode STDOUT, ":encoding(UTF-8)";
		255	print $input->header( -type => 'application/json', -charset => 'UTF-8' );
245		256
246	@checkouts_today = sort { $a->{timestamp} cmp $b->{timestamp} } @checkouts_today;	257	my $sEcho = $input->param('sEcho');
247	@checkouts_today = reverse(@checkouts_today)	258	my ($iTotalRecords) = $dbh->selectrow_array(
248	unless ( C4::Context->preference('todaysIssuesDefaultSortOrder') eq 'desc' );	259	"SELECT COUNT(*) FROM issues WHERE $borrowernumber_sql", undef,
249		260	@borrowernumber);
250	@checkouts_previous = sort { $a->{date_due} cmp $b->{date_due} } @checkouts_previous;
251	@checkouts_previous = reverse(@checkouts_previous)
252	if ( C4::Context->preference('previousIssuesDefaultSortOrder') eq 'desc' );
253
254	my @checkouts = ( @checkouts_today, @checkouts_previous );
255
256	my $i = 1;
257	map { $_->{sort_order} = $i++ } @checkouts;
258
259		261
260	my $data;	262	my $response = {
261	$data->{'iTotalRecords'} = scalar @checkouts;	263	iTotalRecords => $iTotalRecords,
262	$data->{'iTotalDisplayRecords'} = scalar @checkouts;	264	iTotalDisplayRecords => $iTotalDisplayRecords,
263	$data->{'sEcho'} = $input->param('sEcho') \|\| undef;	265	sEcho => $sEcho,
264	$data->{'aaData'} = \@checkouts;	266	aaData => \@checkouts,
		267	};
265		268
266	print to_json($data);	269	print to_json($response);
267	-

Lines 13-25 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc (-2 lines)
13	<th scope="col"> </th>	13	<th scope="col"> </th>
14	<th scope="col"> </th>	14	<th scope="col"> </th>
15	<th scope="col">Due date</th>	15	<th scope="col">Due date</th>
16	<th scope="col">Due date</th>
17	<th scope="col">Title</th>	16	<th scope="col">Title</th>
18	<th scope="col">Item type</th>	17	<th scope="col">Item type</th>
19	<th scope="col">Collection</th>	18	<th scope="col">Collection</th>
20	<th scope="col">Location</th>	19	<th scope="col">Location</th>
21	<th scope="col">Home library</th>	20	<th scope="col">Home library</th>
22	<th scope="col"> </th>
23	<th scope="col">Checked out on</th>	21	<th scope="col">Checked out on</th>
24	<th scope="col">Checked out from</th>	22	<th scope="col">Checked out from</th>
25	<th scope="col">Call no</th>	23	<th scope="col">Call no</th>

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts.js.inc (+27 lines)
	1	[% USE Asset %]
	2	[% USE Koha %]
	3	[% USE raw %]
	4
	5	<script>
	6	[% IF Koha.Preference('ServerSideCheckoutsTables') %]
	7	var ServerSideCheckoutsTables = true;
	8	[% ELSE %]
	9	var ServerSideCheckoutsTables = false;
	10	[% END %]
	11	var AllowCirculate = [% (CAN_user_circulate_circulate_remaining_permissions)? 1 : 0 \| $raw %];
	12	var AllowRenewalLimitOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalLimitOverride'))? 1 : 0 \| $raw %];
	13	var AllowRenewalOnHoldOverride = [% (CAN_user_circulate_override_renewals && Koha.Preference('AllowRenewalOnHoldOverride') )? 1: 0 \| $raw %];
	14
	15	var MSG_DT_LOADING_RECORDS = _("Loading... you may continue scanning.");
	16
	17	var borrowernumber = "[% borrowernumber \| $raw %]";
	18	var relatives_borrowernumbers = new Array();
	19	[% FOREACH b IN relatives_borrowernumbers %]
	20	relatives_borrowernumbers.push("[% b \| $raw %]");
	21	[% END %]
	22
	23	var columns_settings_issues_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'issues-table', 'json' ) \| $raw %];
	24	var relatives_columns_settings = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'relatives-issues-table', 'json' ) \| $raw %];
	25	</script>
	26
	27	[% Asset.js('js/checkouts.js') \| $raw %]

Lines 4-16 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/relatives-issues-table.inc (-2 lines)
4	<table id="relatives-issues-table" style="width: 100% !Important;">	4	<table id="relatives-issues-table" style="width: 100% !Important;">
5	<thead>	5	<thead>
6	<tr>	6	<tr>
7	<th scope="col">Due date (unformatted, hidden)</th>
8	<th scope="col">Due date</th>	7	<th scope="col">Due date</th>
9	<th scope="col">Title</th>	8	<th scope="col">Title</th>
10	<th scope="col">Item type</th>	9	<th scope="col">Item type</th>
11	<th scope="col">Collection code</th>	10	<th scope="col">Collection code</th>
12	<th scope="col">Location</th>	11	<th scope="col">Location</th>
13	<th scope="col">Checked out on (hidden, unformatted)</th>
14	<th scope="col">Checked out on</th>	12	<th scope="col">Checked out on</th>
15	<th scope="col">Checked out from</th>	13	<th scope="col">Checked out from</th>
16	<th scope="col">Call no</th>	14	<th scope="col">Call no</th>