$this->SetY(-15); $this->SetDrawColor(90, 90, 90); $this->Line(15, 278, 195, 278); $this->SetFont('Arial', '', 9); $this->SetTextColor(150, 150, 150); $this->Cell(0, 0, chr(169) . ' ' . appconf('company_name') . ', ' . date('Y') . ' For further information, visit us online at ' . appconf('company_website'), 0, 0, 'R'); $this->SetTextColor(0); } } // end PDF $pdf = new PDF(); $pdf->SetFont('Arial', '', 10); $pdf->Open(); $pdf->SetDisplayMode(150, 'single'); $pdf->SetLeftMargin(15); $pdf->SetRightMargin(15); $pdf->SetFillColor(240, 240, 240); $pdf->AddPage(); $pdf->Cell(0, 5, ' ', 0, 1, 'C'); $pdf->Ln(); // heading $pdf->SetFont('Arial', '', 10); //$pdf->Cell (0, 5, 'Simian Systems Inc.', 0, 1, 'R'); $pdf->SetFont('Arial', '', 10); $pdf->Cell(0, 5, appconf('company_address'), 0, 1, 'R'); $pdf->SetLeftMargin(131.5); $pdf->WriteHTML('tel: ' . appconf('company_phone') . ', web: <a href="http://' . appconf('company_website') . '/">' . appconf('company_website') . '</a>'); $pdf->SetLeftMargin(15); $pdf->Ln(); $pdf->Cell(0, 5, ' ', 0, 1, 'C'); $pdf->Ln();
$statement->execute(); $statement->nextRowSet(); $statement->closeCursor(); $statement = $db->prepare('SELECT sa_examenes_himno.nota_himno as NOTA FROM sa_examenes_himno WHERE sa_examenes_himno.cod_solicitud = ' . $codsHimno[$i]); $statement->execute(); $tablaNota = $statement->fetchALL(PDO::FETCH_ASSOC); foreach ($tablaNota as $filaNota) { $calificacion = $filaNota['NOTA']; $nota_letras = convertir_a_letras($calificacion); } $statement->nextRowSet(); $statement->closeCursor(); $pdf->AddPage(); $pdf->Image($maindir . 'assets/img/Encabezado de documentos.jpg', 0.4, 0.05, 20.96, 3.22, 'JPG'); $pdf->Image($maindir . "assets/img/Pie de documentos.jpg", 0.4, 19.1, 20.88, 13.7, 'JPG'); $pdf->SetRightMargin(1.0); $pdf->SetLeftMargin(1.0); $pdf->SetFont('Calibri', 'B', 11); $pdf->Cell(0, -0.45, utf8_decode("FACULTAD DE CIENCIAS JURÍDICAS "), 0, 0, 'R'); $pdf->Ln(0.2); $pdf->SetFont('Arial', '', 10); $pdf->Cell(0, 0, utf8_decode("Teléfono: 2232-2290 "), 0, 1, 'R'); $pdf->Ln(0.41); $pdf->Cell(0, 0, utf8_decode("Edificio A-2 "), 0, 1, 'R'); $pdf->Ln(0.41); $pdf->Cell(0, 0, utf8_decode("Ciudad Universitaria "), 0, 1, 'R'); $pdf->Ln(0.41); $pdf->Cell(0, 0, utf8_decode("Tegucigalpa, Honduras "), 0, 1, 'R'); $pdf->ln(3.5); $pdf->SetFont('Cambria', 'BI', 16); $pdf->Cell(0, 0, utf8_decode("CONSTANCIA DE HIMNO"), 0, 1, 'C');
$rsmeucci = $stmtMeucci->fetch(PDO::FETCH_ASSOC); $sql = "SELECT azienda.*,stage.*,tirocinante.*,persTutor.PAZ_Titolo AS ta_Titolo,persTutor.PAZ_Nome AS ta_Nome,persTutor.PAZ_Telefono AS ta_Telefono, persTutor.PAZ_Cellulare AS ta_Cellulare, persTutor.PAZ_Email AS ta_Email, persLegal.*,tutor.* FROM stage INNER JOIN azienda ON ( azienda.AZ_ID = stage.AZ_ID_Azienda ) INNER JOIN tirocinante ON ( stage.TIR_ID_Tirocinante = tirocinante.TIR_ID ) INNER JOIN tutor ON ( tutor.TUT_ID = stage.TUT_ID_Tutor ) LEFT JOIN personale AS persTutor ON ( persTutor.PAZ_ID = stage.PAZ_ID_Tutor ) LEFT JOIN personale AS persLegal ON ( azienda.AZ_ID = persLegal.AZ_ID_Azienda AND persLegal.PAZ_RapprLegale =1 ) WHERE STA_ID=:id"; $stmt = $dbh->prepare($sql); $stmt->bindValue(':id', $_GET['id']); $stmt->execute(); if ($stmt->rowCount() > 0) { $row = $stmt->fetch(PDO::FETCH_ASSOC); $pdf = new PDF(); $pdf->SetTitle("Progetto formativo e di orientamento"); $pdf->AddFont('abac', '', 'abac.php'); $pdf->AddFont('abalc', '', 'ABALC.php'); $pdf->SetFillColor(255, 230, 255); $pdf->AliasNbPages(); $pdf->AddPage(); $pdf->SetLeftMargin(18); $pdf->SetRightMargin(18); $pdf->SetFont('abac', '', 14); $pdf->Cell(0, 10, 'PROGETTO FORMATIVO e di ORIENTAMENTO', 0, 0, 'C'); $pdf->Ln(10); $pdf->SetFont('abalc', '', 11); $pdf->Cell(40, 6, 'Tirocinante ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . utf8_decode($row['TIR_Nome']) . ' ' . utf8_decode($row['TIR_Cognome']) . ' - C.F.: ' . utf8_decode($row['TIR_CodiceFiscale']), 1, 1); $pdf->Cell(40, 6, 'Luogo e data di nascita ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . utf8_decode($row['TIR_NatoA']) . ' (' . $row['TIR_NatoProv'] . ') il ' . strftime('%d/%m/%Y', strtotime($row['TIR_DataNascita'])), 1, 1); $pdf->Cell(40, 6, 'Residenza ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . utf8_decode($row['TIR_IndirizzoResidenza']) . ' - ' . $row['TIR_CAP'] . ' ' . utf8_decode($row['TIR_ComuneResidenza']), 1, 1); $pdf->Cell(40, 6, 'Recapiti ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . $row['TIR_Cellulare'] . ' - ' . $row['TIR_TelefonoFisso'] . ' - ' . $row['TIR_EMail'], 1, 1); $pdf->Cell(40, 6, 'Classe / Indirizzo ', 1, 0, 'R', 1); $pdf->Cell(135, 6, ' ' . $row['TIR_Classe'] . ' ' . $row['TIR_Indirizzo'], 1, 1); $pdf->Ln(3);
$w = 63; $top = 28; $c1x = 13; $c2x = $c1x + $w; $c3x = $c2x + $w; $c4x = $c3x + $w; $c1h = 170; $c2h = $c1h / 2; $c3h = $c2h / 2; $c4h = $c3h / 2; $bottom = $top + $c1h; $pdf = new PDF('L', 'mm', 'Letter'); $pdf->Open(); $pdf->SetTopMargin(13); $pdf->SetLeftMargin(13); $pdf->SetRightMargin(10); $pdf->SetAutoPageBreak(True, 13); $pdf->AddPage(); $pdf->SetCreator($_SERVER["PHP_SELF"]); $pdf->SetAuthor("Keith Morrison, keithm@infused.org"); $pdf->SetTitle(sprintf(gtc("Pedigree for %s"), $o->full_name())); $pdf->SetSubject(gtc("Genealogy")); # Person 1 $pdf->SetY($top); $pdf->SetX($c1x); $pdf->Cell($w, $c1h, '', 1, 0, 'L'); $pdf->SetY($top + $c1h / 2 - 6); $pdf->SetX($c1x); $pdf->SetFont($font, 'B', 10); $pdf->MultiCell($w, 4, isset($g_node_strings[1][0]) ? $g_node_strings[1][0] : '', 0, 'L'); $pdf->SetFont($font, '', 10);
//Pie de página function Footer() { $this->SetY(-19); $this->SetFont('Arial', '', 10); $this->MultiCell(0, 5, $this->pie, 0, C); } } $db = new ConnectionHandler("{$ruta_raiz}"); $db->conn->SetFetchMode(ADODB_FETCH_ASSOC); $pdf = new PDF('p', 'mm', 'letter'); $pdf->pie = $pie; $pdf->AddPage(); $pdf->SetTitle("Departamento Nacional de Planeacion"); $pdf->SetLeftMargin(25); $pdf->SetRightMargin(25); $pdf->SetFont('Arial', 'B', 12); $pdf->Cell(50, 5, $numradicado, 0, 1, L); $pdf->Cell(105, 5, $lugar . "., " . $fecha, 0, 1, L); $pdf->ln(18); $pdf->SetFont('Arial', '', 12); $pdf->write(5, $asu); $pdf->ln(25); $pdf->Cell(60, 5, $mensaje, 0, 1, L); $pdf->ln(5); $pdf->MultiCell(0, 5, $reseptor, 0, L); $primerno = substr($numRadicadoPadre, 0, 4); $segundono = substr($numRadicadoPadre, 4, 3); $ruta = "/" . $primerno . "/" . $segundono . "/docs/" . $numradicado; $adjuntos = BODEGAPATH . $ruta; $pdf->Output($adjuntos . '.pdf', 'f');
session_start(); /*if(!isset($_SESSION['USN'])) { header("Location: stulogin.php"); } */ require 'Library/fpdf/MultiCellBlt2.php'; $con = mysqli_connect("localhost", "root", "root", "amgs"); $usn = $_SESSION['USN']; //echo $usn; //$usn=$_POST["USN"]; $whichinternal = "internal1"; //$whichinternal=$_POST["whichinternal"]; $pdf = new PDF(); $pdf->AddPage(); $pdf->SetLeftMargin(15); $pdf->SetRightMargin(20); $res = mysqli_query($con, "Select name from student where USN like '{$usn}'"); $a = mysqli_fetch_array($res); $name = $a[0]; $subct = 6; //$sub[0]="12IS62"; $sub = array(); $i = 0; $coresubcount = 4; $res = mysqli_query($con, "select * from subject"); while ($row = mysqli_fetch_array($res)) { if ($coresubcount != 0) { $sub[$i++] = $row["course_code"]; $coresubcount--; } }
$this->Cell(80, 3, 'Cagua Edo. Aragua. Telfs: 0244-3964557 / 0426-5125749', 0, 1, 'C'); //Linea 5 $this->Cell(59, 3, '', 0, 0, 'C'); $this->Cell(80, 3, '0416-0458957 / 0426-5180385 / 0424-3261656', 0, 1, 'C'); $this->Ln(10); } parent::Header(); } } if (isset($imp)) { $pdf = new PDF('L', 'mm', 'Legal'); } else { $pdf = new PDF('P', 'mm', 'Letter'); } $pdf->SetLeftMargin(6); $pdf->SetRightMargin(7); $pdf->Open(); $pdf->AddPage(); //T�tulo del Reporte $pdf->Ln(3); $pdf->SetFont('times', 'B', 12); $pdf->Cell(1, 4, 'Clientes' . $text, 0, 1); $pdf->Cell(1, 10, "Listado de Morosos Productos con" . $giros . utf8_decode(" o más cuotas vencidas"), 0, 1, 'L'); $pdf->SetFont('Arial', '', 10); //Connect to database mysql_select_db($database_tecno, $tecno); $queryCliente = "SELECT *, COUNT(giro) as giro, CONCAT(nombres,' ', primerApellido) as fullName, CONCAT(telefono,' / ',celular) as telefonos FROM datospersonales, detallescliente, refpersonal, inflaboral WHERE status<>1 AND fechaV <'{$today}' AND datospersonales.id = detallescliente.id AND datospersonales.id = refpersonal.id AND datospersonales.id=inflaboral.id AND inflaboral.ministerio= '{$tpCli}' AND detallescliente.tipo = 1 GROUP BY detallescliente.idArt HAVING COUNT(giro) >= '{$giros}' ORDER BY datospersonales.nombres ASC"; $cliente = mysql_query($queryCliente, $tecno) or die(mysql_error()); $rowCliente = mysql_fetch_assoc($cliente); $totalRowsCliente = mysql_num_rows($cliente); if ($totalRowsCliente > 0) {
} $cadenaOrientacion = ", con orientación en " . $orientacion . ""; $cadenaPlanEstudio = "(" . $planEstudio . ")"; $fechaPalabras = $_POST["cadena"]; $statement->nextRowSet(); $statement->closeCursor(); $statement = $db->prepare('UPDATE sa_solicitudes SET fecha_exportacion = "' . $fechaExp . '" WHERE codigo = ' . $codsConstancias[$i] . ''); $statement->execute(); $statement->nextRowSet(); $statement->closeCursor(); $pdf->AddPage(); $pdf->Image($maindir . 'assets/img/Encabezado constancias.jpg', 20.0, 7, 176, 33.2, 'JPG'); $pdf->ln(65); $pdf->SetFont('Cambria', 'BI', 16); $pdf->SetLeftMargin(22); $pdf->SetRightMargin(22); $pdf->Cell(0, 0, utf8_decode("C O N S T A N C I A"), 0, 1, 'C'); //Definir la siguente cadena //$cadenaOrientacion = ""; $pdf->Ln(19); $pdf->SetFont('Cambria', 'I', 16); $pdf->SetLeftMargin(22); $pdf->SetRightMargin(22); $pdf->newFlowingBlock(170, 10, 0, 'J'); $pdf->SetFont('Cambria', 'I', 14); $pdf->WriteFlowingBlock(utf8_decode('El Suscrito, Secretario de la Facultad de Ciencias Jurídicas de la Universidad Nacional ' . 'Autónoma de Honduras, por medio de la presente HACE CONSTAR: ')); $pdf->SetFont('Cambria', 'I', 14); $pdf->WriteFlowingBlock(utf8_decode('Que el(la) alumno(a)')); $pdf->SetFont('Cambria', 'BI', 14); $pdf->WriteFlowingBlock(utf8_decode(' ' . $nombreTemporal . ' ')); $pdf->SetFont('Cambria', 'I', 14);
@($persDb = $db_functions->get_person($family_id)); // *** Use person class *** $pers_cls = new person_cls(); $pers_cls->construct($persDb); $name = $pers_cls->person_name($persDb); $title = pdf_convert(__('Ancestor sheet') . __(' of ') . $name["standard_name"]); $pdf = new PDF(); $pdf->SetTitle($title); $pdf->SetAuthor('Huub Mons (pdf: Yossi Beck)'); $pdf->SetTopMargin(4); $pdf->SetAutoPageBreak(false); //$pdf->SetLineWidth(3); //$pdf->AddPage(); $pdf->AddPage("L"); $pdf->SetLeftMargin(16); $pdf->SetRightMargin(16); $pdf->SetFont('Arial', 'B', 12); $pdf->Ln(2); $name = $pers_cls->person_name($persDb); $pdf->MultiCell(0, 10, __('Ancestor sheet') . __(' of ') . $name["standard_name"], 0, 'C'); $pdf->Ln(2); $pdf->SetFont('Arial', '', 8); // Output the cells: $posy = $pdf->GetY(); $posx = $pdf->GetX(); // for each generation check if there is anyone, otherwise don't display those rows $exist = false; for ($x = 16; $x < 32; $x++) { if ($gedcomnumber[$x] != '') { $exist = true; }
/** * Export PDF document * * @param string $where WHERE clause for SQL statement */ function pdfexport($WHERE) { global $config; $ypos = $config['pdf_font_size']; // Match the font size for proper vertical offset $page_width = $config['pdf_page_width']; $margin = $config['pdf_margin']; $left_margin = $config['pdf_left_margin']; $right_margin = $config['pdf_right_margin']; $mediaimg_width = $config['pdf_image_media_width']; $font_size = $config['pdf_font_size']; $image_height = $config['pdf_image_height']; $image_width = $config['pdf_image_width']; $font_title = $config['pdf_font_title']; $font_plot = $config['pdf_font_plot']; $text_length = $config['pdf_text_length']; $tempfolder = cache_get_folder(''); if ($config['cache_pruning']) { cache_prune_folder($tempfolder, 3600, false, false, 'videodb*.pdf'); } $filename = $tempfolder . 'videodb' . date('His', time()) . '.pdf'; // setup pdf class $pdf = new PDF(); $pdf->Open($filename); $pdf->VerifyFont($font_title); $pdf->VerifyFont($font_title, 'B'); $pdf->VerifyFont($font_plot); $pdf->AddPage(); $pdf->SetRightMargin($right_margin); // add downscaling if ($config['pdf_scale']) { $pdf->Scale = $config['pdf_scale']; $pdf->max_width = $config['pdf_image_max_width']; $pdf->max_height = $config['pdf_image_max_height']; } // get data $result = iconv_array('utf-8', 'iso-8859-1', exportData($WHERE)); foreach ($result as $row) { set_time_limit(300); // rise per movie execution timeout limit if safe_mode is not set in php.ini $title = $row['title']; if ($row['subtitle']) { $title .= ' - ' . $row['subtitle']; } if ($row['diskid'] || $row['mediatype']) { $title .= ' ['; if ($row['mediatype']) { $title .= $row['mediatype'] . ', '; } if ($row['diskid']) { $title .= $row['diskid']; } $title = preg_replace('/, $/', '', $title) . ']'; } // get drilldown url for image $imdb = $row['imdbID']; $link = $imdb ? engineGetContentUrl($imdb, engineGetEngine($imdb)) : ''; // title $pdf->SetFont($font_title, 'B', $font_size); $pdf->SetXY($left_margin + $image_width + $margin, $ypos); $pdf->Cell(0, 0, $title, 0, 1, 'L', 0, $link); // [muddle] technical details unset($tech['V']); if ($row['video_width'] and $row['video_height']) { $vw = $row['video_width']; $vh = $row['video_height']; $tech['V'] = "Video: "; if ($vw > 1920) { $tech['V'] .= "UHD " . $vw . "x" . $vh; } elseif ($vw > 1280) { $tech['V'] .= "HD 1080p"; } elseif ($vw == 1280 or $vh == 720) { $tech['V'] .= "HD 720p"; } elseif ($vw == 720 or $vw == 704) { $tech['V'] .= "SD "; if ($vh == 480) { $tech['V'] .= "NTSC"; } elseif ($vh == 576) { $tech['V'] .= "PAL"; } else { $tech['V'] .= $vw . "x" . $vh; } } else { $tech['V'] .= "LORES " . $vw . "x" . $vh; } } unset($tech['A']); if ($row['audio_codec']) { $tech['A'] = "Audio: " . $row['audio_codec']; } unset($tech['D']); if ($row['created']) { $tech['D'] = "Date: " . $row['created']; } $techinfo = implode(", ", $tech); $pdf->SetFont($font_title, 'B', $font_size - 3); $pdf->SetXY($left_margin + $image_width + $margin, $ypos + 4); $pdf->Cell(0, 0, $techinfo, 0, 1, 'L', 0); // plot $plot = leftString($row['plot'], $text_length); $pdf->SetFont($font_plot, '', $font_size - 1); $pdf->SetXY($left_margin + $image_width + $margin, $ypos + 3 + 3); $pdf->SetLeftMargin($left_margin + $image_width + $margin); $pdf->WriteHTML($plot); // image $file = getThumbnail($row['imgurl']); if (preg_match('/^img.php/', $file)) { $file = img(); } // image file present? if ($file) { $pdf->Image($file, $left_margin, $ypos - 2, $image_width, $image_height, '', $link); } // add mediatype image if ($type_image = getMediaImage($row['mediatype'])) { $pdf->Image('./images/media/' . $type_image, $page_width - $mediaimg_width - $right_margin, $ypos - 2, $mediaimg_width, 0, '', ''); } // new position $ypos += $margin; if ($file or $plot) { $ypos += max($image_height, $font_size); } else { $ypos += $font_size; } if ($ypos > 250) { $ypos = $config['pdf_font_size']; $pdf->AddPage(); } } $pdf->Output('videoDB.pdf', 'D'); // get rid of temp file @unlink($filename); }