mappers、wheres
"my": {
//#region child 1对多/chilobject1对1
"showExtand": "null reader",
//reader
"bridgeColumnExtand": "",
"fieldChild": {
"reader": {
"moduleKey": "bs-msg-notice-site",
"responseField": "showmy",
"showMethod": "childobject"
}
},
//#endregion child 1对多/chilobject1对1
"extend": "basis",
"auth": true,
// #region 开启扩展入库配置
"saveSqlExtand": true,
// #endregion 开启扩展入库配置
// #region 移除多余字段
"bridgeColumnRemoves": "audit_opinion",
// #endregion 移除多余字段
// #region 5分钟内数据置顶,sort_id
"order": "{date_diff_sort},modify_time desc",
//"whereSql": "{where_sql}",
"field": {
"sort": {
"createTime": {
"column": "create_time",
"dateDiffMinute": 5
}
}
},
// #endregion 5分钟内数据置顶
//#region _mapperType
"mappers": {
// 默认工单
"default": {
"columnAlias": "title,sign,open_method,notice_id,img_url,content"
},
// 未读的消息
"0": {
"columnAlias": "default"
}
},
//#endregion _mapperType
"wheres": [
"{where_sql} and audit_status=1",
// #region 未读取的消息
"{s-if:_mapperType}",
"{op-eq:0}",
//bs_msg_notice.notice_id=bs_msg_notice_site.notice_id and
" and not exists (select notice_id from bs_msg_notice_site where user_id=@_userId) ",
"{op-eq:0}",
"{e-if:_mapperType}"
// #endregion 未读取的消息
]
},
文档更新时间: 2022-09-18 13:25 作者:admin