DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
German Murphy	doloribus hic corporis	Microsoft	41.0
Dahlia Hilll	repudiandae officiis qui	Google	41.0
Cherly Kovacek	vitae eum pariatur	Google	42.0
Evangelina Pfeffer	eum amet quia	Google	42.0
Evangelina Pfeffer	odio velit repudiandae	Apple	42.0
Kellie Cassin	perspiciatis totam perferendis	Apple	42.0
Jamie Stehr	suscipit consectetur beatae	Google	42.0
Gonzalo Blanda	doloribus hic corporis	Microsoft	42.0
Shannon Botsford	perspiciatis totam perferendis	Apple	42.0
Jon Lindgren	saepe hic temporibus	Microsoft	42.0
Elenora Brakus	suscipit consectetur beatae	Google	42.0
Almeta Adams	suscipit consectetur beatae	Google	42.0
Huong McKenzie	eum amet quia	Google	42.0
Blake Hoppe	eum amet quia	Google	42.0
Vernia Dietrich	perspiciatis totam perferendis	Apple	42.0
Eleonore Wisozk	odio velit repudiandae	Apple	42.0
Wen Daniel	animi aperiam tenetur	Google	42.0
Rossana Schneider	quibusdam sed sit	Apple	43.0
Sixta Bashirian	animi aperiam tenetur	Google	43.0
Raquel Runolfsson	quibusdam sed sit	Apple	43.0
Alex Legros	animi aperiam tenetur	Google	43.0
Grace Kris	animi aperiam tenetur	Google	43.0
Vernia Dietrich	quibusdam sed sit	Apple	43.0
Bridgett Reilly	doloribus hic corporis	Microsoft	43.0
Ophelia Hermiston	animi aperiam tenetur	Google	43.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