🐛 Replace Ticket.search with inline regex queries
🐛 Escape user input to prevent regex injection

♻️ Replace inline Regexp with dedicated search methods Use Account.search, Gathering.search, Organisation.search and Event.search instead of manually building regexes. This centralises search logic and makes future improvements (e.g. full-text, stemming) possible without touching every query.

♻️ (check_in, orders): replace duplicated ticket-search logic with reusable Ticket.search method

🗃️ (ticket.rb): add id_string field to store string representation of id
✨ (ticket.rb): auto-populate id_string from id when id exists and id_string is blank

♻️ (search_helper.rb): move query-length guard clauses into helper
🔥 (searchable.rb): remove duplicate length checks now handled by helper

🐛 (check_in): rename param from p to secret for clarity
✨ (check_in): show friendly error page instead of plain 403

♻️ Remove redundant $match stage from aggregation

♻️ (event_tag.rb): refactor update_tags_for_select to reduce aggregation pipeline complexity

♻️ (organisation_events.rb): move filter_events_by_search_and_tags call before ordering to ensure consistent results

🐛 (event_feedback.erb): wrap answers table in conditional to prevent nil errors

🐛 Fix organisation assignment when loading event from draft

🔍️ (searchable.rb): wrap query in quotes to force exact-match search

♻️ Remove redundant cache clearing for /accounts/pay_progress fragments

♻️ Rename account_cache association to account_recommendation_cache

The old name was too generic; the new one clarifies its purpose and avoids confusion with other caches.

✨ Introduce AccountRecommendationCache model to store pre-computed people and event recommendations

♻️ (searchable.rb): replace MongoDB Atlas $search aggregation with $text $match to remove Atlas dependency

🐛 (search_helper.rb, searchable.rb): strip leading/trailing whitespace from search query to prevent empty or malformed searches

🐛 Clamp requested page to valid range when max limit is set

Prevents 500 when user asks for a page beyond the capped total. Calculates max_page from capped_count / per_page and forces page option into 1..max_page before calling will_paginate.

✨ Add PaginateWithLimit module to cap large pagination queries

Prevents excessive DB hits by limiting result sets to 10×per_page and injecting total_entries so will_paginate respects the cap.

♻️ Replace deprecated .page with .paginate for consistency All pagination calls now use the explicit .paginate(page: …) syntax instead of the shorthand .page, ensuring uniform behavior across the codebase and avoiding future deprecation warnings.