Bug 19719: Add new column for collection in the patron checkouts data tables

[koha.git] / svc / checkouts

diff --git a/svc/checkouts b/svc/checkouts
index fefadee..d1fb8d3 100755 (executable)
--- a/svc/checkouts
+++ b/svc/checkouts
@@ -90,6 +90,8 @@ my $sql = '
         items.itype,
         biblioitems.itemtype,
 
+        items.ccode,
+
         borrowernumber,
         surname,
         firstname,
@@ -171,6 +173,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},
         location             => $location,
         homebranch           => $c->{homebranch},
         itemnotes            => $c->{itemnotes},