<?php
    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_entrada WHERE ent_id=$v_id");
    $row    = mysql_fetch_array($rs_sql);
    $rs_ip  = mysql_query("SELECT * FROM v_lista_entrada_itens WHERE aei_ent_id=$v_id");

    class PDF extends FPDF
    {
        public function Header()
        {
            global $entida;
            global $secret;
            global $row;
            $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', 11);
            $this->Cell(0, 8, 'Entrada - Nota fiscal N°: ' . $row['ent_nf'], 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 | Sistema de Gestão da Alimentação Escolar', 0, 0, 'R');
        }
    }

    //dados da entrada
    $pdf = new PDF();
    $pdf->AddPage('Portrait', 'A4');
    $pdf->SetFont('Arial', 'B', 9);
    $pdf->Cell(50, 5, 'ID', 0, 0, "L");
    $pdf->Cell(50, 5, 'N� contrato', 0, 0, "L");
    $pdf->Cell(50, 5, 'Programa', 0, 0, "L");
    $pdf->Cell(50, 5, 'N� ordem compra', 0, 1, "L");
    $pdf->SetFont('Arial', '', 7);
    $pdf->Cell(50, 5, $row['ent_id'], 0, 0, "L");
    $pdf->Cell(50, 5, utf8_decode($row['cpl_numproc_lic']), 0, 0, "L");
    $pdf->Cell(50, 5, utf8_decode($row['prg_programa']), 0, 0, "L");
    $pdf->Cell(50, 5, utf8_decode($row['odc_numordcomp']), 0, 1, "L");
    $pdf->Ln(1);
    $pdf->SetFont('Arial', 'B', 9);
    $pdf->Cell(50, 5, 'Fornecedor', 0, 0, "L");
    $pdf->Cell(50, 5, 'Data emissão', 0, 0, "L");
    $pdf->Cell(50, 5, 'Data entrada', 0, 0, "L");
    $pdf->Cell(50, 5, 'Valor', 0, 1, "L");
    $pdf->SetFont('Arial', '', 7);
    $pdf->Cell(50, 5, utf8_decode($row['pes_pessoa']), 0, 0, "L");
    $pdf->Cell(50, 5, $row['ent_nfdtemissao'], 0, 0, "L");
    $pdf->Cell(50, 5, $row['ent_data'], 0, 0, "L");
    $pdf->Cell(50, 5, 'R$ ' . number_format($row['total'], 2, ',', '.'), 0, 1, "L");
    $pdf->Ln(1);
    $pdf->SetFont('Arial', 'B', 9);
    $pdf->Cell(50, 5, 'Série', 0, 0, "L");
    $pdf->Cell(50, 5, 'Tipo', 0, 0, "L");
    $pdf->Cell(50, 5, 'Observações', 0, 1, "L");
    $pdf->SetFont('Arial', '', 7);
    $pdf->Cell(50, 5, utf8_decode($row['ent_nfserie']), 0, 0, "L");
    $pdf->Cell(50, 5, utf8_decode($row['ent_nftipo']), 0, 0, "L");
    $pdf->SetFillColor(255, 255, 255);
    $pdf->MultiCell(100, 3, $row['ent_obs'], 0, 1, "L");
    //itens da entrada
    $pdf->Ln(1);
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', 'B', 9);
    $pdf->Cell(190, 6, 'Itens da entrada', 0, 1, "C");
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', '', 7);
    $pdf->Cell(10, 5, 'ID', 0, 0, "L");
    $pdf->Cell(82, 5, "Produto", '', 0, 'L');
    $pdf->Cell(16, 5, "Und.", '', 0, 'L');
    $pdf->Cell(16, 5, "Qtd.", '', 0, 'R');
    $pdf->Cell(16, 5, "Vl.Unit.", '', 0, 'R');
    $pdf->Cell(20, 5, "Total", '', 0, 'R');
    $pdf->Cell(16, 5, "Lote", '', 0, 'C');
    $pdf->Cell(16, 5, "Validade", '', 1, 'L');
    $pdf->Cell(0, 1, "", "B", 1);
    $i = 0;
    while ($l = mysql_fetch_array($rs_ip)) {
        $pdf->SetFont('Arial', '', 7);
        $pdf->Cell(10, 5, utf8_decode($l['aei_id']), 0, 0, "L");
        $pdf->Cell(82, 5, utf8_decode($l['pro_produto']), 0, 0, "L");
        $pdf->Cell(16, 5, utf8_decode($l['und_desc']), 0, 0, "L");
        $pdf->Cell(16, 5, number_format($l['aei_pro_qtd'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(16, 5, number_format($l['aei_pro_vrunit'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(20, 5, number_format($l['total'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(16, 5, utf8_decode($l['aei_lote']), 0, 0, "C");
        $pdf->Cell(16, 5, utf8_decode($l['aei_dtvalidade']), 0, 1, "L");
        $i++;
    }
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', 'B', 8);
    $pdf->Cell(0, 5, 'Itens: ' . $i, 0, 1, "R");
    ob_clean();
    $pdf->Output('entrada.pdf', 'I');
    exit;