Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Bridgett Reilly quibusdam sed sit 67.0
Bridgett Reilly repudiandae officiis qui 73.0
Bridgett Reilly saepe hic temporibus 52.0
Bridgett Reilly suscipit consectetur beatae 52.0
Bridgett Reilly vitae eum pariatur 79.0
Brigid McLaughlin animi aperiam tenetur 34.0
Brigid McLaughlin doloribus hic corporis 76.0
Brigid McLaughlin eum amet quia 82.0
Brigid McLaughlin odio velit repudiandae 63.0
Brigid McLaughlin perspiciatis totam perferendis 53.0
Brigid McLaughlin quibusdam sed sit 52.0
Brigid McLaughlin repudiandae officiis qui 50.0
Brigid McLaughlin saepe hic temporibus 67.0
Brigid McLaughlin suscipit consectetur beatae 39.0
Brigid McLaughlin vitae eum pariatur 79.0
Britney Ruecker animi aperiam tenetur 49.0
Britney Ruecker doloribus hic corporis 65.0
Britney Ruecker eum amet quia 85.0
Britney Ruecker odio velit repudiandae 49.0
Britney Ruecker perspiciatis totam perferendis 112.0
Britney Ruecker quibusdam sed sit 63.0
Britney Ruecker repudiandae officiis qui 47.0
Britney Ruecker saepe hic temporibus 84.0
Britney Ruecker suscipit consectetur beatae 64.0
Britney Ruecker vitae eum pariatur 40.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>