5 * Copyright 1999-2001 (c) VA Linux Systems
6 * The rest Copyright 2002-2004 (c) GForge Team
9 * This file is part of GForge.
11 * GForge is free software; you can redistribute it and/or modify
12 * it under the terms of the GNU General Public License as published by
13 * the Free Software Foundation; either version 2 of the License, or
14 * (at your option) any later version.
16 * GForge is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
21 * You should have received a copy of the GNU General Public License
22 * along with GForge; if not, write to the Free Software
23 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
26 require_once('../../env.inc.php');
27 require_once $gfwww.'include/pre.php';
28 require_once $gfwww.'people/people_utils.php';
30 if (!$sys_use_people) {
34 $group_id = getIntFromRequest('group_id');
35 $job_id = getIntFromRequest('job_id');
37 if (user_ismember(1,'A')) {
39 if (getStringFromRequest('post_changes')) {
44 if (getStringFromRequest('people_cat')) {
45 $cat_name = getStringFromRequest('cat_name');
46 if (!form_key_is_valid(getStringFromRequest('form_key'))) {
47 exit_form_double_submit();
49 $result=db_query_params("INSERT INTO people_job_category (name) VALUES ($1)", array($cat_name));
52 form_release_key(getStringFromRequest("form_key"));
53 $feedback .= ' Error inserting value ';
56 $feedback .= ' Category Inserted ';
58 } else if (getStringFromRequest('people_skills')) {
59 $skill_name = getStringFromRequest('skill_name');
60 if (!form_key_is_valid(getStringFromRequest('form_key'))) {
61 exit_form_double_submit();
63 $result=db_query_params("INSERT INTO people_skill (name) VALUES ($1)", array($skill_name));
66 form_release_key(getStringFromRequest("form_key"));
67 $feedback .= ' Error inserting value ';
70 $feedback .= ' Skill Inserted ';
72 } else if (getStringFromRequest('people_cat_mod')) {
73 $cat_name = getStringFromRequest('cat_name');
74 $people_cat_id = getIntFromRequest('people_cat_id');
76 $sql="UPDATE people_category SET category_name='$cat_name' WHERE people_category_id='$people_cat_id' AND group_id='$group_id'";
77 $result=db_query($sql);
78 if (!$result || db_affected_rows($result) < 1) {
79 $feedback .= ' Error modifying bug category ';
82 $feedback .= ' Bug Category Modified ';
85 } else if (getStringFromRequest('people_group_mod')) {
86 $group_name = getStringFromRequest('group_name');
87 $people_group_id = getIntFromRequest('people_group_id');
88 $group_id = getIntFromRequest('group_id');
90 $sql="UPDATE people_group SET group_name = '$group_name' WHERE people_group_id='$people_group_id' AND group_id='$group_id'";
91 $result=db_query($sql);
92 if (!$result || db_affected_rows($result) < 1) {
93 $feedback .= ' Error modifying bug cateogry ';
96 $feedback .= ' Bug Category Modified ';
106 if (getStringFromRequest('people_cat')) {
108 Show categories and blank row
110 people_header(array ('title'=>'Add/Change Categories'));
113 List of possible categories for this group
115 $result=db_query_params("select category_id,name from people_job_category", array());
117 if ($result && db_numrows($result) > 0) {
118 ShowResultSet($result,'Existing Categories','people_cat');
121 <h1>No job categories</h1>';
126 <form action="<?php echo getStringFromServer('PHP_SELF'); ?>" method="post">
127 <input type="hidden" name="people_cat" value="y" />
128 <input type="hidden" name="post_changes" value="y" />
129 <input type="hidden" name="form_key" value="<?php echo form_generate_key();?>">
130 <h4>New Category Name:</h4>
131 <input type="text" name="cat_name" value="" size="15" maxlength="30" /><br />
133 <span class="imporant">Once you add a category, it cannot be deleted</span></p>
135 <input type="submit" name="submit" value="SUBMIT"></p>
139 people_footer(array());
141 } else if (getStringFromRequest('people_skills')) {
143 Show people_groups and blank row
145 people_header(array ('title'=>'Add/Change People Skills'));
148 List of possible people_groups for this group
150 $result=db_query_params("select skill_id,name from people_skill", array());
152 if ($result && db_numrows($result) > 0) {
153 ShowResultSet($result,"Existing Skills","people_skills");
156 echo "\n<h2>No Skills Found</h2>";
160 <form action="<?php echo getStringFromServer('PHP_SELF'); ?>" method="post">
161 <input type="hidden" name="people_skills" value="y" />
162 <input type="hidden" name="post_changes" value="y" />
163 <input type="hidden" name="form_key" value="<?php echo form_generate_key();?>">
164 <h4>New Skill Name:</h4>
165 <input type="text" name="skill_name" value="" size="15" maxlength="30" /><br />
167 <span class="important">Once you add a skill, it cannot be deleted</span></p>
169 <input type="submit" name="submit" value="SUBMIT"></p>
173 people_footer(array());
180 people_header(array ('title'=>'People Administration'));
183 <a href="'.getStringFromServer('PHP_SELF').'?people_cat=1">Add Job Categories</a><br />';
184 // echo "\nAdd categories of bugs like, 'mail module','gant chart module','interface', etc<p>";
186 echo "\n<a href=\"".getStringFromServer('PHP_SELF')."?people_skills=1\">Add Job Skills</a><br />";
187 // echo "\nAdd Groups of bugs like 'future requests','unreproducible', etc<p>";
189 people_footer(array());
193 exit_permission_denied();