DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Adrienne Eichmann	saepe hic temporibus	Microsoft	59.0
Brigid McLaughlin	perspiciatis totam perferendis	Apple	59.0
Eleonore Wisozk	eum amet quia	Google	59.0
Alise Rolfson	animi aperiam tenetur	Google	59.0
Rossana Schneider	doloribus hic corporis	Microsoft	59.0
Shane Glover	doloribus hic corporis	Microsoft	59.0
Elida Zulauf	vitae eum pariatur	Google	59.0
Malvina Zulauf	repudiandae officiis qui	Google	59.0
Verla Friesen	odio velit repudiandae	Apple	59.0
Isidro McCullough	quibusdam sed sit	Apple	59.0
Reinaldo Heidenreich	odio velit repudiandae	Apple	59.0
Claudette Hagenes	eum amet quia	Google	59.0
Clifton Hintz	animi aperiam tenetur	Google	59.0
Jackson Kozey	eum amet quia	Google	59.0
Arnita Smith	suscipit consectetur beatae	Google	59.0
Beverlee Auer	vitae eum pariatur	Google	58.0
Dania Crona	repudiandae officiis qui	Google	58.0
Flavia Will	odio velit repudiandae	Apple	58.0
Imelda Heidenreich	animi aperiam tenetur	Google	58.0
Marna Ritchie	animi aperiam tenetur	Google	58.0
Claudette Hagenes	repudiandae officiis qui	Google	58.0
Gonzalo Blanda	repudiandae officiis qui	Google	58.0
Gwendolyn Satterfield	perspiciatis totam perferendis	Apple	58.0
Gonzalo Blanda	saepe hic temporibus	Microsoft	58.0
Awilda Schumm	doloribus hic corporis	Microsoft	58.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>