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