|
Lines 2087-2097
sub GetLateOrders {
Link Here
|
| 2087 |
$from .= " AND (closedate <= DATE_SUB(CAST(now() AS date),INTERVAL ? DAY)) " ; |
2087 |
$from .= " AND (closedate <= DATE_SUB(CAST(now() AS date),INTERVAL ? DAY)) " ; |
| 2088 |
push @query_params, $delay; |
2088 |
push @query_params, $delay; |
| 2089 |
} |
2089 |
} |
| 2090 |
$having = " |
2090 |
$having = "HAVING quantity <> 0"; |
| 2091 |
HAVING quantity <> 0 |
|
|
| 2092 |
AND unitpricesupplier <> 0 |
| 2093 |
AND unitpricelib <> 0 |
| 2094 |
"; |
| 2095 |
} else { |
2091 |
} else { |
| 2096 |
# FIXME: account for IFNULL as above |
2092 |
# FIXME: account for IFNULL as above |
| 2097 |
$select .= " |
2093 |
$select .= " |
| 2098 |
- |
|
|