public function criteriaMethods()
{
$filter = new StdClass();
$filter->login = '******';
// Método Estático (sem instanciar o Modelo)
$result = models\Usuario::staticListAll()->asQuery()->getResult();
$usuario = new models\Usuario();
// Join automatico e expressoes
$result = $usuario->criteriaMethod01()->asQuery()->getResult();
// Join automatico e parametro
$result = $usuario->criteriaMethod02($filter)->asQuery()->getResult();
// Join forçado
$result = $usuario->criteriaMethod03($filter)->asQuery()->getResult();
// Alias com join automatico
$result = $usuario->criteriaMethod04($filter)->asQuery()->getResult();
// Alias com join forçado
$result = $usuario->criteriaMethod05($filter)->asQuery()->getResult();
// Parâmetros
$result = $usuario->criteriaMethod06($filter)->asQuery('admin', 'F%')->getResult();
$result = $usuario->criteriaMethod06($filter)->asQuery(array('admin', 'F%'))->getResult();
// Clásula distinct
$result = $usuario->criteriaMethod07()->asQuery()->getResult();
// Associação Many-to-many
$result = $usuario->criteriaMethod08()->asQuery()->getResult();
// Group By e Agregações
$result = $usuario->criteriaMethod09()->asQuery()->getResult();
// Operador IN
$result = $usuario->criteriaMethod10()->asQuery()->getResult();
// Auto-associação
$result = $usuario->criteriaMethod11()->asQuery()->getResult();
// Subqueries e parâmetros
$result = $usuario->criteriaMethod12()->asQuery()->getResult();
// Subqueries com referência a query externa
$result = $usuario->criteriaMethod13()->asQuery()->getResult();
// Outer join
$result = $usuario->criteriaMethod14()->asQuery()->getResult();
// herança
$aluno = new models\Aluno();
$result = $aluno->criteriaMethod01()->asQuery()->getResult();
$result = $aluno->criteriaMethod02()->asQuery()->getResult();
$result = $aluno->criteriaMethod03()->asQuery()->getResult();
// by-pass a SuperClasse
$result = $usuario->criteriaMethod15()->asQuery()->getResult();
// Condição complexa
$result = $usuario->criteriaMethod16()->asQuery()->getResult();
// Parâmetros nomeados (com array)
$result = $usuario->criteriaMethod17($filter)->asQuery()->getResult();
// Parâmetros nomeados (com objetos)
$result = $usuario->criteriaMethod18($filter)->asQuery()->getResult();
// Table criteria - criteria usado na clausla FROM
$result = $usuario->criteriaMethod19($filter)->asQuery()->getResult();
$this->render();
}
