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;
}
\t\t\t\t<div class = 'csenote_bar_left'><img src='{$this_thumb}'> {$this_fname} {$this_lname}</div>
\t\t\t\t<div class = 'csenote_bar_right'>
\t\t\t\t<label>Date:</label> <input type='hidden' name='csenote_date' class='csenote_date_value' value='{$this_date}'> {$selector}
\t\t\t\t<input type='hidden' name='csenote_user' value='{$this_user}'>
\t\t\t\t<input type='hidden' name='csenote_case_id' value='{$this_case_id}'>
\t\t\t\t<input type='hidden' name='query_type' value='add'>
\t\t\t\t<button class='csenote_action_submit'>Add</button><button class='csenote_action_cancel'>Cancel</button></div>
\t\t\t</div>
\t\t\t<textarea name='csenote_description'></textarea>
\t\t\t</form>
\t\t\t</div>
NEWNOTE;
//show all case notes
foreach ($case_notes_data as $case_notes) {
$time = convert_case_time($case_notes['time']);
echo "<div class='csenote' id='csenote_" . $case_notes['id'] . "'>\n\t\t\t\t<div class='csenote_bar'>\n\t\t\t\t<div class = 'csenote_bar_left'><img class='thumbnail-mask' src='" . thumbify($case_notes['picture_url']) . "'>  " . username_to_fullname($dbh, $case_notes['username']) . "</div><div class = 'csenote_bar_right'><span class='csenote_date'>" . extract_date($case_notes['date']) . "</span> · <span class='csenote_time'>" . $time[0] . $time[1] . "</span>";
if ($case_notes['username'] == $_SESSION['login']) {
echo " · <a href='#' class='csenote_edit'>Edit</a> <a href='#' class='csenote_delete'>Delete</a>";
}
echo "</div></div><p class='csenote_instance'>" . nl2br(htmlentities($case_notes['description'])) . "</p></div>";
}
if (empty($case_notes_data)) {
if (isset($search)) {
echo "<p>No case notes found matching <i>{$search}</i></p>";
} else {
echo "<p>No case notes found</p>";
die;
}
}
if (!isset($_POST['update'])) {
<li><a href="#caseEvents" data-toggle="tab">Events</a></li>
</ul>
</li>
</ul>
<div class="tab-content">
<div class="tab-pane" id="caseNotes">
<dl class="dl-sectioned">
<?php
if (empty($case_notes_data)) {
echo "No case notes found";
} else {
foreach ($case_notes_data as $c) {
extract($c);
$thumb = thumbify($picture_url);
$date_human = extract_date($date);
$tc = convert_case_time($time);
echo "<dd><img class='img-rounded' src='{$thumb}' />{$first_name} {$last_name} <span class='pull-right'> {$date_human} </span></dd>\n <dt>" . nl2br(htmlentities($description)) . " <span class='muted'>({$tc['0']} {$tc['1']})</span></dt> ";
}
}
?>
</dl>
</div>
<div class="tab-pane" id="caseData">
<dl class="mobile-list">
<?php
foreach ($dta as $d) {
extract($d);
if ($input_type == 'dual') {
?>
<dt class="muted"><?php
echo $display_name;
<h3 style="text-align:center" >
<?php
echo $data['first_name'] . " " . $data['last_name'];
?>
</h3>
<p><label>Total Time on this Case:</label></p>
<p>
<?php
if (isset($data['totaltime'])) {
$total = convert_case_time($data['totaltime']);
echo $total[0] . $total[1];
} else {
echo "0 minutes";
}
?>
</p>
<p><label>Group:</label></p>
<p><?php
$grp = get_group_title($data['grp'], $dbh);
echo $grp;
?>
</p>
