$sContenido .= "Distancia del trayecto: {$sDistancia}<br/>"; $sContenido .= "Tiempo del trayecto: {$sTiempo}"; $sContenido .= "</div>"; } $arMarkers[] = array("title" => $sTitulo, "content" => $sContenido, "latitude" => $sLatitude, "longitude" => $sLongitud); //$sTitulo = ""; } //Fin foreach de paradas } //bug($arMarkers); $arReturn["markers"] = $arMarkers; $arReturn["stops"] = $arStops; //bug($arReturn); return $arReturn; } $oBD = CBaseDatos::get_instancia(); $arRevisiones = array("1", "", ""); //396763,,397762,,398658" $arRuta = array(); //http://www.w3schools.com/html/html_colornames.asp $arColores = array("9ACD32", "FFA500", "800080", "FF0000", "4169E1", "000080", "C71585", "FF00FF", "00FF00", "20B2AA", "FFD700", "DC143C", "8A2BE2"); foreach ($arRevisiones as $i => $idRevision) { $sSQL = " -- PARADAS\n SELECT DISTINCT \n --trz.Fecha AS Fecha,\n trz.id_revision_tarifa AS id_revision_tarifa,\n trz.Orden AS Orden,\n trz.id AS id_trazado, trz.Fecha, SUBSTRING(trz.Hora,1,2)+':'+SUBSTRING(trz.Hora,3,2) AS Hora, \n trz.Alumnos_Suben, trz.Alumnos_Bajan, \n trz.Esparada, trz.Latitud AS Latitud, trz.Longitud AS Longitud, \n par.Description AS Parada\n FROM \n (\n SELECT id, Fecha, Hora, Alumnos_Suben, Alumnos_Bajan, id_parada_ise,\n Esparada, Latitud, Longitud, Orden, id_revision_tarifa \n FROM prj_trazado\n WHERE id_revision_tarifa = '{$idRevision}'\n AND Latitud != '0.0' AND Longitud !='0.0'\n ) AS trz\n -- Left porque para CL. no existen paradas ise\n LEFT JOIN prj_parada AS par\n ON trz.id_parada_ise = par.id_parada_ise\n WHERE 1=1\n AND trz.Esparada='1'\n ORDER BY id_revision_tarifa, Orden ASC\n "; $arTrazado = $oBD->query($sSQL); /* $arMarcadores[]=array( "title"=>"uno ","content"=>"<b>Content 1</b><input type=\"text\" value=\"marcador uno\">", "latitude"=>"40.5475437","longitude"=>"-3.6420912" );*/ //bug($arTrazado); $arMarkersAndStops = get_markers_and_stops($arTrazado, $i);
private static function search_mssql($sSQL) { $oBD = CBaseDatos::get_instancia(); $oBD->conectar(); $arTabla = array(); try { $oResult = mssql_query($sSQL, $oBD->get_link_id()); //@mssql_query("SET NAMES utf8"); $i = 0; while ($arFila = mssql_fetch_array($oResult, MSSQL_ASSOC)) { $arTabla[$i] = $arFila; $i++; } //Array que tiene como indices los nombres de los campos return $arTabla; } catch (Exception $e) { die("Error al ejecutar la search"); } }