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

Developer Project Company Report hours
Maryanna Medhurst animi aperiam tenetur
Google
91.0
Maryanna Medhurst doloribus hic corporis
Microsoft
77.0
Maryanna Medhurst eum amet quia
Google
59.0
Maryanna Medhurst odio velit repudiandae
Apple
65.0
Maryanna Medhurst perspiciatis totam perferendis
Apple
63.0
Maryanna Medhurst quibusdam sed sit
Apple
33.0
Maryanna Medhurst repudiandae officiis qui
Google
45.0
Maryanna Medhurst saepe hic temporibus
Microsoft
55.0
Maryanna Medhurst suscipit consectetur beatae
Google
77.0
Maryanna Medhurst vitae eum pariatur
Google
90.0
Micheal Jenkins animi aperiam tenetur
Google
69.0
Micheal Jenkins doloribus hic corporis
Microsoft
57.0
Micheal Jenkins eum amet quia
Google
57.0
Micheal Jenkins odio velit repudiandae
Apple
64.0
Micheal Jenkins perspiciatis totam perferendis
Apple
86.0
Micheal Jenkins quibusdam sed sit
Apple
63.0
Micheal Jenkins repudiandae officiis qui
Google
115.0
Micheal Jenkins saepe hic temporibus
Microsoft
54.0
Micheal Jenkins suscipit consectetur beatae
Google
48.0
Micheal Jenkins vitae eum pariatur
Google
41.0
Milagros Lemke animi aperiam tenetur
Google
46.0
Milagros Lemke doloribus hic corporis
Microsoft
66.0
Milagros Lemke eum amet quia
Google
100.0
Milagros Lemke odio velit repudiandae
Apple
51.0
Milagros Lemke perspiciatis totam perferendis
Apple
99.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