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 |