====== FDM autoemail ======
Some of data used in [[http://www.filmdistributionmanager.com/wiki/doku.php?id=reports|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:

  -Every hour special script check the schedule table
  -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 [[http://www.filmdistributionmanager.com/wiki/doku.php?id=reports:invoice|invoices]] and [[http://www.filmdistributionmanager.com/wiki/doku.php?id=reports:dgbos|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