forked from bugzilla/bugzilla
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy patheditworkflow.cgi
More file actions
executable file
·140 lines (122 loc) · 4.59 KB
/
editworkflow.cgi
File metadata and controls
executable file
·140 lines (122 loc) · 4.59 KB
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
#!/usr/bin/perl -T
# 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.
use 5.10.1;
use strict;
use warnings;
use lib qw(. lib);
use Bugzilla;
use Bugzilla::Constants;
use Bugzilla::Error;
use Bugzilla::Token;
use Bugzilla::Status;
my $cgi = Bugzilla->cgi;
my $dbh = Bugzilla->dbh;
my $user = Bugzilla->login(LOGIN_REQUIRED);
print $cgi->header();
$user->in_group('admin')
|| ThrowUserError('auth_failure', {group => 'admin',
action => 'modify',
object => 'workflow'});
my $action = $cgi->param('action') || 'edit';
my $token = $cgi->param('token');
sub get_workflow {
my $dbh = Bugzilla->dbh;
my $workflow = $dbh->selectall_arrayref('SELECT old_status, new_status, require_comment
FROM status_workflow');
my %workflow;
foreach my $row (@$workflow) {
my ($old, $new, $type) = @$row;
$workflow{$old || 0}{$new} = $type;
}
return \%workflow;
}
sub load_template {
my ($filename, $message) = @_;
my $template = Bugzilla->template;
my $vars = {};
$vars->{'statuses'} = [Bugzilla::Status->get_all];
$vars->{'workflow'} = get_workflow();
$vars->{'token'} = issue_session_token("workflow_$filename");
$vars->{'message'} = $message;
$template->process("admin/workflow/$filename.html.tmpl", $vars)
|| ThrowTemplateError($template->error());
exit;
}
if ($action eq 'edit') {
load_template('edit');
}
elsif ($action eq 'update') {
check_token_data($token, 'workflow_edit');
my $statuses = [Bugzilla::Status->get_all];
my $workflow = get_workflow();
my $sth_insert = $dbh->prepare('INSERT INTO status_workflow (old_status, new_status)
VALUES (?, ?)');
my $sth_delete = $dbh->prepare('DELETE FROM status_workflow
WHERE old_status = ? AND new_status = ?');
my $sth_delnul = $dbh->prepare('DELETE FROM status_workflow
WHERE old_status IS NULL AND new_status = ?');
# Part 1: Initial bug statuses.
foreach my $new (@$statuses) {
if ($cgi->param('w_0_' . $new->id)) {
$sth_insert->execute(undef, $new->id)
unless defined $workflow->{0}->{$new->id};
}
else {
$sth_delnul->execute($new->id);
}
}
# Part 2: Bug status changes.
foreach my $old (@$statuses) {
foreach my $new (@$statuses) {
next if $old->id == $new->id;
# All transitions to 'duplicate_or_move_bug_status' must be valid.
if ($cgi->param('w_' . $old->id . '_' . $new->id)
|| ($new->name eq Bugzilla->params->{'duplicate_or_move_bug_status'}))
{
$sth_insert->execute($old->id, $new->id)
unless defined $workflow->{$old->id}->{$new->id};
}
else {
$sth_delete->execute($old->id, $new->id);
}
}
}
delete_token($token);
load_template('edit', 'workflow_updated');
}
elsif ($action eq 'edit_comment') {
load_template('comment');
}
elsif ($action eq 'update_comment') {
check_token_data($token, 'workflow_comment');
my $workflow = get_workflow();
my $sth_update = $dbh->prepare('UPDATE status_workflow SET require_comment = ?
WHERE old_status = ? AND new_status = ?');
my $sth_updnul = $dbh->prepare('UPDATE status_workflow SET require_comment = ?
WHERE old_status IS NULL AND new_status = ?');
foreach my $old (keys %$workflow) {
# Hashes cannot have undef as a key, so we use 0. But the DB
# must store undef, for referential integrity.
my $old_id_for_db = $old || undef;
foreach my $new (keys %{$workflow->{$old}}) {
my $comment_required = $cgi->param("c_${old}_$new") ? 1 : 0;
next if ($workflow->{$old}->{$new} == $comment_required);
if ($old_id_for_db) {
$sth_update->execute($comment_required, $old_id_for_db, $new);
}
else {
$sth_updnul->execute($comment_required, $new);
}
}
}
delete_token($token);
load_template('comment', 'workflow_updated');
}
else {
ThrowUserError('unknown_action', {action => $action});
}