Jump to content

Erreur dans modules Followup

Recommended Posts


j'ai découvert deux erreures dans le module Followup : (Customers follow-up v1.0)


- erreur de query, veuillez changer la query par celle-ci : (ligne 166)

            $stats = Db::getInstance()->ExecuteS('
           SELECT DATE_FORMAT(l.date_add, \'%Y-%m-%d\') date_stat, l.id_email_type, COUNT(l.id_log_email) nb, 
           (SELECT COUNT(l2.id_discount) 
           FROM '._DB_PREFIX_.'log_email l2
           LEFT JOIN '._DB_PREFIX_.'order_discount od ON (od.id_discount = l2.id_discount)
           LEFT JOIN '._DB_PREFIX_.'orders o ON (o.id_order = od.id_order)
           WHERE l2.id_email_type = l.id_email_type AND l2.date_add = l.date_add AND od.id_order IS NOT NULL AND o.valid = 1) nb_used
           FROM '._DB_PREFIX_.'log_email l
           WHERE l.date_add >= DATE_SUB(CURDATE(), INTERVAL 60 DAY)
           GROUP BY [b]DATE_FORMAT(l.date_add, \'%Y-%m-%d\')[/b], l.id_email_type');

- erreur de calcule de rating (ligne 208), veuillez corriger ceci :

$rates[$i] = number_format(($statsArray[$date_stat][$i][[b]'nb_used'[/b]] / $statsArray[$date_stat][$i][[b]'nb'[/b]])*100, 2, '.', '');   

De plus, attention car ce module (et d'autres aussi) ne prend pas en compte les comptes client désactivés !!!
En ce qui me concerne j'ai ajouté aux quatres query la clause : "cu.active = 1" pour ne prendre en compte que les comptes actifs !!!!

voilà !

Link to comment
Share on other sites

  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...