Magento 查询订单和该笔总的qty

最新推荐文章于 2018-12-28 11:21:18 发布

学习笔记666

最新推荐文章于 2018-12-28 11:21:18 发布

阅读量608

点赞数

本文链接：https://blog.csdn.net/github_26672553/article/details/50352283

版权

SELECT main_table.increment_id, main_table.created_at,main_table.base_grand_total,main_table.`status`,
customer_table.email,
SUM(qty_ordered) AS total_qty_ordered
FROM sales_flat_order_grid AS main_table
LEFT JOIN customer_entity AS customer_table ON main_table.customer_id = customer_table.entity_id
LEFT JOIN sales_flat_order_item AS item_table ON item_table.order_id= main_table.entity_id
WHERE item_table.product_type='simple' #简单类型产品(如果不知道会包含可配置产品,这样就和Magento后台展示的不一致了)
AND main_table.created_at >= '2015-03-16' #时间范围
AND main_table.created_at < '2015-12-18' #时间范围
AND (main_table.status = 'processing' OR main_table.status = 'complete') #限制订单状态
AND customer_table.email NOT IN ('qq@gmail.com') #排除某个email账号的订单 
GROUP BY main_table.increment_id #按照订单分组
ORDER BY `main_table`.increment_id DESC;