. 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(); } } }