| | |
| | | */ |
| | | public function getEstimateCommission($user_id,$time_type,$is_own) |
| | | { |
| | | $info = Db::name('douyin_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('douyin_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',[1,2])->find(); |
| | | return $info; |
| | | } |
| | | |