admin/product.php

   1 <?php
   2 /*=====================================================================*\
   3 || ###################################################################
   4 || # Bugdar
   5 || # Copyright (c)2004-2008 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 // TODO - add API for product.php
  23
  24 require_once('./global.php');
  25 require_once('./includes/functions_datastore.php');
  26
  27 NavLinks::productsAdd();
  28 $navigator->set_focus('tab', 'products', null);
  29
  30 if (!can_perform('canadminversions'))
  31 {
  32         admin_login();
  33 }
  34
  35 function construct_option_list($type_display, $type, $id, $edit, $addcomponent, $addversion, $delete, $displayorder)
  36 {
  37         global $bugsys;
  38
  39         $type = ($type == 'component' ? 'product' : $type);
  40         $type_action = (($type == 'version') ? 'versionid' : 'productid');
  41
  42         if ($edit)
  43         {
  44                 $opt .= '<option value="product.php?do=edit' . $type . '&' . $type_action . '=' . $id . '">' . sprintf(T('Edit %1$s'), $type_display) . '</option>';
  45         }
  46
  47         if ($delete)
  48         {
  49                 $opt .= '<option value="product.php?do=delete' . $type . '&' . $type_action . '=' . $id . '">' . sprintf(T('Delete %1$s'), $type_display) . '</option>';
  50         }
  51
  52         if ($addcomponent)
  53         {
  54                 $opt .= '<option value="product.php?do=addproduct&productid=' . $id . '">' . T('Add Component') . '</option>';
  55         }
  56
  57         if ($addversion)
  58         {
  59                 $opt .= '<option value="product.php?do=addversion&productid=' . $id . '">' . T('Add Version') . '</option>';
  60         }
  61
  62         $type = strtolower($type);
  63
  64         $name = $type . '_' . $id;
  65
  66         $displayorder = (($displayorder != -1) ? '<input type="text" name="displayorder[' . $name . ']" value="' . $displayorder . '" size="4" class="input" /> ' : '');
  67
  68         return $displayorder . '<select id="' . $name . '" name="' . $name . '" onchange="exec_action(\'' . $name . '\')" class="input">' . $opt . '</select> <input type="button" class="button" name="gobutton" value="  ' . T('Go') . '  " onclick="exec_action(\'' . $name . '\')" />';
  69 }
  70
  71 // ###################################################################
  72
  73 if (empty($_REQUEST['do']))
  74 {
  75         $_REQUEST['do'] = 'modify';
  76 }
  77
  78 // ###################################################################
  79
  80 if ($_REQUEST['do'] == 'killversion')
  81 {
  82         $input->inputClean('versionid', TYPE_UINT);
  83         $db->query("DELETE FROM " . TABLE_PREFIX . "version WHERE versionid = " . $input->in['versionid']);
  84         $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE version = " . $input->in['versionid']);
  85
  86         build_versions();
  87
  88         $admin->redirect('product.php?do=modify');
  89 }
  90
  91 // ###################################################################
  92
  93 if ($_REQUEST['do'] == 'deleteversion')
  94 {
  95         $admin->page_confirm(T('Are you sure you want to delete this version? Doing so will do <strong>delete all the bugs with this version</strong>.'), 'product.php', 'killversion', array('versionid' => $input->inputClean('versionid', TYPE_UINT)));
  96 }
  97
  98 // ###################################################################
  99
 100 if ($_REQUEST['do'] == 'insertversion')
 101 {
 102         $db->query("INSERT INTO " . TABLE_PREFIX . "version (productid, version, displayorder, obsolete) VALUES (" . $input->inputClean('productid', TYPE_UINT) . ", '" . $bugsys->input_escape('version') . "', " . $input->inputClean('displayorder', TYPE_UINT) . ", " . $input->inputClean('obsolete', TYPE_UINT) . ")");
 103         build_versions();
 104         $admin->redirect('product.php?do=modify');
 105 }
 106
 107 // ###################################################################
 108
 109 if ($_REQUEST['do'] == 'addversion')
 110 {
 111         NavLinks::productsEdit($input->inputClean('productid', TYPE_UINT));
 112         $navigator->set_focus('link', 'products-edit-version', 'products-edit');
 113
 114         if ($input->in['productid'] != -1)
 115         {
 116                 $product = $db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = " . $input->in['productid']);
 117                 if (!is_array($product))
 118                 {
 119                         $admin->error(L_INVALID_ID);
 120                 }
 121         }
 122         else
 123         {
 124                 $input->in['productid'] = 0;
 125         }
 126
 127         $admin->page_start(T('Add Version'));
 128
 129         $admin->form_start('product.php', 'insertversion');
 130         $admin->form_hidden_field('productid', $input->in['productid']);
 131         $admin->table_start();
 132         $admin->table_head(T('Add New Version'));
 133         $admin->row_input(T('Version Number<div><dfn>This is the version string for this product.</dfn></div>'), 'version');
 134         $admin->row_input(T('Display Order<div><dfn>The order in which the versions are displayed.</dfn></div>'), 'displayorder');
 135         $admin->row_yesno(T('Obsolete<div><dfn>An obsolete version cannot have new bugs filed against it, but existing ones can be set to it.</dfn></div>'), 'obsolete', false);
 136         $admin->row_submit();
 137         $admin->table_end();
 138         $admin->form_end();
 139
 140         $admin->page_end();
 141 }
 142
 143 // ###################################################################
 144
 145 if ($_REQUEST['do'] == 'updateversion')
 146 {
 147         if (empty($input->in['version']))
 148         {
 149                 $admin->error(T('Please fill in a version number.'));
 150         }
 151
 152         $db->query("UPDATE " . TABLE_PREFIX . "version SET version = '" . $bugsys->input_escape('version') . "', displayorder = " . $input->inputClean('displayorder', TYPE_UINT) . ", obsolete = " . $input->inputClean('obsolete', TYPE_UINT) . " WHERE versionid = " . $input->inputClean('versionid', TYPE_UINT));
 153         build_versions();
 154
 155         $admin->redirect('product.php?do=modify');
 156 }
 157
 158 // ###################################################################
 159
 160 if ($_REQUEST['do'] == 'editversion')
 161 {
 162         $admin->page_start(T('Edit Version'));
 163
 164         $version = $db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "version WHERE versionid = " . $input->inputClean('versionid', TYPE_UINT));
 165         if (!is_array($version))
 166         {
 167                 $admin->error(L_INVALID_ID);
 168         }
 169
 170         $admin->form_start('product.php', 'updateversion');
 171         $admin->form_hidden_field('versionid', $version['versionid']);
 172         $admin->table_start();
 173         $admin->table_head(sprintf(T('Edit Version - %1$s'), $version['version']));
 174         $admin->row_input(T('Version Number<div><dfn>This is the version string for this product.</dfn></div>'), 'version', $version['version']);
 175         $admin->row_input(T('Display Order<div><dfn>The order in which the versions are displayed.</dfn></div>'), 'displayorder', $version['displayorder']);
 176         $admin->row_yesno(T('Obsolete<div><dfn>An obsolete version cannot have new bugs filed against it, but existing ones can be set to it.</dfn></div>'), 'obsolete', $version['obsolete']);
 177         $admin->row_submit();
 178         $admin->table_end();
 179         $admin->form_end();
 180
 181         $admin->page_end();
 182 }
 183
 184 // ###################################################################
 185
 186 if ($_REQUEST['do'] == 'killproduct')
 187 {
 188         $input->inputClean('productid', TYPE_UINT);
 189         $allprods = $db->query("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = " . $input->in['productid'] . " OR parentid = " . $input->in['productid']);
 190         foreach ($allprods as $prod)
 191         {
 192                 $list[] = $prod['productid'];
 193         }
 194
 195         $db->query("DELETE FROM " . TABLE_PREFIX . "product WHERE productid IN (" . implode(', ', $list) . ")");
 196         $db->query("DELETE FROM " . TABLE_PREFIX . "version WHERE productid IN (" . implode(', ', $list) . ")");
 197         $db->query("DELETE FROM " . TABLE_PREFIX . "bug WHERE product IN (" . implode(', ', $list) . ")");
 198
 199         build_products();
 200
 201         $admin->redirect('product.php?do=modify');
 202 }
 203
 204 // ###################################################################
 205
 206 if ($_REQUEST['do'] == 'deleteproduct')
 207 {
 208         $admin->page_confirm(T('Are you sure you want to delete this product and all of it\'s versions and components <strong>and any bugs that have been assigned those products or components</strong>?'), 'product.php', 'killproduct', array('productid' => $input->inputClean('productid', TYPE_UINT)));
 209 }
 210
 211 // ###################################################################
 212
 213 if ($_REQUEST['do'] == 'insertproduct')
 214 {
 215         if (empty($input->in['title']))
 216         {
 217                 $admin->error(T('Please go back and fill in the title field.'));
 218         }
 219
 220         $db->query("
 221                 INSERT INTO " . TABLE_PREFIX . "product
 222                         (title, parentid, description, displayorder)
 223                 VALUES
 224                         ('" . $bugsys->input_escape('title') . "', " . $input->inputClean('parentid', TYPE_UINT) . ",
 225                         '" . $bugsys->input_escape('description') . "', " . $input->inputClean('displayorder', TYPE_UINT) . "
 226                 )"
 227         );
 228         build_products();
 229
 230         $admin->redirect('product.php?do=modify');
 231 }
 232
 233 // ###################################################################
 234
 235 if ($_REQUEST['do'] == 'addproduct')
 236 {
 237         if ($input->inputClean('productid', TYPE_UINT))
 238         {
 239                 NavLinks::productsEdit($input->in['productid']);
 240         }
 241         else
 242         {
 243                 NavLinks::productsAdd();
 244         }
 245         $navigator->set_focus('link', 'products-add', 'products');
 246
 247         $admin->page_start(T('Add New Product'));
 248
 249         $admin->form_start('product.php', 'insertproduct');
 250         $admin->form_hidden_field('parentid', $input->in['productid']);
 251         $admin->table_start();
 252         $admin->table_head(T('Add Product'));
 253         $admin->row_input(T('Title'), 'title');
 254         $admin->row_textarea(T('Description<div><dfn>A short description of this product.</dfn></div>'), 'description');
 255         $admin->row_input(T('Display Order<div><dfn>The order in which the products are displayed.</dfn></div>'), 'displayorder');
 256         $admin->row_submit();
 257         $admin->table_end();
 258         $admin->form_end();
 259
 260         $admin->page_end();
 261 }
 262
 263 // ###################################################################
 264
 265 if ($_REQUEST['do'] == 'updateproduct')
 266 {
 267         if (empty($input->in['title']))
 268         {
 269                 $admin->error(T('Please go back and fill in the title field.'));
 270         }
 271
 272         if (empty($input->in['productid']))
 273         {
 274                 $admin->error(L_INVALID_ID);
 275         }
 276
 277         $db->query("UPDATE " . TABLE_PREFIX . "product SET title = '" . $bugsys->input_escape('title') . "', description = '" . $bugsys->input_escape('description') . "', displayorder = " . $input->inputClean('displayorder', TYPE_UINT) . " WHERE productid = " . $input->inputClean('productid', TYPE_UINT));
 278         build_products();
 279
 280         $admin->redirect('product.php?do=modify');
 281 }
 282
 283 // ###################################################################
 284
 285 if ($_REQUEST['do'] == 'editproduct')
 286 {
 287         NavLinks::productsEdit($input->inputClean('productid', TYPE_UINT));
 288         $navigator->set_focus('link', 'products-edit', 'products-edit');
 289
 290         $admin->page_start(T('Edit Product'));
 291
 292         $product = $db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "product WHERE productid = " . $input->in['productid']);
 293         if (!is_array($product))
 294         {
 295                 $admin->error(L_INVALID_ID);
 296         }
 297
 298         $admin->form_start('product.php', 'updateproduct');
 299         $admin->form_hidden_field('productid', $product['productid']);
 300         $admin->table_start();
 301         $admin->table_head(sprintf(T('Edit Product - %1$s'), $product['title']));
 302         $admin->row_input(T('Title'), 'title', $product['title']);
 303         $admin->row_textarea(T('Description<div><dfn>A short description of this product.</dfn></div>'), 'description', $product['description']);
 304         $admin->row_input(T('Display Order<div><dfn>The order in which the products are displayed.</dfn></div>'), 'displayorder', $product['displayorder']);
 305         $admin->row_submit();
 306         $admin->table_end();
 307         $admin->form_end();
 308
 309         $admin->page_end();
 310 }
 311
 312 // ###################################################################
 313
 314 if ($_POST['do'] == 'displayorder')
 315 {
 316         $input->inputClean('displayorder', TYPE_UINT);
 317         if (is_array($input->in['displayorder']))
 318         {
 319                 foreach ($input->in['displayorder'] AS $namebit => $displayorder)
 320                 {
 321                         $name = explode('_', $namebit);
 322                         if ($name[0] == 'product' OR $name[0] == 'version')
 323                         {
 324                                 $id = $bugsys->clean($name[1], TYPE_UINT);
 325                                 $order = $displayorder;
 326                                 $db->query("UPDATE " . TABLE_PREFIX . "$name[0] SET displayorder = $order WHERE $name[0]id = $id");
 327                         }
 328                 }
 329                 build_products();
 330                 build_versions();
 331         }
 332         $admin->redirect('product.php?do=modify');
 333 }
 334
 335 // ###################################################################
 336
 337 if ($_REQUEST['do'] == 'modify')
 338 {
 339         $navigator->set_focus('link', 'products-manage', 'products');
 340
 341         $admin->page_start(T('Products and Versions'));
 342
 343         $javascript = <<<EOF
 344 <script type="text/javascript">
 345 <!--
 346         function exec_action(name)
 347         {
 348                 window.location = document.getElementById(name).value;
 349         }
 350 //-->
 351 </script>
 352 EOF;
 353
 354         $admin->page_code($javascript);
 355
 356         $admin->form_start('product.php', 'displayorder');
 357
 358         $products_get = $db->query("SELECT * FROM " . TABLE_PREFIX . "product ORDER BY displayorder ASC");
 359         $products = array();
 360         foreach ($products_get as $prod)
 361         {
 362                 if (!$prod['parentid'])
 363                 {
 364                         $products["$prod[productid]"] = $prod;
 365                 }
 366                 else
 367                 {
 368                         $components["$prod[parentid]"][] = $prod;
 369                 }
 370                 $version["$prod[productid]"] = array();
 371         }
 372
 373         $versions_get = $db->query("SELECT * FROM " . TABLE_PREFIX . "version ORDER BY displayorder ASC");
 374         $versions = array();
 375         foreach ($versions_get as $vers)
 376         {
 377                 $versions["$vers[productid]"]["$vers[versionid]"] = $vers;
 378         }
 379
 380         $admin->table_start();
 381         $admin->table_head(T('Products / Versions'));
 382
 383         // Handle our global versions
 384         if (is_array($versions['0']))
 385         {
 386                 $admin->row_text(T('Global Versions'), construct_option_list(T('Product'), 'product', -1, 0, 0, 1, 0, -1), 'middle', 2, 'alt3');
 387                 foreach ($versions['0'] AS $version)
 388                 {
 389                         $admin->row_text('-- ' . $version['version'], construct_option_list(T('Version'), 'version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
 390                 }
 391         }
 392
 393         // Now let's do the rest of the versions
 394         foreach ($products AS $product)
 395         {
 396                 // Product
 397                 $admin->row_text("<a href=\"product.php?do=editproduct&amp;productid=$product[productid]\">$product[title]</a>", construct_option_list(T('Product'), 'product', $product['productid'], 1, 1, 1, 1, $product['displayorder']), 'middle', 2, 'alt3');
 398
 399                 // Versions
 400                 if (is_array($versions["$product[productid]"]))
 401                 {
 402                         foreach ($versions["$product[productid]"] AS $version)
 403                         {
 404                                 $admin->row_text('-- ' . $version['version'], construct_option_list(T('Version'), 'version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
 405                         }
 406                 }
 407
 408                 // Components
 409                 if (is_array($components["$product[productid]"]))
 410                 {
 411                         foreach ($components["$product[productid]"] AS $comp)
 412                         {
 413                                 $admin->row_text("-- <a href=\"product.php?do=editproduct&amp;productid=$comp[productid]\">$comp[title]</a>", construct_option_list(T('Component'), 'component', $comp['productid'], 1, 0, 1, 1, $comp['displayorder']), 'middle', 2, 'alt1');
 414
 415                                 // Component versions
 416                                 if (is_array($versions["$comp[productid]"]))
 417                                 {
 418                                         foreach ($versions["$comp[productid]"] AS $version)
 419                                         {
 420                                                 $admin->row_text('---- ' . $version['version'], construct_option_list(T('Version'), 'version', $version['versionid'], 1, 0, 0, 1, $version['displayorder']), 'middle', 2, 'alt2');
 421                                         }
 422                                 }
 423                         }
 424                 }
 425         }
 426
 427         $admin->row_submit(null, T('Save Display Order'), null);
 428
 429         $admin->table_end();
 430
 431         $admin->form_end();
 432
 433         $admin->page_end();
 434 }
 435
 436 ?>