Skip to content

Instantly share code, notes, and snippets.

@Hotfirenet

Hotfirenet/prestashop_order_day_by_day.sql

Created October 2, 2017 08:15
Show Gist options
  • Save Hotfirenet/2a763da6deef8566b94a8e59b2183ad8 to your computer and use it in GitHub Desktop.
Save Hotfirenet/2a763da6deef8566b94a8e59b2183ad8 to your computer and use it in GitHub Desktop.
Download ZIP
Cette requête sql permet de connaitre le nombre de commande et le chiffre d'affaire TTC par jour et par paiement
Raw
prestashop_order_day_by_day.sql
SELECT COUNT(id_order) AS nbOrder
, SUM(total_paid_tax_incl) AS 'CA_TTC'
, DATE(date_add) AS 'Date'
, payment
FROM ps_orders
WHERE YEAR(date_add) = 2017
GROUP BY DATE(date_add), payment
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment