if (!file_exists($GLOBALS['dirLibServer'] . 'dkLibServer.php')) {
echo "não encontrou arquivo de biblioteca";
}
include $GLOBALS['dirLibServer'] . 'dkLibServer.php';
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<meta charset="utf-8" />
<?php
$dkphp = new dkLibServer();
$dkphp->header();
$dkphp->setdbType("oracle");
$dkphp->setConnection();
?>
<title></title>
</head>
<body>
<?php
//Pagar
$nrcontrato = array("attribute" => array("id" => "nrcontrato", "name" => "nrcontrato", "value" => "1", "type" => "text", "table_field" => "nrcontrato", "table" => "pagar"));
$nrpagar = array("attribute" => array("class" => "form-control", "name" => "nrpagar", "id" => "nrpagar", "value" => "", "type" => "number", "table_field" => "nrpagar", "table" => array("pagar", "pagar_parcela")), "label_text" => "Numero Pagar");
$nrfornecedor = array("attribute" => array("class" => "form-control", "name" => "nrfornecedor", "id" => "nrfornecedor", "value" => "", "type" => "number", "table_field" => "nrfornecedor", "table" => "pagar"), "label_text" => "Numero do Fornecedor");
$txobservacao = array("attribute" => array("class" => "form-control", "name" => "txobservacao", "id" => "txobservacao", "type" => "text", "value" => "", "table_field" => "txobservacao", "table" => "pagar"), "label_text" => "Taxa de Observacao");
include_once '../controller/dkLib.php';
if (!file_exists($GLOBALS['dirLibServer'] . 'dkLibServer.php')) {
echo "não encontrou arquivo de biblioteca: " . $GLOBALS['dirLibServer'];
}
include $GLOBALS['dirLibServer'] . 'dkLibServer.php';
?>
<!DOCTYPE HTML>
<html lang="en">
<head>
<?php
$dkphp = new dkLibServer();
$dkphp->header();
$dkphp->setdbType("ORACLE");
$dkphp->setConnection();
//Criação do js
$tableFName = $dkphp->generateFileName("table");
$javaScript = array("name" => "geraFluxo", "result" => "resultadoPesquisa", "component" => array("jsdtinicio" => array("id" => "dtinicio", "type" => "date"), "dtfim" => array("id" => "dtfim", "type" => "date")));
$dkphp->generateJavaScript($javaScript, $tableFName);
$dkphp->clearJSCode();
$dkphp->setQueryType("SEARCH");
$sql = 'SELECT * FROM table(dkfinanceiro.fluxo_det( :dtinicio , :dtfim )) ';
$sql = "select a.nrorigem,\n a.nrparcela,\n a.txfluxo,\n a.dtfluxo,\n to_char(a.vlreceber,'9,999,990.00') vlreceber,\n to_char(a.vlpagar,'9,999,990.00') vlpagar,\n to_char(a.vlsaldo,'9,999,990.00') vlsaldo,\n a.situacao\n from table(dkfinanceiro.fluxo_det(:dtinicio,:dtfim)) a";
$sql = '"' . $sql . '"';
$dkphp->setQuery($sql);
$dkphp->setQueryParam(array(":dtinicio", ":dtfim"));
$table = array("id" => "txfluxo", "div" => array("class='matter'", "class='container' ", "class='row' ", "class='col-md-12'", "class='widget wgreen'", "class='widget-head'", "class='clearfix'", "class='page-tables'", "class='widget-content'", "class='padd'", "class='table-responsive'"), "class" => "table-striped table-bordered table-hover cellpadding='0' cellspacing='0' border='0' width='100%'", "header" => array("Origem", "Parc.", "Data", "Descr.", "Receber", "Pagar", "SAldo", "Situação"), "header-coluna-style" => array("Receber" => " align='right' ", "vlpagar" => "align='right'"), "coluna" => array("nrorigem", "nrparcela", "dtfluxo", "txfluxo", "vlreceber", "vlpagar", "vlsaldo", "situacao"), "coluna-style" => array("vlreceber" => " align='right'", "vlpagar" => "align='right'", "vlsaldo" => "align='right'"));
$dkphp->generateTable($table);
?>