| <?php | |
| abstract class Resource | |
| { | |
| protected static $httpMethods = array("GET", "POST", "HEAD", | |
| "PUT", "OPTIONS", "DELETE", "TRACE", "CONNECT"); | |
| protected $params; | |
| public function __construct(array $params) { | |
| $this->params = $params; |
| RewriteEngine on | |
| RewriteCond %{REQUEST_FILENAME} !-f | |
| RewriteCond %{REQUEST_FILENAME} !-d | |
| RewriteRule ^(.*)$ /index.php |
| <?php | |
| /** | |
| * API Index | |
| */ | |
| header('Cache-Control: no-cache, must-revalidate'); | |
| header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); | |
| header('Content-type: application/json'); | |
| $service = $_GET['s']; | |
| date_default_timezone_set('America/Porto_Velho'); |
| /* | |
| * ---------------------------------------------------------------------------- | |
| * "THE BEER-WARE LICENSE" (Revision 42): | |
| * <[email protected]> wrote this file. As long as you retain this notice you | |
| * can do whatever you want with this stuff. If we meet some day, and you think | |
| * this stuff is worth it, you can buy me a beer in return Poul-Henning Kamp | |
| * ---------------------------------------------------------------------------- | |
| */ | |
| /* | |
| * DuinoClient |
| // adicionar no arquivo routes.php | |
| Router::connect('/noticia/:id/:title', | |
| array('controller' => 'posts', 'action' => 'view'), | |
| array('pass' => array('id'), 'title' => '[a-z0-9-#]+','id' => '[0-9]+') | |
| ); |
| /** | |
| * The role map defines how to resolve the user record from your application | |
| * to the roles you defined in the roles configuration. | |
| */ | |
| $config['map'] = array( | |
| 'Pessoa' => 'Pessoa/cpf', // username login field | |
| 'Perfil' => 'Pessoa/perfil_id', // user role field | |
| ); | |
| /** |
| <?php | |
| /** | |
| * arquivo AppController.php | |
| */ | |
| public $components = array( | |
| /* outros componentes chamados aqui */ | |
| 'Acl', | |
| 'Auth' => array( | |
| 'authError' => 'O usuário não tem permissão para acessar essa ação', |
| /* | |
| * This decorates Handlebars.js with the ability to load | |
| * templates from an external source, with light caching. | |
| * | |
| * To render a template, pass a closure that will receive the | |
| * template as a function parameter, eg, | |
| * T.render('templateName', function(t) { | |
| * $('#somediv').html( t() ); | |
| * }); | |
| * Source: https://github.com/wycats/handlebars.js/issues/82 |
The first step is to remove older version of PostGIS if any.
sudo apt-get purge postgis
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" >> /etc/apt/sources.list.d/postgresql.list'
| $latlng = "-8.769926868691913 -63.88429307573199"; | |
| $radius = 5000; | |
| $places = Place::where(DB::raw("ST_Distance_Sphere(places.latlng, ST_GeometryFromText('SRID=4326;POINT({latlng})'))"), '<', $radius) | |
| ->select('offers.*', DB::raw("ST_Distance_Sphere(places.latlng, ST_GeometryFromText('SRID=4326;POINT({$latlng})')) AS distance")) | |
| ->get(); |