/**
* Adds an object to the instance pool.
*
* Propel keeps cached copies of objects in an instance pool when they are retrieved
* from the database. In some cases -- especially when you override doSelect*()
* methods in your stub classes -- you may need to explicitly add objects
* to the cache in order to ensure that the same objects are always returned by doSelect*()
* and retrieveByPK*() calls.
*
* @param Professor $value A Professor object.
* @param string $key (optional) key to use for instance map (for performance boost if key was already calculated externally).
*/
public static function addInstanceToPool(Professor $obj, $key = null)
{
if (Propel::isInstancePoolingEnabled()) {
if ($key === null) {
$key = (string) $obj->getId();
}
// if key === null
self::$instances[$key] = $obj;
}
}
public function gravaDadosProfessor(Professor $professor){
$banco = $this->getBancoDados();
$query = " SELECT count(*) AS cont
FROM tbl_professor
WHERE upper(login) = upper(".$professor->Xlogin.") ";
if (strlen($professor->getId())>0){
$query .= " AND professor <> ".$professor->getId();
}
$retorno = $banco->executaSQL($query);
$linha = $banco->fetchArray($retorno);
if ($linha['cont']>0){
throw new Exception("O login escolhido ".$professor->Xlogin." já existe. Tente outro diferente.");
}
if (strlen($professor->getId())>0) {
$query = " UPDATE tbl_professor SET
nome = $professor->Xnome,
email = $professor->Xemail,
login = $professor->Xlogin,
senha = $professor->Xsenha,
ativo = $professor->Xativo,
endereco = $professor->Xendereco,
numero = $professor->Xnumero,
complemento = $professor->Xcomplemento,
bairro = $professor->Xbairro,
cidade = $professor->Xcidade,
estado = $professor->Xestado,
cep = $professor->Xcep,
pais = $professor->Xpais
WHERE professor = ".$professor->getId();
}else{
$query = "INSERT INTO tbl_professor (
nome,
email,
login,
senha,
ativo,
nivel_ensino,
area_atuacao,
endereco,
numero,
complemento,
bairro,
cidade,
estado,
cep,
pais
) VALUES (
$professor->Xnome,
$professor->Xemail,
$professor->Xlogin,
$professor->Xsenha,
$professor->Xativo,
$professor->Xnivel_ensino,
$professor->Xarea_atuacao,
$professor->Xendereco,
$professor->Xnumero,
$professor->Xcomplemento,
$professor->Xbairro,
$professor->Xcidade,
$professor->Xestado,
$professor->Xcep,
$professor->Xpais
)";
}
if(!$banco->updateSQL($query)) {
throw new Exception("Erro ao atualizar / inserir Professor. ($query) ");
}
if (strlen($professor->getId())==0){
$professor->setId($banco->insert_id());
$query = "INSERT INTO tbl_instituicao_professor (
instituicao,
professor
) VALUES (
".$professor->_login_instituicao.",
".$professor->getId()."
)";
if(!$banco->updateSQL($query)) {
throw new Exception("Erro inserir relacionmaneto entre professor / disciplina ($query) ");
}
}
}
<!DOCTYPE html>
<?php
require "Professor.class.php";
$henrique = new Professor("1", "Henrique");
?>
<html>
<head>
<meta charset="UTF-8">
<meta name="description" content="">
<meta name="keywords" content="">
<meta name="author" content="Rui Henrique Leite de Oliveira">
<meta name="robots" content="index, follow">
<link rel="stylesheet" type="text/css" href="estilos.css">
<title>PHP OO 0.1</title>
</head>
<body>
Este é o tesde de objeto php.
Vamos ver as informações da pessoa:
<?php
echo "<br />Id: " . $henrique->getId();
echo "<br />Nome: " . $henrique->getNome();
?>
</body>
</html>
/**
* Declares an association between this object and a Professor object.
*
* @param Professor $v
* @return Gradeunit The current object (for fluent API support)
* @throws PropelException
*/
public function setProfessor(Professor $v = null)
{
if ($v === null) {
$this->setProfessorId(NULL);
} else {
$this->setProfessorId($v->getId());
}
$this->aProfessor = $v;
// Add binding for other direction of this n:n relationship.
// If this object has already been added to the Professor object, it will not be re-added.
if ($v !== null) {
$v->addGradeunit($this);
}
return $this;
}
function logAcessoProfessor(Instituicao $instituicao,Professor $professor){
$logDAO = new LogDAO();
$logDAO->setBancoDados($this->banco);
$logDAO->gravarLog('PROFESSOR',$professor->getId(),$instituicao->getId());
}
