DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Wen Daniel	quibusdam sed sit	Apple	58.0
Imelda Heidenreich	animi aperiam tenetur	Google	58.0
Beverlee Auer	vitae eum pariatur	Google	58.0
Tess Nikolaus	eum amet quia	Google	58.0
Elisa Wintheiser	odio velit repudiandae	Apple	58.0
Claudette Hagenes	repudiandae officiis qui	Google	58.0
Dania Crona	repudiandae officiis qui	Google	58.0
Flavia Will	odio velit repudiandae	Apple	58.0
Gwendolyn Satterfield	perspiciatis totam perferendis	Apple	58.0
Dahlia Hilll	vitae eum pariatur	Google	58.0
Awilda Schumm	odio velit repudiandae	Apple	59.0
Shane Glover	doloribus hic corporis	Microsoft	59.0
Isidro McCullough	quibusdam sed sit	Apple	59.0
Claudette Hagenes	eum amet quia	Google	59.0
Malvina Zulauf	repudiandae officiis qui	Google	59.0
Reinaldo Heidenreich	odio velit repudiandae	Apple	59.0
Dania Crona	odio velit repudiandae	Apple	59.0
Bong Witting	suscipit consectetur beatae	Google	59.0
Jackson Kozey	eum amet quia	Google	59.0
Rossana Schneider	doloribus hic corporis	Microsoft	59.0
Jamison Hagenes	saepe hic temporibus	Microsoft	59.0
Elida Zulauf	vitae eum pariatur	Google	59.0
Adrienne Eichmann	saepe hic temporibus	Microsoft	59.0
Grace Kris	saepe hic temporibus	Microsoft	59.0
Brigid McLaughlin	perspiciatis totam perferendis	Apple	59.0

Grid:

class TimeEntriesGrid < ApplicationGrid

  #
  # 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_with model: @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