Código PHP:
Ver original
<?php require('fpdf/fpdf.php'); class PDF extends FPDF { { $this->SetFont('Arial','B',14); //Logo $this->Image('imagenes/sadd.jpg',3,5,50); //Título $this->Cell(200,20,'LISTADO MAESTRO DE DOCUMENTOS INTERNOS',0,0,'C'); //linea // do{ $this->Ln(0); $this->SetFillColor(128,0,0); $this->SetTextColor(255,255,255); $this->setLeftMargin(5); $this->SetFont('Arial','B',7); $this->Text(30,30,' ',1,0,'C',1); $this->Ln(15); $this->SetFillColor(0,47,98); $this->Cell(200,0.5,' ',0,0,'C',1); //Salto de línea $this->Ln(0); $this->SetFillColor(128,0,0); $this->SetTextColor(183,183,183); $this->setLeftMargin(5); $this->SetFont('Arial','B',7); $this->Text(20,30,'ID',1,0,'C',1); $this->Text(40,30,'Clave',1,0,'C',1); $this->Text(60,30,'Nombre del Documento',1,0,'C',1); $this->Text(115,30,'Versión',1,0,'C',1); $this->Text(150,30,'Fecha Liberacion',1,0,'C',1); //titulo 2 $this->Ln(13); $this->SetFont('Arial','I',8); $this->SetTextColor(0,47,98); $this->SetFillColor(231,122,24); $this->Cell(200,4,'DISTRIBUCION DEL DOCUMENTO',2,0,'C',10); //segunda tabla $this->Ln(10); $this->SetFillColor(128,0,0); $this->SetTextColor(183,183,183); $this->setLeftMargin(5); $this->SetFont('Arial','B',7); $this->Text(20,45,'ID',2,0,'C',1); $this->Text(40,45,'Clave del Empleado',2,0,'C',1); $this->Text(80,45,'Nombre del Empleado',2,0,'C',1); $this->Text(125,45,'Copia Controlada',2,0,'C',1); $this->Text(160,45,'Puesto',2,0,'C',1); $this->Text(180,45,'Area',2,0,'C',1); //linea $this->Ln(5); $this->SetFont('Arial','I',9); $this->SetFillColor(0,0,0); $this->SetTextColor(82,82,80); $this->Cell(200,0.5,' ',1,0,'C',1); $this->Ln(10); } function Footer() { //Posición: a 1,5 cm del final $this->SetY(-15); //Arial italic 8 $this->SetFont('Arial','I',8); //Número de página $this->Cell(0,10,'Pagina '.$this->PageNo().' de {nb}',0,0,'C'); } } //$num=$_POST["solicitud"]; //Creación del objeto de la clase heredada $pdf=new PDF('P','mm','Letter'); $QResult = mysql_query("SELECT d.IdDocumentos,d.Clave,d.Nombre,e.IdEmp,e.ClaveEmpleado, e.Nombre,Apaterno, AMaterno, CopiaControlada, NomPuesto, a.Nombre FROM Empleado e, DocumentosDistribucion o, Documentos d, Area a, Puesto p WHERE e.IdArea = a.IdArea AND e.IdPuesto = p.IdPuesto AND o.IdEmp = e.IdEmp AND d.IdDocumentos = o.IdDocumentos AND Consulta=1 ",$conexion) or die(mysql_error()); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetFont('arial','I',8); $pdf->SetTextColor(0,47,98); $pdf->setLeftMargin(10); { $pdf->Text(20,35,''.$row[0],1,0,'C'); $pdf->Text(40,35,''.$row[1],1,0,'C'); $pdf->Text(60,35,''.$row[2],1,0,'C'); $pdf->Text(20,50,''.$row[3],1,0,'C'); $pdf->Text(40,50,''.$row[4],1,0,'C'); $pdf->Text(70,50,''.$row[5],1,0,'C'); $pdf->Text(90,50,''.$row[6],1,0,'C'); $pdf->Text(110,50,''.$row[7],1,0,'C'); $pdf->Text(135,50,''.$row[8],1,0,'C'); $pdf->Text(160,50,''.$row[9],1,0,'C'); $pdf->Text(180,50,''.$row[10],1,1,'C'); } $pdf->Output(); ?>