People Invites Should be Tracked in the DB

[Brad Phillips]

As an upgrade to the basic Invite functionality, storing these invitations in a dedicated table in the db would allow owners to make more use of them.

To do this:

* Create a table in the db to store the invites. Necessary fields include:
** pkey
** recipient_id
** sent_date
** message
** invite_accepted
** on_submit/email

* Next, edit the form in 'Databases & Forms' section of Aiki to store appropriate values

* Create an Aiki Widget that has a (#(form:##:add)#) & place it on the /users/invite/ url

Once this data is being recorded, the owner could receive information relating to the number of days since the invite was sent, if the invite has been accepted. Also, it could prevent the owner from sending a duplicate invite to a user & could, instead, offer the ability to resend an invitation with an altered message, etc.

[Brad Phillips (brad-bradphillips)]

This is currently working. The only data not being recorded from this spec is a specific message. There is a field provided for this, but it was decided earlier that this is, at present, not necessary & a default message has been created as a substitute.

Every invite date is tracked, when a user accepts an invitation, that date is also recorded. The sender/recipient ids are recorded, as well as the email that the invite was sent to.