showreport.php

   1 <?php
   2 /*=====================================================================*\
   3 || ################################################################### ||
   4 || # Bugdar [#]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'] AND $bug['userid'] != 0) 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('canviewbugs', "p$bug[productid]c$bug[componentid]v$bug[versionid]");
 130
 131         if ($bug['duplicateof'])
 132         {
 133                 $duplicate = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
 134         }
 135
 136         if ($bug['dependency'])
 137         {
 138                 $dependencies = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
 139                 while ($dependency = $db->fetch_array($dependencies))
 140                 {
 141                         $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\">$dependency[bugid]</a>";
 142                 }
 143                 $dependencies = implode(' ', $depends);
 144         }
 145
 146         $select['autoactions'] = '';
 147         $show['autoactions'] = false;
 148         foreach ($bugsys->datastore['autoaction'] AS $action)
 149         {
 150                 $label = $action['name'];
 151                 $value = $action['actionid'];
 152                 $selected = false;
 153                 eval('$select[autoaction] .= "' . $template->fetch('selectoption') . '";');
 154                 $show['autoactions'] = true;
 155         }
 156         if ($show['autoactions'])
 157         {
 158                 $label = '';
 159                 $value = 0;
 160                 $selected = true;
 161                 eval('$select[autoaction] = "' . $template->fetch('selectoption') . '" . $select[autoaction];');
 162         }
 163 }
 164
 165 // ###################################################################
 166 // non-edit display
 167 else
 168 {
 169         // -------------------------------------------------------------------
 170         // prep display
 171         $bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
 172         $bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
 173         $bug['severity'] = $bugsys->datastore['severity']["$bug[severity]"]['severity'];
 174         $bug['priority'] = $bugsys->datastore['priority']["$bug[priority]"]['priority'];
 175
 176         $assigninfo = $bugsys->datastore['assignto']["$bug[assignedto]"];
 177         $bug['assigninfo'] = ((is_array($assigninfo)) ? construct_user_display($assigninfo) : '');
 178
 179         $duplicateof = $db->query_first("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
 180
 181         $duplicates = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE duplicateof = $bug[bugid]");
 182         while ($duplicate = $db->fetch_array($duplicates))
 183         {
 184                 $dupelist[] = "<a href=\"showreport.php?bugid=$duplicate[bugid]\" target=\"_blank\">$duplicate[summary]</a>";
 185         }
 186         $dupelist = implode(', ', $dupelist);
 187
 188         if ($bug['dependency'])
 189         {
 190                 $dependencies = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
 191                 while ($dependency = $db->fetch_array($dependencies))
 192                 {
 193                         $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\" target=\"_blank\">$dependency[bugid]</a>";
 194                 }
 195                 $dependencies = implode(' ', $depends);
 196         }
 197 }
 198
 199 // ###################################################################
 200 // custom field output
 201
 202 $fields = construct_custom_fields($bug);
 203 $show['customfields'] = ($fields ? true : false);
 204
 205 $bugsys->debug('fields modulo: ' . count($fields) % 2);
 206 $i = 1;
 207 foreach ($fields AS $field)
 208 {
 209         $bugsys->debug("i = $i");
 210         if ($i == 1)
 211         {
 212                 $customfields['right'] .= $field;
 213         }
 214         else if ($i == 2)
 215         {
 216                 $customfields['left'] .= $field;
 217                 $i = 0;
 218         }
 219         $i++;
 220 }
 221
 222 // ###################################################################
 223 // other elements
 224
 225 // -------------------------------------------------------------------
 226 // hilight
 227 $words = explode(' ', $bugsys->in['hilight']);
 228 foreach ($words AS $word)
 229 {
 230         if (trim($word))
 231         {
 232                 $word = preg_quote($bugsys->unsanitize($word));
 233                 $hilight[] = $temp = trim(preg_replace('#[^0-9a-zA-Z_ ]#', '', $word));
 234         }
 235 }
 236
 237 // -------------------------------------------------------------------
 238 // attachments
 239 $show['getattachments'] = ((can_perform('cangetattach', $bug['productid']) OR can_perform('caneditattach', $bug['productid'])) ? true : false);
 240 $show['putattachments'] = ((can_perform('canputattach', $bug['productid']) OR can_perform('caneditattach', $bug['productid'])) ? true : false);
 241 $show['attachments'] = ($show['getattachments'] OR $show['putattachments']) ? true : false;
 242
 243 if ($show['getattachments'] OR $show['putattachments'])
 244 {
 245         $attachments_fetch = $db->query("
 246                 SELECT attachment.attachmentid, attachment.filename,
 247                         attachment.description, attachment.dateline,
 248                         attachment.userid, attachment.obsolete, user.email,
 249                         user.showemail, user.displayname
 250                 FROM " . TABLE_PREFIX . "attachment AS attachment
 251                 LEFT JOIN " . TABLE_PREFIX . "user AS user
 252                         ON (attachment.userid = user.userid)
 253                 WHERE attachment.bugid = $bug[bugid]
 254                 ORDER BY attachment.dateline"
 255         );
 256
 257         $attaches = false;
 258         while ($attachment = $db->fetch_array($attachments_fetch))
 259         {
 260                 $attaches = true;
 261                 $show['editattach'] = ((can_perform('caneditattach', $bug['productid']) OR ($attachment['userid'] == $bugsys->userinfo['userid'] AND can_perform('canputattach', $bug['productid']))) ? true : false);
 262                 $attachment['date'] = $datef->format($bugsys->options['dateformat'], $attachment['dateline']);
 263                 $attachment['user'] = construct_user_display($attachment, false);
 264                 eval('$attachments .= "' . $template->fetch('showreport_attachment') . '";');
 265         }
 266
 267         $show['attachments'] = (!$show['putattachments'] AND !$attaches) ? false : true;
 268 }
 269
 270 // -------------------------------------------------------------------
 271 // votes
 272
 273 $vote = $db->query_first("SELECT *, FIND_IN_SET(" . $bugsys->userinfo['userid'] . ", userids) AS uservote FROM " . TABLE_PREFIX . "vote WHERE bugid = $bug[bugid]");
 274
 275 $vote['total'] = $vote['votefor'] + $vote['voteagainst'];
 276 $vote['forpercent'] = round($vote['votefor'] / $vote['total'], 3) * 100;
 277 $vote['againstpercent'] = round($vote['voteagainst'] / $vote['total'], 3) * 100;
 278
 279 $show['vote'] = ((can_perform('canvote', $bug['productid']) AND !$vote['uservote']) ? true : false);
 280
 281 // -------------------------------------------------------------------
 282 // get comments
 283 $comments_fetch = $db->query("
 284         SELECT comment.*, user.email, user.showemail, user.displayname
 285         FROM " . TABLE_PREFIX . "comment AS comment
 286         LEFT JOIN " . TABLE_PREFIX . "user AS user
 287                 ON (comment.userid = user.userid)
 288         WHERE comment.bugid = $bug[bugid]" . ((!can_perform('canviewhidden', $bug['productid'])) ? "
 289                 AND !hidden" : '') . "
 290         ORDER BY comment.dateline ASC"
 291 );
 292 while ($comment = $db->fetch_array($comments_fetch))
 293 {
 294         $comment['posttime'] = $datef->format($bugsys->options['dateformat'], $comment['dateline']);
 295         $comment['postby'] = construct_user_display($comment);
 296         $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']));
 297
 298         $bugsys->debug((int)(can_perform('caneditownreply', $bug['productid']) AND $bugsys->userinfo['userid'] == $comment['userid']));
 299         $bugsys->debug((int)(can_perform('caneditotherreply', $bug['productid']) AND $bugsys->userinfo['userid'] != $comment['userid']));
 300         $bugsys->debug($show['editcomment']);
 301
 302         if (is_array($hilight))
 303         {
 304                 foreach ($hilight AS $id => $find)
 305                 {
 306                         $find = "#($find)#i";
 307                         $replace = "<span style=\"background-color: yellow; font-weight: bold; color: red;\">\\1</span>";
 308                         $comment['comment_parsed'] = preg_replace($find, $replace, $comment['comment_parsed']);
 309                 }
 310         }
 311
 312         eval('$comments .= "' . $template->fetch('showreport_comment') . '";');
 313 }
 314
 315 $show['newreply'] = ((can_perform('canpostcomments', $bug['productid'])) ? true : false);
 316
 317 if (is_array($hilight))
 318 {
 319         foreach ($hilight AS $id => $find)
 320         {
 321                 $find = "#($find)#i";
 322                 $replace = "<span style=\"background-color: yellow; font-weight: bold; color: red;\">\\1</span>";
 323                 $bug['summary'] = preg_replace($find, $replace, $bug['summary']);
 324         }
 325 }
 326
 327 eval('$template->flush("' . $template->fetch('showreport') . '");');
 328
 329 /*=====================================================================*\
 330 || ###################################################################
 331 || # $HeadURL$
 332 || # $Id$
 333 || ###################################################################
 334 \*=====================================================================*/
 335 ?>