wangdu_public_api/app/Modules/Finance/Services/WithdrawCashService.php

<?php

/**
 * Created by PhpStorm.
 * User: tandunzhao
 * Date: 2017/12/2
 * Time: 下午3:34
 */

namespace App\Modules\Finance\Services;

use App\Modules\Channel\Services\ChannelService;
use App\Modules\Finance\Models\FinancialPayMerchantBalance;
use App\Modules\Finance\Models\FinancialStat;
use App\Modules\Finance\Models\WithdrawCash;
use App\Modules\Manage\Services\ManageService;
use App\Modules\User\Services\UserService;
use DB;

class WithdrawCashService
{

    /**
     * 自动提现
     * @param unknown_type $request
     */
    public static function auto_add_withdrawCash($distribution_channel_id, $amount, $remark)
    {
        $distribution_channel_name = '';

        if (!is_numeric($amount)) {
            return response()->error("PARAM_ERROR");
        }
        if ($amount < 100) {
            //TODO 渠道14，取消100 金额的判断 大于1一块钱就可以
            if ($distribution_channel_id == 14 || $distribution_channel_id = "14" || $distribution_channel_id = '14') {
                if ($amount < 1) {
                    return response()->error("WITHDRAW_CASH_AMOUNT");
                }
            } else {
                return response()->error("WITHDRAW_CASH_AMOUNT");
            }
        }
        if ($amount >= (20 * 10000)) {
            //TODO 取消单笔提现额度限制
            //return response()->error("WITHDRAW_CASH_AMOUNT_MORE");
        }

        $financialStat = FinancialStatService::getFinancialStatSingle($distribution_channel_id);
        if (empty($financialStat) || $financialStat['enable_withdrawal_amount'] < $amount) {
            //可提现金额不够
            return response()->error("WITHDRAW_CASH_AMOUNT_INSUFFICIEN");
        }

        if (FinancialConfigService::isFrozenDistributionChannel($distribution_channel_id)) {
            //渠道被冻结
            return response()->error("WITHDRAW_CASH_AMOUNT_FROZEN");
        }

        //判断账户是否设置
        if (!CashAccountService::isCashAccountExits($distribution_channel_id)) {
            return response()->error("WITHDRAW_CASH_AMOUNT_ACCOUNT");
        }

        //判断今天是否已经提现
        if (WithdrawCashService::isWithdrawCashChannelToToday($distribution_channel_id)) {
            return response()->error("WITHDRAW_CASH_TODAY_USE");
        }
        $is_company = 0;
        $cashAccount = CashAccountService::getCashAccountSingle($distribution_channel_id);
        if (!empty($cashAccount)) {
            $is_company = $cashAccount['is_company'];
        }
        //一次提现不得超过一个公司主体最大充值金额
        /*$enable_by_company = FinancialPayMerchantBalanceService::getChannelEnableWithdraw($distribution_channel_id,$is_company);
        if(!$enable_by_company){
            return response()->error('WITHDRAW_CASH_AMOUNT_INSUFFICIEN');
        }
        $enable_amount = $enable_by_company->enable_withdrawal_amount;
        if($enable_amount<$amount){
            return ['code'=>101010,'msg'=>'本次最多可提现:'.$enable_amount];
        }*/
        $enable_by_companys = FinancialPayMerchantBalanceService::getChannelEnableWithdrawByCompanyId($distribution_channel_id);
        \Log::info('distribution_channel_id:' . $distribution_channel_id . 'amount:' . $amount);
        \Log::info('distribution_channel_id:' . $distribution_channel_id . 'enable:' . json_encode($enable_by_companys));

        DB::beginTransaction();
        try {
            foreach ($enable_by_companys as $enable_by_company) {
                $with_draw_amount = ($enable_by_company->enable_withdrawal_amount >= $amount) ? $amount : $enable_by_company->enable_withdrawal_amount;
                $pay_company_id = $enable_by_company->pay_merchant_company_id;
                WithdrawCashService::addWithdrawCash($distribution_channel_id, $with_draw_amount, $remark, $pay_company_id);

                $financialStatUp = FinancialStatService::updateFinancialStatByWithdraw($distribution_channel_id, $with_draw_amount);
                FinancialPayMerchantBalanceService::updateBalanceByWithdraw($with_draw_amount, $distribution_channel_id, $pay_company_id);
                $amount = $amount - $with_draw_amount;
                //部分通道公司只能对公打款
                if ($is_company == 0 && in_array($pay_company_id, explode(',', env('ZW_COMPANY_IDS')))) {
                    DB::rollBack();
                    return response()->error('NOT_ALLOWED_PRIVATE_ACCOUNT');
                }
                if ($amount <= 0) {
                    break;
                }
            }
        } catch (\Exception $e) {
            DB::rollBack();
            \Log::error('withdraw error !' . ($e->getMessage()));
            return response()->error('WITHDRAW_CASHES_FAILED');
        }
        DB::commit();
        //修改可提现总额
        $enable_amount = $financialStatUp['enable_withdrawal_amount'];
        //修改提现中金额
        $withdraw_pending_amount = $financialStatUp['withdraw_pending_amount'];

        return response()->success(compact('enable_amount', 'withdraw_pending_amount'));
    }

