Beispiel #1
0
<?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> &gt; " . $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();
Beispiel #2
0
        while ($r = db_fetch($tickets)) {
            echo drawTicketRow($r, "type");
        }
    } else {
        if ($filtered) {
            echo drawHeaderRow("<a class='white' href='types.php'>Types</a> &gt; " . $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> &gt; " . $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> &gt; 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();