jro_apps/redmine Commit - r12189:61c6858b0536

1

# Redmine - project management software

1

# Redmine - project management software

2

3

#

3

#

4

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

4

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

5

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

5

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

6

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

6

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

7

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

7

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

8

#

8

#

9

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

9

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

10

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

10

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

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

12

# GNU General Public License for more details.

12

# GNU General Public License for more details.

13

#

13

#

14

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

14

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

15

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

15

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

16

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

16

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

17

18

class Principal < ActiveRecord::Base

18

class Principal < ActiveRecord::Base

19

self.table_name = "#{table_name_prefix}users#{table_name_suffix}"

19

self.table_name = "#{table_name_prefix}users#{table_name_suffix}"

20

21

# Account statuses

21

# Account statuses

22

STATUS_ANONYMOUS = 0

22

STATUS_ANONYMOUS = 0

23

STATUS_ACTIVE = 1

23

STATUS_ACTIVE = 1

24

STATUS_REGISTERED = 2

24

STATUS_REGISTERED = 2

25

STATUS_LOCKED = 3

25

STATUS_LOCKED = 3

26

27

has_many :members, :foreign_key => 'user_id', :dependent => :destroy

27

has_many :members, :foreign_key => 'user_id', :dependent => :destroy

28

has_many :memberships, :class_name => 'Member', :foreign_key => 'user_id', :include => [ :project, :roles ], :conditions => "#{Project.table_name}.status<>#{Project::STATUS_ARCHIVED}", :order => "#{Project.table_name}.name"

28

has_many :memberships, :class_name => 'Member',

29

:foreign_key => 'user_id',

30

:include => [:project, :roles],

31

:conditions => "#{Project.table_name}.status<>#{Project::STATUS_ARCHIVED}",

32

:order => "#{Project.table_name}.name"

29

has_many :projects, :through => :memberships

33

has_many :projects, :through => :memberships

30

has_many :issue_categories, :foreign_key => 'assigned_to_id', :dependent => :nullify

34

has_many :issue_categories, :foreign_key => 'assigned_to_id', :dependent => :nullify

31

35

32

# Groups and active users

36

# Groups and active users

33

scope :active, lambda { where(:status => STATUS_ACTIVE) }

37

scope :active, lambda { where(:status => STATUS_ACTIVE) }

34

38

35

scope :like, lambda {|q|

39

scope :like, lambda {|q|

36

q = q.to_s

40

q = q.to_s

37

if q.blank?

41

if q.blank?

38

where({})

42

where({})

39

else

43

else

40

pattern = "%#{q}%"

44

pattern = "%#{q}%"

41

sql = %w(login firstname lastname mail).map {|column| "LOWER(#{table_name}.#{column}) LIKE LOWER(:p)"}.join(" OR ")

45

sql = %w(login firstname lastname mail).map {|column| "LOWER(#{table_name}.#{column}) LIKE LOWER(:p)"}.join(" OR ")

42

params = {:p => pattern}

46

params = {:p => pattern}

43

if q =~ /^(.+)\s+(.+)$/

47

if q =~ /^(.+)\s+(.+)$/

44

a, b = "#{$1}%", "#{$2}%"

48

a, b = "#{$1}%", "#{$2}%"

45

sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:a) AND LOWER(#{table_name}.lastname) LIKE LOWER(:b))"

49

sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:a) AND LOWER(#{table_name}.lastname) LIKE LOWER(:b))"

46

sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:b) AND LOWER(#{table_name}.lastname) LIKE LOWER(:a))"

50

sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:b) AND LOWER(#{table_name}.lastname) LIKE LOWER(:a))"

47

params.merge!(:a => a, :b => b)

51

params.merge!(:a => a, :b => b)

48

end

52

end

49

where(sql, params)

53

where(sql, params)

50

end

54

end

51

}

55

}

52

56

53

# Principals that are members of a collection of projects

57

