We need the provider to produce a PHP script that will be run once a day or once a week by cron (we will arrange that part).
The script will need to do the following:
Lookup on mysql database for all fields where OPSTATUS=6 and BACKUP=0.
For all matching fields their will be a folder on our ftp named by ORDER_ID field (as shown in image document)
The script must zip this folder and contents and send it to predetermined email address (not variable). Individual email sent for each set.
Once the folder has been zipped and emailed the folder needs to be deleted
Once this has been done the BACKUP field in database needs to be set to BACKUP=1
The winning provider will be the one who has the best balance of feedback and price. We will consider those with zero feedback as we believe everyone has to start somewhere.
This is a simple low budget project which we need done within a few days.