itemtypes.notforloan as notforloan_per_itemtype,
holding.branchurl,
holding.branchname,
- holding.opac_info as branch_opac_info,
- home.branchurl AS homebranchurl
+ holding.opac_info as branch_opac_info
FROM items
LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode
LEFT JOIN branches AS home ON items.homebranch=home.branchcode
if ( my $bdata = $bsth->fetchrow_hashref ) {
$data->{'branchname'} = $bdata->{'branchname'};
}
- $bsth = $dbh->prepare(
- "SELECT * FROM branches WHERE branchcode = ?
- "
- );
- $bsth->execute( $data->{'homebranch'} );
- if ( my $bdata = $bsth->fetchrow_hashref ) {
- $data->{'homebranchname'} = $bdata->{'branchname'};
- }
$data->{'datedue'} = $datedue;
# get notforloan complete status if applicable