$dbh->begin_work;
- my $sth = $dbh->prepare("select biblionumber,barcode,stocknumber,itype from items where itemnumber = ?");
+ my $sth = $dbh->prepare("select biblionumber,barcode,stocknumber,itype,homebranch from items where itemnumber = ?");
$sth->execute( $itemnumber );
if ( $sth->rows != 1 ) {
die "ERROR: itemnumber $itemnumber have ", $sth->rows, " rows";
}
- my ( $biblionumber, $barcode, $stocknumber, $itype ) = $sth->fetchrow_array;
- warn "YYY got ", dump( $biblionumber, $barcode, $stocknumber, $itype );
+ my ( $biblionumber, $barcode, $stocknumber, $itype, $homebranch ) = $sth->fetchrow_array;
+ warn "YYY got ", dump( $biblionumber, $barcode, $stocknumber, $itype, $homebranch );
next if $itype =~ /(BAZA|PER|CLA|PRE|RZB)/;
my $year = DateTime->now->year;
- if (! $stocknumber) {
+ if (! $stocknumber && ( $homebranch eq 'FFZG' || $homebranch eq 'AKZG' ) ) {
- $sth = $dbh->prepare("select max(num) from ffzg_inventarna_knjiga where year = ?");
+ my $inventarna_knjiga = lc($homebranch) . '_inventarna_knjiga';
+
+ $sth = $dbh->prepare("select max(num) from $inventarna_knjiga where year = ?");
$sth->execute($year);
$stocknumber = $sth->fetchrow; # return null without any data
$stocknumber += 1;
- $sth = $dbh->prepare("insert into ffzg_inventarna_knjiga (year,num, biblionumber, itemnumber) values (?,?,?,?)");
+ $sth = $dbh->prepare("insert into $inventarna_knjiga (year,num, biblionumber, itemnumber) values (?,?,?,?)");
$sth->execute( $year, $stocknumber, $biblionumber, $itemnumber );
$stocknumber = "$year-$stocknumber";
+
+ $stocknumber = 'AK-' . $stocknumber if $homebranch eq 'AKZG';
}
warn "## itemnumber: $itemnumber barcode: $barcode stocknumber: $stocknumber\n";