|
Lines 712-718
sub GetBasketsInfosByBookseller {
Link Here
|
| 712 |
|
712 |
|
| 713 |
unless ( $allbaskets ) { |
713 |
unless ( $allbaskets ) { |
| 714 |
# Don't show the basket if it's NOT CLOSED or is FULLY RECEIVED |
714 |
# Don't show the basket if it's NOT CLOSED or is FULLY RECEIVED |
| 715 |
$query.=" HAVING (closedate IS NULL OR (expected_items > 0))" |
715 |
$query.=" HAVING (closedate IS NULL OR ( |
|
|
716 |
SUM( |
| 717 |
IF(aqorders.datereceived IS NULL |
| 718 |
AND (aqorders.datecancellationprinted IS NULL OR aqorders.datecancellationprinted='0000-00-00') |
| 719 |
, aqorders.quantity |
| 720 |
, 0) |
| 721 |
) > 0))" |
| 716 |
} |
722 |
} |
| 717 |
|
723 |
|
| 718 |
my $sth = $dbh->prepare($query); |
724 |
my $sth = $dbh->prepare($query); |
| 719 |
- |
|
|