Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Benita Thompson quibusdam sed sit 48.0
Benita Thompson repudiandae officiis qui 56.0
Benita Thompson saepe hic temporibus 58.0
Benita Thompson suscipit consectetur beatae 40.0
Benita Thompson vitae eum pariatur 72.0
Beverlee Auer animi aperiam tenetur 59.0
Beverlee Auer doloribus hic corporis 36.0
Beverlee Auer eum amet quia 22.0
Beverlee Auer odio velit repudiandae 50.0
Beverlee Auer perspiciatis totam perferendis 60.0
Beverlee Auer quibusdam sed sit 53.0
Beverlee Auer repudiandae officiis qui 62.0
Beverlee Auer saepe hic temporibus 78.0
Beverlee Auer suscipit consectetur beatae 40.0
Beverlee Auer vitae eum pariatur 63.0
Blake Hoppe animi aperiam tenetur 54.0
Blake Hoppe doloribus hic corporis 46.0
Blake Hoppe eum amet quia 69.0
Blake Hoppe odio velit repudiandae 63.0
Blake Hoppe perspiciatis totam perferendis 37.0
Blake Hoppe quibusdam sed sit 66.0
Blake Hoppe repudiandae officiis qui 81.0
Blake Hoppe saepe hic temporibus 88.0
Blake Hoppe suscipit consectetur beatae 90.0
Blake Hoppe vitae eum pariatur 60.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>