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');
}
}
}
