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

Developer Project Company Report hours
Wen Daniel quibusdam sed sit
Apple
42.0
Wen Daniel repudiandae officiis qui
Google
83.0
Wen Daniel saepe hic temporibus
Microsoft
50.0
Wen Daniel suscipit consectetur beatae
Google
94.0
Wen Daniel vitae eum pariatur
Google
91.0
Wiley Wuckert animi aperiam tenetur
Google
68.0
Wiley Wuckert doloribus hic corporis
Microsoft
33.0
Wiley Wuckert eum amet quia
Google
85.0
Wiley Wuckert odio velit repudiandae
Apple
63.0
Wiley Wuckert perspiciatis totam perferendis
Apple
42.0
Wiley Wuckert quibusdam sed sit
Apple
48.0
Wiley Wuckert repudiandae officiis qui
Google
55.0
Wiley Wuckert saepe hic temporibus
Microsoft
64.0
Wiley Wuckert suscipit consectetur beatae
Google
71.0
Wiley Wuckert vitae eum pariatur
Google
55.0
Winfred Franecki animi aperiam tenetur
Google
72.0
Winfred Franecki doloribus hic corporis
Microsoft
66.0
Winfred Franecki eum amet quia
Google
51.0
Winfred Franecki odio velit repudiandae
Apple
41.0
Winfred Franecki perspiciatis totam perferendis
Apple
50.0
Winfred Franecki quibusdam sed sit
Apple
65.0
Winfred Franecki repudiandae officiis qui
Google
71.0
Winfred Franecki saepe hic temporibus
Microsoft
70.0
Winfred Franecki suscipit consectetur beatae
Google
65.0
Winfred Franecki vitae eum pariatur
Google
38.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