DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Desmond Murray	doloribus hic corporis	Microsoft	53.0
Dona Gutkowski	doloribus hic corporis	Microsoft	47.0
Dorthey Turner	doloribus hic corporis	Microsoft	57.0
Elenora Brakus	doloribus hic corporis	Microsoft	60.0
Eleonore Wisozk	doloribus hic corporis	Microsoft	30.0
Elida Zulauf	doloribus hic corporis	Microsoft	57.0
Elisa Wintheiser	doloribus hic corporis	Microsoft	56.0
Elise Waelchi	doloribus hic corporis	Microsoft	41.0
Elli Dietrich	doloribus hic corporis	Microsoft	84.0
Elsa Goodwin	doloribus hic corporis	Microsoft	56.0
Ethyl Ankunding	doloribus hic corporis	Microsoft	92.0
Evangelina Pfeffer	doloribus hic corporis	Microsoft	95.0
Felisa Jaskolski	doloribus hic corporis	Microsoft	41.0
Flavia Will	doloribus hic corporis	Microsoft	83.0
German Murphy	doloribus hic corporis	Microsoft	41.0
Gonzalo Blanda	doloribus hic corporis	Microsoft	42.0
Grace Kris	doloribus hic corporis	Microsoft	29.0
Gwendolyn Satterfield	doloribus hic corporis	Microsoft	55.0
Huong McKenzie	doloribus hic corporis	Microsoft	16.0
Imelda Heidenreich	doloribus hic corporis	Microsoft	89.0
Isidro McCullough	doloribus hic corporis	Microsoft	50.0
Jackson Kozey	doloribus hic corporis	Microsoft	51.0
Jamie Stehr	doloribus hic corporis	Microsoft	69.0
Jamison Hagenes	doloribus hic corporis	Microsoft	93.0
Jarvis Ryan	doloribus hic corporis	Microsoft	60.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>