jro_apps/redmine Commit - r15391:374468e88aab

1

# encoding: utf-8

1

# encoding: utf-8

2

#

2

#

3

# Redmine - project management software

3

# Redmine - project management software

4

5

#

5

#

6

# This program is free software; you can redistribute it and/or

6

# This program is free software; you can redistribute it and/or

7

# modify it under the terms of the GNU General Public License

7

# modify it under the terms of the GNU General Public License

8

# as published by the Free Software Foundation; either version 2

8

# as published by the Free Software Foundation; either version 2

9

# of the License, or (at your option) any later version.

9

# of the License, or (at your option) any later version.

10

#

10

#

11

# This program is distributed in the hope that it will be useful,

11

# This program is distributed in the hope that it will be useful,

12

# but WITHOUT ANY WARRANTY; without even the implied warranty of

12

# but WITHOUT ANY WARRANTY; without even the implied warranty of

13

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

13

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

14

# GNU General Public License for more details.

14

# GNU General Public License for more details.

15

#

15

#

16

# You should have received a copy of the GNU General Public License

16

# You should have received a copy of the GNU General Public License

17

# along with this program; if not, write to the Free Software

17

# along with this program; if not, write to the Free Software

18

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

18

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

19

20

module MyHelper

20

module MyHelper

21

def calendar_items(startdt, enddt)

21

def calendar_items(startdt, enddt)

22

Issue.visible.

22

Issue.visible.

23

where(:project_id => User.current.projects.map(&:id)).

23

where(:project_id => User.current.projects.map(&:id)).

24

where("(start_date>=? and start_date<=?) or (due_date>=? and due_date<=?)", startdt, enddt, startdt, enddt).

24

where("(start_date>=? and start_date<=?) or (due_date>=? and due_date<=?)", startdt, enddt, startdt, enddt).

25

includes(:project, :tracker, :priority, :assigned_to).

25

includes(:project, :tracker, :priority, :assigned_to).

26

references(:project, :tracker, :priority, :assigned_to).

26

references(:project, :tracker, :priority, :assigned_to).

27

to_a

27

to_a

28

end

28

end

29

30

def documents_items

30

def documents_items

31

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

31

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

32

end

32

end

33

34

def issuesassignedtome_items

34

def issuesassignedtome_items

35

Issue.visible.open.

35

Issue.visible.open.

36

assigned_to(User.current).

36

assigned_to(User.current).

37

limit(10).

37

limit(10).

38

includes(:status, :project, :tracker, :priority).

38

includes(:status, :project, :tracker, :priority).

39

references(:status, :project, :tracker, :priority).

39

references(:status, :project, :tracker, :priority).

40

order("#{IssuePriority.table_name}.position DESC, #{Issue.table_name}.updated_on DESC")

40

order("#{IssuePriority.table_name}.position DESC, #{Issue.table_name}.updated_on DESC")

41

end

41

end

42

43

def issuesreportedbyme_items

43

def issuesreportedbyme_items

44

Issue.visible.

44

Issue.visible.open.

45

where(:author_id => User.current.id).

45

where(:author_id => User.current.id).

46

limit(10).

46

limit(10).

47

includes(:status, :project, :tracker).

47

includes(:status, :project, :tracker).

48

references(:status, :project, :tracker).

48

references(:status, :project, :tracker).

49

order("#{Issue.table_name}.updated_on DESC")

49

order("#{Issue.table_name}.updated_on DESC")

50

end

50

end

51

52

def issueswatched_items

52

def issueswatched_items

53

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

53

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

54

end

54

end

55

56

def news_items

56

def news_items

57

News.visible.

57

News.visible.

58

where(:project_id => User.current.projects.map(&:id)).

58

where(:project_id => User.current.projects.map(&:id)).

59

limit(10).

59

limit(10).

60

includes(:project, :author).

60

includes(:project, :author).

61

references(:project, :author).

61

references(:project, :author).

62

order("#{News.table_name}.created_on DESC").

62

order("#{News.table_name}.created_on DESC").

63

to_a

63

to_a

64

end

64

end

65

66

def timelog_items

66

def timelog_items

67

TimeEntry.

67

TimeEntry.

68

where("#{TimeEntry.table_name}.user_id = ? AND #{TimeEntry.table_name}.spent_on BETWEEN ? AND ?", User.current.id, User.current.today - 6, User.current.today).

68

where("#{TimeEntry.table_name}.user_id = ? AND #{TimeEntry.table_name}.spent_on BETWEEN ? AND ?", User.current.id, User.current.today - 6, User.current.today).

69

joins(:activity, :project).

69

joins(:activity, :project).

70

references(:issue => [:tracker, :status]).

70

references(:issue => [:tracker, :status]).

71

includes(:issue => [:tracker, :status]).

71

includes(:issue => [:tracker, :status]).

72

order("#{TimeEntry.table_name}.spent_on DESC, #{Project.table_name}.name ASC, #{Tracker.table_name}.position ASC, #{Issue.table_name}.id ASC").

72

order("#{TimeEntry.table_name}.spent_on DESC, #{Project.table_name}.name ASC, #{Tracker.table_name}.position ASC, #{Issue.table_name}.id ASC").

73

to_a

73

to_a

74

end

74

end

75

end

75

end

             <% reported_issues = issuesreportedbyme_items %>
             <h3>
               <%= link_to l(:label_reported_issues),
-                    issues_path(:set_filter => 1, :status_id => '*', :author_id => 'me', :sort => 'updated_on:desc') %>
+                    issues_path(:set_filter => 1, :status_id => 'o', :author_id => 'me', :sort => 'updated_on:desc') %>
               (<%= reported_issues.limit(nil).count %>)
             </h3>
             <%= render :partial => 'issues/list_simple', :locals => { :issues => reported_issues.to_a } %>
             <% content_for :header_tags do %>
             <%= auto_discovery_link_tag(:atom,
                                         {:controller => 'issues', :action => 'index', :set_filter => 1,
                                          :author_id => 'me', :format => 'atom', :key => User.current.rss_key},
                                         {:title => l(:label_reported_issues)}) %>
             <% end %>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             # encoding: utf-8
             #
             # 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.
             module MyHelper
               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
               def documents_items
                 Document.visible.order("#{Document.table_name}.created_on DESC").limit(10).to_a
               end
               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
               def issuesreportedbyme_items
-                Issue.visible.
+                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
               def issueswatched_items
                 Issue.visible.open.on_active_project.watched_by(User.current.id).recently_updated.limit(10)
               end
               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
               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
             end