# Principals that are members of a collection of projects

54

scope :member_of, lambda {|projects|

58

scope :member_of, lambda {|projects|

55

projects = [projects] unless projects.is_a?(Array)

59

projects = [projects] unless projects.is_a?(Array)

56

if projects.empty?

60

if projects.empty?

57

where("1=0")

61

where("1=0")

58

else

62

else

59

ids = projects.map(&:id)

63

ids = projects.map(&:id)

60

active.uniq.joins(:members).where("#{Member.table_name}.project_id IN (?)", ids)

64

active.uniq.joins(:members).where("#{Member.table_name}.project_id IN (?)", ids)

61

end

65

end

62

}

66

}

63

# Principals that are not members of projects

67

# Principals that are not members of projects

64

scope :not_member_of, lambda {|projects|

68

scope :not_member_of, lambda {|projects|

65

projects = [projects] unless projects.is_a?(Array)

69

projects = [projects] unless projects.is_a?(Array)

66

if projects.empty?

70

if projects.empty?

67

where("1=0")

71

where("1=0")

68

else

72

else

69

ids = projects.map(&:id)

73

ids = projects.map(&:id)

70

where("#{Principal.table_name}.id NOT IN (SELECT DISTINCT user_id FROM #{Member.table_name} WHERE project_id IN (?))", ids)

74

where("#{Principal.table_name}.id NOT IN (SELECT DISTINCT user_id FROM #{Member.table_name} WHERE project_id IN (?))", ids)

71

end

75

end

72

}

76

}

73

scope :sorted, lambda { order(*Principal.fields_for_order_statement)}

77

scope :sorted, lambda { order(*Principal.fields_for_order_statement)}

74

78

75

before_create :set_default_empty_values

79

before_create :set_default_empty_values

76

80

77

def name(formatter = nil)

81

def name(formatter = nil)

78

to_s

82

to_s

79

end

83

end

80

84

81

def <=>(principal)

85

def <=>(principal)

82

if principal.nil?

86

if principal.nil?

83

-1

87

-1

84

elsif self.class.name == principal.class.name

88

elsif self.class.name == principal.class.name

85

self.to_s.downcase <=> principal.to_s.downcase

89

self.to_s.downcase <=> principal.to_s.downcase

86

else

90

else

87

# groups after users

91

# groups after users

88

principal.class.name <=> self.class.name

92

principal.class.name <=> self.class.name

89

end

93

end

90

end

94

end

91

95

92

# Returns an array of fields names than can be used to make an order statement for principals.

96

# Returns an array of fields names than can be used to make an order statement for principals.

93

# Users are sorted before Groups.

97

# Users are sorted before Groups.

94

# Examples:

98

# Examples:

95

def self.fields_for_order_statement(table=nil)

99

def self.fields_for_order_statement(table=nil)

96

table ||= table_name

100

table ||= table_name

97

columns = ['type DESC'] + (User.name_formatter[:order] - ['id']) + ['lastname', 'id']

101

columns = ['type DESC'] + (User.name_formatter[:order] - ['id']) + ['lastname', 'id']

98

columns.uniq.map {|field| "#{table}.#{field}"}

102

columns.uniq.map {|field| "#{table}.#{field}"}

99

end

103

end

100

104

101

protected

105

protected

102

106

103

# Make sure we don't try to insert NULL values (see #4632)

107

# Make sure we don't try to insert NULL values (see #4632)

104

def set_default_empty_values

108

def set_default_empty_values

105

self.login ||= ''

109

self.login ||= ''

106

self.hashed_password ||= ''

110

self.hashed_password ||= ''

107

self.firstname ||= ''

111

self.firstname ||= ''

108

self.lastname ||= ''

112

self.lastname ||= ''

109

self.mail ||= ''

113

self.mail ||= ''

110

true

114

true

111

end

115

end

112

end

