fastadmin_tailored/application/common/model/ExchangeOrder.php

<?php

namespace app\common\model;

use think\Model;


class ExchangeOrder extends Model
{

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

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

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

    // 追加属性
    protected $append = [
        'type_text',
        'status_text'
    ];

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

    public function getStatusList()
    {
        return ['created' => __('待兑换'), 'inprogress' => __('处理中'), 'rejected' => __('已拒绝'), 'delivered' => __('已发货'), 'completed' => __('已完成')];
    }

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


    public function getStatusTextAttr($value, $data)
    {
        $value = $value ?: ($data['status'] ?? '');
        $list = $this->getStatusList();
        return $list[$value] ?? '';
    }

    //常见兑换订单
    public static function createOrder($data)
    {
        $data['orderid'] = date("Ymdhis") . sprintf("%06d", $data['user_id']) . mt_rand(1000, 9999);
        $data['ip'] = request()->ip();
        $data['useragent'] = substr(request()->server('HTTP_USER_AGENT'), 0, 255);
        return (new self)->save($data);
    }


    //获取列表
    public static function tableList($param)
    {
        $pageNum = 10;
        if (!empty($param['num'])) {
            $pageNum = $param['num'];
        }
        return self::with(['Exchange' => function ($query) {
            $query->field('id,title,image');
        }])->field('id,status,nums,score,type,exchange_id,reason,expressname,expressno,createtime')->where(function ($query) use ($param) {
            if (!empty($param['type'])) {
                $query->where('type', $param['type']);
            }
            if (!empty($param['status'])) {
                $query->where('status', $param['status']);
            }
            if (!empty($param['user_id'])) {
                $query->where('user_id', $param['user_id']);
            }
        })->order('createtime desc')->paginate($pageNum);
    }

    public function Exchange()
    {
        return $this->hasOne('Exchange', 'id', 'exchange_id');
    }
}