Esempio n. 1
0
            }
            $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));