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?

Villa import from Airbnb

• Can we extract the GPS location?

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

Villa description

• Need to translate the “About this villa” text into every language.  
  • Should we use the Translation entity or multiple entities in the Villa entity? I think the Translation entity. Agree?

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

New Booking (when not logged in, ie as consumer user, not admin or user)

• Apply the phone Analyser to the Guest phone field
• Hide the Language field, but store it (records what language they looked at the website in)
  • Make the confirmation in English and their preferred language
  • bcc sjwn71@gmail.com in all confirmations (as we test)

Emails

• Check that the emails are working (cc'ing the 3 recipients defined in the  villa )
• Save the emails in database and show link in booking

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)

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

Owner

• Test logging in as non-Admin, but as an owner and see what you can do.
• Owners (non-Admin) should be able to edit their villa(s) including the text, rates and see bookings for their villa only.

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 

Villa Photos

• Photos not filling the page very well and being top/tailed on homepage

Multi-lingual

• How do i handle the option that different villas want different languages?

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

Stripe

• Set up Stripe to take payments

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

"Owner" entity

• Objective is to define which User (or Users) have admin rights to each villa
• This entity has two fields:  Villa and User
  • Both are relational fields and the User one is multi
  • Villa field cannot be null
  • Sort each dropdown by fullName (User) and name (villa) respectively. 
  • In the index show some of the key villa_details as a lookup into the Villa entity
    • Address
    • Contact First/Last name
    •  Wesbite URL (which launches in new window)
• Admin rights enables those permitted users to:
  • Administer the “Villa” settings
  • Set Seasonal Rates
  • See and reply to bookings
• Have link to it on the Standard Dashboard, say near the seasonal rates

On mobile

• Date fields are not aligned nicely

Voucher scheme

• Establish a discount code system for returner

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.

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. 

Version of Calendar

• Create a table view of the Calendar so Users, Admin and Owners can see multiple villas in one view
• See attached xls to illustrate what it should look like
• Filter buttons for Month and City of Villa

Export and imports 

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

1. Market Intelligence — highest development priority

Your current scraper collects valuable raw observations: 30 different stay durations for each arrival date, repeated across villas.

But owners won't want to look at 30 columns of numbers. They want to know whether they're charging the right price, how their competitors are performing and what they should change.

Daily price reconstruction

P0- Convert total stay prices into understandable daily rates: Minimum stay and discount detection

P0 - Identify 3-, 7-, 14- and 28-night restrictions or discounts Competitor comparison dashboard

P0 -  Compare similar villas over the same dates. Scheduled scraping

P0 - Automatically build historical price data. Availability change tracking

P1 -Identify newly blocked or reopened dates.Pricing recommendations

P1 -Highlight where an owner appears expensive or cheap.Historical pricing charts

P1 - Show how prices change as arrival dates approach. Automated owner reports

P2 - Send weekly insights by email

A. Daily pricing reconstruction

This is probably the most intellectually interesting part of the project.

Your existing T+1 to T+30 observations are total stay prices, not daily prices. The task is to infer underlying nightly rates and distinguish them from length-of-stay discounts.

• Ordinary nightly rates, potentially varying by day.
• Minimum stay requirements.
• Weekly and monthly discounts.
• Additional cleaning and service fees.
• Inconsistent or incomplete observations.
• Prices that cannot be reliably decomposed.

My suggestion: Create a derived DailyRate dataset while preserving the original PriceHistory observations. Assign a confidence level to estimated nightly rates rather than assuming every price can be explained perfectly.

B. Competitor comparison

I would let an owner select their villa and see comparable properties within the same resort.

Importantly, compare like with like. A beachfront four-bedroom villa with a heated pool isn't directly comparable to an inland three-bedroom property.

C. Availability and estimated occupancy

Because you'll collect snapshots over time, you can observe when previously available dates become unavailable.

That gives you a potentially valuable occupancy indicator.

However, unavailable does not necessarily mean booked. The owner may have blocked dates for personal use, maintenance or bookings through another channel.

I would distinguish between:

• Confirmed bookings on your own platform.
• Dates unavailable on Airbnb.
• Estimated booking activity inferred from changes.
• Uncertain or missing observations.

Market these as estimated occupancy and booking signals, not verified competitor revenue.

2. Direct Booking Platform — what still needs doing

