<?php
echo $s["office"];
?>
<br>
<?php
echo $s["bio"];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
$result = db_query("SELECT \n\t\t\tISNULL(u.nickname, u.firstname) first,\n\t\t\tu.lastname last,\n\t\t\tu.title,\n\t\t\td.departmentName,\n\t\t\tu.userID, \n\t\t\tu.endDate\n\t\t\tFROM intranet_users u\n\t\t\tJOIN intranet_departments d ON u.departmentID = d.departmentID\n\t\t\tWHERE " . db_datediff("u.endDate", "GETDATE()") . " < 32 ORDER BY endDate DESC");
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Goings", 4);
?>
<tr>
<th width="47"></th>
<th width="25%" align="left">Name</th>
<th width="50%" align="left">Title, Department</th>
<th width="20%" align="right">Last Day</th>
</tr>
<?php
while ($r = db_fetch($result)) {
?>
<?php
include "../include.php";
drawTop();
$users = db_query("select \n\t\tISNULL(u.nickname, u.firstname) first,\n\t\tu.lastname last,\n\t\tu.userID,\n\t\tu.title,\n\t\td.departmentName,\n\t\tu.officeid,\n\t\tr.isPayroll,\n\t\tu.lastlogin, \n\t\tu.updatedOn, \n\t\t" . db_datediff("u.updatedOn", "GETDATE()") . " recent \n\tFROM intranet_users u\n\tJOIN intranet_departments d on u.departmentID = d.departmentID\n\tJOIN intranet_ranks r on u.rankID = r.id\n\tWHERE u.isactive = 1 and (u.homeaddress1 = '' OR u.homeaddress1 IS NULL)\n\tORDER BY lastname");
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Staff Profiles Needing Update (" . db_found($users) . ")", 4);
?>
<tr>
<th width="25%" align="left">email</th>
<th width="30%" align="left">department</th>
<th width="30%" align="left">title</th>
<th width="15%" align="right">last login</th>
</tr>
<?php
while ($u = db_fetch($users)) {
?>
<tr>
<td><a href="/staff/view.php?id=<?php
echo $u["userID"];
?>
"><?php
echo $u["first"];
?>
<?php
echo $u["last"];
?>
</a></td>
<td><?php
function login($username, $password, $skippass = false)
{
global $_SESSION;
//need id, fullname, email departmentid, ishelpdesk, homepage, update_days, updated_on, first
if ($skippass) {
$where = '';
error_debug('<b>login</b> running without password', __FILE__, __LINE__);
} else {
$where = ' AND ' . db_pwdcompare($password, 'u.password') . ' = 1';
error_debug('<b>login</b> running with password', __FILE__, __LINE__);
}
if ($user = db_grab('SELECT
u.id,
ISNULL(u.nickname, u.firstname) firstname,
u.lastname,
u.email,
' . db_pwdcompare('', 'u.password') . ' password,
u.departmentID,
d.isHelpdesk,
u.help,
u.is_admin,
u.updated_date,
u.language_id,
l.code language,
' . db_datediff('u.updated_date', 'GETDATE()') . ' update_days
FROM users u
LEFT JOIN languages l ON u.language_id = l.id
LEFT JOIN departments d ON u.departmentID = d.departmentID
WHERE u.email = \'' . $username . '\' AND u.is_active = 1' . $where)) {
//login was good
db_query('UPDATE users SET lastlogin = GETDATE() WHERE id = ' . $user['id']);
$_SESSION['user_id'] = $user['id'];
$_SESSION['is_admin'] = $user['is_admin'];
$_SESSION['email'] = $user['email'];
$_SESSION['homepage'] = '/bb/';
$_SESSION['departmentID'] = $user['departmentID'];
$_SESSION['isHelpdesk'] = $user['isHelpdesk'];
$_SESSION['update_days'] = $user['update_days'];
$_SESSION['updated_date'] = $user['updated_date'];
$_SESSION['password'] = $user['password'];
$_SESSION['language_id'] = $user['language_id'];
$_SESSION['language'] = $user['language'];
$_SESSION['full_name'] = $user['firstname'] . ' ' . $user['lastname'];
$_SESSION['isLoggedIn'] = true;
cookie('last_login', $user['email']);
cookie('last_email', $user['email']);
return true;
}
$_SESSION['user_id'] = false;
return false;
}
$printing = isset($_GET["print"]) ? true : false;
$editing = isset($_GET["id"]) ? true : false;
$action = isset($_GET["action"]) ? $_GET["action"] : false;
//query user & module info
if (!isset($_COOKIE["last_login"]) || empty($_COOKIE["last_login"])) {
//not logged in
if ($_josh["request"]["path"] != "/") {
if (isset($_GET["goto"])) {
url_change("/index.php?goto=" . $_GET["goto"]);
} elseif ($page["isSecure"]) {
url_change("/index.php?goto=" . urlencode($_josh["request"]["path_query"]));
}
}
} else {
//get user info
$user = db_grab("SELECT \n\t\t\tu.userID id,\n\t\t\tu.firstname first_name,\n\t\t\tu.lastname last_name,\n\t\t\tISNULL(u.nickname, u.firstname) first,\n\t\t\tu.lastname last,\n\t\t\tu.email,\n\t\t\t" . db_pwdcompare("", "u.password") . " password,\n\t\t\t" . db_datediff("u.updatedOn", "GETDATE()") . " update_days,\n\t\t\tp.url homepage,\n\t\t\tu.rankID,\n\t\t\tu.departmentID,\n\t\t\td.isHelpdesk,\n\t\t\tu.isOpenHelp,\n\t\t\tu.isOpenTools, \n\t\t\tu.isOpenAreas,\n\t\t\tu.isOpenCalendar,\n\t\t\tu.isOpenContacts,\n\t\t\tu.isOpenBulletinBoard,\n\t\t\tu.isOpenHelpdesk,\n\t\t\tu.isOpenDocuments,\n\t\t\tu.isOpenStaff,\n\t\t\tu.isActive,\n\t\t\tu.updatedOn\n\t\tFROM intranet_users u\n\t\tJOIN intranet_departments d ON u.departmentID = d.departmentID\n\t\tJOIN pages p\t\t\t\tON u.homePageID = p.id\n\t\tWHERE email = '{$_COOKIE["last_login"]}' AND u.isActive = 1");
//user isn't active or has bad cookie
if (!isset($user["id"]) || !$user["id"]) {
url_change("/index.php?goto=" . urlencode($_josh["request"]["path_query"]));
}
$user["full_name"] = $user["first"] . " " . $user["last"];
//get modules info
$result = db_query("SELECT \n\t\t\t\tm.id,\n\t\t\t\tp.url,\n\t\t\t\tm.name,\n\t\t\t\tm.pallet,\n\t\t\t\tm.isPublic,\n\t\t\t\t(SELECT COUNT(*) FROM administrators a WHERE a.userID = {$user["id"]} AND a.moduleID = m.id) isAdmin\n\t\t\tFROM modules m\n\t\t\tJOIN pages p ON p.id = m.homePageID\n\t\t\tWHERE m.isActive = 1\n\t\t\tORDER BY m.precedence");
$modules = array();
$areas = array();
$user["isAdmin"] = false;
while ($r = db_fetch($result)) {
$modules[$r["id"]] = array("id" => $r["id"], "name" => $r["name"], "url" => $r["url"], "isPublic" => $r["isPublic"], "pallet" => $r["pallet"], "isAdmin" => $r["isAdmin"]);
if (!$r["pallet"]) {
$areas[$r["name"]] = $r["id"];
}
<?php
include '../include.php';
echo drawTop();
$clips = db_query('SELECT
c.id,
c.title,
c.url,
c.publication,
c.pub_date,
c.description,
t.title type
FROM press_clips c
JOIN press_clips_types t ON c.type_id = t.id
WHERE c.is_active = 1 AND ' . db_datediff('c.pub_date') . ' < 7
ORDER BY t.precedence, c.pub_date');
$return = '';
$lastType = '';
while ($c = db_fetch($clips)) {
if ($lastType != $c['type']) {
$return .= '<div style="font-size:18px;margin-top:24px;">' . $c['type'] . ':</div>';
$lastType = $c['type'];
}
$return .= draw_link($c['url'], $c['title'], false, array('style' => 'font-size:14px;')) . '<br>' . $c['publication'] . '<br>' . format_date($c['pub_date'], ' ', 'M d, Y', false) . $c['description'];
}
echo draw_div_class('press_export', $return);
echo '<textarea class="press_export">' . htmlentities($return, ENT_QUOTES, 'UTF-8') . '</textarea>';
echo drawBottom();
<?php
include "include.php";
$report = array();
$result = db_query("SELECT \n\t\tISNULL(u.nickname, u.firstname) 'Helpdesk Admin',\n\t\t(SELECT COUNT(*) FROM helpdesk_tickets t WHERE t.ownerID = u.id AND " . db_datediff("t.created_date", "t.closed_date") . " <= 1) 'Under Day',\n\t\t(SELECT COUNT(*) FROM helpdesk_tickets t WHERE t.ownerID = u.id AND " . db_datediff("t.created_date", "t.closed_date") . " <= 7 AND " . db_datediff("t.created_date", "t.closed_date") . " > 1) 'Under Week',\n\t\t(SELECT COUNT(*) FROM helpdesk_tickets t WHERE t.ownerID = u.id AND " . db_datediff("t.created_date", "t.closed_date") . " <= 30 AND " . db_datediff("t.created_date", "t.closed_date") . " > 7) 'Under Month',\n\t\t(SELECT COUNT(*) FROM helpdesk_tickets t WHERE t.ownerID = u.id AND " . db_datediff("t.created_date", "t.closed_date") . " > 30) 'Over Month'\n\tFROM users u\n\tWHERE u.departmentid = 8 AND ((SELECT COUNT(*) FROM users_to_modules a WHERE a.module_id = 3 AND a.user_id = u.id) > 0)\n\tORDER BY ISNULL(u.nickname, u.firstname)");
while ($r = db_fetch($result)) {
$report[] = $r;
}
echo file_array($report, "Admins by Age");
<td width="40%"><a href="award_view.php?id=<?php
echo $r["awardID"];
?>
"><?php
echo $r["awardTitle"];
?>
</a></td>
<td><nobr><?php
echo date("n/y", strToTime($r["awardStartDate"]));
?>
- <?php
echo date("n/y", strToTime($r["awardEndDate"]));
?>
</nobr></td>
<td width="40%"><?php
$result_notes = db_query("SELECT \n\t\t\t\t\t\ta.activityDate, \n\t\t\t\t\t\ta.activityTitle,\n\t\t\t\t\t\tISNULL(u.nickname, u.firstname) first,\n\t\t\t\t\t\tu.lastname last,\n\t\t\t\t\t\ta.isComplete\n\t\t\t\t\tFROM funders_activity a\n\t\t\t\t\tINNER JOIN users u ON a.activityAssignedTo = u.id\n\t\t\t\t\tWHERE awardID = " . $r["awardID"] . " AND \n\t\t\t\t\t((" . db_datediff("GETDATE()", "a.activityDate") . " > -60 AND " . db_datediff("GETDATE()", "a.activityDate") . " < 60) OR\n\t\t\t\t\t(" . db_datediff("GETDATE()", "a.activityDate") . " < 60) AND isComplete = 0)\n\t\t\t\t\tORDER BY a.activityDate");
while ($rn = db_fetch($result_notes)) {
if (!$rn["isComplete"]) {
echo "<b>";
}
echo "<li>" . $rn["activityTitle"] . " (" . $rn["first"] . " " . $rn["last"] . " - " . format_date($rn["activityDate"]) . ")" . "</li>";
if (!$rn["isComplete"]) {
echo "</b>";
}
}
?>
</td>
<td align="right">$<?php
echo number_format($r["awardAmount"]);
?>
<?php
include "include.php";
echo drawTop();
//comings
$links = $page['is_admin'] ? array('add_edit.php' => getString('add_new')) : false;
echo drawStaffList('u.is_active = 1 AND ' . db_datediff('u.startdate') . ' < 60', getString('staff_new_empty'), $links, getString('staff_new'));
//goings
echo drawStaffList('u.is_active = 0 AND ' . db_datediff("u.endDate", "GETDATE()") . ' < 32', getString('staff_goings_empty'));
echo drawBottom();