    /**
     * 保存提现信息
     * @param $channelId 渠道ID
     * @param $amount 提现金额
     * @param $remark 备注
     * @return mixed
     */
    public static function addWithdrawCash($channelId, $amount, $remark, $pay_company_id)
    {
        $tallage = FinanceService::getWithdrawCashTallage($channelId, $amount);
        $is_company = 0;
        $channelName = ChannelService::getChannelNicknameById($channelId);
        $cashAccount = CashAccountService::getCashAccountSingle($channelId);
        if (!empty($cashAccount)) {
            $is_company = $cashAccount['is_company'];
            $dataWithdrawCash['account_bank'] = $cashAccount->account_bank;
            $dataWithdrawCash['bank_account'] = $cashAccount->card_number;
            $dataWithdrawCash['account_name'] = $cashAccount->account_name;
        }
        $dataWithdrawCash['distribution_channel_id'] = $channelId;
        $dataWithdrawCash['distribution_channel_name'] = $channelName;
        $dataWithdrawCash['amount'] = $amount;
        $dataWithdrawCash['tallage'] = $tallage;
        $dataWithdrawCash['status'] = self::getWithdrawCashStatusStr(0);
        $dataWithdrawCash['remark'] = $remark;
        $dataWithdrawCash['is_company'] = $is_company;
        $dataWithdrawCash['pay_merchant_company_id'] = $pay_company_id;
        $withdrawCash = WithdrawCash::create($dataWithdrawCash);
        return $withdrawCash;
    }

