2 /*=====================================================================*\
3 || ###################################################################
4 || # Bugdar [#]version[#]
5 || # Copyright ©2002-[#]year[#] Iris Studios, Inc.
7 || # This program is free software; you can redistribute it and/or modify
8 || # it under the terms of the GNU General Public License as published by
9 || # the Free Software Foundation; version [#]gpl[#] of the License.
11 || # This program is distributed in the hope that it will be useful, but
12 || # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
13 || # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
16 || # You should have received a copy of the GNU General Public License along
17 || # with this program; if not, write to the Free Software Foundation, Inc.,
18 || # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
19 || ###################################################################
20 \*=====================================================================*/
22 require_once('./global.php');
23 require_once('./includes/api_field.php');
25 if (!can_perform('canadminfields'))
30 // ###################################################################
32 if (empty($_REQUEST['do']))
34 $_REQUEST['do'] = 'modify';
37 // ###################################################################
39 if ($_REQUEST['do'] == 'kill')
41 $field = new FieldAPI($bugsys);
42 $field->set('fieldid', $bugsys->in
['fieldid']);
43 $field->set_condition();
46 $admin->redirect('field.php?do=modify');
49 // ###################################################################
51 if ($_REQUEST['do'] == 'delete')
53 $admin->page_confirm($lang->string('Are you sure you want to delete this bug field? Doing so will remove everything for this field and it cannot be undone!'), "field.php?do=kill&fieldid=" . $bugsys->in
['fieldid']);
56 // ###################################################################
58 if ($_REQUEST['do'] == 'update')
63 $type = $bugsys->in
['type'];
65 $field = new FieldAPI($bugsys);
67 if ($bugsys->in
['fieldid'])
69 $field->set('fieldid', $bugsys->in
['fieldid']);
70 $field->set_condition();
75 $type = $field->objdata
['type'];
81 $field->set('defaultvalue', $bugsys->in
['defaultvalue']);
82 $field->set('regexmatch', $bugsys->in
['regexmatch']);
83 $field->set('maxlength', $bugsys->in
['maxlength']);
86 case 'input_checkbox':
87 $field->set('defaultvalue', $bugsys->in
['defaultvalue']);
91 $field->set('selects', $bugsys->in
['selects']);
92 $field->set('usedefault', $bugsys->in
['usedefault']);
96 $field->set('name', $bugsys->in
['name']);
97 $field->set('description', $bugsys->in
['description']);
98 $field->set('required', $bugsys->in
['required']);
99 $field->set('cansearch', $bugsys->in
['cansearch']);
103 $field->set('type', $type);
105 $fieldid = $field->insertid
;
107 $db->query("ALTER TABLE " . TABLE_PREFIX
. "bugvaluefill ADD field$fieldid MEDIUMTEXT NULL");
108 $db->query("OPTIMIZE TABLE " . TABLE_PREFIX
. "bugvaluefill");
113 $fieldid = $field->values
['fieldid'];
116 $bugsys->input_clean('custom', TYPE_UINT
);
117 foreach ($bugsys->in
['custom'] AS $usergroupid => $mask)
119 $values[] = $bugsys->clean($usergroupid, TYPE_UINT
) . ", $fieldid, " . $mask;
123 REPLACE INTO " . TABLE_PREFIX
. "bugfieldpermission
124 (usergroupid, fieldid, mask)
126 (" . implode("),\n\t\t\t(", $values) . ")"
129 $admin->redirect('field.php?do=modify', ($add ?
$lang->string('The custom field has been added') : $lang->string('The custom field has been updated')));
132 // ###################################################################
134 if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'edit')
136 $field = new FieldAPI($bugsys);
138 $add = (($_REQUEST['do'] == 'add') ? true
: false
);
139 $typeselect = (($add AND empty($bugsys->in
['step'])) ? true
: false
);
140 $edit = (($add) ? false
: true
);
142 $admin->page_start(($add ?
$lang->string('Add New Custom Field') : $lang->string('Edit Custom Field')));
143 $admin->form_start('field.php', ($typeselect ?
'add' : 'update'));
144 if ($add AND !$typeselect)
146 $admin->form_hidden_field('type', $bugsys->in
['type']);
150 $admin->form_hidden_field('step', 1);
151 $admin->table_start(true
, '40%');
152 $admin->table_head($lang->string('Select Type'), 2, 'custom_bug_fields');
156 $admin->table_start();
157 $admin->table_head(($add ?
$lang->string('Add New Bug Field') . ' - ' . FieldAPI
::field_types($bugsys->in
['type']) : $lang->string('Edit Field')), 2, 'custom_bug_fields_options');
162 $field->set('fieldid', $bugsys->in
['fieldid']);
163 $field->set_condition();
166 $admin->form_hidden_field('fieldid', $field->objdata
['fieldid']);
171 $type = (($add) ?
$bugsys->in
['type'] : $field->objdata
['type']);
174 // show type selector
175 if (empty($bugsys->in
['step']) AND $add)
177 foreach (FieldAPI
::field_types() AS $name => $description)
179 $admin->list_item($description, $name);
181 $admin->row_list($lang->string('Field Type'), 'type', false
);
183 $admin->row_submit();
186 // have type, do that funkay thing!
189 $field->set('type', $type);
192 $admin->row_span($lang->string('Global Fields'), 'thead', 'center');
193 $admin->row_text($lang->string('Field Type'), FieldAPI
::field_types($type));
194 $admin->row_input($lang->string('Display Name'), 'name', $field->objdata
['name']);
195 $admin->row_textarea($lang->string('Description'), 'description', $field->objdata
['description']);
196 $admin->row_yesno($lang->string('Required'), 'required', $field->objdata
['required']);
197 $admin->row_yesno($lang->string('Can Be Searched'), 'cansearch', ((isset($field->objdata
['cansearch'])) ?
$field->objdata
['cansearch'] : true
));
199 // type-specific fields
200 $admin->row_span($lang->string('Type-Specific Fields'), 'thead', 'center');
205 $admin->row_input($lang->string('Default Value'), 'defaultvalue', $field->objdata
['defaultvalue']);
206 $admin->row_input($lang->string('Regular Expression Match'), 'regexmatch', $field->objdata
['regexmatch']);
207 $admin->row_input($lang->string('Maximum Length'), 'maxlength', $field->objdata
['maxlength'], 2, 10);
210 case 'input_checkbox':
211 $admin->row_yesno($lang->string('Checked By Default'), 'defaultvalue', $field->objdata
['defaultvalue']);
214 case 'select_single':
215 $admin->row_textarea($lang->string('Selection Values'), 'selects', stripslashes(implode("\n", unserialize($field->objdata
['selects']))));
216 $admin->row_yesno($lang->string('Make the First Option Default'), 'usedefault', $field->objdata
['usedefault']);
222 // custom field permissions
223 $admin->table_start();
224 $admin->table_head($lang->string('Custom Field Permissions'));
228 $perms = $db->query("SELECT usergroupid, mask FROM " . TABLE_PREFIX
. "bugfieldpermission WHERE fieldid = " . $field->objdata
['fieldid']);
229 while ($perm = $db->fetch_array($perms))
231 $permissions["$perm[usergroupid]"] = $perm['mask'];
235 $usergroups = $db->query("SELECT * FROM " . TABLE_PREFIX
. "usergroup ORDER BY usergroupid");
236 while ($usergroup = $db->fetch_array($usergroups))
239 $admin->list_item($lang->string('No Permission'), 0, $permissions["$usergroup[usergroupid]"] == 0);
240 $admin->list_item($lang->string('Can View Field'), 1, $permissions["$usergroup[usergroupid]"] == 1);
241 $admin->list_item($lang->string('Can View, Edit Field'), 2, $permissions["$usergroup[usergroupid]"] == 2);
242 $admin->row_list($usergroup['title'], "custom[$usergroup[usergroupid]]");
248 $admin->table_start();
249 $admin->row_submit((($edit) ?
'<a href="field.php?do=delete&fieldid=' . $field->objdata
['fieldid'] . '">[' . $lang->string('Delete Field') . ']</a>' : ''));
257 // ###################################################################
259 if ($_REQUEST['do'] == 'modify')
261 $admin->page_start($lang->string('Additional Bug Fields'));
263 $admin->table_start();
264 $admin->table_head($lang->string('Additional Bug Fields'), 3, 'custom_bug_fields');
265 $admin->table_column_head(array($lang->string('Display Name/Description'), $lang->string('Field ID'), $lang->string('Actions')));
267 $fields = $db->query("SELECT * FROM " . TABLE_PREFIX
. "bugfield ORDER BY fieldid ASC");
268 while ($field = $db->fetch_array($fields))
270 $admin->row_multi_item(
272 "$field[name]<div class=\"smallfont\"><em>$field[description]</em></div>" => 'l',
273 "$field[fieldid]" => 'c',
274 "<a href=\"field.php?do=edit&fieldid=$field[fieldid]\">[" . $lang->string('Edit') . "]</a> <a href=\"field.php?do=delete&fieldid=$field[fieldid]\">[" . $lang->string('Delete') . "]</a>" => 'c'
279 $admin->row_span('<a href="field.php?do=add">[' . $lang->string('Add New Bug Field') . ']</a>', 'tfoot', 'center', 3);
285 /*=====================================================================*\
286 || ###################################################################
289 || ###################################################################
290 \*=====================================================================*/