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

Developer Project Company Report hours
Rebecca Rempel quibusdam sed sit
Apple
65.0
Rebecca Rempel repudiandae officiis qui
Google
54.0
Rebecca Rempel saepe hic temporibus
Microsoft
71.0
Rebecca Rempel suscipit consectetur beatae
Google
61.0
Rebecca Rempel vitae eum pariatur
Google
65.0
Reinaldo Heidenreich animi aperiam tenetur
Google
76.0
Reinaldo Heidenreich doloribus hic corporis
Microsoft
72.0
Reinaldo Heidenreich eum amet quia
Google
82.0
Reinaldo Heidenreich odio velit repudiandae
Apple
52.0
Reinaldo Heidenreich perspiciatis totam perferendis
Apple
78.0
Reinaldo Heidenreich quibusdam sed sit
Apple
79.0
Reinaldo Heidenreich repudiandae officiis qui
Google
81.0
Reinaldo Heidenreich saepe hic temporibus
Microsoft
70.0
Reinaldo Heidenreich suscipit consectetur beatae
Google
48.0
Reinaldo Heidenreich vitae eum pariatur
Google
60.0
Rossana Schneider animi aperiam tenetur
Google
42.0
Rossana Schneider doloribus hic corporis
Microsoft
93.0
Rossana Schneider eum amet quia
Google
34.0
Rossana Schneider odio velit repudiandae
Apple
82.0
Rossana Schneider perspiciatis totam perferendis
Apple
51.0
Rossana Schneider quibusdam sed sit
Apple
106.0
Rossana Schneider repudiandae officiis qui
Google
78.0
Rossana Schneider saepe hic temporibus
Microsoft
47.0
Rossana Schneider suscipit consectetur beatae
Google
76.0
Rossana Schneider vitae eum pariatur
Google
30.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