public function alterar(Contribuicao $obj)
{
$intIdLote = "(NULL)";
if ($obj->getLote()->getId() > 0) {
$intIdLote = "'" . $obj->getLote()->getId() . "'";
}
$strSQL = "UPDATE FIN_CTB_CONTRIBUICOES SET ";
$strSQL .= "CEN_ID=" . $obj->getCentroCusto()->getId() . ", ";
$strSQL .= "COB_ID=" . $obj->getContaBancaria()->getId() . ", ";
if ($obj->getPessoa() == null) {
$strSQL .= "PES_ID=(NULL), ";
} elseif ($obj->getPessoa()->getId() == "") {
$strSQL .= "PES_ID=(NULL), ";
} else {
$strSQL .= "PES_ID=" . $obj->getPessoa()->getId() . ", ";
}
$strSQL .= "FPG_ID=" . $obj->getFormaPagamento()->getId() . ", ";
$strSQL .= "LOT_ID=" . $intIdLote . ", ";
$strSQL .= "CTB_DataContribuicao='" . $obj->getData() . "', ";
$strSQL .= "CTB_Referencia='" . $obj->getReferencia() . "', ";
$strSQL .= "CTB_Valor=" . $obj->getValor() . ", ";
$strSQL .= "CTB_Observacao='" . $obj->getObservacao() . "', ";
$strSQL .= "USU_Alteracao_ID=" . $_SESSION["USUARIO_ID"] . ", ";
$strSQL .= "CTB_DataHoraAlteracao = '" . date("Y-m-d H:i:s") . "' ";
$strSQL .= "WHERE CTB_ID=" . $obj->getId() . " ";
return Db::getInstance()->executar($strSQL);
}
