const getAvailableTrains =  async (depId, arrivId, horraireDep) => {
  var date = new Date();
  var horraireDep = horraireDep || moment(date).format('HH:mm:ss')
  var querry = {
    agency_key: 'SNCFT',
    stop_id: depId
  }
  var f = []
  await gtfs.getStoptimes(querry).then((data)=>{ f = data})
    .catch((e) => {
      console.error(e.stack)
      res.status(500).send('something broke!')
  })
  //console.log(horraireDep)
  var t = []
  f.forEach(function(element) {
    if(element.departure_time >= horraireDep){
      t.push(element)
    }
  })
  var querry2  = {
    agency_key: 'SNCFT',
    stop_id: arrivId
  }
  var m = []
  await gtfs.getStoptimes(querry2).then((data)=>{ m = data})
    .catch((e) => {
      console.error(e.stack)
      res.status(500).send('something broke!')
  })


  var finaleTable = []
  t.forEach(function(element){
    m.forEach(function(element2){
      if(element2.trip_id == element.trip_id && element.departure_time < element2.arrival_time)
        finaleTable.push({'trip_id':element2.trip_id,
                            'departure_station':element.stop_id,
                            'departure_time':element.departure_time,
                            'arrival_station': element2.stop_id,
                            'arrival_time':element2.arrival_time

      })
    })
  })

  return finaleTable.reverse();

}

//server.js
app.get('/api/trip_plan/:idDep/:idArriv', (req, res) => {
  var idDep = req.params.idDep
  var idArriv = req.params.idArriv
  getAvailableTrains(idDep, idArriv)
    .then((data) => { res.json(data)
    })
    .catch((e) => {
      console.error(e.stack)
      res.status(500).send('Something broke!')
    })
})