|
Lines 595-601
sub GetBasketsInfosByBookseller {
Link Here
|
| 595 |
) AS expected_items |
595 |
) AS expected_items |
| 596 |
FROM aqbasket |
596 |
FROM aqbasket |
| 597 |
LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno |
597 |
LEFT JOIN aqorders ON aqorders.basketno = aqbasket.basketno |
| 598 |
WHERE booksellerid = ? |
598 |
WHERE booksellerid = ? AND ( aqorders.quantity > aqorders.quantityreceived OR quantityreceived IS NULL) |
|
|
599 |
AND datecancellationprinted IS NULL |
| 599 |
GROUP BY aqbasket.basketno |
600 |
GROUP BY aqbasket.basketno |
| 600 |
}; |
601 |
}; |
| 601 |
my $sth = $dbh->prepare($query); |
602 |
my $sth = $dbh->prepare($query); |
| 602 |
- |
|
|