Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced)

Time Entries Grid


Developer Project Report hours
Almeta Adams eum amet quia 46.0
Malvina Zulauf quibusdam sed sit 46.0
Jewell Kreiger quibusdam sed sit 46.0
Bong Witting doloribus hic corporis 46.0
Elsa Goodwin saepe hic temporibus 46.0
Blake Hoppe doloribus hic corporis 46.0
Felisa Jaskolski eum amet quia 46.0
Wiley Wuckert vitae eum pariatur 46.0
Ethyl Ankunding animi aperiam tenetur 46.0
Jarvis Ryan animi aperiam tenetur 45.0
Royce Spencer perspiciatis totam perferendis 45.0
Juliana Hauck vitae eum pariatur 45.0
Flavia Will perspiciatis totam perferendis 45.0
Li Considine repudiandae officiis qui 45.0
Ophelia Hermiston animi aperiam tenetur 45.0
Lesia Hyatt quibusdam sed sit 45.0
Malvina Zulauf vitae eum pariatur 45.0
Eleonore Wisozk perspiciatis totam perferendis 45.0
German Murphy repudiandae officiis qui 45.0
Pearlie McGlynn perspiciatis totam perferendis 45.0
Mi Prosacco quibusdam sed sit 45.0
Elli Dietrich vitae eum pariatur 44.0
Winfred Franecki repudiandae officiis qui 44.0
Wiley Wuckert repudiandae officiis qui 44.0
Palmira Fay repudiandae officiis qui 44.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>