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>