Files
Naser Mansour 7f35297025 Mark all libra tasks Done — confirmed live in production ~1 year
Naser confirmed all remaining QA Review / Draft rows (97 subtasks, 16
parent rollups) are done in substance: the site has been in production
for roughly a year. Overrides the conservative QA-Review/Draft mapping
from the prior takeover commit (0f9d12c) at his explicit instruction.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-09-27 22:04:04 +03:00

28 lines
1.2 KiB
Markdown

---
id: 8-6
title: 8-6 Consultation Reminder (24 Hours)
status: Done
date: 2026-09-27
parent: 8
---
## Description
As a client, I want to receive a reminder 24 hours before my consultation, So that I don't forget my appointment. Add tracking column to prevent duplicate reminders:. Full implementation history: docs/stories/story-8.6-consultation-reminder-24h.md
## Acceptance Criteria
- [ ] Scheduled artisan command runs hourly
- [ ] Find consultations approximately 24 hours away (within 30-minute window)
- [ ] Only for approved consultations (`status = 'approved'`)
- [ ] Skip cancelled/no-show/completed consultations
- [ ] Track sent reminders to prevent duplicates
- [ ] Subject: "Reminder: Your consultation is tomorrow" / "تذكير: استشارتك غدًا"
- [ ] Consultation date and time (formatted per locale)
- [ ] Consultation type (free/paid)
- [ ] Payment reminder: Show if `consultation_type = 'paid'` AND `payment_status != 'received'`
- [ ] Calendar file download link (using route to CalendarService)
- [ ] Office contact information for questions
- [ ] Email rendered in client's `preferred_language` (ar/en)
- [ ] Date/time formatted according to locale