西部数码主机 | 阿里云主机| 虚拟主机 | 服务器 | 返回乐道官网
当前位置: 主页 > php教程 > magento教程 >

Magento查询订单和该笔总的qty查询语句

时间:2016-01-02 03:28来源:未知 作者:好模板 点击:次
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 custome
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;
(责任编辑：好模板)
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
栏目列表
热点内容
随机内容
随机模板
CopyRight © 2010-2023 乐道主机 All Rights Reserved.