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

Developer Project Company Report hours
Jewell Swaniawski quibusdam sed sit
Apple
67.0
Jewell Swaniawski repudiandae officiis qui
Google
89.0
Jewell Swaniawski saepe hic temporibus
Microsoft
40.0
Jewell Swaniawski suscipit consectetur beatae
Google
52.0
Jewell Swaniawski vitae eum pariatur
Google
35.0
Joelle Hodkiewicz animi aperiam tenetur
Google
75.0
Joelle Hodkiewicz doloribus hic corporis
Microsoft
88.0
Joelle Hodkiewicz eum amet quia
Google
51.0
Joelle Hodkiewicz odio velit repudiandae
Apple
52.0
Joelle Hodkiewicz perspiciatis totam perferendis
Apple
68.0
Joelle Hodkiewicz quibusdam sed sit
Apple
70.0
Joelle Hodkiewicz repudiandae officiis qui
Google
84.0
Joelle Hodkiewicz saepe hic temporibus
Microsoft
23.0
Joelle Hodkiewicz suscipit consectetur beatae
Google
98.0
Joelle Hodkiewicz vitae eum pariatur
Google
67.0
Johnny Spinka animi aperiam tenetur
Google
58.0
Johnny Spinka doloribus hic corporis
Microsoft
71.0
Johnny Spinka eum amet quia
Google
48.0
Johnny Spinka odio velit repudiandae
Apple
75.0
Johnny Spinka perspiciatis totam perferendis
Apple
42.0
Johnny Spinka quibusdam sed sit
Apple
72.0
Johnny Spinka repudiandae officiis qui
Google
61.0
Johnny Spinka saepe hic temporibus
Microsoft
30.0
Johnny Spinka suscipit consectetur beatae
Google
70.0
Johnny Spinka vitae eum pariatur
Google
43.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