Module: Lipsiadmin::DataBase::UtilityScopes

Defined in:
lib/data_base/utility_scopes.rb

Overview

This Module provides named scope for:

  • Search records in a extjs way (but can reusable)

  • Paginate records in a extjs way (but can be reusable)

  • Add association to the model (used for search in dependents tables)

    Examples:

    invoices = .store.invoices.with(:order).ext_search(params)
invoices_count = invoices.size
invoices_paginated = invoices.ext_paginate(params)

Class Method Summary collapse

Class Method Details

.included(base) ⇒ Object

:nodoc:



16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 
# File 'lib/data_base/utility_scopes.rb', line 16

def self.included(base)#:nodoc:
  base.class_eval do
    named_scope :ext_search, lambda { |params|
      order = params[:sort].blank? && params[:dir].blank? ? nil : "#{params[:sort]} #{params[:dir]}"
      conditions = nil

      if !params[:query].blank? && !params[:fields].blank?
        filters = params[:fields].split(",").collect { |f| "#{f} LIKE ?" }.compact
        conditions = [filters.join(" OR ")].concat((1..filters.size).collect { "%#{params[:query]}%" })
      end

      { :conditions => conditions }
    }
    named_scope :ext_paginate, lambda { |params|
      order = params[:sort].blank? && params[:dir].blank? ? nil : "#{params[:sort]} #{params[:dir]}"
      { :order => order, :limit => params[:limit], :offset => params[:start] }
    }
    named_scope :with, lambda { |*associations| { :include => associations } }

    # You or your plugins (ex: will_paginate) now can override the search/paginate
    # at the moment we can't remove them for backward compatibility.
    (class << self; self end).instance_eval do
      %w(search paginate).each do |name|
        define_method name do |*args|
          send("ext_#{name}", *args)
        end
      end
    end
  end
end