skl-service/service-cms/app/service/imgnews.js

'use strict';

const assert = require('assert');
const moment = require('moment');
const Service = require('egg').Service;
class ImgnewsService extends Service {
  constructor(ctx) {
    super(ctx);
    this.model = this.ctx.model.Imgnews;
    this.column = this.ctx.model.Column;
    this.pages = this.ctx.model.Pages;
  }
  async create({ type, bind, date, img, url, content, describe, title, isshow, twoTitle }) {
    assert(bind, '绑定类型不存在');
    // assert(img, '图片不存在');
    assert(title, '标题不存在');
    try {
      const createAt = moment().format('x');
      const updateAt = moment().format('x');
      const item = await this.model.create({ title, type, bind, date, img, url, content, describe, createAt, updateAt, isshow, twoTitle });
      return { errcode: 0, errmsg: '', data: item };
    } catch (error) {
      throw error;
    }
  }
  async update({ id, type, bind, date, img, url, content, describe, title, isshow, twoTitle }) {
    assert(id, 'id不存在');
    try {
      const res = await this.model.findOne({ _id: id });
      if (!res) return { errcode: -1001, errmsg: '数据不存在', data: '' };
      const updateAt = moment().format('x');
      await this.model.updateOne({ _id: id }, { title, type, bind, date, img, url, content, describe, updateAt, isshow, twoTitle });
      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: '' };
      await this.model.remove({ _id: id });
      return { errcode: 0, errmsg: '', data: 'delete' };
    } catch (error) {
      throw error;
    }
  }
  async query({ skip, limit, title, date, bind, isshow, twoTitle }) {
    const filter = {};
    if (title || date) filter.$or = [];
    if (title) filter.$or.push({ code: { $regex: title } });
    if (twoTitle) filter.$or.push({ code: { $regex: twoTitle } });
    if (date) filter.$or.push({ date: { $regex: date } });
    if (bind) filter.bind = bind;
    if (isshow) filter.isshow = isshow;
    try {
      // let res;
      // const total = await this.model.find({ ...filter }, { content: false });
      // if (skip && limit) {
      //   res = await this.model.find({ ...filter }, { content: false })
      //     .skip(Number(skip) * Number(limit))
      //     .limit(Number(limit));
      // } else {
      //   res = await this.model.find({ ...filter }, { content: false });
      // }
      // return { errcode: 0, errmsg: '', data: res, total: total.length };
      // 获取完整未分页结果
      const totalList = await this.model.find({ ...filter }, { content: false });

      // 在 JS 层进行排序：将 date 为 0 的放最后，其它按 date 降序
      const sorted = totalList.sort((a, b) => {
        const aDate = a.date || 0;
        const bDate = b.date || 0;

        // 把 date=0 的排在后面
        if (aDate === 0 && bDate !== 0) return 1;
        if (aDate !== 0 && bDate === 0) return -1;

        return bDate - aDate; // 正常降序排序
      });

      // 再进行分页
      let res = sorted;
      if (skip && limit) {
        const start = Number(skip) * Number(limit);
        const end = start + Number(limit);
        res = sorted.slice(start, end);
      }

      return {
        errcode: 0,
        errmsg: '',
        data: res,
        total: totalList.length,
      };
    } catch (error) {
      throw error;
    }
  }
  async fetch({ id }) {
    try {
      const res = await this.model.findOne({ _id: id });
      if (!res) return { errcode: -1001, errmsg: '数据不存在', data: '' };
      return { errcode: 0, errmsg: '', data: res };
    } catch (error) {
      throw error;
    }
  }
}

module.exports = ImgnewsService;