X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=svc%2Fcheckouts;h=119053c2f45ee64187d480f7308a9d49ba01d927;hb=99bdb7edbd6d284417fead443e88a3a1f20afffd;hp=f1e3ffa1c3fb4d817cf719e7c1e5736c75b5038f;hpb=d44d0acfec4e0b9a7f5dac33677e759e0fd69ab0;p=koha.git

diff --git a/svc/checkouts b/svc/checkouts
index f1e3ffa1c3..119053c2f4 100755
--- a/svc/checkouts
+++ b/svc/checkouts
@@ -78,13 +78,14 @@ my $sql = '
 
         itemnumber,
         barcode,
+        branches2.branchname AS homebranch,
         itemnotes,
         itemnotes_nonpublic,
         itemcallnumber,
         replacementprice,
 
         issues.branchcode,
-        branchname,
+        branches.branchname,
 
         items.itype,
         biblioitems.itemtype,
@@ -106,6 +107,7 @@ my $sql = '
         LEFT JOIN biblioitems USING ( biblionumber )
         LEFT JOIN borrowers USING ( borrowernumber )
         LEFT JOIN branches ON ( issues.branchcode = branches.branchcode )
+        LEFT JOIN branches branches2 ON ( items.homebranch = branches2.branchcode )
     WHERE borrowernumber
 ';
 
@@ -155,6 +157,7 @@ while ( my $c = $sth->fetchrow_hashref() ) {
         itemtype             => $item_level_itypes ? $c->{itype} : $c->{itemtype},
         itemtype_description => $itemtype->{translated_description},
         location             => $c->{location} ? GetAuthorisedValueByCode( 'LOC', $c->{location} ) : q{},
+        homebranch           => $c->{homebranch},
         itemnotes            => $c->{itemnotes},
         itemnotes_nonpublic  => $c->{itemnotes_nonpublic},
         branchcode           => $c->{branchcode},