<?php
    /**
     * Created by PhpStorm.
     * User: RalpAlves
     * Date: 13/01/2016
     * Time: 10:11
     */
    include_once("../../includes/conexao.php");
    include "../../fpdf/fpdf.php";

    $v_id    = $_GET['id'];
    $rs_ent  = mysql_query("select * from entidade");
    $rs_res  = mysql_fetch_array($rs_ent);
    $rs_sql  = mysql_query("SELECT * FROM v_lista_ordem_compra where odc_id=$v_id");
    $resulta = mysql_fetch_array($rs_sql);
    $id_prg = $resulta['prg_id'];
    $rs_ite  = mysql_query("SELECT * FROM v_lista_ordem_compra_itens where oci_odc_id=$v_id and oci_prg_id=$id_prg ORDER BY pro_produto");

    $pdf = new FPDF('P', 'cm', 'A4');
    $pdf = new FPDF();
    $pdf->Open();
    $pdf->SetTitle("Remessa de produtos");
    //HEADER
    $pdf->AddPage();
    $pdf->image('../../logo/logo.jpg', 10, 10, 40);
    $pdf->SetFont('Arial', 'B', 12);
    $pdf->Cell(0, 5, $rs_res['ent_entidade'], 0, 1, "C");
    $pdf->Cell(0, 5, utf8_decode('Secretaria Municipal de Educação'), 0, 1, "C");
    $pdf->Cell(0, 5, utf8_decode('Ordem de compra nº: ') . $resulta['odc_numordcomp'], 0, 1, "C");
    //
    $pdf->Ln(6);
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', '', 10);
    $pdf->Cell(25, 5, utf8_decode('Data: '));
    $pdf->Cell(0, 5, $resulta['odc_data'], 0, 1);
    $pdf->Cell(25, 4, utf8_decode('U.G.: '));
    $pdf->Cell(0, 4, $resulta['uo_nome'], 0, 1);
    $pdf->Cell(25, 4, utf8_decode('Nº Licitação: '));
    $pdf->Cell(0, 4, $resulta['cpl_numproc_lic'], 0, 1);
    $pdf->Cell(25, 4, utf8_decode('Fornecedor: '));
    $pdf->Cell(0, 4, utf8_decode($resulta['pes_pessoa'] ), 0, 1);
    $pdf->Cell(25, 4, utf8_decode('Programa: '));
    $pdf->Cell(0, 4, utf8_decode($resulta['prg_programa'] ), 0, 1);
    $pdf->Cell(25, 4, utf8_decode('Período: '));
    $pdf->Cell(0, 4, $resulta['odc_dtinic'] . ' a ' . $resulta['odc_dtfim'], 0, 1);
    $pdf->Cell(25, 4, utf8_decode('Observação: '));
    $pdf->Cell(0, 4, $resulta['odc_observacao'], 0, 1);
    $pdf->Cell(0, 1, "", "B", 1);
    //
    $pdf->SetFont('Arial', 'B', 9);
    $pdf->Cell(100, 6, utf8_decode('Item'));
    $pdf->Cell(20, 6, utf8_decode('Und.'), 0, 0, "C");
    $pdf->Cell(20, 6, utf8_decode('Programa'), 0, 0, "C");
    $pdf->Cell(30, 6, utf8_decode('Qtd.'), 0, 0, "R");
    $pdf->Cell(20, 6, utf8_decode('Vlr.Unit.'), 0, 0, "R");
    $pdf->Cell(20, 6, utf8_decode('Total'), 0, 1, "R");
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', '', 8);
    while ($row = mysql_fetch_array($rs_ite)) {
        $pdf->Cell(100, 4, utf8_decode($row['pro_produto']) . '-' . $row['oci_item_id']);
        $pdf->Cell(20, 4, utf8_decode($row['und_desc']), 0, 0, "C");
        $pdf->Cell(20, 4, utf8_decode($row['prg_programa']), 0, 0, "C");
        $pdf->Cell(30, 4, utf8_decode(number_format($row['oci_quant'], 2, ',', '.')), 0, 0, "R");
        $pdf->Cell(20, 4, number_format($row['oci_vrunit'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(20, 4, number_format($row['oci_vrtotal'], 2, ',', '.'), 0, 1, "R");
    }
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', '', 8);
    $pdf->Cell(0, 4, utf8_decode('Itens na ordem de compra: ') . mysql_num_rows($rs_ite), 0, 1, "R");
//
//    $pdf->Ln(20);
//    $pdf->SetFont('Arial', '', 10);
//    $pdf->Cell(70, 8, utf8_decode('Responsável pela entrega '), 'T', 0, 'L');
//    $pdf->Cell(40, 8, ' ', 0, 0, 'L');
//    $pdf->Cell(70, 8, utf8_decode('Responsável pelo recebimento'), 'T', 0, 'L');
//    $pdf->Ln(15);
//    $pdf->Cell(0, 0, utf8_decode('Ciente e de acordo em ____/____/____'), 0, 1);
//
    $pdf->Cell(0, 1, "", "B", 1); //linha
    $pdf->SetFont('Arial', '', 8);
    $pdf->Cell(63, 4, utf8_decode('Emissão: ') . date('d/m/Y'), 0, 0, "L");
    $pdf->SetFont('Arial', '', 6);
    $pdf->Cell(63, 4, utf8_decode('rel_ordcompra'), 0, 0, "C");
    $pdf->SetFont('Arial', '', 8);
    $pdf->Cell(64, 4, utf8_decode('SGAE - Merenda'), 0, 1, "R");
    ob_clean();
    $pdf->Output('Ordem de compra: ' . $resulta['odc_numordcomp'] . '.pdf', 'I');
    exit;