From de40502e0722e03aaf62c3a6b3d581643d658bbe Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Mon, 26 Sep 2016 17:43:20 +0000 Subject: [PATCH] Bug 17353 - Add phone number column to checkout search This patch adds borrowers.phone as 'Primary phone' in the checkout search results. To test: 1 - Perform a checkout search 2 - Note phone is not displayed 3 - Apply patch 4 - Note phone displays 5 - Ensure page functions as before patch --- C4/Utils/DataTables/Members.pm | 2 +- koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/C4/Utils/DataTables/Members.pm b/C4/Utils/DataTables/Members.pm index d63ce51..86b30ac 100644 --- a/C4/Utils/DataTables/Members.pm +++ b/C4/Utils/DataTables/Members.pm @@ -39,7 +39,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"; diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc index eadeefb..89c1151 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc +++ b/koha-tmpl/intranet-tmpl/prog/en/includes/circ-patron-search-results.inc @@ -19,6 +19,7 @@ Category Library Address + Primary phone @@ -34,6 +35,7 @@ [% Categories.GetName( borrower.categorycode ) %] [% Branches.GetName( borrower.branchcode ) %] [% borrower.address %] + [% borrower.phone %] [% END %] -- 2.1.4