X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=circ%2Fysearch.pl;h=8973902925659f6249dd27d8919c910c100a6436;hb=ef5d4f3c62957100dae0948a44bd27a2159892b4;hp=4a3663e34828db653401c22d76f76a608b1bd52b;hpb=6b72f249082fc6be8811c3dacec15648f7c5ccd9;p=koha_fer diff --git a/circ/ysearch.pl b/circ/ysearch.pl index 4a3663e348..8973902925 100755 --- a/circ/ysearch.pl +++ b/circ/ysearch.pl @@ -45,19 +45,19 @@ if ($auth_status ne "ok") { my $dbh = C4::Context->dbh; my $sql = q( - SELECT surname, firstname, cardnumber, address, city, zipcode, country + SELECT borrowernumber, surname, firstname, cardnumber, address, city, zipcode, country FROM borrowers WHERE ( surname LIKE ? OR firstname LIKE ? OR cardnumber LIKE ? ) ); -if (C4::Context->preference("IndependentBranches")){ - if ( C4::Context->userenv - && (C4::Context->userenv->{flags} % 2) !=1 - && C4::Context->userenv->{'branch'} - ){ - $sql .= " AND borrowers.branchcode =" . $dbh->quote(C4::Context->userenv->{'branch'}); - } +if ( C4::Context->preference("IndependentBranches") + && C4::Context->userenv + && !C4::Context->IsSuperLibrarian() + && C4::Context->userenv->{'branch'} ) +{ + $sql .= " AND borrowers.branchcode =" + . $dbh->quote( C4::Context->userenv->{'branch'} ); } $sql .= q( ORDER BY surname, firstname LIMIT 10); @@ -68,7 +68,8 @@ print "["; my $i = 0; while ( my $rec = $sth->fetchrow_hashref ) { if($i > 0){ print ","; } - print "{\"surname\":\"" . $rec->{surname} . "\",\"" . + print "{\"borrowernumber\":\"" . $rec->{borrowernumber} . "\",\"" . + "surname\":\"".$rec->{surname} . "\",\"" . "firstname\":\"".$rec->{firstname} . "\",\"" . "cardnumber\":\"".$rec->{cardnumber} . "\",\"" . "address\":\"".$rec->{address} . "\",\"" .