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

Developer Project Company Report hours
Penney Schowalter animi aperiam tenetur
Google
63.0
Penney Schowalter doloribus hic corporis
Microsoft
79.0
Penney Schowalter eum amet quia
Google
51.0
Penney Schowalter odio velit repudiandae
Apple
59.0
Penney Schowalter perspiciatis totam perferendis
Apple
66.0
Penney Schowalter quibusdam sed sit
Apple
43.0
Penney Schowalter repudiandae officiis qui
Google
57.0
Penney Schowalter saepe hic temporibus
Microsoft
45.0
Penney Schowalter suscipit consectetur beatae
Google
84.0
Penney Schowalter vitae eum pariatur
Google
64.0
Raquel Runolfsson animi aperiam tenetur
Google
103.0
Raquel Runolfsson doloribus hic corporis
Microsoft
74.0
Raquel Runolfsson eum amet quia
Google
70.0
Raquel Runolfsson odio velit repudiandae
Apple
60.0
Raquel Runolfsson perspiciatis totam perferendis
Apple
58.0
Raquel Runolfsson quibusdam sed sit
Apple
45.0
Raquel Runolfsson repudiandae officiis qui
Google
42.0
Raquel Runolfsson saepe hic temporibus
Microsoft
53.0
Raquel Runolfsson suscipit consectetur beatae
Google
74.0
Raquel Runolfsson vitae eum pariatur
Google
38.0
Rebecca Rempel animi aperiam tenetur
Google
84.0
Rebecca Rempel doloribus hic corporis
Microsoft
34.0
Rebecca Rempel eum amet quia
Google
43.0
Rebecca Rempel odio velit repudiandae
Apple
59.0
Rebecca Rempel perspiciatis totam perferendis
Apple
44.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