public function execute($request) { $queryParams = $this->getUser()->getLocalPrefs()->syncRequestParams('detailedflashcardlist', array(uiSelectPager::QUERY_ROWSPERPAGE => 20, uiSelectTable::QUERY_SORTCOLUMN => 'framenum', uiSelectTable::QUERY_SORTORDER => 0)); $this->pager = new uiSelectPager(array('select' => ReviewsPeer::getDetailedFlashcardList($this->getUser()->getUserId()), 'internal_uri' => 'review/flashcardlist', 'query_params' => $queryParams, 'max_per_page' => $queryParams[uiSelectPager::QUERY_ROWSPERPAGE], 'page' => $request->getParameter(uiSelectPager::QUERY_PAGENUM, 1))); $this->pager->init(); $this->table = new uiSelectTable(new FlashcardListBinding(), $this->pager->getSelect(), $request->getParameterHolder()); $this->table->configure(array('sortColumn' => $queryParams[uiSelectTable::QUERY_SORTCOLUMN], 'sortOrder' => $queryParams[uiSelectTable::QUERY_SORTORDER])); }