DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Adrienne Eichmann	quibusdam sed sit	Apple	67.0
Alex Legros	quibusdam sed sit	Apple	42.0
Alise Rolfson	quibusdam sed sit	Apple	36.0
Almeta Adams	quibusdam sed sit	Apple	36.0
Arnita Smith	quibusdam sed sit	Apple	33.0
Ashleigh Kris	quibusdam sed sit	Apple	38.0
Awilda Schumm	quibusdam sed sit	Apple	84.0
Benita Thompson	quibusdam sed sit	Apple	48.0
Beverlee Auer	quibusdam sed sit	Apple	53.0
Blake Hoppe	quibusdam sed sit	Apple	66.0
Bok Wolf	quibusdam sed sit	Apple	71.0
Bong Witting	quibusdam sed sit	Apple	42.0
Bridgett Reilly	quibusdam sed sit	Apple	67.0
Brigid McLaughlin	quibusdam sed sit	Apple	52.0
Britney Ruecker	quibusdam sed sit	Apple	63.0
Carlota Gottlieb	quibusdam sed sit	Apple	50.0
Cathey Prohaska	quibusdam sed sit	Apple	79.0
Cherly Kovacek	quibusdam sed sit	Apple	40.0
Claudette Hagenes	quibusdam sed sit	Apple	58.0
Clifton Hintz	quibusdam sed sit	Apple	81.0
Crissy Brekke	quibusdam sed sit	Apple	78.0
Cristopher Dooley	quibusdam sed sit	Apple	80.0
Dahlia Hilll	quibusdam sed sit	Apple	37.0
Dania Crona	quibusdam sed sit	Apple	59.0
Deja Corkery	quibusdam sed sit	Apple	52.0

Grid:

class TimeEntriesGrid < BaseGrid

  #
  # Scope
  #

  scope do
    User.select(
      "users.name, projects.name as project_name, accounts.name as account_name, sum(time_entries.hours) as report_hours"
    ).joins(:time_entries => {:project => :account}).group("projects.name", "users.name", "accounts.name").order("users.name")

  end


  #
  # Filters
  #

  filter(:project_id, :enum,
    :select => lambda {Project.all.map {|p| [p.name, p.id]}},
    :multiple => true,
    :include_blank => false
  ) do |value|
    self.where(:time_entries => {:project_id => value})
  end


  filter(:year, :enum,
         :select => lambda { TimeEntry.all.any? ? (TimeEntry.minimum(:date).year..TimeEntry.maximum(:date).year) : []},
    :include_blank => false,
    :default => lambda {Date.today.year}
  ) do |value|
    self.where(["extract(year from time_entries.date) = ?", value.to_i])
  end

  filter(:month, :enum,
         :select => Date::MONTHNAMES[1..12].enum_for(:each_with_index).collect {|name, index| [name, index + 1]},
         :include_blank => false,
         :default => lambda {Date.today.month}
        ) do |value|

    self.where(["extract(month from time_entries.date) = ?", value.to_i])
  end


  #
  # Columns
  #

  column(:user_name, :header => "Developer", :order => "users.name") do
    self.name
  end
  column(:project_name, :header => "Project", :order => "projects.name")
  column(
    :account_name,
    :header => "Company",
    :order => "accounts.name",
  ) do |model|
    format(model.account_name) do
      render :partial => "time_entries/company", :locals => {:model => model}
    end
  end

  column(:report_hours, order: "sum(time_entries.hours)")

end

Controller:

class TimeEntriesController < ApplicationController

  def index
    @time_entries_grid = TimeEntriesGrid.new(params[:g]) do |scope|
      scope.page(params[:page] )
    end
  end
end

View:


<h3>Time Entries Grid</h3>


<div class="left">
  <%= datagrid_form_for @time_entries_grid, url: time_entries_path %>
  <br/>

  <%= datagrid_table(@time_entries_grid) %>
  <%= paginate @time_entries_grid.assets %>

</div>

<div class="right">
  <%= render :partial => "shared/source", :object => @time_entries_grid %>
</div>