dev-chiefworks
38 lines
1.5 KiB
PHP
38 lines
1.5 KiB
PHP
<?php
|
|
|
|
require('../backend.php');
|
|
|
|
$httpAuthToken = "99dfe35fcb7de1ee";
|
|
$encryptionAlg = "aes-256-ctr";
|
|
$encryptionKey = "1234567890abcdef1234567890abcdef";
|
|
$encryptionIV = "1234567890abcdef";
|
|
|
|
$db_host = $savvyext->cfgReadChar('database.host');
|
|
$db_name = $savvyext->cfgReadChar('database.name');
|
|
$db_user = $savvyext->cfgReadChar('database.user');
|
|
$db_pass = $savvyext->cfgReadChar('database.pass');
|
|
$db_port = $savvyext->cfgReadLong('database.port');
|
|
$connstr = "host=${db_host} port=${db_port} dbname=${db_name} user=${db_user} password=${db_pass}";
|
|
$conn = pg_connect($connstr);
|
|
|
|
$f = file_get_contents("../district.json");
|
|
$d = json_decode($f,true);
|
|
|
|
foreach ($d["data"]["features"] as $i) {
|
|
//echo $i["properties"]["id"]." => ".$i["properties"]["latitude"].",".$i["properties"]["longitude"]."\n";
|
|
$q = "UPDATE geofence_area SET latitude=".$i["properties"]["latitude"].",longitude=".$i["properties"]["longitude"]." WHERE id=".$i["properties"]["id"];
|
|
//$r = pg_query($conn,$q);
|
|
echo $i["properties"]["id"]." => ".count($i["geometry"]["coordinates"][0][0])."\n";
|
|
$q = "SELECT * FROM geofence_area WHERE id=".$i["properties"]["id"];
|
|
$r = pg_query($conn, $q);
|
|
if ($r && pg_num_rows($r) && $f=pg_fetch_assoc($r)) {
|
|
$b = json_decode($f["boundaries"],true);
|
|
$b["polygon"] = $i["geometry"]["coordinates"][0][0];
|
|
$q = "UPDATE geofence_area SET boundaries='".json_encode($b)."' WHERE id=".$i["properties"]["id"];
|
|
echo $q."\n";
|
|
$r = pg_query($conn, $q);
|
|
echo "ERROR: ".pg_last_error()."\n";
|
|
}
|
|
}
|
|
|