editreport.php

   1 <?php
   2 /*=====================================================================*\
   3 || ################################################################### ||
   4 || # BugStrike [#]version[#]
   5 || # --------------------------------------------------------------- # ||
   6 || # All parts of this file are ©2002-[#]year[#] Iris Studios, Inc. No     # ||
   7 || # part of this file may be reproduced in any way: part or whole.  # ||
   8 || # --------------------------------------------------------------- # ||
   9 || # ©2002 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com   # ||
  10 || ################################################################### ||
  11 \*=====================================================================*/
  12
  13 define('SVN', '$Id$');
  14
  15 $focus['showreport'] = 'focus';
  16
  17 require_once('./global.php');
  18
  19 $bug = $db->query_first("
  20         SELECT bugvaluefill.*, bug.*, user.email, user.displayname, user.showemail
  21         FROM " . TABLE_PREFIX . "bug AS bug
  22         LEFT JOIN " . TABLE_PREFIX . "user AS user
  23                 ON (bug.userid = user.userid)
  24         LEFT JOIN " . TABLE_PREFIX . "bugvaluefill AS bugvaluefill
  25                 ON (bug.bugid = bugvaluefill.bugid)
  26         WHERE bug.bugid = " . intval($bugsys->in['bugid'])
  27 );
  28
  29 if (!(((can_perform('caneditown') AND $bugsys->userinfo['userid'] == $comment['userid']) OR can_perform('caneditothers')) AND can_perform('caneditinfo')) AND !can_perform('canpostcomments'))
  30 {
  31         $message->error_permission();
  32 }
  33
  34 if (!$bug)
  35 {
  36         $message->error($lang->getlex('error_invalid_id'));
  37 }
  38
  39 if ($bug['hidden'] AND !can_perform('canviewhidden'))
  40 {
  41         $message->error_permission();
  42 }
  43
  44 // setup logging
  45 require_once('./includes/class_history.php');
  46 $log = new History();
  47 $log->bugid = $bug['bugid'];
  48
  49 // ###################################################################
  50
  51 if ($_POST['do'] == 'update')
  52 {
  53         // -------------------------------------------------------------------
  54         // process comment stuff
  55         if (!(((can_perform('caneditown') AND $bugsys->userinfo['userid'] == $comment['userid']) OR can_perform('caneditothers')) AND can_perform('caneditinfo')))
  56         {
  57                 $hascomment = (!empty($bugsys->in['comment'])) ? true : false;
  58
  59                 if ($hascomment OR $autoaction['comment'])
  60                 {
  61                         if ($hascomment AND $autoaction['comment'])
  62                         {
  63                                 $bugsys->in['comment'] .= "\n\n--------------- AUTOMATIC RESPONSE ---------------\n" . $autoaction['comment'];
  64                         }
  65                         else if (!$hascomment AND $autoaction['comment'])
  66                         {
  67                                 $bugsys->in['comment'] = $autoaction['comment'];
  68                         }
  69
  70                         $bugsys->in['comment_parsed'] = $bugsys->in['comment'];
  71
  72                         if (!$bugsys->options['allowhtml'])
  73                         {
  74                                 $bugsys->in['comment_parsed'] = $bugsys->sanitize($bugsys->in['comment_parsed']);
  75                         }
  76
  77                         $time = TIMENOW;
  78
  79                         $db->query("
  80                                 INSERT INTO " . TABLE_PREFIX . "comment
  81                                         (bugid, userid, dateline, comment, comment_parsed)
  82                                 VALUES
  83                                         (" . intval($bugsys->in['bugid']) . ", " . $bugsys->userinfo['userid'] . ",
  84                                         $time, '" . $bugsys->in['comment'] . "',
  85                                         '" . nl2br($bugsys->in['comment_parsed']) . "'
  86                                 )"
  87                         );
  88
  89                         $commentid = $db->insert_id();
  90
  91                         $db->query("
  92                                 UPDATE " . TABLE_PREFIX . "bug
  93                                 SET lastposttime = $time,
  94                                         lastpostby = " . $bugsys->userinfo['userid'] . ",
  95                                         hiddenlastposttime = $time,
  96                                         hiddenlastpostby = " . $bugsys->userinfo['userid'] . "
  97                                 WHERE bugid = " . intval($bugsys->in['bugid'])
  98                         );
  99
 100                         if ($hascomment)
 101                         {
 102                                 $log->language = 'log_new_comment';
 103                                 $log->arguments = array($commentid);
 104                                 $log->log();
 105                         }
 106                 }
 107         }
 108
 109         if (!(((can_perform('caneditown') AND $bugsys->userinfo['userid'] == $comment['userid']) OR can_perform('caneditothers')) AND can_perform('caneditinfo')))
 110         {
 111                 $message->redirect($lang->string('Your reply has been added to the comment list.'), "showreport.php?bugid=$bug[bugid]");
 112         }
 113
 114         // -------------------------------------------------------------------
 115         // do update stuff
 116         $pcv = parse_pcv_select($bugsys->in['pcv_select'], true);
 117
 118         if (!$bugsys->in['summary'])
 119         {
 120                 $message->error($lang->string('You need to enter a summary for this bug.'));
 121         }
 122         if (!$pcv)
 123         {
 124                 $message->error($lang->string('Invalid product/component/version selected.'));
 125         }
 126
 127         $hist[0] = (array)$db->query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[bugid]");
 128         $hist2[0] = (array)$temp = $noinitialcustom = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "bugvaluefill WHERE bugid = $bug[bugid]");
 129
 130         // -------------------------------------------------------------------
 131         // start updates
 132
 133         // auto action
 134         $autoaction = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "autoaction WHERE actionid = " . intval($bugsys->in['autoaction']));
 135         if ($autoaction)
 136         {
 137                 $autoaction['fields'] = unserialize($autoaction['fieldchanges']);
 138
 139                 foreach ($autoaction['fields']['builtin'] AS $field => $value)
 140                 {
 141                         $bugsys->in["$field"] = $value;
 142                 }
 143
 144                 foreach ($autoaction['fields']['custom'] AS $field => $value)
 145                 {
 146                         $bugsys->in["field$field"] = $value;
 147                 }
 148         }
 149
 150         process_custom_fields($bug['bugid']);
 151
 152         $dependencies = preg_split('#([^0-9].*?)#', $bugsys->in['dependency'], -1, PREG_SPLIT_NO_EMPTY);
 153         $dependencies = ((count($dependencies) < 1) ? '' : implode(', ', $dependencies));
 154
 155         $db->query("
 156                 UPDATE " . TABLE_PREFIX . "bug
 157                 SET summary = '" . $bugsys->in['summary'] . "',
 158                         severity = " . intval($bugsys->in['severity']) . "," .
 159                                 (can_perform('canchangestatus') ? "
 160                                         priority = " . intval($bugsys->in['priority']) . ",
 161                                         status = " . intval($bugsys->in['status']) . ",
 162                                         resolution = " . intval($bugsys->in['resolution']) . ","
 163                                 : '') . "
 164                         " . (can_perform('canassign') ? "assignedto = " . intval($bugsys->in['assignedto']) . "," : '') . "
 165                         duplicateof = " . intval($bugsys->in['duplicateof']) . ",
 166                         dependency = '$dependencies',
 167                         productid = " . $pcv['product'] . ",
 168                         componentid = " . $pcv['component'] . ",
 169                         versionid = " . $pcv['version'] . ",
 170                         hidden = " . intval($bugsys->in['hidden']) . "
 171                 WHERE bugid = $bug[bugid]"
 172         );
 173
 174         // -------------------------------------------------------------------
 175         // do diff history
 176
 177         $hist[1] = (array)$db->query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[bugid]");
 178         $hist2[1] = (array)$db->query_first("SELECT * FROM " . TABLE_PREFIX . "bugvaluefill WHERE bugid = $bug[bugid]");
 179
 180         $diff[0] = array_diff_assoc($hist[0], $hist[1]);
 181         $diff[1] = array_diff_assoc($hist[1], $hist[0]);
 182
 183         $lookupindex = array(
 184                 'status' => 'status',
 185                 'severity' => 'severity',
 186                 'priority' => 'priority',
 187                 'versionid' => 'version',
 188                 'assignedto' => 'assignto',
 189                 'resolution' => 'resolution',
 190                 'productid' => 'product',
 191                 'componentid' => 'product'
 192         );
 193
 194         $log->language = 'log_update_bug';
 195
 196         foreach ($diff AS $num => $diffs)
 197         {
 198                 foreach ($diffs AS $key => $value)
 199                 {
 200                         if (!isset($lookupindex["$key"]))
 201                         {
 202                                 continue;
 203                         }
 204
 205                         $ref = $lookupindex["$key"];
 206                         $temp =& $bugsys->datastore["$ref"]["$value"];
 207                         $thevalue = $temp["$ref"];
 208                         $idbit = ' (id: ' . $temp["$ref" . 'id'] . ')';
 209
 210                         if ($key == 'assignedto')
 211                         {
 212                                 $thevalue = (($temp['userid']) ? construct_user_display($temp) : '');
 213                                 $idbit = '';
 214                         }
 215                         else if ($key == 'productid' OR $key == 'componentid')
 216                         {
 217                                 $ref = 'product';
 218                                 $thevalue = $temp['title'];
 219                         }
 220
 221                         $diff["$num"]["$key"] = (($thevalue) ? $thevalue . $idbit : '');
 222                 }
 223         }
 224
 225         foreach ($diff[1] AS $key => $value)
 226         {
 227                 $log->log($log->diff($key, $diff[0]["$key"], $diff[1]["$key"]));
 228         }
 229
 230         $diff2[0] = array_diff_assoc($hist2[0], $hist2[1]);
 231         $diff2[1] = array_diff_assoc($hist2[1], $hist2[0]);
 232
 233         if ($noinitialcustom === false)
 234         {
 235                 $canallowempty = true;
 236                 $checkbox = $db->query("SELECT * FROM " . TABLE_PREFIX . "bugfield WHERE type = 'input_checkbox'");
 237                 while ($box = $db->fetch_array($checkbox))
 238                 {
 239                         $boxlist[] = 'field' . $box['fieldid'];
 240                 }
 241         }
 242
 243         foreach ($diff2[1] AS $key => $value)
 244         {
 245                 if (in_array($key, $boxlist) AND $canallowempty)
 246                 {
 247                         $log->allowempty = true;
 248                 }
 249                 else
 250                 {
 251                         $log->allowempty = false;
 252                 }
 253
 254                 if ($key == 'bugid')
 255                 {
 256                         continue;
 257                 }
 258
 259                 $log->log($log->diff('custom_' . $key, $diff2[0]["$key"], $diff2[1]["$key"]));
 260         }
 261
 262         $log->allowempty = false;
 263
 264         // -------------------------------------------------------------------
 265         // more comment
 266         $hascomment = (!empty($bugsys->in['comment'])) ? true : false;
 267
 268         if ($hascomment OR $autoaction['comment'])
 269         {
 270                 if ($hascomment AND $autoaction['comment'])
 271                 {
 272                         $bugsys->in['comment'] .= "\n\n--------------- AUTOMATIC RESPONSE ---------------\n" . $autoaction['comment'];
 273                 }
 274                 else if (!$hascomment AND $autoaction['comment'])
 275                 {
 276                         $bugsys->in['comment'] = $autoaction['comment'];
 277                 }
 278
 279                 $bugsys->in['comment_parsed'] = $bugsys->in['comment'];
 280
 281                 if (!$bugsys->options['allowhtml'])
 282                 {
 283                         $bugsys->in['comment_parsed'] = $bugsys->sanitize($bugsys->in['comment_parsed']);
 284                 }
 285
 286                 $time = TIMENOW;
 287
 288                 $db->query("
 289                         INSERT INTO " . TABLE_PREFIX . "comment
 290                                 (bugid, userid, dateline, comment, comment_parsed)
 291                         VALUES
 292                                 (" . intval($bugsys->in['bugid']) . ", " . $bugsys->userinfo['userid'] . ",
 293                                 $time, '" . $bugsys->in['comment'] . "',
 294                                 '" . nl2br($bugsys->in['comment_parsed']) . "'
 295                         )"
 296                 );
 297
 298                 $commentid = $db->insert_id();
 299
 300                 $db->query("
 301                         UPDATE " . TABLE_PREFIX . "bug
 302                         SET lastposttime = $time,
 303                                 lastpostby = " . $bugsys->userinfo['userid'] . ",
 304                                 hiddenlastposttime = $time,
 305                                 hiddenlastpostby = " . $bugsys->userinfo['userid'] . "
 306                         WHERE bugid = " . intval($bugsys->in['bugid'])
 307                 );
 308
 309                 if ($hascomment)
 310                 {
 311                         $log->language = 'log_new_comment';
 312                         $log->arguments = array($commentid);
 313                         $log->log();
 314                 }
 315         }
 316
 317
 318         $message->redirect($lang->string('Your changes to the bug have been saved.'), "showreport.php?bugid=$bug[bugid]");
 319 }
 320
 321 /*=====================================================================*\
 322 || ###################################################################
 323 || # $HeadURL$
 324 || # $Id$
 325 || ###################################################################
 326 \*=====================================================================*/
 327 ?>