';
return $this->_html;
}
function getKeywords($url)
{
if (!Validate::isAbsoluteUrl($url))
return false;
$parsedUrl = parse_url($url);
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('SELECT `server`, `getvar` FROM `'._DB_PREFIX_.'search_engine`');
foreach ($result as $index => $row)
{
$host =& $row['server'];
$varname =& $row['getvar'];
if (strstr($parsedUrl['host'], $host))
{
$kArray = array();
if (!isset($parsedUrl['query']))
return false;
preg_match('/[^a-z]'.$varname.'=.+\&'.'/U', $parsedUrl['query'], $kArray);
if (!isset($kArray[0]) OR empty($kArray[0]))
preg_match('/[^a-z]'.$varname.'=.+$'.'/', $parsedUrl['query'], $kArray);
if (!isset($kArray[0]) OR empty($kArray[0]))
return false;
$kString = urldecode(str_replace('+', ' ', ltrim(substr(rtrim($kArray[0], '&'), strlen($varname) + 1), '=')));
return $kString;
}
}
}
protected function getData($layers)
{
$this->_titles['main'] = $this->l('10 first keywords');
$totalResult = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($this->_query.$this->getDate().$this->_query2);
$total = 0;
$total2 = 0;
foreach ($totalResult as $totalRow)
$total += $totalRow['occurences'];
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($this->_query.$this->getDate().$this->_query2.' LIMIT 9');
foreach ($result as $row)
{
$this->_legend[] = $row['keyword'];
$this->_values[] = $row['occurences'];
$total2 += $row['occurences'];
}
if ($total >= $total2)
{
$this->_legend[] = $this->l('Others');
$this->_values[] = $total - $total2;
}
}
}