<?php
    /**
     * Created by PhpStorm.
     * User: RalpAlves
     * Date: 04/02/2015
     * Time: 08:22
     */
    include_once("../../includes/conexao.php");
    include "../../fpdf/fpdf.php";
    session_start();
    $entida = $_SESSION['prefeitura'];
    $secret = $_SESSION['secretaria'];
    
    $v_id = $_GET['id'];
    
    $rs_ite = mysql_query("select * from v_lista_escolas_programa GROUP BY esc_id ORDER BY esc_nome");
    
    class PDF extends FPDF
    {
        public function Header()
        {
            global $entida;
            global $secret;
            $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');
            //TITULO do RELATORIO
            $this->SetFont('Arial', 'B', 12);
            $this->Cell(0, 5, 'Rela��o de Escolas', 0, 1, "C");
            $this->Ln(8);
            $this->Cell(0, 1, "", "B", 1);
            
            //CABECALHO DO LACO
            //PRODUTO
            $this->SetFont('Arial', 'B', 8);
            $this->Cell(10, 4, 'ID');
            $this->Cell(80, 4, 'Escola', 0, 0, "C");
            $this->Cell(60, 4, 'Bairro', 0, 0, "L");
            $this->Cell(30, 4, 'Distrito', 0, 0, "L");
            $this->Cell(30, 4, 'Rota', 0, 0, "L");
            $this->Cell(50, 4, 'Diretor', 0, 0, "L");
            $this->Cell(30, 4, 'Telefone', 0, 1, "L");
            $this->Cell(0, 0, "", "B", 1);
        }
        
        function Footer()
        {
            $this->SetY(-10);
            $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', false,"http://www.gtcontroller.com.br/site/");
        }
    }
    
    $pdf = new PDF();
    $pdf->AddPage('Landscape', 'A4');
    $pdf->SetFont('Arial', '', 7);
    while ($row = mysql_fetch_array($rs_ite)) {
        $pdf->Cell(0, 0, "", "B", 1);
        $pdf->Cell(10, 4, utf8_encode($row['esc_id']), 0, 0, "L");
        $pdf->SetFont('Arial', 'B', 7);
        $pdf->Cell(80, 4, $row['esc_nome'], 0, 0, "L", false);
        $pdf->SetFont('Arial', '', 7);
        $pdf->Cell(60, 4, $row['esc_bairro'], 0, 0, "L");
        $pdf->Cell(30, 4, $row['dis_distrito'], 0, 0, "L");
        $pdf->Cell(30, 4, $row['rota'], 0, 0, "L");
        $pdf->Cell(50, 4, $row['esc_diretor'], 0, 0, "L");
        $pdf->Cell(30, 4, $row['esc_telefone'], 0, 1, "L");
        $pdf->Cell(0, 0, "", "B", 1);
        
        $idesc      = $row['esc_id'];
        $v_manha    = 0;
        $v_tarde    = 0;
        $v_noite    = 0;
        $v_integral = 0;
        $v_ampliada = 0;
        $rs_prg     = mysql_query("select * from v_lista_escolas_programa WHERE esc_id=$idesc");
        while ($l = mysql_fetch_array($rs_prg)) {
            $pdf->SetFont('Arial', '', 7);
            $pdf->Cell(25, 4, $l['prg_programa'], 0, 0, "L");
            $pdf->Cell(25, 4, 'Manh�: ' . $l['esp_manha'], 0, 0, "R");
            $pdf->Cell(25, 4, 'Tarde: ' . $l['esp_tarde'], 0, 0, "R");
            $pdf->Cell(25, 4, 'Noite: ' . $l['esp_noite'], 0, 0, "R");
            $pdf->Cell(25, 4, 'Integral: ' . $l['esp_integral'], 0, 0, "R");
            $pdf->Cell(25, 4, 'Ampliada: ' . $l['esp_ampliada'], 0, 1, "R");
            $pdf->SetFont('Arial', '', 8);
            
            $v_manha    += $l['esp_manha'];
            $v_tarde    += $l['esp_tarde'];
            $v_noite    += $l['esp_noite'];
            $v_integral += $l['esp_integral'];
            $v_ampliada += $l['esp_ampliada'];
        }
        
        $pdf->SetFont('Arial', '', 7);
        $pdf->Cell(25, 4, 'TOTAIS: ', 0, 0, "L");
        $pdf->Cell(25, 4, 'Total: ' . $v_manha, 0, 0, "R");
        $pdf->Cell(25, 4, 'Total: ' . $v_tarde, 0, 0, "R");
        $pdf->Cell(25, 4, 'Total: ' . $v_noite, 0, 0, "R");
        $pdf->Cell(25, 4, 'Total: ' . $v_integral, 0, 0, "R");
        $pdf->Cell(25, 4, 'Total: ' . $v_ampliada, 0, 0, "R");
        
        $v_total = $v_manha + $v_tarde + $v_noite + $v_integral + $v_ampliada;
        $pdf->Cell(30, 4, 'Total de alunos: ' . $v_total, 0, 1, "R", false,"");
    
        $pdf->Cell(0, 2, "", "", 1);
    }
    //QTD ITENS DO LACO
    $pdf->SetFont('Arial', '', 8);
    $pdf->Cell(0, 0, "", "B", 1);
    $pdf->Cell(0, 5, 'Escolas: ' . mysql_num_rows($rs_ite), 0, 1, "R");
    
    ob_clean();
    $pdf->Output('relacao de escolas.pdf', 'I');
    exit;