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

Developer Project Company Report hours
Maryanna Medhurst animi aperiam tenetur
Google
47.0
Maryanna Medhurst doloribus hic corporis
Microsoft
81.0
Maryanna Medhurst eum amet quia
Google
36.0
Maryanna Medhurst odio velit repudiandae
Apple
72.0
Maryanna Medhurst perspiciatis totam perferendis
Apple
76.0
Maryanna Medhurst quibusdam sed sit
Apple
48.0
Maryanna Medhurst repudiandae officiis qui
Google
74.0
Maryanna Medhurst saepe hic temporibus
Microsoft
48.0
Maryanna Medhurst suscipit consectetur beatae
Google
62.0
Maryanna Medhurst vitae eum pariatur
Google
84.0
Micheal Jenkins animi aperiam tenetur
Google
29.0
Micheal Jenkins doloribus hic corporis
Microsoft
70.0
Micheal Jenkins eum amet quia
Google
76.0
Micheal Jenkins odio velit repudiandae
Apple
44.0
Micheal Jenkins perspiciatis totam perferendis
Apple
75.0
Micheal Jenkins quibusdam sed sit
Apple
33.0
Micheal Jenkins repudiandae officiis qui
Google
44.0
Micheal Jenkins saepe hic temporibus
Microsoft
93.0
Micheal Jenkins suscipit consectetur beatae
Google
64.0
Micheal Jenkins vitae eum pariatur
Google
72.0
Milagros Lemke animi aperiam tenetur
Google
67.0
Milagros Lemke doloribus hic corporis
Microsoft
54.0
Milagros Lemke eum amet quia
Google
53.0
Milagros Lemke odio velit repudiandae
Apple
30.0
Milagros Lemke perspiciatis totam perferendis
Apple
76.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