Push notification system added

Deep links fix

Partner Cafes Get Priority Cafes attached to a cafe admin account now float to the top of neighborhood playlists and personal playlists. Playlist covers automatically pick a partner cafe first, so verified spots represent the neighborhood. Verified Badge Everywhere Partner/verified cafes now show a small checkmark badge next to their name across all playlists, the feed, popular list, and borough tiles — not just inside the pin details page. Unified Cover Photos Cover photo priority is now consistent everywhere: site admin override → cafe admin pick → newest user photo. Admins can override any cafe's cover from the pin sheet, and it wins across playlists, the feed, and detail pages. Cafe Admin Profile Tab Cafe admin profiles now show their assigned cafe in full detail instead of a generic "cafes contributed" list, with the detail sheet auto-opening. WiFi Editing for Cafe Admins Cafe account holders can now edit WiFi details on their assigned cafe, same as regular admins. Neighborhood Auto-Assignment All 8 previously submitted cafes were backfilled with correct neighborhoods. Going forward, every approved cafe submission is automatically reverse-geocoded and placed in the right borough playlist. Leaderboard Cleanup Cafe admin accounts are now excluded from the leaderboard — only regular community members appear.

What's New in Coffice Passwordless Sign-In Replaced the email/password flow with a single-screen magic link sign-in. Enter your email, tap the link in your inbox, and you're in — no passwords to remember or reset. Same flow handles new accounts and returning users automatically. Optional referral code field on the sign-in screen so first-time users can credit a friend. Clear "No password needed" explainer so nobody wonders what to type. Partner Dashboard (for café partners) Brand-new Partner Dashboard for verified café accounts and admins, with month-by-month performance data per café. Tracks views, saves, photos, community notes, and confirms for every partner café. One-tap CSV export for the selected month. Automatic syncing: assigning a café account now flags that location as a partner — Partner Dashboard always reflects who's officially onboarded. Powered by three new SECURITY DEFINER RPCs (get_cafe_views_count, get_cafe_favorites_count, get_cafe_stats) and a new index on cafe_views for fast reads. Playlists, Organized by Borough Neighborhood playlists are now grouped by borough (Manhattan, Brooklyn, Queens, etc.) instead of one endless scroll. Each borough shows a handful of playlists with a "See all" button to expand. Cleaner two-up grid on mobile. Refined borough mappings so Alphabet City, Koreatown, Gramercy Park, the Bowery, Stuyvesant Heights, and Bedford all live where you'd expect. Larger, more consistent typography across personal and curated playlist titles. Feed Upgrades New user search bar above curated playlists — find people by username or full name in under a second. Truly infinite scroll — fixed a cursor bug so the feed now loads activity all the way back to mid-2025. Feed CTA for guests reads "Continue with email" to match the new passwordless flow. Favorites by City Your favorites page now groups cafés by city, the same way playlists are organized by neighborhood — much easier to scan when you've saved spots across multiple cities. Referral System v2 Switched to referral codes (8-char) shared via https://app.cofficecafes.com/?ref=CODE. Codes are auto-captured from the URL on first load, logged in referral_clicks, and applied on sign-in. Both referrer and referee receive 3 Coffice Beans on a successful redemption — with safeguards against self-referrals and double-redemption. Audit fixed the silent failure where codes weren't being captured at all. Mobile Polish Pin-detail top-right actions (visited, heart, playlist, close) are now always tappable, even when long café names wrap. Photo lightbox close button respects the iOS safe area — no more hidden X under the notch. "Check your email" card sits lower on mobile so it's visible above the keyboard. Followers/Following sheets float above the navigation bar instead of being hidden behind it. Swipe-back gestures work consistently across Playlists, Leaderboard, Notifications, and Feed detail pages. Standardized safe-area top padding across Admin Feedback and other secondary pages. Quality of Life All input fields are 16px+ to stop iOS from auto-zooming when you tap them. Silent sign-in: no celebratory toasts on login — you just land in the app. Sign-in confirmation links hard-coded to https://app.cofficecafes.com so the magic link always points to production, never localhost or preview URLs.

