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; }