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

(-)a/C4/Utils/DataTables/Members.pm (-3 / +4 lines)
Lines 28-36 sub search { Link Here
28
28
29
    my $dbh = C4::Context->dbh;
29
    my $dbh = C4::Context->dbh;
30
    my $select = "SELECT
30
    my $select = "SELECT
31
        borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address,
31
        borrowers.borrowernumber, borrowers.surname, borrowers.firstname,
32
        borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country,
32
        borrowers.streetnumber, borrowers.streettype, borrowers.address,
33
        cardnumber, borrowers.dateexpiry,
33
        borrowers.address2, borrowers.city, borrowers.state, borrowers.zipcode,
34
        borrowers.country, cardnumber, borrowers.dateexpiry,
34
        borrowers.borrowernotes, borrowers.branchcode, borrowers.email,
35
        borrowers.borrowernotes, borrowers.branchcode, borrowers.email,
35
        categories.description AS category_description, categories.category_type,
36
        categories.description AS category_description, categories.category_type,
36
        branches.branchname";
37
        branches.branchname";
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/members/tables/members_results.tt (-2 / +1 lines)
Lines 12-18 Link Here
12
                "dt_cardnumber":
12
                "dt_cardnumber":
13
                    "[% data.cardnumber %]",
13
                    "[% data.cardnumber %]",
14
                "dt_name":
14
                "dt_name":
15
                    "<span style='white-space:nowrap'><a href='/cgi-bin/koha/members/moremember.pl?borrowernumber=[% data.borrowernumber %]'>[% 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%]</a><br />[% IF ( data.streetnumber ) %][% data.streetnumber %] [% END %][% data.address %][% IF ( data.address2 ) %]<br />[% data.address2 %][% END %][% IF ( data.city ) %]<br />[% 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 %]<br/>Email&#58; <a href='mailto&#58;[% data.email %]'>[% data.email %]</a>[% END %]</span>",
15
                    "<span style='white-space:nowrap'><a href='/cgi-bin/koha/members/moremember.pl?borrowernumber=[% data.borrowernumber %]'>[% 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%]</a><br />[% IF ( data.streetnumber ) %][% data.streetnumber %] [% END %][% IF ( data.streettype ) %][% data.streettype %] [% END %][% data.address %][% IF ( data.address2 ) %]<br />[% data.address2 %][% END %][% IF ( data.city || data.state || data.zipcode || data.country) %]<br />[% 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 %]<br/>Email&#58; <a href='mailto&#58;[% data.email %]'>[% data.email %]</a>[% END %]</span>",
16
                "dt_category":
16
                "dt_category":
17
                    "[% data.category_description |html %] ([% data.category_type |html %])",
17
                    "[% data.category_description |html %] ([% data.category_type |html %])",
18
                "dt_branch":
18
                "dt_branch":
19
- 

Return to bug 4013