Need a simple PHP website.
MySQL Database - Clients - simple client database (data items will be specified), incl. data handling routines (add, modify, delete)
- Vendors (translators) - simple translator database (data items will be specified), incl. data handling routines (add, modify, delete)
- Projects - simple project database - project No, client, translator, project data (data items will be specified)
Important: Need a function of automatic translator selection and mass sending of e-mail with invitations for projects
Idea: I get a translation in EN-DE language pair. The script searches all translators from the database, who translate from English to German. The script creates e-mail containing project details with links to accept the project and to reject the project. The script then sends this mass e-mail to selected translators. The first translator who responded (clicked the accept link in e-mail) will be selected and assigned a project. Project manager will be notified by e-mail that translator was selected.
If possible, each client and translator should have their own data folder (FTP) to save the relevant data. Possibly, after winning the project, translator should be able to download the complete project data from FTP (I operate FileZilla server).