view_tickets.inc

不错的东西

<?php
$query = $sql->query("SELECT * FROM tickets WHERE `status` = '1' OR `status` = '2' ORDER BY `date` ASC");
while($data = mysql_fetch_assoc($query))
{
	$_user['tickets'][$data['tid']]['level'] = $data['level'];
	$_user['tickets'][$data['tid']]['status'] = $data['status'];
	$_user['tickets'][$data['tid']]['hostname'] = $data['hostname'];
	$_user['tickets'][$data['tid']]['date'] = $data['date'];
	/*
	*  Modified: 10/27/05
	*  Justin Osterholt
	*  Quote/slash fix
	*/
	$_user['tickets'][$data['tid']]['subject'] = html_entity_decode($data['subject'], ENT_QUOTES);
}

if(isset($_GET['tid']))
{
	$query = $sql->query("SELECT * FROM tickets AS a LEFT JOIN messages AS b ON (a.tid = b.tid) WHERE a.tid = '" . mysql_escape_string($_GET['tid']) . "' LIMIT 1") or die(mysql_error());
	$data = mysql_fetch_assoc($query);
	$level_txt = array("None","Low","Medium","High");
	$status_txt = array("Closed","Open","On Hold");
	$ticket_status = $data['status'];
	?>

	<table border="1" width="70%">
	<tr>
		<td width=150>Ticket ID:</td>
		<td><? echo $data['tid']; ?></td>
	</tr>
	<tr>
		<td width=150>Level:</td>
		<td><? echo $level_txt[$data['level']]; ?></td>
	</tr>
	<tr>
		<td width=150>Status:</td>
		<td><? echo $status_txt[$data['status']]; ?></td>
	</tr>
	<tr>
		<td width=150>Date:</td>
		<td><? echo date("M. j, Y @ g:ia", $data['date']); ?></td>
	</tr>
	<tr>
		<td width=150>Hostname:</td>
		<td><? echo long2ip($data['hostname']); ?></td>
	</tr>
	<tr>
		<td width=150>Subject:</td>
		<td><? echo $data['subject']; ?></td>
	</tr>
	<?
	$query = $sql->query("SELECT * FROM `messages` WHERE `tid` = '".mysql_escape_string($_GET['tid'])."' ORDER BY `date` ASC");
        while ($data = mysql_fetch_assoc($query)) {
		$usrquery = $sql->query("SELECT * FROM `accounts` WHERE `id` = '".$data['id']."' LIMIT 1") or die(mysql_error());
		$usrrow = mysql_fetch_assoc($usrquery);
		/*
		*  Modified: 10/27/05
		*  Justin Osterholt
		*  Slash/quote fix
		*/
	?>
	<tr>
		<td colspan="2"><? echo html_entity_decode($data['message'], ENT_QUOTES); ?><br><br><i>Posted by <span style='align: right'><? echo $usrrow['username']; ?></i></span></td>
	</tr>
	<?
	}
	?>
	</table><br><br>
	<b>Add Reply</b><BR>
	<form name="addreply" method="post" action="?page=view_tickets">
	<input type="hidden" name="tid" value="<? echo $_GET['tid']; ?>">
	<TEXTAREA NAME="replymsg" COLS=40 ROWS=6></TEXTAREA><br><input type="submit" name="submit" value="Add Reply">
	</form><br><br>
	<?
	if ($ticket_status != 0) {
	 echo '<a href="?page=edit_ticket&tid='.$_GET['tid'].'&action=close">[Close Ticket]</a> ';
	 if ($ticket_status == 2) {
	  echo '<a href="?page=edit_ticket&tid='.$_GET['tid'].'&action=open">[Open Ticket]</a> ';
	 }
	}
	else
	{
	 echo '<a href="?page=edit_ticket&tid='.$_GET['tid'].'&action=open">[Open Ticket]</a> ';
	}
	if ($ticket_status != 2) {
 	 echo '<a href="?page=edit_ticket&tid='.$_GET['tid'].'&action=hold">[Put On Hold]</a> ';
	}
	?>
	<a href="?page=edit_ticket&tid=<? echo $_GET['tid']; ?>&action=delete">[Delete Ticket]</a> 
	<?php
}
else
{
	?>

	<table width="50%">
	<tr>
		<td>ID</td>
		<td>SUBJECT</td>
		<td>OPEN</td>
		<td>LEVEL</td>
		<td>STATUS</td>
	</tr>

	<?php
	$level_txt = array("None","Low","Medium","High");
	$status_txt = array("Closed","Open","On Hold");
	if (isset($_user)) {
	foreach($_user['tickets'] as $k => $ticket)
	{
		?>
	
		<tr>
			<td><a href="?page=view_tickets&tid=<?=$k?>"><?=$k?></a></td>
			<td><a href="?page=view_tickets&tid=<?=$k?>"><?=$_user['tickets'][$k]['subject']?></a></td>
			<td><?=$_user['tickets'][$k]['date']?></td>
			<td><?=$level_txt[$_user['tickets'][$k]['level']]?></td>
			<td><?=$status_txt[$_user['tickets'][$k]['status']]?></td>
		</tr>
	
		<?php
	}
	}
}
?>

</table>
<br><br>
<a href="?page=closed_tickets">[View Closed]</a>