inputClean('bugid', TYPE_UINT);
// ###################################################################
if (empty($bugid) OR $_REQUEST['do'] == 'quicksearch')
{
if (!empty($bugid))
{
if ($db->queryFirst("SELECT bugid FROM " . TABLE_PREFIX . "bug WHERE bugid = $bugid"))
{
header("Location: showreport.php?bugid=$bugid");
exit;
}
else
{
$error = L_INVALID_ID;
}
}
eval('$template->flush("' . $template->fetch('quicksearch') . '");');
exit;
}
// ###################################################################
// -------------------------------------------------------------------
// get the report
$bug = $db->queryFirst("
SELECT bug.*, user.email, user.displayname, user.showemail
FROM " . TABLE_PREFIX . "bug AS bug
LEFT JOIN " . TABLE_PREFIX . "user AS user
ON (bug.userid = user.userid)
WHERE bug.bugid = $bugid"
);
if (!is_array($bug))
{
$message->error(L_INVALID_ID);
}
if (!check_bug_permissions($bug))
{
$message->errorPermission();
}
$show['edit'] = ((can_perform('caneditown', $bug['product']) AND bugdar::$userinfo['userid'] == $bug['userid'] AND $bug['userid'] != 0) OR (can_perform('caneditother', $bug['product']) AND bugdar::$userinfo['userid'] != $bug['userid']));
$show['delete'] = can_perform('candeletedata', $bug['product']);
// ###################################################################
// edit display
if ($show['edit'])
{
$select['severity'] = construct_datastore_select('severity', 'severity', 'severityid', $bug['severity']);
$show['changestatus'] = (can_perform('canchangestatus', $bug['product']) ? true : false);
if (can_perform('canchangestatus', $bug['product']))
{
$select['priority'] = construct_datastore_select('priority', 'priority', 'priorityid', $bug['priority']);
$select['status'] = construct_datastore_select('status', 'status', 'statusid', $bug['status']);
$select['resolution'] = construct_datastore_select('resolution', 'resolution', 'resolutionid', $bug['resolution']);
}
else
{
$bug['status'] = bugdar::$datastore['status']["$bug[status]"]['status'];
$bug['resolution'] = bugdar::$datastore['resolution']["$bug[resolution]"]['resolution'];
$bug['severity'] = bugdar::$datastore['severity']["$bug[severity]"]['severity'];
$bug['priority'] = bugdar::$datastore['priority']["$bug[priority]"]['priority'];
}
$show['assign'] = (can_perform('canassign', $bug['product']));
if (can_perform('canassign', $bug['product']) && is_array(bugdar::$datastore['assignto']))
{
foreach (bugdar::$datastore['assignto'] as $dev)
{
$tpl = new BSTemplate('selectoption');
$tpl->vars = array(
'value' => $dev['userid'],
'label' => construct_user_display($dev, false),
'selected' => ($dev['userid'] == $bug['assignedto'])
);
$select['dev'] .= $tpl->evaluate()->getTemplate();
}
}
$productSelect = ConstructProductSelect('canviewbugs', "$bug[product],$bug[component],$bug[version]");
if ($bug['duplicateof'])
{
$duplicate = $db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
}
if ($bug['dependency'])
{
$depends = array();
$dependencies = $db->query("SELECT * FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
foreach ($dependencies as $dependency)
{
$depends[] = "$dependency[bugid]";
}
$dependencies = implode(' ', $depends);
}
$select['automations'] = '';
$show['automations'] = false;
if (is_array(bugdar::$datastore['automation']))
{
foreach (bugdar::$datastore['automation'] as $action)
{
$tpl = new BSTemplate('selectoption');
$tpl->vars = array(
'label' => $action['name'],
'value' => $action['actionid'],
'selected' => false
);
$select['automation'] .= $tpl->evaluate()->getTemplate();
$show['automations'] = true;
}
if ($show['automations'])
{
$tpl = new BSTemplate('selectoption');
$tpl->vars = array(
'label' => '',
'value' => 0,
'selected' => true
);
$select['automation'] = $tpl->evaluate()->getTemplate() . $select['automation'];
}
}
}
// ###################################################################
// non-edit display
else
{
// -------------------------------------------------------------------
// prep display
$bug['status'] = bugdar::$datastore['status']["$bug[status]"]['status'];
$bug['resolution'] = bugdar::$datastore['resolution']["$bug[resolution]"]['resolution'];
$bug['severity'] = bugdar::$datastore['severity']["$bug[severity]"]['severity'];
$bug['priority'] = bugdar::$datastore['priority']["$bug[priority]"]['priority'];
$assigninfo = bugdar::$datastore['assignto']["$bug[assignedto]"];
$bug['assigninfo'] = ((is_array($assigninfo)) ? construct_user_display($assigninfo) : '');
$duplicateof = $db->queryFirst("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
$dupelist = array();
$duplicates = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE duplicateof = $bug[bugid]");
foreach ($duplicates as $duplicate)
{
$dupelist[] = "$duplicate[summary]";
}
$dupelist = implode(', ', $dupelist);
if ($bug['dependency'])
{
$depends = array();
$dependencies = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
foreach ($dependencies as $dependency)
{
$depends[] = "$dependency[bugid]";
}
$dependencies = implode(' ', $depends);
}
}
// ###################################################################
// global display items
$show['subscribe'] = can_perform('cansubscribe', $bug['product']);
$favorite = (bool)$db->queryFirst("SELECT * FROM " . TABLE_PREFIX . "favorite WHERE bugid = $bug[bugid] AND userid = " . bugdar::$userinfo['userid']);
$favoritetext = ($favorite ? T('Remove from Favorites') : T('Add to Favorites'));
$bug['userinfo'] = construct_user_display($bug);
$bug['datetime'] = $datef->format(bugdar::$options['dateformat'], $bug['dateline']);
$bug['productid'] = $bug['product'];
$bug['product'] = bugdar::$datastore['product']["$bug[product]"]['title'];
$bug['componentid'] = $bug['component'];
$bug['component'] = ($bug['component'] ? bugdar::$datastore['product']["$bug[component]"]['title'] : '');
$bug['versionid'] = $bug['version'];
$bug['version'] = bugdar::$datastore['version']["$bug[version]"]['version'];
// ###################################################################
// custom field output
$fields = construct_custom_fields($bug);
$i = 0;
foreach ($fields AS $field)
{
if ($i % 2 == 0)
{
$customfields['left'] .= $field;
}
else
{
$customfields['right'] .= $field;
}
$i++;
}
// ###################################################################
// other elements
// -------------------------------------------------------------------
// hilight
$words = explode(' ', $input->in['hilight']);
foreach ($words AS $word)
{
if (trim($word))
{
$word = preg_quote($bugsys->unsanitize($word));
$hilight[] = $temp = trim(preg_replace('#[^0-9a-zA-Z_ ]#', '', $word));
}
}
// -------------------------------------------------------------------
// attachments
$show['getattachments'] = ((can_perform('cangetattach', $bug['productid']) OR can_perform('caneditattach', $bug['productid'])) ? true : false);
$show['putattachments'] = ((can_perform('canputattach', $bug['productid']) OR can_perform('caneditattach', $bug['productid'])) ? true : false);
$show['attachments'] = ($show['getattachments'] OR $show['putattachments']) ? true : false;
if ($show['getattachments'] OR $show['putattachments'])
{
$attachments_fetch = $db->query("
SELECT attachment.attachmentid, attachment.filename,
attachment.description, attachment.dateline,
attachment.userid, attachment.obsolete, user.email,
user.showemail, user.displayname
FROM " . TABLE_PREFIX . "attachment AS attachment
LEFT JOIN " . TABLE_PREFIX . "user AS user
ON (attachment.userid = user.userid)
WHERE attachment.bugid = $bug[bugid]
ORDER BY attachment.dateline"
);
$attaches = false;
foreach ($attachments_fetch as $attachment)
{
$attaches = true;
$show['editattach'] = ((can_perform('caneditattach', $bug['productid']) OR ($attachment['userid'] == bugdar::$userinfo['userid'] AND can_perform('canputattach', $bug['productid']))) ? true : false);
$attachment['date'] = $datef->format(bugdar::$options['dateformat'], $attachment['dateline']);
$attachment['user'] = construct_user_display($attachment, false);
eval('$attachments .= "' . $template->fetch('showreport_attachment') . '";');
}
$show['attachments'] = (!$show['putattachments'] AND !$attaches) ? false : true;
}
// -------------------------------------------------------------------
// votes
$vote = $db->queryFirst("SELECT *, FIND_IN_SET(" . bugdar::$userinfo['userid'] . ", userids) AS uservote FROM " . TABLE_PREFIX . "vote WHERE bugid = $bug[bugid]");
$vote['total'] = $vote['votefor'] + $vote['voteagainst'];
if ($vote['total'] != 0)
{
$vote['forpercent'] = round($vote['votefor'] / $vote['total'], 3) * 100;
$vote['againstpercent'] = round($vote['voteagainst'] / $vote['total'], 3) * 100;
}
else
{
$vote['forpercent'] = 0;
$vote['againstpercent'] = 0;
}
$show['vote'] = ((can_perform('canvote', $bug['productid']) AND !$vote['uservote']) ? true : false);
// -------------------------------------------------------------------
// get comments
$comments_fetch = $db->query("
SELECT comment.*, user.email, user.showemail, user.displayname
FROM " . TABLE_PREFIX . "comment AS comment
LEFT JOIN " . TABLE_PREFIX . "user AS user
ON (comment.userid = user.userid)
WHERE comment.bugid = $bug[bugid]" . (!can_perform('canviewhidden', $bug['productid']) ? "
AND !hidden" : '') . "
ORDER BY comment.dateline ASC"
);
foreach ($comments_fetch as $comment)
{
$comment['posttime'] = $datef->format(bugdar::$options['dateformat'], $comment['dateline']);
$comment['postby'] = construct_user_display($comment);
$show['editcomment'] = ((can_perform('caneditownreply', $bug['productid']) AND bugdar::$userinfo['userid'] == $comment['userid']) OR (can_perform('caneditotherreply', $bug['productid']) AND bugdar::$userinfo['userid'] != $comment['userid']));
BSApp::debug('can edit own replies: ' . (int)(can_perform('caneditownreply', $bug['productid']) AND bugdar::$userinfo['userid'] == $comment['userid']));
BSApp::debug('can edit other replies:' . (int)(can_perform('caneditotherreply', $bug['productid']) AND bugdar::$userinfo['userid'] != $comment['userid']));
BSApp::debug('$show[editcomment]: ' . $show['editcomment']);
if (is_array($hilight))
{
foreach ($hilight AS $id => $find)
{
$find = "#($find)#i";
$replace = "\\1";
$comment['comment_parsed'] = preg_replace($find, $replace, $comment['comment_parsed']);
}
}
$tpl = new BSTemplate('showreport_comment');
$tpl->vars = array('comment' => $comment);
$comments .= $tpl->evaluate()->getTemplate();
}
$show['newreply'] = (can_perform('canpostcomments', $bug['productid']) ? true : false);
$bug['summary_title'] = $bug['summary'];
if (is_array($hilight) AND !$show['edit'])
{
foreach ($hilight AS $id => $find)
{
$find = "#($find)#i";
$replace = "\\1";
$bug['summary'] = preg_replace($find, $replace, $bug['summary']);
}
}
$tpl = new BSTemplate('showreport');
$tpl->vars = array(
'bug' => $bug,
'comments' => $comments,
'select' => $select,
'vote' => $vote
);
$tpl->evaluate()->flush();
/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>