Foovince Posted June 23, 2015 Share Posted June 23, 2015 Hello, J'ai pensé a cette requetes pour retrouver tous les paniers abandonnés, qu'en pensez vous ? J'ai visiblement bien les bons paniers... SELECT * FROM ( SELECT CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) `customer`, a.id_cart total, ca.name carrier, IF (IFNULL(o.id_order, 'Non ordered') = 'Non ordered', IF(TIME_TO_SEC(TIMEDIFF('2015-06-23 13:44:00', a.`date_add`)) > 86400, 'Abandoned cart', 'Non ordered'), o.id_order) id_order, IF(o.id_order, 1, 0) badge_success, IF(o.id_order, 0, 1) badge_danger, IF(co.id_guest, 1, 0) id_guest FROM ps_cart a LEFT JOIN ps_customer c ON (c.id_customer = a.id_customer) LEFT JOIN ps_currency cu ON (cu.id_currency = a.id_currency) LEFT JOIN ps_carrier ca ON (ca.id_carrier = a.id_carrier) LEFT JOIN ps_orders o ON (o.id_cart = a.id_cart) LEFT JOIN `ps_connections` co ON (a.id_guest = co.id_guest AND TIME_TO_SEC(TIMEDIFF('2015-06-23 13:44:00', co.`date_add`)) < 1800) ) AS toto WHERE id_order='Abandoned cart' 1 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