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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
| 'use strict';
| module.exports = {
| /**
| * 获取我的课程列表
| * @url client/learn/pub/myCourseList 前端调用的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 {
| pageIndex = 1, pageSize = 10, uid,
| type
|
| } = data;
| let res = {
| code: 0,
| msg: ""
| };
| // 业务逻辑开始-----------------------------------------------------------
|
| if (uid == null) {
| res.code = -1
| res.msg = "请登录后查看"
| return res
| }
|
| let whereJson = {};
| whereJson['user_id'] = uid
| whereJson['goods_type'] = type
| let foreignDB = type == 'course' ? [{
| dbName: "course",
| localKey: "goods_id",
| foreignKey: "_id",
| as: "courseInfo",
| fieldJson: {
| render_desc: false
| },
| limit: 1,
| foreignDB: [{
| dbName: "course_chapter",
| localKey: "_id",
| foreignKey: "course_id",
| as: "chapter",
| fieldJson: {
| render_desc: false
| }
| }, {
| dbName: "course_videos",
| localKey: "_id",
| foreignKey: "course_id",
| as: "videos",
| fieldJson: {
| render_desc: false
| }
| }]
| }] : [{
| dbName: "live_course",
| localKey: "goods_id",
| foreignKey: "_id",
| as: "courseInfo",
| fieldJson: {
| render_desc: false
| },
| limit: 1,
| foreignDB: [{
| dbName: "course_chapter",
| localKey: "_id",
| foreignKey: "course_id",
| as: "chapter",
| fieldJson: {
| render_desc: false
| }
| }, {
| dbName: "live_course_videos",
| localKey: "_id",
| foreignKey: "course_id",
| as: "videos",
| fieldJson: {
| render_desc: false
| }
| }]
| }]
| res = await vk.baseDao.selects({
| dbName: "user_goods",
| whereJson: whereJson,
| pageIndex: pageIndex,
| pageSize: pageSize,
| sortArr: [{
| "name": "_add_time",
| "type": "desc"
| }],
| fieldJson: {
| render_desc: false
| },
| // 副表列表
| foreignDB,
| lastWhereJson: {
| "courseInfo._id": _.exists(true)
| }
| });
|
|
| // 业务逻辑结束-----------------------------------------------------------
| return res;
| }
| }
|
|
