Multi-language handling

• Handling of dates in availability calendar when changing to GR
• Refreshing the page reverts to English, if not logged in.  A problem in ATS not CDV specfically

Batch Scrape — Add "Scrape All Villas" Button

The existing Batch Scrape functionality is complete and working. I would like to extend it to support scraping multiple villas in a single operation.

1. Existing functionality (no changes)

Keep the current Batch Scrape option, which accepts:

• Villa ID (selected from villas with an Airbnb URL)
• First Start Date (e.g. 22-Oct-2026)
• Number of Dates (e.g. 10)

This runs the existing scraper and creates one PriceHistory record per start date for the selected villa.

2. New functionality — Scrape All Villas

Add a second button labelled "Scrape All Villas".

This should use the same First Start Date and Number of Dates inputs, but automatically run the existing Batch Scrape process for every villa that meets both conditions:

• Villa Status is Live or Market Intelligence.
• Villa has a valid Airbnb URL.

Villas marked Draft should be excluded.

3. Processing

• Reuse the existing Batch Scrape service rather than duplicating the scraping logic.
• Process each qualifying villa using the same date range.
• Save the resulting PriceHistory records against the correct Villa.
• One villa failing should not prevent the remaining villas from being processed.
• Display a summary showing the number of villas processed, PriceHistory records created and any failures.

4. Example

If there are 100 qualifying villas and the Number of Dates is set to 10:

• 100 villas × 10 start dates = 1,000 PriceHistory records.
• Each record contains the existing T+1 to T+30 price observations.
• Total: up to 30,000 price observations.

5. Additional considerations

As this could involve thousands of Airbnb requests, the process should ideally run in the background using a Symfony Messenger queue or equivalent, rather than within a single HTTP request?

The interface should display progress and prevent accidentally launching the same batch multiple times.

Villa screen

• When clicking on the Previous/Next month, the screen jumps down so you can't read the full page

Villa Status — Replace “testingMode” field

Rename the existing testingMode field in the Villa entity to villaStatus.

The field should have three possible values:

• Live — Villa is published on the public booking website and available for customers to browse and book.
• Draft — Villa is being prepared for publication. It can be edited by authorised users but is not visible to customers.
• Market Intelligence — Villa is maintained solely for competitor monitoring, Airbnb price discovery and market analysis. It is not available for booking through our platform.

Implementation requirements

• Reuse the existing Testing Mode field if practical, renaming it to status.
• Update the Villa form to use a dropdown with the three options above.
• Only villas with status Live should appear on the public villa listings, search results and booking selection pages.
• Both Draft and Market Intelligence villas must be excluded from all public booking pages.
• All three statuses should remain visible in the admin Villa index, with a status filter and colour-coded labels:
  • Live — Green
  • Draft — Amber
  • Market Intelligence — Blue
• New villas created through the normal admin interface should default to Draft.
• Villas automatically imported through Airbnb Villa Discovery should default to Market Intelligence.The Market Intelligence and Price History tools should be able to access villas of any status, provided they have a valid Airbnb URL.
• Allow administrators to change a villa's status at any time, including promoting a Market Intelligence villa to Draft or Live.
• Migrate existing Testing Mode values appropriately, ensuring no villas are inadvertently published or hidden.

Important: Villa Status determines whether a villa is displayed publicly. It should not restrict its inclusion in market intelligence reporting or price discovery.

Adding Region to the Discovery process

• In the Discover Villas form, add a Resort dropdown (linked to the existing Resort entity). 
  • When new Villa records are created through the discovery process, automatically populate their Resort field using the selected Region.
• This will ensure that all villas discovered in a particular search are assigned to the correct resort without requiring manual updates.

ICS export  (AirbnbIcalSyncCommand)

• Is this working for each villa?   Test with TheaVista?

CyprusVillasDirect — Market Intelligence

1. Background

We want to build a Market Intelligence feature for CyprusVillasDirect that collects pricing and availability information for holiday villas listed on Airbnb.

For example, we could collect data for villas in Pissouri and market this information to other villa owners in Pissouri, helping them understand whether they are overpricing or underpricing their properties relative to competitors.

The commercial objective is to develop a historical database that tells us:

• What each villa is charging for different arrival dates and lengths of stay.
• Which dates appear available or unavailable.
• What minimum-stay restrictions appear to apply.
• Whether discounts are being offered.
• How prices and availability change over time.
• How competitively each villa is priced relative to other villas.

Over time, this should allow us to estimate occupancy, identify pricing trends and compare the performance of competing properties.

Today's task is to build the collection and storage functionality, not the analytics or reporting.

2. Existing application

Villa entity

Already exists and contains:

• villaName
• airbnbUrl

PriceHistory entity

Already created with:

• Villa — ManyToOne relationship
• StartDate — proposed arrival date
• T1Price through T30Price — total prices for stays of 1–30 nights
• createdAt — timestamp recording when the information was collected

There is also an existing CRUD interface, including an index showing all 30 prices and a manual form.

Each collection should create a new record rather than overwrite an existing record, allowing us to track historical price changes.

No new entities or changes to existing entities are required.

3. Data collection methodology

For each villa, investigate every possible arrival date over the next six months (initially 180 days).

For each arrival date, obtain prices for stays of between 1 and 30 nights.

For example:

Villa: TheaVista
Arrival date: 1 July 2027

• 1 night: Checkout 2 July 2027 — Price £xxx
• 2 nights: Checkout 3 July 2027 — Price £xxx
• 3 nights: Checkout 4 July 2027 — Price £xxx
• And so on, up to:
• 30 nights: Checkout 31 July 2027 — Price £xxx

The checkout date is always calculated as:  checkoutDate = startDate + numberOfNights

The proposed coverage per villa is: 180 arrival dates × 30 stay lengths = 5,400 quotes.

Some requests will not return a price because dates are unavailable, minimum-stay rules prevent booking, or another restriction applies.

Where no valid price is returned, store NULL, not zero.

A missing price does not necessarily mean the villa is occupied.

If we collect prices today and again tomorrow, both observations must be retained for historical comparison.

All prices should be collected in a consistent currency (GBP initially) and represent the total quoted price for the requested stay.

4. Implementation

Create a Symfony service named:

VillaMarketIntelligenceService

The service should accept:

• Villa ID
• Arrival date

The service will:

• Load the Villa entity.
• Check that airbnbUrl exists and an authorised pricing data source is available.
• For the specified arrival date, request prices for stays of 1–30 nights, or obtain equivalent information in bulk if the source supports it.
• Parse and validate the returned information.
• Create a new PriceHistory record with the Villa, StartDate and collection timestamp.
• Save the prices in T1Price through T30Price.
• Record errors in the application logs without aborting the complete collection.

Batch collection

Also provide a method that accepts:

• Villa ID
• Start date
• Number of arrival dates to investigate (default 180)

This should call the single-arrival-date method for each date.

For 180 arrival dates, the process should create 180 PriceHistory records per villa, each containing up to 30 prices.

Use a permitted data source, respect its rate limits and avoid unnecessary requests where equivalent bulk pricing information is available.

5. Testing

Initially, test the functionality on one villa and one arrival date.

Verify that:

• The correct Airbnb listing is identified.
• The 30 checkout dates are calculated correctly.
• Valid returned prices are saved against the correct T1Price–T30Price fields.
• Missing prices are saved as NULL.
• The existing collection timestamp is populated.
• Running the same collection twice creates two separate historical records.
• An individual quote failure does not stop the other quotes being collected.

Once this works, test collecting several arrival dates for the same villa.

6. Scope for today

Build:

• VillaMarketIntelligenceService.
• Pricing collection for 1–30 nights.
• Storage of collected prices in the existing PriceHistory entity.
• Historical snapshots without overwriting previous collections.
• Batch collection across multiple arrival dates.
• Basic error handling and testing.

Do not build today:

• Any new entities or entity changes.
• Competitor comparison reports.
• Occupancy calculations.
• Pricing recommendations.
• Charts or dashboards.
• Automatic scheduled collections.

The priority is to establish a reliable database of historical prices using the existing PriceHistory entity. We can develop the analytics once the underlying data collection is working.

Objective: Automatically discover and import villas from an Airbnb search results page into our existing Villa database (eg villas in Pissouri or Coral Bay).  

Example: https://www.airbnb.co.uk/s/Coral-Bay--Pegeia/homes?place_id=ChIJEe9tmjwI5xQRb4uBfixUqUc&refinement_paths%5B%5D=%2Fhomes&location_bb=Qgt6hkIBiHtCC2PYQgFrnQ%3D%3D&acp_id=t-g-ChIJEe9tmjwI5xQRb4uBfixUqUc&date_picker_type=calendar&search_type=autocomplete_click 

Search URL Input

• Create a page where an administrator can paste an Airbnb search URL (e.g. a search for villas in Pissouri, Cyprus).
• Add a "Discover Villas" button to initiate the process.

Scrape Airbnb Search Results

• Open the supplied URL and extract all villas returned by the search.
• Handle pagination/infinite scrolling to capture all available results, not just the first page.
• For each villa, capture:
  • Airbnb listing URL (permanent URL without search dates or tracking parameters).
  • Airbnb listing ID.
  • Property title/name.
  • Maximum number of guests (sleeps X).
  • Number of bedrooms, beds and bathrooms (where available).
  • Location/area.
  • Main property image URL (if available).

Create Villa Records

