twong329/app/admin/model/routine/RoutineTemplate.php

<?php

namespace app\admin\model\routine;

use crmeb\traits\ModelTrait;
use crmeb\basic\BaseModel;

/**
 * 小程序模板消息Model
 * Class RoutineTemplate
 * @package app\admin\model\wechat
 */
class RoutineTemplate extends BaseModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

    /**
     * 模型名称
     * @var string
     */
    protected $name = 'template_message';

    use ModelTrait;

    public static function vialdWhere(string $alias = '', int $type = 0)
    {
        if ($alias) {
            $alias .= '.';
        }
        return self::where($alias . 'type', $type);
    }

    /**
     * 获取系统分页数据   分类
     * @param array $where
     * @return array
     */
    public static function systemPage($where = array())
    {
        $model = self::vialdWhere();
        if ($where['name'] !== '') $model = $model->where('name', 'LIKE', "%$where[name]%");
        if ($where['status'] !== '') $model = $model->where('status', $where['status']);
        return self::page($model, $where);
    }

    /**
     * 根据模版编号获取模版ID
     * @param $tempkey
     */
    public static function getTempid($tempkey)
    {
        return self::vialdWhere()->where('tempkey', $tempkey)->where('status', 1)->cache(true, 3600)->value('tempid');
    }
}