View | Details | Raw Unified | Return to bug 13364
Collapse All | Expand All

(-)a/cataloguing/value_builder/cn_browser.pl (-4 / +2 lines)
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
- 

Return to bug 13364