public function getStreetList($request) { $like = isset($request['term']) ? $request['term'] : null; $limit = isset($request['limit']) ? $request['limit'] : null; $used_by = isset($request['used_by']) ? $request['used_by'] : null; return array('status' => R3_AJAX_NO_ERROR, 'data' => R3EcoGisHelper::forceJSonArray(R3EcogisHelper::getStreetList($this->do_id, $request['mu_id'], array('like' => $like, 'limit' => $limit, 'used_by' => $used_by, 'allow_empty' => true)))); }
public function getStreetList($request) { $db = ezcDbInstance::get(); $lang = R3Locale::getLanguageID(); $like = isset($request['term']) ? $request['term'] : null; $limit = isset($request['limit']) ? $request['limit'] : null; if (isset($request['mu_name'])) { $request['mu_id'] = (int) $db->query("SELECT mu_id FROM municipality WHERE mu_name_{$lang} ILIKE " . $db->quote($request['mu_name']))->fetchColumn(); } if (isset($request['autocomplete'])) { return R3EcogisHelper::getStreetList($_SESSION['do_id'], $request['mu_id'], array('like' => $like, 'limit' => $limit, 'allow_empty' => false)); } return array('status' => R3_AJAX_NO_ERROR, 'data' => R3EcoGisHelper::forceJSonArray(R3EcogisHelper::getStreetList($_SESSION['do_id'], $request['mu_id'], array('allow_empty' => true)))); }