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

Developer Project Company Report hours
Vernia Dietrich animi aperiam tenetur
Google
55.0
Vernia Dietrich doloribus hic corporis
Microsoft
36.0
Vernia Dietrich eum amet quia
Google
73.0
Vernia Dietrich odio velit repudiandae
Apple
74.0
Vernia Dietrich perspiciatis totam perferendis
Apple
47.0
Vernia Dietrich quibusdam sed sit
Apple
28.0
Vernia Dietrich repudiandae officiis qui
Google
43.0
Vernia Dietrich saepe hic temporibus
Microsoft
61.0
Vernia Dietrich suscipit consectetur beatae
Google
49.0
Vernia Dietrich vitae eum pariatur
Google
69.0
Vivien Murray animi aperiam tenetur
Google
54.0
Vivien Murray doloribus hic corporis
Microsoft
43.0
Vivien Murray eum amet quia
Google
38.0
Vivien Murray odio velit repudiandae
Apple
94.0
Vivien Murray perspiciatis totam perferendis
Apple
37.0
Vivien Murray quibusdam sed sit
Apple
71.0
Vivien Murray repudiandae officiis qui
Google
77.0
Vivien Murray saepe hic temporibus
Microsoft
85.0
Vivien Murray suscipit consectetur beatae
Google
57.0
Vivien Murray vitae eum pariatur
Google
77.0
Wen Daniel animi aperiam tenetur
Google
57.0
Wen Daniel doloribus hic corporis
Microsoft
61.0
Wen Daniel eum amet quia
Google
126.0
Wen Daniel odio velit repudiandae
Apple
83.0
Wen Daniel perspiciatis totam perferendis
Apple
128.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