zalsaeed / cgav

Certificate Generation and Verification
GNU General Public License v3.0
3 stars 2 forks source link

Event Deletion: Complete Removal or Inactivation for Admin API Check #46

Closed SalmanSaleh1 closed 7 months ago

SalmanSaleh1 commented 9 months ago

When deleting an event, it should either be completely removed or made inactive so that admins can still check the API for certificates associated with that event.

SalmanSaleh1 commented 9 months ago

After discussions with the team, we've decided on the following approach:

When a user initiates event deletion, a delete confirm popup will inform them that deleting the event will remove it from the database, preventing certificate verification via the API.

Additionally, an email notification will be sent to recipients, informing them of the event's deletion by administrators or certificate generators.

SalmanSaleh1 commented 9 months ago

If the event is neither downloaded nor sent, it will be deleted without sending any email notifications.

SalmanSaleh1 commented 9 months ago

We will soon address the following tasks:

SalmanSaleh1 commented 8 months ago

Improved delete confirmation popup with a concise warning message highlighting that deleting the event permanently removes it from the database, preventing certificate verification and triggering email notifications to recipients. Improves user clarity.

image
SalmanSaleh1 commented 8 months ago

added two new fields, "sent" and "downloaded," to the addCertificate table in the database schema. These fields are of type BOOLEAN and default to FALSE. They are intended to track whether a certificate has been sent or downloaded image

SalmanSaleh1 commented 8 months ago

image image

Updated the download_certificates function to mark certificates as downloaded after they are downloaded.

SalmanSaleh1 commented 8 months ago

Following team discussions, it has been determined that email notifications will be sent to all relevant stakeholders, including recipients and certificate holders, upon event deletion.