330103 Need Bulk SMS Website

I gang Opslået Jun 23, 2009 Betalt ved levering
I gang Betalt ved levering

We want to build a sms portal to meet the following requirements.

1. Programming Requirement

1.1. Language - PHP

1.2. Database – MySql

2. Type of Users

2.1. Single User A/C

2.1.1. They need to register the a/c with valid email address and mobile numbers

2.1.2. Payment will be done through Paypal

2.1.3. Once they buy the credits and payment successfully acknowledged by Paypal, they will instantly receive 1 SMS to their mobile phone with a code (code will not repeat i.e. new code for every new registrant), and they will also receive a email reflecting a link which they can go to activate their a/c. In a nutshell, to activate their a/c after successfully paid through Paypal, they need to go to the link reflected on the website and key in to code that is on their mobile phone. Once done, they can start using their a/c.

2.1.4. By default, user ID will be the mobile numbers of the registrant

2.1.5. By default, the sender ID will the mobile numbers of the registrant

2.1.6. Registrant can request for the sender ID to be masked into another name but that has to be prior approved before they can use it

2.2. Multiple Users A/C

2.2.1. There is a Administrator Function where they can assign as many users as they like, and allocate credits to its users

2.2.2. A/c will be manually activated by us

2.2.3. Payment can be done through Paypal, Telegraphic Transfer, Cheque, Cash, etc

3. Super Administrator (Control By Us)

3.1. Member Management

3.1.1. Add/ edit/ delete/ disable/ reactivate/ view member accounts

3.1.2. Search for members by Full Name, Preferred Calling Name, Mobile Phone Numbers, Company Name, Email Address, Mailing Address, City, Country, Date of Registration

3.2. Credit Management

3.2.1. Auto triggers a SMS to member mobile phone when credit value is low. Ability to set and change low credit limit for different members.

3.2.2. Allocate and change credits

3.2.3. Can allocate special credit pricing

3.2.4. Can allocate FREE credits to uses

3.2.5. State and change credit expiry dates

3.2.6. Search function to view credit information by date (start and end date), by nature (new top up, current credit available for use, expired credits etc), by a/c type (1 user or multiple users a/c), by user name, by sender id, by mobile phone numbers, by low credit limit etc. Able to view total numbers of sent SMS for each search type.

3.2.7. Can deduct users credit manually and specify the reason for deduction e.g. apply sender ID charge etc

3.3. Price Management

3.3.1. Add, edit, and delete pricing structure based on quantity, unit price, country, duration (eg. Valid for 1 month, 3 months, 12 months etc)

3.3.2. In the price management, clearly show which countries are current still valid for SMS sending (eg. available), which ones are temporary unavailable for sending (eg. temp unavailable), or which ones are unavailable (eg. unavailable).

3.4. Sender ID Management

3.4.1. Sender ID refers to the sender name/numbers reflected on the mobile phone i.e. masking

3.4.2. All creation of Sender ID can only be created, approved, and allocated by us

3.4.3. For 1 user a/c, users can request for sender ID through clicking onto sender ID request function

3.4.4. For multiple users a/c, only administrator can for sender ID through clicking onto sender ID request function

3.4.5. Show list of all status such as new, pending, approved, rejected sender ID

3.4.6. Users are able to know status of their request

3.4.7. Search sender ID by status and date

3.5. Assign Administrator Limit For Allocation of Users

3.5.1. Allocate numbers of users that Administrator can create a/c and password for

3.6. Site Configuration

3.6.1. Edit system configurations

3.7. SQL Backup

3.7.1. Ability to download MySQL database backups

3.8. New Management

3.8.1. Add/edit news or announcements which will be shown to members when they log into the account

3.9. Sent Record

3.9.1. View all the sent record

3.9.2. Select viewing of sent record by date (start and end date), by sent status (processing, successfully, failed), by user name, by mobile numbers

3.9.3. Able to export sent record, and search sent record

4. Administrator – (For Multiple User A/c)

4.1. Top up a/c i.e. buy credits from Paypal

4.2. Add/ edit/ delete/ disable/ reactivate/ view users accounts

4.3. Create user a/c and password

4.4. Set the maximum monthly SMS sending limit for each user. Once

user exceeds the monthly limit, user cannot send anymore unless Administrator extended the limit (Note: This is not allocating of credits to user but simply setting of each user maximum monthly sending quantity)

4.5. View ALL the sending records of the staff

4.6. Search for sending record under by date (start and end date) and user ID. Able to show total numbers of sent SMS for each search type.

4.7. Able to delete and clear sent records

4.8. Able to export sent record to excel

4.9. Able to do a “backup” to save all sent record

4.10. Able to “restore backup” to contain the exact old data

5. User –Multiple A/C User

5.1. Send SMS up to the monthly sending limit as set by the Administrator

5.3. User can tick “remember login id and password on this pc”

5.4. View own sending record

5.5. Search for sending record under by date (start and end date), and shows the total numbers of SMS sent.