    /**
     * 更新提现信息状态
     * @param $id
     * @param $userId
     * @param $statusIn 状态 查看接口 WithdrawCashService::getWithdrawCashStatusList
     * @param $remark
     * @param string $serialNumber
     * @return mixed
     */
    public static function updateWithdrawCashStatus($id, $userId = '', $statusIn, $remark = '', $serialNumber = '')
    {
        //TODO 对于一个提现记录只有一条打款是没有Bug的。
        //TODO 一个提现记录对应多个支付通道打款，存在逻辑bug
        $withdrawCash = WithdrawCash::where('id', $id)->first();

        if (!empty($withdrawCash) && is_numeric($statusIn)) {

            if (WithdrawCashService::isWithdrawCashStatusPaymentIngStr($withdrawCash['status'])) {
                //当前状态是 打款中 可以修改状态
            } else {
                if (WithdrawCashService::isEditWithdrawCashStatus($id)) {
                    return $withdrawCash;
                }
            }
            $userName = "";
            if ($userId) {
                $manage = ManageService::getById($userId);
                if (!empty($manage)) {
                    $userName = $manage['nickname'];
                }
            }

            $statusStr = WithdrawCashService::getWithdrawCashStatusStr($statusIn);
            if (empty($statusStr)) {
            } else {
                if ($statusStr) {
                    $withdrawCash['status'] = $statusStr;
                }
            }
            if (WithdrawCashService::isWithdrawCashStatusCodeSuccess($statusIn)) {
                //成功提现

                $financialStat = FinancialStat::getByDistributionChannel($withdrawCash['distribution_channel_id']);
                //修改累计提现金额
                $financialStat['accumulative_withdrawal_amount'] = (float)$financialStat['accumulative_withdrawal_amount'] + (float)$withdrawCash['amount'];
                //修改提现中金额
                $financialStat['withdraw_pending_amount'] = (float)$financialStat['withdraw_pending_amount'] - (float)$withdrawCash['amount'];
                $financialStat->save();
                //
                $financePayMerchantBalanceInfo = FinancialPayMerchantBalance::getOne($withdrawCash['distribution_channel_id'], $withdrawCash['pay_merchant_company_id']);
                \Log::info('financePayMerchantBalanceInfo:channel_id:' . $withdrawCash['distribution_channel_id'] . 'pay_merchant_company_id:' . $withdrawCash['pay_merchant_company_id'] . json_encode($financePayMerchantBalanceInfo));
                //修改累计提现金额
                $financePayMerchantBalanceInfo->accumulative_withdrawal_amount = (float)$financePayMerchantBalanceInfo->accumulative_withdrawal_amount + (float)$withdrawCash['amount'];
                //修改提现中金额
                $financePayMerchantBalanceInfo->withdraw_pending_amount = (float)$financePayMerchantBalanceInfo->withdraw_pending_amount - (float)$withdrawCash['amount'];
                $financePayMerchantBalanceInfo->save();
            }
            if ($userId) {
                $withdrawCash['check_user_id'] = $userId;
            }
            if ($userName) {
                $withdrawCash['check_user_name'] = $userName;
            }
            if ($remark) {
                $withdrawCash['remark'] = $remark;
            }
            if ($serialNumber) {
                if (strpos($withdrawCash['serial_number'], $serialNumber) !== false) {
                    //包含
                } else {
                    $serialNumber = $withdrawCash['serial_number'] . "," . $serialNumber;
                }
                $withdrawCash['serial_number'] = $serialNumber;
            }
            $withdrawCash->save();
        }
        return $withdrawCash;
    }

    /**
     * 获取一个提现信息
     * @param $id
     * @return mixed
     */
    public static function getWithdrawCash($id)
    {
        $withdrawCash = WithdrawCash::where('id', $id)->first();
        return $withdrawCash;
    }


    /**
     * 获取提现列表
     * @param string $channel_id 可不传
     * @param string $channel_name 可不传
     * @param string $start_date 可不传
     * @param string $end_date 可不传
     * @param string $statusIn 状态 查看接口 WithdrawCashService::getWithdrawCashStatusList  可不传
     * @param bool $is_all 可不传
     * @return mixed
     */
    public static function getList($channel_id = '', $channel_name = '', $start_date = '', $end_date = '', $statusIn = '', $is_all = false)
    {
        $status = false;
        if (is_numeric($statusIn)) {
            $status = self::getWithdrawCashStatusStrList($statusIn);
        }
        return WithdrawCash::getListByDistributionChannel($channel_id, $channel_name, $start_date, $end_date, $status, $is_all);
    }

    /**
     * 财务对账
     * @param $params[]
     *                  channel_id:渠道ID 可选
     *                  channel_name:渠道名称 可选
     *                  account_name: 打款人姓名
     *                  search_name: 搜索名称
     *                  start_date:开始时间 可选
     *                  end_date:结束时间 可选
     *                  is_frozen:冻结  0:正常状态； -1:冻结状态 可选
     *                  is_company: 0:私人； 1:公司
     * @param string $statusIn 状态 查看接口 WithdrawCashService::getWithdrawCashStatusList  可不传
     * @param $isAll
     * @return mixed
     */
    public static function getFinancialCounting($params = [], $statusIn = '', $isAll = '')
    {
        if (is_numeric($statusIn)) {
            $params['status'] = self::getWithdrawCashStatusStrList($statusIn);
        }
        return WithdrawCash::getFinancialCountingParam($params, $isAll);
    }

