} //generar el listado setlocale(LC_ALL, "es_VE.UTF8"); $lobjPdf = new clsFpdf(); $lobjPdf->AddPage("L"); $lobjPdf->AliasNbPages(); $lobjPdf->SetFont("arial", "B", 8); $lobjPdf->SetFont('Arial', '', 12); //Table with 20 rows and 5 columns $lobjPdf->SetWidths(array(20, 35, 26)); $pgsql = new Conexion(); $sql = "SELECT *,(CASE estatus WHEN '1' THEN 'ACTIVO' ELSE 'DESACTIVADO' END) AS estatus from biblioteca.ttema"; $i = -1; $data = $pgsql->Ejecutar($sql); if ($pgsql->Total_Filas($data) != 0) { $lobjPdf->SetFillColor(0, 0, 140); $avnzar = 90; $altura = 7; $anchura = 10; $color_fondo = false; $lobjPdf->SetFont('Arial', 'B', 10); $lobjPdf->SetTextColor(0, 0, 0); $lobjPdf->SetFont('Arial', '', 8); $lobjPdf->SetTextColor(0, 0, 0); $xxxx = 0; while ($tperfil = $pgsql->Respuesta($data)) { $lobjPdf->Row(array(ucwords($tperfil['codigo_tema']), ucwords($tperfil['descripcion']), ucwords($tperfil['estatus']))); $lobjPdf->Cell($avnzar); } $lobjPdf->Output('documento', "I"); } else {
$this->Cell(10); } } setlocale(LC_ALL, "es_VE.UTF8"); $lobjPdf = new clsFpdf(); $lobjPdf->AliasNbPages(); $lobjPdf->AddPage('P', array(290, 183)); $lobjPdf->SetFont("arial", "B", 9); $anchura = 32.2; $altura = 6; $margin = 10; $background = false; $alignacion = "C"; $weekend = 1; $lobjPdf->SetFont("arial", "", 9); $lobjPdf->SetFillColor(255, 0, 0); if (isset($_SESSION['datos']['dia'])) { $dia = $_SESSION['datos']['dia']; $hora = $_SESSION['datos']['hora']; $id_celda = $_SESSION['datos']['celda']; } if (isset($_SESSION['datos']['id_hora'])) { $id_hora = $_SESSION['datos']['id_hora']; } $bloque_horas = new horario(); $turno = 0; $get_hora = $bloque_horas->bloque_hora("todos"); $lobjPdf->SetWidths(array($anchura - 7, $anchura, $anchura, $anchura, $anchura, $anchura, $anchura, $anchura)); $valor_a_buscar = array(); $lobjPdf->Cell(-10); for ($i = 0; $i < count($get_hora['id']); $i++) {