tram-detective/mapdata.php at master · wongm/tram-detective · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php

header('Content-Type: application/json');

require_once('includes/melb-tram-fleet/functions.php');
require_once('includes/melb-tram-fleet/routes.php');
require_once('includes/config.php');
require_once('includes/functions.php');
require_once('includes/ServiceRouteData.php');
$mysqli = new mysqli($config['dbServer'], $config['dbUsername'], $config['dbPassword'], $config['dbName']);

$tableCheck = "SELECT * FROM `" . $config['dbName'] . "`.`trams` WHERE lat != 0 AND lng != 0";
$result = $mysqli->query($tableCheck);

while($row = $result->fetch_assoc())
{
	$melbournetimezone = new DateTimeZone('Australia/Melbourne');
	$formattedprediction = new DateTime();
	$formattedprediction->setTimestamp(strtotime($row['lastupdated']));
	$formattedprediction->setTimezone($melbournetimezone);
	$formatteddate = $formattedprediction->format('d/m/Y H:i');

	$tram = new stdClass;
	$tram->id = $row['id'];
	$tram->name = getTramClassAndNumber($row['id']);
	$tram->class = getTramClass($row['id']);
	$tram->lat = $row['lat'];
	$tram->lng = $row['lng'];
	$tram->routeNo = $row['routeNo'];
	$tram->offUsualRoute = ($row['offUsualRoute'] == "1");
	$tram->destination = $row['destination'];
	$tram->direction = $row['direction'];
	$tram->lastupdated = $formatteddate;
	$trams[] = $tram;
}

$data['trams'] = $trams;

$lastUpdates = getLastUpdatedData();
$data['maxlastupdated'] = $lastUpdates['maxlastupdated'];
$data['minlastupdated'] = $lastUpdates['minlastupdated'];

echo json_encode($data);

?>