decome2013 Posted April 8, 2014 Share Posted April 8, 2014 (edited) Bonjour, Je recherche un module qui permettrait d'ajouter un commentaire interne (non visible du client) dans les commandes du BO. Le seul module qui se rapproche de ce que je cherche est un module qui enregistrer l'IP du client lorsqu'il passe commande et qui l'inscrit dans un champ en bas de la fiche de commande (voir ci-dessous case entouré en rose : Lorsqu'on clique : "Cliquez ici pour ajouter un commentaire ou envoyer un message au client", le message saisi n'apparrait pas dans la commande mais dans les messages clients, même si ce dernier n'est pas visible des clients. J'aimerais pouvoir par exemple que mon commentaire s'affiche au même endroit que l'IP. Est-ce que quelqu'un connaît un moyen de faire cela ou meme un module ? merci d'avance Edited April 9, 2014 by decome2013 (see edit history) Link to comment Share on other sites More sharing options...
decome2013 Posted April 9, 2014 Author Share Posted April 9, 2014 ptit up Link to comment Share on other sites More sharing options...
telyweb Posted April 29, 2014 Share Posted April 29, 2014 je rencontre exactement le même problème cette fonction était bien présente en natif dans presta 1.4 et la dans 1.5.6 j'ai le message qui ne s'affiche pas dans les messages de la commande en back office Link to comment Share on other sites More sharing options...
telyweb Posted April 29, 2014 Share Posted April 29, 2014 la solution dans le fichier message.php présent dans classe changer la fonction getMessagesByOrderId ligne 91 par public static function getMessagesByOrderId($id_order, $private = false, Context $context = null) { if (!Validate::isBool($private)) die(Tools::displayError()); if (!$context) $context = Context::getContext(); $m = Db::getInstance()->executeS(' SELECT m.*, c.`firstname` AS cfirstname, c.`lastname` AS clastname, e.`firstname` AS efirstname, e.`lastname` AS elastname, (COUNT(mr.id_message) = 0 AND m.id_customer != 0) AS is_new_for_me FROM `'._DB_PREFIX_.'message` m LEFT JOIN `'._DB_PREFIX_.'customer` c ON m.`id_customer` = c.`id_customer` LEFT JOIN `'._DB_PREFIX_.'message_readed` mr ON mr.`id_message` = m.`id_message` AND mr.`id_employee` = '.(isset($context->employee) ? (int)$context->employee->id : '\'\'').' LEFT OUTER JOIN `'._DB_PREFIX_.'employee` e ON e.`id_employee` = m.`id_employee` WHERE m.`id_order` = '.(int)$id_order.' '.(!$private ? ' AND m.`private` = 0' : '').' GROUP BY m.id_message ORDER BY m.date_add DESC '); $o = Db::getInstance()->executeS(' SELECT ct.*, m.*, e.`firstname` AS efirstname, e.`lastname` AS elastname FROM `'._DB_PREFIX_.'customer_thread` ct LEFT JOIN `'._DB_PREFIX_.'customer_message` m ON m.`id_customer_thread` = ct.`id_customer_thread` LEFT OUTER JOIN `'._DB_PREFIX_.'employee` e ON e.`id_employee` = m.`id_employee` WHERE ct.`id_order` = '.(int)$id_order.' ORDER BY ct.`date_add` DESC' ); return array_merge($o,$m); } bonne continuation 1 Link to comment Share on other sites More sharing options...
Marmotte Posted July 24, 2014 Share Posted July 24, 2014 la solution dans le fichier message.php présent dans classe changer la fonction getMessagesByOrderId ligne 91 par public static function getMessagesByOrderId($id_order, $private = false, Context $context = null) { if (!Validate::isBool($private)) die(Tools::displayError()); if (!$context) $context = Context::getContext(); $m = Db::getInstance()->executeS(' SELECT m.*, c.`firstname` AS cfirstname, c.`lastname` AS clastname, e.`firstname` AS efirstname, e.`lastname` AS elastname, (COUNT(mr.id_message) = 0 AND m.id_customer != 0) AS is_new_for_me FROM `'._DB_PREFIX_.'message` m LEFT JOIN `'._DB_PREFIX_.'customer` c ON m.`id_customer` = c.`id_customer` LEFT JOIN `'._DB_PREFIX_.'message_readed` mr ON mr.`id_message` = m.`id_message` AND mr.`id_employee` = '.(isset($context->employee) ? (int)$context->employee->id : '\'\'').' LEFT OUTER JOIN `'._DB_PREFIX_.'employee` e ON e.`id_employee` = m.`id_employee` WHERE m.`id_order` = '.(int)$id_order.' '.(!$private ? ' AND m.`private` = 0' : '').' GROUP BY m.id_message ORDER BY m.date_add DESC '); $o = Db::getInstance()->executeS(' SELECT ct.*, m.*, e.`firstname` AS efirstname, e.`lastname` AS elastname FROM `'._DB_PREFIX_.'customer_thread` ct LEFT JOIN `'._DB_PREFIX_.'customer_message` m ON m.`id_customer_thread` = ct.`id_customer_thread` LEFT OUTER JOIN `'._DB_PREFIX_.'employee` e ON e.`id_employee` = m.`id_employee` WHERE ct.`id_order` = '.(int)$id_order.' ORDER BY ct.`date_add` DESC' ); return array_merge($o,$m); } bonne continuation C'est génial, c'est exactement ce que je cherchais... Merci beaucoup !!! Link to comment Share on other sites More sharing options...
schibinet Posted February 22, 2016 Share Posted February 22, 2016 la solution dans le fichier message.php présent dans classe changer la fonction getMessagesByOrderId ligne 91 par public static function getMessagesByOrderId($id_order, $private = false, Context $context = null) { if (!Validate::isBool($private)) die(Tools::displayError()); if (!$context) $context = Context::getContext(); $m = Db::getInstance()->executeS(' SELECT m.*, c.`firstname` AS cfirstname, c.`lastname` AS clastname, e.`firstname` AS efirstname, e.`lastname` AS elastname, (COUNT(mr.id_message) = 0 AND m.id_customer != 0) AS is_new_for_me FROM `'._DB_PREFIX_.'message` m LEFT JOIN `'._DB_PREFIX_.'customer` c ON m.`id_customer` = c.`id_customer` LEFT JOIN `'._DB_PREFIX_.'message_readed` mr ON mr.`id_message` = m.`id_message` AND mr.`id_employee` = '.(isset($context->employee) ? (int)$context->employee->id : '\'\'').' LEFT OUTER JOIN `'._DB_PREFIX_.'employee` e ON e.`id_employee` = m.`id_employee` WHERE m.`id_order` = '.(int)$id_order.' '.(!$private ? ' AND m.`private` = 0' : '').' GROUP BY m.id_message ORDER BY m.date_add DESC '); $o = Db::getInstance()->executeS(' SELECT ct.*, m.*, e.`firstname` AS efirstname, e.`lastname` AS elastname FROM `'._DB_PREFIX_.'customer_thread` ct LEFT JOIN `'._DB_PREFIX_.'customer_message` m ON m.`id_customer_thread` = ct.`id_customer_thread` LEFT OUTER JOIN `'._DB_PREFIX_.'employee` e ON e.`id_employee` = m.`id_employee` WHERE ct.`id_order` = '.(int)$id_order.' ORDER BY ct.`date_add` DESC' ); return array_merge($o,$m); } bonne continuation Bonjour, Merci beaucoup fonctionne très bien sur 1.6.0.6 et 1.6.0.9 - juste l'ordre des messages ajoutés n'est pas très logique mais se suive bien - Beaucoup plus simple pour travailler. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now