$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");
}
}
