jro_apps/redmine Commit - r3229:12ea682b6639

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

set_table_name 'users'

19

set_table_name 'users'

20

21

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

21

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

22

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

22

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

23

has_many :projects, :through => :memberships

23

has_many :projects, :through => :memberships

24

25

# Groups and active users

25

# Groups and active users

26

named_scope :active, :conditions => "#{Principal.table_name}.type='Group' OR (#{Principal.table_name}.type='User' AND #{Principal.table_name}.status = 1)"

26

named_scope :active, :conditions => "#{Principal.table_name}.type='Group' OR (#{Principal.table_name}.type='User' AND #{Principal.table_name}.status = 1)"

27

28

named_scope :like, lambda {|q|

28

named_scope :like, lambda {|q|

29

s = "%#{q.to_s.strip.downcase}%"

29

s = "%#{q.to_s.strip.downcase}%"

30

{:conditions => ["LOWER(login) LIKE :s OR LOWER(firstname) LIKE :s OR LOWER(lastname) LIKE :s OR LOWER(mail) LIKE :s", {:s => s}],

30

{:conditions => ["LOWER(login) LIKE :s OR LOWER(firstname) LIKE :s OR LOWER(lastname) LIKE :s OR LOWER(mail) LIKE :s", {:s => s}],

31

:order => 'type, login, lastname, firstname, mail'

31

:order => 'type, login, lastname, firstname, mail'

32

}

32

}

33

}

33

}

34

35

before_create :set_default_empty_values

36

35

def <=>(principal)

37

def <=>(principal)

36

if self.class.name == principal.class.name

38

if self.class.name == principal.class.name

37

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

39

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

38

else

40

else

39

# groups after users

41

# groups after users

40

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

42

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

41

end

43

end

42

end

44

end

45

46

protected

47

48

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

49

def set_default_empty_values

50

self.login ||= ''

51

self.hashed_password ||= ''

52

self.firstname ||= ''

53

self.lastname ||= ''

54

self.mail ||= ''

55

true

56

end

43

end

57

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-2009  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
               set_table_name 'users'
               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_ACTIVE}", :order => "#{Project.table_name}.name"
               has_many :projects, :through => :memberships
               # Groups and active users
               named_scope :active, :conditions => "#{Principal.table_name}.type='Group' OR (#{Principal.table_name}.type='User' AND #{Principal.table_name}.status = 1)"
               named_scope :like, lambda {|q|
                 s = "%#{q.to_s.strip.downcase}%"
                 {:conditions => ["LOWER(login) LIKE :s OR LOWER(firstname) LIKE :s OR LOWER(lastname) LIKE :s OR LOWER(mail) LIKE :s", {:s => s}],
                  :order => 'type, login, lastname, firstname, mail'
                 }
               }
+              before_create :set_default_empty_values
               def <=>(principal)
                 if 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
+              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