<?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";
    }
}