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

Developer Project Company Report hours
Adrienne Eichmann animi aperiam tenetur
Google
44.0
Adrienne Eichmann doloribus hic corporis
Microsoft
50.0
Adrienne Eichmann eum amet quia
Google
64.0
Adrienne Eichmann odio velit repudiandae
Apple
79.0
Adrienne Eichmann perspiciatis totam perferendis
Apple
75.0
Adrienne Eichmann quibusdam sed sit
Apple
63.0
Adrienne Eichmann repudiandae officiis qui
Google
63.0
Adrienne Eichmann saepe hic temporibus
Microsoft
71.0
Adrienne Eichmann suscipit consectetur beatae
Google
51.0
Adrienne Eichmann vitae eum pariatur
Google
98.0
Alex Legros animi aperiam tenetur
Google
67.0
Alex Legros doloribus hic corporis
Microsoft
66.0
Alex Legros eum amet quia
Google
42.0
Alex Legros odio velit repudiandae
Apple
80.0
Alex Legros perspiciatis totam perferendis
Apple
42.0
Alex Legros quibusdam sed sit
Apple
60.0
Alex Legros repudiandae officiis qui
Google
39.0
Alex Legros saepe hic temporibus
Microsoft
55.0
Alex Legros suscipit consectetur beatae
Google
88.0
Alex Legros vitae eum pariatur
Google
54.0
Alise Rolfson animi aperiam tenetur
Google
65.0
Alise Rolfson doloribus hic corporis
Microsoft
71.0
Alise Rolfson eum amet quia
Google
59.0
Alise Rolfson odio velit repudiandae
Apple
47.0
Alise Rolfson perspiciatis totam perferendis
Apple
63.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