1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
|
# This Source Code Form is subject to the terms of the Mozilla Public
# License, v. 2.0. If a copy of the MPL was not distributed with this
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
# This Source Code Form is "Incompatible With Secondary Licenses", as
# defined by the Mozilla Public License, v. 2.0.
package Bugzilla::Extension::TrackingFlags::Flag;
use base qw(Bugzilla::Object);
use strict;
use warnings;
use Bugzilla::Error;
use Bugzilla::Constants;
use Bugzilla::Util qw(detaint_natural trim);
use Bugzilla::Extension::TrackingFlags::Constants;
use Bugzilla::Extension::TrackingFlags::Flag::Bug;
use Bugzilla::Extension::TrackingFlags::Flag::Value;
use Bugzilla::Extension::TrackingFlags::Flag::Visibility;
###############################
#### Initialization ####
###############################
use constant DB_TABLE => 'tracking_flags';
use constant DB_COLUMNS => qw(
id
field_id
name
description
type
sortkey
is_active
);
use constant LIST_ORDER => 'sortkey';
use constant UPDATE_COLUMNS => qw(
name
description
type
sortkey
is_active
);
use constant VALIDATORS => {
name => \&_check_name,
description => \&_check_description,
type => \&_check_type,
sortkey => \&_check_sortkey,
is_active => \&Bugzilla::Object::check_boolean,
};
use constant UPDATE_VALIDATORS => {
name => \&_check_name,
description => \&_check_description,
type => \&_check_type,
sortkey => \&_check_sortkey,
is_active => \&Bugzilla::Object::check_boolean,
};
###############################
#### Methods ####
###############################
sub new {
my $class = shift;
my $param = shift;
my $cache = Bugzilla->request_cache;
if (!ref $param
&& exists $cache->{'tracking_flags'}
&& exists $cache->{'tracking_flags'}->{$param})
{
return $cache->{'tracking_flags'}->{$param};
}
return $class->SUPER::new($param);
}
sub create {
my $class = shift;
my $params = shift;
my $dbh = Bugzilla->dbh;
$dbh->bz_start_transaction();
$params = $class->run_create_validators($params);
# We have to create an entry for this new flag
# in the fielddefs table for use elsewhere. We cannot
# use Bugzilla::Field->create as it will create the
# additional tables needed by custom fields which we
# do not need. Also we do this so as not to add a
# another column to the bugs table.
# We will create the entry as a custom field with a
# type of FIELD_TYPE_EXTENSION so Bugzilla will skip
# these field types in certain parts of the core code.
$dbh->do("INSERT INTO fielddefs
(name, description, sortkey, type, custom, obsolete, buglist)
VALUES
(?, ?, ?, ?, ?, ?, ?)",
undef,
$params->{'name'},
$params->{'description'},
$params->{'sortkey'},
FIELD_TYPE_EXTENSION,
1, 0, 1);
$params->{'field_id'} = $dbh->bz_last_key;
my $flag = $class->SUPER::create($params);
$dbh->bz_commit_transaction();
return $flag;
}
sub update {
my $self = shift;
my $dbh = Bugzilla->dbh;
my $old_self = $self->new($self->flag_id);
# HACK! Bugzilla::Object::update uses hardcoded $self->id
# instead of $self->{ID_FIELD} so we need to reverse field_id
# and the real id temporarily
my $field_id = $self->id;
$self->{'field_id'} = $self->{'id'};
my $changes = $self->SUPER::update(@_);
$self->{'field_id'} = $field_id;
# Update the fielddefs entry
$dbh->do("UPDATE fielddefs SET name = ?, description = ? WHERE name = ?",
undef,
$self->name, $self->description, $old_self->name);
# Update request_cache
my $cache = Bugzilla->request_cache;
if (exists $cache->{'tracking_flags'}) {
$cache->{'tracking_flags'}->{$self->flag_id} = $self;
}
return $changes;
}
sub match {
my $class = shift;
my ($params) = @_;
# Use later for preload
my $bug_id = delete $params->{'bug_id'};
# Retrieve all flags relevant for the given product and component
if (!exists $params->{'id'}
&& ($params->{'component'} || $params->{'component_id'}
|| $params->{'product'} || $params->{'product_id'}))
{
my $visible_flags
= Bugzilla::Extension::TrackingFlags::Flag::Visibility->match(@_);
my @flag_ids = map { $_->tracking_flag_id } @$visible_flags;
delete $params->{'component'} if exists $params->{'component'};
delete $params->{'component_id'} if exists $params->{'component_id'};
delete $params->{'product'} if exists $params->{'product'};
delete $params->{'product_id'} if exists $params->{'product_id'};
$params->{'id'} = \@flag_ids;
}
my $flags = $class->SUPER::match(@_);
preload_all_the_things($flags, { bug_id => $bug_id });
return [ sort { $a->sortkey <=> $b->sortkey } @$flags ];
}
sub get_all {
my $self = shift;
my $cache = Bugzilla->request_cache;
if (!exists $cache->{'tracking_flags'}) {
my @tracking_flags = $self->SUPER::get_all(@_);
preload_all_the_things(\@tracking_flags);
my %tracking_flags_hash = map { $_->flag_id => $_ } @tracking_flags;
$cache->{'tracking_flags'} = \%tracking_flags_hash;
}
return sort { $a->flag_type cmp $b->flag_type || $a->sortkey <=> $b->sortkey }
values %{ $cache->{'tracking_flags'} };
}
sub remove_from_db {
my $self = shift;
my $dbh = Bugzilla->dbh;
$dbh->bz_start_transaction();
$dbh->do('DELETE FROM fielddefs WHERE name = ?', undef, $self->name);
$self->SUPER::remove_from_db(@_);
$dbh->bz_commit_transaction();
# Remove from request cache
my $cache = Bugzilla->request_cache;
if (exists $cache->{'tracking_flags'}) {
delete $cache->{'tracking_flags'}->{$self->flag_id};
}
}
sub preload_all_the_things {
my ($flags, $params) = @_;
my %flag_hash = map { $_->flag_id => $_ } @$flags;
my @flag_ids = keys %flag_hash;
return unless @flag_ids;
# Preload values
my $value_objects
= Bugzilla::Extension::TrackingFlags::Flag::Value->match({ tracking_flag_id => \@flag_ids });
# Now populate the tracking flags with this set of value objects.
foreach my $obj (@$value_objects) {
my $flag_id = $obj->tracking_flag_id;
# Prepopulate the tracking flag object in the value object
$obj->{'tracking_flag'} = $flag_hash{$flag_id};
# Prepopulate the current value objects for this tracking flag
$flag_hash{$flag_id}->{'values'} ||= [];
push(@{$flag_hash{$flag_id}->{'values'}}, $obj);
}
# Preload bug values if a bug_id is passed
if ($params && exists $params->{'bug_id'} && $params->{'bug_id'}) {
# We don't want to use @flag_ids here as we want all flags attached to this bug
# even if they are inactive.
my $bug_objects
= Bugzilla::Extension::TrackingFlags::Flag::Bug->match({ bug_id => $params->{'bug_id'} });
# Now populate the tracking flags with this set of objects.
# Also we add them to the flag hash since we want them to be visible even if
# they are not longer applicable to this product/component.
foreach my $obj (@$bug_objects) {
my $flag_id = $obj->tracking_flag_id;
# Prepopulate the tracking flag object in the bug flag object
$obj->{'tracking_flag'} = $flag_hash{$flag_id};
# Prepopulate the the current bug flag object for the tracking flag
$flag_hash{$flag_id}->{'bug_flag'} = $obj;
}
}
@$flags = values %flag_hash;
}
###############################
#### Validators ####
###############################
sub _check_name {
my ($invocant, $name) = @_;
$name = trim($name);
$name || ThrowCodeError('param_required', { param => 'name' });
return $name;
}
sub _check_description {
my ($invocant, $description) = @_;
$description = trim($description);
$description || ThrowCodeError( 'param_required', { param => 'description' } );
return $description;
}
sub _check_type {
my ($invocant, $type) = @_;
$type = trim($type);
$type || ThrowCodeError( 'param_required', { param => 'type' } );
grep($_->{name} eq $type, @{FLAG_TYPES()})
|| ThrowUserError('tracking_flags_invalid_flag_type', { type => $type });
return $type;
}
sub _check_sortkey {
my ($invocant, $sortkey) = @_;
detaint_natural($sortkey)
|| ThrowUserError('field_invalid_sortkey', { sortkey => $sortkey });
return $sortkey;
}
###############################
#### Setters ####
###############################
sub set_name { $_[0]->set('name', $_[1]); }
sub set_description { $_[0]->set('description', $_[1]); }
sub set_type { $_[0]->set('type', $_[1]); }
sub set_sortkey { $_[0]->set('sortkey', $_[1]); }
sub set_is_active { $_[0]->set('is_active', $_[1]); }
###############################
#### Accessors ####
###############################
sub flag_id { return $_[0]->{'id'}; }
sub name { return $_[0]->{'name'}; }
sub description { return $_[0]->{'description'}; }
sub flag_type { return $_[0]->{'type'}; }
sub sortkey { return $_[0]->{'sortkey'}; }
sub is_active { return $_[0]->{'is_active'}; }
sub values {
return $_[0]->{'values'} ||= Bugzilla::Extension::TrackingFlags::Flag::Value->match({
tracking_flag_id => $_[0]->flag_id
});
}
sub visibility {
return $_[0]->{'visibility'} ||= Bugzilla::Extension::TrackingFlags::Flag::Visibility->match({
tracking_flag_id => $_[0]->flag_id
});
}
sub can_set_value {
my ($self, $new_value, $user) = @_;
$user ||= Bugzilla->user;
my $new_value_obj;
foreach my $value (@{$self->values}) {
if ($value->value eq $new_value) {
$new_value_obj = $value;
last;
}
}
return $new_value_obj && $user->in_group($new_value_obj->setter_group->name)
? 1
: 0;
}
sub bug_flag {
my ($self, $bug_id) = @_;
# Return the current bug value object if defined unless the passed bug_id does
# not equal the current bug value objects id.
if (defined $self->{'bug_flag'}
&& (!$bug_id || $self->{'bug_flag'}->bug->id == $bug_id))
{
return $self->{'bug_flag'};
}
# Flag::Bug->new will return a default bug value object if $params undefined
my $params = !$bug_id
? undef
: { condition => "tracking_flag_id = ? AND bug_id = ?",
values => [ $self->flag_id, $bug_id ] };
return $self->{'bug_flag'} = Bugzilla::Extension::TrackingFlags::Flag::Bug->new($params);
}
sub has_values {
my ($self) = @_;
return $self->{'has_values'} if defined $self->{'has_values'};
my $dbh = Bugzilla->dbh;
$self->{'has_values'} = scalar $dbh->selectrow_array("
SELECT 1
FROM tracking_flags_bugs
WHERE tracking_flag_id = ? " .
$dbh->sql_limit(1),
undef, $self->flag_id);
return $self->{'has_values'};
}
######################################
# Compatibility with Bugzilla::Field #
######################################
# Here we return 'field_id' instead of the real
# id as we want other Bugzilla code to treat this
# as a Bugzilla::Field object in certain places.
sub id { return $_[0]->{'field_id'}; }
sub type { return FIELD_TYPE_EXTENSION; }
sub legal_values { return $_[0]->values; }
sub custom { return 1; }
sub in_new_bugmail { return 1; }
sub obsolete { return 0; }
sub enter_bug { return 1; }
sub buglist { return 1; }
sub is_select { return 1; }
sub is_abnormal { return 1; }
sub is_timetracking { return 0; }
sub visibility_field { return undef; }
sub visibility_values { return undef; }
sub controls_visibility_of { return undef; }
sub value_field { return undef; }
sub controls_values_of { return undef; }
sub is_visible_on_bug { return 1; }
sub is_relationship { return 0; }
sub reverse_desc { return ''; }
sub is_mandatory { return 0; }
sub is_numeric { return 0; }
1;
|