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