Suoritettu

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:
( 1 arvostelu ) Belgrade, Serbia

Projektin tunnus: #16517510

Myönnetty käyttäjälle:

ast3r1sk

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ä
(42 Arvostelua)
5.3

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

hawkscodeaus

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ä
(46 arvostelua)
6.9
kingAsterisk

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 : [url removed, login to view] skyp Lisää

$600 USD 10 päivässä
(36 arvostelua)
6.2
arodrigue

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ä
(71 arvostelua)
6.1
ngxperts

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ä
(54 arvostelua)
6.5
tangramua

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ä
(13 arvostelua)
5.6
DigiWhizz

A proposal has not yet been provided

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

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)
4.6
CreativeExpertIT

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ä
(37 arvostelua)
4.6
schoudhary1553

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ä
(9 arvostelua)
4.1
bhruguios

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ä
(7 arvostelua)
3.7
beautiXiao

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)
3.8
MyAwesomeTeam

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ä
(3 arvostelua)
3.2
mula9211

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

$250 USD 5 päivässä
(1 arvostelu)
0.8
raoherlin

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ä
(0 arvostelua)
0.0
asterisk2voip

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 10 päivässä
(0 arvostelua)
0.0
$555 USD 10 päivässä
(0 arvostelua)
0.0
DarshnaVac

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 12 päivässä
(0 arvostelua)
0.0
$250 USD 10 päivässä
(0 arvostelua)
0.0
aaankur81

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ä
(0 arvostelua)
0.0
sreenivas2903

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

$250 USD 3 päivässä
(0 arvostelua)
0.0