public function criteriaCommands()
{
$filter = $this->data;
$filter->login = '******';
$usuario = new models\Usuario();
// Join automatico e expressoes
$criteria = $usuario->criteriaCommand01()->asQuery()->getResult();
// Join automatico e parametro
$criteria = $usuario->criteriaCommand02($filter)->asQuery()->getResult();
// Join forçado
$criteria = $usuario->criteriaCommand03($filter)->asQuery()->getResult();
// Alias com join automatico
$criteria = $usuario->criteriaCommand04($filter)->asQuery()->getResult();
// Alias com join forçado
$criteria = $usuario->criteriaCommand05($filter)->asQuery()->getResult();
// Parâmetros
$criteria = $usuario->criteriaCommand06($filter)->asQuery('admin', 'F%')->getResult();
$criteria = $usuario->criteriaCommand06($filter)->asQuery(array('admin', 'F%'))->getResult();
// Clásula distinct
$criteria = $usuario->criteriaCommand07()->asQuery()->getResult();
// Associação Many-to-many
$criteria = $usuario->criteriaCommand08()->asQuery()->getResult();
// Group By e Agregações
$criteria = $usuario->criteriaCommand09()->asQuery()->getResult();
// Operador IN
$criteria = $usuario->criteriaCommand10()->asQuery()->getResult();
// Auto-associação
$criteria = $usuario->criteriaCommand11()->asQuery()->getResult();
// Subqueries e parâmetros
$criteria = $usuario->criteriaCommand12()->asQuery()->getResult();
// Subqueries com referência a query externa
//$criteria = $usuario->criteriaCommand13()->asQuery()->getResult();
// outer join
$criteria = $usuario->criteriaCommand14()->asQuery()->getResult();
// herança
$aluno = new models\Aluno();
$criteria = $aluno->criteriaCommand01()->asQuery()->getResult();
$criteria = $aluno->criteriaCommand02()->asQuery()->getResult();
// by-pass a SuperClasse
$criteria = $usuario->criteriaCommand15()->asQuery()->getResult();
// Condição complexa
$criteria = $usuario->criteriaCommand16()->asQuery()->getResult();
$this->render();
}
