view_tickets.inc

不错的东西

<?php
$query = $sql->query("SELECT * FROM tickets WHERE id = '{$_SESSION['auth']['uid']}'");
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'];
	$_user['tickets'][$data['tid']]['subject'] = $data['subject'];
	$_user['tickets'][$data['tid']]['id'] = $data['id'];
}

if(isset($_GET['tid']))
{
	/*  Modified --- By Calpine */
	$query = $sql->query("SELECT * FROM tickets AS a LEFT JOIN messages AS b ON (a.tid = b.tid) WHERE a.id = '{$_SESSION['auth']['uid']}'  and a.tid = '" . mysql_escape_string($_GET['tid']) . "' LIMIT 1") or die(mysql_error());
	if($_GET['id'] == $_SESSION['auth']['uid'] && mysql_num_rows($query)>0)
	{
	
				
		$data = mysql_fetch_assoc($query);
		$level_txt = array("None","Low","Medium","High");
		$status_txt = array("Closed","Open","On Hold");
		?>

		<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("F j, Y, g:i a", $data['date']); ?></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");
			$usrrow = mysql_fetch_assoc($usrquery);
		?>
		<tr>
		<td colspan="2"><? echo $data['message']; ?><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>

	<?php
	} else { 
	/*
	*  Modified: 10/28/05
	*  Justin Osterholt
	*  Created back link to replace error
	*/
	?>
	<table border="0" width="70%">
	<tr>
		<td>Reply Posted! Click <a href='?page=view_tickets'>here</a> to go back to ticket list.</td>
	</tr>
	</table>
	<?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)
	{
		/*   Modified By Calpine */
		?>
	
		<tr> 
			<td><a href="?page=view_tickets&tid=<?=$k?>&id=<?=$_user['tickets'][$k]['id']?>"><?=$k?></a></td>
			<td><a href="?page=view_tickets&tid=<?=$k?>&id=<?=$_user['tickets'][$k]['id']?>"><?=$_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>