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

Kemahiran: Asterisk PBX, Linux, MySQL, VoIP

Lihat lagi: 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

Tentang Majikan:
( 1 ulasan ) Belgrade, Serbia

ID Projek: #16517510

Dianugerahkan kepada:


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 Lagi

$250 USD dalam sehari
(42 Ulasan)

26 pekerja bebas membida secara purata $426 untuk pekerjaan ini


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 Lagi

$560 USD dalam 7 hari
(46 Ulasan)

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 Lagi

$600 USD dalam 10 hari
(36 Ulasan)

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 dalam 3 hari
(71 Ulasan)

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. Lagi

$500 USD dalam 7 hari
(54 Ulasan)

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 Lagi

$575 USD dalam 21 hari
(13 Ulasan)

A proposal has not yet been provided

$500 USD dalam 9 hari
(7 Ulasan)

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 Lagi

$550 USD dalam 6 hari
(9 Ulasan)

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 Lagi

$400 USD dalam 14 hari
(37 Ulasan)

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.. Lagi

$500 USD dalam 10 hari
(9 Ulasan)

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 Lagi

$300 USD dalam 2 hari
(7 Ulasan)

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 Lagi

$555 USD dalam 4 hari
(3 Ulasan)

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 Lagi

$575 USD dalam 6 hari
(3 Ulasan)

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 dalam 5 hari
(1 Ulasan)

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 Lagi

$277 USD dalam 5 hari
(0 Ulasan)

hi, we have good experience with Asterisk based voip solutions. so, please give us chance to work with you. sk ype ID : asterisk2voip Contact no : 962 402 2999

$277 USD dalam 10 hari
(0 Ulasan)
$555 USD dalam 10 hari
(0 Ulasan)

Having understanding and experience about Asterisk PBX, Linux, MySQL, VoIP. Have successfully closed many projects by fulfilling every requirement from client's end.

$531 USD dalam 12 hari
(0 Ulasan)
$250 USD dalam 10 hari
(0 Ulasan)

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 Lagi

$250 USD dalam 2 hari
(0 Ulasan)

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

$250 USD dalam 3 hari
(0 Ulasan)