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

Developer Project Company Report hours
Gonzalo Blanda animi aperiam tenetur
Google
46.0
Gonzalo Blanda doloribus hic corporis
Microsoft
70.0
Gonzalo Blanda eum amet quia
Google
66.0
Gonzalo Blanda odio velit repudiandae
Apple
46.0
Gonzalo Blanda perspiciatis totam perferendis
Apple
49.0
Gonzalo Blanda quibusdam sed sit
Apple
82.0
Gonzalo Blanda repudiandae officiis qui
Google
89.0
Gonzalo Blanda saepe hic temporibus
Microsoft
72.0
Gonzalo Blanda suscipit consectetur beatae
Google
52.0
Gonzalo Blanda vitae eum pariatur
Google
81.0
Grace Kris animi aperiam tenetur
Google
34.0
Grace Kris doloribus hic corporis
Microsoft
74.0
Grace Kris eum amet quia
Google
60.0
Grace Kris odio velit repudiandae
Apple
78.0
Grace Kris perspiciatis totam perferendis
Apple
37.0
Grace Kris quibusdam sed sit
Apple
52.0
Grace Kris repudiandae officiis qui
Google
33.0
Grace Kris saepe hic temporibus
Microsoft
49.0
Grace Kris suscipit consectetur beatae
Google
40.0
Grace Kris vitae eum pariatur
Google
74.0
Gwendolyn Satterfield animi aperiam tenetur
Google
40.0
Gwendolyn Satterfield doloribus hic corporis
Microsoft
49.0
Gwendolyn Satterfield eum amet quia
Google
47.0
Gwendolyn Satterfield odio velit repudiandae
Apple
65.0
Gwendolyn Satterfield perspiciatis totam perferendis
Apple
53.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