Esempio n. 1
0
/**
 *
 *
 * @param unknown $table
 * @param unknown $sql
 * @param unknown $sql2
 * @param unknown $from
 */
function doSelect($table, $sql, $sql2, $from)
{
    global $db;
    global $depth;
    global $postgisObject;
    global $srs;
    global $gmlNameSpaceUri;
    global $lf;
    global $gmlNameSpace;
    global $gmlNameSpaceGeom;
    global $gmlFeature;
    global $gmlGeomFieldName;
    global $gmlUseAltFunctions;
    global $defaultBoundedBox;
    global $cacheDir;
    global $startTime;
    global $useWktToGmlInPHP;
    global $thePath;
    global $HTTP_FORM_VARS;
    global $tableObj;
    global $postgisschema;
    global $fieldConfArr;
    if (!$gmlFeature[$table]) {
        $gmlFeature[$table] = $table;
    }
    if ($sql2) {
        $postgisObject->execQuery("BEGIN");
        $result = $postgisObject->execQuery($sql2 . $from);
        //logfile::write($sql2.$from."\n");
        if ($postgisObject->numRows($result) == 1) {
            while ($myrow = $postgisObject->fetchRow($result)) {
                if (!empty($myrow["txmin"])) {
                    //added NR
                    genBBox($myrow["txmin"], $myrow["tymin"], $myrow["txmax"], $myrow["tymax"]);
                } else {
                    //return;
                }
            }
        } else {
            print $defaultBoundedBox;
        }
    } else {
        print $defaultBoundedBox;
    }
    $result = $postgisObject->execQuery($sql . $from . " LIMIT 1000000");
    if ($postgisObject->numRows($result) < 1) {
        $sql = str_replace(",public.ST_AsText(public.ST_Transform(the_geom,25832)) as the_geom", "", $sql);
        $from = str_replace("view", "join", $from);
        $result = $postgisObject->execQuery($sql . $from);
    }
    logfile::write("SQL fired\n\n");
    logfile::write($sql . $from . "\n");
    $totalTime = microtime_float() - $startTime;
    logfile::write("\nQuery time {$totalTime}\n");
    //foreach($postgisObject -> execQuery($sql.$from." LIMIT 10000") as $myrow) { //Iteration directly over result. Only PDO
    if ($postgisObject->PDOerror) {
        makeExceptionReport($postgisObject->PDOerror);
    }
    while ($myrow = $postgisObject->fetchRow($result)) {
        writeTag("open", "gml", "featureMember", null, True, True);
        $depth++;
        writeTag("open", $gmlNameSpace, $gmlFeature[$table], array("fid" => "{$table}.{$myrow["fid"]}"), True, True);
        $depth++;
        $checkIfGeomHasPassed = false;
        // Check that geom field is written out only once.
        $numFields = sizeof($myrow);
        $keys = array_keys($myrow);
        for ($i = 0; $i < $numFields; $i++) {
            $FieldName = $keys[$i];
            $FieldValue = $myrow[$FieldName];
            if ($tableObj->metaData[$FieldName]['type'] != "geometry" && $FieldName != "txmin" && $FieldName != "tymin" && $FieldName != "txmax" && $FieldName != "tymax" && $FieldName != "tymax" && $FieldName != "oid") {
                if ($gmlUseAltFunctions['altFieldValue']) {
                    $FieldValue = altFieldValue($FieldName, $FieldValue);
                }
                if ($gmlUseAltFunctions['altFieldNameToUpper']) {
                    $FieldName = altFieldNameToUpper($FieldName);
                }
                if ($gmlUseAltFunctions['changeFieldName']) {
                    $FieldName = changeFieldName($FieldName);
                }
                $fieldProperties = (array) json_decode($fieldConfArr[$FieldName]->properties);
                if ($fieldProperties['cartomobilePictureUrl']) {
                    //if ($myrow[$fieldProperties['cartomobilePictureUrl']]) {
                    $FieldValue = getCartoMobilePictureUrl($table, $FieldName, $fieldProperties['cartomobilePictureUrl'], $myrow["fid"]);
                    //}
                }
                //$FieldValue = htmlentities($FieldValue);
                $FieldValue = altUseCdataOnStrings($FieldValue);
                if ($FieldValue && ($FieldName != "fid" && $FieldName != "FID")) {
                    writeTag("open", $gmlNameSpace, $FieldName, null, True, False);
                    //$FieldType = pg_field_type($result, $i);
                    echo $FieldValue;
                    writeTag("close", $gmlNameSpace, $FieldName, null, False, True);
                }
            } elseif ($tableObj->metaData[$FieldName]['type'] == "geometry") {
                // Check if the geometry field use another name space and element name
                if (!$gmlGeomFieldName[$table]) {
                    $gmlGeomFieldName[$table] = $FieldName;
                }
                if ($gmlNameSpaceGeom) {
                    $tmpNameSpace = $gmlNameSpaceGeom;
                } else {
                    $tmpNameSpace = $gmlNameSpace;
                }
                writeTag("open", $tmpNameSpace, $gmlGeomFieldName[$table], null, True, True);
                $depth++;
                if ($useWktToGmlInPHP) {
                    $__geoObj = geometryfactory::createGeometry($myrow[$FieldName], "EPSG:" . $srs);
                    echo $__geoObj->getGML();
                    unset($__geoObj);
                } else {
                    echo $myrow[$FieldName];
                }
                $depth--;
                writeTag("close", $tmpNameSpace, $gmlGeomFieldName[$table], null, True, True);
            }
        }
        $depth--;
        writeTag("close", $gmlNameSpace, $gmlFeature[$table], null, True, True);
        $depth--;
        writeTag("close", "gml", "featureMember", null, True, True);
    }
    $totalTime = microtime_float() - $startTime;
    print "\n<!-- {$totalTime} -->";
    $postgisObject->execQuery("ROLLBACK");
}
 function geometryCollection($wktArray)
 {
     foreach ($wktArray as $__key => $__value) {
         $this->geometryArray[$__key] = parent::createGeometry($__value);
     }
 }
