Play custom messages to caller, based on ODBC Database connection

I have a requirement to play a custom message to a caller, that needs to be driven from a database, and is able to scale out. We will have IVRs in place, that the caller will press, which will then move to the context we are looking for your to develop for us. In side this context, you will need to look up a database, with a syntax like (callerregion is set by option the caller selects in the IVR) select areas,restoretime from tblADMSOutages where region='${callerregion}' If this returns no information, you will need to proceed to the failover destination. If this returns information, we need to play the information from the database to the user. You may have single or multiple rows of data, which is in the following format. areas Area One,City Four,Town Two restoretime 2018-05-03 13:00:00 areas Area Three,City Seven,City Eight restoretime 2018-05-08 23:00:00 So assuming the above, and assuming the call was incoming on the 2018-05-03 at 11am, we would expect the caller to hear: We are currently aware of outages in the following areas: Area One,City Four,Town Two with an expected restore time of today at 1pm Area Three,City Seven,City Eight with an expected restore time of 8th of May at 11pm If you require additional information, please press 1 However if the caller was calling in within 30 minutes of an outage resolution time (or past an expected restore time, we would expect the caller to hear: We are currently aware of outages in the following areas: Area One,City Four,Town Two that should be restored within the next 30 minutes. Area Three,City Seven,City Eight with an expected restore time of 8th of May at 11pm If you require additional information, please press 1 In order to achieve this, we have recorded the following: intro - We are currently aware of outages in the following areas: restore - with an expected restore time of restoresoon - that should be restored within the next 30 minutes footer - If you require additional information, please press 1 For each area we have the audio file recorded, which is saved all in lowercase, with no spaces etc (so Area One would be areaone, and City Four would be cityfour, etc) At anytime during the message the caller should be able to press 1. If the caller does not press anything within 5 seconds of the message been completed, the message should repeat once, if the caller doesnt press anything, the call should end. If the caller does press 1, the call should be transferred to failover number. This needs to scale, during peak times, this will be getting played to 200+ callers concurrently. I'm not sure if what we require can be managed within the dialplan, if AGI is required, we would like this to be PHP.