Question

我需要编制一份铁路收据清单,需要按项目订单关系领域订购( 付款_method_meta_type. 姓名)。

模型:

Receipt
Deposit
PaymentMethodMetaType

在《交存示范法》中:

class Deposit < ActiveRecord::Base

  belongs_to :payment_method_meta_type
  has_many   :receipts, :class_name=>"Receipt", :foreign_key=>"deposit_id", 
                    :dependent => :destroy
end

我在控制器中的接收器已经穿透:

@receipts = Receipt.find(:all, :conditions => ["date BETWEEN ? AND ?", 
  @start_date, @end_date], :order => "date DESC, id DESC", 
  :limit => limit, :offset => offset)

在我看来,我可以显示付款“方法_meta”类型。

- @receipts.each do |o|
  %tr.
    .....
    %td #{o.receipt_number}
    %td #{o.deposit.payment_method_meta_type.name}
    .....

但是,在我设立收件阵列时,我如何按照<代码>的顺序显示名单?

Answer 1

当时,我最后做了大量工作,在座标中使用。

@receipts = Receipt.find(:all, :include => {:deposit => [:payment_method_meta_type] } ,:conditions => ["Receipts.business_date BETWEEN ? AND ?", @current_month_start_date, @current_month_end_date],:order => "tag_types.name , Receipts.business_date DESC",:limit => limit)

Answer 2

为此:

@receipts = Receipt.all(:joins => {:deposit => :payment_method_meta_type},
              :conditions => {:date => @start_date..@end_date}, 
              :order => "payment_method_meta_types.name ASC", 
              :limit => limit, :offset => offset)

友情链接