"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(); } // 导航状态修改 1,显示; 0,不显示 public static function navStaus(int $id) { try { $info = self::find($id); $info->is_nav = -1 - $info['is_nav']; $info->save(); return json(['code' => 0, 'msg' => '修改成功!', 'is_nav'=>$info->is_nav]); } catch (\Exception $e) { return json(['code' => 1, 'msg' => $e->getMessage()]); } } public static function selectOne() { $list = self::where('type', 1)->field("id, parent_id,name")->select(); $top = new static([ "id"=> 0, "parent_id" => -1, "name" => "顶级栏目" ]); $list->push($top); return list_tree($list, 'id', 'parent_id', 'child', -1); } }