<!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);
?>
<title></title>
</head>
