'use strict'; const assert = require('assert'); const Service = require('egg').Service; class MenuService extends Service { constructor(ctx) { super(ctx); this.model = this.ctx.model.Menu; this.column = this.ctx.model.Column; this.pages = this.ctx.model.Pages; } async create({ name, code, sort, type, url, column, pages }) { assert(name, '名称不存在'); assert(code, '编码不存在'); assert(type, '类型不存在'); try { const res = await this.model.findOne({ code }); if (res) return { errcode: -1001, errmsg: '编码已存在', data: '' }; const item = await this.model.create({ name, code, sort, type, url, column, pages }); return { errcode: 0, errmsg: '', data: item }; } catch (error) { throw error; } } async update({ id, name, sort, type, url, column, pages }) { assert(id, 'id不存在'); try { const res = await this.model.findOne({ _id: id }); if (!res) return { errcode: -1001, errmsg: '数据不存在', data: '' }; await this.model.updateOne({ _id: id }, { name, sort, type, url, column, pages }); return { errcode: 0, errmsg: '', data: 'update' }; } catch (error) { throw error; } } async delete({ id }) { assert(id, 'id不存在'); try { const res = await this.model.findOne({ _id: id }); if (!res) return { errcode: -1001, errmsg: '数据不存在', data: '' }; const column = await this.column.findOne({ bind: res.code }); const pages = await this.pages.findOne({ bind: res.code }); if (column || pages) return { errcode: -1001, errmsg: '存在绑定关系,不能删除', data: '' }; await this.model.remove({ _id: id }); return { errcode: 0, errmsg: '', data: 'delete' }; } catch (error) { throw error; } } async query({ skip, limit, name, code }) { const filter = {}; if (name || code) filter.$or = []; if (name) filter.$or.push({ name: { $regex: name } }); if (code) filter.$or.push({ code: { $regex: code } }); try { let res; const total = await this.model.find({ ...filter }); if (skip && limit) { res = await this.model.find({ ...filter }) .skip(Number(skip) * Number(limit)) .limit(Number(limit)) .sort({ date: 1 }); } else { res = await this.model.find({ ...filter }); } return { errcode: 0, errmsg: '', data: res, total: total.length }; } catch (error) { throw error; } } } module.exports = MenuService;