<?php
/**
 * Created by PhpStorm.
 * User: Wladimir
 * Date: 20/04/2017
 * Time: 20:58
 */
//ini_set('display_errors', 1);
//ini_set('display_startup_erros', 1);
//error_reporting(E_ALL);
$cod_orgao   = isset($_POST['codigo_orgao']) ? $_POST['codigo_orgao'] : "0";
$dao         = new notas_pagamentos();
$empenho     = new notas_empenhos();
$html        = "";
$data_inicio = 0;
$data_fim    = 0;
?>
<script src="./form/<?= $_GET['p'] ?>/<?= $_GET['p'] ?>.js"></script>
<div class="panel panel-success">
    <!-- Default panel contents -->
    <div class="panel-heading text-center"><b>PAGAMENTOS</b></div>
    <div class="panel-body">
        <div class="row text-right">
            <button class="btn btn-github" onclick="history.go(-1)"><i class="fa fa-reply"></i>&nbsp;VOLTAR
            </button>
            <?php
            if ($_POST) {
                ?>
                <button class="btn btn-github" type="submit" form="pdf"><i class="fa fa-print"></i>&nbsp;IMPRIMIR
                </button>
            <? } ?>
        </div>
        <br>
        <form action="" method="POST">
            <div class="row">
                <div class="col-md-3">
                    <label for="">ORGAOS</label><br>
                    <select name="codigo_orgao" class="selectpicker" data-live-search="true">
                        <option value="0">>>TODOS<<</option>
                        <?php
                        $orgaos = new orgaos();
                        $orgaos->SelectTodos();
                        ?>
                    </select>
                </div>
                <div class="col-md-4">
                    <label for="">negociante</label><br>
                    <select name="negociante" id="negociante" class="selectpicker" data-live-search="true">
                        <option value="0">>>TODOS<<</option>
                        <?php
                        $rows = $empenho->ObterPorTodosFornecedor();
                        foreach ($rows as $row) {
                            echo "<option value='" . $row->getNome_negociante() . "'>" . $row->getNome_negociante() . "</option>";
                        }
                        ?>
                    </select>
                </div>
                <div class="col-md-2">
                    <label for="data_inicio">INICIO</label>
                    <div class='input-group date' id='data_inicio'>
                        <input type='text' class="form-control" name="data_inicio"/>
                        <span class="input-group-addon">
                        <span class="glyphicon glyphicon-calendar"></span>
                    </span>
                    </div>
                </div>
                <div class="col-md-2">
                    <label for="data_fim">FIM</label>
                    <div class='input-group date' id='data_fim'>
                        <input type='text' class="form-control" name="data_fim"/>
                        <span class="input-group-addon">
                        <span class="glyphicon glyphicon-calendar"></span>
                    </span>
                    </div>
                </div>
                <div class="col-md-1 text-left">
                    <button class="btn btn-app" type="submit"><i class="fa fa-search"></i>&nbsp;BUSCAR
                    </button>
                </div>
            </div>
        </form>
        <?php
        $data = new Data();
        if ($_POST){
        $data_inicio = $_POST['data_inicio'];
        $data_inicio = $data->setBanco($data_inicio);
        $data_fim    = $_POST['data_fim'];
        $data_fim    = $data->setBanco($data_fim);
        $fornercedor = $_POST['negociante'];

        ?>
        <div class="">
            <?php
            $res           = $dao->ObterPorRelatorio($_SESSION['municipio'], $cod_orgao, $data_inicio, $data_fim, $fornercedor);
            $form_elemento = new formate_elemento();
            $orgao         = new orgaos();

            $html = "<table class='table table-striped table-hover bpmTopicC' cellspacing='0' width='100%'>";
            $html .= "<thead>";
            $html .= "<tr class='headerrow'>";
            $html .= "<th>ELEMENTO</th>";
            $html .= "<th>ORGAO</th>";
            $html .= "<th>NEGOCIANTE</th>";
            $html .= "<th>DATA EMPENHO</th>";
            $html .= "<th>EMPENHO</th>";
            $html .= "<th>VALOR EMPENHO</th>";
            $html .= "<th>CAIXA</th>";
            $html .= "<th>DATA PAGAMENTO</th>";
            $html .= "<th>VALOR PAGAMENTO</th>";
            $html .= "</tr>";
            $html .= "</thead>";
            $html .= "<tbody>";

            $valor_total = 0;
            foreach ($res as $r) {
                $html        .= "<tr >";
                $html        .= "<td >" . $r->getCodigo_municipio() . "</td>";
                $html        .= "<td >" . $orgao->ObterPorExercioMunicipioOrgaoBE($_SESSION['exercicio'],$_SESSION['municipio'],$r->getCodigo_orgao())->getNome_orgao() . "</td>";
                $html        .= "<td >" . $r->getNome_pagador() . "</td>";
                $html        .= "<td >" . date('d/m/Y', strtotime($r->getData_emissao_empenho())) . "</td>";
                $html        .= "<td >" . $r->getNumero_empenho() . "</td>";
                $html        .= "<td >" . number_format($r->getNumero_sub_empenho(), 2, ',', '.') . "</td>";
                $html        .= "<td >" . $r->getNu_documento_caixa() . "</td>";
                $html        .= "<td >" . date('d/m/Y', strtotime($r->getData_nota_pagamento())) . "</td>";
                $html        .= "<td >" . number_format($r->getValor_nota_pagamento(), 2, ',', '.') . "</td>";
                $html        .= "</tr>";
                $valor_total += $r->getValor_nota_pagamento();
            }
            $html .= "<tr >";
            $html .= "<td align='right' colspan='8' ><b>Valor Pagamentos Total</td>";
            $html .= "<td colspan='' ><b>" . number_format($valor_total, 2, ',', '.') . "</td>";
            $html .= "</tr>";
            $html .= "</tbody>";
            $html .= "</table>";
            echo $html;
            } ?>
        </div>
    </div>
</div>
<form target="_blank" id="pdf" method="post" action="form/print_pdf/pdf.php">
    <input type="hidden" name="pdf" value="<?= $html ?>">
    <input type="hidden" name="data_i" value="<?= $data_inicio ?>">
    <input type="hidden" name="data_f" value="<?= $data_fim ?>">
    <input type="hidden" name="codigo_orgao" value="<?= $cod_orgao ?>">
    <input type="hidden" name="codigo_municipio" value="<?= $_SESSION['municipio'] ?>">
    <input type="hidden" name="nome_relatorio" value="PAGAMENTOS POR PERIODO">
</form>