Background
We currently have a site that is used as a way for our customers to access their records. We handle things like their commissions and supplies etc. We compile this data from a secure database and upload the files to this portal.
The site is currently built in phpNuke and continues to give problems. It is also hosted on an expensive Windows server and runs on MSSql. We are tired of dealing with the problems of windows and Nuke and want to move to LAMP Joomla environment.
What we’re looking for
We need a Joomla Component built that handles accessing a database and printing to the screen reports based on the data.
1. There are three separate reports that need to be generated. Each one will have slightly different specifics, and will be built from different tables.
2. The reports will be mainly sorted by the name of the Customer.
3. There will need to be some sort of profile page built for when a customer’s name is clicked.
4. There will be a fourth report that will be built at a later phase, and that job will be handled by the winning bidder as well (but as a separate project of course)
5. We also need to create a series of permissions that will give users different levels of access.
6. The data that these reports are created from are uploaded via CSV files (either daily, weekly or monthly) – so there needs to be some sort of upload feature. I will send examples of these files to the winning bidder.
7. When the new commission data is uploaded, because it appends, there needs some way to remove this data if it turns out to be bad. Currently we can delete any month of commission data from a table… a more elegant solution would be nice.
8. Our current user list would need to be moved and would need to work with the new permissions.
What you’ll have
• The existing site is mainly written in php. This should make it pretty easy (if youre familiar with nuke) to simply grab a lot of the SQL queries and translate them
• You will also be given access to the live site, so that you can see how the reports are formatted and sorted, everything. So there shouldn’t be any worry about how to lay things out or how to organize data.
• You will have access to a project manager via phone and AIM (voodoomagiccrab).
Attached is a fuller scope of the project and the permissions lay out.