10 use Data::Dump qw(dump);
13 my $dbh = C4::Context->dbh;
28 join borrowers on borrowers.borrowernumber = issues.borrowernumber
29 join items on issues.itemnumber = items.itemnumber
30 join biblioitems on items.biblioitemnumber = biblioitems.biblioitemnumber
31 join biblio on biblioitems.biblionumber = biblio.biblionumber
36 if ( my $nick = $query->param('nick') ) {
37 push @where, 'userid = ?';
41 if ( my $jmbag = $query->param('jmbag') ) {
42 push @where, 'cardnumber = ?';
43 push @data, 'S' . sprintf("%010d",$jmbag);
46 die 'need nick=? and/or jmbag=?' unless @data;
48 $sql .= ' where ' . join(' or ', @where);
49 warn "# SQL: $sql ",dump(@data);
50 my $sth = $dbh->prepare($sql);
54 while ( my $row = $sth->fetchrow_hashref ) {
58 print "Content-type: application/json\r\n\r\n", to_json(\@rows, { utf8 => 1 });