| | |
| | | */ |
| | | public function getEstimateCommission($user_id,$time_type,$is_own) |
| | | { |
| | | $info = Db::name('jingdong_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('jingdong_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',[16,17,18])->find(); |
| | | return $info; |
| | | } |
| | | |
| | |
| | | 'pay_month' => $order['pay_month'], |
| | | 'create_time' => time() |
| | | ]; |
| | | |
| | | // dump(2222);exit; |
| | | $save_data[] = $tmp_1; |
| | | // $push_data[] = [ |
| | | // 'user' => $user, |