Task #39
openAd View (Ad Listing & Detail Display)
0%
Description
*Display Category List
Show all available business categories.
*Category-wise Navigation
Allow users to browse business listings based on selected categories.
*Subcategory Handling
Display parent and child categories in a structured format.
***Table: categories (Category View)
*id-INT (PK)-Category ID
*parent_id-INT (FK)-Parent category
*name-VARCHAR-Category name
*slug-VARCHAR-URL-friendly name
*is_active-BOOLEAN-Category active status
*created_at-DATETIME-Category creation time
*Used to populate home page category section.
*Helps users filter business listings easily.
*Supports structured navigation across categories.
***Validations
*Only active categories should be visible to users.
*Categories must be unique and clearly named.
*Parent–child category relationships must be correctly maintained.
*Categories without business listings may be hidden or disabled.
*Categories should be sorted alphabetically or by priority.
Updated by Dana Basheer about 2 months ago
- Subject changed from Category View (Category Listing & Navigation) to Ad View (Ad Listing & Detail Display)
*Display Ad Listings
Show all published ads to users based on category and location.
*Ad Detail View
Display complete ad information such as title, description, price, images, and seller details.
*Ad Image Display
Show multiple images related to an ad in a proper sequence.
***Table: ads (Ad View)
*id-INT (PK)-Ad ID
*user_id-INT (FK)-Ad owner
*category_id-INT (FK)-Ad category
*location_id-INT (FK)-Ad location
*title-VARCHAR-Ad title
*description-TEXT-Ad description
*price-DECIMAL-Ad price
*price_type-ENUM-fixed / negotiable / free
*status-ENUM-published / expired
*created_at-DATETIME-Ad created time
***Table: ad_images (Ad Image View)
*id-INT (PK)-Image ID
*ad_id-INT (FK)-Related ad
*image_url-VARCHAR-Image path
*sort_order-INT-Image display order
*created_at-DATETIME-Image upload time
*The ads table provides the main ad details for listing and detail pages.
*The ad_images table stores multiple images per ad, improving visual clarity.
*Ads and images are combined to render a complete ad detail view.
*** Validations
*Only published and active ads should be visible to users.
*Ads marked as expired, rejected, or inactive must not appear in the ad view.
*Each ad must be linked to a valid user and category.
*Ads without mandatory details (title, category, description) should not be displayed.
*Images should be loaded only from valid ad image records.
*Deleted ads must be hidden immediately from the user interface.
Updated by Anna Ann about 1 month ago
- Status changed from In Progress to Resolved