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

(-)a/C4/Items.pm (-1 / +22 lines)
Lines 1269-1274 sub GetItemsInfo { Link Here
1269
            $data->{notforloanvalue} = $lib;
1269
            $data->{notforloanvalue} = $lib;
1270
        }
1270
        }
1271
1271
1272
        # get itemnotes authorised value if applicable
1273
        my $sql_itemnotes = "
1274
            SELECT authorised_value
1275
            FROM   marc_subfield_structure
1276
            WHERE  kohafield = 'items.itemnotes'
1277
            AND    frameworkcode = ?
1278
        ";
1279
        my $sth_itemnotes = $dbh->prepare( $sql_itemnotes );
1280
        $sth_itemnotes->execute( $data->{'frameworkcode'} );
1281
1282
        my ($authorised_valuecode) = $sth_itemnotes->fetchrow;
1283
        if ($authorised_valuecode) {
1284
            $sth_itemnotes = $dbh->prepare(
1285
                "SELECT lib FROM authorised_values
1286
                 WHERE  category=?
1287
                 AND authorised_value=?"
1288
            );
1289
            $sth_itemnotes->execute( $authorised_valuecode, $data->{'itemnotes'} );
1290
            my ($lib) = $sth_itemnotes->fetchrow;
1291
            $data->{'itemnotes'} = $lib;
1292
        }
1293
1272
        # get restricted status and description if applicable
1294
        # get restricted status and description if applicable
1273
        my $restrictedstatus = $dbh->prepare(
1295
        my $restrictedstatus = $dbh->prepare(
1274
            'SELECT authorised_value
1296
            'SELECT authorised_value
1275
- 

Return to bug 7515