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

Developer Project Company Report hours
Ashleigh Kris animi aperiam tenetur
Google
51.0
Ashleigh Kris doloribus hic corporis
Microsoft
86.0
Ashleigh Kris eum amet quia
Google
34.0
Ashleigh Kris odio velit repudiandae
Apple
44.0
Ashleigh Kris perspiciatis totam perferendis
Apple
75.0
Ashleigh Kris quibusdam sed sit
Apple
53.0
Ashleigh Kris repudiandae officiis qui
Google
57.0
Ashleigh Kris saepe hic temporibus
Microsoft
63.0
Ashleigh Kris suscipit consectetur beatae
Google
74.0
Ashleigh Kris vitae eum pariatur
Google
78.0
Awilda Schumm animi aperiam tenetur
Google
51.0
Awilda Schumm doloribus hic corporis
Microsoft
41.0
Awilda Schumm eum amet quia
Google
80.0
Awilda Schumm odio velit repudiandae
Apple
97.0
Awilda Schumm perspiciatis totam perferendis
Apple
39.0
Awilda Schumm quibusdam sed sit
Apple
56.0
Awilda Schumm repudiandae officiis qui
Google
79.0
Awilda Schumm saepe hic temporibus
Microsoft
66.0
Awilda Schumm suscipit consectetur beatae
Google
34.0
Awilda Schumm vitae eum pariatur
Google
77.0
Benita Thompson animi aperiam tenetur
Google
43.0
Benita Thompson doloribus hic corporis
Microsoft
68.0
Benita Thompson eum amet quia
Google
20.0
Benita Thompson odio velit repudiandae
Apple
76.0
Benita Thompson perspiciatis totam perferendis
Apple
56.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