public function indexAction() { $error = array(); if ($this->getRequest()->isPost()) { $request = $this->getRequest()->getParams(); $error = $this->_checkForm($request); if (count($error) == 0) { if ($request['textSearch']) { $condition = array(); $condition['firstName LIKE ?'] = "%{$request['textSearch']}%"; $condition['lastName LIKE ?'] = "%{$request['textSearch']}%"; $condition['city LIKE ?'] = "%{$request['textSearch']}%"; $session_condition = array(); $session_condition['textSearch'] = $request['textSearch']; $_SESSION['Condition'] = $session_condition; $page = $this->getRequest()->getParam('page'); list($this->view->Pager, $this->view->Trainer) = Trainer::getAllBySearch($condition, $page, 50, $order = 'lastName,firstName'); $this->view->Title = "Search Trainers by keyword: <span style='color:#0073EA'>" . $request['textSearch'] . "</span>"; $this->view->headTitle($this->view->Title); } } else { $this->view->error = $error; } } else { if ($_SESSION['Condition'] != "") { $condition = array(); $condition['firstName LIKE ?'] = "%{$_SESSION['Condition']['textSearch']}%"; $condition['lastName LIKE ?'] = "%{$_SESSION['Condition']['textSearch']}%"; $condition['city LIKE ?'] = "%{$_SESSION['Condition']['textSearch']}%"; $page = $this->getRequest()->getParam('page'); list($this->view->Pager, $this->view->Trainer) = Trainer::getAllBySearch($condition, $page, 50, $order = 'firstName, lastName'); $this->view->Title = "Search Trainers by keyword: <span style='color:#0073EA'>" . $_SESSION['Condition']['textSearch'] . "</span>"; $this->view->headTitle($this->view->Title); } else { $error[] = "Not found data. Please enter a keyword to search!"; $this->view->error = $error; } } }
public function indexAction() { $page = $this->getRequest()->getParam('page'); if (!$page) { $_SESSION['Condition'] = ""; } if ($this->getRequest()->isPost()) { $request = $this->getRequest()->getParams(); $error = $this->_checkFormSearch($request); if (count($error) == 0) { if ($request['textSearch']) { $condition = array(); if ($request['option'] == "firstname") { $condition['firstName LIKE ?'] = "%{$request['textSearch']}%"; } if ($request['option'] == "lastname") { $condition['lastName LIKE ?'] = "%{$request['textSearch']}%"; } if ($request['option'] == "city") { $condition['city LIKE ?'] = "%{$request['textSearch']}%"; } $session_condition = array(); $session_condition['option'] = $request['option']; $session_condition['textSearch'] = $request['textSearch']; $_SESSION['Condition'] = $session_condition; $this->view->Title = 'Trainers Listing'; $this->view->headTitle($this->view->Title); list($this->view->Pager, $this->view->Trainers) = Trainer::getAllBySearch($condition, 1, 20, $order = 'firstName, lastName'); } } else { $this->view->Title = 'Trainers Listing'; $this->view->headTitle($this->view->Title); $condition = array(); $ordder = "trainersListId"; list($this->view->Pager, $this->view->Trainers) = Trainer::getAll($condition, $page, 20, $order = 'firstName, lastName'); $this->view->error = $error; } } else { if (!$_SESSION['Condition']['textSearch'] || !$_SESSION['Condition']['option']) { $this->view->Title = 'Trainers Listing'; $this->view->headTitle($this->view->Title); $condition = array(); $ordder = "trainersListId"; list($this->view->Pager, $this->view->Trainers) = Trainer::getAll($condition, $page, 20, $order = 'firstName, lastName'); } else { $condition = array(); if ($_SESSION['Condition']['option'] == "firstname") { $condition['firstName LIKE ?'] = "%{$_SESSION['Condition']['textSearch']}%"; } if ($_SESSION['Condition']['option'] == "lastname") { $condition['lastName LIKE ?'] = "%{$_SESSION['Condition']['textSearch']}%"; } if ($_SESSION['Condition']['option'] == "city") { $condition['city LIKE ?'] = "%{$_SESSION['Condition']['textSearch']}%"; } $this->view->Title = 'Trainers Listing'; $this->view->headTitle($this->view->Title); list($this->view->Pager, $this->view->Trainers) = Trainer::getAll($condition, $page, 20, $order = 'firstName, lastName'); } } }