Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Lesia Hyatt saepe hic temporibus 69.0
Jon Lindgren odio velit repudiandae 69.0
Vernia Dietrich suscipit consectetur beatae 69.0
Evangelina Pfeffer saepe hic temporibus 69.0
Rossana Schneider repudiandae officiis qui 69.0
Crissy Brekke animi aperiam tenetur 69.0
Vernia Dietrich repudiandae officiis qui 69.0
Jeanne Witting suscipit consectetur beatae 70.0
Flavia Will odio velit repudiandae 70.0
Dania Crona repudiandae officiis qui 70.0
Mi Prosacco quibusdam sed sit 70.0
Tami Gibson doloribus hic corporis 70.0
Shannon Botsford repudiandae officiis qui 70.0
Britney Ruecker eum amet quia 70.0
Dahlia Hilll perspiciatis totam perferendis 70.0
Royce Spencer doloribus hic corporis 70.0
Tess Nikolaus suscipit consectetur beatae 70.0
Carlota Gottlieb vitae eum pariatur 70.0
Lillie Hamill eum amet quia 70.0
Blake Hoppe eum amet quia 70.0
Rossana Schneider suscipit consectetur beatae 70.0
Jewell Swaniawski suscipit consectetur beatae 70.0
Elli Dietrich animi aperiam tenetur 70.0
Terisa Ruecker eum amet quia 70.0
Beverlee Auer quibusdam sed sit 70.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>