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

Developer Project Company Report hours
Felisa Jaskolski quibusdam sed sit
Apple
72.0
Felisa Jaskolski repudiandae officiis qui
Google
49.0
Felisa Jaskolski saepe hic temporibus
Microsoft
57.0
Felisa Jaskolski suscipit consectetur beatae
Google
103.0
Felisa Jaskolski vitae eum pariatur
Google
87.0
Flavia Will animi aperiam tenetur
Google
56.0
Flavia Will doloribus hic corporis
Microsoft
78.0
Flavia Will eum amet quia
Google
64.0
Flavia Will odio velit repudiandae
Apple
40.0
Flavia Will perspiciatis totam perferendis
Apple
64.0
Flavia Will quibusdam sed sit
Apple
89.0
Flavia Will repudiandae officiis qui
Google
46.0
Flavia Will saepe hic temporibus
Microsoft
90.0
Flavia Will suscipit consectetur beatae
Google
99.0
Flavia Will vitae eum pariatur
Google
34.0
German Murphy animi aperiam tenetur
Google
63.0
German Murphy doloribus hic corporis
Microsoft
90.0
German Murphy eum amet quia
Google
94.0
German Murphy odio velit repudiandae
Apple
47.0
German Murphy perspiciatis totam perferendis
Apple
52.0
German Murphy quibusdam sed sit
Apple
63.0
German Murphy repudiandae officiis qui
Google
70.0
German Murphy saepe hic temporibus
Microsoft
71.0
German Murphy suscipit consectetur beatae
Google
64.0
German Murphy vitae eum pariatur
Google
65.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