*/ class Mage_Adminhtml_Block_Dashboard_Graph extends Mage_Adminhtml_Block_Dashboard_Abstract { /** * Api URL */ const API_URL = 'http://chart.apis.google.com/chart'; /** * All series * * @var array */ protected $_allSeries = array(); /** * Axis labels * * @var array */ protected $_axisLabels = array(); /** * Axis maps * * @var array */ protected $_axisMaps = array(); /** * Data rows * * @var array */ protected $_dataRows = array(); /** * Simple encoding chars * * @var string */ protected $_simpleEncoding = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'; /** * Extended encoding chars * * @var string */ protected $_extendedEncoding = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.'; /** * Chart width * * @var string */ protected $_width = '587'; /** * Chart height * * @var string */ protected $_height = '300'; /** * Google chart api data encoding * * @var string */ protected $_encoding = 'e'; /** * Html identifier * * @var string */ protected $_htmlId = ''; /** * Initialize object * * @return void */ public function __construct() { parent::__construct(); $this->setTemplate('dashboard/graph.phtml'); } /** * Get tab template * * @return string */ protected function _getTabTemplate() { return 'dashboard/graph.phtml'; } /** * Set data rows * * @param mixed $rows * @return void */ public function setDataRows($rows) { $this->_dataRows = (array)$rows; } /** * Add series * * @param string $seriesId * @param array $options * @return void */ public function addSeries($seriesId, array $options) { $this->_allSeries[$seriesId] = $options; } /** * Get series * * @param string $seriesId * @return mixed */ public function getSeries($seriesId) { if (isset($this->_allSeries[$seriesId])) { return $this->_allSeries[$seriesId]; } else { return false; } } /** * Get all series * * @return array */ public function getAllSeries() { return $this->_allSeries; } /** * Get chart url * * @param bool $directUrl * @return string */ public function getChartUrl($directUrl = true) { $params = array( 'cht' => 'lc', 'chf' => 'bg,s,f4f4f4|c,lg,90,ffffff,0.1,ededed,0', 'chm' => 'B,f4d4b2,0,0,0', 'chco' => 'db4814' ); $this->_allSeries = $this->getRowsData($this->_dataRows); foreach ($this->_axisMaps as $axis => $attr){ $this->setAxisLabels($axis, $this->getRowsData($attr, true)); } $timezoneLocal = Mage::app()->getStore()->getConfig(Mage_Core_Model_Locale::XML_PATH_DEFAULT_TIMEZONE); list ($dateStart, $dateEnd) = Mage::getResourceModel('reports/order_collection') ->getDateRange($this->getDataHelper()->getParam('period'), '', '', true); $dateStart->setTimezone($timezoneLocal); $dateEnd->setTimezone($timezoneLocal); $dates = array(); $datas = array(); while($dateStart->compare($dateEnd) < 0){ switch ($this->getDataHelper()->getParam('period')) { case '24h': $d = $dateStart->toString('yyyy-MM-dd HH:00'); $dateStart->addHour(1); break; case '7d': case '1m': $d = $dateStart->toString('yyyy-MM-dd'); $dateStart->addDay(1); break; case '1y': case '2y': $d = $dateStart->toString('yyyy-MM'); $dateStart->addMonth(1); break; } foreach ($this->getAllSeries() as $index=>$serie) { if (in_array($d, $this->_axisLabels['x'])) { $datas[$index][] = (float)array_shift($this->_allSeries[$index]); } else { $datas[$index][] = 0; } } $dates[] = $d; } /** * setting skip step */ if (count($dates) > 8 && count($dates) < 15) { $c = 1; } else if (count($dates) >= 15){ $c = 2; } else { $c = 0; } /** * skipping some x labels for good reading */ $i=0; foreach ($dates as $k => $d) { if ($i == $c) { $dates[$k] = $d; $i = 0; } else { $dates[$k] = ''; $i++; } } $this->_axisLabels['x'] = $dates; $this->_allSeries = $datas; //Google encoding values if ($this->_encoding == "s") { // simple encoding $params['chd'] = "s:"; $dataDelimiter = ""; $dataSetdelimiter = ","; $dataMissing = "_"; } else { // extended encoding $params['chd'] = "e:"; $dataDelimiter = ""; $dataSetdelimiter = ","; $dataMissing = "__"; } // process each string in the array, and find the max length foreach ($this->getAllSeries() as $index => $serie) { $localmaxlength[$index] = sizeof($serie); $localmaxvalue[$index] = max($serie); $localminvalue[$index] = min($serie); } if (is_numeric($this->_max)) { $maxvalue = $this->_max; } else { $maxvalue = max($localmaxvalue); } if (is_numeric($this->_min)) { $minvalue = $this->_min; } else { $minvalue = min($localminvalue); } // default values $yrange = 0; $yLabels = array(); $miny = 0; $maxy = 0; $yorigin = 0; $maxlength = max($localmaxlength); if ($minvalue >= 0 && $maxvalue >= 0) { $miny = 0; if ($maxvalue > 10) { $p = pow(10, $this->_getPow($maxvalue)); $maxy = (ceil($maxvalue/$p))*$p; $yLabels = range($miny, $maxy, $p); } else { $maxy = ceil($maxvalue+1); $yLabels = range($miny, $maxy, 1); } $yrange = $maxy; $yorigin = 0; } $chartdata = array(); foreach ($this->getAllSeries() as $index => $serie) { $thisdataarray = $serie; if ($this->_encoding == "s") { // SIMPLE ENCODING for ($j = 0; $j < sizeof($thisdataarray); $j++) { $currentvalue = $thisdataarray[$j]; if (is_numeric($currentvalue)) { $ylocation = round((strlen($this->_simpleEncoding)-1) * ($yorigin + $currentvalue) / $yrange); array_push($chartdata, substr($this->_simpleEncoding, $ylocation, 1) . $dataDelimiter); } else { array_push($chartdata, $dataMissing . $dataDelimiter); } } // END SIMPLE ENCODING } else { // EXTENDED ENCODING for ($j = 0; $j < sizeof($thisdataarray); $j++) { $currentvalue = $thisdataarray[$j]; if (is_numeric($currentvalue)) { if ($yrange) { $ylocation = (4095 * ($yorigin + $currentvalue) / $yrange); } else { $ylocation = 0; } $firstchar = floor($ylocation / 64); $secondchar = $ylocation % 64; $mappedchar = substr($this->_extendedEncoding, $firstchar, 1) . substr($this->_extendedEncoding, $secondchar, 1); array_push($chartdata, $mappedchar . $dataDelimiter); } else { array_push($chartdata, $dataMissing . $dataDelimiter); } } // ============= END EXTENDED ENCODING ============= } array_push($chartdata, $dataSetdelimiter); } $buffer = implode('', $chartdata); $buffer = rtrim($buffer, $dataSetdelimiter); $buffer = rtrim($buffer, $dataDelimiter); $buffer = str_replace(($dataDelimiter . $dataSetdelimiter), $dataSetdelimiter, $buffer); $params['chd'] .= $buffer; $labelBuffer = ""; $valueBuffer = array(); $rangeBuffer = ""; if (sizeof($this->_axisLabels) > 0) { $params['chxt'] = implode(',', array_keys($this->_axisLabels)); $indexid = 0; foreach ($this->_axisLabels as $idx=>$labels){ if ($idx == 'x') { /** * Format date */ foreach ($this->_axisLabels[$idx] as $_index=>$_label) { if ($_label != '') { switch ($this->getDataHelper()->getParam('period')) { case '24h': $this->_axisLabels[$idx][$_index] = $this->formatTime( new Zend_Date($_label, 'yyyy-MM-dd HH:00'), 'short', false ); break; case '7d': case '1m': $this->_axisLabels[$idx][$_index] = $this->formatDate( new Zend_Date($_label, 'yyyy-MM-dd') ); break; case '1y': case '2y': $formats = Mage::app()->getLocale()->getTranslationList('datetime'); $format = isset($formats['yyMM']) ? $formats['yyMM'] : 'MM/yyyy'; $format = str_replace(array("yyyy", "yy", "MM"), array("Y", "y", "m"), $format); $this->_axisLabels[$idx][$_index] = date($format, strtotime($_label)); break; } } else { $this->_axisLabels[$idx][$_index] = ''; } } $tmpstring = implode('|', $this->_axisLabels[$idx]); $valueBuffer[] = $indexid . ":|" . $tmpstring; if (sizeof($this->_axisLabels[$idx]) > 1) { $deltaX = 100/(sizeof($this->_axisLabels[$idx])-1); } else { $deltaX = 100; } } else if ($idx == 'y') { $valueBuffer[] = $indexid . ":|" . implode('|', $yLabels); if (sizeof($yLabels)-1) { $deltaY = 100/(sizeof($yLabels)-1); } else { $deltaY = 100; } // setting range values for y axis $rangeBuffer = $indexid . "," . $miny . "," . $maxy . "|"; } $indexid++; } $params['chxl'] = implode('|', $valueBuffer); }; // chart size $params['chs'] = $this->getWidth().'x'.$this->getHeight(); if (isset($deltaX) && isset($deltaY)) { $params['chg'] = $deltaX . ',' . $deltaY . ',1,0'; } // return the encoded data if ($directUrl) { $p = array(); foreach ($params as $name => $value) { $p[] = $name . '=' .urlencode($value); } return self::API_URL . '?' . implode('&', $p); } else { $gaData = urlencode(base64_encode(serialize($params))); $gaHash = Mage::helper('adminhtml/dashboard_data')->getChartDataHash($gaData); $params = array('ga' => $gaData, 'h' => $gaHash); return $this->getUrl('*/*/tunnel', array('_query' => $params)); } } /** * Get rows data * * @param array $attributes * @param bool $single * @return array */ protected function getRowsData($attributes, $single = false) { $items = $this->getCollection()->getItems(); $options = array(); foreach ($items as $item){ if ($single) { $options[] = max(0, $item->getData($attributes)); } else { foreach ((array)$attributes as $attr){ $options[$attr][] = max(0, $item->getData($attr)); } } } return $options; } /** * Set axis labels * * @param string $axis * @param array $labels * @return void */ public function setAxisLabels($axis, $labels) { $this->_axisLabels[$axis] = $labels; } /** * Set html id * * @param string $htmlId * @return void */ public function setHtmlId($htmlId) { $this->_htmlId = $htmlId; } /** * Get html id * * @return string */ public function getHtmlId() { return $this->_htmlId; } /** * Return pow * * @param int $number * @return int */ protected function _getPow($number) { $pow = 0; while ($number >= 10) { $number = $number/10; $pow++; } return $pow; } /** * Return chart width * * @return string */ protected function getWidth() { return $this->_width; } /** * Return chart height * * @return string */ protected function getHeight() { return $this->_height; } /** * Prepare chart data * * @return void */ protected function _prepareData() { $availablePeriods = array_keys($this->helper('adminhtml/dashboard_data')->getDatePeriods()); $period = $this->getRequest()->getParam('period'); $this->getDataHelper()->setParam('period', ($period && in_array($period, $availablePeriods)) ? $period : '24h' ); } }