Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Crissy Brekke animi aperiam tenetur 44.0
Crissy Brekke doloribus hic corporis 30.0
Crissy Brekke eum amet quia 58.0
Crissy Brekke odio velit repudiandae 42.0
Crissy Brekke perspiciatis totam perferendis 84.0
Crissy Brekke quibusdam sed sit 78.0
Crissy Brekke repudiandae officiis qui 60.0
Crissy Brekke saepe hic temporibus 73.0
Crissy Brekke suscipit consectetur beatae 53.0
Crissy Brekke vitae eum pariatur 22.0
Cristopher Dooley animi aperiam tenetur 52.0
Cristopher Dooley doloribus hic corporis 51.0
Cristopher Dooley eum amet quia 101.0
Cristopher Dooley odio velit repudiandae 29.0
Cristopher Dooley perspiciatis totam perferendis 61.0
Cristopher Dooley quibusdam sed sit 80.0
Cristopher Dooley repudiandae officiis qui 147.0
Cristopher Dooley saepe hic temporibus 79.0
Cristopher Dooley suscipit consectetur beatae 85.0
Cristopher Dooley vitae eum pariatur 69.0
Dahlia Hilll animi aperiam tenetur 58.0
Dahlia Hilll doloribus hic corporis 61.0
Dahlia Hilll eum amet quia 60.0
Dahlia Hilll odio velit repudiandae 52.0
Dahlia Hilll perspiciatis totam perferendis 30.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>