QUICKSIR

Implement a Recently Viewed feature that tracks and displays the listings a user has recently viewed. This helps users quickly revisit Ads, Business Listings, or Skill/Service Listings they checked earlier. The list should be user-specific and show the most recently viewed items first.

***Tables Used

***recently_viewed
Field Description
id (PK) Recently viewed record ID
user_id (FK users.id) User who viewed the listing
listing_type ad / business / service
listing_id Viewed listing ID
viewed_at Timestamp of view

***ads
Field Description
id (PK) Ad ID
title Ad title
is_active Active / Inactive
status Draft / Pending / Approved / Sold

***business_listings
Field Description
id (PK) Business listing ID
business_name Business name
is_active Active / Inactive
status Pending / Approved / Rejected

***skill_service_listings
Field Description
id (PK) Service listing ID
skill_title Service title
is_active Active / Inactive
status Pending / Approved / Rejected

***Validations / Rules

*Recently viewed items should be saved only for logged-in users

*Same listing should not be duplicated:

 *If viewed again, update viewed_at timestamp

Show only:

 *Active listings

 *Approved listings

*Limit recently viewed items to last 10–15 records per user

*Items should be ordered by most recent first

*If a listing becomes inactive or deleted:

 *It should not appear in recently viewed list