hewerthomn

-- Source of inspiration of this snippet
-- https://www.experts-exchange.com/questions/27396707/Search-for-a-string-across-all-tables-in-oracle.html#a42581782

declare
    num_rows number;
    sql_text varchar2(2500);
    sql_info varchar2(1000);
    v_text varchar2(100) := '''%value_in_lowercase%''';
begin
    dbms_output.enable(1000000);

hewerthomn

<?php

/**
 * Calculate the mod11
 * @param  string $baseVal
 * @param  string $separator
 * @return string
 */
public function mod11($baseVal = "", $separator = '-')
{

hewerthomn

<?php
// app/Http/Kernel.php

  /* ... */
  
protected $middleware = [
  /* ... */
  
  \App\Http\Middleware\LocaleSetup::class,
  /* ... */

hewerthomn

How to install OCI8 on Ubuntu 16.04 and PHP 7.1

Source: http://www.syahzul.com/2016/04/06/how-to-install-oci8-on-ubuntu-14-04-and-php-5-6/

Install Oracle Instant Client and SDK

Step 1

Download the Oracle Instant Client and SDK from Oracle website. (Need to login in Oracle page)

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

hewerthomn

@include('envoy.config.php');

@servers($servers)

@setup
  $startTime = microtime(true);
  $startedAt = date('H:i:s');

  if ( ! isset($repo) ) {
    throw new Exception('Variável $repo não está definido!');

hewerthomn

main() {
  # Use colors, but only if connected to a terminal, and that terminal
  # supports them.
  if which tput >/dev/null 2>&1; then
      ncolors=$(tput colors)
  fi
  if [ -t 1 ] && [ -n "$ncolors" ] && [ "$ncolors" -ge 8 ]; then
    RED="$(tput setaf 1)"
    GREEN="$(tput setaf 2)"
    YELLOW="$(tput setaf 3)"

hewerthomn

<?php

/*...*/

public function selectList()
{
  $list = $this->select('name', 'id')
            ->orderBy('name')
            ->pluck('name', 'id');
  

hewerthomn

server {
	server_name	DOMAIN;
	listen		80;
	listen		[::]:80;

	return		301	https://$server_name$request_uri;
}

server {
	server_name	DOMAIN;

hewerthomn

<?php

$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();

hewerthomn

$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();