From d4bb7d5dfb8dfd5c878a5f83a3d835ad3a6a5554 Mon Sep 17 00:00:00 2001
From: Robert Sesek <rsesek@bluestatic.org>
Date: Thu, 23 Dec 2004 06:42:00 +0000
Subject: [PATCH] r15: Basic bug viewing.

---
 showreport.php | 114 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 114 insertions(+)
 create mode 100644 showreport.php

diff --git a/showreport.php b/showreport.php
new file mode 100644
index 0000000..d61614b
--- /dev/null
+++ b/showreport.php
@@ -0,0 +1,114 @@
+<?php
+/*=====================================================================*\
+|| ################################################################### ||
+|| # [#]app[#] [#]version[#]
+|| # --------------------------------------------------------------- # ||
+|| # All parts of this file are ©2003-[#]year[#] Iris Studios, Inc. No     # || 
+|| # part of this file may be reproduced in any way: part or whole.  # ||
+|| # --------------------------------------------------------------- # ||
+|| # ©2003 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com   # ||
+|| ################################################################### ||
+\*=====================================================================*/
+
+require_once('./global.php');
+
+if (!($bugsys->userinfo['permissions'] & CANVIEWBUGS))
+{
+	echo 'no permission';
+	exit;
+}
+
+// ###################################################################
+
+if (empty($_REQUEST['do']))
+{
+	$_REQUEST['do'] = 'modify';
+}
+
+// ###################################################################
+
+if ($_REQUEST['do'] == 'modify')
+{
+	sanitize(array('bugid' => INT));
+	
+	if (!$vars['bugid'])
+	{
+		echo 'alert: bad bug';
+		exit;
+	}
+	
+	$bugfetch = $DB_sql->query("
+		SELECT bug.*, user1.displayname, user1.email, user1.showemail,
+			comment.userid AS posterid, user2.displayname AS postedby,
+			user2.email AS posteremail, user2.showemail AS postershowemail,
+			comment.comment, comment.dateline AS postedon
+		FROM " . TABLE_PREFIX . "bug AS bug
+		LEFT JOIN " . TABLE_PREFIX . "comment AS comment
+			ON (bug.bugid = comment.bugid)
+		LEFT JOIN " . TABLE_PREFIX . "user AS user1
+			ON (bug.userid = user1.userid)
+		LEFT JOIN " . TABLE_PREFIX . "user AS user2
+			ON (comment.userid = user1.userid)
+		WHERE bug.bugid = $vars[bugid]
+		ORDER BY comment.dateline ASC"
+	);
+	while ($buginfo = $DB_sql->fetch_array($bugfetch))
+	{
+		if (!is_array($bug))
+		{
+			$bug = array(
+				'bugid' => $buginfo['bugid'],
+				'userid' => $buginfo['userid'],
+				'displayname' => $buginfo['displayname'],
+				'email' => $buginfo['email'],
+				'showemail' => $buginfo['showemail'],
+				'productid' => $buginfo['productid'],
+				'componentid' => $buginfo['componentid'],
+				'versionid' => $buginfo['versionid'],
+				'summary' => $buginfo['summary'],
+				'priority' => $buginfo['priority'],
+				'severity' => $buginfo['severity'],
+				'status' => $buginfo['status'],
+				'resolution' => $buginfo['resolution'],
+				'assignedto' => $buginfo['assignedto']
+			);
+		}
+		$comments[] = array(
+			'userid' => $buginfo['posterid'],
+			'displayname' => $buginfo['displayname'],
+			'email' => $buginfo['posteremail'],
+			'showemail' => $buginfo['postershowemail'],
+			'dateline' => $buginfo['postedon'],
+			'comment' => $buginfo['comment']
+		);
+	}
+
+	echo "<div><strong>Bug ID:</strong> $bug[bugid]</div>";
+	echo "<div><strong>Reported by:</strong> $bug[displayname]" . iff($bug['showemail'], " &lt;$bug[email]&gt;") . " (userid: $bug[userid])</div>";
+	echo "<div><strong>Product:</strong> " . $bugsys->datastore['product']["$bug[productid]"]['title'] . iff($bug['componentid'], ' / <strong>Component:</strong>' . $bugsys->datastore['product']["$bug[componentid]"]['title'] . '</strong>') . ' / <strong>Version:</strong> ' . $bugsys->datastore['version']["$bug[versionid]"]['version'] . "</div>";
+	echo "<div><strong>Title / summary:</strong> $bug[summary]</div>";
+	echo "<div><strong>Status:</strong> " . $bugsys->datastore['status']["$bug[status]"]['status'] . " / <strong>Resolution:</strong> " . $bugsys->datastore['resolution']["$bug[resolution]"]['resolution'] . "</div>";
+	echo "<div><strong>Severity:</strong> " . $bugsys->datastore['severity']["$bug[severity]"]['severity'] . "</div>";
+	echo "<div><strong>Priority:</strong> " . $bugsys->datastore['priority']["$bug[priority]"]['priority'] . "</div>";
+	$assigninfo = $bugsys->datastore['assignto']["$bug[assignedto]"];
+	echo iff(is_array($assigninfo), "<div><strong>Assigned to:</strong> " . $assigninfo['displayname'] . iff($assigninfo['showemail'], " &lt;$assigninfo[email]&gt;") . " (userid: $assigninfo[userid])</div>");
+	
+	echo '<br />';
+	
+	foreach ($comments AS $comment)
+	{
+		echo '<table border="1" cellspacing="2" cellpadding="4" width="100%"><tr style="background-color:#EEEEEE"><td><span style="float:right">' . datelike('standard', $comment['dateline']) . '</span>' . $comment['displayname'] . iff($comment['showemail'], " &lt;$comment[email]&gt;") . " (userid: $comment[userid])</td></tr>";
+		echo "<tr><td>" . nl2br($comment['comment']) . "</td></tr></table>";
+	}
+	
+	/*print_r($bug);
+	print_r($comments);*/
+}
+
+/*=====================================================================*\
+|| ###################################################################
+|| # $HeadURL$
+|| # $Id$
+|| ###################################################################
+\*=====================================================================*/
+?>
\ No newline at end of file
-- 
2.22.5