<?php
include dirname(__FILE__) . '/../bootstrap/Doctrine.php';
$t = new lime_test(31, new lime_output_color());
// ->setParam()
$t->diag('->setParam()');
$g = new ChartSource();
$g->setParam('dfsdf', 'asdfgsdg');
$t->cmp_ok($g->getParam('dfsdf'), '===', 'asdfgsdg', '->setParam() sets the defined parameter');
// ->addParams()
$t->diag('->addParams()');
$p = array('a1234' => '34', 'wrter' => 'wetwet', 'ysrw34' => 'asgsdf');
$g->addParams($p);
$t->cmp_ok($g->getParam('a1234'), '===', '34', '->addParams() allows to set multiple parameters via an array');
// ->getSeries()
$t->diag('->getSeries()');
$gs = new ChartSource();
try {
$gs->getSeries();
$t->fail('no code should be executed after throwing an exception');
} catch (Exception $e) {
$t->pass('->getSeries() require series to be set.');
}
// ->setSeries()
$t->diag('->setSeries()');
$series = array();
$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->getSeries(), '===', $series, '->getSeries() returns series set by setSeries()');
// ->getSeriesCount()
/**
* 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;
}
