function GraphIt($names, $values, $title) { $counter = count($names); /* Can choose any color you wish */ for ($i = 0; $i < $counter; $i++) { $bars[$i] = "#DEDEEE"; } $counter = count($values); /* Figure the max_value passed in, so scale can be determined */ $max_value = 0.0; for ($i = 0; $i < $counter; $i++) { if ($values[$i] > $max_value) { $max_value = $values[$i]; } } if ($max_value < 1) { $max_value = 1; } /* I want my graphs all to be 800 pixels wide, so that is my divisor */ //$scale = (int) (600/$max_value); $scale = 200 / $max_value; /* I create a wrapper table around the graph that holds the title */ echo "<TABLE BGCOLOR=\"NAVY\" CELLSPACING=2 CELLPADDING=3>"; echo "<TR><TD BGCOLOR=\"NAVY\"><FONT COLOR=WHITE><B>{$title}</TD></TR><TR><TD>"; /* Create an associatve array to pass in. I leave most of it blank */ $vals = array("vlabel" => "", "hlabel" => "", "type" => "0", "cellpadding" => "", "cellspacing" => "", "border" => "", "width" => "", "background" => "", "vfcolor" => "", "hfcolor" => "", "vbgcolor" => "", "hbgcolor" => "", "vfstyle" => "", "hfstyle" => "", "noshowvals" => "", "scale" => "{$scale}", "namebgcolor" => "", "valuebgcolor" => "", "namefcolor" => "", "valuefcolor" => "", "namefstyle" => "", "valuefstyle" => "", "doublefcolor" => ""); /* This is the actual call to the HTML_Graphs class */ html_graph($names, $values, $bars, $vals); echo "</TD></TR></TABLE>"; }
function zen_banner_graph_daily($banner_id) { global $db, $banner, $_GET; $year = isset($_GET['year']) ? $_GET['year'] : date('Y'); $month = isset($_GET['month']) ? $_GET['month'] : date('n'); $days = date('t', mktime(0, 0, 0, $month)) + 1; $stats = array(); for ($i = 1; $i < $days; $i++) { $names[] = $i; $values[] = '0'; $dvalues[] = '0'; } $banner_stats = $db->Execute("select dayofmonth(banners_history_date) as banner_day,\n\t banners_shown as value, banners_clicked as dvalue\n\t\t\t\t\t\t\t\t\t\t from " . TABLE_BANNERS_HISTORY . "\n\t\t\t\t\t\t\t\t\t\t where banners_id = '" . (int) $banner_id . "'\n\t\t\t\t\t\t\t\t\t\t and month(banners_history_date) = '" . zen_db_input($month) . "'\n\t\t\t\t\t\t\t\t\t\t and year(banners_history_date) = '" . zen_db_input($year) . "'"); while (!$banner_stats->EOF) { $names[$banner_stats->fields['banner_day'] - 1] = $banner_stats->fields['banner_day']; $values[$banner_stats->fields['banner_day'] - 1] = $banner_stats->fields['value'] ? $banner_stats->fields['value'] : '0'; $dvalues[$banner_stats->fields['banner_day'] - 1] = $banner_stats->fields['dvalue'] ? $banner_stats->fields['dvalue'] : '0'; $banner_stats->MoveNext(); } $largest = @max($values); $bars = array(); $dbars = array(); for ($i = 0, $n = sizeof($values); $i < $n; $i++) { $bars[$i] = DIR_WS_IMAGES . 'graph_hbar_blue.gif'; $dbars[$i] = DIR_WS_IMAGES . 'graph_hbar_red.gif'; } $graph_vals = @array('vlabel' => TEXT_BANNERS_DATA, 'hlabel' => sprintf(TEXT_BANNERS_DAILY_STATISTICS, $banner->fields['banners_title'], strftime('%B', mktime(0, 0, 0, $month)), $year), 'type' => '3', 'cellpadding' => '', 'cellspacing' => '1', 'border' => '', 'width' => '', 'vfcolor' => '#ffffff', 'hfcolor' => '#ffffff', 'vbgcolor' => '#81a2b6', 'hbgcolor' => '#81a2b6', 'vfstyle' => 'Verdana, Arial, Helvetica', 'hfstyle' => 'Verdana, Arial, Helvetica', 'scale' => 100 / $largest, 'namebgcolor' => '#f3f5fe', 'valuebgcolor' => '#f3f5fe', 'namefcolor' => '', 'valuefcolor' => '#0000d0', 'namefstyle' => 'Verdana, Arial, Helvetica', 'valuefstyle' => '', 'doublefcolor' => '#ff7339'); return html_graph($names, $values, $bars, $graph_vals, $dvalues, $dbars); }
/** * draws a double vertical bar graph for the banner views vs clicks statistics * * @param $banner_id * @return string */ function oosBannerGraphDaily($banner_id) { global $banner; $year = $_GET['year'] ? $_GET['year'] : date('Y'); $month = $_GET['month'] ? $_GET['month'] : date('n'); $days = date('t', mktime(0, 0, 0, $month)) + 1; $stats = array(); for ($i = 1; $i < $days; $i++) { $names[] = $i; $values[] = '0'; $dvalues[] = '0'; } // Get database information $dbconn =& oosDBGetConn(); $oostable =& oosDBGetTables(); $query = "SELECT dayofmonth(banners_history_date) as banner_day,\n banners_shown as value, banners_clicked as dvalue\n FROM " . $oostable['banners_history'] . " \n WHERE banners_id = '" . $banner_id . "'\n AND month(banners_history_date) = '" . $month . "'\n AND year(banners_history_date) = '" . $year . "'"; $result =& $dbconn->Execute($query); while ($banner_stats = $result->fields) { $names[$banner_stats['banner_day'] - 1] = $banner_stats['banner_day']; $values[$banner_stats['banner_day'] - 1] = $banner_stats['value'] ? $banner_stats['value'] : '0'; $dvalues[$banner_stats['banner_day'] - 1] = $banner_stats['dvalue'] ? $banner_stats['dvalue'] : '0'; // Move that ADOdb pointer! $result->MoveNext(); } // Close result set $result->Close(); $largest = @max($values); $bars = array(); $dbars = array(); for ($i = 0, $n = count($values); $i < $n; $i++) { $bars[$i] = OOS_IMAGES . 'graph_hbar_blue.gif'; $dbars[$i] = OOS_IMAGES . 'graph_hbar_red.gif'; } $graph_vals = @array('vlabel' => TEXT_BANNERS_DATA, 'hlabel' => sprintf(TEXT_BANNERS_DAILY_STATISTICS, $banner['banners_title'], strftime('%B', mktime(0, 0, 0, $month)), $year), 'type' => '3', 'cellpadding' => '', 'cellspacing' => '1', 'border' => '', 'width' => '', 'vfcolor' => '#ffffff', 'hfcolor' => '#ffffff', 'vbgcolor' => '#81a2b6', 'hbgcolor' => '#81a2b6', 'vfstyle' => 'Verdana, Arial, Helvetica', 'hfstyle' => 'Verdana, Arial, Helvetica', 'scale' => 100 / $largest, 'namebgcolor' => '#f3f5fe', 'valuebgcolor' => '#f3f5fe', 'namefcolor' => '', 'valuefcolor' => '#0000d0', 'namefstyle' => 'Verdana, Arial, Helvetica', 'valuefstyle' => '', 'doublefcolor' => '#ff7339'); return html_graph($names, $values, $bars, $graph_vals, $dvalues, $dbars); }
/** * GraphIt() - Build a graph * * @author Tim Perdue tperdue@valinux.com * @param array An array of names * @param array An array of values * @param string The title of the graph * */ function GraphIt($name_string, $value_string, $title) { global $HTML; $counter = count($name_string); /* Can choose any color you wish */ $bars = array(); for ($i = 0; $i < $counter; $i++) { $bars[$i] = $HTML->COLOR_LTBACK1; } $counter = count($value_string); /* Figure the max_value passed in, so scale can be determined */ $max_value = 0; for ($i = 0; $i < $counter; $i++) { if ($value_string[$i] > $max_value) { $max_value = $value_string[$i]; } } if ($max_value < 1) { $max_value = 1; } /* I want my graphs all to be 800 pixels wide, so that is my divisor */ $scale = 400 / $max_value; /* I create a wrapper table around the graph that holds the title */ $title_arr = array(); $title_arr[] = $title; echo $GLOBALS['HTML']->listTableTop($title_arr); echo '<tr><td>'; /* Create an associate array to pass in. I leave most of it blank */ $vals = array('vlabel' => '', 'hlabel' => '', 'type' => '', 'cellpadding' => '', 'cellspacing' => '0', 'border' => '', 'width' => '', 'background' => '', 'vfcolor' => '', 'hfcolor' => '', 'vbgcolor' => '', 'hbgcolor' => '', 'vfstyle' => '', 'hfstyle' => '', 'noshowvals' => '', 'scale' => $scale, 'namebgcolor' => '', 'valuebgcolor' => '', 'namefcolor' => '', 'valuefcolor' => '', 'namefstyle' => '', 'valuefstyle' => '', 'doublefcolor' => ''); /* This is the actual call to the HTML_Graphs class */ html_graph($name_string, $value_string, $bars, $vals); echo ' </td></tr> <!-- end outer graph table -->'; echo $GLOBALS['HTML']->listTableBottom(); }
function GraphIt($name_string, $value_string, $title) { /* GraphIt by Tim Perdue, PHPBuilder.com */ $counter = count($name_string); /* Can choose any color you wish */ $bars = array(); for ($i = 0; $i < $counter; $i++) { $bars[$i] = util_get_image_theme('bargraph.png'); } $counter = count($value_string); /* Figure the max_value passed in, so scale can be determined */ $max_value = 0; for ($i = 0; $i < $counter; $i++) { if ($value_string[$i] > $max_value) { $max_value = $value_string[$i]; } } if ($max_value < 1) { $max_value = 1; } /* I want my graphs all to be 800 pixels wide, so that is my divisor */ $scale = 400 / $max_value; /* I create a wrapper table around the graph that holds the title */ $title_arr = array(); $title_arr[] = $title; echo html_build_list_table_top($title_arr); echo '<TR><TD>'; /* Create an associate array to pass in. I leave most of it blank */ $vals = array('vlabel' => '', 'hlabel' => '', 'type' => '', 'cellpadding' => '', 'cellspacing' => '0', 'border' => '', 'width' => '', 'background' => '', 'vfcolor' => '', 'hfcolor' => '', 'vbgcolor' => '', 'hbgcolor' => '', 'vfstyle' => '', 'hfstyle' => '', 'noshowvals' => '', 'scale' => $scale, 'namebgcolor' => '', 'valuebgcolor' => '', 'namefcolor' => '', 'valuefcolor' => '', 'namefstyle' => '', 'valuefstyle' => '', 'doublefcolor' => ''); /* This is the actual call to the HTML_Graphs class */ html_graph($name_string, $value_string, $bars, $vals); echo ' </TD></TR></TABLE> <!-- end outer graph table -->'; }
function olc_banner_graph_daily($banner_id) { global $banner; $year = $_GET['year'] ? $_GET['year'] : date('Y'); $month = $_GET['month'] ? $_GET['month'] : date('n'); $days = date('t', mktime(0, 0, 0, $month)) + 1; $stats = array(); for ($i = 1; $i < $days; $i++) { $names[] = $i; $values[] = '0'; $dvalues[] = '0'; } $banner_stats_query = olc_db_query("select dayofmonth(banners_history_date) as banner_day, banners_shown as value, banners_clicked as dvalue from " . TABLE_BANNERS_HISTORY . " where banners_id = '" . $banner_id . "' and month(banners_history_date) = '" . $month . "' and year(banners_history_date) = '" . $year . APOS); while ($banner_stats = olc_db_fetch_array($banner_stats_query)) { $names[$banner_stats['banner_day'] - 1] = $banner_stats['banner_day']; $values[$banner_stats['banner_day'] - 1] = $banner_stats['value'] ? $banner_stats['value'] : '0'; $dvalues[$banner_stats['banner_day'] - 1] = $banner_stats['dvalue'] ? $banner_stats['dvalue'] : '0'; } $largest = @max($values); $bars = array(); $dbars = array(); for ($i = 0, $n = sizeof($values); $i < $n; $i++) { $bars[$i] = DIR_WS_IMAGES . 'graph_hbar_blue.gif'; $dbars[$i] = DIR_WS_IMAGES . 'graph_hbar_red.gif'; } $graph_vals = @array('vlabel' => TEXT_BANNERS_DATA, 'hlabel' => sprintf(TEXT_BANNERS_DAILY_STATISTICS, $banner['banners_title'], strftime('%B', mktime(0, 0, 0, $month)), $year), 'type' => '3', 'cellpadding' => '', 'cellspacing' => '1', 'border' => '', 'width' => '', 'vfcolor' => '#ffffff', 'hfcolor' => '#ffffff', 'vbgcolor' => '#81a2b6', 'hbgcolor' => '#81a2b6', 'vfstyle' => 'Verdana, Arial, Helvetica', 'hfstyle' => 'Verdana, Arial, Helvetica', 'scale' => 100 / $largest, 'namebgcolor' => '#f3f5fe', 'valuebgcolor' => '#f3f5fe', 'namefcolor' => '', 'valuefcolor' => '#0000d0', 'namefstyle' => 'Verdana, Arial, Helvetica', 'valuefstyle' => '', 'doublefcolor' => '#ff7339'); return html_graph($names, $values, $bars, $graph_vals, $dvalues, $dbars); }