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

(-)a/C4/Utils/DataTables/Members.pm (-2 / +2 lines)
Lines 27-33 sub search { Link Here
27
    }
27
    }
28
28
29
    my $dbh = C4::Context->dbh;
29
    my $dbh = C4::Context->dbh;
30
    my $select = "SELECT SQL_CALC_FOUND_ROWS
30
    my $select = "SELECT
31
        borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address,
31
        borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address,
32
        borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country,
32
        borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country,
33
        CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry,
33
        CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry,
Lines 104-110 sub search { Link Here
104
    my $patrons = $sth->fetchall_arrayref({});
104
    my $patrons = $sth->fetchall_arrayref({});
105
105
106
    # Get the iTotalDisplayRecords DataTable variable
106
    # Get the iTotalDisplayRecords DataTable variable
107
    $query = "SELECT FOUND_ROWS()";
107
    $query = "SELECT COUNT(*) ". $from . ($where ? $where : "");
108
    $sth = $dbh->prepare($query);
108
    $sth = $dbh->prepare($query);
109
    $sth->execute;
109
    $sth->execute;
110
    ($iTotalDisplayRecords) = $sth->fetchrow_array;
110
    ($iTotalDisplayRecords) = $sth->fetchrow_array;
(-)a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc (-3 / +2 lines)
Lines 91-98 Link Here
91
        <option value="[% categorie.categorycode %]" selected="selected">[% categorie.description %]</option>[% ELSE %]
91
        <option value="[% categorie.categorycode %]" selected="selected">[% categorie.description %]</option>[% ELSE %]
92
        <option value="[% categorie.categorycode %]">[% categorie.description %]</option>[% END %]
92
        <option value="[% categorie.categorycode %]">[% categorie.description %]</option>[% END %]
93
      [% END %]</select>
93
      [% END %]</select>
94
	</p>
94
    </p>
95
	[% END %]
95
    [% END %]
96
</form>
96
</form>
97
	</div>
97
	</div>
98
98
99
- 

Return to bug 9811