if ($i == $bins - 1) {
$bin_labels[$i] = $bin_size * $i . " to " . $max_raps_per_rope;
} else {
$a = $bin_size * $i;
$b = $bin_size * ($i + 1) - 1;
$bin_labels[$i] = $a . " to " . $b;
}
}
/*
echo "Bins: ".$bins."\n";
echo "Max Raps Per Rope: ".$max_raps_per_rope."\n";
echo "Bin Size: ".$bin_size."\n";
print_r($bin_labels);
*/
if ($total_ropes == 0) {
chart_error_msg("No ropes have been retired!");
} else {
$chart_data = "<chart_data>\n" . "\t<row>\n" . "\t\t<null/>\n";
foreach ($bin_labels as $label) {
$chart_data .= "\t\t<string>" . $label . "</string>\n";
}
$chart_data .= "\t</row>\n" . "\t<row>\n" . "\t\t<string>% of retired ropes with designated raps</string>\n";
foreach ($rope_cat as $idx => $rope_count) {
$pct = $rope_count / $total_ropes * 100;
$chart_data .= "\t\t<number label='" . $pct . "%' tooltip='" . $pct . "% of retired ropes\rhave only " . $bin_labels[$idx - 1] . " raps'>" . $pct . "</number>\n";
}
$chart_data .= "\t</row>\n" . "</chart_data>\n";
$chart_type = "<chart_type>column</chart_type>\n";
$chart_rect = "<chart_rect\tx='25'\n\t\t\t\t\t\t\t\t\ty='40'\n\t\t\t\t\t\t\t\t\twidth='200'\n\t\t\t\t\t\t\t\t\theight='150' />\n";
$legend = "<legend\tlayout='horizontal'\n\t\t\t\t\t\t\t\tbullet='square'\n\t\t\t\t\t\t\t\tfont='arial'\n\t\t\t\t\t\t\t\tbold='true'\n\t\t\t\t\t\t\t\tsize='10'\n\t\t\t\t\t\t\t\tcolor='555555'\n\t\t\t\t\t\t\t\talpha='90'\n\t\t\t\t\t\t\t\twidth='250'\n\t\t\t\t\t\t\t\tx='0'\n\t\t\t\t\t\t\t\ty='0'\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\ttransition='slide_left' delay='1' duration='1'/>\n";
$axis_value_label = "";
<?php
include '../php_doc_root.php';
require_once "classes/mydb_class.php";
require_once "classes/hrap_class.php";
require_once "classes/crew_class.php";
require_once "includes/charts/chart_error_msg.php";
session_name('raprec');
session_start();
// Get Regional Data
$query = "\n\tSELECT count(hraps.id) as hrap_count FROM hraps \n\tINNER JOIN rosters ON (rosters.hrap_id = hraps.id AND rosters.year = " . $_SESSION['current_view']['year'] . ")\n\tINNER JOIN crews ON (crews.id = rosters.crew_id AND crews.region = '" . $_SESSION['current_view']['crew']->get('region') . "')";
$result = mydb::cxn()->query($query);
if (!$result) {
chart_error_msg("Error counting rappels:\n" . mydb::cxn()->error);
} else {
$row = $result->fetch_assoc();
}
$total_hraps_in_region = $row['hrap_count'];
$query = "\n\tSELECT operation_type, count(raps) AS raps \n\tFROM rap_type_count \n\tWHERE year = '" . $_SESSION['current_view']['year'] . "' AND region = '" . $_SESSION['current_view']['crew']->get('region') . "' \n\tGROUP BY operation_type";
$result = mydb::cxn()->query($query);
if (!$result) {
echo "Error: " . mydb::cxn()->error;
}
$region_avg = array('operational' => 0, 'proficiency_live' => 0, 'proficiency_tower' => 0, 'certification_new_aircraft' => 0, 'certification_new_hrap' => 0);
while ($row = $result->fetch_assoc()) {
if (array_key_exists($row['operation_type'], $region_avg)) {
$region_avg[$row['operation_type']] = round($row['raps'] / $total_hraps_in_region, 1);
}
}
$region_avg['proficiency_live'] = $region_avg['proficiency_live'] + $region_avg['certification_new_aircraft'] + $region_avg['certification_new_hrap'];
$region_avg['total_live'] = $region_avg['proficiency_live'] + $region_avg['operational'];
<?php
include '../php_doc_root.php';
require_once "classes/mydb_class.php";
require_once "classes/hrap_class.php";
require_once "classes/crew_class.php";
require_once "includes/charts/chart_error_msg.php";
session_name('raprec');
session_start();
$max_rope_life = $_SESSION['max_rope_life_time'];
//Number of years before a rope MUST be retired (This value is specified in the 'includes/constants.php' file)
$query = "SELECT serial_num, life_days_remaining, status, in_service_date, DATEDIFF( STR_TO_DATE( retired_date, '%m/%d/%Y' ) , STR_TO_DATE( in_service_date, '%m/%d/%Y' ) ) AS retired_age FROM rope_use_view WHERE id = " . $_GET['rope_id'];
$result = mydb::cxn()->query($query);
if (!$result) {
chart_error_msg("Rope not found!");
} else {
$row = $result->fetch_assoc();
if ($row['status'] != "retired") {
$days_in_service = 365 * $max_rope_life - $row['life_days_remaining'];
$tooltip1 = "This rope has been\rIn Service for " . $days_in_service . " days";
if ($row['life_days_remaining'] > 0) {
$used_life = round(100 * (365 * $max_rope_life - $row['life_days_remaining']) / (365 * $max_rope_life), 1);
// A percentage of max_rope_life
$remaining_life = round(100 - $used_life, 1);
// The remaining percentage of max_rope_life
} else {
$used_life = 100;
$remaining_life = 0;
}
$tooltip2 = "This rope must be\rretired in " . $row['life_days_remaining'] . " days";
} else {
