| | |
| | | */ |
| | | 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; |
| | | } |
| | | |