public static function graphedLocalTTL()
{
$db = Database::tDataConnect();
$lookup = "SELECT \n SUM(CASE WHEN p.local=1 THEN l.total ELSE 0 END) as localTTL,\n SUM(CASE WHEN l.trans_type IN ('I','D') then l.total ELSE 0 END) as itemTTL\n FROM localtemptrans AS l LEFT JOIN " . CoreLocal::get('pDatabase') . $db->sep() . "products AS p\n ON l.upc=p.upc\n WHERE l.trans_type IN ('I','D')";
$lookup = $db->query($lookup);
if ($db->num_rows($lookup) == 0) {
return '';
}
$row = $db->fetch_row($lookup);
if ($row['localTTL'] == 0) {
return '';
}
$percent = (double) $row['localTTL'] / (double) $row['itemTTL'];
$str = sprintf('LOCAL PURCHASES = $%.2f (%.2f%%)', $row['localTTL'], 100 * $percent);
$str .= "\n";
$str .= self::$PRINT_OBJ->RenderBitmap(Bitmap::barGraph($percent), 'L');
return $str . "\n";
}
