Class: TimeEntryQuery

Inherits:
Query
  • Object
show all
Defined in:
app/models/time_entry_query.rb

Overview

Redmine - project management software Copyright (C) 2006-2014 Jean-Philippe Lang

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

Constant Summary

Constants inherited from Query

Query::VISIBILITY_PRIVATE, Query::VISIBILITY_PUBLIC, Query::VISIBILITY_ROLES

Instance Method Summary collapse

Methods inherited from Query

add_available_column, #add_available_filter, #add_filter, #add_filter_error, #add_filters, #add_short_filter, #all_projects, #all_projects_values, #available_block_columns, #available_filters, #available_filters_as_json, #available_inline_columns, #block_columns, build_from_params, #column_names=, #columns, #delete_available_filter, #editable_by?, #group_by_column, #group_by_sort_order, #group_by_statement, #groupable_columns, #grouped?, #has_column?, #has_custom_field_column?, #has_default_columns?, #has_filter?, #inline_columns, #label_for, #operator_for, operators_labels, #project_statement, #queried_table_name, #sort_criteria, #sort_criteria=, #sort_criteria_key, #sort_criteria_order, #sort_criteria_order_for, #sortable_columns, #statement, #trackers, #type_for, #validate_query_filters, #value_for, #values_for

Constructor Details

#initialize(attributes = nil, *args) ⇒ TimeEntryQuery

Returns a new instance of TimeEntryQuery.


32
33
34
35
36
# File 'app/models/time_entry_query.rb', line 32

def initialize(attributes=nil, *args)
  super attributes
  self.filters ||= {}
  add_filter('spent_on', '*') unless filters.present?
end

Instance Method Details

#available_columnsObject


91
92
93
94
95
96
97
98
99
# File 'app/models/time_entry_query.rb', line 91

def available_columns
  return @available_columns if @available_columns
  @available_columns = self.class.available_columns.dup
  @available_columns += TimeEntryCustomField.visible.
                          map {|cf| QueryCustomFieldColumn.new(cf) }
  @available_columns += IssueCustomField.visible.
                          map {|cf| QueryAssociationCustomFieldColumn.new(:issue, cf) }
  @available_columns
end

#build_from_params(params) ⇒ Object

Accepts :from/:to params as shortcut filters


129
130
131
132
133
134
135
136
137
138
139
# File 'app/models/time_entry_query.rb', line 129

def build_from_params(params)
  super
  if params[:from].present? && params[:to].present?
    add_filter('spent_on', '><', [params[:from], params[:to]])
  elsif params[:from].present?
    add_filter('spent_on', '>=', [params[:from]])
  elsif params[:to].present?
    add_filter('spent_on', '<=', [params[:to]])
  end
  self
end

#default_columns_namesObject


101
102
103
# File 'app/models/time_entry_query.rb', line 101

def default_columns_names
  @default_columns_names ||= [:project, :spent_on, :user, :activity, :issue, :comments, :hours]
end

#initialize_available_filtersObject


38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
# File 'app/models/time_entry_query.rb', line 38

def initialize_available_filters
  add_available_filter "spent_on", :type => :date_past

  principals = []
  if project
    principals += project.principals.visible.sort
    unless project.leaf?
      subprojects = project.descendants.visible.to_a
      if subprojects.any?
        add_available_filter "subproject_id",
          :type => :list_subprojects,
          :values => subprojects.collect{|s| [s.name, s.id.to_s] }
        principals += Principal.member_of(subprojects).visible
      end
    end
  else
    if all_projects.any?      # members of visible projects

      principals += Principal.member_of(all_projects).visible      # project filter

      project_values = []
      if User.current.logged? && User.current.memberships.any?
        project_values << ["<< #{l(:label_my_projects).downcase} >>", "mine"]
      end
      project_values += all_projects_values
      add_available_filter("project_id",
        :type => :list, :values => project_values
      ) unless project_values.empty?
    end
  end
  principals.uniq!
  principals.sort!
  users = principals.select {|p| p.is_a?(User)}

  users_values = []
  users_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
  users_values += users.collect{|s| [s.name, s.id.to_s] }
  add_available_filter("user_id",
    :type => :list_optional, :values => users_values
  ) unless users_values.empty?

  activities = (project ? project.activities : TimeEntryActivity.shared.active)
  add_available_filter("activity_id",
    :type => :list, :values => activities.map {|a| [a.name, a.id.to_s]}
  ) unless activities.empty?

  add_available_filter "comments", :type => :text
  add_available_filter "hours", :type => :float

  add_custom_fields_filters(TimeEntryCustomField)
  add_associations_custom_fields_filters :project, :issue, :user
end

#results_scope(options = {}) ⇒ Object


105
106
107
108
109
110
111
112
113
114
# File 'app/models/time_entry_query.rb', line 105

def results_scope(options={})
  order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?)

  TimeEntry.visible.
    where(statement).
    order(order_option).
    joins(joins_for_order_statement(order_option.join(','))).
    includes(:activity).
    references(:activity)
end

#sql_for_activity_id_field(field, operator, value) ⇒ Object


116
117
118
119
120
121
122
123
124
125
126
# File 'app/models/time_entry_query.rb', line 116

def sql_for_activity_id_field(field, operator, value)
  condition_on_id = sql_for_field(field, operator, value, Enumeration.table_name, 'id')
  condition_on_parent_id = sql_for_field(field, operator, value, Enumeration.table_name, 'parent_id')
  ids = value.map(&:to_i).join(',')
  table_name = Enumeration.table_name
  if operator == '='
    "(#{table_name}.id IN (#{ids}) OR #{table_name}.parent_id IN (#{ids}))"
  else
    "(#{table_name}.id NOT IN (#{ids}) AND (#{table_name}.parent_id IS NULL OR #{table_name}.parent_id NOT IN (#{ids})))"
  end
end