public function executeChartEmployees() { $data = array(); foreach (JobPeer::doSelect(new Criteria()) as $job) { $c = new Criteria(); $c->add(EmployeePeer::JOB_ID, $job->getId()); $data[$job->getName()] = EmployeePeer::doCount($c); } //To create a bar chart we need to create a stBarOutline Object $bar = new stBarOutline(80, '#78B9EC', '#3495FE'); $bar->key('', 10); //Passing the random data to bar chart $bar->data = $data; //Creating a stGraph object $g = new stGraph(); $g->title('Employee Job Type Break-Down', '{font-size: 20px;}'); $g->bg_colour = '#FFFFFF'; $g->set_inner_background('#E3F0FD', '#CBD7E6', 90); $g->x_axis_colour('#8499A4', '#E4F5FC'); $g->y_axis_colour('#8499A4', '#E4F5FC'); //Pass stBarOutline object i.e. $bar to graph $g->data_sets[] = $bar; //Setting labels for X-Axis $g->set_x_labels(array_keys($data)); // to set the format of labels on x-axis e.g. font, color, step $g->set_x_label_style(10, '#18A6FF', 0, 2); // To tick the values on x-axis // 2 means tick every 2nd value $g->set_x_axis_steps(2); //set maximum value for y-axis //we can fix the value as 20, 10 etc. //but its better to use max of data $g->set_y_max(max($data)); $g->y_label_steps(4); $g->set_y_legend('# Employees', 12, '#18A6FF'); echo $g->render(); return sfView::NONE; }
/** * Creates line chart from random data. */ public function executeLineChartData() { $chartData = array(); for ($i = 0; $i < 7; $i++) { $chartData[] = rand(0, 50); } //Create new stGraph object $g = new stGraph(); // Chart Title $g->title('stOfcPlugin example', '{font-size: 20px;}'); $g->bg_colour = '#E4F5FC'; $g->set_inner_background('#E3F0FD', '#CBD7E6', 90); $g->x_axis_colour('#8499A4', '#E4F5FC'); $g->y_axis_colour('#8499A4', '#E4F5FC'); //Use line_dot to set line dots diameter, text, color etc. $g->line_dot(2, 3, '#3495FE', 'Number of downloads per day', 10); //In case of line chart data should be passed to stGraph object //unsing set_data $g->set_data($chartData); //Setting labels for X-Axis $g->set_x_labels(array('Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun')); //to set the format of labels on x-axis e.g. font, color, step $g->set_x_label_style(10, '#18A6FF', 0, 1); //set maximum value for y-axis //we can fix the value as 20, 10 etc. //but its better to use max of data $g->set_y_max(max($chartData)); $g->y_label_steps(5); // display the data echo $g->render(); echo $g->render(); return sfView::NONE; }
public function executeGraficoLinea() { $chartData = array(); for ($i = 0; $i < 25; $i++) { $chartData[] = rand(0, 50); } //Create new stGraph object $g = new stGraph(); // Chart Title $g->title('% de Facilitadores por Estado', '{font-size: 20px;}'); $g->bg_colour = '#E4F5FC'; $g->set_inner_background('#E3F0FD', '#CBD7E6', 90); $g->x_axis_colour('#8499A4', '#E4F5FC'); $g->y_axis_colour('#8499A4', '#E4F5FC'); //Use line_dot to set line dots diameter, text, color etc. $g->line_dot(2, 3, '#3495FE', 'Porcentaje de facilitadores por Estado', 10); //In case of line chart data should be passed to stGraph object //unsing set_data $g->set_data($chartData); //Setting labels for X-Axis $estados = Doctrine_Core::getTable('Estado')->getEstados(); foreach ($estados as $e) { $lista_estados[] = $e->getNombreEstado(); } $g->set_x_labels($lista_estados); //to set the format of labels on x-axis e.g. font, color, step $g->set_x_label_style(10, '#18A6FF', 1, 1); //set maximum value for y-axis //we can fix the value as 20, 10 etc. //but its better to use max of data $g->set_y_max(max($chartData)); $g->y_label_steps(10); // display the data echo $g->render(); echo $g->render(); return sfView::NONE; }