require "datagrid/utils" require "active_support/core_ext/class/attribute" module Datagrid module Columns require "datagrid/columns/column" def self.included(base) base.extend ClassMethods base.class_eval do include Datagrid::Core class_attribute :default_column_options self.default_column_options = {} class_attribute :batch_size self.batch_size = 1000 end base.send :include, InstanceMethods end # self.included module ClassMethods ## # :method: batch_size= # # :call-seq: batch_size=(size) # # Specify a default batch size when generating CSV or just data # Default: 1000 # # self.batch_size = 500 # # Disable batches # self.batch_size = nil # ## # :method: batch_size # # :call-seq: batch_size # # Returns specified batch_size configuration variable # See batch_size= for more information # ## # :method: default_column_options= # # :call-seq: default_column_options=(options) # # Specifies default options for `column` method. # They still can be overwritten at column level. # # # Disable default order # self.default_column_options = { :order => false } # # Makes entire report HTML # self.default_column_options = { :html => true } # ## # :method: default_column_options # # :call-seq: default_column_options # # Returns specified default column options hash # See default_column_options= for more information # # Returns a list of columns defined. # All column definistion are returned by default # You can limit the output with only columns you need like: # # grid.columns(:id, :name) # # Supported options: # # * :data - if true returns only non-html columns. Default: false. def columns(*args) options = args.extract_options! args.compact! args.map!(&:to_sym) columns_array.select do |column| (!options[:data] || column.data?) && (!options[:html] || column.html?) && (column.mandatory? || args.empty? || args.include?(column.name)) end end # Defines new datagrid column # # Arguments: # # * name - column name # * query - a string representing the query to select this column (supports only ActiveRecord) # * options - hash of options # * block - proc to calculate a column value # # Available options: # # * :html - determines if current column should be present in html table and how is it formatted # * :order - determines if this column could be sortable and how. # The value of order is explicitly passed to ORM ordering method. # Ex: "created_at, id" for ActiveRecord, [:created_at, :id] for Mongoid # * :order_desc - determines a descending order for given column # (only in case when :order can not be easily reversed by ORM) # * :order_by_value - used in case it is easier to perform ordering at ruby level not on database level. # Warning: using ruby to order large datasets is very unrecommended. # If set to true - datagrid will use column value to order by this column # If block is given - datagrid will use value returned from block # * :mandatory - if true, column will never be hidden with #column_names selection # * :url - a proc with one argument, pass this option to easily convert the value into an URL # * :before - determines the position of this column, by adding it before the column passed here # * :after - determines the position of this column, by adding it after the column passed here # * :if - the column is shown if the reult of calling this argument is true # * :unless - the column is shown unless the reult of calling this argument is true # # See: https://github.com/bogdan/datagrid/wiki/Columns for examples def column(name, options_or_query = {}, options = {}, &block) if options_or_query.is_a?(String) query = options_or_query else options = options_or_query end check_scope_defined!("Scope should be defined before columns") block ||= lambda do |model| model.send(name) end position = Datagrid::Utils.extract_position_from_options(columns_array, options) column = Datagrid::Columns::Column.new(self, name, query, default_column_options.merge(options), &block) columns_array.insert(position, column) end # Returns column definition with given name def column_by_name(name) self.columns.find do |col| col.name.to_sym == name.to_sym end end # Returns an array of all defined column names def column_names columns.map(&:name) end def respond_to(&block) #:nodoc: Datagrid::Columns::Column::ResponseFormat.new(&block) end def format(value, &block) if block_given? respond_to do |f| f.data { value } f.html do instance_exec(value, &block) end end else # Ruby Object#format exists. # We don't want to change the behaviour and overwrite it. super end end def inherited(child_class) #:nodoc: super(child_class) child_class.columns_array = self.columns_array.clone end end # ClassMethods module InstanceMethods def assets driver.append_column_queries(super, columns.select(&:query)) end # Returns Array of human readable column names. See also "Localization" section # # Arguments: # # * column_names - list of column names if you want to limit data only to specified columns def header(*column_names) data_columns(*column_names).map(&:header) end # Returns Array column values for given asset # # Arguments: # # * column_names - list of column names if you want to limit data only to specified columns def row_for(asset, *column_names) data_columns(*column_names).map do |column| column.data_value(asset, self) end end # Returns Hash where keys are column names and values are column values for the given asset def hash_for(asset) result = {} self.data_columns.each do |column| result[column.name] = column.data_value(asset, self) end result end # Returns Array of Arrays with data for each row in datagrid assets without header. # # Arguments: # # * column_names - list of column names if you want to limit data only to specified columns def rows(*column_names) map_with_batches do |asset| self.row_for(asset, *column_names) end end # Returns Array of Arrays with data for each row in datagrid assets with header. # # Arguments: # # * column_names - list of column names if you want to limit data only to specified columns def data(*column_names) self.rows(*column_names).unshift(self.header(*column_names)) end # Return Array of Hashes where keys are column names and values are column values # for each row in filtered datagrid relation. # # Example: # # class MyGrid # scope { Model } # column(:id) # column(:name) # end # # Model.create!(:name => "One") # Model.create!(:name => "Two") # # MyGrid.new.data_hash # => [{:name => "One"}, {:name => "Two"}] # def data_hash map_with_batches do |asset| hash_for(asset) end end # Returns a CSV representation of the data in the table # You are able to specify which columns you want to see in CSV. # All data columns are included by default # Also you can specify options hash as last argument that is proxied to # Ruby CSV library. # # Example: # # grid.to_csv # grid.to_csv(:id, :name) # grid.to_csv(:col_sep => ';') def to_csv(*column_names) options = column_names.extract_options! klass = if RUBY_VERSION >= "1.9" require 'csv' CSV else require "fastercsv" FasterCSV end klass.generate( {:headers => self.header(*column_names), :write_headers => true}.merge(options) ) do |csv| self.rows(*column_names).each do |row| csv << row end end end # Returns all columns selected in grid instance # # Examples: # # MyGrid.new.columns # => all defined columns # grid = MyGrid.new(:column_names => [:id, :name]) # grid.columns # => id and name columns # grid.columns(:id, :category) # => id and category column def columns(*args) self.class.columns(*args).select {|column| column.enabled?(self)} end # Returns all columns that can be represented in plain data(non-html) way def data_columns(*names) options = names.extract_options! options[:data] = true names << options self.columns(*names) end # Returns all columns that can be represented in HTML table def html_columns(*names) options = names.extract_options! options[:html] = true names << options self.columns(*names) end # Finds a column definition by name def column_by_name(name) self.class.column_by_name(name) end # Gives ability to have a different formatting for CSV and HTML column value. # # Example: # # column(:name) do |model| # format(model.name) do |value| # content_tag(:strong, value) # end # end # # column(:company) do |model| # format(model.company.name) do # render :partial => "company_with_logo", :locals => {:company => model.company } # end # end def format(value, &block) if block_given? self.class.format(value, &block) else # don't override Object#format method super end end # Returns an object representing a table row. # Allows to access column values # # Example: # # class MyGrid # scope { User } # column(:id) # column(:name) # column(:number_of_purchases) do |user| # user.purchases.count # end # end # # row = MyGrid.new.data_row(User.last) # row.id # => user.id # row.number_of_purchases # => user.purchases.count def data_row(asset) ::Datagrid::Columns::DataRow.new(self, asset) end protected def map_with_batches(&block) if batch_size && batch_size > 0 driver.batch_map(assets, batch_size, &block) else assets.map(&block) end end end # InstanceMethods class DataRow def initialize(grid, model) @grid = grid @model = model end def method_missing(meth, *args, &blk) if column = @grid.column_by_name(meth) column.data_value(@model, @grid) else super end end end end end