5.6. Export sent record to Excel

5.7. Delete sent record

6. User - Single A/C User

6.1. Can top up a/c through Paypal

6.3. User can tick “remember login id and password on this pc”

6.4. View sending record

6.5. Search for sending record under by date (start and end date), and shows the total numbers of SMS sent.

6.6. Credit account record – current balance, top up amount, new balance and expiry date for each category

6.7. Export sent record to Excel

6.8. Delete sent record

7. Address Book Function

7.1. Create groups and sub groups

7.2. Can pull and drag contacts from one group to another

7.3. Can import contacts from Excel into address book

7.4. Can export contacts to Excel

7.5. Search function by name, mobile numbers, country and etc

7.6. Address book format – Name, mobile numbers, preferred to be addressed as, birthday, plus 5 blanks columns for customers to fill up anything that they want. (((All the columns can be used to do SMS merge under “Send SMS” function e.g. Name can be known as column A, mobile numbers as column B, personal salutation as column C, and so on)))

8. Birthday Greetings

8.1. Activate birthday greetings and system will send the recipient for scheduled sending automatically.

8.2. Set preferred time of sending for all birthday greetings

8.3. System must be able to avoid sending of birthday greetings to the same numbers twice on the same day i.e. track duplicate mobile numbers on day of birthday greeting sending.

9. Template

9.1. Create groups and sub groups

10. Send Function

10.1. Sender ID

10.1.1. For 1 user a/c - by default will be the mobile numbers of the user, additional sender ID available for selection once approved and assigned by us

10.1.2. For multiple users a/c – administer can create sender ID for its users

10.2. Select Recipient

10.2.1. By importing from excel, and manually input

10.2.2. Search function to allow selection of recipients based on certain criteria range (from and to, equal, contain), and they system will search for it from the Address book and add as recipients. Eg: search column C of excel and from date between 11/11/98 and 2/2/02. Example, search column E to contain word “female”

10.2.3. Shows total numbers of recipients

10.3. Type SMS Message

10.3.1. By default <ADV> will appear automatically before typing any text

10.3.2. Auto detect Unicode

10.3.3. Can insert SMS merge codes – column c, d, e, f, or g of Excel worksheet (similar to mail merge)

10.3.4. Can insert template

10.3.5. Can save SMS message as “saved template” into the appropriate template groups for future use

10.3.6. Show number of characters use, number of SMS it comprises

10.4. Check duplicate items and delete

10.4.1. Once users click on this function, automatically delete duplicated numbers from recipients list

10.4.2. Show total numbers of duplicated items deleted

10.4.3. Show numbers of non-duplicated items

10.5. Send Option

10.5.1. Option of “Send Now” or “Send Later”

10.5.2. Click “Send Now” and it will instantly deduct the numbers of credits. Will show numbers of credits deducted, numbers of recipients, numbers of SMS to be sent

10.5.3. Click “Send Later” and it will check if there is enough credit to be used, if yes it will reserve the credits for this scheduled SMS and deduct the credits once it is ready for sending. If there is no enough credits, user has to top up first. (Note: if user cancel the sending of the scheduled SMS before the time of sending, credits will be reinstated into his a/c)

10.5.4. Must be able to compute the credits correctly based on which country the SMS will be sent to. Different countries bear different credit rate. Also, different customers may have different rate. Must detect correctly.

11. Scheduled SMS

11.1. Show details of scheduled SMS

11.2. Show total numbers of credits allocated for each batch of scheduled SMS

11.3. Allow canceling of scheduled SMS, and once cancelled the credits will be reinstated into their a/c automatically

12. Sent Record

12.1. Show status of SMS sending - all processing, successfully sent, and failed to send record by date

12.2. Show nature of SMS sending – scheduled SMS or not

12.3. Shows numbers of credit deducted for each SMS sent

12.4. Shows all sent details including sender ID used for single/bulk SMS sending

12.5. Search by date (start & end date), status (processing, successfully sent, failed to send), and ALL record

12.6. All record can be exported to Excel

13. Top Up

13.1. Top up and pay by Paypal

14. Account Record (Credits Record)

14.1. Opening credit balance, FREE credits (if any), top up amount,

credits deducted today, credits refunded (appears only when there is cancellation of scheduled SMS), total credits available for use

14.2. Able to show if the top up is done by paypal, or status manually top up by us because it is paid by other means eg. Cheque

15. Additional Sender ID Request

15.1. For 1 user a/c, user can request for additional sender ID under this function

15.2. For multiple users a/c, administrator can request for additional sender ID under this function, and assign the approved sender ID to respective user to use

16. PLUS, Other valuable functions that you would recommend which has proven to be very useful

For An Idea can check website like [url removed, login to view] and www.airclub.in. We need sites like [url removed, login to view]

MySQL Odd Jobs PHP

Projekt ID: #2075912

Om projektet

Remote projekt Aktiv Jul 11, 2012