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