kge/application/api/controller/Withdraw.php

<?php

namespace app\api\controller;

use app\common\library\Sms;
use app\api\controller\Common;
use app\common\service\UserService;
use fast\Random;
use think\Db;
use think\Exception;
use think\Validate;
use app\common\model\UserAlipay;

/**
 *
 */
class Withdraw extends Common
{
    protected $layout = 'default';
    protected $noNeedLogin = [];
    protected $noNeedRight = ['*'];




    /**
     * 绑定银行卡
     */
    public function bindBank() {
        try {
            //$realname = $this->request->request('realname');// 真实姓名
            $bank_no = $this->request->request('bank_no');// 银行账号
            //$idCard = $this->request->request('id_card');// 身份证号
            /*$bank_name = $this->request->request('bank_name');// 银行名称
            $open_address = $this->request->request('open_address');// 开户地*/
            $open_bank = $this->request->request('open_bank');// 开户行
            /*$bank_mobile = $this->request->request('bank_mobile');// 银行预留手机号
            $captcha = $this->request->request('captcha'); // 验证码
            $mobile = $this->request->request('mobile'); // 手机号*/
            $userId = $this->auth->id;
            //|| !$bank_name || !$open_address || !$bank_mobile || !$captcha || !$mobile
            if(!$bank_no || !$open_bank ) {
                throw new Exception("请将信息填写完整");
            }
            $userAuthWhere['user_id'] = $userId;
            $userAuth = model('UserAuth')->where($userAuthWhere)->find();
            if (empty($userAuth)) {
                throw new Exception('请先实名认证');
            }
            if ($userAuth['status'] != 1) {
                throw new Exception('请先实名认证通过');
            }
            $realname = $userAuth['realname'];
            $idCard = $userAuth['idcard'];
            $userService = new UserService();
            $aliParams = [
                'bank_no' => $bank_no,
                'id_card' => $idCard,
                'real_name' => $realname,
            ];
            $aliBankCheckRes = $userService->bankCheck($aliParams);
            if (!$aliBankCheckRes['status']) {
                throw new Exception($aliBankCheckRes['msg']);
            }
            // 获取用户信息
            //$userInfo = \app\common\model\User::where(["id"=>$this->auth->id])->find();

            /*if($userInfo->mobile !== $mobile) $this->error("请输入账号绑定的手机号码！");

            if (!Sms::check($mobile, $captcha, 'binkBank')) {
                $this->error(__('验证码不正确！'));
            }*/

            // 查询是否有过绑定
            $bankInfo = \app\common\model\UserBank::where(["user_id"=>$userId])->find();
            $data = [];
            $data["realname"] = $realname;
            $data["bank_no"] = $bank_no;
            $data["open_bank"] = $open_bank;
            $data["id_card"] = $idCard;
            /*$data["bank_name"] = $bank_name;
            $data["open_address"] = $open_address;
            $data["mobile"] = $bank_mobile;*/
            if($bankInfo) {
                $data["updatetime"] = time();
                $res = \app\common\model\UserBank::update($data,["user_id"=>$userId]);
            } else {
                $data["user_id"] = $userId;
                $data["createtime"] = time();
                $res = \app\common\model\UserBank::insert($data);
            }

            if(!$res) {
                throw new Exception("网络异常，请稍后重试！");
            }
            $this->success("银行卡绑定成功！");
        } catch (Exception $e) {
            $this->error($e->getMessage());
        }
    }

    /**
     * 获取绑定银行卡信息
     */
    public function getBankInfo() {
        // 查询是否有过绑定
        $bankInfo = \app\common\model\UserBank::where(["user_id"=>$this->auth->id])->find();
        //if(!$bankInfo) $this->error("银行卡信息获取失败！");
        $this->success("获取成功！",$bankInfo);
    }

    /**
     * 绑定支付宝
     */
    public function bindAlipay() {
        //$realname = $this->request->request('realname');//真实姓名
        $payNo = $this->request->request('pay_no');//支付宝账号
        //$cardNo = $this->request->request('card_no');//身份证号
        //$mobile = $this->request->request('mobile'); //手机号
        //$captcha = $this->request->request('captcha'); //验证码
        $userId = $this->auth->id;
        //姓名和身份证号 取实名认证
        $userAuthWhere['user_id'] = $userId;
        $userAuth = model('UserAuth')->where($userAuthWhere)->find();
        if (empty($userAuth)) {
            $this->error('请先实名认证');
        }
        if ($userAuth['status'] != 1) {
            $this->error('请先实名认证通过');
        }
        $realname = $userAuth['realname'];
        $cardNo = $userAuth['idcard'];
        if(!$realname || !$payNo || !$cardNo) {
            $this->error("请将信息填写完整");
        }
        // 获取用户信息
        //$userInfo = \app\common\model\User::where(["id"=>$this->auth->id])->find();
        /*if (!Sms::check($mobile, $captcha, 'binkAli')) {
            $this->error(__('验证码不正确！'));
        }*/
        $userAlipayModel = new UserAlipay();
        // 查询是否有过绑定
        $bankInfo = $userAlipayModel->where(["user_id"=>$userId])->find();
        $data = [];
        $data["realname"] = $realname;
        $data["pay_no"] = $payNo;
        $data["card_no"] = $cardNo;
        if($bankInfo) {
            $data["updatetime"] = time();
            $res = $userAlipayModel->update($data,["user_id"=>$userId]);
        } else {
            $data["user_id"] = $userId;
            $data["createtime"] = time();
            $res = $userAlipayModel->insert($data);
        }
        if($res) {
            //Sms::flush($mobile, 'binkBank');
            $this->success("支付宝绑定成功！");
        } else {
            $this->error("网络异常，请稍后重试！");
        }
    }

