@@ -, +, @@
---
C4/Utils/DataTables/Members.pm | 7 ++++---
.../prog/en/modules/members/tables/members_results.tt | 3 ++-
2 files changed, 6 insertions(+), 4 deletions(-)
--- a/C4/Utils/DataTables/Members.pm
+++ a/C4/Utils/DataTables/Members.pm
@@ -28,9 +28,10 @@ sub search {
my $dbh = C4::Context->dbh;
my $select = "SELECT
- borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address,
- borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country,
- cardnumber, borrowers.dateexpiry,
+ borrowers.borrowernumber, borrowers.surname, borrowers.firstname,
+ borrowers.streetnumber, borrowers.streettype, borrowers.address,
+ borrowers.address2, borrowers.city, borrowers.state, borrowers.zipcode,
+ borrowers.country, cardnumber, borrowers.dateexpiry,
borrowers.borrowernotes, borrowers.branchcode, borrowers.email,
categories.description AS category_description, categories.category_type,
branches.branchname";
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/members/tables/members_results.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/members/tables/members_results.tt
@@ -1,3 +1,4 @@
+[% USE AuthorisedValues %]
{
"sEcho": [% sEcho %],
"iTotalRecords": [% iTotalRecords %],
@@ -12,7 +13,7 @@
"dt_cardnumber":
"[% data.cardnumber %]",
"dt_name":
- "[% INCLUDE 'patron-title.inc' borrowernumber = data.borrowernumber category_type = data.category_type firstname = data.firstname surname = data.surname othernames = data.othernames cardnumber = data.cardnumber invert_name = 1%]
[% IF ( data.streetnumber ) %][% data.streetnumber %] [% END %][% data.address %][% IF ( data.address2 ) %]
[% data.address2 %][% END %][% IF ( data.city ) %]
[% data.city %][% IF ( data.state ) %],[% END %][% END %][% IF ( data.state ) %] [% data.state %][% END %] [% IF ( data.zipcode ) %] [% data.zipcode %][% END %][% IF ( data.country ) %], [% data.country %][% END %][% IF data.email %]
Email: [% data.email %][% END %]",
+ "[% INCLUDE 'patron-title.inc' borrowernumber = data.borrowernumber category_type = data.category_type firstname = data.firstname surname = data.surname othernames = data.othernames cardnumber = data.cardnumber invert_name = 1%]
[% IF ( data.streetnumber ) %][% data.streetnumber %] [% END %][% IF ( data.streettype ) %][% AuthorisedValues.GetByCode( 'ROADTYPE', data.streettype ) %] [% END %][% data.address %][% IF ( data.address2 ) %]
[% data.address2 %][% END %][% IF ( data.city || data.state || data.zipcode || data.country) %]
[% END %][% IF ( data.city ) %][% data.city %][% IF ( data.state ) %],[% END %][% END %][% IF ( data.state ) %] [% data.state %][% END %] [% IF ( data.zipcode ) %] [% data.zipcode %][% END %][% IF ( data.country ) %], [% data.country %][% END %][% IF data.email %]
Email: [% data.email %][% END %]",
"dt_category":
"[% data.category_description |html %] ([% data.category_type |html %])",
"dt_branch":
--