pangu

盘古开天，用于 admin 页面管理

1 数据模型

1.1 pangu_menu

+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
| url         | varchar(128) | NO   | UNI | NULL    |                |
| label       | varchar(64)  | NO   |     | NULL    |                |
| icon        | varchar(64)  | NO   |     | NULL    |                |
| is_folder   | tinyint(1)   | NO   | MUL | NULL    |                |
| is_visible  | tinyint(1)   | NO   | MUL | NULL    |                |
| parent_id   | int(11)      | NO   | MUL | NULL    |                |
| page_id     | int(11)      | NO   | MUL | NULL    |                |
| update_time | datetime     | NO   |     | NULL    |                |
| create_time | datetime     | NO   |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

CREATE TABLE `pangu_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(128) NOT NULL,
  `label` varchar(64) NOT NULL,
  `icon` varchar(64) NOT NULL,
  `is_folder` tinyint(1) NOT NULL,
  `is_visible` tinyint(1) NOT NULL,
  `parent_id` int(11) NOT NULL,
  `page_id` int(11) NOT NULL,
  `update_time` datetime NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pangumenu_url` (`url`),
  KEY `pangumenu_is_folder` (`is_folder`),
  KEY `pangumenu_is_visible` (`is_visible`),
  KEY `pangumenu_parent_id` (`parent_id`),
  KEY `pangumenu_page_id` (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

1.2 pangu_page

+---------------+---------------+------+-----+---------+----------------+
| Field         | Type          | Null | Key | Default | Extra          |
+---------------+---------------+------+-----+---------+----------------+
| id            | int(11)       | NO   | PRI | NULL    | auto_increment |
| page_content  | text          | YES  |     | NULL    |                |
| page_describe | varchar(2048) | NO   |     | NULL    |                |
| update_time   | datetime      | NO   |     | NULL    |                |
| create_time   | datetime      | NO   |     | NULL    |                |
+---------------+---------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

CREATE TABLE `pangu_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_content` text,
  `page_describe` varchar(2048) NOT NULL,
  `update_time` datetime NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2 后端接口

POST /pangu/menu_create 'url_key' 'label' 'icon' 'is_visible=yes' 'parent_id=0'
POST /pangu/menu_delete 'menu_id'
GET  /pangu/menu_list  'parent_id=0'
GET  /pangu/menu_list_for_nav
GET  /pangu/menu_list_for_page_select
GET  /pangu/menu_list_in_aside
POST /pangu/menu_update 'menu_id' 'url_key' 'label' 'icon' 'is_visible=yes' 'parent_id=0'
POST /pangu/page_create 'url_key' 'label' 'icon' 'is_visible' 'parent_id' 'page_content' 'page_describe='
GET  /pangu/page_get 'page_id'
GET  /pangu/page_show 'page_id' '_replace=None'
POST /pangu/page_update 'page_id' 'page_content=None' 'page_describe=None'

3 前端

4 传送门

https://aisuda.bce.baidu.com/amis/zh-CN/components/nav