[jngu]

Hi, I have a small business website. Lately, I signed up with my hosting company to have PHP and mySQL enabled. I need to have the following functionality in place. A client can sign up for a new account on my website by filling in the details. He will get a confirmation via email on his new account. Using his new account, he can logon securely (SSL) and do the following:
1. submit job request (with ability to attach files),
2. check job status,
3. download completed reports & invoices (pdf or doc)
4. send email using his account
I hope to use mySQL to autosave the job request and the attachment. For me (administrator), I can logon to do the following:
1. view all the job requests in mySQL
2. download job request and the attachment (if any)
2. upload completed reports and invoices to individual clients
Whenever a job is completed, an email and a SMS will be sent to client . Hope anyone can provide me some help or point me to any program which can do all this. Thanks. You may email me at jonathan@lumee.com

[jewellgr]

Are you willing to pay for something like that?

[YourPHPPro]

This or this might be what you are looking for:

OpenDocMan is a web based document management system designed to comply with ISO 17025 and OIE standard for document management. Written in PHP and using MySQL as it's database, it features fine grained control of access to files, a detailed search engine, and file moderation. Many new features were added.

SDMS uses PHP to provide you with a pretty interface to a MySQL server that allows you to store and retrieve documents and to share those doucments between users. In addition, the system uses ACL (Access Control Lists) to grant access rights to documents on a per-user basis. It allows you to distribute project documentation on a need-to-know basis, whilst keeping a central repository of documents that is accessible to all team members and easy to manage.

If you desire custom modifications to either of them, feel free to PM me.

[stomper@stomper.net]

We might be able to put something together for you using our script from gateowl.com. When you say "job request", what kind of job are you talking about?