ecost_tax_included, budgetdate, entrydate,
aqbasket.booksellerid,
aqbooksellers.name as vendorname,
- GROUP_CONCAT(DISTINCT itype),
+ GROUP_CONCAT(DISTINCT itype SEPARATOR '|') AS itypes,
title
FROM (aqorders, aqbasket)
LEFT JOIN biblio ON
my $total = 0;
while ( my $data = $sth->fetchrow_hashref ) {
+ $data->{'itemtypes'} = [split('\|', $data->{itypes})];
my $left = $data->{'tleft'};
if ( !$left || $left eq '' ) {
$left = $data->{'quantity'};
quantity-quantityreceived AS tleft,
budgetdate, entrydate,
aqbasket.booksellerid,
- GROUP_CONCAT(DISTINCT itype),
+ GROUP_CONCAT(DISTINCT itype SEPARATOR '|') as itypes,
title,
aqorders.invoiceid,
aqinvoices.invoicenumber,
my @spent;
while ( my $data = $sth->fetchrow_hashref ) {
my $recv = $data->{'quantityreceived'};
+ $data->{'itemtypes'} = [split('\|', $data->{itypes})];
if ( $recv > 0 ) {
my $rowtotal = $recv * get_rounded_price($data->{'unitprice_tax_included'});
$data->{'rowtotal'} = sprintf( "%.2f", $rowtotal );
<th class="anti-the"> Title </th>
<th> Order </th>
<th> Vendor </th>
- <th> Item type </th>
+ <th> Item types </th>
<th> Left on order </th>
<th> Estimated cost per unit </th>
<th class="title-string"> Date ordered </th>
<a href="/cgi-bin/koha/acqui/supplier.pl?booksellerid=[% order.booksellerid | uri %]">[% order.vendorname | html %]</a>
</td>
<td class="cell">
- [% ItemTypes.GetDescription( order.itype ) | html %]
+ [% FOREACH itemtype IN order.itemtypes %]
+ [% IF !(loop.count() mod 2) %] | [% END %]
+ [% ItemTypes.GetDescription( itemtype ) | html %]
+ [% END %]
</td>
<td class="cell">
[% order.left | html %]
<th>Order</th>
<th>Vendor</th>
<th>Invoice</th>
- <th>Item type</th>
+ <th>Item types</th>
<th>Received</th>
<th>Unit price</th>
<th class="title-string">Date ordered</th>
<a href="/cgi-bin/koha/acqui/invoice.pl?invoiceid=[% order.invoiceid | uri %]">[% order.invoicenumber | html %]</a>
</td>
<td class="cell">
- [% ItemTypes.GetDescription( order.itype ) | html %]
+ [% FOREACH itemtype IN order.itemtypes %]
+ [% IF !(loop.count() mod 2) %] | [% END %]
+ [% ItemTypes.GetDescription( itemtype ) | html %]
+ [% END %]
</td>
<td class="cell">
[% order.quantityreceived | html %]