Peruttu

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.

Taidot: HTML

Näytä lisää: 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

Projektin tunnus: #4273520

6 freelanceria on tarjonnut keskimäärin 115 $ tähän työhön

signo

details in PM

150 $ USD 2 päivässä
(8 arvostelua)
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 5 päivässä
(6 arvostelua)
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 Lisää

190 $ USD 6 päivässä
(2 arvostelua)
2.2
edduvs

I can do this easily.

80 $ USD 1 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0
creativeweblogo

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

85 $ USD 6 päivässä
(0 arvostelua)
0.0