Closed

Web based transaction monitor - repost

This project received 6 bids from talented freelancers with an average bid price of $115 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
6
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online