column.js 2.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. 'use strict';
  2. const Service = require('egg').Service;
  3. const assert = require('assert');
  4. const moment = require('moment');
  5. // const _ = require('lodash');
  6. class ColumnService extends Service {
  7. async create({ name, code, menuList }) {
  8. assert(name, '名称不存在');
  9. assert(code, '编码不存在');
  10. const { Column: model } = this.ctx.model;
  11. const createAt = moment().format('x');
  12. try {
  13. await model.create({ name, code, menuList, createAt });
  14. return { errmsg: '', errcode: 0 };
  15. } catch (error) {
  16. throw new Error({ errcode: -2001, errmsg: '添加失败' });
  17. }
  18. }
  19. async update({ name, code, id, menuList }) {
  20. assert(id, 'id不存在');
  21. const { Column: model } = this.ctx.model;
  22. try {
  23. await model.findByIdAndUpdate(id, { name, code, menuList });
  24. return { errmsg: '', errcode: 0 };
  25. } catch (error) {
  26. throw new Error({ errcode: -2001, errmsg: '修改失败' });
  27. }
  28. }
  29. async del({ id }) {
  30. assert(id, 'id不存在');
  31. const { Column: model } = this.ctx.model;
  32. const { Content: Contentmodel } = this.ctx.model;
  33. try {
  34. // 当前数据
  35. const res = await model.findById(id);
  36. // 复杂查询文章数据
  37. const contentList = await Contentmodel.where('columnList').in(res.code);
  38. contentList.filter(async p => {
  39. const columnList = p.columnList.filter(e => e !== res.code);
  40. await Contentmodel.findByIdAndUpdate(p._id, { columnList });
  41. });
  42. await model.findByIdAndDelete(id);
  43. return { errmsg: '', errcode: 0 };
  44. } catch (error) {
  45. throw new Error({ errcode: -2001, errmsg: '删除失败' });
  46. }
  47. }
  48. // async query() {
  49. // const { Column: model } = this.ctx.model;
  50. // const { adminUser: usermodel } = this.ctx.model;
  51. // const jwt = this.app.middleware.jwt(this.app.config.jwt);
  52. // try {
  53. // const userInfo = await usermodel.findById(jwt.userId);
  54. // const menus = [];
  55. // userInfo.roleList.forEach(async e => {
  56. // const res = await model.where('roleLise').in(e);
  57. // menus.push(...res);
  58. // });
  59. // const list = _.uniqWith(menus, _.isEqual);
  60. // return { errmsg: '', errcode: 0, data: list };
  61. // } catch (error) {
  62. // throw new Error({ errcode: -2001, errmsg: '查询失败' });
  63. // }
  64. // }
  65. async query({ skip, limit, filter }) {
  66. const { Column: model } = this.ctx.model;
  67. try {
  68. let res;
  69. if (skip && limit) {
  70. res = await model.find(filter).skip(skip * limit).limit(limit);
  71. } else {
  72. res = await model.find(filter);
  73. }
  74. return { errmsg: '', errcode: 0, data: res };
  75. } catch (error) {
  76. throw new Error({ errcode: -2001, errmsg: '查询失败' });
  77. }
  78. }
  79. }
  80. module.exports = ColumnService;