session_name('raprec');
session_start();
require_once "includes/constants.php";
// Force 'constants.php' to load, even if it has been previously included by one of the classes above. Must set SESSION vars AFTER the session_start() declaration.
require_once "includes/auth_functions.php";
require_once "includes/check_get_vars.php";
require_once "includes/make_menu.php";
require_once "includes/photo_upload_functions.php";
// Make sure this user is allowed to access this page
if ($_SESSION['logged_in'] == 1 && check_access("crew_admin", $_GET['crew'])) {
// ACCESS GRANTED!
// Attempt to load the specified crew
try {
global $crew;
$crew = new crew();
$crew->load($_GET['crew']);
} catch (Exception $e) {
if ($_SESSION['current_user']->get('account_type') == 'admin') {
//echo "admin";
if ($_GET['function'] != 'no_crew_specified') {
header('location: ' . $_SERVER['PHP_SELF'] . '?function=no_crew_specified');
}
} else {
header('location: index.php');
}
}
} else {
// ACCESS DENIED!
store_intended_location();
//Redirect user back to their intended location after they log in
header('location: index.php');
if (isset($_GET['eq_type']) && in_array(strtolower($_GET['eq_type']), array('rope', 'genie', 'letdown_line'))) {
$eq_type = strtolower($_GET['eq_type']);
try {
$eq = new $eq_type();
if (isset($_GET['eq_id']) && $_GET['eq_id'] != "") {
$eq->load($_GET['eq_id']);
} else {
$eq->load(false);
}
} catch (Exception $e) {
/* An equipment type was specified, but not a specific equipment ID - show cumulatives for this eq_type */
// Determine whether to show equipment records for a particular CREW or an entire REGION
try {
$zoom_obj = new crew();
// $zoom_obj will become either a CREW OBJECT or a REGION ID, depending on $zoom_level
isset($_GET['crew']) ? $zoom_obj->load($_GET['crew']) : $zoom_obj->load(false);
$zoom_level = 'crew';
} catch (Exception $e) {
/* No CREW was specified - check for a preselected CREW in the 'current_view' SESSION var */
try {
if ($_SESSION['current_view']['crew'] != NULL) {
$zoom_obj->load($_SESSION['current_view']['crew']->get('id'));
} else {
throw new Exception('This exception is meant solely to trigger the following catch block');
}
$zoom_level = 'crew';
} catch (Exception $e) {
/* No CREW selection was stored in the SESSION - check for a REGION selection*/
if (isset($_SESSION['current_view']['region']) && $_SESSION['current_view']['region'] !== NULL) {
$zoom_level = 'region';
unset($zoom_obj);
function show_proficiency_report($view_type = 'region', $id = false)
{
// INPUTS:
// $view_type is either 'crew' or 'region', specifying the scope of the report
// $obj is either an integer region ID or a crew ID
//
// OUTPUT:
// This function prints the appropriate HTML page content to the screen.
// There is no return value.
$rappel_platform = isset($_GET['rappel_platform']) ? $_GET['rappel_platform'] : 'bell_medium';
if ($rappel_platform == 'bell_medium') {
$aircraft_criteria = "(aircraft_types.type = '2' OR isNull(aircraft_types.type))";
} else {
$aircraft_criteria = "(aircraft_types.shortname = '" . $rappel_platform . "' OR isNull(aircraft_types.type))";
}
switch ($view_type) {
case 'crew':
$crew = new crew();
$crew->load($id);
$_SESSION['current_view']['crew'] = $crew;
$roster_criteria = "rosters.crew_id = " . $id;
$text = "<br /><div style=\"width:100%; text-align:left;\">\n" . "<h1>Proficiency Status</h1><br />\n" . "<h2>" . $crew->get('name') . " -- " . $_SESSION['current_view']['year'] . "</h2>\n" . "</div>\n";
break;
case 'region':
default:
if (!$id) {
$id = 6;
}
//This shouldn't happen, but default to region 6 if inputs were incomplete
$roster_criteria = "rosters.crew_id IN (SELECT id FROM crews WHERE region = " . $id . ")";
$text = "<br /><div style=\"width:100%; text-align:left;\">\n" . "<h1>Proficiency Status</h1><br />\n" . "<h2>Region " . $id . " -- " . $_SESSION['current_view']['year'] . "</h2>\n" . "<hr style=\"width:100%\">" . "</div>\n";
break;
}
// End: switch($view_type)
$text .= build_rappel_platform_dropdown();
$query = "\nSELECT \nhraps.id AS hrap_id, \nCONCAT( hraps.firstname,' ', hraps.lastname ) AS name, \nvr1.date, \nvr1.operation_id, \nvr1.aircraft_fullname, \nvr1.aircraft_type, \naircraft_types.shortname AS aircraft_shortname, \nDATEDIFF( NOW( ) , STR_TO_DATE( vr1.date, '%m/%d/%Y') ) AS days_ago\n\nFROM \nhraps INNER JOIN rosters ON ((rosters.year = '" . $_SESSION['current_view']['year'] . "') AND (" . $roster_criteria . ") AND (hraps.id = rosters.hrap_id))\nLEFT OUTER JOIN view_rappels as vr1 ON hraps.id = vr1.hrap_id\nLEFT OUTER JOIN view_rappels as vr2 ON ((vr1.hrap_id = vr2.hrap_id) AND (STR_TO_DATE( vr1.date, '%m/%d/%Y' ) < STR_TO_DATE( vr2.date, '%m/%d/%Y' )))\nLEFT OUTER JOIN aircraft_types ON (\n\t\t(vr1.aircraft_type_id = aircraft_types.id) AND (" . $aircraft_criteria . ")\n\t\t)\nWHERE vr2.hrap_id IS NULL\nGROUP BY hraps.id\nORDER BY name";
$result = mydb::cxn()->query($query);
if (mydb::cxn()->affected_rows < 1) {
$text .= "<br /><span class=\"error_msg\">This " . $view_type . " has no roster information for " . $_SESSION['current_view']['year'] . "</span>";
} else {
$text .= "<br>\n" . "<table class=\"alternating_rows\" style=\"width:100%; border:2px solid #555555;\">\n" . "<th>+</th>" . "<th>HRAP</th>" . "<th>Aircraft</th>" . "<th>Days Since Last Rap</th>" . "<th>Days Until Lapse</th>" . "<th>Status</th></tr>\n";
$current_row = 0;
while ($row = $result->fetch_assoc()) {
$current_row++;
//if($current_row % 2 == 0) $class = "class=\"evn\"";
//else $class = "class=\"odd\"";
$class = "class=\"odd\"";
// Determine whether the current HRAP is proficient or not and HIGHLIGHT this row accordingly
$highlight = "";
$p_status = "Proficient";
if ($row['days_ago'] > $_SESSION['proficiency_duration'] || $row['days_ago'] == "") {
$highlight = "background-color:#ff6666;";
// Highlight RED if HRAP is past proficiency date
$p_status = "Not Proficient";
} elseif ($row['days_ago'] > $_SESSION['proficiency_duration'] - 3) {
$highlight = "background-color:#ffff66;";
}
// Highlight YELLOW if HRAP is within 3 days of proficiency date
$text .= "<tr " . $class . " style=\"height:1.8em;" . $highlight . "\">\n" . "<td style=\"text-align:center;\">";
if ($row['operation_id'] != "") {
$text .= "<a href=\"view_rappels.php?&op=" . $row['operation_id'] . "&hrap=" . $row['hrap_id'] . "\"><img src=\"images/magnifying_glass.png\" style=\"margin:0;\"></a>";
}
$text .= "</td>" . "<td>" . $row['name'] . "</td>" . "<td>" . $row['aircraft_fullname'] . "</td>" . "<td style=\"text-align:center;\">" . $row['days_ago'] . "</td>" . "<td style=\"text-align:center;\">" . ($row['days_ago'] == "" ? "0" : max((int) $_SESSION['proficiency_duration'] - (int) $row['days_ago'], 0)) . "</td>" . "<td>" . $p_status . "</td>" . "</tr>\n\n";
}
$text .= "</table><br>\n\n";
$text .= color_coding_legend();
}
// End: else [if(mydb::cxn()->affected_rows < 1)]
echo $text;
}
function make_menu()
{
/******* PROCESS LOGIN ATTEMPT ***************************/
/*
if(isset($_POST['username']) && isset($_POST['passwd'])) $login_result = login($_POST['username'], $_POST['passwd']);
elseif(!isset($_SESSION['logged_in']) && !isset($login_result)) $login_result = array(-1,"No login attempt made yet");
else $login_result = array(-1,"No login attempt made yet");
*/
/******* MAKE LOCATION BAR ***************************/
if (isset($_GET['year']) && check_year($_GET['year'])) {
$_SESSION['current_view']['year'] = $_GET['year'];
} elseif (!isset($_SESSION['current_view']['year'])) {
$_SESSION['current_view']['year'] = date('Y');
}
if (!isset($_SESSION['mobile'])) {
$_SESSION['mobile'] = false;
}
$current_file = explode('/', $_SERVER['PHP_SELF']);
$current_file = strtolower($current_file[sizeof($current_file) - 1]);
// Get the filename of the script that called this function (no path info, just the filename)
$region = NULL;
$crew = new crew();
$hrap = new hrap();
$op = NULL;
try {
//This exception below is meant solely to trigger the 'catch' block. The message is never displayed to the user.
if ($current_file == "index.php" || $current_file == "proficiency_report.php") {
throw new Exception('You cannot specify an individual HRAP on the index or proficiency page.');
}
isset($_GET['hrap']) ? $hrap->load($_GET['hrap']) : $hrap->load(false);
$crew->load($hrap->get_crew_by_year($_SESSION['current_view']['year']));
$_SESSION['current_view']['hrap'] = $hrap;
if (isset($crew->id)) {
$_SESSION['current_view']['region'] = $crew->region;
$_SESSION['current_view']['crew'] = $crew;
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $crew->region . "\">R" . $crew->region . "</a>";
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $crew->region . "&crew=" . $crew->id . "\">" . $crew->name . "</a>";
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $crew->region . "&crew=" . $crew->id . "&hrap=" . $hrap->id . "\">" . $hrap->name . "</a>";
} else {
/* The requested HRAP is not assigned to a crew for the requested year, maintain the previous 'current_view' (do nothing)*/
}
} catch (Exception $e) {
if (isset($_GET['eq_type'])) {
// The current view is on a piece of equipment, retain CREW and REGION but reset all other 'current_view' parameter
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
if (isset($_GET['eq_id'])) {
try {
$eq = new $_GET['eq_type']();
$eq->load($_GET['eq_id']);
$_SESSION['current_view']['crew'] = new crew();
$_SESSION['current_view']['crew']->load($eq->get('crew_affiliation_id'));
$result = mydb::cxn()->query("SELECT region FROM crews WHERE id = " . $eq->get('crew_affiliation_id'));
$row = $result->fetch_assoc();
$_SESSION['current_view']['region'] = $row['region'];
$_SESSION['location_bar'] .= " / <a href=\"view_equipment.php?eq_type=" . $_GET['eq_type'] . "®ion=" . $_SESSION['current_view']['region'] . "\">R" . $_SESSION['current_view']['region'] . "</a>" . " / <a href=\"view_equipment.php?eq_type=" . $_GET['eq_type'] . "&crew=" . $_SESSION['current_view']['crew']->get('id') . "\">" . $_SESSION['current_view']['crew']->get('name') . "</a>" . " / <a href=\"view_equipment.php?crew=" . $_SESSION['current_view']['crew']->get('id') . "\">Equipment</a>";
} catch (Exception $e) {
}
} elseif (isset($_GET['crew']) && check_crew($_GET['crew'])) {
$crew->load($_GET['crew']);
$_SESSION['current_view']['region'] = $crew->get('region');
$_SESSION['current_view']['crew'] = $crew;
$_SESSION['location_bar'] .= " / <a href=\"view_equipment.php?eq_type=" . $_GET['eq_type'] . "®ion=" . $_SESSION['current_view']['region'] . "\">R" . $_SESSION['current_view']['region'] . "</a>" . " / <a href=\"view_equipment.php?eq_type=" . $_GET['eq_type'] . "&crew=" . $_SESSION['current_view']['crew']->get('id') . "\">" . $_SESSION['current_view']['crew']->get('name') . "</a>" . " / <a href=\"view_equipment.php?crew=" . $_SESSION['current_view']['crew']->get('id') . "\">Equipment</a>";
} elseif (isset($_GET['region']) && is_valid_region($_GET['region'])) {
$_SESSION['current_view']['region'] = $_GET['region'];
$_SESSION['location_bar'] .= " / <a href=\"view_equipment.php?eq_type=" . $_GET['eq_type'] . "®ion=" . $_SESSION['current_view']['region'] . "\">R" . $_SESSION['current_view']['region'] . "</a>" . " / <a href=\"view_equipment.php?region=" . $_SESSION['current_view']['region'] . "\">Equipment</a>";
$_SESSION['current_view']['crew'] = NULL;
}
$_SESSION['current_view']['hrap'] = NULL;
$_SESSION['current_view']['op'] = NULL;
} elseif (isset($_GET['crew']) && check_crew($_GET['crew'])) {
try {
$crew->load($_GET['crew']);
} catch (Exception $e) {
}
$_SESSION['current_view']['region'] = $crew->get('region');
$_SESSION['current_view']['crew'] = $crew;
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
if ($current_file != "modify_roster.php") {
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $crew->get('region') . "\">R" . $crew->get('region') . "</a>";
} else {
$_SESSION['location_bar'] .= " / <a href=\"./index.php?region=" . $crew->get('region') . "\">R" . $crew->get('region') . "</a>";
}
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $crew->get('region') . "&crew=" . $crew->get('id') . "\">" . $crew->get('name') . "</a>";
if ($current_file == "proficiency_report.php") {
$_SESSION['location_bar'] .= " / Proficiency Report";
}
// Clear the unknown 'current_view' elements
$_SESSION['current_view']['hrap'] = NULL;
$_SESSION['current_view']['op'] = NULL;
} elseif (isset($_GET['region']) && is_valid_region($_GET['region'])) {
$region = $_GET['region'];
$_SESSION['current_view']['region'] = $region;
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $region . "\">R" . $region . "</a>";
if ($current_file == "proficiency_report.php") {
$_SESSION['location_bar'] .= " / Proficiency Report";
}
// Clear the unknown 'current_view' elements
$_SESSION['current_view']['crew'] = NULL;
$_SESSION['current_view']['hrap'] = NULL;
$_SESSION['current_view']['op'] = NULL;
} elseif (isset($_GET['op']) && operation::exists($_GET['op'])) {
// If a specific OPERATION is being viewed (and none of the above criteria were met), there is a mix of different CREWS, HRAPS, and possibly REGIONS...
// So just maintain the same location bar that was shown before the user accessed this page
$op = $_GET['op'];
// DO NOTHING
} elseif ($current_file == "proficiency_report.php") {
// Viewing the proficiency report, but no Crew or Region has been specified.
// 1st - Look for pre-existing crew or region in the $_SESSION['current_view'] array
// 2nd - Try to determine the current user's crew and use that
// 3rd - Display the page with no parameters - the page will show an error and offer a link to the Home page
if (isset($_SESSION['current_view']['crew'])) {
$crew = $_SESSION['current_view']['crew'];
$region = $crew->get('region');
$_SESSION['current_view']['region'] = $region;
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
$_SESSION['location_bar'] .= " / <a href=\"" . $current_file . "?region=" . $region . "\">R" . $region . "</a>";
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $crew->get('region') . "&crew=" . $crew->get('id') . "\">" . $crew->get('name') . "</a>";
$_SESSION['location_bar'] .= " / Proficiency Report";
// Clear the unknown 'current_view' elements
$_SESSION['current_view']['hrap'] = NULL;
$_SESSION['current_view']['op'] = NULL;
} elseif (isset($_SESSION['current_view']['region'])) {
$region = $_SESSION['current_view']['region'];
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
$_SESSION['location_bar'] .= " / <a href=\"" . $current_file . "?region=" . $region . "\">R" . $region . "</a>";
$_SESSION['location_bar'] .= " / Proficiency Report";
// Clear the unknown 'current_view' elements
$_SESSION['current_view']['crew'] = NULL;
$_SESSION['current_view']['hrap'] = NULL;
$_SESSION['current_view']['op'] = NULL;
} elseif (isset($_SESSION['current_user']) && $_SESSION['current_user']->get('crew_affiliation_id') != false) {
$crew = new crew();
$crew->load($_SESSION['current_user']->get('crew_affiliation_id'));
$region = $crew->get('region');
$_SESSION['current_view']['crew'] = $crew;
$_SESSION['current_view']['region'] = $region;
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
$_SESSION['location_bar'] .= " / <a href=\"" . $current_file . "?region=" . $region . "\">R" . $region . "</a>";
$_SESSION['location_bar'] .= " / <a href=\"./" . $current_file . "?region=" . $crew->get('region') . "&crew=" . $crew->get('id') . "\">" . $crew->get('name') . "</a>";
$_SESSION['location_bar'] .= " / Proficiency Report";
// Clear the unknown 'current_view' elements
$_SESSION['current_view']['hrap'] = NULL;
$_SESSION['current_view']['op'] = NULL;
}
} else {
// Clear the unknown 'current_view' elements
$_SESSION['location_bar'] = "Location: <a href=\"./index.php\">Home</a>";
$_SESSION['current_view']['region'] = NULL;
$_SESSION['current_view']['crew'] = NULL;
$_SESSION['current_view']['hrap'] = NULL;
$_SESSION['current_view']['op'] = NULL;
}
}
// End: try/catch block
/********************************************************************************************************************************/
/*******************<< USER is not logged in (yet) >>****************************************************************************/
if (!isset($_SESSION['logged_in']) || $_SESSION['logged_in'] != 1) {
//Initialize the current_user as a GUEST
$_SESSION['current_user'] = new user('guest');
/******* PROCESS LOGIN ATTEMPT ***************************/
try {
if (!isset($_POST['username']) || !isset($_POST['passwd'])) {
throw new Exception('');
}
//No login attempt was made
login($_POST['username'], $_POST['passwd']);
} catch (Exception $e) {
// If this block is reached, either no login attempt was made, or a login attempt failed with an exception.
echo "<div id=\"left_sidebar_title\">Login</div>\n";
echo "<form action=\"" . $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'] . "\" method=\"post\" style=\"margin:0; padding:0;\">\n" . "\t<table style=\"margin:0; padding:0;\">\n" . "\t\t<tr><td colspan=\"2\"><div id=\"login_result\">" . $e->getMessage() . "</div></td></tr>\n" . "\t\t<tr><td>Username:</td><td><input name=\"username\" type=\"text\" class=\"loginfield\" value=\"" . (isset($_POST['username']) ? $_POST['username'] : "") . "\" /></td></tr>\n" . "\t\t<tr><td>Password:</td><td><input name=\"passwd\" type=\"password\" class=\"loginfield\" /></td></tr>\n" . "\t\t<tr><td> </td><td style=\"text-align:right;\"><input type=\"submit\" value=\"Login\" class=\"form_button\" style=\"margin-right:0;\" /></td></tr>\n" . "\t</table>\n" . "</form>";
echo "<hr><br>\n" . "<table>\n" . "\t<tr><td>You are viewing information for the following year:</td></tr>\n" . "\t<tr><td style=\"text-align:center;vertical-align:center;padding:0;\">\n" . "\t\t<form action=\"" . $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'] . "\" method=\"GET\" id=\"sidebar_year_form\" name=\"sidebar_year_form\">\n" . "\t\t<input name=\"year\" type=\"text\" value=\"" . $_SESSION['current_view']['year'] . "\" style=\"width:40px; height:1.3em; font-size:1.2em; font-weight:bold; margin:1px;\">\n";
if ($region != NULL) {
echo "<input type=\"hidden\" name=\"region\" value=\"" . $_GET['region'] . "\">\n";
}
if ($crew != NULL) {
echo "<input type=\"hidden\" name=\"crew\" value=\"" . $crew->get('id') . "\">\n";
}
if ($hrap != NULL) {
echo "<input type=\"hidden\" name=\"hrap\" value=\"" . $hrap->get('id') . "\">\n";
}
if ($op != NULL) {
echo "<input type=\"hidden\" name=\"op\" value=\"" . $op . "\">\n";
}
if (isset($_GET['function']) && $_GET['function'] != '') {
echo "<input type=\"hidden\" name=\"function\" value=\"" . $_GET['function'] . "\">\n";
}
echo "\t\t<input type=\"button\" value=\"Update\" class=\"form_button\" onClick=' document.forms.sidebar_year_form.submit();'>\n" . "\t\t</form>\n" . "\t\t</td>\n" . "\t</tr>\n" . "</table>\n" . "<br><hr>\n\n";
}
}
/******* USER IS LOGGED IN*******************************************************************************************************/
if (isset($_SESSION['logged_in']) && $_SESSION['logged_in'] == 1) {
echo "<div id=\"left_sidebar_title\">RapRec Menu</div>\n";
echo "You are logged in as:<br />" . $_SESSION['current_user']->get('firstname') . " " . $_SESSION['current_user']->get('lastname') . "<br /><i>" . $_SESSION['current_user']->get('username') . "</i><br><br>\n";
echo "<a href=\"index.php?logout=1" . (isset($_SESSION['mobile']) ? "&mobile=" . $_SESSION['mobile'] : "") . "\">Logout</a><br>";
echo "<hr><br>\n" . "<table>\n" . "\t<tr><td>You are viewing information for the following year:</td></tr>\n" . "\t<tr><td>\n" . "\t\t<form action=\"" . $_SERVER['PHP_SELF'] . "?" . $_SERVER['QUERY_STRING'] . "\" method=\"GET\" id=\"sidebar_year_form\" name=\"sidebar_year_form\">\n" . "\t\t<input name=\"year\" id=\"sidebar_year\" type=\"text\" size=\"4\" value=\"" . $_SESSION['current_view']['year'] . "\" style=\"width:40px\">\n";
if ($region != NULL) {
echo "<input type=\"hidden\" name=\"region\" value=\"" . $_GET['region'] . "\">\n";
}
if ($crew != NULL) {
echo "<input type=\"hidden\" name=\"crew\" value=\"" . $crew->get('id') . "\">\n";
}
if ($hrap != NULL) {
echo "<input type=\"hidden\" name=\"hrap\" value=\"" . $hrap->get('id') . "\">\n";
}
if ($op != NULL) {
echo "<input type=\"hidden\" name=\"op\" value=\"" . $op . "\">\n";
}
if (isset($_GET['function']) && $_GET['function'] != '') {
echo "<input type=\"hidden\" name=\"function\" value=\"" . $_GET['function'] . "\">\n";
}
echo "<input type=\"button\" value=\"Update\" class=\"form_button\" onClick='document.forms.sidebar_year_form.submit();'></form></td></tr></table><br><hr>\n\n";
/*
//Decide what to show in the 'Location Bar' when navigating to the 'update_rappels.php' page, since updating rappels is not a crew-dependent operation
if(isset($_SESSION['current_view']['crew']) && ($_SESSION['current_view']['crew']->get('id') != NULL)) $update_rappels_crew_id = $_SESSION['current_view']['crew']->get('id');
else $update_rappels_crew_id = $_SESSION['current_user']->get('crew_affiliation_id');
*/
$crew_id = "";
$crew_name = "None Selected";
$region = "";
if (isset($_SESSION['current_view']['crew'])) {
$crew_id = $_SESSION['current_view']['crew']->get('id');
$crew_name = $_SESSION['current_view']['crew']->get('name');
}
if (isset($_SESSION['current_view']['region'])) {
$region = $_SESSION['current_view']['region'];
}
$academy_id = get_academy_id($region);
echo "<h3>" . ucwords(str_replace("_", " ", $_SESSION['current_user']->get('account_type'))) . "</h3><br><br>\n" . "<ul class=\"sidebar_menu\">\n";
echo "<li>Home\n" . "<ul>\n" . "\t<li><a href=\"index.php\">National Map</a></li>\n";
if ($_SESSION['current_user']->get('crew_affiliation_id')) {
echo "\t<li><a href=\"index.php?crew=" . $_SESSION['current_user']->get('crew_affiliation_id') . "\">My Crew</a></li>\n";
}
echo "<li><a href=\"weekly_report.php\">Weekly Report</a></li>\n";
echo "</ul></li>\n";
/*
if($crew_id != "") {
echo "<li><a href=\"modify_roster.php?crew=".$crew_id."\">Current Crew<br><small>(".$crew_name.")</small></a>\n"
."<ul>\n"
." <li><a href=\"modify_roster.php?crew=".$crew_id."\">View / Edit Crewmembers</a></li>\n"
." <li><a href=\"modify_roster.php?crew=".$crew_id."&function=add_hrap_menu\">Add Crewmembers</a></li>\n"
."</ul></li>\n\n";
}
*/
if ($region != "" || $crew_id != "" || $_SESSION['current_user']->get('account_type') == 'crew_admin') {
echo "<li>Rosters\n<ul>\n";
}
if ($region != "") {
echo "\t<li><a href=\"index.php?region=" . $region . "\">Regional Crew List</a></li>\n";
}
if ($crew_id != "") {
echo "\t<li><a href=\"index.php?region=" . $region . "&crew=" . $crew_id . "\">Crew Roster</a></li>\n";
}
if ($_SESSION['current_user']->get('account_type') == 'crew_admin') {
echo "\t<li><a href=\"modify_roster.php?&crew=" . $_SESSION['current_user']->get('crew_affiliation_id') . "\">Modify My Roster</a></li>\n";
}
if ($crew_id != "" && $_SESSION['current_user']->get('account_type') == 'admin') {
echo "\t<li><a href=\"modify_roster.php?&crew=" . $crew_id . "\">Modify This Roster</a></li>\n";
}
if ($region != "" || $crew_id != "" || $_SESSION['current_user']->get('account_type') == 'crew_admin') {
echo "</ul></li>\n";
}
if (in_array($_SESSION['current_user']->get('account_type'), array('admin', 'crew_admin'))) {
echo "\t<li>Rappel Records\n" . "\t<ul>\n" . "\t<li><a href=\"update_rappels.php?function=add_rappel\">Add a New Rappel</a></li>\n";
} elseif ($crew_id != "" || $region != "") {
echo "\t<li>Rappel Records\n" . "\t<ul>\n";
}
if ($crew_id != "" || $region != "") {
echo "\t<li><a href=\"proficiency_report.php?region=" . $region . "\">Regional Proficiency Report</a></li>\n" . "\t<li><a href=\"view_rappels.php?region=" . $region . "\">Regional Rappels</a></li>\n";
}
if ($crew_id != "") {
echo "\t<li><a href=\"proficiency_report.php?crew=" . $crew_id . "\">Crew Proficiency Report</a></li>\n" . "\t<li><a href=\"view_rappels.php?crew=" . $crew_id . "\">Crew Rappels</a></li>\n";
}
if ($crew_id != "" || $region != "" || in_array($_SESSION['current_user']->get('account_type'), array('admin', 'crew_admin'))) {
echo "</ul></li>\n\n";
}
if ($crew_id != "" || $region != "") {
echo "<li>Equipment\n" . "<ul>\n";
if (in_array($_SESSION['current_user']->get('account_type'), array('admin', 'crew_admin'))) {
echo "\t<li><a href=\"add_new_equipment.php?crew=" . $crew->get('id') . "\">Add New Equipment</a></li>\n";
}
echo "\t<li><a href=\"view_equipment.php?region=" . $region . "\">Regional Equipment</a></li>\n";
if ($academy_id != false) {
echo "\t<li><a href=\"view_equipment.php?crew=" . $academy_id . "®ion=" . $region . "\">Academy Equipment</a></li>\n";
}
if ($crew_id != "") {
echo "\t<li><a href=\"view_equipment.php?crew=" . $crew_id . "\">Crew Equipment</a></li>\n";
}
echo "</ul></li>\n\n";
}
echo "\t<li>Account Management\n" . "\t\t<ul><li><a href=\"account_management.php?function=edit_account&user_id=" . $_SESSION['current_user']->get('id') . "\">Edit My Account</a></li>\n";
if (in_array($_SESSION['current_user']->get('account_type'), array('admin', 'crew_admin'))) {
echo "\t\t<li><a href=\"account_management.php\">All Accounts</a></li>\n";
}
if (in_array($_SESSION['current_user']->get('account_type'), array('admin', 'crew_admin'))) {
echo "\t\t<li><a href=\"account_management.php?function=create_account\">Create an Account</a></li></ul>\n";
}
echo "\t</li>\n";
echo "</ul>\n\n";
}
}
function show_crew_cumulatives()
{
$crew = new crew();
$crew->load($_SESSION['current_view']['crew']->get('id'));
// Display Crew Cumulatives
echo "<div style=\"text-align:center;\">\n";
echo "<table style=\"margin:0 auto 0 auto;\">\n" . "<tr><td><img src=\"" . $crew->logo_filename . "\"></td>\n" . "<td><h1>" . $crew->name . "</h1>" . "<table style=\"margin:0 auto 0 auto;\">\n" . "<tr><td style=\"text-align:right\">Crew Size in " . $_SESSION['current_view']['year'] . ":</td><td style=\"text-align:right\">" . $crew->crewmember_count . "</td></tr>\n" . "<tr><td style=\"text-align:right\">Total Rappels in " . $_SESSION['current_view']['year'] . ":</td><td style=\"text-align:right\">" . $crew->raps_this_year_total . "</td></tr>\n" . "<tr><td style=\"text-align:right\">Operationals in " . $_SESSION['current_view']['year'] . ":</td><td style=\"text-align:right\">" . $crew->raps_this_year_operational . "</td></tr>\n" . "<tr><td style=\"text-align:right\">Operationals-per-Person in " . $_SESSION['current_view']['year'] . ":</td><td style=\"text-align:right; padding-left:10px;\">" . $crew->raps_this_year_per_person_operational . "</td></tr>\n" . "<tr><th colspan=\"2\" style=\"padding-top:10px;border-bottom:1px solid #555555;\">Demographics</th></tr>\n" . "<tr><td style=\"text-align:right\">Average Age:</td><td style=\"text-align:right\">" . $crew->avg_age . "</td></tr>\n" . "<tr><td style=\"text-align:right\">Crewmembers Who Are Male:</td><td style=\"text-align:right\">" . $crew->gender_ratio . "%</td></tr>\n" . "<tr><td style=\"text-align:right\">Rappels by Men / Women in " . $_SESSION['current_view']['year'] . ":</td><td style=\"text-align:right\">" . $crew->male_rappels . " / " . $crew->female_rappels . "</td></tr>\n" . "</table>\n" . "</td></tr>\n\n" . "</table></div>\n\n";
echo "<hr style=\"width:75%; height:3px; \">\n\n";
echo "This crew has roster information for the following years:<br>\n";
$year_str = "";
if ($year_array = $crew->get_roster_years()) {
foreach ($year_array as $year) {
$year_str .= "<a href=\"" . $_SERVER['PHP_SELF'] . "?region=" . $_SESSION['current_view']['region'] . "&crew=" . $_SESSION['current_view']['crew']->get('id') . "&year=" . $year . "\">" . $year . "</a> | ";
}
$year_str = substr($year_str, 0, strlen($year_str) - 3);
// Strip the last pipe divider off the string
}
echo $year_str . "\n<br><br>\n";
// Display crew roster - if user is logged in, each crewmember image will be a link to their rappel history. If NOT logged in, images are not links.
try {
if ($crew->get_crewmembers($_SESSION['current_view']['year'])) {
$col_count = 1;
echo "<table style=\"margin:0 auto 0 auto;\">\n";
foreach ($crew->crewmembers as $hrap) {
if (($col_count - 1) % 5 == 0) {
echo "<tr>\n";
}
echo "<td class=\"roster_thumbnail\">";
if (isset($_SESSION['logged_in']) && $_SESSION['logged_in']) {
echo "<a href=\"view_rappels.php?hrap=" . $hrap->get('id') . "\">";
}
echo "<img src=\"" . $hrap->headshot_filename . "\">";
if (isset($_SESSION['logged_in']) && $_SESSION['logged_in']) {
echo "</a>";
}
/* echo "<br>\n"
."<table><tr><td colspan=\"2\" style=\"text-align:center;font-weight:bold;\">".$hrap->name."</td></tr>\n"
."<tr><td style=\"text-align:right;\">Operationals:</td><td style=\"text-align:left;\">".$hrap->raps_all_time_operational."</td></tr></table>\n</td>";
*/
echo "<br>\n" . "<span style=\"font-weight:bold;\">" . $hrap->name . "</span><br>\n" . $hrap->raps_all_time_operational . " Ops / " . $hrap->raps_all_time_live . " Total</td>\n";
if ($col_count % 5 == 0) {
echo "\n</tr>\n";
}
$col_count++;
}
// End: foreach
echo "</table></div><br>\n";
}
} catch (Exception $e) {
echo $e->getMessage() . "<br>\n";
//Display message if there is no data for the selected year
}
}
