Gem source code Demo source code
Author: Bogdan Gusiev

User Grid (basic) Time Entry Grid (advanced) Document Grid (Mongoid)

Time Entries Grid


Developer Project Report hours
Reta Boyer dolor numquam cumque 40.0
Maximillian Ryan sint ut ea 73.0
Reta Boyer non et est 110.0
Rylee Fadel dolor numquam cumque 68.0
Fausto Larkin non et est 32.0
Tod Heller sint ut ea 39.0
Dell Champlin non et est 89.0
Austin Heathcote non et est 35.0
Joelle Jenkins sint ut ea 38.0
Ernie Considine non et est 49.0
Darius Bins non et est 98.0
Lora Kilback sint ut ea 48.0
Earline Hahn non et est 62.0
Carmel Huel non et est 49.0
Fausto Larkin dolor numquam cumque 46.0
Louisa Franecki sint ut ea 39.0
Jeffry Osinski sint ut ea 31.0
Diego Marvin dolor numquam cumque 68.0
Alayna Swaniawski dolor numquam cumque 63.0
Jalyn Mante non et est 57.0
Oleta Rau non et est 67.0
Josefa Spinka sint ut ea 54.0
Estevan Reilly non et est 50.0
Lemuel Cummings non et est 37.0
Moises Kuhlman non et est 52.0

Grid:

class TimeEntriesGrid

  include Datagrid

  #
  # 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[:time_entries_grid]) 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>