• Check whether each Airbnb listing (eg the villa's unique ID) already exists in our Villa database, using the Airbnb listing ID or canonical URL to identify duplicates.
• If it exists, skip it (do not overwrite existing data).
• If it does not exist, create a new Villa entity and populate the available fields, including airBnBUrl.
• Reuse the existing Villa entity and fields wherever possible. Do not create another entity.

Results Summary

• Display the number of villas discovered.
• Number of new Villa records created.
• Number already in the database (skipped).
• Number of failures, with error details.

Other Considerations

• The process should work for any Airbnb search URL, allowing us to discover villas in Pissouri, Aphrodite Hills, Coral Bay, Polis, etc.
• Avoid duplicate records when the same villa appears in multiple searches.
• Handle missing property information without failing the entire import.

Purpose: Build up our database of competing villas automatically so that our existing Market Intelligence / Price History functionality can subsequently track their prices, availability and pricing trends.

Batch Scrape

• Create a service that has 3 inputs
  • VillaID (eg Columbia) - selected from Villas with a AirBnBUrl
  • First Start Date (e.g. 22-Oct26)
  • Number of Dates to run  (e.g. 10)
• This will create 10 records in the database, changing the StartDate (22-Oct, 23-Oct, …. 2 Nov)
• Run the scraper we had before 
• …. So this will get 10 x 300 prices, saved in 10 records. 

Amenities

• If the Amenity description is not in the Translations list, show a warning sign

Client-show-villa

• Photos don't size/re-size properly and cut off heads etc

HomePage

• Add region search to the search box 

Confirmation email

• Villa address is incorrect - needs to be villa specific
• Contact tel number is incorrect  - needs to be villa specific

Seasonal rates. 

• Include a Villa field in each seasonal rate (DONE)
• Index view:
  • Not available to non-logged in users
  • Non-Admin Users (ie ROLE_USERS) see only their villas (as defined in Owner entity)
  • ROLE_ADMIN users see all
• The view should be by single villa (you never want to see all villas on one page) - so you select the villa you want to see
• The error messages (checking continuity) are by villa (Make sense?)
• And finally it might be great to show a graph of prices by dates.  Again ROLE_ADMIN see all graphs, ROLE_USER see their own only. 

Export and imports 

• Build export and import for Bookings (SN to do)

New Booking

• In booking/new,  the user (non ROLE_ADMIN) should not be able to edit:   
  • Status
  • isAirBnB booking
  • Checkin & Checkout Dates (should be set from the button and depends on availability)
    • OK to made these editable so long as it knows the availability schedule
• Handling availability in the booking dropdown: We need to handle cases where the available booking basis changes between Daily and Weekly during the period shown.  
  • For example: 1–3 January is available on a daily basis.
    • From 4 January onwards, availability is weekly only:
      • 4–10 January
      • 11–17 January
      • 18–24 January, etc.
    • In this case, the permitted departure dates for an arrival on 1 January should be:
      • 2 Jan, 3 Jan, 4 Jan, 10 Jan, 17 Jan, 24 Jan, etc.
      • It should not allow departure dates such as 5–9 January or 11–16 January, because once the booking crosses into the weekly-only period, the departure date must align with the end of one of the available weekly blocks.
      • The dropdown therefore needs to build valid departure dates by considering changes in the availability/rate basis across the booking period, rather than assuming the entire stay is either daily or weekly.

On mobile

• Date fields are not aligned nicely

Homepage

• At the bottom of index_homepage.html.twig: Include a map of the island with each villa location shown.  
  • Restrict the map markers to those that meet the search criteria
  • Hovering over the map maker shows the name of the villa, and number of bedrooms in brackets and price (lowest daily/weekly rate in the date range)
  • Clicking on the map marker launches the show-villa page

Show villa

• Remove “Select an available date on the calendar to book this villa directly.  Direct booking. About 15% cheaper than Airbnb”
• Change text to: “Save versus AirBnB by booking direct. Compare price: ” then include the AirBnB link under the AirBnB icon  
• For ROLE_ADMIN include an icon (next to the map-marker?) with a link to their unique site

Seasonal Rates

• There are 2 new fields in Seasonal Rates -  “weeklyBookingsOnly” flag and “weekStartDay”
• These are used if a villa only allows bookings by the week- eg Saturday→Saturday.   
  • This is common in ski resorts so that they don't have 1 of 2 days empty as the visitors don't fit exactly
• So if this Boolean is checked, then customers can only book in 1 week slots (eg Saturday to Saturday).  In that case the price per night is really price per week (so multiply by 7),  And the weekday (eg Saturday) is controlled here too. 
• Also we need to change the Booking calendar to only accept week-long bookings

Main CyprusVillasDirectHomePage

• This should show ALL villas
• See https://www.villaplus.com/  
  • See how you can search by dates, # bedrooms, and then click on a villa. 
  • The info section gives a good example of the extra fields we need to add in the Villa entity (I will do that)

HomePage (VillaIndex)

• Make the HomePageIndex the homepage (settings?)
• Make the “View villa URL”,  Show (eye) and Edit (Pen) buttons only available to ROLE_ADMIN.  
• Clicking on the picture of villa should launch the villa's show page (not their OWN website) which includes the Availability

Search functionality

• Initially the Homepage should show all villas
• Once the Search function (dates, #bedrooms) is selected, it should only show villas that are available in the full date range and meets the bedroom and region criteria
• Can we add a dropdown list of Amenities that the villa needs to have (eg must have swimming pool)

Villa-Show

• Move the Availability to top right
• Remove the Villa Location box.
  • Make the map-market at the top of the page launch the map/directions page,  
  • Looks like you have replaced the map-marker icon with the villa favicon - no…. it should be the map-marker and pressing it should open the location/directions page

Availability grid

• Info icon appears on days when you can't book (hide it)  
• When I have Sep highlighted it looks like you can't book 1-4 Oct... which you can
• Weekly only doesn't look good on mobile   
• When the villa is weekly booking only, I think we need to change the display and just show the weeks.  And not show the weekly price in every day.  Perhaps only show the price on the [Saturday] and change the text to $700/week
  • Clicking on Book should show only bookings for 1 or 2 weeks from the prescribed start date
• Remove the  word "Book" - it is implied 

Individual websites

• This is the key challenge.
• Let's assume to begin with that each villa holds their ‘unique’ villa website on the atts-systems.com domain…
• Then what I would ideally like to happen is that as soon as we create a villa entry for a new villla  (eg Villa RogerFederer,   website:  www.villarogerfederer@atts-systms.com) then it is immediately available as a unique site (rather than a directory under villacyprusdirect). Is that possible?
• Let's assume each villa wants their own URL (which is not part of atts-system  eg VillaRogerFederer.com), I am sure we have to buy the URL and redirect in the DNS our own sub-directory to that external, non ATS, site)?
  • Is that how you would do it?

 Controlling the CMS on each individual website

• We can;t use the CmsCopy entity in CyprusVillaDirect to control the CMS on say “TheaVistaPissouri.com” because the CMSCopy has no unique villa ID
• And we can't add villa_id to the CmsCopy entity (and CmsPhoto entity) as that will be over-written by ATS copy bat file (and we need the CmsCopy for the CyprusVillaDirect site…. 
• So what do we do. I think we need to create a villa-specific CmsCopy and CmsPhoto entities. 
  • Do you agree?  If you agree let's call them:  CmsCopyVilla  and CmsPhotoVilla

Villa slug into other entities

• Photos
• CmsCopyItems

Think about

• Weather: How to handle more than one weather location
• Business Contacts: Should these be unique by villa? Seems a shame not to share.  Thoughts

Calendar synchronisation with Airbnb

• Objective; To avoid double-bookings between the two platforms
• Both systems support iCal calendar synchronisation. In practice this means the two calendars exchange availability information automatically:
  • The website will publish a calendar feed showing dates that are already booked or blocked. Airbnb can read this and automatically mark those dates as unavailable on Airbnb.
  • Airbnb also provides its own calendar feed. 
  • The website will read that feed regularly and automatically block those dates on the website if an Airbnb booking is made.
• I have made that link in the TheaVistaPissouri project to make bookings made on our site available to AirBnB, but not the reverse – can you research?

ToDo:

• In the ‘pull’ from AirBnB can you display the name of the booking?

CMS export.

• Allow export of the actual copy to enable upload into ChatGPT etc

Business contacts

• Buttons at the top to be sorted in ranking order not alphabetically (SN to do)

CMS Photo

• If the English text (for the title) is not translated into all the available languages show a warning sign

User - Email to UserGroups

• Email sending error

Business Contacts

• Add Town/Region
• Show distance from home venue
• Add all emergency and health contacts

User Import

• Make flexible so that it looks at the title of the column to determine the field to populate

User

• Groups (eg London. Cyprus.  Tennis). And messages by group.  Send all or by one

CMS formatting

In Techarete the CMS edit does not increase the height of the edit box

Contact form

• Fails to create a Website contact anymore

Contact form

• No longer saving a record in Website Contacts

CMS Photo

• Default the rotate to zero
• When editing, if it was a Product it reverts to Static upon opening
• If photo.photo is blank, it should be ignored in the controller (displaying product.html.twig)

OfficeAddress

• Why doesn't it occupy full page, especially on mobile?

SQL download

• Learn how to import into local

HomePage

• Allow multi-selections in the Contact Us form
• Add Product-include in Contact form field

Useful files

• E-mail functionality doesn't work
• Edit issue

User

• Reset passwords etc

Photos

• Header Link should go to the Show By Location if sole location

CMS

• Home Page.  if the flag for Photos only is not checked and there is no CMS page Static-Home, then show an error message

Users

• Link the list of fields viewable to the CompanyDetails settings
  • Home Address
  • Business Address
  • Personal Details
  • Job Details

Multi-lingual functionality:

• Include in the CompanyDetails entity a field called ‘multilingual’ (booelan)
• Create new entity called ‘Languages’ containing, language (English, French, German, Spanish) , flag icon file,  and abbreviation
• Selection of flag switches language of text

Page count

• Add field in the Products entity for pageCount and pageCountAdmin
• When a page is loaded add to the pageCount (and if an Admin user add to pageCountAdmin only)

Create a Help entity

• Ability to show video of implementing each function

CMS Copy

• Headlings and Titles in CMS_Copy should be be hidden unless Ranking ==1
• Default Ranking =1 for first one and 2 thereafter

Product List

• Button to make Active/Inactive from the Index
• Buttons to Change the Ranking and Renumber

Translations

• Create import/export buttons for the translations
• Replace records with same English

Business Contacts

• Index:  Need to sort by the ranking of the Business Types
• In Business Contact form
  • Java-script to hide the First/Last Name if the BusinessOrPerson= “Business”.   if Person selected, show both
  • Add GPS location button that picks current location.   Activate from the view too. 
• When deleting a business contact, cascade to the Referrals log

CMS Photos

• Movie files in Interests/Products or Home page don't seem to size correctly

Facebook Reviews

• List of users : FindByRole function should have up to 3 roles 
• Include a setting for limit review history (eg 3 months), and show/hide the reviews according to that limit
• Import Reviews needs to find the User and the Facebook Group from the entity

Registration

• Settings.   Have a flag for enable registrations
• Email templates:
  • Registration - Thank you registering and has a verification link to confirm
  • Referral 
• Display QR code on home page

ATS Template

• Multi-lingual functionality:
  • Include in the CompanyDetails entity a field called ‘multilingual’ (booelan)
  • Create new entity called ‘Languages’ containing, language (English, French, German, Spanish) , flag icon file,  and abbreviation
  • Selection of flag switches language of text
• Page count
  • Add field in the Products entity for pageCount and pageCountAdmin
  • When a page is loaded add to the pageCount (and if an Admin user add to pageCountAdmin only

Map Icons

• Button to delete icons and hide/show the form field as appropriate

User

• Work out a way to share some common features of the User entity but allowing for adaptions for each different project
• ChatGPT:  I am building about 10 different websites that all work on Symfony/PHP.  They will all share the same foundations or basic architecture (basic USER handling, a CMS, and other standard features) and any changes in one are updated across all by copying the Entity, Controller, Form, Repository and Templates.  The each site will have some specific code unique to each site.   The problem I have is that the USER entity needs to be slightly different for each site, so I can't copy those across.  How can I maintain consistency and the uniqueness.  My thought was to split the user entity in two and embed the second (different) USER2 contents within the USER form.  Any suggestions

Company Details 

• Boolean flag to show/hide Contact Details in the Headers
• Other flags to hide/show other functionality from the Dashboard 
  • Weather, Facebook groups, Business contacts, Instructions, Competitors.  

Company Details

• Need to make email and Default password mandatory, if using the contact form. 

Referrals log

• Date Time function

Company Details

• Index view - The i icon for Directions doesn't slice or raw
• Weather -  Fails with GMT as time zone
• Map link field - increase height

Photos

• In the CountService, for the CountPrivateLocations, don't just count those Private locations, but those where the user has access to

HomePage (Photos only)

• Closer together

ATS Company Details Show

• Fix slider
• hide facebook months and registration email if deselected 

Services.yaml

• The only directory that doesn't work is the favicons_directory and mapicons_directory
  • However it works in the CompanyDetailsController, it only fails to work in twig (company-details-index,  QR-homepage, base.html)   
  • In each of those twigs, they don't accept other directories from the service.yaml   and favicon_directory works in other twigs

Email server

• Emails failing in many projects

Home page (photos only)

• Looks terrible on Ipad Pro 
  • Looks ok on iPad Mini

• Add useful contacts – copy from Stephen-nurse or Immigration
• Include a map that shows the location of each restaurant/hotel etc
• Restaurant entity to include opening times (for on and off peak season)
• Menu entity
  • Linked to restaurants
• Add all to the copy batch file

User

• Add photo, which should be part of personal details
• Improve views

Business Contacts

• Counter fix.  Don't display Business Types if Counter =0

Products

• CkEditor in Products

Languages

• Add a link on the Active/Inactive to turn off/off instantly
• Add a ranking number to control the order of the flags in the dropdown
• Import feature to upload all the countries.  Delete all

Photo Locations

• New Photo Location creates an error

Mobile view needs to be improved

• Dashboard
• Company Details
  • Change from a table to a single record to display across whole page (Show)
    • Show function doesn't work as is
• CMS_Copy - restrict content 
• CMS_Photo - restrict content 

User

• Reset password doesn't work

Website contacts

• How do I see what Product they are interested in?

Security

• Email verification for New users

Interests/Products

• In the hyperlink in the Products/Interests entity - in the index correct for https or www to launch even if lazily entered.   Same for business contacts

CMS Copy

• Can't save Edits
• Increase height of the content box
• Define different page layout formats and have the CMS copy be applied to that format

Login Direction

• Doesn't seem to do anything anymore

Logout time

• How do I control the time til the systems logs you out?

User Log

• Edit function error

Backdoor

Doesn't work: Password Encoder error

Products

• Notes field should be better positioned (on the right, col-8) and be editable with CKEditor.
• As you hover over the Links for the Products in the menu it should show you the Notes

Website contacts

• Ordering of products according to ranking
• Similarly in email

Weather

• Index - Link to the live google weather page doesn't find the location specfied
• Create a daily chron job

Edit the bat file to add the new project specific inflation 

Product list (header)

• If there is only one product in the ProductList, then it should become the Header
• Same for SubProducts

HomePage Contact Form

• Still shows the DateTime sent.
• Phone number should be optional

Workflow

• Auto registration

Facebook Groups and Products

• Not sorting

Header & Footer

• Product list should be sorted by Ranking number 

Instructions

• Import Media file
• Display media file
• And launch

QR page

• Look and feel on full and small screen

Project specific roles maintain in settings

• Create an entity to define the roles available in the project 
• Also in the User form, be able to control which fields are active as a function of the role

Users

• Edit User fails because
  • Password is not visible
  • If the user has 2 or more than 3 names in the fullName 

Business contacts

• New contact: Sort categories alphabetically
• FIle and photo field show in edit mode when not empty.  Copy JS in Edit for CompanyDetails
• Index: Desktop class doesn’t work
• Count contacts where maplocation is not empty service

Git fails

• Copy to Whistles and Bells

Company Details

• Include Contact Details or not in the headers

Server clean-up

• Button to clean up the attachments for all directories
• Button to import the mapicon files 

CMS Copy

• When switching between Static Page and Product, deleting the field for Static page/Product respectively
• New CMS: Product list to be ordered by ranking

Maps

To calculate the optimal zoom level for a Google Map that just fits all of your venues without scrolling, you need to determine the bounding box that encompasses all the venue locations. Based on the bounding box, you can compute the zoom level that ensures all the venues are visible. Here’s how you can approach this:

Steps to Calculate Optimal Zoom Level

Find the bounding box:
For all your venues, compute the min and max latitudes and min and max longitudes:

• minLat = minimum latitude of all venues
• maxLat = maximum latitude of all venues
• minLng = minimum longitude of all venues
• maxLng = maximum longitude of all venues

Calculate the geographical range:

• The latitude range is:
  latRange = maxLat - minLat
• The longitude range is:
  lngRange = maxLng - minLng

Calculate the center of the map:
The center of the map is simply the average of the latitudes and longitudes:

• centerLat = (maxLat + minLat) / 2
• centerLng = (maxLng + minLng) / 2

Calculate the diagonal distance: The diagonal distance between the top-left and bottom-right corners of the bounding box is critical for determining the zoom level. You can use the Haversine formula or a simplified approximation to compute the distance.

The Haversine formula is:

1. a = sin²(Δφ/2) + cos(φ1) ⋅ cos(φ2) ⋅ sin²(Δλ/2) c = 2 ⋅ atan2(√a, √(1−a)) d = R ⋅ c

Where:

• Δφ = difference in latitude (in radians)
• Δλ = difference in longitude (in radians)
• φ1, φ2 = latitude values in radians
• R = radius of the Earth (mean radius = 6,371 km)
• d = the distance between the two points (diagonal distance)

Estimate zoom level:
Based on the diagonal distance, Google Maps provides a rough way to estimate the zoom level, which is typically from 0 (world) to 21 (street level). A common approach is to map the diagonal distance to zoom levels using a logarithmic scale, but this depends on the map's current bounds and the projection used. Generally, a simplified formula is:

1. zoomLevel = maxZoom - log(d / maxDistance) * scaleFactor
   • maxZoom = the maximum zoom level allowed (usually 21)
   • maxDistance = the maximum diagonal distance you want to show (e.g., distance across your entire map's viewable range)
   • scaleFactor adjusts for the desired map fit

Using Google Maps API to Simplify:

You can simplify this calculation by using the Google Maps API, which has a method to fit markers within a viewport using fitBounds():

// Assuming you have an array of venue locations in {lat, lng} format: const locations = [  {lat: 40.748817, lng: -73.985428},  {lat: 40.748217, lng: -73.985128},  // Add other venues here ]; // Create a bounds object const bounds = new google.maps.LatLngBounds(); // Extend bounds to include each venue locations.forEach(location => {  bounds.extend(new google.maps.LatLng(location.lat, location.lng)); }); // Create a map with the bounds set const map = new google.maps.Map(document.getElementById("map"), {  center: bounds.getCenter(),  // Center map at the average of the venues  zoom: 15  // You can let Google automatically choose the zoom or set a default }); // Fit map to the bounds map.fitBounds(bounds);

This method will automatically adjust the zoom level and center based on your venues, ensuring all the locations are visible without scrolling. You don't need to manually calculate the zoom level if you're using this approach.

HomePage (Photos) and Interests Page

• If the hyperlink is blank it should do anything when clicked.

CMS Photo

• When editing, if the file is loaded, don't show the input box
• Make the unique identifier just three letters
• Increase the size of the photo in the Edit field much larger
• Make the Hyperlink adaptable to include rhe https// and www 
• Improve the title on the Edit page

Bugs in live systems vs ATSTemplate

• MapIcon, Business Types and Business Contacts imports don't work on stephen-nurse.com
• Winter Cash Cup: Upgrade from ATS didn't work

Users

• VCF export not built
• Show each user's log count, counting the number of times the number has logged in. 
  • Hover to show the date/time of the last [5] view

Company Details

• Doesn't save the Driving Instructions. Can't save edits
• Wrap google map link

Website contacts

• Add a delete all button
• Include the phoneChceker into the index view

Project specific landing page post login for different access rights

Have in the Settings a flag for if site is still in testing mode.

• If in Testing mode, then:
  • Login screen contains the test login buttons

Photo gallery

• Don't open the photo-locations page unless an Admin and there are at least [15] different locations
• Instead show the name (and date and # photos) of each location in the dropdown.  Listed either alphabetically or by date (make that a control in the Settings)
• Then have the private groups listed, in red

Photos

• Individual photo doesn't resize well when viewed by a mobile

HomePage - All photos

• The photos don't have the hyerlink or the title pop-up working

Header

• Useful links show/hide doesn't seem to be in all projects

Multi-lingual

• Make the titles in Indexes language-specific

Competitors

• Improve field names

User Import

• No longer works as the SetRoles line needs to reference the Roles entity

ROLES

• Doesn't seem to work

User

• Photo field showing when populated.   

Photos

• E-mail fails
• Handling of favourites

User log

• Build out a more comprehensive user tracking log.  Not just logins .  Google analytics

Business contacts

• The File and Photo fields show when not empty.  Copy JS found in Company Details Edit form

Header

• Photo Gallery and Photos appear twice in the Header if logged in as ADMIN

Useful Articles

• Create a “Useful articles page” with some helpful topics.    

New functionality: Import from Outlook

• I am building a system to manage client bookings and although i would prefer that clients book online directly, some do email me.  I would like to build the ability to import the content, subject line and sender and date from my email system (eg Outlook) email into a record in the database
• My plans is that emails that need to be brought into the booking system would be moved to a specific directory (eg “Upload to system”) and these are the emails that the booking system would see and extract the data from.  The booking system would need access to the email 
• I am using Symfony/PHP - how can i build this?

Delete from phphmyadmin:

• aphroditetenniscup
• chartwellcourt
• irishpassport (dev name is irishpassports)
• parknride
• visitweimar

Multi-currency flags don't work

Instructions

• Control in Company Details to include a link to instructions functionality.   
• Show in dashboard if selected. 
• Include in Header display selections

Contacts details (Company Details settings)

• Flag to include business card or not 
  • Business card to include only the information permissioned 
• Perhaps include email as  

Instructions page

• Nesting problem

User

• Default language - order by ranking

Workflow from Website Contact to User

• The objective here is to automate the process of converting a Website Inquiry into a User
• Form received from client (in Website contacts).  
• To do
  • Allow multiple entries on the checklist
  • Add field in Products for “Include in Contact Form” and references in the Contact Us form
  • Add input in CompanyDetails as to whether to receive an alert with a new Inquiry
  • And ‘Email’ text in Product form
• Office_Staff decides to accept a Website Inquiry or not (perhaps automate this). 
  • Converting to User creates a New User with the credentials provided in the Website Inquiry. 
  • Sends a generic email
•  

Helpful guides

• Seems to take Products as well as Helpful Guides.   Do I need the checkbox if picking Helpful Gudes?

Useful links to pages

• Create a page (thinking of gwenny) that contains a list of topics. 
• In Product, create a boolean “includeInHelpfulGuides” which brings the Products into the Guide

Business Contacts

• Use the White-space:No wrap and in-line style settings to make sure the names line up and the map icon appears on the same line as address

User photo 

• Delete doesnt work

Photos

• Handling HEIC photos

Roles

• https://chatgpt.com/c/67c36d52-da60-8004-bd25-35abfd4ef594

Office directions

• Ensure is multi-lingual
• Waze icon

User import

• Doesn't seem to work

Deprecated: Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter::__construct(): Implicitly marking parameter $registry as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/DoctrineParamConverter.php on line 46

Deprecated: Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter::__construct(): Implicitly marking parameter $expressionLanguage as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/DoctrineParamConverter.php on line 46

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::__construct(): Implicitly marking parameter $twig as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/TemplateListener.php on line 39

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::__construct(): Implicitly marking parameter $language as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/SecurityListener.php on line 43

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::__construct(): Implicitly marking parameter $trustResolver as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/SecurityListener.php on line 43

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::__construct(): Implicitly marking parameter $roleHierarchy as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/SecurityListener.php on line 43

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::__construct(): Implicitly marking parameter $tokenStorage as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/SecurityListener.php on line 43

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::__construct(): Implicitly marking parameter $authChecker as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/SecurityListener.php on line 43

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::__construct(): Implicitly marking parameter $logger as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/SecurityListener.php on line 43

Deprecated: Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::__construct(): Implicitly marking parameter $authChecker as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/EventListener/IsGrantedListener.php on line 33

Deprecated: Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter::__construct(): Implicitly marking parameter $class as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/Configuration/ParamConverter.php on line 61

Deprecated: Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter::__construct(): Implicitly marking parameter $converter as nullable is deprecated, the explicit nullable type must be used instead in /var/www/html/linkedinexport/vendor/sensio/framework-extra-bundle/src/Configuration/ParamConverter.php on line 61

Page visits. 

• Can we remove certain IP addresses (ie me) to avoid overwhelming the count
• What about adding google analytics to show original of links

Login Direction

• Table too wide

Photos

• Don't change the filename upon upload

CMS Copy

• Sort the CMSCopy by Product ranking

File Attachments

• The delete file button doesn't work and the file input is viewable when populated

CMS Copy/Format

• I have placeholder field in all the CMS_Copy records called CMS_Format.  It includes the different tricks to format the page (Accordian etc).   
• Can you wire them up and make them work so we can have a different formatted page?

I want to improve the look and feel of our websites.  My plan would be to build a set of different CMS type inputs (initially in ATS) and then rollout to all all projects.

At the moment, I only have the ability to split the pages into “with photo” or “no photo”,  The photo is on the right and I can include a carousel if I add >1 photo.  But there are lots of other things that I can't do…

For example, have a look at this site for example:   https://www.stgeorges.ch/school-life/school-transport and specifically at this subpage:   https://stgeorges-enrichment.lovable.app/

Things we can;t do:

• Grid of links under Enrichment Activities or
• Carousel under the World Class Facilities. 

In ATS

I started thinkg about this in the past, but never finished it. 

I defined a set of ‘formats’ to apply to each CMS page.  The list is in the entity “CMSPageFormats”  which is what I was going to employ to generate the various features, using diffent twigs. 

At the moment, they all do the same.  So I think I will need to create blocks that I can use the standard page, then a carousel, then a xxx etc.   But each of these may need us to define info other than a single text box as currently designed (eg how many boxes, what is the text and link in each box)….        

Have a think about this and then let's discuss tomorrow

Homepage link

• Include a icon for the jump to the homepage

Homepage

• Skinny up the Contact us block.  Looks silly so wide.

Product

• In the Product Index, check to see if there is an entry in the Translation entity for the Product.  If not, add a button to create it
• How the Product translation in a tool-tip in the Index twig

Translation

• Dynamic languages in translation entity 

Company Details

• Boolean checkbox can't not be checked

Products Index

• Main/Sub label should follow the label in the CompanyDetails 

CMS

• Launching the photo into view mode doesn't work

Products

• Re-numbering/re-ordering button

SQL export

• Is the export SQL database functionality working – this will help us with testing if we can make the dev versions more similar to live to data purposes

Weather

• Weather refresh is only every 3 hours

Company details

• The show pages is not device responsive.  Unreadable in mobile

User

• Languages spoken

Company Details

• In the form, The “delete VCF photo” button deletes the QR code not the VCF photo.  
  • There is no controller for delete VCF phoot.  
  • Copy the QR code delete button  (line 240 in the controller) and link to the button in the twig 
• The WeatherLastScraped field is not well shown in the CompanyDetails edit twig. 

User

• Create fields for the GPSLocations for both HomeAddress and BusinessAddress
  • businessGpsLongitude
  • businessGpsLatitude
  • homeGpsLongitude
  • homeGpsLatitude
    • DONE
• Include buttons to take current location and populate either Home or Business gpsLocations  TODO
• Improve the user/show twig (compare to business card show) and include a map with both the addresses on them  DONE
• Hide Business or Home buttons depending on settings in CompanyDetails DONE
• In User index include the red map-marker icon if the gps longitude/latitude are present (like business contacts) DONE
• Include in CompanyDetails, in the User Profile,  a flag to include GPS (one flag for Home, one for Business) DONE

Website contacts

• Capture the products asked about. 
• In the reply it should include a list of products asks for and their description 

Team bio

• Button on user to show team members

Languages

• Confirm you can delete an icon from within a record
• Save file name in lowercase upon saving or editing

User log

• Create a user log for pages visited even if not logged in

Services Consolidator

• Let's write a quick summary of what each service does and where it is used.  
• And then merge some more of the ATS services to make the list easier in a way that is logical:
• Create a Help.doc saved in Services which contains the info we need about each one

• Suggested consolidations:

ATS_UtilitiesService

• AgeService
• CheckIfUserService
• EmailFetcher
• ICAL
• HeicImageService
• LanguagesSerivce
• LogService
• PageVisitStatsService
• RoleService
• StringReplaceService
• TranslastionService
• WeatherService

ATS_CountService (all 10)

• CountAllocatedWebsites (what does this do?)
• CountBusinessContacReferrealsService
• …..
• CountUserLogsService

ATS_PhoneService:

• FakesWhatsAppValidator[Service]
• PhoneAnalyser
• PhoneNumberValidator
• WhatsAppValidator

CMS Photo

• Add an input field in the entity that puts a title on the photo (or a flag to move it from a tooltip to a title)

Multi-lingual support

• Registration e-mails
• Products in Menu
• Menu titles

Useful URLs

• Security issues.  Non admin can't see any of the records. Inconsistent with being able to see the URL.
• I think control it through the CompanyDetails menu and hide the login and passwords.  Not secure info

User

• The display parameters in CompanyDetails no longer seem to trigger different displays in the User form

CSS

• Seem to have lost some CSS (eg the formatting of CKeditor)

Delete ChartwellCourt and VisitWeimar

• I have deleted the project on C,  and the git repositories
• Please delete anything else?

Security/Login

• I can login with a new user if their access is Admin or Super_Admin,   but not User (ROLE_USER)

Photos

• If the photo file is missing, you can't delete the record

Clear all attachments

• Button to clear public directory - assume that the directories will be made as files are saved for the first time?

 2 Jan 2026 update

1) Please pull latest changes (ATSTemplate)

Please git pull on ATSTemplate. I made minor changes overnight (not related to Services consolidation):

• Fix 1 bug in CompanyDetails
• Fix 1 bug in HomeController

2) Testing of Services consolidation

I tested the latest consolidation of Services in ATSTemplate and everything appeared to work.

I then propagated the changes using the BAT file (attached) into:

• techarete
• linkedinexport

I updated the BAT file to delete duplicate/legacy versions of some Services that have been renamed over time (mainly the “Import…” related ones). The aim is that simple projects (e.g., techarete, whistlesandbells) don’t accumulate superfluous files after running the script.

Post-update testing

• techarete (closest to “pure ATS”, minimal bespoke code): worked fine after composer dump-autoload.
• linkedinexport: initially failed until I restored these files (so they are still required somewhere in that project):
  • PhoneAnalyzer.php
  • CountPhoneLocationsService.php
  • CountUserLogsService.php

Request: Please help identify where linkedinexport still depends on these (direct usage, service wiring, or indirect dependency), and whether we should:

• keep them in ATSUtilities, or
• keep them project-local to linkedinexport, or
• refactor linkedinexport to remove dependency.

3) Next Services to consolidate into ATSUtilities

Please add these currently unconsolidated Services into ATSUtilities (with the usual wiring/config updates as needed):

• BusinessContactVCFExport
• CompanyDetailsService
• FindUser
• PhotoAuthorsByLocationService
• ProductService
• TranslationWorkerService

4) Repo structure tidy-up ideas (seeking your recommendation)

I’m considering two structural changes:

• Controllers: create src/Controller/ATS/ (or similar) and move ATS template controllers into it.
• Templates: create templates/ATS/ and move ATS template templates into it.

Please advise whether either change causes issues in Symfony, and if so what’s the cleanest way to do it. My expectation:

Controllers move should be low-risk (assuming routing attributes / service discovery still work).

Templates move will require updating template references (render(), extends, include, etc.) and should be done systematically to avoid broken links.

My view on the sub-directory changes:

A) Controllers under a sub-directory: generally safe

