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

Developer Project Company Report hours
Sixta Bashirian animi aperiam tenetur
Google
55.0
Sixta Bashirian doloribus hic corporis
Microsoft
47.0
Sixta Bashirian eum amet quia
Google
31.0
Sixta Bashirian odio velit repudiandae
Apple
81.0
Sixta Bashirian perspiciatis totam perferendis
Apple
59.0
Sixta Bashirian quibusdam sed sit
Apple
115.0
Sixta Bashirian repudiandae officiis qui
Google
88.0
Sixta Bashirian saepe hic temporibus
Microsoft
45.0
Sixta Bashirian suscipit consectetur beatae
Google
56.0
Sixta Bashirian vitae eum pariatur
Google
64.0
Sylvester Hane animi aperiam tenetur
Google
78.0
Sylvester Hane doloribus hic corporis
Microsoft
77.0
Sylvester Hane eum amet quia
Google
21.0
Sylvester Hane odio velit repudiandae
Apple
54.0
Sylvester Hane perspiciatis totam perferendis
Apple
35.0
Sylvester Hane quibusdam sed sit
Apple
65.0
Sylvester Hane repudiandae officiis qui
Google
49.0
Sylvester Hane saepe hic temporibus
Microsoft
38.0
Sylvester Hane suscipit consectetur beatae
Google
69.0
Sylvester Hane vitae eum pariatur
Google
62.0
Tamera Bogan animi aperiam tenetur
Google
137.0
Tamera Bogan doloribus hic corporis
Microsoft
51.0
Tamera Bogan eum amet quia
Google
57.0
Tamera Bogan odio velit repudiandae
Apple
44.0
Tamera Bogan perspiciatis totam perferendis
Apple
50.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