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