JOB 1. Correct Stored Procedure PlayerStatusForIDCoach on [login to view URL] project and send corrected stored procedure via email for upload to live database
1. Sign in as a superuser and create and individual client. Then assign an IDCoach to that player
2. Then sign in as that IDCoach
3. At the momment he will be able to see the new individual client on this page /IDCoach-ClubManager/[login to view URL]
4. But there is no sign of the new client on this page. /IDCoach-ClubManager/[login to view URL]
The task is to make all individual clients that are assigned to an iD coach show up on that ID Coaches status page
JOB 2 - Code 3 new Stored Procedures for [login to view URL] and send stored procedures via email for upload to live database
You need to add 3 more columns to your copy of [login to view URL]
1. ProcessReminderSent default=0
2. ProcessesSent default=0
3. PostMatchReminderSent default=0
Stored Procedure 1 - SendProcessReminder
Looks at each record in [login to view URL]
If in [login to view URL] its less than 24 hours until the date of the match AND isActive = 1 AND IsExpectedProcessCue = 1 AND ProcessReminder < 1 AND ((ProcessOne is NULL OR ="") OR (ProcessTwo is NULL OR ="") OR (ProcessThree is NULL OR =""))
THEN Return FirstName, Surname, ContactNumber, Email, Message (all from [login to view URL]) Date/time of Match, Opponent, Venue (from MasterMatch)
Stored Procedure 2 - SendProcesses
Looks at each record in [login to view URL]
If in [login to view URL] its less than 12 hours until the date of the match AND isActive = 1 AND IsExpectedProcessCue = 1 AND ProcessesSent < 1 AND ((ProcessOne has an entry) OR (ProcessTwo has an entry) OR (ProcessThree has an entry))
THEN Return FirstName, Surname, ContactNumber, Email, Message (all from [login to view URL]) Date/time of Match, Opponent, Venue (from MasterMatch), ProcessOne, ProcessTwo, ProcessThree
Stored Procedure 3 - SendPostMatchReminder
Looks at each record in [login to view URL]
If in [login to view URL] its more than 72 hours after the date of the match AND isActive = 1 AND IsExpectedPostMatch = 1 AND PostMatchReminderSent < 1 AND ((PrOne is NULL OR ="") OR (Good1 is NULL OR ="") OR Better1 is NULL OR =""))
THEN Return FirstName, Surname, ContactNumber, Email, Message (all from [login to view URL]) Date/time of Match, Opponent, Venue (from MasterMatch)