Twilio Sms from CDR - To be called by cron
Db asterisk user root no pass
select right(src,11),right(dst,7) from cdr where calldate > date_sub(now(),interval 1 hour) and (src like '1%' or src like '+1%') and (CHAR_LENGTH(src) = 11 or CHAR_LENGTH(src) = 12);
Send SMS to right(src,11)
Thanks for calling right(dst,7) .
More deals at [login to view URL]
select right(src,12),right(dst,7) from cdr where calldate > date_sub(now(),interval 1 hour) and (src like '33%' or src like '+33%') and (CHAR_LENGTH(src) = 11 or CHAR_LENGTH(src) = 12);
Send sms to select right(src,12)
Merci d'avoir appelé à RIGHT(dst, 7).
Plus d'offres sur [login to view URL]
Keep a database of the sms that have been sent
Dont send to same number more than 1 time per 30 days
22 freelancers are bidding on average $179 for this job
Hello. I have rich experiences in Twillio SMS API and have used it before for SMS feature in [login to view URL] cron functions. I can satisfy you perfectly. Please send message so that we can discuss further. Thanks
Dear client. Nice to meet you. I have developed web app using twilio and nexmo sms. I can start work immediately and do project perfectly. Please message me if you have an interest. I CAN START WORK IMMEDIATELY.
Hello! I worked many times before with nexmo and so I think I am the right person for your Project. Maybe you have further questions, so just contact me. Best greetings Stefan