Sequelize分页 -针对拼接数组进行封装

最新推荐文章于 2023-09-23 15:08:33 发布

Demo_xr

最新推荐文章于 2023-09-23 15:08:33 发布

阅读量460

点赞数 1

分类专栏： Sequelize 文章标签： nodejs mysql

本文链接：https://blog.csdn.net/Tirst_/article/details/106028555

版权

Sequelize 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

代码流程

1. 数组1查询

    const AllTourGuide = await this._TourGuide.findAll({
      include: this._getAssociationOptionsForTime()
    })
    let arr = []
    for (let leave of AllTourGuide) {
      if (leave.tour_guide_leaves.length === 0) {
        arr.push(leave)
      }
    }

arr数组

2. 数组2查询

    let where = { attractionId }
    let include = null
    if (Time) {
      include = this._getAssociationOptionForTime(Time)
    } else {
      include = this._getAssociationOptionsForTime()
    }
    const options = {
      where,
      include
    }
    const leaveGuide = await this._TourGuide.findAll(options)

3.返回数组1，数组2 并对返回的数组分页

 return this.getpaging(currentPage, Count, result)
  }

  getpaging (currentPage, count, result) {
    return result.slice((currentPage - 1) * count, currentPage * count)
  }