123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204 |
- const express = require('express');
- const _ = require('lodash');
- const { query, body } = require('express-validator');
- const { onSuccess, fill, dateFormat, onError } = require('../../../utils');
- const { limit, COURSE_STATUS, COURSE_TYPE } = require('../../config');
- const check = require('../../../middleware/check');
- const Course = require('../../../db/models/course');
- const Teacher = require('../../../db/models/teacher');
- const Chapter = require('../../../db/models/chapter');
- const router = express.Router();
- const _COURSE_STATUS = _.invert(COURSE_STATUS);
- const _COURSE_TYPE = _.invert(COURSE_TYPE);
- async function fillSingle(data) {
- const { teacherId, recordId } = data;
- const recorder = await Teacher.findOne({ where: { id: recordId } });
- data.teachers = await Promise.all(
- teacherId.map(item => {
- return Teacher.findOne({ where: { id: item } });
- })
- );
- recorder && (data.recordName = recorder.name);
- data.publishAt && (data.publishAt = dateFormat(data.publishAt));
- data.statusStr = _COURSE_STATUS[data.status];
- data.typeStr = _COURSE_TYPE[data.type];
- return data;
- }
- /**
- * showdoc
- * @catalog v1/课程
- * @title 课程列表
- * @description 课程列表接口
- * @method GET
- * @url /master/course/
- * @param page 0 Int 页码: 不传默认取第1页数据,每页20条数据
- * @return {"code":0, "count":1, "data": []}
- * @return_param id integer id
- * @return_param title string 标题
- * @return_param desc string 描述
- * @return_param detailimg string 详情大图
- * @return_param listimg string 描述
- * @return_param teacherId integer 讲师
- * @return_param recordId integer 录播讲师
- * @return_param oprice decimal 原价
- * @return_param price decimal 现价
- * @return_param discountmsg string 优惠信息
- * @return_param type tinyint 1碳资产开发2碳核算
- * @return_param status tinyint 0草稿1已发布2下线
- * @return_param weight integer 权重
- * @return_param richText text 富文本
- * @return_param createdAt date -
- * @return_param updatedAt date -
- * @remark
- * @number
- */
- router.get('/', async (req, res) => {
- const { page = 0 } = req.query;
- const where = _.omit(req.query, ['page']);
- const info = onSuccess();
- info.data = await Course.findAll({ where, limit, offset: page * limit });
- info.data = await fill(info.data, fillSingle);
- if (!page) {
- info.count = await Course.count({ where });
- }
- res.send(info);
- });
- /**
- * showdoc
- * @catalog v1/课程
- * @title 课程详情
- * @description
- * @method GET
- * @url /master/course/:id
- * @param :id 1 STRING 详情ID
- * @return {"code":0, "data": {}}
- * @return_param id integer id
- * @return_param title string 标题
- * @return_param desc string 描述
- * @return_param detailimg string 详情大图
- * @return_param listimg string 描述
- * @return_param teacherId integer 讲师
- * @return_param recordId integer 录播讲师
- * @return_param oprice decimal 原价
- * @return_param price decimal 现价
- * @return_param discountmsg string 优惠信息
- * @return_param type tinyint 1碳资产开发2碳核算
- * @return_param status tinyint 0草稿1已发布2下线
- * @return_param weight integer 权重
- * @return_param richText text 富文本
- * @return_param createdAt date -
- * @return_param updatedAt date -
- * @remark
- * @number
- */
- router.get('/:id', async (req, res) => {
- let data = await Course.findOne({ where: req.params });
- data = await fill(data, fillSingle);
- res.send(onSuccess(data));
- });
- /**
- * showdoc
- * @catalog v1/课程
- * @title 课程添加
- * @description
- * @method POST
- * @url /master/course/
- * @param title string 标题
- * @param desc string 描述
- * @param detailimg string 详情大图
- * @param listimg string 描述
- * @param teacherId integer 讲师
- * @param recordId integer 录播讲师
- * @param oprice decimal 原价
- * @param price decimal 现价
- * @param discountmsg string 优惠信息
- * @param type tinyint 1碳资产开发2碳核算
- * @param status tinyint 0草稿1已发布2下线
- * @param weight integer 权重
- * @param richText text 富文本
- * @return {"code":0, "data": {}}
- * @remark
- * @number
- */
- router.post('/', check([body([]).notEmpty()]), async (req, res) => {
- const data = await Course.create(req.body);
- res.send(onSuccess(data));
- });
- /**
- * showdoc
- * @catalog v1/课程
- * @title 课程上线下线
- * @description
- * @method PUT
- * @url /master/course/status/:id
- * @param status 1 number 1上线2下线
- * @return {"code":0, "msg": "修改成功"}
- * @remark
- * @number
- */
- router.put('/status/:id', async (req, res) => {
- const { status } = req.body;
- const { id } = req.params;
- // eslint-disable-next-line eqeqeq
- if (status == 1) {
- req.body.publishAt = new Date();
- const vcount = await Chapter.count({ where: { cid: id } });
- if (!vcount) {
- return onError('请上传视频后再发布');
- }
- }
- const data = await Course.update(req.body, { where: { id }, limit: 1 });
- res.send(onSuccess(null, '修改成功'));
- });
- /**
- * showdoc
- * @catalog v1/课程
- * @title 课程修改
- * @description
- * @method PUT
- * @url /master/course/:id
- * @param :id 1 STRING 详情ID
- * @param title string 标题
- * @param desc string 描述
- * @param detailimg string 详情大图
- * @param listimg string 描述
- * @param teacherId integer 讲师
- * @param recordId integer 录播讲师
- * @param oprice decimal 原价
- * @param price decimal 现价
- * @param discountmsg string 优惠信息
- * @param type tinyint 1碳资产开发2碳核算
- * @param status tinyint 0草稿1已发布2下线
- * @param weight integer 权重
- * @param richText text 富文本
- * @return {"code":0, "msg": "修改成功"}
- * @remark
- * @number
- */
- router.put('/:id', async (req, res) => {
- const data = await Course.update(req.body, { where: req.params, limit: 1 });
- res.send(onSuccess(null, '修改成功'));
- });
- /**
- * showdoc
- * @catalog v1/课程
- * @title 课程删除
- * @description
- * @method DELETE
- * @url /master/course/:id
- * @param :id 1 STRING 详情ID
- * @return {"status":0, "msg": "删除成功"}
- * @remark
- * @number
- */
- router.delete('/:id', async (req, res) => {
- const data = await Course.destroy({ where: req.params, limit: 1 });
- res.send(onSuccess(null, '删除成功'));
- });
- module.exports = router;
|