<?php
include "include.php";
drawTop();
echo drawJumpToStaff();
?>
<table class="left" cellspacing="1">
<?php
if ($isAdmin) {
echo drawHeaderRow("Comings", 2, "new", "add_edit.php");
} else {
echo drawHeaderRow("Comings", 2);
}
$staff = db_query("SELECT\n\t\tu.userID,\n\t\tISNULL(u.nickname, u.firstname) first, \n\t\tu.lastname last,\n\t\tu.title,\n\t\td.departmentName,\n\t\to.name office,\n\t\tu.startdate,\n\t\tu.bio\n\tFROM intranet_users u\n\tJOIN intranet_offices o ON u.officeID = o.id\n\tJOIN intranet_departments d ON u.departmentID = d.departmentID\n\tWHERE " . db_datediff("u.startdate", "GETDATE()") . " < 60 AND u.isActive = 1\n\tORDER BY u.startdate DESC");
while ($s = db_fetch($staff)) {
?>
<tr>
<td width="129" height="90" align="center" style="padding:1px;"><?php
echo "<a href='/staff/view.php?id=" . $s["userID"] . "'>" . drawImg($s['userID']) . "</a>";
?>
</td>
<td class="text">
<b><a href="/staff/view.php?id=<?php
echo $s["userID"];
?>
"><?php
echo $s["first"];
?>
<?php
echo $s["last"];
?>
<?php
include "../../include.php";
echo drawTop();
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Services", 2, "add new organization", "organization_add_edit.php");
?>
<tr>
<th align="left">Service</td>
<th align="right">#</td>
</tr>
<?php
$result = db_query("SELECT s.id, s.name, (SELECT count(*) FROM web_organizations_2_services o2s WHERE o2s.serviceID = s.id) as countservices FROM web_services s ORDER by s.name");
while ($r = db_fetch($result)) {
?>
<tr>
<td><a href="service.php?id=<?php
echo $r["id"];
?>
"><?php
echo $r["name"];
?>
</a></td>
<td align="right"><?php
echo $r["countservices"];
?>
</td>
</tr>
<?php
u.lastname,
t.title' . langExt($l['code']) . ' title,
t.description' . langExt($l['code']) . ' description,
y.title' . langExt($l['code']) . ' type,
t.created_date
FROM bb_topics t
LEFT JOIN bb_topics_types y ON t.type_id = y.id
JOIN users u ON t.created_user = u.id
WHERE t.id = ' . $id);
$channels_text = db_array('SELECT title' . langExt($l['code']) . ' FROM channels WHERE id IN (' . implode(',', $channels) . ')');
$channels_text = implode(', ', $channels_text);
$message = '<p style="font-weight:bold;">' . $topic['firstname'] . ' ' . $topic['lastname'] . ' ' . getString('bb_notify', $l['code']) . '</p>
<p>' . getString('title', $l['code']) . ': ' . draw_link(url_base() . '/bb/topic.php?id=' . $id, $topic['title']) . '</p>
<p>' . getString('channels_label', $l['code']) . ': ' . $channels_text . '</p>';
if ($topic['type']) {
$message .= '<p>' . getString('category', $l['code']) . ': ' . $topic['type'] . '</p>';
}
$message .= '<div style="color:#555; border-top:1px dotted #555; padding-top:5px; margin-top:5px;">' . $topic['description'] . '</div>';
emailUser($addresses, $topic['title'], $message);
}
}
bbDrawRss();
url_change();
}
echo drawTop(drawSyndicateLink('bb'));
echo draw_div('bb_topics', bbDrawTable(15));
echo draw_javascript('function_attach(setInterval(refreshBB, 60000));');
//add new topic
echo '<a name="bottom"></a>';
echo drawTopicForm();
echo drawBottom();
