QUICKSIR

Implement a user-side page that allows logged-in users to create, view, and manage their business listings. Users should be able to submit business details, select category and location, and optionally add map-based coordinates. Listings should follow an approval workflow and only approved, active business ads should be visible to other users.

Tables Used (Reference Existing)
***business_listings

Field Description
id (PK) Unique business listing ID
user_id (FK users.id) Owner of the listing
category_id (FK categories.id) Selected business category
business_name Name of the business
description Business details
contact_name Contact person name
phone_number Contact phone number
email Contact email (optional)
website Business website (optional)
state State name
district District name
place City/Area
latitude Location latitude (nullable)
longitude Location longitude (nullable)
status Pending / Approved / Rejected
is_active Active / Inactive
created_at Created timestamp

***categories
Field Description
id (PK) Category ID
name Category name
is_active Active/inactive

***locations
Field Description
id (PK) Location ID
parent_id Parent location
name Location name
type State/District/City/Area
is_active Active/inactive

***Validations

***User-Side Form Validations

*Business Name – Mandatory, minimum 3 characters

*Category – Mandatory, must be an active category

*Description – Mandatory, minimum 10 characters

*Contact Name – Mandatory

*Phone Number – Mandatory, numeric, 10–15 digits

*Email – Optional, must be valid format if entered

*Website – Optional, must be valid URL if entered

*State / District / Place – Mandatory (must be active locations)

***Map & Location Rules

*Latitude and longitude are optional

*Latitude & longitude must be saved together

*Latitude range: -90 to +90

*Longitude range: -180 to +180

*Manual typing of coordinates should be blocked (map-only selection)

***System Rules

*Users can only edit their own listings

*New listings default to status = Pending

*Only Approved & Active listings are visible publicly

*Inactive categories/locations must not appear in dropdowns

*User cannot create two active listings with the same business name