zhaojs
2023-07-12 87940848162256b5adaa125408b297dba3e8691b
application/api/logic/commission/Wph.php
@@ -27,7 +27,7 @@
     */
    public function getEstimateCommission($user_id,$time_type,$is_own)
    {
        $info = Db::name('vip_order_commission')->field("COUNT(id) as order_num,COALESCE(SUM(pub_share_pre_fee),0) as money,COALESCE(SUM(alipay_total_price),0) as sales_volume,'唯品会' as name")->where(['member_id'=>$user_id,'is_own'=>$is_own])->whereTime('tb_paid_time', $time_type)->find();
        $info = Db::name('vip_order_commission')->field("COUNT(id) as order_num,COALESCE(SUM(pub_share_pre_fee),0) as money,COALESCE(SUM(alipay_total_price),0) as sales_volume,'唯品会' as name")->where(['member_id'=>$user_id,'is_own'=>$is_own])->whereTime('tb_paid_time', $time_type)->whereIn('tk_status',['已付款','已签收','待结算','已结算'])->find();
        return $info;
    }