field('id,avatar,nickname')->where('id',$this->auth->id)->find(); $wallet = Db::name('user_wallet')->field('intro_level')->where('user_id',$this->auth->id)->find(); //团队总业绩 $chuju = config('site.intro_chuju_min_money'); //下级 $list = Db::name('user_wallet')->alias('uw') ->field('user.id,user.nickname,user.avatar,uw.intro_level') ->join('user','uw.user_id = user.id','LEFT') ->where('uw.intro_uid',$this->auth->id) //我邀请的 ->where('uw.intro_level','neq','-1') //入金了 ->where('uw.intro_level','elt',$wallet['intro_level']) //等级比我低 // ->where('uw.money','lt',$chuju) //金额小于500,出局 ->select(); dump($list); $down_uids = array_column($list,'id'); //下下级 $list2 = Db::name('user_wallet')->alias('uw') ->field('user.id,user.nickname,user.avatar,uw.intro_level,intro.id as intro_id,intro.intro_level as kkk') ->join('user','uw.user_id = user.id','LEFT') ->join('user_wallet intro','uw.intro_uid = intro.user_id','LEFT') //加这里,就是防止:下下级当中,虽然都比我低,但是有可能高于自己的上级(也就是我的直推) ->whereIN('uw.intro_uid',$down_uids) //下下级 ->where('uw.intro_level','neq','-1') //入金了 ->where('uw.intro_level','elt',$wallet['intro_level']) //等级比我低 ->where('uw.intro_level <= intro.intro_level') //加这里,就是防止:下下级当中,虽然都比我低,但是有可能高于自己的上级(也就是我的直推) ->select(false); dump($list2); $down_down_uids = array_column($list2,'id'); // $this->success('success',$list); } //我的分销余额日志 public function my_intromoney_log(){ $type = input('type',0); $map = [ 'user_id' => $this->auth->id, ]; if($type == 1){ $map['change_value'] = ['gt',0]; } if($type == 2){ $map['change_value'] = ['lt',0]; } $list = Db::name('user_intromoney_log') ->field('id,log_type,before,change_value,remain,remark,createtime') ->where($map)->order('id desc')->autopage()->select(); // $list = $this->list_appen_logtext($list); $this->success('success',$list); } //提现配置 public function take_cash_config(){ $plat_bilv = config('site.intro_takecash_plat_bili'); $take_cash_days = config('site.intro_takecash_days'); $take_cash_days_str = implode(',',$take_cash_days); $data = [ 'intromoney' => model('wallet')->getwallet($this->auth->id,'intromoney'), 'plat_bilv' => $plat_bilv, 'user_bank' => Db::name('user_bank')->where('user_id',$this->auth->id)->find(), 'take_cash_days' => $take_cash_days_str, 'remark' => '每月'.$take_cash_days_str.'日可以提现', 'take_cash_button' => in_array(date('d'),$take_cash_days) ? 1 : 0, ]; $this->success('success',$data); } //提现before public function take_cash_before(){ $freemoney = input('freemoney',0); if(!$freemoney){ $this->error('请填写金额'); } $money = floatval($freemoney); if($money<=0) { $this->error('金额必须大于0'); } $min = config('site.intro_takecash_min_money'); $max = config('site.intro_takecash_max_money'); if($money < $min){ $this->error('提现金额不能小于'.$min); } if($money > $max){ $this->error('提现金额不能大于'.$max); } $user_money = model('wallet')->getwallet($this->auth->id,'intromoney'); if($money > $user_money){ $this->error('提现金额不能大于可提现余额'); } //平台手续费 $plat_bilv = config('site.intro_takecash_plat_bili'); $plat_money = bcdiv(bcmul($money,$plat_bilv,2),100,2); //减去手续费,得实得金额 $get_money = bcsub($money,$plat_money,2); $data = [ 'money' => $money, 'plat_bilv' => $plat_bilv, 'plat_money' => $plat_money, 'get_money' => $get_money, ]; $this->success(1,$data); } //提现 public function take_cash(){ $freemoney = input('freemoney',0); // $type = input('type',1); $type = 2; if(!$freemoney){ $this->error('请填写金额'); } if (!in_array($type,[1,2,3])) { $this->error('未知的提现类型'); } //提现日期限制 $take_cash_days = config('site.intro_takecash_days'); if(!in_array(date('d'),$take_cash_days)){ $take_cash_days_str = implode(',',$take_cash_days); $this->error('每月'.$take_cash_days_str.'日才可以提现'); } //赋值money /*if($rc_id){ $recharge_config = Db::name('take_cash_config')->where('id',$rc_id)->find(); $money = $recharge_config['money'] ?: 0; }*/ //自由输入覆盖 if(!empty($freemoney)){ $rc_id = 0; $money = floatval($freemoney); } // if($money<=0) { $this->error('金额必须大于0'); } $min = config('site.intro_takecash_min_money'); $max = config('site.intro_takecash_max_money'); if($money < $min){ $this->error('提现金额不能小于'.$min); } if($money > $max){ $this->error('提现金额不能大于'.$max); } $check = Db::name('intro_user_take_cash')->where(['user_id'=>$this->auth->id,'status'=>0])->find(); if($check){ $this->error('您已经申请了提现,请等待审核'); } $user_money = model('wallet')->getwallet($this->auth->id,'intromoney'); if($money > $user_money){ $this->error('提现金额不能大于可提现余额'); } if($type == 1){ $table_name = 'user_alipay'; $account_json = Db::name($table_name)->where('user_id',$this->auth->id)->find(); if(empty($account_json)){ $this->error('未绑定对应的提现账号'); } }elseif($type == 2){ $table_name = 'user_bank'; $account_json = Db::name($table_name)->where('user_id',$this->auth->id)->find(); if(empty($account_json)){ $this->error('未绑定对应的提现账号'); } }elseif($type == 3){ //微信支付 $table_name = 'user_wechat'; $account_json = Db::name($table_name)->where('user_id',$this->auth->id)->find(); if(empty($account_json)){ $this->error('未绑定对应的提现账号'); } } //平台手续费 $plat_bilv = config('site.intro_takecash_plat_bili'); $plat_money = bcdiv(bcmul($money,$plat_bilv,2),100,2); //减去手续费,得实得金额 $get_money = bcsub($money,$plat_money,2); $data = [ 'user_id' => $this->auth->id, 'money' => $money, 'plat_bilv' => $plat_bilv, 'plat_money' => $plat_money, 'get_money' => $get_money, 'type' => $type, 'acount_json' => json_encode($account_json), 'createtime' => time(), 'updatetime' => time(), 'status' => 0, ]; Db::startTrans(); $log_id = Db::name('intro_user_take_cash')->insertGetId($data); if(!$log_id){ Db::rollback(); $this->error('提现失败'); } //扣除money $rs_wallet = model('Wallet')->lockChangeAccountRemain($this->auth->id,'intromoney',-$money,121,'提现(审核中)','intro_user_take_cash',$log_id); if($rs_wallet['status']===false) { Db::rollback(); $this->error($rs_wallet['msg']); } Db::commit(); $this->success('申请成功请等待审核'); } //提现记录 public function take_cash_log(){ $list = Db::name('intro_user_take_cash')->field('id,money,get_money,type,createtime,status')->where(['user_id'=>$this->auth->id])->autopage()->select(); foreach($list as $key => &$val){ $val['remark'] = ''; if($val['type'] == 1){ $val['remark'] = '支付宝提现'; }elseif($val['type'] == 2){ $val['remark'] = '银行卡提现'; }else{ $val['remark'] = '微信提现'; } } $this->success('success',$list); } }