<?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; }