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); }