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