DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Adrienne Eichmann	quibusdam sed sit	Apple	67.0
Alex Legros	quibusdam sed sit	Apple	84.0
Alise Rolfson	quibusdam sed sit	Apple	67.0
Almeta Adams	quibusdam sed sit	Apple	92.0
Arnita Smith	quibusdam sed sit	Apple	56.0
Ashleigh Kris	quibusdam sed sit	Apple	71.0
Awilda Schumm	quibusdam sed sit	Apple	68.0
Benita Thompson	quibusdam sed sit	Apple	83.0
Beverlee Auer	quibusdam sed sit	Apple	33.0
Blake Hoppe	quibusdam sed sit	Apple	29.0
Bok Wolf	quibusdam sed sit	Apple	72.0
Bong Witting	quibusdam sed sit	Apple	69.0
Bridgett Reilly	quibusdam sed sit	Apple	48.0
Brigid McLaughlin	quibusdam sed sit	Apple	64.0
Britney Ruecker	quibusdam sed sit	Apple	48.0
Carlota Gottlieb	quibusdam sed sit	Apple	69.0
Cathey Prohaska	quibusdam sed sit	Apple	55.0
Cherly Kovacek	quibusdam sed sit	Apple	74.0
Claudette Hagenes	quibusdam sed sit	Apple	74.0
Clifton Hintz	quibusdam sed sit	Apple	65.0
Crissy Brekke	quibusdam sed sit	Apple	65.0
Cristopher Dooley	quibusdam sed sit	Apple	87.0
Dahlia Hilll	quibusdam sed sit	Apple	56.0
Dania Crona	quibusdam sed sit	Apple	60.0
Deja Corkery	quibusdam sed sit	Apple	44.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>