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

Developer Project Company Report hours
Jewell Swaniawski quibusdam sed sit
Apple
59.0
Jewell Swaniawski repudiandae officiis qui
Google
66.0
Jewell Swaniawski saepe hic temporibus
Microsoft
59.0
Jewell Swaniawski suscipit consectetur beatae
Google
18.0
Jewell Swaniawski vitae eum pariatur
Google
41.0
Joelle Hodkiewicz animi aperiam tenetur
Google
35.0
Joelle Hodkiewicz doloribus hic corporis
Microsoft
46.0
Joelle Hodkiewicz eum amet quia
Google
28.0
Joelle Hodkiewicz odio velit repudiandae
Apple
85.0
Joelle Hodkiewicz perspiciatis totam perferendis
Apple
62.0
Joelle Hodkiewicz quibusdam sed sit
Apple
67.0
Joelle Hodkiewicz repudiandae officiis qui
Google
57.0
Joelle Hodkiewicz saepe hic temporibus
Microsoft
100.0
Joelle Hodkiewicz suscipit consectetur beatae
Google
63.0
Joelle Hodkiewicz vitae eum pariatur
Google
42.0
Johnny Spinka animi aperiam tenetur
Google
41.0
Johnny Spinka doloribus hic corporis
Microsoft
86.0
Johnny Spinka eum amet quia
Google
59.0
Johnny Spinka odio velit repudiandae
Apple
79.0
Johnny Spinka perspiciatis totam perferendis
Apple
60.0
Johnny Spinka quibusdam sed sit
Apple
61.0
Johnny Spinka repudiandae officiis qui
Google
88.0
Johnny Spinka saepe hic temporibus
Microsoft
74.0
Johnny Spinka suscipit consectetur beatae
Google
79.0
Johnny Spinka vitae eum pariatur
Google
65.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