QUICKSIR

Implement a global search feature for Business Ad Listings that allows users to search businesses by keyword and select a specific location using a popup. The popup should enable users to choose State, District, and Area or select a point on the map to find relevant and nearby business advertisements. Only active and approved business ads should be displayed.

***Tables Used (Reference Existing)
business_listings
Field Description
id (PK) Unique business listing ID
user_id (FK) Owner of the business ad
category_id (FK) Business category
business_name Name of the business
description Business details
state State name
district District name
place City/Area
latitude Location latitude (nullable)
longitude Location longitude (nullable)
status Listing status (Pending/Approved/Rejected)
is_active Active/inactive flag
created_at Created timestamp

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

***Validations

*Search keyword is mandatory

*User must select a location using the popup (State/District/Area or map selection)

*Only active locations should appear in the popup

*Latitude and longitude must be selected together (map-based selection)

*Latitude must be between -90 and +90

*Longitude must be between -180 and +180

*Only active and approved business ads should appear in results

*Invalid or empty search or location selection should show a user-friendly error message