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

(-)a/C4/Items.pm (-4 / +6 lines)
Lines 1250-1259 sub GetItemsInfo { Link Here
1250
            'SELECT authorised_value
1250
            'SELECT authorised_value
1251
            FROM   marc_subfield_structure
1251
            FROM   marc_subfield_structure
1252
            WHERE  kohafield="items.notforloan"
1252
            WHERE  kohafield="items.notforloan"
1253
            AND frameworkcode = ?
1253
        '
1254
        '
1254
        );
1255
        );
1255
1256
1256
        $sthnflstatus->execute;
1257
        $sthnflstatus->execute( $data->{frameworkcode} );
1257
        my ($authorised_valuecode) = $sthnflstatus->fetchrow;
1258
        my ($authorised_valuecode) = $sthnflstatus->fetchrow;
1258
        if ($authorised_valuecode) {
1259
        if ($authorised_valuecode) {
1259
            $sthnflstatus = $dbh->prepare(
1260
            $sthnflstatus = $dbh->prepare(
Lines 1272-1281 sub GetItemsInfo { Link Here
1272
            'SELECT authorised_value
1273
            'SELECT authorised_value
1273
            FROM   marc_subfield_structure
1274
            FROM   marc_subfield_structure
1274
            WHERE  kohafield="items.restricted"
1275
            WHERE  kohafield="items.restricted"
1276
            AND frameworkcode = ?
1275
        '
1277
        '
1276
        );
1278
        );
1277
1279
1278
        $restrictedstatus->execute;
1280
        $restrictedstatus->execute( $data->{frameworkcode} );
1279
        ($authorised_valuecode) = $restrictedstatus->fetchrow;
1281
        ($authorised_valuecode) = $restrictedstatus->fetchrow;
1280
        if ($authorised_valuecode) {
1282
        if ($authorised_valuecode) {
1281
            $restrictedstatus = $dbh->prepare(
1283
            $restrictedstatus = $dbh->prepare(
Lines 1297-1305 sub GetItemsInfo { Link Here
1297
            'SELECT authorised_value
1299
            'SELECT authorised_value
1298
             FROM   marc_subfield_structure
1300
             FROM   marc_subfield_structure
1299
             WHERE  kohafield="items.stack"
1301
             WHERE  kohafield="items.stack"
1302
             AND frameworkcode = ?
1300
        '
1303
        '
1301
        );
1304
        );
1302
        $stackstatus->execute;
1305
        $stackstatus->execute( $data->{frameworkcode} );
1303
1306
1304
        ($authorised_valuecode) = $stackstatus->fetchrow;
1307
        ($authorised_valuecode) = $stackstatus->fetchrow;
1305
        if ($authorised_valuecode) {
1308
        if ($authorised_valuecode) {
1306
- 

Return to bug 7872