<?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();