Moving controllers from src/Controller to src/Controller/ATS is normally fine in Symfony provided you are using attribute routes (you are) and Composer autoloading covers src/.  Symfony will still discover the classes.

Common “gotchas”:

Namespace must match folder path (e.g., namespace App\Controller\ATS;), and any references/imports updated.

If you have any config that targets controller paths explicitly (rare, but possible), it may need updating. Examples:

• services.yaml resource patterns for autowire/autoconfigure (often src/ so it’s fine)
• security access control rules relying on controller class names (uncommon)

Route names and paths are unaffected as long as the attributes remain unchanged.

Net: this is mostly an organisational refactor; low functional risk.

B) Templates under a sub-directory: also safe, but requires systematic reference updates

Moving templates under templates/ATS/ won’t “break Symfony” per se, but you must update every template reference that uses the old path.

So, do you think this is a good idea, or will it take too long?

Team Bio inclusion

• Think of a way to not just have ROLE_ADMIN in Team Bio
• Flag in User, only visible to ROLE_ADMIN?

Chrome vs Firefox

• The login script doesn't work in Chrome

vCard export (Team Bio)

• Can't handle a birthday (string expected)
• Check all fields in user and business contacts

SQL Upload into Live

• How do I upload my local sql into the live server?  TennisFInder.sql

