Unicenta - Automated Script to email daily report and alerts

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.

Skills: HTML, Java, MySQL, PHP

See more: project manager open source php, php code to create report, php and mysql pdf, job description of project manager, java alerts, it project manager job description, generating reports in php mysql, email application in php, automated website for sale, job application skills list, unicenta, point of sale application, mysql/java-mysql-job, daily sale, mysql script php pdf, point sale system source code, java inventory application, report mysql php database, email process job, transaction report

About the Employer:
( 1 review ) London, United Kingdom

Project ID: #4973733

Awarded to:


We can do this for you, no problem, in both ways, when do you needed finished and when can we start, we prefer CRON is tha ok with you

$30 USD in 3 days
(5 Reviews)

2 freelancers are bidding on average $47 for this job


Hi there, I am interested in working on this project....Please check my reviews and then decide on me. We can make use of the 2nd approach.i.e The second way would be to create a CRON job in PHP which will sit More

$64 USD in 3 days
(142 Reviews)