Lines 82-93
sub plugin {
Link Here
|
82 |
FROM items AS i |
82 |
FROM items AS i |
83 |
JOIN biblio AS b USING (biblionumber) |
83 |
JOIN biblio AS b USING (biblionumber) |
84 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
84 |
LEFT OUTER JOIN branches ON (branches.branchcode = homebranch) |
85 |
WHERE cn_sort < '$cn_sort' |
85 |
WHERE cn_sort < ? |
86 |
AND itemcallnumber != '' |
86 |
AND itemcallnumber != '' |
87 |
ORDER BY cn_sort DESC, itemnumber |
87 |
ORDER BY cn_sort DESC, itemnumber |
88 |
LIMIT $real_limit;"; |
88 |
LIMIT $real_limit;"; |
89 |
$sth = $dbh->prepare($query); |
89 |
$sth = $dbh->prepare($query); |
90 |
$sth->execute(); |
90 |
$sth->execute($cn_sort); |
91 |
while ( my $data = $sth->fetchrow_hashref ) { |
91 |
while ( my $data = $sth->fetchrow_hashref ) { |
92 |
if ( $data->{itemcallnumber} eq $q ) { |
92 |
if ( $data->{itemcallnumber} eq $q ) { |
93 |
$data->{background} = 'red'; |
93 |
$data->{background} = 'red'; |
Lines 102-108
sub plugin {
Link Here
|
102 |
unshift @cn, $data; |
102 |
unshift @cn, $data; |
103 |
} |
103 |
} |
104 |
$rows_lt = $sth->rows; |
104 |
$rows_lt = $sth->rows; |
105 |
$sth->finish; |
|
|
106 |
} |
105 |
} |
107 |
|
106 |
|
108 |
if ( $search ne $lt ) { |
107 |
if ( $search ne $lt ) { |
109 |
- |
|
|