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

Developer Project Company Report hours
Jon Lindgren animi aperiam tenetur
Google
68.0
Jon Lindgren doloribus hic corporis
Microsoft
41.0
Jon Lindgren eum amet quia
Google
32.0
Jon Lindgren odio velit repudiandae
Apple
73.0
Jon Lindgren perspiciatis totam perferendis
Apple
48.0
Jon Lindgren quibusdam sed sit
Apple
66.0
Jon Lindgren repudiandae officiis qui
Google
66.0
Jon Lindgren saepe hic temporibus
Microsoft
88.0
Jon Lindgren suscipit consectetur beatae
Google
113.0
Jon Lindgren vitae eum pariatur
Google
64.0
Juliana Hauck animi aperiam tenetur
Google
63.0
Juliana Hauck doloribus hic corporis
Microsoft
74.0
Juliana Hauck eum amet quia
Google
82.0
Juliana Hauck odio velit repudiandae
Apple
72.0
Juliana Hauck perspiciatis totam perferendis
Apple
72.0
Juliana Hauck quibusdam sed sit
Apple
73.0
Juliana Hauck repudiandae officiis qui
Google
52.0
Juliana Hauck saepe hic temporibus
Microsoft
88.0
Juliana Hauck suscipit consectetur beatae
Google
60.0
Juliana Hauck vitae eum pariatur
Google
39.0
Kaye Greenfelder animi aperiam tenetur
Google
67.0
Kaye Greenfelder doloribus hic corporis
Microsoft
31.0
Kaye Greenfelder eum amet quia
Google
59.0
Kaye Greenfelder odio velit repudiandae
Apple
72.0
Kaye Greenfelder perspiciatis totam perferendis
Apple
60.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