incident-detailed.php

   1 <?php
   2 require_once('require/class.Connection.php');
   3 require_once('require/class.Accident.php');
   4 require_once('require/class.Language.php');
   5 $Accident = new Accident();
   6 $title = _("Latest incidents");
   7 require_once('header.php');
   8 $page_url = $globalURL.'/incident-detailed';
   9 if (!isset($_GET['date']))
  10 {
  11         $date = date('Y-m-d');
  12 } else {
  13         $date = filter_input(INPUT_GET,'date',FILTER_SANITIZE_STRING);
  14 }
  15
  16 if(!isset($_GET['limit']))
  17 {
  18         $limit_start = 0;
  19         $limit_end = 25;
  20         $absolute_difference = 25;
  21 } else {
  22         $limit_explode = explode(",", $_GET['limit']);
  23         $limit_start = $limit_explode[0];
  24         $limit_end = $limit_explode[1];
  25         if (!ctype_digit(strval($limit_start)) || !ctype_digit(strval($limit_end))) {
  26                 $limit_start = 0;
  27                 $limit_end = 25;
  28         }
  29 }
  30 $absolute_difference = abs($limit_start - $limit_end);
  31 $limit_next = $limit_end + $absolute_difference;
  32 $limit_previous_1 = $limit_start - $absolute_difference;
  33 $limit_previous_2 = $limit_end - $absolute_difference;
  34
  35 print '<div class="select-item">';
  36 print '<form action="'.$globalURL.'/incident" method="post" class="form-inline">';
  37 print '<div class="form-group">';
  38 print '<label for="datepickeri">'._("Select a Date").'</label>';
  39 print '<div class="input-group date" id="datepicker">';
  40 print '<input type="text" class="form-control" id="datepickeri" name="date" value="" />';
  41 print '<span class="input-group-addon"><span class="glyphicon glyphicon-calendar"></span></span>';
  42 print '</div>';
  43 print '<button type="submit"><i class="fa fa-angle-double-right"></i></button>';
  44 print '</div>';
  45 print '</form>';
  46 print '</div>';
  47 print '<script type="text/javascript">$(function () { $("#datepicker").datetimepicker({ format: "YYYY-MM-DD", defaultDate: "'.$date.'" }); }); </script>';
  48 print '<br />';
  49
  50 print '<div class="info column">';
  51 print '<h1>'.sprintf(_("Incidents from %s"),date("l F j, Y",strtotime($date))).'</h1>';
  52 print '</div>';
  53
  54 print '<div class="table column">';
  55 print '<p>'.sprintf(_("The table below shows the Incidents on <strong>%s</strong>."),date("l M j, Y",strtotime($date))).'</p>';
  56 $spotter_array = $Accident->getAccidentData($limit_start.",".$absolute_difference,'incident',$date);
  57 //print_r($spotter_array);
  58 if (!empty($spotter_array) && isset($spotter_array[0]['query_number_rows']) && $spotter_array[0]['query_number_rows'] != 0) {
  59         include('table-output.php');
  60         print '<div class="pagination">';
  61         if ($limit_previous_1 >= 0) print '<a href="'.$page_url.'/'.$date.'/'.$limit_previous_1.','.$limit_previous_2.'">&laquo;'._("Previous Page").'</a>';
  62         if ($spotter_array[0]['query_number_rows'] == $absolute_difference) print '<a href="'.$page_url.'/'.$date.'/'.$limit_end.','.$limit_next.'">'._("Next Page").'&raquo;</a>';
  63         print '</div>';
  64 }
  65 print '</div>';
  66
  67 require_once('footer.php');
  68 ?>