按照 Rails 中连接模型定义的顺序进行分页

发布于 2024-09-26 22:38:32 字数 870 浏览 1 评论 0原文

目前，我的 Rails 应用程序 (Rails 2.3.5) 中存在以下问题：

我想按作者姓名和书名对存储在应用程序中的书籍进行排序。

Book和Author是具体模型，对应的表是Ressources和People。模式的相关部分是（我稍微简化了模型）：

  create_table "people", :force => true do |t|
      t.string   "sur_name"
      t.string   "pre_name"
      ...
      t.string   "type"
    end

  create_table "people_ressources", :id => false, :force => true do |t|
      t.integer  "ressource_id"
      t.integer  "person_id"
    end

  create_table "ressources", :force => true do |t|
      t.string   "type"
      t.string   "title"
    end

为了显示书籍列表，我使用了以下分页器：

@books = Book.paginate(
             :order => 'title', :per_page => 15, :page => params[:page])

我现在的问题是：应该如何构建分页器，以便书籍按顺序排列按标题，但首先按作者（==人） sur_name？如果这不容易实现，那么什么构造可以允许将书籍和作者存储为单独的实体，但又允许获得具有定义顺序的分页器？

原文

I have currently the following problem in my Rails application (Rails 2.3.5):

I want to sort books stored in the application by the author name, then the title of the book.

Book and Author are concrete models, the corresponding tables are Ressources and People. The relevant portion of the schema is (I have stripped down the model a bit):

  create_table "people", :force => true do |t|
      t.string   "sur_name"
      t.string   "pre_name"
      ...
      t.string   "type"
    end

  create_table "people_ressources", :id => false, :force => true do |t|
      t.integer  "ressource_id"
      t.integer  "person_id"
    end

  create_table "ressources", :force => true do |t|
      t.string   "type"
      t.string   "title"
    end

To show the list of books, I have used the following paginator:

@books = Book.paginate(
             :order => 'title', :per_page => 15, :page => params[:page])

My question now is: How should the paginator be constructed so that the books are ordered not by title, but first by author (== person) sur_name? And if that is not easily reachable, what construct would allow to store books and authors as separate entities, but would allow to get a paginator with the defined order?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

手长情犹 2024-10-03 22:38:32

鉴于您的一本书有多个作者，您需要决定如何确定应使用哪个作者的姓名来对图书列表进行排序。

您可以添加关联 has_one :main_author, :class_name => 'Author' 到您的 Book 类中，按照您的意愿进行定义（也许在 people_ressources 中有一个主要作者字段，或者您只使用可用的第一个作者

has_one :main_author, :through => :author_books, :order => 'sur_name'

： has_one 关联意味着您可以将其包含在分页中并根据 sur_name 进行排序：

@books = Book.paginate(:order => "#{Author.table_name}.sur_name", 
                       :per_page => 15, 
                       :page => params[:page])

Given that you have multiple authors for a book you would need to decide how you determine which is the author whose name should be used to order the list of books.

You could add an association has_one :main_author, :class_name => 'Author' to your Book class defined however you wish (maybe there is a primary author field in people_ressources or maybe you just use the first author available:

has_one :main_author, :through => :author_books, :order => 'sur_name'

Having that has_one association means that you can include that in the pagination and order against the sur_name there:

@books = Book.paginate(:order => "#{Author.table_name}.sur_name", 
                       :per_page => 15, 
                       :page => params[:page])

回复收藏 0 原文

~没有更多了~