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(); }