Users (Basic) Time Sheets (Advanced) Issues (API)

Developer Project Company Report hours
Gonzalo Blanda animi aperiam tenetur
Google
101.0
Gonzalo Blanda doloribus hic corporis
Microsoft
40.0
Gonzalo Blanda eum amet quia
Google
73.0
Gonzalo Blanda odio velit repudiandae
Apple
80.0
Gonzalo Blanda perspiciatis totam perferendis
Apple
32.0
Gonzalo Blanda quibusdam sed sit
Apple
73.0
Gonzalo Blanda repudiandae officiis qui
Google
46.0
Gonzalo Blanda saepe hic temporibus
Microsoft
62.0
Gonzalo Blanda suscipit consectetur beatae
Google
62.0
Gonzalo Blanda vitae eum pariatur
Google
56.0
Grace Kris animi aperiam tenetur
Google
57.0
Grace Kris doloribus hic corporis
Microsoft
68.0
Grace Kris eum amet quia
Google
61.0
Grace Kris odio velit repudiandae
Apple
41.0
Grace Kris perspiciatis totam perferendis
Apple
63.0
Grace Kris quibusdam sed sit
Apple
60.0
Grace Kris repudiandae officiis qui
Google
81.0
Grace Kris saepe hic temporibus
Microsoft
33.0
Grace Kris suscipit consectetur beatae
Google
59.0
Grace Kris vitae eum pariatur
Google
53.0
Gwendolyn Satterfield animi aperiam tenetur
Google
51.0
Gwendolyn Satterfield doloribus hic corporis
Microsoft
83.0
Gwendolyn Satterfield eum amet quia
Google
40.0
Gwendolyn Satterfield odio velit repudiandae
Apple
76.0
Gwendolyn Satterfield 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