#!/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::Util; use Bugzilla::Error; use Bugzilla::User; use Bugzilla::Component; use Bugzilla::Token; my $cgi = Bugzilla->cgi; my $template = Bugzilla->template; my $vars = {}; # There is only one section about components in the documentation, # so all actions point to the same page. $vars->{'doc_section'} = 'administering/categorization.html#components'; # # Preliminary checks: # my $user = Bugzilla->login(LOGIN_REQUIRED); print $cgi->header(); $user->in_group('editcomponents') || scalar(@{$user->get_products_by_permission('editcomponents')}) || ThrowUserError("auth_failure", {group => "editcomponents", action => "edit", object => "components"}); # # often used variables # my $product_name = trim($cgi->param('product') || ''); my $comp_name = trim($cgi->param('component') || ''); my $action = trim($cgi->param('action') || ''); my $showbugcounts = (defined $cgi->param('showbugcounts')); my $token = $cgi->param('token'); ## REDHAT EXTENSION START 462305 1067210 sub load_product_data { my ($product_name, $showbugcounts) = @_; my $dbh = Bugzilla->dbh; my $query = q{ SELECT c.id, c.name, c.description, c.initialowner, c.initialqacontact, c.initialdocscontact, devel.login_name AS default_assignee, qa.login_name AS default_qa_contact, docs.login_name AS default_docs_contact, c.isactive, CASE WHEN sc.sub_component_count IS NULL THEN 'Add' ELSE CONCAT('Edit (', sc.sub_component_count, ')') END AS sub_component_string, } . $dbh->sql_group_concat('ccu.login_name') . q{ AS initial_cc_names FROM components c LEFT JOIN component_cc cc ON c.id = cc.component_id LEFT JOIN products p ON c.product_id = p.id LEFT JOIN profiles ccu ON cc.user_id = ccu.userid LEFT JOIN profiles docs ON c.initialdocscontact = docs.userid LEFT JOIN profiles qa ON c.initialqacontact = qa.userid LEFT JOIN profiles devel ON c.initialowner = devel.userid LEFT JOIN (SELECT component_id, COUNT(*) AS sub_component_count FROM rh_sub_components GROUP BY component_id ) AS sc ON sc.component_id = c.id WHERE p.name = ? GROUP BY c.id, c.name, c.description, c.initialowner, c.initialqacontact, c.initialdocscontact, c.isactive, devel.login_name, qa.login_name, docs.login_name, sc.sub_component_count }; trick_taint($product_name); my $components = $dbh->selectall_arrayref($query, {'Slice' => {}}, $product_name); if ($showbugcounts) { ## REDHAT EXTENSION BEGIN 584957 $query = q{ SELECT component_id, COUNT(DISTINCT bug_id) AS bug_count FROM ( SELECT b.bug_id, b.component_id FROM bugs AS b JOIN products AS p ON b.product_id = p.id WHERE p.name = ? UNION ALL SELECT b.bug_id, c.id AS component_id FROM bugs b JOIN rh_multiple_bug_components mbc USING ( bug_id ) JOIN components c ON (c.id = mbc.component_id) JOIN products p ON (c.product_id = p.id) WHERE p.name = ? ) AS every_derived_table_must_have_its_own_alias GROUP BY component_id }; ## REDHAT EXTENSION END 584957 my $count_arr = $dbh->selectcol_arrayref($query, {Columns => [1, 2]}, $product_name, $product_name); my %counts = @$count_arr; foreach my $component (@$components) { $component->{bug_count} = defined $counts{$component->{id}} ? $counts{$component->{id}} : 0; } } return {name => $product_name, components => $components,}; } ## REDHAT EXTENSION END 462305 1067210 # # product = '' -> Show nice list of products # unless ($product_name) { my $selectable_products = $user->get_selectable_products; # If the user has editcomponents privs for some products only, # we have to restrict the list of products to display. unless ($user->in_group('editcomponents')) { $selectable_products = $user->get_products_by_permission('editcomponents'); } $vars->{'products'} = $selectable_products; $vars->{'showbugcounts'} = $showbugcounts; $template->process("admin/components/select-product.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } my $product = $user->check_can_admin_product($product_name); # # action='' -> Show nice list of components # unless ($action) { $vars->{'showbugcounts'} = $showbugcounts; $vars->{'product'} = load_product_data($product_name, $showbugcounts); $template->process("admin/components/list.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } # # action='add' -> present form for parameters for new component # # (next action will be 'new') # if ($action eq 'add') { ## REDHAT EXTENSION START 460258 $vars->{comp}{bvp_template_id} = Bugzilla->default_template_id; ## REDHAT EXTENSION END 460258 $vars->{'token'} = issue_session_token('add_component'); $vars->{'product'} = $product; $template->process("admin/components/create.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } # # action='new' -> add component entered in the 'action=add' screen # if ($action eq 'new') { check_token_data($token, 'add_component'); # Do the user matching Bugzilla::User::match_field({ 'initialowner' => {'type' => 'single'}, 'initialqacontact' => {'type' => 'single'}, ## REDHAT EXTENSION 876015: Add initialdocscontact 'initialdocscontact' => {'type' => 'single'}, 'initialcc' => {'type' => 'multi'}, }); my $default_assignee = trim($cgi->param('initialowner') || ''); my $default_qa_contact = trim($cgi->param('initialqacontact') || ''); ## REDHAT EXTENSION 876015: Add default_docs_contact my $default_docs_contact = trim($cgi->param('initialdocscontact') || ''); my $description = trim($cgi->param('description') || ''); my @initial_cc = $cgi->param('initialcc'); my $isactive = $cgi->param('isactive'); ## REDHAT EXTENSION 460258: Add bvp_template_id my $bvp_template_id = $cgi->param('bvp_template_id'); my $default_pool = $cgi->param('default_pool'); ## RED HAT EXTENSION 1613297 my $agile_team = $cgi->param('agile_team'); ## RED HAT EXTENSION 1622371 my $component = Bugzilla::Component->create({ name => $comp_name, product => $product, description => $description, initialowner => $default_assignee, initialqacontact => $default_qa_contact, ## REDHAT EXTENSION 876015: Add initialdocscontact initialdocscontact => $default_docs_contact, initial_cc => \@initial_cc, # XXX We should not be creating series for products that we # didn't create series for. create_series => 1, ## REDHAT EXTENSION 460258: Add bvp_template_id bvp_template_id => $bvp_template_id, default_pool => $default_pool, ## RED HAT EXTENSION 1613297 agile_team => $agile_team, ## RED HAT EXTENSION 1622371 }); $vars->{'message'} = 'component_created'; $vars->{'comp'} = $component; $vars->{'product'} = load_product_data($product_name, $showbugcounts); delete_token($token); $template->process("admin/components/list.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } # # action='del' -> ask if user really wants to delete # # (next action would be 'delete') # if ($action eq 'del') { $vars->{'token'} = issue_session_token('delete_component'); $vars->{'comp'} = Bugzilla::Component->check({product => $product, name => $comp_name}); $vars->{'product'} = $product; $template->process("admin/components/confirm-delete.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } # # action='delete' -> really delete the component # if ($action eq 'delete') { check_token_data($token, 'delete_component'); my $component = Bugzilla::Component->check({product => $product, name => $comp_name}); $component->remove_from_db; $vars->{'message'} = 'component_deleted'; $vars->{'comp'} = $component; $vars->{'product'} = load_product_data($product_name, $showbugcounts); $vars->{'no_edit_component_link'} = 1; delete_token($token); $template->process("admin/components/list.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } # # action='edit' -> present the edit component form # # (next action would be 'update') # if ($action eq 'edit') { $vars->{'token'} = issue_session_token('edit_component'); my $component = Bugzilla::Component->check({product => $product, name => $comp_name}); $vars->{'comp'} = $component; $vars->{'initial_cc_names'} = join(', ', map($_->login, @{$component->initial_cc})); $vars->{'product'} = $product; $template->process("admin/components/edit.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } # # action='update' -> update the component # if ($action eq 'update') { check_token_data($token, 'edit_component'); # Do the user matching Bugzilla::User::match_field({ 'initialowner' => {'type' => 'single'}, 'initialqacontact' => {'type' => 'single'}, ## REDHAT EXTENSION 876015: Add initialdocscontact 'initialdocscontact' => {'type' => 'single'}, 'initialcc' => {'type' => 'multi'}, }); my $comp_old_name = trim($cgi->param('componentold') || ''); my $default_assignee = trim($cgi->param('initialowner') || ''); my $default_qa_contact = trim($cgi->param('initialqacontact') || ''); ## REDHAT EXTENSION 876015: Add default_docs_contact my $default_docs_contact = trim($cgi->param('initialdocscontact') || ''); my $description = trim($cgi->param('description') || ''); my @initial_cc = $cgi->param('initialcc'); my $isactive = $cgi->param('isactive'); ## REDHAT EXTENSION 460258: Add bvp_template_id my $bvp_template_id = $cgi->param('bvp_template_id'); my $default_pool = $cgi->param('default_pool'); ## RED HAT EXTENSION 1613297 my $agile_team = $cgi->param('agile_team'); ## RED HAT EXTENSION 1622371 my $component = Bugzilla::Component->check({product => $product, name => $comp_old_name}); $component->set_name($comp_name); $component->set_description($description); $component->set_default_assignee($default_assignee); $component->set_default_qa_contact($default_qa_contact); ## REDHAT EXTENSION 876015: Add default_docs_contact $component->set_default_docs_contact($default_docs_contact); $component->set_cc_list(\@initial_cc); $component->set_is_active($isactive); ## REDHAT EXTENSION 460258 1326981: Add bvp_template_id $component->set_template_id($bvp_template_id); $component->set_default_pool($default_pool); ## RED HAT EXTENSION 1613297 $component->set_agile_team($agile_team); ## RED HAT EXTENSION 1622371 ## REDHAT EXTENSION BEGIN 1326559 $component->set_always_cc(scalar $cgi->param('always_cc')); ## REDHAT EXTENSION END 1326559 my $changes = $component->update(); $vars->{'message'} = 'component_updated'; $vars->{'comp'} = $component; $vars->{'product'} = load_product_data($product_name, $showbugcounts); $vars->{'changes'} = $changes; delete_token($token); $template->process("admin/components/list.html.tmpl", $vars) || ThrowTemplateError($template->error()); exit; } # No valid action found ThrowUserError('unknown_action', {action => $action});