Feature Request: Add Due Date, Alerts, and Badge Color Change for Tickets #133

Currently, tickets only allow input of estimated time in hours, which feels disconnected from real project timelines and does not prompt action. We propose adding a Due Date field to each ticket and enhancing user experience with notifications and visual urgency cues.

Requirements

1. Due Date Field on Tickets

Each ticket should have an optional due_date field.

The due date should be displayed clearly in the ticket details and Kanban board view.

2. Notification Mechanism

If a ticket is 1 day or 3 days before the due date:

The assigned user should receive an email notification.

The project owner should also be notified.

A real-time in-app notification (e.g., via Pusher or similar) should be triggered if the user is online.

3. UI Enhancement: Badge Color Change

On the Kanban board, the ticket's due date badge should change to red if:

It is 3 days or less before the due date.

This will visually indicate urgency to all users.

Notification Content (Suggestion)
Email Subject: ⏰ Upcoming Due Date for Ticket: [ticket title]
Email Body:

Hi [User Name],
Just a reminder that your ticket "[ticket title]" is approaching its due date: [due_date].
Please make sure it's on track.

Regards,
Project Management System

Notes
The configuration (1-day, 3-day reminders) could be made adjustable via admin settings.

Make sure not to notify if the ticket is already marked as Done or Archived.