/////////medio $pdf->SetFont('Amble-Regular', '', 10); $pdf->Text(30, 42, maxCaracter(utf8_decode($cliente), 80), 1, 0, 'L', 0); /////cliente $pdf->Text(30, 48, maxCaracter(utf8_decode($fecha), 20), 1, 0, 'L', 0); /////fecha $pdf->Text(30, 53, maxCaracter(utf8_decode($direccion), 35), 1, 0, 'L', 0); ////direccion $pdf->Text(155, 42, maxCaracter(utf8_decode($ci_ruc), 20), 1, 0, 'L', 0); ////ruc ci $pdf->Text(155, 48, maxCaracter(utf8_decode($telefono), 20), 1, 0, 'L', 0); ////telefono if ($estado == 'Pasivo') { $pdf->SetTextColor(249, 33, 33); $pdf->RotatedImage('../images/circle.png', 110, 42, 30, 10, 45); $pdf->RotatedText(120, 41, 'ANULADO!', 45); $pdf->RotatedImage('../images/circle.png', 260, 42, 30, 10, 45); $pdf->RotatedText(269, 41, 'ANULADO!', 45); } ////////detalles $sql = pg_query("select cantidad,articulo,precio_venta,total_venta from detalle_factura_venta,productos where id_factura_venta = '" . $_GET['id'] . "' and detalle_factura_venta.cod_productos = productos.cod_productos and productos.incluye_iva= 'Si'"); $yy = 66; $iva_base = 1.12; $pdf->SetTextColor(0, 0, 0); while ($row = pg_fetch_row($sql)) { $total_si = 0; $total_sit = 0; $total_si = $row[3] / $iva_base; $total_sit = $total_si / $row[0]; $total_si = truncateFloat($total_si, 2); $total_sit = truncateFloat($total_sit, 2);
//creation du fichier pdf $pdf = new PDF(); $pdf->Open(); //$pdf->FPDF($orientation,$unit,$_GET['format']); //$format="A4"; //phpinfo(); //echo $_GET["format"]; $pdf->FPDF($orientation, $unit, $_GET['format']); //$pdf->FPDF('P','mm','A4'); //création page $pdf->AddFont('font1', '', 'font1.php'); $pdf->AddPage(); $pdf->RotatedImage('../tmp/' . $tex[0] . '.jpg', $posiximage, $posiyimage, $larimage, $hauimage, $angle); $pdf->SetFont('font1', '', $sizerosa); //echo $logo.",".$posixlogo.",".$posiylogo.",".$larlogo.",".$haulogo.",".$angle; $pdf->RotatedText($posixrosa, $posiyrosa, 'a', $angle); if ($logo != "") { if ($logo[0] != '/') { // Si le chemin du logo est relatif, le faire decouler de fs_root $pdf->RotatedImage($logo, $posixlogo, $posiylogo, $larlogo, $haulogo, $angle); } else { $pdf->RotatedImage($fs_root . "/" . $logo, $posixlogo, $posiylogo, $larlogo, $haulogo, $angle); } } $pdf->SetFont('arial', '', $sizetitre); $pdf->RotatedCell($angle, $xtitre, $ytitre, $wtitre, $htitre, $_GET['titre'], 0, 0, 'C'); $pdf->RotatedText(15, 15, $titre, 0); $pdf->SetFont('arial', '', $sizeechelle); if ($_GET['echelle'] == 0) { $pdf->RotatedText($posixechelle, $posiyechelle, 'Sans échelle', $angle); } else {
$pdf->Cell(30, 8, utf8_decode($fila[2]), 0, 1, 'C'); $pdf->SetX(172); $pdf->Cell(30, 8, utf8_decode($fila[0]), 0, 1, 'C'); $pdf->SetX(172); $pdf->Cell(30, 8, utf8_decode($fila[1]), 0, 1, 'C'); $pdf->SetX(172); $pdf->Cell(30, 8, '', 0, 1, 'C'); $pdf->SetX(172); $pdf->Cell(30, 8, utf8_decode($fila[3]), 0, 1, 'C'); $pdf->SetX(172); $pdf->Cell(30, 8, utf8_decode($fila[4]), 0, 1, 'C'); ////////////// if ($anulado == 1) { $pdf->SetFont('Arial', '', 12); $pdf->RotatedImage('../images/circle.png', 165, 30, 40, 16, 45); $pdf->RotatedText(178, 30, 'ANULADO!', 45); } if ($prod == 1 or $cont_prod == 1) { $pdf->AddPage(); $pdf->SetX(30); $pdf->SetY(10); $pdf->SetFont('Arial', '', 13); $pdf->Cell(200, 8, utf8_decode('Números de Serie'), 0, 1, 'C'); $sql = pg_query("select * FROM detalle_factura_venta,productos where productos.cod_productos=detalle_factura_venta.cod_productos and id_factura_venta='{$_GET['id']}'"); while ($row = pg_fetch_row($sql)) { $temp = ''; $temp1 = ''; $temp = $row[9]; $sql1 = pg_query("select * from serie_venta,factura_venta,productos where factura_venta.id_factura_venta=serie_venta.id_factura_venta and productos.cod_productos=serie_venta.cod_productos and serie_venta.id_factura_venta='{$_GET['id']}' and productos.cod_productos='{$row['2']}'"); if (pg_num_rows($sql1)) { while ($row1 = pg_fetch_row($sql1)) {
<?php require 'rotation.php'; class PDF extends PDF_Rotate { function RotatedText($x, $y, $txt, $angle) { //Rotation du texte autour de son origine $this->Rotate($angle, $x, $y); $this->Text($x, $y, $txt); $this->Rotate(0); } function RotatedImage($file, $x, $y, $w, $h, $angle) { //Rotation de l'image autour du coin supérieur gauche $this->Rotate($angle, $x, $y); $this->Image($file, $x, $y, $w, $h); $this->Rotate(0); } } $pdf = new PDF(); $pdf->AddPage(); $pdf->SetFont('Arial', '', 20); $pdf->RotatedImage('circle.png', 85, 60, 40, 16, 45); $pdf->RotatedText(100, 60, 'Hello !', 45); $pdf->Output();
$this->Rotate($angle, $x, $y); $this->Text($x, $y, $txt); $this->Rotate(0); } function RotatedImage($file, $x, $y, $w, $h, $angle) { //Image rotated around its upper-left corner $this->Rotate($angle, $x, $y); $this->Image($file, $x, $y, $w, $h); $this->Rotate(0); } } $pdf = new PDF(); $pdf->AddPage(); $pdf->SetFont('Arial', '', 8); $pdf->RotatedText(15, 11, utf8_decode('Je soussigné-e formatrice(formateur) au centre de formation certificie que le candidat(la candidate) a bien effectué en formation les activités et missions présentées dans ce tableau'), -90); $pdf->SetFont('Arial', '', 14); $pdf->RotatedText(200, 50, utf8_decode('BTS SERVICES INFORMATIQUES AUX ORGANISATIONS-TABLEAU DE SYNTHESE'), -90); $pdf->SetFont('Arial', '', 12); $pdf->RotatedText(180, 35, utf8_decode('Nom et prénom du candidat: ' . $nom . ' ' . $prenom . ' Parcours: ' . $parcours . ' Numéro du candidat: ' . $numeroINE), -90); $pdf->SetFont('Arial', '', 5); $pdf->SetX(30); $pdf->Cell(15, 4, '', 1, 0, ''); $pdf->SetDrawColor(235, 235, 235); $pdf->Cell(25, 4, '', 1, 0, ''); $pdf->SetDrawColor(0, 0, 0); $pdf->Cell(60, 4, '', 1, 0, ''); $pdf->RotatedText(140, 11, 'Situation obligatoire', -90); $pdf->Cell(20, 16, '', 1, 0, ''); $i = 0; foreach ($rowsObligatoire as $data) {
$pdf->Text(30, 82, maxCaracter(utf8_decode($ci_ruc), 20), 1, 0, 'L', 0); /////identificacion $pdf->Text(30, 87, maxCaracter(utf8_decode($direccion), 35), 1, 0, 'L', 0); ////direccion $pdf->Text(30, 93, maxCaracter(utf8_decode($telefono), 35), 1, 0, 'L', 0); ////telefono $pdf->Text(88, 92, maxCaracter(utf8_decode($ciudad), 35), 1, 0, 'L', 0); ////ciudad $pdf->Text(165, 77, maxCaracter(utf8_decode($fecha), 20), 1, 0, 'L', 0); ////fecha $pdf->Text(165, 82, maxCaracter(utf8_decode($pago), 20), 1, 0, 'L', 0); ////forma pago if ($estado == 'Pasivo') { $pdf->SetTextColor(249, 33, 33); $pdf->RotatedImage('../images/circle.png', 150, 42, 30, 10, 45); $pdf->RotatedText(160, 41, 'ANULADO!', 45); } // detalles factura $sql = pg_query("select cantidad,articulo,precio_venta,total_venta from detalle_factura_venta,productos where id_factura_venta = '" . $_GET['id'] . "' and detalle_factura_venta.cod_productos = productos.cod_productos and productos.incluye_iva= 'Si'"); $yy = 107; $iva_base = 1.12; $pdf->SetTextColor(0, 0, 0); while ($row = pg_fetch_row($sql)) { $total_si = 0; $total_sit = 0; $total_si = $row[3] / $iva_base; $total_sit = $total_si / $row[0]; $total_si = truncateFloat($total_si, 2); $total_sit = truncateFloat($total_sit, 2); // posiciones cantidad $pdf->Text(15, $yy, maxCaracter(utf8_decode($row[0]), 3), 0, 1, 'L', 0);
{ $this->Rotate($angle, $x, $y); $this->Image($file, $x, $y, $w, $h); $this->Rotate(0); } } $pdf = new PDF(); $pdf->FPDF('L', 'mm', 'Legal'); $pdf->AddPage(); $pdf->SetFont('Arial', '', 6); $x = 15; $y = 33; $pdf->Image($_SESSION["path"] . '/logo.jpg', 10, 6, 15); if (count($ramos) > 0) { foreach ($ramos as $nom_ramo => $datos_ramo) { $pdf->RotatedText(100 + $x, $y, $nom_ramo, 30); $x = $x + 7; } } $pdf->SetTextColor(255, 0, 0); $pdf->RotatedText(100 + $x, $y, "PROMEDIO FINAL", 30); $pdf->SetTextColor(0, 0, 0); $pdf->RotatedText(107 + $x, $y, "RELIGION", 30); $pdf->RotatedText(114 + $x, $y, "ASISTENCIA %", 30); $pdf->SetTextColor(0, 0, 0); $pdf->SetFont('Arial', '', 16); $pdf->Cell(15, 5, " ", 0, 0); $pdf->Cell(20, 5, $titulo . " ", 0, 1); $pdf->Cell(15, 5, " ", 0, 0); $pdf->Cell(20, 5, mostrar_curso($curso, true), 0, 1); $pdf->SetFont('Arial', '', 10);
$pdf->Cell(10, $zelle, CLMText::tiebrFormat($liga[0]->tiebr1, $punkte[$x]->sumtiebr1), 0, 0, 'C'); } if ($liga[0]->tiebr2 > 0) { $pdf->Cell(10, $zelle, CLMText::tiebrFormat($liga[0]->tiebr1, $punkte[$x]->sumtiebr2), 0, 0, 'C'); } if ($liga[0]->tiebr3 > 0) { $pdf->Cell(10, $zelle, CLMText::tiebrFormat($liga[0]->tiebr1, $punkte[$x]->sumtiebr3), 0, 0, 'C'); } $pdf->Cell(1, $zelle + 1, "", 'R', 0, 'C'); $pdf->SetFont('Symbol', '', $font); if ($x < $liga[0]->auf) { $pdf->Cell(6, $zelle, chr(221), 0, 1, 'C'); } elseif ($x >= $liga[0]->auf and $x < $liga[0]->auf + $liga[0]->auf_evtl) { $xxp = $pdf->GetX() + 2; $yyp = $pdf->GetY() + 2; $pdf->RotatedText($xxp, $yyp, chr(221), 315); $pdf->Cell(6, $zelle, '', 0, 1, 'C'); } elseif ($x >= $liga[0]->teil - ($liga[0]->ab_evtl + $liga[0]->ab) and $x < $liga[0]->teil - $liga[0]->ab) { $xxp = $pdf->GetX() + 4; $yyp = $pdf->GetY() + 4; $pdf->RotatedText($xxp, $yyp, chr(223), 45); $pdf->Cell(6, $zelle, '', 0, 1, 'C'); } elseif ($x >= $liga[0]->teil - $liga[0]->ab) { $pdf->Cell(6, $zelle, chr(223), 0, 1, 'C'); } else { $pdf->Cell(10, $zelle, '', 0, 1, 'C'); } $pdf->SetFont('Times', '', $font); } if (!$cr) { $pdf->SetX($xx1);
$this->Image($file, $x, $y, $w, $h); $this->Rotate(0); } } $dbh = mysql_connect($host, $usuariodb, $clave) or die('I cannot connect to the database because: ' . mysql_error()); mysql_select_db($db); $sql = 'select * from ramos where `curso` =' . "'" . $curso . "'" . ' AND nombre <> \'RELIGION\' ORDER BY num'; $result = mysql_query($sql, $dbh); $pdf = new PDF(); $pdf->FPDF('L', 'mm', 'Legal'); $pdf->AddPage(); $pdf->SetFont('Arial', '', 8); $x = 15; while ($row = mysql_fetch_array($result)) { $nombreramo = $row["nombre"]; $pdf->RotatedText(100 + $x, 33, $nombreramo, 30); $x = $x + 7; } $pdf->SetTextColor(255, 0, 0); $pdf->RotatedText(100 + $x, 33, "Promedio Final", 30); $pdf->SetTextColor(0, 0, 0); $pdf->RotatedText(107 + $x, 33, "Religión", 30); $pdf->RotatedText(114 + $x, 33, "Asistencia", 30); $sql = 'select * from alumnos where `curso` =' . "'" . $curso . "'" . "ORDER BY matricula"; $result = mysql_query($sql, $dbh); $pdf->SetFont('Arial', '', 16); $pdf->Cell(20, 5, "Planilla Anual " . mostrar_curso($curso), 0); $pdf->ln(); $pdf->ln(); $pdf->ln(); $pdf->ln();