Task #180
Updated by Dana Basheer about 2 months ago
Create a Current Affairs Master module where admin can: * Add daily current affairs * Categorize (e.g., National, International, Economy, Sports, etc.) * Attach description, date, region, category and image/reference Also implement a public view: * Users can browse current affairs date-wise / category-wise * Useful for daily study and mock preparation **Table** vid_content_region_master * id INT (PK) Region ID * region_name VARCHAR(100) Region name (Kerala, India, International) * status BOOLEAN Active/Inactive * created_at DATETIME Created date vid_current_affairs_master * id INT (PK) Current affair ID * title VARCHAR(200) Headline/title * description TEXT Detailed content * category VARCHAR(100) Category (National, Sports, etc.) * region_id INT (FK) Reference to content region * affair_date DATE Date of news * image VARCHAR(255) Optional image path * reference_link VARCHAR(255) Optional source link * status BOOLEAN Active/Inactive * created_at DATETIME Created date * updated_at DATETIME Updated date **Validations** Backend * title → required * description → required * affair_date → cannot be future * region_id → must exist in region master * category → required * reference_link → valid URL (if provided) * Prevent duplicate Frontend Required fields: * Title * Description * Date * Category * Region * Dropdown for: * Category * Region * Date picker restrict future * Image preview before upload