<?php
    /**
     * Created by PhpStorm.
     * User: RalpAlves
     * Date: 13/01/2016
     * Time: 11:44
     */
    include_once("../../includes/conexao.php");
    include "../../fpdf/fpdf.php";
    
    $rs_ent = mysql_query("SELECT * FROM entidade");
    $rs_res = mysql_fetch_array($rs_ent);
    $rs_sql = mysql_query("SELECT * FROM v_lista_ordem_compra ORDER BY cdp_nmcardapio,prg_programa,pes_pessoa");
    $rs_itn = mysql_query("SELECT * FROM v_lista_ordem_compra_itens");
    
    $pdf = new FPDF('L');
    $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, 8, utf8_decode('Secretaria Municipal de Educação'), 0, 1, "C");
    $pdf->SetFont('Arial', 'B', 10);
    $pdf->Cell(0, 5, utf8_decode('Listagem de Ordens de compra'), 0, 1, "C");
    //
    $pdf->Ln(6);
    $pdf->Cell(0, 0, "", "B", 1);
    //
    $pdf->SetFont('Arial', 'B', 8);
    $pdf->Cell(8, 6, utf8_decode('ID'));
    $pdf->Cell(16, 6, utf8_decode('Nº O.C.'), 0, 0, "L");
    $pdf->Cell(75, 6, utf8_decode('Cardápio'), 0, 0, "L");
    $pdf->Cell(20, 6, utf8_decode('Programa'), 0, 0, "L");
    $pdf->Cell(20, 6, utf8_decode('Data'), 0, 0, "L");
    $pdf->Cell(75, 6, utf8_decode('Fornecedor'), 0, 0, "L");
    $pdf->Cell(20, 6, utf8_decode('Nº Lic.'), 0, 0, "L");
    $pdf->Cell(5, 6, utf8_decode('R'), 0, 0, "L");
    $pdf->Cell(10, 6, utf8_decode('Período'), 0, 1, "L");
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', '', 7);
    while ($row = mysql_fetch_array($rs_sql)) {
        $pdf->Cell(8, 6, utf8_decode($row['odc_id']), 0, 0, "L");
        $pdf->Cell(16, 6, utf8_decode($row['odc_numordcomp']), 0, 0, "L");
        $pdf->Cell(75, 6, utf8_decode($row['cdp_nmcardapio']), 0, 0, "L");
        $pdf->Cell(20, 6, utf8_decode($row['prg_programa']), 0, 0, "L");
        $pdf->Cell(20, 6, utf8_decode($row['odc_data']), 0, 0, "L");
        $pdf->Cell(75, 6, utf8_decode($row['pes_pessoa']), 0, 0, "L");
        $pdf->Cell(20, 6, utf8_decode($row['cpl_numproc_lic']), 0, 0, "L");
        $pdf->Cell(5, 6, utf8_decode($row['odc_repete']), 0, 0, "L");
        $pdf->Cell(5, 6, utf8_decode($row['odc_dtinic'] . ' a ' . $row['odc_dtfim']), 0, 1, "L");
        $pdf->Cell(0, 1, "", "B", 1);
        $id_ord = $row['odc_id'];
        $rs_itn = mysql_query("SELECT * FROM v_lista_ordem_compra_itens WHERE oci_odc_id=$id_ord");
        $pdf->Cell(24, 4, '', 0, 0);
        $pdf->SetFont('Arial', 'B', 8);
        $pdf->Cell(55, 6, utf8_decode('Produto'), 0, 0, "L");
        $pdf->Cell(20, 6, utf8_decode('Unid.'), 0, 0, "L");
        $pdf->Cell(15, 6, utf8_decode('Programa'), 0, 0, "L");
        $pdf->Cell(30, 6, utf8_decode('Percapita'), 0, 0, "R");
        $pdf->Cell(30, 6, utf8_decode('Quant.'), 0, 0, "R");
        $pdf->Cell(30, 6, utf8_decode('Val.Unit.'), 0, 0, "R");
        $pdf->Cell(30, 6, utf8_decode('Total'), 0, 1, "R");
        $soma = 0;
        while ($ro1 = mysql_fetch_array($rs_itn)) {
            $pdf->SetFont('Arial', '', 7);
            $pdf->Cell(24, 4, '', 0, 0);
            $pdf->Cell(55, 4, utf8_decode($ro1['pro_produto']), 0, 0);
            $pdf->Cell(20, 4, utf8_decode($ro1['und_desc']), 0, 0);
            $pdf->Cell(15, 4, utf8_decode($ro1['prg_programa']), 0, 0);
            if ($ro1['oci_percapita'] <> null) {
                $pdf->Cell(30, 4, utf8_decode($ro1['oci_percapita']), 0, 0, 'R');
            } else {
                $pdf->Cell(30, 4, '0.0000', 0, 0, 'R');
            }
            $pdf->Cell(30, 4, utf8_decode($ro1['oci_quant']), 0, 0, 'R');
            $pdf->Cell(30, 4, number_format($ro1['oci_vrunit'], 2, ',', '.'), 0, 0, 'R');
            $pdf->Cell(30, 4, number_format($ro1['oci_quant'] * $ro1['oci_vrunit'], 2, ',', '.'), 0, 1, 'R');
            $soma += $ro1['oci_quant'] * $ro1['oci_vrunit'];
        }
        $pdf->SetFont('Arial', 'B', 7);
        $pdf->Cell(234, 4, 'Total '.number_format($soma, 2, ',', '.'), 0, 1, 'R');
        $pdf->SetFont('Arial', '', 8);
        $pdf->Ln(1);
        $pdf->Cell(0, 1, "", "B", 1);
    }
    $pdf->Cell(0, 1, "", "B", 1);
    $pdf->SetFont('Arial', '', 8);
    $pdf->Cell(0, 4, utf8_decode('Ordens: ') . mysql_num_rows($rs_sql), 0, 1, "R");
    //
    $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_ordcompralista'), 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' . 'pdf', 'I');
    exit;