Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Alise Rolfson quibusdam sed sit 36.0
Alise Rolfson repudiandae officiis qui 56.0
Alise Rolfson saepe hic temporibus 64.0
Alise Rolfson suscipit consectetur beatae 73.0
Alise Rolfson vitae eum pariatur 48.0
Almeta Adams animi aperiam tenetur 22.0
Almeta Adams doloribus hic corporis 107.0
Almeta Adams eum amet quia 46.0
Almeta Adams odio velit repudiandae 43.0
Almeta Adams perspiciatis totam perferendis 34.0
Almeta Adams quibusdam sed sit 36.0
Almeta Adams repudiandae officiis qui 95.0
Almeta Adams saepe hic temporibus 87.0
Almeta Adams suscipit consectetur beatae 65.0
Almeta Adams vitae eum pariatur 37.0
Arnita Smith animi aperiam tenetur 98.0
Arnita Smith doloribus hic corporis 52.0
Arnita Smith eum amet quia 48.0
Arnita Smith odio velit repudiandae 65.0
Arnita Smith perspiciatis totam perferendis 71.0
Arnita Smith quibusdam sed sit 33.0
Arnita Smith repudiandae officiis qui 32.0
Arnita Smith saepe hic temporibus 40.0
Arnita Smith suscipit consectetur beatae 104.0
Arnita Smith vitae eum pariatur 78.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>