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