Contents

class EmployeeReport < Dossier::Report

  set_callback :build_query, :before, :example_before_hook
  set_callback :execute,     :after  do
    # do some stuff
  end

  # Valid for users to choose via a multi-select
  def self.valid_columns
    %w[id name hired_on suspended]
  end

  def sql
    "SELECT #{columns} FROM employees WHERE 1=1".tap do |sql|
      sql << "\n AND division in (:divisions)"  if divisions.any?
      sql << "\n AND salary > :salary"          if salary?
      sql << "\n AND (#{names_like})"           if names_like.present?
      sql << "\n ORDER BY name #{order}"
    end
  end

  def columns
    valid_columns.join(', ').presence || '*'
  end

  def valid_columns
    self.class.valid_columns & Array.wrap(options[:columns])
  end

  def order
    options[:order].to_s.upcase === 'DESC' ? 'DESC' : 'ASC'
  end

  def salary
    10_000
  end

  def name
    "%#{names.pop}%"
  end

  def divisions
    @divisions ||= options.fetch(:divisions) { [] }
  end

  def salary?
    options[:salary].present?
  end

  def names_like
    names.map { |name| "name like :name" }.join(' or ')
  end

  def names
    @names ||= options.fetch(:names) { [] }.dup
  end

  def format_salary(amount)
    formatter.number_to_currency(amount) # unless format.csv?
  end

  def format_hired_on(date)
    date.to_s(:db)
  end

  def format_name(name)
    "Employee #{name}"
  end

  def format_suspended(value)
    value.to_i == 1 ? 'Yes' : 'No'
  end

  def example_before_hook
    # do some stuff
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
dossier-2.0.1	spec/support/reports/employee.rb
dossier-2.0.0	spec/support/reports/employee_report.rb