Re: [Citrusdb-users] Saving PDF Invoices to Server

2010-03-01 Thread Paul Yasi
When you said mailing them with a cron job, do you mean attaching them to an email? There is an e-invoice type for emailed invoices, however it sends a text invoice right now. At some point i'd like to add an option that makes that attach pdf files to invoices too that would need to generate eac

Re: [Citrusdb-users] Saving PDF Invoices to Server

2010-02-26 Thread Paul Yasi
You'll need to take the code from printpreivous and edit it a bit and run it outside of citrusdb with the php command line program. If use use SELECT DISTINCT billing_details.invoice_number I don't think you'll need to do that thing that removes duplicate results either. Include the functions at

Re: [Citrusdb-users] Saving PDF Invoices to Server

2010-02-25 Thread Allen
this is great! Ben Monypenny wrote: > Hi Paul, > > I have been working on a way to save the day's new invoices as PDF's > to a path on the server for mailing with a cron job. My code is: > > > $host = 'localhost'; // MYSQL database host adress > $db = 'dbname'; // MYSQL database name > $user = '

[Citrusdb-users] Saving PDF Invoices to Server

2010-02-25 Thread Ben Monypenny
Hi Paul, I have been working on a way to save the day's new invoices as PDF's to a path on the server for mailing with a cron job. My code is: $query = "SELECT billing_details.billing_id,billing_details.invoice_number,customer.account_number FROM billing_details,customer WHERE billing_detai