Streamline Login by Email

[WolfElkan]

Families may login by either username or email address

• Email addresses must be unique
• If any user enters an email address that is in use by any family, parent, student, or teacher, return an error
• If parent or student enters their alt_email as the same as their own family's main email, do not return an error, but store it as NULL
• When a user tries to login, they will give a username or email. Use this string to locate their account:
  • If an account matches by username, return it
  • If not, check if a student or teacher account matches by email. If so, return it.
  • If not, check if a family account matches by main email or by either parent's alt_email. If so, return it.
  • If not, inform user that they do not have an account, and advise them to create one.