<?php
    include_once("../../includes/conexao.php");
    include "../../fpdf/fpdf.php";
    mysql_select_db($banco, $conexao);
    
    $esc_id  = $_GET['esc_id'];
    $data_r  = $_GET['data_r'];
    $rs_ent  = mysql_query("select * from entidade");
    $rs_res  = mysql_fetch_array($rs_ent);
    $rs_sql  = mysql_query("select * from v_lista_remessa_programas_a where ra_escola=$esc_id and ra_data='$data_r'");
    $rs_sql2 = mysql_query("select * from v_lista_remessa_programas_a where ra_escola=$esc_id and ra_data='$data_r'");
    $resulta = mysql_fetch_array($rs_sql2);
    
//    $pdf = new FPDF('L', 'cm', 'A4');
    $pdf = new FPDF();
    $pdf->Open();
    $pdf->SetTitle("Remessa de produtos");
    //HEADER
    $pdf->AddPage('L');
    $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('Remessa de produtos'), 0, 1, "C");
    //
    $pdf->Cell(0, 8, "", "", 1);
    $pdf->SetFont('Arial', '', 9);
    $pdf->Cell(18, 5, utf8_decode('Data: '));
    $pdf->Cell(0, 5, $resulta['ra_data'], 0, 1);
    $pdf->Cell(18, 4, utf8_decode('Escola: '));
    $pdf->Cell(0, 4, $resulta['esc_nome'], 0, 1);
    $pdf->Cell(18, 4, utf8_decode('Endereço: '));
    $pdf->Cell(0, 4, $resulta['esc_endereco'], 0, 1);
    $pdf->Cell(18, 4, utf8_decode('Diretor(a): '));
    $pdf->Cell(0, 4, $resulta['esc_diretor'], 0, 1);
    $pdf->Cell(18, 4, utf8_decode('Rota: '));
    $pdf->Cell(0, 4, $resulta['rota'], 0, 1);
    $pdf->Cell(18, 4, utf8_decode('Exercício: '));
    $pdf->Cell(0, 4, $resulta['ra_exercicio'], 0, 1);
    $pdf->Cell(0, 2, "", "B", 1);
    //
    $pdf->SetFont('Arial', 'B', 8);
    $pdf->Cell(10, 4, utf8_decode('ID'));
    $pdf->Cell(93, 4, utf8_decode('Item'));
    $pdf->Cell(18, 4, utf8_decode('Und.'), 0, 0, "C");
    $pdf->Cell(15, 4, utf8_decode('PNAEF'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('PNAEC'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('PNAEP'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('EJA'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('PNAEM'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('AEE'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('+ EDUC.'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('INDIG.'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('QUILOMB.'), 0, 0, "R");
    $pdf->Cell(15, 4, utf8_decode('TOTAL'), 0, 1, "R");
    $pdf->SetFont('Arial', '', 9);
    while ($row = mysql_fetch_array($rs_sql)) {
        $pdf->Cell(10, 4, utf8_decode($row['rai_pro_id']));
        $pdf->Cell(93, 4, utf8_decode($row['pro_produto']));
        $pdf->Cell(18, 4, utf8_decode($row['und_desc']), 0, 0, "C");
        $pdf->Cell(15, 4, number_format($row['PNAEF'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['PNAEC'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['PNAEP'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['EJA'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['PNAEM'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['AEE'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['MAIS ED.'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['INDIGENA'], 2, ',', '.'), 0, 0, "R");
        $pdf->Cell(15, 4, number_format($row['QUILOMB.'], 2, ',', '.'), 0, 0, "R");
        $pdf->SetFont('Arial', 'B', 9);
        $pdf->Cell(15, 4, number_format($row['total'], 2, ',', '.'), 0, 1, "R");
        $pdf->SetFont('Arial', '', 9);
    }
    $pdf->Cell(0, 0, "", "B", 1);
    $pdf->SetFont('Arial', '', 8);
//    $pdf->Cell(0, 5, utf8_decode('Itens na remessa: '. mysql_num_rows($rs_sql)), 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, 4, "", "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_ficha_remessa_por_escola'), 0, 0, "C");
    $pdf->SetFont('Arial', '', 8);
    $pdf->Cell(64, 4, utf8_decode('SGAE | Sistema de Gestão da Alimentação Escolar'), 0, 1, "R");
    ob_clean();
    $pdf->Output('Remessa.pdf', 'I');
    exit;