<script src="./form/<?= $_GET['p'] ?>/<?= $_GET['p'] ?>.js"></script>
<?php

/**
 * Created by PhpStorm.
 * User: Wladimir
 * Date: 13/07/2016
 * Time: 13:37
 */

$dao = new notas_empenhos();

if ($_POST) {
    $negociante = isset($_POST['negociante']) ? $_POST['negociante'] : "0";
} else {
    $negociante = isset($_GET['negociante']) ? $_GET['negociante'] : "0";
}
?>

<div class="panel panel-success">
    <!-- Default panel contents -->
    <div class="panel-heading text-center"><b>NOTAS DE PAGAMETNOS</b></div>
    <div class="panel-body">
        <div class="row text-right">
            <button class="btn btn-app" onclick="history.go(-1)"><i class="fa fa-reply"></i>&nbsp;VOLTAR
            </button>
        </div>
        <form action="" method="POST">
            <div class="row text-left">
                <div class="col-md-4">
                    <select name="negociante" class="selectpicker" data-live-search="true">
                        <option value="">SELECIONE UM FORNECEDOR</option>
                        <?php
                        $rows = $dao->ObterPorTodosFornecedor();
                        foreach ($rows as $row) {
                            echo "<option value='" . $row->getNome_negociante() . "'>" . $row->getNome_negociante() . "</option>";
                        }
                        ?>
                    </select>
                </div>
                <div class=" text-left col-md-6">
                    <button class="btn btn-app" type="submit"><i class="fa fa-search"></i>&nbsp;BUSCAR</button>
                </div>
            </div>
        </form>
        <?php
        //   $html .=  $cod_orgao;
        if ($negociante) {
            ?>
            <div class="">
                <?php
                $res           = $dao->ObterPorFornecedor($negociante);
                $form_elemento = new formate_elemento();
                $orgao         = new orgaos();

                $html = "<table class='table table-striped table-hover' cellspacing='0' width='100%'>";
                $html .= "<thead>";
                $html .= "<th>orgao</th>";
                $html .= "<th>data empenho</th>";
                $html .= "<th>numero empenho</th>";
                $html .= "<th width='30%' >descricao empenho</th>";
                $html .= "<th>elemento despesa</th>";
                $html .= "<th>valor empenhado</th>";
                $html .= "<th>numero licitacao</th>";
                $html .= "<th>valor liquidado</th>";
                $html .= "<th>data liquidacao</th>";
                $html .= "<th>data pagamento</th>";
                $html .= "<th>valor pagamento</th>";
                $html .= "</thead>";
                $html .= "<tbody>";

                $i                 = 1;
                $valor_total_liqui = 0;
                foreach ($res as $r) {


                    $html .= "<tr >";
                    $html .= "<td >{$orgao->ObterPorPK($r->getCodigo_orgao())->getNome_orgao()}</td>";
                    $html .= "<td >{$r->getData_emissao_empenho()}</td>";
                    $html .= "<td >{$r->getNumero_empenho()}</td>";
                    $html .= "<td >{$r->getDescricao_empenho()}</td>";
                    $html .= "<td >{$r->getValor_empenhado()}</td>";
                    $html .= "<td >{$r->getCodigo_elemento_despesa()}</td>";
                    $html .= "<td >{$r->getNumero_licitacao()}</td>";
                    $html .= "<td >" . number_format($r->getNome_municipio_negociante(), 2, ',', '.') . "</td>";
                    $html .= "<td >{$r->getCodigo_uf()}</td>";
                    $html .= "<td >{$r->getTipo_fonte()}</td>";
                    $html .= "<td >{$r->getCodigo_fonte()}</td>";
                    $html .= "</tr>";

                    $valor_total_liqui = $valor_total_liqui + $r->getNome_municipio_negociante();
                    $i++;
                }
                $html .= "<tr >";
                $html .= "<td colspan='7' >Valor Liquida Total</td>";
                $html .= "<td colspan='' >" . number_format($valor_total_liqui, 2, ',', '.') . "</td>";
                $html .= "</tr>";
                $html .= "</tbody>";
                $html .= "</table>";
                echo $html;
                ?>
            </div>
        <? } ?>
    </div>
</div>