blob: 14a207a2dbe44b07b9bf4a6fe382bbcddd72eda6 (
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
|
<?php
/**
* $Header$
*
* @copyright (c) 2004 bitweaver.org
* Copyright (c) 2003 tikwiki.org
* Copyright (c) 2002-2003, Luis Argerich, Garland Foster, Eduardo Polidor, et. al.
* All Rights Reserved. See below for details and a complete list of authors.
* Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See http://www.gnu.org/copyleft/lesser.html for details
*
* $Id$
* @author Luis Argerich (lrargerich@yahoo.com)
* @package search
*/
namespace Bitweaver\Search;
use Bitweaver\BitBase;
/**
* @package search
* @subpackage SearchStatsLib
*/
class SearchStatsLib extends BitBase {
public function clear_search_stats() {
$query = "DELETE FROM `".BIT_DB_PREFIX."search_stats";
$result = $this->mDb->query($query,[]);
}
public function list_search_stats($offset, $max_records, $sort_mode, $find) {
if ($find) {
$mid = " WHERE (UPPER(`term`) LIKE ?)";
$bindvars = [ "%".strtoupper( $find )."%" ];
} else {
$mid = "";
$bindvars = [];
}
$query = "SELECT * FROM `".BIT_DB_PREFIX."search_stats` $mid ORDER BY ".$this->mDb->convertSortmode($sort_mode);
$query_cant = "SELECT COUNT(*) FROM `".BIT_DB_PREFIX."search_stats` $mid";
$result = $this->mDb->query($query,$bindvars,$max_records,$offset);
$cant = $this->mDb->getOne($query_cant,$bindvars);
$ret = [];
while ($res = $result->fetchRow()) {
$ret[] = $res;
}
$retval = [];
$retval["data"] = $ret;
$retval["cant"] = $cant;
return $retval;
}
}
|
