Module: MyHelper

Defined in:
app/helpers/my_helper.rb

Overview

Redmine - project management software Copyright (C) 2006-2016 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.

Since:

  • 0.4.0

Instance Method Summary collapse

Instance Method Details

#calendar_items(startdt, enddt) ⇒ Object

Deprecated.

Removed at 3.4.0

Since:

  • 2.3.0



21
22
23
24
25
26
27
28
 
# File 'app/helpers/my_helper.rb', line 21

def calendar_items(startdt, enddt)
  Issue.visible.
    where(:project_id => User.current.projects.map(&:id)).
    where("(start_date>=? and start_date<=?) or (due_date>=? and due_date<=?)", startdt, enddt, startdt, enddt).
    includes(:project, :tracker, :priority, :assigned_to).
    references(:project, :tracker, :priority, :assigned_to).
    to_a
end

#documents_items ⇒ Object

Deprecated.

Removed at 3.4.0

Since:

  • 2.3.0



30
31
32
 
# File 'app/helpers/my_helper.rb', line 30

def documents_items
  Document.visible.order("#{Document.table_name}.created_on DESC").limit(10).to_a
end

#issuesassignedtome_items ⇒ Object

Deprecated.

Removed at 3.4.0

Since:

  • 2.3.0



34
35
36
37
38
39
40
41
 
# File 'app/helpers/my_helper.rb', line 34

def issuesassignedtome_items
  Issue.visible.open.
    assigned_to(User.current).
    limit(10).
    includes(:status, :project, :tracker, :priority).
    references(:status, :project, :tracker, :priority).
    order("#{IssuePriority.table_name}.position DESC, #{Issue.table_name}.updated_on DESC")
end

#issuesreportedbyme_items ⇒ Object

Deprecated.

Removed at 3.4.0

Since:

  • 2.3.0



43
44
45
46
47
48
49
50
 
# File 'app/helpers/my_helper.rb', line 43

def issuesreportedbyme_items
  Issue.visible.open.
    where(:author_id => User.current.id).
    limit(10).
    includes(:status, :project, :tracker).
    references(:status, :project, :tracker).
    order("#{Issue.table_name}.updated_on DESC")
end

#issueswatched_items ⇒ Object

Deprecated.

Removed at 3.4.0

Since:

  • 2.3.0



52
53
54
 
# File 'app/helpers/my_helper.rb', line 52

def issueswatched_items
  Issue.visible.open.on_active_project.watched_by(User.current.id).recently_updated.limit(10)
end

#news_items ⇒ Object

Deprecated.

Removed at 3.4.0

Since:

  • 2.3.0



56
57
58
59
60
61
62
63
64
 
# File 'app/helpers/my_helper.rb', line 56

def news_items
  News.visible.
    where(:project_id => User.current.projects.map(&:id)).
    limit(10).
    includes(:project, :author).
    references(:project, :author).
    order("#{News.table_name}.created_on DESC").
    to_a
end

#timelog_items ⇒ Object

Deprecated.

Removed at 3.4.0

Since:

  • 2.3.0



66
67
68
69
70
71
72
73
74
 
# File 'app/helpers/my_helper.rb', line 66

def timelog_items
  TimeEntry.
    where("#{TimeEntry.table_name}.user_id = ? AND #{TimeEntry.table_name}.spent_on BETWEEN ? AND ?", User.current.id, User.current.today - 6, User.current.today).
    joins(:activity, :project).
    references(:issue => [:tracker, :status]).
    includes(:issue => [:tracker, :status]).
    order("#{TimeEntry.table_name}.spent_on DESC, #{Project.table_name}.name ASC, #{Tracker.table_name}.position ASC, #{Issue.table_name}.id ASC").
    to_a
end