Project

General

Profile

Actions

Task #22

open

Skill / Service Listing

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

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

0%

Estimated time:

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.

Actions #1

Updated by Varsha Venugopal about 2 months ago

  • Status changed from New to In Progress
Actions #2

Updated by Varsha Venugopal about 2 months ago

  • Status changed from In Progress to Resolved
Actions

Also available in: Atom PDF