From de40502e0722e03aaf62c3a6b3d581643d658bbe Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
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 @@
             <th>Category</th>
             <th>Library</th>
             <th>Address</th>
+            <th>Primary phone</th>
         </tr>
     </thead>
     <tbody>
@@ -34,6 +35,7 @@
                 <td>[% Categories.GetName( borrower.categorycode ) %]</td>
                 <td>[% Branches.GetName( borrower.branchcode ) %]</td>
                 <td>[% borrower.address %]</td>
+                <td>[% borrower.phone %]</td>
             </tr>
         [% END %]
     </tbody>
-- 
2.1.4