cshenfu
2024-06-27 58aa6e282bb343503be3cb198948328ea3ed7b79
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
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 = "live_course";
        let whereJson = {}
        if (userInfo.role[0] == 'teacher') {
            whereJson.teacher_ids = uid
        }
        res = await vk.baseDao.getTableData({
            dbName,
            data,
            whereJson,
            foreignDB: [{
                    dbName: "course_category",
                    localKey: "category_id",
                    foreignKey: "_id",
                    as: "category",
                    limit: 1,
                }, {
                    dbName: "course_chapter",
                    localKey: "_id",
                    foreignKey: "course_id",
                    as: "chapter"
                },
                {
                    dbName: "uni-id-users",
                    localKey: "teacher_ids",
                    limit: 1,
                    foreignKey: "_id",
                    as: "teacher"
                }
            ]
        });
        return res;
    }
 
}