public function RealizaUpdate($CampoCondicao, $Condicao, $CampoAtualizado, $Tabela, $Valor, $Trans = FALSE) {
$Sql = "UPDATE $Tabela SET $CampoAtualizado = $Valor WHERE $CampoCondicao = $Condicao";
if ($Trans) {
return parent::execute_query_trans($Trans, $Sql);
} else {
return parent::execute_query($Sql);
}
}
public function __construct() {
//Singleton
if (!isset(self::$instanciaClasse)) {
self::$instanciaClasse = $this->Conecta();
} else {
return self::$instanciaClasse;
}
}
public function TotalizaPendenciasCaixa() {
$result = parent::execute_query("SELECT
COUNT(DISTINCT CAST(DATA AS DATE)) AS DATA
FROM CAIXA
WHERE FORMA_PAGAMENTO != ''
AND CREDITO > 0
AND TIPO = 'C'
AND F_CONSOLIDACAO_DIA_ID IS NULL");
$linha = parent::criaObjetoConsulta($result);
return ($linha->DATA);
}
