Build a new website that reads a single table on a MySQL with the following structure:
mysql> describe message;
+------------------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+-------------------+----------------+
| message_id | int(11) | NO | PRI | NULL | auto_increment |
| message_key | varchar(12) | NO | UNI | NULL | |
| message_request | text | YES | | NULL | |
| message_response | text | YES | | NULL | |
| status | varchar(10) | NO | | NULL | |
| last_update_ts | timestamp | NO | | CURRENT_TIMESTAMP | |
+------------------+-------------+------+-----+-------------------+----------------+
6 rows in set (0.01 sec)
1. Widget One ( Summary Info )
Display a summary count records by status and display results ( refresh every x secords )
processed 100
success 20
pending 2
etc
[login to view URL] 2 Drill down : Click processed and display the last 100 transaction in a new widget ( jQuery/Ajax style no page rebuild widget added below )
Display all fields
keep adding widget below when transaction type is clicked.
3. Widget 3 List all transactions and to export results to tab delimited text file..
( config reports to be run by predefine SQL statement with associated name)
Example
List Pending Transactions
SELECT * from message where status EQ 'pending'
...
That's it.
Hi,
I'm a Web-developer having a lot of experience on PHP,Codeigniter,MySql,HTML,CSS,Javascript,CSS,jQuery,Ajax etc.I can assure you quality work. Please consider my bid.
Thanks
I am interested to do job for you. I have seen the specifications of your project.
I have 4+ years of experience in webdesign/ development, Mobile Development.
I have read your project details.
I am interested to work with you.
Please see PMB.