1. cms-config 配置
域 | 解释 |
---|
“_id” | ObjectId(“5a791725dd573c3574ee333f”), |
“_class” | “com.xuecheng.framework.domain.cms.CmsConfig” |
“name” | “轮播图”、精品推荐、分类信息 |
“model” | json格式的数据模型 |
例子
{
"_id" : ObjectId("5a791725dd573c3574ee333f"),
"_class" : "com.xuecheng.framework.domain.cms.CmsConfig",
"name" : "轮播图",
"model" : [
{
"key" : "banner1",
"name" : "轮播图1地址",
"value" : "http://192.168.101.64/group1/M00/00/01/wKhlQFp5wnCAG-kAAATMXxpSaMg864.png"
},
{
"key" : "banner2",
"name" : "轮播图2地址",
"value" : "http://192.168.101.64/group1/M00/00/01/wKhlQVp5wqyALcrGAAGUeHA3nvU867.jpg"
},
{
"key" : "banner3",
"name" : "轮播图3地址",
"value" : "http://192.168.101.64/group1/M00/00/01/wKhlQFp5wtWAWNY2AAIkOHlpWcs395.jpg"
}
]
}
查询此表
- 条件查询
int size=9;
int page=1;
Pageable pageable=PageRequest.of(page,size);
CmsPage cmsPage = new CmsPage();
cmsPage.setSiteId("5a751fab6abb5044e0d19ea1");
ExampleMatcher matching = ExampleMatcher.matching();
Example< CmsPage> example=Example.of(cmsPage,matching);
Page<CmsPage> all = cmsPageRepository.findAll(example, pageable);
System.out.println(all.getContent());
- 模糊查询
cmsPage.setPageAliase("轮播");
matching=matching.withMatcher("pageAliase",ExampMatcher.GenericPropertyMatchers.contains());
2. cms-page 页面信息
域 | 解释 |
---|
“_class” | “com.xuecheng.framework.domain.cms.CmsPage” |
“siteId” | 站点ID — “5a751fab6abb5044e0d19ea1” |
“pageName” | “index.html” 页面名称 |
“pageAliase” | 页面别名 |
“pageWebPath” | 访问地址 — “/index.html” |
“pagePhysicalPath” | 物理地址 --“F:\develop\xc_portal_static\” |
“pageType” | 静态页面或者动态页面 “0” |
“pageCreateTime” | 创建时间 ISODate(“2018-02-03T05:37:53.256+0000”) |
“templateId” | 模板ID—“5a962b52b00ffc514038faf7” |
“htmlFileId” | “5a7c1c54d019f14d90a1fb23” |
{
"_id" : ObjectId("5a754adf6abb500ad05688d9"),
"_class" : "com.xuecheng.framework.domain.cms.CmsPage",
"siteId" : "5a751fab6abb5044e0d19ea1",
"pageName" : "index.html",
"pageAliase" : "首页",
"pageWebPath" : "/index.html",
"pagePhysicalPath" : "F:\\develop\\xc_portal_static\\",
"pageType" : "0",
"pageCreateTime" : ISODate("2018-02-03T05:37:53.256+0000"),
"templateId" : "5a962b52b00ffc514038faf7",
"htmlFileId" : "5a7c1c54d019f14d90a1fb23"
}
cms-site 站点数据
域 | 解释 |
---|
_id | ObjectId( 5a751fab6abb5044e0d19ea1 ) page数据中的siteID |
_class | com.xuecheng.framework.domain.cms.CmsSite |
siteName | 门户主站 |
siteDomain | http |
sitePort | 80 , |
siteWebPath | / |
siteCreateTime | ISODate( 2018-02-03T02 |
{
"_id" : ObjectId("5a751fab6abb5044e0d19ea1"),
"_class" : "com.xuecheng.framework.domain.cms.CmsSite",
"siteName" : "门户主站",
"siteDomain" : "http://localhost",
"sitePort" : "80",
"siteWebPath" : "/",
"siteCreateTime" : ISODate("2018-02-03T02:34:19.113+0000")
}
cms-site-server 服务器信息
域 | 解释 |
---|
_id | ObjectId(5a754bdb6abb500ad05688db) |
_class | com.xuecheng.framework.domain.cms.CmsSiteServer |
ip | 127.0.0.1 |
port | 80 |
webPath | / |
serverName | 门户服务器 |
uploadPath | /upload |
siteId | 5a751fab6abb5044e0d19ea1 |
cms-template 模板信息
域 | 解释 |
---|
_id | ObjectId(5a925be7b00ffc4b3c1578b5) |
_class | com.xuecheng.framework.domain.cms.CmsTemplate |
siteId | 5a751fab6abb5044e0d19ea1 |
templateName | 模板名称 课程详情页面 |
templateParameter | courseid |
templateFileId | 模板文件ID 5ad8a51f68db5240b42e5fea |
fileSystem 文件系统 fastDFS
域 | 解释 |
---|
_id | group1/M00/00/01/wKhlQFp5fGiAUSkDAAARA0xqVgo187.png |
_class | com.xuecheng.framework.domain.filesystem.FileSystem |
filePath | group1/M00/00/01/wKhlQFp5fGiAUSkDAAARA0xqVgo187.png |
fileSize | NumberLong(4355) |
fileName | asset-logo.png |
fileType | image/png |
fileWidth | NumberInt(0) |
fileHeight | NumberInt(0) |
fs.chunks 大文件存储
域 | 解释 |
---|
_id | ObjectId(5a7719d76abb5042987eec3b) |
files_id | ObjectId(5a7719d76abb5042987eec3a) |
n | NumberInt(0) |
data | BinData(0,“大文件字符码” ) |
fs.file 文件存储
域 | 解释 |
---|
_id | ObjectId(5a7719d76abb5042987eec3a) |
metadata | {cms-page的所有信息} |
filename | index.html |
aliases | null |
chunkSize | NumberLong(261120) |
uploadDate | ISODate(2018-02-04T14 |
length | NumberLong(33595) |
contentType | null |
md5 | abea232200712179ed3dce1505c1be46 |
sys-dictionary
域 | 解释 |
---|
_id | ObjectId(5a7d50bdd019f150f4ab8ef7) |
d_name | 文件类型 |
d_type | 100 |
d_value | [ { “sd_name” : “cms配置图片”, “sd_id” : “100001”, “sd_status” : “1”}] |
user-test 用户测试
域 | 解释 |
---|
_id | ObjectId(5abe3b9c5b05aa218434f4cf) |
_class | com.xuecheng.framework.domain.test.UserTest |
name | 传智播客 |
createTime | ISODate(2018-03-30T13 |