function get_last_case_activity($dbh, $user)
{
$q = $dbh->prepare("SELECT * FROM `cm_case_notes`\n\t\tWHERE username = ? ORDER BY `date` desc LIMIT 0,1");
$q->bindParam(1, $user);
$q->execute();
$c = $q->fetch();
if ($c) {
$data = extract_date_time($c['date']) . ": " . implode(' ', convert_case_time($c['time'])) . ' on the <a href="index.php?i=Cases.php#cases/' . $c['case_id'] . '" target="_new">' . case_id_to_casename($dbh, $c['case_id']) . "</a> case.";
} else {
$data = "None";
}
return $data;
}
$follow_url = CC_BASE_URL . 'index.php?i=Cases.php#cases/' . $close['id'];
$item = array('by' => $by, 'action_text' => $action_text, 'casename' => $casename, 'id' => $id, 'what' => $what, 'follow_url' => $follow_url, 'time_done' => $time_done, 'time_formatted' => $time_formatted);
$activities[] = $item;
}
}
//new users who have requested access
if ($p['activate_users'] == '1') {
$get_new_users = $dbh->prepare("SELECT * FROM cm_users\n\t\t\t\tWHERE date_created >= '{$mysqldate}' AND new = 'yes'");
$get_new_users->execute();
$news = $get_new_users->fetchAll(PDO::FETCH_ASSOC);
foreach ($news as $new) {
$by = username_to_fullname($dbh, $new['username']);
$thumb = 'people/tn_no_picture.png';
$action_text = " signed up for ClinicCases ";
$time_done = $new['date_created'];
$time_formatted = extract_date_time($new['date_created']);
$what = 'Please review this application.';
$follow_url = CC_BASE_URL . 'index.php?i=Users.php';
$casename = '(view here)';
$id = null;
$item = array('by' => $by, 'action_text' => $action_text, 'casename' => $casename, 'id' => $id, 'what' => $what, 'follow_url' => $follow_url, 'time_done' => $time_done, 'time_formatted' => $time_formatted);
$activities[] = $item;
}
}
//TODO add board posts
//Sort the activity array
if (!empty($activities)) {
sortBySubkey($activities, 'time_done');
}
//Create RSS
$body = "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n\t\t<rss version=\"2.0\">\n\t\t<channel>\n\t\t\t<title>Latest Activity - ClinicCases - " . CC_PROGRAM_NAME . "</title>\n\t\t\t<link>" . CC_BASE_URL . "</link>\n\t\t\t<description>Notification of new case activity on ClinicCases</description>\n\t\t";
<?php
foreach ($folders as $folder) {
if (strrchr($folder['folder'], '/')) {
$folder_name = substr(strrchr($folder['folder'], '/'), 1);
} else {
$folder_name = $folder['folder'];
}
$folder_path = $folder['folder'];
$user = username_to_fullname($dbh, $folder['username']);
$date = extract_date_time($folder['date_modified']);
echo "<div class='doc_item folder' path='{$folder_path}' data-id='{$folder['id']}'><img src='html/ico/folder.png'><p>{$folder_name}</p></div>";
echo "<div class='doc_properties' tabindex='1'><h3><img src='html/ico/folder.png'>{$folder_name}</h3>\n\t\t\t\t\t<hr />\n\t\t\t\t\t<p><label>Type</label> Folder</p>\n\t\t\t\t\t<p><label>Created:</label> {$date}</p>\n\t\t\t\t\t<p><label>Created By:</label> {$user}</p>\n\t\t\t\t\t</div>";
}
foreach ($documents as $document) {
$icon = get_icon($document['type']);
$user = username_to_fullname($dbh, $document['username']);
$date = extract_date_time($document['date_modified']);
echo "<div id='doc_{$document['id']}' class='doc_item item {$document['type']}' data-id='{$document['id']}'><img src='{$icon}'><p>{$document['name']}</p></div>";
echo "<div class='doc_properties' tabindex='1'><h3><img src='{$icon}'>{$document['name']}</h3>\n\t\t\t<hr />\n\t\t\t<p><label>Type</label> {$document['type']}</p>\n\t\t\t<p><label>Uploaded:</label> {$date}</p>\n\t\t\t<p><label>Uploaded By:</label> {$user}</p>\n\t\t\t</div>";
}
if (empty($folders) and empty($documents)) {
echo "<span class='docs_empty'>No documents found.</a>";
}
echo "<div class='doc_spacing_fix'></div>";
?>
<?php
if (!isset($update)) {
echo "</div>";
}
<img class="thumbnail-mask" src = "<?php
echo return_thumbnail($dbh, $from);
?>
">
<?php
echo username_to_fullname($dbh, $from);
?>
</div>
<div class = "msg_reply_right">
<?php
echo extract_date_time($time_sent);
?>
</div>
<p><?php
echo nl2br(htmlentities(text_prepare($body)));
?>
</p>
</div>
<?php
}
}
?>
</p>
<p><label>Status</label><?php
echo $status;
?>
</p>
<p><label>Date Created</label><?php
echo extract_date_time($date_created);
?>
</p>
<p><label>Last Login</label><?php
$last_login = get_last_login($dbh, $username);
if ($last_login) {
echo extract_date_time($last_login);
} else {
echo "Never";
}
?>
</p>
<p><label>Last Case Activity</label><?php
echo get_last_case_activity($dbh, $username);
?>
</p>
</div>
<div class = "user_detail_right">
$this_users_groups = user_which_groups($dbh, $_SESSION['login']);
$grps = implode("','", $this_users_groups);
$q = $dbh->prepare("SELECT * FROM `cm_board` as all_posts\n\tJOIN\n\t(SELECT * FROM cm_board_viewers WHERE viewer IN ('{$grps}') GROUP BY cm_board_viewers.post_id) AS this_user\n\tON\n\tall_posts.id = this_user.post_id AND all_posts.time_added >= '{$mysqldate}'");
$q->execute();
$posts = $q->fetchAll(PDO::FETCH_ASSOC);
foreach ($posts as $post) {
$activity_type = 'new_board_post';
if ($post['author'] === $username) {
$by = 'You';
} else {
$by = username_to_fullname($dbh, $post['author']);
}
$thumb = return_thumbnail($dbh, $post['author']);
$action_text = " posted on your Board ";
$time_done = $post['time_added'];
$time_formatted = extract_date_time($post['time_added']);
$what = $post['title'];
$follow_url = 'index.php?i=Board.php';
$mobile_url = 'index.php?i=Board.php';
$casename = "(view here)";
$id = null;
$item = array('activity_type' => $activity_type, 'by' => $by, 'thumb' => $thumb, 'action_text' => $action_text, 'casename' => $casename, 'id' => $id, 'what' => $what, 'follow_url' => $follow_url, 'time_done' => $time_done, 'time_formatted' => $time_formatted, 'mobile_url' => $mobile_url);
$activities[] = $item;
}
}
if (!empty($activities)) {
sortBySubkey($activities, 'time_done');
}
if (!$_SESSION['mobile']) {
include '../../../html/templates/interior/home_activities.php';
}
<p><label>Start:</label>
<span class = "event_start"><?php
echo extract_date_time($start);
?>
</span>
<?php
if ($all_day === '1') {
echo " <span class='event_all_day'>(All day)</span>";
}
?>
</p>
<p><label>End:</label>
<span class = "event_end"><?php
if (!empty($end) && $end != '0000-00-00 00:00:00') {
echo extract_date_time($end);
}
?>
</span>
</p>
<p><label>Where:</label>
<span class = "event_location"><?php
echo htmlentities($location);
?>
</span>
</p>
<p><label>Notes:</label>
<span class = "event_notes"><?php
echo htmlentities($notes);
?>
<div class="row">
<form class="navbar-search">
<input type="text" class="board-search search-query" placeholder="Search">
</form>
</div>
<div class="row board-container">
<?php
if ($_SESSION['permissions']['view_board'] === '1') {
if (empty($posts)) {
echo "<p class='end'>There have been no posts to your Board yet.</p>";
die;
} else {
foreach ($posts as $p) {
extract($p);
echo "<div class='container board-item' style='background-color:rgb({$color})'>" . "<h3><img class='img-rounded' src='" . return_thumbnail($dbh, $author) . "'><span class='searchable'> {$title}</span></h3>" . "<div class='searchable'>{$body}</div>" . "<br /><div class='muted searchable'>Posted By " . username_to_fullname($dbh, $author) . " on " . extract_date_time($time_added) . "</div>";
$attach = check_attachments($dbh, $post_id);
if ($attach == true) {
echo "<br /><div class='searchable'><label>Attachments:</label>{$attach}</div>";
}
echo "</div>";
}
}
} else {
echo "<p>You do not have permission to view the board.";
}
?>
</div>
</div>
</body>
</html>
<div class="journal_detail">
<div class="journal_header ui-widget-header ui-corner-tl ui-corner-tr ui-helper-clearfix">
<img class="thumbnail-mask" src="<?php
echo return_thumbnail($dbh, $username);
?>
" border="0">
<p>Journal Submitted by <?php
echo username_to_fullname($dbh, $username);
?>
on <?php
echo extract_date_time($date_added);
?>
</p>
<div class = "journal_detail_control">
<?php
if ($view !== 'edit' && $_SESSION['permissions']['writes_journals'] == '1') {
?>
<button class="journal_delete">Delete</button>
<button class="journal_edit">Edit</button>
<button class="journal_print">Print</button>
<?php
} elseif ($view !== 'edit') {
?>
<div id = "home_nav" data-key = "<?php echo $_SESSION['private_key']; ?> "> <div id = "home_data"> <div><?php echo $_SESSION['first_name'] . ' ' . $_SESSION['last_name']; ?> </div> <?php include 'lib/php/auth/last_login.php'; include 'lib/php/utilities/convert_times.php'; $last_log = extract_date_time(get_last_login($dbh, $_SESSION['login'])); ?> <div class="small"> Last login: <?php echo $last_log; ?> </div> </div> <span class = "home_nav_choices"> <input type="radio" id="activity_button" name="radio" checked="checked" /><label for="activity_button">Activity</label> <input type="radio" id="upcoming_button" name="radio" /><label for="upcoming_button">Upcoming</label>