blog_tp6/app/common/model/Category.php

<?php
declare(strict_types=1);

namespace app\common\model;

/**
 * 栏目模型
 */
class Category extends Base
{
    protected $schema = [
        "id"          => "int",
        "parent_id"   => "int",
        "name"        => "varchar",
        "url"         => "varchar",
        "route"       => "varchar",
        "tablename"   => "varchar",
        "template"    => "varchar",
        "type"        => "int",
        "is_nav"      => "int",
        "remark"       => "varchar",
        "sort"        => "int",
        'status'      => "varchar",
        "title"       => "varchar",
        "keywords"    => "varchar",
        "description" => "varchar",
        "is_blank"    => "int",
        "create_time" => "int",
        "update_time" => "int"
    ];

    // 获取列表
    public static function getList(array $param = [])
    {
        $where = [];

        if (isset($param['is_nav']) ) {
            $where[] = ['is_nav', '=', (int) $param['is_nav']];
        }

        if (isset($param['type']) ) {
            $where[] = ['type', '=', (int) $param['type']];
        }

        $order = isset($param['order']) ? (string) $param['order'] : "sort ASC,id DESC";

        return self::where($where)->field("id,parent_id,name,url,route,tablename,template,type,is_nav,remark,sort,title,keywords,
            description,is_blank,create_time,update_time")->order($order)->select();
    }
}