/* Navicat Premium Data Transfer Source Server : jd-test Source Server Type : MySQL Source Server Version : 80027 Source Host : 47.105.89.238:2290 Source Schema : jiedao_cms Target Server Type : MySQL Target Server Version : 80027 File Encoding : 65001 Date: 17/05/2022 17:31:49 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for cms_archives -- ---------------------------- DROP TABLE IF EXISTS `cms_archives`; CREATE TABLE `cms_archives` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题', `properties` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'n' COMMENT '自定义属性', `image_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '缩略图', `tag` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签', `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容摘要', `category_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '上级栏目', `comment` int NULL DEFAULT 1 COMMENT '允许评论', `subscribe` int NULL DEFAULT 1 COMMENT '允许订阅', `clicks` int NULL DEFAULT 0 COMMENT '浏览量', `weight` int NULL DEFAULT 0 COMMENT '权重', `status` int NULL DEFAULT 1 COMMENT '状态1:已发布0未发布', `category_ids` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目层级', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '档案' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_archives -- ---------------------------- INSERT INTO `cms_archives` VALUES ('13037ae7e98048708cf9978368eeb820', '产品一', 'n', '', NULL, '', '6498f8307af5475683d4deb7b7b81d31', 1, 1, 0, 0, 1, '.uw6lcqqd', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:08:23', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:31:08'); INSERT INTO `cms_archives` VALUES ('182306d8eab44225a5ce123ad6a01ffd', '温馨家居搭配设计css3网站模板', 'p', '20190815\\2dbcc0552eae41578b03f34235c71db0.jpg', NULL, '', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 0, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:35:39', NULL, '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('18f228df7b8443dfa1039fe3c3e53503', 'Dreamer CMS是企业在创立初期很好的技术基础框架', 'p', '20190816\\ecb040a2c77348958e6fd39b1afebe18.jpg', NULL, '', '4b1968cc854745418c4c0d305fbe7e15', 1, 1, 0, 0, 1, '.1hq8501w', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:21:14', NULL, '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('31ca333eb9b04c8f8cc6f0f1c1447615', '微软', 'p', '20190816\\b39c908830744191b47830ac5e7d1b72.png', NULL, '', 'b0bb4daa71694c0ebdb59a986d11684f', 1, 1, 0, 0, 1, '.2jk6313y', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:02:00', NULL, '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('495c981ae1be45fb8d989d76b2d18672', '你好,我们公司想要订购产品?', 'n', '', '', '', '46041acafe0444ac95870f165977b6a0', 0, 0, 5, 0, 1, '.wqz18j7q', NULL, '2020-07-22 07:44:14', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:48:13'); INSERT INTO `cms_archives` VALUES ('4f451c4797c54536869f5cf748944f9e', 'Dreamer CMS 梦想家内容发布系统v1.0.0', 'n', '', NULL, '', '592ef65f97264ecda6caeb284d9f6355', 1, 1, 11, 0, 1, '.he9g4d0j', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:20:53', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-08 18:00:21'); INSERT INTO `cms_archives` VALUES ('4f884e12b4be456a89156a51316c3f04', 'iop', 'p', '20190816\\ed8897c2c2ac4e61be5081584cf236ad.png', NULL, '', 'b0bb4daa71694c0ebdb59a986d11684f', 1, 1, 0, 0, 1, '.2jk6313y', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:07:06', NULL, '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('6a9d2d84c2cf4dae97e06b3af5c05e78', '硬件产品二', 'n', '', NULL, '', '5562f6d3f2e24f9c8be3abe69023cc27', 1, 1, 0, 0, 1, '.uw6lcqqd.l8pzde13', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:10:34', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:30:28'); INSERT INTO `cms_archives` VALUES ('755912b5365540479499a9272157ac3b', '软件产品一', 'n', '', NULL, '', '15445e172d734d0c87f52530549f91de', 1, 1, 0, 0, 1, '.uw6lcqqd.1gi964u0', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-07 09:38:50', NULL, '2020-07-07 17:38:53'); INSERT INTO `cms_archives` VALUES ('779bc296ea4a4149bd3c97cdb8cd8593', '个人开发者也可以使用Dreamer CMS承接外包项目', 'p', '20190816\\3f3f65a75df74027b3755d155b0f29b2.png', NULL, '', '4b1968cc854745418c4c0d305fbe7e15', 1, 1, 0, 0, 1, '.1hq8501w', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:47:51', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('93b0ac1621024e4682442acd646da397', 'kid儿童用品商城shop网站模板', 'p', '20190815\\bbcb488fd42b42b4bd5af53f8c6ebcfe.jpg', NULL, '', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 0, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:37:07', NULL, '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('9736f68a332a48419178c5d3fdeb42bd', '我们是做产品直销的?有没有合作的意向?', 'n', '', '', '', '46041acafe0444ac95870f165977b6a0', 0, 0, 0, 0, 1, '.wqz18j7q', NULL, '2020-07-22 07:45:30', NULL, '2020-07-22 15:45:30'); INSERT INTO `cms_archives` VALUES ('ae451258a33642d2b6e57729c83f3eb7', 'Yale', 'p', '20190816\\a04e19bd311c45bebfc7a3dd2695a88c.png', NULL, '', 'b0bb4daa71694c0ebdb59a986d11684f', 1, 1, 0, 0, 1, '.2jk6313y', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:11:22', NULL, '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('cc1b4cc70af54410a9486e7d4babd5a7', '大气css3动画BUSINESS商务展会企业模板', 'p', '20190815\\6fa657689394413d9b724cfa522301e6.jpg', '商务', '', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 2, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:38:19', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('d64d167032c84521ad21708cccc1f963', '大气orion渐变绿色css3响应式商业模板', 'p', '20190815\\18c8a53e1b63493b821c9ab865c4b395.jpg', 'css3,html5,bootstrap', '大气orion渐变绿色css3响应式商业模板', 'e6cdbf119da14a30a86a0f9f2189b8e5', 1, 1, 0, 0, 1, '.a54547w2', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:28:10', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('e738f12d050849fd9998ac01fd0f5ad7', '初学JAVA的同学可以下载源代码来进行学习交流', 'p', '20190816\\da8377d716dc473a8f35d7a1b1a078c4.jpg', NULL, '', '4b1968cc854745418c4c0d305fbe7e15', 1, 1, 0, 0, 1, '.1hq8501w', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:49:55', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-22 09:20:10'); INSERT INTO `cms_archives` VALUES ('edda8fda8cc24a00b82e3f2ccfeb521d', 'Dreamer CMS 梦想家内容发布系统v2.5.1', 'n', '', NULL, '', '592ef65f97264ecda6caeb284d9f6355', 1, 1, 0, 0, 1, '.he9g4d0j', '9f4b807db2e94670bb02cdc212ea7389', '2020-06-19 08:36:16', NULL, '2020-06-19 16:36:16'); INSERT INTO `cms_archives` VALUES ('fb7c4cf30dd1456e8b21af621479a2e4', 'Dreamer CMS 梦想家内容发布系统v2.0.0', 'n', '', NULL, '', '592ef65f97264ecda6caeb284d9f6355', 1, 1, 15, 0, 1, '.he9g4d0j', '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:30:57', NULL, '2021-01-16 12:36:04'); -- ---------------------------- -- Table structure for cms_article -- ---------------------------- DROP TABLE IF EXISTS `cms_article`; CREATE TABLE `cms_article` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NOT NULL, `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `html_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文章' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_article -- ---------------------------- INSERT INTO `cms_article` VALUES ('1db4bded81e5487fb977dc08c8c0994d', '4f884e12b4be456a89156a51316c3f04', NULL, '2018-01-01 00:00:00', NULL, '2019-08-16 10:07:06', NULL, NULL, NULL, NULL, NULL, NULL, ''); INSERT INTO `cms_article` VALUES ('36906ce147a34df8af6d076e3ded98f5', '13037ae7e98048708cf9978368eeb820', NULL, '2018-01-01 00:00:00', NULL, '2020-07-07 17:08:25', NULL, NULL, NULL, NULL, NULL, NULL, '
ddd
'); INSERT INTO `cms_article` VALUES ('3847200101314c1e98ea78658ac54409', 'ae451258a33642d2b6e57729c83f3eb7', NULL, '2018-01-01 00:00:00', NULL, '2019-08-16 10:11:22', NULL, NULL, NULL, NULL, NULL, NULL, ''); INSERT INTO `cms_article` VALUES ('431dc64e8d064aba95418674e5b11d7f', '755912b5365540479499a9272157ac3b', NULL, '2018-01-01 00:00:00', NULL, '2020-07-07 17:38:53', NULL, NULL, NULL, NULL, NULL, NULL, ''); INSERT INTO `cms_article` VALUES ('869c49d8819045d78c1353026c2e6e42', '6a9d2d84c2cf4dae97e06b3af5c05e78', NULL, '2018-01-01 00:00:00', NULL, '2020-07-07 17:10:35', NULL, NULL, NULL, NULL, NULL, NULL, ''); INSERT INTO `cms_article` VALUES ('8a457c20a8bc4159a728a75f329678da', '31ca333eb9b04c8f8cc6f0f1c1447615', NULL, '2018-01-01 00:00:00', NULL, '2019-08-16 10:02:00', NULL, NULL, NULL, NULL, NULL, NULL, ''); -- ---------------------------- -- Table structure for cms_attachment -- ---------------------------- DROP TABLE IF EXISTS `cms_attachment`; CREATE TABLE `cms_attachment` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标识码', `filename` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名', `filesize` int NULL DEFAULT NULL COMMENT '文件大小', `filetype` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件类型', `filepath` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件路径', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '附件' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_attachment -- ---------------------------- INSERT INTO `cms_attachment` VALUES ('abd987209da941349001c85ffece6eb1', 'ez159g51', 'java1.8新特性.pptx', 113690, 'application/vnd.openxmlformats-officedocument.presentationml.presentation', '20191225\\acb604753b4c4d9ea281ae977d712f31.pptx', '9f4b807db2e94670bb02cdc212ea7389', '2019-12-25 05:47:34', '9f4b807db2e94670bb02cdc212ea7389', '2019-12-25 05:47:34'); -- ---------------------------- -- Table structure for cms_category -- ---------------------------- DROP TABLE IF EXISTS `cms_category`; CREATE TABLE `cms_category` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `cnname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '栏目名称', `enname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目英文名称', `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码', `cat_seq` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '层级关系', `form_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表单ID', `image_path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目图片', `description` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目描述', `link_target` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接目标', `page_size` int NULL DEFAULT 20 COMMENT '分页数量', `cat_model` int NULL DEFAULT 20 COMMENT '栏目模型(1封面,2列表,3外部链接)', `visit_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '访问路径', `cover_temp` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '封面模版', `list_temp` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列表模版', `article_temp` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内容页模版', `link_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '链接路径', `default_editor` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '默认编辑器', `md_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'md内容', `html_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'html内容', `parent_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '上级栏目', `is_show` int NULL DEFAULT 1 COMMENT '是否显示1显示0隐藏', `level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '栏目级别', `sort` int NULL DEFAULT 50 COMMENT '排序', `is_input` int NULL DEFAULT 0 COMMENT '是否允许投稿', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NOT NULL, `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '栏目' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_category -- ---------------------------- INSERT INTO `cms_category` VALUES ('0ca9667691d045a098e138fddb644ee0', '分页栏目标签', 'Page Category Label', '2y1e2puq', '.822n58d3.u8xo56nx.2y1e2puq', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 分页栏目标签dreamer-cms:category\r\n### 1.标签说明\r\n这个标签是用于在分页(封面页面和列表页面和文章页面)调用当前栏目信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\nfield|typenamecn|字段名\r\n\r\n### 2.返回字段说明\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\ntypeid|String|栏目ID\r\ntypenamecn|String|栏目中文名称\r\ntypenameen|String|栏目英文名称\r\ntypecode|String|栏目编码(8位唯一)\r\ntypeseq|String|栏目的层级\r\ntypeimg|String|栏目图片\r\ndescription|String|栏目描述\r\nlinktarget|String|链接目标\r\npagesize|Integer|分页大小(该属性控制列表页面默认的分页大小)\r\nvisiturl|String|访问URL(浏览器地址栏中将以该url显示,如果为空,则为栏目中文名称的拼音)\r\nlinkurl|String|链接URL\r\neditor|String|编辑器(md或ue)\r\nmdcontent|String|markdown内容\r\nhtmlcontent|String|生成的html内容\r\nparentname|String|上级栏目名称\r\nisshow|Integer|是否显示\r\nlevel|Integer|栏目层级\r\nsort|Integer|排序(默认为50)\r\ncreateby|String|创建人\r\ncreatetime|Date|创建时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\ntypeurl|String|栏目URL\r\next01|String|扩展字段1\r\next02|String|扩展字段2\r\next03|String|扩展字段3\r\next04|String|扩展字段4\r\next05|String|扩展字段5\r\nhaschildren|Boolean|是否有下级栏目(该属性在dreamer-cms:type标签下不可用)\r\n\r\n### 3.示例代码\r\n```html\r\n这个标签是用于在分页(封面页面和列表页面和文章页面)调用当前栏目信息。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
field | \r\ntypenamecn | \r\n字段名 | \r\n
属性名 | \r\n字段类型 | \r\n描述 | \r\n
---|---|---|
typeid | \r\nString | \r\n栏目ID | \r\n
typenamecn | \r\nString | \r\n栏目中文名称 | \r\n
typenameen | \r\nString | \r\n栏目英文名称 | \r\n
typecode | \r\nString | \r\n栏目编码(8位唯一) | \r\n
typeseq | \r\nString | \r\n栏目的层级 | \r\n
typeimg | \r\nString | \r\n栏目图片 | \r\n
description | \r\nString | \r\n栏目描述 | \r\n
linktarget | \r\nString | \r\n链接目标 | \r\n
pagesize | \r\nInteger | \r\n分页大小(该属性控制列表页面默认的分页大小) | \r\n
visiturl | \r\nString | \r\n访问URL(浏览器地址栏中将以该url显示,如果为空,则为栏目中文名称的拼音) | \r\n
linkurl | \r\nString | \r\n链接URL | \r\n
editor | \r\nString | \r\n编辑器(md或ue) | \r\n
mdcontent | \r\nString | \r\nmarkdown内容 | \r\n
htmlcontent | \r\nString | \r\n生成的html内容 | \r\n
parentname | \r\nString | \r\n上级栏目名称 | \r\n
isshow | \r\nInteger | \r\n是否显示 | \r\n
level | \r\nInteger | \r\n栏目层级 | \r\n
sort | \r\nInteger | \r\n排序(默认为50) | \r\n
createby | \r\nString | \r\n创建人 | \r\n
createtime | \r\nDate | \r\n创建时间 | \r\n
updateby | \r\nString | \r\n更新人 | \r\n
updatetime | \r\nDate | \r\n更新时间 | \r\n
typeurl | \r\nString | \r\n栏目URL | \r\n
ext01 | \r\nString | \r\n扩展字段1 | \r\n
ext02 | \r\nString | \r\n扩展字段2 | \r\n
ext03 | \r\nString | \r\n扩展字段3 | \r\n
ext04 | \r\nString | \r\n扩展字段4 | \r\n
ext05 | \r\nString | \r\n扩展字段5 | \r\n
haschildren | \r\nBoolean | \r\n是否有下级栏目(该属性在dreamer-cms:type标签下不可用) | \r\n
<section class=\"page-header d-flex align-items-center\">\r\n<div class=\"container-fluid\">\r\n <div class=\"page-header-content text-center\">\r\n <div class=\"page-header-tag\">{dreamer-cms:global name=\"title\" /}</div>\r\n <div class=\"page-header-title\">{dreamer-cms:category field=\"typenamecn\" /}</div>\r\n </div>\r\n</div>\r\n</section>\r\n
\r\n', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 9, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:04:05', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('2512e4593b514db2a10841cbc8a63a23', '开发者', 'developer', 'mvpeun1s', '.4ol61bbh.mvpeun1s', 'c17ddcad9fb149a6bf90f7bba0e0696b', '20190820\\8ab5d68c3f9e4687816d1cbb083d9f71.jpg', '', '1', 20, 1, 'developer', '/developer.html', '', '', '', 'ue', '', '
王俊南(QQ:153095904);
个人博客:http://www.itechyou.cn/
DreamerCMS创始人;草根站长;
有10年的JAVA学习工作研究经验,先后参与过国家电网登高项目,企业OA项目;
多个政府服务平台项目,具有丰富的J2EE开发经验;
5年多的Java培训指导教育经验,原创教程通俗易懂,深受喜爱;
从事多年IT,拥有较广的人脉;
个人名言:我喜欢程序员,他们单纯、固执、容易体会到成就感;面对压力,能够挑灯夜战不眠不休;面对困难,能够迎难而上挑战自我。他们也会感到困惑与傍徨,但每个程序员的心中都有一个比尔盖茨或是乔布斯的梦想“用智慧开创属于自己的事业”。我想说的是,其实我只是一个程序员!
该标签作用是获取后台系统配置中的配置项。该标签属于单标签,也可以写成{dreamer-cms:global name=”xxx”}{/dreamer-cms:global}。该标签只有一个属性 name,并适用于所有模版。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
name | \r\nwebsite | \r\n获取网站地址 | \r\n
name | \r\ntitle | \r\n获取网站标题 | \r\n
name | \r\nkeywords | \r\n获取网站关键字 | \r\n
name | \r\ndescribe | \r\n获取网站描述 | \r\n
name | \r\nicp | \r\n获取网站备案号 | \r\n
name | \r\ncopyright | \r\n获取网站版权 | \r\n
name | \r\nuploaddir | \r\n获取网站上传目录 | \r\n
name | \r\nappid | \r\n暂无作用 | \r\n
name | \r\nappkey | \r\n暂无作用 | \r\n
<!--=== footer ===-->\r\n<footer class=\"footer\">\r\n <div class=\"container-fluid\">\r\n <div class=\"row\">\r\n <div class=\"col-lg-5 col-md-6 col-sm-5 align-self-center\">\r\n <div>\r\n <p>\r\n {dreamer-cms:global name=\"copyright\" /}\r\n 备案号:{dreamer-cms:global name=\"icp\" /}\r\n </p>\r\n </div>\r\n\r\n </div>\r\n <div class=\"col-lg-7 col-md-6 col-sm-7 align-self-center\">\r\n <ul class=\"list-inline footer-menu\">\r\n {dreamer-cms:channel type=\'top\' currentstyle=\"\"}\r\n <li class=\"list-inline-item\"><a href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n {/dreamer-cms:channel}\r\n </ul>\r\n </div>\r\n </div>\r\n </div>\r\n</footer>\r\n
\r\n', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 1, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 16:15:10', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('25e7a8290c8a468b90b7453dab8c2b19', '文章列表标签', 'List Label', 'sp7hj754', '.822n58d3.u8xo56nx.sp7hj754', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 文章列表标签dreamer-cms:list\r\n### 1.标签说明\r\n该标签是常用标记,主要用于获取栏目下的文章并适用于所有模版,通常用于网站内容列表等信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目\r\nstart|0|从第几个开始获取\r\nlength|5|获取个数\r\nflag|p|文章属性p图片\r\naddfields|evaluator,content,source|附加字段,多个字段间用英文逗号分隔\r\nformkey|2EFPN7JY|表单模型的编码(可以在后台表单管理列表中获取)\r\nsortWay|asc|排序方式(asc或desc)\r\nsortBy||排序字段\r\n\r\n### 2.返回字段说明\r\n\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\nid|String|文章ID\r\ntitle|String|标题\r\nproperties|String|文章属性(头条h加粗b幻灯f图片b)\r\nlitpic|String|缩略图\r\ntag|String|文章标签\r\nremark|String|文章描述\r\ncategoryid|String|栏目ID\r\ncomment|Integer|是否允许评论\r\nsubscribe|Integer|是否允许订阅\r\nclicks|Integer|点击数\r\nweight|Integer|权重(可以利用该字段来排序)\r\nstatus|Integer|状态\r\ncreateby|String|发布人\r\ncreatetime|Date|发布时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\narcurl|String|文章访问URL\r\n\r\n### 3.示例代码\r\n```html\r\n
该标签是常用标记,主要用于获取栏目下的文章并适用于所有模版,通常用于网站内容列表等信息。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
typeid | \r\n4ol61bbh | \r\n后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目 | \r\n
start | \r\n0 | \r\n从第几个开始获取 | \r\n
length | \r\n5 | \r\n获取个数 | \r\n
flag | \r\np | \r\n文章属性p图片 | \r\n
addfields | \r\nevaluator,content,source | \r\n附加字段,多个字段间用英文逗号分隔 | \r\n
formkey | \r\n2EFPN7JY | \r\n表单模型的编码(可以在后台表单管理列表中获取) | \r\n
sortWay | \r\nasc | \r\n排序方式(asc或desc) | \r\n
sortBy | \r\n\r\n | 排序字段 | \r\n
属性名 | \r\n字段类型 | \r\n描述 | \r\n
---|---|---|
id | \r\nString | \r\n文章ID | \r\n
title | \r\nString | \r\n标题 | \r\n
properties | \r\nString | \r\n文章属性(头条h加粗b幻灯f图片b) | \r\n
litpic | \r\nString | \r\n缩略图 | \r\n
tag | \r\nString | \r\n文章标签 | \r\n
remark | \r\nString | \r\n文章描述 | \r\n
categoryid | \r\nString | \r\n栏目ID | \r\n
comment | \r\nInteger | \r\n是否允许评论 | \r\n
subscribe | \r\nInteger | \r\n是否允许订阅 | \r\n
clicks | \r\nInteger | \r\n点击数 | \r\n
weight | \r\nInteger | \r\n权重(可以利用该字段来排序) | \r\n
status | \r\nInteger | \r\n状态 | \r\n
createby | \r\nString | \r\n发布人 | \r\n
createtime | \r\nDate | \r\n发布时间 | \r\n
updateby | \r\nString | \r\n更新人 | \r\n
updatetime | \r\nDate | \r\n更新时间 | \r\n
arcurl | \r\nString | \r\n文章访问URL | \r\n
<div class=\"row\">\r\n <div class=\"col-lg-12 text-center\">\r\n <div class=\"section-tag\">{dreamer-cms:global name=\"title\" /}</div>\r\n <div class=\"section-title mb-5\"><h2>模版中心</h2></div>\r\n </div>\r\n {dreamer-cms:list typeid=\"A54547W2\" start=\"0\" length=\"8\" flag=\"p\"}\r\n <div class=\"col-lg-3 col-md-4 col-sm-6\">\r\n <div class=\"feature-wrap\">\r\n <div class=\"feature-image\"><img src=\"[field:litpic /]\" class=\"ion ion-ios-cloud-outline\"></i></div>\r\n <a href=\"[field:arcurl/]\">[field:title /]</a>\r\n <p></p>\r\n </div>\r\n </div>\r\n {/dreamer-cms:list}\r\n</div>\r\n
\r\n当前版本:2.0.1 梦想家CMS官网:http://www.itechyou.cn QQ群交流: ①597652651 ②623605199 DreamerCMS(梦想家CMS内容管理系统)公开解决了快速搭建展示型网站(如:企业官网、技术博客、信息门户等)的框架体系,是电子政务、电信综合门户、企业信息门户、知识管理平台、电子商务平台的基础性软件系统。可以帮助政府、企业或组织灵活、准确、高效、智能地管理信息内容,实现信息的采集、加工、审核、发布、存储、检索、统计、分析、 反馈等整个信息生命周期的管理。采用时下最流行的Springboot+thymeleaf框架搭建,具有灵活小巧,配置简单,标签化模版,快速开发等特点。主要解决公司搭建网站成本高、投入大、周期长等问题,也可作为初创公司很好的基础技术框架。使用过程中不需要专业的后端技术开发技能,只要使用系统提供的模版标签,即可轻轻松松建设网站。 DreamerCMS从2.0.0版本开始采用了解析式引擎与编译式引擎并存的模式,由于在解析模版时,解析式引擎拥有巨大的优势,但对于动态浏览的互动性质的页面,编译式引擎更实用高效,DreamerCMS采用双引擎并存的模式,在保持标签风格一致性的同时,也保证将来开发更多互动模块时有更好的性能和更好的扩展。 免费完整开源:基于APACHE 2.0开源协议,源代码完全开源; 标签化建站:不需要专业的后台开发技能,只要使用系统提供的标签,就能轻松建设网站; 模版开发方便:支持在线上传模版包开发方便快捷; 每月更新:每月进行系统升级,分享更多好用的模版与插件; 政府:可以使用Dreamer CMS来快速构建政府门户; 电信:可以使用Dreamer CMS来快速构建电信综合门户; 企业:可以使用Dreamer CMS构建信息门户,知识管理平台,也可作为基础技术框架,是企业在创立初期很好的技术选型; 个人开发者:可以使用Dreamer CMS承接外包项目; 核心框架:Spring Boot 2 安全框架:Apache Shiro 1.5 视图框架:Spring MVC 4 持久层框架:MyBatis 3 日志管理:Log4j2 模版框架:Thymeleaf JS框架:jQuery,Bootstrap CSS框架:Bootstrap 富文本:Ueditor、editor.md 建议开发者使用以下环境,这样避免版本带来的问题 IDE:Spring Tool Suite 4(STS) DB:Mysql 5.7 JDK:jdk8 Redis:3.2+ CMS包括两个部分(代码部分、资源部分)代码不多说。资源就是图片、模版等,该目录在application.yml中web.resource-path配置项目中配置。 克隆项目到本地工作空间 导入Eclipse或Sts等开发工具(推荐使用Spring Tools Suite 4)(项目中缺少的google/kaptcha.jar在附件中,大家自行下载) 项目需要Redis,请自行修改application.yml中Redis配置 修改项目资源目录,application.yml文件web.resource-path配置项(如D:/dreamer-cms/) 将项目src/main/resources/db/dreamer-cms.zip文件解压,保证解压后的目录路径的名称和资源目录一致 运行项目DreamerBlogApplication.java 网站首页:http://localhost:8888 项目管理后台:http://localhost:8888/admin 管理后台用户名:wangjn;密码:123456 模版标签开发教程请参考:http://doc.itechyou.cn ', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 7, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 09:51:26', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('44e864cda6a049349e1516ce40eaa58e', '框架说明', 'Framework', '6rztc072', '.4ol61bbh.6rztc072', 'c17ddcad9fb149a6bf90f7bba0e0696b', '20190820\\aad2aaef17ca4cb49b3ffac27c29bb02.png', '', '1', 10, 1, 'framework', '/framework.html', '', '', '', 'ue', '# 梦想家CMS内容管理系统开源版J2EE代码\r\n\r\n当前版本:1.0.1\r\n\r\n梦想家CMS官网:[http://www.itechyou.cn](www.itechyou.cn)\r\n\r\nQQ群交流:\r\n- ①597652651\r\n\r\nDreamer CMS 梦想家内容发布系统是国内首款java开发的内容发布系统,采用最流行的springboot+thymeleaf框架搭建,灵活小巧,配置简单。\r\n\r\n# 特点\r\n* 免费完整开源:基于MIT协议,源代码完全开源;\r\n* 标签化建站:不需要专业的后台开发技能,只要使用系统提供的标签,就能轻松建设网站;\r\n* 模版开发方便:支持在线上传模版包开发方便快捷;\r\n* 每月更新:每月进行系统升级,分享更多好用的模版与插件;\r\n\r\n# 面向对象\r\n* Dreamer CMS是企业在创立初期很好的技术基础框架,加快公司项目开发进度,当然也可以对现有的系统进行升级;\r\n* 个人开发者也可以使用Dreamer CMS承接外包项目;\r\n* 初学JAVA的同学可以下载源代码来进行学习交流;\r\n\r\n# 技术框架\r\n* 核心框架:Spring Boot 2\r\n* 安全框架:Apache Shiro 1.5\r\n* 视图框架:Spring MVC 4\r\n* 持久层框架:MyBatis 3\r\n* 日志管理:Log4j2\r\n* 模版框架:Thymeleaf\r\n* JS框架:jQuery,Bootstrap\r\n* CSS框架:Bootstrap\r\n* 富文本:Ueditor、editor.md\r\n\r\n# 系统结构\r\n\r\n\r\n# 开发环境\r\n建议开发者使用以下环境,这样避免版本带来的问题\r\n* IDE:Spring Tool Suite(STS)\r\n* DB:Mysql 5.7\r\n* JDK:jdk8\r\n\r\n# 快速入门\r\n* 克隆项目到本地\r\n* 导入Eclipse或Sts等开发工具\r\n* 项目需要Redis,请自行修改application.yml中Redis配置\r\n* 将项目主页附件标签页里的dreamer-blog.zip附件下载并解压到D盘根目录\r\n* 运行项目DreamerBlogApplication.java\r\n* 项目首页:http://localhost:8888;项目管理后台:http://localhost:8888/admin\r\n* 管理后台用户名:wangjn;密码:123456\r\n\r\n# 系统美图\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '
梦想家CMS内容管理系统开源版J2EE代码
模版标签开发教程请参考:http://doc.itechyou.cn特点
面向对象
技术框架
系统结构
开发环境
快速入门
一、开发环境搭建及项目导入
https://www.bilibili.com/video/BV1G7411m72U/
二、资源目录和代码之间的关系
https://www.bilibili.com/video/BV1G7411m7qz/
三、熟悉管理后台及系统设置功能介绍
https://www.bilibili.com/video/BV1at4y1m785/
四、变量管理和附件管理
https://www.bilibili.com/video/BV1Xc41187Ja/
五、表单管理功能介绍及演示
https://www.bilibili.com/video/BV15g4y1a73s/
六、标签管理功能介绍
https://www.bilibili.com/video/BV1hQ4y1M7WR/
七、栏目管理功能介绍
https://www.bilibili.com/video/BV1Fa4y1t7H3/
八、文章管理功能介绍及演示
https://www.bilibili.com/video/BV1Pg4y1a7pu/
九、风格设置功能介绍及演示
https://www.bilibili.com/video/BV1fA41187w6/
版本号:[field:versionnum/]
\r\n发布日期:[field:createtime/]
\r\n 查看详情 \r\n这个标签是用于在列表页面调用文章列表并显示分页信息。一般该标签配合{dreamer-cms:pagination /}共同使用。见下方例子。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
formkey | \r\n4ol61bbh | \r\n表单模型的编码 | \r\n
addfields | \r\nversionnum,notes | \r\n附加字段(该字段须设置了formkey后生效) | \r\n
sortWay | \r\nasc或desc | \r\n排序方式 | \r\n
sortBy | \r\n\r\n | 排序字段 | \r\n
属性名 | \r\n字段类型 | \r\n描述 | \r\n
---|---|---|
id | \r\nString | \r\n文章ID | \r\n
title | \r\nString | \r\n标题 | \r\n
properties | \r\nString | \r\n文章属性(头条h加粗b幻灯f图片b) | \r\n
litpic | \r\nString | \r\n缩略图 | \r\n
tag | \r\nString | \r\n文章标签 | \r\n
remark | \r\nString | \r\n文章描述 | \r\n
categoryid | \r\nString | \r\n栏目ID | \r\n
comment | \r\nInteger | \r\n是否允许评论 | \r\n
subscribe | \r\nInteger | \r\n是否允许订阅 | \r\n
clicks | \r\nInteger | \r\n点击数 | \r\n
weight | \r\nInteger | \r\n权重(可以利用该字段来排序) | \r\n
status | \r\nInteger | \r\n状态 | \r\n
createby | \r\nString | \r\n发布人 | \r\n
createtime | \r\nDate | \r\n发布时间 | \r\n
updateby | \r\nString | \r\n更新人 | \r\n
updatetime | \r\nDate | \r\n更新时间 | \r\n
arcurl | \r\nString | \r\n文章访问URL | \r\n
<div class=\"row\">\r\n {dreamer-cms:pagelist pagesize=\"10\" formkey=\"LUVC0AW2\" addfields=\"versionnum,notes\"}\r\n <div class=\"col-lg-4 col-md-6 col-sm-6\">\r\n <div class=\"blog-post\">\r\n <div class=\"blog-details\">\r\n <ul class=\"list-inline blog-item-links\">\r\n <li class=\"list-inline-item\"><a href=\"#\"><i class=\"ion ion-calendar\"></i>版本号:[field:versionnum/]</a></li>\r\n <li class=\"list-inline-item\"><a href=\"#\"><i class=\"ion ion-chatbubbles\"></i>点击:[field:clicks/]</a></li>\r\n </ul>\r\n <a href=\"[field:arcurl/]\"><h4 class=\"media-heading\">[field:title/]</h4></a>\r\n <p class=\"product-para\">版本号:[field:versionnum/]</p>\r\n <p class=\"product-para\">发布日期:[field:createtime/]</p>\r\n <a href=\"[field:arcurl/]\" class=\"blog-post-link\">查看详情 <i class=\"fa fa-angle-double-right\"></i></a>\r\n </div>\r\n </div>\r\n </div>\r\n {/dreamer-cms:pagelist}\r\n</div>\r\n<div class=\"row\">\r\n <div class=\"col-lg-12 col-md-12 col-sm-12\">\r\n {dreamer-cms:pagination /}\r\n </div>\r\n</div>\r\n
\r\n\r\n 1、标签统一dreamer-cms:打头,花括号包裹,dreamer-cms标签只能用于html模版页面中;', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 10, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:26:12', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('7b773cb86e574302a8878573de87b32a', '文档丰富', 'richdoc', '1ggrj6n9', '.4ol61bbh.tnleskz4.1ggrj6n9', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', 'd9fea2574384477199d038ac66ebd095', 0, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:49:37', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:32:21', 'fa fa-file-word-o', '', '', '', '');
INSERT INTO `cms_category` VALUES ('7ddb8cde57554702976f01593488d807', '模版化', 'templateing', 'e96c4wkr', '.4ol61bbh.tnleskz4.e96c4wkr', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', 'd9fea2574384477199d038ac66ebd095', 0, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:48:26', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:35:47', 'fa fa-object-group', '', '', '', '');
INSERT INTO `cms_category` VALUES ('8923a09d403f49a289f3af780dcca0c2', '标签', 'label', 'u8xo56nx', '.822n58d3.u8xo56nx', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'ue', '# 标签\r\n* 标签统一dreamer-cms:打头,花括号包裹,dreamer-cms标签只能用于html模版页面中;\r\n* 标签格式:{ms:标签 属性1=值1 属性2=值2 属性n=值n/}属性值需要用双引号包裹,相邻的两个属性之间也要用空格隔开;\r\n* 模版也是普通的html文件格式,文件后缀为.html;\r\n* 只支持两种默认首页,分别是引导页(default.html)与主页(index.html);\r\n * default.html一般是做网站的欢迎引导界面;\r\n * index.html为网站的主页;\r\n* 模版需要与后台的栏目绑定,通过生成器生成才有效;\r\n* 栏目有两个非常重要的概念,列表与封面;\r\n* 列表:例如产品列表、文章列表,列表会绑定两个模版地址一是列表模版、二是内容模版;\r\n* 封面:例如关于我们、联系方式这些都属于单篇模版;\r\n* 文章是必须发布在最终子栏目;\r\n* 自定义模型,如果文章现有的字段无法满足可以通过自定义模型来满足,通过[field:*/]获取自定义属性。', '
2、标签格式:{ms:标签 属性1=值1 属性2=值2 属性n=值n/}属性值需要用双引号包裹,相邻的两个属性之间也要用空格隔开;
3、模版也是普通的html文件格式,文件后缀为.html;
4、只支持两种默认首页,分别是引导页(default.html)与主页(index.html);
a、default.html一般是做网站的欢迎引导界面;
b、index.html为网站的主页;
5、模版需要与后台的栏目绑定,通过生成器生成才有效;
6、栏目有两个非常重要的概念,列表与封面;
7、列表:例如产品列表、文章列表,列表会绑定两个模版地址一是列表模版、二是内容模版;
8、封面:例如关于我们、联系方式这些都属于单篇模版;
9、文章是必须发布在最终子栏目;
10、自定义模型,如果文章现有的字段无法满足可以通过自定义模型来满足,通过[field:*/]获取自定义属性。\r\n
\r\n
\r\n
该标签作用是获取后台变量管理中的配置项。该标签属于单标签,也可以写成{dreamer-cms:variable name=”xxx”}{/dreamer-cms:variable}。该标签只有一个属性 name,并适用于所有模版。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
name | \r\ncfg_github_addr | \r\n后台变量管理中的变量名 | \r\n
<section id=\"action\" class=\"call-to-action-2\">\r\n <div class=\"container-fluid\">\r\n <div class=\"row\">\r\n <div class=\"col-12\">\r\n <div class=\"call-to-action-wrap\">\r\n <div class=\"call-to-action-title\">\r\n <div class=\"text-center\"><a href=\"{dreamer-cms:variable name=\'cfg_gitee_addr\'/}\" class=\"btn btn-primary main-btn\">源码下载</a></div>\r\n <h3>梦想家CMS内容管理系统支持码云、Github等多种渠道下载。</h3>\r\n </div>\r\n <div class=\"list-wrap\">\r\n <ul class=\"list-inline applications\">\r\n <li class=\"list-inline-item\"><a href=\"{dreamer-cms:variable name=\'cfg_gitee_addr\'/}\"><img src=\"{dreamer-cms:template /}images/app1.png\" alt=\"Application\"></a></li>\r\n <li class=\"list-inline-item\"><a href=\"{dreamer-cms:variable name=\'cfg_github_addr\'/}\"><img src=\"{dreamer-cms:template /}images/app2.png\" alt=\"Application\"></a></li>\r\n </ul>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n </div>\r\n</section>\r\n
\r\n', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 2, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 17:21:18', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('b0bb4daa71694c0ebdb59a986d11684f', '合作伙伴', 'partner', '2jk6313y', '.2jk6313y', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 2, '', '', '/list_partner.html', '/list_partner.html', '', 'md', '', '', '-1', 0, '1', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:59:32', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:52:52', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('b2cca489d9e14f4e8e291c59308d1ae0', '栏目标签', 'Type Label', '1765m053', '.822n58d3.u8xo56nx.1765m053', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 变量标签dreamer-cms:type\r\n### 1.标签说明\r\n该标签作用是获取指定栏目的内容。该标签只有一个属性typeid,并适用于所有模版。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目\r\n\r\n### 2.返回字段说明\r\n\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\ntypeid|String|栏目ID\r\ntypenamecn|String|栏目中文名称\r\ntypenameen|String|栏目英文名称\r\ntypecode|String|栏目编码(8位唯一)\r\ntypeseq|String|栏目的层级\r\ntypeimg|String|栏目图片\r\ndescription|String|栏目描述\r\nlinktarget|String|链接目标\r\npagesize|Integer|分页大小(该属性控制列表页面默认的分页大小)\r\nvisiturl|String|访问URL(浏览器地址栏中将以该url显示,如果为空,则为栏目中文名称的拼音)\r\nlinkurl|String|链接URL\r\neditor|String|编辑器(md或ue)\r\nmdcontent|String|markdown内容\r\nhtmlcontent|String|生成的html内容\r\nparentname|String|上级栏目名称\r\nisshow|Integer|是否显示\r\nlevel|Integer|栏目层级\r\nsort|Integer|排序(默认为50)\r\ncreateby|String|创建人\r\ncreatetime|Date|创建时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\ntypeurl|String|栏目URL\r\next01|String|扩展字段1\r\next02|String|扩展字段2\r\next03|String|扩展字段3\r\next04|String|扩展字段4\r\next05|String|扩展字段5\r\nhaschildren|Boolean|是否有下级栏目(该属性在dreamer-cms:type标签下不可用)\r\n\r\n### 3.示例代码\r\n```html\r\n
该标签作用是获取指定栏目的内容。该标签只有一个属性typeid,并适用于所有模版。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
typeid | \r\n4ol61bbh | \r\n后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目 | \r\n
属性名 | \r\n字段类型 | \r\n描述 | \r\n
---|---|---|
typeid | \r\nString | \r\n栏目ID | \r\n
typenamecn | \r\nString | \r\n栏目中文名称 | \r\n
typenameen | \r\nString | \r\n栏目英文名称 | \r\n
typecode | \r\nString | \r\n栏目编码(8位唯一) | \r\n
typeseq | \r\nString | \r\n栏目的层级 | \r\n
typeimg | \r\nString | \r\n栏目图片 | \r\n
description | \r\nString | \r\n栏目描述 | \r\n
linktarget | \r\nString | \r\n链接目标 | \r\n
pagesize | \r\nInteger | \r\n分页大小(该属性控制列表页面默认的分页大小) | \r\n
visiturl | \r\nString | \r\n访问URL(浏览器地址栏中将以该url显示,如果为空,则为栏目中文名称的拼音) | \r\n
linkurl | \r\nString | \r\n链接URL | \r\n
editor | \r\nString | \r\n编辑器(md或ue) | \r\n
mdcontent | \r\nString | \r\nmarkdown内容 | \r\n
htmlcontent | \r\nString | \r\n生成的html内容 | \r\n
parentname | \r\nString | \r\n上级栏目名称 | \r\n
isshow | \r\nInteger | \r\n是否显示 | \r\n
level | \r\nInteger | \r\n栏目层级 | \r\n
sort | \r\nInteger | \r\n排序(默认为50) | \r\n
createby | \r\nString | \r\n创建人 | \r\n
createtime | \r\nDate | \r\n创建时间 | \r\n
updateby | \r\nString | \r\n更新人 | \r\n
updatetime | \r\nDate | \r\n更新时间 | \r\n
typeurl | \r\nString | \r\n栏目URL | \r\n
ext01 | \r\nString | \r\n扩展字段1 | \r\n
ext02 | \r\nString | \r\n扩展字段2 | \r\n
ext03 | \r\nString | \r\n扩展字段3 | \r\n
ext04 | \r\nString | \r\n扩展字段4 | \r\n
ext05 | \r\nString | \r\n扩展字段5 | \r\n
haschildren | \r\nBoolean | \r\n是否有下级栏目(该属性在dreamer-cms:type标签下不可用) | \r\n
<div class=\"row\">\r\n <div class=\"col-12 mt-5\">\r\n {dreamer-cms:type typeid=\"A54547W2\"}\r\n <div class=\"text-center\"><a href=\"[field:typeurl/]\" class=\"btn btn-primary main-btn btn-reload\"><i class=\"fa fa-spinner fa-spin\"></i> 查看更多</a></div>\r\n {/dreamer-cms:type}\r\n </div>\r\n</div>\r\n
\r\n', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 5, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 18:08:54', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('b86a0c79aec447d78afb7d25111eae1a', '模版制作', 'Template making', '24is7n55', '.822n58d3.24is7n55', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '', '', 'ce1c25b233c0422bb136c27aca4b38f4', 1, '2', 53, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 15:48:31', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('bd2ff1d7e4174078ab573457507f7a08', '栏目内容列表', 'Category Article List', 'h56yw2e9', '.822n58d3.u8xo56nx.h56yw2e9', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 栏目内容列表标签dreamer-cms:categoryartlist\r\n### 1.标签说明\r\n这个标签是系统中唯一的一个支持嵌套的标签,这个标签通常使用在首页(含封面首页),用于输出一组栏目内容列表,主要用于获取下级栏目的内容列表标签并适用于所有模版,通常用于网站内容列表等信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目\r\nlength|5|获取个数\r\n\r\n### 2.返回字段说明\r\n参照channel和list标签返回字段说明\r\n\r\n### 3.示例代码\r\n```html\r\n
这个标签是系统中唯一的一个支持嵌套的标签,这个标签通常使用在首页(含封面首页),用于输出一组栏目内容列表,主要用于获取下级栏目的内容列表标签并适用于所有模版,通常用于网站内容列表等信息。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
typeid | \r\n4ol61bbh | \r\n后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目 | \r\n
length | \r\n5 | \r\n获取个数 | \r\n
参照channel和list标签返回字段说明
\r\n<ul class=\"nav navbar-nav mr-auto\">\r\n <li class=\"nav-item active\"><a class=\"nav-link scroll\" href=\"/\">首页</a></li>\r\n {dreamer-cms:categoryartlist length=\"1\"}\r\n {dreamer-cms:if test=\"(\'true\' eq [field:haschildren/])\"}\r\n <li class=\"dropdown nav-item\"><a href=\"[field:typeurl/]\" class=\"nav-link dropdown-toggle\" data-toggle=\"dropdown\">[field:typenamecn /]</a>\r\n <ul class=\"dropdown-menu\">\r\n {dreamer-cms:channel}\r\n <li><a class=\"dropdown-item\" href=\"[field:typeurl/]\"><i class=\"ion ion-chevron-right\"></i>[field:typenamecn /]</a></li>\r\n {/dreamer-cms:channel}\r\n </ul>\r\n </li>\r\n {/dreamer-cms:if}\r\n {dreamer-cms:if test=\"(\'false\' eq [field:haschildren/])\"}\r\n <li class=\"nav-item\"><a class=\"nav-link scroll\" href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n {/dreamer-cms:if}\r\n {/dreamer-cms:categoryartlist}\r\n</ul>\r\n
\r\n', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 8, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:00:03', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('c057161b83274a708265da8808cb8f87', '概要', 'outline', 'xk315i87', '.822n58d3.xk315i87', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, '', '/document.html', '', '', '', 'ue', '# 梦想家CMS内容管理系统开源版J2EE代码\r\n\r\n当前版本:1.0.1\r\n\r\n梦想家CMS官网:[http://www.itechyou.cn](www.itechyou.cn)\r\n\r\nQQ群交流:\r\n- ①597652651\r\n\r\nDreamer CMS 梦想家内容发布系统是国内首款java开发的内容发布系统,采用最流行的springboot+thymeleaf框架搭建,灵活小巧,配置简单。\r\n\r\n# 特点\r\n* 免费完整开源:基于MIT协议,源代码完全开源;\r\n* 标签化建站:不需要专业的后台开发技能,只要使用系统提供的标签,就能轻松建设网站;\r\n* 模版开发方便:支持在线上传模版包开发方便快捷;\r\n* 每月更新:每月进行系统升级,分享更多好用的模版与插件;\r\n\r\n# 面向对象\r\n* Dreamer CMS是企业在创立初期很好的技术基础框架,加快公司项目开发进度,当然也可以对现有的系统进行升级;\r\n* 个人开发者也可以使用Dreamer CMS承接外包项目;\r\n* 初学JAVA的同学可以下载源代码来进行学习交流;\r\n\r\n# 技术框架\r\n* 核心框架:Spring Boot 2\r\n* 安全框架:Apache Shiro 1.5\r\n* 视图框架:Spring MVC 4\r\n* 持久层框架:MyBatis 3\r\n* 日志管理:Log4j2\r\n* 模版框架:Thymeleaf\r\n* JS框架:jQuery,Bootstrap\r\n* CSS框架:Bootstrap\r\n* 富文本:Ueditor、editor.md\r\n\r\n# 系统结构\r\n\r\n\r\n# 开发环境\r\n建议开发者使用以下环境,这样避免版本带来的问题\r\n* IDE:Spring Tool Suite(STS)\r\n* DB:Mysql 5.7\r\n* JDK:jdk8\r\n\r\n# 快速入门\r\n* 克隆项目到本地\r\n* 导入Eclipse或Sts等开发工具\r\n* 项目需要Redis,请自行修改application.yml中Redis配置\r\n* 将项目主页附件标签页里的dreamer-blog.zip附件下载并解压到D盘根目录\r\n* 运行项目DreamerBlogApplication.java\r\n* 项目首页:http://localhost:8888;项目管理后台:http://localhost:8888/admin\r\n* 管理后台用户名:wangjn;密码:123456\r\n\r\n# 系统美图\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '
DreamerCMS(梦想家CMS内容管理系统)公开解决了快速搭建展示型网站(如:企业官网、技术博客、信息门户等)的框架体系,是电子政务、电信综合门户、企业信息门户、知识管理平台、电子商务平台的基础性软件系统。可以帮助政府、企业或组织灵活、准确、高效、智能地管理信息内容,实现信息的采集、加工、审核、发布、存储、检索、统计、分析、 反馈等整个信息生命周期的管理。采用时下最流行的Springboot+thymeleaf框架搭建,具有灵活小巧,配置简单,标签化模版,快速开发等特点。主要解决公司搭建网站成本高、投入大、周期长等问题,也可作为初创公司很好的基础技术框架。使用过程中不需要专业的后端技术开发技能,只要使用系统提供的模版标签,即可轻轻松松建设网站。
DreamerCMS从2.0.0版本开始采用了解析式引擎与编译式引擎并存的模式,由于在解析模版时,解析式引擎拥有巨大的优势,但对于动态浏览的互动性质的页面,编译式引擎更实用高效,DreamerCMS采用双引擎并存的模式,在保持标签风格一致性的同时,也保证将来开发更多互动模块时有更好的性能和更好的扩展。
CMS包括两个部分(代码部分、资源部分)代码不多说。资源就是图片、模版等,该目录在application.yml中web.resource-path配置项目中配置。视频教程:
链接:https://pan.baidu.com/s/1plsfBl_ds_5TkVa-yRkESQ
提取码:2c8i
1、克隆项目到本地工作空间
2、导入Eclipse或Sts等开发工具(推荐使用Spring Tools Suite 4)(项目中缺少的google/kaptcha.jar在附件中,大家自行下载)
3、项目需要Redis,请自行修改application.yml中Redis配置
4、修改项目资源目录,application.yml文件web.resource-path配置项(如D:/dreamer-cms/)
5、将项目src/main/resources/db/dreamer-cms.zip文件解压,保证解压后的目录路径的名称和资源目录一致
6、运行项目DreamerCMSApplication.java
7、网站首页:http://localhost:8888 项目管理后台:http://localhost:8888/admin
8、管理后台用户名:wangjn;密码:123456
9、模版标签开发教程请参考:http://doc.itechyou.cn
该标签作用是引入其它模板的内容,以方便拆分头部、尾部等公共部分。该标签属于单标签,也可以写成{dreamer-cms:include file=”xxx.html”}{/dreamer-cms:include}。该标签只有一个file属性,并适用于所有模版,建议使用单标签
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
file | \r\nheader.html | \r\n引入当前模版同目录下的名为header.html的头部模版 | \r\n
{dreamer-cms:include file=\'header.html\'/}\r\n
\r\n', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 4, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 17:59:27', NULL, '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('d9c8397d7474485e879b4e5d58992609', '模版路径标签', 'Template Path Label', 'a44xd784', '.822n58d3.u8xo56nx.a44xd784', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 变量标签dreamer-cms:template\r\n### 1.标签说明\r\n该标签作用是获取当前模板的路径,以方便加载静态资源。该标签属于单标签,也可以写成{dreamer-cms:template}{/dreamer-cms:template}。该标签没有属性,并适用于所有模版,建议使用单标签\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\n无|无|无\r\n\r\n### 2.示例代码\r\n```html\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n```\r\n### 3.效果\r\n无', '
该标签作用是获取当前模板的路径,以方便加载静态资源。该标签属于单标签,也可以写成{dreamer-cms:template}{/dreamer-cms:template}。该标签没有属性,并适用于所有模版,建议使用单标签
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
无 | \r\n无 | \r\n无 | \r\n
<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}bootstrap/css/bootstrap.min.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/font-awesome.min.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}plugins/slick/slick.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}plugins/slick/slick-theme.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/app.css\">\r\n<link rel=\"stylesheet\" href=\"{dreamer-cms:template /}css/responsive.css\">\r\n<script src=\"{dreamer-cms:template /}js/jquery-3.2.1.slim.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}bootstrap/js/bootstrap.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}js/popper.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}plugins/slick/slick.min.js\"></script>\r\n<script src=\"{dreamer-cms:template /}js/app.js\"></script>\r\n
\r\n无
', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 3, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-19 17:53:42', NULL, '2020-07-22 15:51:14', '', '', '', '', ''); INSERT INTO `cms_category` VALUES ('d9fea2574384477199d038ac66ebd095', '框架特点', 'feature', 'tnleskz4', '.4ol61bbh.tnleskz4', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', '4e1c58e65fa9423482cf1a29a6ef629b', 0, '2', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:33:50', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:51:23', '', '', '', '', ''); INSERT INTO `cms_category` VALUES ('dc10045aed08446bb2d0e5c5d5bf1ae7', '频道标签', 'Channel Label', '6y146016', '.822n58d3.u8xo56nx.6y146016', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 频道标签dreamer-cms:channel\r\n### 1.标签说明\r\n该标签是常用标记,主要用于显示页面的栏目分类并适用于所有模版,通常用于网站顶部以获取站点栏目信息。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntypeid|4ol61bbh|后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目\r\nstart|0|从第几个开始获取\r\nlength|5|获取个数\r\ntype|top或son|显示类型(top为顶级栏目,son在设置typeid时起作用,获取指定栏目的下级栏目)\r\nshowall|true或false|是否显示隐藏栏目\r\n\r\n### 2.返回字段说明\r\n\r\n属性名|字段类型|描述\r\n:--:|:--:|:--:\r\ntypeid|String|栏目ID\r\ntypenamecn|String|栏目中文名称\r\ntypenameen|String|栏目英文名称\r\ntypecode|String|栏目编码(8位唯一)\r\ntypeseq|String|栏目的层级\r\ntypeimg|String|栏目图片\r\ndescription|String|栏目描述\r\nlinktarget|String|链接目标\r\npagesize|Integer|分页大小(该属性控制列表页面默认的分页大小)\r\nvisiturl|String|访问URL(浏览器地址栏中将以该url显示,如果为空,则为栏目中文名称的拼音)\r\nlinkurl|String|链接URL\r\neditor|String|编辑器(md或ue)\r\nmdcontent|String|markdown内容\r\nhtmlcontent|String|生成的html内容\r\nparentname|String|上级栏目名称\r\nisshow|Integer|是否显示\r\nlevel|Integer|栏目层级\r\nsort|Integer|排序(默认为50)\r\ncreateby|String|创建人\r\ncreatetime|Date|创建时间\r\nupdateby|String|更新人\r\nupdatetime|Date|更新时间\r\ntypeurl|String|栏目URL\r\next01|String|扩展字段1\r\next02|String|扩展字段2\r\next03|String|扩展字段3\r\next04|String|扩展字段4\r\next05|String|扩展字段5\r\nhaschildren|Boolean|是否有下级栏目(该属性在dreamer-cms:type标签下不可用)\r\n\r\n### 3.示例代码\r\n```html\r\n该标签是常用标记,主要用于显示页面的栏目分类并适用于所有模版,通常用于网站顶部以获取站点栏目信息。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
typeid | \r\n4ol61bbh | \r\n后台栏目管理列表页面中的编码,通过唯一编码,获取指定栏目 | \r\n
start | \r\n0 | \r\n从第几个开始获取 | \r\n
length | \r\n5 | \r\n获取个数 | \r\n
type | \r\ntop或son | \r\n显示类型(top为顶级栏目,son在设置typeid时起作用,获取指定栏目的下级栏目) | \r\n
showall | \r\ntrue或false | \r\n是否显示隐藏栏目 | \r\n
属性名 | \r\n字段类型 | \r\n描述 | \r\n
---|---|---|
typeid | \r\nString | \r\n栏目ID | \r\n
typenamecn | \r\nString | \r\n栏目中文名称 | \r\n
typenameen | \r\nString | \r\n栏目英文名称 | \r\n
typecode | \r\nString | \r\n栏目编码(8位唯一) | \r\n
typeseq | \r\nString | \r\n栏目的层级 | \r\n
typeimg | \r\nString | \r\n栏目图片 | \r\n
description | \r\nString | \r\n栏目描述 | \r\n
linktarget | \r\nString | \r\n链接目标 | \r\n
pagesize | \r\nInteger | \r\n分页大小(该属性控制列表页面默认的分页大小) | \r\n
visiturl | \r\nString | \r\n访问URL(浏览器地址栏中将以该url显示,如果为空,则为栏目中文名称的拼音) | \r\n
linkurl | \r\nString | \r\n链接URL | \r\n
editor | \r\nString | \r\n编辑器(md或ue) | \r\n
mdcontent | \r\nString | \r\nmarkdown内容 | \r\n
htmlcontent | \r\nString | \r\n生成的html内容 | \r\n
parentname | \r\nString | \r\n上级栏目名称 | \r\n
isshow | \r\nInteger | \r\n是否显示 | \r\n
level | \r\nInteger | \r\n栏目层级 | \r\n
sort | \r\nInteger | \r\n排序(默认为50) | \r\n
createby | \r\nString | \r\n创建人 | \r\n
createtime | \r\nDate | \r\n创建时间 | \r\n
updateby | \r\nString | \r\n更新人 | \r\n
updatetime | \r\nDate | \r\n更新时间 | \r\n
typeurl | \r\nString | \r\n栏目URL | \r\n
ext01 | \r\nString | \r\n扩展字段1 | \r\n
ext02 | \r\nString | \r\n扩展字段2 | \r\n
ext03 | \r\nString | \r\n扩展字段3 | \r\n
ext04 | \r\nString | \r\n扩展字段4 | \r\n
ext05 | \r\nString | \r\n扩展字段5 | \r\n
haschildren | \r\nBoolean | \r\n是否有下级栏目(该属性在dreamer-cms:type标签下不可用) | \r\n
<div class=\"popup\" id=\"popup\">\r\n <div class=\"popup-content\"><div class=\"left-slide-sidebar \">\r\n <div class=\"canvas-title\">DreamerCMS MENUS</div>\r\n <ul class=\"list-unstyled slide-sidebar\">\r\n <li><a href=\"#\">首页</a></li>\r\n {dreamer-cms:channel type=\'top\' currentstyle=\"\"}\r\n <li><a href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n {/dreamer-cms:channel}\r\n </ul>\r\n </div>\r\n <a href=\"#close\" class=\"popup-close\">×</a>\r\n </div>\r\n</div>\r\n
\r\n', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 6, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 09:38:41', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('dfd4ca19e29841d99a33cc4829b7033a', '免费开源', 'opensource', '01k96rfd', '.4ol61bbh.tnleskz4.01k96rfd', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 20, 1, '', '/framework.html', '', '', '', 'md', '', '', 'd9fea2574384477199d038ac66ebd095', 0, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 16:46:53', '9f4b807db2e94670bb02cdc212ea7389', '2021-01-26 03:51:05', 'fa fa-github', '', '', '', '');
INSERT INTO `cms_category` VALUES ('e5297d56df9a4e8ead60c4347e2dd5c4', '开发社区', 'community', '71e2w1xx', '.71e2w1xx', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 3, '', '', '', '', 'http://www.itechyou.cn', 'md', '', '', '-1', 1, '1', 6, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:55:33', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', '');
INSERT INTO `cms_category` VALUES ('e65a0268deb14b9fa7cd6c057034e886', '判断标签', 'If Label', 'g4x40i76', '.822n58d3.u8xo56nx.g4x40i76', 'c17ddcad9fb149a6bf90f7bba0e0696b', '', '', '1', 10, 1, 'document', '/document.html', '', '', '', 'md', '# 判断标签dreamer-cms:if\r\n### 1.标签说明\r\n这个标签是用于在页面中作简单的判断,目前只支持eq和neq。\r\n\r\n属性名|取值范围|描述\r\n:--:|:--:|:--:\r\ntest|(\'true\' eq [field:haschildren/])|表达式(注:一定要用小括号包裹,目前只支持eq和neq。)\r\n\r\n### 2.返回字段说明\r\n无\r\n\r\n### 3.示例代码\r\n```html\r\n{dreamer-cms:if test=\"(\'true\' eq [field:haschildren/])\"}\r\n
这个标签是用于在页面中作简单的判断,目前只支持eq和neq。
\r\n属性名 | \r\n取值范围 | \r\n描述 | \r\n
---|---|---|
test | \r\n(‘true’ eq [field:haschildren/]) | \r\n表达式(注:一定要用小括号包裹,目前只支持eq和neq。) | \r\n
无
\r\n{dreamer-cms:if test=\"(\'true\' eq [field:haschildren/])\"}\r\n<li class=\"dropdown nav-item\"><a href=\"[field:typeurl/]\" class=\"nav-link dropdown-toggle\" data-toggle=\"dropdown\">[field:typenamecn /]</a>\r\n <ul class=\"dropdown-menu\">\r\n {dreamer-cms:channel}\r\n <li><a class=\"dropdown-item\" href=\"[field:typeurl/]\"><i class=\"ion ion-chevron-right\"></i>[field:typenamecn /]</a></li>\r\n {/dreamer-cms:channel}\r\n </ul>\r\n</li>\r\n{/dreamer-cms:if}\r\n{dreamer-cms:if test=\"(\'false\' eq [field:haschildren/])\"}\r\n<li class=\"nav-item\"><a class=\"nav-link scroll\" href=\"[field:typeurl /]\" title=\"[field:typenamecn /]\">[field:typenamecn /]</a></li>\r\n{/dreamer-cms:if}\r\n
\r\n无
', '8923a09d403f49a289f3af780dcca0c2', 1, '3', 50, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 10:42:23', NULL, '2020-07-22 15:51:14', '', '', '', '', ''); INSERT INTO `cms_category` VALUES ('e6cdbf119da14a30a86a0f9f2189b8e5', '模版中心', 'templates', 'a54547w2', '.a54547w2', '9b5112043c2240d8823bd15759c67604', '', '', '1', 10, 2, 'templates', '', '/list_templates.html', '/article_templates.html', '', 'md', '', '', '-1', 1, '1', 5, 0, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 15:55:05', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 15:51:14', '', '', '', '', ''); -- ---------------------------- -- Table structure for cms_evaluate -- ---------------------------- DROP TABLE IF EXISTS `cms_evaluate`; CREATE TABLE `cms_evaluate` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID', `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `evaluator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_evaluate -- ---------------------------- INSERT INTO `cms_evaluate` VALUES ('02238eaa19b44f7bbb2203f01a92ee8f', '18f228df7b8443dfa1039fe3c3e53503', NULL, NULL, NULL, NULL, NULL, '程雨', 'www.xinhudong.com.cn', 'Dreamer CMS是企业在创立初期很好的技术基础框架,加快公司项目开发进度,当然也可以对现有的系统进行升级'); INSERT INTO `cms_evaluate` VALUES ('c70f70e7dd5a4cfa87e0d5c89cfb6ff7', '779bc296ea4a4149bd3c97cdb8cd8593', NULL, NULL, NULL, NULL, NULL, '王俊南', 'www.itechyou.cn', '标签化建站:不需要专业的后台开发技能,只要使用系统提供的标签,就能轻松建设网站;模版开发方便:支持在线上传模版包开发方便快捷'); INSERT INTO `cms_evaluate` VALUES ('63aac7b1d6ca4f81ac051b2e8d79198f', 'e738f12d050849fd9998ac01fd0f5ad7', NULL, NULL, NULL, NULL, NULL, '王亚伟', 'www.itechyou.cn', '免费完整开源:基于Apache2.0协议,源代码完全开源;初学JAVA的同学可以下载源代码来进行学习交流'); -- ---------------------------- -- Table structure for cms_fields -- ---------------------------- DROP TABLE IF EXISTS `cms_fields`; CREATE TABLE `cms_fields` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `form_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `field_text` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段提示名', `field_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段名', `type` int NULL DEFAULT 1 COMMENT '类型:0系统自动生成表单字段', `data_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据类型', `default_value` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认值', `max_length` int NULL DEFAULT NULL COMMENT '最大长度', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NOT NULL, `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字段' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_fields -- ---------------------------- INSERT INTO `cms_fields` VALUES ('01a3d20d81f24d678d50238fcd5892ca', 'c17ddcad9fb149a6bf90f7bba0e0696b', '文章内容', 'content', 1, 'html', '', 200, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-21 11:51:24', NULL, '2018-09-21 11:51:24', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('125fcd235ab5419ca50e513485f359cf', '9b5112043c2240d8823bd15759c67604', '内容', 'body', 1, 'html', '', 200, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-20 11:30:53', NULL, '2019-08-20 11:30:53', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('574d8ab867e948a4ab8bed0eb9162bf1', '440dc002ad4846018d7a1b9433021b22', '版本号', 'versionnum', 1, 'varchar', '', 128, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:17:06', NULL, '2019-08-16 10:17:06', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('74e71cc418494c18bd2b2026fa0b21db', '440dc002ad4846018d7a1b9433021b22', '升级说明', 'notes', 1, 'markdown', '', 1024, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:17:51', NULL, '2019-08-16 10:17:51', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('86601971f1bb47bd81e06f2167ba4398', '06c540abf3a64d9699762711439c82dd', '客户来源', 'source', 1, 'varchar', '', 255, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:05:41', NULL, '2019-08-16 09:05:41', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('a2b7dcd22d1042ef929e2d17c97e747c', '02c73a0271644e8c91cf2400d9325e93', '链接地址', 'link_url', 1, 'varchar', '', 256, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-25 14:33:17', NULL, '2018-09-25 14:33:16', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('a7be21842fc14c108fb779dd1826f6b6', '33a091d40c5e484b880daa744ef4e8aa', '电话', 'telephone', 1, 'varchar', '', 32, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:18:20', NULL, '2020-07-22 14:18:20', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('dddaf4417cec46ed86571035a50d17a7', '33a091d40c5e484b880daa744ef4e8aa', '内容', 'content', 1, 'textarea', '', 500, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:24:03', NULL, '2020-07-22 14:24:03', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('e67c80193b63443d8587971590fba810', '33a091d40c5e484b880daa744ef4e8aa', '回复内容', 'reply', 1, 'textarea', '', 500, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 07:46:47', NULL, '2020-07-22 15:46:47', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('e7d3405934a148c19a7fc1327551a146', '06c540abf3a64d9699762711439c82dd', '评价内容', 'content', 1, 'textarea', '', 200, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:06:19', NULL, '2019-08-16 09:06:19', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_fields` VALUES ('f312ae651c254b0b88bf090ae3db6c3f', '06c540abf3a64d9699762711439c82dd', '评价人', 'evaluator', 1, 'varchar', '', 64, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:05:18', NULL, '2019-08-16 09:05:18', NULL, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for cms_forms -- ---------------------------- DROP TABLE IF EXISTS `cms_forms`; CREATE TABLE `cms_forms` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `form_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表单名', `table_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表名', `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '编码系统自动生成', `type` int NULL DEFAULT 1 COMMENT '类型:0系统模型,1自定义模型', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NOT NULL, `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '表单' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_forms -- ---------------------------- INSERT INTO `cms_forms` VALUES ('02c73a0271644e8c91cf2400d9325e93', '友情链接', 'links', '80AZ783M', 1, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-25 14:30:02', NULL, '2018-09-25 14:30:01', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_forms` VALUES ('06c540abf3a64d9699762711439c82dd', '客户评价', 'evaluate', '2EFPN7JY', 1, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 09:04:22', NULL, '2019-08-16 09:04:22', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_forms` VALUES ('33a091d40c5e484b880daa744ef4e8aa', '留言管理', 'message', '8t2lkr8d', 1, '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:10:04', '9f4b807db2e94670bb02cdc212ea7389', '2020-07-22 06:10:36', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_forms` VALUES ('440dc002ad4846018d7a1b9433021b22', '更新记录', 'versionnotes', 'LUVC0AW2', 1, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-16 10:16:31', NULL, '2019-08-16 10:16:31', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_forms` VALUES ('9b5112043c2240d8823bd15759c67604', '模版中心', 'templates', '3NF20KCW', 1, '9f4b807db2e94670bb02cdc212ea7389', '2019-08-15 17:26:20', NULL, '2019-08-15 17:26:20', NULL, NULL, NULL, NULL, NULL); INSERT INTO `cms_forms` VALUES ('c17ddcad9fb149a6bf90f7bba0e0696b', '普通文章', 'article', 'V1WL66A0', 0, '9f4b807db2e94670bb02cdc212ea7389', '2018-09-12 09:59:38', NULL, '2018-09-12 10:26:00', 'selected', NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for cms_labels -- ---------------------------- DROP TABLE IF EXISTS `cms_labels`; CREATE TABLE `cms_labels` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `tag_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签名称', `pinyin` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拼音', `first_char` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '首字母', `tag_count` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标签使用次数', `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT '2018-01-01 00:00:00', `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '标签' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_labels -- ---------------------------- INSERT INTO `cms_labels` VALUES ('241d2e14a9764795acc29ff6b4ef0a4a', 'hbase', 'hbase', 'h', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08'); INSERT INTO `cms_labels` VALUES ('27ee21fd44ee4b3996d2546e700ca68a', 'css', 'css', 'c', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:09'); INSERT INTO `cms_labels` VALUES ('2df0b5c5dc474fc38969ce4fab5b1ee7', '花开', 'huakai', 'h', '1', NULL, '2018-09-21 13:40:16', NULL, '2018-09-21 13:40:15'); INSERT INTO `cms_labels` VALUES ('30b42859b3b2400396b123947fb4f5b4', '单例', 'danli', 'd', '1', NULL, '2018-09-27 10:54:28', NULL, '2018-09-27 10:54:28'); INSERT INTO `cms_labels` VALUES ('3459b5788ec04732b336c484db6c8806', '大数据', 'dashuju', 'd', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08'); INSERT INTO `cms_labels` VALUES ('3808d4ebd78a4861bc49cf3d653000aa', '职业发展', 'zhiyefazhan', 'z', '1', NULL, '2018-09-21 13:44:36', NULL, '2018-09-21 13:44:35'); INSERT INTO `cms_labels` VALUES ('4ccffe77671a4c3bbbf7854fdc44d0c8', 'css3', 'css3', 'c', '1', NULL, '2019-08-20 11:32:05', NULL, '2019-08-20 11:32:05'); INSERT INTO `cms_labels` VALUES ('5b471f24146144899e5227a5dc4eaadd', '原型', 'yuanxing', 'y', '1', NULL, '2018-09-27 11:19:00', NULL, '2018-09-27 11:18:59'); INSERT INTO `cms_labels` VALUES ('5e7586fcb4d44c15a3d94e93f6281c54', 'eee', 'eee', 'e', '1', NULL, '2019-12-18 02:18:59', NULL, '2019-12-18 10:18:59'); INSERT INTO `cms_labels` VALUES ('77eae8930c30458aac733a4e778ba498', '商务', 'shangwu', 's', '1', NULL, '2019-08-21 16:47:41', NULL, '2019-08-21 16:47:41'); INSERT INTO `cms_labels` VALUES ('8daeee953c764a33ba2c91ae0f3610b7', 'html5', 'html5', 'h', '1', NULL, '2019-08-20 11:32:05', NULL, '2019-08-20 11:32:05'); INSERT INTO `cms_labels` VALUES ('96f315f72dfa498e8e65afe85a22775e', 'hive', 'hive', 'h', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08'); INSERT INTO `cms_labels` VALUES ('a49146f9af0b43a592998f6072af08bf', 'html', 'html', 'h', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:08'); INSERT INTO `cms_labels` VALUES ('a8e12dfe133a4bd8808e029f8a8c4a05', 'eeee', 'eeee', 'e', '1', NULL, '2019-12-18 02:21:34', NULL, '2019-12-18 10:21:34'); INSERT INTO `cms_labels` VALUES ('a96f5f9c526d447cbee797b2536af1b3', '要强', 'yaoqiang', 'y', '1', NULL, '2018-09-21 13:42:05', NULL, '2018-09-21 13:42:04'); INSERT INTO `cms_labels` VALUES ('a9d47da353be4e10aac3e1e23338862a', 'js', 'js', 'j', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:08'); INSERT INTO `cms_labels` VALUES ('cd6cd19104ab4bdf86bad96c0c9ac0cf', 'factory', 'factory', 'f', '1', NULL, '2018-09-27 11:16:22', NULL, '2018-09-27 11:16:21'); INSERT INTO `cms_labels` VALUES ('d51ddfca743b47f686120300691cecd0', '工厂模式', 'gongchangmoshi', 'g', '1', NULL, '2018-09-27 11:16:22', NULL, '2018-09-27 11:16:21'); INSERT INTO `cms_labels` VALUES ('e281ef86dfbb4d75b8141f8abfb7291b', '建造者', 'jianzaozhe', 'j', '1', NULL, '2018-09-27 11:19:00', NULL, '2018-09-27 11:18:59'); INSERT INTO `cms_labels` VALUES ('e39a57377c814132b9db8d7c1105a3db', 'qqq', 'qqq', 'q', '1', NULL, '2019-12-18 02:34:41', NULL, '2019-12-18 10:34:41'); INSERT INTO `cms_labels` VALUES ('e4bf078774b840b5a13eafa48c03a3a7', 'singleton', 'singleton', 's', '1', NULL, '2018-09-27 10:54:28', NULL, '2018-09-27 10:54:27'); INSERT INTO `cms_labels` VALUES ('e6d72c095f9c4532a298337e6a612c22', 'script', 'script', 's', '1', NULL, '2018-09-21 12:47:09', NULL, '2018-09-21 12:47:09'); INSERT INTO `cms_labels` VALUES ('f4d45bfa3b284792b6411390831063d7', 'bootstrap', 'bootstrap', 'b', '1', NULL, '2019-08-20 11:32:05', NULL, '2019-08-20 11:32:05'); INSERT INTO `cms_labels` VALUES ('f55bab7dc7234dfa9883c181e8d29825', 'hadoop', 'hadoop', 'h', '1', NULL, '2018-09-27 11:29:08', NULL, '2018-09-27 11:29:08'); INSERT INTO `cms_labels` VALUES ('fdf1a43c32a7454dbfd42626ec4d4263', 'thymeleaf', 'thymeleaf', 't', '1', NULL, '2018-09-28 16:52:32', NULL, '2018-09-28 16:52:31'); -- ---------------------------- -- Table structure for cms_links -- ---------------------------- DROP TABLE IF EXISTS `cms_links`; CREATE TABLE `cms_links` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID', `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `link_url` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '外链' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_links -- ---------------------------- INSERT INTO `cms_links` VALUES ('00de5fcc84f44d07ba2fd3b80098dd3a', '47864f1e06334cdc8c87b9419dc63abf', NULL, NULL, NULL, NULL, NULL, 'http://www.itechyou.cn'); INSERT INTO `cms_links` VALUES ('60534518cfa04fb8bc864119035f6970', '598fb8d59fbf4bdca544d71cb64c1ce0', NULL, NULL, NULL, NULL, NULL, 'http://www.baidu.com'); -- ---------------------------- -- Table structure for cms_message -- ---------------------------- DROP TABLE IF EXISTS `cms_message`; CREATE TABLE `cms_message` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID', `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `telephone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `content` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, `reply` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_message -- ---------------------------- INSERT INTO `cms_message` VALUES ('5c41458ebf3849b5befe56a5b0b5d329', '495c981ae1be45fb8d989d76b2d18672', NULL, NULL, NULL, NULL, NULL, '13888888888', '你好,我们公司想要订购产品?请问是怎么个操作流程?', '订购产品加添加官方唯一指定微信:wangjn2015,我们会线上为您解答各种问题。'); INSERT INTO `cms_message` VALUES ('c9fc5f46c24d4619854224da9594b38d', '9736f68a332a48419178c5d3fdeb42bd', NULL, NULL, NULL, NULL, NULL, '13666664444', '我们是做产品直销的?有没有合作的意向?详情请联系QQ153095904', NULL); -- ---------------------------- -- Table structure for cms_search -- ---------------------------- DROP TABLE IF EXISTS `cms_search`; CREATE TABLE `cms_search` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `keywords` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文章标题', `create_time` datetime NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '搜索词' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_search -- ---------------------------- INSERT INTO `cms_search` VALUES ('0576a469a5d44f5189c15108c7faeab2', '商务展会', '2020-04-02 03:17:33'); INSERT INTO `cms_search` VALUES ('101784639d6f47b481bb60e910e0ff6e', '商务展会', '2020-04-02 03:26:18'); INSERT INTO `cms_search` VALUES ('144d69a4ddbd4a6788bee5d6e5d1f791', '商务展会', '2020-04-02 03:26:57'); INSERT INTO `cms_search` VALUES ('14ed5a98124c4715bc35ff76dc4e7e62', 'ddd', '2020-04-02 02:40:53'); INSERT INTO `cms_search` VALUES ('14fc6be9ee154f1c83601f1601805566', 'orion', '2020-04-02 02:41:44'); INSERT INTO `cms_search` VALUES ('190e8c68f24941cf8ba4717999d90135', 'ddd', '2020-04-02 02:39:04'); INSERT INTO `cms_search` VALUES ('199ed8841e4241cfbfc2f34a54185459', 'ddd', '2020-04-02 02:40:26'); INSERT INTO `cms_search` VALUES ('1fd26fcab46d4cb7bda59fba0b90b712', '商务展会', '2020-04-02 03:29:36'); INSERT INTO `cms_search` VALUES ('243b5395cb374d9d8cde05048fa76d23', 'kid', '2020-04-02 02:52:41'); INSERT INTO `cms_search` VALUES ('2525f2133f494568856f8ad44242bbf9', '商务展会', '2020-04-02 03:14:32'); INSERT INTO `cms_search` VALUES ('27b96c0b2575442cb34d62d1520865f0', '生命', '2018-09-25 16:55:49'); INSERT INTO `cms_search` VALUES ('38f9dd4448864a77b50a2753a01e6566', '123', '2018-09-29 10:13:52'); INSERT INTO `cms_search` VALUES ('3a009f62856e4b59b2bbbe8dc856ebe1', '生命', '2018-09-25 16:55:54'); INSERT INTO `cms_search` VALUES ('536dccc79be54304a0e5da5ab14b6d7e', '商务展会', '2020-04-02 03:26:20'); INSERT INTO `cms_search` VALUES ('549e965be5514399b45823dc45334159', '商务展会', '2020-04-02 03:19:24'); INSERT INTO `cms_search` VALUES ('5e0a340ef72d4a48ab79490da80c9787', 'ddd', '2020-04-02 01:35:31'); INSERT INTO `cms_search` VALUES ('62dd8ec00f014f679bf67971adea862d', '商务展会', '2020-04-02 03:13:45'); INSERT INTO `cms_search` VALUES ('665a4ff7f9274656b84d7591bafa6fa9', '商务展会', '2020-04-02 03:18:59'); INSERT INTO `cms_search` VALUES ('66a2dfda9e474cbeb7ea933611020fce', 'ddd', '2020-04-02 01:35:58'); INSERT INTO `cms_search` VALUES ('6b3c43b6e6434a7c80707318f0a31205', '商务展会', '2020-04-02 03:14:26'); INSERT INTO `cms_search` VALUES ('6fd3f7e5383c43d3a80231e04b274366', '网页', '2018-09-29 13:59:37'); INSERT INTO `cms_search` VALUES ('71378a798659412ba35c5bf4b049d993', '生涯', '2018-09-29 10:18:10'); INSERT INTO `cms_search` VALUES ('78c3ef5c791c41bf98c8f653b424eb3a', '程序员', '2018-09-25 15:17:08'); INSERT INTO `cms_search` VALUES ('7dafe01549344990856819ea0cdd04ba', '商务展会', '2020-04-02 03:10:42'); INSERT INTO `cms_search` VALUES ('7eb0417789c14fae8f81e2cb09cdd960', 'ddd', '2020-04-02 01:35:00'); INSERT INTO `cms_search` VALUES ('8d2758e477934827b8e66e15eb3de577', 'orion', '2020-04-02 02:52:12'); INSERT INTO `cms_search` VALUES ('9481b56b96d64fa89434ac74764c7a23', '商务展会', '2020-04-02 03:28:34'); INSERT INTO `cms_search` VALUES ('97429b54220e4b12a34269cf4c729ae8', 'ddd', '2020-04-02 02:41:22'); INSERT INTO `cms_search` VALUES ('9a022ea5908746c8be4b617dc843bad7', '程序员', '2018-09-25 15:13:43'); INSERT INTO `cms_search` VALUES ('9ae46553ba814124bb77936e37c321ec', '商务展会', '2020-04-02 03:28:59'); INSERT INTO `cms_search` VALUES ('a66efae4d3d54a97904b9aa80e3df11b', '商务展会', '2020-04-02 03:14:20'); INSERT INTO `cms_search` VALUES ('ac19c322c2b04d1fa4f74f9c5f14a9c7', '大气ORION渐变', '2021-04-03 04:10:53'); INSERT INTO `cms_search` VALUES ('b3e145bb35e54356a7f641ddc34da677', '商务展会', '2020-04-02 03:25:25'); INSERT INTO `cms_search` VALUES ('c009c85f6cd2409a81e136a79e8eb424', '商务展会', '2020-04-02 03:09:53'); INSERT INTO `cms_search` VALUES ('ce488145bd9648699955635e947a6dde', '商务展会', '2020-04-02 05:59:17'); INSERT INTO `cms_search` VALUES ('d05cfad7936041a1ae18fbf39b568cc4', '商务展会', '2020-04-02 03:12:19'); INSERT INTO `cms_search` VALUES ('db15a8e41db3459fa9540f5c4a8001fe', '商务展会', '2020-05-15 06:36:20'); INSERT INTO `cms_search` VALUES ('df4816a927d6405a99712b85eb75eae6', '商务展会', '2020-04-02 03:27:32'); INSERT INTO `cms_search` VALUES ('ea72063604a249db8df3cbed171b83f4', '商务展会', '2020-04-02 03:19:50'); INSERT INTO `cms_search` VALUES ('eb01083582c242bc9f915fa671de8314', '商务展会', '2020-04-02 03:28:05'); INSERT INTO `cms_search` VALUES ('f0f604b09dbd4b3783758ad80bea5e9f', 'orion', '2020-04-02 02:49:11'); INSERT INTO `cms_search` VALUES ('f2c798f6baba4963ae23883d2afe41ee', '程序员', '2018-09-25 15:17:53'); INSERT INTO `cms_search` VALUES ('f45e52d31d57470ab0fd0b8987ba29b7', '商务展会', '2020-04-02 03:18:33'); INSERT INTO `cms_search` VALUES ('f4cdbb9d28c24a498fd83652a984cbcf', '商务展会', '2020-04-02 03:25:34'); INSERT INTO `cms_search` VALUES ('f7f3c4a6bcac48ad9663431cb6c3cf10', '商务展会', '2020-04-02 03:09:02'); INSERT INTO `cms_search` VALUES ('fd8c5fa78c164962bdbc92248d0b65df', 'kid', '2020-04-02 03:00:05'); -- ---------------------------- -- Table structure for cms_setting -- ---------------------------- DROP TABLE IF EXISTS `cms_setting`; CREATE TABLE `cms_setting` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `website` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '网站地址', `title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点标题', `keywords` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点关键词', `describe` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点描述', `icp` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备案号', `copyright` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '版权', `uploaddir` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'uploads/' COMMENT '上传目录', `appid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '畅言appid', `appkey` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '畅言appkey', `staticdir` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'htmls' COMMENT '静态化目录', `browse_type` int NULL DEFAULT 1 COMMENT '浏览方式(1:动态2:静态)', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_setting -- ---------------------------- INSERT INTO `cms_setting` VALUES ('1', 'http://localhost:8888/', 'Dreamer CMS 梦想家内容发布系统', 'Dreamer CMS 梦想家内容发布系统', 'Dreamer CMS 梦想家内容发布系统是国内首款java开发的内容发布系统,采用最流行的springboot+thymeleaf框架搭建,灵活小巧,配置简单。', '冀ICP备19026223号', 'Copyright © 2018 Powered by I Tech You,我教你,Dreamer CMS 梦想家内容发布系统', 'uploads/', 'cytQcJUcb', '2dd87fd430f0509cf00e18de4328e100', 'htmls', 1); -- ---------------------------- -- Table structure for cms_templates -- ---------------------------- DROP TABLE IF EXISTS `cms_templates`; CREATE TABLE `cms_templates` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `aid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主表ID', `ext01` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext02` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext03` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext04` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `ext05` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_templates -- ---------------------------- INSERT INTO `cms_templates` VALUES ('989bac83b8004120845fb3f8791936e4', 'd64d167032c84521ad21708cccc1f963', NULL, NULL, NULL, NULL, NULL, '模板名称:
财税记账工商注册认证公司类织梦模板(带手机端)+PC+移动端+利于SEO优化
模板介绍:
织梦最新内核开发的模板,该模板属于财税记账、工商注册类企业使用,
自带最新的手机移动端,同一个后台,数据即时同步,简单适用!
原创设计、手工书写DIV+CSS,
完美兼容IE7+、Firefox、Chrome、360浏览器等;主流浏览器;
页面简洁简单,容易管理,DEDE内核都可以使用;附带测试数据!
模板特点:
该模板多数为单页面,修改很多需要在代码文件上修改,图片很多也需要通过FTP工具修改,
因为财税类的页面比较多,所以很多都是写在模板文件上的!
使用程序:
织梦DEDECMS版本都可以使用。
模板页面:
index.htm 首页模板
head.htm
footer.htm
article_article.htm 文章内容
这里不一一列出!
温馨提示:
按照正常的织梦安装步骤来安装还原就可以用了,从后台重新点击保存下系统基本参数。 系统>系统基本参数> 保存(确定)。
后期bug修正:
暂无
PC截图: