jro_apps/redmine Commit - r1301:80a5ad7ff344

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 Project < ActiveRecord::Base

18

class Project < ActiveRecord::Base

19

# Project statuses

19

# Project statuses

20

STATUS_ACTIVE = 1

20

STATUS_ACTIVE = 1

21

STATUS_ARCHIVED = 9

21

STATUS_ARCHIVED = 9

22

23

has_many :members, :include => :user, :conditions => "#{User.table_name}.status=#{User::STATUS_ACTIVE}"

23

has_many :members, :include => :user, :conditions => "#{User.table_name}.status=#{User::STATUS_ACTIVE}"

24

has_many :users, :through => :members

24

has_many :users, :through => :members

25

has_many :custom_values, :dependent => :delete_all, :as => :customized

25

has_many :custom_values, :dependent => :delete_all, :as => :customized

26

has_many :enabled_modules, :dependent => :delete_all

26

has_many :enabled_modules, :dependent => :delete_all

27

has_and_belongs_to_many :trackers, :order => "#{Tracker.table_name}.position"

27

has_and_belongs_to_many :trackers, :order => "#{Tracker.table_name}.position"

28

has_many :issues, :dependent => :destroy, :order => "#{Issue.table_name}.created_on DESC", :include => [:status, :tracker]

28

has_many :issues, :dependent => :destroy, :order => "#{Issue.table_name}.created_on DESC", :include => [:status, :tracker]

29

has_many :issue_changes, :through => :issues, :source => :journals

29

has_many :issue_changes, :through => :issues, :source => :journals

30

has_many :versions, :dependent => :destroy, :order => "#{Version.table_name}.effective_date DESC, #{Version.table_name}.name DESC"

30

has_many :versions, :dependent => :destroy, :order => "#{Version.table_name}.effective_date DESC, #{Version.table_name}.name DESC"

31

has_many :time_entries, :dependent => :delete_all

31

has_many :time_entries, :dependent => :delete_all

32

has_many :queries, :dependent => :delete_all

32

has_many :queries, :dependent => :delete_all

33

has_many :documents, :dependent => :destroy

33

has_many :documents, :dependent => :destroy

34

has_many :news, :dependent => :delete_all, :include => :author

34

has_many :news, :dependent => :delete_all, :include => :author

35

has_many :issue_categories, :dependent => :delete_all, :order => "#{IssueCategory.table_name}.name"

35

has_many :issue_categories, :dependent => :delete_all, :order => "#{IssueCategory.table_name}.name"

36

has_many :boards, :order => "position ASC"

36

has_many :boards, :dependent => :destroy, :order => "position ASC"

37

has_one :repository, :dependent => :destroy

37

has_one :repository, :dependent => :destroy

38

has_many :changesets, :through => :repository

38

has_many :changesets, :through => :repository

39

has_one :wiki, :dependent => :destroy

39

has_one :wiki, :dependent => :destroy

40

# Custom field for the project issues

40

# Custom field for the project issues

41

has_and_belongs_to_many :custom_fields,

41

has_and_belongs_to_many :custom_fields,

42

:class_name => 'IssueCustomField',

42

:class_name => 'IssueCustomField',

43

:order => "#{CustomField.table_name}.position",

43

:order => "#{CustomField.table_name}.position",

44

:join_table => "#{table_name_prefix}custom_fields_projects#{table_name_suffix}",

44

:join_table => "#{table_name_prefix}custom_fields_projects#{table_name_suffix}",

45

:association_foreign_key => 'custom_field_id'

45

:association_foreign_key => 'custom_field_id'

46

47

acts_as_tree :order => "name", :counter_cache => true

47

acts_as_tree :order => "name", :counter_cache => true

48

49

acts_as_searchable :columns => ['name', 'description'], :project_key => 'id'

49

acts_as_searchable :columns => ['name', 'description'], :project_key => 'id'

50

acts_as_event :title => Proc.new {|o| "#{l(:label_project)}: #{o.name}"},

50

acts_as_event :title => Proc.new {|o| "#{l(:label_project)}: #{o.name}"},

51

:url => Proc.new {|o| {:controller => 'projects', :action => 'show', :id => o.id}}

51

:url => Proc.new {|o| {:controller => 'projects', :action => 'show', :id => o.id}}

52

53

attr_protected :status, :enabled_module_names

53

attr_protected :status, :enabled_module_names

54

55

validates_presence_of :name, :identifier

55

validates_presence_of :name, :identifier

56

validates_uniqueness_of :name, :identifier

56

validates_uniqueness_of :name, :identifier

57

validates_associated :custom_values, :on => :update

57

validates_associated :custom_values, :on => :update

58

validates_associated :repository, :wiki

58

validates_associated :repository, :wiki

59

validates_length_of :name, :maximum => 30

59

validates_length_of :name, :maximum => 30

60

validates_length_of :homepage, :maximum => 60

60

validates_length_of :homepage, :maximum => 60

61

validates_length_of :identifier, :in => 3..20

61

validates_length_of :identifier, :in => 3..20

62

validates_format_of :identifier, :with => /^[a-z0-9\-]*$/

62

validates_format_of :identifier, :with => /^[a-z0-9\-]*$/

63

64

before_destroy :delete_all_members

64

before_destroy :delete_all_members

65

66

def identifier=(identifier)

66

def identifier=(identifier)

67

super unless identifier_frozen?

67

super unless identifier_frozen?

68

end

68

end

69

70

def identifier_frozen?

70

def identifier_frozen?

71

errors[:identifier].nil? && !(new_record? || identifier.blank?)

71

errors[:identifier].nil? && !(new_record? || identifier.blank?)

72

end

72

end

73

74

def issues_with_subprojects(include_subprojects=false)

74

def issues_with_subprojects(include_subprojects=false)

75

conditions = nil

75

conditions = nil

76

if include_subprojects && !active_children.empty?

76

if include_subprojects && !active_children.empty?

77

ids = [id] + active_children.collect {|c| c.id}

77

ids = [id] + active_children.collect {|c| c.id}

78

conditions = ["#{Issue.table_name}.project_id IN (#{ids.join(',')})"]

78

conditions = ["#{Issue.table_name}.project_id IN (#{ids.join(',')})"]

79

end

79

end

80

conditions ||= ["#{Issue.table_name}.project_id = ?", id]

80

conditions ||= ["#{Issue.table_name}.project_id = ?", id]

81

# Quick and dirty fix for Rails 2 compatibility

81

# Quick and dirty fix for Rails 2 compatibility

82

Issue.send(:with_scope, :find => { :conditions => conditions }) do

82

Issue.send(:with_scope, :find => { :conditions => conditions }) do

83

yield

83

yield

84

end

84

end

85

end

85

end

86

87

# returns latest created projects

87

# returns latest created projects

88

# non public projects will be returned only if user is a member of those

88

# non public projects will be returned only if user is a member of those

89

def self.latest(user=nil, count=5)

89

def self.latest(user=nil, count=5)

90

find(:all, :limit => count, :conditions => visible_by(user), :order => "created_on DESC")

90

find(:all, :limit => count, :conditions => visible_by(user), :order => "created_on DESC")

91

end

91

end

92

93

def self.visible_by(user=nil)

93

def self.visible_by(user=nil)

94

if user && user.admin?

94

if user && user.admin?

95

return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}"

95

return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}"

96

elsif user && user.memberships.any?

96

elsif user && user.memberships.any?

97

return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE} AND (#{Project.table_name}.is_public = #{connection.quoted_true} or #{Project.table_name}.id IN (#{user.memberships.collect{|m| m.project_id}.join(',')}))"

97

return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE} AND (#{Project.table_name}.is_public = #{connection.quoted_true} or #{Project.table_name}.id IN (#{user.memberships.collect{|m| m.project_id}.join(',')}))"

98

else

98

else

99

return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE} AND #{Project.table_name}.is_public = #{connection.quoted_true}"

99

return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE} AND #{Project.table_name}.is_public = #{connection.quoted_true}"

100

end

100

end

101

end

101

end

102

103

def self.allowed_to_condition(user, permission, options={})

103

def self.allowed_to_condition(user, permission, options={})

104

statements = []

104

statements = []

105

base_statement = "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}"

105

base_statement = "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}"

106

if options[:project]

106

if options[:project]

107

project_statement = "#{Project.table_name}.id = #{options[:project].id}"

107

project_statement = "#{Project.table_name}.id = #{options[:project].id}"

108

project_statement << " OR #{Project.table_name}.parent_id = #{options[:project].id}" if options[:with_subprojects]

108

project_statement << " OR #{Project.table_name}.parent_id = #{options[:project].id}" if options[:with_subprojects]

109

base_statement = "(#{project_statement}) AND (#{base_statement})"

109

base_statement = "(#{project_statement}) AND (#{base_statement})"

110

end

110

end

111

if user.admin?

111

if user.admin?

112

# no restriction

112

# no restriction

113

elsif user.logged?

113

elsif user.logged?

114

statements << "#{Project.table_name}.is_public = #{connection.quoted_true}" if Role.non_member.allowed_to?(permission)

114

statements << "#{Project.table_name}.is_public = #{connection.quoted_true}" if Role.non_member.allowed_to?(permission)

115

allowed_project_ids = user.memberships.select {|m| m.role.allowed_to?(permission)}.collect {|m| m.project_id}

115

allowed_project_ids = user.memberships.select {|m| m.role.allowed_to?(permission)}.collect {|m| m.project_id}

116

statements << "#{Project.table_name}.id IN (#{allowed_project_ids.join(',')})" if allowed_project_ids.any?

116

statements << "#{Project.table_name}.id IN (#{allowed_project_ids.join(',')})" if allowed_project_ids.any?

117

elsif Role.anonymous.allowed_to?(permission)

117

elsif Role.anonymous.allowed_to?(permission)

118

# anonymous user allowed on public project

118

# anonymous user allowed on public project

119

statements << "#{Project.table_name}.is_public = #{connection.quoted_true}"

119

statements << "#{Project.table_name}.is_public = #{connection.quoted_true}"

120

else

120

else

121

# anonymous user is not authorized

121

# anonymous user is not authorized

122

statements << "1=0"

122

statements << "1=0"

123

end

123

end

124

statements.empty? ? base_statement : "((#{base_statement}) AND (#{statements.join(' OR ')}))"

124

statements.empty? ? base_statement : "((#{base_statement}) AND (#{statements.join(' OR ')}))"

125

end

125

end

126

127

def project_condition(with_subprojects)

127

def project_condition(with_subprojects)

128

cond = "#{Project.table_name}.id = #{id}"

128

cond = "#{Project.table_name}.id = #{id}"

129

cond = "(#{cond} OR #{Project.table_name}.parent_id = #{id})" if with_subprojects

129

cond = "(#{cond} OR #{Project.table_name}.parent_id = #{id})" if with_subprojects

130

cond

130

cond

131

end

131

end

132

133

def self.find(*args)

133

def self.find(*args)

134

if args.first && args.first.is_a?(String) && !args.first.match(/^\d*$/)

134

if args.first && args.first.is_a?(String) && !args.first.match(/^\d*$/)

135

project = find_by_identifier(*args)

135

project = find_by_identifier(*args)

136

raise ActiveRecord::RecordNotFound, "Couldn't find Project with identifier=#{args.first}" if project.nil?

136

raise ActiveRecord::RecordNotFound, "Couldn't find Project with identifier=#{args.first}" if project.nil?

137

project

137

project

138

else

138

else

139

super

139

super

140

end

140

end

141

end

141

end

142

143

def to_param

143

def to_param

144

identifier

144

identifier

145

end

145

end

146

147

def active?

147

def active?

148

self.status == STATUS_ACTIVE

148

self.status == STATUS_ACTIVE

149

end

149

end

150

151

def archive

151

def archive

152

# Archive subprojects if any

152

# Archive subprojects if any

153

children.each do |subproject|

153

children.each do |subproject|

154

subproject.archive

154

subproject.archive

155

end

155

end

156

update_attribute :status, STATUS_ARCHIVED

156

update_attribute :status, STATUS_ARCHIVED

157

end

157

end

158

159

def unarchive

159

def unarchive

160

return false if parent && !parent.active?

160

return false if parent && !parent.active?

161

update_attribute :status, STATUS_ACTIVE

161

update_attribute :status, STATUS_ACTIVE

162

end

162

end

163

164

def active_children

164

def active_children

165

children.select {|child| child.active?}

165

children.select {|child| child.active?}

166

end

166

end

167

168

# Returns an array of the trackers used by the project and its sub projects

168

# Returns an array of the trackers used by the project and its sub projects

169

def rolled_up_trackers

169

def rolled_up_trackers

170

@rolled_up_trackers ||=

170

@rolled_up_trackers ||=

171

Tracker.find(:all, :include => :projects,

171

Tracker.find(:all, :include => :projects,

172

:select => "DISTINCT #{Tracker.table_name}.*",

172

:select => "DISTINCT #{Tracker.table_name}.*",

173

:conditions => ["#{Project.table_name}.id = ? OR #{Project.table_name}.parent_id = ?", id, id],

173

:conditions => ["#{Project.table_name}.id = ? OR #{Project.table_name}.parent_id = ?", id, id],

174

:order => "#{Tracker.table_name}.position")

174

:order => "#{Tracker.table_name}.position")

175

end

175

end

176

177

# Deletes all project's members

177

# Deletes all project's members

178

def delete_all_members

178

def delete_all_members

179

Member.delete_all(['project_id = ?', id])

179

Member.delete_all(['project_id = ?', id])

180

end

180

end

181

182

# Users issues can be assigned to

182

# Users issues can be assigned to

183

def assignable_users

183

def assignable_users

184

members.select {|m| m.role.assignable?}.collect {|m| m.user}.sort

184

members.select {|m| m.role.assignable?}.collect {|m| m.user}.sort

185

end

185

end

186

187

# Returns the mail adresses of users that should be always notified on project events

187

# Returns the mail adresses of users that should be always notified on project events

188

def recipients

188

def recipients

189

members.select {|m| m.mail_notification? || m.user.mail_notification?}.collect {|m| m.user.mail}

189

members.select {|m| m.mail_notification? || m.user.mail_notification?}.collect {|m| m.user.mail}

190

end

190

end

191

192

# Returns an array of all custom fields enabled for project issues

192

# Returns an array of all custom fields enabled for project issues

193

# (explictly associated custom fields and custom fields enabled for all projects)

193

# (explictly associated custom fields and custom fields enabled for all projects)

194

def custom_fields_for_issues(tracker)

194

def custom_fields_for_issues(tracker)

195

all_custom_fields.select {|c| tracker.custom_fields.include? c }

195

all_custom_fields.select {|c| tracker.custom_fields.include? c }

196

end

196

end

197

198

def all_custom_fields

198

def all_custom_fields

199

@all_custom_fields ||= (IssueCustomField.for_all + custom_fields).uniq

199

@all_custom_fields ||= (IssueCustomField.for_all + custom_fields).uniq

200

end

200

end

201

202

def <=>(project)

202

def <=>(project)

203

name.downcase <=> project.name.downcase

203

name.downcase <=> project.name.downcase

204

end

204

end

205

206

def to_s

206

def to_s

207

name

207

name

208

end

208

end

209

210

# Returns a short description of the projects (first lines)

210

# Returns a short description of the projects (first lines)

211

def short_description(length = 255)

211

def short_description(length = 255)

212

description.gsub(/^(.{#{length}}[^\n]*).*$/m, '\1').strip if description

212

description.gsub(/^(.{#{length}}[^\n]*).*$/m, '\1').strip if description

213

end

213

end

214

215

def allows_to?(action)

215

def allows_to?(action)

216

if action.is_a? Hash

216

if action.is_a? Hash

217

allowed_actions.include? "#{action[:controller]}/#{action[:action]}"

217

allowed_actions.include? "#{action[:controller]}/#{action[:action]}"

218

else

218

else

219

allowed_permissions.include? action

219

allowed_permissions.include? action

220

end

220

end

221

end

221

end

222

223

def module_enabled?(module_name)

223

def module_enabled?(module_name)

224

module_name = module_name.to_s

224

module_name = module_name.to_s

225

enabled_modules.detect {|m| m.name == module_name}

225

enabled_modules.detect {|m| m.name == module_name}

226

end

226

end

227

228

def enabled_module_names=(module_names)

228

def enabled_module_names=(module_names)

229

enabled_modules.clear

229

enabled_modules.clear

230

module_names = [] unless module_names && module_names.is_a?(Array)

230

module_names = [] unless module_names && module_names.is_a?(Array)

231

module_names.each do |name|

231

module_names.each do |name|

232

enabled_modules << EnabledModule.new(:name => name.to_s)

232

enabled_modules << EnabledModule.new(:name => name.to_s)

233

end

233

end

234

end

234

end

235

236

protected

236

protected

237

def validate

237

def validate

238

errors.add(parent_id, " must be a root project") if parent and parent.parent

238

errors.add(parent_id, " must be a root project") if parent and parent.parent

239

errors.add_to_base("A project with subprojects can't be a subproject") if parent and children.size > 0

239

errors.add_to_base("A project with subprojects can't be a subproject") if parent and children.size > 0

240

errors.add(:identifier, :activerecord_error_invalid) if !identifier.blank? && identifier.match(/^\d*$/)

240

errors.add(:identifier, :activerecord_error_invalid) if !identifier.blank? && identifier.match(/^\d*$/)

241

end

241

end

242

243

private

243

private

244

def allowed_permissions

244

def allowed_permissions

245

@allowed_permissions ||= begin

245

@allowed_permissions ||= begin

246

module_names = enabled_modules.collect {|m| m.name}

246

module_names = enabled_modules.collect {|m| m.name}

247

Redmine::AccessControl.modules_permissions(module_names).collect {|p| p.name}

247

Redmine::AccessControl.modules_permissions(module_names).collect {|p| p.name}

248

end

248

end

249

end

249

end

250

251

def allowed_actions

251

def allowed_actions

252

@actions_allowed ||= allowed_permissions.inject([]) { |actions, permission| actions += Redmine::AccessControl.allowed_actions(permission) }.flatten

252

@actions_allowed ||= allowed_permissions.inject([]) { |actions, permission| actions += Redmine::AccessControl.allowed_actions(permission) }.flatten

253

end

253

end

254

end

254

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  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 Project < ActiveRecord::Base
               # Project statuses
               STATUS_ACTIVE     = 1
               STATUS_ARCHIVED   = 9
               has_many :members, :include => :user, :conditions => "#{User.table_name}.status=#{User::STATUS_ACTIVE}"
               has_many :users, :through => :members
               has_many :custom_values, :dependent => :delete_all, :as => :customized
               has_many :enabled_modules, :dependent => :delete_all
               has_and_belongs_to_many :trackers, :order => "#{Tracker.table_name}.position"
               has_many :issues, :dependent => :destroy, :order => "#{Issue.table_name}.created_on DESC", :include => [:status, :tracker]
               has_many :issue_changes, :through => :issues, :source => :journals
               has_many :versions, :dependent => :destroy, :order => "#{Version.table_name}.effective_date DESC, #{Version.table_name}.name DESC"
               has_many :time_entries, :dependent => :delete_all
               has_many :queries, :dependent => :delete_all
               has_many :documents, :dependent => :destroy
               has_many :news, :dependent => :delete_all, :include => :author
               has_many :issue_categories, :dependent => :delete_all, :order => "#{IssueCategory.table_name}.name"
-              has_many :boards, :order => "position ASC"
+              has_many :boards, :dependent => :destroy, :order => "position ASC"
               has_one :repository, :dependent => :destroy
               has_many :changesets, :through => :repository
               has_one :wiki, :dependent => :destroy
               # Custom field for the project issues
               has_and_belongs_to_many :custom_fields,
                                       :class_name => 'IssueCustomField',
                                       :order => "#{CustomField.table_name}.position",
                                       :join_table => "#{table_name_prefix}custom_fields_projects#{table_name_suffix}",
                                       :association_foreign_key => 'custom_field_id'
               acts_as_tree :order => "name", :counter_cache => true
               acts_as_searchable :columns => ['name', 'description'], :project_key => 'id'
               acts_as_event :title => Proc.new {|o| "#{l(:label_project)}: #{o.name}"},
                             :url => Proc.new {|o| {:controller => 'projects', :action => 'show', :id => o.id}}
               attr_protected :status, :enabled_module_names
               validates_presence_of :name, :identifier
               validates_uniqueness_of :name, :identifier
               validates_associated :custom_values, :on => :update
               validates_associated :repository, :wiki
               validates_length_of :name, :maximum => 30
               validates_length_of :homepage, :maximum => 60
               validates_length_of :identifier, :in => 3..20
               validates_format_of :identifier, :with => /^[a-z0-9\-]*$/
               before_destroy :delete_all_members
               def identifier=(identifier)
                 super unless identifier_frozen?
               end
               def identifier_frozen?
                 errors[:identifier].nil? && !(new_record? || identifier.blank?)
               end
               def issues_with_subprojects(include_subprojects=false)
                 conditions = nil
                 if include_subprojects && !active_children.empty?
                   ids = [id] + active_children.collect {|c| c.id}
                   conditions = ["#{Issue.table_name}.project_id IN (#{ids.join(',')})"]
                 end
                 conditions ||= ["#{Issue.table_name}.project_id = ?", id]
                 # Quick and dirty fix for Rails 2 compatibility
                 Issue.send(:with_scope, :find => { :conditions => conditions }) do
                   yield
                 end
               end
               # returns latest created projects
               # non public projects will be returned only if user is a member of those
               def self.latest(user=nil, count=5)
                 find(:all, :limit => count, :conditions => visible_by(user), :order => "created_on DESC")
               end
               def self.visible_by(user=nil)
                 if user && user.admin?
                   return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}"
                 elsif user && user.memberships.any?
                   return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE} AND (#{Project.table_name}.is_public = #{connection.quoted_true} or #{Project.table_name}.id IN (#{user.memberships.collect{|m| m.project_id}.join(',')}))"
                 else
                   return "#{Project.table_name}.status=#{Project::STATUS_ACTIVE} AND #{Project.table_name}.is_public = #{connection.quoted_true}"
                 end
               end
               def self.allowed_to_condition(user, permission, options={})
                 statements = []
                 base_statement = "#{Project.table_name}.status=#{Project::STATUS_ACTIVE}"
                 if options[:project]
                   project_statement = "#{Project.table_name}.id = #{options[:project].id}"
                   project_statement << " OR #{Project.table_name}.parent_id = #{options[:project].id}" if options[:with_subprojects]
                   base_statement = "(#{project_statement}) AND (#{base_statement})"
                 end
                 if user.admin?
                   # no restriction
                 elsif user.logged?
                   statements << "#{Project.table_name}.is_public = #{connection.quoted_true}" if Role.non_member.allowed_to?(permission)
                   allowed_project_ids = user.memberships.select {|m| m.role.allowed_to?(permission)}.collect {|m| m.project_id}
                   statements << "#{Project.table_name}.id IN (#{allowed_project_ids.join(',')})" if allowed_project_ids.any?
                 elsif Role.anonymous.allowed_to?(permission)
                   # anonymous user allowed on public project
                   statements << "#{Project.table_name}.is_public = #{connection.quoted_true}"
                 else
                   # anonymous user is not authorized
                   statements << "1=0"
                 end
                 statements.empty? ? base_statement : "((#{base_statement}) AND (#{statements.join(' OR ')}))"
               end
               def project_condition(with_subprojects)
                 cond = "#{Project.table_name}.id = #{id}"
                 cond = "(#{cond} OR #{Project.table_name}.parent_id = #{id})" if with_subprojects
                 cond
               end
               def self.find(*args)
                 if args.first && args.first.is_a?(String) && !args.first.match(/^\d*$/)
                   project = find_by_identifier(*args)
                   raise ActiveRecord::RecordNotFound, "Couldn't find Project with identifier=#{args.first}" if project.nil?
                   project
                 else
                   super
                 end
               end
               def to_param
                 identifier
               end
               def active?
                 self.status == STATUS_ACTIVE
               end
               def archive
                 # Archive subprojects if any
                 children.each do |subproject|
                   subproject.archive
                 end
                 update_attribute :status, STATUS_ARCHIVED
               end
               def unarchive
                 return false if parent && !parent.active?
                 update_attribute :status, STATUS_ACTIVE
               end
               def active_children
                 children.select {|child| child.active?}
               end
               # Returns an array of the trackers used by the project and its sub projects
               def rolled_up_trackers
                 @rolled_up_trackers ||=
                   Tracker.find(:all, :include => :projects,
                                      :select => "DISTINCT #{Tracker.table_name}.*",
                                      :conditions => ["#{Project.table_name}.id = ? OR #{Project.table_name}.parent_id = ?", id, id],
                                      :order => "#{Tracker.table_name}.position")
               end
               # Deletes all project's members
               def delete_all_members
                 Member.delete_all(['project_id = ?', id])
               end
               # Users issues can be assigned to
               def assignable_users
                 members.select {|m| m.role.assignable?}.collect {|m| m.user}.sort
               end
               # Returns the mail adresses of users that should be always notified on project events
               def recipients
                 members.select {|m| m.mail_notification? || m.user.mail_notification?}.collect {|m| m.user.mail}
               end
               # Returns an array of all custom fields enabled for project issues
               # (explictly associated custom fields and custom fields enabled for all projects)
               def custom_fields_for_issues(tracker)
                 all_custom_fields.select {|c| tracker.custom_fields.include? c }
               end
               def all_custom_fields
                 @all_custom_fields ||= (IssueCustomField.for_all + custom_fields).uniq
               end
               def <=>(project)
                 name.downcase <=> project.name.downcase
               end
               def to_s
                 name
               end
               # Returns a short description of the projects (first lines)
               def short_description(length = 255)
                 description.gsub(/^(.{#{length}}[^\n]*).*$/m, '\1').strip if description
               end
               def allows_to?(action)
                 if action.is_a? Hash
                   allowed_actions.include? "#{action[:controller]}/#{action[:action]}"
                 else
                   allowed_permissions.include? action
                 end
               end
               def module_enabled?(module_name)
                 module_name = module_name.to_s
                 enabled_modules.detect {|m| m.name == module_name}
               end
               def enabled_module_names=(module_names)
                 enabled_modules.clear
                 module_names = [] unless module_names && module_names.is_a?(Array)
                 module_names.each do |name|
                   enabled_modules << EnabledModule.new(:name => name.to_s)
                 end
               end
             protected
               def validate
                 errors.add(parent_id, " must be a root project") if parent and parent.parent
                 errors.add_to_base("A project with subprojects can't be a subproject") if parent and children.size > 0
                 errors.add(:identifier, :activerecord_error_invalid) if !identifier.blank? && identifier.match(/^\d*$/)
               end
             private
               def allowed_permissions
                 @allowed_permissions ||= begin
                   module_names = enabled_modules.collect {|m| m.name}
                   Redmine::AccessControl.modules_permissions(module_names).collect {|p| p.name}
                 end
               end
               def allowed_actions
                 @actions_allowed ||= allowed_permissions.inject([]) { |actions, permission| actions += Redmine::AccessControl.allowed_actions(permission) }.flatten
               end
             end

             # redMine - project management software
             # Copyright (C) 2006-2007  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.
             require File.dirname(__FILE__) + '/../test_helper'
             class ProjectTest < Test::Unit::TestCase
-              fixtures :projects, :issues, :issue_statuses, :journals, :journal_details, :users, :members, :roles, :projects_trackers, :trackers
+              fixtures :projects, :issues, :issue_statuses, :journals, :journal_details, :users, :members, :roles, :projects_trackers, :trackers, :boards
               def setup
                 @ecookbook = Project.find(1)
                 @ecookbook_sub1 = Project.find(3)
               end
               def test_truth
                 assert_kind_of Project, @ecookbook
                 assert_equal "eCookbook", @ecookbook.name
               end
               def test_update
                 assert_equal "eCookbook", @ecookbook.name
                 @ecookbook.name = "eCook"
                 assert @ecookbook.save, @ecookbook.errors.full_messages.join("; ")
                 @ecookbook.reload
                 assert_equal "eCook", @ecookbook.name
               end
               def test_validate
                 @ecookbook.name = ""
                 assert !@ecookbook.save
                 assert_equal 1, @ecookbook.errors.count
                 assert_equal "activerecord_error_blank", @ecookbook.errors.on(:name)
               end
               def test_public_projects
                 public_projects = Project.find(:all, :conditions => ["is_public=?", true])
                 assert_equal 3, public_projects.length
                 assert_equal true, public_projects[0].is_public?
               end
               def test_archive
                 user = @ecookbook.members.first.user
                 @ecookbook.archive
                 @ecookbook.reload
                 assert !@ecookbook.active?
                 assert !user.projects.include?(@ecookbook)
                 # Subproject are also archived
                 assert !@ecookbook.children.empty?
                 assert @ecookbook.active_children.empty?
               end
               def test_unarchive
                 user = @ecookbook.members.first.user
                 @ecookbook.archive
                 # A subproject of an archived project can not be unarchived
                 assert !@ecookbook_sub1.unarchive
                 # Unarchive project
                 assert @ecookbook.unarchive
                 @ecookbook.reload
                 assert @ecookbook.active?
                 assert user.projects.include?(@ecookbook)
                 # Subproject can now be unarchived
                 @ecookbook_sub1.reload
                 assert @ecookbook_sub1.unarchive
               end
               def test_destroy
                 # 2 active members
                 assert_equal 2, @ecookbook.members.size
                 # and 1 is locked
                 assert_equal 3, Member.find(:all, :conditions => ['project_id = ?', @ecookbook.id]).size
+                # some boards
+                assert @ecookbook.boards.any?
                 @ecookbook.destroy
                 # make sure that the project non longer exists
                 assert_raise(ActiveRecord::RecordNotFound) { Project.find(@ecookbook.id) }
-                # make sure all members have been removed
+                # make sure related data was removed
-                assert_equal 0, Member.find(:all, :conditions => ['project_id = ?', @ecookbook.id]).size
+                assert Member.find(:all, :conditions => ['project_id = ?', @ecookbook.id]).empty?
+                assert Board.find(:all, :conditions => ['project_id = ?', @ecookbook.id]).empty?
               end
               def test_subproject_ok
                 sub = Project.find(2)
                 sub.parent = @ecookbook
                 assert sub.save
                 assert_equal @ecookbook.id, sub.parent.id
                 @ecookbook.reload
                 assert_equal 3, @ecookbook.children.size
               end
               def test_subproject_invalid
                 sub = Project.find(2)
                 sub.parent = @ecookbook_sub1
                 assert !sub.save
               end
               def test_subproject_invalid_2
                 sub = @ecookbook
                 sub.parent = Project.find(2)
                 assert !sub.save
               end
               def test_rolled_up_trackers
                 parent = Project.find(1)
                 child = parent.children.find(3)
                 assert_equal [1, 2], parent.tracker_ids
                 assert_equal [2, 3], child.tracker_ids
                 assert_kind_of Tracker, parent.rolled_up_trackers.first
                 assert_equal Tracker.find(1), parent.rolled_up_trackers.first
                 assert_equal [1, 2, 3], parent.rolled_up_trackers.collect(&:id)
                 assert_equal [2, 3], child.rolled_up_trackers.collect(&:id)
               end
             end