DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Alex Legros	doloribus hic corporis	Microsoft	89.0
Myriam Von	odio velit repudiandae	Apple	90.0
Jamie Stehr	eum amet quia	Google	90.0
Dona Gutkowski	animi aperiam tenetur	Google	90.0
Gonzalo Blanda	eum amet quia	Google	90.0
Jeanne Witting	doloribus hic corporis	Microsoft	90.0
Malvina Zulauf	eum amet quia	Google	90.0
Beverlee Auer	animi aperiam tenetur	Google	90.0
Britney Ruecker	doloribus hic corporis	Microsoft	90.0
Cristopher Dooley	repudiandae officiis qui	Google	90.0
Carlota Gottlieb	suscipit consectetur beatae	Google	90.0
Alise Rolfson	quibusdam sed sit	Apple	90.0
Elisa Wintheiser	saepe hic temporibus	Microsoft	91.0
Tamika Cronin	quibusdam sed sit	Apple	91.0
Alise Rolfson	suscipit consectetur beatae	Google	91.0
Brigid McLaughlin	suscipit consectetur beatae	Google	91.0
Bok Wolf	perspiciatis totam perferendis	Apple	91.0
Gwendolyn Satterfield	suscipit consectetur beatae	Google	91.0
Kellie Cassin	suscipit consectetur beatae	Google	91.0
Thaddeus Stanton	suscipit consectetur beatae	Google	91.0
Johnny Spinka	doloribus hic corporis	Microsoft	91.0
Elida Zulauf	animi aperiam tenetur	Google	91.0
Sylvester Hane	saepe hic temporibus	Microsoft	92.0
Wiley Wuckert	perspiciatis totam perferendis	Apple	92.0
Juliana Hauck	quibusdam sed sit	Apple	92.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>