The last push continues

Still pushing! I've been a bit frustrated and anxious about the site for the last month and I decided to try and nail down why and what to do about it. The thing main thing on my mind was the variable width of the site due to the need to represent project partners as columns. The more partners a project has, the more columns need to be shown. And each column required a sub-query to display it's data. I was worried that large projects with many partners would suffer performance problems as well as display problems (width would exceed visible width of some monitors), but the very idea for the site came from the desire to simplify the management of large projects.

The new layout is without partner columns. Once a document is downloaded or received from the printers, it's version is added/updated in the dispatch table and if not already present, the document is added to a partners watchlist. A watchlist entry contains the documents id along with the versions_count value from when it was last updated. If a new version is added to a document being 'watched' the discrepancy betwen the watchlist row's count and the documents count show up and this is drawn to the attention of the partner. Make sense?

File uploads/downloads working, although without progress bar. Payment processing put back until it becomes a problem (i.e. until I have customers). Adding Print job functionality which works as follws:
select docs to print, select printshop (from partners list), select email template, select due date, send.
Job is added to partners watchlist. Once job arrives, user can check checkbox to update dispatches table.

I've decided to build this so that I can use it here at work. I want to have it up on a web server next month s I can use it on our current project and then see what functionality it still needs. You can't beat live testing. The next stage would be to roll it out on other projects and/or invite partners. And then launch!