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 传送门
Last updated