public function QuantidadeLinhasConsulta($Consulta) {
$select = "SELECT COUNT(*) AS TOTAL
FROM
(
$Consulta
)";
$result = parent::execute_query($select);
if ($result) {
$linha = parent::criaObjetoConsulta($result);
return trim($linha->TOTAL);
} else {
return false;
}
}
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);
}
