FDM autoemail

Some of data used in FDM needed to be send out every day or every week based on industry need.

Invoices – every Wednesday
DGBOS report – everyday at 08:00 EST

Pereferable format – PDF

To solve this I made the next thing on the VPS:

1. Every hour special script check the schedule table
2. If any actions needed – it executed them

Known actions:

• Execute the link (provided URL)

Ok. This action is enough for all needed purposes.

Everytime the special PHP-script made with help of CodeIgniter 2.0 framework is executed and do next things

• Creates the pdf-reports based on mySQL database (single invoices and DGBOS reports)
• On needed time send the PDF-files onto known emails
• Also it write log-file about what files were sent and when, messages if errors
• For security reasons the URL is working only if it's called from the localhost