aboutsummaryrefslogtreecommitdiffstats
path: root/core/namespace/Post/Item.php
blob: d5b7f2e50e1c3f19b3625373b104e1ad305a2df2 (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
<?php
namespace Post;

class Item extends \Item {
	const CONFIGURATION = 'POST';

	#===============================================================================
	# Return absolute post URL
	#===============================================================================
	public function getURL(): string {
		if(\Application::get('POST.SLUG_URLS')) {
			return \Application::getPostURL("{$this->Attribute->get('slug')}/");
		}

		return \Application::getPostURL("{$this->Attribute->get('id')}/");
	}

	#===============================================================================
	# 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 [];
	}

	#===============================================================================
	# Return associated User\Attribute
	#===============================================================================
	public function getUserAttribute() {
		$Statement = $this->Database->query(sprintf('SELECT * FROM user WHERE id = %d', $this->Attribute->get('user')));
		return $Statement->fetchObject('User\Attribute');
	}
}
?>