fuxi-dmrv-server/server/routes/master/clue.js

const { Op } = require('sequelize');
const moment = require('moment');
const express = require('express');
const _ = require('lodash');
const { query, body } = require('express-validator');
const { onSuccess, fill } = require('../../../utils');
const { limit } = require('../../config');
const check = require('../../../middleware/check');
const Clue = require('../../../db/models/clue');
const Admin = require('../../../db/models/admin');

const router = express.Router();

async function fillSingle(data) {
  if (data) {
    const { adminId } = data;
    if (data) {
      const aItem = await Admin.findOne({ where: { id: adminId } });
      aItem && (data.adminName = aItem.name);
    }
  }
  return data;
}
/**
 * showdoc
 * @catalog v1/后台/联系和咨询
 * @title 联系和咨询列表
 * @description 联系和咨询列表接口
 * @method GET
 * @url  /master/clue/
 * @param  page 0 Int 页码: 不传默认取第1页数据，每页20条数据
 * @param  type 1 integer 1联系我们2预约咨询
 * @param  isContact 0 integer 是否联系0未联系1联系
 * @param  stime 0 string 开始时间
 * @param  etime 0 string 结束时间
 * @return {"code":0, "count":1, "data": []}
 * @return_param  id integer id
 * @return_param  name string 联系人
 * @return_param  phone string 手机号
 * @return_param  email string 邮箱
 * @return_param  content string 内容
 * @return_param  adminId integer 管理员ID
 * @return_param  type tinyint 1联系我们2预约咨询
 * @return_param  isContact tinyint 是否联系0未联系1联系
 * @return_param  busName string 账号名
 * @return_param  busCompany string 账号公司
 * @return_param  adminName string 管理员名称
 * @return_param  createdAt date -
 * @return_param  updatedAt date -
 * @remark
 * @number
 */
router.get('/', async (req, res) => {
  const { page = 0, stime, etime } = req.query;
  const where = _.omit(req.query, ['page', 'stime', 'etime']);
  const info = onSuccess();
  stime &&
    etime &&
    (where.createdAt = {
      [Op.gte]: moment(stime).startOf('day'),
      [Op.lte]: moment(etime).endOf('day'),
    });
  info.data = await Clue.findAll({ where, limit, offset: page * limit });
  info.data = await fill(info.data, fillSingle);
  if (!page) {
    info.count = await Clue.count({ where });
  }
  res.send(info);
});
/**
 * showdoc
 * @catalog v1/后台/联系和咨询
 * @title 联系和咨询详情
 * @description
 * @method GET
 * @url  /master/clue/:id
 * @param  :id 1 STRING 详情ID
 * @return {"code":0, "data": {}}
 * @return_param  id integer id
 * @return_param  name string 联系人
 * @return_param  phone string 手机号
 * @return_param  email string 邮箱
 * @return_param  content string 内容
 * @return_param  adminId integer 管理员ID
 * @return_param  type tinyint 1联系我们2预约咨询
 * @return_param  isContact tinyint 是否联系0未联系1联系
 * @return_param  busName string 账号名
 * @return_param  busCompany string 账号公司
 * @return_param  adminName string 管理员名称
 * @return_param  createdAt date -
 * @return_param  updatedAt date -
 * @remark
 * @number
 */
router.get('/:id', async (req, res) => {
  let data = await Clue.findOne({ where: req.params });
  data = await fill(data, fillSingle);
  res.send(onSuccess(data));
});

/**
 * showdoc
 * @catalog v1/后台/联系和咨询
 * @title 联系和咨询修改
 * @description 操作修改
 * @method PUT
 * @url  /master/clue/:id
 * @param  :id 1 STRING 详情ID
 * @param isContact 1 tinyint 是否联系0未联系1联系
 * @return {"code":0, "msg": "修改成功"}
 * @remark
 * @number
 */
router.put('/:id', check([body(['isContact']).notEmpty()]), async (req, res) => {
  req.body.adminId = req.admin.id;
  const data = await Clue.update(_.pick(req.body, ['isContact', 'adminId']), {
    where: req.params,
    limit: 1,
  });
  res.send(onSuccess(null, '修改成功'));
});

module.exports = router;