Esempio n. 3
0
 function loadInDB(&$postgisObject, $tableName)
 {
     if ($this->arr) {
         //First we try to drop table
         $dropSql = "DROP TABLE " . $tableName . " CASCADE";
         //When we try to delete row from geometry_columns
         $deleteFromGeometryColumns = "DELETE FROM geometry_columns WHERE f_table_name='" . $tableName . "'";
         //When we insert new row in geometry_columns
         $sqlInsert = "INSERT INTO geometry_columns VALUES ('', '" . $postgisObject->postgisdb . "', '" . $tableName . "', 'the_geom', 2, 25832, '" . $this->geomType . "', NULL, NULL, NULL)";
         //Last we create the new table
         $createSql = "\n\t\t\tCREATE TABLE " . $tableName . " (\n\t\t\tgid serial NOT NULL,\n\t\t\t" . $this->strForSql . "  character varying,\n\t\t\tthe_geom geometry,\n\t\t\tCONSTRAINT \"\$1\" CHECK ((srid(the_geom) = 25832)),\n\t\t\tCONSTRAINT \"\$2\" CHECK (((geometrytype(the_geom) = '" . $this->geomType . "'::text) OR (the_geom IS NULL)))\n\t\t\t);";
         // Check if table is already created
         $checkSql = "select * FROM " . $tableName;
         $check = $postgisObject->execQuery($checkSql);
         // Start of transactions block
         $postgisObject->execQuery(BEGIN);
         if ($check) {
             $result = $postgisObject->execQuery($dropSql);
             $postgisObject->free($result);
             //echo $tableName." dropped\n";
         }
         $result = $postgisObject->execQuery($deleteFromGeometryColumns);
         $postgisObject->free($result);
         $result = $postgisObject->execQuery($sqlInsert);
         $postgisObject->free($result);
         $result = $postgisObject->execQuery($createSql);
         $postgisObject->free($result);
         //echo "\n";
         $countRows = 0;
         for ($i = 0; $i < sizeof($this->arr['fields']); $i++) {
             $geoObj = geometryfactory::createGeometry($this->arr['geom'][$i], "25832");
             if ($geoObj) {
                 if ($geoObj->getGeomType() == "POLYGON" || $geoObj->getGeomType() == "LINESTRING" || $geoObj->getGeomType() == "POINT") {
                     $this->arr['geom'][$i] = $geoObj->getAsMulti();
                 }
             }
             $sqlInsert = "insert into " . $tableName . " (" . $this->arr['fields'][$i] . ",the_geom) values(" . $this->arr['values'][$i] . ",'SRID=25832;" . $this->arr['geom'][$i] . "')";
             // Check if feature has geometry
             if ($this->arr['geom'][$i] != "()") {
                 $result = $postgisObject->execQuery($sqlInsert);
                 if ($result and pg_affected_rows($result) == 1) {
                     $countRows++;
                     $postgisObject->free($result);
                 } else {
                     logfile::write("Error in #" . $i . "\n");
                     logfile::write("ROLLBACK\n");
                     logfile::write($sqlInsert . "\n");
                     $postgisObject->execQuery(ROLLBACK);
                     logfile::write("Script terminated\n");
                     die;
                 }
             } else {
                 logfile::write("#. " . $i . " missing geometry.\n");
                 logfile::write("ROLLBACK\n");
                 $postgisObject->execQuery(ROLLBACK);
                 logfile::write("Script terminated\n");
                 die;
             }
             //echo ".";
         }
         $postgisObject->execQuery(COMMIT);
         // End of transactions block
     } else {
         $sql = "DELETE FROM " . $tableName;
         $result = $postgisObject->execQuery($sql);
         $postgisObject->free($result);
         $countRows = "0";
     }
     logfile::write(date('l jS \\of F Y h:i:s A') . " " . $countRows . " features loaded in table '" . $tableName . "'\n");
 }
