时间排序、近5分钟置顶
“order”: “{date_diff_sort},sort_id”,
"createTime": {
//区间查询 start 如果创建时间, 可以使用 "extendAlias": "create_time", 替代
"filter": {
"method": "gt_eq_lt"
},
"searchPropertie": {
"showMethodOut": "kv",
"showMethod": "date",
"format": "yyyy-MM-dd"
},
"editPropertie": {
"showMethodOut": "kv",
"isOnlyAdd": true,
"showMethod": "date",
"defaultValue": "_currentDate", //普通区间查询不用配置
"format": "yyyy-MM-dd HH:mm:ss" //普通区间查询不用配置
},
"pagePropertie": {
"showMethodOut": "kv", // n v kv sn//普通区间查询不用配置
"showMethod": "date", //普通区间查询不用配置
"format": "yyyy-MM-dd HH:mm:ss" //普通区间查询不用配置
},
//区间查询 end
//"extendAlias": "create_time",
"tableId": 1,
"isDate": true,
"isData": true,
"field": "createTime",
"dataType": "datetime",
"title": "创建时间",
"name": "create_time",
"alias": "create_time",
"isSearch": true
},
dateDiffMinute
{
//#region 30分钟内数据置顶
"order": "{date_diff_sort},sort_id",
"field": {
"sort": {
"createTime": {
"column": "create_time",
"dateDiffMinute": 30
}
}
},
//#endregion 30分钟内数据置顶
}
//#region 30分钟内数据置顶
"order": "{date_diff_sort},sort_id",
"field": {
"sort": {
"createDate": {
"column": "create_date",
"dateDiffMinute": 30
}
}
},
//#endregion 30分钟内数据置顶
"basis": {
//列表情况默认显示条数,如果自定义通过 参数pageSize控制
//"pageSize": 1,
"bridgeColumn": "address,birthday,city,create_time,email,head_icon,level,id_card,is_guide,is_hide_phone,nike_name,pin_yin,post_code,province,real_name,remark,sex,sort_id,telephone,user_id,view_count,push_name",
//,image_id,bit_val,distance_val,geography_val,geography_val_text,role_val,json_val,money,
"auth": true,
//"show": "user_id,null user_name,{geography_val},null sys_id,null role_id,null dep_id,sex,real_name,telephone,user_status,bit_val,distance_val distance,json_val,is_hide_phone,create_time",
//"original": "'' account,'' role,'' sys,'' merger,'' job,'' dep,role_val,0.0 lng,0.0 lat,view_count",
"original": "null account,user_status,null user_name,null dep_id,null role_id,null role,null dep,null area,null job",
"show": "pin_yin,user_id,null user_name,null sys_id,null role_id,null dep_id,sex,real_name,telephone,id_card,user_status,is_hide_phone,create_time,level,head_icon,'00000000000000000' push_name",
"all": "",
"base64": "",
"field": {
"sort": {
"createTime": {
"column": "create_time",
"dateDiffMinute": 30
}
},
//手机号编码
"enc": {
//"telephone": {
// "columnName": "telephone"
//}
},
//字段格式化显示
"format": {
"createTime": "yyyy-MM-dd"
},
//bit类型转换
"bit": {
"bitVal": "bit_val"
},
//字符正则方式替换展示
"rep": {
//"telephone": [
// {
// "regex": "\\d",
// "key": "",
// "value": "#",
// "sortId": 1
// }
//]
},
//图片补全转换
"doUrl": {
"headIcon": {
"beforeRoot": "beforeRoot:fileWebRoot",
"beforeChar": []
}
},
//多名字情况,按优先基本有数据展示
"doName": {
"pushName": [
{
"name": "push_name",
"path": "real_name",
"sortId": 1
},
{
"key": "user_id", //主键别名 使用于 1对1
"path": "account:nike_name", // : 前面为主表列 , 后面为1对1里面表列
"value": "-",
"sortId": 2
},
{
"path": "email",
"sortId": 3
},
{
"path": "telephone",
"value": "-",
"sortId": 4
}
]
}
},
"where": "{where_sql}",
"order": "{date_diff_sort},sort_id",
"dimField": [ "isHidePhone", "sex" ],
//添加额外扩展
//"where": "{where_sql} and user_id in @fieldWhere",
//"fieldWhere": {
// "filterDemo": {
// "enabled": true,
// "moduleKey": "",
// "responseField": "",
// "sql": "aaaadddd"
// }
//},
//自定义sql方式 sqlPage:[] 优先, 其次: page:"", 最后 动态拼接
//"selectSql": {
// "sqlPage": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ],
// "sqlDetail": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ],
// "sqlCount": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ],
// "sqlList": [
// {
// "sortId": 1,
// "value": "sss"
// },
// {
// "sortId": 0,
// "value": "aaa"
// }
// ]
//},
"fieldChild": {
//1对多 1对1 情况下 继承操作
"account": {
"moduleKey": "bo-user-account",
"responseField": "basis_detail",
"showMethod": "childobject"
},
"role": {
"moduleKey": "bo-user-role",
"responseField": "basis_detail"
}
//,
//"roleVal": {
// "moduleKey": "bo-sys-role",
// "responseField": "user-role"
//}
},
"columns": {
//"geographyVal": {
// "geography": {
// "outPut": "lnglat" //lnglat json geography
// }
//},
"createTime": {
"detailPropertie": {
"showMethodOut": "kv" // n v kv sn
},
"addPropertie": {
},
"editPropertie": {
},
"pagePropertie": {
"showMethodOut": "kv" // n v kv sn
},
"listPropertie": {
}
}
//,
//"distance": {
// "detailPropertie": {
// "showMethodOut": "n" // n v kv sn
// },
// "addPropertie": {
// },
// "editPropertie": {
// },
// "pagePropertie": {
// "showMethodOut": "kv" // n v kv sn
// },
// "listPropertie": {
// }
//}
}
//,
////点击后累加数
//"viewCount": [
// {
// "name": "view_count",
// "alias": "view_count",
// "field": "viewCount"
// }
//]
},
文档更新时间: 2022-06-12 16:03 作者:admin