$hfs = 16;
//header fontsize
$y_max = max($dataraw);
$y_max = $y_max < 10 ? 10 : ceil($y_max / 5) * 5;
$step = $y_max < 20 ? 2 : 5;
if ($y_max > 10) {
$y_max += $step;
}
$tags = new ofc_tags();
$tags->font("Verdana", $xfs)->align_x_center()->text('#y#')->style(true, false, false, 1);
$x = 0;
foreach ($data as $key => $v) {
$tags->append_tag(new ofc_tag($x, $v->top, $statuscolor[$key]));
$x++;
}
$bar = new bar_3d();
$bar->set_values(array_values($data));
$chart->add_element($bar);
$chart->add_element($tags);
//x-label
$xal = new x_axis_labels();
$tmp = array();
foreach ($statustext as $status => $text) {
$tmp[] = new x_axis_label($text, $statuscolor[$status], $xfs, 15);
}
$xal->set_labels($tmp);
$xal->set_size($xfs);
$x = new x_axis();
$x->set_offset(true);
$x->set_labels($xal);
$x->set_3d(5);
function return_ofc_day()
{
global $cms, $ps;
$styles =& $cms->theme->styles;
$days = array();
$labels = array();
$data = array();
$data_avg = array();
$sum = 0;
$avg = 0;
$max = 31;
$maxlimit = 100;
// get the last 31 days of data
$list = $ps->db->fetch_rows(1, "SELECT statdate,SUM(connections) connections " . "FROM {$ps->t_map_data} " . "GROUP BY statdate " . "ORDER BY statdate DESC LIMIT {$max}");
$now = $list ? ymd2time($list[0]['statdate']) : time();
while (count($days) < $max) {
$days[date('Y-m-d', $now)] = 'null';
$labels[] = date('M jS', $now);
$now -= 60 * 60 * 24;
}
$days = array_reverse($days);
$labels = array_reverse($labels);
// build our data and labels
$data = $days;
$maxdata = 0;
foreach ($list as $d) {
if (!array_key_exists($d['statdate'], $days)) {
continue;
}
$sum += $d['connections'];
$data[$d['statdate']] = $d['connections'];
$maxdata = max($maxdata, $d['connections']);
}
if ($data) {
$avg = $sum / count($data);
$data_avg[] = $avg;
$data_avg = array_pad($data_avg, count($data), 'null');
$data_avg[] = $avg;
# $data_avg = array_pad(array(), count($data), $avg);
$maxlimit = ceil(ceil($maxdata / 100) * 100);
}
include_once PS_ROOTDIR . '/includes/ofc/open-flash-chart.php';
$g = new graph();
$g->bg_colour = $styles->val('flash.conn.bgcolor', 'flash.bgcolor');
$g->title($styles->val('flash.conn.title', $cms->trans('Daily Connections'), true), '{' . $styles->val('flash.conn.title.style', 'font-size: 16px', true) . '}');
# $g->set_data($data_avg);
# $g->line(1, '#9999ee', 'Average Connections', 9);
# $g->set_data($data);
## $g->line_hollow(1, 3, '#5555ff', 'Connections', 9);
# $g->bar(75, '#5555ff', 'Connections', 9);
$avg_line = new line($styles->val('flash.conn.line.width'), $styles->val('flash.conn.line.color'));
$avg_line->key($styles->val('flast.conn.line.key', $cms->trans('Average Connections'), true), $styles->val('flash.conn.line.size', 9, true));
$avg_line->data = $data_avg;
$conn_bar = new bar_3d($styles->val('flash.conn.bar3d.opacity', 75, true), $styles->val('flash.conn.bar3d.color1', '#5555ff', true), $styles->val('flash.conn.bar3d.color2', '#3333DD', true));
$conn_bar->key($styles->val('flash.conn.bar3d.key', $cms->trans('Connections'), true), $styles->val('flash.conn.bar3d.size', 9, true));
$conn_bar->data = $data;
/*
$keys = array_keys($data);
for ($i=0; $i<count($data); $i++) {
$conn_bar->add_data_tip($data[$keys[$i]],
$cms->trans("Connections: %d", $data[$keys[$i]]) . "<br>" .
$cms->trans("Average: %d", $data_avg[0])
);
}
/**/
$g->set_tool_tip(sprintf($styles->val('flash.conn.tooltip', '#x_label#<br>#key#: #val# (' . $cms->trans('Avg') . ': %d)', true), round($data_avg[0])));
$g->data_sets[] = $avg_line;
$g->data_sets[] = $conn_bar;
$g->set_x_axis_3d(6);
// label each point with its value
$g->set_x_labels($labels);
// $g->set_x_axis_steps(count($labels) / 3 + 1);
// $g->set_x_tick_size(1);
$g->set_x_label_style(10, '#000000', 0, 3, '#cccccc');
// $g->set_x_label_style('none');
# $g->set_x_label_style( 8, '#000000', 2 );
$g->set_inner_background(coalesce($styles->val('flash.conn.bg_inner1', 'flash.bg_inner1'), '#E3F0FD'), coalesce($styles->val('flash.conn.bg_inner2', 'flash.bg_inner2'), '#CBD7E6'), coalesce($styles->val('flash.conn.bg_inner_angle', 'flash.bg_inner_angle'), 90));
$g->x_axis_colour('#909090', '#ADB5C7');
// $g->x_axis_colour('#eeeeee', '#eeeeee');
$g->y_axis_colour('#5555ff', '#eeeeee');
// $g->set_x_offset( false );
// set the Y max
$g->set_y_min(0);
$g->set_y_max($maxlimit);
$g->set_y_legend($styles->val('flash.conn.bar3d.key', $cms->trans('Connections')), 12, $styles->val('flash.conn.bar3d.color1', '#5555ff', true));
print $g->render();
}
GROUP BY a.RTID, b.Nama ORDER BY b.Nama, a.RTID';
$result = mssql_query($sql);
$data = array();
if (mssql_num_rows($result) > 0) {
while ($val = mssql_fetch_assoc($result)) {
$rt[] = 'RT ' . $val['RT'];
$jumlah[] = $val['Jumlah'];
$total = $val['total'];
$tempJumlah = $val['Jumlah'];
$maxJumlah = $maxJumlah > $tempJumlah ? $maxJumlah : $tempJumlah;
}
}
$max = 0;
$title = new title('Jumlah Data Peserta KB Per RT, RW ' . $aRw[$_REQUEST['rwId']]['nama'] . ' Total : ' . $total . ' ( ' . date("D M d Y") . ' ) ');
$title->set_style('{font-size:15px; color: #bcd6ff; margin:0px; background-color: #5E83BF;}');
$bar = new bar_3d();
$bar->set_values($jumlah);
$bar->colour = '#9999FF';
$bar->set_on_show(new bar_on_show('grow-up', 1, 0));
$labels = new x_axis_labels();
$labels->set_labels($rt);
$y_base = new y_axis_base();
$y_base->set_range(0, $maxJumlah + round($maxJumlah / 2), round($maxJumlah / 10));
$x = new x_axis();
$x->set_labels($labels);
$x->set_3d(5);
$y = new y_axis();
$y->set_labels($y_labels);
$tags = new ofc_tags();
$tags->font('Verdana', 10)->colour('#000000')->align_x_center()->text('#y#');
$i = 0;
}
}
//make IN PACKAGE, SENT TO HH bar is purple
if (in_array('IN PACKAGE', array_keys($data)) || in_array('SENT TO HH', array_keys($data))) {
$bar = new bar_value($package);
$bar->set_colour('#9c00ff');
$data['IN PACKAGE'] = $bar;
$bar = new bar_value($sent);
$bar->set_colour('#9c00ff');
$data['SENT TO HH'] = $bar;
}
/* MAKE ANIMATED BAR GROW
$bar = new bar_filled( '#E2D66A', '#577261' );
$bar->set_on_show(new bar_on_show('grow-up', 2.5, 0));
*/
$bar = new bar_3d();
if ($fullscreen) {
$bar->set_alpha(100);
}
$bar->colour('#0066CC');
//$bar->key("OPEN = PI already printed", 12);
$bar->set_values(array_values($data));
//$data2 = array(10,9,8,7,6,5,4,3,2);
//$bar2 = new bar_glass();
//$bar2->colour( '#5E0722' );
//$bar2->key('This year', 12);
//$bar2->set_values( $data2 );
$tags = new ofc_tags();
$tags->font("Verdana", $tagfs)->colour("#0066CC")->align_x_center()->text('#y#')->style(true, false, false, 1);
$x = 0;
foreach ($data as $key => $v) {
function CasesByProcess()
{
$dataSet = $this->getCasesByProcess();
$data = $dataSet['data'];
//$series2 = $dataSet['series2'];
$g = new graph();
$g->title(' Cases by Process ', '{font-size: 14px;}');
$bar_red = new bar_3d(50, '#3334AD');
$bar_red->key('cases', 10);
$bar_red->data = $data;
$g->data_sets[] = $bar_red;
$g->set_x_axis_3d(12);
$g->x_axis_colour('#909090', '#ADB5C7');
$g->y_axis_colour('#909090', '#ADB5C7');
$g->set_x_labels($dataSet['label']);
$g->set_y_max($dataSet['max']);
$g->y_label_steps(6);
echo $g->render();
}
function Chart3DBAR($LimiteMaximo = 100, $titulo = "", $titulo2 = "")
{
$data = $this->mValues;
$label = $this->mLabels;
$g = new graph();
$g->title($this->mTitle, '{font-size:16px; color: #FFFFFF; margin: 5px; background-color: #505050; padding:5px; padding-left: 20px; padding-right: 20px;}');
//$g->set_data( $data_1 );
//$g->bar_3D( 75, '#D54C78', '2006', 10 );
//$g->set_data( $data_2 );
//$g->bar_3D( 75, '#3334AD', '2007', 10 );
//Crea el Bar Blue
$bar_blue = new bar_3d(75, '#3334AD');
$bar_blue->key($titulo, 10);
$bar_blue->data = $this->mValues;
$g->data_sets[] = $bar_blue;
if (is_array($this->mValues2)) {
$bar_blue2 = new bar_3d(75, '#ff0000');
$bar_blue2->key($titulo2, 10);
$bar_blue2->data = $this->mValues2;
$g->data_sets[] = $bar_blue2;
}
$g->set_x_axis_3d(12);
$g->x_axis_colour('#909090', '#ADB5C7');
$g->y_axis_colour('#909090', '#ADB5C7');
$g->set_x_labels($this->mLabels);
$g->set_y_max($LimiteMaximo);
$g->y_label_steps(5);
//$g->set_y_legend( 'Open Flash Chart', 12, '#736AFF' );
$x = $g->render();
return $this->setWriteFile($x);
}
function PostByUserFlash()
{
$dataSet = $this->getPostByUser();
$data = $dataSet['data'];
$g = new graph();
$g->title(' Posts by User last week ' . date("Y-m-d"), '{font-size: 16px;}');
$max = 1;
foreach ($dataSet['data'] as $k => $val) {
if ($val > $max) {
$max = $val;
}
}
$max = intval($max / 4) * 4 + 4;
$bar_red = new bar_3d(50, '#356aa0');
$bar_red->key('posts', 10);
$bar_red->data = $data;
$bar_blue = new bar_3d(75, '#D54C78');
$bar_blue->key('completed', 10);
$bar_blue->data = $data;
$g->data_sets[] = $bar_red;
//$g->data_sets[] = $bar_blue;
$g->set_x_axis_3d(12);
$g->x_axis_colour('#909090', '#ADB5C7');
$g->y_axis_colour('#909090', '#ADB5C7');
$g->set_x_labels($dataSet['label']);
$g->set_y_max($max);
$g->y_label_steps(4);
$g->set_y_legend('Processmaker', 12, '#736AFF');
echo $g->render();
}
$bar = new bar_value($tmp[1] * -1);
if ($tmp[1] * -1 == 0) {
$bar->set_colour('#FFFFFF');
} else {
if ($tmp[1] * -1 > 0) {
$bar->set_colour('#000000');
} else {
if ($tmp[1] * -1 < 0) {
$bar->set_colour('#900000');
}
}
}
$datalist[] = $bar;
}
$title = new title("This month budget over/under");
$bar = new bar_3d();
$bar->set_values($datalist);
$bar->set_tooltip('$#val#');
$y = new y_axis();
$y->set_range(round($min * 1.2), round($max * 1.2));
$y->set_steps(count($datalist) * 2);
$y->set_label_text("\$#val#");
$x_labels = new x_axis_labels();
$x_labels->rotate(45);
$x_labels->set_labels($labellist);
$x = new x_axis();
$x->set_labels($x_labels);
$chart = new open_flash_chart();
$chart->set_title($title);
$chart->add_element($bar);
$chart->set_x_axis($x);
