admin/field.php

   1 <?php
   2 /*=====================================================================*\
   3 || ###################################################################
   4 || # Bugdar
   5 || # Copyright (c)2004-2009 Blue Static
   6 || #
   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 2 of the License.
  10 || #
  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
  14 || # more details.
  15 || #
  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 \*=====================================================================*/
  21
  22 $fetchtemplates = array(
  23         'field'
  24 );
  25
  26 require_once('./global.php');
  27 require_once('./includes/api_field.php');
  28
  29 if (!can_perform('canadminfields'))
  30 {
  31         admin_login();
  32 }
  33
  34 // ###################################################################
  35
  36 if (empty($_REQUEST['do']))
  37 {
  38         $_REQUEST['do'] = 'modify';
  39 }
  40
  41 // ###################################################################
  42
  43 if ($_REQUEST['do'] == 'kill')
  44 {
  45         $field = new FieldAPI();
  46         $field->set('fieldid',          $input->in['fieldid']);
  47         $field->set_condition();
  48         $field->delete();
  49
  50         $admin->redirect('field.php?do=modify');
  51 }
  52
  53 // ###################################################################
  54
  55 if ($_REQUEST['do'] == 'delete')
  56 {
  57         $admin->page_confirm(T('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', 'kill', array('fieldid' => $input->in['fieldid']));
  58 }
  59
  60 // ###################################################################
  61
  62 if ($_REQUEST['do'] == 'update')
  63 {
  64         $edit = false;
  65         $add = true;
  66
  67         $type = $input->in['type'];
  68
  69         $field = new FieldAPI();
  70
  71         if ($input->in['fieldid'])
  72         {
  73                 $field->set('fieldid',          $input->in['fieldid']);
  74                 $field->set_condition();
  75                 $field->fetch();
  76
  77                 $edit = true;
  78                 $add = false;
  79                 $type = $field->record['type'];
  80         }
  81         else
  82         {
  83                 $field->set('type',             $type);
  84         }
  85
  86         switch ($type)
  87         {
  88                 case 'input_text':
  89                         $field->set('defaultvalue',     $input->in['defaultvalue']);
  90                         $field->set('regexmatch',       $input->in['regexmatch']);
  91                         $field->set('maxlength',        $input->in['maxlength']);
  92                 break;
  93
  94                 case 'input_checkbox':
  95                         $field->set('defaultvalue',     $input->in['defaultvalue']);
  96                 break;
  97
  98                 case 'select_single':
  99                         $field->set('selects',          $input->in['selects']);
 100                         $field->set('usedefault',       $input->in['usedefault']);
 101                 break;
 102         }
 103
 104         $field->set('name',                     $input->in['name']);
 105         $field->set('description',      $input->in['description']);
 106         $field->set('required',         $input->in['required']);
 107         $field->set('cansearch',        $input->in['cansearch']);
 108
 109         if ($add)
 110         {
 111                 $field->insert();
 112                 $fieldid = $field->insertid;
 113
 114                 $db->query("ALTER TABLE " . TABLE_PREFIX . "bug ADD custom$fieldid MEDIUMTEXT NULL");
 115                 $db->query("OPTIMIZE TABLE " . TABLE_PREFIX . "bug");
 116         }
 117         else
 118         {
 119                 $field->update();
 120                 $fieldid = $field->values['fieldid'];
 121         }
 122
 123         $input->inputClean('custom', TYPE_UINT);
 124         foreach ($input->in['custom'] AS $usergroupid => $mask)
 125         {
 126                 $values[] = $bugsys->clean($usergroupid, TYPE_UINT) . ", $fieldid, " . $mask;
 127         }
 128
 129         $db->query("
 130                 REPLACE INTO " . TABLE_PREFIX . "bugfieldpermission
 131                         (usergroupid, fieldid, mask)
 132                 VALUES
 133                         (" . implode("),\n\t\t\t(", $values) . ")"
 134         );
 135
 136         $admin->redirect('field.php?do=modify', ($add ? T('The custom field has been added') : T('The custom field has been updated')));
 137 }
 138
 139 // ###################################################################
 140
 141 if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'edit')
 142 {
 143         $field = new FieldAPI();
 144
 145         $add = (($_REQUEST['do'] == 'add') ? true : false);
 146         $typeselect = (($add AND empty($input->in['step'])) ? true : false);
 147         $edit = (($add) ? false : true);
 148
 149         if ($add)
 150         {
 151                 NavLinks::fieldsAdd();
 152                 $navigator->set_focus('link', 'fields-add', 'fields');
 153         }
 154         else
 155         {
 156                 NavLinks::fieldsEdit($input->in['fieldid']);
 157                 $navigator->set_focus('link', 'fields-pages-fields', 'fields-pages');
 158         }
 159
 160         $admin->page_start(($add ? T('Add New Custom Field') : T('Edit Custom Field')));
 161         $admin->form_start('field.php', ($typeselect ? 'add' : 'update'));
 162         if ($add AND !$typeselect)
 163         {
 164                 $admin->form_hidden_field('type', $input->in['type']);
 165         }
 166         if ($typeselect)
 167         {
 168                 $admin->form_hidden_field('step', 1);
 169                 $admin->table_start(true, '40%');
 170                 $admin->table_head(T('Select Type'));
 171         }
 172         else
 173         {
 174                 $admin->table_start();
 175                 $admin->table_head(($add ? T('Add New Bug Field') . ' - ' . FieldAPI::field_types($input->in['type']) : T('Edit Field')));
 176         }
 177
 178         if ($edit)
 179         {
 180                 $field->set('fieldid',          $input->in['fieldid']);
 181                 $field->set_condition();
 182                 $field->fetch();
 183
 184                 $admin->form_hidden_field('fieldid', $field->record['fieldid']);
 185         }
 186
 187         if (!$typeselect)
 188         {
 189                 $type = (($add) ? $input->in['type'] : $field->record['type']);
 190         }
 191
 192         // show type selector
 193         if (empty($input->in['step']) AND $add)
 194         {
 195                 foreach (FieldAPI::field_types() AS $name => $description)
 196                 {
 197                         $admin->list_item($description, $name);
 198                 }
 199                 $admin->row_list(T('Field Type'), 'type', false);
 200
 201                 $admin->row_submit();
 202                 $admin->table_end();
 203         }
 204         // have type, do that funkay thing!
 205         else
 206         {
 207                 $field->set('type',             $type);
 208
 209                 // global fields
 210                 $admin->row_span(T('Global Fields'), 'thead', 'center');
 211                 $admin->row_text(T('Field Type'), FieldAPI::field_types($type));
 212                 $admin->row_input(T('Display Name'), 'name', $field->record['name']);
 213                 $admin->row_textarea(T('Description'), 'description', $field->record['description']);
 214                 $admin->row_yesno(T('Required'), 'required', $field->record['required']);
 215                 $admin->row_yesno(T('Can Be Searched'), 'cansearch', ((isset($field->record['cansearch'])) ? $field->record['cansearch'] : true));
 216
 217                 // type-specific fields
 218                 $admin->row_span(T('Type-Specific Fields'), 'thead', 'center');
 219
 220                 switch ($type)
 221                 {
 222                         case 'input_text':
 223                                 $admin->row_input(T('Default Value'), 'defaultvalue', $field->record['defaultvalue']);
 224                                 $admin->row_input(T('Regular Expression Match'), 'regexmatch', $field->record['regexmatch']);
 225                                 $admin->row_input(T('Maximum Length'), 'maxlength', $field->record['maxlength'], 2, 10);
 226                         break;
 227
 228                         case 'input_checkbox':
 229                                 $admin->row_yesno(T('Checked By Default'), 'defaultvalue', $field->record['defaultvalue']);
 230                         break;
 231
 232                         case 'select_single':
 233                                 $admin->row_textarea(T('Selection Values'), 'selects', stripslashes(implode("\n", (array)unserialize($field->record['selects']))));
 234                                 $admin->row_yesno(T('Make the First Option Default'), 'usedefault', $field->record['usedefault']);
 235                         break;
 236                 }
 237
 238                 $admin->table_end();
 239
 240                 // custom field permissions
 241                 $admin->table_start();
 242                 $admin->table_head(T('Custom Field Permissions'));
 243
 244                 if ($edit)
 245                 {
 246                         $perms = $db->query("SELECT usergroupid, mask FROM " . TABLE_PREFIX . "bugfieldpermission WHERE fieldid = " . $field->record['fieldid']);
 247                         foreach ($perms as $perm)
 248                         {
 249                                 $permissions["$perm[usergroupid]"] = $perm['mask'];
 250                         }
 251                 }
 252
 253                 $usergroups = $db->query("SELECT * FROM " . TABLE_PREFIX . "usergroup ORDER BY usergroupid");
 254                 foreach ($usergroups as $usergroup)
 255                 {
 256                         unset($listitem);
 257                         $admin->list_item(T('No Permission'), 0, $permissions["$usergroup[usergroupid]"] == 0);
 258                         $admin->list_item(T('Can View Field'), 1, $permissions["$usergroup[usergroupid]"] == 1);
 259                         $admin->list_item(T('Can View, Edit Field'), 2, $permissions["$usergroup[usergroupid]"] == 2);
 260                         $admin->row_list($usergroup['title'], "custom[$usergroup[usergroupid]]");
 261                 }
 262
 263                 $admin->table_end();
 264
 265                 // end table
 266                 $admin->table_start();
 267                 $admin->row_submit();
 268                 $admin->table_end();
 269                 $admin->form_end();
 270         }
 271
 272         $admin->page_end();
 273 }
 274
 275 // ###################################################################
 276
 277 if ($_REQUEST['do'] == 'modify')
 278 {
 279         $tpl = new BSTemplate('field');
 280         $tpl->vars['fields'] = $db->query("SELECT * FROM " . TABLE_PREFIX . "bugfield ORDER BY fieldid ASC");
 281         $tpl->evaluate()->flush();
 282 }
 283
 284 ?>