Статистика

[kislotnik]

Подскажите как сделать чтоб статистика считала не от выполненных а от удаленных заказов?

[parampados]

В файле /simpla/ajax/stat/stat.php заменить строку:

 

$query = $this->db->placehold('SELECT SUM( o.total_price ) AS total_price, DAY(date) AS day, MONTH(date) as month, YEAR(date) as year FROM __orders o WHERE o.closed GROUP BY YEAR(o.date), MONTH(o.date),  DATE(o.date)');
 

 

на:

 

$query = $this->db->placehold('SELECT SUM( o.total_price ) AS total_price, DAY(date) AS day, MONTH(date) as month, YEAR(date) as year FROM __orders o WHERE o.status=3 GROUP BY YEAR(o.date), MONTH(o.date),  DATE(o.date)');