Flight scraper

Populate Kayak data

• Add a button (under Actions) that ROLE_ADMIN can run to populate flights (Kayak) for all active airports serving GVA, for a period of dates. 
  • Use same date schedule as in the Settings

Populate GVA.CH data

• On morning of T+1, run the GVA.CH scrape for ‘tomorrow’, on all flights
  • This is a one-off check, mainly to confirm that the scheduled times from Kayak match the times from gva.ch.  ie ScheduledDepartureTimeGvach === ScheduledArrivalTimeGvach
    • Chron: Run at 8am, on T+1 (ie on Monday 8am, run Tuesday's GVA.CH Overview and Details flight scraper) 
• Throughout T+0, the ‘detailed' refresh should run on “selected” individual flights, where the criteria for selection is:
  • Arrivals:
    • actualArrivalTime is null and
    • scheduledArrivalTimeGvach is after ‘now’ - 1hour 
  • Departures
    • actualDepartureTime is null and
    • status is not cancelled
    • scheduledDeparturelTimeGvach is after ‘now’ - 1hour 

Code-share

• Code share is no longer a relational field (linked to FlightTrips). 
• The Codeshare entity has a flightNumber and the record stores the associated other flights. 
  • This enables mutliple flightTrips with the same flightNumber to be linked to the CodeShare
    • So the determination has to be a lookup on a matching flight number
• The objective is to combine multiple entries for the same flight and return the code-share data in the flight details in the transfer bookings (so a user can search for their flight by any of the flight numbers)
• Check the scrape functionality on the "Operated by" to identify “child” flights (ie the ones that are going to be deleted)
• Establish a view  of all flights where there are more than one flight departing at the same time to the same location.
• Build up a list of code-shares -   question, the gva.ch notes scrape concatenates the flight numbers.  Should we maintain that array or separate into individual code-share identifiers - which will allow us to identify ones to delete?)
• Write a service that identifies the duplicates and delete

Shuttle: Edit Screen

• Remove at the bottom the SBBTrain dropdown list and the Uphill/Downhill field.  DONE
• List of Transfers includes ALL trips (PT and Shared), admittedly restricted to that day.   But doesn't show name of Passenger, or Address.  DONE??
• When you edit a shuttle and press Save, it should go back to the Shuttle page from that shuttle (ie 26-8-2025 in this case).  DONE??

Background/rational

• Taxi companies and individual taxi drivers all share the same software and I will be able to see across the various competing taxi drivers and re-allocate trips or new trips to whoever is best placed to offer them.
  • In truth this is to match drivers who are going back empty with a customer who needs taking
  • Do you think this makes sense that there are [20-50] taxidrivers sharing the same database -or should i clone it?
• Offer each taxi driver their ‘own’ website, so they can give their clients that site and book trips there themselves  (as an incentive to use the system). Assume there are 50 ‘individual’ taxi drivers. 
  • Can I control 50 x CMS (CMS_Copy and CMS_Photo and Product) inputs centrally (ie each CMS page would need to be linked to a taxi driver)
  • Can I point their own URL to my code (eg. www.johnstaxi.com) but where all the bookings go to AXTools?
  • So in each Partner company I would include their URL link if they are adopting my system
  • I think it is ok for ‘their’ link to use the same URL if that is impossible
• Intro fee for referrals
• New drivers sign up and need to send bank details, driving license and car details
  • Automate the on-boarding email - in English and French
• Driver's location is tracked in their response
  • Can we do this via the website or do we need an IOS/Android app?
• For all bookings the driver's time at location is tracked to prove they were on time and to whatsapp the customer

Private + bookings

• We should create a page showing the Private+ bookings that can be seen externally. 
• Recap: A Private+ booking is one that the original client (first) has opted to allow others to travel with them, to share the cost, so long as the times and destinations work.
• The criteria are:
  • Drop-off to an airport - they have to be on flights that leave within [20 - controllable in settings] mins of each other and departing from the same Destination (eg Verbier)
  • Pickup at an airport -  they have to be on the exact same flight…. and obviously going to the same ‘Destination’ (eg Verbier, Chamonix etc)
    • FYI, the 20min rule doesn't apply for pickup at the airport as 1 flight might be early/later and the waiting period could easily extend from 20mins to hours. But for dropoffs that doesn't apply (as we don't know about delayed flights until too late to influence the taxi journey)
• So, the page should reflect that:
  • Date
  • Seats taken
  • Seats left (assume 7 seats in the car)
  • Pickup (from(
    • If airport, then flight number
  • Drop-Off (to)
    • Don't show the address (eg Ch de la Tinte, 5), but show ‘Verbier’
  • Price for 1,2,3… people  
    • We will work on the formula for that.

Driver's page 

• The driver's schedule should detail THEIR trips for the day and allow them to move forward/back to future days. 
  • Background colours to represent past, tomorrow, today, future 
• Links to helpful notes.
• Launch the “Meet & Greet” page for airport/train pickups with the client details/affiliate logo
• Buttons to register events
  • Non-transfer
    • Driver wake-up / Awake
    • Left home
  • Transfer specific
    • At pickup (including GPS location)
    • ‘Found client’
    • Leaving now
    • Arrived
    • WhatsApps/emails to clients
•  Essential that this page is optimised for mobile.  Should also be the login-direction for users that are Drivers