Esempio n. 4
0
 function loadInDB($tableName)
 {
     $st = $this->explodeTableName($tableName);
     //print_r($this -> arr);
     if ($this->arr) {
         //print_r($this->arr);
         //First we try to drop table
         $dropSql = "DROP TABLE " . $tableName . " CASCADE";
         //When we try to delete row from geometry_columns
         $deleteFromGeometryColumns = "DELETE FROM geometry_columns WHERE f_table_schema='" . $st['schema'] . "' AND f_table_name='" . $st['table'] . "'";
         //When we insert new row in geometry_columns
         $sqlInsert = "INSERT INTO geometry_columns VALUES ('', '" . $st['schema'] . "', '" . $st['table'] . "', 'the_geom', 2, {$this->arr['srid'][0]}, '" . $this->geomType . "')";
         //Last we create the new table.Must use schema prefix cos search path include public
         $createSql = "\n\t\t\tCREATE TABLE " . $tableName . " (\n\t\t\tgid serial NOT NULL PRIMARY KEY,\n\t\t\t" . $this->strForSql . "  character varying,\n\t\t\tthe_geom geometry,\n\t\t\tCONSTRAINT \"\$1\" CHECK ((srid(the_geom) = {$this->arr['srid'][0]})),\n\t\t\tCONSTRAINT \"\$2\" CHECK (((geometrytype(the_geom) = '" . $this->geomType . "'::text) OR (the_geom IS NULL)))\n\t\t\t);\n\t\t\t";
         //echo $createSql."\n";
         // Check if table is already created
         $checkSql = "select * FROM " . $tableName;
         $check = $this->execQuery($checkSql);
         $this->PDOerror = NULL;
         // Start of transactions block
         $this->execQuery(BEGIN);
         if ($check) {
             $result = $this->execQuery($dropSql);
             $this->free($result);
             //echo $tableName." dropped\n";
         }
         $result = $this->execQuery($deleteFromGeometryColumns);
         $this->free($result);
         $result = $this->execQuery($sqlInsert);
         $this->free($result);
         $result = $this->execQuery($createSql);
         $this->free($result);
         //echo "\n";
         $countRows = 0;
         for ($i = 0; $i < sizeof($this->arr['fields']); $i++) {
             $geoObj = geometryfactory::createGeometry($this->arr['geom'][$i], $this->arr['srid'][$i]);
             if ($geoObj) {
                 if ($geoObj->getGeomType() == "POLYGON" || $geoObj->getGeomType() == "LINESTRING" || $geoObj->getGeomType() == "POINT") {
                     $this->arr['geom'][$i] = $geoObj->getAsMulti();
                 }
             }
             $sqlInsert = "insert into " . $tableName . " (" . $this->arr['fields'][$i] . ",the_geom) values(" . $this->arr['values'][$i] . ",geomFromText('" . $this->arr['geom'][$i] . "'," . $this->arr['srid'][$i] . "))";
             //echo $sqlInsert;
             // Check if feature has geometry
             if ($this->arr['geom'][$i] != "()") {
                 $result = $this->execQuery($sqlInsert);
                 if (!$this->PDOerror) {
                     $countRows++;
                     $this->free($result);
                 } else {
                     print_r($this->PDOerror);
                     print "Error in #" . $i . "\n";
                     print "ROLLBACK\n";
                     print $sqlInsert . "\n";
                     $this->execQuery(ROLLBACK);
                     print "Script terminated\n";
                     die;
                 }
             } else {
                 print "#. " . $i . " missing geometry.\n";
                 print "ROLLBACK\n";
                 $this->execQuery(ROLLBACK);
                 print "Script terminated\n";
                 die;
             }
             //echo ".";
         }
         $this->execQuery(COMMIT);
         // End of transactions block
     } else {
         $sql = "DELETE FROM " . $tableName;
         $result = $this->execQuery($sql);
         $this->free($result);
         $countRows = "0";
     }
     print date('l jS \\of F Y h:i:s A') . " " . $countRows . " features loaded in table '" . $tableName . "'\n";
 }