Detailed Product Purchased Report! (please add to open cart)

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

$query = $this->db->query("SELECT op.name, op.model, SUM(op.quantity) AS quantity, SUM(op.total+op.total*op.tax/100) AS total FROM `" . DB_PREFIX . "order` o INNER JOIN " . DB_PREFIX . "order_product op ON (op.order_id = o.order_id) WHERE o.order_status_id > 0 GROUP BY op.product_id ORDER BY total DESC LIMIT " . (int)$start . "," . (int)$limit);

Code: Select all

$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_product` GROUP BY model");

Code: Select all

$query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order_product` GROUP BY product_id");

Code: Select all

name 	model 	  price 	Qty 	Orders 	Total 	order_status_id
Canon EOS 5D 	Product 3 	  100.0000 	4 	2 	400.0000 	1
iPod Classic 	product 20   150.0000 	3 	2 	430.0000 	1

Code: Select all

iPod Classic 	product 20 	3 	431.500000000000
Canon EOS 5D 	Product 3 	4 	400.000000000000

Code: Select all

WHERE o.order_status_id IN (1,2,3,5)

Code: Select all

WHERE o.order_status_id > '0'