if ($remaining_weeks > 0) { $sidebar_html .= "\tTo submit electives for approval, <a href=\"" . ENTRADA_URL . "/clerkship/electives?section=add\">click here</a>."; } $sidebar_html .= "</div>\n"; new_sidebar_item("Elective Weeks", $sidebar_html, "page-clerkship", "open"); /* Logbook Review setup */ $query = "SELECT *\n FROM `" . CLERKSHIP_DATABASE . "`.`events` AS a\n LEFT JOIN `" . CLERKSHIP_DATABASE . "`.`event_contacts` AS b\n ON b.`event_id` = a.`event_id`\n LEFT JOIN `" . CLERKSHIP_DATABASE . "`.`regions` AS c\n ON c.`region_id` = a.`region_id`\n WHERE a.`event_finish` >= " . $db->qstr(strtotime("00:00:00", time())) . "\n AND (a.`event_status` = 'published' OR a.`event_status` = 'approval')\n AND b.`econtact_type` = 'student'\n AND b.`etype_id` = " . $db->qstr($ENTRADA_USER->getActiveId()) . "\n ORDER BY a.`event_start` ASC"; $clerkship_schedule = $db->GetAll($query); $query = "SELECT *\n FROM `" . CLERKSHIP_DATABASE . "`.`events` AS a\n LEFT JOIN `" . CLERKSHIP_DATABASE . "`.`event_contacts` AS b\n ON b.`event_id` = a.`event_id`\n LEFT JOIN `" . CLERKSHIP_DATABASE . "`.`regions` AS c\n ON c.`region_id` = a.`region_id`\n WHERE a.`event_finish` <= " . $db->qstr(strtotime("00:00:00", time())) . "\n AND (a.`event_status` = 'published' OR a.`event_status` = 'approval')\n AND b.`econtact_type` = 'student'\n AND b.`etype_id` = " . $db->qstr($ENTRADA_USER->getActiveId()) . "\n ORDER BY a.`event_start` ASC"; $clerkship_past_schedule = $db->GetAll($query); if (isset($clerkship_schedule[0]) && $clerkship_schedule[0]["event_start"] <= time() || isset($clerkship_past_schedule) && $clerkship_past_schedule) { $ROTATION_ID = isset($clerkship_schedule[0]) && $clerkship_schedule[0]["rotation_id"] ? $clerkship_schedule[0]["rotation_id"] : $clerkship_past_schedule[count($clerkship_past_schedule) - 1]["rotation_id"]; $SHOW_LOGBOOK = (int) $_SESSION["details"]["role"] <= date("Y", strtotime("+1 year")) ? true : false; $clinical_rotation = clerkship_get_rotation($rotation ? $rotation : ($ROTATION_ID ? $ROTATION_ID : 0)); $rotation = $clinical_rotation["id"]; $clinical_encounters = clerkship_get_rotation_overview($rotation); $objectives_required = 0; $objectives_recorded = 0; $grad_year = get_account_data("grad_year", $ENTRADA_USER->getID()); if ($rotation < 10) { $query = "\tSELECT `objective_id`, MAX(`number_required`) AS `required`\n\t\t\t\t\t\t\tFROM `" . CLERKSHIP_DATABASE . "`.`logbook_mandatory_objectives`\n\t\t\t\t\t\t\tWHERE `rotation_id` = " . $db->qstr($rotation ? $rotation : ($ROTATION_ID ? $ROTATION_ID : 0)) . "\n\t\t\t\t\t\t\tAND `grad_year_min` <= " . $db->qstr($grad_year) . "\n\t\t\t\t\t\t\tAND (`grad_year_max` = 0 OR `grad_year_max` >= " . $db->qstr($grad_year) . ")\n\t\t\t\t\t\t\tGROUP BY `objective_id`"; $required_objectives = $db->GetAll($query); if ($required_objectives) { foreach ($required_objectives as $required_objective) { $objectives_required += $required_objective["required"]; $number_required[$required_objective["objective_id"]] = $required_objective["required"]; $query = "SELECT COUNT(a.`objective_id`) AS `recorded`\n\t\t\t\t\t\t\t\t\t\tFROM `" . CLERKSHIP_DATABASE . "`.`logbook_entry_objectives` AS a\n\t\t\t\t\t\t\t\t\t\tJOIN `" . CLERKSHIP_DATABASE . "`.`logbook_entries` AS b\n\t\t\t\t\t\t\t\t\t\tON a.`lentry_id` = b.`lentry_id`\n\t\t\t\t\t\t\t\t\t\tAND b.`entry_active` = '1'\n\t\t\t\t\t\t\t\t\t\tAND b.`proxy_id` = " . $db->qstr($ENTRADA_USER->getID()) . "\n\t\t\t\t\t\t\t\t\t\tWHERE a.`objective_id` = " . $db->qstr($required_objective["objective_id"]) . "\n\t\t\t\t\t\t\t\t\t\tGROUP BY a.`objective_id`"; $recorded = $db->GetOne($query); if ($recorded) { if ($required_objective["required"] > $recorded) { if ($objective_ids) {
<thead> <tr> <td class="region">Rotation</td> <td class="completed">Entries</td> <td class="completed">CPs</td> <td class="completed">Mandatory CPs</td> <td class="completed">Procedures</td> </tr> </thead> <tbody> <tr><td colspan="5"></td></tr> <?php $other = false; foreach ($results as $result) { $click_url = ENTRADA_URL . "/clerkship?core=" . $result["rotation_id"]; $clinical_encounters = clerkship_get_rotation_overview($result["rotation_id"]); if ($clinical_encounters["entries"]) { $click_url = ENTRADA_URL . "/clerkship/logbook?section=view&type=entries&core=" . $result["rotation_id"]; } else { $click_url = ENTRADA_URL . "/clerkship?core=" . $result["rotation_id"]; } echo "<tr><td class=\"region\"><a href=\"" . $click_url . "\" style=\"font-size: 11px\">" . limit_chars(html_decode($result["rotation_title"]), 55, true, false) . "</a></td>\n"; echo "<td class=\"completed\">" . blank_zero($clinical_encounters["entries"]) . "</td>\n"; echo "<td class=\"completed\">" . blank_zero($clinical_encounters["objectives"]) . "</td>\n"; echo "<td class=\"completed\">" . blank_zero($clinical_encounters["mandatories"]) . " " . ($clinical_encounters["other_mandatories"] ? " (" . $clinical_encounters["other_mandatories"] . ")" : '') . "</td>\n"; echo "<td class=\"completed\">" . blank_zero($clinical_encounters["procedures"]) . "</td></tr>\n"; } ?> </tbody> </table> <br />