Task #37
openBusiness Listing View (Listing & Display)
0%
Description
*Display Services List
Show all available services posted by users based on location and category.
*Service Detail View
Display complete service information such as title, description, provider details, and location.
*Filter & Search Services
Allow users to search services using keywords and apply filters like category and place.
***Table: user_skills_services (Service View)
*id-INT (PK)-Service ID
*user_id-INT (FK)-Service provider
*category_id-INT (FK)-Service category
*skill_service_id-INT (FK)-Master service
*skill_title-VARCHAR-Service title
*description-TEXT-Service description
*place-VARCHAR-Service location
*latitude-VARCHAR-Latitude
*longitude VARCHAR Longitude
*created_at DATETIME Service created time
*Each record represents one service provided by a user.
*Used to populate service listing pages and service detail pages.
*Helps users discover nearby services easily.
***Validations
*Only active services should be visible to users.
*Services must be linked to a valid category.
*Services without mandatory details (title, category, location) should not be displayed.
*Pagination should be applied when service count is high.
*Deleted or blocked services must not appear in service view.
Updated by Dana Basheer about 2 months ago
- Subject changed from Service View (Service Listing & Display) to Business Listing View (Listing & Display)
*Display Business Listings
Show all available business listings added by users in a structured list format.
*Business Detail View
Display complete business information including name, description, contact details, address, and image.
*Search & Filter Businesses
Allow users to search businesses by name and filter them using category, place, district, or state.
*Location-Based Display
Show nearby businesses using location details such as place, district, and pincode.
***Table: business_listings
*id-INT (PK)-Unique business ID
*user_id-INT (FK)-Business owner (user)
*category_id-INT (FK)-Business category
*business_name-VARCHAR-Name of the business
*description-TEXT-Business description
*contact_no-VARCHAR-Contact number
*website-VARCHAR-Business website
*place-VARCHAR-Business location
*state-VARCHAR-State
*district-VARCHAR-District
*pincode-VARCHAR-Area pincode
*latitude-VARCHAR-Latitude
*longitude-VARCHAR-Longitude
*image_url-VARCHAR-Business image
*status-ENUM-active / inactive
*created_at-DATETIME-Business listing created time
*Each record represents one business listed by a user.
*This table is used to populate:
*Business listing page
*Business detail page
*Category and location fields support filtering and search.
*Status field controls business visibility.
***Validations
*Only businesses with status = active should be visible to users.
*Each business must be linked to a valid category.
*Business listings must contain mandatory fields (business name, category, location).
*Inactive or deleted business listings must not appear in business view.
*Duplicate business entries by the same user should be avoided.
*Pagination should be applied if the number of businesses is large.
*Business images must be of valid format and size.
Updated by Nivya Mariyam about 2 months ago
- Status changed from New to In Progress
Updated by Nivya Mariyam about 1 month ago
- Status changed from In Progress to Resolved