ffzg/recall_notices.pl: added --interval and --dedup

[koha.git] / circ / ysearch.pl

diff --git a/circ/ysearch.pl b/circ/ysearch.pl
index 7429c06..b9e75d0 100755 (executable)
--- a/circ/ysearch.pl
+++ b/circ/ysearch.pl
@@ -7,76 +7,89 @@
 #
 # This file is part of Koha.
 #
-# Koha is free software; you can redistribute it and/or modify it under the
-# terms of the GNU General Public License as published by the Free Software
-# Foundation; either version 2 of the License, or (at your option) any later
-# version.
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
 #
-# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
-# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
-# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
 #
-# You should have received a copy of the GNU General Public License along
-# with Koha; if not, write to the Free Software Foundation, Inc.,
-# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
 
 =head1 ysearch.pl
 
-
 =cut
 
-use strict;
-#use warnings; FIXME - Bug 2505
-use CGI;
+use Modern::Perl;
+use CGI qw ( -utf8 );
 use C4::Context;
-use C4::Members;
 use C4::Auth qw/check_cookie_auth/;
+use Koha::Patrons;
+use Koha::DateUtils qw/format_sqldatetime/;
+
+use JSON qw( to_json );
 
-my $input   = new CGI;
-my $query   = $input->param('term');
+my $input = new CGI;
+my $query = $input->param('term');
 
 binmode STDOUT, ":encoding(UTF-8)";
-print $input->header(-type => 'text/plain', -charset => 'UTF-8');
+print $input->header( -type => 'text/plain', -charset => 'UTF-8' );
 
-my ($auth_status, $sessionID) = check_cookie_auth($input->cookie('CGISESSID'), { circulate => '*' });
-if ($auth_status ne "ok") {
+my ( $auth_status, $sessionID ) = check_cookie_auth( $input->cookie('CGISESSID'), { catalogue => '1' } );
+if ( $auth_status ne "ok" ) {
     exit 0;
 }
 
-my $dbh = C4::Context->dbh;
-my $sql = q(
-    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'});
-  }
+my $limit_on_branch;
+if (   C4::Context->preference("IndependentBranches")
+    && C4::Context->userenv
+    && !C4::Context->IsSuperLibrarian()
+    && C4::Context->userenv->{'branch'} ) {
+    $limit_on_branch = 1;
+}
+
+my @parts = split( / /, $query );
+my @params;
+foreach my $p (@parts) {
+    push(
+        @params,
+        -or => [
+            surname    => { -like => "%$p%" },
+            firstname  => { -like => "%$p%" },
+            cardnumber => { -like => "$p%" },
+        ]
+    );
 }
 
-$sql    .= q( ORDER BY surname, firstname LIMIT 10);
-my $sth = $dbh->prepare( $sql );
-$sth->execute("$query%", "$query%", "$query%");
+push( @params, { branchcode => C4::Context->userenv->{branch} } ) if $limit_on_branch;
+
+my $borrowers_rs = Koha::Patrons->search_limited(
+    { -and => \@params },
+    {
+        # Get the first 10 results
+        page     => 1,
+        rows     => 10,
+        order_by => [ 'surname', 'firstname' ],
+    },
+);
 
-print "[";
-my $i = 0;
-while ( my $rec = $sth->fetchrow_hashref ) {
-    if($i > 0){ print ","; }
-    print "{\"borrowernumber\":\"" . $rec->{borrowernumber} . "\",\"" .
-          "surname\":\"".$rec->{surname} . "\",\"" .
-          "firstname\":\"".$rec->{firstname} . "\",\"" .
-          "cardnumber\":\"".$rec->{cardnumber} . "\",\"" .
-          "address\":\"".$rec->{address} . "\",\"" .
-          "city\":\"".$rec->{city} . "\",\"" .
-          "zipcode\":\"".$rec->{zipcode} . "\",\"" .
-          "country\":\"".$rec->{country} . "\"" .
-          "}";
-    $i++;
+my @borrowers;
+while ( my $b = $borrowers_rs->next ) {
+    push @borrowers,
+      { borrowernumber => $b->borrowernumber,
+        surname        => $b->surname    // '',
+        firstname      => $b->firstname  // '',
+        cardnumber     => $b->cardnumber // '',
+        dateofbirth    => format_sqldatetime($b->dateofbirth, undef, undef, 1) // '',
+        address        => $b->address    // '',
+        city           => $b->city       // '',
+        zipcode        => $b->zipcode    // '',
+        country        => $b->country    // '',
+      };
 }
-print "]";
+
+print to_json( \@borrowers );