Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Adrienne Eichmann animi aperiam tenetur 79.0
Adrienne Eichmann doloribus hic corporis 104.0
Adrienne Eichmann eum amet quia 80.0
Adrienne Eichmann odio velit repudiandae 90.0
Adrienne Eichmann perspiciatis totam perferendis 72.0
Adrienne Eichmann quibusdam sed sit 67.0
Adrienne Eichmann repudiandae officiis qui 55.0
Adrienne Eichmann saepe hic temporibus 81.0
Adrienne Eichmann suscipit consectetur beatae 53.0
Adrienne Eichmann vitae eum pariatur 85.0
Alex Legros animi aperiam tenetur 68.0
Alex Legros doloribus hic corporis 82.0
Alex Legros eum amet quia 88.0
Alex Legros odio velit repudiandae 59.0
Alex Legros perspiciatis totam perferendis 71.0
Alex Legros quibusdam sed sit 42.0
Alex Legros repudiandae officiis qui 89.0
Alex Legros saepe hic temporibus 88.0
Alex Legros suscipit consectetur beatae 39.0
Alex Legros vitae eum pariatur 53.0
Alise Rolfson animi aperiam tenetur 42.0
Alise Rolfson doloribus hic corporis 77.0
Alise Rolfson eum amet quia 52.0
Alise Rolfson odio velit repudiandae 53.0
Alise Rolfson perspiciatis totam perferendis 71.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>