function get_next_arret($trip_id, $dir, $sequence)
{
$date = date("Y-m-d");
$jour_semaine = get_DayWeek($date, 'en');
$rq_day = "c." . $jour_semaine . " = 1";
$sql = 'SELECT t.trip_id,
t.direction_id,
s.arrival_time,
s.departure_time,
a.stop_id,
s.stop_sequence,
a.stop_name,
a.stop_lat,
a.stop_lon
FROM sncf_trips t
INNER JOIN sncf_stop_times s ON s.trip_id = t.trip_id
INNER JOIN sncf_stops a ON s.stop_id = a.stop_id
INNER JOIN sncf_calendar c ON c.service_id = t.service_id
WHERE ' . $rq_day . ' AND t.trip_id = "' . $trip_id . '" AND t.direction_id = "' . $dir . '" AND s.stop_sequence = "' . $sequence . '"';
$query = $this->db->query($sql);
if ($query->num_rows() > 0) {
return $query->result();
}
return FALSE;
}
function get_liste_current($id_ligne, $id_arret, $sens, $nb, $jour)
{
$day['Lu'] = "monday";
$day['Ma'] = "tuesday";
$day['Me'] = "wednesday";
$day['Je'] = "thursday";
$day['Ve'] = "friday";
$day['Sa'] = "saturday";
$day['Di'] = "sunday";
$heure = date("H:i:s");
if ($jour === NULL) {
$date = date("Y-m-d");
$jour_semaine = get_DayWeek($date, 'en');
$rq_day = "c." . $jour_semaine . " = 1";
} else {
$rq_day = "c." . $day[$jour] . " = 1";
}
// Si retour d'heure a zero, on boucle pour choper le stop sequence d'avant
//stop_sequence
$sql = 'SELECT s.arrival_time
FROM stan_routes r
INNER JOIN stan_trips t ON t.route_id = r.route_id
INNER JOIN stan_stop_times s ON s.trip_id = t.trip_id
INNER JOIN stan_stops a ON s.stop_id = a.stop_id
INNER JOIN stan_calendar c ON c.service_id = t.service_id
WHERE c.start_date <= CURDATE() AND c.end_date >= CURDATE()
AND r.route_id = "' . $id_ligne . '" AND a.stop_id = "' . $id_arret . '" AND t.direction_id = "' . $sens . '"
AND ' . $rq_day . ' AND s.arrival_time >= "' . $heure . '" ORDER BY s.arrival_time LIMIT ' . $nb;
$query = $this->db->query($sql);
if ($query->num_rows() > 0) {
foreach ($query->result() as $row) {
$result[] = $row;
}
return $result;
}
return FALSE;
}
function get_arrets_test($id, $direction = 1)
{
$date = date("Y-m-d");
$jour_semaine = get_DayWeek($date, 'en');
$this->db->select('stan_trips.trip_id, stan_routes.route_color');
$this->db->from('stan_trips');
$this->db->join('stan_routes', 'stan_routes.route_id = stan_trips.route_id');
$this->db->join('stan_calendar', 'stan_calendar.service_id = stan_trips.service_id');
$this->db->where('stan_trips.route_id = ' . $id . ' AND stan_trips.direction_id = ' . $direction . ' AND stan_calendar.' . $jour_semaine . '=1');
$query = $this->db->get();
if ($query->num_rows() > 0) {
foreach ($query->result() as $row) {
var_dump($row->trip_id);
}
}
}
