Hi guys...i have a somewhat challenging task.I have to write an application with PHP and MYSQL
This application is intended to be an sms application that sends sms(text messages) to
various job supervisors,reporting the messages that their subordinates have received.
The application is meant to have a template;
E.g :Message From Postmaster:
Message From Auditor:
etc.
The messages for each subordinate are stored in a table and are retrieved
for each subordinate for a given time period.Each subordinate has a job role which defines the kind of message he receives.
That is:A postman has "pre-defined" people that can send a message.E.g The Postmaster,the PostOffice....etc.
An example showing the message format is:
Message From Auditor:Bring Receipts To General Office Sent On Monday
Message From Postmaster:Bring Stamps To Secretariat Sent On Monday
Message From Security: Bring Details For Id Card Sent On Tuesday
Message From Admin:
Message From Supply:
Two subordinates with the same job role can have different messages from the same person.
E.g: Employee x who is a postman might receive "Report to General Office" from the PostMaster,
while Employee y might receive the message "Add New Delivery Routes From Next Week"
The phone numbers for the Supervisors are stored in a table.
A supervisor can supervise mulitple people
who have different job roles.
The major point where i will need assistance
is on how to program the application to pick the phone number of the supervisor for each
employee,get the templates for the employee's job role,and populate it with the messages
for the employee and send it to the supervisor.Also, the employees can have more than 1 supervisor.
I know i will need a loop(a "for-each" loop ??)..
I am not also very knowleadgeable about the procedure used in sending sms messages to people
from a website with php,
but i know it has to do with arrays.
So in short...i need help on building arrays that will house the phonenumbers,messagetemplate
and message template for a particular job role with individual messages
and loop through them
and send them to the recipients.
I will really appreciate any help i can get and i will gladly supply my email to interested parties to further correspondence.THANKS