I would concentrate on six areas. You already have pieces of several of these, so the objective is to close the gaps rather than rebuild them.

A. Villa onboarding and website generation

P0 - Make it possible for a new owner to go from an Airbnb listing to a usable direct-booking website with minimal manual work.

Import or enter descriptions, photographs, facilities, bedrooms, occupancy, check-in rules, location and seasonal prices. Add a publication-readiness checklist and website preview.

B. Booking and availability reliability

P0 - Ensure the pricing engine handles seasonal boundaries, Saturday-to-Saturday restrictions, gap nights, cleaning fees, deposits, discounts and cancellation rules.

Test overlapping bookings, delayed calendar synchronisation, simultaneous booking requests and failed payments. Provide a booking confirmation and modification workflow.

C. Owner portal

P0 -  Owners should be able to update their own photographs, descriptions, rates and blocked dates, view upcoming bookings, and see enquiries and customer details.

Keep permissions restricted to their own properties, with straightforward navigation rather than a large administrative CMS.

D. Direct booking conversion

P0-  Add a clear booking quote, mobile-friendly date selection, visible total pricing, WhatsApp enquiry, guest reviews where legitimately available, and a simple reservation process.

Crucially, show the customer the benefit of booking directly rather than through an OTA.

E. Repeat-customer marketing and CRM

P1 - You already have Return Clients and discount functionality. Extend this to guest history, discount codes, repeat-booking links, targeted offers and scheduled campaigns.

Include consent/marketing preference records, unsubscribe functionality and access controls.

F. Owner financial reporting

P1 - Show booking income, occupancy, average daily rate, revenue per available night and estimated commission savings.

This creates a tangible financial explanation of why owners should continue using CyprusVillasDirect.

One particularly important point is calendar synchronisation. Airbnb currently states that imported calendars refresh automatically every three hours, rather than instantaneously. Your system therefore needs to handle the double-booking risk inherent in iCal synchronisation, especially if you offer instant booking.

3. Commercial features — potentially more important than further coding

You need a repeatable way of acquiring and retaining villa owners.

I would build a simple owner acquisition funnel:

Identify villa owners -  Target villas in Pissouri, Aphrodite Hills, Coral Bay and Polis -  Show an individual market report -  How their villa compares with similar local properties -  Offer a direct-booking website -  Demonstrate commission savings and repeat-customer benefits - Convert to paying customer

Booking commission, intelligence subscription or combined package

I'd add an internal sales CRM to track the owner, villa, location, contact status, demonstration, activation and first booking. Keep it very simple.

Potential revenue models

Direct booking

5% of bookings generated

Market Intelligence Basic - €19/month

Market Intelligence Pro -  €49/month

Combined package - 5% booking commission + €29/month

 Your previous assumption was that 100 villas might be achievable and that perhaps 20% of their bookings could migrate away from Airbnb.

The commercial question I'd test first is whether owners will pay for Market Intelligence without first receiving additional bookings. That would make it a much more attractive standalone business.

4. Infrastructure and product risks

There are several areas I'd address before investing heavily in scale.

Airbnb data access. Airbnb's current European terms prohibit unauthorised automated scraping. Your batch scraper therefore has a genuine contractual and business-continuity risk.1

Before making the entire Market Intelligence product dependent on it, evaluate licensed short-term-rental datasets or authorised integration arrangements. Providers such as AirROI advertise market and calendar data products, but coverage, reliability and commercial usage rights need validation.

Data integrity. Save observation timestamps, query parameters, currency, guest count, fee treatment, failures and the source of each price. Otherwise, historical price comparisons can easily be misleading.

Scalability. Move bulk acquisition into queued jobs with retries, checkpoints, request limits and monitoring. Keep historical snapshots instead of overwriting earlier observations.

Privacy and payment security. Protect guest contact records, handle consent correctly, use a payment service provider rather than storing payment-card details, and implement role-based access and audit trails. For marketing, existing-customer relationships do not automatically permit unrestricted promotional emailing.

5. My recommended development sequence

Given your limited development resources, this is the order I would follow.

Development priorities

Check items off as you implement them

0/12 complete

Phase 1 — Make the existing data useful

Daily price reconstruction

Normalise total stay quotes and identify discounts

Competitor comparison screen

Show prices for comparable villas and dates

Scrape scheduling and monitoring

Automate reliable, permitted data acquisition

Initial owner report

