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