blob: 1adf897cca141180400bddcfc49ee43aa814e96c (
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
|
<?php
namespace Post;
class Item extends \Item {
const CONFIGURATION = 'POST';
#===============================================================================
# Return unique pseudo GUID
#===============================================================================
public function getGUID(): string {
foreach(\Application::get('POST.FEED_GUID') as $attribute) {
$attributes[] = $this->Attribute->get($attribute);
}
return sha1(implode(NULL, $attributes));
}
#===============================================================================
# Return unique post IDs for search results
#===============================================================================
public static function getSearchResultIDs($search, array $date, \Database $Database): array {
$D = ($D = intval($date[0])) !== 0 ? $D : 'NULL';
$M = ($M = intval($date[1])) !== 0 ? $M : 'NULL';
$Y = ($Y = intval($date[2])) !== 0 ? $Y : 'NULL';
$Statement = $Database->prepare(sprintf("SELECT id FROM %s WHERE
({$Y} IS NULL OR YEAR(time_insert) = {$Y}) AND
({$M} IS NULL OR MONTH(time_insert) = {$M}) AND
({$D} IS NULL OR DAY(time_insert) = {$D}) AND
MATCH(name, body) AGAINST(? IN BOOLEAN MODE) LIMIT 20", Attribute::TABLE));
if($Statement->execute([$search])) {
return $Statement->fetchAll($Database::FETCH_COLUMN);
}
return [];
}
}
|
