Purge erroneous survey invitations

[pbchase]

There is an ancient bug in REDCap, long ago fixed, that created a data bug that plagues some old REDCap projects. It causes novel pre-scheduled survey invitation reminders to not get purged after the survey is completed. This still happens on our REDCap 13.8.4 system with survey invitations created this week. We are not alone in this There are many reports of this in te REDCap community:

• https://redcap.vanderbilt.edu/community/post.php?id=131128 Survey reminders continuing to send after survey is completed
• https://redcap.vanderbilt.edu/community/post.php?id=130142 Problem still exist with Reminder Invitation going out after survey complete
• https://redcap.vanderbilt.edu/community/post.php?id=53013 Surveys Sending Inappropriate Reminders
• https://redcap.vanderbilt.edu/community/post.php?id=200610 Future Survey Reminders are NOT deleting after Survey is marked Complete - How to troubleshoot Version 13.4

Whereas we don't know where the data bug is, we can see the symptoms in the form of non-deleted invitation reminders for completed surveys. These are easy to see by looking in Surveys/invite_participants.php for future invitations with completed responses. It's easy to delete them maually there as well, but as new ones are being created every day, it presents a maintance problem. They have to be deleted before a reminder to a completed survey goes out.

To reduce the burden on the REDCap admin, we propose to write a script that can locate and delete these records, then automate it to run daily.

[pbchase]

Addressed by PR #132