View | Details | Raw Unified | Return to bug 20144
Collapse All | Expand All

(-)a/C4/Acquisition.pm (-3 / +3 lines)
Lines 2518-2524 sub GetInvoices { Link Here
2518
2518
2519
    my $dbh = C4::Context->dbh;
2519
    my $dbh = C4::Context->dbh;
2520
    my $query = qq{
2520
    my $query = qq{
2521
        SELECT aqinvoices.*, aqbooksellers.name AS suppliername,
2521
        SELECT aqinvoices.invoiceid, aqinvoices.invoicenumber, aqinvoices.booksellerid, aqinvoices.shipmentdate, aqinvoices.billingdate, aqinvoices.closedate, aqinvoices.shipmentcost, aqinvoices.shipmentcost_budgetid, aqinvoices.message_id,
2522
            aqbooksellers.name AS suppliername,
2522
          COUNT(
2523
          COUNT(
2523
            DISTINCT IF(
2524
            DISTINCT IF(
2524
              aqorders.datereceived IS NOT NULL,
2525
              aqorders.datereceived IS NOT NULL,
Lines 2604-2610 sub GetInvoices { Link Here
2604
    }
2605
    }
2605
2606
2606
    $query .= " WHERE " . join(" AND ", @bind_strs) if @bind_strs;
2607
    $query .= " WHERE " . join(" AND ", @bind_strs) if @bind_strs;
2607
    $query .= " GROUP BY aqinvoices.invoiceid ";
2608
    $query .= " GROUP BY aqinvoices.invoiceid, aqinvoices.invoicenumber, aqinvoices.booksellerid, aqinvoices.shipmentdate, aqinvoices.billingdate, aqinvoices.closedate, aqinvoices.shipmentcost, aqinvoices.shipmentcost_budgetid, aqinvoices.message_id, aqbooksellers.name";
2608
2609
2609
    if($args{order_by}) {
2610
    if($args{order_by}) {
2610
        my ($column, $direction) = split / /, $args{order_by};
2611
        my ($column, $direction) = split / /, $args{order_by};
2611
- 

Return to bug 20144