MyWay timeliness by stop/route
[busui.git] / labs / myway_timeliness_stop.php
blob:a/labs/myway_timeliness_stop.php -> blob:b/labs/myway_timeliness_stop.php
  <?php
  include ('../include/common.inc.php');
  include_header("MyWay Deltas", "mywayDelta");
  ?>
   
  <!--[if lte IE 8]><script language="javascript" type="text/javascript" src="../js/flot/excanvas.min.js"></script><![endif]-->
   
  <script language="javascript" type="text/javascript" src="../js/flot/jquery.flot.js"></script>
  <form method="get" action="">
  <select id="stopid" name="stopid">
  <?php
  $query = "select distinct myway_stop from myway_stops where myway_stop != '' order by myway_stop";
  $query = $conn->prepare($query);
  $query->execute();
  if (!$query) {
  databaseError($conn->errorInfo());
  return Array();
  }
  foreach ($query->fetchAll() as $stop) {
  echo "<option value=\"{$stop['myway_stop']}\">{$stop['myway_stop']}</option>";
   
  };
  ?> </select> <center><div id="placeholder" style="width:900px;height:550px"></div></center>
  <script type="text/javascript">
  $(function () {
  var d = new Date();
  d.setUTCMinutes(0);
  d.setUTCHours(0);
  var midnight = d.getTime();
   
  var placeholder = $("#placeholder");
  var data = [];
  var options = {
  xaxis: {
  mode: "time",
  min: midnight + (1000*60*60*8),
  max: midnight + (1000*60*60*23.5)
  },
  yaxis: {
  tickFormatter: yformatter
  },
  grid: { hoverable: true, clickable: true, labelMargin: 32 },
  };
   
  var plot = $.plot(placeholder, data, options);
  var o;
  o = plot.pointOffset({ x: midnight+ (9*60*60*1000), y: -1.2});
  placeholder.append('<div style="position:absolute;left:' + (o.left + 4) + 'px;top:' + o.top + 'px;color:#666;font-size:smaller">9am</div>');
  o = plot.pointOffset({ x: midnight+ (16*60*60*1000), y: -1.2});
  placeholder.append('<div style="position:absolute;left:' + (o.left + 4) + 'px;top:' + o.top + 'px;color:#666;font-size:smaller">4pm</div>');
  // fetch one series, adding to what we got
  var alreadyFetched = {};
   
  $("#stopid").change(function () {
  var select = $(this);
   
  // find the URL in the link right next to us
  // var dataurl = button.siblings('a').attr('href');
  var dataurl = "myway_timeliness_stop.json.php?stopid=" + select.val();
  // then fetch the data with jQuery
  function onDataReceived(series) {
  // extract the first coordinate pair so you can see that
  // data is now an ordinary Javascript object
  var firstcoordinate = '(' + series.data[0][0] + ', ' + series.data[0][1] + ')';
   
   
  // let's add it to our current data
  if (!alreadyFetched[series.label]) {
  alreadyFetched[series.label] = true;
  data.push(series);
  }
   
  // and plot all we got
  $.plot(placeholder, data, options);
  }
   
  $.ajax({
  url: dataurl,
  method: 'GET',
  dataType: 'json',
  success: onDataReceived
  });
  });
   
  });
  function yformatter(v) {
  if (Math.floor(v/60) < -9) return "";
  return Math.abs(Math.floor(v/60)) + " min " + (v == 0 ? "" : (v >0 ? "early":"late"))
  }
  function showTooltip(x, y, contents) {
  $('<div id="tooltip">' + contents + '</div>').css( {
  position: 'absolute',
  display: 'none',
  top: y + 5,
  left: x + 5,
  border: '1px solid #fdd',
  padding: '2px',
  'background-color': '#fee',
  opacity: 0.80
  }).appendTo("body").fadeIn(200);
  }
   
  var previousPoint = null;
  $("#placeholder").bind("plothover", function (event, pos, item) {
  $("#x").text(pos.x.toFixed(2));
  $("#y").text(pos.y.toFixed(2));
   
  if (item) {
  if (previousPoint != item.dataIndex) {
  previousPoint = item.dataIndex;
   
  $("#tooltip").remove();
  var x = item.datapoint[0].toFixed(2),
  y = item.datapoint[1].toFixed(2);
   
  var d = new Date();
  d.setTime(x);
  var time = d.getUTCHours() +':'+ (d.getUTCMinutes().toString().length == 1 ? '0'+ d.getMinutes(): d.getUTCMinutes())
   
   
  showTooltip(item.pageX, item.pageY,
  item.series.label + " at "+ time +" = " + Math.abs(new Number(y/60).toFixed(2))+" minutes "+(y >0 ? "early":"late"));
  }
  }
  else {
  $("#tooltip").remove();
  previousPoint = null;
  }
  });
   
  </script>