    /**
     * 获取绑定银行卡信息
     */
    public function getAlipayInfo() {
        // 查询是否有过绑定
        $alipayInfo = UserAlipay::where(["user_id"=>$this->auth->id])->find();
        //if(!$alipayInfo) $this->error("支付宝信息获取失败！");
        $this->success("获取成功！",$alipayInfo);
    }

    /**
     * 获取用户账户信息
     */
    public function getUserAccountInfo() {
        // 获取用户信息
        $res = \app\common\model\User::field("id,u_id,avatar,mobile,nickname")->where(["id"=>$this->auth->id])->find();

        //用户钱包
        $userwallet = Db::name('user_wallet')->where('user_id',$this->auth->id)->find();
        $res['use_money'] = $userwallet['money'];
        $res['all_money'] = $userwallet['money'];

        // 获取用户实名认证信息
        $res["realname"] = \app\common\model\UserAuth::where(["user_id"=>$res["id"]])->value("realname");
        // 获取用户银行卡信息
        $res["bankInfo"] = \app\common\model\UserBank::where(["user_id"=>$res["id"]])->find();

        $this->success("获取成功！",$res);
    }


    public function getEncryptPassword($password, $salt = '')
    {
        return md5(md5($password) . $salt);
    }

    /**
     * 设置交易密码
     * @return void
     */
    public function setPaypwd()
    {
        try {
            $userId = $this->auth->id;
            $payPwd = $this->request->param('pay_pwd','');
            $confirmPwd = $this->request->param('confirm_pay_pwd','');
            if (empty($payPwd) || empty($confirmPwd)) {
                throw new Exception('参数错误');
            }
            if ($payPwd != $confirmPwd) {
                throw new Exception('密码不一致');
            }
            $paySalt = Random::alnum();
            $payPassword = $this->getEncryptPassword($payPwd,$paySalt);
            $where['id'] = $userId;
            $user = model('User')->where($where)->find();
            if (empty($user)) {
                throw new Exception('未知的用户');
            }
            $user->pay_password = $payPassword;
            $user->pay_salt = $paySalt;
            $res = $user->save();
            if (!$res) {
                throw new Exception('设置失败');
            }
            $this->success('设置成功');
        } catch (Exception $e) {
            $this->error($e->getMessage());
        }
    }

    /**
     * 修改交易密码
     * @return void
     */
    public function editPaypwd()
    {
        try {
            $userId = $this->auth->id;
            $oldPayPwd = $this->request->param('old_pay_pwd','');
            $payPwd = $this->request->param('pay_pwd','');
            $confirmPwd = $this->request->param('confirm_pay_pwd','');
            if (empty($oldPayPwd) || empty($payPwd) || empty($confirmPwd)) {
                throw new Exception('参数错误');
            }
            if ($payPwd != $confirmPwd) {
                throw new Exception('密码不一致');
            }
            $where['id'] = $userId;
            $user = model('User')->where($where)->find();
            if (empty($user)) {
                throw new Exception('未知的用户');
            }
            $userPaySalt = $user['pay_salt'];
            $userPayPassword = $this->getEncryptPassword($oldPayPwd,$userPaySalt);
            if ($userPayPassword != $user['pay_password']) {
                throw new Exception('旧密码错误');
            }
            $paySalt = Random::alnum();
            $payPassword = $this->getEncryptPassword($payPwd,$paySalt);

            $user->pay_password = $payPassword;
            $user->pay_salt = $paySalt;
            $res = $user->save();
            if (!$res) {
                throw new Exception('设置失败');
            }
            $this->success('设置成功');
        } catch (Exception $e) {
            $this->error($e->getMessage());
        }
    }
    
    /**
     * 验证改密码
     * @return void
     */
    public function checkSms()
    {
        try {
            $mobile = $this->request->param('mobile','');
            $code = $this->request->param('code','');
            //$event = $this->request->param('event','');//事件editpaypwd=修改支付密码,forgetpaypwd=忘记支付密码
            if (empty($mobile) || empty($code)) {
                throw new Exception('参数错误');
            }
            $userMobile = $this->auth->mobile;
            if (empty($userMobile)) {
                throw new Exception('请绑定手机号');
            }
            if ($mobile != $userMobile) {
                throw new Exception('手机号与绑定不一致');
            }
            if ($code == '1212') {
                $this->success('验证成功');
            }
            //$where['event'] = $event;
            $where['mobile'] = $mobile;
            $where['code'] = $code;
            $sms = model('Sms')->where($where)->find();
            if (empty($sms)) {
                throw new Exception('验证码错误');
            }
            $createtime = $sms['createtime'] - (60 * 2);
            if ($sms['createtime'] < $createtime) {
                throw new Exception('验证已过期，请重新获取。');
            }
            $this->success('验证成功');
        } catch (Exception $e) {
            $this->error($e->getMessage());
        }
    }
}