function getDireccionIlike($direccion, $limite)
{
$dbPg = pgSql_db();
$dir = explode(" ", strtolower($direccion));
$sql = "select id_direccion,calle,segmento,numero_municipal,comuna,region,latitud,longitud,query_completa,origen from gis_direccion where 1=1";
foreach ($dir as $d) {
if (trim($d) != "" and !is_numeric($d)) {
$sql .= " and query_completa like '%{$d}%'";
}
if (is_numeric($d)) {
$sql .= " and numero_municipal =" . $d . "";
}
}
if ($limite > 0) {
$sql .= " limit " . $limite . "";
}
$rsCalle = pg_query($dbPg, $sql);
while ($rowCalle = pg_fetch_row($rsCalle)) {
//$arr_callesComuna[$rowCalle[0]] = $rowCalle[1];
$direc = array();
$direc[] = $rowCalle[0];
$direc[] = $rowCalle[1];
$direc[] = $rowCalle[2];
$direc[] = $rowCalle[3];
$direc[] = $rowCalle[4];
$direc[] = $rowCalle[5];
$direc[] = $rowCalle[6];
$direc[] = $rowCalle[7];
$direc[] = $rowCalle[8];
$direc[] = 2;
$direc[] = $rowCalle[9];
$direcciones[] = $direc;
}
pg_close($dbPg);
return $direcciones;
}
function addQuery($query)
{
$dbPg = pgSql_db();
$sql = "insert into cm_query(query,fecha_registro) values('" . $query . "','" . date("Y-m-d H:i:s") . "')";
$rsCalle = pg_query($dbPg, $sql);
pg_close($dbPg);
}
function getDetalleServ($qr)
{
$dbPg = pgSql_db();
$sql = "SELECT id_detalle, id_servicio, url, descripcion, telefono, texto4, \n texto5, fecha_registro\n FROM gis_servicio_detalle where 1=1";
if (trim($qr) != "") {
$sql .= $qr;
}
$rsCalle = pg_query($dbPg, $sql);
//echo $sql;
$data_arr = array();
while ($row2 = pg_fetch_row($rsCalle)) {
$data = array();
$data[] = $row2[0];
$data[] = $row2[1];
$data[] = $row2[2];
$data[] = $row2[3];
$data[] = $row2[4];
$data[] = $row2[5];
$data[] = $row2[6];
$data[] = $row2[7];
$data_arr[] = $data;
}
pg_close($dbPg);
return $data_arr;
}
function getFarmaciasTurno($latI, $latS, $lonD, $lonI)
{
$dbPg = pgSql_db();
$fecha_actual = date("Y-m-d H:i:s");
$fecha_actual2 = strtotime('-3 hours ', strtotime($fecha_actual));
$fec = date('Y-m-d H:i:s', $fecha_actual2);
$fecha = date('Y-m-d', $fecha_actual2);
$nuevafecha = strtotime('-1 day', strtotime($fecha));
$nueva = date('Y-m-d', $nuevafecha);
$nueva_hora = date("Y-m-d 07:59:59");
//echo "<br> fec: ".$fec." -- ".$nueva_hora."";
if ($fec <= $nueva_hora) {
$query = "(fecha = '" . $fecha . "' or (fecha ='" . $nueva . "' and horario ilike '%del dia siguiente%') )";
} else {
$query = "fecha = '" . $fecha . "'";
}
$sql2 = "SELECT nombre,fecha,estado,latitud,longitud,direccion,horario,comuna from cm_farmacia_turno where estado=0 and " . $query . " and latitud<=" . $latS . " and latitud >=" . $latI . " and longitud <=" . $lonD . " and longitud >=" . $lonI . "";
$rs2 = pg_query($dbPg, $sql2);
echo "<br>" . $sql2;
while ($row2 = pg_fetch_row($rs2)) {
$data = array();
$data[] = $row2[0];
$data[] = $row2[1];
$data[] = $row2[2];
$data[] = $row2[3];
$data[] = $row2[4];
$data[] = $row2[5];
$data[] = $row2[6];
$data[] = $row2[7];
$datos[] = $data;
}
pg_close($dbPg);
return $datos;
}
