DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Tamika Cronin	vitae eum pariatur	Google	66.0
Marna Ritchie	eum amet quia	Google	66.0
Elsa Goodwin	doloribus hic corporis	Microsoft	66.0
Ethyl Ankunding	doloribus hic corporis	Microsoft	66.0
Royce Spencer	quibusdam sed sit	Apple	67.0
Jewell Swaniawski	quibusdam sed sit	Apple	67.0
Bong Witting	quibusdam sed sit	Apple	67.0
Shane Glover	odio velit repudiandae	Apple	67.0
Elenora Brakus	animi aperiam tenetur	Google	67.0
Desmond Murray	quibusdam sed sit	Apple	67.0
Lynell Stamm	quibusdam sed sit	Apple	67.0
Huong McKenzie	eum amet quia	Google	67.0
Clifton Hintz	perspiciatis totam perferendis	Apple	67.0
Li Considine	saepe hic temporibus	Microsoft	67.0
Elida Zulauf	vitae eum pariatur	Google	67.0
Lesia Hyatt	eum amet quia	Google	67.0
Carlota Gottlieb	animi aperiam tenetur	Google	67.0
Jackson Kozey	animi aperiam tenetur	Google	67.0
Treena Wolf	quibusdam sed sit	Apple	67.0
Verla Friesen	quibusdam sed sit	Apple	67.0
Beverlee Auer	odio velit repudiandae	Apple	67.0
Jeanne Witting	doloribus hic corporis	Microsoft	67.0
Joelle Hodkiewicz	doloribus hic corporis	Microsoft	67.0
Vivien Murray	animi aperiam tenetur	Google	67.0
Maryanna Medhurst	eum amet quia	Google	68.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>