Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Cherly Kovacek quibusdam sed sit 40.0
Cherly Kovacek repudiandae officiis qui 85.0
Cherly Kovacek saepe hic temporibus 62.0
Cherly Kovacek suscipit consectetur beatae 48.0
Cherly Kovacek vitae eum pariatur 60.0
Claudette Hagenes animi aperiam tenetur 94.0
Claudette Hagenes doloribus hic corporis 66.0
Claudette Hagenes eum amet quia 58.0
Claudette Hagenes odio velit repudiandae 121.0
Claudette Hagenes perspiciatis totam perferendis 73.0
Claudette Hagenes quibusdam sed sit 58.0
Claudette Hagenes repudiandae officiis qui 90.0
Claudette Hagenes saepe hic temporibus 57.0
Claudette Hagenes suscipit consectetur beatae 80.0
Claudette Hagenes vitae eum pariatur 69.0
Clifton Hintz animi aperiam tenetur 50.0
Clifton Hintz doloribus hic corporis 73.0
Clifton Hintz eum amet quia 70.0
Clifton Hintz odio velit repudiandae 74.0
Clifton Hintz perspiciatis totam perferendis 69.0
Clifton Hintz quibusdam sed sit 81.0
Clifton Hintz repudiandae officiis qui 83.0
Clifton Hintz saepe hic temporibus 63.0
Clifton Hintz suscipit consectetur beatae 64.0
Clifton Hintz 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>