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
|
<?php
#===============================================================================
# Get instances
#===============================================================================
$Database = Application::getDatabase();
$Language = Application::getLanguage();
$SEARCH_SUCCESS = FALSE;
$D_LIST = $Database->query(sprintf('SELECT DISTINCT DAY(time_insert) AS temp FROM %s ORDER BY temp', Post\Attribute::TABLE));
$M_LIST = $Database->query(sprintf('SELECT DISTINCT MONTH(time_insert) AS temp FROM %s ORDER BY temp', Post\Attribute::TABLE));
$Y_LIST = $Database->query(sprintf('SELECT DISTINCT YEAR(time_insert) AS temp FROM %s ORDER BY temp', Post\Attribute::TABLE));
if($search = HTTP::GET('q')) {
if(!$attributes = Post\Item::getSearchResults($search, [HTTP::GET('d'), HTTP::GET('m'), HTTP::GET('y')], $Database)) {
$message = $Language->text('search_no_results', escapeHTML($search));
}
}
$form_data = [
'SELECT' => [
'D' => HTTP::GET('d'),
'M' => HTTP::GET('m'),
'Y' => HTTP::GET('y'),
],
'OPTIONS' => [
'D' => $D_LIST->fetchAll($Database::FETCH_COLUMN),
'M' => $M_LIST->fetchAll($Database::FETCH_COLUMN),
'Y' => $Y_LIST->fetchAll($Database::FETCH_COLUMN),
]
];
$search_data = [
'TEXT' => $search,
'INFO' => isset($message) ? $message : FALSE,
];
#===============================================================================
# Build document
#===============================================================================
if(isset($attributes) AND !empty($attributes)) {
foreach($attributes as $Attribute) {
try {
$Post = Post\Factory::buildByAttribute($Attribute);
$User = User\Factory::build($Post->attr('user'));
$posts[] = generatePostItemTemplate($Post, $User);
}
catch(Post\Exception $Exception){}
catch(User\Exception $Exception){}
}
$ResultTemplate = Template\Factory::build('search/result');
$ResultTemplate->set('FORM', $form_data);
$ResultTemplate->set('SEARCH', $search_data);
$ResultTemplate->set('RESULT', [
'LIST' => $posts ?? []
]);
$MainTemplate = Template\Factory::build('main');
$MainTemplate->set('HTML', $ResultTemplate);
$MainTemplate->set('HEAD', [
'NAME' => $Language->text('title_search_results', escapeHTML($search)),
'PERM' => Application::getURL('search/')
]);
}
else {
$SearchTemplate = Template\Factory::build('search/main');
$SearchTemplate->set('FORM', $form_data);
$SearchTemplate->set('SEARCH', $search_data);
$MainTemplate = Template\Factory::build('main');
$MainTemplate->set('HTML', $SearchTemplate);
$MainTemplate->set('HEAD', [
'NAME' => $Language->text('title_search_request'),
'PERM' => Application::getURL('search/')
]);
}
echo $MainTemplate;
|