mccs/app/models/order/PaymentReceived.php

<?php

namespace app\models\order;

use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;
use think\Exception;
use app\models\user\{User,UserBill};
use crmeb\services\PHPExcelService;
/**
 * B子订单详情
 * Class ArticleCategory
 * @package app\models\article
 */
class PaymentReceived  extends BaseModel
{
    use ModelTrait;
    protected function getTypeAttr($value)
    {
        switch($value)
        {
            case 0:
                return '余额';
                break;
            case 1:
                return '消费券';
                break;
            case 2:
                return '积分';
                break;
        }

    }
    /**
     * 生成订单唯一id
     * @param $uid 用户uid
     * @return string
     */
    public static function getNewOrderId()
    {
        list($msec, $sec) = explode(' ', microtime());
        $msectime = number_format((floatval($msec) + floatval($sec)) * 1000, 0, '', '');
        $orderId = 'qr_' . $msectime . mt_rand(10000, 99999);
        while (self::be(['order_id' => $orderId])) $orderId = 'qr_' . $msectime . mt_rand(10000, 99999);
        return $orderId;
    }

    /**
     * 创建支付
     * @param $pay_type
     * @param $code
     * @param $pay_uid
     * @param $collect_uid
     * @param $amount
     */
    public static function Create_Payment($pay_type,$code,$pay_uid,$collect_uid,$amount,$type=0)
    {
        self::beginTrans();
        $order_id = self::getNewOrderId();
        $add_time = time();
        $pay_user = User::find($pay_uid);
        $collect_user = User::find($collect_uid);
        try {
            switch ($type)
            {
                case 0:
                    $field ="now_money";
                    $title = "余额";
                    break;
                case 1:
                    $field ="consumer";
                    $title = "消费券";
                    break;
                case 2:
                    $field ="integral";
                    $title = "积分";
                    break;
            }
            if (bcsub($pay_user[$field], $amount, 2) < 0) return self::setErrorInfo($title.'不足!', true);
            $paid = 1;
            $pay_time = time();
            $transfer = bcdiv(bcmul($amount, sys_config('pay_collection_commission'),2),100,2);
            $service_charge = $transfer;
            $res = self::create(compact('pay_type', 'pay_uid', 'code', 'collect_uid', 'amount', 'order_id', 'add_time', 'paid', 'pay_time','service_charge','type'));
            if ($res) {
                $now_money = bcsub($amount, $transfer, 2);
                @file_put_contents("pay.txt",'uid:'.$pay_uid.'collect_uid:'.$collect_uid.'--'.$amount.'--'.$transfer.'--'.$now_money);
                User::where('uid', $collect_uid)->inc($field, $now_money)->update();
                User::where('uid', $pay_uid)->dec($field, $amount)->update();
                $str = sprintf("收到%s用户%.2f%s,到账:%.2f%s,手续费:%.2f", $pay_user['nickname'], $amount,$title, $now_money,$title, $transfer);
                $res1 = UserBill::income('扫码收款-'.$title, $collect_uid, 'now_money', 'qr_add_'.$field, $now_money, $res['id'], bcadd($collect_user[$field], $now_money, 2), $str);
                $res2 = UserBill::expend("扫码付款-".$title, $pay_uid, 'now_money', 'qr_des_'.$field, $amount, $res['id'], bcsub($pay_user[$field], $amount, 2), '支付给' . $collect_user['nickname'] . $amount . $title, 1);

            }
            if ($res && $res1 && $res2) {
                self::commitTrans();
            } else {
                self::rollbackTrans();
            }
            return $res;
        }catch (Exception $e)
        {
            echo $e->getMessage();
            self::rollbackTrans();
        }
        return false;
    }

    /**
     * 获取支付信息
     * @param $order_id
     */
    public static function getPayment($order_id)
    {
        $info = self::where('order_id',$order_id)->find();
        if($info)
        {
            $info = $info->toArray();
            $info['pay_user'] = User::find($info['pay_uid'])->toarray();
            $info['collect_user'] = User::find($info['collect_uid'])->toarray();
        }
        return $info;
    }

    /**
     * 获取列表
     * @param $where
     */
    public static function lst($where)
    {
        $model = new self;
        if(isset($where['data']) && $where['data']!='') $model = $model->getModelTime($where,$model);
        if(isset($where['pay_type']) && $where['pay_type']>-1) $model = $model->where('pay_type',$where['pay_type']);
        if(isset($where['way'])&&isset($where['way'])!='')
        {
            switch ($where['way'])
            {
                case 'pay':
                    if (isset($where['uid']) && $where['uid'] > 0) $model = $model->where('pay_uid', $where['uid']);
                    break;
                case 'collect':
                    if (isset($where['uid']) && $where['uid'] > 0) $model = $model->where('collect_uid', $where['uid']);
                    break;
            }
        }
        else {
            if (isset($where['uid']) && $where['uid'] > 0) $model = $model->where('pay_uid|collect_uid', $where['uid']);
        }
        if(isset($where['is_tip']) && $where['is_tip']>-1) $model = $model->where('is_tip',$where['is_tip']);
        $count = $model->count();
        $data = $model->page($where['page'],$where['limit'])->select();
        $data  = $data?$data->toArray():[];
        foreach ($data as &$v)
        {
            $v['pay_user'] = User::find($v['pay_uid'])->toarray();
            $v['collect_user'] = User::find($v['collect_uid'])->toarray();
        }
        if(isset($where['excel']) && $where['excel'] == 1)
        {
            $pay_type = ['收款码','扫付款码'];
            foreach ($data as $index => $item) {
                $export[] = [
                    $item['order_id'],
                    $item['pay_name'] => $item['pay_user']['real_name'].":".$item['pay_user']['uid'],
                    $item['amount'],
                    $item['collect_name'] => $item['collect_user']['real_name'].":".$item['collect_user']['uid'],
                    $item['add_time'],
                    $item['pay_type']=> $pay_type[$item['pay_type']],
                ];
            }
            PHPExcelService::setExcelHeader(['订单号','付款人', '金额','收款人', '时间', '方式','类型'])
                ->setExcelTile('收付码', '收付码列表' . time(), ' 生成时间：' . date('Y-m-d H:i:s', time()))
                ->setExcelContent($export)
                ->ExcelSave();
        }
        return compact('count','data');
    }
    public static function collection($uid)
    {
        $card_no = User::where('uid',$uid)->value('merchant_no');
        if(empty(trim($card_no)))
        {
            $card_no = User::max('merchant_no');
            if (intval($card_no) < 10000000000) {
                $card_no = "10000000001";
            } else {
                $card_no = str_pad(bcadd($card_no, 1), 11, "0", STR_PAD_LEFT);
            }
            User::edit(['merchant_no' => $card_no],$uid);
        }
        return $card_no;
    }
}