What's New in Coffice **Coffice Beans & Tiers** Earn Beans by adding cafés, uploading photos, confirming info, completing your profile, creating playlists, and referring friends. Four tiers: Drip → Flat White → Cappuccino → Barista, displayed as badges throughout the app. Track your progress on the new /beans page. **Feed** New Feed tab between Map and Playlists. Browse community activity — new cafés, photos, and notes — plus a curated playlists row at the top. Toggle between global and friends-only views. Includes WiFi copy-to-clipboard, shareable links, and like/comment functionality. **Playlist Upgrades** Playlists are now bookmarkable, owners can add a description/bio, and followed playlists appear on your profile. Playlists without cover photos show a clean text tile. Admin bookmarks notify the playlist creator. **Trending Cafés on the Map** Trending cafés pulse with a soft ember glow on the map (top cafés by 24-hour views). Each trending pin shows a "Trending now" chip with view count. **Verified Café Accounts** Admins can grant Café Account status, adding a checkmark badge, cover photo, editable bio, and a "Claimed by café" transparency line. Owners can edit their pin's name, address, WiFi password, and cover photo. **Admin Tools** New /admin/submissions page to review, geocode, and approve user-submitted cafés. Admins receive notifications for new cafés and photos. **Design & Motion** Luxury frost-glass design system: warm sand backgrounds, espresso accents, frosted panels, and editorial typography. Spring-press buttons, staggered entrances, shimmer skeletons, and haptic nav feedback. **Search & Discovery** Search now surfaces locally-added cafés alongside Mapbox results, tagged "Saved." Fixed search-to-pin flow so the detail sheet and all actions work reliably. **Notifications & Streaks** Infinite scroll notifications. Streak ring: a 7-day pie-chart countdown that shifts green to red as your weekly café-addition streak approaches reset. **Referrals & Leaderboard** Every user gets a unique referral link; both referrer and referee earn Beans. Leaderboard now has tabs for Cafes Added, Beans, Photos, and Community Notes, with rank, username, tier badge, and count per row. **Quality of Life** Post-add toast with quick shortcut to add another café. Duplicate pins merged. Followers/Following sheets slide up from the bottom on mobile. Feed deduplicated and layout standardized across all pages.

Whats new in Coffice * Geolocation auto-fly — MapView.requestUserLocation now flies to the user's position when permission is already granted, and triggers the native prompt (then flies + starts watching, or marks denied) in the prompt state. Refactored updateUserLocation to take a {lat,lng} object. * UserProfile header alignment — removed the sticky header in src/pages/UserProfile.tsx and switched to pt-16 pb-2 so the back arrow + title line up with the Playlists page header on mobile (no more cutoff). * Pin detail header overflow — removed the "marked as visited" inline label in PinDetailSheet that was widening the header row and causing horizontal scroll inside the sheet. * Visited button tooltip — title attribute changed to simply "Visited" when active (was "Marked visited").

What's New in Coffice A polish-focused update with a smoother, more consistent experience across the whole app. Photos — Community photos are now tappable. Open any café photo fullscreen and swipe between them. Profile — Fully redesigned for mobile. Tabs (Playlists, Notes, Visited, Cafés) now scroll horizontally and the layout stays locked and consistent. Community Notes — Likes now save instantly and no longer flicker when you tap them. Navigation — Fixed routing from profile and playlist pages so the nav bar always takes you to the right place. Design — Page headers, grids, and section titles are now aligned consistently across every screen for a cleaner, more native feel. Location — Removed an unwanted location permission prompt that appeared on some devices. Haptics — Added haptic feedback throughout the app for a more tactile, native feel.

What's New in Coffice Personal Playlists Create your own curated collections of cafes! Name your playlist, add a description, and build it your way. Add cafes directly from the playlist page with a built-in search Public or Private — toggle visibility with a simple switch Share playlists with friends via a rich share card featuring the playlist name, cafe count, and your @username Community Playlists Discover playlists curated by other Coffice members. New "Community Playlists" tab on the Playlists page Browse public playlists from users across all cities Tap any creator's @username to visit their profile Public User Profiles Visit any user's profile to see their contributions and playlists. Tap @usernames anywhere in the app to visit profiles See someone's pinned cafes, playlists, and stats Follow / Unfollow other users Map Filters Filter cafes on the map to find exactly what you need. Opening Hours See when cafes are open — right from the pin detail sheet. Hours displayed in a clean, collapsible section Shows today's status at a glance Photo Lightbox Tap any cafe photo to view it full-screen with a smooth lightbox overlay. Cafe Submissions Think a cafe is missing? Submit it directly from the app for review. Visited Cafes Track the cafes you've been to with a simple visited/check-in system. Achievements & Badges Earn recognition for your contributions to the Coffice community. Reply to Community Notes Join the conversation — reply directly to community notes left by other users. WiFi Teaser for Guests Non-signed-in users now see a "Sign in to see WiFi details" prompt on every cafe, encouraging sign-ups. Navigation Everywhere The bottom navigation bar is now accessible on every page — notifications, leaderboard, user profiles, and playlist details. Other Improvements Clickable @usernames on community playlists and playlist detail pages Share arrow icon on playlists for a cleaner look Add to Playlist from any cafe's detail sheet Cafe view tracking for popularity insights Various performance and UI polish improvements

What's New in Coffice Smarter Location Handling The app now properly checks your actual location permission status before showing any banners. If you've already granted permission, it skips straight to finding nearby cafés without bugging you. Nearby Cafés Fixed The Nearby list now correctly shows only cafés within walking distance (0.8 miles) of your location, sorted by proximity. Previously it was showing recently updated cafés regardless of distance. Faster Performance, Lower Bandwidth We've optimized data fetching to reduce Supabase bandwidth usage: Added aggressive caching so the same data isn't fetched repeatedly Limited queries to only the fields needed (no more SELECT *) Capped result sets to prevent loading the entire database at once Leaderboard Layout Improved The Leaderboard page now starts at the same vertical position as other pages for consistent navigation.

