Developer | Project | Company | Report hours |
---|---|---|---|
Dahlia Hilll | quibusdam sed sit |
Apple
|
49.0 |
Dahlia Hilll | repudiandae officiis qui |
Google
|
71.0 |
Dahlia Hilll | saepe hic temporibus |
Microsoft
|
45.0 |
Dahlia Hilll | suscipit consectetur beatae |
Google
|
97.0 |
Dahlia Hilll | vitae eum pariatur |
Google
|
68.0 |
Cristopher Dooley | animi aperiam tenetur |
Google
|
39.0 |
Cristopher Dooley | doloribus hic corporis |
Microsoft
|
38.0 |
Cristopher Dooley | eum amet quia |
Google
|
69.0 |
Cristopher Dooley | odio velit repudiandae |
Apple
|
57.0 |
Cristopher Dooley | perspiciatis totam perferendis |
Apple
|
58.0 |
Cristopher Dooley | quibusdam sed sit |
Apple
|
92.0 |
Cristopher Dooley | repudiandae officiis qui |
Google
|
90.0 |
Cristopher Dooley | saepe hic temporibus |
Microsoft
|
56.0 |
Cristopher Dooley | suscipit consectetur beatae |
Google
|
53.0 |
Cristopher Dooley | vitae eum pariatur |
Google
|
64.0 |
Crissy Brekke | animi aperiam tenetur |
Google
|
69.0 |
Crissy Brekke | doloribus hic corporis |
Microsoft
|
69.0 |
Crissy Brekke | eum amet quia |
Google
|
53.0 |
Crissy Brekke | odio velit repudiandae |
Apple
|
62.0 |
Crissy Brekke | perspiciatis totam perferendis |
Apple
|
97.0 |
Crissy Brekke | quibusdam sed sit |
Apple
|
58.0 |
Crissy Brekke | repudiandae officiis qui |
Google
|
29.0 |
Crissy Brekke | saepe hic temporibus |
Microsoft
|
35.0 |
Crissy Brekke | suscipit consectetur beatae |
Google
|
68.0 |
Crissy Brekke | vitae eum pariatur |
Google
|
78.0 |
class TimeEntriesGrid < BaseGrid
#
# 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 => lambda {Project.all.map {|p| [p.name, p.id]}},
:multiple => true,
:include_blank => false
) do |value|
self.where(:time_entries => {:project_id => value})
end
filter(:year, :enum,
:select => lambda { TimeEntry.all.any? ? (TimeEntry.minimum(:date).year..TimeEntry.maximum(:date).year) : []},
: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 => Date::MONTHNAMES[1..12].enum_for(:each_with_index).collect {|name, index| [name, index + 1]},
: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)")
end
class TimeEntriesController < ApplicationController
def index
@time_entries_grid = TimeEntriesGrid.new(params[:g]) do |scope|
scope.page(params[:page] )
end
end
end
<h3>Time Entries Grid</h3>
<div class="left">
<%= datagrid_form_for @time_entries_grid, url: time_entries_path %>
<br/>
<%= datagrid_table(@time_entries_grid) %>
<%= paginate @time_entries_grid.assets %>
</div>
<div class="right">
<%= render :partial => "shared/source", :object => @time_entries_grid %>
</div>