foodsoft/app/controllers/finance/ordergroups_controller.rb

class Finance::OrdergroupsController < Finance::BaseController
  def index
    m = /^(?<col>name|sum_of_class_\d+)(?<reverse>_reverse)?$/.match params["sort"]
    if m
      sort = m[:col]
      sort += ' DESC' if m[:reverse]
    else
      sort = "name"
    end

    @ordergroups = Ordergroup.undeleted.order(sort)
    @ordergroups = @ordergroups.include_transaction_class_sum
    @ordergroups = @ordergroups.where('groups.name LIKE ?', "%#{params[:query]}%") unless params[:query].nil?

    @ordergroups = @ordergroups.page(params[:page]).per(@per_page)
  end
end