-
Notifications
You must be signed in to change notification settings - Fork 0
/
importTsRoutes.php
49 lines (33 loc) · 1.18 KB
/
importTsRoutes.php
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
47
48
49
<?php
require_once "login.php";
ini_set("session.cookie_httponly", True);
session_start();
header("Content-Type: application/json");
$body = file_get_contents('php://input');
error_log($body);
$dbConn = logIntoPostgreSQL();
$geojsonArray = getTsPoints($dbConn, $body);
echo json_encode($geojsonArray);
function getTsPoints($dbConn, $body){
$geojsonArray = array();
$obj_array = json_decode($body);
$route_table = htmlentities($obj_array->{'routeTable'});
$start_point = htmlentities($obj_array->{'startingPoint'});
$randomColor = rand_color_warm();
// $result = pg_query($dbConn, "select query_route_ts_all_points('$route_table', '$start_point', '$randomColor');");
$result = pg_query_params($dbConn, "select query_route_ts_all_points($1, $2, $3)",
array($route_table, $start_point, $randomColor));
error_log('Query result:');
error_log(print_r($result, true));
while ($row = pg_fetch_row($result)) {
error_log(print_r($row, true));
// build array
array_push($geojsonArray, $row);
}
pg_close($dbConn);
return $geojsonArray;
}
function rand_color_warm() {
return sprintf('#%06X', mt_rand(0, 0xFF0000));
}
?>