DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Raquel Runolfsson	saepe hic temporibus	Microsoft	44.0
Maryanna Medhurst	doloribus hic corporis	Microsoft	44.0
Bok Wolf	perspiciatis totam perferendis	Apple	44.0
Palmira Fay	odio velit repudiandae	Apple	44.0
Gonzalo Blanda	vitae eum pariatur	Google	44.0
Imelda Heidenreich	vitae eum pariatur	Google	44.0
Kaye Greenfelder	eum amet quia	Google	44.0
Crissy Brekke	animi aperiam tenetur	Google	44.0
Ethyl Ankunding	odio velit repudiandae	Apple	43.0
Raquel Runolfsson	repudiandae officiis qui	Google	43.0
Almeta Adams	odio velit repudiandae	Apple	43.0
Dania Crona	animi aperiam tenetur	Google	43.0
Jeanne Witting	repudiandae officiis qui	Google	43.0
Jamison Hagenes	eum amet quia	Google	43.0
Pearlie McGlynn	saepe hic temporibus	Microsoft	43.0
Thaddeus Stanton	quibusdam sed sit	Apple	43.0
Terisa Ruecker	repudiandae officiis qui	Google	43.0
Myriam Von	odio velit repudiandae	Apple	43.0
Myriam Von	animi aperiam tenetur	Google	43.0
Shara Labadie	doloribus hic corporis	Microsoft	42.0
Flavia Will	suscipit consectetur beatae	Google	42.0
Crissy Brekke	odio velit repudiandae	Apple	42.0
Alex Legros	quibusdam sed sit	Apple	42.0
Eleonore Wisozk	quibusdam sed sit	Apple	42.0
Bong Witting	quibusdam sed sit	Apple	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>