function do_print($row_in)
{
global $today, $today_ref, $line_ctr, $units_str, $severities;
if (empty($today)) {
$today_ref = date("z", $row_in['problemstart']);
$today = substr(format_date($row_in['problemstart']), 0, 5);
} else {
if (!($today_ref == date("z", $row_in['problemstart']))) {
// date change?
$today_ref = date("z", $row_in['problemstart']);
$today = substr(format_date($row_in['problemstart']), 0, 5);
}
}
$def_city = get_variable('def_city');
$def_st = get_variable('def_st');
print "<TR CLASS= ''>\n";
print "<TD>{$today}</TD>\n";
// Date -
$problemstart = format_date($row_in['problemstart']);
$problemstart_sh = short_ts($problemstart);
print "<TD onMouseover=\"Tip('{$problemstart}');\" onmouseout='UnTip();'>{$problemstart_sh}</TD>\n";
// start
$problemend = format_date($row_in['problemend']);
$problemend_sh = short_ts($problemend);
print "<TD onMouseover=\"Tip('{$problemend}');\" onmouseout='UnTip();'>{$problemend_sh}</TD>\n";
// end
$elapsed = my_date_diff($row_in['problemstart'], $row_in['problemend']);
print "<TD>{$elapsed}</TD>\n";
// Ending time
print "<TD ALIGN='center'>{$severities[$row_in['severity']]}</TD>\n";
$scope = $row_in['tick_scope'];
$scope_sh = shorten($row_in['tick_scope'], 20);
print "<TD onMouseover=\"Tip('{$scope}');\" onmouseout='UnTip();'>{$scope_sh}</TD>\n";
// Call type
$comment = $row_in['comments'];
$short_comment = shorten($row_in['comments'], 50);
print "<TD onMouseover=\"Tip('{$comment}');\" onMouseout='UnTip();'>{$short_comment}</TD>\n";
// Comments/Disposition
$facility = $row_in['facy_name'];
$facility_sh = shorten($row_in['facy_name'], 16);
print "<TD onMouseover=\"Tip('{$facility}');\" onmouseout='UnTip();'>{$facility_sh}</TD>\n";
// Facility
$city = $row_in['tick_city'] == $def_city ? "" : ", {$row_in['tick_city']}";
$st = $row_in['tick_state'] == $def_st ? "" : ", {$row_in['tick_state']}";
$addr = "{$row_in['tick_street']}{$city}{$st}";
$addr_sh = shorten($row_in['tick_street'] . $city . $st, 20);
print "<TD onMouseover=\"Tip('{$addr}');\" onMouseout='UnTip();'>{$addr_sh}</TD>\n";
// Street addr
print "<TD>{$units_str}</TD>\n";
// Units responding
print "</TR>\n\n";
$line_ctr++;
}
function do_ticket($theRow, $theWidth, $search = FALSE, $dist = TRUE)
{
// returns table - 6/26/10
global $iw_width, $nature, $disposition, $patient, $incident, $incidents;
// 12/3/10
$tickno = get_variable('serial_no_ap') == 0 ? " <I>(#" . $theRow['id'] . ")</I>" : "";
// 1/25/09
switch ($theRow['severity']) {
//color tickets by severity
case $GLOBALS['SEVERITY_MEDIUM']:
$severityclass = 'severity_medium';
break;
case $GLOBALS['SEVERITY_HIGH']:
$severityclass = 'severity_high';
break;
default:
$severityclass = 'severity_normal';
break;
}
$print = "<TABLE BORDER='0' ID='left' width='" . $theWidth . "'>\n";
//
$print .= "<TR CLASS='even'><TD ALIGN='left' CLASS='td_data' COLSPAN=2 ALIGN='center'><B>{$incident}: <I>" . highlight($search, $theRow['scope']) . "</B>" . $tickno . "</TD></TR>\n";
$print .= "<TR CLASS='odd' ><TD ALIGN='left'>" . get_text("Addr") . ":</TD>\t\t<TD ALIGN='left'>" . highlight($search, $theRow['tick_street']) . "</TD></TR>\n";
$print .= "<TR CLASS='even' ><TD ALIGN='left'>" . get_text("City") . ":</TD>\t\t\t<TD ALIGN='left'>" . highlight($search, $theRow['tick_city']);
$print .= " " . highlight($search, $theRow['tick_state']) . "</TD></TR>\n";
$print .= "<TR CLASS='odd' ><TD ALIGN='left'>" . get_text("Priority") . ":</TD> <TD ALIGN='left' CLASS='" . $severityclass . "'>" . get_severity($theRow['severity']);
$print .= " {$nature}: " . get_type($theRow['in_types_id']);
$print .= "</TD></TR>\n";
$print .= "<TR CLASS='even' VALIGN='top'><TD ALIGN='left'>" . get_text("Synopsis") . ":</TD>\t<TD ALIGN='left'>" . replace_quotes(highlight($search, nl2br($theRow['tick_descr']))) . "</TD></TR>\n";
// 8/12/09
$print .= "<TR CLASS='odd' ><TD ALIGN='left'>" . get_text("Protocol") . ":</TD> <TD ALIGN='left' CLASS='{$severityclass}'>{$theRow['protocol']}</TD></TR>\n";
// 7/16/09
$print .= "<TR CLASS='even' VALIGN='top'><TD ALIGN='left'>" . get_text("911 Contacted") . ":</TD>\t<TD ALIGN='left'>" . highlight($search, nl2br($theRow['nine_one_one'])) . "</TD></TR>\n";
// 6/26/10
$print .= "<TR CLASS='odd'><TD ALIGN='left'>" . get_text("Reported by") . ":</TD>\t<TD ALIGN='left'>" . highlight($search, $theRow['contact']) . "</TD></TR>\n";
$print .= "<TR CLASS='even' ><TD ALIGN='left'>" . get_text("Phone") . ":</TD>\t\t\t<TD ALIGN='left'>" . format_phone($theRow['phone']) . "</TD></TR>\n";
$end_date = intval($theRow['problemend']) > 1 ? $theRow['problemend'] : time() - intval(get_variable('delta_mins')) * 60;
$elapsed = my_date_diff($theRow['problemstart'], $end_date);
$elaped_str = intval($theRow['problemend']) > 1 ? "" : " ({$elapsed})";
$print .= "<TR CLASS='odd'><TD ALIGN='left'>" . get_text("Status") . ":</TD>\t\t<TD ALIGN='left'>" . get_status($theRow['status']) . "{$elaped_str}</TD></TR>\n";
$by_str = $theRow['call_taker'] == 0 ? "" : " by " . get_owner($theRow['call_taker']) . " ";
// 1/7/10
$print .= "<TR CLASS='even'><TD ALIGN='left'>" . get_text("Written") . ":</TD>\t\t<TD ALIGN='left'>" . format_date($theRow['date']) . $by_str;
$print .= " Updated: " . format_date($theRow['updated']) . "</TD></TR>\n";
$print .= empty($theRow['booked_date']) ? "" : "<TR CLASS='odd'><TD ALIGN='left'>Scheduled date:</TD>\t\t<TD ALIGN='left'>" . format_date($theRow['booked_date']) . "</TD></TR>\n";
// 10/6/09
$print .= "<TR CLASS='even' ><TD ALIGN='left' COLSPAN='2'> \t<TD ALIGN='left'></TR>\n";
// separator
$print .= empty($theRow['fac_name']) ? "" : "<TR CLASS='odd' ><TD ALIGN='left'>{$incident} at Facility:</TD>\t\t<TD ALIGN='left'>" . highlight($search, $theRow['fac_name']) . "</TD></TR>\n";
// 8/1/09
$print .= empty($theRow['rec_fac_name']) ? "" : "<TR CLASS='even' ><TD ALIGN='left'>Receiving Facility:</TD>\t\t<TD ALIGN='left'>" . highlight($search, $theRow['rec_fac_name']) . "</TD></TR>\n";
// 10/6/09
$print .= empty($theRow['comments']) ? "" : "<TR CLASS='odd' VALIGN='top'><TD ALIGN='left'>{$disposition}:</TD>\t<TD ALIGN='left'>" . replace_quotes(highlight($search, nl2br($theRow['comments']))) . "</TD></TR>\n";
$print .= "<TR CLASS='even' ><TD ALIGN='left'>" . get_text("Run Start") . ":</TD>\t\t\t\t\t<TD ALIGN='left'>" . format_date($theRow['problemstart']);
$elaped_str = intval($theRow['problemend']) > 1 ? $elapsed : "";
$print .= " End: " . format_date($theRow['problemend']) . " ({$elaped_str})</TD></TR>\n";
$locale = get_variable('locale');
// 08/03/09
switch ($locale) {
case "0":
$grid_type = " USNG " . LLtoUSNG($theRow['lat'], $theRow['lng']);
break;
case "1":
$grid_type = " OSGB " . LLtoOSGB($theRow['lat'], $theRow['lng']);
// 8/23/08, 10/15/08, 8/3/09
break;
case "2":
$coords = $theRow['lat'] . "," . $theRow['lng'];
// 8/12/09
$grid_type = " UTM " . toUTM($coords);
// 8/23/08, 10/15/08, 8/3/09
break;
default:
print "ERROR in " . basename(__FILE__) . " " . __LINE__ . "<BR />";
}
$print .= "<TR CLASS='odd'><TD ALIGN='left' onClick = 'javascript: do_coords(" . $theRow['lat'] . "," . $theRow['lng'] . ")'><U>" . get_text("Position") . "</U>: </TD>\n\t\t<TD ALIGN='left'>" . get_lat($theRow['lat']) . " " . get_lng($theRow['lng']) . $grid_type . "</TD></TR>\n";
// 9/13/08
$print .= "<TR><TD colspan=2 ALIGN='left'>";
$print .= show_log($theRow[0]);
// log
$print .= "</TD></TR>";
$print .= "<TR STYLE = 'display:none;'><TD colspan=2><SPAN ID='oldlat'>" . $theRow['lat'] . "</SPAN><SPAN ID='oldlng'>" . $theRow['lng'] . "</SPAN></TD></TR>";
$print .= "</TABLE>\n";
$print .= show_assigns(0, $theRow[0]);
// 'id' ambiguity - 7/27/09
$print .= show_actions($theRow[0], "date", FALSE, FALSE);
return $print;
}
$severities[$GLOBALS['SEVERITY_HIGH']] = "#F80000";
$colors[$GLOBALS['SEVERITY_NORMAL']] = "black";
$colors[$GLOBALS['SEVERITY_MEDIUM']] = "black";
$colors[$GLOBALS['SEVERITY_HIGH']] = "yellow";
echo "<BODY style='background-color:{$severities[$row['severity']]}; text-color: {$colors[$row['severity']]};' onload = 'ck_frames();' >";
/* Creates statistics header and details of responding and en-route units 7/29/09 */
$result_dispatched = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}'\n\tAND `dispatched` IS NOT NULL AND `responding` IS NULL AND `on_scene` IS NULL AND `clear` IS NULL");
$num_rows_dispatched = mysql_num_rows($result_dispatched);
$result_responding = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}'\n\tAND `responding` IS NOT NULL AND `on_scene` IS NULL AND `clear` IS NULL");
$num_rows_responding = mysql_num_rows($result_responding);
$result_on_scene = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}' \n\tAND `on_scene` IS NOT NULL AND `clear` IS NULL");
$num_rows_on_scene = mysql_num_rows($result_on_scene);
$result_cleared = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE ticket_id='{$id}' \n\tAND `clear` IS NOT NULL");
$num_rows_cleared = mysql_num_rows($result_cleared);
$end_date = is_date($row['problemend']) ? totime($row['problemend']) : time() - get_variable('delta_mins') * 60;
$elapsed = my_date_diff($end_date, totime($row['problemstart']));
// integer values req'd - 3/12/10
$stats = "<B>Severity: {$ticket_severity}, <SPAN STYLE='background-color:white; color:black;'> age: {$elapsed} </SPAN>";
echo $stats;
echo "<BR>Units dispatched: ({$num_rows_dispatched}) ";
while ($row_base = mysql_fetch_array($result_dispatched, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
}
echo "<BR>Units responding: ({$num_rows_responding}) ";
while ($row_base = mysql_fetch_array($result_responding, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
}
function do_list($unit_id = "", $capabilities = "", $searchtype)
{
// 12/18/10
global $unav_id_str, $row_ticket, $dispatches_disp, $dispatches_act, $from_top, $eol, $sidebar_width, $sortby_distance;
$conversion = get_dist_factor();
// KM vs mi - 11/23/10
switch ($row_ticket['severity']) {
//color tickets by severity
case $GLOBALS['SEVERITY_MEDIUM']:
$severityclass = 'severity_medium';
break;
case $GLOBALS['SEVERITY_HIGH']:
$severityclass = 'severity_high';
break;
case $GLOBALS['SEVERITY_NORMAL']:
$severityclass = 'severity_normal';
break;
default:
dump(basename(__FILE__) . "/" . __LINE__);
break;
}
$query = "SELECT *,UNIX_TIMESTAMP(problemstart) AS problemstart,UNIX_TIMESTAMP(problemend) AS problemend,\n\t\t\tUNIX_TIMESTAMP(booked_date) AS booked_date,\n\t\t\tUNIX_TIMESTAMP(date) AS date,UNIX_TIMESTAMP(`{$GLOBALS['mysql_prefix']}ticket`.`updated`) AS updated,\n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.`description` AS `tick_descr` \n\t\t\tFROM `{$GLOBALS['mysql_prefix']}ticket` \n\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}in_types` `ty` ON (`{$GLOBALS['mysql_prefix']}ticket`.`in_types_id` = `ty`.`id`)\t\t\n\t\t\tWHERE `{$GLOBALS['mysql_prefix']}ticket`.`id`=" . get_ticket_id() . " LIMIT 1";
// 7/24/09 10/16/08 Incident location 09/25/09 Pre Booking
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_ticket = stripslashes_deep(mysql_fetch_array($result));
$facility = $row_ticket['facility'];
$rec_fac = $row_ticket['rec_facility'];
if ($row_ticket['lat'] == 0.999999 && $row_ticket['lng'] == 0.999999) {
// check for tickets created in no-maps mode 8/4/10
$lat = get_variable('def_lat');
$lng = get_variable('def_lng');
} else {
$lat = $row_ticket['lat'];
$lng = $row_ticket['lng'];
}
// end check for tickets created in no-maps mode
// print "var thelat = " . $lat . ";\nvar thelng = " . $lng . ";\n"; // set js-accessible location data
unset($result);
if ($rec_fac > 0) {
$query_rfc = "SELECT * FROM `{$GLOBALS['mysql_prefix']}facilities` WHERE `id`= {$rec_fac} ";
// 7/24/09 10/16/08 Incident location 10/06/09 Multi point routing
$result_rfc = mysql_query($query_rfc) or do_error($query_rfc, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_rec_fac = stripslashes_deep(mysql_fetch_array($result_rfc));
$rf_lat = $row_rec_fac['lat'];
$rf_lng = $row_rec_fac['lng'];
$rf_name = $row_rec_fac['name'];
// print "var thereclat = " . $rf_lat . ";\nvar thereclng = " . $rf_lng . ";\n"; // set js-accessible location data for receiving facility
} else {
// print "var thereclat;\nvar thereclng;\n"; // set js-accessible location data for receiving facility
}
?>
<SCRIPT>
var color=0;
var last_from;
var last_to;
var rec_fac;
var current_id; // 10/25/08
var output_direcs = ""; //10/6/09
var have_direcs = 0; //10/6/09
var tick_name = "<?php
print $row_ticket['scope'];
?>
"; // 3/15/11
if (GBrowserIsCompatible()) {
var colors = new Array ('odd', 'even');
var Direcs = null; // global
var Now;
var mystart;
var myend;
function setDirections(fromAddress, toAddress, recfacAddress, locale, unit_id) { //10/6/09
if (document.routes_Form.frm_allow_dirs.value==='false') {return false;} // 11/21/09
$("mail_button").style.display = "none"; //10/6/09
$("loading").style.display = "inline-block"; // 10/28/09
$("directions_ok_no").style.display = "none";
$("loading_2").style.display = "inline-block";
last_from = fromAddress;
last_to = toAddress;
rec_fac = recfacAddress;
f_unit = unit_id; //10/6/09
G_START_ICON.image = "./our_icons/sm_white.png";
G_START_ICON.iconSize = new GSize(12,20);
G_END_ICON.image = "./our_icons/sm_white.png";
G_END_ICON.iconSize = new GSize(12,20);
Now = new Date(); // Grab the current date.
mystart = Now.getTime(); // Initialize variable Start
if (rec_fac != "") { //10/6/09
var Direcs = gdir.load("from: " + fromAddress + " to: " + toAddress + " to: " + recfacAddress, { "locale": locale, preserveViewport : true });
}
else{
var Direcs = gdir.load("from: " + fromAddress + " to: " + toAddress, { "locale": locale, preserveViewport : true });
}
GEvent.addListener(Direcs, "addoverlay", GEvent.callback(Direcs, cb2())); // 11/21/09
} // end function set Directions()
function cb2() { // callback function 10/6/09
var output_direcs = "";
for ( var i = 0; i < gdir.getNumRoutes(); i++) { // Traverse all routes - not really needed here, but ...
var groute = gdir.getRoute(i);
var distanceTravelled = 0; // if you want to start summing these
for ( var j = 0; j < groute.getNumSteps(); j++) { // Traverse the steps this route
var gstep = groute.getStep(j);
var directions_text = gstep.getDescriptionHtml();
var directions_dist = gstep.getDistance().html;
output_direcs = output_direcs + directions_text + " " + directions_dist + ". " + "\n";
}
}
output_direcs = output_direcs.replace("<div class=\"google_note\">", "\n -"); //10/6/09
output_direcs = output_direcs.replace("Destination", "\n***Destination"); //10/6/09
output_direcs = output_direcs.replace(" :", " "); //10/6/09
document.email_form.frm_direcs.value = output_direcs; //10/6/09
document.email_form.frm_u_id.value = f_unit; //10/6/09
document.email_form.frm_scope.value = tick_name; //10/29/09
have_direcs = 1; //10/6/09
$("mail_button").style.display = "inline-block"; //10/6/09
$("loading").style.display = "none"; // 10/28/09
$("loading_2").style.display = "none";
$("directions_ok_no").style.display = "inline-block";
} // end function cb2()
function mail_direcs(f) { //10/6/09
f.target = 'Mail Form'
newwindow_mail=window.open('',f.target,'titlebar, location=0, resizable=1, scrollbars, height=360,width=600,status=0,toolbar=0,menubar=0,location=0, left=100,top=300,screenX=100,screenY=300');
if (isNull(newwindow_mail)) {
alert ("Email edit operation requires popups to be enabled -- please adjust your browser options.");
return;
}
newwindow_mail.focus();
f.submit();
return false;
}
function do_sidebar(sidebar, color, id, unit_id) { // No map
var letter = ""+ id; // start with 1 - 1/5/09 - 1/29/09
marker = null;
gmarkers[id] = null; // marker to array for side bar click function
side_bar_html += "<TR ID = '_tr" + id + "' CLASS='" + colors[(id+1)%2] +"' VALIGN='bottom' onClick = myclick(" + id + "," + unit_id +");><TD>";
side_bar_html += "<IMG BORDER=0 SRC='rtarrow.gif' ID = \"R" + id + "\" STYLE = 'visibility:hidden;' /></TD>";
var letter = ""+ id; // start with 1 - 1/5/09 - 1/29/09
// var the_class = (direcs[id])? "emph" : "td_label";
var the_class = (lats[id])? "emph" : "td_label";
side_bar_html += "<TD CLASS='" + the_class + "' ALIGN='right'>" + letter + " "+ sidebar +"</TD></TR>\n";
return null;
} // end function create Marker()
function createMarker(point,sidebar,tabs, color, id, unit_id) { // Creates marker and sets up click event infowindow
do_sidebar(sidebar, color, id, unit_id)
var icon = new GIcon(listIcon);
var uid = unit_id;
var letter = ""+ id;
// start with 1 - 1/5/09 - 1/29/09
var icon_url = "./our_icons/gen_icon.php?blank=" + escape(icons[color]) + "&text=" + letter; // 1/5/09
icon.image = icon_url; // ./our_icons/gen_icon.php?blank=4&text=zz"
var marker = new GMarker(point, icon);
marker.id = color; // for hide/unhide - unused
GEvent.addListener(marker, "click", function() { // here for both side bar and icon click
map.closeInfoWindow();
which = id;
gmarkers[which].hide();
marker.openInfoWindowTabsHtml(infoTabs[id]);
var dMapDiv = document.getElementById("detailmap");
var detailmap = new GMap2(dMapDiv);
detailmap.addControl(new GSmallMapControl());
detailmap.setCenter(point, 17); // larger # = closer
detailmap.addOverlay(marker);
});
gmarkers[id] = marker; // marker to array for side bar click function
infoTabs[id] = tabs; // tabs to array
bounds.extend(point); // extend the bounding box
return marker;
} // end function create Marker()
function createdummyMarker(point,sidebar,tabs, color, id, unit_id) { // Creates marker and sets up click event infowindow
do_sidebar(sidebar, color, id, unit_id)
var icon = new GIcon(listIcon);
var uid = unit_id;
var letter = ""+ id;
// start with 1 - 1/5/09 - 1/29/09
var icon_url = "./our_icons/question1.png"; // 1/5/09
icon.image = icon_url;
var marker = new GMarker(point, icon);
marker.id = color; // for hide/unhide - unused
GEvent.addListener(marker, "click", function() { // here for both side bar and icon click
map.closeInfoWindow();
which = id;
gmarkers[which].hide();
marker.openInfoWindowTabsHtml(infoTabs[id]);
var dMapDiv = document.getElementById("detailmap");
var detailmap = new GMap2(dMapDiv);
detailmap.addControl(new GSmallMapControl());
detailmap.setCenter(point, 17); // larger # = closer
detailmap.addOverlay(marker);
});
gmarkers[id] = marker; // marker to array for side bar click function
infoTabs[id] = tabs; // tabs to array
bounds.extend(point); // extend the bounding box
return marker;
} // end function create Marker()
function myclick(id, unit_id) { // responds to side bar click
var norecfac = "";
if (document.getElementById(current_id)) {
document.getElementById(current_id).style.visibility = "hidden"; // hide last check if defined
}
current_id= "R"+id;
document.getElementById(current_id).style.visibility = "visible"; // show newest
if (lats[id]) { // position data?
$('mail_dir_but').style.visibility = "visible"; // 11/12/09
<?php
if ($lat == 0.999999 && $lng == 0.999999) {
// test of tickets entered in no-maps mode 8/4/10
?>
var thelat = <?php
print get_variable('def_lat');
?>
; var thelng = <?php
print get_variable('def_lng');
?>
; // coords of click point
<?php
} else {
?>
var thelat = <?php
print $lat;
?>
; var thelng = <?php
print $lng;
?>
; // coords of click point
<?php
}
// end of test of tickets entered in no-maps mode 8/4/10
if ($row_ticket['rec_facility'] > 0) {
?>
var thereclat = <?php
print $rf_lat;
?>
; var thereclng = <?php
print $rf_lng;
?>
; //adds in receiving facility
if (direcs[id]) {
setDirections(lats[id] + " " + lngs[id], thelat + " " + thelng, thereclat + " " + thereclng, "en_US", unit_id); // get directions
}
<?php
} else {
?>
if (direcs[id]) {
setDirections(lats[id] + " " + lngs[id], thelat + " " + thelng, norecfac, "en_US", unit_id); // get directions
}
<?php
}
?>
}
else {
$('directions').innerHTML = ""; // no position data, no directions
$('mail_dir_but').style.visibility = "hidden"; // 11/12/09 -
}
$("directions").innerHTML= ""; // prior directions no longer apply - 11/21/09
if (gdir) { gdir.clear();}
} // end function my click(id)
var the_grid;
var grid = false;
function doGrid() {
if (grid) {
map.removeOverlay(the_grid);
}
else {
the_grid = new LatLonGraticule();
map.addOverlay(the_grid);
}
grid = !grid;
} // end function doGrid
var trafficInfo = new GTrafficOverlay();
var toggleState = true;
function doTraffic() { // 10/16/08
if (toggleState) {
map.removeOverlay(trafficInfo);
}
else {
map.addOverlay(trafficInfo);
}
toggleState = !toggleState; // swap
} // end function doTraffic()
var starting = false;
function sv_win(theLat, theLng) { // 8/17/09
if(starting) {return;} // dbl-click proof
starting = true;
// alert(622);
var url = "street_view.php?thelat=" + theLat + "&thelng=" + theLng;
newwindow_sl=window.open(url, "sta_log", "titlebar=no, location=0, resizable=1, scrollbars, height=450,width=640,status=0,toolbar=0,menubar=0,location=0, left=100,top=300,screenX=100,screenY=300");
if (!(newwindow_sl)) {
alert ("Street view operation requires popups to be enabled. Please adjust your browser options - or else turn off the Call Board option.");
return;
}
newwindow_sl.focus();
starting = false;
} // end function sv win()
function handleErrors(){ //G_GEO_UNKNOWN_DIRECTIONS
if (gdir.getStatus().code == G_GEO_UNKNOWN_DIRECTIONS ) {
alert("501: directions unavailable\n\nClick map point for directions.");
}
else if (gdir.getStatus().code == G_GEO_UNKNOWN_ADDRESS)
alert("440: No corresponding geographic location could be found for one of the specified addresses. This may be due to the fact that the address is relatively new, or it may be incorrect.\nError code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_SERVER_ERROR)
alert("442: A map request could not be processed, reason unknown.\n Error code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_MISSING_QUERY)
alert("444: Technical error.\n Error code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_BAD_KEY)
alert("448: The given key is either invalid or does not match the domain for which it was given. \n Error code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_BAD_REQUEST)
alert("450: A directions request could not be successfully parsed.\n Error code: " + gdir.getStatus().code);
else alert("451: An unknown error occurred.");
} // end function handleErrors()
function onGDirectionsLoad(){
// var temp = gdir.getSummaryHtml();
} // function onGDirectionsLoad()
function guest () {
alert ("Demonstration only. Guests may not commit dispatch!");
}
function validate(){ // frm_id_str
msgstr="";
for (var i =1;i<unit_sets.length;i++) { // 3/30
if (unit_sets[i]) {
msgstr+=unit_names[i]+"\n";
document.routes_Form.frm_id_str.value += unit_ids[i] + "|";
}
}
if (msgstr.length==0) {
var more = (nr_units>1)? "s": ""
alert ("Please select unit" + more + ", or cancel");
return false;
}
else {
var quick = <?php
print intval(get_variable("quick") == 1) ? "true;\n" : "false;\n";
?>
if ((quick) || (confirm ("Please confirm unit dispatch\n\n" + msgstr))) { // 11/23/09
document.routes_Form.frm_id_str.value = document.routes_Form.frm_id_str.value.substring(0, document.routes_Form.frm_id_str.value.length - 1); // drop trailing separator
document.routes_Form.frm_name_str.value = msgstr; // for re-use
document.routes_Form.submit();
// document.getElementById("outer").style.display = "none"; 4/26/10
document.getElementById("bottom").style.display = "block";
}
else {
document.routes_Form.frm_id_str.value="";
return false;
}
}
} // end function validate()
function exists(myarray,myid) {
var str_key = " " + myid; // force associative
return ((typeof myarray[str_key])!="undefined"); // exists if not undefined
} // end function exists()
var icons=[]; // note globals
<?php
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}unit_types` ORDER BY `id`";
// types in use
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$icons = $GLOBALS['icons'];
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// map type to blank icon id
$blank = $icons[$row['icon']];
print "\ticons[" . $row['id'] . "] = " . $row['icon'] . ";\n";
//
}
unset($result);
?>
var map;
var center;
var zoom;
var gdir; // directions
var geocoder = null;
var addressMarker;
$("mail_button").style.display = "none"; // 10/28/09
$("loading").style.display = "none"; // 10/28/09
var side_bar_html = "<TABLE border=0 CLASS='sidebar' ID='tbl_responders' STYLE = 'WIDTH: <?php
print $sidebar_width;
?>
px;'>";
var gmarkers = [];
var infoTabs = [];
var lats = [];
var lngs = [];
var unit_names = []; // names
var unit_sets = []; // settings
var unit_ids = []; // id's
var unit_assigns = []; // unit id's assigned this incident
var direcs = []; // if true, do directions - 7/13/09
var which; // marker last selected
var i = 0; // sidebar/icon index
map = new GMap2(document.getElementById("map_canvas")); // create the map
map.setCenter(new GLatLng(<?php
echo get_variable('def_lat');
?>
, <?php
echo get_variable('def_lng');
?>
), <?php
echo get_variable('def_zoom');
?>
);
// map.addControl(new GSmallMapControl()); // 9/23/08
map.setUIToDefault(); // 8/13/10
map.addControl(new GMapTypeControl());
var bounds = new GLatLngBounds(); // create empty bounding box
do_landb(); // 8/1/11 - show scribbles
<?php
if (intval(get_variable('terrain')) == 1) {
?>
map.addMapType(G_PHYSICAL_MAP);
<?php
}
?>
gdir = new GDirections(map, document.getElementById("directions"));
GEvent.addListener(gdir, "load", onGDirectionsLoad);
try {GEvent.addListener(gdir, "error", handleErrors);}
catch (e) {}
var listIcon = new GIcon();
listIcon.image = "./markers/yellow.png"; // yellow.png - 16 X 28
listIcon.shadow = "./markers/sm_shadow.png";
listIcon.iconSize = new GSize(20, 34);
listIcon.shadowSize = new GSize(37, 34);
listIcon.iconAnchor = new GPoint(8, 28);
listIcon.infoWindowAnchor = new GPoint(9, 2);
listIcon.infoShadowAnchor = new GPoint(18, 25);
var newIcon = new GIcon();
newIcon.image = "./markers/white.png"; // yellow.png - 20 X 34
newIcon.shadow = "./markers/shadow.png";
newIcon.iconSize = new GSize(20, 34);
newIcon.shadowSize = new GSize(37, 34);
newIcon.iconAnchor = new GPoint(8, 28);
newIcon.infoWindowAnchor = new GPoint(9, 2);
newIcon.infoShadowAnchor = new GPoint(18, 25);
// set Incident position
var point = new GLatLng(<?php
print $lat;
?>
, <?php
print $lng;
?>
); // 675
bounds.extend(point); // Incident into BB
GEvent.addListener(map, "infowindowclose", function() { // re-center after move/zoom
setDirections(last_from, last_to, "en_US") ;
});
var accept_click = false; // 10/15/08
GEvent.addListener(map, "click", function(marker, point) { // point.lat()
var the_start = point.lat().toString() + "," + point.lng().toString();
var the_end = thelat.toString() + "," + thelng.toString();
setDirections(the_start, the_end, "en_US");
}); // end GEvent.addListener()
var nr_units = 0;
var email= false;
<?php
function get_cd_str($in_row)
{
// unit row in,
global $unit_id;
// // first, already on this run?
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = " . get_ticket_id() . "\n\t\t\t\t\t AND (`responder_id`={$in_row['unit_id']}) \n\t\t\t\t\t AND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00')) LIMIT 1;";
// 6/25/10
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
return " CHECKED DISABLED ";
}
if ($unit_id != "" && (mysql_affected_rows() != 1 || mysql_affected_rows() == 1 && intval($in_row['multi']) == 1)) {
print "checked";
return " CHECKED ";
}
// 12/18/10 - Checkbox checked here individual unit seleted.
if (intval($in_row['dispatch']) == 2) {
return " DISABLED ";
}
// 2nd, disallowed - 5/30/10
if (intval($in_row['multi']) == 1) {
return "";
}
// 3rd, allowed
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` \n\t\t\t\t\tWHERE `responder_id`={$in_row['unit_id']} \n\t\t\t\t\tAND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00'))\n\t\t\t\t\tLIMIT 1;";
// 6/25/10
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
return " DISABLED ";
} else {
return "";
}
}
// function get cd_str($in_row)
$eols = array("\r\n", "\n", "\r");
// all flavors of eol
// build js array of responders to this ticket - possibly none
$query = "SELECT `ticket_id`, `responder_id` \n\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = " . get_ticket_id();
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($assigns_row = stripslashes_deep(mysql_fetch_array($result))) {
print "\t\tunit_assigns[' '+ " . $assigns_row['responder_id'] . "]= true;\n";
// note string forced
}
print "\n";
// ===================================================================================
$query = "SELECT *, UNIX_TIMESTAMP(problemstart) AS problemstart, UNIX_TIMESTAMP(problemend) AS problemend \n\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}ticket` \n\t\t\t\tWHERE `id`= " . get_ticket_id() . " LIMIT 1;";
// 4/5/10
$result_pos = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
$row_position = stripslashes_deep(mysql_fetch_array($result_pos));
$latitude = $row_position['lat'];
$longitude = $row_position['lng'];
$problemstart = $row_position['problemstart'];
$problemend = $row_position['problemend'];
unset($result_pos);
} else {
// dump ($query);
}
$where = empty($unit_id) ? "" : " AND `r`.`id` = {$unit_id} ";
// revised 5/23/08 per AD7PE
// $where2 = (empty($capabilities))? "" : " AND ("; // 12/18/10
if (!empty($unit_id)) {
$where2 = "";
} else {
$where2 = empty($capabilities) ? "" : " AND (";
// 12/18/10
$searchitems = empty($capabilities) ? "" : explode(" ", $capabilities);
if ($searchitems) {
for ($j = 0; $j < count($searchitems); $j++) {
if ($j + 1 != count($searchitems)) {
$where2 .= "`r`.`capab` LIKE '%{$searchitems[$j]}%' {$searchtype}";
} else {
$where2 .= "`r`.`capab` LIKE '%{$searchitems[$j]}%')";
}
}
}
}
switch (intval(trim(get_variable('locale')))) {
// nm conversion, 3/15/11
case 0:
$nm_to_what = 1.1515;
// mi
$capt = "mi";
break;
case 1:
$nm_to_what = 1.1515 * 1.609344;
// UK - km
$capt = "km";
break;
case 2:
$nm_to_what = 1.1515 * 1.609344;
// ROW - km
$capt = "km";
break;
default:
$nm_to_what = 1.1515 * 1.609344;
// ERROR?
$capt = "km";
break;
}
$have_position = !($latitude == 0.999999 && $longitude == 0.999999);
$by_distance = $sortby_distance && $have_position ? "`distance` ASC, " : "";
// 6/19/10 - user-set variable, 2/5/11 calls assigned added as order element
// 5/30/10, 11/24/10
// ============================= Regions Stuff
// Allows Tickets to be dispatched to any responders in the same region as the current user.
// $query = "SELECT * FROM `$GLOBALS[mysql_prefix]allocates` WHERE `type`= 4 AND `resource_id` = '$_SESSION[user_id]' ORDER BY `id` ASC;"; // 4/18/11
// $result = mysql_query($query); // 5/4/11
// $al_groups = array();
// $al_names = "";
// while ($row = stripslashes_deep(mysql_fetch_assoc($result))) { // 5/4/11
// $al_groups[] = $row['group'];
// $query2 = "SELECT * FROM `$GLOBALS[mysql_prefix]region` WHERE `id`= '$row[group]';"; // 5/4/11
// $result2 = mysql_query($query2); // 5/4/11
// while ($row2 = stripslashes_deep(mysql_fetch_assoc($result2))) { // 5/4/11
// $al_names .= $row2['group_name'] . ", ";
// }
// }
// if(isset($_SESSION['viewed_groups'])) {
// $al_groups= explode(",",$_SESSION['viewed_groups']);
// }
// if(!isset($_SESSION['viewed_groups'])) { // 5/4/11
// $x=0;
// $where3 = "AND (";
// foreach($al_groups as $grp) {
// $where4 = (count($al_groups) > ($x+1)) ? " OR " : ")";
// $where3 .= "`a`.`group` = '{$grp}'";
// $where3 .= $where4;
// $x++;
// }
// } else {
// $x=0;
// $where3 = "AND (";
// foreach($al_groups as $grp) {
// $where4 = (count($al_groups) > ($x+1)) ? " OR " : ")";
// $where3 .= "`a`.`group` = '{$grp}'";
// $where3 .= $where4;
// $x++;
// }
// }
// $where3 .= " AND `a`.`type` = 2";
// Replacement code - only allows Tickets to be dispatched to responders in the same region
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 1 AND `resource_id` = " . get_ticket_id() . " ORDER BY `id` ASC;";
// 4/18/11
$result = mysql_query($query);
// 5/4/11
$al_groups = array();
$al_names = "";
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// 5/4/11
$al_groups[] = $row['group'];
$query2 = "SELECT * FROM `{$GLOBALS['mysql_prefix']}region` WHERE `id`= '{$row['group']}';";
// 5/4/11
$result2 = mysql_query($query2);
// 5/4/11
while ($row2 = stripslashes_deep(mysql_fetch_assoc($result2))) {
// 5/4/11
$al_names .= $row2['group_name'] . ", ";
}
}
$x = 0;
$where3 = "AND (";
foreach ($al_groups as $grp) {
$where4 = count($al_groups) > $x + 1 ? " OR " : ")";
$where3 .= "`a`.`group` = '{$grp}'";
$where3 .= $where4;
$x++;
}
$where3 .= " AND `a`.`type` = 2";
// ================================ end of regions stuff
$query = "(SELECT *, UNIX_TIMESTAMP(`updated`) AS `updated`, `r`.`name` AS `unit_name`, `t`.`name` AS `type_name`, `r`.`type` AS `type`,\n\t\t\t\t`r`.`id` AS `unit_id`, `r`.`capab` AS `capab`,\n\t\t\t\t`s`.`status_val` AS `unitstatus`, `contact_via`, \n\t\t\t\t(((acos(sin(({$latitude}*pi()/180)) * sin((`r`.`lat`*pi()/180))+cos(({$latitude}*pi()/180)) * cos((`r`.`lat`*pi()/180)) * cos((({$longitude} - `r`.`lng`)*pi()/180))))*180/pi())*60*{$nm_to_what}) AS `distance`,\n\t\t\t\t(SELECT COUNT(*) as numfound FROM `{$GLOBALS['mysql_prefix']}assigns` \n\t\t\t\t\tWHERE `{$GLOBALS['mysql_prefix']}assigns`.`responder_id` = `r`.`id` \n\t\t\t\t\tAND `clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00' )\n\t\t\t\t\tAS `calls_assigned`\t\t\t\n\t\t\t\t\n\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}responder` `r`\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}un_status` `s` ON (`r`.`un_status_id` = `s`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}unit_types` `t` ON (`r`.`type` = `t`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` `a` ON (`r`.`id` = `a`.`resource_id`)\t\t\t\t\t\n\t\t\t\t WHERE `dispatch` = 0 {$where} {$where2} {$where3} GROUP BY unit_id )\n\t\t\tUNION DISTINCT\n\t\t\t\t(SELECT *, UNIX_TIMESTAMP(`updated`) AS `updated`, `r`.`name` AS `unit_name`, `t`.`name` AS `type_name`, `r`.`type` AS `type`,\n\t\t\t\t`r`.`id` AS `unit_id`, `r`.`capab` AS `capab`,\n\t\t\t\t`s`.`status_val` AS `unitstatus`, `contact_via`, \n\t\t\t\t9999 AS `distance`,\n\t\t\t\t(SELECT COUNT(*) as numfound FROM `{$GLOBALS['mysql_prefix']}assigns` \n\t\t\t\t\tWHERE `{$GLOBALS['mysql_prefix']}assigns`.`responder_id` = `r`.`id` \n\t\t\t\t\tAND `clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00' ) \n\t\t\t\t\tAS `calls_assigned`\t\t\t\n\t\t\t\t\n\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}responder` `r`\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}un_status` `s` ON (`r`.`un_status_id` = `s`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}unit_types` `t` ON (`r`.`type` = `t`.`id`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` `a` ON (`r`.`id` = `a`.`resource_id`)\t\t\t\t\t\n\t\t\t\t WHERE `dispatch` > 0 {$where} {$where2} {$where3} GROUP BY unit_id )\n\t\t\t ORDER BY `dispatch` ASC, `calls_assigned` ASC, {$by_distance} `handle` ASC, `unit_name` ASC, `unit_id` ASC \t\t ";
// 5/4/11
// dump($query);
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() > 0) {
$end_date = intval($problemend) > 1 ? $problemend : time() - get_variable('delta_mins') * 60;
$elapsed = my_date_diff($problemstart, $end_date);
// 5/13/10
// ==========================================================================================
$search_arg = array_key_exists('capabilities', $_GET) ? "<TR class='even' STYLE = 'white-space:nowrap;'><TD COLSPAN='99' ALIGN='center'>Unit capabilities match: '" . $_GET['capabilities'] . "'</TD></TR>" : "";
?>
side_bar_html += "<TR class='even'> <TD CLASS='<?php
print $severityclass;
?>
' COLSPAN=99 ALIGN='center'><B>Routes to Incident: <I><?php
print shorten($row_ticket['scope'], 20) . " (" . $elapsed;
?>
)</I></B></TD></TR>\n";
side_bar_html += "<?php
print $search_arg;
?>
";
side_bar_html += "<TR class='odd'> <TD COLSPAN=99 ALIGN='center'>Click line, icon or map for route</TD></TR>\n";
side_bar_html += "<TR class='even' STYLE = 'white-space:nowrap;'><TD COLSPAN=3></TD><TD ALIGN='left'>Unit</TD><TD ALIGN='right'>SLD (<?php
print $capt;
?>
)</TD><TD ALIGN='center'>Call</TD><TD ALIGN='left'>Status</TD><TD>M</TD><TD ALIGN='left'>As of</TD></TR>\n";
<?php
// major while ... for RESPONDER data starts here
$i = $k = 1;
// sidebar/icon index
while ($unit_row = stripslashes_deep(mysql_fetch_assoc($result))) {
// 7/13/09
$has_coords = my_is_float($unit_row['lat']) && my_is_float($unit_row['lng']);
// 2/25/09, 7/7/09
$has_rem_source = intval($unit_row['aprs']) == 1 || intval($unit_row['instam']) == 1 || intval($unit_row['locatea']) == 1 || intval($unit_row['gtrack']) == 1 || intval($unit_row['glat']) == 1;
// 11/15/09
if (is_email($unit_row['contact_via'])) {
print "\t\t\t email= true;\n";
}
?>
nr_units++;
var i = <?php
print $i;
?>
; // top of loop
unit_names[i] = "<?php
print addslashes($unit_row['unit_name']);
?>
"; // unit name 8/25/08, 4/27/09
unit_preselected = "<?php
print $unit_id;
?>
";
if (unit_preselected != "") {
unit_sets[i] = true; // pre-set checkbox settings
show_butts(to_visible); // sets dispatch button visible if there is a pre-selected unit - for dispatch from unit functionality. 5/4/11
} else {
unit_sets[i] = false;
}
unit_ids[i] = <?php
print $unit_row['unit_id'];
?>
;
direcs[i] = <?php
print intval($unit_row['direcs']) == 1 ? "true" : "false";
?>
; // do directions - 7/13/09
<?php
if ($has_coords) {
$tab_1 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "px'>";
$tab_1 .= "<TR CLASS='odd'><TD COLSPAN=2 ALIGN='center'>" . shorten($unit_row['unit_name'], 48) . "</TD></TR>";
$tab_1 .= "<TR CLASS='even'><TD>Description:</TD><TD>" . shorten(str_replace($eols, " ", $unit_row['description']), 32) . "</TD></TR>";
$tab_1 .= "<TR CLASS='odd'><TD>Status:</TD><TD>" . $unit_row['unitstatus'] . " </TD></TR>";
$tab_1 .= "<TR CLASS='even'><TD>Contact:</TD><TD>" . $unit_row['contact_name'] . " Via: " . $unit_row['contact_via'] . "</TD></TR>";
$tab_1 .= "<TR CLASS='odd'><TD>As of:</TD><TD>" . format_date($unit_row['updated']) . "</TD></TR>";
$tab_1 .= "</TABLE>";
}
?>
new_element = document.createElement("input"); // please don't ask!
new_element.setAttribute("type", "checkbox");
new_element.setAttribute("name", "unit_<?php
print $unit_row['unit_id'];
?>
");
new_element.setAttribute("id", "element_id");
new_element.setAttribute("style", "visibility:hidden");
document.forms['routes_Form'].appendChild(new_element);
var multi = <?php
print intval($unit_row['multi']) == 1 ? "true;\n" : "false;\n";
?>
// 5/22/09
<?php
$dispatched_to = array_key_exists($unit_row['unit_id'], $dispatches_disp) ? $dispatches_disp[$unit_row['unit_id']] : "";
if ($has_coords) {
if ($unit_row['lat'] == 0.999999 && $unit_row['lng'] == 0.999999) {
// check units created in no-maps mode 8/4/10
?>
lats[i] = <?php
print get_variable('def_lat');
?>
; // 774-1 now compute distance - in km
lngs[i] = <?php
print get_variable('def_lng');
?>
;
<?php
} else {
?>
lats[i] = <?php
print $unit_row['lat'];
?>
; // 774-2 now compute distance - in km
lngs[i] = <?php
print $unit_row['lng'];
?>
;
<?php
}
// end check units created in no-maps mode 8/4/10
if ($row_ticket['lat'] == 0.999999 && $row_ticket['lng'] == 0.999999) {
// check tickets created in no-maps mode 8/4/10
$ticket_lat = get_variable('def_lat');
$ticket_lng = get_variable('def_lng');
} else {
$ticket_lat = $row_ticket['lat'];
$ticket_lng = $row_ticket['lng'];
}
?>
<?php
}
if ($has_coords && $has_rem_source && !empty($unit_row['callsign'])) {
// 11/15/09
$thespeed = "";
$query = "SELECT *,UNIX_TIMESTAMP(packet_date) AS packet_date, UNIX_TIMESTAMP(updated) AS updated FROM {$GLOBALS['mysql_prefix']}tracks\n\t\t\t\t\t\t\tWHERE `source`= '{$unit_row['callsign']}' ORDER BY `packet_date` DESC LIMIT 1";
$result_tr = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() > 0) {
// got a track?
$track_row = stripslashes_deep(mysql_fetch_array($result_tr));
// most recent track report
$tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "px'>";
$tab_2 .= "<TR><TH CLASS='even' COLSPAN=2>" . $track_row['source'] . "</TH></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>Course: </TD><TD>" . $track_row['course'] . ", Speed: " . $track_row['speed'] . ", Alt: " . $track_row['altitude'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='even'><TD>Closest city: </TD><TD>" . $track_row['closest_city'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>Status: </TD><TD>" . $track_row['status'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='even'><TD>As of: </TD><TD>" . format_date($track_row['packet_date']) . "</TD></TR>";
$tab_2 .= "</TABLE>";
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($unit_row['unit_name'], 8));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("<?php
print $track_row['source'];
?>
", "<?php
print $tab_2;
?>
"),
new GInfoWindowTab("Zoom", "<DIV ID='detailmap' CLASS='detailmap'></DIV>")
];
<?php
$thespeed = $track_row['speed'] == 0 ? "<FONT COLOR='red'><B>•</B></FONT>" : "<FONT COLOR='green'><B>•</B></FONT>";
if ($track_row['speed'] >= 50) {
$thespeed = "<FONT COLOR='WHITE'><B>•</B></FONT>";
}
?>
var point = new GLatLng(<?php
print $track_row['latitude'];
?>
, <?php
print $track_row['longitude'];
?>
); // 783 - mobile position
bounds.extend(point); // point into BB
<?php
} else {
// no track data
$k--;
// not a clickable unit for dispatch
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($unit_row['unit_name'], 12));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("Zoom", "<DIV ID='detailmap' CLASS='detailmap'></DIV>")
];
<?php
}
// end no track data
// 8/7/09
} else {
// no rem_source
if ($has_coords) {
// 2/25/09
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($unit_row['unit_name'], 12));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("Zoom", "<DIV ID='detailmap' CLASS='detailmap'></DIV>")
];
<?php
if ($unit_row['lat'] == 0.999999 && $unit_row['lng'] == 0.999999) {
// check units created in no-maps mode 8/4/10
?>
lats[i] = <?php
print get_variable('def_lat');
?>
; // 819-1 now compute distance - in km
lngs[i] = <?php
print get_variable('def_lng');
?>
;
<?php
} else {
?>
lats[i] = <?php
print $unit_row['lat'];
?>
; // 819-2 now compute distance - in km
lngs[i] = <?php
print $unit_row['lng'];
?>
;
<?php
}
// end check units created in no-maps mode 8/4/10
if ($row_ticket['lat'] == 0.999999 && $row_ticket['lng'] == 0.999999) {
// check tickets created in no-maps mode 8/4/10
$ticket_lat = get_variable('def_lat');
$ticket_lng = get_variable('def_lng');
} else {
$ticket_lat = $row_ticket['lat'];
$ticket_lng = $row_ticket['lng'];
}
}
// end if ($has_coords)
$thespeed = "";
}
// END IF/ELSE (rem_source)
$the_disp_str = "";
if ($unit_row['dispatch'] == 2) {
print "\tsidebar_line = '<TD ALIGN=center><INPUT TYPE=checkbox disabled STYLE = \"visibility: hidden;\"></TD>'";
} else {
switch ($unit_row['calls_assigned']) {
// 8/29/10
case 0:
break;
case 1:
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` \n\t\t\t\t\t\t\t\t\tWHERE (`responder_id` = {$unit_row['unit_id']}\n\t\t\t\t\t\t\t\t\tAND `clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00' ) \n\t\t\t\t\t\t\t\t\tlimit 1";
$result_as = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_as = stripslashes_deep(mysql_fetch_assoc($result_as));
$the_disp_str = "<SPAN CLASS='disp_stat'> " . get_disp_status($row_as) . " </SPAN> ";
break;
default:
// display count
$the_disp_str = "<SPAN CLASS='disp_stat'> {$unit_row['calls_assigned']} </SPAN> ";
break;
}
// end switch ()
?>
sidebar_line = "<TD ALIGN='center'><INPUT TYPE='checkbox' <?php
print get_cd_str($unit_row);
?>
NAME = 'unit_" + <?php
print $unit_row['unit_id'];
?>
+ "' onClick='show_butts(to_visible); unit_sets[<?php
print $i;
?>
]=this.checked;' /></TD>";
<?php
}
?>
sidebar_line += "<TD TITLE = \"<?php
print addslashes($unit_row['unit_name']);
?>
\">";
<?php
$the_bg_color = $GLOBALS['UNIT_TYPES_BG'][$unit_row['icon']];
// 2/1/10
$the_text_color = $GLOBALS['UNIT_TYPES_TEXT'][$unit_row['icon']];
$strike = $unit_row['dispatch'] == 0 ? "" : "color:red;text-decoration:line-through;";
$the_style = "<SPAN STYLE='{$strike}background-color:{$the_bg_color}; opacity: .7; color:{$the_text_color};'>";
$str_dist = $have_position ? number_format(round($unit_row['distance'], 1), 1) : "";
// 3/5/11
// dump(__LINE__);
?>
sidebar_line += "<NOBR><?php
print $the_style . shorten($unit_row['unit_name'], 20);
?>
</SPAN></NOBR></TD>";
sidebar_line += "<TD ALIGN='right'><?php
print $str_dist;
?>
</TD>"; // 8/25/08, 4/27/09
sidebar_line += "<?php
print get_assigned_td($unit_row['unit_id']);
?>
"; // 3/15/11
<?php
$the_style = "<SPAN STYLE='{$strike}background-color:{$unit_row['bg_color']}; color:{$unit_row['text_color']};'>";
?>
sidebar_line += "<TD TITLE = \"<?php
print $unit_row['unitstatus'];
?>
\" CLASS='td_data'><?php
print $the_style . shorten($unit_row['unitstatus'], 12);
?>
</SPAN></TD>";
sidebar_line += "<TD CLASS='td_data'><?php
print $thespeed;
?>
</TD>";
sidebar_line += "<TD CLASS='td_data'><?php
print substr(format_sb_date($unit_row['updated']), 4);
?>
</TD>";
<?php
if ($has_coords) {
// 2/25/09
if ($unit_row['lat'] == 0.999999 && $unit_row['lng'] == 0.999999) {
// check for facilities entered in no maps mode 8/4/10
?>
var point = new GLatLng(<?php
print get_variable('def_lat');
?>
, <?php
print get_variable('def_lng');
?>
); // 840 for each responder 832
var unit_id = <?php
print $unit_row['unit_id'];
?>
;
bounds.extend(point); // point into BB
var marker = createdummyMarker(point, sidebar_line, myinfoTabs,<?php
print $unit_row['type'];
?>
, i, unit_id); // (point,sidebar,tabs, color, id)
if (!(isNull(marker))) {
map.addOverlay(marker);
}
<?php
} else {
?>
var point = new GLatLng(<?php
print $unit_row['lat'];
?>
, <?php
print $unit_row['lng'];
?>
); // 840 for each responder 832
var unit_id = <?php
print $unit_row['unit_id'];
?>
;
bounds.extend(point); // point into BB
var marker = createMarker(point, sidebar_line, myinfoTabs,<?php
print $unit_row['type'];
?>
, i, unit_id); // (point,sidebar,tabs, color, id)
if (!(isNull(marker))) {
map.addOverlay(marker);
}
<?php
}
// end check for facilities entered in no maps mode 8/4/10
} else {
print "\n\t\t\t\tdo_sidebar(sidebar_line, color, i);\n";
}
// end if/else ($has_coords)
$i++;
$k++;
}
// end major while ($unit_row = ...) for each responder
print "\t\t var start = 1;\n";
// already sorted - 3/24/10
} else {
print "\t\t var start = 0;\n";
// already sorted - 3/24/10
}
// responders complete
if ($row_ticket['lat'] == 0.999999 && $row_ticket['lng'] == 0.999999) {
// check for facilities entered in no maps mode 8/4/10
?>
var point = new GLatLng(<?php
print get_variable('def_lat');
?>
, <?php
print get_variable('def_lng');
?>
); // incident
var baseIcon = new GIcon();
var inc_icon = new GIcon(baseIcon, "./our_icons/question1.png", null); // 10/26/08
var thisMarker = new GMarker(point);
map.addOverlay(thisMarker);
<?php
} else {
?>
var point = new GLatLng(<?php
echo $row_ticket['lat'];
?>
, <?php
echo $row_ticket['lng'];
?>
); // incident
var baseIcon = new GIcon();
var inc_icon = new GIcon(baseIcon, "./markers/sm_black.png", null); // 10/26/08
var thisMarker = new GMarker(point);
map.addOverlay(thisMarker);
<?php
}
?>
if (nr_units==0) {
side_bar_html +="<TR CLASS='odd'><TD ALIGN='center' COLSPAN=99><BR /><BR /><H3>No Units!</H3></TD></TR>";
map.setCenter(new GLatLng(<?php
echo $row_ticket['lat'];
?>
, <?php
echo $row_ticket['lng'];
?>
), <?php
echo get_variable('def_zoom');
?>
);
}
else {
center = bounds.getCenter();
zoom = map.getBoundsZoomLevel(bounds); // -1 for further out
// var radii = new Array (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17) ;
var radii = new Array (100, 100, 100, 100, 50, 50, 50, 50, 40, 20, 10, 5, 5, 5, 5, 5, 5, 5) ; // miles
var the_rad = radii[zoom];
drawCircle(<?php
print $row_position['lat'];
?>
, <?php
print $row_position['lng'];
?>
, the_rad, "#000080", 1, 0.75, "#0000FF", .05);
map.setCenter(center,zoom);
side_bar_html+= "<TR CLASS='" + colors[i%2] +"'><TD COLSPAN=99> </TD></TR>\n";
side_bar_html+= "<TR CLASS='" + colors[(i+1)%2] +"'><TD COLSPAN=99 ALIGN='center'><B>M</B>obility: stopped: <FONT COLOR='red'><B>•</B></FONT> moving: <FONT COLOR='green'><B>•</B></FONT> fast: <FONT COLOR='white'><B>•</B></FONT> silent: <FONT COLOR='black'><B>•</B></FONT></TD></TR>\n";
side_bar_html+= "<TR><TD> </TD></TR>\n";
}
side_bar_html +="</TABLE>\n";
document.getElementById("side_bar").innerHTML = side_bar_html; // put the assembled side_bar_html contents into the side bar div
var thelat = <?php
print $lat;
?>
; var thelng = <?php
print $lng;
?>
;
var norecfac = ""; //10/6/09
if (start>0) {
var current_id= "R"+start; //
document.getElementById(current_id).style.visibility = "visible"; // show link check image at the selected sidebar el ement
$("mail_button").style.display = "none"; //10/6/09
if (lats[start]) {
<?php
if ($rec_fac > 0) {
?>
var thereclat = <?php
print $rf_lat;
?>
; var thereclng = <?php
print $rf_lng;
?>
; //adds in receiving facility
if (direcs[start]) {
setDirections(lats[start] + " " + lngs[start], thelat + " " + thelng, thereclat + " " + thereclng, "en_US", unit_id); // get directions 10/6/09
}
<?php
} else {
?>
if (direcs[start]) {
setDirections(lats[start] + " " + lngs[start], thelat + " " + thelng, norecfac, "en_US", unit_id); // get directions 10/6/09
}
<?php
}
// end if/else ($rec_fac > 0)
?>
} // end if (lats[start])
} // end if (start>0)
<?php
// ======================================
?>
location.href = "#top"; // 11/12/09
} // end if (GBrowserIsCompatible())
else {
alert("Sorry, browser compatibility problem. Contact your tech support group.");
}
</SCRIPT>
<?php
}
function parseXml($filePath, $gpxOffset, $distancetype)
{
$points = null;
$points->dt = array();
$points->lat = array();
$points->lon = array();
$points->ele = array();
$points->dist = array();
$points->speed = array();
$points->hr = array();
$points->atemp = array();
$points->cad = array();
$points->grade = array();
$points->maxTime = 0;
$points->minTime = 0;
$points->maxEle = 0;
$points->minEle = 0;
$points->totalEleUp = 0;
$points->totalEleDown = 0;
$points->avgSpeed = 0;
$points->totalLength = 0;
$gpx = simplexml_load_file($filePath);
if ($gpx === FALSE) {
return;
}
$gpx->registerXPathNamespace('10', 'http://www.topografix.com/GPX/1/0');
$gpx->registerXPathNamespace('11', 'http://www.topografix.com/GPX/1/1');
$gpx->registerXPathNamespace('gpxtpx', 'http://www.garmin.com/xmlschemas/TrackPointExtension/v1');
$nodes = $gpx->xpath('//trk | //10:trk | //11:trk');
//normal gpx
if (count($nodes) > 0) {
foreach ($nodes as $_trk) {
$trk = simplexml_load_string($_trk->asXML());
$trk->registerXPathNamespace('10', 'http://www.topografix.com/GPX/1/0');
$trk->registerXPathNamespace('11', 'http://www.topografix.com/GPX/1/1');
$trk->registerXPathNamespace('gpxtpx', 'http://www.garmin.com/xmlschemas/TrackPointExtension/v1');
$trkpts = $trk->xpath('//trkpt | //10:trkpt | //11:trkpt');
$lastLat = 0;
$lastLon = 0;
$lastEle = 0;
$lastTime = 0;
//$dist = 0;
$lastOffset = 0;
$speedBuffer = array();
foreach ($trkpts as $trkpt) {
$lat = $trkpt['lat'];
$lon = $trkpt['lon'];
$ele = $trkpt->ele;
$time = $trkpt->time;
$speed = (double) $trkpt->speed;
$hr = 0;
$atemp = 0;
$cad = 0;
$grade = 0;
if (isset($trkpt->extensions)) {
$arr = json_decode(json_encode($trkpt->extensions), 1);
if (isset($arr['gpxtpx:TrackPointExtension'])) {
$tpe = $arr['gpxtpx:TrackPointExtension'];
$hr = @$tpe["gpxtpx:hr"];
$atemp = @$tpe["gpxtpx:atemp"];
$cad = @$tpe["gpxtpx:cad"];
} else {
if (isset($arr['TrackPointExtension'])) {
$tpe = $arr['TrackPointExtension'];
$hr = @$tpe["hr"];
$atemp = @$tpe["atemp"];
$cad = @$tpe["cad"];
}
}
}
if ($lastLat == 0 && $lastLon == 0) {
//Base Case
array_push($points->dt, strtotime($time));
array_push($points->lat, (double) $lat);
array_push($points->lon, (double) $lon);
array_push($points->ele, (double) round($ele, 2));
array_push($points->dist, (double) round($dist, 2));
array_push($points->speed, 0);
array_push($points->hr, (double) $hr);
array_push($points->atemp, (double) $atemp);
array_push($points->cad, (double) $cad);
array_push($points->grade, $grade);
$lastLat = $lat;
$lastLon = $lon;
$lastEle = $ele;
$lastTime = $time;
} else {
//Normal Case
$offset = calculateDistance((double) $lat, (double) $lon, (double) $ele, (double) $lastLat, (double) $lastLon, (double) $lastEle, $distancetype);
$dist = $dist + $offset;
$points->totalLength = $dist;
if ($speed == 0) {
$datediff = (double) my_date_diff($lastTime, $time);
if ($datediff > 0) {
$speed = $offset / $datediff;
}
}
if ($ele != 0 && $lastEle != 0) {
$deltaEle = (double) ($ele - $lastEle);
if ((double) $ele > (double) $lastEle) {
$points->totalEleUp += $deltaEle;
} else {
$points->totalEleDown += $deltaEle;
}
$grade = $deltaEle / $offset * 100;
}
array_push($speedBuffer, $speed);
if ((double) $offset + (double) $lastOffset > $gpxOffset) {
//Bigger Offset -> write coordinate
$avgSpeed = 0;
foreach ($speedBuffer as $s) {
$avgSpeed += $s;
}
$avgSpeed = $avgSpeed / count($speedBuffer);
$speedBuffer = array();
$lastOffset = 0;
array_push($points->dt, strtotime($time));
array_push($points->lat, (double) $lat);
array_push($points->lon, (double) $lon);
array_push($points->ele, (double) round($ele, 2));
array_push($points->dist, (double) round($dist, 2));
array_push($points->speed, (double) round($avgSpeed, 1));
array_push($points->hr, $hr);
array_push($points->atemp, $atemp);
array_push($points->cad, $cad);
array_push($points->grade, (double) round($grade, 2));
} else {
//Smoller Offset -> continue..
$lastOffset = (double) $lastOffset + (double) $offset;
}
}
$lastLat = $lat;
$lastLon = $lon;
$lastEle = $ele;
$lastTime = $time;
}
array_push($points->dt, null);
array_push($points->lat, null);
array_push($points->lon, null);
array_push($points->ele, null);
array_push($points->dist, null);
array_push($points->speed, null);
array_push($points->hr, null);
array_push($points->atemp, null);
array_push($points->cad, null);
array_push($points->grade, null);
unset($trkpts);
}
unset($nodes);
try {
array_pop($points->dt, null);
array_pop($points->lat, null);
array_pop($points->lon, null);
array_pop($points->ele, null);
array_pop($points->dist, null);
array_pop($points->speed, null);
array_pop($points->hr, null);
array_pop($points->atemp, null);
array_pop($points->cad, null);
array_pop($points->grade, null);
$_time = array_filter($points->dt);
$_ele = array_filter($points->ele);
$_dist = array_filter($points->dist);
$_speed = array_filter($points->speed);
$points->maxEle = max($_ele);
$points->minEle = min($_ele);
$points->totalLength = max($_dist);
$points->maxTime = max($_time);
$points->minTime = min($_time);
$points->avgSpeed = array_sum($_speed) / count($_speed);
} catch (Exception $e) {
}
} else {
// gpx garmin case
$gpx->registerXPathNamespace('gpxx', 'http://www.garmin.com/xmlschemas/GpxExtensions/v3');
$nodes = $gpx->xpath('//gpxx:rpt');
if (count($nodes) > 0) {
$lastLat = 0;
$lastLon = 0;
$lastEle = 0;
$dist = 0;
$lastOffset = 0;
// Garmin case
foreach ($nodes as $rpt) {
$lat = $rpt['lat'];
$lon = $rpt['lon'];
if ($lastLat == 0 && $lastLon == 0) {
//Base Case
array_push($points->lat, (double) $lat);
array_push($points->lon, (double) $lon);
array_push($points->ele, 0);
array_push($points->dist, 0);
array_push($points->speed, 0);
array_push($points->hr, 0);
array_push($points->atemp, 0);
array_push($points->cad, 0);
array_push($points->grade, 0);
$lastLat = $lat;
$lastLon = $lon;
} else {
//Normal Case
$offset = calculateDistance($lat, $lon, 0, $lastLat, $lastLon, 0, $distancetype);
$dist = $dist + $offset;
if ((double) $offset + (double) $lastOffset > $gpxOffset) {
//Bigger Offset -> write coordinate
$lastOffset = 0;
array_push($points->lat, (double) $lat);
array_push($points->lon, (double) $lon);
array_push($points->ele, 0);
array_push($points->dist, 0);
array_push($points->speed, 0);
array_push($points->hr, 0);
array_push($points->atemp, 0);
array_push($points->cad, 0);
array_push($points->grade, 0);
} else {
//Smoller Offset -> continue..
$lastOffset = (double) $lastOffset + (double) $offset;
}
}
$lastLat = $lat;
$lastLon = $lon;
}
unset($nodes);
} else {
//gpx strange case
$nodes = $gpx->xpath('//rtept | //10:rtept | //11:rtept');
if (count($nodes) > 0) {
$lastLat = 0;
$lastLon = 0;
$lastEle = 0;
$dist = 0;
$lastOffset = 0;
// Garmin case
foreach ($nodes as $rtept) {
$lat = $rtept['lat'];
$lon = $rtept['lon'];
if ($lastLat == 0 && $lastLon == 0) {
//Base Case
array_push($points->lat, (double) $lat);
array_push($points->lon, (double) $lon);
array_push($points->ele, 0);
array_push($points->dist, 0);
array_push($points->speed, 0);
array_push($points->hr, 0);
array_push($points->atemp, 0);
array_push($points->cad, 0);
array_push($points->grade, 0);
$lastLat = $lat;
$lastLon = $lon;
} else {
//Normal Case
$offset = calculateDistance($lat, $lon, 0, $lastLat, $lastLon, 0, $distancetype);
$dist = $dist + $offset;
if ((double) $offset + (double) $lastOffset > $gpxOffset) {
//Bigger Offset -> write coordinate
$lastOffset = 0;
array_push($points->lat, (double) $lat);
array_push($points->lon, (double) $lon);
array_push($points->ele, 0);
array_push($points->dist, 0);
array_push($points->speed, 0);
array_push($points->hr, 0);
array_push($points->atemp, 0);
array_push($points->cad, 0);
array_push($points->grade, 0);
} else {
//Smoller Offset -> continue..
$lastOffset = (double) $lastOffset + (double) $offset;
}
}
$lastLat = $lat;
$lastLon = $lon;
}
unset($nodes);
}
}
}
unset($gpx);
return $points;
}
}
?>
</SELECT>
</TD></TR>
<?php
}
// end if (mysql_num_rows()>0)
print "<TR CLASS='even'>\n\t\t\t\t<TD CLASS='td_label' COLSPAN=2 onmouseout='UnTip()' onmouseover=\"Tip('{$titles['_911']}');\">" . get_text("911 Contacted") . ": </TD>\n\t\t\t\t<TD><INPUT SIZE='56' TYPE='text' NAME='frm_nine_one_one' VALUE='{$row['nine_one_one']}' MAXLENGTH='96' {$dis}/></TD></TR>";
print "<TR CLASS='odd'>\n\t\t\t\t<TD CLASS='td_label' COLSPAN=2 onmouseout='UnTip()' onmouseover=\"Tip('{$titles['_caller']}');\">" . get_text("Reported by") . ":</TD>\n\t\t\t\t<TD><INPUT SIZE='48' TYPE='text' NAME='frm_contact' VALUE=\"{$row['contact']}\" MAXLENGTH='48' {$dis}/></TD></TR>\n";
print "<TR CLASS='even'>\n\t\t\t\t<TD CLASS='td_label' COLSPAN=2 onmouseout='UnTip()' onmouseover=\"Tip('{$titles['_name']}');\">" . get_text("Incident name") . ":</TD>\n\t\t\t\t<TD><INPUT TYPE='text' NAME='frm_scope' SIZE='48' VALUE='{$row['scope']}' MAXLENGTH='48' {$dis} /></TD></TR>\n";
print "<TR CLASS='odd'><TD COLSPAN='2'> </TD></TR>";
$selO = $row['status'] == $GLOBALS['STATUS_OPEN'] ? "SELECTED" : "";
$selC = $row['status'] == $GLOBALS['STATUS_CLOSED'] ? "SELECTED" : "";
$selP = $row['status'] == $GLOBALS['STATUS_SCHEDULED'] ? "SELECTED" : "";
$end_date = intval($row['problemend']) > 1 ? $row['problemend'] : time() - get_variable('delta_mins') * 60;
$elapsed = my_date_diff($row['problemstart'], $end_date);
// 5/13/10
print "<TR CLASS='even'>\n\t\t\t\t<TD CLASS='td_label' COLSPAN=2 onmouseout='UnTip()' onmouseover=\"Tip('{$titles['_status']}');\">" . get_text("Status") . ":</TD>\n\t\t\t\t<TD><SELECT NAME='frm_status' {$dis}><OPTION VALUE='" . $GLOBALS['STATUS_OPEN'] . "' {$selO}>Open</OPTION><OPTION VALUE='" . $GLOBALS['STATUS_CLOSED'] . "'{$selC}>Closed</OPTION><OPTION VALUE='" . $GLOBALS['STATUS_SCHEDULED'] . "'{$selP}>Scheduled</OPTION></SELECT> {$elapsed} </TD></TR>";
// print "<TR CLASS='odd'><TD CLASS='td_label'>Affected:</TD><TD><INPUT TYPE='text' SIZE='48' NAME='frm_affected' VALUE='" . $row['affected'] . "' MAXLENGTH='48' {$dis}></TD></TR>\n";
// facility handling - 3/25/10
$query_al = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 4 AND `resource_id` = '{$_SESSION['user_id']}';";
// 6/10/11
$result_al = mysql_query($query_al);
// 4/13/11
$al_groups = array();
while ($row_al = stripslashes_deep(mysql_fetch_assoc($result_al))) {
// 6/10/11
$al_groups[] = $row_al['group'];
}
if (isset($_SESSION['viewed_groups'])) {
// 6/10/11
<?php
$the_str = !(intval($asgn_row['u2fenr']) > 0) ? "" : my_date_diff($asgn_row['problemstart'], $asgn_row['u2fenr']);
?>
<TR CLASS = 'even'><TD CLASS="td_label" ALIGN="right">Fac en-route:</TD> <TD><?php
print format_date($asgn_row['u2fenr']) . " " . $the_str;
?>
</TD></TR> <!--10/6/09-->
<?php
$the_str = !(intval($asgn_row['u2farr']) > 0) ? "" : my_date_diff($asgn_row['problemstart'], $asgn_row['u2farr']);
?>
<TR CLASS = 'odd'><TD CLASS="td_label" ALIGN="right">Fac arr:</TD> <TD><?php
print format_date($asgn_row['u2farr']) . " " . $the_str;
?>
</TD></TR> <!--10/6/09-->
<?php
$the_str = !(intval($asgn_row['clear']) > 0) ? "" : my_date_diff($asgn_row['problemstart'], $asgn_row['clear']);
?>
<TR CLASS = 'even'><TD CLASS="td_label" ALIGN="right">Clear:</TD> <TD><?php
print format_date($asgn_row['clear']) . " " . $the_str;
?>
</TD></TR>
<TR CLASS = 'even'><TD CLASS="td_label" ALIGN="right">Mileage:</TD> <TD><?php
print "start »{$asgn_row['start_miles']} on-scene » {$asgn_row['on_scene_miles']} end » {$asgn_row['end_miles']}";
?>
</TD></TR>
<TR CLASS="odd">
<TD CLASS="td_label" ALIGN="right">Comments:</TD>
<TD ALIGN='left'><?php
print $asgn_row['assign_comments'];
?>
echo get_beb_by_bid($row['bidinvitation_id'], 'title');
?>
</td>
<td><?php
echo custom_date_format('d.F.Y', $row['dateofconfirmationoffunds']);
?>
</td>
<td>
<?php
echo custom_date_format('d.F.Y', $row['date_signed']);
?>
</td>
<td><?php
echo my_date_diff($row['dateofconfirmationoffunds'], $row['date_signed']);
?>
</td>
<td style="text-align: right;"><?php
echo number_format($row['estimated_amount']);
?>
</td>
<td style="text-align: right;"><?php
echo number_format($row['amount'] * $row['xrate']);
?>
</td>
</tr>
<?php
}
echo "<TABLE ALIGN = 'center'><TR><TD>";
/* Creates statistics header and details of responding and en-route units 7/29/09 */
$result_dispatched = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` \n\tWHERE ticket_id='{$id}'\n\tAND `dispatched` IS NOT NULL \n\tAND `responding` IS NULL \n\tAND `on_scene` IS NULL \n\tAND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00'))");
// 6/25/10
$num_rows_dispatched = mysql_num_rows($result_dispatched);
$result_responding = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` \n\tWHERE ticket_id='{$id}'\n\tAND `responding` IS NOT NULL \n\tAND `on_scene` IS NULL \n\tAND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00'))");
// 6/25/10
$num_rows_responding = mysql_num_rows($result_responding);
$result_on_scene = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` \n\tWHERE ticket_id='{$id}' \n\tAND `on_scene` IS NOT NULL \n\tAND (`clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00')\t\n\t");
// 6/25/10
$num_rows_on_scene = mysql_num_rows($result_on_scene);
$query = "SELECT *,UNIX_TIMESTAMP(as_of) AS as_of, UNIX_TIMESTAMP(problemstart) AS problemstart, \n\t`{$GLOBALS['mysql_prefix']}assigns`.`id` AS `assign_id` ,\n\t`{$GLOBALS['mysql_prefix']}assigns`.`comments` AS `assign_comments`,\n\t`r`.`id` AS `unit_id`,\n\t`r`.`name` AS `unit_name` ,\n\t`r`.`type` AS `unit_type` ,\n\t`{$GLOBALS['mysql_prefix']}assigns`.`as_of` AS `assign_as_of`\n\tFROM `{$GLOBALS['mysql_prefix']}assigns` \n\tLEFT JOIN `{$GLOBALS['mysql_prefix']}ticket`\t `t` ON (`{$GLOBALS['mysql_prefix']}assigns`.`ticket_id` = `t`.`id`)\n\tLEFT JOIN `{$GLOBALS['mysql_prefix']}responder`\t `r` ON (`{$GLOBALS['mysql_prefix']}assigns`.`responder_id` = `r`.`id`)\n\t\tWHERE (`clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00')\n\t\tAND ticket_id='{$id}' ";
$result_cleared = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$num_rows_cleared = mysql_affected_rows();
$ticket_end = $ticket_end > 1 ? $ticket_end : time() - get_variable('delta_mins') * 60;
$elapsed = my_date_diff($ticket_start, $ticket_end);
// 5/13/10
echo "<BR /><B>Ticket: {$title}<BR />Opened: {$ticket_start_str}, Status: {$ticket_status}</B><BR />";
$stats = "<B>Severity: {$ticket_severity}, <SPAN STYLE='background-color:white; color:black;'> age: {$elapsed} </SPAN>";
echo $stats;
echo "<BR>Units dispatched: ({$num_rows_dispatched}) ";
while ($row_base = mysql_fetch_array($result_dispatched, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
}
echo "<BR>Units responding: ({$num_rows_responding}) ";
while ($row_base = mysql_fetch_array($result_responding, MYSQL_ASSOC)) {
$result = mysql_query("SELECT * FROM `{$GLOBALS['mysql_prefix']}responder` WHERE id='{$row_base['responder_id']}'");
$row = mysql_fetch_assoc($result);
echo "{$row['name']}: {$row['handle']} ";
$query = "SELECT `miscellaneous` FROM `{$GLOBALS['mysql_prefix']}constituents` WHERE `phone`= '{$row['phone']}' LIMIT 1";
$result_cons = mysql_query($query) or do_error("", 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() > 0) {
$row_cons = stripslashes_deep(mysql_fetch_array($result_cons));
print "<TR CLASS='even'><TD CLASS='td_label'>Add'l:</TD><TD CLASS='td_label'>{$row_cons['miscellaneous']}</TD></TR>\n";
// 3/13/10
}
unset($result_cons);
}
print "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><HR SIZE=1 COLOR=BLUE WIDTH='67%' /></TD></TR>\n";
$selO = $row['status'] == $GLOBALS['STATUS_OPEN'] ? "SELECTED" : "";
$selC = $row['status'] == $GLOBALS['STATUS_CLOSED'] ? "SELECTED" : "";
$selP = $row['status'] == $GLOBALS['STATUS_SCHEDULED'] ? "SELECTED" : "";
$end_date = !empty($row['problemend']) ? $row['problemend'] : time() - get_variable('delta_mins') * 60;
// 1/7/10
$elapsed = my_date_diff($end_date, $row['problemstart']);
print "<TR CLASS='odd'><TD CLASS='td_label'><A HREF=\"#\" TITLE=\"Incident Status - Open or Closed or set to Scheduled for future booked calls\">" . get_text("Status") . "</A>:</TD><TD>\n\t\t\t\t<SELECT NAME='frm_status'><OPTION VALUE='{$GLOBALS['STATUS_OPEN']}' {$selO}>Open</OPTION><OPTION VALUE='" . $GLOBALS['STATUS_CLOSED'] . "'{$selC}>Closed</OPTION><OPTION VALUE='" . $GLOBALS['STATUS_SCHEDULED'] . "'{$selP}>Scheduled</OPTION></SELECT> {$elapsed} </TD></TR>";
// print "<TR CLASS='even'><TD CLASS='td_label'>Affected:</TD><TD><INPUT TYPE='text' SIZE='48' NAME='frm_affected' VALUE='" . $row['affected'] . "' MAXLENGTH='48'></TD></TR>\n";
// facility handling - 3/25/10
if (!($row['facility'] == NULL)) {
// 9/22/09
print "<TR CLASS='even'><TD CLASS='td_label'><A HREF=\"#\" TITLE=\"Use the first dropdown menu to select the Facility where the incident is located at, use the second dropdown menu to select the facility where persons from the incident will be received\">Facility</A>: </TD>";
// 2/21/09
$query_fc = "SELECT * FROM `{$GLOBALS['mysql_prefix']}facilities` ORDER BY `name` ASC";
$result_fc = mysql_query($query_fc) or do_error($query_fc, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
print "<TD><SELECT NAME='frm_facility_id' onChange='document.edit.frm_fac_chng.value = 1; do_fac_to_loc(this.options[selectedIndex].text.trim(), this.options[selectedIndex].value.trim());'>";
print "<OPTION VALUE=0>Not using facility</OPTION>";
print "\n<SCRIPT>fac_lat[" . 0 . "] = " . get_variable('def_lat') . " ;</SCRIPT>\n";
print "\n<SCRIPT>fac_lng[" . 0 . "] = " . get_variable('def_lng') . " ;</SCRIPT>\n";
while ($row_fc = mysql_fetch_array($result_fc, MYSQL_ASSOC)) {
$sel = $row['facility'] == $row_fc['id'] ? " SELECTED " : "";
function full_scr($sort_by_field = '', $sort_value = '')
{
// list tickets ===================================================
global $now_num, $now_day, $now_mon, $now_year, $monday, $disposition;
if ($_SESSION['scr_width'] < 1300 && $_SESSION['scr_width'] > 1050) {
// 4/5/11 sets shorten length depending on client screen width
$shorten_length = 11;
} elseif ($_SESSION['scr_width'] < 1050) {
$shorten_length = 10;
} elseif ($_SESSION['scr_width'] > 1300) {
$shorten_length = 15;
} else {
$shorten_length = 10;
}
extract($_GET);
$func = isset($func) ? $func : 0;
global $istest;
// $dzf = get_variable('def_zoom_fixed'); // 4/2/09
$cwi = get_variable('closed_interval');
// closed window interval in hours
$captions = array("Current situation", "Incidents closed today", "Incidents closed yesterday+", "Incidents closed this week", "Incidents closed last week", "Incidents closed last week+", "Incidents closed this month", "Incidents closed last month", "Incidents closed this year", "Incidents closed last year");
$pri_buttons_width = (int) get_variable('map_width') * 0.2;
$fac_buttons_width = (int) get_variable('map_width') * 0.4;
$units_buttons_width = (int) get_variable('map_width') * 0.4;
$heading = $captions[$func];
$eols = array("\r\n", "\n", "\r");
// all flavors of eol
$group = isset($_SESSION['group']) ? $_SESSION['group'] : 0;
// 4/11/11
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE `status` = {$GLOBALS['STATUS_CLOSED']} ";
// 10/26/09
$result_ct = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$num_closed = mysql_num_rows($result_ct);
unset($result_ct);
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE `status` = {$GLOBALS['STATUS_SCHEDULED']} ";
// 10/26/09
$result_scheduled = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$num_scheduled = mysql_num_rows($result_scheduled);
unset($result_scheduled);
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 4 AND `resource_id` = '{$_SESSION['user_id']}' ORDER BY `id` ASC;";
// 6/10/11
$result = mysql_query($query);
// 6/10/11
$al_groups = array();
$al_names = "";
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// 6/10/11
$al_groups[] = $row['group'];
$query2 = "SELECT * FROM `{$GLOBALS['mysql_prefix']}region` WHERE `id`= '{$row['group']}';";
// 6/10/11
$result2 = mysql_query($query2);
// 6/10/11
while ($row2 = stripslashes_deep(mysql_fetch_assoc($result2))) {
// 6/10/11
$al_names .= $row2['group_name'] . ", ";
}
}
?>
<!-- 3/29/11 DIVS Incident List & Assignments List -->
<DIV ID = 'inc_list' style='width: 46%; position: fixed; top: 5%; left: 3%; z-index:3; display: block; border: 2px outset #CECECE;'>
<DIV class='heading' style='text-align: center; height: 20px; '><?php
print get_text('Incidents');
?>
<DIV style='float: right'>
<SPAN id='collapse_ticks' onClick="hideDiv('inc_list', 'collapse_ticks', 'expand_ticks'); CngMenuClass('incs_but', 'right_menu');" style = "display: 'none';"><IMG SRC = './buttons/close.png' BORDER=0 STYLE = 'vertical-align: middle'></SPAN></DIV></DIV>
<DIV ID = 'incidents' style='background: #CECECE; width: 100%; max-height: 200px; overflow-y: scroll; overflow-x: hidden; position: relative; z-index:2; display: block;'></DIV> <!-- 3/24/11 List of current open incidents -->
</DIV>
<DIV ID = 'assigns_list' style='width: 46%; position: fixed; top: 5%; right: 3%; z-index:3; display: block; border: 2px outset #CECECE;'>
<DIV class='heading' style='text-align: center; height: 20px;'><?php
print get_text('Assignments');
?>
<DIV style='float: right'>
<SPAN id='collapse_ass' onClick="hideDiv('assigns_list', 'collapse_ass', 'expand_ass'); CngMenuClass('assign_but', 'right_menu');" style = "display: 'none';"><IMG SRC = './buttons/close.png' BORDER=0 STYLE = 'vertical-align: middle'></SPAN></DIV></DIV>
<DIV ID = 'assignments' style='background: #CECECE; width: 100%; max-height: 200px; overflow-y: scroll; overflow-x: hidden; position: relative; z-index:2; display: block;'></DIV> <!-- 3/24/11 List of current assignments -->
</DIV>
<!-- 3/29/11 DIVS for show hide side menu for lists and marker controls -->
<DIV ID='side_menu_cont' class='right_menu_container' style='position: fixed; top: 10%; right: 0px;'>
<BR />
<script>
var text_size = window.screen.width > 1000 ? "16" : "12";
var div_button1 = "<DIV ID='marker_but' CLASS='right_menu' style='font-size:" + text_size + "px' onMouseover=\"showDiv('buttons_sh', 'collapse_buttons', 'expand_buttons'); CngMenuClass('marker_but', 'right_menu_lit');\">M<BR />A<BR />R<BR />K<BR />E<BR />R<BR />S</DIV><BR />";
var div_button2 = "<DIV ID='incs_but' CLASS='right_menu' style='font-size:" + text_size + "px' onMouseover=\"showDiv('inc_list', 'collapse_ticks', 'expand_ticks'); CngMenuClass('incs_but', 'right_menu_lit');\">I<BR />N<BR />C<BR />I<BR />D<BR />E<BR />N<BR />T<BR />S</DIV><BR />";
var div_button3 = "<DIV ID='assign_but' CLASS='right_menu' style='font-size:" + text_size + "px' onMouseover=\"showDiv('assigns_list', 'collapse_ass', 'expand_ass'); CngMenuClass('assign_but', 'right_menu_lit');\">A<BR />S<BR />S<BR />I<BR />G<BR />N<BR />M<BR />E<BR />N<BR />T<BR />S</DIV><BR />";
document.write (div_button1);
document.write (div_button2);
document.write (div_button3);
</script>
</DIV>
<!-- 3/29/11 Marker controls -->
<DIV ID = 'buttons_sh' class='fs_buttons' style='display: none; background: #CECECE; width: 300px; overflow-y: hidden; overflow-x: hidden; position: fixed; right: 10%; top: 20%; z-index:4; border: 3px outset #505050;'>
<DIV class='heading' style='text-align: center; height: 20px;' style='z-index:4; padding: 3px;'>Show / Hide Markers<DIV style='float: right'><SPAN id='collapse_buttons' STYLE = 'text-align: right' onClick="hideDiv('buttons_sh', 'collapse_buttons', 'expand_buttons'); CngMenuClass('marker_but', 'right_menu');"><IMG SRC = './buttons/close.png' BORDER=0 STYLE = 'vertical-align: middle'></SPAN></DIV></DIV>
<DIV ID = 'incidents_sh' style='display: block; position: relative; padding: 10px; overflow-y: scroll; overflow-x: scroll;'>
<DIV class='heading' style='text-align: center; height: 20px; ' style='z-index:4; padding: 3px;'><?php
print get_text('Incidents');
?>
</DIV>
<DIV class='pri_button_fs' onClick="set_pri_chkbox('normal'); hideGroup(1, 'Incident');"><IMG SRC = './our_icons/sm_blue.png' STYLE = 'vertical-align: middle'BORDER=0> Normal: <input type=checkbox id='normal' onClick="set_pri_chkbox('normal')"/> </DIV>
<DIV class='pri_button_fs' onClick="set_pri_chkbox('medium'); hideGroup(2, 'Incident');"><IMG SRC = './our_icons/sm_green.png' BORDER=0 STYLE = 'vertical-align: middle'> Medium: <input type=checkbox id='medium' onClick="set_pri_chkbox('medium')"/> </DIV>
<DIV class='pri_button_fs' onClick="set_pri_chkbox('high'); hideGroup(3, 'Incident');"><IMG SRC = './our_icons/sm_red.png' BORDER=0 STYLE = 'vertical-align: middle'> High: <input type=checkbox id='high' onClick="set_pri_chkbox('high')"/> </DIV>
<DIV class='pri_button_fs' ID = 'pri_all' class='pri_button' STYLE = 'display: none;' onClick="set_pri_chkbox('all'); hideGroup(4, 'Incident');"><IMG SRC = './our_icons/sm_blue.png' BORDER=0 STYLE = 'vertical-align: middle'><IMG SRC = './our_icons/sm_green.png' BORDER=0 STYLE = 'vertical-align: middle'><IMG SRC = './our_icons/sm_red.png' BORDER=0 STYLE = 'vertical-align: middle'>All <input type=checkbox id='all' STYLE = 'display:none;' onClick="set_pri_chkbox('all')"/> </DIV>
<DIV class='pri_button_fs' ID = 'pri_none' class='pri_button' onClick="set_pri_chkbox('none'); hideGroup(5, 'Incident');"><IMG SRC = './our_icons/sm_white.png' BORDER=0 STYLE = 'vertical-align: middle'> None <input type=checkbox id='none' STYLE = 'display:none;' onClick="set_pri_chkbox('none')"/></DIV></b>
</DIV><BR />
<DIV ID = 'units_sh' style='display: block; position: relative; padding: 10px; overflow-y: scroll; overflow-x: scroll;'>
<DIV class='heading' style='text-align: center; height: 20px;' style='z-index:4; padding: 3px;'><?php
print get_text('Units');
?>
</DIV>
<DIV ID = 'boxes' style='position: relative; padding: 3px;'></DIV> <!-- 2/16/11 Units show and hide -->
</DIV><BR />
<DIV ID = 'facs_sh' style='display: block; position: relative; padding: 10px; overflow-y: scroll; overflow-x: scroll;'>
<DIV class='heading' style='text-align: center; height: 20px;' style='z-index:4; padding: 3px;'><?php
print get_text('Facilities');
?>
</DIV>
<DIV ID = 'fac_boxes' style='position: relative; padding: 3px;'></DIV> <!-- 2/16/11 Facilities show and hide -->
</DIV><BR />
</DIV>
</DIV>
<DIV ID = 'bottom_bar' class='td_fs_buttons' style='display: table-cell; position: fixed; bottom: 0%; left: 0%; width: 100%; z-index: 3; height: 5%; text-align: center; vertical-align: middle; padding-top: 5px; border-top: 4px outset #CECECE;'>
<B><NOBR> <!-- 2/16/11 Change CSS classes -->
<FORM>
<SPAN class='fs_buttons' onClick='maxWindow();'><U>Full screen</U></SPAN>
<SPAN class='fs_buttons' onClick='doGrid()' STYLE = 'margin-left: 60px'><U>Grid</U></SPAN>
<SPAN class='fs_buttons' onClick='doTraffic()' STYLE = 'margin-left: 60px'><U>Traffic</U></SPAN>
<?php
// if(((!empty($num_closed)) && ($num_closed > 0)) || ($num_scheduled > 0)) { // 10/26/09 added button, 10/21/09 added check for closed incidents on the database, 3/29/11 added scheduled runs option
echo "<SPAN class='fs_buttons' STYLE = 'margin-left: 60px'><U>Change display</U> » </SPAN>";
echo "\n\t\t <SELECT NAME = 'frm_interval' onChange = 'document.to_all.func.value=this.value; show_btns_closed();'>\n\t\t\t\t<OPTION VALUE='99' SELECTED>Select</OPTION>\n\t\t\t\t<OPTION VALUE='0'>Current situation</OPTION>\n\t\t\t\t<OPTION VALUE='1'>Incidents closed today</OPTION>\n\t\t\t\t<OPTION VALUE='2'>Incidents closed yesterday+</OPTION>\n\t\t\t\t<OPTION VALUE='3'>Incidents closed this week</OPTION>\n\t\t\t\t<OPTION VALUE='4'>Incidents closed last week</OPTION>\n\t\t\t\t<OPTION VALUE='5'>Incidents closed last week+</OPTION>\n\t\t\t\t<OPTION VALUE='6'>Incidents closed this month</OPTION>\n\t\t\t\t<OPTION VALUE='7'>Incidents closed last month</OPTION>\n\t\t\t\t<OPTION VALUE='8'>Incidents closed this year</OPTION>\n\t\t\t\t<OPTION VALUE='9'>Incidents closed last year</OPTION>\n\t\t\t\t<OPTION VALUE='10'>Scheduled Runs</OPTION>\t\t\t\t\n\t\t\t\t</SELECT>\n";
echo "<SPAN ID = 'btn_go' class='fs_buttons' onClick='document.to_all.submit()' STYLE = 'margin-left: 10px; display:none; color: #006600;'><U>Go</U></SPAN>";
echo "<SPAN ID = 'btn_can' class='fs_buttons' onClick='hide_btns_closed()' STYLE = 'margin-left: 10px; display:none; color: #FF0000;'><U>Cancel</U></SPAN>";
// }
?>
<SPAN class='fs_buttons' onClick = "opener.focus()" STYLE = 'margin-left: 60px'><U>Back</U></SPAN>
<A HREF="mailto:shoreas@Gmail.com?subject=Comment%20on%20Tickets%20Dispatch%20System"><SPAN STYLE = 'margin-left: 20px; font-size:10px; '><U>Contact us</U> <IMG SRC="mail.png" BORDER="0" STYLE="vertical-align: text-bottom; margin-left: 10px;"></SPAN></A>
<SPAN class='fs_buttons' onClick = "window.close();" STYLE = 'margin-left: 60px'><U>Close</U></SPAN>
</NOBR>
</B>
</FORM>
</DIV>
<FORM NAME='view_form' METHOD='get' ACTION='units.php'>
<INPUT TYPE='hidden' NAME='func' VALUE='responder'>
<INPUT TYPE='hidden' NAME='view' VALUE='true'>
<INPUT TYPE='hidden' NAME='id' VALUE=''>
</FORM>
<DIV style='position: fixed; top: 0px; left: 0px, z-index: 1'>
<TABLE BORDER=1 STYLE= "margin-top:0;">
<TR CLASS='header'><TD COLSPAN='99' ALIGN='center'><FONT CLASS='header'><?php
print get_variable('map_caption') . " - " . $heading;
?>
<SPAN ID='sev_counts' STYLE = 'margin-left: 40px'></SPAN></FONT></TD></TR> <!-- 1/17/09 -->
<TR ID='map_row'>
<TD COLSPAN='99' CLASS='td_label' width="100%" height="82%">
<?php
@session_start();
//
$by_severity = array(0, 0, 0);
// counters
?>
<script>
var map_width = window.screen.width -16; // 11/6/10
var map_height = window.screen.height *.82; // browser-dependent
var div_style_str = "<DIV ID='map' STYLE='WIDTH:" + map_width + "px; height:" + map_height + "px';></DIV>"
document.write (div_style_str);
</script>
</TD></TR>
</TABLE></DIV>
<SCRIPT>
function show_btns_closed() {
$('btn_go').style.display = 'inline';
$('btn_can').style.display = 'inline';
}
function hide_btns_closed() {
$('btn_go').style.display = 'none';
$('btn_can').style.display = 'none';
document.dummy.frm_interval.selectedIndex=99;
}
</SCRIPT>
<SCRIPT>
function isNull(val) { // checks var stuff = null;
return val === null;
}
function to_str(instr) { // 0-based conversion - 2/13/09
// alert("143 " + instr);
function ord( string ) {
return (string+'').charCodeAt(0);
}
function chr( ascii ) {
return String.fromCharCode(ascii);
}
function to_char(val) {
return(chr(ord("A")+val));
}
var lop = (instr % 26); // low-order portion, a number
var hop = ((instr - lop)==0)? "" : to_char(((instr - lop)/26)-1) ; // high-order portion, a string
return hop+to_char(lop);
}
function sendRequest(url,callback,postData) { // 2/14/09
var req = createXMLHTTPObject();
if (!req) return;
var method = (postData) ? "POST" : "GET";
req.open(method,url,true);
req.setRequestHeader('User-Agent','XMLHTTP/1.0');
if (postData)
req.setRequestHeader('Content-type','application/x-www-form-urlencoded');
req.onreadystatechange = function () {
if (req.readyState != 4) return;
if (req.status != 200 && req.status != 304) {
<?php
if ($istest) {
print "\t\t\talert('HTTP error ' + req.status + '" . __LINE__ . "');\n";
}
?>
return;
}
callback(req);
}
if (req.readyState == 4) return;
req.send(postData);
}
var XMLHttpFactories = [
function () {return new XMLHttpRequest() },
function () {return new ActiveXObject("Msxml2.XMLHTTP") },
function () {return new ActiveXObject("Msxml3.XMLHTTP") },
function () {return new ActiveXObject("Microsoft.XMLHTTP") }
];
function createXMLHTTPObject() {
var xmlhttp = false;
for (var i=0;i<XMLHttpFactories.length;i++) {
try {
xmlhttp = XMLHttpFactories[i]();
}
catch (e) {
continue;
}
break;
}
return xmlhttp;
}
if (GBrowserIsCompatible()) {
$("map").style.backgroundImage = "url('http://maps.google.com/staticmap?center=<?php
echo get_variable('def_lat');
?>
,<?php
echo get_variable('def_lng');
?>
&zoom=<?php
echo get_variable('def_zoom');
?>
&size=<?php
echo get_variable('map_width');
?>
x<?php
echo get_variable('map_height');
?>
&key=<?php
echo get_variable('gmaps_api_key');
?>
')";
var colors = new Array ('odd', 'even');
function add_hash(in_str) { // prepend # if absent
return (in_str.substr(0,1)=="#")? in_str : "#" + in_str;
}
function drawCircle(lat, lng, radius, strokeColor, strokeWidth, strokeOpacity, fillColor, fillOpacity) { // 8/19/09
// drawCircle(53.479874, -2.246704, 10.0, "#000080", 1, 0.75, "#0000FF", .5);
var d2r = Math.PI/180;
var r2d = 180/Math.PI;
var Clat = radius * 0.014483;
var Clng = Clat/Math.cos(lat * d2r);
var Cpoints = [];
for (var i=0; i < 33; i++) {
var theta = Math.PI * (i/16);
Cy = lat + (Clat * Math.sin(theta));
Cx = lng + (Clng * Math.cos(theta));
var P = new GPoint(Cx,Cy);
Cpoints.push(P);
}
var polygon = new GPolygon(Cpoints, strokeColor, strokeWidth, strokeOpacity, fillColor, fillOpacity);
map.addOverlay(polygon);
}
function drawBanner(point, html, text, font_size, color) { // Create the banner
// alert("<?php
echo __LINE__;
?>
" + color);
var invisibleIcon = new GIcon(G_DEFAULT_ICON, "./markers/markerTransparent.png"); // Custom icon is identical to the default icon, except invisible
map.setCenter(point, 8);
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
var the_color = (typeof color == 'undefined')? "#000000" : color ; // default to black
var style_str = 'background-color:transparent;font-weight:bold;border:0px black solid;white-space:nowrap; font-size:' + font_size + 'px; font-family:arial; opacity: 0.9; color:' + add_hash(the_color) + ';';
var contents = '<div><div style= "' + style_str + '">'+text+'<\/div><\/div>';
var label=new ELabel(point, contents, null, new GSize(-8,4), 75, 1);
map.addOverlay(label);
var marker = new GMarker(point,invisibleIcon); // Create an invisible GMarker
// map.addOverlay(marker);
} // end function draw Banner()
function do_landb() { // JS function - 8/1/11
var points = new Array();
<?php
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}mmarkup` WHERE `line_status` = 0 AND `use_with_bm` = 1";
$result = mysql_query($query) or do_error($query, $query, mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
$empty = FALSE;
extract($row);
$name = $row['line_name'];
switch ($row['line_type']) {
case "p":
// poly
$points = explode(";", $line_data);
echo "\n\tvar points = new Array();\n";
for ($i = 0; $i < count($points); $i++) {
$coords = explode(",", $points[$i]);
?>
var thepoint = new GLatLng(<?php
print $coords[0];
?>
, <?php
print $coords[1];
?>
);
bounds.extend(thepoint);
points.push(thepoint);
<?php
}
// end for ($i = 0 ... )
if (intval($filled) == 1 && count($points) > 2) {
?>
var polyline = new GPolygon(points,add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
,add_hash("<?php
print $fill_color;
?>
"), <?php
print $fill_opacity;
?>
);
<?php
} else {
?>
var polyline = new GPolyline(points, add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
);
<?php
}
?>
map.addOverlay(polyline);
<?php
break;
case "c":
// circle
$temp = explode(";", $line_data);
$radius = $temp[1];
$coords = explode(",", $temp[0]);
$lat = $coords[0];
$lng = $coords[1];
$fill_opacity = intval($filled) == 0 ? 0 : $fill_opacity;
echo "\n drawCircle({$lat}, {$lng}, {$radius}, add_hash('{$line_color}'), {$line_width}, {$line_opacity}, add_hash('{$fill_color}'), {$fill_opacity}, {$name}); // 513\n";
break;
case "t":
// text banner
$temp = explode(";", $line_data);
$banner = $temp[1];
$coords = explode(",", $temp[0]);
echo "\n var point = new GLatLng(parseFloat({$coords[0]}) , parseFloat({$coords[1]}));\n";
$the_banner = htmlentities($banner, ENT_QUOTES);
$the_width = intval(trim($line_width), 10);
// font size
echo "\n drawBanner( point, '{$the_banner}', '{$the_banner}', {$the_width});\n";
break;
}
// end switch
}
// end while ()
unset($query, $result);
?>
} // end function do_landb()
function URLEncode(plaintext ) { // The Javascript escape and unescape functions do
// NOT correspond with what browsers actually do...
var SAFECHARS = "0123456789" + // Numeric
"ABCDEFGHIJKLMNOPQRSTUVWXYZ" + // Alphabetic
"abcdefghijklmnopqrstuvwxyz" + // guess
"-_.!*'()"; // RFC2396 Mark characters
var HEX = "0123456789ABCDEF";
var encoded = "";
for (var i = 0; i < plaintext.length; i++ ) {
var ch = plaintext.charAt(i);
if (ch == " ") {
encoded += "+"; // x-www-urlencoded, rather than %20
} else if (SAFECHARS.indexOf(ch) != -1) {
encoded += ch;
} else {
var charCode = ch.charCodeAt(0);
if (charCode > 255) {
alert( "Unicode Character '"
+ ch
+ "' cannot be encoded using standard URL encoding.\n" +
"(URL encoding only supports 8-bit characters.)\n" +
"A space (+) will be substituted." );
encoded += "+";
} else {
encoded += "%";
encoded += HEX.charAt((charCode >> 4) & 0xF);
encoded += HEX.charAt(charCode & 0xF);
}
}
} // end for(...)
return encoded;
}; // end function
// Tickets show / hide by Priority functions
function set_initial_pri_disp() {
$('normal').checked = true;
$('medium').checked = true;
$('high').checked = true;
$('all').checked = true;
$('none').checked = false;
$('buttons_sh').style.display = 'none';
$('incidents').style.display = '';
$('assignments').style.display = '';
}
function hideGroup(color, category) { // 8/7/09 Revised function to correct incorrect display, revised 12/03/10 completely revised
var priority = color;
var priority_name="";
if(priority == 1) {
priority_name="normal";
}
if(priority == 2) {
priority_name="medium";
}
if(priority == 3) {
priority_name="high";
}
if(priority == 4) {
priority_name="all";
}
if(priority == 5) {
priority_name="none";
}
if(priority == 1) {
for (var i = 0; i < gmarkers.length; i++) {
if (gmarkers[i]) {
if ((gmarkers[i].id == priority) && (gmarkers[i].category == category)) {
gmarkers[i].show();
}
if ((gmarkers[i].id != priority) && (gmarkers[i].category == category)) {
gmarkers[i].hide();
}
} // end if (gmarkers[i])
} // end for ()
$('normal').checked = true;
$('medium').checked = false;
$('high').checked = false;
$('all').checked = false;
$('none').checked = false;
$('pri_all').style.display = '';
$('pri_none').style.display = '';
} // end if priority == 1
if(priority == 2) {
for (var i = 0; i < gmarkers.length; i++) {
if (gmarkers[i]) {
if ((gmarkers[i].id == priority) && (gmarkers[i].category == category)) {
gmarkers[i].show();
}
if ((gmarkers[i].id != priority) && (gmarkers[i].category == category)) {
gmarkers[i].hide();
}
} // end if (gmarkers[i])
} // end for ()
$('normal').checked = false;
$('medium').checked = true;
$('high').checked = false;
$('all').checked = false;
$('none').checked = false;
$('pri_all').style.display = '';
$('pri_none').style.display = '';
} // end if priority == 2
if(priority == 3) {
for (var i = 0; i < gmarkers.length; i++) {
if (gmarkers[i]) {
if ((gmarkers[i].id == priority) && (gmarkers[i].category == category)) {
gmarkers[i].show();
}
if ((gmarkers[i].id != priority) && (gmarkers[i].category == category)) {
gmarkers[i].hide();
}
} // end if (gmarkers[i])
} // end for ()
$('normal').checked = false;
$('medium').checked = false;
$('high').checked = true;
$('all').checked = false;
$('none').checked = false;
$('pri_all').style.display = '';
$('pri_none').style.display = '';
} // end if priority == 3
if(priority == 4) { // show All
for (var i = 0; i < gmarkers.length; i++) {
if (gmarkers[i]) {
if (gmarkers[i].category == category) {
gmarkers[i].show();
}
} // end if (gmarkers[i])
} // end for ()
$('normal').checked = true;
$('medium').checked = true;
$('high').checked = true;
$('all').checked = true;
$('none').checked = false;
$('pri_all').style.display = 'none';
$('pri_none').style.display = '';
} // end if priority == 4
if(priority == 5) { // hide all
for (var i = 0; i < gmarkers.length; i++) {
if (gmarkers[i]) {
if (gmarkers[i].category == category) {
gmarkers[i].hide();
}
} // end if (gmarkers[i])
} // end for ()
$('normal').checked = false;
$('medium').checked = false;
$('high').checked = false;
$('all').checked = false;
$('none').checked = true;
$('pri_all').style.display = '';
$('pri_none').style.display = 'none';
} // end if priority == 5
} // end function hideGroup(color, category)
function set_pri_chkbox(control) {
var pri_control = control;
if($(pri_control).checked == true) {
$(pri_control).checked = false;
} else {
$(pri_control).checked = true;
}
}
// End of Tickets show / hide by Priority functions
// Units show / hide functions
function set_categories() { // 12/03/10 - checks current session values and sets checkboxes and view states for hide and show.
var curr_cats = <?php
echo json_encode(get_category_butts());
?>
;
var cat_sess_stat = <?php
echo json_encode(get_session_status());
?>
;
var hidden = <?php
print find_hidden();
?>
;
var shown = <?php
print find_showing();
?>
;
var number_of_units = <?php
print get_no_units();
?>
;
if(hidden!=0) {
$('ALL').style.display = '';
$('ALL_BUTTON').style.display = '';
$('ALL').checked = false;
} else {
$('ALL').style.display = 'none';
$('ALL_BUTTON').style.display = 'none';
$('ALL').checked = false;
}
if(shown!=0) {
$('NONE').style.display = '';
$('NONE_BUTTON').style.display = '';
$('NONE').checked = false;
} else {
$('NONE').style.display = 'none';
$('NONE_BUTTON').style.display = 'none';
$('NONE').checked = false;
}
if(number_of_units==0) {
$('ALL').style.display = 'none';
$('ALL_BUTTON').style.display = 'none';
$('ALL').checked = false;
$('NONE').style.display = 'none';
$('NONE_BUTTON').style.display = 'none';
$('NONE').checked = false;
}
for (var i = 0; i < curr_cats.length; i++) {
var catname = curr_cats[i];
if(cat_sess_stat[i]=="s") {
for (var j = 0; j < gmarkers.length; j++) {
if ((gmarkers[j]) && (gmarkers[j].category) && (gmarkers[j].category == catname)) {
gmarkers[j].show();
}
}
$(catname).checked = true;
} else {
for (var j = 0; j < gmarkers.length; j++) {
if ((gmarkers[j]) && (gmarkers[j].category) && (gmarkers[j].category == catname)) {
gmarkers[j].hide();
}
}
$(catname).checked = false;
}
}
}
function do_view_cats() { // 12/03/10 Show Hide categories, Showing and setting onClick attribute for Next button for category show / hide.
$('go_can').style.display = 'inline';
$('can_button').style.display = 'inline';
$('go_button').style.display = 'inline';
}
function cancel_buttons() { // 12/03/10 Show Hide categories, Showing and setting onClick attribute for Next button for category show / hide.
$('go_can').style.display = 'none';
$('can_button').style.display = 'none';
$('go_button').style.display = 'none';
$('ALL').checked = false;
$('NONE').checked = false;
}
function set_chkbox(control) {
var units_control = control;
if($(units_control).checked == true) {
$(units_control).checked = false;
} else {
$(units_control).checked = true;
}
do_view_cats();
}
function do_go_button() { // 12/03/10 Show Hide categories
var curr_cats = <?php
echo json_encode(get_category_butts());
?>
;
if ($('ALL').checked == true) {
for (var i = 0; i < curr_cats.length; i++) {
var category = curr_cats[i];
var params = "f_n=show_hide_" +URLEncode(category)+ "&v_n=s&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(category).checked = true;
for (var j = 0; j < gmarkers.length; j++) {
if((gmarkers[j]) && (gmarkers[j].category!="Incident")) {
gmarkers[j].show();
}
}
}
$('ALL').checked = false;
$('ALL').style.display = 'none';
$('ALL_BUTTON').style.display = 'none';
$('NONE').style.display = '';
$('NONE_BUTTON').style.display = '';
$('go_button').style.display = 'none';
$('can_button').style.display = 'none';
} else if ($('NONE').checked == true) {
for (var i = 0; i < curr_cats.length; i++) {
var category = curr_cats[i];
var params = "f_n=show_hide_" +URLEncode(category)+ "&v_n=h&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(category).checked = false;
for (var j = 0; j < gmarkers.length; j++) {
if((gmarkers[j]) && (gmarkers[j].category!="Incident")) {
gmarkers[j].hide();
}
}
}
$('NONE').checked = false;
$('ALL').style.display = '';
$('ALL_BUTTON').style.display = '';
$('NONE').style.display = 'none';
$('NONE_BUTTON').style.display = 'none';
$('go_button').style.display = 'none';
$('can_button').style.display = 'none';
} else {
var x = 0;
var y = 0;
for (var i = 0; i < curr_cats.length; i++) {
var category = curr_cats[i];
if (category!="Incident") {
if ($(category).checked == true) {
x++;
var params = "f_n=show_hide_" +URLEncode(category)+ "&v_n=s&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(category).checked = true;
for (var j = 0; j < gmarkers.length; j++) {
if ((gmarkers[j]) && (gmarkers[j].category) && (gmarkers[j].category == category)) {
// alert("Showing gmarker " + j + " in Category " + category);
gmarkers[j].show();
}
}
}
}
}
for (var i = 0; i < curr_cats.length; i++) {
var category = curr_cats[i];
if (category!="Incident") {
if ($(category).checked == false) {
y++;
var params = "f_n=show_hide_" +URLEncode(category)+ "&v_n=h&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(category).checked = false;
var y=0;
for (var j = 0; j < gmarkers.length; j++) {
if ((gmarkers[j]) && (gmarkers[j].category) && (gmarkers[j].category == category)) {
// alert("Hiding gmarker " + j + " in Category " + category);
gmarkers[j].hide();
}
}
}
}
}
}
$('go_button').style.display = 'none';
$('can_button').style.display = 'none';
if((x > 0) && (x < curr_cats.length)) {
$('ALL').style.display = '';
$('ALL_BUTTON').style.display = '';
$('NONE').style.display = '';
$('NONE_BUTTON').style.display = '';
}
if(x == 0) {
$('ALL').style.display = '';
$('ALL_BUTTON').style.display = '';
$('NONE').style.display = 'none';
$('NONE_BUTTON').style.display = 'none';
}
if(x == curr_cats.length) {
$('ALL').style.display = 'none';
$('ALL_BUTTON').style.display = 'none';
$('NONE').style.display = '';
$('NONE_BUTTON').style.display = '';
}
} // end function do_go_button()
function gb_handleResult(req) { // 12/03/10 The persist callback function
}
// Facilities show / hide functions
function set_fac_categories() { // 12/03/10 - checks current session values and sets checkboxes and view states for hide and show.
var fac_curr_cats = <?php
echo json_encode(get_fac_category_butts());
?>
;
var fac_cat_sess_stat = <?php
echo json_encode(get_fac_session_status());
?>
;
var fac_hidden = <?php
print find_fac_hidden();
?>
;
var fac_shown = <?php
print find_fac_showing();
?>
;
if(fac_hidden!=0) {
$('fac_ALL').style.display = '';
$('fac_ALL_BUTTON').style.display = '';
$('fac_ALL').checked = false;
} else {
$('fac_ALL').style.display = 'none';
$('fac_ALL_BUTTON').style.display = 'none';
$('fac_ALL').checked = false;
}
if(fac_shown!=0) {
$('fac_NONE').style.display = '';
$('fac_NONE_BUTTON').style.display = '';
$('fac_NONE').checked = false;
} else {
$('fac_NONE').style.display = 'none';
$('fac_NONE_BUTTON').style.display = 'none';
$('fac_NONE').checked = false;
}
for (var i = 0; i < fac_curr_cats.length; i++) {
var fac_catname = fac_curr_cats[i];
if(fac_cat_sess_stat[i]=="s") {
for (var j = 0; j < fmarkers.length; j++) {
if (fmarkers[j].category == fac_catname) {
fmarkers[j].show();
}
}
$(fac_catname).checked = true;
} else {
for (var j = 0; j < fmarkers.length; j++) {
if (fmarkers[j].category == fac_catname) {
fmarkers[j].hide();
}
}
$(fac_catname).checked = false;
}
}
}
function do_view_fac_cats() { // 12/03/10 Show Hide categories, Showing and setting onClick attribute for Next button for category show / hide.
$('fac_go_can').style.display = 'inline';
$('fac_can_button').style.display = 'inline';
$('fac_go_button').style.display = 'inline';
}
function fac_cancel_buttons() { // 12/03/10 Show Hide categories, Showing and setting onClick attribute for Next button for category show / hide.
$('fac_go_can').style.display = 'none';
$('fac_can_button').style.display = 'none';
$('fac_go_button').style.display = 'none';
$('fac_ALL').checked = false;
$('fac_NONE').checked = false;
}
function set_fac_chkbox(control) {
var fac_control = control;
if($(fac_control).checked == true) {
$(fac_control).checked = false;
} else {
$(fac_control).checked = true;
}
do_view_fac_cats();
}
function do_go_facilities_button() { // 12/03/10 Show Hide categories
var fac_curr_cats = <?php
echo json_encode(get_fac_category_butts());
?>
;
if ($('fac_ALL').checked == true) {
for (var i = 0; i < fac_curr_cats.length; i++) {
var fac_category = fac_curr_cats[i];
var params = "f_n=show_hide_fac_" +URLEncode(fac_category)+ "&v_n=s&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(fac_category).checked = true;
for (var j = 0; j < fmarkers.length; j++) {
if(fmarkers[j].category != "Incident") {
fmarkers[j].show();
}
}
}
$('fac_ALL').checked = false;
$('fac_ALL').style.display = 'none';
$('fac_ALL_BUTTON').style.display = 'none';
$('fac_NONE').style.display = '';
$('fac_NONE_BUTTON').style.display = '';
$('fac_go_button').style.display = 'none';
$('fac_can_button').style.display = 'none';
} else if ($('fac_NONE').checked == true) {
for (var i = 0; i < fac_curr_cats.length; i++) {
var fac_category = fac_curr_cats[i];
var params = "f_n=show_hide_fac_" +URLEncode(fac_category)+ "&v_n=h&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(fac_category).checked = false;
for (var j = 0; j < fmarkers.length; j++) {
if(fmarkers[j].category != "Incident") {
fmarkers[j].hide();
}
}
}
$('fac_NONE').checked = false;
$('fac_ALL').style.display = '';
$('fac_ALL_BUTTON').style.display = '';
$('fac_NONE').style.display = 'none';
$('fac_NONE_BUTTON').style.display = 'none';
$('fac_go_button').style.display = 'none';
$('fac_can_button').style.display = 'none';
} else {
var x = 0;
var y = 0;
for (var i = 0; i < fac_curr_cats.length; i++) {
var fac_category = fac_curr_cats[i];
if ($(fac_category).checked == true) {
x++;
var params = "f_n=show_hide_fac_" +URLEncode(fac_category)+ "&v_n=s&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(fac_category).checked = true;
for (var j = 0; j < fmarkers.length; j++) {
if(fmarkers[j].category == fac_category) {
fmarkers[j].show();
}
}
}
}
for (var i = 0; i < fac_curr_cats.length; i++) {
var fac_category = fac_curr_cats[i];
if ($(fac_category).checked == false) {
y++;
var params = "f_n=show_hide_fac_" +URLEncode(fac_category)+ "&v_n=h&sess_id=<?php
print get_sess_key(__LINE__);
?>
";
var url = "persist2.php";
sendRequest (url, gb_handleResult, params);
$(fac_category).checked = false;
var y=0;
for (var j = 0; j < fmarkers.length; j++) {
if(fmarkers[j].category == fac_category) {
fmarkers[j].hide();
}
}
}
}
}
var hidden = <?php
print find_hidden();
?>
;
var shown = <?php
print find_showing();
?>
;
$('fac_go_button').style.display = 'none';
$('fac_can_button').style.display = 'none';
if((x > 0) && (x < fac_curr_cats.length)) {
$('fac_ALL').style.display = '';
$('fac_ALL_BUTTON').style.display = '';
$('fac_NONE').style.display = '';
$('fac_NONE_BUTTON').style.display = '';
}
if(x == 0) {
$('fac_ALL').style.display = '';
$('fac_ALL_BUTTON').style.display = '';
$('fac_NONE').style.display = 'none';
$('fac_NONE_BUTTON').style.display = 'none';
}
if(x == fac_curr_cats.length) {
$('fac_ALL').style.display = 'none';
$('fac_ALL_BUTTON').style.display = 'none';
$('fac_NONE').style.display = '';
$('fac_NONE_BUTTON').style.display = '';
}
} // end function do_go_button()
function gfb_handleResult(req) { // 12/03/10 The persist callback function
}
// end of facilities show / hide function
function hideDiv(div_area, hide_cont, show_cont) { // 3/29/11, function forhiding DIVS for control areas
var divarea = div_area
var hide_cont = hide_cont
var show_cont = show_cont
if($(divarea)) {
$(divarea).style.display = 'none';
}
}
function showDiv(div_area, hide_cont, show_cont) { // 3/29/11, function for showing DIVS for control areas
var divarea = div_area
var hide_cont = hide_cont
var show_cont = show_cont
if($(divarea)) {
$(divarea).style.display = '';
}
}
var starting = false;
function check_sidemenu() {
if($('inc_list').style.display=="block") {
$('incs_but').className="right_menu_lit";
}
if($('buttons_sh').style.display=="block") {
$('marker_but').className="right_menu_lit";
}
if($('assigns_list').style.display=="block") {
$('assign_but').className="right_menu_lit";
}
}
function myclick(id) { // 3/29/11 For incident list clicks to launch infoWindow
GEvent.trigger(gmarkers[id], "click");
location.href = "#top";
}
function do_mail_fac_win(id) { // Facility email 9/22/09
if(starting) {return;}
starting=true;
var url = "do_fac_mail.php?fac_id=" + id;
newwindow_in=window.open (url, 'Email_Window', 'titlebar, resizable=1, scrollbars, height=300,width=600,status=0,toolbar=0,menubar=0,location=0, left=50,top=150,screenX=100,screenY=300');
if (isNull(newwindow_in)) {
alert ("This requires popups to be enabled. Please adjust your browser options.");
return;
}
newwindow_in.focus();
starting = false;
}
function do_show_Units() {
var params = "f_n=show_hide_unit&v_n=s&sess_id=<?php
print get_sess_key(basename(__FILE__) . __LINE__);
?>
"; // flag 1, value s
var url = "persist.php";
sendRequest (url, s_handleResult, params); // ($to_str, $text, $ticket_id) 10/15/08
} // end function do notify()
function s_handleResult(req) { // the 'called-back' persist function - show
show_Units();
}
function createMarker(point, tabs, color, stat, id, sym, category) { // Creates marker and sets up click event infowindow
points = true;
var icon = new GIcon(baseIcon);
var icon_url = "./our_icons/gen_icon.php?blank=" + escape(icons[color]) + "&text=" + sym; // 1/6/09
icon.image = icon_url;
var marker = new GMarker(point, icon);
marker.id = color; // for hide/unhide
marker.category = category; // 12/03/10 for show / hide by status
marker.stat = stat; // 10/21/09
GEvent.addListener(marker, "click", function() { // here for icon click
// if (ticket_ids[(id-1)]) {
// open_tick_window (ticket_ids[(id-1)]);
// }
// else {
map.closeInfoWindow();
which = id;
gmarkers[which].hide();
marker.openInfoWindowTabsHtml(infoTabs[id]);
setTimeout(function() { // wait for rendering complete - 11/6/08
if ($("detailmap")) { // 10/9/08
var dMapDiv = $("detailmap");
var detailmap = new GMap2(dMapDiv);
detailmap.addControl(new GSmallMapControl());
detailmap.setCenter(point, 17); // larger # = closer
detailmap.addOverlay(marker);
}
else {
}
},3000); // end setTimeout(...)
}); // end function(marker, point)
gmarkers[id] = marker; // marker to array for side_bar click function
infoTabs[id] = tabs; // tabs to array
if (!(map_is_fixed)){
bounds.extend(point);
}
return marker;
} // end function create Marker()
function createdummyMarker(point, tabs, id) { // Creates dummymarker and sets up click event infowindow for "no maps" added tickets and units. 7/28/10
points = true;
var icon = new GIcon(baseIcon);
var icon_url = "./our_icons/question1.png"; // 7/28/10
icon.image = icon_url;
var dummymarker = new GMarker(point, icon);
GEvent.addListener(dummymarker, "click", function() {
map.closeInfoWindow();
which = id;
gmarkers[which].hide();
dummymarker.openInfoWindowTabsHtml(infoTabs[id]);
setTimeout(function() {
if ($("detailmap")) {
var dMapDiv = $("detailmap");
var detailmap = new GMap2(dMapDiv);
detailmap.addControl(new GSmallMapControl());
detailmap.setCenter(point, 17);
detailmap.addOverlay(dummymarker);
}
else {
// alert($("detailmap"));
}
},3000); // end setTimeout(...)
});
gmarkers[id] = dummymarker; // marker to array for side_bar click function
infoTabs[id] = tabs; // tabs to array
if (!(map_is_fixed)){
bounds.extend(point);
}
return dummymarker;
} // end function create dummyMarker()
var the_grid;
var grid = false;
function doGrid() {
if (grid) {
map.removeOverlay(the_grid);
}
else {
the_grid = new LatLonGraticule();
map.addOverlay(the_grid);
}
grid = !grid;
} // end function doGrid
var trafficInfo = new GTrafficOverlay();
var toggleState = true;
function doTraffic() { // 10/16/08
if (toggleState) {
map.removeOverlay(trafficInfo);
}
else {
map.addOverlay(trafficInfo);
}
toggleState = !toggleState; // swap
} // end function doTraffic()
var icons=[]; // note globals
icons[0] = 4; // units white
icons[<?php
print $GLOBALS['SEVERITY_NORMAL'];
?>
+1] = 1; // blue
icons[<?php
print $GLOBALS['SEVERITY_MEDIUM'];
?>
+1] = 2; // yellow
icons[<?php
print $GLOBALS['SEVERITY_HIGH'];
?>
+1] = 3; // red
icons[<?php
print $GLOBALS['SEVERITY_HIGH'];
?>
+2] = 0; // black
var map;
var center;
var zoom;
var points = false;
<?php
$dzf = get_variable('def_zoom_fixed');
print "\tvar map_is_fixed = ";
print $dzf == 1 || $dzf == 3 ? "true;\n" : "false;\n";
$kml_olays = array();
$dir = "./kml_files";
$dh = opendir($dir);
$i = 1;
$temp = explode("/", $_SERVER['REQUEST_URI']);
$temp[count($temp) - 1] = "kml_files";
//
$server_str = "http://" . $_SERVER['SERVER_NAME'] . ":" . $_SERVER['SERVER_PORT'] . implode("/", $temp) . "/";
while (false !== ($filename = readdir($dh))) {
if (!is_dir($filename)) {
echo "\tvar kml_" . $i . " = new GGeoXml(\"" . $server_str . $filename . "\");\n";
$kml_olays[] = "map.addOverlay(kml_" . $i . ");";
$i++;
}
}
// dump ($kml_olays);
?>
function do_mail_win() { // 6/13/09
if(starting) {return;}
starting=true;
newwindow_um=window.open('do_unit_mail.php', 'E_mail_Window', 'titlebar, resizable=1, scrollbars, height=640,width=800,status=0,toolbar=0,menubar=0,location=0, left=50,top=150,screenX=100,screenY=300');
if (isNull(newwindow_um)) {
alert ("This requires popups to be enabled. Please adjust your browser options.");
return;
}
newwindow_um.focus();
starting = false;
}
function open_tick_window (id) { // 4/12/10
var url = "single.php?ticket_id="+ id;
var tickWindow = window.open(url, 'mailWindow', 'resizable=1, scrollbars, height=600, width=600, left=100,top=100,screenX=100,screenY=100');
tickWindow.focus();
}
function do_add_note (id) { // 8/12/09
var url = "add_note.php?ticket_id="+ id;
var noteWindow = window.open(url, 'mailWindow', 'resizable=1, scrollbars, height=240, width=600, left=100,top=100,screenX=100,screenY=100');
noteWindow.focus();
}
function do_track(callsign) {
if (parent.frames["upper"].logged_in()) {
// if(starting) {return;} // 6/6/08
// starting=true;
map.closeInfoWindow();
var width = <?php
print get_variable('map_width');
?>
+360;
var spec ="titlebar, resizable=1, scrollbars, height=640,width=" + width + ",status=0,toolbar=0,menubar=0,location=0, left=100,top=300,screenX=100,screenY=300";
var url = "track_u.php?source="+callsign;
newwindow=window.open(url, callsign, spec);
if (isNull(newwindow)) {
alert ("Track display requires popups to be enabled. Please adjust your browser options.");
return;
}
// starting = false;
newwindow.focus();
}
} // end function do track()
//function do_popup(id) { // added 7/9/09
// if (parent.frames["upper"].logged_in()) {
// map.closeInfoWindow();
// var width = <?php
print get_variable('map_width');
?>
+32;
// var spec ="titlebar, resizable=1, scrollbars, height=590,width=" + width + ",status=no,toolbar=no,menubar=no,location=0, left=100,top=300,screenX=100,screenY=300";
// var url = "incident_popup.php?id="+id;
//
// newwindow=window.open(url, id, spec);
// if (isNull(newwindow)) {
// alert ("Popup Incident display requires popups to be enabled. Please adjust your browser options.");
// return;
// }
//// starting = false;
// newwindow.focus();
// }
// } // end function do popup()
var ticket_ids = [];
var gmarkers = [];
var fmarkers = [];
var infoTabs = [];
var facinfoTabs = [];
var which;
var i = 0; // sidebar/icon index
map = new GMap2($("map")); // create the map
<?php
$maptype = get_variable('maptype');
// 08/02/09
switch ($maptype) {
case "1":
break;
case "2":
?>
map.setMapType(G_SATELLITE_MAP);<?php
break;
case "3":
?>
map.setMapType(G_PHYSICAL_MAP);<?php
break;
case "4":
?>
map.setMapType(G_HYBRID_MAP);<?php
break;
default:
print "ERROR in " . basename(__FILE__) . " " . __LINE__ . "<BR />";
}
?>
// map.addControl(new GSmallMapControl()); // 8/25/08
map.setUIToDefault(); // 8/13/10
map.addControl(new GMapTypeControl());
map.setCenter(new GLatLng(<?php
echo get_variable('def_lat');
?>
, <?php
echo get_variable('def_lng');
?>
), <?php
echo get_variable('def_zoom');
?>
);
mapBounds=new GLatLngBounds(map.getBounds().getSouthWest(), map.getBounds().getNorthEast()); // 4/4/09
var bounds = new GLatLngBounds(); // create bounding box
<?php
if (get_variable('terrain') == 1) {
?>
map.addMapType(G_PHYSICAL_MAP);
<?php
}
?>
map.enableScrollWheelZoom();
do_landb(); // 7/3/11 - show lines
var baseIcon = new GIcon();
baseIcon.shadow = "./markers/sm_shadow.png"; // ./markers/sm_shadow.png
baseIcon.iconSize = new GSize(20, 34);
baseIcon.shadowSize = new GSize(37, 34);
baseIcon.iconAnchor = new GPoint(9, 34);
baseIcon.infoWindowAnchor = new GPoint(9, 2);
baseIcon.infoShadowAnchor = new GPoint(18, 25);
GEvent.addListener(map, "infowindowclose", function() { // re-center after move/zoom
map.setCenter(center,zoom);
map.addOverlay(gmarkers[which])
});
<?php
$order_by = !empty($get_sortby) ? $get_sortby : $_SESSION['sortorder'];
// use default sort order?
//fix limits according to setting "ticket_per_page"
$limit = "";
if ($_SESSION['ticket_per_page'] && check_for_rows("SELECT id FROM `{$GLOBALS['mysql_prefix']}ticket`") > $_SESSION['ticket_per_page']) {
if ($_GET['offset']) {
$limit = "LIMIT {$_GET['offset']},{$_SESSION['ticket_per_page']}";
} else {
$limit = "LIMIT 0,{$_SESSION['ticket_per_page']}";
}
}
$restrict_ticket = get_variable('restrict_user_tickets') == 1 && !is_administrator() ? " AND owner={$_SESSION['user_id']}" : "";
$time_back = mysql_format_date(time() - get_variable('delta_mins') * 60 - $cwi * 3600);
if (!isset($_POST['frm_group'])) {
$x = 0;
$where2 = "AND (";
foreach ($al_groups as $grp) {
$where3 = count($al_groups) > $x + 1 ? " OR " : ")";
$where2 .= "`{$GLOBALS['mysql_prefix']}allocates`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
} else {
$x = 0;
$where2 = "AND (";
foreach ($_POST['frm_group'] as $grp) {
$where3 = count($_POST['frm_group']) > $x + 1 ? " OR " : ")";
$where2 .= "`{$GLOBALS['mysql_prefix']}allocates`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
}
switch ($func) {
//9/29/09 Added capability for Special Incidents 10/27/09 changed to bring scheduled incidents to front when due.
case 0:
$where = "WHERE (`status`='{$GLOBALS['STATUS_OPEN']}' OR (`status`='{$GLOBALS['STATUS_SCHEDULED']}' AND `booked_date` <= (NOW() + INTERVAL 2 DAY)) OR \n\t\t\t\t\t(`status`='{$GLOBALS['STATUS_CLOSED']}' AND `problemend` >= '{$time_back}')){$where2}";
// 11/29/10, 6/10/11, 6/10/11
break;
case 1:
case 2:
case 3:
case 4:
case 5:
case 6:
case 7:
case 8:
case 9:
$the_start = get_start($func);
// mysql timestamp format
$the_end = get_end($func);
$where = " WHERE (`status`='{$GLOBALS['STATUS_CLOSED']}' AND `problemend` BETWEEN '{$the_start}' AND '{$the_end}') {$where2} ";
// 6/10/11, 6/10/11
break;
case 10:
$where = "WHERE (`status`='{$GLOBALS['STATUS_SCHEDULED']}' AND `booked_date` >= (NOW() + INTERVAL 2 DAY)) {$where2}";
// 11/29/10, 6/10/11, 6/10/11
break;
default:
print "error - error - error - error " . __LINE__;
// default: $where = "WHERE `status`='{$GLOBALS['STATUS_OPEN']}' OR (`status`='3' AND `booked_date` <= (NOW() - INTERVAL 6 HOUR))"; break;
}
// end switch($func)
$query = "SELECT *, UNIX_TIMESTAMP(problemstart) AS `problemstart`, \n\t\t\tUNIX_TIMESTAMP(problemend) AS `problemend`,\n\t\t\tUNIX_TIMESTAMP(booked_date) AS booked_date,UNIX_TIMESTAMP(date) AS `date`,\n\t\t\tUNIX_TIMESTAMP(`{$GLOBALS['mysql_prefix']}ticket`.updated) AS `updated`, \n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.`id` AS `ticket_id`, \n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.`severity` AS `severity`, \t\t\t\n\t\t\t`{$GLOBALS['mysql_prefix']}in_types`.type AS `type`,\n\t\t\t`{$GLOBALS['mysql_prefix']}in_types`.`id` AS `t_id`,\n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.`description` AS `tick_descr`,\n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.street AS `tick_street`,\n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.city AS `tick_city`,\n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.state AS `tick_state`,\t\t\t\n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.lat AS `lat`,\n\t\t\t`{$GLOBALS['mysql_prefix']}ticket`.lng AS `lng`,\n\t\t\t`{$GLOBALS['mysql_prefix']}facilities`.lat AS `fac_lat`,\n\t\t\t`{$GLOBALS['mysql_prefix']}facilities`.lng AS `fac_lng`, \n\t\t\t`{$GLOBALS['mysql_prefix']}facilities`.`name` AS `fac_name` \n\t\t\tFROM `{$GLOBALS['mysql_prefix']}ticket`\n\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` ON `{$GLOBALS['mysql_prefix']}ticket`.id=`{$GLOBALS['mysql_prefix']}allocates`.`resource_id`\t\t\t\t\n\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}in_types` ON `{$GLOBALS['mysql_prefix']}ticket`.in_types_id=`{$GLOBALS['mysql_prefix']}in_types`.`id` \n\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}facilities` ON `{$GLOBALS['mysql_prefix']}ticket`.rec_facility=`{$GLOBALS['mysql_prefix']}facilities`.`id` \n\t\t\t{$where} {$restrict_ticket} \n\t\t\t GROUP BY ticket_id ORDER BY `status` DESC, `severity` DESC, `{$GLOBALS['mysql_prefix']}ticket`.`id` ASC";
// 2/2/09, 10/28/09
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$curr_incs = mysql_num_rows($result);
$sb_indx = 0;
// note zero base!
// major while ... starts here
?>
// 3/29/11 Incident List sidebar header
var sidebar_line = "<DIV style='width: 100%;'>";
sidebar_line += "<DIV CLASS= 'in_space odd'><DIV CLASS = 'incs'> </DIV></DIV>";
sidebar_line += "<DIV CLASS= 'in_space odd'><DIV CLASS = 'incs'> </DIV></DIV>";
sidebar_line += "<DIV CLASS= 'in_1 odd'><DIV CLASS = 'incs'><B>Incident</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'in_type odd'><DIV CLASS = 'incs'><B>Type</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'in_1 odd'><DIV CLASS = 'incs'><B>Addr</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'in_date odd'><DIV CLASS = 'incs'><B>Start</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'in_dur odd'><DIV CLASS = 'incs'><B>Duration</B></DIV></DIV></DIV><BR />";
<?php
$evenodd = array("even", "odd");
// CLASS names for alternating table row colors
if ($curr_incs > 0) {
$z = 0;
while ($row = stripslashes_deep(mysql_fetch_array($result))) {
$by_severity[$row['severity']]++;
$z == 0 ? $background_col = "even" : ($background_col = "odd");
print "\t\t ticket_ids.push({$row['ticket_id']});\n";
switch ($row['status']) {
//10/27/09 to Add star to scheduled incidents on current situation screen
case 1:
$sp = "";
break;
case 2:
$sp = "";
break;
case 3:
$sp = "*";
break;
default:
$sp = "";
break;
}
print "\t\tvar scheduled = '{$sp}';\n";
?>
// var sym = i.toString(); // for sidebar and icon
var sym = scheduled + (<?php
print $sb_indx;
?>
+1).toString(); // for sidebar and icon
<?php
$the_id = $row[0];
if ($row['tick_descr'] == '') {
$row['tick_descr'] = '[no description]';
}
// 8/12/09
if (get_variable('abbreviate_description')) {
//do abbreviations on description, affected if neccesary
if (strlen($row['tick_descr']) > get_variable('abbreviate_description')) {
$row['tick_descr'] = substr($row['tick_descr'], 0, get_variable('abbreviate_description')) . '...';
}
}
if (get_variable('abbreviate_affected')) {
if (strlen($row['affected']) > get_variable('abbreviate_affected')) {
$row['affected'] = substr($row['affected'], 0, get_variable('abbreviate_affected')) . '...';
}
}
switch ($row['severity']) {
//color tickets by severity
case $GLOBALS['SEVERITY_MEDIUM']:
$severityclass = 'severity_medium';
break;
case $GLOBALS['SEVERITY_HIGH']:
$severityclass = 'severity_high';
break;
default:
$severityclass = 'severity_normal';
break;
}
$street = empty($row['tick_street']) ? "" : $row['tick_street'] . "<BR/>" . $row['tick_city'] . " " . $row['state'];
$todisp = is_guest() ? "" : " <A HREF='routes.php?ticket_id=" . $the_id . "'><U>Dispatch</U></A>";
// 8/2/08
$now = now();
if ($row['status'] == $GLOBALS['STATUS_CLOSED']) {
$strike = "<strike>";
$strikend = "</strike>";
} else {
$strike = $strikend = "";
}
$index_no = $sb_indx + 1;
?>
// 3/29/11 Incident List sidebar
sidebar_line += "<DIV CLASS='in_space <?php
print $background_col;
?>
<?php
print $severityclass;
?>
'><DIV class='incs' onClick = 'myclick(<?php
print $sb_indx;
?>
);' onmouseout=\"UnTip()\" onmouseover=\"Tip('* means the incident is a scheduled one')\"><?php
print $strike;
?>
<?php
print $index_no;
print $strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='in_space <?php
print $background_col;
?>
<?php
print $severityclass;
?>
'><DIV class='incs' onClick = 'myclick(<?php
print $sb_indx;
?>
);' onmouseout=\"UnTip()\" onmouseover=\"Tip('* means the incident is a scheduled one')\"><?php
print $strike;
?>
<?php
print $sp;
print $strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='in_1 <?php
print $background_col;
?>
<?php
print $severityclass;
?>
'><DIV class='incs' onClick = 'myclick(<?php
print $sb_indx;
?>
);' onmouseout=\"UnTip()\" onmouseover=\"Tip('<?php
print $row['scope'];
?>
')\"><?php
print $strike;
?>
<?php
print shorten($row['scope'], $shorten_length);
print $strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='in_type <?php
print $background_col;
?>
<?php
print $severityclass;
?>
'><DIV class='incs' onClick = 'myclick(<?php
print $sb_indx;
?>
);' onmouseout=\"UnTip()\" onmouseover=\"Tip('<?php
print $row['type'];
?>
')\"><?php
print $strike;
?>
<?php
print shorten($row['type'], $shorten_length);
print $strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='in_1 <?php
print $background_col;
?>
<?php
print $severityclass;
?>
'><DIV class='incs' onClick = 'myclick(<?php
print $sb_indx;
?>
);' onmouseout=\"UnTip()\" onmouseover=\"Tip('<?php
print $row['tick_street'] . " " . $row['tick_city'] . " " . $row['tick_state'];
?>
')\"><?php
print $strike;
?>
<?php
print shorten($row['tick_street'] . ' ' . $row['tick_city'] . " " . $row['tick_state'], $shorten_length);
?>
<?php
print $strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='in_date <?php
print $background_col;
?>
<?php
print $severityclass;
?>
'><DIV class='incs' onClick = 'myclick(<?php
print $sb_indx;
?>
);' onmouseout=\"UnTip()\" onmouseover=\"Tip('<?php
print format_date($row['problemstart']);
?>
')\"><?php
print $strike;
?>
<?php
print shorten(format_date($row['problemstart']), $shorten_length);
print $strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='in_dur <?php
print $background_col;
?>
<?php
print $severityclass;
?>
'><DIV class='incs' onClick = 'myclick(<?php
print $sb_indx;
?>
);' onmouseout=\"UnTip()\" onmouseover=\"Tip('<?php
print my_date_diff($row['problemstart'], $now);
?>
')\"><?php
print $strike;
?>
<?php
print shorten(my_date_diff($row['problemstart'], $now), $shorten_length);
print $strikend;
?>
</DIV></DIV></BR>";
<?php
$rand = $istest ? "&rand=" . chr(rand(65, 90)) : "";
// 10/21/08
$tab_1 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$tab_1 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>{$strike}" . shorten($row['scope'], 48) . "{$strikend}</B></TD></TR>";
$tab_1 .= "<TR CLASS='odd'><TD>As of:</TD><TD>" . format_date($row['updated']) . "</TD></TR>";
if (good_date($row['booked_date'])) {
//4/13/10
$tab_1 .= "<TR CLASS='odd'><TD>Booked Date:</TD><TD>" . format_date($row['booked_date']) . "</TD></TR>";
}
$tab_1 .= "<TR CLASS='even'><TD>Reported by:</TD><TD>" . shorten($row['contact'], 32) . "</TD></TR>";
$tab_1 .= "<TR CLASS='odd'><TD>Phone:</TD><TD>" . format_phone($row['phone']) . "</TD></TR>";
$tab_1 .= "<TR CLASS='even'><TD>Addr:</TD><TD>" . $row['tick_street'] . ' ' . $row['tick_city'] . "</TD></TR>";
$end_date = intval($row['problemend']) > 1 ? $row['problemend'] : time() - get_variable('delta_mins') * 60;
$elapsed = my_date_diff($row['problemstart'], $end_date);
// 5/13/10
$tab_1 .= "<TR CLASS='odd'><TD ALIGN='left'>Status:</TD><TD ALIGN='left'>" . get_status($row['status']) . " ({$elapsed})</TD></TR>";
// 3/27/10
if (!empty($row['fac_name'])) {
$tab_1 .= "<TR CLASS='even'><TD>Receiving Facility:</TD><TD>" . shorten($row['fac_name'], 30) . "</TD></TR>";
//10/28/09
}
$utm = get_variable('UTM');
if ($utm == 1) {
$coords = $row['lat'] . "," . $row['lng'];
// 8/12/09
$tab_1 .= "<TR CLASS='even'><TD>UTM grid:</TD><TD>" . toUTM($coords) . "</TD></TR>";
}
$tab_1 .= "</TABLE>";
// 11/6/08
$tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
// 8/12/09
$tab_2 .= "<TR CLASS='even'>\t<TD ALIGN='left'>Description:</TD><TD ALIGN='left'>" . replace_quotes(shorten(str_replace($eols, " ", $row['tick_descr']), 48)) . "</TD></TR>";
// str_replace("\r\n", " ", $my_string)
$tab_2 .= "<TR CLASS='odd'>\t\t<TD ALIGN='left'>" . get_text('Disposition') . ":</TD><TD ALIGN='left'>" . replace_quotes(shorten($row['comments'], 48)) . "</TD></TR>";
// 8/13/09, 3/15/11
$tab_2 .= "<TR CLASS='even'>\t<TD ALIGN='left'>911 contact:</TD><TD ALIGN='left'>" . replace_quotes(shorten($row['nine_one_one'], 48)) . "</TD></TR>";
// 6/26/10
$locale = get_variable('locale');
// 08/03/09
switch ($locale) {
case "0":
$tab_2 .= "<TR CLASS='even'>\t<TD>USNG:</TD><TD>" . LLtoUSNG($row['lat'], $row['lng']) . "</TD></TR>";
// 8/23/08, 10/15/08, 8/3/09
break;
case "1":
$tab_2 .= "<TR CLASS='even'>\t<TD>OSGB:</TD><TD>" . LLtoOSGB($row['lat'], $row['lng']) . "</TD></TR>";
// 8/23/08, 10/15/08, 8/3/09
break;
case "2":
$coords = $row['lat'] . "," . $row['lng'];
// 8/12/09
$tab_2 .= "<TR CLASS='even'>\t<TD>UTM:</TD><TD>" . toUTM($coords) . "</TD></TR>";
// 8/23/08, 10/15/08, 8/3/09
break;
default:
print "ERROR in " . basename(__FILE__) . " " . __LINE__ . "<BR />";
}
// $tab_2 .= "<TR> <TD> </TD></TR>";
$tab_2 .= "<TR>\t\t\t\t\t<TD COLSPAN=2>" . show_assigns(0, $the_id) . "</TD></TR>";
$tab_2 .= "</TABLE>";
// 11/6/08
$query = "SELECT * FROM {$GLOBALS['mysql_prefix']}action WHERE `ticket_id` = " . $the_id;
$resultav = mysql_query($query) or do_error($query, 'mysql_query', mysql_error(), basename(__FILE__), __LINE__);
$A = mysql_affected_rows();
$query = "SELECT * FROM {$GLOBALS['mysql_prefix']}patient WHERE `ticket_id` = " . $the_id;
$resultav = mysql_query($query) or do_error($query, 'mysql_query', mysql_error(), basename(__FILE__), __LINE__);
$P = mysql_affected_rows();
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($row['scope'], 12));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("More ...", "<?php
print str_replace($eols, " ", $tab_2);
?>
"),
new GInfoWindowTab("Zoom", "<div id='detailmap' class='detailmap'></div>")
];
var point = new GLatLng(<?php
print $row['lat'];
?>
, <?php
print $row['lng'];
?>
); // for each ticket
if (!(map_is_fixed)){ // 4/3/09
bounds.extend(point);
}
var category = "Incident";
var marker = createMarker(point, myinfoTabs,<?php
print $row['severity'] + 1;
?>
, 0, i, sym, category); // (point,tabs, color, id, sym) - 1/6/09
var the_class = ((map_is_fixed) && (!(mapBounds.containsLatLng(point))))? "emph" : "td_label";
map.addOverlay(marker);
i++; // step the index
<?php
if (intval($row['radius']) > 0) {
$color = substr($row['color'], 0, 1) == "#" ? $row['color'] : "#000000";
// black default
?>
// drawCircle( 38.479874, -78.246704, 50.0, "#000080", 1, 0.75, "#0000FF", .2);
drawCircle( <?php
print $row['lat'];
?>
, <?php
print $row['lng'];
?>
, <?php
print $row['radius'];
?>
, "<?php
print $color;
?>
", 1, 0.75, "<?php
print $color;
?>
", .<?php
print $row['opacity'];
?>
);
<?php
}
// end if (intval($row['radius'])
$sb_indx++;
$z == 0 ? $z = 1 : ($z = 0);
}
// end tickets while ($row = ...)
} else {
?>
sidebar_line += "<DIV CLASS='even' style='width: 100%;'><DIV style='text-align: center; color: #FF0000; font-size: 12px; font-weight: bold;'>No Current Incidents for selected time period</DIV></DIV><BR />";
<?php
}
$sev_string = "Severities: normal ({$by_severity[$GLOBALS['SEVERITY_NORMAL']]}), Medium ({$by_severity[$GLOBALS['SEVERITY_MEDIUM']]}), High ({$by_severity[$GLOBALS['SEVERITY_HIGH']]})";
?>
$('sev_counts').innerHTML = "<?php
print $sev_string;
?>
";
$('incidents').innerHTML = sidebar_line; // incident list to sidebar
var sidebar_line = "";
<?php
// ========================================== 3/29/11 ASSIGNMENTS start ================================================
if (isset($_SESSION['viewed_groups'])) {
// 6/10/11
$curr_viewed = explode(",", $_SESSION['viewed_groups']);
}
if (!isset($curr_viewed)) {
$x = 0;
// 6/10/11
$where2 = "AND (";
// 6/10/11
foreach ($al_groups as $grp) {
// 6/10/11
$where3 = count($al_groups) > $x + 1 ? " OR " : ")";
$where2 .= "`a`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
} else {
$x = 0;
// 6/10/11
$where2 = "AND (";
// 6/10/11
foreach ($curr_viewed as $grp) {
// 6/10/11
$where3 = count($curr_viewed) > $x + 1 ? " OR " : ")";
$where2 .= "`a`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
}
$where2 .= "AND `a`.`type` = 2";
$query = "SELECT *,UNIX_TIMESTAMP(as_of) AS as_of,\n\t\t`{$GLOBALS['mysql_prefix']}assigns`.`id` AS `assign_id` ,\n\t\t`{$GLOBALS['mysql_prefix']}assigns`.`comments` AS `assign_comments`,\n\t\t`u`.`user` AS `theuser`, `t`.`scope` AS `tick_scope`,\n\t\t`t`.`description` AS `tick_descr`,\n\t\tUNIX_TIMESTAMP(`t`.`problemstart`) AS `tick_pstart`,\n\t\t`t`.`problemstart` AS `problemstart`,\t\t\n\t\t`t`.`status` AS `tick_status`,\n\t\t`t`.`street` AS `tick_street`,\n\t\t`t`.`city` AS `tick_city`,\n\t\t`t`.`state` AS `tick_state`,\t\t\t\n\t\t`r`.`id` AS `unit_id`,\n\t\t`r`.`name` AS `unit_name` ,\n\t\t`r`.`type` AS `unit_type` ,\n\t\t`{$GLOBALS['mysql_prefix']}assigns`.`as_of` AS `assign_as_of`,\n\t\t`{$GLOBALS['mysql_prefix']}assigns`.`clear` AS `clear`\t\t\n\t\tFROM `{$GLOBALS['mysql_prefix']}assigns` \n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}ticket` `t` ON (`{$GLOBALS['mysql_prefix']}assigns`.`ticket_id` = `t`.`id`)\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}user` `u` ON (`{$GLOBALS['mysql_prefix']}assigns`.`user_id` = `u`.`id`)\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}responder`\t`r` ON (`{$GLOBALS['mysql_prefix']}assigns`.`responder_id` = `r`.`id`)\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` `a` ON ( `r`.`id` = `a`.`resource_id` )\t\t\n\t\t\tWHERE (`clear` IS NULL OR DATE_FORMAT(`clear`,'%y') = '00') {$where2} \n\t\tGROUP BY `unit_id` ORDER BY `severity` DESC, `tick_pstart` ASC";
// dump($query);
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$curr_calls = mysql_num_rows($result);
$guest = is_guest();
$user = is_user();
$doUnit = $guest || $user ? "viewU" : "editU";
// 5/11/10
$doTick = $guest ? "viewT" : "editT";
// 06/26/08
$now = time() - get_variable('delta_mins') * 60;
$items = mysql_affected_rows();
$tags_arr = explode("/", get_variable('disp_stat'));
// 8/29/10
$TBL_INC_PERC = 50;
// incident group - four columns - 50 percent as default
$TBL_UNIT_PERC = 35;
// unit group,
$COLS_INCID = 18;
// incident name - 18 characters as default
$COLS_OPENED = 16;
// date/time opened - 0 characters as default
$COLS_DESCR = 32;
// incident description - 32 characters as default
$COLS_ADDR = 32;
// address - 32 characters as default
$COLS_UNIT = 15;
// unit name
$COLS_ASOF = 9;
// call as-of date/time - 9 characters as default
$priorities = array("", "severity_medium", "severity_high");
if ($curr_calls > 0) {
?>
// 3/29/11 Assignments List sidebar header
sidebar_line += "<DIV style='font-size: 12px; color: #000000; background: #FFFFFF;'>";
sidebar_line += "<DIV CLASS= 'c1 odd'><DIV class='incs'><B>Incident</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'cdate odd'><DIV class='incs'><B>Inc Start</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'c1 odd'><DIV class='incs'><B>Synopsis</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'c1 odd'><DIV class='incs'><B>Addr</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'cspace odd'><DIV class='incs'> </DIV></DIV>";
sidebar_line += "<DIV CLASS= 'unit_n odd'><DIV class='incs'><B>Unit</B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'unit_d odd'><DIV class='incs'><B> </B></DIV></DIV>";
sidebar_line += "<DIV CLASS= 'unit_s odd'><DIV class='incs'><B>Unit St</B></DIV></DIV>";
sidebar_line += "</DIV><BR />";
<?php
$w = 0;
$unit_ids = array();
$i = 1;
$evenodd = array("even", "odd");
// CLASS names for alternating table row colors
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// While for Assignments
// ============================= Regions stuff
$query_un = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 2 AND `resource_id` = '{$row['unit_id']}' ORDER BY `id` ASC;";
// 5/4/11
$result_un = mysql_query($query_un);
// 5/4/11
$un_groups = array();
while ($row_un = stripslashes_deep(mysql_fetch_assoc($result_un))) {
// 5/4/11
$un_groups[] = $row_un['group'];
}
// dump($row);
$inviewed = 0;
// 5/4/11
foreach ($un_groups as $un_val) {
if (in_array($un_val, $al_groups)) {
$inviewed++;
}
}
// ============================= end of Regions stuff
$w == 0 ? $bg_color_class = "even" : ($bg_color_class = "odd");
$in_strike = !empty($row['scope']) && $row['tick_status'] == $GLOBALS['STATUS_CLOSED'] ? "<STRIKE>" : "";
// 11/7/08
$in_strikend = !empty($row['scope']) && $row['tick_status'] == $GLOBALS['STATUS_CLOSED'] ? "</STRIKE>" : "";
if ($inviewed > 0) {
// Tests to see whether assigned unit is in one of the users groups 5/4/11
if (!empty($row['scope'])) {
$the_name = addslashes($row['tick_scope']);
// 9/12/09
$the_short_name = shorten($row['tick_scope'], $shorten_length);
$the_descr = empty($row['tick_descr']) ? " " : addslashes(str_replace($eols, " ", $row['tick_descr']));
$the_short_one = empty($row['tick_descr']) ? " " : shorten(addslashes(str_replace($eols, " ", $row['tick_descr'])), $shorten_length);
$address = empty($row['tick_street']) ? " " : $row['tick_street'] . ", ";
// 8/10/10
$address = addslashes($address . $row['tick_city'] . " " . $row['tick_state']);
$short_addr = shorten($address, $shorten_length);
?>
// 3/29/11 Assignments List sidebar
sidebar_line += "<DIV CLASS='c1 <?php
print $bg_color_class;
?>
'><DIV class='incs' onmouseover=\"Tip('[#<?php
print $row['ticket_id'];
?>
] <?php
print $the_name;
?>
')\" onmouseout=\"UnTip()\"><?php
print $in_strike;
print $the_short_name;
print $in_strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='cdate <?php
print $bg_color_class;
?>
'><DIV class='incs' onmouseover=\"Tip('Opened: <?php
print format_date($row['tick_pstart']);
?>
')\" onmouseout=\"UnTip()\"><?php
print substr($row['problemstart'], 0, $shorten_length);
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='c1 <?php
print $bg_color_class;
?>
'><DIV class='incs' onmouseover=\"Tip('<?php
print $the_descr;
?>
')\" onmouseout=\"UnTip()\"><?php
print $in_strike;
print $the_short_one;
print $in_strikend;
?>
</DIV></DIV>";
sidebar_line += "<DIV CLASS='c1 <?php
print $bg_color_class;
?>
'><DIV class='incs' onmouseover=\"Tip('<?php
print $address;
?>
')\" ALIGN='left' onmouseout=\"UnTip()\"><?php
print $in_strike;
print $short_addr;
print $in_strikend;
?>
</DIV></DIV>";
<?php
} else {
?>
sidebar_line += "<DIV CLASS='c0 <?php
print $bg_color_class;
?>
'><DIV class='incs'>135[#<?php
print $row['ticket_id'];
?>
]</DIV></DIV>";
<?php
}
?>
sidebar_line += "<DIV CLASS='cspace <?php
print $bg_color_class;
?>
'><DIV class='incs'> </DIV></DIV>";
<?php
// UNITS 3 col's - 9/12/09
if (is_date($row['clear'])) {
// 6/26/08
$strike = "<STRIKE>";
$strikend = "</STRIKE>";
// strikethrough on closed assigns
} else {
$strike = $strikend = "";
}
if (!($row['unit_id'] == 0)) {
// 5/11/09
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}unit_types`\tWHERE `id`= '{$row['unit_type']}' LIMIT 1";
$result_type = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_type = mysql_affected_rows() > 0 ? stripslashes_deep(mysql_fetch_assoc($result_type)) : "";
$the_bg_color = empty($row_type) ? "transparent" : $GLOBALS['UNIT_TYPES_BG'][$row_type['icon']];
// 3/15/10
$the_text_color = empty($row_type) ? "black" : $GLOBALS['UNIT_TYPES_TEXT'][$row_type['icon']];
//
unset($row_type);
$unit_name = empty($row['unit_id']) ? "[#{$row['unit_id']}]" : addslashes($row['unit_name']);
// id only if absent
$short_name = shorten($unit_name, 10);
?>
sidebar_line += "<DIV CLASS='unit_n <?php
print $bg_color_class;
?>
' STYLE='background-color:<?php
print $the_bg_color;
?>
; opacity: .7; color:<?php
print $the_text_color;
?>
;'><DIV class='incs' onmouseover=\"Tip('#<?php
print $row['unit_id'];
?>
<?php
print $unit_name;
?>
')\" onmouseout=\"UnTip()\"><B><?php
print $short_name;
?>
</B></DIV></DIV>";
<?php
$the_disp_str = fs_get_disp_status($row);
// 3/25/11
?>
sidebar_line += "<DIV CLASS='unit_d disp_stat'><DIV class='incs'<b> <?php
print $the_disp_str;
?>
</b></DIV></DIV>";
<?php
$query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated`,\n\t\t\t\t\t\t\t\t\t`t`.`id` AS `type_id`, \n\t\t\t\t\t\t\t\t\t`r`.`id` AS `unit_id`, \n\t\t\t\t\t\t\t\t\t`r`.`name` AS `name`,\n\t\t\t\t\t\t\t\t\t`s`.`description` AS `stat_descr`, \n\t\t\t\t\t\t\t\t\t`r`.`name` AS `unit_name`\n\t\t\t\t\t\t\t\t\tFROM `{$GLOBALS['mysql_prefix']}responder` `r` \n\t\t\t\t\t\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}unit_types` `t` ON ( `r`.`type` = t.id )\t\n\t\t\t\t\t\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}un_status` `s` ON ( `r`.`un_status_id` = s.id ) \n\t\t\t\t\t\t\t\t\tWHERE `r`.`id` = '{$row['unit_id']}' LIMIT 1";
$result_unit = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_unit = stripslashes_deep(mysql_fetch_assoc($result_unit));
?>
sidebar_line += "<DIV CLASS='unit_s' <?php
print $bg_color_class;
?>
'><DIV class='incs' onmouseover=\"Tip('<?php
print substr($row_unit['stat_descr'], 0, 12);
?>
')\" onmouseout=\"UnTip()\"> <?php
print substr($row_unit['stat_descr'], 0, 12);
?>
</DIV></DIV>";
sidebar_line += "</DIV><BR />";
<?php
}
}
$i++;
$w == 0 ? $w = 1 : ($w = 0);
}
} else {
?>
sidebar_line += "<DIV CLASS='even' style='width: 100%;'><DIV style='text-align: center; color: #FF0000; font-size: 12px; font-weight: bold;'>No Current Unit Assignments</DIV></DIV><BR />";
<?php
}
?>
$('assignments').innerHTML = sidebar_line; // assignment list to DIV
// ========================================== RESPONDER start ================================================
points = false;
i++;
var j=0;
<?php
$u_types = array();
// 1/1/09
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}unit_types` ORDER BY `id`";
// types in use
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
$u_types[$row['id']] = array($row['name'], $row['icon']);
// name, index, aprs - 1/5/09, 1/21/09
}
//dump($u_types);
unset($result);
$categories = array();
// 12/03/10
$categories = get_category_butts();
// 12/03/10
$assigns = array();
// 08/8/3
$tickets = array();
// ticket id's
$query = "SELECT `{$GLOBALS['mysql_prefix']}assigns`.`ticket_id`, `{$GLOBALS['mysql_prefix']}assigns`.`responder_id`, `{$GLOBALS['mysql_prefix']}ticket`.`scope` AS `ticket` FROM `{$GLOBALS['mysql_prefix']}assigns` LEFT JOIN `{$GLOBALS['mysql_prefix']}ticket` ON `{$GLOBALS['mysql_prefix']}assigns`.`ticket_id`=`{$GLOBALS['mysql_prefix']}ticket`.`id`";
$result_as = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row_as = stripslashes_deep(mysql_fetch_array($result_as))) {
$assigns[$row_as['responder_id']] = $row_as['ticket'];
$tickets[$row_as['responder_id']] = $row_as['ticket_id'];
}
unset($result_as);
$eols = array("\r\n", "\n", "\r");
// all flavors of eol
$bulls = array(0 => "", 1 => "red", 2 => "green", 3 => "white", 4 => "black");
$status_vals = array();
// build array of $status_vals
$status_vals[''] = $status_vals['0'] = "TBD";
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}un_status` ORDER BY `id`";
$result_st = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($row_st = stripslashes_deep(mysql_fetch_array($result_st))) {
$temp = $row_st['id'];
$status_vals[$temp] = $row_st['status_val'];
$status_hide[$temp] = $row_st['hide'];
}
unset($result_st);
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 4 AND `resource_id` = '{$_SESSION['user_id']}';";
// 6/10/11
$result = mysql_query($query);
// 6/10/11
$al_groups = array();
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// 6/10/11
$al_groups[] = $row['group'];
}
if (!isset($_POST['frm_group'])) {
$x = 0;
// 6/10/11
$where2 = "WHERE (";
// 6/10/11
foreach ($al_groups as $grp) {
// 6/10/11
$where3 = count($al_groups) > $x + 1 ? " OR " : ")";
$where2 .= "`a`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
} else {
$x = 0;
// 6/10/11
$where2 = "WHERE (";
// 6/10/11
foreach ($_POST['frm_group'] as $grp) {
// 6/10/11
$where3 = count($_POST['frm_group']) > $x + 1 ? " OR " : ")";
$where2 .= "`a`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
}
$where2 .= "AND `a`.`type` = 2";
//-----------------------UNIT RING FENCE STUFF--------------------6/10/11
?>
var thepoint;
var points = new Array();
var boundary = new Array();
var bound_names = new Array();
<?php
$query_bn = "SELECT * FROM `{$GLOBALS['mysql_prefix']}mmarkup` `l`\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}responder` `r` ON ( `l`.`id` = `r`.`ring_fence`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` `a` ON ( `r`.`id` = `a`.`resource_id` )\t\n\t\t\t\t{$where2} AND `use_with_u_rf`=1 GROUP BY `l`.`id`";
$result_bn = mysql_query($query_bn) or do_error($query_bn, mysql_error(), basename(__FILE__), __LINE__);
while ($row_bn = stripslashes_deep(mysql_fetch_assoc($result_bn))) {
extract($row_bn);
$bn_name = $row_bn['line_name'];
$all_boundaries[] = $row_bn['ring_fence'];
$points = explode(";", $line_data);
for ($i = 0; $i < count($points); $i++) {
$coords = explode(",", $points[$i]);
?>
thepoint = new GLatLng(parseFloat(<?php
print $coords[0];
?>
), parseFloat(<?php
print $coords[1];
?>
));
points.push(thepoint);
<?php
}
// end for ($i = 0 ... )
if (intval($filled) == 1) {
// 6/10/11
?>
var polyline = new GPolygon(points, add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
, add_hash("<?php
print $fill_color;
?>
"), <?php
print $fill_opacity;
?>
, {clickable:false, id:"ringfence"});
boundary.push(polyline);
bound_names.push("<?php
print $bn_name;
?>
");
<?php
} else {
?>
var polyline = new GPolyline(points, add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
, , 0, {clickable:false, id:"ringfence"});
boundary.push(polyline);
bound_names.push("<?php
print $bn_name;
?>
");
<?php
}
?>
map.addOverlay(polyline);
<?php
}
// End while
//-------------------------END OF UNIT RING FENCE STUFF-------------------------
//-----------------------UNIT EXCLUSION ZONE STUFF--------------------6/10/11
?>
var thepoint;
var points = new Array();
<?php
$query_bn = "SELECT * FROM `{$GLOBALS['mysql_prefix']}mmarkup` `l`\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}responder` `r` ON ( `l`.`id` = `r`.`excl_zone`)\n\t\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` `a` ON ( `r`.`id` = `a`.`resource_id` )\t\n\t\t\t\t{$where2} AND `use_with_u_ex`=1 GROUP BY `l`.`id`";
$result_bn = mysql_query($query_bn) or do_error($query_bn, mysql_error(), basename(__FILE__), __LINE__);
while ($row_bn = stripslashes_deep(mysql_fetch_assoc($result_bn))) {
extract($row_bn);
$bn_name = $row_bn['line_name'];
$all_boundaries[] = $row_bn['ring_fence'];
$points = explode(";", $line_data);
for ($i = 0; $i < count($points); $i++) {
$coords = explode(",", $points[$i]);
?>
thepoint = new GLatLng(parseFloat(<?php
print $coords[0];
?>
), parseFloat(<?php
print $coords[1];
?>
));
points.push(thepoint);
<?php
}
// end for ($i = 0 ... )
if (intval($filled) == 1) {
// 6/10/11
?>
var polyline = new GPolygon(points, add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
, add_hash("<?php
print $fill_color;
?>
"), <?php
print $fill_opacity;
?>
, {clickable:false, id:"ringfence"});
boundary.push(polyline);
bound_names.push("<?php
print $bn_name;
?>
");
<?php
} else {
?>
var polyline = new GPolyline(points, add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
, , 0, {clickable:false, id:"ringfence"});
boundary.push(polyline);
bound_names.push("<?php
print $bn_name;
?>
");
<?php
}
?>
map.addOverlay(polyline);
<?php
}
// End while
//-------------------------END OF UNIT EXCLUSION ZONE STUFF-------------------------
// $query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated` FROM `$GLOBALS[mysql_prefix]responder` ORDER BY `handle`"; //
// $query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated` FROM `$GLOBALS[mysql_prefix]responder` ORDER BY `name`"; //
$query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated`, `r`.`name` AS `unit_name`, `r`.`id` AS `unit_id`, `t`.`name` AS `type_name`, `r`.`type` AS `type`\n\t\tFROM `{$GLOBALS['mysql_prefix']}responder` `r` \n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` `a` ON ( `r`.`id` = a.resource_id )\t\t\t\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}unit_types` `t` ON ( `r`.`type` = t.id )\t\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}un_status` `s` ON ( `r`.`un_status_id` = s.id ) \n\t\t{$where2} \n\t\tGROUP BY unit_id ";
// 4/11/11, 5/4/11
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$units_ct = mysql_affected_rows();
// 1/4/10
$aprs = FALSE;
$instam = FALSE;
$locatea = FALSE;
//7/23/09
$gtrack = FALSE;
//7/23/09
$glat = FALSE;
//7/23/09
$i = 0;
// counter
// =============================================================================
$bulls = array(0 => "", 1 => "red", 2 => "green", 3 => "white", 4 => "black");
$utc = gmdate("U");
// 3/25/09
while ($row = stripslashes_deep(mysql_fetch_array($result))) {
// ========== major while() for RESPONDER ==========
$got_point = FALSE;
$latitude = $row['lat'];
// 7/18/10
$longitude = $row['lng'];
// 7/18/10
$name = $row['unit_name'];
// 10/8/09
$temp = explode("/", $name);
$index = $row['icon_str'];
// 4/27/11
print "\t\tvar sym = '{$index}';\n";
// for sidebar and icon 10/8/09
// 2/13/09
$todisp = is_guest() ? "" : " <A HREF='units.php?func=responder&view=true&disp=true&id=" . $row['id'] . "'><U>Dispatch</U></A> ";
// 08/8/02
$toedit = is_guest() ? "" : " <A HREF='units.php?func=responder&edit=true&id=" . $row['id'] . "'><U>Edit</U></A> ";
// 10/8/08
$totrack = intval($row['mobile']) == 0 || empty($row['callsign']) ? "" : " <SPAN onClick = do_track('" . $row['callsign'] . "');><B><U>Tracks</B></U> </SPAN>";
$tofac = is_guest() ? "" : "<A HREF='units.php?func=responder&view=true&dispfac=true&id=" . $row['id'] . "'><U>To Facility</U></A> ";
// 08/8/02
$temp = $row['un_status_id'];
// 2/24/09
$the_status = array_key_exists($temp, $status_vals) ? $status_vals[$temp] : "??";
// 2/2/09
$hide_status = array_key_exists($temp, $status_hide) ? $status_hide[$temp] : "??";
// 10/21/09
if ($hide_status == "y") {
$hide_unit = 1;
} else {
$hide_unit = 0;
}
$temp = $row['un_status_id'];
// 2/24/09
$the_status = array_key_exists($temp, $status_vals) ? $status_vals[$temp] : "??";
// 2/2/09
if ($row['aprs'] == 1) {
// get most recent aprs position data
$query = "SELECT *,UNIX_TIMESTAMP(packet_date) AS `packet_date`, UNIX_TIMESTAMP(updated) AS `updated` FROM `{$GLOBALS['mysql_prefix']}tracks`\n\t\t\t\t\tWHERE `source`= '{$row['callsign']}' ORDER BY `packet_date` DESC LIMIT 1";
// newest
$result_tr = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_aprs = mysql_affected_rows() > 0 ? stripslashes_deep(mysql_fetch_assoc($result_tr)) : FALSE;
$aprs_updated = $row_aprs['updated'];
$aprs_speed = $row_aprs['speed'];
// if (($row_aprs) && (settype($row_aprs['latitude'], "float"))) {
if ($row_aprs && my_is_float($row_aprs['latitude'])) {
echo "\t\tvar point = new GLatLng(" . $row_aprs['latitude'] . ", " . $row_aprs['longitude'] . "); // 677\n";
$got_point = TRUE;
}
unset($result_tr);
} else {
$row_aprs = FALSE;
}
// dump($row_aprs);
if ($row['instam'] == 1) {
// get most recent instamapper data
$temp = explode("/", $row['callsign']);
// callsign/account no. 3/22/09
$query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated` FROM `{$GLOBALS['mysql_prefix']}tracks_hh`\n\t\t\t\t\tWHERE `source` LIKE '{$temp['0']}%' ORDER BY `updated` DESC LIMIT 1";
// newest
$result_tr = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_instam = mysql_affected_rows() > 0 ? stripslashes_deep(mysql_fetch_assoc($result_tr)) : FALSE;
$instam_updated = $row_instam['updated'];
$instam_speed = $row_instam['speed'];
if ($row_instam && my_is_float($row_instam['latitude'])) {
// 4/29/09
echo "\t\tvar point = new GLatLng(" . $row_instam['latitude'] . ", " . $row_instam['longitude'] . "); // 724\n";
$got_point = TRUE;
}
unset($result_tr);
} else {
$row_instam = FALSE;
}
if ($row['locatea'] == 1) {
// get most recent locatea data // 7/23/09
$temp = explode("/", $row['callsign']);
// callsign/account no.
$query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated` FROM `{$GLOBALS['mysql_prefix']}tracks_hh`\n\t\t\t\t\tWHERE `source` LIKE '{$temp['0']}%' ORDER BY `updated` DESC LIMIT 1";
// newest
$result_tr = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_locatea = mysql_affected_rows() > 0 ? stripslashes_deep(mysql_fetch_assoc($result_tr)) : FALSE;
$locatea_updated = $row_locatea['updated'];
$locatea_speed = $row_locatea['speed'];
if ($row_locatea && my_is_float($row_locatea['latitude'])) {
echo "\t\tvar point = new GLatLng(" . $row_locatea['latitude'] . ", " . $row_locatea['longitude'] . "); // 687\n";
$got_point = TRUE;
}
unset($result_tr);
} else {
$row_locatea = FALSE;
}
if ($row['gtrack'] == 1) {
// get most recent gtrack data // 7/23/09
$temp = explode("/", $row['callsign']);
// callsign/account no.
$query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated` FROM `{$GLOBALS['mysql_prefix']}tracks_hh`\n\t\t\t\t\tWHERE `source` LIKE '{$temp['0']}%' ORDER BY `updated` DESC LIMIT 1";
// newest
$result_tr = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_gtrack = mysql_affected_rows() > 0 ? stripslashes_deep(mysql_fetch_assoc($result_tr)) : FALSE;
$gtrack_updated = $row_gtrack['updated'];
$gtrack_speed = $row_gtrack['speed'];
if ($row_gtrack && my_is_float($row_gtrack['latitude'])) {
echo "\t\tvar point = new GLatLng(" . $row_gtrack['latitude'] . ", " . $row_gtrack['longitude'] . "); // 687\n";
$got_point = TRUE;
}
unset($result_tr);
} else {
$row_gtrack = FALSE;
}
if ($row['glat'] == 1) {
// get most recent latitude data // 7/23/09
$temp = explode("/", $row['callsign']);
// callsign/account no.
$query = "SELECT *, UNIX_TIMESTAMP(updated) AS `updated` FROM `{$GLOBALS['mysql_prefix']}tracks_hh`\n\t\t\t\t\tWHERE `source` LIKE '{$temp['0']}%' ORDER BY `updated` DESC LIMIT 1";
// newest
$result_tr = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_glat = mysql_affected_rows() > 0 ? stripslashes_deep(mysql_fetch_assoc($result_tr)) : FALSE;
$glat_updated = $row_glat['updated'];
if ($row_glat && my_is_float($row_glat['latitude'])) {
echo "\t\tvar point = new GLatLng(" . $row_glat['latitude'] . ", " . $row_glat['longitude'] . "); // 687\n";
$got_point = TRUE;
}
unset($result_tr);
} else {
$row_glat = FALSE;
}
if (!$got_point && my_is_float($row['lat'])) {
echo "\t\tvar point = new GLatLng(" . $row['lat'] . ", " . $row['lng'] . ");\t// 753\n";
$got_point = TRUE;
}
// print __LINE__ . "<BR />";
$the_bull = "";
// define the bullet
$update_error = strtotime('now - 6 hours');
// set the time for silent setting
// echo $update_error;
if ($row['aprs'] == 1) {
if ($row_aprs) {
$spd = 2;
// default
if ($aprs_speed == 0) {
$spd = 1;
}
// stopped
if ($aprs_speed >= 50) {
$spd = 3;
}
// fast
} else {
$spd = 0;
// no data
}
$the_bull = "<FONT COLOR=" . $bulls[$spd] . "><B>AP</B></FONT>";
}
// end aprs
if ($row['instam'] == 1) {
if ($instam_speed > 50) {
$the_bull = "<FONT COLOR = 'white'><B>IN</B></FONT>";
}
if ($instam_speed < 50) {
$the_bull = "<FONT COLOR = 'green'><B>IN</B></FONT>";
}
if ($instam_speed == 0) {
$the_bull = "<FONT COLOR = 'red'><B>IN</B></FONT>";
}
if ($instam_updated < $update_error) {
$the_bull = "<FONT COLOR = 'black'><B>IN</B></FONT>";
}
}
if ($row['locatea'] == 1) {
if ($locatea_speed > 50) {
$the_bull = "<FONT COLOR = 'white'><B>LO</B></FONT>";
}
// 7/23/09
if ($locatea_speed < 50) {
$the_bull = "<FONT COLOR = 'green'><B>LO</B></FONT>";
}
if ($locatea_speed == 0) {
$the_bull = "<FONT COLOR = 'red'><B>LO</B></FONT>";
}
if ($locatea_updated < $update_error) {
$the_bull = "<FONT COLOR = 'black'><B>LO</B></FONT>";
}
}
if ($row['gtrack'] == 1) {
if ($gtrack_speed > 50) {
$the_bull = "<FONT COLOR = 'white'><B>GT</B></FONT>";
}
// 7/23/09
if ($gtrack_speed < 50) {
$the_bull = "<FONT COLOR = 'green'><B>GT</B></FONT>";
}
if ($gtrack_speed == 0) {
$the_bull = "<FONT COLOR = 'red'><B>GT</B></FONT>";
}
if ($gtrack_updated < $update_error) {
$the_bull = "<FONT COLOR = 'black'><B>GT</B></FONT>";
}
}
if ($row['glat'] == 1) {
$the_bull = "<FONT COLOR = 'green'><B>GL</B></FONT>";
// 7/23/09
if ($glat_updated < $update_error) {
$the_bull = "<FONT COLOR = 'black'><B>GL</B></FONT>";
}
}
// end bullet stuff
// name
$name = $row['name'];
// 10/8/09
$temp = explode("/", $name);
$display_name = $temp[0];
// assignments 3/16/09
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` LEFT JOIN `{$GLOBALS['mysql_prefix']}ticket` t ON ({$GLOBALS['mysql_prefix']}assigns.ticket_id = t.id)\n\t\t\t\tWHERE `responder_id` = '{$row['id']}' AND `clear` IS NULL ";
// dump($query);
$result_as = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_assign = mysql_affected_rows() == 0 ? FALSE : stripslashes_deep(mysql_fetch_assoc($result_as));
unset($result_as);
switch ($row_assign['severity']) {
//color tickets by severity
case $GLOBALS['SEVERITY_MEDIUM']:
$severityclass = 'severity_medium';
break;
case $GLOBALS['SEVERITY_HIGH']:
$severityclass = 'severity_high';
break;
default:
$severityclass = 'severity_normal';
break;
}
$tick_ct = mysql_affected_rows() > 1 ? "(" . mysql_affected_rows() . ") " : "";
$ass_td = mysql_affected_rows() > 0 ? "<TD COLSPAN=2 CLASS='{$severityclass}' TITLE = '" . $row_assign['scope'] . "' >" . $tick_ct . shorten($row_assign['scope'], 24) . "</TD>" : "<TD>na</TD>";
// status, mobility
// as of
$strike = $strike_end = "";
if ($row['instam'] == 1 && $row_instam || $row['aprs'] == 1 && $row_aprs || $row['locatea'] == 1 && $row_locatea || $row['gtrack'] == 1 && $row_gtrack || $row['glat'] == 1 && $row_glat) {
// either remote source?
$the_class = "emph";
if ($row['aprs'] == 1) {
// 3/24/09
$the_time = $aprs_updated;
$instam = TRUE;
// show footer legend
}
if ($row['instam'] == 1) {
// 3/24/09
$the_time = $instam_updated;
$instam = TRUE;
// show footer legend
}
if ($row['locatea'] == 1) {
// 7/23/09
$the_time = $locatea_updated;
$locatea = TRUE;
// show footer legend
}
if ($row['gtrack'] == 1) {
// 7/23/09
$the_time = $gtrack_updated;
$gtrack = TRUE;
// show footer legend
}
if ($row['glat'] == 1) {
// 7/23/09
$the_time = $glat_updated;
$glat = TRUE;
// show footer legend
}
} else {
$the_time = $row['updated'];
$the_class = "td_data";
}
if (abs($utc - $the_time) > $GLOBALS['TOLERANCE']) {
// attempt to identify non-current values
$strike = "<STRIKE>";
$strike_end = "</STRIKE>";
} else {
$strike = $strike_end = "";
}
// snap(basename( __FILE__) . __LINE__, $the_class );
// tab 1
// if (((settype($row['lat'], "float"))) || ($row_aprs) || ($row_instam)) { // position data?
if (my_is_float($row['lat']) || $row_aprs || $row_instam || $row_locatea || $row_gtrack || $row_glat) {
// 5/4/09
// dump(__LINE__);
$temptype = $u_types[$row['type']];
$the_type = $temptype[0];
// 1/1/09
$tab_1 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$tab_1 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>" . shorten($row['unit_name'], 48) . "</B> - " . $the_type . "</TD></TR>";
$tab_1 .= "<TR CLASS='odd'><TD>Description:</TD><TD>" . shorten(str_replace($eols, " ", $row['description']), 32) . "</TD></TR>";
$tab_1 .= "<TR CLASS='even'><TD>Status:</TD><TD>" . $the_status . " </TD></TR>";
$tab_1 .= "<TR CLASS='odd'><TD>Contact:</TD><TD>" . $row['contact_name'] . " Via: " . $row['contact_via'] . "</TD></TR>";
$tab_1 .= "<TR CLASS='even'><TD>As of:</TD><TD>" . format_date($row['updated']) . "</TD></TR>";
if (array_key_exists($row['id'], $assigns)) {
$tab_1 .= "<TR CLASS='even'><TD CLASS='emph'>Dispatched to:</TD><TD CLASS='emph'><A HREF='main.php?id=" . $tickets[$row['id']] . "'>" . shorten($assigns[$row['id']], 20) . "</A></TD></TR>";
}
$tab_1 .= "<TR CLASS='odd'><TD COLSPAN = 2> </TD></TR>";
$tab_1 .= "<TR CLASS='even'><TD COLSPAN = 2 ALIGN = 'center' onClick = 'do_mail_win();'><B><U>Email units</U></B></TD></TR>";
$tab_1 .= "</TABLE>";
// tab 2
$tabs_done = FALSE;
if ($row_aprs) {
// three tabs if APRS data
$tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$tab_2 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>" . $row_aprs['source'] . "</B></TD></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>Course: </TD><TD>" . $row_aprs['course'] . ", Speed: " . $row_aprs['speed'] . ", Alt: " . $row_aprs['altitude'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='even'><TD>Closest city: </TD><TD>" . $row_aprs['closest_city'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>Status: </TD><TD>" . $row_aprs['status'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='even'><TD>As of: </TD><TD> {$strike} " . format_date($row_aprs['packet_date']) . " {$strike_end} (UTC)</TD></TR></TABLE>";
$tabs_done = TRUE;
// print __LINE__;
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($row['unit_name'], 10));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("APRS <?php
print addslashes(substr($row_aprs['source'], -3));
?>
", "<?php
print $tab_2;
?>
"),
new GInfoWindowTab("Zoom", "<div id='detailmap' class='detailmap'></div>")
];
<?php
}
// end if ($row_aprs)
if ($row_instam) {
// three tabs if instam data
// dump(__LINE__);
$tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$tab_2 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>" . $row_instam['source'] . "</B></TD></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>Course: </TD><TD>" . $row_instam['course'] . ", Speed: " . $row_instam['speed'] . ", Alt: " . $row_instam['altitude'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='even'><TD>As of: </TD><TD> {$strike} " . format_date($row_instam['updated']) . " {$strike_end}</TD></TR></TABLE>";
$tabs_done = TRUE;
// print __LINE__;
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($row['unit_name'], 10));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("Instam <?php
print addslashes(substr($row_instam['source'], -3));
?>
", "<?php
print $tab_2;
?>
"),
new GInfoWindowTab("Zoom", "<div id='detailmap' class='detailmap'></div>") // 830
];
<?php
}
// end if ($row_instam)
if ($row_locatea) {
// three tabs if locatea data 7/23/09
// dump(__LINE__);
$tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$tab_2 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>" . $row_locatea['source'] . "</B></TD></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>Course: </TD><TD>" . $row_locatea['course'] . ", Speed: " . $row_locatea['speed'] . ", Alt: " . $row_locatea['altitude'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='even'><TD>As of: </TD><TD> {$strike} " . format_date($row_locatea['updated']) . " {$strike_end}</TD></TR></TABLE>";
$tabs_done = TRUE;
// print __LINE__;
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($row['unit_name'], 10));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("LocateA <?php
print addslashes(substr($row_locatea['source'], -3));
?>
", "<?php
print $tab_2;
?>
"),
new GInfoWindowTab("Zoom", "<div id='detailmap' class='detailmap'></div>") // 830
];
<?php
}
// end if ($row_gtrack)
if ($row_gtrack) {
// three tabs if gtrack data 7/23/09
// dump(__LINE__);
$tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$tab_2 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>" . $row_gtrack['source'] . "</B></TD></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>Course: </TD><TD>" . $row_gtrack['course'] . ", Speed: " . $row_gtrack['speed'] . ", Alt: " . $row_gtrack['altitude'] . "</TD></TR>";
$tab_2 .= "<TR CLASS='even'><TD>As of: </TD><TD> {$strike} " . format_date($row_gtrack['updated']) . " {$strike_end}</TD></TR></TABLE>";
$tabs_done = TRUE;
// print __LINE__;
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($row['unit_name'], 10));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("Gtrack <?php
print addslashes(substr($row_gtrack['source'], -3));
?>
", "<?php
print $tab_2;
?>
"),
new GInfoWindowTab("Zoom", "<div id='detailmap' class='detailmap'></div>") // 830
];
<?php
}
// end if ($row_gtrack)
if ($row_glat) {
// three tabs if glat data 7/23/09
// dump(__LINE__);
$tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$tab_2 .= "<TR CLASS='odd'><TD COLSPAN=2 ALIGN='center'><B>" . $row_glat['source'] . "</B></TD></TR>";
$tab_2 .= "<TR CLASS='odd'><TD>As of: </TD><TD> {$strike} " . format_date($row_glat['updated']) . " {$strike_end}</TD></TR></TABLE>";
$tabs_done = TRUE;
// print __LINE__;
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($row['unit_name'], 10));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("G Lat <?php
print addslashes(substr($row_glat['source'], -3));
?>
", "<?php
print $tab_2;
?>
"),
new GInfoWindowTab("Zoom", "<div id='detailmap' class='detailmap'></div>") // 830
];
<?php
}
// end if ($row_gtrack)
if (!$tabs_done) {
// else two tabs
?>
var myinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(shorten($row['unit_name'], 10));
?>
", "<?php
print $tab_1;
?>
"),
new GInfoWindowTab("Zoom", "<div id='detailmap' class='detailmap'></div>")
];
<?php
}
// end if(!($tabs_done))
$temp = $u_types[$row['type']];
// array ($row['name'], $row['icon'])
// dump($temp);
$the_color = $row['mobile'] == "1" ? 0 : 4;
// icon color black, white -- 4/18/09
$the_group = get_category($row['unit_id']);
if ($latitude == "0.999999" && $longitude == "0.999999") {
// check for no maps added points 7/28/10
$dummylat = get_variable('def_lat');
$dummylng = get_variable('def_lng');
echo "\t\tvar point = new GLatLng(" . $dummylat . ", " . $dummylng . "); // 677\n";
?>
var dummymarker = createdummyMarker(point, myinfoTabs, <?php
print $sb_indx;
?>
); // Plots dummy icon in default position for units added in no maps operation
map.addOverlay(dummymarker);
<?php
} else {
?>
var the_group = '<?php
print $the_group;
?>
';
var marker = createMarker(point, myinfoTabs, <?php
print $the_color;
?>
, <?php
print $hide_unit;
?>
, <?php
print $sb_indx;
?>
, sym, the_group); // 7/28/10
map.addOverlay(marker);
<?php
}
// end check for no maps added points
} else {
// (sidebar, line_no, rcd_id, letter)
// dump(__LINE__);
}
$i++;
// zero-based
print "\t\ti++;\n";
// 3/20/09
$sb_indx++;
// zero-based
}
// end ========== while() for RESPONDER ==========
$source_legend = $aprs || $instam || $gtrack || $locatea || $glat ? "<TD CLASS='emph' ALIGN='center'>Source time</TD>" : "<TD></TD>";
// if any remote data/time 3/24/09
?>
side_bar_html= "<form action='#'>"; // 12/03/10
<?php
if ($units_ct > 0) {
// 3/15/11
foreach ($categories as $key => $value) {
// 12/03/10
?>
side_bar_html += "<DIV class='cat_button' onClick='set_chkbox(\"<?php
print $value;
?>
\")'><?php
print $value;
?>
: <input type=checkbox id='<?php
print $value;
?>
' onClick='set_chkbox(\"<?php
print $value;
?>
\")'/> </DIV>"; <!-- 12/03/10 -->
<?php
}
$all = "ALL";
// 12/03/10
$none = "NONE";
// 12/03/10
?>
side_bar_html += "<DIV ID = 'ALL_BUTTON' class='cat_button' onClick='set_chkbox(\"<?php
print $all;
?>
\")'><FONT COLOR = 'red'>ALL</FONT><input type=checkbox id='<?php
print $all;
?>
' onClick='set_chkbox(\"<?php
print $all;
?>
\")'/></FONT></DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'NONE_BUTTON' class='cat_button' onClick='set_chkbox(\"<?php
print $none;
?>
\")'><FONT COLOR = 'red'>NONE</FONT><input type=checkbox id='<?php
print $none;
?>
' onClick='set_chkbox(\"<?php
print $none;
?>
\")'/></FONT></DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'go_can' style='float:right; padding:2px;'><SPAN ID = 'go_button' onClick='do_go_button()' class='conf_next_button' STYLE = 'display:none;'><U>Next</U></SPAN>";
side_bar_html += "<SPAN ID = 'can_button' onClick='cancel_buttons()' class='conf_can_button' STYLE = 'display:none;'><U>Cancel</U></SPAN></DIV>";
side_bar_html+="</form></TD></TR></TABLE>"; <!-- 12/03/10 -->
<?php
} else {
foreach ($categories as $key => $value) {
// 12/03/10
?>
side_bar_html += "<DIV class='cat_button' STYLE='display: none;' onClick='set_chkbox(\"<?php
print $value;
?>
\")'><?php
print $value;
?>
: <input type=checkbox id='<?php
print $value;
?>
' onClick='set_chkbox(\"<?php
print $value;
?>
\")'/> </DIV>"; <!-- 12/03/10 -->
<?php
}
$all = "ALL";
// 12/03/10
$none = "NONE";
// 12/03/10
?>
side_bar_html += "<DIV class='cat_button' style='color: red;'>None Defined ! </DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'ALL_BUTTON' class='cat_button' STYLE='display: none;' onClick='set_chkbox(\"<?php
print $all;
?>
\")'><input type=checkbox id='ALL' style='display: none'></DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'NONE_BUTTON' class='cat_button' STYLE='display: none;' onClick='set_chkbox(\"<?php
print $none;
?>
\")'><input type=checkbox id='NONE' style='display: none'></DIV>"; <!-- 12/03/10 -->
side_bar_html +="</form></TD></TR></TABLE></DIV>"; <!-- 12/03/10 -->
<?php
}
?>
$("boxes").innerHTML = side_bar_html; // 12/03/10 side_bar_html to responders div
// ====================================Add Facilities to Map 8/1/09================================================
<?php
$fac_categories = array();
// 12/03/10
$fac_categories = get_fac_category_butts();
// 12/03/10
?>
var icons=[];
var g=0;
var fmarkers = [];
var baseIcon = new GIcon();
baseIcon.shadow = "./markers/sm_shadow.png";
baseIcon.iconSize = new GSize(30, 30);
baseIcon.iconAnchor = new GPoint(15, 30);
baseIcon.infoWindowAnchor = new GPoint(9, 2);
var fac_icon = new GIcon(baseIcon);
fac_icon.image = icons[1];
function createfacMarker(fac_point, fac_name, id, fac_icon, type) {
var fac_marker = new GMarker(fac_point, fac_icon);
// Show this markers index in the info window when it is clicked
var fac_html = fac_name;
fac_marker.category = type;
fmarkers[id] = fac_marker;
GEvent.addListener(fac_marker, "click", function() {fac_marker.openInfoWindowHtml(fac_html);});
return fac_marker;
}
<?php
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 4 AND `resource_id` = '{$_SESSION['user_id']}';";
// 5/4/11
$result = mysql_query($query);
// 5/4/11
$al_groups = array();
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// 5/4/11
$al_groups[] = $row['group'];
}
if (!isset($_POST['frm_group'])) {
// 5/4/11
$x = 0;
// 5/4/11
$where2 = "WHERE (";
// 5/4/11
foreach ($al_groups as $grp) {
// 5/4/11
$where3 = count($al_groups) > $x + 1 ? " OR " : ")";
$where2 .= "`{$GLOBALS['mysql_prefix']}allocates`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
} else {
$x = 0;
// 5/4/11
$where2 = "WHERE (";
// 5/4/11
foreach ($_POST['frm_group'] as $grp) {
// 5/4/11
$where3 = count($_POST['frm_group']) > $x + 1 ? " OR " : ")";
$where2 .= "`{$GLOBALS['mysql_prefix']}allocates`.`group` = '{$grp}'";
$where2 .= $where3;
$x++;
}
}
$where2 .= "AND `{$GLOBALS['mysql_prefix']}allocates`.`type` = 3";
// 5/4/11
$query_fac = "SELECT *,UNIX_TIMESTAMP(updated) AS updated, `{$GLOBALS['mysql_prefix']}facilities`.id AS fac_id,\n\t\t`{$GLOBALS['mysql_prefix']}facilities`.description AS facility_description, \n\t\t`{$GLOBALS['mysql_prefix']}fac_types`.name AS fac_type_name, \n\t\t`{$GLOBALS['mysql_prefix']}facilities`.name AS facility_name \n\t\tFROM `{$GLOBALS['mysql_prefix']}facilities` \n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` ON ( `{$GLOBALS['mysql_prefix']}facilities`.`id` = `{$GLOBALS['mysql_prefix']}allocates`.resource_id )\t\t\t\n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}fac_types` ON `{$GLOBALS['mysql_prefix']}facilities`.type = `{$GLOBALS['mysql_prefix']}fac_types`.id \n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}fac_status` ON `{$GLOBALS['mysql_prefix']}facilities`.status_id = `{$GLOBALS['mysql_prefix']}fac_status`.id \n\t\t{$where2} \n\t\tGROUP BY fac_id ORDER BY `{$GLOBALS['mysql_prefix']}facilities`.type ASC";
$result_fac = mysql_query($query_fac) or do_error($query_fac, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
// dump($query_fac);
while ($row_fac = mysql_fetch_array($result_fac)) {
$fac_id = $row_fac['fac_id'];
$fac_type = $row_fac['icon'];
$fac_type_name = $row_fac['fac_type_name'];
$fac_name = $row_fac['facility_name'];
// 10/8/09
// $fac_name = $row_fac['name']; // 10/8/09
$fac_temp = explode("/", $fac_name);
// 11/27/09
$fac_index = $row_fac['icon_str'];
print "\t\tvar fac_sym = '{$fac_index}';\n";
// for sidebar and icon 10/8/09
$toroute = is_guest() ? "" : " <A HREF='routes.php?ticket_id=" . $fac_id . "'><U>Dispatch</U></A>";
// 8/2/08
if (is_guest()) {
$facedit = $toroute = $facmail = "";
} else {
$facedit = " <A HREF='facilities.php?func=responder&edit=true&id=" . $row_fac['fac_id'] . "'><U>Edit</U></A>";
$facmail = " <SPAN onClick = do_mail_fac_win('" . $row_fac['fac_id'] . "');><U><B>Email</B></U></SPAN>";
$toroute = " <A HREF='fac_routes.php?fac_id=" . $fac_id . "'><U>Route To Facility</U></A>";
// 8/2/08
}
if (my_is_float($row_fac['lat']) && my_is_float($row_fac['lng'])) {
$f_disp_name = $row_fac['facility_name'];
// 10/8/09
$f_disp_temp = explode("/", $f_disp_name);
$facility_display_name = $f_disp_temp[0];
$fac_tab_1 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$fac_tab_1 .= "<TR CLASS='even'><TD COLSPAN=2 ALIGN='center'><B>" . addslashes(shorten($facility_display_name, 48)) . "</B></TD></TR>";
$fac_tab_1 .= "<TR CLASS='odd'><TD COLSPAN=2 ALIGN='center'><B>" . addslashes(shorten($row_fac['fac_type_name'], 48)) . "</B></TD></TR>";
$fac_tab_1 .= "<TR CLASS='even'><TD ALIGN='right'>Description: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['facility_description'])) . "</TD></TR>";
$fac_tab_1 .= "<TR CLASS='odd'><TD ALIGN='right'>Status: </TD><TD ALIGN='left'>" . addslashes($row_fac['status_val']) . " </TD></TR>";
$fac_tab_1 .= "<TR CLASS='even'><TD ALIGN='right'>Contact: </TD><TD ALIGN='left'>" . addslashes($row_fac['contact_name']) . " Email: " . addslashes($row_fac['contact_email']) . "</TD></TR>";
$fac_tab_1 .= "<TR CLASS='odd'><TD ALIGN='right'>Phone: </TD><TD ALIGN='left'>" . addslashes($row_fac['contact_phone']) . " </TD></TR>";
$fac_tab_1 .= "<TR CLASS='even'><TD ALIGN='right'>As of: </TD><TD ALIGN='left'> " . format_date($row_fac['updated']) . "</TD></TR>";
$fac_tab_1 .= "</TABLE>";
$fac_tab_2 = "<TABLE CLASS='infowin' width='" . $_SESSION['scr_width'] / 4 . "'>";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Security contact: </TD><TD ALIGN='left'>" . addslashes($row_fac['security_contact']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Security email: </TD><TD ALIGN='left'>" . addslashes($row_fac['security_email']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Security phone: </TD><TD ALIGN='left'>" . addslashes($row_fac['security_phone']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Access rules: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['access_rules'])) . "</TD></TR>";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Security reqs: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['security_reqs'])) . "</TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Opening hours: </TD><TD ALIGN='left'>" . addslashes(str_replace($eols, " ", $row_fac['opening_hours'])) . "</TD></TR>";
$fac_tab_2 .= "<TR CLASS='odd'><TD ALIGN='right'>Prim pager: </TD><TD ALIGN='left'>" . addslashes($row_fac['pager_p']) . " </TD></TR>";
$fac_tab_2 .= "<TR CLASS='even'><TD ALIGN='right'>Sec pager: </TD><TD ALIGN='left'>" . addslashes($row_fac['pager_s']) . " </TD></TR>";
$fac_tab_2 .= "</TABLE>";
?>
// var fac_sym = (g + 1).toString();
var myfacinfoTabs = [
new GInfoWindowTab("<?php
print nl2brr(addslashes(shorten($row_fac['facility_name'], 10)));
?>
", "<?php
print $fac_tab_1;
?>
"),
new GInfoWindowTab("More ...", "<?php
print str_replace($eols, " ", $fac_tab_2);
?>
")
];
<?php
if ($row_fac['lat'] == 0.999999 && $row_fac['lng'] == 0.999999) {
// check for facilities entered in no maps mode 7/28/10
echo "var fac_icon = new GIcon(baseIcon);\n";
echo "var fac_type = {$fac_type};\n";
echo "var fac_type_name = \"{$fac_type_name}\";\n";
echo "var fac_icon_url = \"./our_icons/question1.png\";\n";
echo "fac_icon.image = fac_icon_url;\n";
echo "var fac_point = new GLatLng(" . get_variable('def_lat') . "," . get_variable('def_lng') . ");\n";
echo "var fac_marker = createfacMarker(fac_point, myfacinfoTabs, g, fac_icon, fac_type_name);\n";
echo "map.addOverlay(fac_marker);\n";
echo "\n";
} else {
echo "var fac_icon = new GIcon(baseIcon);\n";
echo "var fac_type = {$fac_type};\n";
echo "var fac_type_name = \"{$fac_type_name}\";\n";
echo "var fac_icon_url = \"./our_icons/gen_fac_icon.php?blank={$fac_type}&text=\" + (fac_sym) + \"\";\n";
echo "fac_icon.image = fac_icon_url;\n";
echo "var fac_point = new GLatLng(" . $row_fac['lat'] . "," . $row_fac['lng'] . ");\n";
echo "var fac_marker = createfacMarker(fac_point, myfacinfoTabs, g, fac_icon, fac_type_name);\n";
echo "map.addOverlay(fac_marker);\n";
echo "\n";
}
?>
if (fac_marker.isHidden()) {
fac_marker.show();
} else {
fac_marker.hide();
}
<?php
}
// end if my_is_float
?>
g++;
<?php
}
// end while
//}
// =====================================End of functions to show facilities========================================================================
for ($i = 0; $i < count($kml_olays); $i++) {
// emit kml overlay calls
echo "\t\t" . $kml_olays[$i] . "\n";
}
?>
function add_hash(in_str) { // prepend # if absent
return (in_str.substr(0,1)=="#")? in_str : "#" + in_str;
}
function do_landb() { // JS function - 8/1/11
var points = new Array();
<?php
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}mmarkup` WHERE `line_status` = 0 AND (`use_with_bm` = 1 OR `use_with_r` = 1)";
$result = mysql_query($query) or do_error($query, $query, mysql_error(), basename(__FILE__), __LINE__);
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
$empty = FALSE;
extract($row);
$name = $row['line_name'];
switch ($row['line_type']) {
case "p":
// poly
$points = explode(";", $line_data);
echo "\n\tvar points = new Array();\n";
for ($i = 0; $i < count($points); $i++) {
$coords = explode(",", $points[$i]);
?>
var thepoint = new GLatLng(<?php
print $coords[0];
?>
, <?php
print $coords[1];
?>
);
bounds.extend(thepoint);
points.push(thepoint);
<?php
}
// end for ($i = 0 ... )
if (intval($filled) == 1 && count($points) > 2) {
?>
var polyline = new GPolygon(points,add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
,add_hash("<?php
print $fill_color;
?>
"), <?php
print $fill_opacity;
?>
);
<?php
} else {
?>
var polyline = new GPolyline(points, add_hash("<?php
print $line_color;
?>
"), <?php
print $line_width;
?>
, <?php
print $line_opacity;
?>
);
<?php
}
?>
map.addOverlay(polyline);
<?php
break;
case "c":
// circle
$temp = explode(";", $line_data);
$radius = $temp[1];
$coords = explode(",", $temp[0]);
$lat = $coords[0];
$lng = $coords[1];
$fill_opacity = intval($filled) == 0 ? 0 : $fill_opacity;
echo "\n drawCircle({$lat}, {$lng}, {$radius}, add_hash('{$line_color}'), {$line_width}, {$line_opacity}, add_hash('{$fill_color}'), {$fill_opacity}); // 513\n";
break;
case "t":
// text banner
$temp = explode(";", $line_data);
$banner = $temp[1];
$coords = explode(",", $temp[0]);
echo "\n var point = new GLatLng(parseFloat({$coords[0]}) , parseFloat({$coords[1]}));\n";
$the_banner = htmlentities($banner, ENT_QUOTES);
$the_width = intval(trim($line_width), 10);
// font size
echo "\n drawBanner( point, '{$the_banner}', '{$the_banner}', {$the_width});\n";
break;
}
// end switch
}
// end while ()
unset($query, $result);
?>
} // end function do_landb()
/*
try {
do_landb(); // 7/3/11 - show lines
}
catch (e) { }
*/
if (!(map_is_fixed)){
if (!points) { // any?
map.setCenter(new GLatLng(<?php
echo get_variable('def_lat');
?>
, <?php
echo get_variable('def_lng');
?>
), <?php
echo get_variable('def_zoom');
?>
);
}
else {
center = bounds.getCenter();
zoom = map.getBoundsZoomLevel(bounds);
map.setCenter(center,zoom);
} // end if/else (!points)
} // end if (!(map_is_fixed))
side_bar_html = "";
<?php
if (!empty($fac_categories)) {
?>
side_bar_html= "<form action='#'>"; // 12/03/10
<?php
function get_fac_icon($fac_cat)
{
// returns legend string
$icons = $GLOBALS['fac_icons'];
$sm_fac_icons = $GLOBALS['sm_fac_icons'];
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}fac_types` WHERE `name` = \"{$fac_cat}\"";
// types in use
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$print = "";
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
$fac_icon = $row['icon'];
$print .= "<IMG SRC = './our_icons/" . $sm_fac_icons[$fac_icon] . "' STYLE = 'vertical-align: middle'>";
}
unset($result);
return $print;
}
foreach ($fac_categories as $key => $value) {
// 12/03/10
$curr_icon = get_fac_icon($value);
?>
side_bar_html += "<DIV class='cat_button_fs' onClick='set_fac_chkbox(\"<?php
print $value;
?>
\")'><?php
print get_fac_icon($value);
?>
<?php
print $value;
?>
: <input type=checkbox id='<?php
print $value;
?>
' onClick='set_fac_chkbox(\"<?php
print $value;
?>
\")'/></DIV>"; <!-- 12/03/10 -->
<?php
}
$all = "fac_ALL";
// 12/03/10
$none = "fac_NONE";
// 12/03/10
?>
side_bar_html += "<DIV ID = 'fac_ALL_BUTTON' class='cat_button_fs' onClick='set_fac_chkbox(\"<?php
print $all;
?>
\")'><FONT COLOR = 'red'>ALL</FONT><input type=checkbox id='<?php
print $all;
?>
' onClick='set_fac_chkbox(\"<?php
print $all;
?>
\")'/></FONT></DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'fac_NONE_BUTTON' class='cat_button_fs' onClick='set_fac_chkbox(\"<?php
print $none;
?>
\")'><FONT COLOR = 'red'>NONE</FONT><input type=checkbox id='<?php
print $none;
?>
' onClick='set_fac_chkbox(\"<?php
print $none;
?>
\")'/></FONT></DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'fac_go_can' style='float:middle; padding:2px;'><SPAN ID = 'fac_go_button' onClick='do_go_facilities_button()' class='conf_next_button' STYLE = 'display:none;'><U>Next</U></SPAN>";
side_bar_html += "<SPAN ID = 'fac_can_button' onClick='fac_cancel_buttons()' class='conf_can_button' STYLE = 'display:none;'><U>Cancel</U></SPAN></DIV>";
side_bar_html+="</form>"; <!-- 12/03/10 -->
$("fac_boxes").innerHTML = side_bar_html; // 12/03/10 side_bar_html to responders div
<?php
} else {
?>
side_bar_html= ""; // 12/03/10
side_bar_html += "<DIV class='cat_button' style='color: red;'>None Defined ! </DIV>"; <!-- 12/03/10 -->
<?php
$all = "fac_ALL";
// 12/03/10
$none = "fac_NONE";
// 12/03/10
?>
side_bar_html += "<DIV ID = 'fac_ALL_BUTTON' class='cat_button' style='display: none;'><input type=checkbox id='<?php
print $all;
?>
'/><input type=checkbox id='fac_ALL' style='display: none'></DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'fac_NONE_BUTTON' class='cat_button' style='display: none;'><input type=checkbox id='<?php
print $none;
?>
'/><input type=checkbox id='fac_NONE' style='display: none'></DIV>"; <!-- 12/03/10 -->
side_bar_html += "<DIV ID = 'fac_go_can' style='float:right; padding:2px; display: none'><SPAN ID = 'fac_go_button' class='conf_next_button' STYLE = 'display:none;'><U>Next</U></SPAN>";
side_bar_html += "<SPAN ID = 'fac_can_button' class='conf_can_button' STYLE = 'display:none;'><U>Cancel</U></SPAN></DIV>";
side_bar_html+="</form>"; <!-- 12/03/10 -->
$("fac_boxes").innerHTML = side_bar_html; // 12/03/10 side_bar_html to responders div
<?php
}
?>
// =============================================================================================================
} // end if (GBrowserIsCompatible())
else {
alert("Sorry, browser compatibility problem. Contact your tech support group.");
}
</SCRIPT>
<?php
}
function do_list($unit_id = "", $capabilities = "", $searchtype)
{
global $row_ticket, $dispatches_disp, $dispatches_act, $from_top, $from_left, $eol, $sidebar_width;
switch ($row_ticket['severity']) {
//color tickets by severity
case $GLOBALS['SEVERITY_MEDIUM']:
$severityclass = 'severity_medium';
break;
case $GLOBALS['SEVERITY_HIGH']:
$severityclass = 'severity_high';
break;
default:
$severityclass = '';
break;
}
$query = "SELECT *,UNIX_TIMESTAMP(problemstart) AS problemstart,UNIX_TIMESTAMP(problemend) AS problemend,UNIX_TIMESTAMP(booked_date) AS booked_date,\n\t\tUNIX_TIMESTAMP(date) AS date,UNIX_TIMESTAMP(`{$GLOBALS['mysql_prefix']}ticket`.`updated`) AS updated, `{$GLOBALS['mysql_prefix']}ticket`.`description` AS `tick_descr` FROM `{$GLOBALS['mysql_prefix']}ticket` \n\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}in_types` `ty` ON (`{$GLOBALS['mysql_prefix']}ticket`.`in_types_id` = `ty`.`id`)\t\t\n\t\tWHERE `{$GLOBALS['mysql_prefix']}ticket`.`id`= " . quote_smart($_GET['ticket_id']) . " LIMIT 1";
// 7/24/09 10/16/08 Incident location 09/25/09 Pre Booking
// print __LINE__;
// dump($query);
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_ticket = stripslashes_deep(mysql_fetch_array($result));
$facility = $row_ticket['facility'];
$rec_fac = $row_ticket['rec_facility'];
$lat = $row_ticket['lat'];
$lng = $row_ticket['lng'];
$problemstart = $row_ticket['problemstart'];
$problemend = $row_ticket['problemend'];
// dump(mysql_format_date($row_ticket['problemstart']));
// print "var thelat = " . $lat . ";\nvar thelng = " . $lng . ";\n"; // set js-accessible location data
unset($result);
if ($rec_fac > 0) {
$query_rfc = "SELECT * FROM `{$GLOBALS['mysql_prefix']}facilities` WHERE `id`= {$rec_fac} ";
// 7/24/09 10/16/08 Incident location 10/06/09 Multi point routing
$result_rfc = mysql_query($query_rfc) or do_error($query_rfc, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$row_rec_fac = stripslashes_deep(mysql_fetch_array($result_rfc));
$rf_lat = $row_rec_fac['lat'];
$rf_lng = $row_rec_fac['lng'];
$rf_name = $row_rec_fac['name'];
// print "var thereclat = " . $rf_lat . ";\nvar thereclng = " . $rf_lng . ";\n"; // set js-accessible location data for receiving facility
} else {
// print "var thereclat;\nvar thereclng;\n"; // set js-accessible location data for receiving facility
}
?>
<SCRIPT>
var color=0;
var last_from;
var last_to;
var rec_fac;
var current_id; // 10/25/08
var output_direcs = ""; //10/6/09
var have_direcs = 0; //10/6/09
var tick_name = '<?php
print $row_ticket['scope'];
?>
'; //10/29/09
var colors = new Array ('odd', 'even');
var Direcs = null; // global
var Now;
var mystart;
var myend;
function do_sidebar(sidebar, color, id, unit_id) { // No map
var letter = ""+ id; // start with 1 - 1/5/09 - 1/29/09
marker = null;
gmarkers[id] = null; // marker to array for side bar click function
side_bar_html += "<TR ID = '_tr" + id + "' CLASS='" + colors[(id)%2] +"' VALIGN='bottom' onClick = myclick(" + id + "," + unit_id +");><TD>";
side_bar_html += "<IMG BORDER=0 SRC='rtarrow.gif' ID = \"R" + id + "\" STYLE = 'visibility:hidden;'></TD>";
var letter = ""+ id; // start with 1 - 1/5/09 - 1/29/09
// var the_class = (direcs[id])? "emph" : "td_label";
var the_class = (lats[id])? "emph" : "td_label";
side_bar_html += "<TD CLASS='" + the_class + "'>" + letter + " "+ sidebar +"</TD></TR>\n";
return null;
} // end function create Marker()
function myclick(id, unit_id) { // responds to side bar click
// alert (821);
var norecfac = "";
if (document.getElementById(current_id)) {
document.getElementById(current_id).style.visibility = "hidden"; // hide last check if defined
}
current_id= "R"+id;
document.getElementById(current_id).style.visibility = "visible"; // show newest
} // end function my click(id)
function handleErrors(){ //G_GEO_UNKNOWN_DIRECTIONS
if (gdir.getStatus().code == G_GEO_UNKNOWN_DIRECTIONS ) {
alert("501: directions unavailable\n\nClick map point for directions.");
}
else if (gdir.getStatus().code == G_GEO_UNKNOWN_ADDRESS)
alert("440: No corresponding geographic location could be found for one of the specified addresses. This may be due to the fact that the address is relatively new, or it may be incorrect.\nError code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_SERVER_ERROR)
alert("442: A map request could not be processed, reason unknown.\n Error code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_MISSING_QUERY)
alert("444: Technical error.\n Error code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_BAD_KEY)
alert("448: The given key is either invalid or does not match the domain for which it was given. \n Error code: " + gdir.getStatus().code);
else if (gdir.getStatus().code == G_GEO_BAD_REQUEST)
alert("450: A directions request could not be successfully parsed.\n Error code: " + gdir.getStatus().code);
else alert("451: An unknown error occurred.");
} // end function handleErrors()
function onGDirectionsLoad(){
// var temp = gdir.getSummaryHtml();
} // function onGDirectionsLoad()
function guest () {
alert ("Demonstration only. Guests may not commit dispatch!");
}
function validate(){ // frm_id_str
msgstr="";
for (var i =1;i<unit_sets.length;i++) { // 3/30
if (unit_sets[i]) {
msgstr+=unit_names[i]+"\n";
document.routes_Form.frm_id_str.value += unit_ids[i] + "|";
}
}
if (msgstr.length==0) {
var more = (nr_units>1)? "s": ""
alert ("Please select unit" + more + ", or cancel");
return false;
}
else {
var quick = <?php
print intval(get_variable("quick") == 1) ? "true;\n" : "false;\n";
?>
// if (confirm ("Please confirm Unit dispatch as follows\n\n" + msgstr)) {
if ((quick) || (confirm ("Please confirm unit dispatch\n\n" + msgstr))) { // 11/23/09
document.routes_Form.frm_id_str.value = document.routes_Form.frm_id_str.value.substring(0, document.routes_Form.frm_id_str.value.length - 1); // drop trailing separator
document.routes_Form.frm_name_str.value = msgstr; // for re-use
document.routes_Form.submit();
document.getElementById("outer").style.display = "none";
document.getElementById("bottom").style.display = "block";
}
else {
document.routes_Form.frm_id_str.value="";
return false;
}
}
} // end function validate()
function exists(myarray,myid) {
var str_key = " " + myid; // force associative
return ((typeof myarray[str_key])!="undefined"); // exists if not undefined
} // end function exists()
var icons=[]; // note globals
<?php
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}unit_types` ORDER BY `id`";
// types in use
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
$icons = $GLOBALS['icons'];
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// map type to blank icon id
$blank = $icons[$row['icon']];
print "\ticons[" . $row['id'] . "] = " . $row['icon'] . ";\n";
//
}
unset($result);
?>
var side_bar_html = "<TABLE border=0 CLASS='sidebar' ID='tbl_responders' STYLE = 'WIDTH: <?php
print $sidebar_width;
?>
px;'>";
var gmarkers = [];
var lats = [];
var lngs = [];
var distances = [];
var unit_names = []; // names
var unit_sets = []; // settings
var unit_ids = []; // id's
var unit_assigns = []; // unit id's assigned this incident
var direcs = []; // if true, do directions - 7/13/09
var which; // marker last selected
var i = 0; // sidebar/icon index
var nr_units = 0;
var email= false;
<?php
function get_cd_str($in_row)
{
// unit row in,
global $unit_id;
// 11/18/10
// // first, already on this run?
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = " . quote_smart($_GET['ticket_id']) . "\n\t\t\t\t\t AND (`responder_id`={$in_row['unit_id']}) \n\t\t\t\t\t AND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00')) LIMIT 1;";
// 6/25/10
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
return " CHECKED DISABLED ";
}
if ($unit_id != "" && (mysql_affected_rows() != 1 || mysql_affected_rows() == 1 && intval($in_row['multi']) == 1)) {
print "checked";
return " CHECKED ";
}
// 12/18/10 - Checkbox checked here individual unit seleted.
if (intval($in_row['dispatch']) == 2) {
return " DISABLED ";
}
// 2nd, disallowed - 5/30/10
if (intval($in_row['multi']) == 1) {
return "";
}
// 3rd, allowed
// 3rd, on another run?
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}assigns` \n\t\t\t\t\tWHERE `responder_id`={$in_row['unit_id']} \n\t\t\t\t\tAND ((`clear` IS NULL) OR (DATE_FORMAT(`clear`,'%y') = '00'))\n\t\t\t\t\tLIMIT 1;";
// 6/25/10
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
return " DISABLED ";
} else {
return "";
}
}
// function get cd_str($in_row)
$eols = array("\r\n", "\n", "\r");
// all flavors of eol
// build js array of responders to this ticket - possibly none
$query = "SELECT `ticket_id`, `responder_id` FROM `{$GLOBALS['mysql_prefix']}assigns` WHERE `ticket_id` = " . quote_smart($_GET['ticket_id']);
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
while ($assigns_row = stripslashes_deep(mysql_fetch_array($result))) {
print "\t\tunit_assigns[' '+ " . $assigns_row['responder_id'] . "]= true;\n";
// note string forced
}
print "\n";
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}ticket` WHERE `id`=" . quote_smart($_GET['ticket_id']) . " LIMIT 1;";
// 4/5/10
$result_pos = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() == 1) {
$row_position = stripslashes_deep(mysql_fetch_array($result_pos));
$latitude = $row_position['lat'];
$longitude = $row_position['lng'];
unset($result_pos);
} else {
// dump ($query);
}
$where = empty($unit_id) ? "" : " AND `r`.`id` = {$unit_id} ";
// revised 5/23/08 per AD7PE
if (empty($unit_id)) {
// 11/18/10
$where2 = empty($capabilities) ? "" : " AND (";
// 11/18/10
$searchitems = empty($capabilities) ? "" : explode(" ", $capabilities);
if ($searchitems) {
for ($j = 0; $j < count($searchitems); $j++) {
if ($j + 1 != count($searchitems)) {
$where2 .= "`{$GLOBALS['mysql_prefix']}responder`.`capab` LIKE '%{$searchitems[$j]}%' {$searchtype} ";
} else {
$where2 .= "`{$GLOBALS['mysql_prefix']}responder`.`capab` LIKE '%{$searchitems[$j]}%')";
}
}
}
} else {
$where2 = "";
}
// ============================= Regions Stuff
// Allows Tickets to be dispatched to any responders in the same region as the current user.
// $query = "SELECT * FROM `$GLOBALS[mysql_prefix]allocates` WHERE `type`= 4 AND `resource_id` = '$_SESSION[user_id]' ORDER BY `id` ASC;"; // 4/18/11
// $result = mysql_query($query); // 5/4/11
// $al_groups = array();
// $al_names = "";
// while ($row = stripslashes_deep(mysql_fetch_assoc($result))) { // 5/4/11
// $al_groups[] = $row['group'];
// $query2 = "SELECT * FROM `$GLOBALS[mysql_prefix]region` WHERE `id`= '$row[group]';"; // 5/4/11
// $result2 = mysql_query($query2); // 5/4/11
// while ($row2 = stripslashes_deep(mysql_fetch_assoc($result2))) { // 5/4/11
// $al_names .= $row2['group_name'] . ", ";
// }
// }
// if(isset($_SESSION['viewed_groups'])) {
// $al_groups= explode(",",$_SESSION['viewed_groups']);
// }
// if(!isset($_SESSION['viewed_groups'])) { // 5/4/11
// $x=0;
// $where3 = "AND (";
// foreach($al_groups as $grp) {
// $where4 = (count($al_groups) > ($x+1)) ? " OR " : ")";
// $where3 .= "`a`.`group` = '{$grp}'";
// $where3 .= $where4;
// $x++;
// }
// } else {
// $x=0;
// $where3 = "AND (";
// foreach($al_groups as $grp) {
// $where4 = (count($al_groups) > ($x+1)) ? " OR " : ")";
// $where3 .= "`a`.`group` = '{$grp}'";
// $where3 .= $where4;
// $x++;
// }
// }
// $where3 .= " AND `a`.`type` = 2";
// Replacement code - only allows Tickets to be dispatched to responders in the same region
$query = "SELECT * FROM `{$GLOBALS['mysql_prefix']}allocates` WHERE `type`= 1 AND `resource_id` = " . quote_smart($_GET['ticket_id']) . " ORDER BY `id` ASC;";
// 4/18/11
$result = mysql_query($query);
// 5/4/11
$al_groups = array();
$al_names = "";
while ($row = stripslashes_deep(mysql_fetch_assoc($result))) {
// 5/4/11
$al_groups[] = $row['group'];
$query2 = "SELECT * FROM `{$GLOBALS['mysql_prefix']}region` WHERE `id`= '{$row['group']}';";
// 5/4/11
$result2 = mysql_query($query2);
// 5/4/11
while ($row2 = stripslashes_deep(mysql_fetch_assoc($result2))) {
// 5/4/11
$al_names .= $row2['group_name'] . ", ";
}
}
$x = 0;
$where3 = "WHERE (";
foreach ($al_groups as $grp) {
$where4 = count($al_groups) > $x + 1 ? " OR " : ")";
$where3 .= "`a`.`group` = '{$grp}'";
$where3 .= $where4;
$x++;
}
$where3 .= " AND (`a`.`type` = 2)";
// ================================ end of regions stuff
// 4/5/10
$query = "SELECT *, UNIX_TIMESTAMP(`updated`) AS `updated`,\n\t\t\t`r`.`id` AS `unit_id`, \n\t\t\t`s`.`status_val` AS `unitstatus`, `contact_via`, \n\t\t\t(POW(ABS({$latitude} - `r`.`lat`), 2.0) + POW(ABS({$longitude} - `r`.`lng`), 2.0)) AS `distance`\t\t\t\n\t\t\tFROM `{$GLOBALS['mysql_prefix']}responder` `r`\n\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}un_status` `s` ON (`r`.`un_status_id` = `s`.`id`)\n\t\t\tLEFT JOIN `{$GLOBALS['mysql_prefix']}allocates` `a` ON (`r`.`id` = `a`.`resource_id`)\t\t\t\t\t\n\t\t\t{$where3} {$where} {$where2} GROUP BY unit_id\n\t\t\tORDER BY `distance` ASC, `handle` ASC, `name` ASC, `unit_id` ASC";
// 12/09/09
// print $query;
$result = mysql_query($query) or do_error($query, 'mysql query failed', mysql_error(), basename(__FILE__), __LINE__);
if (mysql_affected_rows() > 0) {
$end_date = intval($problemend) > 1 ? $problemend : time() - get_variable('delta_mins') * 60;
// dump(mysql_format_date($problemstart));
// dump(mysql_format_date($end_date));
$elapsed = my_date_diff($problemstart, $end_date);
// 5/13/10
?>
side_bar_html += "<TR class='even'> <TD CLASS='<?php
print $severityclass;
?>
' COLSPAN=99 ALIGN='center'><B>To Incident: <I><?php
print shorten($row_ticket['scope'], 20) . "</I> (" . $elapsed;
?>
)</B></TD></TR>\n";
side_bar_html += "<TR class='odd' STYLE = 'white-space:nowrap;'><TD COLSPAN=3></TD><TD ALIGN='center'>Unit</TD><TD ALIGN='center'>Call</TD><TD ALIGN='center'>Status</TD><TD ALIGN='center'>As of</TD></TR>\n";
<?php
// major while ... for RESPONDER data starts here
$i = $k = 1;
// sidebar/icon index
while ($unit_row = stripslashes_deep(mysql_fetch_assoc($result))) {
// 7/13/09
$has_coords = my_is_float($unit_row['lat']) && my_is_float($unit_row['lng']);
// 2/25/09, 7/7/09
$has_rem_source = intval($unit_row['aprs']) == 1 || intval($unit_row['instam']) == 1 || intval($unit_row['locatea']) == 1 || intval($unit_row['gtrack']) == 1 || intval($unit_row['glat']) == 1;
// 11/15/09
if (is_email($unit_row['contact_via'])) {
print "\t\temail= true\n";
}
?>
nr_units++;
var i = <?php
print $i;
?>
; // top of loop
unit_names[i] = "<?php
print addslashes($unit_row['name']);
?>
"; // unit name 8/25/08, 4/27/09
unit_sets[i] = false; // pre-set checkbox settings
unit_preselected = "<?php
print $unit_id;
?>
";
if (unit_preselected != "") {
unit_sets[i] = true; // pre-set checkbox settings
} else {
unit_sets[i] = false;
}
unit_ids[i] = <?php
print $unit_row['unit_id'];
?>
;
new_element = document.createElement("input"); // please don't ask!
new_element.setAttribute("type", "checkbox");
new_element.setAttribute("name", "unit_<?php
print $unit_row['unit_id'];
?>
");
new_element.setAttribute("id", "element_id");
new_element.setAttribute("style", "visibility:hidden");
document.forms['routes_Form'].appendChild(new_element);
var dist_mi = "na";
var multi = <?php
print intval($unit_row['multi']) == 1 ? "true;\n" : "false;\n";
?>
// 5/22/09
<?php
$dispatched_to = array_key_exists($unit_row['unit_id'], $dispatches_disp) ? $dispatches_disp[$unit_row['unit_id']] : "";
?>
sidebar_line = "<TD ALIGN='center'><INPUT TYPE='checkbox' <?php
print get_cd_str($unit_row);
?>
NAME = 'unit_" + <?php
print $unit_row['unit_id'];
?>
+ "' onClick='unit_sets[<?php
print $i;
?>
]=this.checked;'></TD>";
sidebar_line += "<TD TITLE = \"<?php
print addslashes($unit_row['name']);
?>
\">";
sidebar_line += "<NOBR><?php
print shorten($unit_row['name'], 20);
?>
</NOBR></TD>";
sidebar_line += "<TD><NOBR><?php
print shorten(addslashes($dispatched_to), 20);
?>
</NOBR></TD>";
sidebar_line += "<TD TITLE = \"<?php
print $unit_row['unitstatus'];
?>
\" CLASS='td_data'><?php
print shorten($unit_row['unitstatus'], 12);
?>
</TD>";
sidebar_line += "<TD CLASS='td_data'><?php
print substr(format_sb_date($unit_row['updated']), 4);
?>
</TD>";
<?php
print "\n\t\t\t\tdo_sidebar(sidebar_line, color, i);\n";
$i++;
$k++;
}
// end major while ($unit_row = ...) for each responder
print "\t\t var start = 1;\n";
// already sorted - 3/24/10
} else {
print "\t\t var start = 0;\n";
// already sorted - 3/24/10
}
// responders complete
?>
if (nr_units==0) {
side_bar_html +="<TR CLASS='odd'><TD ALIGN='center' COLSPAN=99><BR /><BR /><H3>No Units!</H3></TD></TR>";
}
else {
side_bar_html+= "<TR CLASS='" + colors[i%2] +"'><TD COLSPAN=99> </TD></TR>\n";
side_bar_html+= "<TR CLASS='" + colors[(i+1)%2] +"'><TD COLSPAN=99 ALIGN='center'><B>M</B>obility: stopped: <FONT COLOR='red'><B>•</B></FONT> moving: <FONT COLOR='green'><B>•</B></FONT> fast: <FONT COLOR='white'><B>•</B></FONT> silent: <FONT COLOR='black'><B>•</B></FONT></TD></TR>\n";
side_bar_html+= "<TR><TD> </TD></TR>\n";
}
side_bar_html +="</TABLE>\n";
document.getElementById("side_bar").innerHTML = side_bar_html; // put the assembled side_bar_html contents into the side bar div
if (start>0) {
var current_id= "R"+start; //
document.getElementById(current_id).style.visibility = "visible"; // show link check image at the selected sidebar el ement
location.href = "#top"; // 11/12/09
}
</SCRIPT>
<?php
}
