Reporta Modules

reporta-modules is a Rails gem packed with modules and helpers to help you build your reports.

It is also a fork from the original reporta Rails engine gem.

Add reporta-modules to your Gemfile

gem 'reporta-modules'

Generate default view templates / $ rails generate reporta:views

Include Reporta::Reportable in your view model.

class YourReport
  include Reporta::Reportable
end

class ProjectReport
  include Reporta::Reportable

  filter :start_date, default: '2013-01-01', required: true
  filter :finish_date, default: '2013-12-13', required: true

  column :name
  column :created_at

  def rows
    Project.where(created_at: start_date..finish_date)
  end
end

class ProjectReportsController < ApplicationController
  def show
    @report = ProjectReport.new(params[:reporta_form])
  end
end

<%= filters_for @report %>
<%= table_for @report %>

Reporta::Reportable added DSL for your convenience to create your report's view model/object.

Reports are normally generated based on filters or input from users. Define those filters with filter filter_name [options].
For example:

class ProjectReport
  include Reporta::Reportable

  filter :start_date, as: :date, default: '2013-01-01', required: true 
  filter :finish_date, as: :date, default: '2013-12-31', required: true
  filter :status, collection: Status.all, include_blank: false
  filter :exclude_deleted, as: :boolean, default: false
  
  def rows 
    # use filters above to manipulate the results
    projects = Project.where(created_at: start_date..finish_date)
      .where(status: status)
    projects = projects.where(deleted_at: nil) if exclude_deleted
    projects
  end
end

Filter Options

• required - set to true to specify it as required, defaults to false.
• collection - specify a collection to render a select input, will be used in options_for_select(collection)
• include_blank - specify whether to include blank in the select input, defaults to true.
• as - specify the type of field. e.g. :boolean, :string, :check_boxes, :radio, :date, defaults to :string.
• default - set the default value for the filter.
• label - set the label for the filter.

Tables will be generated in your report, defining columns with DSL allows the flexibility of changes on what will be display. Define those columns with column column_name [options].
For example:

class ProjectReport
  include Reporta::Reportable
  
  def indexed; @index||=0; @index += 1; end
  
  column :indexed, title: 'No.:'
  column :name
  column :created_at, helper: :readable_date, title: 'Created at'
  column :manager, data_chain: 'manager.full_name'
  column :cost, class_names: 'sum currency'

  def rows
    Projects.all
  end

  def readable_date(value)
    value.strftime("%b %d, %Y")
  end
end

Column Options

• title - set a custom title, defaults to the column.humanize
• data_chain - provide a chain of methods to call in order to fetch the data.
• class_names - specify html class attribute for column, useful for custom styling or Javascript hooks.
• helper - specify view helper for the column

Define the rows method to represent data rows to be used for display.
Note: For the return array of records, each record should comform(respond_to) to the specified columns.
For example:

class ProjectReport
  include Reporta::Reportable

  column :full_name
  
  def rows
    Project.select('concat(first_name, last_name) as full_name').all
  end
end

View templates are available after running rails generate reporta:views, it will generate views in app/views/reporta folder for you to customize. These templates are required for the view helpers:

The filters_for helper generates a html form based on the filters you have defined.

<%= filters_for @report %>

Template: app/views/reporta/report/_filters.html.erb

<%= form_for @report.form do |f| %>
  <% @report.filters.each do |filter| %>
    <%= f.label filter.name %>
    <%= f.text_field filter.name %>
  <% end %>
  <%= f.submit %>
<% end %>

The table_for helper generates a html table based on the columns you have defined.

<%= table_for @report %>

Template:

<table>
  <thead>
  	<tr>
      <% @report.columns.each do |column| %>
        <th class="#{column.class_names}">
       	  <%= column.title %>
        </th>
      <% end %>
    </tr>
  </thead>
  <tbody>
    <% @report.rows.each do |record| %>
      <tr>
        <% @report.columns.each do |column| %>
          <th class="#{column.class_names}">
            <%= @report.value_for(record, column) %>
          </th>
        <% end %>
      </tr>
    <% end %>
  </tbody>
</table>

After Reporta::Reportable is included, useful instance methods are also added as below:

• filters - returns hash of filters definition. e.g. filters[:name]
• params - return hash of filters' values received from request. e.g. params[:name]

see MIT-LICENSE