DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Desmond Murray	doloribus hic corporis	Microsoft	51.0
Dona Gutkowski	doloribus hic corporis	Microsoft	48.0
Dorthey Turner	doloribus hic corporis	Microsoft	77.0
Elenora Brakus	doloribus hic corporis	Microsoft	91.0
Eleonore Wisozk	doloribus hic corporis	Microsoft	78.0
Elida Zulauf	doloribus hic corporis	Microsoft	59.0
Elisa Wintheiser	doloribus hic corporis	Microsoft	94.0
Elise Waelchi	doloribus hic corporis	Microsoft	61.0
Elli Dietrich	doloribus hic corporis	Microsoft	50.0
Elsa Goodwin	doloribus hic corporis	Microsoft	87.0
Ethyl Ankunding	doloribus hic corporis	Microsoft	75.0
Evangelina Pfeffer	doloribus hic corporis	Microsoft	62.0
Felisa Jaskolski	doloribus hic corporis	Microsoft	67.0
Flavia Will	doloribus hic corporis	Microsoft	71.0
German Murphy	doloribus hic corporis	Microsoft	78.0
Gonzalo Blanda	doloribus hic corporis	Microsoft	70.0
Grace Kris	doloribus hic corporis	Microsoft	71.0
Gwendolyn Satterfield	doloribus hic corporis	Microsoft	66.0
Huong McKenzie	doloribus hic corporis	Microsoft	43.0
Imelda Heidenreich	doloribus hic corporis	Microsoft	38.0
Isidro McCullough	doloribus hic corporis	Microsoft	54.0
Jackson Kozey	doloribus hic corporis	Microsoft	94.0
Jamie Stehr	doloribus hic corporis	Microsoft	73.0
Jamison Hagenes	doloribus hic corporis	Microsoft	65.0
Jarvis Ryan	doloribus hic corporis	Microsoft	39.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