I have a mysql database with a table called sms_in. the structure for sms_in is:
CREATE TABLE sms_in (id int NOT NULL auto_increment,
PRIMARY KEY (id)) default charset=utf8;
The table is constantly receiving data after every hour. This data comes from mobile phones in form of an sms and is saved in the table sms_in. sample data can be found in the attached database
The time the message was received is stored in the field sender_number, the time it was received is stored in the field sent_dt and the SMS message itself is stored in the fields sms_text
Only two kinds of sms data are received. The one starting with DAILYREPORT and the one starting with TRIPSUMMARY. Each SMS message has parameters with different values
You are needed to create two php webforms to be able to filter the data in the table for a user and for an administrator.
For the user, you first filter the data by a date range, then by a keyword to be input by the user. Once the user enters the date range and the keyword, he will press the update button and data filtered in that criteria is displayed. Now for the filtered data, you should display the sum of individual variables as indicated in the user interface. He can also download the filtered data to his computer
For the Administrator, you also filter the data by a date range, then by a keyword. The only difference here is that the keyword is preset and the administrator does not type it on the form. The keyword is preset as DAILYREPORT. So once administrator enters the date range, the form filters the data in sms_in table based on the date range and the keyword DAILYREPORT. The filtered data is then displayed on the form. Now for the filtered data, the sum of all the individual parameters is displayed as shown in the Admin user interface attached. he can also download the filtered data
The administrator can also add/remove another administrator, add/remove another user and view the audit trail of who logged in/out and when
Deliverable: all files and any scripts for the database that I can upload to my subdomain to display the two search forms
A sample of the two kinds of SMS is as below
TRIPSUMMARY, KBM920Y, TripNo=8, Destination=thika,nakuru, Begin=14:23, End=19:39, TripCardTickets=0, TripCashTickets=21, TripTotalTickets=21, TripCashSales=1200, TripCardSales=700, TripGrossSales=1900, TripFuel&Other=8000, TripCardTopUp=3000
DAILYREPORT, KBM920Y, DailyFuel&Other=3000, DailyCardTickets=60, DailyCashTickets=90, DailyTotalTickets=150, DailyCardSales=300, DailyCashSales=5000, DailyGrossSales=7000, DailyCardTopUp=40000
27 freelancers are bidding on average $139 for this job
Hi I have read your requirements carefully. I am high skilled and rich experienced in PHP and MySQL. If you share more details,I can start work. Best Regards.
Hi Nice to meet you. I have same site using Twilio. If you want, I can share login and instructions. Let me know if you are interested in me. Regards. Lian
Hello I am senior web developer. With my skills and experiences, I will implement php search form for filtering data on a mysql database. I look forward to hearing from you. Thanks.
We Believe in Delivering Perfect Work and Providing Full Satisfaction to Our Client . We also Insure to Deliver the Work in the given Time Frame . we have highly Qualified Professionals in our team