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

Time Entries Grid

Reset

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