<?php
/*=====================================================================*\
-|| ################################################################### ||
-|| # BugStrike [#]version[#]
-|| # --------------------------------------------------------------- # ||
-|| # Copyright ©2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
-|| # This file may not be reproduced in any way without permission. # ||
-|| # --------------------------------------------------------------- # ||
-|| # User License Agreement at http://www.iris-studios.com/license/ # ||
-|| ################################################################### ||
+|| ###################################################################
+|| # Bugdar
+|| # Copyright (c)2004-2009 Blue Static
+|| #
+|| # This program is free software; you can redistribute it and/or modify
+|| # it under the terms of the GNU General Public License as published by
+|| # the Free Software Foundation; version 2 of the License.
+|| #
+|| # This program is distributed in the hope that it will be useful, but
+|| # WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
+|| # or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
+|| # more details.
+|| #
+|| # You should have received a copy of the GNU General Public License along
+|| # with this program; if not, write to the Free Software Foundation, Inc.,
+|| # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
+|| ###################################################################
\*=====================================================================*/
$fetchtemplates = array(
- 'SHOWREPORT',
+ 'showreport',
'showreport_attachment',
- 'showreport_comment'
+ 'showreport_comment',
+ 'quicksearch',
+ 'bugfield_static_text'
);
+
+$focus['showreport'] = 'focus';
+
require_once('./global.php');
+require_once('./includes/functions_product.php');
+
+$bugid = $input->inputClean('bugid', TYPE_UINT);
+
+// ###################################################################
-if (!can_perform('canviewbugs'))
+if (empty($bugid) OR $_REQUEST['do'] == 'quicksearch')
{
- $message->error_permission();
+ 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;
+ }
+ }
+
+ $tpl = new BSTemplate('quicksearch');
+ $tpl->vars = array('error' => $error);
+ $tpl->evaluate()->flush();
+ exit;
}
// ###################################################################
// -------------------------------------------------------------------
// get the report
-$bug = $db->query_first("
- SELECT bug.*, user.displayname, user.email, user.showemail
+$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 = " . intval($bugsys->in['bugid'])
+ WHERE bug.bugid = $bugid"
);
if (!is_array($bug))
{
- $message->error('alert: bad bug');
+ $message->error(L_INVALID_ID);
}
-if ($bug['hidden'] AND !can_perform('canviewhidden'))
+if (!check_bug_permissions($bug))
{
- $message->error_permission();
+ $message->errorPermission();
}
-// -------------------------------------------------------------------
-// prep display
-$bug['userinfo'] = construct_user_display($bug);
-$bug['product'] = $bugsys->datastore['product']["$bug[productid]"]['title'];
-$bug['component'] = (($bug['componentid']) ? $bugsys->datastore['product']["$bug[componentid]"]['title'] : '');
-$bug['version'] = $bugsys->datastore['version']["$bug[versionid]"]['version'];
-$bug['status'] = $bugsys->datastore['status']["$bug[status]"]['status'];
-$bug['resolution'] = $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'];
-$bug['severity'] = $bugsys->datastore['severity']["$bug[severity]"]['severity'];
-$bug['priority'] = $bugsys->datastore['priority']["$bug[priority]"]['priority'];
-
-$assigninfo = $bugsys->datastore['assignto']["$bug[assignedto]"];
-$bug['assigninfo'] = ((is_array($assigninfo)) ? construct_user_display($assigninfo) : '');
-
-$show['editreport'] = ((((can_perform('caneditown') AND $bugsys->userinfo['userid'] == $comment['userid']) OR can_perform('caneditothers')) AND can_perform('caneditinfo')) ? true : false);
+$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']);
-$duplicateof = $db->query_first("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid = $bug[duplicateof]");
-
-$duplicates = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE duplicateof = $bug[bugid]");
-while ($duplicate = $db->fetch_array($duplicates))
+// ###################################################################
+// edit display
+if ($show['edit'])
{
- $dupelist[] = "<a href=\"showreport.php?bugid=$duplicate[bugid]\" target=\"_blank\">$duplicate[summary]</a>";
+ $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 = construct_product_select('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[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\">$dependency[bugid]</a>";
+ }
+ $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'];
+ }
+ }
}
-$dupelist = implode(', ', $dupelist);
-if ($bug['dependency'])
+// ###################################################################
+// non-edit display
+else
{
- $dependencies = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
- while ($dependency = $db->fetch_array($dependencies))
+ // -------------------------------------------------------------------
+ // 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[] = "<a href=\"showreport.php?bugid=$duplicate[bugid]\" target=\"_blank\">$duplicate[summary]</a>";
+ }
+ $dupelist = implode(', ', $dupelist);
+
+ if ($bug['dependency'])
{
- $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\" target=\"_blank\">$dependency[bugid]</a>";
+ $depends = array();
+ $dependencies = $db->query("SELECT bugid, summary FROM " . TABLE_PREFIX . "bug WHERE bugid IN ($bug[dependency])");
+ foreach ($dependencies as $dependency)
+ {
+ $depends[] = "<a href=\"showreport.php?bugid=$dependency[bugid]\" title=\"$dependency[summary]\" target=\"_blank\">$dependency[bugid]</a>";
+ }
+ $dependencies = implode(' ', $depends);
}
- $dependencies = implode(' ', $depends);
}
-// -------------------------------------------------------------------
-// custom fields
-$customfields = '';
+// ###################################################################
+// global display items
-$allfields = $db->query("SELECT * FROM " . TABLE_PREFIX . "bugfield");
-while ($field = $db->fetch_array($allfields))
-{
- $fieldlist["$field[shortname]"] = $field;
-}
+$show['subscribe'] = can_perform('cansubscribe', $bug['product']);
-$fieldvalues = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "bugvaluefill WHERE bugid = $bug[bugid]");
+$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'));
-foreach ($fieldvalues AS $shortname => $value)
+$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 ($shortname == 'bugid')
- {
- continue;
- }
-
- $field =& $fieldlist["$shortname"];
-
- $customfields .= "<div><strong>$field[name]:</strong> ";
-
- if (is_null($value))
- {
- $value = $field['defaultvalue'];
- }
-
- if ($field['type'] == 'input_text' OR $field['type'] == 'textarea' OR $field['type'] == 'select_single')
+ if ($i % 2 == 0)
{
- $customfields .= $value;
+ $customfields['left'] .= $field;
}
- else if ($field['type'] == 'input_checkbox')
+ else
{
- $customfields .= (($value) ? 'True' : 'False');
+ $customfields['right'] .= $field;
}
- $customfields .= "</div>\n\n";
+ $i++;
}
+// ###################################################################
+// other elements
+
// -------------------------------------------------------------------
// hilight
-$words = explode(' ', $bugsys->in['hilight']);
+$words = explode(' ', $input->in['hilight']);
foreach ($words AS $word)
{
if (trim($word))
{
- $word = preg_quote($bugsys->unsanitize($word));
+ $word = preg_quote($input->unsanitize($word));
$hilight[] = $temp = trim(preg_replace('#[^0-9a-zA-Z_ ]#', '', $word));
}
}
// -------------------------------------------------------------------
// attachments
-$show['getattachments'] = ((can_perform('cangetattach') OR can_perform('caneditattach')) ? true : false);
-$show['putattachments'] = ((can_perform('canputattach') OR can_perform('caneditattach')) ? true : false);
+$show['getattachments'] = (can_perform('cangetattach', $bug['productid']) || can_perform('caneditattach', $bug['productid']));
+$show['putattachments'] = (can_perform('canputattach', $bug['productid']) || can_perform('caneditattach', $bug['productid']));
+$show['attachments'] = ($show['getattachments'] || $show['putattachments']);
-if ($show['getattachments'] OR $show['putattachments'])
+if ($show['getattachments'] || $show['putattachments'])
{
$attachments_fetch = $db->query("
- SELECT attachment.*, user.email, user.showemail,
- user.displayname
+ 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"
);
- while ($attachment = $db->fetch_array($attachments_fetch))
+
+ $attaches = false;
+ foreach ($attachments_fetch as $attachment)
{
- $show['editattach'] = ((can_perform('caneditattach') OR ($attachment['userid'] == $bugsys->userinfo['userid'] AND can_perform('canputattach'))) ? true : false);
- $attachment['date'] = datelike('standard', $attachment['dateline']);
+ $attaches = true;
+ $show['editattach'] = (can_perform('caneditattach', $bug['productid']) || ($attachment['userid'] == bugdar::$userinfo['userid'] && can_perform('canputattach', $bug['productid'])));
+ $attachment['date'] = $datef->format(bugdar::$options['dateformat'], $attachment['dateline']);
$attachment['user'] = construct_user_display($attachment, false);
- eval('$attachments .= "' . $template->fetch('showreport_attachment') . '";');
+
+ $tpl = new BSTemplate('showreport_attachment');
+ $tpl->vars = array(
+ 'attachment' => $attachment
+ );
+ $attachments .= $tpl->evaluate()->getTemplate();
}
+
+ $show['attachments'] = ($show['putattachments'] && $attaches);
}
+// -------------------------------------------------------------------
+// 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("
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')) ? "
+ WHERE comment.bugid = $bug[bugid]" . (!can_perform('canviewhidden', $bug['productid']) ? "
AND !hidden" : '') . "
ORDER BY comment.dateline ASC"
);
-while ($comment = $db->fetch_array($comments_fetch))
+$description = null;
+foreach ($comments_fetch as $comment)
{
- $comment['posttime'] = datelike('standard', $comment['dateline']);
+ $comment['posttime'] = $datef->format(bugdar::$options['dateformat'], $comment['dateline']);
$comment['postby'] = construct_user_display($comment);
- $show['editcomment'] = (((can_perform('caneditown') AND $bugsys->userinfo['userid'] == $comment['userid']) OR can_perform('caneditothers')) ? true : false);
+ $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)#";
+ $find = "#($find)#i";
$replace = "<span style=\"background-color: yellow; font-weight: bold; color: red;\">\\1</span>";
$comment['comment_parsed'] = preg_replace($find, $replace, $comment['comment_parsed']);
}
}
- eval('$comments .= "' . $template->fetch('showreport_comment') . '";');
+ $tpl = new BSTemplate('showreport_comment');
+ $tpl->vars = array('comment' => $comment);
+ $temp = $tpl->evaluate()->getTemplate();
+ if ($description == null)
+ {
+ $description = $temp;
+ }
+ else
+ {
+ $comments .= $temp;
+ }
}
-$show['newreply'] = ((can_perform('canpostcomments')) ? true : false);
+$show['newreply'] = (can_perform('canpostcomments', $bug['productid']) ? true : false);
-if (is_array($hilight))
+$bug['summary_title'] = $bug['summary'];
+if (is_array($hilight) AND !$show['edit'])
{
foreach ($hilight AS $id => $find)
{
- $find = "#($find)#";
+ $find = "#($find)#i";
$replace = "<span style=\"background-color: yellow; font-weight: bold; color: red;\">\\1</span>";
$bug['summary'] = preg_replace($find, $replace, $bug['summary']);
}
}
-eval('$template->flush("' . $template->fetch('SHOWREPORT') . '");');
+$tpl = new BSTemplate('showreport');
+$tpl->vars = array(
+ 'bug' => $bug,
+ 'comments' => $comments,
+ 'select' => $select,
+ 'vote' => $vote,
+ 'favoritetext' => $favoritetext,
+ 'customfields' => $customfields,
+ 'attachments' => $attachments,
+ 'productSelect' => $productSelect
+);
+$tpl->evaluate()->flush();
-/*=====================================================================*\
-|| ###################################################################
-|| # $HeadURL$
-|| # $Id$
-|| ###################################################################
-\*=====================================================================*/
?>
\ No newline at end of file