<?php
    /**
     * Created by PhpStorm.
     * User: RalpAlves
     * Date: 13/01/2016
     * Time: 13:25
     */
    include_once("../../includes/conexao.php");
    include "../../fpdf/fpdf.php";
    session_start();
    $entida  = $_SESSION['prefeitura'];
    $secret  = $_SESSION['secretaria'];
    $v_id    = $_GET['id'];
    $ano     = date('Y');
    $rs_sql  = mysql_query("select * from v_lista_licitacao where cpl_id = $v_id");
    $resulta = mysql_fetch_array($rs_sql);
    $rs_ite  = mysql_query("SELECT * from v_lista_licitacao_forn where plf_cpl_id = $v_id");

    class PDF extends FPDF
    {
        public function Header()
        {
            global $entida;
            global $secret;
            global $resulta;
            $this->AliasNbPages();
            $this->image('../../logo/logo.jpg', 10, 10, 40);
            $this->SetFont('Arial', 'B', 12);
            $this->Cell(0, 5, $entida, 0, 1, "C");
            $this->Cell(0, 5, $secret, 0, 1, "C");
            $this->SetFont('Arial', 'B', 8);
            $this->Cell(0, 4, 'p�gina: ' . $this->PageNo() . '/{nb}', 0, 1, 'R');
            $this->SetFont('Arial', 'B', 12);
            $this->Cell(0, 5, 'Processo Licitat�rio N�: ' . $resulta['cpl_numproc_lic'], 0, 1, "C");
            $this->Ln(3);
            $this->Cell(0, 1, "", "B", 1);
        }

        function Footer()
        {
            $this->SetY(-17);
            $this->Cell(0, 4, "", "B", 1);
            $this->SetFont('Arial', '', 8);
            $this->Cell(0, 4, 'Emiss�o: ' . date('d/m/Y'), 0, 0, "L");
            $this->Cell(0, 4, 'SGAE | Gest�o da Merenda Escolar', 0, 0, 'R');
        }
    }

    $pdf = new PDF();
    $pdf->AddPage('Portrait', 'A4');
    $pdf->Ln(1);
    $pdf->SetFont('Arial', '', 10);
    $pdf->Cell(20, 5, 'Exerc�cio: ', 0, 0, "L");
    $pdf->Cell(0, 5, $resulta['cpl_exerc'], 0, 1);
    $pdf->Cell(20, 5, '�rg�o: ', 0, 0, "L");
    $pdf->Cell(0, 5, utf8_decode($resulta['org_nome_orgao']), 0, 1);
    $pdf->Cell(20, 5, 'Und. Or�: ', 0, 0, "L");
    $pdf->Cell(0, 5, utf8_decode($resulta['uo_nome']), 0, 1);
    $pdf->Cell(20, 5, 'Data Lic.: ', 0, 0, "L");
    $pdf->Cell(0, 5, utf8_decode($resulta['cpl_dtlicit']), 0, 1);
    $pdf->Cell(20, 5, 'Valor Total: ', 0, 0, "L");
    $pdf->Cell(0, 5, 'R$ ' . number_format($resulta['cpl_vrtotal'], 2, ',', '.'), 0, 1);
    $pdf->Cell(20, 5, 'Tipo Lic.: ', 0, 0, "L");
    $sit = $resulta['cpl_agrfam']=='2' ? 'N�O' : 'SIM';
    $pdf->Cell(0, 5, utf8_decode($resulta['tpl_tipolicitacao'] . ' | Modalidade: ') . $resulta['mod_desc'] . ' | Ag.Familiar: ' . $sit, 0, 1);
    $pdf->Cell(0, 1, "", "B", 1);
    //Fornecedor
    while ($row = mysql_fetch_array($rs_ite)) {
        $pdf->SetFont('Arial', 'B', 9);
        $pdf->Cell(130, 5, utf8_decode('Fornecedor'));
        $pdf->Cell(30, 5, utf8_decode('Contrato'), 0, 0, "L");
        $pdf->Cell(30, 5, utf8_decode('Valor Contrato'), 0, 1, "R");
        $pdf->Cell(0, 1, "", "B", 1);
        $pdf->SetFont('Arial', 'B', 8);
        $pdf->Cell(130, 5, utf8_decode($row['pes_pessoa']) . '-' . $row['plf_forn_id'], 0, 0, "L");
        $pdf->Cell(30, 5, utf8_decode($row['plf_numcontrato']), 0, 0, "L");
        $pdf->Cell(30, 5, utf8_decode(number_format($row['plf_valor_cont'], 2, ',', '.')), 0, 1, "R");
        //Itens do fornecedor
        $pdf->Cell(100, 5, 'Item ', 0, 0, "L");
        $pdf->Cell(12, 5, 'Unidade ', 0, 0, "C");
        $pdf->Cell(25, 5, 'Quantidade ', 0, 0, "R");
        $pdf->Cell(25, 5, 'V.Unit�rio ', 0, 0, "R");
        $pdf->Cell(28, 5, 'Total ', 0, 1, "R");
        $pdf->Cell(0, 1, "", "B", 1);
        $id_for = $row['plf_forn_id'];
        $rs_if  = mysql_query("select * from v_lista_licitacao_forn_item where pli_plf_id = $id_for");
        $i      = 0;
        while ($line = mysql_fetch_array($rs_if)) {
            $pdf->SetFont('Arial', '', 7);
            $pdf->Cell(100, 5, utf8_decode($line['pro_produto']), 0, 0, "L");
            $pdf->Cell(12, 5, utf8_decode($line['und_desc']), 0, 0, "C");
            $pdf->Cell(25, 5, utf8_decode(number_format($line['pli_pro_qtd'], 0, ',', '.')), 0, 0, "R");
            $pdf->Cell(25, 5, utf8_decode(number_format($line['pli_pro_vrunit'], 2, ',', '.')), 0, 0, "R");
            $pdf->Cell(28, 5, utf8_decode(number_format($line['pli_pro_total'], 2, ',', '.')), 0, 1, "R");
            $i++;
        }
        $pdf->SetFont('Arial', '', 8);
        $pdf->Cell(0, 1, "", "B", 1);
        $pdf->Cell(0, 5, 'Itens do fornecedor ' . utf8_decode($row['pes_pessoa']) . ': ' . $i, 0, 1, "R");
        $pdf->Cell(0, 1, "", "B", 1);
    }
    $pdf->SetFont('Arial', 'B', 8);
    $pdf->Cell(0, 5, utf8_decode('Fornecedores: ') . mysql_num_rows($rs_ite) . ' | Total da licita��o R$ ' . number_format($resulta['cpl_vrtotal'], 2, ',', '.'), 0, 1, "C");
    ob_clean();
    $pdf->Output('Processo licitatorio: ' . $resulta['cpl_numproc_lic'] . '.pdf', 'I');
    exit;