    /**
     * 财务审核
     * @param $params[]
     *                  channel_id:渠道ID 可选
     *                  channel_name:渠道名称 可选
     *                  account_name: 打款人姓名
     *                  search_name: 搜索名称 可选
     *                  start_date:开始时间 可选
     *                  end_date:结束时间 可选
     *                  is_frozen:冻结  0:正常状态； -1:冻结状态 可选
     *                  is_company: 0:私人； 1:公司
     * @param string $statusIn 状态 查看接口 WithdrawCashService::getWithdrawCashStatusList  可不传
     * @param $isAll
     * @return mixed
     */
    public static function getFinancialAudit($params = [], $statusIn = '', $isAll = false)
    {
        if (is_numeric($statusIn)) {
            $params['status'] = self::getWithdrawCashStatusStrList($statusIn);
        }
        return WithdrawCash::getFinancialAuditParam($params, $isAll);
    }

    /**
     * 判断当前渠道今天有没有提现
     * @param $channelId
     * @return bool  true:今天已经提现
     */
    public static function isWithdrawCashChannelToToday($channelId)
    {
        $withdrawCash = WithdrawCash::getWithdrawCashLastRecord($channelId);
        if (empty($withdrawCash)) {
            return false;
        }
        $todayStart = strtotime(date('Y-m-d', time()) . ' 00:00:00');
        $createTime = strtotime($withdrawCash['created_at']);
        if ($createTime > $todayStart) {
            return true;
        }
        return false;
    }

    /**
     * 是否能修改提现状态
     * @param $withdrawCashId
     * @return bool true:不能修改
     */
    public static function isEditWithdrawCashStatus($withdrawCashId)
    {
        $withdrawCash = WithdrawCash::where('id', $withdrawCashId)->first();
        if (empty($withdrawCash)) {
            return false;
        }
        if (
            $withdrawCash['status'] == "打款中"
            || $withdrawCash['status'] == "自动打款中"
            || $withdrawCash['status'] == "人工打款中"
            || $withdrawCash['status'] == "打款成功"
            || $withdrawCash['status'] == "自动打款成功"
            || $withdrawCash['status'] == "人工打款成功"
        ) {
            return true;
        }
        return false;
    }

    /**
     * 判断当前提现记录是否 已打款  打款成功 状态
     * @param $withdrawCashId
     * @return bool true:已经打款 打款成功
     */
    public static function isWithdrawCashStatusSuccess($withdrawCashId)
    {
        $withdrawCash = WithdrawCash::where('id', $withdrawCashId)->first();
        if (empty($withdrawCash)) {
            return false;
        }
        if (
            $withdrawCash['status'] == "打款成功"
            || $withdrawCash['status'] == "自动打款成功"
            || $withdrawCash['status'] == "人工打款成功"
        ) {
            return true;
        }
        return false;
    }

    /**
     * 待打款状态
     * @param string $statusStr
     * @return bool
     */
    public static function isWithdrawCashStatusPaymentWaitStr($statusStr = '')
    {
        if (
            $statusStr == "待打款"
            || $statusStr == "自动待打款"
            || $statusStr == "人工待打款"
        ) {
            return true;
        }
        return false;
    }

    /**
     * 打款中状态
     * @param string $statusStr
     * @return bool
     */
    public static function isWithdrawCashStatusPaymentIngStr($statusStr = '')
    {
        if (
            $statusStr == "打款中"
            || $statusStr == "自动打款中"
            || $statusStr == "人工打款中"
        ) {
            return true;
        }
        return false;
    }

