Project

General

Profile

Actions

Task #25

open

Create Businesss Listing

Added by Dana Basheer about 2 months ago. Updated about 2 months ago.

Status:
Resolved
Priority:
High
Assignee:
Start date:
01/08/2026
Due date:
01/08/2026 (57 days late)
% Done:

0%

Estimated time:

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.

Actions

Also available in: Atom PDF