162 lines
3.2 KiB
JavaScript
162 lines
3.2 KiB
JavaScript
// 表单校验规则由 schema2code 生成，不建议直接修改校验规则，而建议通过 schema2code 生成, 详情: https://uniapp.dcloud.net.cn/uniCloud/schema
|
|
|
|
|
|
const validator = {
|
|
"parent_id": {
|
|
"rules": [
|
|
{
|
|
"format": "string"
|
|
}
|
|
],
|
|
"title": "父评论ID",
|
|
"defaultValue": "",
|
|
"label": "父评论ID"
|
|
},
|
|
"user_id": {
|
|
"rules": [
|
|
{
|
|
"required": true
|
|
},
|
|
{
|
|
"format": "string"
|
|
}
|
|
],
|
|
"title": "用户ID",
|
|
"label": "用户ID"
|
|
},
|
|
"content": {
|
|
"rules": [
|
|
{
|
|
"required": true
|
|
},
|
|
{
|
|
"format": "string"
|
|
},
|
|
{
|
|
"minLength": 1,
|
|
"maxLength": 500
|
|
}
|
|
],
|
|
"title": "评论内容",
|
|
"label": "评论内容"
|
|
},
|
|
"like_count": {
|
|
"rules": [
|
|
{
|
|
"format": "int"
|
|
},
|
|
{
|
|
"minimum": 0
|
|
}
|
|
],
|
|
"title": "点赞数",
|
|
"defaultValue": 0,
|
|
"label": "点赞数"
|
|
},
|
|
"create_time": {
|
|
"rules": [
|
|
{
|
|
"format": "timestamp"
|
|
}
|
|
],
|
|
"title": "创建时间",
|
|
"defaultValue": {
|
|
"env": "now"
|
|
},
|
|
"label": "创建时间"
|
|
},
|
|
"update_time": {
|
|
"rules": [
|
|
{
|
|
"format": "timestamp"
|
|
}
|
|
],
|
|
"title": "更新时间",
|
|
"defaultValue": {
|
|
"env": "now"
|
|
},
|
|
"label": "更新时间"
|
|
},
|
|
"status": {
|
|
"rules": [
|
|
{
|
|
"format": "string"
|
|
},
|
|
{
|
|
"range": [
|
|
{
|
|
"value": "draft",
|
|
"text": "草稿"
|
|
},
|
|
{
|
|
"value": "published",
|
|
"text": "已发布"
|
|
},
|
|
{
|
|
"value": "deleted",
|
|
"text": "已删除"
|
|
}
|
|
]
|
|
}
|
|
],
|
|
"title": "状态",
|
|
"defaultValue": "published",
|
|
"label": "状态"
|
|
}
|
|
}
|
|
|
|
const enumConverter = {
|
|
"status_valuetotext": {
|
|
"draft": "草稿",
|
|
"published": "已发布",
|
|
"deleted": "已删除"
|
|
}
|
|
}
|
|
|
|
function filterToWhere(filter, command) {
|
|
let where = {}
|
|
for (let field in filter) {
|
|
let { type, value } = filter[field]
|
|
switch (type) {
|
|
case "search":
|
|
if (typeof value === 'string' && value.length) {
|
|
where[field] = new RegExp(value)
|
|
}
|
|
break;
|
|
case "select":
|
|
if (value.length) {
|
|
let selectValue = []
|
|
for (let s of value) {
|
|
selectValue.push(command.eq(s))
|
|
}
|
|
where[field] = command.or(selectValue)
|
|
}
|
|
break;
|
|
case "range":
|
|
if (value.length) {
|
|
let gt = value[0]
|
|
let lt = value[1]
|
|
where[field] = command.and([command.gte(gt), command.lte(lt)])
|
|
}
|
|
break;
|
|
case "date":
|
|
if (value.length) {
|
|
let [s, e] = value
|
|
let startDate = new Date(s)
|
|
let endDate = new Date(e)
|
|
where[field] = command.and([command.gte(startDate), command.lte(endDate)])
|
|
}
|
|
break;
|
|
case "timestamp":
|
|
if (value.length) {
|
|
let [startDate, endDate] = value
|
|
where[field] = command.and([command.gte(startDate), command.lte(endDate)])
|
|
}
|
|
break;
|
|
}
|
|
}
|
|
return where
|
|
}
|
|
|
|
export { validator, enumConverter, filterToWhere }
|