Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Isidro McCullough animi aperiam tenetur 48.0
Isidro McCullough doloribus hic corporis 78.0
Isidro McCullough eum amet quia 75.0
Isidro McCullough odio velit repudiandae 59.0
Isidro McCullough perspiciatis totam perferendis 66.0
Isidro McCullough quibusdam sed sit 79.0
Isidro McCullough repudiandae officiis qui 85.0
Isidro McCullough saepe hic temporibus 89.0
Isidro McCullough suscipit consectetur beatae 77.0
Isidro McCullough vitae eum pariatur 56.0
Jackson Kozey animi aperiam tenetur 84.0
Jackson Kozey doloribus hic corporis 69.0
Jackson Kozey eum amet quia 71.0
Jackson Kozey odio velit repudiandae 54.0
Jackson Kozey perspiciatis totam perferendis 56.0
Jackson Kozey quibusdam sed sit 53.0
Jackson Kozey repudiandae officiis qui 78.0
Jackson Kozey saepe hic temporibus 73.0
Jackson Kozey suscipit consectetur beatae 71.0
Jackson Kozey vitae eum pariatur 61.0
Jamie Stehr animi aperiam tenetur 84.0
Jamie Stehr doloribus hic corporis 51.0
Jamie Stehr eum amet quia 86.0
Jamie Stehr odio velit repudiandae 81.0
Jamie Stehr perspiciatis totam perferendis 34.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>