Description of Project
This project needs a custom built script to check the inventory level of the current stock and send an alert to the Manager if the stock level reaches to a certain amount or [url removed, login to view] same script may be used to send an email once a sale is made. I would also like the script to send out a daily report in a .PDF format. Unicenta already has functions to generate a report in a .PDF format so you can reuse this code.
There are two ways of generating the reports and email them to the Manager. The first way will be to implement a new method into the Open Source Application written in Java. The second way would be to create a CRON job in PHP which will sit on the server and check the MySQL database for any updates, process any reports and then email it to the manager.
List of Requirements
* Check the stock levels in the MySQL database
* Send an email once a Sale transaction is made.
* Generate a report and send an email
* Generate a daily report of all sales and email
I would like for this script to be completed 5 days after project commences.
Knowledge of Java, MySQL, PHP and HTML is required.
The source files of the Open Source Point of Sale System can be downloaded from there website.