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

Developer Project Company Report hours
Desmond Murray animi aperiam tenetur
Google
97.0
Desmond Murray doloribus hic corporis
Microsoft
56.0
Desmond Murray eum amet quia
Google
63.0
Desmond Murray odio velit repudiandae
Apple
54.0
Desmond Murray perspiciatis totam perferendis
Apple
67.0
Desmond Murray quibusdam sed sit
Apple
61.0
Desmond Murray repudiandae officiis qui
Google
82.0
Desmond Murray saepe hic temporibus
Microsoft
32.0
Desmond Murray suscipit consectetur beatae
Google
83.0
Desmond Murray vitae eum pariatur
Google
71.0
Dona Gutkowski animi aperiam tenetur
Google
26.0
Dona Gutkowski doloribus hic corporis
Microsoft
66.0
Dona Gutkowski eum amet quia
Google
56.0
Dona Gutkowski odio velit repudiandae
Apple
82.0
Dona Gutkowski perspiciatis totam perferendis
Apple
72.0
Dona Gutkowski quibusdam sed sit
Apple
57.0
Dona Gutkowski repudiandae officiis qui
Google
30.0
Dona Gutkowski saepe hic temporibus
Microsoft
57.0
Dona Gutkowski suscipit consectetur beatae
Google
115.0
Dona Gutkowski vitae eum pariatur
Google
37.0
Dorthey Turner animi aperiam tenetur
Google
72.0
Dorthey Turner doloribus hic corporis
Microsoft
85.0
Dorthey Turner eum amet quia
Google
74.0
Dorthey Turner odio velit repudiandae
Apple
63.0
Dorthey Turner perspiciatis totam perferendis
Apple
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