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

Developer Project Company Report hours
Rebecca Rempel quibusdam sed sit
Apple
39.0
Rebecca Rempel repudiandae officiis qui
Google
75.0
Rebecca Rempel saepe hic temporibus
Microsoft
63.0
Rebecca Rempel suscipit consectetur beatae
Google
47.0
Rebecca Rempel vitae eum pariatur
Google
52.0
Reinaldo Heidenreich animi aperiam tenetur
Google
42.0
Reinaldo Heidenreich doloribus hic corporis
Microsoft
55.0
Reinaldo Heidenreich eum amet quia
Google
108.0
Reinaldo Heidenreich odio velit repudiandae
Apple
51.0
Reinaldo Heidenreich perspiciatis totam perferendis
Apple
48.0
Reinaldo Heidenreich quibusdam sed sit
Apple
68.0
Reinaldo Heidenreich repudiandae officiis qui
Google
55.0
Reinaldo Heidenreich saepe hic temporibus
Microsoft
46.0
Reinaldo Heidenreich suscipit consectetur beatae
Google
56.0
Reinaldo Heidenreich vitae eum pariatur
Google
67.0
Rossana Schneider animi aperiam tenetur
Google
102.0
Rossana Schneider doloribus hic corporis
Microsoft
59.0
Rossana Schneider eum amet quia
Google
57.0
Rossana Schneider odio velit repudiandae
Apple
80.0
Rossana Schneider perspiciatis totam perferendis
Apple
51.0
Rossana Schneider quibusdam sed sit
Apple
63.0
Rossana Schneider repudiandae officiis qui
Google
64.0
Rossana Schneider saepe hic temporibus
Microsoft
49.0
Rossana Schneider suscipit consectetur beatae
Google
71.0
Rossana Schneider vitae eum pariatur
Google
41.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