red/application/common/model/Lave.php

<?php

namespace app\common\model;

use liuniu\BaseModel;
use think\Exception;
use think\Model;


class Lave extends BaseModel
{

    // 表名
    protected $name = 'lave';

    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';

    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = false;
    protected $deleteTime = false;

    // 追加属性
    protected $append = [
        'is_open_text',
        'is_ticket_text',
        'paid_text',
        'pay_type_text',
        'paytime_text',
        'type_text'
    ];


    public function getIsOpenList()
    {
        return ['0' => __('Is_open 0'), '1' => __('Is_open 1')];
    }

    public function getIsTicketList()
    {
        return ['0' => __('Is_ticket 0'), '1' => __('Is_ticket 1')];
    }

    public function getPaidList()
    {
        return ['0' => __('Paid 0'), '1' => __('Paid 1')];
    }

    public function getPayTypeList()
    {
        return ['0' => __('Pay_type 0'), '1' => __('Pay_type 1'), '2' => __('Pay_type 2'), '3' => __('Pay_type 3'), '4' => __('Pay_type 4')];
    }

    public function getTypeList()
    {
        return ['0' => __('Type 0'), '1' => __('Type 1')];
    }


    public function getIsOpenTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['is_open']) ? $data['is_open'] : '');
        $list = $this->getIsOpenList();
        return isset($list[$value]) ? $list[$value] : '';
    }


    public function getIsTicketTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['is_ticket']) ? $data['is_ticket'] : '');
        $list = $this->getIsTicketList();
        return isset($list[$value]) ? $list[$value] : '';
    }


    public function getPaidTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['paid']) ? $data['paid'] : '');
        $list = $this->getPaidList();
        return isset($list[$value]) ? $list[$value] : '';
    }


    public function getPayTypeTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['pay_type']) ? $data['pay_type'] : '');
        $list = $this->getPayTypeList();
        return isset($list[$value]) ? $list[$value] : '';
    }


    public function getPaytimeTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['paytime']) ? $data['paytime'] : '');
        return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
    }


    public function getTypeTextAttr($value, $data)
    {
        $value = $value ? $value : (isset($data['type']) ? $data['type'] : '');
        $list = $this->getTypeList();
        return isset($list[$value]) ? $list[$value] : '';
    }

    protected function setPaytimeAttr($value)
    {
        return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
    }

    public static function lst($where)
    {
        $model = new self;
        $xwhere = null;
        $order = "id desc";
        if (isset($where['cid']) && $where['cid'] > 0) $xwhere['cid'] = $where['cid'];
        if (isset($where['user_id']) && $where['user_id'] > 0) $xwhere['user_id'] = $where['user_id'];
        if (isset($where['category_id']) && $where['category_id'] > 0) $xwhere['category_id'] = $where['category_id'];
        if (isset($where['paid']) && $where['paid'] > -1) $xwhere['paid'] = $where['paid'];
        if (isset($where['help_id']) && $where['help_id'] > -1) $xwhere['help_id'] = $where['help_id'];
        if (isset($where['order']) && $where['order'] != '') $order = $where['order'];
        if (isset($where['key']) && $where['key'] != '') $xwhere['name|contact|tel'] = ['like', "%{$where['key']}%"];
        $data = $model->where($xwhere)->order($order)->page($where['page'], $where['limit'])->select();
        $count = $model->where($xwhere)->count();
        return compact('count', 'data');
    }

    public static function lave_create($where)
    {
        try {
            if ($where['cid'] == 0 || $where['user_id'] == 0 || $where['amount'] <= 0 || empty($where['name']) || empty($where['tel'])) return self::setErrorInfo('请核对信息');
            if ($where['type'] == 1 && $where['contact'] == '') return self::setErrorInfo('请核对信息');
            $where['order_id'] = self::getNewOrderId();
            $rs = self::create($where);
            return $rs;
        } catch (Exception $e) {
            return self::setErrorInfo($e->getMessage());
        }
    }

    public static function getNewOrderId()
    {
        do {
            list($msec, $sec) = explode(' ', microtime());
            $msectime = number_format((floatval($msec) + floatval($sec)) * 1000, 0, '', '');
            $orderId = 'wx' . $msectime . mt_rand(10000, 99999);
        } while (self::where(['order_id' => $orderId])->find());
        return $orderId;
    }

    public static function paySuccess($cid, $order_id)
    {
        $max_sn = self::where('cid', $cid)->order('SN DESC')->value('SN');
        if ($max_sn) {
            $no = intval(explode("_", $max_sn)[1]) + 1;
        } else {
            $no = 1;
        }
        $SN = $cid . "_" . str_pad($no, 8, '0', STR_PAD_LEFT);
        $res = self::where('order_id', $order_id)->where('cid', $cid)->update(['paid' => 1, 'paytime' => time(), "SN" => $SN]);//订单改为支付
        return false !== $res;
    }

}