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