Produce a useful, understandable pricing report

Phase 2 — Complete the booking proposition

Villa onboarding

Import or enter a villa and publish it quickly

Booking reliability

Test pricing, payments, synchronisation and double bookings

Owner self-service

Allow owners to maintain their listings and availability

Mobile booking flow

Make guest enquiry and booking straightforward

Phase 3 — Commercialise

Owner acquisition CRM

Track prospective owners and conversion

Pricing and subscriptions

Test paid Market Intelligence plans

Guest marketing

Repeat-customer campaigns and discounts

Owner analytics

Measure bookings, revenue and commission savings

Copy checklist

6. What I would deliberately not build yet

I would postpone native mobile apps, elaborate AI chatbots, sophisticated dynamic-pricing automation, full accounting integrations, multi-country expansion and extensive property-management functionality.

You don't yet need to compete with established property-management systems feature-for-feature.

Your advantage could be a much narrower proposition: a villa owner gets a website for direct bookings, can market to their previous guests, and receives better local competitor intelligence.

I would aim for an initial pilot of 10 real villa owners in Pissouri or Aphrodite Hills. Measure how many activate their websites, whether anyone receives direct bookings, and — most importantly — whether owners find the competitor reports useful enough to pay for.

That will tell you far more about the project's prospects than adding another dozen technical features.

My strongest priority would be the Market Intelligence comparison screen. You already have much of the difficult data-collection work underway; turning those observations into an immediately useful report is the shortest path to determining whether the intelligence product has commercial value.

Confirmation email

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

Client-show-villa

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

HomePage

• Add region search to the search box 

Amenities

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

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. 

ICS export  (AirbnbIcalSyncCommand)

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

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.

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.

Villa screen

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

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.

Bat file

• Include in the bat file that will copy the Language-Icon files

Contact form

• Fails to create a Website contact anymore

Bat file to update all projects at once

• Assumes that each project is saved in c:\dev

Roles entity

• Create a ranking of roles. See if you can mimic the hierarchy. 
  • ie Create a list of other roles that are granted by association

Contact form

• No longer saving a record in Website Contacts

Header

• Include image in header. Like Olivios

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)

Backup plan

• Can the live server copy the database to c:\dev every [x] hours.  Controlled in the settings

Cms copy

• Ability to be able to add a CmsCopy and insert it as desired - effectively a re-number button 

OfficeAddress

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

Payment link

Set up a link to Stripe or similar.  Be able to copy to other projects

• Payment entity linked to the User
• Account at Stripe (use nurse_stephen@hotmail.com)

User

• Button when no email/mobile to ask for via WhatsApp or email respectfully. 
• Show last login and or no address or gps. 

SQL download

• Learn how to import into local

Homepage on iPhone screen

• When one adds the URL link to a site on your iPhone, it would be great if the icon on the homepages had some sort of icon
• Ability to resend the homescreen
• Waze button from map directions (check if works from GPS or Address)

HomePage

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

Product/Sub Product

• A way to control the URL for Interests

Useful files

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

CMS

• Ability to click to the point on the page 
• SEO optimisation

Business Contacts

• Check count

Translation export

• Finish export of Translation text for upload into ChatGPT and import into Translations

Stripe integration

User

• Reset passwords etc

Contact form responses

• Link permanently the record  in Translation with the record in Company Details (ie avoid them getting out of sync)

Photos

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

WeatherService still active and causing a deprecation

• [2025-02-07T12:25:03.392918+00:00] deprecation.INFO: Deprecated: Creation of dynamic property App\Services\WeatherService::$companyDetailsRepository is deprecated {"exception":"[object] (ErrorException(code: 0): Deprecated: Creation of dynamic property App\\Services\\WeatherService::$companyDetailsRepository is deprecated at /var/www/html/atstemplate2/src/Services/WeatherService.php:111)"} []
• ubuntu@vps-90142977:/var/www/html/atstemplate2$ tail -n 100 var/log/dev.log

Live server set up

• Automate the process to give read/write access to the public/administration
  • sudo chmod -R 775 /var/www/html/stephennurse/public/administration/Attachments/
  • sudo chown -R www-data:www-data /var/www/html/stephennurse/public/administration/Attachments/
• Write a batch file that will copy the Map-Icon and Language-Icon files,  to all the projects (or have them uploaded in the git process)

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

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

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