@@ -, +, @@ --- C4/Acquisition.pm | 8 +++++--- .../prog/en/modules/acqui/booksellers.tt | 2 ++ 2 files changed, 7 insertions(+), 3 deletions(-) --- a/C4/Acquisition.pm +++ a/C4/Acquisition.pm @@ -590,7 +590,8 @@ sub GetBasketsInfosByBookseller { my $dbh = C4::Context->dbh; my $query = qq{ SELECT aqbasket.*, - SUM(aqorders.quantity) AS total_items, + aqbasketgroups.name as basketgroupname, + SUM(aqorders.quantity) AS total_items, COUNT(DISTINCT aqorders.biblionumber) AS total_biblios, SUM( IF(aqorders.datereceived IS NULL @@ -600,9 +601,10 @@ sub GetBasketsInfosByBookseller { ) AS expected_items FROM aqbasket LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno - WHERE booksellerid = ?}; + LEFT JOIN aqbasketgroups ON aqbasket.basketgroupid = aqbasketgroups.id + WHERE aqbasket.booksellerid = ?}; if(!$allbaskets) { - $query.=" AND (closedate IS NULL OR (aqorders.quantity > aqorders.quantityreceived AND datecancellationprinted IS NULL))"; + $query.=" AND (aqbasket.closedate IS NULL OR (aqorders.quantity > aqorders.quantityreceived AND datecancellationprinted IS NULL))"; } $query.=" GROUP BY aqbasket.basketno"; --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/booksellers.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/booksellers.tt @@ -97,6 +97,7 @@ $(document).ready(function() { No. Name + Basket group Item count Biblio count Items expected @@ -115,6 +116,7 @@ $(document).ready(function() { [% END %] [% basket.basketno %] [% basket.basketname %] + [% basket.basketgroupname %] ([% basket.basketgroupid %]) [% basket.total_items %] [% basket.total_biblios %] [% basket.expected_items %] --