Find Jobs
Hire Freelancers

Web Based Reporting Module for Messaging System

$100-500 USD

Closed
Posted over 20 years ago

$100-500 USD

Paid on delivery
I am looking for coders experienced in writing usage and report module for messaging oriented systems. You should be able to use your judgment to create a set of exhaustive Web based usage and statistical reports for message traffic stored in a database. First Pref. is for JSP, then for PHP but will consider other tools if they work both on Apache and IIS, and with SQL Server and mySQL. The bulk of this project is to create a generic infrastructure for the report module and some initial reports. IMP: Multipage output should have navigation keys. It should be possible to SORT the report by any of the columns. Links should be provided to export the report in CSV format, XML format, a format for printing, emailing. I would like to see samples of your previous work- Screenshots of report generator and output screens are ok. We have a proxy server used to manage persistent session oriented client-server connections. Users of the system use a custom client to connect to a server, and once a user SESSION is permitted, they engage in conversations and exchange small text/XML messages with a number of other similarly connected USERS. All connection information is in 2 DB tables so that a Sessions table has a list of all SESSIONS ever made or in progress. Associated with each Session are a set of text messages exchanged over that connection. These are stored in a MESSAGES Table with keys that tie a message to a session. The operation of this system is of no concern to the coder, but the following two resulting DB tables are. SESSIONS Table includes information for each session like userid, start time, stop time, Connection Type, IP address of client etc. MESSAGES Table includes sessionid, messageid, type of message, content of message, timestamp, From User, To User etc Actual schemas will be provided to successful bidder - they are simple. [login to view URL] of the system are interested in statistical reports on number of connection attempts (successful, failed, type), Total Messages Today,This Week,This Month, between data and time ranges etc, by userid, by IP address etc so they can slice and dice data. 2. The second set of reports are on the conversations and actual content. Conversations between User A and B, between x and y time, containing certain keywords etc ATTENTION: FULL DESCRIPTION IS IN DELIVERABLES SECTION BELOW ## Deliverables I am looking for coders experienced in writing usage and report module for messaging oriented systems. You should be able to use your experience and judgment to create a set of exhaustive Web based usage and statistical reports for message data traffic stored in a database. First Preference is for JSP, second for PHP but will consider other scripting and reporting tools as long as they work both on Apache and IIS, and with SQL Server and mySQL. The database is fairly simple, so the bulk of this project is to create a generic infrastructure for the report module and some initial reports. If you have them, I would like to see samples of your previous work in your bids. Screenshots of report generator and output screens are ok. We have a proxy server used to manage persistent session oriented client-server connections. Users of the system use a custom client to connect to our server, and once a user SESSION is permitted based on certain credential checks, they engage in conversations and exchange small text/XML messages with a number of other similarly connected USERS. All connection information is stored in a DB table so that a Sessions table has a list of all SESSIONS ever made or currently in progress. Associated with each Session is a set of text messages exchanged over that connection. These are stored in a Messages Table with keys that tie a message to a session. The operation of this system is of no concern to the coder, but the following two resulting database tables are. SESSIONS Table includes information for each session like userid, start time, stop time, Connection Type, IP address of client etc. MESSAGES Table includes sessionid, messageid, type of message, content of message, timestamp of message, From User, To User etc Actual table schemas will be provided to successful bidder - they are pretty straightforward. [login to view URL] of the system are interested in number of statistical reports on number of connection attempts (successful, failed, type), Total Messages Today, This Week, This Month, between data and time ranges etc, by userid, by IP address etc so they can slice and dice data. 2. The second type of reports are on the conversations and actual content. Conversations between User A and B, between x and y time, containing certain keywords etc Some reports/queries should be presented as standard reports, and others should be allowed to be created on the fly. Reports that generate more than one page data should have navigation keys. It should be possible to SORT the report by any of the columns where appropriate. Certain elements in the HTML reports should be hyperlinked to offer drilldown information from other tables. Links should be provided to export the report in CSV format, XML format, a format suitable for printing, emailing etc. It is ok to use additional 3rd party components for this. For the statistical reports on number of messages and sessions, simple graphs, as part of report will be a bonus. Technology: Database: The DBs we use are MySQL, SQL Server, and Oracle so your queries should be fairly generic. Web Server: Apache and IIS Proxy Server: Win2K and Linux First Preference is for JSP, but will consider other scripting and reporting tools as long as they work both on Apache and IIS. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site). ## Platform Apache/IIS mySQL/SQL Server/Oracle IE/Netscape Linux/Win2K
Project ID: 2985165

About the project

4 proposals
Remote project
Active 20 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $339 USD for this job
User Avatar
See private message.
$170 USD in 14 days
5.0 (8 reviews)
3.8
3.8
User Avatar
See private message.
$165.75 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$340 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$680 USD in 14 days
0.0 (2 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Newark, United States
4.9
35
Payment method verified
Member since Apr 3, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.