SMS marketing platform in Perl/MySQL

SMS marketing platform (web-based portal) to be developed using perl/MySQL to send a customised sms message to a list of delivery mobile numbers along with a mailmerge field if necessary. Key features are as follows: - Deliverables: Perl code, HTML pages, MySQL database/table schemas - Perl CGI, using HTML::Template to load HTML pages, DBI for MySQL communication - Ability to create campaign with a name, description, creator, promo code reference - Ability to upload/enter delivery list of up to 10000 mobile numbers - Ability to set delivery from field - Ability to enter specific message (java character counter needed) - Ability to 'mailmerge' an additional data field into the message using an appropriate variable name - Ability to preview SMS's before sending - Low-level send_sms function will be provided (e.g. send_sms($msg, $to, $from)); - All outbound messages to be checked against STOP/unsubscribed list before sending, details + schema for this MySQL will be provided - Delivery list to be deduped to prevent multiple messages going to the same recipient during the session - All messages are sent also to a default test list which is maintained separately - Full logs of all messages sent and timings to be maintained - Sending a batch is undertaken by a cron job - Campaign summary stats page + deeper breakdown stats