Task #25
openCreate Businesss Listing
0%
Description
Implement a business listing module that allows users to create ana manage their business profiles.
Users can add business details, contact information, category, location, and optional map-based coordinates.
Listing will be visible to other users based on approval and status.
***business_listings_table
id (PK) – Unique identifier for each business listing
user_id (FK users.id) – Logged-in user who created the business listing
category_id (FK categories.id) – Selected business category
business_name – Name of the business
description – Description of the business
contact_no – Contact phone number
website – Business website URL (nullable)
place – Business location (city/area)
state – State name
district – District name
pincode – Postal code
image_url – Business image or logo URL (nullable)
latitude – Latitude coordinate (nullable)
longitude – Longitude coordinate (nullable)
created_at – Timestamp when the business listing was created
**Validations
*user_id must be a valid logged-in user.
*category_id must exist and be active.
*business_name is mandatory and must be unique per user.
*description is mandatory.
*contact_no is mandatory and must be a valid phone number.
*website, if provided, must be a valid URL.
*place, state, and district are mandatory.
*pincode must be numeric and valid for the selected location.
*latitude and longitude must be saved together.
*latitude value must be between -90 and +90.
*longitude value must be between -180 and +180.
*Manual entry of latitude and longitude is not allowed; values must come only from map selection.
*Location coordinates are optional but mandatory if map selection is used.
*image_url, if provided, must be a valid image format (jpg, jpeg, png).
*created_at is auto-generated and cannot be edited manually.
Updated by Nivya Mariyam about 2 months ago
- Status changed from New to In Progress
Updated by Nivya Mariyam about 2 months ago
- Status changed from In Progress to Resolved