/** * Verifica que el correo electronico este registrado y activado. * Genera un codigo unico para confirmar por correo electronico el cambio de password * @param string $email * @throws Exception * @return string $changePasswordCode */ public function updateChangePasswordCodeforValidUserActive($email) { //* $response = array(); $connection = Yii::app()->db; $sql = Querys::SEARCH_USER_ACTIVATED; $command = $connection->createCommand($sql); $index = 0; $command->bindValue(++$index, $email, PDO::PARAM_STR); $data = $command->query(); foreach ($data as $row) { $changePasswordCode = CodeGenerator::generateChangePasswordCode($email, $row['idusers'], $row['name']); $command->update('users', array('change_password_code' => $changePasswordCode), 'idusers=:id', array(':id' => $row['idusers'])); return $changePasswordCode; } $connection->active = false; throw new Exception(Constants::ERROR_DATA_FORM); }