The job consists of writing a “BATCH CONTROL” program and a database filter called “PR3”. The “Batch control” is basically a small database that gives us an overview of our orders. This database “reads” the orders form an e-mail XML file and puts them into the database. This process is controlled by a CRON.
The second program is a database filter called “PR3”. This filter is starting from a CSV file which needs to be loaded in the database. The database is performing a filter process and mails the result to an e-mail address.
All code is in PHP/MYSQL for a linux platform. All code must be written in a well structured way, and needs to be well documented with clearly defined parameters and procedures.