come posso agire su queste righe affinché ciò succeda?
Code: Select all
$query = $this->db->query("SELECT op.name, op.model, SUM(op.quantity) AS quantity, SUM(op.total + op.tax) AS total FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' GROUP BY model ORDER BY total DESC LIMIT " . (int)$start . "," . (int)$limit);
Code: Select all
$sql = "SELECT MIN(o.date_added) AS date_start, MAX(o.date_added) AS date_end, op.name, op.model, SUM(op.quantity) AS quantity, SUM(op.total + op.tax) AS total FROM `";
grazie