diff options
author | 2009-10-03 14:08:25 +0000 | |
---|---|---|
committer | 2009-10-03 14:08:25 +0000 | |
commit | b7345f833dea849e94f2ce23fdbe6ab58ba98be3 (patch) | |
tree | b6b6d73910e69621824e0fb46bcaa81d08607052 /src/SemanticScuttle/Service/searchhistoryservice.php | |
parent | 29422fa55379aa61a61019b832c83dab6d450264 (diff) | |
download | scuttle-b7345f833dea849e94f2ce23fdbe6ab58ba98be3.tar.gz scuttle-b7345f833dea849e94f2ce23fdbe6ab58ba98be3.zip |
more file renamings
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@387 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'src/SemanticScuttle/Service/searchhistoryservice.php')
-rw-r--r-- | src/SemanticScuttle/Service/searchhistoryservice.php | 124 |
1 files changed, 0 insertions, 124 deletions
diff --git a/src/SemanticScuttle/Service/searchhistoryservice.php b/src/SemanticScuttle/Service/searchhistoryservice.php deleted file mode 100644 index 91457e8..0000000 --- a/src/SemanticScuttle/Service/searchhistoryservice.php +++ /dev/null @@ -1,124 +0,0 @@ -<?php -class SearchHistoryService { - var $db; - var $tablename; - var $sizeSearchHistory; - - function &getInstance(&$db) { - static $instance; - if (!isset($instance)) - $instance =& new SearchHistoryService($db); - return $instance; - } - - function SearchHistoryService(& $db) { - $this->db =& $db; - $this->tablename = $GLOBALS['tableprefix'] .'searchhistory'; - if(isset($GLOBALS['sizeSearchHistory'])) { - $this->sizeSearchHistory = $GLOBALS['sizeSearchHistory']; - } else { - $this->sizeSearchHistory = 10; - } - } - - function addSearch($terms, $range, $nbResults, $uId=0) { - if(strlen($terms) == 0) { - return false; - } - $datetime = gmdate('Y-m-d H:i:s', time()); - - //Insert values - $values = array('shTerms'=>$terms, 'shRange'=>$range, 'shDatetime'=>$datetime, 'shNbResults'=>$nbResults, 'uId'=>$uId); - $sql = 'INSERT INTO '. $this->getTableName() .' '. $this->db->sql_build_array('INSERT', $values); - $this->db->sql_transaction('begin'); - if (!($dbresult = & $this->db->sql_query($sql))) { - $this->db->sql_transaction('rollback'); - message_die(GENERAL_ERROR, 'Could not insert search history', '', __LINE__, __FILE__, $sql, $this->db); - return false; - } - - if($this->sizeSearchHistory != -1 && - $this->countSearches() > $this->sizeSearchHistory) { - $this->deleteOldestSearch(); - } - } - - function getAllSearches($range = NULL, $uId = NULL, $nb = NULL, $start = NULL, $distinct = false, $withResults = false) { - $sql = 'SELECT DISTINCT(shTerms), shId, shRange, shNbResults, shDatetime, uId'; - $sql.= ' FROM '. $this->getTableName(); - $sql.= ' WHERE 1=1'; - if($range != NULL) { - $sql.= ' AND shRange = "'.$range.'"'; - } else { - $sql.= ' AND shRange = "all"'; - } - if($uId != NULL) { - $sql.= ' AND uId = '.$uId; - } - if($withResults = true) { - $sql.= ' AND shNbResults > 0'; - } - if($distinct) { - $sql.= ' GROUP BY shTerms'; - } - $sql.= ' ORDER BY shId DESC'; - - if (!($dbresult = & $this->db->sql_query_limit($sql, $nb, $start))) { - message_die(GENERAL_ERROR, 'Could not get searches', '', __LINE__, __FILE__, $sql, $this->db); - return false; - } - - $searches = array(); - while ($row = & $this->db->sql_fetchrow($dbresult)) { - $searches[] = $row; - } - $this->db->sql_freeresult($dbresult); - return $searches; - } - - function countSearches() { - $sql = 'SELECT COUNT(*) AS `total` FROM '. $this->getTableName(); - if (!($dbresult = & $this->db->sql_query($sql)) || (!($row = & $this->db->sql_fetchrow($dbresult)))) { - message_die(GENERAL_ERROR, 'Could not get total searches', '', __LINE__, __FILE__, $sql, $this->db); - return false; - } - $this->db->sql_freeresult($dbresult); - return $row['total']; - } - - /* This function allows to limit the number of saved searches - by deleting the oldest one */ - function deleteOldestSearch() { - $sql = 'DELETE FROM '.$this->getTableName(); - $sql.= ' ORDER BY shId ASC LIMIT 1'; // warning: here the limit is important - - $this->db->sql_transaction('begin'); - if (!($dbresult = & $this->db->sql_query($sql))) { - $this->db->sql_transaction('rollback'); - message_die(GENERAL_ERROR, 'Could not delete bookmarks', '', __LINE__, __FILE__, $query, $this->db); - return false; - } - } - - function deleteSearchHistoryForUser($uId) { - $query = 'DELETE FROM '. $this->getTableName() .' WHERE uId = '. intval($uId); - - if (!($dbresult = & $this->db->sql_query($query))) { - message_die(GENERAL_ERROR, 'Could not delete search history', '', - __LINE__, __FILE__, $query, $this->db); - return false; - } - - return true; - } - - function deleteAll() { - $query = 'TRUNCATE TABLE `'. $this->getTableName() .'`'; - $this->db->sql_query($query); - } - - // Properties - function getTableName() { return $this->tablename; } - function setTableName($value) { $this->tablename = $value; } -} -?> |