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
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
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 = '
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