Gem source code Demo source code
Author: Bogdan Gusiev
User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid

Reset

Developer
↑ ↓
Project
↑ ↓
Report hours
↑ ↓
Alex Legros perspiciatis totam perferendis 73.0
Rossana Schneider quibusdam sed sit 73.0
Johnny Spinka quibusdam sed sit 73.0
Juliana Hauck repudiandae officiis qui 73.0
Grace Kris suscipit consectetur beatae 73.0
Nelson Leannon quibusdam sed sit 72.0
Eleonore Wisozk animi aperiam tenetur 72.0
Blake Hoppe doloribus hic corporis 72.0
Thaddeus Stanton repudiandae officiis qui 72.0
Huong McKenzie odio velit repudiandae 72.0
Rebecca Rempel saepe hic temporibus 72.0
Terisa Ruecker suscipit consectetur beatae 72.0
Terisa Ruecker animi aperiam tenetur 72.0
Alex Legros saepe hic temporibus 72.0
Carlota Gottlieb repudiandae officiis qui 72.0
Wen Daniel repudiandae officiis qui 72.0
Treena Wolf odio velit repudiandae 72.0
Bok Wolf repudiandae officiis qui 72.0
Pearlie McGlynn eum amet quia 72.0
Claudette Hagenes repudiandae officiis qui 72.0
Cathey Prohaska vitae eum pariatur 71.0
Jamison Hagenes repudiandae officiis qui 71.0
Evangelina Pfeffer eum amet quia 71.0
Dahlia Hilll repudiandae officiis qui 71.0
Bok Wolf doloribus hic corporis 71.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>