Changes to functionality of an existing site

The following amendments need to be carried out on an existing site.

1. Currently there is a Users Database, with a list of users who receive reports. The type of report they get depends on the type of user they are. The reports are sent daily iin an email and it is all done automatically by the click of a button.

We want the users list to be changed and to have a Company list instead with a list of users within each company. In other words a company might have 3 users so there will need to be a company table and a user table linked into this.

The company information will contain information such as Start Date, expiry date etc. so that we can run reports to show companies that are due to renew, also we need a box to tick to stop that company and its related users gaining access to the reports if they do not renew their subscription.

Currently the users get an email daily but they can also log in using a username and password and can gain access to their level of reports on the site also.

2. We need an archives section. Firstly we need to be able to upload archived reports as far back as 2005. Each report when being entered into the system will need a date field so that when we are inputting archived reports we can select the relevant date. Some companies will purchase the ability to view archives from us and is this happens we want to tick a box at company level to allow all users in the company access to archives going back to 2005.

3. The start date for Companies is so thatl companies will have access to archives only from their Start Date by default.

4. Currently when a report is being added (daily) the record in the database is indexed by id which changes every time a record is added. Some users want to automate the download of this report and to do this we need the link to be the same every day. To exalain better the link now looks something like [url removed, login to view] we need it to be [url removed, login to view] where [url removed, login to view] will be in the filename field of the record. Now, to handle archiving reports, when an administrator uploads a report every day, they will make sure that the report will always have the same name. But we need the system to take the report currently on the system i.e. yesterdays report and move the record to an archives table, append yesterdays date to the end of the filename (the date will be added to the record when the reports are being uploaded to the system) and then move the renamed pdf to an archives folder on the server. the purpose of putting the date to the end of the name is to make the filename unique.

Users can then use the date field to filter archived reports.

Hopefully the spec doc will make it easier to follow.

AJAX JavaScript MySQL PHP

Nº del proyecto: #1021291

Sobre el proyecto