Bugs

• CMS_photo view requires login, so errors for non users
• The secret wizard (pending reach-outs) is viewable by all

Footer

• Don't display Product title if count = 0

Autologin

• Check auto-login is working.
• Pause for bookmark

Database download

• Test the download database required to copy the live database to dev

CSS 

• Should these files be copied from the ATS Template?

Dynamic Header

• Review the include/exclude logic

Competitor

• Get Location buttons don't work in Index or Show

Services consolidation

• Does it make sense to consolidate all the ImportServices into a single one?
• And the Count Services into a single Service?
• Does it make sense to rename the Services with a ATS prefix?

Weather

• Don't refresh with a cron, but check the last time it was refreshed.   Store in settings.  and if longer than x then refresh automatically upon the index being called

Contact Box on HomePage

• if there is only 1 active product, don't show the checkbox
• Include in the CompanyDetails a checkbox to ask whether to include the tel number and or the Message question in the contact us box

Languages

• Can't edit any record.

Company details

• Change the vCard download to the posh one 

Page Visits

• Check that this is working ok
• Data at top of page should be hashed out
• Ability to reset the Homepage
• Colour code dates
  • Weekday, weekdates

Header

• Include a checkbox that says include Photo in the Title when not logged in. 

Header

• Photo header appears if there are no photos stored

