|
Lines 635-640
sub GetBasketsInfosByBookseller {
Link Here
|
| 635 |
my $query = qq{ |
635 |
my $query = qq{ |
| 636 |
SELECT aqbasket.*, |
636 |
SELECT aqbasket.*, |
| 637 |
SUM(aqorders.quantity) AS total_items, |
637 |
SUM(aqorders.quantity) AS total_items, |
|
|
638 |
SUM( |
| 639 |
IF ( aqorders.orderstatus = 'cancelled', aqorders.quantity, 0 ) |
| 640 |
) AS total_items_cancelled, |
| 638 |
COUNT(DISTINCT aqorders.biblionumber) AS total_biblios, |
641 |
COUNT(DISTINCT aqorders.biblionumber) AS total_biblios, |
| 639 |
SUM( |
642 |
SUM( |
| 640 |
IF(aqorders.datereceived IS NULL |
643 |
IF(aqorders.datereceived IS NULL |