$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);
}
