public function get_index()
{
$safeName = \app\inc\Model::toAscii($_REQUEST['name'], array(), "_");
if (is_numeric($safeName[0])) {
$safeName = "_" . $safeName;
}
$srid = $_REQUEST['srid'] ?: "4326";
$file = $_REQUEST['file'];
$key = Connection::$param["postgisschema"] . "." . $safeName . ".rast";
// Create new table
$table = new Table($safeName);
$res = $table->createAsRasterTable($srid);
// Set bitmapsource
$join = new Table("settings.geometry_columns_join");
$json = '{"data":{"bitmapsource":"' . $file . '","_key_":"' . $key . '"}}';
$data = (array) json_decode(urldecode($json));
$join->updateRecord($data, "_key_");
if ($res["success"]) {
$response['success'] = true;
$response['message'] = "Layer <b>{$safeName}</b> is created";
} else {
$response['success'] = false;
$response['message'] = "Some thing went wrong. Check the log.";
Session::createLog(array($res['message']), $_REQUEST['file']);
}
return Response::json($response);
}
public function delete_index()
{
if (Input::getPath()->part(4) === "schema") {
$response = $this->auth(null, array());
if (!$response['success']) {
return $response;
}
$dir = App::$param['path'] . "app/tmp/" . Connection::$param["postgisdb"] . "/" . Input::getPath()->part(5) . ".*";
} else {
$parts = explode(".", Input::getPath()->part(4));
$layer = $parts[0] . "." . $parts[1];
$response = $this->auth(Input::getPath()->part(4), array("all" => true, "write" => true));
if (!$response['success']) {
return $response;
}
$dir = App::$param['path'] . "app/tmp/" . Connection::$param["postgisdb"] . "/" . $layer;
}
$dir = str_replace("..", "", $dir);
//$dirReal = realpath($dir); // Do not work on *
if ($dir) {
exec("rm -R {$dir}");
if (strpos($dir, ".*") !== false) {
$dir = str_replace(".*", "", $dir);
exec("rm -R {$dir}");
}
$respons['success'] = true;
$respons['message'] = "Tile cache deleted";
} else {
$respons['success'] = false;
$respons['message'] = "No tile cache to delete.";
}
return Response::json($respons);
}
function __construct()
{
// Prevent unauthorized use of gc2scheduler
if (!\app\conf\App::$param["gc2scheduler"][$_SESSION["screen_name"]]) {
$code = "401";
header("HTTP/1.0 {$code} " . \app\inc\Util::httpCodeText($code));
die(\app\inc\Response::toJson(array("success" => false, "message" => "Not allowed")));
}
$this->job = new \app\models\Job();
}
private function get_file($type)
{
include_once 'Cache_Lite/Lite.php';
$db = Input::getPath()->part(5);
$baseLayer = Input::get("baselayer");
$layers = Input::get("layers");
$center = Input::get("center");
$zoom = Input::get("zoom");
$size = Input::get("size");
$sizeArr = explode("x", Input::get("size"));
$bbox = Input::get("bbox");
$sql = Input::get("sql");
$id = $db . "_" . $baseLayer . "_" . $layers . "_" . $center . "_" . $zoom . "_" . $size . "_" . $bbox . "_" . $sql;
$lifetime = Input::get('lifetime') ?: 0;
$options = array('cacheDir' => \app\conf\App::$param['path'] . "app/tmp/", 'lifeTime' => $lifetime);
$Cache_Lite = new \Cache_Lite($options);
if ($data = $Cache_Lite->get($id)) {
//echo "Cached";
} else {
ob_start();
$fileName = md5(time() . rand(10000, 99999) . microtime());
$file = \app\conf\App::$param["path"] . "/app/tmp/_" . $fileName . "." . $type;
$cmd = "wkhtmltoimage " . "--height {$sizeArr[1]} --disable-smart-width --width {$sizeArr[0]} --quality 90 --javascript-delay 1000 " . "\"" . "http://127.0.0.1" . "/api/v1/staticmap/html/{$db}?baselayer={$baseLayer}&layers={$layers}¢er={$center}&zoom={$zoom}&size={$size}&bbox={$bbox}&sql={$sql}\" " . $file;
//die($cmd);
exec($cmd);
switch ($type) {
case "png":
$res = imagecreatefrompng($file);
break;
case "jpg":
$res = imagecreatefromjpeg($file);
break;
}
if (!$res) {
$response['success'] = false;
$response['message'] = "Could not create image";
$response['code'] = 406;
header("HTTP/1.0 {$response['code']} " . \app\inc\Util::httpCodeText($response['code']));
echo \app\inc\Response::toJson($response);
exit;
}
header('Content-type: image/png');
imageAlphaBlending($res, true);
imageSaveAlpha($res, true);
imagepng($res);
// Cache script
$data = ob_get_contents();
$Cache_Lite->save($data, $id);
ob_get_clean();
}
header("Content-type: image/png");
echo $data;
exit;
}
public function get_index()
{
$dir = App::$param['path'] . "app/tmp/" . Connection::$param["postgisdb"] . "/__bitmaps";
$safeName = \app\inc\Model::toAscii($_REQUEST['name'], array(), "_");
if (is_numeric($safeName[0])) {
$safeName = "_" . $safeName;
}
$srid = $_REQUEST['srid'] ?: "4326";
$cmd = "raster2pgsql " . "-s " . $srid . " -I -C -M -d " . $dir . "/" . $_REQUEST['file'] . " -F" . " -t 100x100 " . Connection::$param["postgisschema"] . "." . $safeName . " | PGPASSWORD="******"postgispw"] . " psql " . Connection::$param["postgisdb"] . " -U " . Connection::$param["postgisuser"] . " -h " . Connection::$param["postgishost"] . " -p " . Connection::$param["postgisport"];
exec($cmd . ' 2>&1', $out);
$err = false;
// This is a HACK. raster2pgsql doesn't return the error to stdout or stderr.
if (!isset($out[0])) {
$out[0] = "ERROR: Unable to read raster file";
}
foreach ($out as $line) {
if (strpos($line, 'ERROR') !== false) {
$err = true;
break;
}
}
if (!$err) {
$response['success'] = true;
$response['cmd'] = $cmd;
$response['message'] = "Raster layer <b>{$safeName}</b> is created";
$key = Connection::$param["postgisschema"] . "." . $safeName . ".rast";
$class = new \app\models\Classification($key);
$arr = $class->getAll();
if (empty($arr['data'])) {
$class->insert();
$class->update("0", \app\models\Classification::createClass("POLYGON"));
}
if ($_REQUEST['displayfile']) {
$join = new Table("settings.geometry_columns_join");
$json = '{"data":{"bitmapsource":"' . $_REQUEST['file'] . '","_key_":"' . $key . '"}}';
$data = (array) json_decode(urldecode($json));
$join->updateRecord($data, "_key_");
}
} else {
$response['success'] = false;
$response['message'] = "Some thing went wrong. Check the log.";
Session::createLog($out, $_REQUEST['file']);
}
$response['cmd'] = $cmd;
return Response::json($response);
}
static function add($uri, $func = "", $silent = false)
{
$time_start = Util::microtime_float();
$requestUri = strtok($_SERVER["REQUEST_URI"], '?');
if (strpos($requestUri, $uri) !== false) {
if ($func) {
$func();
}
$uri = trim($uri, "/");
$e = explode("/", $uri);
$e[count($e) - 1] = ucfirst($e[count($e) - 1]);
$uri = implode($e, "/");
$n = sizeof($e);
$className = strtr($uri, '/', '\\');
$class = "app\\{$className}";
$action = Input::getMethod() . "_" . Input::getPath()->part($n + 1);
if (class_exists($class)) {
$controller = new $class();
if (method_exists($controller, $action)) {
$response = $controller->{$action}();
} else {
$action = Input::getMethod() . "_index";
if (method_exists($controller, $action)) {
$response = $controller->{$action}();
} else {
header('HTTP/1.0 404 Not Found');
echo "<h1>404 Not Found</h1>";
exit;
}
}
}
//header('charset=utf-8');
//header('Content-Type: text/plain; charset=utf-8');
$code = isset($response["code"]) ? $response["code"] : "200";
header("HTTP/1.0 {$code} " . Util::httpCodeText($code));
if (isset($response["json"])) {
echo Response::passthru($response["json"]);
} else {
if (!$silent) {
$response["_execution_time"] = round(Util::microtime_float() - $time_start, 3);
echo Response::toJson($response);
}
}
exit;
}
}
public function get_tms()
{
$parts = explode("/", $_SERVER['REQUEST_URI']);
$url = "http://127.0.0.1/cgi/tilecache.py/{$parts[3]}/{$parts[4]}/{$parts[5]}/{$parts[6]}/{$parts[7]}?cfg={$this->db}";
$res = imagecreatefrompng($url);
if (!$res) {
$response['success'] = false;
$response['message'] = "Could create tile";
$response['code'] = 406;
header("HTTP/1.0 {$response['code']} " . \app\inc\Util::httpCodeText($response['code']));
echo \app\inc\Response::toJson($response);
exit;
}
header('Content-type: image/png');
imageAlphaBlending($res, true);
imageSaveAlpha($res, true);
imagepng($res);
exit;
}
public function get_fields()
{
return Response::json($this->wmslayer->getfields());
}
public function get_index()
{
$dir = App::$param['path'] . "app/tmp/" . Connection::$param["postgisdb"] . "/__vectors";
$safeName = \app\inc\Model::toAscii($_REQUEST['name'], array(), "_");
$skipFailures = $_REQUEST["ignoreerrors"] == "true" ? true : false;
$append = $_REQUEST["append"] == "true" ? true : false;
$overwrite = $_REQUEST["overwrite"] == "true" ? true : false;
if (is_numeric($safeName[0])) {
$safeName = "_" . $safeName;
}
//Check if file is .zip
$zipCheck1 = explode(".", $_REQUEST['file']);
$zipCheck2 = array_reverse($zipCheck1);
if (strtolower($zipCheck2[0]) == "zip" || strtolower($zipCheck2[0]) == "rar") {
$ext = array("shp", "tab", "geojson", "gml", "kml", "mif", "gdb");
$folderArr = array();
$safeNameArr = array();
for ($i = 0; $i < sizeof($zipCheck1) - 1; $i++) {
$folderArr[] = $zipCheck1[$i];
}
$folder = implode(".", $folderArr);
if (strtolower($zipCheck2[0]) == "zip") {
// ZIP start
$zip = new \ZipArchive();
$res = $zip->open($dir . "/" . $_REQUEST['file']);
if ($res === false) {
$response['success'] = false;
$response['message'] = "Could not unzip file";
return Response::json($response);
}
$zip->extractTo($dir . "/" . $folder);
$zip->close();
// ZIP end
}
if (strtolower($zipCheck2[0]) == "rar") {
// RAR start
$rar_file = rar_open($dir . "/" . $_REQUEST['file']);
if (!$rar_file) {
$response['success'] = false;
$response['message'] = "Could not unrar file";
return Response::json($response);
}
$list = rar_list($rar_file);
foreach ($list as $file) {
$entry = rar_entry_get($rar_file, $file);
$file->extract($dir . "/" . $folder);
// extract to the current dir
}
rar_close($rar_file);
// RAR end
}
if ($handle = opendir($dir . "/" . $folder)) {
while (false !== ($entry = readdir($handle))) {
if ($entry !== "." && $entry !== "..") {
$zipCheck1 = explode(".", $entry);
$zipCheck2 = array_reverse($zipCheck1);
if (in_array(strtolower($zipCheck2[0]), $ext)) {
$_REQUEST['file'] = $folder . "/" . $entry;
for ($i = 0; $i < sizeof($zipCheck1) - 1; $i++) {
$safeNameArr[] = $zipCheck1[$i];
}
$safeName = \app\inc\Model::toAscii(implode(".", $safeNameArr), array(), "_");
break;
}
$_REQUEST['file'] = $folder;
}
}
}
}
$srid = $_REQUEST['srid'] ?: "4326";
$encoding = $_REQUEST['encoding'] ?: "LATIN1";
switch ($_REQUEST['type']) {
case "Point":
$type = "point";
break;
case "Polygon":
$type = "multipolygon";
break;
case "Line":
$type = "multilinestring";
break;
case "Geometry":
$type = "geometry";
break;
default:
$type = "PROMOTE_TO_MULTI";
break;
}
$model = new \app\inc\Model();
$tableExist = $model->isTableOrView(Connection::$param["postgisschema"] . "." . $safeName);
$tableExist = $tableExist["success"];
if ($tableExist == true && $overwrite == false && $append == false) {
$response['success'] = false;
$response['message'] = "'{$safeName}' exists already, use 'Overwrite'";
$response['code'] = 406;
return $response;
}
if ($_REQUEST["append"] == "true") {
$sql = "DELETE FROM " . Connection::$param["postgisschema"] . "." . $safeName;
$res = $model->prepare($sql);
try {
$res->execute();
} catch (\PDOException $e) {
$response['success'] = false;
$response['message'] = "Could not delete from {$safeName}";
$response['code'] = 406;
return $response;
}
}
$cmd = "PGCLIENTENCODING={$encoding} ogr2ogr " . ($skipFailures ? "-skipfailures " : " ") . ($append ? "-append " : " ") . ($overwrite == true && $append == false ? "-overwrite " : " ") . "-dim 2 " . ($append ? "" : "-lco 'GEOMETRY_NAME=the_geom' ") . ($append ? "" : "-lco 'FID=gid' ") . ($append ? "" : "-lco 'PRECISION=NO' ") . ($append ? "" : "-lco 'PG_USE_COPY=YES' ") . "-a_srs 'EPSG:{$srid}' " . "-f 'PostgreSQL' PG:'host=" . Connection::$param["postgishost"] . " user="******"postgisuser"] . " password="******"postgispw"] . " dbname=" . Connection::$param["postgisdb"] . " active_schema=" . Connection::$param["postgisschema"] . "' " . "'" . $dir . "/" . $_REQUEST['file'] . "' " . "-nln {$safeName} " . "-nlt {$type}";
exec($cmd . ' 2>&1', $out, $err);
$geoType = $model->getGeometryColumns(Connection::$param["postgisschema"] . "." . $safeName, "type");
$key = Connection::$param["postgisschema"] . "." . $safeName . ".the_geom";
$class = new \app\models\Classification($key);
$arr = $class->getAll();
// Set layer editable
$join = new \app\models\Table("settings.geometry_columns_join");
$json = '{"data":{"editable":true,"_key_":"' . $key . '"}}';
$data = (array) json_decode(urldecode($json));
$join->updateRecord($data, "_key_");
if (empty($arr['data'])) {
$class->insert();
$class->update("0", \app\models\Classification::createClass($geoType));
}
$def = new \app\models\Tile($key);
$arr = $def->get();
if (empty($arr['data'][0])) {
$json = '{
"theme_column":"",
"label_column":"",
"query_buffer":"",
"opacity":"",
"label_max_scale":"",
"label_min_scale":"",
"meta_tiles":false,
"meta_size":"3",
"meta_buffer":"10",
"ttl":""}';
$def->update($json);
}
if ($out[0] == "") {
$response['success'] = true;
$response['message'] = "Layer <b>{$safeName}</b> is created";
$response['type'] = $geoType;
// Bust cache, in case of layer already exist
\app\controllers\Tilecache::bust(Connection::$param["postgisschema"] . "." . $safeName);
} else {
$response['success'] = false;
$response['message'] = $safeName . ": Some thing went wrong. Check the log.";
$response['out'] = $out[0];
Session::createLog($out, $_REQUEST['file']);
// Make sure the table is dropped if not skipping failures and it didn't exists before
if ($skipFailures == false && $tableExist == false) {
$sql = "DROP TABLE " . Connection::$param["postgisschema"] . "." . $safeName;
$res = $model->prepare($sql);
try {
$res->execute();
} catch (\PDOException $e) {
}
}
}
$response['cmd'] = $cmd;
return $response;
}
