Asterisk simple routing based on SQL query

- Routes calls to Route1 or Route2 based on 2 simple database queries

- Query 1 is to check if the B number is in recent calls list (up to 24 hours before, editable in the script), this can be done by running query on CDR database or additional table

- Query 2 is to check if B number exists in the simple one column table, table can have up to 1 million raws

- If Query 1 is positive / has results call is routed to Route1, if it is negative / has has no results then we run Query 2

- If Query 2 is negative we route the call to Route1, if positive we route to Route2

- Telephone numbers are 12 digits long, no special characters

- Should work with Asterisk 13.14 and MySQL 5.5

- Should handle 5-10 calls per second without issues and need for special hardware

Taidot: Asterisk PBX, Linux, MySQL, VoIP

Näytä lisää: Oracle SQL Query Work, simple grid frontend sql query, sql query based form input graph results, create simple sql query, triql sql query translator work, sql query display employee namehiredate order results based day week starting monday, sql query filter based number child records, simple sql query creator, simple sql query, getafreelancer message sql query help needed, sql query tree children, web based sql client, sql query tree structure, sql query child child, simple html based image viewers, asterisk call forward database sql query, sql query tree structure records

Tietoa työnantajasta:
( 2 arvostelua ) Belgrade, Serbia

Projektin tunnus: #16517510

Myönnetty käyttäjälle:


Hi, i can write such query, via odbc mysql driver or via php AGI script. But for performance you probably will need tweak Mysql database, like place all data in RAM. But mysql tweaking is not my primary skills, so bet Lisää

$250 USD 1 päivässä
(46 Arvostelua)

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


Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Lisää

$560 USD 7 päivässä
(55 arvostelua)

hello, we have 10 year experience with Asterisk pbx. we already provide modify dialer Code, Report part & GUI part as per customer requirement. visit live dialer demo : [login to view URL] skyp Lisää

$600 USD 10 päivässä
(39 arvostelua)

Hello I can help you to develop VoIP system you need. Here is the system that my team has developed for our business: Main features which we have implemented in our VoIP system: - calls to most of world countries t Lisää

$575 USD 21 päivässä
(43 arvostelua)

I have done this task before and willing to provide a demo, contact me and work with a real Asterisk / PHP / MYSQL expert

$250 USD 3 päivässä
(91 arvostelua)

hi, all these can be done and we can create a web interface for you to edit the parameters, like the 24hrs time or other table and database access etc. kindly let me know if we can chat in detail about the project. Lisää

$500 USD 7 päivässä
(57 arvostelua)

A proposal has not yet been provided

$500 USD 9 päivässä
(7 arvostelua)

Hi, I am technical support for [login to view URL], I can do the job for you with full confidence, let us chat if interested.

$250 USD 5 päivässä
(17 arvostelua)
$250 USD 10 päivässä
(4 arvostelua)

We have 7+ years of experience in this field and we have expertise in every technology. We have well experienced Developers and Designers in our company and we are 35+ people in our company. You can have a look at our Lisää

$550 USD 6 päivässä
(9 arvostelua)

i have developed many projects based on asterisk like routing call based on some condition, IVRS, autodialer, call agent monitor, recording, voicemail, conference, billing, cdr and more. Based on your job descriptio Lisää

$300 USD 2 päivässä
(9 arvostelua)
$500 USD 7 päivässä
(4 arvostelua)

Nice to meet you, mihatz. .I think i can do this project Our skills same your requirement skills : Linux, Asterisk PBX, MySQL, VoIP. All my previous project was feedbacked 5 stars. because i care Lisää

$575 USD 6 päivässä
(13 arvostelua)

Hello Sir, Thanks for the details.. We have read your project requirement. Our Skill is completely matched with job description. We have more than 6 years’ experience. Please check our past work portfolio cl Lisää

$400 USD 14 päivässä
(39 arvostelua)

Hi there..... Warm Greetings We came along with your request for Asterisk simple routing based on SQL query and we reviewed your project description. We'd like to help you with confidence and satisfying results.. Lisää

$500 USD 10 päivässä
(19 arvostelua)

Hi, i have 8+ years of experience in working with asterisk, vicidial, VOIP solutions, softphones.. i have designed many custom solutions for call centers, marketing campaigns. i have a good experience of conditio Lisää

$250 USD 2 päivässä
(1 arvostelu)
$555 USD 10 päivässä
(1 arvostelu)

Hi,we're all senior software developers,we've just checked your project requirements,we're able to perform your project and you'll be interesting with us,please come in contact with us to discuss for more project detai Lisää

$555 USD 4 päivässä
(3 arvostelua)

Hello, I have three year working experience with linux , we normally use linux for development of every software and i believe i can solve your problems related to linux. These were the projects which I worked on: Lisää

$777 USD 15 päivässä
(3 arvostelua)

I am very thankful for this opportunity. Below are some examples from our portfolio which shows our expertise and work experience:[url removed, login to view][url removed, login to view][url removed, login to view][url Lisää

$277 USD 5 päivässä
(2 arvostelua)

I would like to work on this queries i could give you the best

$250 USD 3 päivässä
(1 arvostelu)