<?php include "include.php"; url_query_require("admins.php"); echo drawTop(); echo drawTicketFilter(); ?> <table class="left" cellspacing="1"> <?php $result = db_query("SELECT\r\n\t\t\t\t\t\tt.title,\r\n\t\t\t\t\t\tt.statusID,\r\n\t\t\t\t\t\t(SELECT COUNT(*) FROM helpdesk_tickets_followups f WHERE f.ticketID = t.id) as ticketfollowups,\r\n\t\t\t\t\t\tt.created_user,\r\n\t\t\t\t\t\tt.updated_date,\r\n\t\t\t\t\t\tt.id,\r\n\t\t\t\t\t\tt.ownerID,\r\n\t\t\t\t\t\tt.priorityID,\r\n\t\t\t\t\t\tt.created_date,\r\n\t\t\t\t\t\tISNULL(u.nickname, u.firstname) first,\r\n\t\t\t\t\t\tu.lastname last\r\n\t\t\t\t\tFROM helpdesk_tickets t\r\n\t\t\t\t\tJOIN users u ON u.id = t.created_user\r\n\t\t\t\t\tWHERE t.ownerID = {$_GET["id"]} {$where}\r\n\t\t\t\t\tORDER BY t.created_date DESC"); $admin = db_grab("SELECT ISNULL(u.nickname, u.firstname) first FROM users u WHERE u.id = " . $_GET["id"]); echo drawHeaderRow("<a href='admins.php' class='white'>Admins</a> > " . $admin["first"] . " (" . db_found($result) . ")", 5); if (db_found($result)) { echo drawTicketHeader(); while ($r = db_fetch($result)) { echo drawTicketRow($r); } } else { if ($filtered) { echo drawEmptyResult("No tickets were assigned to this admin in this month / year", 5); } else { echo drawEmptyResult("No tickets were assigned to this admin.", 5); } } ?> </table> <?php echo drawBottom();
while ($r = db_fetch($tickets)) { echo drawTicketRow($r, "type"); } } else { if ($filtered) { echo drawHeaderRow("<a class='white' href='types.php'>Types</a> > " . $type . " (" . db_found($tickets) . ")", 5); echo drawEmptyResult("No tickets have this type / month / year.", 5); } else { echo drawHeaderRow("<a class='white' href='types.php'>Types</a> > " . $type . " (" . db_found($tickets) . ")", 5, "edit name", "type_add_edit.php?id=" . $_GET["id"], "delete", $request["path_query"] . "&deleteType=true"); echo drawEmptyResult("No tickets are tagged as this type. You can delete the type above.", 5); } } } else { echo drawHeaderRow("<a class='white' href='types.php'>Types</a> > No Type Set" . " (" . db_found($tickets) . ")", 5); if (db_found($tickets)) { echo drawTicketHeader(); while ($r = db_fetch($tickets)) { echo drawTicketRow($r, "type"); } } else { if ($filtered) { echo drawEmptyResult("No tickets are untyped in this month / year.", 5); } else { echo drawEmptyResult("No tickets are untyped! Excellent!", 5); } } } ?> </table> <?php echo drawBottom();