DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Eleonore Wisozk	saepe hic temporibus	Microsoft	52.0
Tamera Bogan	doloribus hic corporis	Microsoft	52.0
Deja Corkery	quibusdam sed sit	Apple	52.0
Verla Friesen	vitae eum pariatur	Google	52.0
Cristopher Dooley	animi aperiam tenetur	Google	52.0
Ethyl Ankunding	suscipit consectetur beatae	Google	52.0
Wiley Wuckert	saepe hic temporibus	Microsoft	52.0
Bridgett Reilly	saepe hic temporibus	Microsoft	52.0
Joelle Hodkiewicz	quibusdam sed sit	Apple	52.0
Joelle Hodkiewicz	doloribus hic corporis	Microsoft	52.0
Bong Witting	repudiandae officiis qui	Google	52.0
Penney Schowalter	repudiandae officiis qui	Google	52.0
Awilda Schumm	perspiciatis totam perferendis	Apple	52.0
Jewell Swaniawski	repudiandae officiis qui	Google	52.0
Cherly Kovacek	doloribus hic corporis	Microsoft	53.0
Tess Nikolaus	perspiciatis totam perferendis	Apple	53.0
Felisa Jaskolski	perspiciatis totam perferendis	Apple	53.0
Beverlee Auer	quibusdam sed sit	Apple	53.0
Lillie Hamill	quibusdam sed sit	Apple	53.0
Wen Daniel	doloribus hic corporis	Microsoft	53.0
Elise Waelchi	quibusdam sed sit	Apple	53.0
Crissy Brekke	suscipit consectetur beatae	Google	53.0
Imelda Heidenreich	suscipit consectetur beatae	Google	53.0
Dorthey Turner	quibusdam sed sit	Apple	53.0
Bok Wolf	animi aperiam tenetur	Google	53.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>