【小编推荐】人人商城获取订单数量

根据openid获取所有订单

$orderobj  = pdo_fetchall('select O.id,O.status,O.openid,OG.total from  ims_ewei_shop_order as O left join ims_ewei_shop_order_goods as OG on O.id=OG.orderid  where  O.openid = "'. $_W['openid'] .'" and O.status=3 ');  

根据openid获取订单总数（商品总件数）

    
$ordernumberobj = pdo_fetch('select sum(OG.total) as tatal from  ims_ewei_shop_order as O left join ims_ewei_shop_order_goods as OG on O.id=OG.orderid  where  O.openid = "'. $_W['openid'] .'" and O.status=3 ');   

//获取自己下一级用户的所有件数，比如 查找3号用户的所有下级用户的订单
$yijisuoyou = pdo_fetchall('SELECT 
    O.openid,
    SUM(OG.total) AS total,
    O.status,
    M1.id AS member_id,
    M1.nickname
FROM 
    ims_ewei_shop_order AS O  
JOIN 
    ims_ewei_shop_order_goods AS OG ON O.id = OG.orderid  
LEFT JOIN 
    ims_ewei_shop_member AS M ON O.agentid = M.id
LEFT JOIN 
    ims_ewei_shop_member AS M1 ON O.openid = M1.openid   
WHERE 
    O.agentid = 3 AND O.status = 3
GROUP BY 
    O.openid, O.status, M.id; ');  
  
   print_r($yijisuoyou);  

输出结果：
Array
(
    [0] => Array
        (
            [openid] => sns_wa_ocKVy7VF04r0N_77FTSSZF9_7wwE
            [total] => 1
            [status] => 3
            [member_id] => 7
            [nickname] => Q
        )

    [1] => Array
        (
            [openid] => sns_wa_ocKVy7WhFT8Y1s8PMR6eAN_BghxE
            [total] => 2
            [status] => 3
            [member_id] => 4
            [nickname] => 梁国芳
        )

)

获取指定用户的 订单数，使用  in查询，方便查询 多人的订单数

//获取指定用户所有的订单数
$yijisuoyou = pdo_fetchall('SELECT 
    O.openid,
    SUM(OG.total) AS total,
    O.status,
    M1.id AS member_id,
    M1.nickname
FROM 
    ims_ewei_shop_order AS O  
JOIN 
    ims_ewei_shop_order_goods AS OG ON O.id = OG.orderid  

LEFT JOIN 
    ims_ewei_shop_member AS M1 ON O.openid = M1.openid   
WHERE 
    O.openid in("sns_wa_")   AND O.status = 3
GROUP BY 
    O.openid, O.status, M1.id; ');  
  
  print_r($yijisuoyou);  

根据openid获取到 用户的所有订单信息

   echo $suoyouxiaji= $this->gesuoyouxiaji(3);
     
     
//获取指定用户所有的订单数 'sns_wa_ocKVy7WhFT8Y1s8PMR6eAN_BghxE','sns_wa_ocKVy7VF04r0N_77FTSSZF9_7wwE','sns_wa_','sns_wa_ooJx85Tk-cNPceICJRmsqsoQmkTU','sns_wa_orCaR4vPRRn5zTI-y_jWCTeOEs34','sns_wa_ocKVy7bDty-XebzaKNWedX8nq7i8
$yijisuoyou = pdo_fetchall('SELECT 
    O.openid,
    SUM(OG.total) AS total,
    O.status,
    M1.id AS member_id,
    M1.nickname
FROM 
    ims_ewei_shop_order AS O  
JOIN 
    ims_ewei_shop_order_goods AS OG ON O.id = OG.orderid  

LEFT JOIN 
    ims_ewei_shop_member AS M1 ON O.openid = M1.openid   
WHERE 
    O.openid in('.$suoyouxiaji.')   AND O.status = 3
GROUP BY 
    O.openid, O.status, M1.id; ');  
  
  print_r($yijisuoyou);   

结果如下：


    [0] => Array
        (
            [openid] => sns_wa_
            [total] => 19
            [status] => 3
            [member_id] => 5
            [nickname] => 
        )

    [1] => Array
        (
            [openid] => sns_wa_ocKVy7VF04r0N_77FTSSZF9_7wwE
            [total] => 1
            [status] => 3
            [member_id] => 7
            [nickname] => Q
        )

    [2] => Array
        (
            [openid] => sns_wa_ocKVy7WhFT8Y1s8PMR6eAN_BghxE
            [total] => 2
            [status] => 3
            [member_id] => 4
            [nickname] => 梁国芳
        )
如果要输出  所有用户的 所有订单 。去掉 GROUP BY 
    O.openid, O.status, M1.id; 即可