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

Developer Project Company Report hours
Jon Lindgren animi aperiam tenetur
Google
30.0
Jon Lindgren doloribus hic corporis
Microsoft
70.0
Jon Lindgren eum amet quia
Google
42.0
Jon Lindgren odio velit repudiandae
Apple
61.0
Jon Lindgren perspiciatis totam perferendis
Apple
66.0
Jon Lindgren quibusdam sed sit
Apple
49.0
Jon Lindgren repudiandae officiis qui
Google
70.0
Jon Lindgren saepe hic temporibus
Microsoft
46.0
Jon Lindgren suscipit consectetur beatae
Google
49.0
Jon Lindgren vitae eum pariatur
Google
97.0
Juliana Hauck animi aperiam tenetur
Google
50.0
Juliana Hauck doloribus hic corporis
Microsoft
49.0
Juliana Hauck eum amet quia
Google
64.0
Juliana Hauck odio velit repudiandae
Apple
37.0
Juliana Hauck perspiciatis totam perferendis
Apple
55.0
Juliana Hauck quibusdam sed sit
Apple
70.0
Juliana Hauck repudiandae officiis qui
Google
79.0
Juliana Hauck saepe hic temporibus
Microsoft
83.0
Juliana Hauck suscipit consectetur beatae
Google
61.0
Juliana Hauck vitae eum pariatur
Google
80.0
Kaye Greenfelder animi aperiam tenetur
Google
69.0
Kaye Greenfelder doloribus hic corporis
Microsoft
60.0
Kaye Greenfelder eum amet quia
Google
81.0
Kaye Greenfelder odio velit repudiandae
Apple
19.0
Kaye Greenfelder perspiciatis totam perferendis
Apple
81.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