function methodDefault()
{
$iPage = (int) $this->getRequest("page", 1);
$iRecordPerPage = 20;
$aKeys = $this->getDBQuery("RepositoryListValuesTable")->select("distinct(listkey) as listkey")->orderBy("listkey asc")->execute();
$this->oView->addVar("aKeys", $aKeys);
$oQuery = $this->getDBQuery("RepositoryListValuesTable")->limit($iRecordPerPage)->offset(($iPage - 1) * $iRecordPerPage)->orderBy("listkey asc, weight asc, listvalue asc");
$oCountQuery = $this->getDBQuery("RepositoryListValuesTable");
$sFilter = $this->getFilter();
if (!empty($sFilter)) {
$oQuery->where("listkey=?", $sFilter);
$oCountQuery->where("listkey=?", $sFilter);
}
$this->oView->addVar("filter_listkey", $sFilter);
$aList = $oQuery->execute();
//for more condition, add where clause
$iCount = FlexiModelUtil::getRecordCount($oCountQuery);
//var_dump($iCount);
$this->oView->addPaging($iCount, $iRecordPerPage, $iPage, array(), null);
$this->oView->addVar("aList", $aList->toArray());
if (FlexiConfig::$sFramework == "modx" || FlexiConfig::$sFramework == "modx2") {
$sForm = $this->renderMarkup($this->loadForm());
$this->oView->addVar("form", $sForm);
}
return true;
}
