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

Time Entries Grid

Reset

Developer
↑ ↓
Project
↑ ↓
Report hours
↑ ↓
Alise Rolfson eum amet quia 43.0
Bridgett Reilly doloribus hic corporis 43.0
Verla Friesen saepe hic temporibus 43.0
Sixta Bashirian animi aperiam tenetur 43.0
Ophelia Hermiston animi aperiam tenetur 43.0
Grace Kris animi aperiam tenetur 43.0
Alex Legros animi aperiam tenetur 43.0
Raquel Runolfsson quibusdam sed sit 43.0
Evangelina Pfeffer eum amet quia 42.0
Blake Hoppe eum amet quia 42.0
Wen Daniel animi aperiam tenetur 42.0
Cherly Kovacek vitae eum pariatur 42.0
Eleonore Wisozk odio velit repudiandae 42.0
Jamie Stehr suscipit consectetur beatae 42.0
Jon Lindgren saepe hic temporibus 42.0
Huong McKenzie eum amet quia 42.0
Kellie Cassin perspiciatis totam perferendis 42.0
Elenora Brakus suscipit consectetur beatae 42.0
Almeta Adams suscipit consectetur beatae 42.0
Vernia Dietrich perspiciatis totam perferendis 42.0
Gonzalo Blanda doloribus hic corporis 42.0
Shannon Botsford perspiciatis totam perferendis 42.0
Evangelina Pfeffer odio velit repudiandae 42.0
Crissy Brekke odio velit repudiandae 41.0
Mi Prosacco animi aperiam tenetur 41.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>