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
|
<?php
// h-source, a web software to build a community of people that want to share their hardware information.
// Copyright (C) 2010 Antonio Gallo (h-source-copyright.txt)
//
// This file is part of h-source
//
// h-source is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// h-source is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with h-source. If not, see <http://www.gnu.org/licenses/>.
if (!defined('EG')) die('Direct access not allowed!');
class SearchController extends BaseController
{
public function __construct($model, $controller, $queryString)
{
$this->_topMenuClasses['search'] = " class='currentitem'";
parent::__construct($model, $controller, $queryString);
$this->model('HardwareModel');
$data['title'] = 'search - '.Website::$generalName;
$this->append($data);
}
public function form($lang = 'en')
{
$this->cleverLoad('form');
$this->right();
}
public function results($lang = 'en')
{
Params::$nullQueryValue = 'undef';
$argKeys = array(
'page:forceNat' => 1,
'action:sanitizeAlphanum' => 'search',
'type:sanitizeString' => 'notebook',
'model:sanitizeString' => 'undef',
);
$this->setArgKeys($argKeys);
$this->shift(1);
if (strcmp($this->viewArgs['action'],'search') === 0)
{
Params::$whereClauseSymbolArray = array('like');
$whereClause = array(
'type' => $this->viewArgs['type'],
'model' => "like '%".$this->viewArgs['model']."%'",
'-deleted' => "no",
);
// echo $this->viewArgs['type'];
$recordNumber = $this->m['HardwareModel']->clear()->where($whereClause)->orderBy("id_hard desc")->rowNumber();
$data['recordNumber'] = $recordNumber;
//load the Pages helper
$this->helper('Pages',$this->controller.'/results/'.$this->lang,'page');
$page = $this->viewArgs['page'];
//set the limit clause
$limit = $this->h['Pages']->getLimit($page,$recordNumber,10);
$data['table'] = $this->m['HardwareModel']->clear()->select('id_hard,model,type,comm_year')->where($whereClause)->limit($limit)->orderBy("id_hard desc")->send();
// echo $this->m['HardwareModel']->getQuery();
$data['pageList'] = $this->h['Pages']->render($page-3,7);
$this->append($data);
$this->cleverLoad('results');
$this->right();
}
}
}
|
