wangdu_public_api/app/Modules/Finance/Models/Payment.php

<?php
/**
 * Created by PhpStorm.
 * User: tandunzhao
 * Date: 2017/11/17
 * Time: 下午4:38
 */

namespace App\Modules\Finance\Models;

use Illuminate\Database\Eloquent\Model;

/**
 * Class Payment 打款表
 * @package App\Modules\Finance\Models
 */
class Payment extends Model
{
    protected $table = 'payments';
    protected $fillable = ['withdraw_cash_id', 'amount', 'amount_person', 'remark','pay_time', 'pay_merchant_source', 'trade_no', 'status', 'is_company', 'pay_merchant_source_msg', 'pay_merchant_source_result'];


    /**
     * 保存打款信息
     * @param $withdraw_cash_id
     * @param $amount
     * @param $remark
     * @param $pay_merchant_source 支付渠道
     * @param $trade_no 交易流水号
     * @param $status 打款状态
     * @param $pay_merchant_source_msg 支付通道返回信息
     * @param int $is_company 0:私人； 1:公司
     * @param int $amount_person 人工打款金额
     * @return mixed
     */
    public static function addPayment($withdraw_cash_id, $amount, $remark, $pay_merchant_source, $trade_no, $status, $pay_merchant_source_msg, $is_company = 0, $amount_person = 0) {
        $dataPayment['withdraw_cash_id'] = $withdraw_cash_id;
        $dataPayment['amount'] = $amount;
        $dataPayment['remark'] = $remark;
        $dataPayment['pay_time'] = date('Y-m-d H:i:s');
        $dataPayment['pay_merchant_source'] = $pay_merchant_source;
        $dataPayment['trade_no'] = $trade_no;
        $dataPayment['status'] = $status;
        $dataPayment['pay_merchant_source_msg'] = $pay_merchant_source_msg;
        $dataPayment['is_company'] = $is_company;
        $dataPayment['amount_person'] = $amount_person;
        $payment = Payment::create($dataPayment);

        return $payment;
    }

    /**
     * 更新打款状态
     * @param $id
     * @param $status
     * @param $pay_merchant_source_msg
     * @param $pay_merchant_source_result
     * @return mixed
     */
    public static function updatePaymentStatus($id, $status = '', $pay_merchant_source_msg, $pay_merchant_source_result) {
        $dataPayment = self::find($id);
        if(!empty($dataPayment)) {
            if($status) {
                $dataPayment['status'] = $status;
            }
            $dataPayment['pay_merchant_source_msg'] = $pay_merchant_source_msg;
            $dataPayment['pay_merchant_source_result'] = $pay_merchant_source_result;
            $dataPayment = $dataPayment->save();
        }

        return $dataPayment;
    }

    /**
     * 获取打款列表
     * @param $withdraw_cash_id
     * @param string $start_date
     * @param string $end_date
     * @param string $status
     * @param bool $is_all
     * @return mixed
     */
    static function getList($withdraw_cash_id, $start_date='',$end_date='', $status = '', $is_all=false) {
        $search_object = self::orderBy('pay_time','desc');

        if($withdraw_cash_id) {
            $search_object->where('withdraw_cash_id', $withdraw_cash_id);
        }
        if($start_date) $search_object->where('pay_time','>=',$start_date);
        if($end_date) $search_object->where('pay_time','<=',$end_date);

        if($status) {
            $search_object->where('status',$status);
        }

        if($is_all)
        {
            return $search_object->get();
        }else{
            return $search_object->paginate();
        }
    }

    /**
     * 更新打款状态
     * @param $id
     * @param $status
     * @return mixed
     */
    public static function updateSimplePaymentStatus($id, $status)
    {
        return self::where('id', $id)->update(['status' => $status]);
    }

    /**
     * 打款详情列表
     * @param array $params[]
     *                  withdraw_cash_id : 提现ID
     *                  channel_id:渠道ID 可选
     *                  channel_name:渠道名称 可选
     *                  account_name: 打款人姓名
     *                  start_date:开始时间 可选
     *                  end_date:结束时间 可选
     *                  end_date:结束时间 可选
     *                  search_name: 搜索名称
     *                  status: 状态 查看接口 WithdrawCashService::getWithdrawCashStatusList
     * @return mixed
     */
    static function getListDetail($params=[]) {
        $search_object = self::select([
            'payments.id',
            'payments.withdraw_cash_id as cash_id',
            'payments.amount',
            'payments.amount_person',
            'payments.pay_time',
            'payments.pay_merchant_source',
            'payments.trade_no',
            'payments.status as payments_status',
            'payments.is_company',
            'payments.pay_merchant_source_result',
            'payments.pay_merchant_source_msg',
            'withdraw_cashes.distribution_channel_id as channel_id',
            'withdraw_cashes.distribution_channel_name as channel_name',
            'withdraw_cashes.status as wc_status',
            'withdraw_cashes.remark',
            'withdraw_cashes.check_user_id',
            'withdraw_cashes.check_user_name',
            'withdraw_cashes.amount as withdraw_cashes_amount',
            'withdraw_cashes.tallage as withdraw_cashes_tallage',
            'cash_accounts.account_name',
            'cash_accounts.identity_card',
            'cash_accounts.card_number',
            'cash_accounts.account_bank',
            'cash_accounts.bank',
            'cash_accounts.province',
            'cash_accounts.status as ca_status '
        ])
            ->leftjoin('withdraw_cashes','withdraw_cashes.id','=','payments.withdraw_cash_id')
            ->leftjoin('cash_accounts','cash_accounts.distribution_channel_id','=','withdraw_cashes.distribution_channel_id')
            ->orderBy('payments.id','desc');


        if(isset($params['withdraw_cash_id']) && $params['withdraw_cash_id']) $search_object->where('payments.withdraw_cash_id', $params['withdraw_cash_id']);

        if(isset($params['channel_id']) && $params['channel_id']) $search_object->where('withdraw_cashes.distribution_channel_id', $params['channel_id']);

        if(isset($params['search_name']) && $params['search_name']) {
            $search_object->where(function ($query) use($params) {
                $query->where('withdraw_cashes.distribution_channel_name','like', "%".$params['search_name']."%")
                    ->orWhere('cash_accounts.account_name', 'like', "%".$params['search_name']."%");
            });
        }

        if(isset($params['channel_name']) && $params['channel_name']) $search_object->where('withdraw_cashes.distribution_channel_name','like', "%".$params['channel_name']."%");
        if(isset($params['account_name']) && $params['account_name']) $search_object->where('cash_accounts.account_name', 'like', "%".$params['account_name']."%");

        if(isset($params['start_date']) && $params['start_date']) $search_object->where('payments.pay_time','>=', $params['start_date']);
        if(isset($params['end_date']) && $params['end_date']) $search_object->where('payments.pay_time','<=', $params['end_date']);

        if(isset($params['is_company']) && is_numeric($params['is_company'])) $search_object->where('payments.is_company', $params['is_company']);

        if(isset($params['status']) && $params['status']) {
            $search_object->whereIn('withdraw_cashes.status', $params['status']);
        }
        return $search_object->paginate();
    }
}