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

Developer Project Report hours
Terisa Ruecker animi aperiam tenetur 67.0
Terisa Ruecker doloribus hic corporis 65.0
Terisa Ruecker eum amet quia 58.0
Terisa Ruecker odio velit repudiandae 85.0
Terisa Ruecker perspiciatis totam perferendis 39.0
Terisa Ruecker quibusdam sed sit 30.0
Terisa Ruecker repudiandae officiis qui 47.0
Terisa Ruecker saepe hic temporibus 34.0
Terisa Ruecker suscipit consectetur beatae 79.0
Terisa Ruecker vitae eum pariatur 54.0
Tess Nikolaus animi aperiam tenetur 70.0
Tess Nikolaus doloribus hic corporis 82.0
Tess Nikolaus eum amet quia 64.0
Tess Nikolaus odio velit repudiandae 66.0
Tess Nikolaus perspiciatis totam perferendis 61.0
Tess Nikolaus quibusdam sed sit 75.0
Tess Nikolaus repudiandae officiis qui 26.0
Tess Nikolaus saepe hic temporibus 82.0
Tess Nikolaus suscipit consectetur beatae 71.0
Tess Nikolaus vitae eum pariatur 59.0
Thaddeus Stanton animi aperiam tenetur 40.0
Thaddeus Stanton doloribus hic corporis 105.0
Thaddeus Stanton eum amet quia 35.0
Thaddeus Stanton odio velit repudiandae 66.0
Thaddeus Stanton perspiciatis totam perferendis 98.0

Grid:

class TimeEntriesGrid < BaseGrid

  #
  # 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_for @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