Users

• I introduced sorting for all the columns (ie post pagination functionality) for the Users index.   Curiously, some work but not all.  

Business contacts

• Tried to insert the PhoneAnalyzer into Business Contacts, but it fails

Business contacts

• Handle re-imports well
• if a field is updated in import then import it, otherwise don't change

Helpful files 

• View of Useful URLs on the mobile
• Email fails with one file
• Email fails when more than one file (different error)

User Indexes

• Dynamic control of sorting in Index 

Business Contacts and Competitors

• The export function should mirror the import and add back in the Company name accordingly

Business contacts

• Map not working.  Creates an error 
  • Add a button for each Business Type.
• Improve the Admin View - Show GPS Long/Lat to 4 dps
• Index:  Sort by the ranking of the Business Types
• In Business Contact form
  • GPS button doesn't work from within the record
• In Business Contacts index, fix the count function.  Don't show empty Type to the Users (only to Admin)

Business contacts

• In Business Contacts index, fix the count function.  Don't show empty Type to the Users (only to Admin)
• Map
  • Buttons to restrict to one business type don't work.

CMS Copy and Photo overlap

• Increase size of text box
• Decide to split the screen as a function of the text ranking
• Check what happens to Accordian in CMS Format Styles?
• If non GB text is blank, return the GB text prefixed by (Awaiting translation…)

User registration

• More elegant handling of a duplicate user

Contact Us

• Don't show the Interested in… and list of Products if there is only 1 product on offer

CMS Photos

• It is possible to select Video for a JPG
• When switching between Product and Static Page it keeps the Static Page name and therefore impacts the Save

Languages

• CompanyDetails page fails if no languages in database or no English
• Doesn't seem to work in TennisClub.

Competitor Page

• We collect the address and GPS locations of the competitors but don't use that anywhere.  
• Perhaps create a map and a VCF download - similar to business contacts 

CMS

• On each product.html page include a link for admin to the product. To change the name of the product

Multi-lingual

• In Company Details control the default language, with one setting being to look at the browser language?

Business contacts map

• Map not displaying

Products

• Deleting a Product when the CMS is populated drives an error

Product

• Formatting of New and Edit are different
• From Index be able to launch the Page
• Nowrap on arrows
• Add a button to add 3 CMS and 3 Photos or +new from the index 

Multi-Lingual (Languages)

• Flag import fails.  Possibly because file already exists?

Registration

• Email fails
• Need to test the full process

Map Icons

• New/Edit:  Selection of icons to be sorted alphabetically

New functionality: Glossary

• Add a new entity called Glossary or Help
• Creates a page with some background that can be linked from another page.  But shouldn't be in the main drop-down menus

Mobile view - needs work.

• CompanyDetails Show/Edit
• Products
• CMS- Edit/New is good
• SubPage
• CMSPhoto- index only
• UsefulLinks - ok
• Instructions -New
• Weather -ok
• Business contacts - New and Edit
• Map Icons - edit
• Facebook Groups - Index and Edit
• Competitors - New

User

• Create a field in CompanyDetails that permits or not “Auto login” from a given unique URL
  • Each User gets a unique URL, which will log them into the site with their name
  • Construct a controller that does that login for them

Login Directions

• Functionality doesn't seem to work

Business contacts

• Test that the file attachment and photo get deleted if you delete a contact

Users

• Error message when adding a birthday “datefmt_create: invalid locale: U_ILLEGAL_ARGUMENT_ERROR”
• Make the flags on the User/index saveable fields in the CompanyDetails page, so the standard can be saved for each application 
  • Add conditionality so that unnecessary flags are hidden in both the User View and in Company Details

WhatsApp number

• Develop a service that checks if a number is a valid WhatsApp number or not

Doctrine update - Entities not working

• Instructions
• Weather
• Facebook Groups
• Competitor
• Competitor Service

Check backdoor functionality

• Doesn't work in ComfyCats (live)

Company Details 

• Button to add Longitude and Latitude into the Company Details record
• Can't save changes (since adding Photos)

Photo Gallery

• Email button doesn't work
• Favoured/unfavoured button don't work

Transfer

• Clicking out an accommodation does not delete it

Transfer

• The number of Child and Babies should be capped at (Total Pax -1)
  • ie If the total passengers is 5, you can't have 3 children + 2 babies.   Assumption is that there is always 1 adult
• In the booking Notes we should include ages of children.  or should we make this a new field?  (ChildAges,  BabyAges)?  As free text. 

• Multi-lingual functionality:
  • Include in the CompanyDetails entity a field called ‘multilingual’ (booelan)
  • Create new entity called ‘Languages’ containing, language (English, French, German, Spanish) , flag icon file,  and abbreviation
  • Selection of flag switches language of text
