Cancelled

Web based transaction monitor - repost

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

[url removed, login to view] 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.

Skills: HTML

See more: ok-uni, monitor default, jquery widget, statement structure sql, jquery ajax message, mysql select statement, table set html, tab delimited text, web count, mysql export table sql, display mysql results ajax, sql reports mysql, info display, jquery display results, web widget jquery, jquery refresh page, build web widget, tab count, repost page jquery ajax, mysql export structure html, sql reports html, rebuild jquery, widget mysql, web config, display table jquery

About the Employer:
( 9 reviews ) United Kingdom

Project ID: #4273520

6 freelancers are bidding on average $115 for this job

signo

details in PM

$150 USD in 2 days
(8 Reviews)
4.2
pranotosh

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

$110 USD in 5 days
(6 Reviews)
2.9
maxpl

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 More

$190 USD in 6 days
(2 Reviews)
2.2
edduvs

I can do this easily.

$80 USD in 1 day
(0 Reviews)
0.0
RITESHBATHWAL

I am an expert in HTML and MySQL. I am eager to work on this project. You can bet your money on me. Regards.

$75 USD in 1 day
(0 Reviews)
0.0
creativeweblogo

Hi, Please visit our pm/profile for work samples and proposal. Regards, Sandip Ganguly

$85 USD in 6 days
(0 Reviews)
0.0