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

Developer Project Company Report hours
Desmond Murray animi aperiam tenetur
Google
71.0
Desmond Murray doloribus hic corporis
Microsoft
24.0
Desmond Murray eum amet quia
Google
57.0
Desmond Murray odio velit repudiandae
Apple
48.0
Desmond Murray perspiciatis totam perferendis
Apple
87.0
Desmond Murray quibusdam sed sit
Apple
92.0
Desmond Murray repudiandae officiis qui
Google
54.0
Desmond Murray saepe hic temporibus
Microsoft
80.0
Desmond Murray suscipit consectetur beatae
Google
70.0
Desmond Murray vitae eum pariatur
Google
57.0
Dona Gutkowski animi aperiam tenetur
Google
20.0
Dona Gutkowski doloribus hic corporis
Microsoft
66.0
Dona Gutkowski eum amet quia
Google
62.0
Dona Gutkowski odio velit repudiandae
Apple
41.0
Dona Gutkowski perspiciatis totam perferendis
Apple
67.0
Dona Gutkowski quibusdam sed sit
Apple
56.0
Dona Gutkowski repudiandae officiis qui
Google
49.0
Dona Gutkowski saepe hic temporibus
Microsoft
75.0
Dona Gutkowski suscipit consectetur beatae
Google
54.0
Dona Gutkowski vitae eum pariatur
Google
45.0
Dorthey Turner animi aperiam tenetur
Google
45.0
Dorthey Turner doloribus hic corporis
Microsoft
81.0
Dorthey Turner eum amet quia
Google
67.0
Dorthey Turner odio velit repudiandae
Apple
101.0
Dorthey Turner perspiciatis totam perferendis
Apple
92.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