DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Bok Wolf	saepe hic temporibus	Microsoft	92.0
Arnita Smith	animi aperiam tenetur	Google	92.0
Milagros Lemke	saepe hic temporibus	Microsoft	92.0
Blake Hoppe	saepe hic temporibus	Microsoft	92.0
Arnita Smith	eum amet quia	Google	92.0
Jon Lindgren	eum amet quia	Google	91.0
Elida Zulauf	suscipit consectetur beatae	Google	91.0
Jamison Hagenes	perspiciatis totam perferendis	Apple	91.0
Flavia Will	saepe hic temporibus	Microsoft	91.0
Palmira Fay	perspiciatis totam perferendis	Apple	91.0
Royce Spencer	saepe hic temporibus	Microsoft	91.0
Elenora Brakus	doloribus hic corporis	Microsoft	91.0
Felisa Jaskolski	animi aperiam tenetur	Google	90.0
Brigid McLaughlin	animi aperiam tenetur	Google	90.0
Jeanne Witting	eum amet quia	Google	90.0
Cherly Kovacek	vitae eum pariatur	Google	90.0
Elise Waelchi	animi aperiam tenetur	Google	90.0
Britney Ruecker	eum amet quia	Google	90.0
Carlota Gottlieb	odio velit repudiandae	Apple	90.0
Bok Wolf	eum amet quia	Google	89.0
Brigid McLaughlin	saepe hic temporibus	Microsoft	89.0
Arnita Smith	doloribus hic corporis	Microsoft	89.0
Elise Waelchi	quibusdam sed sit	Apple	89.0
Thaddeus Stanton	animi aperiam tenetur	Google	89.0
Shara Labadie	quibusdam sed sit	Apple	89.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