$result = mysql_query($sql); if ($result) { $total = 0; $totalsold = 0; $totalbroken = 0; $totaldemo = 0; while ($member = mysql_fetch_assoc($result)) { $sold = $member['sold'] != "" ? $member['sold'] : 0; $broken = $member['broken'] != "" ? $member['broken'] : 0; $demo = $member['demo'] != "" ? $member['demo'] : 0; $line = array("Product" => $member['name'], "Sold" => " " . $sold, "Broken" => " " . $broken, "Demo" => " " . $demo, "Cost" => "£ " . number_format($member['retailprice'] * ($broken + $sold + $demo), 2)); $this->addLine($this->GetY(), $line); $total += $member['retailprice'] * ($broken + $sold + $demo); $totalsold += $sold; $totalbroken += $broken; $totaldemo += $demo; } $line = array("Product" => "Total : ", "Sold" => " " . $totalsold, "Broken" => " " . $totalbroken, "Demo" => " " . $totaldemo, "Cost" => "£ " . number_format($total, 2)); $this->addLine($this->GetY() + 4, $line); } else { logError($sql . " - " . mysql_error()); } } catch (Exception $e) { logError($e->getMessage()); } } } start_db(); $pdf = new SalesReport('P', 'mm', 'A4'); $pdf->Output();
<?php require_once "system-db.php"; require_once 'reportdailycostslibdata.php'; start_db(); $file = "uploads/emailforecast-" . session_id() . "-" . time() . ".pdf"; $report = new SalesReport('P', 'mm', 'A4', date("d/m/Y")); $report->Output($file, "F"); sendRoleMessage("FORECASTALERT", "Forecast Results", "Forecast information attached", array($file));