DatagridDemo

Developer ↑ ↓	Project ↑ ↓	Company ↑ ↓	Report hours ↑ ↓
Huong McKenzie	suscipit consectetur beatae	Google	42.0
Verla Friesen	repudiandae officiis qui	Google	42.0
Ethyl Ankunding	odio velit repudiandae	Apple	42.0
Brigid McLaughlin	saepe hic temporibus	Microsoft	42.0
Li Considine	vitae eum pariatur	Google	42.0
Carlota Gottlieb	perspiciatis totam perferendis	Apple	42.0
Myriam Von	perspiciatis totam perferendis	Apple	42.0
Benita Thompson	repudiandae officiis qui	Google	43.0
Jackson Kozey	quibusdam sed sit	Apple	43.0
Imelda Heidenreich	doloribus hic corporis	Microsoft	43.0
Tamika Cronin	odio velit repudiandae	Apple	43.0
Jewell Kreiger	suscipit consectetur beatae	Google	43.0
Beverlee Auer	doloribus hic corporis	Microsoft	43.0
Sixta Bashirian	quibusdam sed sit	Apple	43.0
Rossana Schneider	odio velit repudiandae	Apple	43.0
Kaye Greenfelder	saepe hic temporibus	Microsoft	43.0
Jamie Stehr	repudiandae officiis qui	Google	43.0
Brigid McLaughlin	perspiciatis totam perferendis	Apple	43.0
Penney Schowalter	eum amet quia	Google	43.0
Clifton Hintz	perspiciatis totam perferendis	Apple	43.0
Jamison Hagenes	eum amet quia	Google	44.0
Huong McKenzie	perspiciatis totam perferendis	Apple	44.0
Reinaldo Heidenreich	vitae eum pariatur	Google	44.0
Shane Glover	doloribus hic corporis	Microsoft	44.0
Benita Thompson	animi aperiam tenetur	Google	44.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