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

Time Entries Grid

Reset

Developer
↑ ↓
Project
↑ ↓
Report hours
↑ ↓
Nelson Leannon doloribus hic corporis 41.0
Mi Prosacco eum amet quia 41.0
Myriam Von vitae eum pariatur 41.0
Claudette Hagenes quibusdam sed sit 41.0
Penney Schowalter odio velit repudiandae 41.0
Imelda Heidenreich animi aperiam tenetur 41.0
Terisa Ruecker quibusdam sed sit 41.0
Tamika Cronin vitae eum pariatur 41.0
Reinaldo Heidenreich vitae eum pariatur 41.0
Tamika Cronin quibusdam sed sit 41.0
Grace Kris vitae eum pariatur 42.0
Rebecca Rempel eum amet quia 42.0
Marna Ritchie odio velit repudiandae 42.0
Juliana Hauck perspiciatis totam perferendis 42.0
Jamison Hagenes quibusdam sed sit 42.0
Elida Zulauf eum amet quia 42.0
Eleonore Wisozk vitae eum pariatur 42.0
Jeanne Witting eum amet quia 42.0
Arnita Smith animi aperiam tenetur 42.0
Treena Wolf repudiandae officiis qui 42.0
Clifton Hintz saepe hic temporibus 42.0
Grace Kris eum amet quia 42.0
Nelson Leannon animi aperiam tenetur 42.0
Myrtle O'Conner saepe hic temporibus 42.0
Jewell Swaniawski eum amet quia 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>