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