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

Developer Project Report hours
Sixta Bashirian animi aperiam tenetur 54.0
Sixta Bashirian doloribus hic corporis 30.0
Sixta Bashirian eum amet quia 67.0
Sixta Bashirian odio velit repudiandae 39.0
Sixta Bashirian perspiciatis totam perferendis 58.0
Sixta Bashirian quibusdam sed sit 84.0
Sixta Bashirian repudiandae officiis qui 75.0
Sixta Bashirian saepe hic temporibus 37.0
Sixta Bashirian suscipit consectetur beatae 102.0
Sixta Bashirian vitae eum pariatur 84.0
Sylvester Hane animi aperiam tenetur 77.0
Sylvester Hane doloribus hic corporis 66.0
Sylvester Hane eum amet quia 56.0
Sylvester Hane odio velit repudiandae 85.0
Sylvester Hane perspiciatis totam perferendis 69.0
Sylvester Hane quibusdam sed sit 92.0
Sylvester Hane repudiandae officiis qui 46.0
Sylvester Hane saepe hic temporibus 57.0
Sylvester Hane suscipit consectetur beatae 29.0
Sylvester Hane vitae eum pariatur 81.0
Tamera Bogan animi aperiam tenetur 81.0
Tamera Bogan doloribus hic corporis 76.0
Tamera Bogan eum amet quia 68.0
Tamera Bogan odio velit repudiandae 90.0
Tamera Bogan perspiciatis totam perferendis 82.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