As a user, I want to use a backend PHP API that fetches all tasks from the MySQL `tasks` table (id, task_name, status, created_at), sorted by creation date descending, so the Home page can display them. Must include input validation and protection against SQL injection.
As a user, I want to see the Home page styled exactly as per the mock-design (v2), including the sky blue (#87CEEB) primary color, white background, lime green accents (#32CD32), minimalist corkboard theme, sticky note visual motif, Inter font family, and all design tokens applied consistently. Remove any scaffold pages not needed (login, signup, welcome, dashboard variants) since this project requires no authentication. This task must be completed independently before all other tasks.
As a user, I want to use a backend PHP API endpoint that accepts a task id via DELETE/POST and removes the corresponding record from the `tasks` table, so I can delete tasks directly from the Home page sticky note board.
As a user, I want to use a backend PHP API endpoint that accepts a task_name via POST request, inserts a new record into the `tasks` table with status='pending' and a generated created_at timestamp, and returns the created task. Must sanitize inputs to prevent SQL injection.
As a user, I want to use the Home page frontend that implements the full mock-design (v2) including: NavBar with 'clever-tasks' wordmark, HeroBanner greeting ('Hello, Samprikta!'), AddTaskBar with rounded input and CTA button, FilterSortBar with pill toggles (All/Pending/Completed) and sort dropdown, TaskBoard with draggable sticky notes (yellow for pending, lime-tinted for completed), EmptyState illustration, TaskStatsStrip with live counts, and Footer with copyright and back-to-top link. All sections must be responsive (mobile-first).
As a user, I want to use a backend PHP API endpoint that accepts a task id via PATCH/POST and updates the task's status to 'completed' in the `tasks` table, so I can mark tasks as done from the Home page sticky note board.
As a user, I want the Home page frontend to be fully wired to the PHP backend APIs โ fetching tasks on load, posting new tasks via AddTaskBar, toggling complete status on sticky note checkbox click (with paper-fold animation), deleting tasks via trash icon (with fade-out animation), and updating FilterSortBar counts and TaskStatsStrip reactively without full page reload.

No comments yet. Be the first!