DatagridDemo

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