zhuishuyun_quickapp/app/Http/Controllers/Manage/Finance/PaymentController.php

<?php
/**
 * Created by PhpStorm.
 * User: tandunzhao
 * Date: 2017/11/22
 * Time: 下午3:23
 */

namespace App\Http\Controllers\Manage\Finance;


use App\Http\Controllers\Manage\Finance\Transformers\PaymentDetailTransformer;
use App\Http\Controllers\Manage\Finance\Transformers\PaymentTransformer;
use App\Libs\PayHelper;
use App\Modules\Channel\Services\ChannelService;
use App\Modules\Finance\Models\FinanceMerchantStat;
use App\Modules\Finance\Models\LiquidatedStat;
use App\Modules\Finance\Services\CashAccountService;
use App\Modules\Finance\Services\FinanceMerchantStatService;
use App\Modules\Finance\Services\FinancialConfigService;
use App\Modules\Finance\Services\LiquidatedStatService;
use App\Modules\Finance\Services\PaymentService;
use App\Modules\Finance\Services\WithdrawCashService;
use Illuminate\Http\Request;
use DB;

class PaymentController extends BaseController
{

    /**
     * @apiDefine Finance 结算提现模块
     */


    /**
     * @apiVersion 1.0.0
     * @apiDescription 创建打款信息
     * @api {POST} addPayment 创建打款信息
     * @apiGroup Finance
     * @apiName addPayment
     * @apiParam   {Number}  withdraw_cash_id 提现id.
     * @apiParam   {Number}  amount 打款金额.
     * @apiParam   {String}  [remark] 备注说明.
     * @apiParam   {String}  [source] 打款通道[tl, ll].
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":{
     *              }
     *     }
     */
    function add_payment(Request $request) {
        $withdraw_cash_id = $request->has('withdraw_cash_id') ? $request->input('withdraw_cash_id') : '';
        if(!is_numeric($withdraw_cash_id)) {
            return response()->error("PARAM_ERROR");
        }
        $amount = $request->has('amount') ? $request->input('amount') : '';
        if(!is_numeric($amount) || (float)$amount <= 0) {
            return response()->error("PARAM_ERROR");
        }
//        $userId = $request->has('user_id') ? $request->input('user_id') : '';
//        if(!is_numeric($userId)) {
//            return response()->error("PARAM_ERROR");
//        }
        $userId = $this->getLoginUserId();

        $remark = $request->has('remark') ? $request->input('remark') : '';

        $withdrawCash = WithdrawCashService::getWithdrawCash($withdraw_cash_id);
        if(empty($withdrawCash)) {
            return response()->error("PARAM_ERROR");
        }
        //对公 走手动打款
        if($withdrawCash['is_company'] == 1) {
            return response()->error("PAYMENT_AUTO_NOT_OPEN");
        }
        //已打款，判断
        if(WithdrawCashService::isEditWithdrawCashStatus($withdraw_cash_id)) {
            return response()->error("PAYMENT_WITHDRAW_MONEY_TOO");
        }


        //判断打款钱核对   提现金额 - 手续费 = 实际打款金额
        $money = (float)$withdrawCash['amount'] - (float)$withdrawCash['tallage'];
        if($amount != $money) {
            return response()->error("PAYMENT_WITHDRAW_MONEY");
        }

        $channelId = $withdrawCash['distribution_channel_id'];
        //判断渠道是否冻结
        if(FinancialConfigService::isFrozenDistributionChannel($channelId)) {
            return response()->error("WITHDRAW_CASH_AMOUNT_FROZEN");
        }
        //判断账户是否已经设置
        if(!CashAccountService::isCashAccountExits($channelId)) {
            return response()->error("WITHDRAW_CASH_AMOUNT_ACCOUNT");
        }

        //TODO 先关闭自动打款
        if(!env('PAYMENT_AUTO_PAY_ON')) {
            return response()->error("PAYMENT_AUTO_NOT_OPEN");
        }

        $isTD = 0;

        $source = $request->has('source') ? $request->input('source') : '';
        if ("tl" == $source || "ll" == $source) {
            if("tl" == $source) {
                //通联支付通道账户
                $tonglianpayLiquidatedStatData = LiquidatedStatService::getLiquidatedStatSingleBySource(config('common.tonglianpay'));
                if(!empty($tonglianpayLiquidatedStatData) && $tonglianpayLiquidatedStatData['account_balance_amount_day'] > ($money - 1)) {
                    //判断通联支付通道钱余额大于 提现金额    需要算上每次 手续费 【1块钱】
                    $isTD = 2;
                }
            }
            if("ll" == $source) {
                //连连支付通道账户
                $lianlianpayLiquidatedStatData = LiquidatedStatService::getLiquidatedStatSingleBySource(config('common.lianlianpay'));
                if(!empty($lianlianpayLiquidatedStatData) && $lianlianpayLiquidatedStatData['account_balance_amount_day'] > ($money - 1)) {
                    //判断连连支付通道钱余额大于 提现金额    需要算上每次 手续费 【1块钱】
                    $isTD = 1;
                }
            }
        } else {
            //通联支付通道账户
            $tonglianpayLiquidatedStatData = LiquidatedStatService::getLiquidatedStatSingleBySource(config('common.tonglianpay'));
            if($isTD == 0) {
                //连连通道钱余额不走，判断通联
                if(!empty($tonglianpayLiquidatedStatData) && $tonglianpayLiquidatedStatData['account_balance_amount_day'] > ($money - 1)) {
                    //判断通联支付通道钱余额大于 提现金额    需要算上每次 手续费 【1块钱】
                    $isTD = 2;
                }
            }

            //连连支付通道账户
            $lianlianpayLiquidatedStatData = LiquidatedStatService::getLiquidatedStatSingleBySource(config('common.lianlianpay'));
            if($isTD == 0) {
                //默认看连连通道余额
                if(!empty($lianlianpayLiquidatedStatData) && $lianlianpayLiquidatedStatData['account_balance_amount_day'] > ($money - 1)) {
                    //判断连连支付通道钱余额大于 提现金额    需要算上每次 手续费 【1块钱】
                    $isTD = 1;
                }
            }
        }

        if($isTD == 0) {
            //连连支付通道，余额不足
            //通联支付通道，余额不足
            // 返回，支付通道余额不足，请走人工打款
            return response()->error("PAYMENT_CHANNEL_AMOUNT_WITHOUT");
        }

        //正式环境，线上为 2
        if(env('PAYMENT_AUTO_PAY_TEST') == 2) {
            if($isTD == 1) {
                //连连支付通道打款
                PaymentService::makeThreeSourcePayment($userId, $withdraw_cash_id, (float)$amount, $remark, $lianlianpayLiquidatedStatData);
                return response()->success();
            }
            if($isTD == 2) {
                //通连支付通道打款
                PaymentService::makeThreeSourcePayment($userId, $withdraw_cash_id, (float)$amount, $remark, $tonglianpayLiquidatedStatData);
                return response()->success();
            }
        } else {
            //测试环境直接修改状态为 成功
            $tradeNo = "测试_".$channelId;
            $pay_merchant_source = "测试";
            if($isTD == 1) {
                $pay_merchant_source = $lianlianpayLiquidatedStatData['pay_merchant_source'];
            }
            if($isTD == 2) {
                $pay_merchant_source = $tonglianpayLiquidatedStatData['pay_merchant_source'];
            }
            //测试环境，直接走逻辑打款成功
            $payment = PaymentService::addPayment($withdraw_cash_id, $amount, $remark, $pay_merchant_source, $tradeNo, WithdrawCashService::getWithdrawCashStatusStr(32), "测试", $withdrawCash['is_company'], 0);
            //更新单个第三方通道可打款金额
            FinanceMerchantStatService::createOrUpdate($channelId, $pay_merchant_source, -$amount);
            //更新当前渠道当天当前支付通道可打款余额
            LiquidatedStatService::updateAccountBalanceAmountDay($pay_merchant_source, -$amount);
            //修改状态
            WithdrawCashService::updateWithdrawCashStatus($withdraw_cash_id, $userId, 32, $remark, $tradeNo);

            return response()->success();
        }
        //其他，走人工打款
        return response()->error("PAYMENT_CHANNEL_AMOUNT_WITHOUT");
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 创建人工打款信息
     * @api {POST} addPaymentPersonMade 创建人工打款信息
     * @apiGroup Finance
     * @apiName addPaymentPersonMade
     * @apiParam   {Number}  withdraw_cash_id 提现id.
     * @apiParam   {Number}  amount_person 人工打款金额
     * @apiParam   {String}  trade_no 银行交易流水号.
     * @apiParam   {String}  [remark] 备注说明.
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":{
     *              }
     *     }
     */
    function add_paymentPersonMade(Request $request) {
        $withdraw_cash_id = $request->has('withdraw_cash_id') ? $request->input('withdraw_cash_id') : '';
        if(!is_numeric($withdraw_cash_id)) {
            return response()->error("PARAM_ERROR");
        }
//        $userId = $request->has('user_id') ? $request->input('user_id') : '';
//        if(!is_numeric($userId)) {
//            return response()->error("PARAM_ERROR");
//        }
        $userId = $this->getLoginUserId();

        $amount_person = $request->has('amount_person') ? $request->input('amount_person') : '';
        if(!is_numeric($amount_person)) {
            return response()->error("PARAM_ERROR");
        }

        $trade_no = $request->has('trade_no') ? $request->input('trade_no') : '';
        if(empty($trade_no)) {
            return response()->error("PARAM_ERROR");
        }
        $remark = $request->has('remark') ? $request->input('remark') : '';
        $remark = "[人工打款]{".$remark."}";

        $withdrawCash = WithdrawCashService::getWithdrawCash($withdraw_cash_id);
        if(empty($withdrawCash)) {
            return response()->error("PARAM_ERROR");
        }
        //已打款，判断
        if(WithdrawCashService::isWithdrawCashStatusSuccess($withdraw_cash_id)) {
            return response()->error("PAYMENT_WITHDRAW_MONEY_TOO");
        }
        $channelId = $withdrawCash['distribution_channel_id'];
        //判断渠道是否冻结
        if(FinancialConfigService::isFrozenDistributionChannel($channelId)) {
            return response()->error("ACCOUNT_FRONZEN");
        }

        //判断打款钱核对   提现金额 - 手续费 = 实际打款金额
        $amount = (float)$withdrawCash['amount'] - (float)$withdrawCash['tallage'];

        //人工打款成功
        //Payment 插入人工
        // WithdrawCashStatus
        // Liquidation 人工 判断渠道支付通道余额，分别生成
        // LiquidatedStat
        PaymentService::makePersonMadePayment($userId, $withdraw_cash_id, $amount, $remark, $trade_no, $amount_person);
        return response()->success();
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 打款列表
     * @api {GET} payments 打款列表
     * @apiGroup Finance
     * @apiName payments
     * @apiParam   {Number}  [withdraw_cash_id] 提现id.
     * @apiParam   {String}  [start_time] 开始时间(可不传)
     * @apiParam   {String}  [end_time] 结束时间(可不传)
     * @apiSuccess {Number}  id 打款 id.
     * @apiSuccess {Number}  withdraw_cash_id 提现 id.
     * @apiSuccess {Number}  amount 打款金额.
     * @apiSuccess {String}  remark 备注
     * @apiSuccess {String}  pay_time 打款时间
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":{
     *              "list": [
     *                      {
     *                          "id": 1,
     *                          "withdraw_cash_id": 1,
     *                          "amount": "1000.0000",
     *                          "remark": "dfsdfssd",
     *                          "pay_time": "2017-11-20 14:28:28"
     *                      }
     *                   ],
     *                     "meta": {
     *                           "total": 1,
     *                           "per_page": 15,
     *                           "current_page": 1,
     *                          "last_page": 1,
     *                          "next_page_url": "",
     *                          "prev_page_url": ""
     *                   }
     *              }
     *     }
     */
    function get_list(Request $request) {
        $withdraw_cash_id = $request->has('withdraw_cash_id') ? $request->input('withdraw_cash_id') : '';
        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? date('Ymd',strtotime($request->input('start_time'))) : '';
        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Ymd',strtotime($request->input('end_time'))) : '';
        $end_time = self::getMaxDay($end_time);

        $payments = PaymentService::getPaymentList($withdraw_cash_id, $start_time, $end_time);

        return response()->pagination(new PaymentTransformer(), $payments);
    }

    /**
     * @apiVersion 1.0.0
     * @apiDescription 打款列表详情
     * @api {GET} listPayments 打款列表详情
     * @apiGroup Finance
     * @apiName listPayments
     * @apiParam   {Number}  [withdraw_cash_id] 提现id.
     * @apiParam   {String}  [start_time] 开始时间(可不传)
     * @apiParam   {String}  [end_time] 结束时间(可不传)
     * @apiParam   {Number}  [distribution_channel_id] 渠道id.(可不传，获取所有渠道)
     * @apiParam   {String}  [distribution_channel_name] 渠道名称.(可不传，获取所有渠道)
     * @apiParam   {String}  [account_name] 账户名称
     * @apiParam   {String}  [search_name] 搜索名称
     * @apiParam   {Number}  [status] 状态 查看接口 api/getWithdrawCashStatus (可不传，获取所有状态)
     * @apiParam   {Number}  [is_company] 0:对私, 1:对公司.(可不传，获取所有渠道)
     * @apiSuccess {Number}  id 打款 id.
     * @apiSuccess {Number}  withdraw_cash_id 提现 id.
     * @apiSuccess {Number}  amount 打款金额.
     * @apiSuccess {String}  remark 备注
     * @apiSuccess {String}  pay_time 打款时间
     * @apiSuccess {Number}  channel_id 渠道ID
     * @apiSuccess {String}  channel_name 渠道名称
     * @apiSuccess {String}  status 打款状态
     * @apiSuccess {Number}  check_user_id 审核人ID
     * @apiSuccess {String}  check_user_name 审核人名称
     * @apiSuccess {String}  account_name 银行卡户主名称
     * @apiSuccess {String}  identity_card 银行卡户主身份证
     * @apiSuccess {String}  card_number 银行卡账号
     * @apiSuccess {String}  account_bank 银行支行
     * @apiSuccess {String}  bank 银行名称
     * @apiSuccess {String}  province 银行地址
     * @apiSuccessExample {json} Success-Response:
     *
     *     {
     *         "code": 0,
     *         "msg": "",
     *         "data":{
     *              "list": [
     *                      {
     *                           "id": 1,
     *                           "withdraw_cash_id": 1,
     *                           "amount": "1000.0000",
     *                           "pay_time": "2017-11-20 14:28:28",
     *                           "channel_id": 1,
     *                           "channel_name": "渠道一",
     *                           "status": "已打款",
     *                           "remark": "哈哈哈，有钱",
     *                           "check_user_id": 1,
     *                           "check_user_name": "张大妈",
     *                           "account_name": "宋晓",
     *                           "identity_card": "33038119930901821X",
     *                           "card_number": "6222520177654916",
     *                           "account_bank": "钱江支行",
     *                           "bank": "杭州银行",
     *                           "province": "北京市"
     *                      }
     *                   ],
     *                     "meta": {
     *                           "total": 1,
     *                           "per_page": 15,
     *                           "current_page": 1,
     *                          "last_page": 1,
     *                          "next_page_url": "",
     *                          "prev_page_url": ""
     *                   }
     *              }
     *     }
     */
    function get_listDetail(Request $request) {
        $distribution_channel_id = $request->has('distribution_channel_id') ? $request->input('distribution_channel_id') : '';
        $distribution_channel_name = $request->has('distribution_channel_name') ? $request->input('distribution_channel_name') : '';

        $withdraw_cash_id = $request->has('withdraw_cash_id') ? $request->input('withdraw_cash_id') : '';
        $start_time = $request->has('start_time') && !empty($request->input('start_time')) ? date('Ymd',strtotime($request->input('start_time'))) : '';
        $end_time = $request->has('end_time') && !empty($request->input('end_time')) ? date('Ymd',strtotime($request->input('end_time'))) : '';
        $end_time = self::getMaxDay($end_time);

        $account_name = $request->has('account_name') ? $request->input('account_name') : '';
        $search_name = $request->has('search_name') ? $request->input('search_name') : '';
        $status = $request->has('status') ? $request->input('status') : '';
        $is_company = $request->has('is_company') ? $request->input('is_company') : '';

        $params = [
            'withdraw_cash_id'=>$withdraw_cash_id,
            'channel_id'=>$distribution_channel_id,
            'channel_name'=>$distribution_channel_name,
            'start_date'=>$start_time,
            'end_date'=>$end_time,
            'account_name'=>$account_name,
            'search_name'=>$search_name,
            'is_company'=>$is_company,
        ];
        $payments = PaymentService::getPaymentDetailList($params, $status);

        return response()->pagination(new PaymentDetailTransformer(), $payments);
    }

    /**
     * 更新打款状态
     * id 条目id
     * status 状态(10：待打款)
     * @param Request $request
     * @return mixed
     */
    function updatePaymentStatus(Request $request)
    {
        $id = $request->has('id') ? $request->input('id') : '';
        // $status = $request->has('status') ? $request->input('status') : '';

        if (!$id) {
            return response()->error("PARAM_EMPTY");
        }

        $status = WithdrawCashService::getWithdrawCashStatusStr(10);
        $result = PaymentService::updateSimplePaymentStatus($id, $status);
        if ($result) {
            return response()->success();
        } else {
            return response()->error("HANDLE_FAILED");
        }
    }


    function test_add_payment(Request $request)
    {
        $payType = "ALLINPAY";




//        $transactionSerialNumber = date('YmdHis').mt_rand(10,99)."_1";
//        $bankCode = "102";
//        $bankName = '';
//        $bankAccountNO = "6222031202001646388";
//        $bankAccountName = "宋栋波";
//        $amount = 0.01;
//        $summary = "summary";
//        $remark = "remark";
//        $channelId = 1;
//        $isCompany = 0;
//        $resultPayData = PayHelper::pay($payType, $transactionSerialNumber, $bankCode, $bankName, $bankAccountNO, $bankAccountName, $amount, $summary, $remark, $channelId, $isCompany);
//        $resultDataMsg = $remark;
//        if(!empty($resultPayData) && !empty($resultPayData['msg'])) {
//            $resultDataMsg = $resultDataMsg."_【".$resultPayData['msg']."】";
//        }
//        dd($transactionSerialNumber);
////        dd($resultPayData);
//        if(!empty($resultPayData) && $resultPayData['code'] == 1) {
//            $reqSn = date('YmdHis').mt_rand(100000,999999);
//            $resultQueryData = PayHelper::payQuery($payType, $transactionSerialNumber, $reqSn);
//            if(!empty($resultQueryData) && !empty($resultQueryData['msg'])) {
//                $resultDataMsg = $resultDataMsg."_【".$resultQueryData['msg']."】";
//            }
//            if(!empty($resultQueryData) && $resultQueryData['code'] == 1) {
//            }
//        }
//        dd($resultDataMsg);


//        $transactionSerialNumber = '2017122511504564_1';
//        $resultDataMsg = '';
//        $reqSn = date('YmdHis').mt_rand(100000,999999);
//        $resultQueryData = PayHelper::payQuery($payType, $transactionSerialNumber, $reqSn);
//        if(!empty($resultQueryData) && !empty($resultQueryData['msg'])) {
//            $resultDataMsg = $resultDataMsg."_【".$resultQueryData['msg']."】";
//        }
//        if(!empty($resultQueryData) && $resultQueryData['code'] == 1) {
//        }
//        return response()->success($resultQueryData);


//        $reqSn = date('YmdHis').mt_rand(100000,999999);
//        $resultQueryData = PayHelper::payAccountInfo($payType, $reqSn);
//        return response()->success($resultQueryData);

//        $reqSn = date('YmdHis').mt_rand(100000,999999);
//        $startDay = date('Ymd', strtotime(date("Y-m-d")." -2 day"));
//        $endDay = date('Ymd');
//        $resultQueryData = PayHelper::payAccountHistoryBalanceAmount($payType, $reqSn, $startDay, $endDay);
//        return response()->success($resultQueryData);

//        dd(json_encode($resultQueryData));
//        dd($resultDataMsg);


//        $financeMerchantStat = new FinanceMerchantStat();
//        $financeMerchantStat['pay_merchant_source'] = "ALLINPAY";
//        $financeMerchantStat['distribution_channel_id'] = 1;
//        $withdraw_cash_id = 68;
//
//        PaymentService::makeThreeSourcePayment(1, $withdraw_cash_id, 0.01, "测试", $financeMerchantStat);






        $payType = "LIANLIANPAY";
//        $transactionSerialNumber = date('YmdHis').mt_rand(10,99)."_1";
//        $bankCode = "102";
//        $bankName = '';
//        $bankAccountNO = "6222031202001646388";
//        $bankAccountName = "宋栋波";
//        $amount = 0.01;
//        $summary = "summary";
//        $remark = "remark";
//        $channelId = 1;
//        $isCompany = 0;
//        $resultPayData = PayHelper::pay($payType, $transactionSerialNumber, $bankCode, $bankName, $bankAccountNO, $bankAccountName, $amount, $summary, $remark, $channelId, $isCompany);
//        $resultDataMsg = $remark;
//        if(!empty($resultPayData) && !empty($resultPayData['msg'])) {
//            $resultDataMsg = $resultDataMsg."_【".$resultPayData['msg']."】";
//        }
////        dd($transactionSerialNumber);
//        return response()->success($resultPayData);

//        $liquidatedStat = new LiquidatedStat();
//        $liquidatedStat['pay_merchant_source'] = $payType;
//        $withdraw_cash_id = 392;
//        PaymentService::makeThreeSourcePayment(1, $withdraw_cash_id, 1.09, "测试", $liquidatedStat);

//        $transactionSerialNumber = '2017122916450888_1';
//        $resultDataMsg = '';
//        $reqSn = date('YmdHis').mt_rand(100000,999999);
//        $resultQueryData = PayHelper::payQuery($payType, $transactionSerialNumber, $reqSn);
//        if(!empty($resultQueryData) && !empty($resultQueryData['msg'])) {
//            $resultDataMsg = $resultDataMsg."_【".$resultQueryData['msg']."】";
//        }
//        if(!empty($resultQueryData) && $resultQueryData['code'] == 1) {
//        }
//        return response()->success($resultQueryData);

//        $reqSn = date('YmdHis').mt_rand(100000,999999);
//        $resultQueryData = PayHelper::payAccountInfo($payType, $reqSn);
//        return response()->success($resultQueryData);

        return response()->success();
    }
}