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

Developer Project Company Report hours
Shane Glover quibusdam sed sit
Apple
43.0
Shane Glover repudiandae officiis qui
Google
58.0
Shane Glover saepe hic temporibus
Microsoft
75.0
Shane Glover suscipit consectetur beatae
Google
61.0
Shane Glover vitae eum pariatur
Google
44.0
Shannon Botsford animi aperiam tenetur
Google
67.0
Shannon Botsford doloribus hic corporis
Microsoft
67.0
Shannon Botsford eum amet quia
Google
53.0
Shannon Botsford odio velit repudiandae
Apple
75.0
Shannon Botsford perspiciatis totam perferendis
Apple
47.0
Shannon Botsford quibusdam sed sit
Apple
57.0
Shannon Botsford repudiandae officiis qui
Google
63.0
Shannon Botsford saepe hic temporibus
Microsoft
70.0
Shannon Botsford suscipit consectetur beatae
Google
100.0
Shannon Botsford vitae eum pariatur
Google
72.0
Shara Labadie animi aperiam tenetur
Google
48.0
Shara Labadie doloribus hic corporis
Microsoft
53.0
Shara Labadie eum amet quia
Google
100.0
Shara Labadie odio velit repudiandae
Apple
95.0
Shara Labadie perspiciatis totam perferendis
Apple
36.0
Shara Labadie quibusdam sed sit
Apple
91.0
Shara Labadie repudiandae officiis qui
Google
85.0
Shara Labadie saepe hic temporibus
Microsoft
93.0
Shara Labadie suscipit consectetur beatae
Google
76.0
Shara Labadie vitae eum pariatur
Google
43.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