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

Developer Project Company Report hours
Elida Zulauf animi aperiam tenetur
Google
40.0
Elida Zulauf doloribus hic corporis
Microsoft
95.0
Elida Zulauf eum amet quia
Google
65.0
Elida Zulauf odio velit repudiandae
Apple
45.0
Elida Zulauf perspiciatis totam perferendis
Apple
48.0
Elida Zulauf quibusdam sed sit
Apple
67.0
Elida Zulauf repudiandae officiis qui
Google
68.0
Elida Zulauf saepe hic temporibus
Microsoft
57.0
Elida Zulauf suscipit consectetur beatae
Google
78.0
Elida Zulauf vitae eum pariatur
Google
76.0
Elisa Wintheiser animi aperiam tenetur
Google
50.0
Elisa Wintheiser doloribus hic corporis
Microsoft
60.0
Elisa Wintheiser eum amet quia
Google
37.0
Elisa Wintheiser odio velit repudiandae
Apple
35.0
Elisa Wintheiser perspiciatis totam perferendis
Apple
71.0
Elisa Wintheiser quibusdam sed sit
Apple
88.0
Elisa Wintheiser repudiandae officiis qui
Google
76.0
Elisa Wintheiser saepe hic temporibus
Microsoft
41.0
Elisa Wintheiser suscipit consectetur beatae
Google
62.0
Elisa Wintheiser vitae eum pariatur
Google
44.0
Elise Waelchi animi aperiam tenetur
Google
40.0
Elise Waelchi doloribus hic corporis
Microsoft
60.0
Elise Waelchi eum amet quia
Google
34.0
Elise Waelchi odio velit repudiandae
Apple
29.0
Elise Waelchi perspiciatis totam perferendis
Apple
76.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