public function ajaxGetClassesAction() { $this->_helper->layout->disableLayout(); $subjectModel = new Application_Model_Subjects(); $subjects = $subjectModel->fetchAll($subjectModel->getAllAvaiabled()); $this->view->subjects = $subjects; $page = $this->_getParam('page', 1); $params = array('Classes.ClassId' => 'DESC'); $params['foreign'] = array(array('table' => 'Grades', 'key' => 'GradeId', 'cols' => array('GradeName')), array('table' => 'Districts', 'key' => 'DistrictId', 'cols' => array('DistrictName'))); $where = array('Classes.IsDisabled = 0'); $class = $this->_getParam('class', null); $district = $this->_getParam('district', null); $subject = $this->_getParam('subject', null); if (!is_null($class)) { $where[] = 'Classes.GradeId=' . $class; } if (!is_null($district)) { $where[] = 'Classes.DistrictId=' . $district; } if (!is_null($subject)) { $sub = "ClassSubjects = '{$subject}' "; $sub .= "OR ClassSubjects like '{$subject},%' "; $sub .= "OR ClassSubjects like '%,{$subject},%' "; $sub .= "OR ClassSubjects like '%,{$subject}' "; $where[] = $sub; } $params['where'] = $where; //set Lastest News pagination $this->view->page = $page; $paginator = Zend_Paginator::factory($this->_model->getQuerySelectAll($params)); $paginator->setItemCountPerPage(CLASSES_ITEMS); $paginator->setCurrentPageNumber($page); $this->view->paginator = $paginator; }