30) { $this->error('账号姓名1-30位'); } if ($banknumber === '' || iconv_strlen($banknumber, 'utf-8') > 50) { $this->error('账号1-50位'); } if ($bankname === '' || iconv_strlen($bankname, 'utf-8') > 50) { $this->error('银行名称1-50位'); } //添加 $count = Db::name('user_bank')->where(['user_id' => $this->auth->id])->count('id'); if ($count) { $this->error('您已经拥有该类型账号,不能再添加'); } $data['user_id'] = $this->auth->id; $data['realname'] = $realname; $data['banknumber'] = $banknumber; $data['bankname'] = $bankname; $data['createtime'] = time(); $rs = Db::name('user_bank')->insertGetId($data); if (!$rs) { $this->error('添加失败'); } $this->success('添加成功'); } //提现账号编辑 public function bankedit(){ $id = input('id', 0, 'intval'); //账号id $realname = input('realname', '', 'trim'); //账户真实姓名 $banknumber = input('banknumber', '', 'trim'); //卡号或账号 $bankname = input('bankname', '', 'trim'); //银行名称 if ($realname === '' || iconv_strlen($realname, 'utf-8') > 30) { $this->error('账号姓名1-30位'); } if ($banknumber === '' || iconv_strlen($banknumber, 'utf-8') > 50) { $this->error('账号1-50位'); } if ($bankname === '' || iconv_strlen($bankname, 'utf-8') > 50) { $this->error('银行名称1-50位'); } //查询账号是否存在 $info = Db::name('user_bank')->where(['id' => $id, 'user_id' => $this->auth->id])->find(); if (!$info) { $this->error('账号不存在'); } $data['realname'] = $realname; $data['banknumber'] = $banknumber; $data['bankname'] = $bankname; $data['updatetime'] = time(); $rs = Db::name('user_bank')->where(['id' => $id])->update($data); if ($rs === false) { $this->error('修改失败'); } $this->success('修改成功'); } //提现账号信息 public function bankinfo() { $info = Db::name('user_bank')->where(['user_id' => $this->auth->id])->find(); if (!$info) { $info = (object)[]; } $this->success('账户信息', $info); } //提现 public function moneywithdraw() { $id = input('id', 0, 'intval'); //提现账号id $money = input('money', '', 'trim'); if (!$id) { $this->error('请选择提现账号'); } $bankinfo = Db::name('user_bank')->where(['id' => $id, 'user_id' => $this->auth->id])->find(); if (!$bankinfo) { $this->error('账号不存在'); } if (!preg_match('/^[0-9]+(.[0-9]{1,8})?$/', $money) || $money <= 0) { $this->error('请输入正确提现金额'); } //余额查询 $user_money = model('wallet')->getWallet($this->auth->id,'money'); if ($user_money < $money) { $this->error('余额不足'); } //查询最低最高提现金额 $min_withdrawal_money = config('site.min_withdrawal_money') ? config('site.min_withdrawal_money') : 1; $max_withdrawal_money = config('site.max_withdrawal_money') ? config('site.max_withdrawal_money') : 50000; if ($money < $min_withdrawal_money) { $this->error('最低提现金额' . $min_withdrawal_money . '元'); } if ($money > $max_withdrawal_money) { $this->error('最高提现金额' . $max_withdrawal_money . '元'); } //查询提现手续费百分比 $withdrawal_service_fee = (int)config('site.withdrawal_service_fee') ? : 0; if ($withdrawal_service_fee < 0 || $withdrawal_service_fee >= 100) { $this->error('提现手续费异常'); } $real_money = bcdiv(bcmul($money,bcsub(100,$withdrawal_service_fee)),100); $data['order_no'] = createUniqueNo('T',$this->auth->id); $data['user_id'] = $this->auth->id; $data['amount'] = $money; $data['money'] = $real_money; $data['user_bank_id'] = $id; $data['realname'] = $bankinfo['realname']; $data['banknumber'] = $bankinfo['banknumber']; $data['bankname'] = $bankinfo['bankname']; $data['status'] = 0; $data['createtime'] = time(); //开启事务 Db::startTrans(); //添加提现记录 $log_id = Db::name('user_withdraw')->insertGetId($data); if (!$log_id) { Db::rollback(); $this->error('申请提现失败'); } $rs_wallet = model('wallet')->lockChangeAccountRemain($this->auth->id,'money',$money,4,'提现','user_withdraw',$log_id); if ($rs_wallet['status'] == false) { $this->error($rs_wallet['msg']); Db::rollback(); } Db::commit(); $this->success('申请提现成功,请等待审核'); } //用户钱包流水 public function moneylog(){ $list = Db::name('user_money_log')->field('id,change_value,log_type,createtime')->where('user_id',$this->auth->id)->page($this->page,$this->listrow)->select(); foreach($list as $key => &$val){ $val['log_type_text'] = model('wallet')->getlogtype($val['log_type']); } $this->success('success',$list); } }