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

Developer Project Company Report hours
Jeanne Witting saepe hic temporibus
Microsoft
82.0
Jewell Kreiger saepe hic temporibus
Microsoft
38.0
Jewell Swaniawski saepe hic temporibus
Microsoft
47.0
Joelle Hodkiewicz saepe hic temporibus
Microsoft
71.0
Johnny Spinka saepe hic temporibus
Microsoft
84.0
Jon Lindgren saepe hic temporibus
Microsoft
42.0
Juliana Hauck saepe hic temporibus
Microsoft
65.0
Kaye Greenfelder saepe hic temporibus
Microsoft
46.0
Kellie Cassin saepe hic temporibus
Microsoft
69.0
Lesia Hyatt saepe hic temporibus
Microsoft
72.0
Li Considine saepe hic temporibus
Microsoft
35.0
Lillie Hamill saepe hic temporibus
Microsoft
66.0
Lynell Stamm saepe hic temporibus
Microsoft
114.0
Malvina Zulauf saepe hic temporibus
Microsoft
35.0
Marna Ritchie saepe hic temporibus
Microsoft
81.0
Maryanna Medhurst saepe hic temporibus
Microsoft
45.0
Micheal Jenkins saepe hic temporibus
Microsoft
62.0
Milagros Lemke saepe hic temporibus
Microsoft
66.0
Mi Prosacco saepe hic temporibus
Microsoft
40.0
Myriam Von saepe hic temporibus
Microsoft
44.0
Myrtle O'Conner saepe hic temporibus
Microsoft
61.0
Nelson Leannon saepe hic temporibus
Microsoft
45.0
Ophelia Hermiston saepe hic temporibus
Microsoft
60.0
Palmira Fay saepe hic temporibus
Microsoft
82.0
Pearlie McGlynn saepe hic temporibus
Microsoft
48.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