|
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 |
- |
|
|