116

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

             # Redmine - project management software
             # Copyright (C) 2006-2013  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.
             class Principal < ActiveRecord::Base
               self.table_name = "#{table_name_prefix}users#{table_name_suffix}"
               # Account statuses
               STATUS_ANONYMOUS  = 0
               STATUS_ACTIVE     = 1
               STATUS_REGISTERED = 2
               STATUS_LOCKED     = 3
               has_many :members, :foreign_key => 'user_id', :dependent => :destroy
-              has_many :memberships, :class_name => 'Member', :foreign_key => 'user_id', :include => [ :project, :roles ], :conditions => "#{Project.table_name}.status<>#{Project::STATUS_ARCHIVED}", :order => "#{Project.table_name}.name"
+              has_many :memberships, :class_name => 'Member',
+                       :foreign_key => 'user_id',
+                       :include => [:project, :roles],
+                       :conditions => "#{Project.table_name}.status<>#{Project::STATUS_ARCHIVED}",
+                       :order => "#{Project.table_name}.name"
               has_many :projects, :through => :memberships
               has_many :issue_categories, :foreign_key => 'assigned_to_id', :dependent => :nullify
               # Groups and active users
               scope :active, lambda { where(:status => STATUS_ACTIVE) }
               scope :like, lambda {|q|
                 q = q.to_s
                 if q.blank?
                   where({})
                 else
                   pattern = "%#{q}%"
                   sql = %w(login firstname lastname mail).map {|column| "LOWER(#{table_name}.#{column}) LIKE LOWER(:p)"}.join(" OR ")
                   params = {:p => pattern}
                   if q =~ /^(.+)\s+(.+)$/
                     a, b = "#{$1}%", "#{$2}%"
                     sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:a) AND LOWER(#{table_name}.lastname) LIKE LOWER(:b))"
                     sql << " OR (LOWER(#{table_name}.firstname) LIKE LOWER(:b) AND LOWER(#{table_name}.lastname) LIKE LOWER(:a))"
                     params.merge!(:a => a, :b => b)
                   end
                   where(sql, params)
                 end
               }
               # Principals that are members of a collection of projects
               scope :member_of, lambda {|projects|
                 projects = [projects] unless projects.is_a?(Array)
                 if projects.empty?
                   where("1=0")
                 else
                   ids = projects.map(&:id)
                   active.uniq.joins(:members).where("#{Member.table_name}.project_id IN (?)", ids)
                 end
               }
               # Principals that are not members of projects
               scope :not_member_of, lambda {|projects|
                 projects = [projects] unless projects.is_a?(Array)
                 if projects.empty?
                   where("1=0")
                 else
                   ids = projects.map(&:id)
                   where("#{Principal.table_name}.id NOT IN (SELECT DISTINCT user_id FROM #{Member.table_name} WHERE project_id IN (?))", ids)
                 end
               }
               scope :sorted, lambda { order(*Principal.fields_for_order_statement)}
               before_create :set_default_empty_values
               def name(formatter = nil)
                 to_s
               end
               def <=>(principal)
                 if principal.nil?
                   -1
                 elsif self.class.name == principal.class.name
                   self.to_s.downcase <=> principal.to_s.downcase
                 else
                   # groups after users
                   principal.class.name <=> self.class.name
                 end
               end
               # Returns an array of fields names than can be used to make an order statement for principals.
               # Users are sorted before Groups.
               # Examples:
               def self.fields_for_order_statement(table=nil)
                 table ||= table_name
                 columns = ['type DESC'] + (User.name_formatter[:order] - ['id']) + ['lastname', 'id']
                 columns.uniq.map {|field| "#{table}.#{field}"}
               end
               protected
               # Make sure we don't try to insert NULL values (see #4632)
               def set_default_empty_values
                 self.login ||= ''
                 self.hashed_password ||= ''
                 self.firstname ||= ''
                 self.lastname ||= ''
                 self.mail ||= ''
                 true
               end
             end