    /**
     * 成功打款Code
     * @param string $statusIn
     * @return bool
     */
    public static function isWithdrawCashStatusCodeSuccess($statusIn = '')
    {
        if ($statusIn == 30 || $statusIn == 31 || $statusIn == 32) {
            return true;
        }
        return false;
    }
    /**
     * 成功打款
     * @param string $statusStr
     * @return bool
     */
    public static function isWithdrawCashStatusStrSuccess($statusStr = '')
    {
        if (
            $statusStr == "打款成功"
            || $statusStr == "自动打款成功"
            || $statusStr == "人工打款成功"
        ) {
            return true;
        }
        return false;
    }

    /**
     * 获取成功和失败的状态
     * @return array
     */
    public static function getWithdrawCashStatusStrSuccessAndFailList()
    {
        $status = [];
        $status[] = "打款成功";
        $status[] = "自动打款成功";
        $status[] = "人工打款成功";
        $status[] = "打款失败";
        $status[] = "自动打款失败";
        $status[] = "人工打款失败";
        return $status;
    }

    /**
     * 获取 审核失败 打款成功 打款失败 状态
     * @return array
     */
    public static function getWithdrawCashStatusStrSuccessFailCheckedSuccessList()
    {
        $status = [];
        $status[] = "审核通过";
        $status[] = "审核不通过";
        $status[] = "待打款";
        $status[] = "自动待打款";
        $status[] = "人工待打款";
        $status[] = "打款中";
        $status[] = "自动打款中";
        $status[] = "人工打款中";
        $status[] = "打款成功";
        $status[] = "自动打款成功";
        $status[] = "人工打款成功";
        $status[] = "打款失败";
        $status[] = "自动打款失败";
        $status[] = "人工打款失败";
        return $status;
    }

    public static function getWithdrawCashStatusList($type)
    {
        if ($type == 10) {
            //channel
            $params = [
                ['code' => 0, 'name' => "待审核",        'show' => 1],
                //                ['code' => 1 ,'name' => "审核中",        'show' => 0],
                //                ['code' => 2 ,'name' => "审核通过",        'show' => 0],
                ['code' => 9, 'name' => "审核不通过",       'show' => 1],

                ['code' => 10, 'name' => "待打款",         'show' => 1],
                //                ['code' => 11,'name' => "自动待打款",      'show' => 0],
                //                ['code' => 13,'name' => "人工待打款",      'show' => 0],

                ['code' => 20, 'name' => "打款中",         'show' => 1],
                //                ['code' => 21,'name' => "自动打款中",      'show' => 0],
                //                ['code' => 22,'name' => "人工打款中",      'show' => 0],

                ['code' => 30, 'name' => "打款成功",       'show' => 1],
                //                ['code' => 31,'name' => "自动打款成功",    'show' => 0],
                //                ['code' => 32,'name' => "人工打款成功",    'show' => 0],

                ['code' => 40, 'name' => "打款失败",       'show' => 1],
                //                ['code' => 41,'name' => "自动打款失败",    'show' => 0],
                //                ['code' => 42,'name' => "人工打款失败",    'show' => 0],

                //                ['code' => -1,'name' => "其他错误",       'show' => 0],
            ];
            return $params;
        }
        if ($type == 20) {
            //manage
            $params = [
                ['code' => 0, 'name' => "待审核",        'show' => 1],
                ['code' => 1, 'name' => "审核中",        'show' => 0],
                ['code' => 2, 'name' => "审核通过",        'show' => 0],
                ['code' => 9, 'name' => "审核不通过",       'show' => 1],

                ['code' => 10, 'name' => "待打款",         'show' => 1],
                ['code' => 11, 'name' => "自动待打款",      'show' => 0],
                ['code' => 13, 'name' => "人工待打款",      'show' => 0],

                ['code' => 20, 'name' => "打款中",         'show' => 1],
                ['code' => 21, 'name' => "自动打款中",      'show' => 0],
                ['code' => 22, 'name' => "人工打款中",      'show' => 0],

                ['code' => 30, 'name' => "打款成功",       'show' => 1],
                ['code' => 31, 'name' => "自动打款成功",    'show' => 0],
                ['code' => 32, 'name' => "人工打款成功",    'show' => 0],

                ['code' => 40, 'name' => "打款失败",       'show' => 1],
                ['code' => 41, 'name' => "自动打款失败",    'show' => 0],
                ['code' => 42, 'name' => "人工打款失败",    'show' => 0],

                ['code' => -1, 'name' => "其他错误",       'show' => 0],
            ];
            return $params;
        }
    }

