1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
| module.exports = {
| /**
| * 查询多条记录 分页
| * @url admin/kong/sys/getList 前端调用的url参数地址
| * data 请求参数 说明
| * @param {Number} pageIndex 当前页码
| * @param {Number} pageSize 每页显示数量
| * @param {Array<Object>} sortRule 排序规则
| * @param {object} formData 查询条件数据源
| * @param {Array<Object>} columns 查询条件规则
| * res 返回参数说明
| * @param {Number} code 错误码,0表示成功
| * @param {String} msg 详细信息
| */
| main: async (event) => {
| let { data = {}, userInfo, util, filterResponse, originalParam } = event;
| let { customUtil, uniID, config, pubFun, vk, db, _ } = util;
| let { uid } = data;
| let res = { code: 0, msg: '' };
| // 业务逻辑开始-----------------------------------------------------------
| let dbName = "bbs_article";
| res = await vk.baseDao.getTableData({
| dbName,
| data,
| sortArr: [
| { "name": "bbs_status", "type": "asc" },
| { "name": "_add_time", "type": "desc" }
| ],
| foreignDB: [{
| dbName: "uni-id-users",
| localKey: "uid",
| foreignKey: "_id",
| as: "user",
| fieldJson: { nickname: true, avatar: true },
| limit: 1,
| },
| {
| dbName: "bbs_category",
| localKey: "category_id",
| foreignKey: "_id",
| as: "category",
| fieldJson: { name: true },
| limit: 1,
| }
| ]
| });
| return res;
| }
|
| }
|
|