<?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();
<?php include '../include.php'; url_query_require(); if (url_action('delete')) { db_delete('press_clips', $_GET['delete_id']); url_change('/press-clips/'); } echo drawTop(); echo drawTableStart(); echo drawHeaderRow($page['breadcrumbs'] . $page['title'], 2, getString('edit'), 'edit/?id=' . $_GET['id'], getString('delete'), drawDeleteLink()); $r = db_grab('SELECT c.title' . langExt() . ' title, c.url, c.pub_date, c.publication' . langExtT() . ' publication, c.type_id, c.description' . langExt() . ' description, t.title' . langExt() . ' type FROM press_clips c JOIN press_clips_types t ON c.type_id = t.id WHERE c.id = ' . $_GET['id']); ?> <tr> <td class="left"><?php echo getString('title'); ?> </td> <td class='title'><?php echo $r['title']; ?> </td> </tr> <tr> <td class="left"><?php echo getString('category'); ?> </td> <td><?php echo draw_link('categories.php?id=' . $r['type_id'], $r['type']); ?>
<?php include 'include.php'; url_query_require('skills.php'); if (!($skill = db_grab('SELECT title FROM skills where isActive = 1 AND id = ' . url_id()))) { url_chagne('skills.php'); } echo drawTop(); echo drawTableStart(); if ($isAdmin) { echo drawHeaderRow($skill, 1, 'Edit', 'skill_add_edit.php?id=' . url_id()); } else { echo drawHeaderRow($skill, 1); } if ($users = db_table('SELECT u.userID, u.firstName, u.lastName FROM users_to_skills u2s JOIN intranet_users u ON u2s.user_id = u.userID WHERE u2s.skill_id = ' . url_id() . ' AND u.isActive = 1 ORDER BY u.lastName, u.firstName')) { ?> <tr> <th>User</th> </tr> <?php foreach ($users as $u) { echo '<tr> <td><a href="view.php?id=' . $u['userID'] . '">' . $u['firstName'] . ' ' . $u['lastName'] . '</a></td> </tr>';
<?php include "include.php"; url_query_require("users.php"); echo drawTop(); $result = db_query("select\r\n\t\t\t\tt.title,\r\n\t\t\t\tt.statusID,\r\n\t\t\t\t(SELECT COUNT(*) FROM helpdesk_tickets_followups f where f.ticketID = t.id) as ticketfollowups,\r\n\t\t\t\tt.created_user,\r\n\t\t\t\tt.updated_date,\r\n\t\t\t\tt.id,\r\n\t\t\t\tt.ownerID,\r\n\t\t\t\tt.priorityID,\r\n\t\t\t\tt.created_date,\r\n\t\t\t\tISNULL(u.nickname, u.firstname) first,\r\n\t\t\t\tu.lastname last,\r\n\t\t\t\t(SELECT COUNT(*) FROM users_to_modules a WHERE a.module_id = 3 AND a.user_id = t.created_user) is_adminIT\r\n\t\t\tFROM helpdesk_tickets t\r\n\t\t\tJOIN users u ON u.id = t.created_user\r\n\t\t\tWHERE t.created_user = {$_GET["id"]} {$where}\r\n\t\t\tORDER BY t.created_date DESC"); echo drawTicketFilter(); ?> <table class="left" cellspacing="1"> <?php $u = db_grab("SELECT ISNULL(nickname, firstname) first, lastname last FROM users WHERE id = " . $_GET["id"]); echo drawHeaderRow("<a href='users.php' class='white'>Users</a> > " . $u["first"] . " " . $u["last"] . " (" . 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 for this user / month / year.", 5); } else { echo drawEmptyResult("This user hasn't posted any tickets.", 5); } } ?> </table> <?php echo drawBottom();
<?php include "../../include.php"; url_query_require("types.php"); echo drawTop(); $r = db_grab("SELECT description FROM wiki_topics_types WHERE id = " . $_GET["id"]); ?> <table class="left" cellspacing="1"> <?php echo drawHeaderRow("<a href='types.php' class='white'>Types</a> > " . $r["description"], 4); $topics = db_query("SELECT \n\t\tw.id,\n\t\tw.title,\n\t\tw.description,\n\t\tISNULL(u.nickname, u.firstname) first,\n\t\tu.lastname last,\n\t\tw.created_date\n\tFROM wiki_topics w\n\tJOIN wiki_topics_types t ON w.type_id = t.id\n\tJOIN users u ON w.created_user = u.id\n\tWHERE w.is_active = 1 AND w.type_id = " . $_GET["id"]); if (db_found($topics)) { ?> <tr> <th width="16"></th> <th align="left">Title</th> <th align="left" width="100">Created By</th> <th align="right" width="80">Created On</th> </tr> <?php while ($t = db_fetch($topics)) { ?> <tr height="36"> <td></td> <td><a href="topic.php?id=<?php echo $t["id"]; ?> "><?php echo $t["title"]; ?> </a></td>
<?php include '../include.php'; //need a type url_query_require('./'); if (url_action('delete')) { db_delete('external_orgs', $_GET['org_id']); url_drop('action,org_id'); } echo drawTop(); //main table echo drawTableStart(); if ($page['is_admin']) { echo drawHeaderRow($page['breadcrumbs'] . format_string(db_grab('SELECT title' . langExt() . ' title FROM external_orgs_types WHERE id = ' . $_GET['id'])), 1, getString('add_new'), '#bottom'); } else { echo drawHeaderRow($page['breadcrumbs'] . format_string(db_grab('SELECT title' . langExt() . ' title FROM external_orgs_types WHERE id = ' . $_GET['id']))); } $orgs = db_query('SELECT o.id, o.url, o.title' . langExt() . ' title, o.description' . langExt() . ' description FROM external_orgs o ' . getChannelsWhere('external_orgs', 'o', 'org_id') . ' AND (SELECT COUNT(*) FROM external_orgs_to_types t WHERE t.org_id = o.id AND t.type_id = ' . $_GET['id'] . ' > 0) ORDER BY o.title'); if (db_found($orgs)) { while ($o = db_fetch($orgs)) { ?> <tr> <td class='text'> <?php if ($page['is_admin']) { ?>
<?php include "include.php"; url_query_require("offices.php"); echo drawTop(); $result = db_query("SELECT\n\t\t\t\tt.title,\n\t\t\t\tt.statusID,\n\t\t\t\t(SELECT COUNT(*) FROM helpdesk_tickets_followups f where f.ticketID = t.id) as ticketfollowups,\n\t\t\t\tt.created_user,\n\t\t\t\tt.updated_date,\n\t\t\t\tt.id,\n\t\t\t\tt.ownerID,\n\t\t\t\tt.priorityID,\n\t\t\t\tt.created_date,\n\t\t\t\tISNULL(u.nickname, u.firstname) first,\n\t\t\t\tu.lastname last,\n\t\t\t\t(SELECT COUNT(*) FROM users_to_modules a WHERE a.module_id = 3 AND a.user_id = t.created_user) is_adminIT\n\t\t\tFROM helpdesk_tickets t\n\t\t\tJOIN users u ON u.id = t.created_user\n\t\t\tWHERE u.officeID = {$_GET["id"]} {$where}\n\t\t\tORDER BY t.created_date DESC"); echo drawTicketFilter(); ?> <table class="left" cellspacing="1"> <?php echo drawHeaderRow("<a href='offices.php' class='white'>Offices</a> > " . db_grab("SELECT name FROM offices WHERE id = " . $_GET["id"]) . " (" . 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 for this office / month / year.", 5); } else { echo drawEmptyResult("No tickets have been posted from this office.", 5); } } ?> </table> <?php echo drawBottom();