Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Bok Wolf animi aperiam tenetur 53.0
Bok Wolf doloribus hic corporis 59.0
Bok Wolf eum amet quia 83.0
Bok Wolf odio velit repudiandae 100.0
Bok Wolf perspiciatis totam perferendis 44.0
Bok Wolf quibusdam sed sit 71.0
Bok Wolf repudiandae officiis qui 103.0
Bok Wolf saepe hic temporibus 61.0
Bok Wolf suscipit consectetur beatae 79.0
Bok Wolf vitae eum pariatur 51.0
Bong Witting animi aperiam tenetur 112.0
Bong Witting doloribus hic corporis 46.0
Bong Witting eum amet quia 74.0
Bong Witting odio velit repudiandae 85.0
Bong Witting perspiciatis totam perferendis 49.0
Bong Witting quibusdam sed sit 42.0
Bong Witting repudiandae officiis qui 52.0
Bong Witting saepe hic temporibus 78.0
Bong Witting suscipit consectetur beatae 71.0
Bong Witting vitae eum pariatur 51.0
Bridgett Reilly animi aperiam tenetur 89.0
Bridgett Reilly doloribus hic corporis 48.0
Bridgett Reilly eum amet quia 54.0
Bridgett Reilly odio velit repudiandae 81.0
Bridgett Reilly perspiciatis totam perferendis 33.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>