Whats new in Coffice Coffice has expanded beyond New York City. • 9 new cities added: San Francisco, Chicago, Boston, Los Angeles, Washington DC, Seattle, Austin, London, and Paris • New city selector on the map — switch cities instantly • Neighborhood playlists now filter automatically by selected city • Community submissions open in all new cities • Bug fixes and performance improvements Know a great work café in your city? Tap 'Add a spot' and help build the map.

What's New - Coffice 2.0: 1. Real-time location tracking — Your position on the map now updates continuously without needing to close and reopen the app. The blue dot moves smoothly as you walk. 2. "Locate me" button — A new location arrow button on the map instantly re-centres the view on your current position. It automatically hides when the nearby cafes card is expanded. 3. Amenity tags on café cards — Every café card now shows pill-shaped amenity indicators for WiFi, Outlets, Quiet, Busy, Space, and Bathroom. Green pills highlight strong amenities; grey pills indicate unrated categories awaiting community input. 4. Amenity tags on café detail pages — Opening any café now shows the full set of amenity pills with color-coded ratings (green = good, yellow = ok, red = poor, grey = not yet rated) so you can see workability details at a glance. 5. Workability scores in Favorites — Favorites cards now display the workability score badge, matching what you see in playlists. 6. Smarter café search — Updated to the Mapbox Search Box API with proximity bias, so searching by business name returns nearby results first. 7. Workability survey after pinning — The workability survey now reliably opens immediately after you pin a new café. 8. Early Contributor badge — The "first contributor" popup now only appears once per user, so you won't see it repeatedly. 9. Improved ranking — Top 30 cafes with equal likes are now ranked by workability score as a tiebreaker.

Whats New in Coffice Community Notes, Upgraded We've completely refreshed the community notes experience. Notes are now cleaner and easier to read, with author names and timestamps. You can now like community notes — think Reddit-style upvotes — to surface the most helpful tips from fellow Coffice users. Notifications Never miss when someone appreciates your contributions. A new notifications page (accessible from the bell icon on your profile) shows you who liked your community notes, which note they liked, and at which cafe. Unread notifications are marked with a badge so you always know when something's new. Smarter Playlists Cafes with user-uploaded photos now appear first in neighborhood playlists, followed by cafes with wifi passwords filled out. This means the most complete and helpful listings are always front and center. Wifi Passwords at a Glance You can now see wifi password previews peeking out on playlist cards — just like the nearby cafes list. Sign in to unlock the full details. Cover Photos Selected cover photos now properly display across the app — on playlist headers, cafe cards, favorites, and nearby lists. We also cleaned up cafes that were showing incorrect or placeholder images. Annual Goals Your cafe goal tracker now resets each January 1st and lets you view your progress by year — compare your 2025 discoveries with your 2026 adventures. Founding User Badges Early contributors who helped build the Coffice community with notes and data now sport a Founding User badge on their profiles. Bug Fixes - Fixed an issue where searching for a cafe wouldn't navigate to its pin on the map - Removed orphaned placeholder entries from the database New Map Engine - Switched from Google Maps to Mapbox GL J — faster loading, smoother panning/zooming, crisper vector tiles, better mobile performance Improved Search - Search now powered by Mapbox Geocoding API (replaces Google Places) - Faster, lighter search with no external script loading Neighborhood Playlists Overhaul - All cafés reassigned to neighborhoods using zip code–based rules instead of rough coordinate bounding boxes - New neighborhoods added: Tribeca, Murray Hill, Midtown East, Midtown West, Ridgewood, Two Bridges - New database trigger auto-assigns neighborhoods for future café additions Workability Score on Playlist Cards - Cafes now have a workability score

Community Notes, Upgraded We've completely refreshed the community notes experience. Notes are now cleaner and easier to read, with author names and timestamps. You can now like community notes — think Reddit-style upvotes — to surface the most helpful tips from fellow Coffice users. Notifications Never miss when someone appreciates your contributions. A new notifications page (accessible from the bell icon on your profile) shows you who liked your community notes, which note they liked, and at which cafe. Unread notifications are marked with a badge so you always know when something's new. Smarter Playlists Cafes with user-uploaded photos now appear first in neighborhood playlists, followed by cafes with wifi passwords filled out. This means the most complete and helpful listings are always front and center. Wifi Passwords at a Glance You can now see wifi password previews peeking out on playlist cards — just like the nearby cafes list. Sign in to unlock the full details. Cover Photos Selected cover photos now properly display across the app — on playlist headers, cafe cards, favorites, and nearby lists. We also cleaned up cafes that were showing incorrect or placeholder images. Annual Goals Your cafe goal tracker now resets each January 1st and lets you view your progress by year — compare your 2025 discoveries with your 2026 adventures. Founding User Badges Early contributors who helped build the Coffice community with notes and data now sport a Founding User badge on their profiles. Bug Fixes - Fixed an issue where searching for a cafe wouldn't navigate to its pin on the map - Removed orphaned placeholder entries from the database

This update addresses the following fixes: 1. Fixed Supabase session persistence so users stay logged in after inactivity 2. Fixed location permission being requested repeatedly after inactivity 3. Implemented optimistic UI updates across the app for faster response times on favourites, badges, and profile updates