/////////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();
