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
21 freelancers are bidding on average $180 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
I have gone through your job post and I am quite confident that I can handle your task very well. I have prior experience with website CRON job. please share your best discussion time to move further.
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