X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=svc%2Fcheckouts;h=9a1b3a5648c23df43c2237a871847d111090e1c0;hb=refs%2Fheads%2Fkoha_ffzg;hp=d1fb8d34f9e303c9d4fb9c56d8f0c107fdb55238;hpb=fd4d17ace14052662f78d38eae2084cfefa12b9d;p=koha.git

diff --git a/svc/checkouts b/svc/checkouts
index d1fb8d34f9..9a1b3a5648 100755
--- a/svc/checkouts
+++ b/svc/checkouts
@@ -90,7 +90,7 @@ my $sql = '
         items.itype,
         biblioitems.itemtype,
 
-        items.ccode,
+        items.ccode AS collection,
 
         borrowernumber,
         surname,
@@ -156,6 +156,11 @@ while ( my $c = $sth->fetchrow_hashref() ) {
         my $av = Koha::AuthorisedValues->search({ category => 'LOC', authorised_value => $c->{location} });
         $location = $av->count ? $av->next->lib : '';
     }
+    my $collection;
+    if ( $c->{collection} ) {
+        my $av = Koha::AuthorisedValues->search({ category => 'CCODE', authorised_value => $c->{collection} });
+        $collection = $av->count ? $av->next->lib : '';
+    }
     my $lost;
     if ( $c->{itemlost} ) {
         my $av = Koha::AuthorisedValues->search({ category => 'LOST', authorised_value => $c->{itemlost} });
@@ -173,7 +178,7 @@ while ( my $c = $sth->fetchrow_hashref() ) {
         barcode              => $c->{barcode},
         itemtype             => $item_level_itypes ? $c->{itype} : $c->{itemtype},
         itemtype_description => $itemtype ? $itemtype->translated_description : q{},
-        ccode                => $c->{ccode},
+        collection           => $collection,
         location             => $location,
         homebranch           => $c->{homebranch},
         itemnotes            => $c->{itemnotes},