public function executeAjaxProjectPager() { $this->section = $this->getRequestParameter('section', sfConfig::get('app_tab_projects_browse')); $owner = $this->getRequestParameter('project_owner', 'null'); $title = $this->getRequestParameter('project_title', 'null'); $keywords = $this->getRequestParameter('project_keywords', 'null'); $school = $this->getRequestParameter('project_school', 'null'); $status = $this->getRequestParameter('project_status', 'null'); $department = $this->getRequestParameter('project_department', 'null'); $applications = $this->getRequestParameter('project_applications', 'null'); $c = new Criteria(); $this->uri_options = ''; if ($title != "null" && $title != '') { $this->logMessage('title not null, setting: [' . $title . ']'); $c->add(ProjectPeer::TITLE, "%" . $title . "%", Criteria::LIKE); $this->uri_options .= '&project_title=' . urlencode($title); } //URI: project_title=C&project_status=&project_department= //URI: project_title=C&project_status=project_department&project_department= if ($status != "null" && $status != '') { $this->logMessage('status not null, setting: [' . $status . ']'); $c->add(ProjectPeer::STATUS, $status); $this->uri_options .= '&project_status=' . urlencode($status); } if ($department != "null" && $department != '') { $this->logMessage('department not null, setting: [' . $department . ']'); $c->add(ProjectPeer::DEPARTMENT_ID, $department); $this->uri_options .= '&project_department=' . urlencode($department); } if ($applications != "null" && $applications != '') { $this->logMessage('applications not null, setting: [' . $applications . ']'); $c->add(ProjectPeer::APPLICATIONS, $applications); $this->uri_options .= '&project_applications=' . urlencode($applications); } if ($school != "null" && $school != '') { $this->logMessage('school not null, setting: [' . $school . ']'); $c->add(ProjectPeer::CAMPUS_ID, $school); $this->uri_options .= '&project_school=' . urlencode($school); } if ($owner != "null" && $owner != '') { $this->logMessage('owner not null, setting: [' . $owner . ']'); //$c->add(ProjectPeer::, "%".$title."%", Criteria::LIKE); //$this->uri_options .= '&project_school='.urlencode($school); } $this->uri_options .= '§ion=' . $this->section; //$this->projects = ProjectPeer::doSelect(new Criteria()); $this->logMessage('get pager....'); if ($this->section == sfConfig::get('app_tab_projects_browse')) { $this->logMessage('browse tab...'); $this->projects = ProjectPeer::retrievePager($c, $this->getRequestParameter('page', 1), $this->getRequestParameter('max', sfConfig::get('app_pager_project_max'))); } if ($this->section == sfConfig::get('app_tab_projects_myprojects')) { $this->logMessage('browse tab...'); $this->projects = ProjectPeer::retrievePagerByUser($this->getUser()->getID(), $this->getRequestParameter('page', 1), $this->getRequestParameter('max', sfConfig::get('app_pager_project_max'))); } if ($this->section == sfConfig::get('app_tab_projects_favorited')) { $this->logMessage('browse tab...'); $this->projects = ProjectPeer::retrievePagerByUserStarred($this->getUser()->getId(), $this->getRequestParameter('page', 1), $this->getRequestParameter('max', sfConfig::get('app_pager_project_max'))); } $this->logMessage('pager retrieved....'); $this->logMessage('uri: [' . $this->uri_options . ']'); $this->uri_options = str_replace('?&', '?', $this->uri_options); $this->logMessage('uri: [' . $this->uri_options . ']'); }