add features and some changes in current bulk sms system -
now insert sms are storing in send_sms table...
first thing (to speed up millions of data insert) - have to insert in send_sms_temporary table , with help of queue only which will insert in background so the user can browse other pages on system.
from send_sms_temporary table it will move to send_sms table by checking against blacklist table.. (done at my sql level not by php code for speed up millions of numbers)
if a number exists in blacklist table then it will go to directly to sent_sms table with its status in delivery table .. UNDELIVERED..
if it don't exist then it will go to send_sms table
At the end speed should be very fast..
second thing - -Error option: phonebook not in coverage – to be able to run the campaign even if there will be wrong numbers and to skip those wrong numbers
Third thing - Option to copy & past data in the form in recipient area , when the client need to run a campaign (at least 500k) most of the clients don’t want to download their data in the portal so option for copying & pasting will be fair enough
companies dont bid,
laravel exp must and queues in laravel is must
speed up the process is imp