tl/app/api/controller/user/UserExtractController.php

<?php

namespace app\api\controller\user;

use app\admin\model\system\SystemConfig;
use app\models\store\StoreOrder;
use app\models\tree\Tree;
use app\models\user\User;
use app\models\user\UserBill;
use app\models\user\UserExtract;
use app\models\user\UserTransfer;
use app\Request;
use crmeb\services\UtilService;

/**
 * 提现类
 * Class UserExtractController
 * @package app\api\controller\user
 */
class UserExtractController
{
    /**
     * 提现银行
     * @param Request $request
     * @return mixed
     */
    public function bank(Request $request)
    {
        $user = $request->user();
        $broken_time = intval(sys_config('extract_time'));
        $search_time = time() - 86400 * $broken_time;
        //可提现佣金
        //返佣 +
        $brokerage_commission = UserBill::where(['uid' => $user['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
            ->where('add_time', '>', $search_time)
            ->where('pm', 1)
            ->sum('number');
        //退款退的佣金 -
        $refund_commission = UserBill::where(['uid' => $user['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
            ->where('add_time', '>', $search_time)
            ->where('pm', 0)
            ->sum('number');
        $data['broken_commission'] = bcsub($brokerage_commission, $refund_commission, 2);
        if ($data['broken_commission'] < 0)
            $data['broken_commission'] = 0;
//        return $data;
        $data['brokerage_price'] = $user['brokerage_price'];
        //可提现佣金
        $data['commissionCount'] = $data['brokerage_price'] - $data['broken_commission'];
        $extractBank = sys_config('user_extract_bank') ?? []; //提现银行
        $extractBank = str_replace("\r\n", "\n", $extractBank);//防止不兼容
        $data['extractBank'] = explode("\n", is_array($extractBank) ? (isset($extractBank[0]) ? $extractBank[0] : $extractBank) : $extractBank);
        $data['minPrice'] = sys_config('user_extract_min_price');//提现最低金额
        $data['commission'] = sys_config('commission', 10);//提现手续费
        return app('json')->successful($data);
    }

    /**
     * 提现申请
     * @param Request $request
     * @return mixed
     */
    public function cash(Request $request)
    {
        $extractInfo = UtilService::postMore([
            ['alipay_code', ''],
            ['extract_type', ''],
            ['money', 0],
            ['name', ''],
            ['bankname', ''],
            ['cardnum', ''],
            ['weixin', ''],
            ['balance_type', 0],
        ], $request);

        $uids = User::where('spread_uid', $request->user()['uid'])->column('uid');
        if (Tree::where('uid', 'in', $uids)->count() < 1) {
            return app('json')->fail('需要直推一人购买才能提现');
        }

        if (!preg_match('/^(([1-9][0-9]*)|(([0]\.\d{1,2}|[1-9][0-9]*\.\d{1,2})))$/', $extractInfo['money'])) return app('json')->fail('提现金额输入有误');
        //提现设置最低金额
        if ($extractInfo['money'] < sys_config('user_extract_min_price')) return app('json')->fail('金额小于最低提现金额');
        $user = $request->user();
        $broken_time = intval(sys_config('extract_time'));
        $search_time = time() - 86400 * $broken_time;
        //可提现佣金
        //返佣 +
        $brokerage_commission = UserBill::where(['uid' => $user['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
            ->where('add_time', '>', $search_time)
            ->where('pm', 1)
            ->sum('number');
        //退款退的佣金 -
        $refund_commission = UserBill::where(['uid' => $user['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
            ->where('add_time', '>', $search_time)
            ->where('pm', 0)
            ->sum('number');
        $data['broken_commission'] = bcsub($brokerage_commission, $refund_commission, 2);
        if ($data['broken_commission'] < 0)
            $data['broken_commission'] = 0;
        $data['brokerage_price'] = $user['brokerage_price'];
        //可提现佣金
        $commissionCount = $data['brokerage_price'] - $data['broken_commission'];
        if ($extractInfo['money'] > $commissionCount) return app('json')->fail('可提现佣金不足');
        /*
        if (!$extractInfo['cardnum'] == '')
            if (!preg_match('/^([1-9]{1})(\d{14}|\d{18})$/', $extractInfo['cardnum']))
                return app('json')->fail('银行卡号输入有误');*/
        if (UserExtract::userExtract($request->user(), $extractInfo))
            return app('json')->successful('申请提现成功!');
        else
            return app('json')->fail(UserExtract::getErrorInfo('提现失败'));
    }

    /**
     * 余额转账
     * @param Request $request
     */
    public function transfer(Request $request)
    {
        list($to_uid, $pass, $merber, $type) = UtilService::postMore([
            ['to_uid', ''],
            ['pass', ''],
            ['merber', 0],
            ['type', 0],
        ], $request, true);
        if (!User::be(['uid' => $to_uid])) return app('json')->fail('用户不存在');
        if (strlen($pass) != 6) return app('json')->fail('交易密码只能输入6位数字');
        $user = $request->user();
        $money = $user['now_money'];
        $in = "转出余额";
        $out = "转入余额";
        $field = "now_money";
        if ($type == 1) {
            $money = $user['consume'];
            $in = "转入钻石";
            $out = "转出钻石";
            $field = "consume";
        }
        if (md5(md5($user['salt'] . $pass) . $user['salt']) != $user['transaction']) return app('json')->fail('交易密码错误');
        if (bcsub($money, $merber, 2) >= 0) {
            $user = User::where('uid', $request->uid())->lock(true)->find();
            User::where('uid', $request->uid())->dec($field, $merber)->update();
            $touser = User::where('uid', $to_uid)->find();
            User::where('uid', $to_uid)->inc($field, $merber)->update();
            $data['uid'] = $request->uid();
            $data['touid'] = $touser['uid'];
            $data['money'] = $merber;
            $data['order_id'] = UserTransfer::getNewOrderId();
            $data['add_time'] = time();
            $data['type'] = $type;
            $data['paid'] = 1;
            UserTransfer::create($data);
            UserBill::expend($out, $request->uid(), 'now_money', 'transfer_out', $merber, 0, bcsub($user['now_money'], $merber, 2), '转给' . $touser['nickname'] . "用户", 1);
            UserBill::income($in, $touser['uid'], 'now_money', 'transfer_in', $merber, 0, bcadd($touser['now_money'], $merber, 2), '收到用户' . $user['uid'] . '转账号');
            return app('json')->successful('转账成功!');
        } else {
            return app('json')->fail($out . '不足');
        }
    }

    /**
     * 转账记录
     * @param Request $request
     */
    public function transfer_list(Request $request)
    {
        list($page, $limit, $pm, $type) = UtilService::postMore([
            ['page', 1],
            ['limit', 20],
            ['pm', 0],
            ['type', 0]
        ], $request, true);
        if ($pm == 0) {
            $count = UserTransfer::where('uid', $request->uid())->where('type', $type)->count();
            $data = UserTransfer::where('uid', $request->uid())->where('type', $type)->page($page, $limit)->order("id desc")->select();
            foreach ($data as &$v) {
                $v['to_user'] = User::where('uid', $v['touid'])->value('nickname');
                $v['_add_time'] = date("Y-m-d H:i:s", $v['add_time']);
            }
        } else {
            $count = UserTransfer::where('touid', $request->uid())->where('type', $type)->count();
            $data = UserTransfer::where('touid', $request->uid())->where('type', $type)->page($page, $limit)->order("id desc")->select();
            foreach ($data as &$v) {
                $v['to_user'] = User::where('uid', $v['uid'])->value('nickname');
                $v['_add_time'] = date("Y-m-d H:i:s", $v['add_time']);
            }
        }
        return app('json')->successful(compact('count', 'data'));
    }
}