• Page count
  • Add field in the Products entity for pageCount and pageCountAdmin
  • When a page is loaded add to the pageCount (and if an Admin user add to pageCountAdmin only

Shared Transfers

Conceptual overview:

• The Shared Service is a bus service from LeChable to Verbier (about 10mins drive) that can be shared by multiple passengers allowing people to complete their journey without hiring an expensive taxi
  •  It is a bus with up to 13 seats.  
  • LeChable is where the train arrives, at the bottom of the mountain. Verbier is the mountain village where the skiers stay.   
    • Uphill (arrivals, at start of holiday):  LeChable→ Verbier 
    • Downhill (departures, at end of holiday): Verbier →  LeChable
• There is a Shuttle (ie a bus available) for every train that starts/ends at LeChable that goes to/from GVA.  Typical tourist from, say London….
  • Arrival:   
    • Flight: London→ GVA
    • Train:  GVA→ LeChable
    • Shuttle bus:  LeChable→Verbier  (uphill)
  • Departure:   
    • Shuttle bus:  Verbier→LeChable (downhill)
    • Train: LeChable → GVA
    • Flight: GVA→ London
  • Therefore
    • The uphill shuttle (LC→V) is derived from the fight arrivals and then matched train GVA→LC (working forward from the flight arrival time)
    • The downhill shuttle (V→LC) is derived from the fight departures and then matched train LC→GVA (working backwards from the flight departure time)
• Each passenger is assigned to their best shuttle according to their flight details.  See flight_trip index - which assigns them to the best train time.
• Let's first assume infinite capacity for the Shuttle and then consider how to limit the seats.

Assigning Transfers to a Shuttle Bus 

• A “Shared” Transfer (in a booking) needs to be assigned to a shuttle 
• This is important as there are limited seats and the shuttle driver needs to know who they are picking up and where they are taking them to
• Also, I want to be able to see the list of shuttles and how many seats are booked (and free = 13 - # booked), as during the day as flights are late/early people may need to be bumped to earlier/later shuttles.   This should only applies to the Arrivals (Uphill) shuttles as  people will take their chosen Shuttle on the Departures (downhill) in time to catch their planes (ie we are ‘upstream’ of any flight delays).  But we should be able to bump people up down the shuttles schedule easily/quickly and indeed enable the user to do that themselves (we should send them an email/whatsapp when we think they are on their train and confirm etc). 

Pricing

• There is also the pricing of Shared to consider

Transfers

• Add 3 new fields – 1) “Price Adjustment” (float) and 2) “isSharedAllowed” (boolean) and “sharedTransfers” (relation linked to Transfer Entity – ManyToMany).

