* @copyright 2007-2011 PrestaShop SA * @version Release: $Revision: 6594 $ * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA */ if (!defined('_CAN_LOAD_FILES_')) exit; class StatsSearch extends ModuleGraph { private $_html = ''; private $_query = ''; private $_query2 = ''; function __construct() { $this->name = 'statssearch'; $this->tab = 'analytics_stats'; $this->version = 1.0; $this->author = 'PrestaShop'; $this->need_instance = 0; $this->_query = ' SELECT ss.`keywords`, COUNT(TRIM(ss.`keywords`)) as occurences, MAX(results) as total FROM `'._DB_PREFIX_.'statssearch` ss WHERE ss.`date_add` BETWEEN '; $this->_query2 = ' GROUP BY ss.`keywords` HAVING occurences > 1 ORDER BY occurences DESC'; parent::__construct(); $this->displayName = $this->l('Shop search'); $this->description = $this->l('Display which keywords have been searched by your visitors.'); } function install() { if (!parent::install() OR !$this->registerHook('search') OR !$this->registerHook('AdminStatsModules')) return false; return Db::getInstance()->Execute(' CREATE TABLE `'._DB_PREFIX_.'statssearch` ( id_statssearch INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, keywords VARCHAR(255) NOT NULL, results INT(6) NOT NULL DEFAULT 0, date_add DATETIME NOT NULL, PRIMARY KEY(id_statssearch) ) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8'); } function uninstall() { if (!parent::uninstall()) return false; return (Db::getInstance()->Execute('DROP TABLE `'._DB_PREFIX_.'statssearch`')); } function hookSearch($params) { Db::getInstance()->Execute('INSERT INTO `'._DB_PREFIX_.'statssearch` (`keywords`,`results`,`date_add`) VALUES (\''.pSQL($params['expr']).'\', '.(int)($params['total']).', NOW())'); } function hookAdminStatsModules() { if (Tools::getValue('export')) $this->csvExport(array('type' => 'pie')); $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS($this->_query.ModuleGraph::getDateBetween().$this->_query2); $this->_html = '

'.$this->displayName.''; $table = '

'; foreach ($result as $row) { if (Tools::strlen($row['keywords']) >= Configuration::get('PS_SEARCH_MINWORDLEN')) $table .= ''; } $table .= '

'.$this->l('Keywords').'	'.$this->l('Occurrences').'	'.$this->l('Results').'
'.$row['keywords'].'	'.$row['occurences'].'	'.$row['total'].'

'; if (sizeof($result)) $this->_html .= ''.ModuleGraph::engine(array('type' => 'pie')).'

'.$this->l('CSV Export').'

'.$table; else $this->_html .= '

'.$this->l('No keywords searched more than once found.').'

'; $this->_html .= '

'; return $this->_html; } protected function getData($layers) { $this->_titles['main'] = $this->l('First 10 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) { if (!$row['occurences']) continue; $this->_legend[] = $row['keywords']; $this->_values[] = $row['occurences']; $total2 += $row['occurences']; } if ($total > $total2) { $this->_legend[] = $this->l('Others'); $this->_values[] = $total - $total2; } } }