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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
| 'use strict';
| module.exports = {
| /**
| * 获取广场列表
| * @url client/bbs/pub/getSquareList 前端调用的url参数地址
| * data 请求参数
| * @param {String} params1 参数1
| */
| main: async (event) => {
| let { data = {}, userInfo, util, filterResponse, originalParam } = event;
| let { customUtil, uniID, config, pubFun, vk, db, _ } = util;
| let { uid, pageNo, pageSize } = data;
| let res = { code: 0, msg: "" };
| console.log(uid);
| // 业务逻辑开始-----------------------------------------------------------
| let whereJson = { bbs_status: 1 };
| //课程分类
| if (data.cid != '') whereJson["category_id"] = data.cid
| // 要关联取出 评论条数
| let dbName = "bbs_article";
| res = await vk.baseDao.selects({
| dbName,
| getMain: false, // 是否只返回rows数据
| pageIndex: pageNo, // 当前第几页
| pageSize: pageSize, // 每页条数
| whereJson,
| sortArr: [{ "name": "_add_time", "type": "desc" }],
| fieldJson: {
| content: true,
| uid: true,
| category_id: true,
| images: true,
| _add_time: true,
| like_count: true
| },
| foreignDB: [{
| dbName: "user-bbs-tumbup",
| localKey: "_id",
| foreignKey: "posts_id",
| as: "tumbups",
| fieldJson: { _id: true }
| }, {
| dbName: "user-bbs-tumbup",
| localKey: "_id",
| foreignKey: "posts_id",
| as: "tumbup",
| fieldJson: { _id: true },
| whereJson: {
| user_id: uid
| },
| limit: 1,
| }, {
| dbName: "user-bbs-star",
| localKey: "_id",
| foreignKey: "posts_id",
| as: "star",
| fieldJson: { _id: true },
| whereJson: {
| user_id: uid
| },
| limit: 1,
| }, {
| 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: "categoey",
| fieldJson: { name: true },
| limit: 1,
| },
| {
| dbName: "bbs_comments",
| localKey: "_id",
| foreignKey: "aid",
| as: "comments",
| // limit: 5,
| foreignDB: [{
| dbName: "uni-id-users",
| localKey: "uid",
| foreignKey: "_id",
| as: "user",
| fieldJson: { nickname: true, avatar: true },
| limit: 1,
| }],
| }
| ]
| });
| // 业务逻辑结束-----------------------------------------------------------
| return res;
| }
| }
|
|
