private function printPDF($customer_id, $post_device, $post_user, $comment, $username, $randomcode, $date) { require_once Mage::getBaseDir('lib') . '/tcpdf/tcpdf.php'; // create new PDF docume, nt $pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); // set font $pdf->SetFont('helvetica', '', 11); // add a page $pdf->AddPage(); $pdf->setJPEGQuality(100); // set cell padding $pdf->setCellPaddings(0, 0, 0, 0); $pdf->SetLineWidth(0.2); // set cell margins $pdf->setCellMargins(0, 0, 0, 0); $pdf->setCellHeightRatio(1); // set color for background $pdf->SetFillColor(255, 255, 255); // Multicell // MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0) // Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=0, $link='', $stretch=0, $ignore_min_height=false, $calign='T', $valign='M') $pdf->SetFont('helvetica', '', 11); $pdf->MultiCell(50, 0, 'SERVISNI LIST - REVERS', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->SetFont('helvetica', '', 8); $pdf->MultiCell(100, 0, 'GAMEBOX, Cara Dušana 47, Niš - tel 018/514-666 - 060/514-666-0', 0, 'L', 1, 0, 80, $pdf->getY() + 1, true, 0, false); // Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false) // $pdf->Image(dirname(__FILE__). '/bcimages/'. $randkey . '.png',80,8,100,8,'','','',true); $pdf->Image(Mage::getBaseDir('media') . '/pdf/gbr.png', 182, 10, 20, 60, '', '', '', true); $pdf->Ln(); $pdf->Ln(); $pdf->SetFont('helvetica', '', 8); $pdf->Cell(70, 6, 'Naziv uredjaja', 0, 0, 'L', 0); $pdf->Cell(40, 6, 'Serijski broj', 0, 0, 'L', 0); $pdf->Cell(60, 6, 'Opis kvara', 0, 0, 'L', 0); $pdf->Ln(); $i = 1; foreach ($post_device as $key => $post) { if ($i == 1) { $pdf->MultiCell(70, 6, ' ' . $i . '. ' . $post['name'], 'LT', 'L', 1, 0, 10, '', true, 0, false); $pdf->MultiCell(40, 6, $post['sn'], 'T', 'L', 1, 0, 80, '', true, 0, false); $pdf->MultiCell(60, 6, $post['description'], 'TR', 'L', 1, 0, 120, '', true, 0, false); } else { $pdf->MultiCell(70, 6, ' ' . $i . '. ' . $post['name'], 'L', 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(40, 6, $post['sn'], 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(60, 6, $post['description'], 'R', 'L', 1, 0, '', '', true, 0, false); } $pdf->Ln(); ++$i; } //$pdf->MultiCell(70, 15, ' 1. ' . $naziv1, 'LT', 'L', 1, 0, 10, '', true, 0, false); //$pdf->MultiCell(40, 15, $_POST['sn1'], 'T', 'L', 1, 0, 80, '', true, 0, false); //$pdf->MultiCell(60, 15, $opis1, 'TR', 'L', 1, 0, 120, '', true, 0, false); //$pdf->Ln(); $pdf->MultiCell(70, 1, ' ', 'LB', 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(40, 1, ' ', 'B', 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(60, 1, ' ', 'RB', 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->Cell(70, 6, 'Dodatna uputstva / komentari', 0, 0, 'L', 0); $pdf->Ln(); $pdf->MultiCell(170, 5, $comment, 'TRLB', 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->Cell(70, 6, 'Na servis predao', 0, 0, 'L', 0); $pdf->Ln(); $pdf->Ln(); $pdf->MultiCell(20, 6, 'Ime:', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 6, $post_user['name'], 0, 'L', 1, 0, 25, '', true, 0, false); $pdf->MultiCell(50, 6, 'Datum i vreme prijema:', 0, 'L', 1, 0, 70, '', true, 0, false); $pdf->MultiCell(50, 6, $date, 0, 'L', 1, 0, 100, '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(20, 6, 'Email:', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 6, $post_user['email'], 0, 'L', 1, 0, 25, '', true, 0, false); $pdf->MultiCell(50, 6, 'Kontrolni kod:', 0, 'L', 1, 0, 70, '', true, 0, false); $pdf->MultiCell(50, 6, $randomcode, 0, 'L', 1, 0, 100, '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(20, 6, 'Telefon:', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 6, $post_user['phone'], 0, 'L', 1, 0, 25, '', true, 0, false); $pdf->MultiCell(120, 6, 'Pratite stanje Vašeg uredjaja na servisu.<br>Posetite <b>http://proveraservisa.gamebox.co.rs/</b> i unesite Vaš kontrolni kod<br />ili skenirajte <b>QR</b> kod pomocu Vašeg mobilnog telefona', 0, 'L', 1, 0, 70, '', true, 0, true); $pdf->Ln(); $pdf->Ln(3); $pdf->MultiCell(110, 10, "\n" . Mage::getStoreConfig('servisnilist/text/upozorenje'), 1, 'C', 1, 0, 50, '', true, 0, false); $pdf->Ln(); if (count($post_device) == 1) { $pdf->Ln(); } $pdf->Ln(5); $pdf->Image(Mage::getBaseDir('media') . '/pdf/cut-here.png', 3, '', 250, 3, '', '', '', false, 300, '', false, false, 0, true); $pdf->Ln(9); $x = $pdf->GetX(); $y = $pdf->GetY(); // bottom part $pdf->SetFont('helvetica', '', 11); $pdf->MultiCell(50, 8, 'SERVISNI LIST - REVERS', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->SetFont('helvetica', '', 8); $pdf->MultiCell(100, 0, 'GAMEBOX, Cara Dušana 47, Niš - tel 018/514-666 - 060/514-666-0', 0, 'L', 1, 0, 80, '', true, 0, false); $pdf->Ln(); $pdf->Ln(); $pdf->SetFont('helvetica', '', 8); $pdf->Cell(70, 6, 'Naziv uredjaja', 0, 0, 'L', 0); $pdf->Cell(40, 6, 'Serijski broj', 0, 0, 'L', 0); $pdf->Cell(60, 6, 'Opis kvara', 0, 0, 'L', 0); $pdf->Ln(); $i = 1; foreach ($post_device as $key => $post) { if ($i == 1) { $pdf->MultiCell(70, 6, ' ' . $i . '. ' . $post['name'], 'LT', 'L', 1, 0, 10, '', true, 0, false); $pdf->MultiCell(40, 6, $post['sn'], 'T', 'L', 1, 0, 80, '', true, 0, false); $pdf->MultiCell(60, 6, $post['description'], 'TR', 'L', 1, 0, 120, '', true, 0, false); } else { $pdf->MultiCell(70, 6, ' ' . $i . '. ' . $post['name'], 'L', 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(40, 6, $post['sn'], 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(60, 6, $post['description'], 'R', 'L', 1, 0, '', '', true, 0, false); } $pdf->Ln(); ++$i; } $pdf->MultiCell(70, 1, ' ', 'LB', 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(40, 1, ' ', 'B', 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(60, 1, ' ', 'RB', 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->Cell(70, 6, 'Dodatna uputstva / komentari', 0, 0, 'L', 0); $pdf->Ln(); $pdf->MultiCell(170, 5, $comment, 'TRLB', 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->Cell(70, 6, 'Obracun', 0, 0, 'L', 0); $pdf->Ln(); $pdf->Cell(90, 6, 'Materijal', 0, 0, 'L', 0); $pdf->Cell(20, 6, 'j. mere', 0, 0, 'L', 0); $pdf->Cell(15, 6, 'kolicina', 0, 0, 'L', 0); $pdf->Cell(20, 6, 'cena', 0, 0, 'L', 0); $pdf->Cell(25, 6, 'UKUPNO', 0, 0, 'L', 0); $pdf->Ln(); $pdf->Cell(90, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(20, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(15, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(20, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(25, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Ln(); $pdf->Cell(90, 6, 'Opis usluge', 0, 0, 'L', 0); $pdf->Cell(20, 6, 'j. mere', 0, 0, 'L', 0); $pdf->Cell(15, 6, 'kolicina', 0, 0, 'L', 0); $pdf->Cell(20, 6, 'cena', 0, 0, 'L', 0); $pdf->Cell(25, 6, 'UKUPNO', 0, 0, 'L', 0); $pdf->Ln(); $pdf->Cell(90, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(20, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(15, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(20, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Cell(25, 5, ' ', 'TRLB', 0, 'L', 0); $pdf->Ln(); $pdf->MultiCell(60, 6, 'SVEGA:', 'B', 'L', 1, 0, 120, $pdf->getY() + 1, true, 0, false); $pdf->Ln(); $pdf->Cell(70, 6, 'Na servis predao', 0, 0, 'L', 0); $pdf->Ln(); $pdf->MultiCell(20, 6, 'Ime:', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 6, $post_user['name'], 0, 'L', 1, 0, 25, '', true, 0, false); $pdf->MultiCell(50, 6, 'Datum i vreme prijema:', 0, 'L', 1, 0, 70, '', true, 0, false); $pdf->MultiCell(50, 6, $date, 0, 'L', 1, 0, 100, '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(20, 6, 'Email:', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 6, $post_user['email'], 0, 'L', 1, 0, 25, '', true, 0, false); $pdf->MultiCell(50, 6, 'Kontrolni kod:', 0, 'L', 1, 0, 70, '', true, 0, false); $pdf->MultiCell(50, 6, $randomcode, 0, 'L', 1, 0, 100, '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(20, 6, 'Telefon:', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 6, $post_user['phone'], 0, 'L', 1, 0, 25, '', true, 0, false); //$pdf->Image(dirname(__FILE__) . '/bcimages/' . $randkey . '.png', 66, $pdf->getY() - 2, 100, 8, '', '', '', true, 300, '', false, false, 0, false); // $pdf->MultiCell(120, 6, 'Pratite stanje Vaseg uredjaja na servisu.<br>Posetite <b>http://bengazi.com/proveraservisa</b> i unesite Vas kontrolni kod' ,0, 'L', 1, 0, 70, '', true, 0, true); $pdf->Ln(); $pdf->MultiCell(20, 6, 'Potpis:', 0, 'L', 1, 0, '', '', true, 0, false); // CODE 128 B // define barcode style $style1d = array('position' => 'S', 'align' => 'C', 'stretch' => false, 'fitwidth' => true, 'cellfitalign' => '', 'border' => false, 'hpadding' => '35', 'vpadding' => '30', 'fgcolor' => array(0, 0, 0), 'bgcolor' => false, 'text' => false, 'font' => 'helvetica', 'fontsize' => 8, 'stretchtext' => 4); $pdf->setXY(180, $y + 35); //155 $pdf->StartTransform(); $pdf->Rotate(90); $pdf->write1DBarcode($randomcode, 'C128B', '', '', '', 14, 0.5, $style1d, 'T'); $pdf->StopTransform(); // new style $styleQR = array('border' => false, 'padding' => 0, 'fgcolor' => array(0, 0, 0), 'bgcolor' => false); // QRCODE,H : QR-CODE Best error correction $pdf->write2DBarcode('http://proveraservisa.gamebox.co.rs/?kk=' . $randomcode, 'QRCODE,H', 184, 75, 50, 50, $styleQR, 'N'); // QRCODE,H : QR-CODE Best error correction $pdf->write2DBarcode(Mage::getBaseUrl() . 'servisnilist/status/qr/slid/' . $customer_id, 'QRCODE,H', 184, $y + 65, 50, 50, $styleQR, 'N'); // Close and output PDF document $pdf->IncludeJS('print();'); // die('y'); //ob_clean(); //stupid tcpdf need this $pdf->Output('trt.pdf', 'I'); exit; }
public function testPdfOutput() { // create new PDF document $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('Nicola Asuni'); $pdf->SetTitle('TCPDF Example 009'); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // set default header data $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 009', PDF_HEADER_STRING); // set header and footer fonts $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); // set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->SetHeaderMargin(PDF_MARGIN_HEADER); $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); // set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); // set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); // set some language-dependent strings (optional) $pdf->setLanguageArray($this->langSettings); // ------------------------------------------------------------------- // add a page $pdf->AddPage(); // set JPEG quality $pdf->setJPEGQuality(75); // Image method signature: // Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false) // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Example of Image from data stream ('PHP rules') $imgdata = base64_decode('iVBORw0KGgoAAAANSUhEUgAAABwAAAASCAMAAAB/2U7WAAAABlBMVEUAAAD///+l2Z/dAAAASUlEQVR4XqWQUQoAIAxC2/0vXZDrEX4IJTRkb7lobNUStXsB0jIXIAMSsQnWlsV+wULF4Avk9fLq2r8a5HSE35Q3eO2XP1A1wQkZSgETvDtKdQAAAABJRU5ErkJggg=='); // The '@' character is used to indicate that follows an image data stream and not an image file name $pdf->Image('@' . $imgdata); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Image example with resizing $pdf->Image('./tests/images/image_demo.jpg', 15, 140, 75, 113, 'JPG', 'http://www.tcpdf.org', '', true, 150, '', false, false, 1, false, false, false); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // test fitbox with all alignment combinations $horizontal_alignments = array('L', 'C', 'R'); $vertical_alignments = array('T', 'M', 'B'); $x = 15; $y = 35; $w = 30; $h = 30; // test all combinations of alignments for ($i = 0; $i < 3; ++$i) { $fitbox = $horizontal_alignments[$i] . ' '; $x = 15; for ($j = 0; $j < 3; ++$j) { $fitbox[1] = $vertical_alignments[$j]; $pdf->Rect($x, $y, $w, $h, 'F', array(), array(128, 255, 128)); $pdf->Image('./tests/images/image_demo.jpg', $x, $y, $w, $h, 'JPG', '', '', false, 300, '', false, false, 0, $fitbox, false, false); $x += 32; // new column } $y += 32; // new row } $x = 115; $y = 35; $w = 25; $h = 50; for ($i = 0; $i < 3; ++$i) { $fitbox = $horizontal_alignments[$i] . ' '; $x = 115; for ($j = 0; $j < 3; ++$j) { $fitbox[1] = $vertical_alignments[$j]; $pdf->Rect($x, $y, $w, $h, 'F', array(), array(128, 255, 255)); $pdf->Image('./tests/images/image_demo.jpg', $x, $y, $w, $h, 'JPG', '', '', false, 300, '', false, false, 0, $fitbox, false, false); $x += 27; // new column } $y += 52; // new row } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Stretching, position and alignment example $pdf->SetXY(110, 200); $pdf->Image('./tests/images/image_demo.jpg', '', '', 40, 40, '', '', 'T', false, 300, '', false, false, 1, false, false, false); $pdf->Image('./tests/images/image_demo.jpg', '', '', 40, 40, '', '', '', false, 300, '', false, false, 1, false, false, false); $this->comparePdfs($pdf); }
function student_kolizijapdf() { global $userid; require_once 'lib/tcpdf/tcpdf.php'; $semestar = intval($_REQUEST['semestar']); if ($semestar == 1) { $tekst_semestar = "zimskom"; } else { $tekst_semestar = "ljetnjem"; } // Prikupljam podatke iz baze // Za koju godinu se prijavljuje? $q1 = myquery("select id, naziv from akademska_godina where aktuelna=1"); $q2 = myquery("select id, naziv from akademska_godina where id>" . mysql_result($q1, 0, 0) . " order by id limit 1"); if (mysql_num_rows($q2) < 1) { // nicemessage("U ovom trenutku nije aktiviran upis u sljedeću akademsku godinu."); // return; // Pretpostavljamo da se upisuje u aktuelnu? $zagodinu = mysql_result($q1, 0, 0); $agnaziv = mysql_result($q1, 0, 1); $q3 = myquery("select id from akademska_godina where id<{$zagodinu} order by id desc limit 1"); $proslagodina = mysql_result($q3, 0, 0); } else { $proslagodina = mysql_result($q1, 0, 0); $zagodinu = mysql_result($q2, 0, 0); $agnaziv = mysql_result($q2, 0, 1); } // Koji je odsjek? $q4 = myquery("select s.id, s.naziv, i.naziv, ss.semestar from studij as s, student_studij as ss, institucija as i where ss.student={$userid} and ss.studij=s.id and s.institucija=i.id and ss.akademska_godina={$proslagodina} order by semestar desc limit 1"); if (mysql_num_rows($q4) < 1) { // Očito da su aktuelna i prošla godina loše određene $q4 = myquery("select s.id, s.naziv, i.naziv, ss.semestar, ss.akademska_godina from studij as s, student_studij as ss, institucija as i where ss.student={$userid} and ss.studij=s.id and s.institucija=i.id order by akademska_godina desc, semestar desc limit 1"); if (mysql_num_rows($q4) < 1) { biguglyerror("Nikada niste bili nas student!"); return; } $proslagodina = mysql_result($q4, 0, 4); if (mysql_num_rows($q2) < 1) { biguglyerror("Nije kreirana nova akademska godina u koju se upisujete."); print "Kontaktirajte administratora."; return; } $q2 = myquery("select id, naziv from akademska_godina where id>{$proslagodina} order by id limit 1"); $zagodinu = mysql_result($q2, 0, 0); $agnaziv = mysql_result($q2, 0, 1); } $studij = mysql_result($q4, 0, 0); $studij_naziv = mysql_result($q4, 0, 1); $institucija_naziv = mysql_result($q4, 0, 2); $godina_studija = ceil(mysql_result($q4, 0, 3) / 2); // Da li je student popunio ugovor za drugi odsjek? $tekst_mijenja = ""; $q7 = myquery("select s.id, s.naziv, i.naziv from studij as s, ugovoroucenju as uou, institucija as i where uou.student={$userid} and uou.studij=s.id and s.institucija=i.id and uou.akademska_godina={$zagodinu}"); if (mysql_num_rows($q7) > 1 && $studij != mysql_result($q7, 0, 0)) { $institucija_naziv = mysql_result($q7, 0, 2); $tekst_mijenja = "predao sam zahtjev za promjenu studija na " . mysql_result($q7, 0, 1) . ". S tim u vezi, "; } // Zapis u tabeli kolizija $predmeti_kolizija = $predmeti_ects = array(); $q10 = myquery("select p.id, p.naziv, p.ects from kolizija as k, predmet as p where k.student={$userid} and k.akademska_godina={$zagodinu} and k.semestar={$semestar} and k.predmet=p.id"); if (mysql_num_rows($q10) < 1) { biguglyerror("Vi niste popunili Zahtjev za koliziju za {$agnaziv} godinu!"); print "Ako je ovo greska, kontaktirajte administratora."; return; } while ($r10 = mysql_fetch_row($q10)) { $predmeti_kolizija[$r10[0]] = $r10[1]; $predmeti_ects[$r10[0]] = $r10[2]; } if ($semestar == 1) { $s2 = 1; } else { $s2 = 0; } // Predmeti koje nije polozio $predmeti_prenos = array(); $q20 = myquery("select p.id, p.naziv, p.ects from student_predmet as sp, ponudakursa as pk, predmet as p where sp.student={$userid} and sp.predmet=pk.id and pk.predmet=p.id and pk.akademska_godina={$proslagodina} and pk.semestar MOD 2={$s2} and pk.semestar<{$godina_studija}*2+1 and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id and ko.ocjena != 5)=0"); while ($r20 = mysql_fetch_row($q20)) { if (array_key_exists($r20[0], $predmeti_kolizija)) { continue; } $predmeti_prenos[$r20[0]] = $r20[1]; $predmeti_ects[$r20[0]] = $r20[2]; } // Podaci o studentu $q30 = myquery("select ime, prezime, brindexa, spol from osoba where id={$userid}"); $ime = mysql_result($q30, 0, 0); $prezime = mysql_result($q30, 0, 1); $brindexa = mysql_result($q30, 0, 2); $spol = mysql_result($q30, 0, 3); if ($spol == "") { $spol = spol(mysql_result($q30, 0, 0)); } if ($spol == "M") { $student = "student"; $polozio = "položio"; } else { $student = "studentica"; $polozio = "položila"; } ?> <html> <head> <title>Zahtjev za koliziju</title> </head> <body> <p>Univerzitet u Sarajevu<br> Elektrotehnički fakultet Sarajevo<br> <?php echo $institucija_naziv; ?> </p> <p> </p> <p>Student: <?php echo "{$ime} {$prezime} ({$brindexa})"; ?> </p> <p> </p> <p><b>Predmet: ZAHTJEV ZA KOLIZIJU</b></p> <p> </p> <p>Ja, <?php echo "{$ime} {$prezime}"; ?> , <?php echo $student; ?> studija <?php echo $studij_naziv; ?> , <?php echo $godina_studija; ?> . godina, broj indexa <?php echo $brindexa; ?> , <?php echo $tekst_mijenja; ?> molim Vas da mi u skladu sa Zakonom o visokom obrazovanju Kantona Sarajevo, u <?php echo $tekst_semestar; ?> semestru akademske <?php echo $agnaziv; ?> godine odobrite slušanje sljedećih predmeta sa <?php echo $godina_studija + 1; ?> . godine studija u koliziji:</p> <ul> <?php foreach ($predmeti_kolizija as $id => $predmet) { print "<li>{$predmet} (" . $predmeti_ects[$id] . " ECTS)</li>\n"; } ?> </ul> <p> </p> <p>Obzirom da sa <?php echo $godina_studija; ?> . godine studija nisam <?php echo $polozio; ?> sljedeće predmete:</p> <ul> <?php foreach ($predmeti_prenos as $id => $predmet) { print "<li>{$predmet} (" . $predmeti_ects[$id] . " ECTS)</li>\n"; } ?> </ul> te da se jedan predmet prenosi, nije prekoračen maksimalan broj od 30 ECTS kredita po semestru.</p> <p> </p> <p>U nadi da ćete udovoljiti mom zahtjevu,</p> <p> </p> <table border="0"><tr><td width="100%"> </td><td align="right"><p> </p><p>_____________________________________</p></td></tr> <tr><td width="100%"> </td><td align="center"><?php echo "{$ime} {$prezime}"; ?> </td></tr></table> </body> </html> <?php return; $q5 = myquery("select uu.id, s.id, s.naziv, s.naziv_en, uu.semestar, s.tipstudija from ugovoroucenju as uu, studij as s where uu.student={$userid} and uu.akademska_godina={$zagodinu} and uu.studij=s.id order by semestar desc limit 1"); if (mysql_num_rows($q5) < 1) { niceerror("Nije kreiran ugovor o učenju za studenta."); return; } $ugovorid = mysql_result($q5, 0, 0); $studij = mysql_result($q5, 0, 1); $studijbos = mysql_result($q5, 0, 2); $studijbos = substr($studijbos, 0, strpos($studijbos, "(") - 1); $studijeng = mysql_result($q5, 0, 3); $sem2 = mysql_result($q5, 0, 4); $tipstudija = mysql_result($q5, 0, 5); $sem1 = $sem2 - 1; $godina = $sem2 / 2; // Ostali podaci o osobi $q10 = myquery("select ime, prezime, brindexa from osoba where id={$userid}"); $imeprezime = mysql_result($q10, 0, 0) . " " . mysql_result($q10, 0, 1); $brindexa = mysql_result($q10, 0, 2); // Najnoviji plan za odabrani studij $q6 = myquery("select godina_vazenja from plan_studija where studij={$studij} order by godina_vazenja desc limit 1"); if (mysql_num_rows($q6) < 1) { niceerror("Nepostojeći studij"); return; } $najnoviji_plan = mysql_result($q6, 0, 0); // Da li je ponovac? $q20 = myquery("select semestar from student_studij where student={$userid} and studij={$studij} and akademska_godina={$proslagodina} order by semestar desc limit 1"); if ($sem1 > mysql_result($q20, 0, 0)) { $ponovac = 0; } else { $ponovac = 1; } // Odredjujemo da li ima prenesenih predmeta // TODO: ovo sada ne radi za izborne predmete $q20 = myquery("select p.sifra, p.naziv, p.ects, ps.semestar from predmet as p, plan_studija as ps where ps.godina_vazenja={$najnoviji_plan} and ps.studij={$studij} and (ps.semestar=" . ($sem1 - 1) . " or ps.semestar=" . ($sem1 - 2) . ") and ps.obavezan=1 and ps.predmet=p.id and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); if (mysql_num_rows($q20) > 1) { niceerror("Nemate uslove za upis {$godina}. godine studija"); print "Sačekajte da prikupite uslov ili popunite Ugovor za prethodnu godinu studija."; return; } if (mysql_num_rows($q20) == 1) { $ima_preneseni = 1; $preneseni_sifra = mysql_result($q20, 0, 0); $preneseni_naziv = mysql_result($q20, 0, 1); $preneseni_ects = mysql_result($q20, 0, 2); $preneseni_semestar = mysql_result($q20, 0, 3); } else { $ima_preneseni = 0; } // Privremeni hack za master if ($tipstudija == 3) { $mscfile = "-msc"; } else { if ($tipstudija == 2) { $mscfile = ""; } } // Ako čovjek upisuje prvu godinu nečeka (mastera), broj indexa je netačan! if ($godina == 1) { $brindexa = ""; } // ----- Pravljenje PDF dokumenta $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // set document information $pdf->SetCreator("Zamger"); $pdf->SetTitle('Domestic Learning Agreement / Ugovor o ucenju'); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(0, 0, 0); //set auto page breaks $pdf->SetAutoPageBreak(false); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO*2.083333); $pdf->setJPEGQuality(100); //set some language-dependent strings $pdf->setLanguageArray($l); // --------------------------------------------------------- // set font $pdf->SetFont('freesans', 'B', 9); $pdf->SetHeaderData("", 0, "", ""); $pdf->SetPrintHeader(false); $pdf->SetPrintFooter(false); // add a page $pdf->AddPage(); // $pdf->Image("images/content/150dpi/ETF-Domestic-contract-PGS-ALL-0.png",210,297,0,0,'','','',true,150); $pdf->Image("images/content/150dpi/domestic-contract{$mscfile}-0.png", 0, 0, 210, 0, '', '', '', true, 150); $pdf->SetXY(175, 34); $pdf->Cell(23, 0, $agnaziv, 0, 0, 'C'); $pdf->SetXY(175, 42); $pdf->Cell(23, 0, $godina . ".", 0, 0, 'C'); $pdf->SetXY(175, 50); $pdf->Cell(23, 0, $sem1 . ". & " . $sem2, 0, 0, 'C'); $pdf->SetXY(70, 48); $pdf->Cell(100, 0, $studijeng, 0, 0); $pdf->SetXY(70, 52); $pdf->Cell(100, 0, $studijbos, 0, 0); $pdf->SetXY(70, 62); $pdf->Cell(100, 0, $imeprezime); $pdf->SetXY(70, 69); $pdf->Cell(100, 0, $brindexa); // PRVI SEMESTAR $pdf->AddPage(); $pdf->Image("images/content/150dpi/domestic-contract{$mscfile}-1.png", 0, 0, 210); $pdf->SetXY(175, 34); $pdf->Cell(23, 0, $agnaziv, 0, 0, 'C'); $pdf->SetXY(175, 42); $pdf->Cell(23, 0, $godina . ".", 0, 0, 'C'); $pdf->SetXY(175, 50); $pdf->Cell(23, 0, $sem1 . ".", 0, 0, 'C'); $pdf->SetXY(70, 48); $pdf->Cell(100, 0, $studijeng, 0, 0); $pdf->SetXY(70, 52); $pdf->Cell(100, 0, $studijbos, 0, 0); $pdf->SetXY(70, 62); $pdf->Cell(100, 0, $imeprezime); $pdf->SetXY(70, 69); $pdf->Cell(100, 0, $brindexa); // Spisak obaveznih predmeta na neparnom semestru // Ako je ponovac, ne prikazujemo predmete koje je polozio if ($ponovac == 1) { $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$najnoviji_plan} and ps.studij={$studij} and ps.semestar={$sem1} and ps.obavezan=1 and ps.predmet=p.id and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { // Ako nije, trebamo prikazati one koje je položio u koliziji $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$najnoviji_plan} and ps.studij={$studij} and ps.semestar={$sem1} and ps.obavezan=1 and ps.predmet=p.id"); } $ykoord = 95; $ects = 0; while ($r100 = mysql_fetch_row($q100)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r100[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r100[1]); $e = "{$r100['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r100[2]; } // Da li je prenesen predmet na neparnom semestru? if ($ima_preneseni && $preneseni_semestar % 2 == 1) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $preneseni_sifra); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $preneseni_naziv); $e = "{$preneseni_ects}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $preneseni_ects; } // Spisak izbornih predmeta if ($ponovac == 1) { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem1} and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem1}"); } $ykoord = 123; while ($r110 = mysql_fetch_row($q110)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r110[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r110[1]); $e = "{$r110['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r110[2]; } // Suma ects if (!strchr($ects, ".")) { $ects .= ".0"; } $pdf->SetXY(170, 135); $pdf->Cell(100, 0, $ects); // DRUGI SEMESTAR $pdf->AddPage(); $pdf->Image("images/content/150dpi/domestic-contract{$mscfile}-2.png", 0, 0, 210); $pdf->SetXY(175, 34); $pdf->Cell(23, 0, $agnaziv, 0, 0, 'C'); $pdf->SetXY(175, 42); $pdf->Cell(23, 0, $godina . ".", 0, 0, 'C'); $pdf->SetXY(175, 50); $pdf->Cell(23, 0, $sem2 . ".", 0, 0, 'C'); $pdf->SetXY(70, 48); $pdf->Cell(100, 0, $studijeng, 0, 0); $pdf->SetXY(70, 52); $pdf->Cell(100, 0, $studijbos, 0, 0); $pdf->SetXY(70, 62); $pdf->Cell(100, 0, $imeprezime); $pdf->SetXY(70, 69); $pdf->Cell(100, 0, $brindexa); // Spisak obaveznih predmeta na parnom semestru if ($ponovac == 1) { $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$najnoviji_plan} and ps.studij={$studij} and ps.semestar={$sem2} and ps.obavezan=1 and ps.predmet=p.id and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$najnoviji_plan} and ps.studij={$studij} and ps.semestar={$sem2} and ps.obavezan=1 and ps.predmet=p.id"); } $ykoord = 95; $ects = 0; while ($r100 = mysql_fetch_row($q100)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r100[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r100[1]); $e = "{$r100['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r100[2]; } // Da li je prenesen predmet na parnom semestru? if ($ima_preneseni && $preneseni_semestar % 2 == 0) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $preneseni_sifra); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $preneseni_naziv); $e = "{$preneseni_ects}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $preneseni_ects; } // Spisak izbornih predmeta if ($ponovac == 1) { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem2} and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem2}"); } $ykoord = 123; while ($r110 = mysql_fetch_row($q110)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r110[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r110[1]); $e = "{$r110['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r110[2]; } // Suma ects if (!strchr($ects, ".")) { $ects .= ".0"; } $pdf->SetXY(170, 135); $pdf->Cell(100, 0, $ects); // --------------------------------------------------------- //Close and output PDF document $pdf->Output('ugovor_o_ucenju.pdf', 'I'); //============================================================+ // END OF FILE //============================================================+ }
function createPdfFromImage($arrImagename, $strFilename) { $this->load->library('tcpdf/TCPDF'); $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); $pdf->SetCreator(PDF_CREATOR); $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->SetHeaderMargin(PDF_MARGIN_HEADER); $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) { require_once dirname(__FILE__) . '/lang/eng.php'; $pdf->setLanguageArray($l); } // ------------------------------------------------------------------- $pdf->AddPage(); $pdf->setJPEGQuality(75); $imgdata = base64_decode('iVBORw0KGgoAAAANSUhEUgAAABwAAAASCAMAAAB/2U7WAAAABlBMVEUAAAD///+l2Z/dAAAASUlEQVR4XqWQUQoAIAxC2/0vXZDrEX4IJTRkb7lobNUStXsB0jIXIAMSsQnWlsV+wULF4Avk9fLq2r8a5HSE35Q3eO2XP1A1wQkZSgETvDtKdQAAAABJRU5ErkJggg=='); $pdf->Image('@' . $imgdata); $intY = 25; foreach ($arrImagename as $intkey => $oneImage) { if ($intkey % 2 == 0 && $intkey != 0) { $intY = 25; $pdf->AddPage(); } $pdf->Image($oneImage, 10, $intY, 180, 103, 'png', '', 'C', true, 150, '', false, false, 1, false, false, false); $intY += 125; } $pdf->Output($strFilename . '.pdf', 'I'); }
function izvjestaj_prijemni_brzi_unos() { require_once 'lib/tcpdf/tcpdf.php'; $termin = intval($_REQUEST['termin']); $osoba = intval($_REQUEST['osoba']); $q10 = myquery("select ime, prezime, imeoca, jmbg from osoba where id={$osoba}"); if (mysql_num_rows($q10) < 1) { biguglyerror("Nepostojeća osoba"); zamgerlog("nepostojeca osoba {$osoba}", 3); return; } $ime = mysql_result($q10, 0, 0); $prezime = mysql_result($q10, 0, 1); $imeoca = mysql_result($q10, 0, 2); $jmbg = mysql_result($q10, 0, 3); $q20 = myquery("select sifra, jezik from prijemni_obrazac where osoba={$osoba} and prijemni_termin={$termin}"); if (mysql_num_rows($q20) < 1) { biguglyerror("Ne postoji obrazac za ovu osobu"); zamgerlog("za osobu u{$osoba} ne postoji obrazac na terminu {$termin}", 3); return; } $sifra = mysql_result($q20, 0, 0); $jezik = mysql_result($q20, 0, 1); $datum = date("d. m. Y."); $vrijeme = date("h:i"); // ----- Pravljenje PDF dokumenta $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // set document information $pdf->SetCreator("Zamger"); $pdf->SetTitle('Sifra kandidata i pregled vaznijih datuma'); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(0, 0, 0); //set auto page breaks $pdf->SetAutoPageBreak(false); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO*2.083333); $pdf->setJPEGQuality(100); //set some language-dependent strings $pdf->setLanguageArray($l); // --------------------------------------------------------- // set font $pdf->SetFont('freesans', '', 48); $pdf->SetHeaderData("", 0, "", ""); $pdf->SetPrintHeader(false); $pdf->SetPrintFooter(false); // add a page $pdf->AddPage(); // $pdf->Image("images/content/150dpi/ETF-Domestic-contract-PGS-ALL-0.png",210,297,0,0,'','','',true,150); if ($jezik == "en") { $pdf->Image("images/content/150dpi/obrazac_sa_sifrom_en.png", 0, 0, 210, 0, '', '', '', true, 150); $en_offset = 7; } else { $pdf->Image("images/content/150dpi/obrazac_sa_sifrom.png", 0, 0, 210, 0, '', '', '', true, 150); $en_offset = 0; } $pdf->SetXY(130, 15); $pdf->Cell(23, 0, $sifra, 0, 0, 'C'); $pdf->SetFont('freesans', '', 16); $pdf->SetXY(80, 62 + $en_offset); $pdf->Cell(23, 0, "{$ime} ({$imeoca}) {$prezime}"); $pdf->SetXY(80, 73 + $en_offset); $pdf->Cell(23, 0, $jmbg); $pdf->SetFont('freesans', '', 14); $pdf->SetXY(40, 113 + $en_offset); $pdf->Cell(23, 0, $datum); $pdf->SetXY(130, 113 + $en_offset); $pdf->Cell(23, 0, $vrijeme); // --------------------------------------------------------- //Close and output PDF document $pdf->Output('obrazac_sa_sifrom.pdf', 'I'); //============================================================+ // END OF FILE //============================================================+ }
function showPdf($idReg = "") { global $db; // Oficina $sesIdOficina = $_SESSION[sesIdOficina]; $oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina); // create new PDF document $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', false, 'ISO-8859-1', false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('Nicola Asuni'); $pdf->SetTitle('TCPDF Example 009'); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // set default header data //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING); // set header and footer fonts //$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); //$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); //$pdf->SetHeaderMargin(PDF_MARGIN_HEADER); // $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); // $pdf->SetFooterMargin(3); $pdf->setPageOrientation('P', '', 1); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings //$pdf->setLanguageArray($l); // set some language dependent data: $lg = array(); $lg['a_meta_charset'] = 'ISO-8859-1'; $lg['a_meta_dir'] = 'ltr'; $lg['a_meta_language'] = 'en'; $lg['w_page'] = 'page'; //set some language-dependent strings $pdf->setLanguageArray($lg); // ------------------------------- // CONSULTA DE DATOS // ------------------------------- $sql = "select * from INVENTARIO where id_inventario='{$idReg}'"; $db->query($sql); while ($db->next_record()) { $entSal = $db->f('ent_sal'); $eir = $db->f(eir); //$idCliente = $db->f('id_cliente'); //$cliente = getValueTable("cliente","CLIENTE","id_cliente",$idCliente); $cliente = $db->f('consig'); $idConte = $db->f('id_contenedor'); $conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte); if (preg_match("/(\\w{4})(\\d{7})/", $conte, $parts)) { $conteL = $parts[1]; $conteN = $parts[2]; } $idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte); $equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq); $bkg = $db->f('bkg'); $clase = $db->f('clase'); $clase = "CLASE: {$clase} "; $damage = $db->f('damage'); $sello = $db->f('sello'); $nota = $db->f('nota'); //$idTrans = $db->f('id_transporte'); //$transp = getValueTable("transporte","TRANSPORTE","id_transporte",$idTrans); $transp = $db->f('transportista'); $conteP1 = substr($conte, 0, 4); $conteP2 = substr($conte, 4, 10); if (preg_match("/(\\d+)(\\d)\$/", $conteP2, $parts)) { $conteP2 = $parts[1] . "-" . $parts[2]; } $idNav = $db->f('id_naviera'); $naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav); $placas = $db->f('placas'); // $idOperador = $db->f('id_operador'); //$operador = getValueTable("operador","OPERADOR","id_operador",$idOperador); $operador = $db->f('operador'); $capFec = $db->f('cap_fec'); if ($entSal == "E") { $entSalTx = "INVENTARIO"; } if ($entSal == "S") { $entSalTx = "SALIDA"; } $tipoMani = $db->f('tipo_mani'); $noRecibo = $db->f('recibo'); if ($tipoMani == "D") { $tipoManiTx = "MANIOBRA DE DESCARGA"; } if ($tipoMani == "C") { $tipoManiTx = "MANIOBRA DE CARGA"; } $maniCosto = $db->f('mani_costo'); $montoLetra = traducirCifra($maniCosto); $capIdUsr = $db->f('cap_id_usr'); $capFec = $db->f('cap_fec'); $capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr); } // ------------------------------ // DAÑOS // ------------------------------ $sql = "select * from REL_NOME "; $sql .= "where id_inventario='{$idReg}' "; $dano = ""; $db->query($sql); while ($db->next_record()) { $idRelNome = $db->f(id_rel_nome); $idNome = $db->f(id_nome); $idUbica = $db->f(id_ubicacion); $idDime = $db->f(id_dimension); $nome = getValueTable("nombre", "NOMENCLATURA", "id_nome", $idNome); $nomeCode = getValueTable("codigo", "NOMENCLATURA", "id_nome", $idNome); $ubica = getValueTable("ubicacion", "UBICACION", "id_ubicacion", $idUbica); $dimen = getValueTable("dimension", "DIMENSION", "id_dimension", $idDime); $dano .= "{$nome} ({$nomeCode}) : {$ubica} : {$dimen}\n"; } $dano = nl2br($dano); // --------------------------------------------------------- // DATOS DEL RECIBO // --------------------------------------------------------- if ($noRecibo > 0) { $datoRecibo = "\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>FECHA</b></td>\n <td><b>No.R.I.E.</b></td> \n <td></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$capFec}</td> \n <td>{$idReg}</td>\n <td></td>\n <td>{$conteL}{$conteN}</td>\n <td>{$equipo}</td>\n </tr> \n <tr>\n <td><b>CONCEPTO</b></td> \n <td><b>TRANSPORTISTA</b></td> \n <td><b>OPERADOR</b></td>\n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td>{$tipoManiTx}</td> \n <td>{$transp}</td>\n <td>{$operador}</td> \n <td colspan=\"2\">{$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>MANIOBRA \$</b></td>\n <td align=\"left\">{$maniCosto}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>SUBTOTAL \$</b></td>\n <td align=\"left\">{$maniCosto}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>IVA \$</b></td>\n <td align=\"left\">{$maniIva}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"left\">{$maniCosto}</td>\n </tr>\n </table>\n </td>\n </tr>\n <tr>\n <td colspan=\"3\" align=\"left\">RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100 </td>\n </tr>\n </table> \n "; } // ------------------------------------------------------------------- $pdf->AddPage(); // Logo $pdf->setJPEGQuality(100); $pdf->Image('../images/logo_color.jpg', 13, 4, 25, 25, '', '', '', false); //$pdf->Image('../images/nome.jpg', 15, 140, 185, 96,'','','',false); // set cell padding //$pdf->setCellPaddings(1, 1, 1, 1); // set cell margins //$pdf->setCellMargins(1, 1, 1, 1); // Encabezado $pdf->SetFillColor(197, 197, 197); if ($sesIdOficina == 1) { $txt = "ALMARTCON, S.A. DE C.V.\n\"El Trébol\""; $pdf->SetFont('helvetica', '', 14); $pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true); $txt = "Direccion, Guatemala \nTels.: 505-2350-0976 Cel. 505-8635-0708"; $pdf->SetFont('helvetica', '', 7); $pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true); } /* elseif( $sesIdOficina==3 ){ $txt = "TRANSPORTES MALEJA, S.A. DE C.V.\n\"El Pino\""; $pdf->SetFont('helvetica', '', 14); $pdf->MultiCell(65, 4,$txt, 0, 'L',0, 0, 40, 10,true); $txt="Carretera Querétaro San Luis Potosí Km.28\nCol.Buenavista Santa Rosa Jauregui\nQueretaro, QRO."; $pdf->SetFont('helvetica', '', 7); $pdf->MultiCell(60, 4,$txt, 0, 'C',0, 0, 105, 10,true); } */ $pdf->SetFont('helvetica', '', 12); $tbl = <<<EOD <table cellspacing="0" cellpadding="3" border="1" align="center"> <tr bgcolor="#cacaca"> <th>FOLIO</th> </tr> <tr> \t \t<td><font color="red">{$entSal} {$eir}</font></td> </tr> </table> EOD; $pdf->writeHTML($tbl, true, false, false, false, ''); $txt = "RECIBO DE INTERCAMBIO DE EQUIPO (R.I.E)"; $pdf->SetFont('helvetica', 'B', 12); $pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true); $pdf->SetFont('helvetica', '', 8); $tbl = <<<EOD <br><br><br> <table cellspacing="0" cellpadding="3" border="1" align="center"> <tr> <th><b>CLIENTE</b></th> <th><b>MARCA</b></th> <th><b>NUMERO</b></th> <th><b>CARACTERISTICAS FISICAS</b></th> </tr> <tr> \t \t<td>{$cliente}</td> \t<td>{$conteL}</td> \t<td>{$conteN}</td> \t<td>{$equipo} / {$damage} </td> \t </tr> <tr bgcolor="#cacaca"> \t<th colspan="4"><b>{$entSalTx}</b></th> </tr> <tr> \t<td><b>ENTREGADO POR :</b></td> \t<td><b>FECHA Y HORA</b></td> <td><b>BOOKING</b></td> \t<td><b>ESTADO FISICO</b></td> \t </tr> <tr> \t<td>{$naviera}</td> \t<td>{$capFec}</td> <td>{$bkg}</td> \t<td>{$clase}</td> \t </tr> <tr> \t<td><b>TRANSPORTISTA</b></td> <td><b>OPERADOR</b></td> <td><b>PLACAS</b></td> \t<td><b>SELLO</b></td> \t \t </tr>\t <tr> \t<td>{$transp}</td> <td>{$operador}</td> <td>{$placas}</td> <td>{$sello}</td> </tr> <tr> \t<td colspan="2"><b>OBSERVACIONES</b></td> \t <td colspan="2"><b>DANOS</b></td> </tr> <tr> <td colspan="2">{$nota}</td> \t<td colspan="2">{$dano}</td> </tr> <tr> <td colspan="4"><i>Capturo: {$capUsr}<br>Fecha captura: {$capFec} </i></td> </tr> </table> <br><br><br> {$datoRecibo} EOD; $pdf->writeHTML($tbl, true, false, false, false, ''); $noRecibo > 0 ? $corY = 180 : ($corY = 105); $txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 15, $corY, true); $txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(30, 10, $txt, 1, 'C', 0, 0, 55, $corY, true); $txt = "AUTO. DE REPARACION\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 85, $corY, true); $txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 125, $corY, true); $txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(35, 10, $txt, 1, 'C', 0, 0, 165, $corY, true); //Close and output PDF document $pdf->Output('example_eir.pdf', 'I'); }
function student_ugovoroucenjupdf() { global $userid; require_once 'lib/tcpdf/tcpdf.php'; // Prikupljam podatke iz baze // Za koju godinu se prijavljuje? $q1 = myquery("select id, naziv from akademska_godina where aktuelna=1"); $q2 = myquery("select id, naziv from akademska_godina where id>" . mysql_result($q1, 0, 0) . " order by id limit 1"); if (mysql_num_rows($q2) < 1) { // nicemessage("U ovom trenutku nije aktiviran upis u sljedeću akademsku godinu."); // return; // Pretpostavljamo da se upisuje u aktuelnu? $zagodinu = mysql_result($q1, 0, 0); $agnaziv = mysql_result($q1, 0, 1); $q3 = myquery("select id from akademska_godina where id<{$zagodinu} order by id desc limit 1"); $proslagodina = mysql_result($q3, 0, 0); } else { $proslagodina = mysql_result($q1, 0, 0); $zagodinu = mysql_result($q2, 0, 0); $agnaziv = mysql_result($q2, 0, 1); } // Zapis u tabeli ugovoroucenju $q5 = myquery("select uu.id, s.id, s.naziv, s.naziv_en, uu.semestar, s.tipstudija from ugovoroucenju as uu, studij as s where uu.student={$userid} and uu.akademska_godina={$zagodinu} and uu.studij=s.id order by semestar desc limit 1"); if (mysql_num_rows($q5) < 1) { niceerror("Nije kreiran ugovor o učenju za studenta."); return; } $ugovorid = mysql_result($q5, 0, 0); $studij = mysql_result($q5, 0, 1); $studijbos = mysql_result($q5, 0, 2); $studijbos = substr($studijbos, 0, strpos($studijbos, "(") - 1); $studijeng = mysql_result($q5, 0, 3); $sem2 = mysql_result($q5, 0, 4); $tipstudija = mysql_result($q5, 0, 5); $sem1 = $sem2 - 1; $godina = $sem2 / 2; // Ostali podaci o osobi $q10 = myquery("select ime, prezime, brindexa from osoba where id={$userid}"); $imeprezime = mysql_result($q10, 0, 0) . " " . mysql_result($q10, 0, 1); $brindexa = mysql_result($q10, 0, 2); // Odabir plana studija $plan_studija = 0; $q5a = myquery("SELECT studij, plan_studija FROM student_studij WHERE student={$userid} AND akademska_godina<={$zagodinu} ORDER BY akademska_godina DESC LIMIT 1"); if (mysql_num_rows($q5a) > 0 && $studij == mysql_result($q5a, 0, 0)) { $plan_studija = mysql_result($q5a, 0, 1); } if ($plan_studija == 0) { // Student nije prethodno studirao na istom studiju ili plan studija nije bio definisan // Uzimamo najnoviji plan za odabrani studij $q6 = myquery("select godina_vazenja from plan_studija where studij={$studij} order by godina_vazenja desc limit 1"); if (mysql_num_rows($q6) < 1) { niceerror("Nepostojeći studij"); return; } $plan_studija = mysql_result($q6, 0, 0); } // Da li je ponovac (ikada slušao isti tip studija)? $q20 = myquery("select ss.semestar from student_studij as ss, studij as s, tipstudija as ts where ss.student={$userid} and ss.akademska_godina<={$proslagodina} and ss.studij=s.id and s.tipstudija={$tipstudija} order by semestar desc limit 1"); if (mysql_num_rows($q20) < 1) { /*niceerror("Ne možete popunjavati ugovor o učenju ako prvi put slušate prvu godinu studija."); return;*/ // Zašto ne bismo dozvolili? $ponovac = 0; } else { if ($sem1 > mysql_result($q20, 0, 0)) { $ponovac = 0; } else { $ponovac = 1; } } // Odredjujemo da li ima prenesenih predmeta // TODO: ovo sada ne radi za izborne predmete $q20 = myquery("select p.sifra, p.naziv, p.ects, ps.semestar from predmet as p, plan_studija as ps where ps.godina_vazenja={$plan_studija} and ps.studij={$studij} and (ps.semestar=" . ($sem1 - 1) . " or ps.semestar=" . ($sem1 - 2) . ") and ps.obavezan=1 and ps.predmet=p.id and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); if (mysql_num_rows($q20) > 1) { niceerror("Nemate uslove za upis {$godina}. godine studija"); print "Sačekajte da prikupite uslov ili popunite Ugovor za prethodnu godinu studija."; return; } if (mysql_num_rows($q20) == 1) { $ima_preneseni = 1; $preneseni_sifra = mysql_result($q20, 0, 0); $preneseni_naziv = mysql_result($q20, 0, 1); $preneseni_ects = mysql_result($q20, 0, 2); $preneseni_semestar = mysql_result($q20, 0, 3); } else { $ima_preneseni = 0; } // Privremeni hack za master if ($tipstudija == 3) { $mscfile = "-msc"; } else { if ($tipstudija == 2) { $mscfile = ""; } } // Ako čovjek upisuje prvu godinu mastera, broj indexa je netačan! if ($godina == 1 && $tipstudija == 3) { $brindexa = ""; } // ----- Pravljenje PDF dokumenta $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // set document information $pdf->SetCreator("Zamger"); $pdf->SetTitle('Domestic Learning Agreement / Ugovor o ucenju'); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(0, 0, 0); //set auto page breaks $pdf->SetAutoPageBreak(false); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO*2.083333); $pdf->setJPEGQuality(100); //set some language-dependent strings $pdf->setLanguageArray($l); // --------------------------------------------------------- // set font $pdf->SetFont('freesans', 'B', 9); $pdf->SetHeaderData("", 0, "", ""); $pdf->SetPrintHeader(false); $pdf->SetPrintFooter(false); // add a page $pdf->AddPage(); // $pdf->Image("images/content/150dpi/ETF-Domestic-contract-PGS-ALL-0.png",210,297,0,0,'','','',true,150); $pdf->Image("images/content/150dpi/domestic-contract{$mscfile}-0.png", 0, 0, 210, 0, '', '', '', true, 150); $pdf->SetXY(175, 34); $pdf->Cell(23, 0, $agnaziv, 0, 0, 'C'); $pdf->SetXY(175, 42); $pdf->Cell(23, 0, $godina . ".", 0, 0, 'C'); $pdf->SetXY(175, 50); $pdf->Cell(23, 0, $sem1 . ". & " . $sem2, 0, 0, 'C'); $pdf->SetXY(70, 48); $pdf->Cell(100, 0, $studijeng, 0, 0); $pdf->SetXY(70, 52); $pdf->Cell(100, 0, $studijbos, 0, 0); $pdf->SetXY(70, 62); $pdf->Cell(100, 0, $imeprezime); $pdf->SetXY(70, 69); $pdf->Cell(100, 0, $brindexa); // PRVI SEMESTAR $pdf->AddPage(); $pdf->Image("images/content/150dpi/domestic-contract{$mscfile}-1.png", 0, 0, 210); $pdf->SetXY(175, 34); $pdf->Cell(23, 0, $agnaziv, 0, 0, 'C'); $pdf->SetXY(175, 42); $pdf->Cell(23, 0, $godina . ".", 0, 0, 'C'); $pdf->SetXY(175, 50); $pdf->Cell(23, 0, $sem1 . ".", 0, 0, 'C'); $pdf->SetXY(70, 48); $pdf->Cell(100, 0, $studijeng, 0, 0); $pdf->SetXY(70, 52); $pdf->Cell(100, 0, $studijbos, 0, 0); $pdf->SetXY(70, 62); $pdf->Cell(100, 0, $imeprezime); $pdf->SetXY(70, 69); $pdf->Cell(100, 0, $brindexa); // Spisak obaveznih predmeta na neparnom semestru // Ako je ponovac, ne prikazujemo predmete koje je polozio if ($ponovac == 1) { $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$plan_studija} and ps.studij={$studij} and ps.semestar={$sem1} and ps.obavezan=1 and ps.predmet=p.id and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { // Ako nije, trebamo prikazati one koje je položio u koliziji $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$plan_studija} and ps.studij={$studij} and ps.semestar={$sem1} and ps.obavezan=1 and ps.predmet=p.id"); } $ykoord = 95; $ects = 0; while ($r100 = mysql_fetch_row($q100)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r100[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r100[1]); $e = "{$r100['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r100[2]; } // Da li je prenesen predmet na neparnom semestru? if ($ima_preneseni && $preneseni_semestar % 2 == 1) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $preneseni_sifra); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $preneseni_naziv); $e = "{$preneseni_ects}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $preneseni_ects; } // Spisak izbornih predmeta if ($ponovac == 1) { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem1} and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem1}"); } $ykoord = 123; while ($r110 = mysql_fetch_row($q110)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r110[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r110[1]); $e = "{$r110['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r110[2]; } // Suma ects if (!strchr($ects, ".")) { $ects .= ".0"; } $pdf->SetXY(170, 135); $pdf->Cell(100, 0, $ects); // DRUGI SEMESTAR $pdf->AddPage(); $pdf->Image("images/content/150dpi/domestic-contract{$mscfile}-2.png", 0, 0, 210); $pdf->SetXY(175, 34); $pdf->Cell(23, 0, $agnaziv, 0, 0, 'C'); $pdf->SetXY(175, 42); $pdf->Cell(23, 0, $godina . ".", 0, 0, 'C'); $pdf->SetXY(175, 50); $pdf->Cell(23, 0, $sem2 . ".", 0, 0, 'C'); $pdf->SetXY(70, 48); $pdf->Cell(100, 0, $studijeng, 0, 0); $pdf->SetXY(70, 52); $pdf->Cell(100, 0, $studijbos, 0, 0); $pdf->SetXY(70, 62); $pdf->Cell(100, 0, $imeprezime); $pdf->SetXY(70, 69); $pdf->Cell(100, 0, $brindexa); // Spisak obaveznih predmeta na parnom semestru if ($ponovac == 1) { $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$plan_studija} and ps.studij={$studij} and ps.semestar={$sem2} and ps.obavezan=1 and ps.predmet=p.id and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { $q100 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, plan_studija as ps where ps.godina_vazenja={$plan_studija} and ps.studij={$studij} and ps.semestar={$sem2} and ps.obavezan=1 and ps.predmet=p.id"); } $ykoord = 95; $ects = 0; while ($r100 = mysql_fetch_row($q100)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r100[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r100[1]); $e = "{$r100['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r100[2]; } // Da li je prenesen predmet na parnom semestru? if ($ima_preneseni && $preneseni_semestar % 2 == 0) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $preneseni_sifra); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $preneseni_naziv); $e = "{$preneseni_ects}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $preneseni_ects; } // Spisak izbornih predmeta if ($ponovac == 1) { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem2} and (select count(*) from konacna_ocjena as ko where ko.student={$userid} and ko.predmet=p.id)=0"); } else { $q110 = myquery("select p.sifra, p.naziv, p.ects from predmet as p, ugovoroucenju_izborni as uoui, ugovoroucenju as uu where uoui.ugovoroucenju=uu.id and uu.student={$userid} and uu.akademska_godina={$zagodinu} and uoui.predmet=p.id and uu.semestar={$sem2}"); } $ykoord = 123; while ($r110 = mysql_fetch_row($q110)) { $pdf->SetXY(13, $ykoord); $pdf->Cell(100, 0, $r110[0]); $pdf->SetXY(50, $ykoord); $pdf->Cell(100, 0, $r110[1]); $e = "{$r110['2']}"; if (!strchr($e, ".")) { $e .= ".0"; } $pdf->SetXY(170, $ykoord); $pdf->Cell(100, 0, $e); $ykoord += 4; $ects += $r110[2]; } // Suma ects if (!strchr($ects, ".")) { $ects .= ".0"; } $pdf->SetXY(170, 135); $pdf->Cell(100, 0, $ects); // --------------------------------------------------------- //Close and output PDF document $pdf->Output('ugovor_o_ucenju.pdf', 'I'); //============================================================+ // END OF FILE //============================================================+ }
static function printTicket($ticket_html, $order) { ob_end_clean(); $config = JComponentHelper::getParams('com_bookpro'); $page_ticket = "<h1 color='Red'> Wellcome to tcpdf </h1>"; $page_ticket = $ticket_html; // create new PDF document $pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false); $order_number = $order->order_number; // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('Joombooking'); $pdf->SetTitle('Travel Ticket ' . $order_number); $pdf->SetSubject('Travel Ticket'); $pdf->SetKeywords('TCPDF, PDF, ticket, travel, booking'); // set default header data //$pdf->SetHeaderData($config->get('company_logo'),50, $config->get('company_name'), "Ticket \n www."); // set header and footer fonts $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); //$pdf->setHeaderMargin(10); $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins //$pdf->SetMargins(30, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); //$pdf->SetHeaderMargin(PDF_MARGIN_HEADER); $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings $pdf->setLanguageArray($l); // --------------------------------------------------------- // set font $pdf->SetFont('times', '', 11); // add a page $pdf->AddPage(); // set JPEG quality $pdf->setJPEGQuality(75); $style['position'] = 'R'; /* * $type type of barcode (see tcpdf_barcodes_1d.php for supported formats). * */ //$pdf->write1DBarcode($order_number, 'C128B','', '', '', 10, 0.4, $style, 'M'); // create some HTML content //$pdf->writeHTML($htmlcontent, true, 0, true, 0); //$pdf->WriteHTML(file_get_contents('test.html')); $pdf->WriteHTML($page_ticket); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // reset pointer to the last page $pdf->lastPage(); // --------------------------------------------------------- //Close and output PDF document ob_end_clean(); $pdf->Output($order->name . '.pdf', 'I'); //Should use variable to make file name ob_end_flush(); }
public function render(\TCPDF $pdf, $width = null) { $image = $this->_obj->getContent(); $imgSize = getimagesize(Core::$basePath . $image); $height = $pdf->pixelsToUnits($imgSize[1]); $width = $pdf->pixelsToUnits($imgSize[0]); $pdf->setJPEGQuality(75); if ($this->_obj->getParameter('pos_x') || $this->_obj->getParameter('pos_y')) { $currentY = $pdf->getY(); $currentAPB = $pdf->getAutoPageBreak(); $currentMB = $pdf->getMargins(); $currentMB = $currentMB['bottom']; $pdf->setAutoPageBreak(false, 0); $pdf->write(''); } $pdf->Image(Core::$basePath . $image, $this->_obj->getParameter('pos_x') ? $pdf->pixelsToUnits($this->_obj->getParameter('pos_x')) : null, $this->_obj->getParameter('pos_y') ? $pdf->pixelsToUnits($this->_obj->getParameter('pos_y')) : null, $width * $this->_obj->getParameter('ratio'), $height * $this->_obj->getParameter('ratio'), null, $this->_obj->getParameter('link'), 'N'); if (isset($currentY)) { $pdf->setY($currentY); $pdf->setAutoPageBreak($currentAPB, $currentMB); } }
function showPdf($idReg = "") { global $db; // Oficina //$sesIdOficina = $_SESSION[sesIdOficina]; //$oficina = getValueTable("oficina","OFICINA","id_oficina",$sesIdOficina); // create new PDF document $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', false, 'ISO-8859-1', false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('Nicola Asuni'); $pdf->SetTitle('TCPDF Example 009'); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // set default header data //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING); // set header and footer fonts //$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); //$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); //$pdf->SetHeaderMargin(PDF_MARGIN_HEADER); // $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); // $pdf->SetFooterMargin(3); $pdf->setPageOrientation('P', '', 1); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings //$pdf->setLanguageArray($l); // set some language dependent data: $lg = array(); $lg['a_meta_charset'] = 'ISO-8859-1'; $lg['a_meta_dir'] = 'ltr'; $lg['a_meta_language'] = 'es'; $lg['w_page'] = 'page'; //set some language-dependent strings $pdf->setLanguageArray($lg); // ------------------------------- // CONSULTA DE DATOS // ------------------------------- $sql = "select * from SALIDA where id_salida='{$idReg}'"; $db->query($sql); while ($db->next_record()) { $docu = $db->f(doc_tipo); $docuRef = $db->f(doc_ref); $docTipo = $db->f(doc_tipo); //$entSal= $db->f('ent_sal'); $idSal = $idReg; $eir = $db->f(eir); $idOficina = $db->f(id_oficina); //$idCliente = $db->f('id_cliente'); //$cliente = getValueTable("cliente","CLIENTE","id_cliente",$idCliente); $cliente = $db->f('consig'); $idConte = $db->f('id_contenedor'); $conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte); if (preg_match("/(\\w{4})(\\d{7})/", $conte, $parts)) { $conteL = $parts[1]; $conteN = $parts[2]; } $maniStPago = $db->f(mani_st_pago); if ($maniStPago == "M") { $pagaManiobras = "MERCHANT"; } elseif ($maniStPago == "C") { $pagaManiobras = "CARRIER"; } $idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte); $equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq); $bkg = $db->f('bkg'); $clase = $db->f('clase'); $clase = "CLASE: {$clase} "; $damage = $db->f('damage'); $sello = $db->f('sello'); $nota = $db->f('nota'); //$idTrans = $db->f('id_transporte'); //$transp = getValueTable("transporte","TRANSPORTE","id_transporte",$idTrans); $transp = $db->f('transportista'); $conteP1 = substr($conte, 0, 4); $conteP2 = substr($conte, 4, 10); if (preg_match("/(\\d+)(\\d)\$/", $conteP2, $parts)) { $conteP2 = $parts[1] . "-" . $parts[2]; } $idNav = $db->f('id_naviera'); $naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav); $placas = $db->f('placas'); // $idOperador = $db->f('id_operador'); //$operador = getValueTable("operador","OPERADOR","id_operador",$idOperador); $operador = $db->f('operador'); $capFec = $db->f('cap_fec'); $entSalTx = "SALIDA"; $tipoMani = $db->f('tipo_mani'); $noRecibo = $db->f('recibo'); if ($tipoMani == "D") { $tipoManiTx = "MANIOBRA DE DESCARGA"; } if ($tipoMani == "C") { $tipoManiTx = "MANIOBRA DE CARGA"; } $maniCosto = $db->f('mani_costo'); $repaCosto = $db->f('repa_costo'); $sumaCpto = $maniCosto + $repaCosto; $montoLetra = traducirCifra($sumaCpto); $capIdUsr = $db->f('cap_id_usr'); $capFec = $db->f('cap_fec'); $capUsr = getValueTable("usuario", "USUARIO", "id_usuario", $capIdUsr); $modFec = $db->f('mod_fec'); $consig = $db->f('consig'); } // ------------------------------ // DAÑOS // ------------------------------ $sql = "select * from REL_NOME_SAL_PLUS "; $sql .= "where id_salida='{$idSal}' "; $dano = ""; $db->query($sql); while ($db->next_record()) { $idRelNome = $db->f(id_rel_nome); $idNome = $db->f(id_nome); $idUbica = $db->f(id_ubicacion); $idDime = $db->f(id_dimension); $nome = getValueTable("nombre", "NOMENCLATURA", "id_nome", $idNome); $nomeCode = getValueTable("codigo", "NOMENCLATURA", "id_nome", $idNome); $ubica = getValueTable("ubicacion", "UBICACION", "id_ubicacion", $idUbica); $dimen = getValueTable("dimension", "DIMENSION", "id_dimension", $idDime); $dano .= "{$nome} ({$nomeCode}) : {$ubica} : {$dimen}\n"; } $dano = nl2br($dano); // --------------------------------------------------------- // DATOS DEL RECIBO // --------------------------------------------------------- if ($noRecibo > 0) { $subTotal = $maniCosto + $repaCosto; $total = $subTotal; $subTotal = number_format($subTotal, 2); $total = number_format($total, 2); $datoRecibo = "\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES OPEMANTRA</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>FECHA</b></td>\n <td><b>No.R.I.E.</b></td> \n <td></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$capFec}</td> \n <td>{$idReg}</td>\n <td></td>\n <td>{$conteL}{$conteN}</td>\n <td>{$equipo}</td>\n </tr> \n <tr>\n <td><b>CONCEPTO</b></td> \n <td><b>TRANSPORTISTA</b></td> \n <td><b>OPERADOR</b></td>\n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td>{$tipoManiTx}</td> \n <td>{$transp}</td>\n <td>{$operador}</td> \n <td colspan=\"2\">{$docu} {$docuRef} / {$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>MANIOBRA \$</b></td>\n <td align=\"right\">{$maniCosto}</td>\n </tr>\n <tr>\n <td align=\"right\"><b>REPARACIONES \$</b></td>\n <td align=\"right\">{$repaCosto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"right\">{$total}</td>\n </tr>\n </table>\n </td>\n </tr>\n "; if ($docTipo == "EFECTIVO") { $datoRecibo .= "\n <tr> \n <td colspan=\"3\" align=\"right\">RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100 </td>\n </tr>\n "; } $datoRecibo .= "</table>"; } // ------------------------------------------------------------------- $pdf->AddPage(); // Logo $pdf->setJPEGQuality(100); $pdf->Image('../images/logo.jpg', 13, 4, 60, 30, '', '', '', false); //$pdf->Image('../images/nome.jpg', 15, 145, 185, 120,'','','',false); // set cell padding $pdf->setCellPaddings(1, 1, 1, 1); // set cell margins $pdf->setCellMargins(1, 1, 1, 1); // Encabezado $pdf->SetFillColor(197, 197, 197); // Trebol $pdf->SetFont('helvetica', '', 14); $pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true); //$txt="Av. "; $pdf->SetFont('helvetica', '', 7); $pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true); $pdf->SetFont('helvetica', '', 12); $tbl = <<<EOD <table cellspacing="0" cellpadding="3" border="0" align="center"> <tr bgcolor="#cacaca"> <th>FOLIO</th> </tr> <tr> \t \t<td><font color="red">S {$eir}</font></td> </tr> </table> EOD; $pdf->writeHTML($tbl, true, false, false, false, ''); $txt = "RECIBO DE INTERCAMBIO DE EQUIPO (R.I.E)"; $pdf->SetFont('helvetica', 'B', 12); $pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true); $pdf->SetFont('helvetica', '', 8); $tbl = <<<EOD <br><br><br> <table cellspacing="0" cellpadding="3" border="0" align="center"> <tr> <th><b>CONTENEDOR</b></th> <th><b>CARACTERISTICAS FISICAS</b></th> <td><b>CLIENTE</b></td> <td><b>PAGA MANIOBRAS</b></td> </tr> <tr> \t<td>{$conteL}{$conteN}</td> \t<td>{$equipo} / {$damage} </td> \t<td>{$consig}</td> <td>{$pagaManiobras}</td> </tr> <tr bgcolor="#cacaca"> \t<th colspan="4"><b>{$entSalTx}</b></th> </tr> <tr> \t<td><b>NAVIERA</b></td> \t<td><b>FECHA Y HORA</b></td> <td><b>BOOKING / BL</b></td> \t<td><b>ESTADO FISICO</b></td> \t </tr> <tr> \t<td>{$naviera}</td> \t<td>{$capFec}</td> <td>{$bkg}</td> \t<td>{$clase}</td> \t </tr> <tr> \t<td><b>TRANSPORTISTA</b></td> <td><b>OPERADOR</b></td> <td><b>PLACAS</b></td> \t<td><b>SELLO</b></td> \t \t </tr>\t <tr> \t<td>{$transp}</td> <td>{$operador}</td> <td>{$placas}</td> <td>{$sello}</td> </tr> <tr > \t<td colspan="2"><b>OBSERVACIONES</b></td> \t <td colspan="2"><b>DANOS</b></td> </tr> <tr > <td colspan="2">{$nota}</td> \t<td colspan="2">{$dano}</td> </tr> <tr> <td><b>OPERADOR<br><br><br>Nombre y Firma</b></td> <td><b>INSPECTOR<br><br><br>Nombre y Firma</b></td> <td colspan="2">EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.</td> </tr> <tr bgcolor="#cacaca"> <td colspan="4"><i>Capturo: {$capUsr}<br>Fecha captura: {$modFec} </i></td> </tr> </table> <br><br><br> <!-- {$datoRecibo} --> EOD; $pdf->writeHTML($tbl, true, false, false, false, ''); /* ($noRecibo>0)?$corY=180:$corY=125; $txt="OPERADOR\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40,10,$txt, 0, 'C',0, 0, 15, $corY,true); $txt="INSPECTOR\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(30, 10,$txt, 0, 'C',0, 0, 55, $corY,true); $txt="EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS. Solicitarla al correo: factu@demo.com.mx"; $pdf->MultiCell(105, 10,$txt, 0, 'L',0, 0, 95, $corY,true); $txt="EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS. Solicitarla al correo: facturacionpatios@demo.com.mx"; */ //($noRecibo>0)?$corY=200:$corY=125; //$pdf->MultiCell(185, 10,$txt, 1, 'C',0, 0, 15, 200,true); //Close and output PDF document $pdf->Output('eirSalida.pdf', 'I'); }
$TRANSACTION_ID = mysql_real_escape_string($_GET['MNT_TRANSACTION_ID']); $q_gos = "SELECT * FROM payment WHERE payment_id = \"" . $TRANSACTION_ID . "\" AND payment_confirm= \"1\" LIMIT 1"; $res_gos = mysql_query($q_gos); if (mysql_num_rows($res_gos) > 0) { $row_gos = mysql_fetch_array($res_gos); require_once $up_way . 'dir/modules/tcpdf/config/lang/rus.php'; require_once $up_way . 'dir/modules/tcpdf/tcpdf.php'; // PDF_PAGE_FORMAT - A4 // PDF_PAGE_ORIENTATION // PDF_UNIT - mm $pdf = new TCPDF('P', 'mm', array(108, 200), true, 'UTF-8', false); $pdf->SetTitle('Transaction ID Ref ' . $TRANSACTION_ID); // remove default header/footer $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); $pdf->setJPEGQuality(100); $pdf->SetMargins(10, 10, true); // add a page $pdf->AddPage(); $pdf->SetFont('arial', '', 8); $strContent = '<div style="border:1px dashed #aaa;"><br/><span style="text-align:center">НКО «МОНЕТА.РУ» (ООО)</span><br/> <span style="text-align:center">424000, Российская Федерация,</span><br/> <span style="text-align:center">Республика Марий Эл, г. Йошкар-Ола,</span><br/> <span style="text-align:center">ул. Гоголя, д. 2, строение "А"</span><br/> <span style="text-align:center">тел./факс: 8 (495) 743-49-85,</span><br/> <span style="text-align:center;">e-mail: helpdesk.support@moneta.ru</span><br/> <div style="text-align:center;border-top:1px solid #aaa;border-bottom:1px solid #aaa;height:100px"><br/> <b>Квитанция об оплате</b><br/> </div><br/> <span style="text-align:left;"> Номер операции: ' . $row_gos['MNT_OPERATION_ID'] . '</span><br/> <span style="text-align:left;"> Дата и время: ' . $row_gos['payment_date'] . '</span><br/><br/>
function showPdf($idReg = "") { global $db; // ------------------------------- // CONSULTA DE DATOS // ------------------------------- $sql = "select * from ENTRADA where id_entrada='{$idReg}'"; $db->query($sql); while ($db->next_record()) { $entSal = $db->f('ent_sal'); //$idCliente = $db->f('id_cliente'); //$cliente = getValueTable("cliente","CLIENTE","id_cliente",$idCliente); $cliente = $db->f('consig'); $idConte = $db->f('id_contenedor'); $conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte); if (preg_match("/(\\w{4})(\\d{7})/", $conte, $parts)) { $conteL = $parts[1]; $conteN = $parts[2]; } $idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte); $equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq); $bkg = $db->f('bkg'); $clase = $db->f('clase'); $damage = $db->f('damage'); $sello = $db->f('sello'); $nota = $db->f('nota'); //$idTrans = $db->f('id_transporte'); //$transp = getValueTable("transporte","TRANSPORTE","id_transporte",$idTrans); $transp = $db->f('transportista'); $conteP1 = substr($conte, 0, 4); $conteP2 = substr($conte, 4, 10); if (preg_match("/(\\d+)(\\d)\$/", $conteP2, $parts)) { $conteP2 = $parts[1] . "-" . $parts[2]; } $idNav = $db->f('id_naviera'); $naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNav); $placas = $db->f('placas'); // $idOperador = $db->f('id_operador'); //$operador = getValueTable("operador","OPERADOR","id_operador",$idOperador); $operador = $db->f('operador'); if ($entSal == "E") { $entCapFec = $db->f('cap_fec'); $entTrans = $transp; $entOpera = $operador; $entPlacas = $placas; $entClase = "CLASE : {$clase}"; $entDamage = $damage; $entSello = $sello; $entNota = $nota; } if ($entSal == "S") { $salCapFec = $db->f('cap_fec'); $salTrans = $transp; $salOpera = $operador; $salPlacas = $placas; $salClase = "CLASE : {$clase}"; $salDamage = $damage; $salSello = $sello; $salNota = $nota; } } // create new PDF document $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', true, 'ISO-8859-1', false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('Nicola Asuni'); $pdf->SetTitle('TCPDF Example 009'); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // set default header data //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING); // set header and footer fonts //$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); //$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); //$pdf->SetHeaderMargin(PDF_MARGIN_HEADER); // $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); // $pdf->SetFooterMargin(3); $pdf->setPageOrientation('P', '', 1); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings $pdf->setLanguageArray($l); // ------------------------------------------------------------------- $pdf->AddPage(); // Logo $pdf->setJPEGQuality(100); $pdf->Image('../images/logo_color.jpg', 13, 4, 25, 25, '', '', '', false); $pdf->Image('../images/nome.jpg', 15, 140, 185, 96, '', '', '', false); // set cell padding //$pdf->setCellPaddings(1, 1, 1, 1); // set cell margins //$pdf->setCellMargins(1, 1, 1, 1); $pdf->SetFillColor(197, 197, 197); // set font $txt = "TRANSPORTES MALEJA, S.A. DE C.V."; $pdf->SetFont('aefurat', '', 14); $pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true); // set font $txt = "Av. San Pablo s/n esq. Benito Juarez \nCol.San Pablo Xalpa Municipio Tlalnepantla \nC.P. 54090 Edo. de Mexico \nTels.: 5319-9375 5319-9228"; $pdf->SetFont('pdfahelvetica', '', 7); $pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true); $pdf->SetFont('pdfahelvetica', '', 12); $tbl = <<<EOD <table cellspacing="0" cellpadding="3" border="1" align="center"> <tr bgcolor="#cacaca"> <th>FOLIO</th> </tr> <tr> \t \t<td>{$idReg}</td> </tr> </table> EOD; $pdf->writeHTML($tbl, true, false, false, false, ''); $txt = "RECIBO DE INTERCAMBIO DE EQUIPO (R.I.E)"; $pdf->SetFont('helvetica', 'B', 12); $pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true); $pdf->SetFont('helvetica', '', 8); $tbl = <<<EOD <br><br><br> <table cellspacing="0" cellpadding="3" border="1" align="center"> <tr> <th><b>CLIENTE</b></th> <th><b>MARCA</b></th> <th><b>NUMERO</b></th> <th><b>CARACTERISTICAS FISICAS</b></th> <th><b>LOCALIZACION</b></th> </tr> <tr> \t \t<td>{$cliente}</td> \t<td>{$conteL}</td> \t<td>{$conteN}</td> \t<td>{$equipo}</td> \t<td>{$localizacion}</td> </tr> <tr bgcolor="#cacaca"> \t<th colspan="3"><b>ENTRADA</b></th> \t<th colspan="2"><b>SALIDA</b></th> \t </tr> <tr> \t<td><b>ENTREGADO POR :</b></td> \t<td><b>FECHA Y HORA</b></td> \t<td><b>AUTORIZACION</b></td> \t<td><b>FECHA Y HORA</b></td> \t<td><b>DESTINO</b></td> </tr> <tr> \t<td>{$naviera}</td> \t<td>{$entCapFec}</td> \t<td>{$bkg}</td> \t<td>{$salCapFec}</td> \t<td> </td> </tr> <tr> \t<td><b>TRANSPORTISTA</b></td> \t<td><b><b>CARTA PORTE</b></b></td> \t<td><b>-</b></td> \t<td><b>TRANSPORTISTA</b></td> \t<td><b>CARTA PORTE</b></td> </tr> <tr> \t<td>{$entTrans}</td> \t<td>-</td> \t<td>-</td> \t<td>{$salTrans}</td> \t<td>-</td> </tr> <tr> \t<td><b>OPERADOR</b></td> \t<td><b>PLACAS</b></td> \t \t<td><b>-</b></td> \t \t<td><b>OPERADOR</b></td> \t<td><b>PLACAS</b></td> </tr>\t <tr> \t<td>{$entOpera}</td> \t<td>{$entPlacas}</td> \t<td>-</td> \t<td>{$salOpera}</td> \t<td>{$salPlacas}</td> </tr> <tr> \t<td><b>ESTADO FISICO</b></td> \t<td></td> \t<td></td> \t<td><b>ESTADO FISICO</b></td> \t<td></td> </tr> <tr> \t<td>{$entClase}</td> \t<td>{$entDamage}</td> \t<td>-</td> \t \t<td>{$salClase}</td> \t<td>{$salDamage}</td> </tr> <tr> \t<td colspan="3"><b>NO.SELLO</b></td> \t<td colspan="2"><b>NO.SELLO</b></td> </tr> <tr> \t<td colspan="3">{$entSello}</td> \t<td colspan="2">{$salSello}</td> </tr> <tr> \t<td colspan="3"><b>OBSERVACIONES</b></td> \t<td colspan="2"><b>OBSERVACIONES</b></td> </tr> <tr> \t<td colspan="3">{$entNota}</td> \t<td colspan="2">{$salNota}</td> </tr> </table> EOD; $pdf->writeHTML($tbl, true, false, false, false, ''); $txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 15, 255, true); $txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(30, 10, $txt, 1, 'C', 0, 0, 55, 255, true); $txt = "AUTO. DE REPARACION\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 85, 255, true); $txt = "POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10, $txt, 1, 'C', 0, 0, 125, 255, true); $txt = "POR DEPOSITO\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(35, 10, $txt, 1, 'C', 0, 0, 165, 255, true); //Close and output PDF document $pdf->Output('example_eir.pdf', 'I'); }
/** * Convert html to tcpdf. * * @param $paper_size * @param $orientation * @param $margins * @param $html * @param $output * @param $fileName * @param $stationery_path */ public static function _html2pdf_tcpdf($paper_size, $orientation, $margins, $html, $output, $fileName, $stationery_path) { // Documentation on the TCPDF library can be found at: http://www.tcpdf.org // This function also uses the FPDI library documented at: http://www.setasign.com/products/fpdi/about/ // Syntax borrowed from https://github.com/jake-mw/CDNTaxReceipts/blob/master/cdntaxreceipts.functions.inc require_once 'tcpdf/tcpdf.php'; require_once 'FPDI/fpdi.php'; // This library is only in the 'packages' area as of version 4.5 $paper_size_arr = array($paper_size[2], $paper_size[3]); $pdf = new TCPDF($orientation, 'pt', $paper_size_arr); $pdf->Open(); if (is_readable($stationery_path)) { $pdf->SetStationery($stationery_path); } $pdf->SetAuthor(''); $pdf->SetKeywords('CiviCRM.org'); $pdf->setPageUnit($margins[0]); $pdf->SetMargins($margins[4], $margins[1], $margins[2], TRUE); $pdf->setJPEGQuality('100'); $pdf->SetAutoPageBreak(TRUE, $margins[3]); $pdf->AddPage(); $ln = TRUE; $fill = FALSE; $reset_parm = FALSE; $cell = FALSE; $align = ''; // output the HTML content $pdf->writeHTML($html, $ln, $fill, $reset_parm, $cell, $align); // reset pointer to the last page $pdf->lastPage(); // close and output the PDF $pdf->Close(); $pdf_file = 'CiviLetter' . '.pdf'; $pdf->Output($pdf_file, 'D'); CRM_Utils_System::civiExit(1); }
function izvjestaj_prijave() { require_once 'lib/tcpdf/tcpdf.php'; global $userid, $conf_files_path; // Poslani parametar $ispit_termin = intval($_GET['ispit_termin']); $predmet = intval($_GET['predmet']); $ag = intval($_GET['ag']); $student = intval($_GET['student']); $nasa_slova = array("č" => "c", "ć" => "c", "đ" => "d", "š" => "s", "ž" => "z", "Č" => "C", "Ć" => "C", "Đ" => "D", "Š" => "S", "Ž" => "Z"); // Odredjujemo filename if ($ispit_termin > 0) { $q5 = myquery("select p.id, p.naziv, UNIX_TIMESTAMP(it.datumvrijeme), i.akademska_godina from predmet as p, ispit as i, ispit_termin as it where it.id={$ispit_termin} and it.ispit=i.id and i.predmet=p.id"); $predmet = mysql_result($q5, 0, 0); $ag = mysql_result($q5, 0, 3); $filename = "prijave-" . strtr(mysql_result($q5, 0, 1), $nasa_slova) . "-" . date("d-m-Y", mysql_result($q5, 0, 2)) . ".pdf"; } else { if ($predmet > 0) { $q5 = myquery("select naziv from predmet where id={$predmet}"); $filename = "prijave-" . strtr(mysql_result($q5, 0, 0), $nasa_slova) . ".pdf"; } else { $filename = "prijave.pdf"; } } $upit = "SELECT o.id, o.ime, o.prezime, o.brindexa, pk.semestar, s.naziv, p.naziv, ag.naziv, "; // slijedi datum // Stampaj sve studente na terminu if ($ispit_termin > 0) { // Uzimamo datum termina $upit .= "UNIX_TIMESTAMP(it.datumvrijeme) from osoba as o, ispit_termin as it, student_ispit_termin as sit, student_predmet as sp, ponudakursa as pk, ispit as i, studij as s, predmet as p, akademska_godina as ag where sit.ispit_termin=it.id and sit.student=o.id and it.id={$ispit_termin} and o.id=sp.student and sp.predmet=pk.id and it.ispit=i.id and i.predmet=pk.predmet and i.akademska_godina=pk.akademska_godina and pk.studij=s.id and pk.predmet=p.id and pk.akademska_godina=ag.id order by o.prezime, o.ime"; } else { if ($predmet <= 0 || $ag <= 0) { biguglyerror("Neispravni parametri"); print "Da li je moguće da ste odabrali neispravan ili nepostojeći predmet?"; return; // Stampaj jednog studenta } else { if ($student > 0) { // Uzecemo danasnji datum $upit .= "UNIX_TIMESTAMP(NOW()) from osoba as o, ponudakursa as pk, studij as s, predmet as p, akademska_godina as ag, student_predmet as sp where o.id={$student} and sp.student={$student} and sp.predmet=pk.id and pk.predmet={$predmet} and pk.akademska_godina={$ag} and p.id={$predmet} and ag.id={$ag} and pk.studij=s.id"; // Sve studente koji nemaju ocjenu } else { if ($_GET['tip'] == "bez_ocjene" || $_GET['tip'] == "uslov") { // Naknadno provjeravamo da li ima uslov // Uzecemo danasnji datum $upit .= "UNIX_TIMESTAMP(NOW()) from osoba as o, ponudakursa as pk, studij as s, predmet as p, akademska_godina as ag, student_predmet as sp where o.id=sp.student and sp.predmet=pk.id and pk.predmet={$predmet} and pk.akademska_godina={$ag} and p.id={$predmet} and ag.id={$ag} and pk.studij=s.id and (select count(*) from konacna_ocjena as ko where ko.student=o.id and ko.predmet={$predmet})=0 order by o.prezime, o.ime"; // Sve studente koji imaju ocjenu } else { if ($_GET['tip'] == "sa_ocjenom") { // Uzecemo danasnji datum $upit .= "UNIX_TIMESTAMP(NOW()) from osoba as o, ponudakursa as pk, studij as s, predmet as p, akademska_godina as ag, student_predmet as sp where o.id=sp.student and sp.predmet=pk.id and pk.predmet={$predmet} and pk.akademska_godina={$ag} and p.id={$predmet} and ag.id={$ag} and pk.studij=s.id and (select count(*) from konacna_ocjena as ko where ko.student=o.id and ko.predmet={$predmet})>0 order by o.prezime, o.ime"; // Sve studente na predmetu } else { if ($_GET['tip'] == "sve") { // Uzecemo danasnji datum $upit .= "UNIX_TIMESTAMP(NOW()) from osoba as o, ponudakursa as pk, studij as s, predmet as p, akademska_godina as ag, student_predmet as sp where o.id=sp.student and sp.predmet=pk.id and pk.predmet={$predmet} and pk.akademska_godina={$ag} and p.id={$predmet} and ag.id={$ag} and pk.studij=s.id order by o.prezime, o.ime"; // Ovo se može desiti ako se klikne na prikaz pojedinačnog studenta, a nijedan student nije izabran // (npr. ako nijedan student ne sluša predmet) } else { biguglyerror("Neispravni parametri"); print "Da li je moguće da ovaj predmet ne sluša niti jedan student?"; return; } } } } } } // PDF inicijalizacija $pdf = new TCPDF('P', 'mm', 'a5', true, 'UTF-8', false); $pdf->SetCreator("Zamger"); $pdf->SetTitle('Printanje prijava'); $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); $pdf->SetMargins(0, 0, 0); $pdf->SetAutoPageBreak(false); $pdf->setLanguageArray($l); $pdf->SetFont('freesans', 'B', 9); $pdf->SetHeaderData("", 0, "", ""); $pdf->SetPrintHeader(false); $pdf->setFooterMargin($fm = 0); $pdf->SetPrintFooter(false); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO*2.083333); $pdf->setJPEGQuality(100); // Izvršenje upita $q10 = myquery($upit); while ($r10 = mysql_fetch_row($q10)) { $student = $r10[0]; $imeprezime = $r10[1] . " " . $r10[2]; $brind = $r10[3]; $godStudija = intval(($r10[4] + 1) / 2); $odsjek = $r10[5]; $nazivPr = $r10[6]; $skolskaGod = $r10[7]; // $NastavnikSl=$r10[9]; $datumIspita = date("d. m. Y.", $r10[8]); // $NastavnikPr=$r10[8]; // $datumPrijave=$r10[12]; $datumPrijave = $datumIspita; // $datumPolaganja=$r10[10]; $datumPolaganja = $datumIspita; // $datumUsmenog=$r10[13]; $datumUsmenog = $datumIspita; // $datumDrPar=$r10[14]; // Ispis nastavnika $q33 = myquery("select osoba from angazman where predmet={$predmet} and akademska_godina={$ag} and angazman_status=1"); if (mysql_num_rows($q33) == 1) { // Ako imaju dva odgovorna nastavnika, ne znam kojeg da stavim $id_nastavnika = mysql_result($q33, 0, 0); $nastavnik = tituliraj($id_nastavnika, $sa_akademskim_zvanjem = false); } else { $nastavnik = ""; } // Da li ima uslov? if ($_GET['tip'] == "uslov") { // Dva parcijalna ispita $q35 = myquery("select count(*) from ispitocjene as io, ispit as i, komponenta as k where io.student={$student} and io.ispit=i.id and i.predmet={$predmet} and i.akademska_godina={$ag} and i.komponenta=k.id and k.tipkomponente=1 and io.ocjena>=k.prolaz"); $parcijalnih = mysql_result($q35, 0, 0); // Integralni ispiti $q37 = myquery("select count(*) from ispitocjene as io, ispit as i, komponenta as k where io.student={$student} and io.ispit=i.id and i.predmet={$predmet} and i.akademska_godina={$ag} and i.komponenta=k.id and k.tipkomponente=2 and io.ocjena>=k.prolaz"); $integralnih = mysql_result($q37, 0, 0); if ($integralnih == 1 || $parcijalnih == 2) { // FIXME: ovo radi samo za ETF Bologna standard kreirajPrijavu($pdf, $imeprezime, $brind, $godStudija, $odsjek, $nazivPr, $skolskaGod, $datumIspita, $nastavnik); } } else { // Da li je student polozio predmet? $q40 = myquery("select ocjena, UNIX_TIMESTAMP(datum_u_indeksu), datum_provjeren from konacna_ocjena where student={$student} and predmet={$predmet}"); if (mysql_num_rows($q40) > 0) { $ocjena = mysql_result($q40, 0, 0); $datum_provjeren = mysql_result($q40, 0, 2); if ($datum_provjeren) { $datumIspita = $datumPrijave = $datumPolaganja = $datumUsmenog = date("d. m. Y.", mysql_result($q40, 0, 1)); } } else { $ocjena = 0; } kreirajPrijavu($pdf, $imeprezime, $brind, $godStudija, $odsjek, $nazivPr, $skolskaGod, $datumIspita, $ocjena, $nastavnik); // print "$pdf, $imeprezime, $brind, $godStudija, $odsjek, $nazivPr, $skolskaGod, $datumIspita ($r10[8]), $ocjena, $nastavnik<br>\n"; } } $pdf->Output($filename, 'I'); }
public function PostAction() { $rma_ids = $this->getRequest()->getParam('povratnica'); if (!count($rma_ids)) { exit; } $broj_povratnice = Mage::helper('rma')->getBrojPovratnice(); $dobavljac = Mage::getModel('rma/rmadevices')->load($rma_ids[0])->getSupplier(); require_once Mage::getBaseDir('lib') . '/tcpdf/tcpdf.php'; // create new PDF document $pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false); $pdf->setPrintHeader(false); $pdf->setPrintFooter(false); // set font $pdf->SetFont('helvetica', '', 11); // add a page $pdf->AddPage(); $pdf->setJPEGQuality(100); // set cell padding $pdf->setCellPaddings(0, 0, 0, 0); $pdf->SetLineWidth(0.2); // set cell margins $pdf->setCellMargins(0, 0, 0, 0); $pdf->setCellHeightRatio(1); // set color for background $pdf->SetFillColor(255, 255, 255); // Multicell // MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0) // Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=0, $link='', $stretch=0, $ignore_min_height=false, $calign='T', $valign='M') $pdf->SetFont('helvetica', '', 11); $pdf->MultiCell(150, 0, 'BENGAZI DOO NIŠ, KRFSKA 18', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(100, 0, 'PIB: 104028469', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(100, 0, 'šifra delatnosti: 4666', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(100, 0, 'TR: 160-214265-03 / Banca Intesa a.d.', 0, 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->SetFont('helvetica', '', 16); $pdf->MultiCell(100, 0, 'Povratnica na servis ' . date("Y") . "/" . $broj_povratnice, 0, 'L', 1, 0, 65, '', true, 0, false); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->SetFont('helvetica', '', 11); $pdf->MultiCell(100, 6, 'Niš, ' . date("j.n.Y"), 0, 'L', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 6, $dobavljac, 0, 'L', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->Ln(); $pdf->MultiCell(20, 8, "Redni broj", 'TL', 'C', 1, 0, '', '', true, 0, false); $pdf->MultiCell(70, 8, "Naziv artikla", 'LT', 'C', 1, 0, 30, '', true, 0, false); $pdf->MultiCell(20, 8, "jm", 'LT', 'C', 1, 0, 100, '', true, 0, false); $pdf->MultiCell(20, 8, "kolicina", 'LT', 'C', 1, 0, 120, '', true, 0, false); $pdf->MultiCell(60, 8, "Opis kvara", 'LTR', 'C', 1, 0, 140, '', true, 0, false); $pdf->Ln(); foreach ($rma_ids as $pos => $rbr) { $rma = Mage::getModel('rma/rmadevices')->load($rbr); $sn = $rma->getSerial() ? ' sn: ' . $rma->getSerial() : ''; $pdf->MultiCell(20, 8, $pos + 1, 'TL', 'C', 1, 0, '', '', true, 0, false); $pdf->MultiCell(70, 8, $rma->getName() . $sn, 'LT', 'C', 1, 0, 30, '', true, 0, false); $pdf->MultiCell(20, 8, "kom", 'LT', 'C', 1, 0, 100, '', true, 0, false); $pdf->MultiCell(20, 8, "1", 'LT', 'C', 1, 0, 120, '', true, 0, false); $pdf->MultiCell(60, 8, $rma->getDescription(), 'LTR', 'C', 1, 0, 140, '', true, 0, false); $pdf->Ln(); $rma->setDocumentId($broj_povratnice)->save(); } $pdf->MultiCell(190, 8, "", 'T', 'C', 1, 0, '', '', true, 0, false); $pdf->Ln(); $pdf->Ln(); $pdf->MultiCell(50, 5, "", 'B', 'C', 1, 0, '', '', true, 0, false); $pdf->MultiCell(20, 2, "mp", 0, 'C', 1, 0, 100, '', true, 0, false); $pdf->MultiCell(50, 5, "Predrag Stevanovic", 'B', 'C', 1, 0, 150, '', true, 0, false); $pdf->Ln(); $pdf->MultiCell(50, 10, "robu primio", 0, 'C', 1, 0, '', '', true, 0, false); $pdf->MultiCell(50, 10, "robu predao", 0, 'C', 1, 0, 150, '', true, 0, false); // Close and output PDF document $pdf->IncludeJS("print();"); //ob_clean(); //stupid tcpdf need this $pdf->Output(Mage::getBaseDir('media') . '/rma_pdf/' . $broj_povratnice . "-" . $dobavljac . '.pdf', 'FI'); exit; }
/** * 图片 */ function pdf_seven() { require_once 'tcpdf.php'; // create new PDF document $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('Nicola Asuni'); $pdf->SetTitle('TCPDF Example 009'); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // set default header data $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE . ' 009', PDF_HEADER_STRING); // set header and footer fonts $pdf->setHeaderFont(array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); $pdf->setFooterFont(array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); // set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); $pdf->SetHeaderMargin(PDF_MARGIN_HEADER); $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); // set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); // set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); // set some language-dependent strings (optional) if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) { require_once dirname(__FILE__) . '/lang/eng.php'; $pdf->setLanguageArray($l); } // ------------------------------------------------------------------- // add a page $pdf->AddPage(); // set JPEG quality $pdf->setJPEGQuality(75); // Image method signature: // Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false) // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Example of Image from data stream ('PHP rules') $imgdata = base64_decode('iVBORw0KGgoAAAANSUhEUgAAABwAAAASCAMAAAB/2U7WAAAABlBMVEUAAAD///+l2Z/dAAAASUlEQVR4XqWQUQoAIAxC2/0vXZDrEX4IJTRkb7lobNUStXsB0jIXIAMSsQnWlsV+wULF4Avk9fLq2r8a5HSE35Q3eO2XP1A1wQkZSgETvDtKdQAAAABJRU5ErkJggg=='); // The '@' character is used to indicate that follows an image data stream and not an image file name $pdf->Image('@' . $imgdata); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Image example with resizing $pdf->Image('examples/images/image_demo.jpg', 15, 140, 75, 113, 'JPG', 'http://www.tcpdf.org', '', true, 150, '', false, false, 1, false, false, false); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // test fitbox with all alignment combinations $horizontal_alignments = array('L', 'C', 'R'); $vertical_alignments = array('T', 'M', 'B'); $x = 15; $y = 35; $w = 30; $h = 30; // test all combinations of alignments for ($i = 0; $i < 3; ++$i) { $fitbox = $horizontal_alignments[$i] . ' '; $x = 15; for ($j = 0; $j < 3; ++$j) { $fitbox[1] = $vertical_alignments[$j]; $pdf->Rect($x, $y, $w, $h, 'F', array(), array(128, 255, 128)); $pdf->Image('examples/images/image_demo.jpg', $x, $y, $w, $h, 'JPG', '', '', false, 300, '', false, false, 0, $fitbox, false, false); $x += 32; // new column } $y += 32; // new row } $x = 115; $y = 35; $w = 25; $h = 50; for ($i = 0; $i < 3; ++$i) { $fitbox = $horizontal_alignments[$i] . ' '; $x = 115; for ($j = 0; $j < 3; ++$j) { $fitbox[1] = $vertical_alignments[$j]; $pdf->Rect($x, $y, $w, $h, 'F', array(), array(128, 255, 255)); $pdf->Image('examples/images/image_demo.jpg', $x, $y, $w, $h, 'JPG', '', '', false, 300, '', false, false, 0, $fitbox, false, false); $x += 27; // new column } $y += 52; // new row } // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Stretching, position and alignment example $pdf->SetXY(110, 200); $pdf->Image('examples/images/image_demo.jpg', '', '', 40, 40, '', '', 'T', false, 300, '', false, false, 1, false, false, false); $pdf->Image('examples/images/image_demo.jpg', '', '', 40, 40, '', '', '', false, 300, '', false, false, 1, false, false, false); // ------------------------------------------------------------------- //饼状图 // add a page $pdf->AddPage(); $pdf->Write(0, 'Example of PieSector() method.'); $xc = 105; $yc = 100; $r = 50; $pdf->SetFillColor(0, 0, 255); $pdf->PieSector($xc, $yc, $r, 20, 120, 'FD', false, 0, 2); $pdf->SetFillColor(0, 255, 0); $pdf->PieSector($xc, $yc, $r, 120, 250, 'FD', false, 0, 2); $pdf->SetFillColor(255, 0, 0); $pdf->PieSector($xc, $yc, $r, 250, 20, 'FD', false, 0, 2); // write labels $pdf->Text(105, 65, 'BLUE11'); $pdf->Text(60, 95, 'GREEN'); $pdf->Text(120, 115, 'RED'); //二维码 // add a page $pdf->AddPage(); // print a message $txt = "You can also export 2D barcodes in other formats (PNG, SVG, HTML). Check the examples inside the barcode directory.\n"; $pdf->MultiCell(70, 50, $txt, 0, 'J', false, 1, 125, 30, true, 0, false, true, 0, 'T', false); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // set style for barcode $style = array('border' => true, 'vpadding' => 'auto', 'hpadding' => 'auto', 'fgcolor' => array(0, 0, 0), 'bgcolor' => false, 'module_width' => 1, 'module_height' => 1); // write RAW 2D Barcode $code = '111011101110111,010010001000010,010011001110010,010010000010010,010011101110010'; $pdf->write2DBarcode($code, 'RAW', 80, 30, 30, 20, $style, 'N'); // write RAW2 2D Barcode $code = '[111011101110111][010010001000010][010011001110010][010010000010010][010011101110010]'; $pdf->write2DBarcode($code, 'RAW2', 80, 60, 30, 20, $style, 'N'); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // set style for barcode $style = array('border' => 2, 'vpadding' => 'auto', 'hpadding' => 'auto', 'fgcolor' => array(0, 0, 0), 'bgcolor' => false, 'module_width' => 1, 'module_height' => 1); // QRCODE,L : QR-CODE Low error correction $pdf->write2DBarcode('你好!哈哈', 'QRCODE,L', 20, 30, 50, 50, $style, 'N'); $pdf->Text(20, 25, 'QRCODE L'); // QRCODE,M : QR-CODE Medium error correction $pdf->write2DBarcode('www.tcpdf.org', 'QRCODE,M', 20, 90, 50, 50, $style, 'N'); $pdf->Text(20, 85, 'QRCODE M'); // QRCODE,Q : QR-CODE Better error correction $pdf->write2DBarcode('www.tcpdf.org', 'QRCODE,Q', 20, 150, 50, 50, $style, 'N'); $pdf->Text(20, 145, 'QRCODE Q'); // QRCODE,H : QR-CODE Best error correction $pdf->write2DBarcode('www.tcpdf.org', 'QRCODE,H', 20, 210, 50, 50, $style, 'N'); $pdf->Text(20, 205, 'QRCODE H'); // ------------------------------------------------------------------- // PDF417 (ISO/IEC 15438:2006) /* The $type parameter can be simple 'PDF417' or 'PDF417' followed by a number of comma-separated options: 'PDF417,a,e,t,s,f,o0,o1,o2,o3,o4,o5,o6' Possible options are: a = aspect ratio (width/height); e = error correction level (0-8); Macro Control Block options: t = total number of macro segments; s = macro segment index (0-99998); f = file ID; o0 = File Name (text); o1 = Segment Count (numeric); o2 = Time Stamp (numeric); o3 = Sender (text); o4 = Addressee (text); o5 = File Size (numeric); o6 = Checksum (numeric). Parameters t, s and f are required for a Macro Control Block, all other parametrs are optional. To use a comma character ',' on text options, replace it with the character 255: "\xff". */ $pdf->write2DBarcode('www.tcpdf.org', 'PDF417', 80, 90, 0, 30, $style, 'N'); $pdf->Text(80, 85, 'PDF417 (ISO/IEC 15438:2006)'); // ------------------------------------------------------------------- // DATAMATRIX (ISO/IEC 16022:2006) $pdf->write2DBarcode('http://www.tcpdf.org', 'DATAMATRIX', 80, 150, 50, 50, $style, 'N'); $pdf->Text(80, 145, 'DATAMATRIX (ISO/IEC 16022:2006)'); // ------------------------------------------------------------------- // new style $style = array('border' => 2, 'padding' => 'auto', 'fgcolor' => array(0, 0, 255), 'bgcolor' => array(255, 255, 64)); // QRCODE,H : QR-CODE Best error correction $pdf->write2DBarcode('www.tcpdf.org', 'QRCODE,H', 80, 210, 50, 50, $style, 'N'); $pdf->Text(80, 205, 'QRCODE H - COLORED'); // new style $style = array('border' => false, 'padding' => 0, 'fgcolor' => array(128, 0, 0), 'bgcolor' => false); // QRCODE,H : QR-CODE Best error correction $pdf->write2DBarcode('www.tcpdf.org', 'QRCODE,H', 140, 210, 50, 50, $style, 'N'); $pdf->Text(140, 205, 'QRCODE H - NO PADDING'); //Close and output PDF document $pdf->Output('example.pdf', 'I'); }
//set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings $pdf->setLanguageArray($l); // - - - - - - - - - - - - - - - - - - - - - - - - - - - - - // Print a table /* dc_YDown() */ function dc_YDown($a = 0) { global $pdf; $pdf->SetY($pdf->GetY() + $a); // Line break 2mm return $pdf->GetY(); } // set JPEG quality $pdf->setJPEGQuality(75); // Image method signature: // Image($file, $x='', $y='', $w=0, $h=0, $type='', $link='', $align='', $resize=false, $dpi=300, $palign='', $ismask=false, $imgmask=false, $border=0, $fitbox=false, $hidden=false, $fitonpage=false) // set font $pdf->SetFont('dejavusans', '', 11, '', true); // set cell padding $pdf->setCellPaddings(0, 0, 0, 0.5); //$left='', $top='', $right='', $bottom='') // set cell margins $pdf->setCellMargins(0, 0, 0, 0); // set color for background $pdf->SetFillColor(255, 255, 255); // MultiCell($w, $h, $txt, $border=0, $align='J', $fill=0, $ln=1, $x='', $y='', $reseth=true, $stretch=0, $ishtml=false, $autopadding=true, $maxh=0) // START ////////////////////////// // Queries: //$t=dbSel("*","catalog","W/`dcid`='$dcid' LIMIT 0,1");
function showPdf($idReg = "") { global $db; // Oficina $sesIdOficina = $_SESSION[sesIdOficina]; $oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina); // create new PDF document $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, 'LETTER', false, 'ISO-8859-1', false); // set document information $pdf->SetCreator(PDF_CREATOR); $pdf->SetAuthor('Nicola Asuni'); $pdf->SetTitle('TCPDF Example 009'); $pdf->SetSubject('TCPDF Tutorial'); $pdf->SetKeywords('TCPDF, PDF, example, test, guide'); // set default header data //$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 009', PDF_HEADER_STRING); // set header and footer fonts //$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); //$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); //set margins $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); //$pdf->SetHeaderMargin(PDF_MARGIN_HEADER); // $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); // $pdf->SetFooterMargin(3); $pdf->setPageOrientation('P', '', 1); //set auto page breaks $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); //set image scale factor $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); //set some language-dependent strings //$pdf->setLanguageArray($l); // set some language dependent data: $lg = array(); $lg['a_meta_charset'] = 'ISO-8859-1'; $lg['a_meta_dir'] = 'ltr'; $lg['a_meta_language'] = 'en'; $lg['w_page'] = 'page'; //set some language-dependent strings $pdf->setLanguageArray($lg); // ------------------------------- // CONSULTA DE DATOS // ------------------------------- $sql = "select * from PENSION where id_pension='{$idReg}'"; $db->query($sql); while ($db->next_record()) { $noRecibo = $db->f(id_pension); $entFec = $db->f(ent_fec); $salFec = $db->f(sal_fec); $idConte = $db->f(id_contenedor); $conte = getValueTable("numero", "CONTENEDOR", "id_contenedor", $idConte); $idEq = getValueTable("id_equipo", "CONTENEDOR", "id_contenedor", $idConte); $equipo = getValueTable("equipo", "EQUIPO", "id_equipo", $idEq); $concepto = $db->f(concepto); $operador = $db->f(operador); $placas = $db->f(placas); $monto = $db->f(monto); $montoLetra = traducirCifra($monto); $idOficina = $db->f(id_oficina); $transporte = $db->f(transporte); $metPago = $db->f(met_pago); } // --------------------------------------------------------- // DATOS DEL RECIBO // --------------------------------------------------------- $datoRecibo = "\n\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES TMA</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>ENTRADA</b></td>\n <td><b>SALIDA</b></td> \n <td><b>TRANSPORTE</b></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$entFec}</td> \n <td>{$salFec}</td>\n <td>{$transporte}</td>\n <td>{$conte}</td>\n <td>{$equipo}</td>\n </tr> \n <tr> \n <td colspan=\"2\"><b>OPERADOR</b></td> \n <td><b>PLACAS</b></td> \n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td colspan=\"2\">{$operador}</td>\n <td>{$placas}</td> \n <td colspan=\"2\">{$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>{$concepto} \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>SUBTOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n </table>\n </td>\n </tr>\n <tr>\n <td colspan=\"3\" align=\"center\">\n RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100<br> \n <b>Metodo de pago :</b> {$metPago}<br>\n ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>\n EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO<br>\n PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.<br>\n Solicitarla al correo: facturacionpatios@demo.com.mx<br>\n </td>\n </tr>\n </table> \n\n <br><br><br><br><br><br>\n <center>---------------------------------- RECIBO PARA VIGILANCIA ---------------------------------- </center> \n <br><br><br><br><br>\n\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\"> \n <tr>\n <td colspan=\"4\" valign=\"middle\"><b>DEPOSITO DE CONTENEDORES</b></td>\n <td>\n <table cellspacing=\"1\" cellpadding=\"2\" border=\"0\" align=\"center\"> \n <tr>\n <td bgcolor=\"black\"><b><font color=\"white\">FOLIO</font></b></td>\n </tr>\n <tr>\n <td><font color=\"red\"><b>No. {$noRecibo}</b></font></td>\n </tr>\n </table>\n </td>\n </tr> \n <tr>\n <td><b>ENTRADA</b></td>\n <td><b>SALIDA</b></td> \n <td><b>TRANSPORTE</b></td>\n <td><b>CONTENEDOR</b></td>\n <td><b>TIPO</b></td>\n </tr>\n <tr>\n <td>{$entFec}</td> \n <td>{$salFec}</td>\n <td>{$transporte}</td>\n <td>{$conte}</td>\n <td>{$equipo}</td>\n </tr> \n <tr> \n <td colspan=\"2\"><b>OPERADOR</b></td> \n <td><b>PLACAS</b></td> \n <td colspan=\"2\"><b>OBSERVACIONES</b></td> \n </tr> \n <tr> \n <td colspan=\"2\">{$operador}</td>\n <td>{$placas}</td> \n <td colspan=\"2\">{$nota}</td> \n </tr>\n </table>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td ><b>FIRMA OPERADOR</b></td>\n <td ><b>FIRMA DEL DEPOSITO</b></td>\n <td>\n <table cellspacing=\"0\" cellpadding=\"3\" border=\"1\" align=\"center\">\n <tr>\n <td align=\"right\"><b>{$concepto} \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>SUBTOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n <tr>\n <td align=\"right\"><b>TOTAL \$</b></td>\n <td align=\"right\">{$monto}</td>\n </tr> \n </table>\n </td>\n </tr>\n <tr>\n <td colspan=\"3\" align=\"center\">\n RECIBIMOS DE <u>{$operador}</u> LA CANTIDAD DE {$montoLetra} PESOS M.N. 00/100 <br>\n <b>Metodo de pago :</b> {$metPago}<br>\n ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>\n EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO<br>\n PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.<br>\n Solicitarla al correo: facturacionpatios@demo.com.mx<br>\n </td>\n </tr>\n </table> \n\n "; // ------------------------------------------------------------------- $pdf->AddPage(); // Logo $pdf->setJPEGQuality(100); $pdf->Image('../images/logo_color.jpg', 13, 4, 25, 25, '', '', '', false); //$pdf->Image('../images/nome.jpg', 15, 140, 185, 96,'','','',false); // set cell padding //$pdf->setCellPaddings(1, 1, 1, 1); // set cell margins //$pdf->setCellMargins(1, 1, 1, 1); // Encabezado $pdf->SetFillColor(197, 197, 197); if ($idOficina == 1) { $txt = "ALMARTCON S.A. DE C.V.\n\"El Trébol\""; $pdf->SetFont('helvetica', '', 14); $pdf->MultiCell(65, 4, $txt, 0, 'L', 0, 0, 40, 10, true); $txt = "Direccion, Guatemala \\Tel. 505-2350-0976 Cel. 505-8635-0708"; $pdf->SetFont('helvetica', '', 7); $pdf->MultiCell(60, 4, $txt, 0, 'C', 0, 0, 105, 10, true); } /* elseif( $idOficina==2 ){ $txt = "ALMARTCON S.A DE C.V.\n\"El Arbol\""; $pdf->SetFont('helvetica', '', 14); $pdf->MultiCell(65, 4,$txt, 0, 'L',0, 0, 40, 10,true); $txt="Av. Refinería Azcapotzalco S/N \nEsq. Ferrocarriles Nacionales.\nMéxico D.F."; $pdf->SetFont('helvetica', '', 7); $pdf->MultiCell(60, 4,$txt, 0, 'C',0, 0, 105, 10,true); } elseif( $idOficina==3 ){ $txt = "TRANSPORTES MALEJA S.A DE C.V.\n\"El Pino\""; $pdf->SetFont('helvetica', '', 14); $pdf->MultiCell(65, 4,$txt, 0, 'L',0, 0, 40, 10,true); $txt="Carretera Querétaro San Luis Potosí Km.28\nCol.Buenavista Santa Rosa Jauregui\nQueretaro, QRO."; $pdf->SetFont('helvetica', '', 7); $pdf->MultiCell(60, 4,$txt, 0, 'C',0, 0, 105, 10,true); } */ $pdf->SetFont('helvetica', '', 12); //$tbl = <<<EOD EOD; //$pdf->writeHTML($tbl, true, false, false, false, ''); $txt = "RECIBO"; $pdf->SetFont('helvetica', 'B', 12); $pdf->MultiCell(100, 4, $txt, 0, 'C', 0, 0, 60, 37, true); $pdf->SetFont('helvetica', '', 8); $tbl = <<<EOD <br><br><br> {$datoRecibo} EOD; //$tbl = "$datoRecibo"; $pdf->writeHTML($tbl, true, false, false, false, ''); $txt = "EMISION DE FACTURA DENTRO DE LOS 5 DIAS POSTERIORES A LA REALIZACIÓN DE SU SERVICIO\n PASADO ESTE TIEMPO NO HABRÁ EMISIÓN DE FACTURAS.\n Solicitarla al correo: facturacionpatios@demo.com.mx"; $noRecibo > 0 ? $corY = 200 : ($corY = 125); //$pdf->MultiCell(185, 4,$txt, 1, 'C',0, 0, 16, 109,true); /* ($noRecibo>0)?$corY=180:$corY=105; $txt="POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40,10,$txt, 1, 'C',0, 0, 15, $corY,true); $txt="POR DEPOSITO\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(30, 10,$txt, 1, 'C',0, 0, 55, $corY,true); $txt="AUTO. DE REPARACION\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10,$txt, 1, 'C',0, 0, 85, $corY,true); $txt="POR TRANSPORTISTA\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(40, 10,$txt, 1, 'C',0, 0, 125, $corY,true); $txt="POR DEPOSITO\n\n\nNOMBRE Y FIRMA"; $pdf->MultiCell(35, 10,$txt, 1, 'C',0, 0, 165, $corY,true); */ //Close and output PDF document $pdf->Output('reciboPension.pdf', 'I'); }