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:
<?php
$host = 'localhost'; // MYSQL database host adress
$db = 'dbname'; // MYSQL database name
$user = 'dbuser'; // Mysql Datbase user
$pass = $_REQUEST['password']; // Mysql Datbase password
$rounddate = $_REQUEST['rounddate'];
//parse round date
$sheetyear = substr($rounddate,4,4);
$sheetmonth = substr($rounddate,2,2);
$sheetday = substr($rounddate,0,2);
$date = $sheetyear."-".$sheetmonth."-".$sheetday;
// Connect to the database
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
//Get data from citrus
$query = "SELECT
billing_details.billing_id,billing_details.invoice_number,customer.account_number
FROM billing_details,customer WHERE
billing_details.billing_id=customer.default_billing_id and
billing_details.creation_date = '$date'";
$result = mysql_query($query);
//put data in array
$i = "0";
$details = array();
while ($row = mysql_fetch_array($result)) {
$details[$i][0]=$row[0];
$details[$i][1]=$row[1];
$details[$i][2]=$row[2];
$i++;
}
//remove duplicates where there is more than one service per invoice
$j = "0";
$duplicates=array();
$dets=$details;
while ($j < $i+1) {
if (in_array($details[$j][1],$duplicates)) {
unset($dets[$j]);
}
array_push($duplicates,$details[$j][1]);
//$details = array_values($details);
$j++;
}
//save PDF invoices
for ($m=0; $m<$i; $m++) {
$url =
"http://citrusurl/index.php?load=tools/printpreviousinvoice&billingid=".$dets[$m][0]."&invoiceid=".$dets[$m][1]."&details=on&type=dl&submit=on";;
$path =
"/home/user/invoices/".$sheetyear.$sheetmonth.$sheetday.$dets[$m][2].".pdf";
$in = fopen($url,"rb");
$out = fopen($path,"wb");
while($chunk = fread($in,8192)){
fwrite($out,$chunk,8192);
}
fclose($in);
fclose($out);
//print $dets[$m][0];
//print $dets[$m][1];
//print $dets[$m][2];
}
?>
When the script attempts to retrieve the PDF's it can't because it isn't
logged into citrus. It is creating files with the citrus login page
saved in them. Can you help with a workaround?
Many thanks,
Ben Monypenny
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
