6 use Data::Dump qw(dump);
12 my $dbh = C4::Context->dbh;
17 create temporary table if not exists t1 as
20 substr(itemcallnumber,1,2) as prefix,
21 substr(itemcallnumber,4) as num,
25 itemcallnumber as signatura,
28 itype as vrsta_gradje_item,
29 itemtype as vrsta_gradje_bib,
37 join biblioitems on items.biblionumber=biblioitems.biblionumber
40 itemcallnumber rlike '^[PDFMS][ABCDERO] ';
45 ./DD-SE/07-MR.sql:where itemcallnumber like 'MR %' and
46 ./DD-SE/08-DR.sql:where itemcallnumber like 'DR %' and
47 ./DD-SE/09-FO.sql:where itemcallnumber like 'FO %' and
48 ./DD-SE/06-DD.sql:where itemcallnumber like 'DD %' and
49 ./DD-SE/10-SE.sql:where itemcallnumber like 'SE %' and
51 ./PC-PE/04-PD.sql:where itemcallnumber like 'PD %' and
52 ./PC-PE/05-PE.sql:where itemcallnumber like 'PE %' and
53 ./PC-PE/03-PC.sql:where itemcallnumber like 'PC %' and
55 ./PA/01-PA.sql:where itemcallnumber like 'PA %' and
57 ./PB/02-PB.sql:where itemcallnumber like 'PB %' and
58 ./PB2/02-PB.sql:where itemcallnumber like 'PB %' and
59 ./PB3/02-PB.sql:where itemcallnumber like 'PB %' and
60 ./PB4/02-PB.sql:where itemcallnumber like 'PB %' and
61 ./PB5/02-PB.sql:where itemcallnumber like 'PB %' and
65 my $sth = $dbh->prepare(qq{
78 while( my $row = $sth->fetchrow_hashref ) {
80 $row->{num} =~ s/\s+$//;
82 if ( $row->{num} !~ m/^\d+$/ ) {
83 warn "SKIP ",dump($row);
87 if ( ! defined $prefix || $prefix ne $row->{prefix}) {
88 $prefix = $row->{prefix};
90 warn "NEW $prefix $num";
95 while ( $row->{num} > $num ) {
96 print "$prefix $num\n";