/** * * @param array $request the request * @return array the result data */ public function getTemporaryFeature($request) { R3EcoGisHelper::cleanTmporaryMapEditingData(); $db = ezcDbInstance::get(); $q = $db->createSelectQuery(); $q->select("ST_AsText(the_geom) AS txt_geom")->from("edit_tmp_polygon")->where(array("session_id=?")); $stmt = $q->prepare(); $stmt->execute(array(session_id())); $result = array(); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $result[] = array('type' => _(''), 'geom' => $row['txt_geom']); } return array('status' => R3_AJAX_NO_ERROR, 'data' => $result); }