Bug 12508: adding an error message if a contract cannot be removed
[koha_fer] / C4 / Items.pm
index a252ba1..1781880 100644 (file)
@@ -1270,8 +1270,8 @@ sub GetItemsInfo {
            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 holding_branch_opac_info,
+           home.opac_info as home_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
@@ -1323,14 +1323,6 @@ sub GetItemsInfo {
         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