|
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 |
- |
|
|