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

Developer Project Company Report hours
Ophelia Hermiston quibusdam sed sit
Apple
47.0
Ophelia Hermiston repudiandae officiis qui
Google
45.0
Ophelia Hermiston saepe hic temporibus
Microsoft
61.0
Ophelia Hermiston suscipit consectetur beatae
Google
80.0
Ophelia Hermiston vitae eum pariatur
Google
80.0
Palmira Fay animi aperiam tenetur
Google
85.0
Palmira Fay doloribus hic corporis
Microsoft
60.0
Palmira Fay eum amet quia
Google
49.0
Palmira Fay odio velit repudiandae
Apple
79.0
Palmira Fay perspiciatis totam perferendis
Apple
55.0
Palmira Fay quibusdam sed sit
Apple
47.0
Palmira Fay repudiandae officiis qui
Google
62.0
Palmira Fay saepe hic temporibus
Microsoft
31.0
Palmira Fay suscipit consectetur beatae
Google
96.0
Palmira Fay vitae eum pariatur
Google
55.0
Pearlie McGlynn animi aperiam tenetur
Google
72.0
Pearlie McGlynn doloribus hic corporis
Microsoft
57.0
Pearlie McGlynn eum amet quia
Google
34.0
Pearlie McGlynn odio velit repudiandae
Apple
62.0
Pearlie McGlynn perspiciatis totam perferendis
Apple
37.0
Pearlie McGlynn quibusdam sed sit
Apple
61.0
Pearlie McGlynn repudiandae officiis qui
Google
100.0
Pearlie McGlynn saepe hic temporibus
Microsoft
78.0
Pearlie McGlynn suscipit consectetur beatae
Google
71.0
Pearlie McGlynn vitae eum pariatur
Google
47.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