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
| 'use strict';
| module.exports = {
| /**
| * 获取我收藏的广场帖子
| * @url client/bbs/pub/getMySquareCollection 前端调用的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 } = data;
| let res = { code: 0, msg: "" };
| // 业务逻辑开始-----------------------------------------------------------
|
| // 要关联取出 评论条数
| let dbName = "user-bbs-star";
| res = await vk.baseDao.selects({
| dbName,
| data,
| getMain: false, // 是否只返回rows数据
| pageIndex: data.pageNo, // 当前第几页
| pageSize: data.pageSize, // 每页条数
| whereJson: {
| user_id: uid
| },
| sortArr: [
| { "name": "_add_time", "type": "desc" }
| ],
| foreignDB: [{
| dbName: "bbs_article",
| localKey: "posts_id",
| foreignKey: "_id",
| as: "posts",
| limit: 1,
| fieldJson: {
| content: true,
| uid: true,
| category_id: true,
| images: true,
| _add_time: true,
| like_count: true
| }
| }, {
| dbName: "user-bbs-tumbup",
| localKey: "posts_id",
| foreignKey: "posts_id",
| as: "tumbups",
| fieldJson: { _id: true }
| }, {
| dbName: "user-bbs-tumbup",
| localKey: "posts_id",
| foreignKey: "posts_id",
| as: "tumbup",
| fieldJson: { _id: true },
| whereJson: {
| user_id: uid
| },
| limit: 1,
| }, {
| dbName: "bbs_comments",
| localKey: "posts_id",
| foreignKey: "aid",
| as: "comments",
| foreignDB: [{
| dbName: "uni-id-users",
| localKey: "uid",
| foreignKey: "_id",
| as: "user",
| fieldJson: { nickname: true, avatar: true },
| limit: 1,
| }]
| }, {
| dbName: "uni-id-users",
| localKey: "poster_id",
| foreignKey: "_id",
| as: "poster",
| fieldJson: { nickname: true, avatar: true },
| limit: 1,
| }]
| });
|
| // 业务逻辑结束-----------------------------------------------------------
| return res;
| }
| }
|
|