1. Price Adjustment:  Each transfer will have a price, which will be composed of the “standard price” plus the possibility of a manual ‘adjustment’ (which most of the time is zero).  The adjustment might be positive or negative and for example might be because the customer wants something special (eg snacks/drinks in the car, or a stopover en route) etc.   The “standard price” will be calculated from the destination combination (eg VRB to GVA), the number of passengers and potentially the time of day, and we will designed an entity to capture that.   And the Price Adjustment is a manual input.   The standard price is  computed dynamically – but I want to save it in case the formula changes as we can’t change a price already given (hence a field is required. Make sense?
2. IsSharedAllowed.  The concept I want to introduce here is that I want to offer people the ability to share a taxi. Typically the vehicles will take 7 people, so if you are a family of 4, you have 3 spare seats.  I will only allow a share if the others are on the same flight/train (if inbound – as sometimes flights are late and don’t want any additional waiting) or within [10] mins for a flight/train departure.   So if a client says yes to “isSharedAllowed” we will try to combine and split the costs.
   1. To do that we might need  to link transfers together using the sharedTransfers  field which will contain which transfers are being combined  (typically 2 clients (ie 2 transfers) but could be more, eg   4 passengers +2 passengers +1 passenger) And then we can assign all [3] transfers to the same vehicle/driver….
3. For the train pickup service that is the same concept – we will have a bus (say 13 seats) that can take various combinations of passengers to fill it (could be 13 single travellers).  That service will take people from LeChable train to their chalets in Verbier.    Does that make sense?

Client confirmation button

• I want to be able to launch the client confirmation button either in (1) new mode or (2) direct to send (with a popup confirming).   
  • This is because if i know I amnot going to edit the confirmation before sending what is the point in shwoing the screen
  • How to display:  Double-click to go stright to send?
• In the top right corner of the booking, show the history of the confirmations sent similar to the booking index view

Transfer

• 3 buttons at the top:
  • ‘Save’ -  This updates the database but returns the user to the same screen (ie opens the Edit if new or stays on the Edit if in Edit mode)
  • ‘Discard’ - Closes the screen and doesn't save.  Prompt a "Are you sure?
  • ‘Save & Close’ - Saves the record and returns to the Bookings Index
• Cancel transfer
  • This is essentially a new field. All the details are saved, but the transfer will disappear from (or zero costs) in any bills or from the driver's manifest
• City- Address
  • The chalet name disappears after 2-3 seconds.   
  • The search should include the Affiliate name, so I can search for “Bramble”
• Cancel button should be in Extras

SBB

• Fix SBB scrape to include all the trains for the day (currently just taking 4-5 trains (one screen's worth), whereas I would expect there to be 30-40 trains per day (for GVA to Martigny as an example)
• I think SBB changed the design of their page?

Bookings index

• In each transfer (T1..T4), show as much info as possible
  • Flights.  Blue for Arrival, Green for Departure.  Hover for flight details including scheduled and actual times.    Show a warning sign if later than x
  • Completed trips background colour green
  • Accommodation via a popup (name, address. afiiliate, diff access)
  • Times shown in icon with error sign if missing or late

Bookings

• Show updated flight details in each booking, including flight times when departed/arrived 

Flight trips

• I am developing a PHP symfony PS project that looks at flight times.  I have 2 sources for the scheduled flight times (departure and arrival) data and i want to use both to cross-check.  My fields  are respectively  1) scheduledDepartureTime and scheduledDepartureTimeGvach  and 2) scheduledArrivalTime and scheduledArrivalTimeGvach
• In order to save real estate on the page I want to consolidate this data to a single figure, but have colours identify any discrepancies.   My thought is that the display should be (using departures es the example)
  • If only the scheduledDeparture time is present (and the scheduledDepartureTimeGvach is null), then display the scheduledDeparture, in grey
  • If both scheduledDeparture  and scheduledDepartureTimeGvach  are availablen and the the same then display either one (scheduledDepartureTimeGvach) in black
  • If both are available but are different by more than 10mins, the show scheduledDepartureTimeGvach  in black with red !, with the ability to show the scheduledDepartureTime via a tooltip/hover

Taxi site

• Track the history of the flights to build up a picture as to the on-going schedule
• Email Hermes to see if they will send us the scheduled flights

Email Template

• if the field AffiliateBooking is set to “Direct to Consumer”, then:
  • Set specificAffiliate to null
  • Set aggregateComfirmation to "Single Booking"
    • and hide these 2 fields

Flight scrape

• Saves the kayak link into the Details Link - whereas this should be used for the GVA.CH scrape
• Duplicates seem to still being produced (eg if you run the scrape a second time)
• Doesn't seem to detect or save the airline code.
  • Plus airlines have created a bunch of blank airlines (linked to flights - ie can't delete)
• Does scraping make more sense, as the airline is shown in the drop-down?   https://www.justfly.com/  

Feedback on Transfer Macro

• The time box should be a format for time (24hrs) and width should match the dates
• Date should show the DoW (eg Sun 16 May 2025)  TODO
• Destination
  • Should be sorted by “SortOder” and then alphabetically on "City"-  with a break before ‘20’ TODO
• Handling Destination is a "Train Station"
  • If you change the Destination from a City to a train/airport (eg from Verbier to Martigny Train) then the From Address field should switch to  Train time/Flight 
• When Destination is a City (eg Verbier), the Accommodation dropdown needs to contain all the information (see attached screenshot). 2 lines required for each address: 
  • Symbol to indicate the “Type”
    • ‘House’ for a Chalet
    • ‘Knife and fork’ for a Restaurant
    • ‘Office building’ for a Hotel
  • Then show the Chalet Name, Apartment  details, and then the Affiliate (in brackets)
  • Then line below should have the street and house number
• Looking at the database entry for the Transfer:
  • PassengerName and PassengerEmail and PassengerMobile should not be inherited from the Booking.  
    • This is an over-ride should the transfer not be in the name of the Booking. So unless populated manully, it should be null
  • Trip date should be not nullable.  Time should not be nullable but have a TBD over-ride or (TBD checkbox)
  • Should we rename TripXX to TransferXX in all the fields?
  • The addressStart and addressEnd still seems to be a string field rather than a relation field related to the Accommodation entity
    • We need this to be linked because the driver will be given various info points from the Accommodation entity (eg Door Code, GPS location, Driver notes, Client notes, Associated Resort Contact).   But there neeeds to be a manual over-ride “Other” available
• Layout of Pax Child/baby.  Try to get on 1 line

• The Hide/Show extra fields
  • The Passenger Name/Email/Mobile should be here.  (These are the “over-ride ones in case the names is not the same as the Passenger details for the ”Booking" as a whole
  • Delete Button should be hidden
  • There should be a “Cancel trip flag” - which is similar to delete but retains the info for document record keeping purposes
  • Notes needs to be a bigger field
  • The timestamps can be indicated in pop-ups without expanding the section.  The user will only expand if they want to edit  - which is rare as the times are generated by the system.

Feedback on the Booking section (on the left)

• When you save the booking, you should show the ID of the “Booking”.  This is the customer reference number
• Client email and client mobile should be nullable
• Client details should be saved in the Clients entity if unique (ie that database grows) 
• Status should be: Confirmed/Inquiry/Cancelled  (no need for cancel booking field)
• Booking history:  This should save the logged-user and time of creation
• Payment link expiry:  First trip date time less 24 hours
• Still has the word “Transfers” on the bottom left

Feedback on Transfer Macro

• Date should show the DoW (eg Sun 16 May 2025) 
• Destinations
  • Should be sorted by “SortOder” and then alphabetically on "City"-  with a break before ‘20’ (or different colour)  (this is because the first 5 or 6 are the common ones, and the others are rare) 
  • Add buttons change order, but keep 20 as 20

Clients

• Can't make entity
• Add new fields:
  • Total PV
  • Summary data
• Add link to their trips
  • 12month PV
  • List of bookings, with first date and PV

Affiliates

• if this can be done in less than 1 hours….  as it will only take 2 hours to do it manually…
• Cycle through each of the afffiliates and extract all of the data (including the icon) and either save to a CSV or import directly into the Affiliates entity
  •  http://alpexstage.caponica.com/controlroom/affiliate/1/edit 
  • Login: kd
  • Password: 35East38th
• Do not need to collect the following data:
  • Image file if difficult - I can collate manually (it is a 10min job to do all of them)
  • SMS recipients (this is probably stale info by now)

Accommodation

• Cycle through the list of accommodations and extract all the details.  All info available in the Index and no need to go into each record, but need to open 23 different pages
• http://alpexstage.caponica.com/controlroom/accommodation/list

Resort contacts

• Import the Resort Contacts.  
• Need a new entity for them,,  User with ROLE_RESORT_CLIENT
• Add a new entity ResortContact and create new record alongside new User

Clients

• Extract all client info (188 pages) from this view.
• http://alpexstage.caponica.com/controlroom/customer/list

New Booking

• When switching direction, retain the address (and date).  Delete the flights (if applicable)
• If Shared, add a link to the SBB train times (on the correct date and direction)

New booking - from email 

• Ability to ‘suck in’ an email into a Booking.
• The contents of the Email  (include To: From,  Date, cc, Subject and the main body) should be brought into a single field which is appended at the bottom of the Booking screen (full width of screen and deep).
• The email from field should populate the Booking.Email field.  
  • Think of it this way.  Say we get the following email from john.smith@gmail.com “Subject:  Reservation request for Smith family…    Body: Hello Alpinexpress,  I would like to book 2 transfers.  the first on 1 March 2026, picking up at Geneva airport. We are on EZ 1234 from gatwick. we need to go to Chalet Makini in Verbier.  We are 3 people.    And we are returning a week later on the flight EZ23456 at 11.30am.   thank you, John Smith +44 758877444444”
• We should be able to see the full email (not just the body, but also the email address of sender, date/time and subject) and then we can make sure we have uploaded the email accurately and kept a record of that in the booking.
• In truth it is really for auditing and to help the booker convert an email to a set of transfers 
• Systematically, it needs to pull in the From, CC, Subject and Body fields from the email, and format nicely into a single field.   Then it should fill name the client email with the senders email.  That's it.    Does that make sense? 
• We have some of this functionality already - just not bringing it into a new booking. 
• The process of adding a new booking should move the email to DONE directory 
• In Company Details we have fields that define where to look in the email for new bookings and where to place them once uploaded. And the email login and password - do you remember that?

Customer confirmations

• Launching the email from the Booking menu - where you have 2 choices, namely to edit or just send as standard.    
  • The edited version should open in a new tab (target =_blank) DONE
• Looking at the formatting
  • The email fragments placed at the bottom of the page seem to be within the ‘grid’ so don't use the full page. DONE
  • I think at the top of the page you should show the To and CC fields and make them editable.   DONE
  • Can you widen the grid so that the text doesn't wrap? DONE
• Tab titles - Bookings and Client Confirmation emails DONE
  • Currently they are all the same ("VBC-1234 (Stephen Nurse)"), so you can't tell if it is a booking page, or confirmation page.  
  • Suggest we update the tab title to enable us to distinguish and include some more key details (status and affiliate)
    • Booking: 
      • [B] at the start, to indicate booking.  Or can you have an icon (ticket icon)?
      • [PT] is all Privates, {ST} is all Shared, [PST] if a combination 
      • Can we add green tick/red cross/grey question-mark to indicate status
      • If affiliate, then affiliate code in bracket (eg BS, which is the code for Bramble Ski)?
        • <Ticket-icon> [PT] <green tick>: 13085: Stephen Nurse [BS] 
    • Emails: 
      • Perhaps an envelope icon to start to indicate an email
      • Affiliate code in bracket (eg BS, which is the code for Bramble Ski)?
        • <Envelope-icon> [PT] <green tick>: 13085: Stephen Nurse [BS] Shared Shuttle
  • The heading for Uphill text says “Drop-up address".  Should be “Drop-off”
• Save vs Send
  • Can the email actually be sent so we can see how it looks in Outlook or on a phone.   STILL TO DO
  • Set send address to nurse_stephen@hotmail.com or your email while we are testing
• Deleting a booking
  • Should delete all associated confirmations too (cascade).   We will disable this button in live

Booking

• The status field  (confirmed, enquiry, cancelled) can never be null.   DONE
• For the Shared Shuttle,  no need to display the text in red at the top (9 km, 20 mins  Suggested Time:xxx).  This is helpful for Private Transfers, but is known for the Shared  DONE

Imported emails

• What's the difference between:
  • http://localhost:8000/emails_import/index
  • http://localhost:8000/booking/index_pending_emails
• index_pending_emails view:
  • Display date as 12-Nov-25  DONE
  • Sort by date+time DONE
  • The text includes formatting code “1 private transfer from V-Verbier to GVA.&nbsp; To get flight to LGW at 3pm.&nbsp; 5 pax”       DONE
    • Show the first 2-3 lines,   Hover over to show the full text  DONE
  • Perhaps show the number of bookings with that email address as counter (to help indicate if a regular/important customer)  DONE

Confirmations

• http://localhost:8000/client_confirmations/index
• Include sorting buttons, similar to booking. 
  • Must be searchable by Booking ID and/or name and/or tel number
• No wrap on all columns  DONE
• Include a button on a confirmation that takes you to all emails on that booking specific booking DONE
• Booking ID→ ID to save space DONE
• Show content with a hover. DONE
• By-  show initials and hover over for fullName. Save space.  Auto -  show computer icon   DONE

Transfers

• The Cancel button should be a checkbox, that can be unchecked to allow the transfer to be uncancelled
• Add a ‘Copy’ button that copies all the details of a given transfer, and does a Save-Re-Open too.     
  • This is because we are often asked to do similar trips (eg pick up the family at 8am to take to school Mon, Tues, Weds)
• Without opening the Extras section, we should be able to see the content, if populated, in the Transfer main box, using icons and title/hover
  • For Passenger Name
  • For the Driver, show the Departed and Arrived Times via icons and the mins late/early  (see template/transfer/parts/trip_times_body.html.twig)
• By the accommodation, if picked from the dropdown list, have a link to the accommodation/show record and also a pop-up box(es) with all the content summarised
  • Key icon for door-code
  • Warning icon if Difficult Access
  • 3 Notes fields (Driver Icon, User Icon, Office icon)
  • Map marker

Booking

• If there are more than 1 transfer, they transfers should be ordered by Date-Time, and ordered Transfer#1, Transfer #2, Transfer #3 etc
• Cancelled transfers should appear in the list (in order) but without a Transfer number
• Why does the Zero Commission and Follow-Up Flag display differently?
• Fields for notes doesn't expand when typing
• Last edited time/user required 

Email confirmations and history

• Under the Customer Details (below mobile) have an icon/link to customer confirmations,  It should include the count sent and a link that shows all confirmations for this booking
• Similarly for WhatsApp messages

Flight selector in New Booking

• Find a date where there are flights available.
• Select “LGW” (for London Gatwick LGW)….   Initially this will show the LGW flights but then shows others

Transfers

Destination is a City

• If the Destintaion IS a city (for either the start or end of the transfer), we need to show the dropdown list of accommodations to know where to pickup or drop off.  Include the possibility of "Other"
  • Save the accommodation id if picked from the dropdown (ie not ‘other’)
  • If Other, save the input in a new field
  • We will need 2 fields as we may have new locations in both the pickup and dropoff . Create two new fields
    • addressStartOverRide
    • addressEndOverRide 
• Note: if the Destination is NOT a city (eg airport or train station), then do not show the address field at all (as there is effectively only 1 address)

Destination is a Train Station

• If the Destination is a Train station, ask for train time and perhaps the origin/destination location.  So the 2 fields are
  • trainTime (time)
  • trainOriginOrDestination (string)
    • Depending on whether Transfer picks up at Martigny or drop offs, we can work out the direction of the journey and check the times.   But as far as capturing data- these are the 2 fields

Destination is an Airport (eg GVA)

• We need to know the flight details (time, airline, city of origin or end) for both for (1) pickups from at airport (ie where the transfer starts at GVA)  and (2) drop-offs at the airport (ie where the transfer ends at GVA)
• However it is the case that only one of the Start or End is an airport  - (ignoring the case where we are picking someone up at one airport and driving them to a second airport to take another flight - that never happens)
• So while we need to capture the details of the flight (airline, flight number, destination/origin city, time) if not found in the flight database. we can work out if it is a departure or arrival from whether the Transfer is picking up or dropping off at the airport. So in the Transfer Entity you can use the same fields for Over-rides on the flights
  • flightOverRideAirline
  • flightOverRideFlightNumber
  • flightOverRideFlightTime
  • flightOverRideFlightCity

Destinations

• Add the following fields:
  • Default address (used for airports and train stations)
  • Default longitude and latitude 
  • Notes

Accommodation Street

• Add a field “defaultLongitude” and “defaultLatitude”. 
  • This is used to guide the map function when none of the buildings on that street has a GPS location….  That will allow you to  allocate buildings to the street numbers

New Bookings (default settings)

• Automatically add 1 transfer, with certain default assumptions.  
• Create records in the SystemSettings entity to define the default settings.   
  • DestinationStart  (eg “GVA”)
  • DestinationEnd  (eg “VRB”)
  • Date: Following [Saturday]
  • Passenger #: 1
  • Baby:0 Child: 0 
  • Add 3 buttons on each transfer
    • Delete transfer (in hidden fields, next to cancel)
    • Copy transfer (in hidden fields). This makes an exact copy of the transfer details other than the assigned driver/vehicle and times 
      • Imagine being asked to create a series of transfers like the same pickup from chalet X to go to ski-lifts every day of the week at say 7am. Easiest way to do that is to create it once, then copy changing the day by +1 day
      • Importantly, do not copy the driver/vehicle details as these are not assigned and history is unique (ie when the driver arrrived)
    • Return trip - this reverses the To/From.  Make the date 1 week later.  Same number of passengers.  Not hidden - bottom right (could be an icon)
• Create fields called lastSaved and savedBy  
  • (I have created them already) , that stores the time of last saved.  
  • Show time and initials in top right. of screen
    • These seem to still appear at the bottom of the booking page on the left
• CreatedBy and CreatedOn fields  are not being saved at the moment
  • Moved to bottom of page, in light grey

Email received into the mailbox

• Ability to import in an email into a Booking.
• Populates the “EmailImport” field with the content
• Popluates Client-email from the sentFrom field of the email
• Will need to save in the website the email login and password and the directory (i.e. "_Taxi Bookings To Be Uploaded”)  to look into. 
• When the import is done, it moves the email to a new directory (i.e. "_Taxi Bookings Uploaded”)

New booking

• For taxi drop-offs at train stations, add the ‘10’ mins required to buy their ticket to the travel time
  • eg     Train time : 12;00 ;  drive time =  32mins,   then leave Verbier time is 12.00 - 32mins -10mins = 11:18
• For all drive times add 5mins and multiply by 1.1  (dynamically controlled in settings).
• Airport bookings
  • Is showing the Geneva flights for Zurich Airport or Sion Airport.   It needs to match on airport too.  Let's add some Zurich and Sion flights to test 

Flight Index

• Where the train times are shown in the view, hover over to show the 2 preceding and 5 following train departure times.
• When a flight arrival is delayed, show the new expected train time and the previous one in a warning box

Populate flights

• The challenge is to get the Flight data populated such that you have the schedule of flight past and present as far as possible.
• For the updated times (ie delays/cancellations) you need to scrape the live site from the airport (eg gva.ch for Geneva airport,  https://www.hermesairports.com/flight-info/arrivals-and-departures-pfo for Pathos)
  • So practically there are two tasks, 
    1. Build the forward schedule (so clients can book a trip say 2 weeks in advance
    2. Check and update live times on the day of the flight. 
       1. And the objective is to then marry that data
       2. In absence of the list of flights, can we scrape kayak for all the destinations served by the airport to build a list of flights?
• Chat GPT tells me the PFO site is easy to scrape as simple HTML, but the GVA site is harder
• The basic idea is that we should get updated flight info from the live sites (gva.ch for Geneva and https://www.hermesairports.com for Pathos) but use aviationstack free account to get the schedule a rolling 3 months in advance   
  • https://chatgpt.com/share/684f8ea5-7768-8004-9627-b77cddf8a50f
• On Tuesday, can you work on the scrapers for PFO and GVA?

Transfer_macro

• When you have a flight, display the flight details so easy on the eye - presumably this can be der0vied from the flight id:
  • Flight #/airline
  • To/From
  • Either the Scheduled Departure (for depatures) or Arrival (for Arrivals) time
  • Updated time (ie delays etc)
• In the Transfer_macro, when spooling through the flights, only show the flights where the Date of the flight equals the date of the trip and the ‘direction’ is correct, namely:
  • Airport pickups: (ie meeting clients at the airport and taking to the resort- i.e. destinationStart = Airport) - then we are meeting a flight arrival
    • If transfer.destinationStart = 'GVA",  then look for flightTrips where flightTrip.arrivalAirport = destinationStart  
  • Airport dropoffs: (ie depositing  clients at the airport and starting from the resort- i.e. destinationEnd = Airport) - then we are meeting a flight departure
    • If transfer.destinationEnd = 'GVA",  then look for flightTrips where flightTrip.departureAirport = destinationEnd  
• Compute the pickup time derived from flight or train times
  • For pickups it is the flight/train arrival time plus the baggage time (eg 20mins for flights, 2mins for trains)
  • For drop-offs  (going to the airport), you have to work backwards from take flight time…. less commute time (see routes entity) and the check-in time allowance ,
    • System Settings contain the airport and train station delays

Live site.

• Setting up the login https://axtools.atts-systems.com/backdoor   causes an error. This is part of ATS, but I can't replicate on ATS
  • “An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'pause_for_bookmark' cannot be null”

New booking 

Client search

• The client dropdown list of ‘matching’ clients only displays the client name and their email address. The phone number is not displayed 
• However, you can search by tel number, even if not displayed
• If you select a client in error, perhaps there could be a quick way to reset? 

 Chalet address

• If a selected accommodation is picked, it should not show the Other Address
• And if you do select Other, it seems to maintain the link to a prior address

Date selection

• Online (users) should not be able to select a date in the past. Nor too far ahead (eg 6months)
• In the backend, we should allow historic dates but a warning flag to show if the travel date is in the past

Billing

• Payment link not required if Outstanding = 0
• Outstanding calculation is not correct.   Doesn't include the surcharges to the Trip prices, nor capture the Paid amount. 

New/Edit Booking

• When the Destination is a City….
  • Standard: If the address is selected from the list of accommodations, can you put the chalet name in the original dialogue box, with a ‘x’ there to change, and the address etc in the line below. 
  • Other:  If the selected address is ‘Other’, it doesn't display the accommodation details when reopened in Edit mode.   It does save in the DB and can be accessed in the index.html.twig
• Check database (StartAddress, StartAddressOverRide, EndAddress, EndAddressOverRide) and how they change if you change Destination.  Specifically, changing the Destination (eg Verbier change to [Chamonix]) should clear accommodation if selected from the dropdown list (as that would be in Verbier)

Transfer #1

• The default transfer #1 on a new booking is a trip from GVA to Verbier on the next [Sunday]. 
  • However the transfer_macro does not offer the user a list of flights.  One has to switch to another destination and back to GVA to trigger the population of flights (need to confirm if still true)   Let's wait to test on Saturday when we can upload some flights to test

Transfer #2

• When adding a new transfer(trip 2), the defaults should be:
  • Date: Date of trip #1+ 1 week
  • Destinations:  Same as trip #1 but in the opposite direction 
  • Accommodation:  Same as trip #1

New booking

• Flights should be sorted as follows:
  • GVA pickup (ie Flight Arrivals): By scheduled flight arrival time
  • GVA drop-offs (ie Flight Departures).  By scheduled flight departure time 
    • Note, by "scheduled" I mean the gvach if it exists and the plain scheduled one if not
• Departure times from trips to/from an airport not computed yet.  Should reference the flight arrival or departure times with the formulas agreed.

Client confirmations

• As well as saving the client confirmations, can the confirmation be sent out
  • While testing hard-code the To field to: nurse_stephen@hotmail.com
  • Should we use the Live/Testing field in CompanyDetails for this?

Email fragments

• I have added another fragment for Shared_Waiting_List.   
  • That doesn't follow the other logic so the inclusion criteria should look at the Name of the template (eg Shared_Waiting_List) or something similar.  

New Booking.

• When you save a New Booking, it selects ‘1’ for the ZeroCommission and followUpFlag fields, even if unchecked.  This is the form (same for both): 

->add('followUpFlag', CheckboxType::class, [
    'required' => false,
    'empty_data' => false,
    'label' => 'Follow Up',
])

• The dropdowns are slow and repeatedly trigger.   Most notable is for the Client Name/email/tel  and the flight details

Managing the shuttles

For Arrivals.

• Look at scheduled flight arrival time
• Find next train to LeChable that is at least 45mins post scheduled flight arrival

For Departures

• Look at scheduled flight departure  time
• Find the first train to GVA from LeChable that arrives at least 2 hours before the scheduled flight departure time

Pricing

• In Settings create a formula for the derivation of a price derived from
  • Entity:  HighVolume Days
  • Early start time/ Late finish time/premium
  • Weekend
• Shared price P1, P2, P3, P4, P5, P6, P7, P8

Accommodation

• Dropdown list in a new Transfer to show only relevant accommodations (ie those from that City
• Include a chalet name (no GPS) for testing purposes 
  • If no chalet GPS show location of street?

Client phone numbers

• Including details of the tel number (country code, PhoneAnalyser - confirm if the number is “verified”) 

Client site (public pages)

• The “Book Now” page on the public site collect a basic booking (One-way or Return to the same routes -  ie only 1 or 2 journeys, same combinations).   
  • The backend can be used for more complex ones.
  • Unlike a backend booking, we should sequence the collection of data….  ie the client wants to know prices and options first, before typing in their details and payment details. 
• This site does it brilliantly:  https://www.mountaindropoffs.com.  
  • Please try making a fake booking (don't save anything, just click out before payment - they are nice people) their site.  
  • It is amazing and super well thought out site. Best in the business. 
• This is what you will see.  All on one page but with tabs to make it quick 
  • Step 1 is picking the dates and destinations
    • Number of pax
    • Destination list
      • Nice details: Return date can't be before Outbound date
      • Second journey defaults to the reverse of First journey
        • Dates remembered if you unclick Return and back again
  • Step 2 is flight data or address and then the service type/price
    • If airport: flight
    • if non airport:  Address
      • Then picking the Shared/Private/Private+ with price 
  • Step 3 is collecting contact details, names/emails/telephone/babies etc and luggage
    • Nice way to get international codes
    • Look at the extras (babies, luggage)
  • Step 4 payment
• The design of this is 100% optimal (the owner is very experienced and logical) and we did exactly the same, but my old site has been changed so I can't show you that

Dashboard

• Create a AXTools specific dashboard (ie not Standard/Advanced) as this is getting crowded

Ops Warnings

• Build out a list of Transfers (not bookings) where certain aspects are unclear on the booking
  • Accommodation unknown
  • Flight unknown
  • Follow-up flag marked 
  • Missing client emails or phone numbers
  • Phone number check
    • Email link to client for confirmation

Calendar page

• Develop a calendar page with the same look/feel as alpinexpress.com
• Example: Alpinexpress_calendar

Payment Made

• Ability to add multiple in one pop up