DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Huong McKenzie	perspiciatis totam perferendis	Apple	44.0
Palmira Fay	repudiandae officiis qui	Google	44.0
Gonzalo Blanda	repudiandae officiis qui	Google	44.0
Lesia Hyatt	eum amet quia	Google	44.0
Clifton Hintz	eum amet quia	Google	44.0
Sixta Bashirian	quibusdam sed sit	Apple	43.0
Penney Schowalter	eum amet quia	Google	43.0
Jewell Kreiger	suscipit consectetur beatae	Google	43.0
Kaye Greenfelder	saepe hic temporibus	Microsoft	43.0
Clifton Hintz	perspiciatis totam perferendis	Apple	43.0
Brigid McLaughlin	perspiciatis totam perferendis	Apple	43.0
Jackson Kozey	quibusdam sed sit	Apple	43.0
Tamika Cronin	odio velit repudiandae	Apple	43.0
Rossana Schneider	odio velit repudiandae	Apple	43.0
Imelda Heidenreich	doloribus hic corporis	Microsoft	43.0
Jamie Stehr	repudiandae officiis qui	Google	43.0
Beverlee Auer	doloribus hic corporis	Microsoft	43.0
Benita Thompson	repudiandae officiis qui	Google	43.0
Myriam Von	perspiciatis totam perferendis	Apple	42.0
Verla Friesen	repudiandae officiis qui	Google	42.0
Ethyl Ankunding	odio velit repudiandae	Apple	42.0
Carlota Gottlieb	perspiciatis totam perferendis	Apple	42.0
Brigid McLaughlin	saepe hic temporibus	Microsoft	42.0
Li Considine	vitae eum pariatur	Google	42.0
Huong McKenzie	suscipit consectetur beatae	Google	42.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>