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

Developer Project Company Report hours
Bridgett Reilly quibusdam sed sit
Apple
125.0
Bridgett Reilly repudiandae officiis qui
Google
47.0
Bridgett Reilly saepe hic temporibus
Microsoft
50.0
Bridgett Reilly suscipit consectetur beatae
Google
45.0
Bridgett Reilly vitae eum pariatur
Google
52.0
Brigid McLaughlin animi aperiam tenetur
Google
59.0
Brigid McLaughlin doloribus hic corporis
Microsoft
54.0
Brigid McLaughlin eum amet quia
Google
61.0
Brigid McLaughlin odio velit repudiandae
Apple
44.0
Brigid McLaughlin perspiciatis totam perferendis
Apple
72.0
Brigid McLaughlin quibusdam sed sit
Apple
41.0
Brigid McLaughlin repudiandae officiis qui
Google
67.0
Brigid McLaughlin saepe hic temporibus
Microsoft
45.0
Brigid McLaughlin suscipit consectetur beatae
Google
53.0
Brigid McLaughlin vitae eum pariatur
Google
81.0
Britney Ruecker animi aperiam tenetur
Google
71.0
Britney Ruecker doloribus hic corporis
Microsoft
45.0
Britney Ruecker eum amet quia
Google
102.0
Britney Ruecker odio velit repudiandae
Apple
57.0
Britney Ruecker perspiciatis totam perferendis
Apple
36.0
Britney Ruecker quibusdam sed sit
Apple
76.0
Britney Ruecker repudiandae officiis qui
Google
76.0
Britney Ruecker saepe hic temporibus
Microsoft
79.0
Britney Ruecker suscipit consectetur beatae
Google
61.0
Britney Ruecker vitae eum pariatur
Google
68.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