Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Ashleigh Kris animi aperiam tenetur 72.0
Ashleigh Kris doloribus hic corporis 57.0
Ashleigh Kris eum amet quia 77.0
Ashleigh Kris odio velit repudiandae 56.0
Ashleigh Kris perspiciatis totam perferendis 36.0
Ashleigh Kris quibusdam sed sit 38.0
Ashleigh Kris repudiandae officiis qui 105.0
Ashleigh Kris saepe hic temporibus 71.0
Ashleigh Kris suscipit consectetur beatae 60.0
Ashleigh Kris vitae eum pariatur 63.0
Awilda Schumm animi aperiam tenetur 81.0
Awilda Schumm doloribus hic corporis 65.0
Awilda Schumm eum amet quia 63.0
Awilda Schumm odio velit repudiandae 54.0
Awilda Schumm perspiciatis totam perferendis 52.0
Awilda Schumm quibusdam sed sit 84.0
Awilda Schumm repudiandae officiis qui 70.0
Awilda Schumm saepe hic temporibus 55.0
Awilda Schumm suscipit consectetur beatae 69.0
Awilda Schumm vitae eum pariatur 59.0
Benita Thompson animi aperiam tenetur 57.0
Benita Thompson doloribus hic corporis 100.0
Benita Thompson eum amet quia 57.0
Benita Thompson odio velit repudiandae 78.0
Benita Thompson perspiciatis totam perferendis 54.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>