@@ -, +, @@ --- C4/Utils/DataTables/Members.pm | 2 +- admin/columns_settings.yml | 19 ++++++++++++++++++- .../prog/en/includes/circ-patron-search-results.inc | 2 ++ .../intranet-tmpl/prog/en/modules/circ/circulation.tt | 3 ++- koha-tmpl/intranet-tmpl/prog/js/checkouts.js | 2 +- .../prog/js/circ-patron-search-results.js | 14 ++++++++------ 6 files changed, 32 insertions(+), 10 deletions(-) --- a/C4/Utils/DataTables/Members.pm +++ a/C4/Utils/DataTables/Members.pm @@ -64,7 +64,7 @@ sub search { borrowers.borrowernotes, borrowers.branchcode, borrowers.email, borrowers.userid, borrowers.dateofbirth, borrowers.categorycode, categories.description AS category_description, categories.category_type, - branches.branchname"; + branches.branchname, borrowers.phone"; my $from = "FROM borrowers LEFT JOIN branches ON borrowers.branchcode = branches.branchcode LEFT JOIN categories ON borrowers.categorycode = categories.categorycode"; --- a/admin/columns_settings.yml +++ a/admin/columns_settings.yml @@ -566,7 +566,24 @@ modules: columnname: export cannot_be_toggled: 1 cannot_be_modified: 1 - + table_borrowers: + - + columnname: name + cannot_be_toggled: 1 + cannot_be_modified: 1 + - + columnname: cardnumber + - + columnname: date_of_birth + - + columnname: category + - + columnname: library + - + columnname: address + - + columnname: phone + is_hidden: 1 returns: checkedintable: - --- a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc +++ a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc @@ -9,6 +9,7 @@ Category Library Address + Primary phone @@ -30,6 +31,7 @@ [% Categories.GetName( borrower.categorycode ) | html %] [% Branches.GetName( borrower.branchcode ) | html %] [% borrower.address | html %] + [% borrower.phone | html %] [% END %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt @@ -1005,7 +1005,8 @@ No patron matched [% message | html %] 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 = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'issues-table', 'json' ) | $raw %] + 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 %] if($.cookie("holdfor") != [% patron.borrowernumber | html %]){ --- a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js +++ a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js @@ -546,7 +546,7 @@ $(document).ready(function() { .append(ul) .insertBefore(oSettings.nTableWrapper) }, - }, columns_settings).rowGrouping( + }, columns_settings_issues_table).rowGrouping( { iGroupingColumnIndex: 1, iGroupingOrderByColumnIndex: 0, --- a/koha-tmpl/intranet-tmpl/prog/js/circ-patron-search-results.js +++ a/koha-tmpl/intranet-tmpl/prog/js/circ-patron-search-results.js @@ -3,9 +3,11 @@ $(document).ready(function() { $(".clickable").click(function() { window.document.location = $(this).data('url'); }); - var table = $("#table_borrowers").dataTable($.extend(true, {}, dataTablesDefaults, { - "aaSorting": [ 0, "asc" ], - "sDom": "t", - "iDisplayLength": -1 - })); -}); + var table = KohaTable("table_borrowers", + { + "aaSorting": [ 0, "asc" ], + "sDom": "t", + "iDisplayLength": -1 + }, + columns_settings_borrowers_table, null); +}); --