ruby-on-rails - Searchkick分页，限制和偏移问题，滑轨

Question

我想在第一行显示3个最后的外观，然后我要显示所有其他但没有3个最后的外观。
这是我的代码

def index
    query = params[:query].presence || "*"
    conditions = {}
    conditions[:available] = true
    conditions[:look_tags] = params[:look_tags] if params[:look_tags].present?
    @last_3_looks = Look.search query, where: conditions, order: { created_at: :desc }, limit: 3
    @looks = Look.search query, where: conditions, order: { created_at: :desc }, page: params[:page], per_page: 8
end

问题是如果我像下面这样放置偏移量，我在每页上都有相同的8个外观，请问如何处理？

@looks = Look.search query, where: conditions, order: { created_at: :desc }, page: params[:page], per_page: 8, offset: 3
end

Answer 1

好像您要计算偏移量，例如:

  page = params[:page].to_i
  per_page = 8
  starting_offset = 3
  offset = starting_offset + ((page - 1) * per_page)

  @looks = Look.search query, where: conditions, order: { created_at: :desc }, page: page, per_page: per_page, offset: offset

但是您也可以考虑使用 kaminari gem，它将为您进行计算。
看起来像Searchkick allows that。
另外，请参阅此 answers。