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

Developer Project Company Report hours
Bok Wolf animi aperiam tenetur
Google
61.0
Bok Wolf doloribus hic corporis
Microsoft
75.0
Bok Wolf eum amet quia
Google
86.0
Bok Wolf odio velit repudiandae
Apple
39.0
Bok Wolf perspiciatis totam perferendis
Apple
62.0
Bok Wolf quibusdam sed sit
Apple
42.0
Bok Wolf repudiandae officiis qui
Google
64.0
Bok Wolf saepe hic temporibus
Microsoft
52.0
Bok Wolf suscipit consectetur beatae
Google
54.0
Bok Wolf vitae eum pariatur
Google
62.0
Bong Witting animi aperiam tenetur
Google
43.0
Bong Witting doloribus hic corporis
Microsoft
92.0
Bong Witting eum amet quia
Google
62.0
Bong Witting odio velit repudiandae
Apple
96.0
Bong Witting perspiciatis totam perferendis
Apple
101.0
Bong Witting quibusdam sed sit
Apple
102.0
Bong Witting repudiandae officiis qui
Google
52.0
Bong Witting saepe hic temporibus
Microsoft
58.0
Bong Witting suscipit consectetur beatae
Google
79.0
Bong Witting vitae eum pariatur
Google
63.0
Bridgett Reilly animi aperiam tenetur
Google
58.0
Bridgett Reilly doloribus hic corporis
Microsoft
102.0
Bridgett Reilly eum amet quia
Google
74.0
Bridgett Reilly odio velit repudiandae
Apple
48.0
Bridgett Reilly perspiciatis totam perferendis
Apple
37.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