projects
/
share-koha-fer
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
04f3e71
)
convert barcode to number in sql
author
Dobrica Pavlinusic
<dpavlin@rot13.org>
Wed, 24 Feb 2021 10:48:55 +0000
(11:48 +0100)
committer
Dobrica Pavlinusic
<dpavlin@rot13.org>
Wed, 24 Feb 2021 10:48:55 +0000
(11:48 +0100)
intranet/cgi-bin/fer/inventura.pl
patch
|
blob
|
history
diff --git
a/intranet/cgi-bin/fer/inventura.pl
b/intranet/cgi-bin/fer/inventura.pl
index
af0aa55
..
6d88bb4
100755
(executable)
--- a/
intranet/cgi-bin/fer/inventura.pl
+++ b/
intranet/cgi-bin/fer/inventura.pl
@@
-63,6
+63,8
@@
if ( $barcode ) {
my $dbh = C4::Context->dbh;
+ warn "inventura barcode: $barcode ",dump($barcode);
+
my $sql = qq{
select
itemnumber,
@@
-80,7
+82,7
@@
if ( $barcode ) {
from items
join biblio on items.biblionumber = biblio.biblionumber
join biblioitems on items.biblionumber = biblioitems.biblionumber
- where barcode = ?
+ where barcode = ?
+ 0
};
#warn "# sql $sql\n";