    public static function getWithdrawCashStatusStr($statusIn = '')
    {
        $status = '';
        if (is_numeric($statusIn)) {
            if ($statusIn == 0) {
                $status = "待审核";
            } else if ($statusIn == 1) {
                $status = "审核中";
            } else if ($statusIn == 2) {
                $status = "审核通过";
            } else if ($statusIn == 9) {
                $status = "审核不通过";
            } else if ($statusIn == 10) {
                $status = "待打款";
            } else if ($statusIn == 11) {
                $status = "自动待打款";
            } else if ($statusIn == 12) {
                $status = "人工待打款";
            } else if ($statusIn == 20) {
                $status = "打款中";
            } else if ($statusIn == 21) {
                $status = "自动打款中";
            } else if ($statusIn == 22) {
                $status = "人工打款中";
            } else if ($statusIn == 30) {
                $status = "打款成功";
            } else if ($statusIn == 31) {
                $status = "自动打款成功";
            } else if ($statusIn == 32) {
                $status = "人工打款成功";
            } else if ($statusIn == 40) {
                $status = "打款失败";
            } else if ($statusIn == 41) {
                $status = "自动打款失败";
            } else if ($statusIn == 42) {
                $status = "人工打款失败";
            } else if ($statusIn == -1) {
                $status = "其他错误";
            } else {
                $status = "";
            }
        }
        return $status;
    }

    public static function getWithdrawCashStatusStrList($statusIn = '')
    {
        $status = '';
        if (is_numeric($statusIn)) {
            $status = [];
            if ($statusIn == 0) {
                $status[] = "待审核";
            } else if ($statusIn == 1) {
                $status[] = "审核中";
            } else if ($statusIn == 2) {
                $status[] = "审核通过";
            } else if ($statusIn == 9) {
                $status[] = "审核不通过";
            } else if ($statusIn == 10) {
                $status[] = "待打款";
                $status[] = "自动待打款";
                $status[] = "人工待打款";
            } else if ($statusIn == 11) {
                $status[] = "自动待打款";
            } else if ($statusIn == 12) {
                $status[] = "人工待打款";
            } else if ($statusIn == 20) {
                $status[] = "打款中";
                $status[] = "自动打款中";
                $status[] = "人工打款中";
            } else if ($statusIn == 21) {
                $status[] = "自动打款中";
            } else if ($statusIn == 22) {
                $status[] = "人工打款中";
            } else if ($statusIn == 30) {
                $status[] = "打款成功";
                $status[] = "自动打款成功";
                $status[] = "人工打款成功";
            } else if ($statusIn == 31) {
                $status[] = "自动打款成功";
            } else if ($statusIn == 32) {
                $status[] = "人工打款成功";
            } else if ($statusIn == 40) {
                $status[] = "打款失败";
                $status[] = "自动打款失败";
                $status[] = "人工打款失败";
            } else if ($statusIn == 41) {
                $status[] = "自动打款失败";
            } else if ($statusIn == 42) {
                $status[] = "人工打款失败";
            } else if ($statusIn == -1) {
                $status[] = "其他错误";
            } else {
                $status[] = "未知错误码";
            }
        }
        return $status;
    }

    public static function updateWithdrawCashType($id, $param)
    {
        return WithdrawCash::where('id', $id)->update($param);
    }
}