showreport.php

   1 <?php
   2 /*=====================================================================*\
   3 || ################################################################### ||
   4 || # BugStrike [#]version[#]
   5 || # --------------------------------------------------------------- # ||
   6 || # Copyright ©2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
   7 || # This file may not be reproduced in any way without permission.  # ||
   8 || # --------------------------------------------------------------- # ||
   9 || # User License Agreement at http://www.iris-studios.com/license/  # ||
  10 || ################################################################### ||
  11 \*=====================================================================*/
  12
  13 $fetchtemplates = array(
  14         'showreport',
  15         'showreport_attachment',
  16         'showreport_comment',
  17         'quicksearch',
  18         'bugfield_static_text'
  19 );
  20
  21 define('SVN', '$Id$');
  22
  23 $focus['showreport'] = 'focus';
  24
  25 require_once('./global.php');
  26 require_once('./includes/functions_product.php');
  27
  28 $bugid = intval($bugsys->in['bugid']);
  29
  30 // ###################################################################
  31
  32 if (empty($bugid) OR $_REQUEST['do'] == 'quicksearch')
  33 {
  34         if (!empty($bugid))
  35         {
  36                 if ($db->query_first("SELECT bugid FROM " . TABLE_PREFIX . "bug WHERE bugid = $bugid"))
  37                 {
  38                         header("Location: showreport.php?bugid=$bugid");
  39                         exit;
  40                 }
  41                 else
  42                 {
  43                         $error = $lang->getlex('error_invalid_id');
  44                 }
  45         }
  46
  47         eval('$template->flush("' . $template->fetch('quicksearch') . '");');
  48         exit;
  49 }
  50
  51 // ###################################################################
  52
  53 // -------------------------------------------------------------------
  54 // get the report
  55 $bug = $db->query_first("
  56         SELECT bugvaluefill.*, bug.*, user.email, user.displayname, user.showemail
  57         FROM " . TABLE_PREFIX . "bug AS bug
  58         LEFT JOIN " . TABLE_PREFIX . "user AS user
  59                 ON (bug.userid = user.userid)
  60         LEFT JOIN " . TABLE_PREFIX . "bugvaluefill AS bugvaluefill
  61                 ON (bug.bugid = bugvaluefill.bugid)
  62         WHERE bug.bugid = " . intval($bugsys->in['bugid'])
  63 );
  64
  65 if (!can_perform('canviewbugs', $bug['productid']))
  66 {
  67         $message->error_permission();
  68 }
  69
  70 $show['edit'] = ((can_perform('caneditown', $bug['productid']) AND $bugsys->userinfo['userid'] == $bug['userid']) OR (can_perform('caneditother', $bug['productid']) AND $bugsys->userinfo['userid'] != $bug['userid']));
  71
  72 if (!is_array($bug))
  73 {
  74         $message->error($lang->getlex('error_invalid_id'));
  75 }
  76
  77 if ($bug['hidden'] AND !can_perform('canviewhidden', $bug['productid']))
  78 {
  79         $message->error_permission();
  80 }
  81
  82 // ###################################################################
  83 // global display items
  84
  85 $show['subscribe'] = can_perform('cansubscribe', $bug['productid']);
  86
  87 $favourite = (bool)$db->query_first("SELECT * FROM " . TABLE_PREFIX . "favourite WHERE bugid = $bug[bugid] AND userid = " . $bugsys->userinfo['userid']);
  88 $favouritetext = (($favourite) ? $lang->string('Remove from Favourites') : $lang->string('Add to Favourites'));
  89
  90 $bug['userinfo'] = construct_user_display($bug);
  91 $bug['datetime'] = $datef->format($bugsys->options['dateformat'], $bug['dateline']);
  92 $bug['product'] = $bugsys->datastore['product']["$bug[productid]"]['title'];
  93 $bug['component'] = (($bug['componentid']) ? $bugsys->datastore['product']["$bug[componentid]"]['title'] : '');
  94 $bug['version'] = $bugsys->datastore['version']["$bug[versionid]"]['version'];
  95
  96 // ###################################################################
  97 // edit display
  98 if ($show['edit'])
  99 {
 100         $select['severity'] = construct_datastore_select('severity', 'severity', 'severityid', $bug['severity']);
 101
 102         $show['changestatus'] = ((can_perform('canchangestatus', $bug['productid'])) ? true : false);
 103         if (can_perform('canchangestatus', $bug['productid']))
 104         {
 105                 $select['priority'] = construct_datastore_select('priority', 'priority', 'priorityid', $bug['priority']);
 106                 $select['status'] = construct_datastore_select('status', 'status', 'statusid', $bug['status']);
 107                 $select['resolution'] = construct_datastore_select('resolution', 'resolution', 'resolutionid', $bug['resolution']);
 108         }
 109         else
 110         {
 111                 $bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
 112                 $bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
 113                 $bug['severity'] = $bugsys->datastore['severity']["$bug[severity]"]['severity'];
 114                 $bug['priority'] = $bugsys->datastore['priority']["$bug[priority]"]['priority'];
 115         }
 116
 117         $show['assign'] = ((can_perform('canassign', $bug['productid'])) ? true : false);
 118         if (can_perform('canassign', $bug['productid']))
 119         {
 120                 foreach ($bugsys->datastore['assignto'] AS $dev)
 121                 {
 122                         $value = $dev['userid'];
 123                         $selected = (($dev['userid'] == $bug['assignedto']) ? true : false);
 124                         $label = construct_user_display($dev, false);
 125                         eval('$select[dev] .= "' . $template->fetch('selectoption') . '";');
 126                 }
 127         }
 128
 129         $pcv_select = construct_pcv_select("p$bug[productid]c$bug[componentid]v$bug[versionid]");
 130
 131         $firstcomment = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "comment WHERE bugid = $bug[bugid] ORDER BY dateline ASC LIMIT 1");
 132
 133         if ($bug['duplicateof'])
 134         {
 135                 $duplicate = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
 136         }
 137
 138         if ($bug['dependency'])
 139         {
 140                 $dependencies = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
 141                 while ($dependency = $db->fetch_array($dependencies))
 142                 {
 143                         $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\">$dependency[bugid]</a>";
 144                 }
 145                 $dependencies = implode(' ', $depends);
 146         }
 147
 148         $actions = $db->query("SELECT * FROM " . TABLE_PREFIX . "autoaction ORDER BY name ASC");
 149         $select['autoactions'] = '';
 150         $show['autoactions'] = false;
 151         while ($action = $db->fetch_array($actions))
 152         {
 153                 $label = $action['name'];
 154                 $value = $action['actionid'];
 155                 $selected = false;
 156                 eval('$select[autoaction] .= "' . $template->fetch('selectoption') . '";');
 157                 $show['autoactions'] = true;
 158         }
 159         if ($show['autoactions'])
 160         {
 161                 $label = '';
 162                 $value = 0;
 163                 $selected = true;
 164                 eval('$select[autoaction] = "' . $template->fetch('selectoption') . '" . $select[autoaction];');
 165         }
 166 }
 167
 168 // ###################################################################
 169 // non-edit display
 170 else
 171 {
 172         // -------------------------------------------------------------------
 173         // prep display
 174         $bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
 175         $bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
 176         $bug['severity'] = $bugsys->datastore['severity']["$bug[severity]"]['severity'];
 177         $bug['priority'] = $bugsys->datastore['priority']["$bug[priority]"]['priority'];
 178
 179         $assigninfo = $bugsys->datastore['assignto']["$bug[assignedto]"];
 180         $bug['assigninfo'] = ((is_array($assigninfo)) ? construct_user_display($assigninfo) : '');
 181
 182         $duplicateof = $db->query_first("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
 183
 184         $duplicates = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE duplicateof = $bug[bugid]");
 185         while ($duplicate = $db->fetch_array($duplicates))
 186         {
 187                 $dupelist[] = "<a href=\"showreport.php?bugid=$duplicate[bugid]\" target=\"_blank\">$duplicate[summary]</a>";
 188         }
 189         $dupelist = implode(', ', $dupelist);
 190
 191         if ($bug['dependency'])
 192         {
 193                 $dependencies = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
 194                 while ($dependency = $db->fetch_array($dependencies))
 195                 {
 196                         $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\" target=\"_blank\">$dependency[bugid]</a>";
 197                 }
 198                 $dependencies = implode(' ', $depends);
 199         }
 200 }
 201
 202 // ###################################################################
 203 // custom field output
 204
 205 $fields = construct_custom_fields($bug);
 206 $show['customfields'] = ($fields ? true : false);
 207
 208 $bugsys->debug('fields modulo: ' . count($fields) % 2);
 209 $i = 1;
 210 foreach ($fields AS $field)
 211 {
 212         $bugsys->debug("i = $i");
 213         if ($i == 1)
 214         {
 215                 $customfields['right'] .= $field;
 216         }
 217         else if ($i == 2)
 218         {
 219                 $customfields['left'] .= $field;
 220                 $i = 0;
 221         }
 222         $i++;
 223 }
 224
 225 // ###################################################################
 226 // other elements
 227
 228 // -------------------------------------------------------------------
 229 // hilight
 230 $words = explode(' ', $bugsys->in['hilight']);
 231 foreach ($words AS $word)
 232 {
 233         if (trim($word))
 234         {
 235                 $word = preg_quote($bugsys->unsanitize($word));
 236                 $hilight[] = $temp = trim(preg_replace('#[^0-9a-zA-Z_ ]#', '', $word));
 237         }
 238 }
 239
 240 // -------------------------------------------------------------------
 241 // attachments
 242 $show['getattachments'] = ((can_perform('cangetattach', $bug['productid']) OR can_perform('caneditattach', $bug['productid'])) ? true : false);
 243 $show['putattachments'] = ((can_perform('canputattach', $bug['productid']) OR can_perform('caneditattach', $bug['productid'])) ? true : false);
 244 $show['attachments'] = ($show['getattachments'] OR $show['putattachments']) ? true : false;
 245
 246 if ($show['getattachments'] OR $show['putattachments'])
 247 {
 248         $attachments_fetch = $db->query("
 249                 SELECT attachment.*, user.email, user.showemail,
 250                         user.displayname
 251                 FROM " . TABLE_PREFIX . "attachment AS attachment
 252                 LEFT JOIN " . TABLE_PREFIX . "user AS user
 253                         ON (attachment.userid = user.userid)
 254                 WHERE attachment.bugid = $bug[bugid]
 255                 ORDER BY attachment.dateline"
 256         );
 257
 258         $attaches = false;
 259         while ($attachment = $db->fetch_array($attachments_fetch))
 260         {
 261                 $attaches = true;
 262                 $show['editattach'] = ((can_perform('caneditattach', $bug['productid']) OR ($attachment['userid'] == $bugsys->userinfo['userid'] AND can_perform('canputattach', $bug['productid']))) ? true : false);
 263                 $attachment['date'] = $datef->format($bugsys->options['dateformat'], $attachment['dateline']);
 264                 $attachment['user'] = construct_user_display($attachment, false);
 265                 eval('$attachments .= "' . $template->fetch('showreport_attachment') . '";');
 266         }
 267
 268         $show['attachments'] = (!$show['putattachments'] AND !$attaches) ? false : true;
 269 }
 270
 271 // -------------------------------------------------------------------
 272 // votes
 273
 274 $vote = $db->query_first("SELECT *, FIND_IN_SET(" . $bugsys->userinfo['userid'] . ", userids) AS uservote FROM " . TABLE_PREFIX . "vote WHERE bugid = $bug[bugid]");
 275
 276 $vote['total'] = $vote['votefor'] + $vote['voteagainst'];
 277 $vote['forpercent'] = round($vote['votefor'] / $vote['total'], 3) * 100;
 278 $vote['againstpercent'] = round($vote['voteagainst'] / $vote['total'], 3) * 100;
 279
 280 $show['vote'] = ((can_perform('canvote', $bug['productid']) AND !$vote['uservote']) ? true : false);
 281
 282 // -------------------------------------------------------------------
 283 // get comments
 284 $comments_fetch = $db->query("
 285         SELECT comment.*, user.email, user.showemail, user.displayname
 286         FROM " . TABLE_PREFIX . "comment AS comment
 287         LEFT JOIN " . TABLE_PREFIX . "user AS user
 288                 ON (comment.userid = user.userid)
 289         WHERE comment.bugid = $bug[bugid]" . ((!can_perform('canviewhidden', $bug['productid'])) ? "
 290                 AND !hidden" : '') . "
 291         ORDER BY comment.dateline ASC"
 292 );
 293 while ($comment = $db->fetch_array($comments_fetch))
 294 {
 295         $comment['posttime'] = $datef->format($bugsys->options['dateformat'], $comment['dateline']);
 296         $comment['postby'] = construct_user_display($comment);
 297         $show['editcomment'] = ((can_perform('caneditownreply', $bug['productid']) AND $bugsys->userinfo['userid'] == $comment['userid']) OR (can_perform('caneditotherreply', $bug['productid']) AND $bugsys->userinfo['userid'] != $comment['userid']));
 298
 299         $bugsys->debug((int)(can_perform('caneditownreply', $bug['productid']) AND $bugsys->userinfo['userid'] == $comment['userid']));
 300         $bugsys->debug((int)(can_perform('caneditotherreply', $bug['productid']) AND $bugsys->userinfo['userid'] != $comment['userid']));
 301         $bugsys->debug($show['editcomment']);
 302
 303         if (is_array($hilight))
 304         {
 305                 foreach ($hilight AS $id => $find)
 306                 {
 307                         $find = "#($find)#";
 308                         $replace = "<span style=\"background-color: yellow; font-weight: bold; color: red;\">\\1</span>";
 309                         $comment['comment_parsed'] = preg_replace($find, $replace, $comment['comment_parsed']);
 310                 }
 311         }
 312
 313         eval('$comments .= "' . $template->fetch('showreport_comment') . '";');
 314 }
 315
 316 $show['newreply'] = ((can_perform('canpostcomments', $bug['productid'])) ? true : false);
 317
 318 if (is_array($hilight))
 319 {
 320         foreach ($hilight AS $id => $find)
 321         {
 322                 $find = "#($find)#";
 323                 $replace = "<span style=\"background-color: yellow; font-weight: bold; color: red;\">\\1</span>";
 324                 $bug['summary'] = preg_replace($find, $replace, $bug['summary']);
 325         }
 326 }
 327
 328 eval('$template->flush("' . $template->fetch('showreport') . '");');
 329
 330 /*=====================================================================*\
 331 || ###################################################################
 332 || # $HeadURL$
 333 || # $Id$
 334 || ###################################################################
 335 \*=====================================================================*/
 336 ?>