public function salvar(FluxoCaixa $obj)
{
$strSQL = "INSERT INTO FIN_LCA_LANCAMENTOS_CAIXA(";
$strSQL .= "CEN_ID, ";
$strSQL .= "COB_ID, ";
$strSQL .= "PES_ID, ";
$strSQL .= "FOR_ID, ";
$strSQL .= "FPG_ID, ";
$strSQL .= "PLA_ID, ";
$strSQL .= "LCA_DataMovimento, ";
$strSQL .= "LCA_Referencia, ";
$strSQL .= "LCA_Valor, ";
$strSQL .= "LCA_Observacao, ";
$strSQL .= "LCA_DataHoraCadastro, ";
$strSQL .= "USU_Cadastro_ID, ";
$strSQL .= "LCA_Descricao, ";
$strSQL .= "LCA_Tipo ";
$strSQL .= ")VALUES(";
$strSQL .= " " . $obj->getCentroCusto()->getId() . ", ";
$strSQL .= " " . $obj->getContaBancaria()->getId() . ", ";
if ($obj->getPessoa() == null) {
$strSQL .= " (NULL), ";
} elseif ($obj->getPessoa()->getId() == "") {
$strSQL .= " (NULL), ";
} else {
$strSQL .= " " . $obj->getPessoa()->getId() . ", ";
}
if ($obj->getFornecedor() == null) {
$strSQL .= " (NULL), ";
} elseif ($obj->getFornecedor()->getId() == "") {
$strSQL .= " (NULL), ";
} else {
$strSQL .= " " . $obj->getFornecedor()->getId() . ", ";
}
$strSQL .= " " . $obj->getFormaPagamento()->getId() . ", ";
$strSQL .= " " . $obj->getPlanoConta()->getId() . ", ";
$strSQL .= "'" . $obj->getData() . "', ";
$strSQL .= "'" . $obj->getReferencia() . "', ";
$strSQL .= " " . $obj->getValor() . ", ";
$strSQL .= "'" . $obj->getObservacao() . "', ";
$strSQL .= "'" . date("Y-m-d H:i:s") . "', ";
$strSQL .= " " . $_SESSION["USUARIO_ID"] . ", ";
$strSQL .= " '" . $obj->getHistorico() . "', ";
$strSQL .= " '" . $obj->getTipo() . "' ";
$strSQL .= ")";
return Db::getInstance()->executar($strSQL);
}
