summaryrefslogtreecommitdiff
path: root/src/SemanticScuttle/Service/searchhistoryservice.php
blob: 91457e8d85b08ac93386c79ea9590f330786da9e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?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; }
}
?>