Suoritettu

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.

Taidot: Asterisk PBX, MySQL

Näytä lisää: digium asterisk version, digium repository, asterisk google voice caller id, asterisk google voice incoming, asterisk fun, configure asterisk to use google voice, digium asterisk iso, what can you do with asterisk, database connection php, login page database connection php, database connection php joomla, joomla database connection php, joomla odbc access database connection, vbs database connection odbc, flex database connection php

Tietoa työnantajasta:
( 0 arvostelua ) Hastings, New Zealand

Projektin tunnus: #16997600

Myönnetty käyttäjälle:

octopus823

How are you? I have rich experience in developing asterisk. I have been studying about pbx for 5 years. I will satisfy your requirement. Hope to contact with you. Best regards.

$972 NZD 10 päivässä
(16 Arvostelua)
6.2

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$972 NZD 10 päivässä
(68 arvostelua)
5.6
topstar323

hello how are you? I have just read your job description and so much interested in your project. I have already good experience with Asterisk PBX and VOIP call app so I feel confident in this field. do you have any Lisää

$972 NZD 10 päivässä
(1 arvostelu)
2.7