Product views report

[chulcha]

All versions

opencart/upload/extension/opencart/admin/model/report/product.php

Line 25 in e22ddfb

$query = $this->db->query("SELECT SUM(`viewed`) AS `total` FROM `" . DB_PREFIX . "product`");

opencart/upload/extension/opencart/admin/model/report/product.php

Line 31 in e22ddfb

$query = $this->db->query("SELECT COUNT(*) AS `total` FROM `" . DB_PREFIX . "product` WHERE `viewed` > '0'");

Need add

LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
		WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "'

Also, I would like to have sorting and filtering
But this can be left for developers too.

[TheCartpenter]

Using SUM is not the same as COUNT and viewed higher than 0 will not provide the same result as SUM ... as for the language ID, however, that'd be correct.

[chulcha]

Using SUM is not the same as COUNT and viewed higher than 0 will not provide the same result as SUM ... as for the language ID, however, that'd be correct.

Get your a..s..s.. if you don't understand what this is about

[danielkerr]

code has changed also not a clue what u are actually doing with these changes