$series[] = new ChartDataSerie(array('raw_data' => array(1, 2, 3)));
$series[] = new ChartDataSerie(array('raw_data' => array(3, 4, 5)));
$gs->setSeries($series);
$t->cmp_ok($gs->getSeriesCount(), '===', 2, '->getSeriesCount() counts the number of series in the raw_data array');
// ->getSeriesDataByColumn()
$t->diag('->getSeriesDataByColumn()');
$data = Doctrine_Core::getTable('Charge')->findAll();
$gs = new ChartSource();
try {
$gs->getSeriesDataByColumn('kilometers');
$t->fail('no code should be executed after throwing an exception');
} catch (Exception $e) {
$t->pass('->getSeriesDataByColumn() Raw data must be set before retrieving series');
}
$series = array(new ChartDataSerie(array('raw_data' => $data)));
$gs->setSeries($series);
try {
$gs->getSeriesDataByColumn('quantity');
$t->fail('no code should be executed after throwing an exception');
} catch (Exception $e) {
$t->pass('->getSeriesDataByColumn() All rows must be defined in charges table to build sets for a given column');
}
$series = $gs->getSeriesDataByColumn('kilometers');
$t->cmp_ok(count($series), '===', 1, '->getSeriesDataByColumn() returns an array containing the requested data for each data serie');
$t->cmp_ok(count($series[0]), '===', count($data), '->getSeriesDataByColumn() returns a value for each element in raw_data');
$dates = array();
$dates_ts = array();
foreach ($data as $charge) {
$dates[] = $charge->getDate();
$dates_ts[] = strtotime($charge->getDate());
}
/**
* Builds and stores a ChartSource object, containing the raw data required to
* plot the chart.
*
* @see ChartSource
*
* @return true of false, depending if a ChartSource has been correctly built.
*/
public function buildChartSource()
{
$gs = new ChartSource();
$gs->addParams($this->getParameters());
// setting chart parameters
$gs->addParams($this->getOption('chart_parameters'));
// getting source data
$vehicle_display = $this->getParameter('vehicle_display', 'single');
$category_display = $this->getParameter('category_display', 'stacked');
$series = $this->getChartSourceData($vehicle_display, $category_display);
if (!$series) {
return false;
}
$gs->setSeries($series);
$this->getLogger()->info(sprintf('Chart %s source does not exist exist. Building chart data source.', $this->getChartName()));
$this->chart_source = $gs;
return true;
}
public function getChartSource($scenario, $categories_names = array(), $params = array())
{
$vd = $scenario[0];
$cd = $scenario[1];
$scn = $this->getCase($vd, $cd);
$defalut_categories = array('Fuel', 'Tax', 'Maintenance');
$default_vehicles = array('car_gs_1', 'car_gs_2', 'car_gs_3');
switch ($scn) {
case 1:
$q = Doctrine_Core::getTable('Charge')->createQuery('c')->select('c.*')->leftJoin('c.User u')->andWhere('u.Username = ?', array('user_gs'));
if ($categories_names) {
$q->leftJoin('c.Category ct')->andWhereIn('ct.name', $categories_names);
}
$history = $this->handleLimits($q, $scenario, $params);
$q = $q->execute();
$v = Doctrine_Core::getTable('Vehicle')->findByUserId($this->getUserId('user_gs'));
$vid = $this->extractIds($v);
$cid = $this->getCategoriesIdByName($categories_names);
$series = array(new ChartDataSerie(array('raw_data' => $q, 'label' => 'all stacked', 'id' => 'allstacked', 'vehicle_id' => $vid, 'category_id' => $cid)));
break;
case 2:
$cat = $categories_names ? $categories_names : $defalut_categories;
$v = Doctrine_Core::getTable('Vehicle')->findByUserId($this->getUserId('user_gs'));
$vid = $this->extractIds($v);
$series = array();
foreach ($cat as $key => $name) {
$q = Doctrine_Core::getTable('Charge')->createQuery('c')->select('c.*')->leftJoin('c.Category ct')->andWhere('ct.Name = ?', $name)->leftJoin('c.User u')->andWhere('u.Username = ?', array('user_gs'));
$history = $this->handleLimits($q, $scenario, $params);
$q = $q->execute();
$cid = $this->getCategoriesIdByName($name);
$series[$key] = new ChartDataSerie(array('raw_data' => $q, 'label' => 'tax', 'id' => 'tax', 'vehicle_id' => $vid, 'category_id' => $cid));
}
break;
case 3:
$cat = $categories_names ? $categories_names : array();
$cid = $this->getCategoriesIdByName($cat);
$series = array();
foreach ($default_vehicles as $key => $name) {
$q = Doctrine_Core::getTable('Charge')->createQuery('c')->select('c.*')->leftJoin('c.Vehicle v')->andWhere('v.Name = ?', $name)->leftJoin('c.User u')->andWhere('u.Username = ?', array('user_gs'));
if ($categories_names) {
$q->leftJoin('c.Category ct')->andWhereIn('ct.name', $categories_names);
}
$history = $this->handleLimits($q, $scenario, $params);
$q = $q->execute();
$v = Doctrine_Core::getTable('Vehicle')->findOneByName($name);
$vid = $this->extractIds($v);
$series[$key] = new ChartDataSerie(array('raw_data' => $q, 'label' => 'car_gs_1', 'id' => 'car_gs_1', 'vehicle_id' => $vid, 'category_id' => $cid));
}
break;
case 4:
$cat = $categories_names ? $categories_names : $defalut_categories;
$series = array();
foreach ($default_vehicles as $vk => $vname) {
foreach ($cat as $ck => $cname) {
$q = Doctrine_Core::getTable('Charge')->createQuery('c')->select('c.*')->leftJoin('c.Vehicle v')->andWhere('v.Name = ?', $vname)->leftJoin('c.Category ct')->andWhere('ct.Name = ?', $cname)->leftJoin('c.User u')->andWhere('u.Username = ?', array('user_gs'));
$history = $this->handleLimits($q, $scenario, $params);
$q = $q->execute();
$v = Doctrine_Core::getTable('Vehicle')->findOneByName($vname);
$vid = $this->extractIds($v);
$c = Doctrine_Core::getTable('Category')->findOneByName($cname);
$cid = $this->extractIds($c);
$series[] = new ChartDataSerie(array('raw_data' => $q, 'label' => 'car_gs_1_tax', 'id' => 'car_gs_1_tax', 'vehicle_id' => $vid, 'category_id' => $cid));
}
}
break;
default:
throw new sfException('Case not defined');
break;
}
$cat = $categories_names ? $categories_names : $defalut_categories;
$cid = $this->getCategoriesIdByName($cat);
$params = array('vehicle_display' => $vd, 'category_display' => $cd, 'categories_list' => $cid, 'full_history' => $history);
if (isset($scenario[3])) {
if ('distance' == $scenario[2]) {
$params['kilometers_from'] = $scenario[3];
$params['kilometers_to'] = $scenario[4];
} else {
$params['date_from'] = $scenario[3];
$params['date_to'] = $scenario[4];
}
}
$g = new ChartSource();
$g->addParams($params);
$g->setSeries($series);
return $g;
}
