Datagrid Demo
User Grid (basic) Time Sheets Grid (advanced)
Reset

Developer
↑ ↓
Project
↑ ↓
Report hours
↑ ↓
Awilda Schumm vitae eum pariatur 44.0
Myriam Von vitae eum pariatur 44.0
Huong McKenzie perspiciatis totam perferendis 44.0
Gonzalo Blanda repudiandae officiis qui 44.0
Dorthey Turner suscipit consectetur beatae 44.0
Tamika Cronin odio velit repudiandae 43.0
Kaye Greenfelder saepe hic temporibus 43.0
Jewell Kreiger suscipit consectetur beatae 43.0
Sixta Bashirian quibusdam sed sit 43.0
Clifton Hintz perspiciatis totam perferendis 43.0
Jamie Stehr repudiandae officiis qui 43.0
Benita Thompson repudiandae officiis qui 43.0
Rossana Schneider odio velit repudiandae 43.0
Penney Schowalter eum amet quia 43.0
Brigid McLaughlin perspiciatis totam perferendis 43.0
Beverlee Auer doloribus hic corporis 43.0
Imelda Heidenreich doloribus hic corporis 43.0
Jackson Kozey quibusdam sed sit 43.0
Verla Friesen repudiandae officiis qui 42.0
Li Considine vitae eum pariatur 42.0
Huong McKenzie suscipit consectetur beatae 42.0
Elsa Goodwin doloribus hic corporis 42.0
Carlota Gottlieb perspiciatis totam perferendis 42.0
Myriam Von perspiciatis totam perferendis 42.0
Ethyl Ankunding odio velit repudiandae 42.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 => :project_id_select,
    :multiple => true,
    :include_blank => false
  ) do |value|
    self.where(:time_entries => {:project_id => value})
  end


  filter(
    :year, :enum,
    :select => :year_select,
    :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 => :month_select,
    :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)")

  protected

  def year_select
    TimeEntry.all.any? ? (TimeEntry.minimum(:date).year..TimeEntry.maximum(:date).year) : []
  end
  def month_select
    Date::MONTHNAMES[1..12].enum_for(:each_with_index).collect {|name, index| [name, index + 1]}
  end

  def project_id_select
    Project.all.map {|p| [p.name, p.id]}
  end
end

Controller:

class TimeEntriesController < ApplicationController

  def index
    @time_entries_grid = TimeEntriesGrid.new(params[:g]) do |scope|
      scope.page(params[:page] )
    end
  end
end

View:

.grid-index-grid
  %div{class: 'overflow-x-auto p-4'}
    = datagrid_form_for @time_entries_grid, url: time_entries_path
    %br/
    = datagrid_table(@time_entries_grid)
    = paginate @time_entries_grid.assets, window: 2
  %div
    = render :partial => "shared/source", :object => @time_entries_grid