Task #22
openSkill / Service Listing
0%
Description
Implement functionality that allows users to create and manage skill or service listings.
User can select a category and skill/service type, provide details, and optionally add location information using map-based selection
***skill_service_listings_table
id (PK) – Unique identifier for each skill/service listing
user_id (FK users.id) – Logged-in user who created the listing
category_id (FK categories.id) – Selected category
skill_service_id (FK skill_service_master.id) – Selected skill/service
skill_title – Title of the skill or service
description – Detailed description of the skill or service
place – Location name or address (city/area)
latitude – Latitude coordinate (nullable)
longitude – Longitude coordinate (nullable)
created_at – Timestamp when the listing was created
**Validations
*user_id must be a valid logged-in user.
*category_id must exist and be active.
*skill_service_id must exist and be active in Skill Service Master.
*skill_title is mandatory and should be meaningful (min length validation recommended).
*description is mandatory.
*place is mandatory if location details are displayed to users.
*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.
*Only authorized users (admin or system-controlled logic) can update latitude and longitude if required.
*created_at is auto-generated and cannot be edited manually.
Updated by Varsha Venugopal about 2 months ago
- Status changed from New to In Progress
Updated by Varsha Venugopal about 2 months ago
- Status changed from In Progress to Resolved