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