\t SELECT mb_user_wmc.wmc_serial_id as wmc_id, mb_user_wmc.wmc_title, mb_user_wmc.wmc_timestamp, wmc_load_count.load_count FROM mb_user_wmc LEFT JOIN wmc_load_count ON wmc_load_count.fkey_wmc_serial_id = mb_user_wmc.wmc_serial_id WHERE wmc_serial_id IN ({$wmcList}); SQL; $res = db_query($sql); $resultObj = array("header" => array("WMC ID", "Titel", "Timestamp", "Load Count", ""), "data" => array()); while ($row = db_fetch_row($res)) { // convert NULL to '', NULL values cause datatables to crash $walk = array_walk($row, create_function('&$s', '$s=strval($s);')); $link = "<a class='cancelClickEvent' target='_blank' href='../php/mod_showMetadata.php?" . "languageCode=" . Mapbender::session()->get("mb_lang") . "&resource=wmc&id=" . $row[0] . "'>" . _mb("Metadata") . "</a>"; array_push($row, $link); $resultObj["data"][] = $row; } $ajaxResponse->setResult($resultObj); $ajaxResponse->setSuccess(true); break; case "getWmcMetadata": $wmcId = $ajaxResponse->getParameter("id"); $sql = <<<SQL \t SELECT wmc_serial_id as wmc_id, abstract, wmc_title, wmc_timestamp, wmc_timestamp_create, wmc_public FROM mb_user_wmc WHERE wmc_serial_id = {$wmcId}; SQL; $res = db_query($sql); $row = db_fetch_assoc($res); $resultObj = array(); $resultObj['wmc_id'] = $row['wmc_id']; $resultObj['wmc_abstract'] = $row['abstract'];
try { switch ($method) { case "intersect": $geometries = $request->getParameter("geometries"); $clickPoint = $request->getparameter("clickPoint"); $resultGeometries = array(); $i = 0; foreach ($geometries as $geometry) { $sql = "SELECT ST_Intersects ('{$clickPoint}'::geometry, '{$geometry}'::geometry);"; $dbresult = db_query($sql); $row = db_fetch_array($dbresult); $result = $row["st_intersects"] == "f" ? false : true; if ($result) { $resultGeometries[$i] = $geometry; } $i++; } $request->setSuccess(true); $request->setResult(array("geometries" => $resultGeometries)); break; default: $e = new mb_exception(__FILE__ . ": RPC called with invalid Method '{$method}'"); $request->setSuccess(false); $request->setMessage(__FILE__ . ": RPC called with invalid Method '{$method}'"); } } catch (Exception $E) { $e = new mb_exception(__FILE__ . ": RPC failed. Exception: '{$E}'"); $request->setSuccess(false); $request->setMessage(__FILE__ . ": RPC failed. Exception: '{$E}'"); } $request->send();
# # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. require_once dirname(__FILE__) . "/../../core/globalSettings.php"; require_once dirname(__FILE__) . "/../php/mb_validateSession.php"; require_once dirname(__FILE__) . "/../classes/class_json.php"; require_once dirname(__FILE__) . "/../classes/class_wfs_configuration.php"; require_once dirname(__FILE__) . "/../classes/class_wfs_conf.php"; $ajaxResponse = new AjaxResponse($_REQUEST); $command = $ajaxResponse->getMethod(); switch ($command) { case "getWfsConfsFromId": $wfsConfIdString = $ajaxResponse->getParameter("wfsConfIdString"); if (!$wfsConfIdString) { $ajaxResponse->setSuccess($false); $ajaxResponse->setMessage("missing wfsConfIdString"); $ajaxResponse->send(); break; } $wfsConfIdString = trim($wfsConfIdString, ','); $wfsConfIds = explode(',', $wfsConfIdString); $result = array(); foreach ($wfsConfIds as $wfsId) { $currentWfsConf = WfsConfiguration::createFromDb($wfsId); if ($currentWfsConf !== null) { $result[] = $currentWfsConf; } } $ajaxResponse->setResult($result); $ajaxResponse->send();
/* * License: * Copyright (c) 2009, Open Source Geospatial Foundation * This program is dual licensed under the GNU General Public License * and Simplified BSD license. * http://svn.osgeo.org/mapbender/trunk/mapbender/license/license.txt */ require_once dirname(__FILE__) . "/../php/mb_validateSession.php"; require_once dirname(__FILE__) . "/../classes/class_administration.php"; require_once dirname(__FILE__) . "/../classes/class_wmc.php"; require_once dirname(__FILE__) . "/../classes/class_json.php"; require_once dirname(__FILE__) . "/../classes/class_lzw_decompress.php"; $ajaxResponse = new AjaxResponse($_POST); if ($ajaxResponse->getMethod() != "saveWMC") { $ajaxResponse->setSuccess(false); $ajaxResponse->setMessage("method invalid"); $ajaxResponse->send(); exit; } $json = new Mapbender_JSON(); // get data from POST and SESSION $userId = Mapbender::session()->get("mb_user_id"); $mapObject = $ajaxResponse->getParameter('mapObject'); $lzwCompressed = $ajaxResponse->getParameter('lzwCompressed'); $saveInSession = $ajaxResponse->getParameter('saveInSession'); $extensionData = $json->decode($ajaxResponse->getParameter('extensionData')); $attributes = $ajaxResponse->getParameter('attributes'); $overwrite = $ajaxResponse->getParameter('overwrite'); $overwrite = $overwrite == "1" ? true : false; //for debugging, write mapObject to file