service/router/home_news.js

const HomeNews = require('../module/HomeNews');
const Router = require('koa-router');
const permission = require('../intercept/permission');
const router = new Router();

/**
 * 获取案例数据
 */
router.get('/', async ctx => {
  let hnews = new HomeNews();

  hnews.hide = 0;
  for (let key in ctx.request.query) {
    hnews[key] = ctx.request.query[key]
  }
  let result = await hnews.query()

  ctx.body = {
    msg: '成功获取数据',
    content: result
  }
});



/**
 * 添加案例
 */
router.post('/', permission, async ctx => {
  let body = ctx.request.body;
  let hnews = new HomeNews();

  hnews.cover = body.cover;
  hnews.text = body.text;
  hnews.title = body.title;
  hnews.language = body.language;
  hnews.nid = body.nid;
  hnews.sort = body.sort;

  let { insertId } = await hnews.insert()

  ctx.body = {
    msg: '成功添加!',
    insertId
  };
});



/**
 * 修改案例
 */
router.put('/', permission, async ctx => {
  let body = ctx.request.body;
  let hnews = new HomeNews();
  hnews.id = body.id;

  if (!await hnews.exists()) {
    ctx.error('该案例不存在!')
  }

  hnews.cover = body.cover;
  hnews.text = body.text;
  hnews.title = body.title;
  hnews.language = body.language;
  hnews.sort = body.sort;

  await hnews.update()

  ctx.body = {
    msg: '成功修改!'
  };
});

/**
 * 删除案例
 */
router.delete('/:id', permission, async ctx => {
  let id = ctx.params.id;

  (!id || !Number.isFinite(Number(id))) &&
    ctx.error('该案例不存在，请刷新后重试！');

  let hnews = new HomeNews();
  hnews.id = id;
  hnews.hide = 0;

  (await hnews.exists()) ||
    ctx.error('该案例不存在，请刷新后重试！');

  hnews.hide = 1;
  await hnews.update();

  ctx.body = { msg: '成功删除！' };
});

module.exports = exports = { path: '/home_news', router };