| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/merenda/itapipoca20/modulos/remessa/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 04/02/2015
* Time: 09:25
*/
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_remessa");
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 Remessas', 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(20, 4, 'Data', 0, 0, "L");
$this->Cell(20, 4, 'Per.Inicial', 0, 0, "L");
$this->Cell(20, 4, 'Per. Final', 0, 0, "L");
$this->Cell(90, 4, 'Card�pio', 0, 0, "L");
$this->Cell(80, 4, 'Escola', 0, 0, "L");
$this->Cell(60, 4, 'Programa', 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');
}
}
$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, $row['rms_id'], 0, 0, "L");
$pdf->Cell(20, 4, $row['rms_data'], 0, 0, "L");
$pdf->Cell(20, 4, $row['rms_dtinic'], 0, 0, "L");
$pdf->Cell(20, 4, $row['rms_dtfim'], 0, 0, "L");
$pdf->Cell(90, 4, $row['cdp_nmcardapio'], 0, 0, "L");
$pdf->Cell(80, 4, $row['esc_nome'], 0, 0, "L");
$pdf->Cell(60, 4, $row['prg_programa'], 0, 1, "L");
}
//QTD ITENS DO LACO
$pdf->SetFont('Arial', '', 8);
$pdf->Cell(0, 0, "", "B", 1);
$pdf->Cell(0, 5, 'Itens: ' . mysql_num_rows($rs_ite), 0, 1, "R");
ob_clean();
$pdf->Output('relacao de remessas.pdf', 'I');
exit;