GX-Bug #42904 » SaleReportFix.patch
| src/admin/includes/classes/sales_report.php (revision ) | ||
|---|---|---|
| 184 | 184 |
$rqShipping = xtc_db_query($this->queryShipping . " AND o.date_purchased >= '" . xtc_db_input(date("Y-m-d\TH:i:s", $sd)) . "' AND o.date_purchased < '" . xtc_db_input(date("Y-m-d\TH:i:s", $ed)) . "'" . $filterString);
|
| 185 | 185 |
$shipping = xtc_db_fetch_array($rqShipping); |
| 186 | 186 |
|
| 187 |
$rqItems = xtc_db_query($this->queryItemCnt . " AND o.date_purchased >= '" . xtc_db_input(date("Y-m-d\TH:i:s", $sd)) . "' AND o.date_purchased < '" . xtc_db_input(date("Y-m-d\TH:i:s", $ed)) . "'" . $filterString . " group by pid " . $this->sortString);
|
|
| 187 |
$rqItems = xtc_db_query($this->queryItemCnt . " AND o.date_purchased >= '" . xtc_db_input(date("Y-m-d\TH:i:s", $sd)) . "' AND o.date_purchased < '" . xtc_db_input(date("Y-m-d\TH:i:s", $ed)) . "'" . $filterString . " group by pmodel " . $this->sortString);
|
|
| 188 | 188 |
|
| 189 | 189 |
// set the return values |
| 190 | 190 |
$this->actDate = $ed; |