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;
}
private function Rotate($type, $x = -1, $y = -1)
{
if ($type == "") {
$angle = 0;
} elseif ($type == "Left") {
$angle = 90;
} elseif ($type == "Right") {
$angle = 270;
} elseif ($type == "UpsideDown") {
$angle = 180;
}
if ($x == -1) {
$x = $this->pdf->getX();
}
if ($y == -1) {
$y = $this->pdf->getY();
}
if ($this->angle != 0) {
$this->pdf->_out('Q');
}
$this->angle = $angle;
if ($angle != 0) {
$angle *= M_PI / 180;
$c = cos($angle);
$s = sin($angle);
$cx = $x * $this->pdf->k;
$cy = ($this->pdf->h - $y) * $this->pdf->k;
$this->pdf->_out(sprintf('q %.5f %.5f %.5f %.5f %.2f %.2f cm 1 0 0 1 %.2f %.2f cm', $c, $s, -$s, $c, $cx, $cy, -$cx, -$cy));
}
}
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 007');
$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 . ' 007', 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);
// ---------------------------------------------------------
// set font
$pdf->SetFont('times', '', 12);
// add a page
$pdf->AddPage();
// create columns content
$left_column = '<b>LEFT COLUMN</b> left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column';
$right_column = '<b>RIGHT COLUMN</b> right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column';
// writeHTMLCell($w, $h, $x, $y, $html='', $border=0, $ln=0, $fill=0, $reseth=true, $align='', $autopadding=true)
// get current vertical position
$y = $pdf->getY();
// set color for background
$pdf->SetFillColor(255, 255, 200);
// set color for text
$pdf->SetTextColor(0, 63, 127);
// write the first column
$pdf->writeHTMLCell(80, '', '', $y, $left_column, 1, 0, 1, true, 'J', true);
// set color for background
$pdf->SetFillColor(215, 235, 255);
// set color for text
$pdf->SetTextColor(127, 31, 0);
// write the second column
$pdf->writeHTMLCell(80, '', '', '', $right_column, 1, 1, 1, true, 'J', true);
// reset pointer to the last page
$pdf->lastPage();
$this->comparePdfs($pdf);
}
/**
* set the New position for the current Tag
*
* @access public
*/
public function setPosition()
{
// get the current position
$currentX = $this->_pdf->getX();
$currentY = $this->_pdf->getY();
// save it
$this->value['xc'] = $currentX;
$this->value['yc'] = $currentY;
if ($this->value['position'] == 'relative' || $this->value['position'] == 'absolute') {
if ($this->value['right'] !== null) {
$x = $this->getLastWidth(true) - $this->value['right'] - $this->value['width'];
if ($this->value['margin']['r']) {
$x -= $this->value['margin']['r'];
}
} else {
$x = $this->value['left'];
if ($this->value['margin']['l']) {
$x += $this->value['margin']['l'];
}
}
if ($this->value['bottom'] !== null) {
$y = $this->getLastHeight(true) - $this->value['bottom'] - $this->value['height'];
if ($this->value['margin']['b']) {
$y -= $this->value['margin']['b'];
}
} else {
$y = $this->value['top'];
if ($this->value['margin']['t']) {
$y += $this->value['margin']['t'];
}
}
if ($this->value['position'] == 'relative') {
$this->value['x'] = $currentX + $x;
$this->value['y'] = $currentY + $y;
} else {
$this->value['x'] = $this->_getLastAbsoluteX() + $x;
$this->value['y'] = $this->_getLastAbsoluteY() + $y;
}
} else {
$this->value['x'] = $currentX;
$this->value['y'] = $currentY;
if ($this->value['margin']['l']) {
$this->value['x'] += $this->value['margin']['l'];
}
if ($this->value['margin']['t']) {
$this->value['y'] += $this->value['margin']['t'];
}
}
// save the new position
$this->_pdf->setXY($this->value['x'], $this->value['y']);
}
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);
}
}
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
$pdf->setLanguageArray($l);
//initialize document
$pdf->AliasNbPages();
// add a page
$pdf->AddPage();
// ---------------------------------------------------------
// set font
$pdf->SetFont("times", "", 12);
// create columns content
$left_column = "<b>left column</b> left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column";
$right_column = "<b>right column</b> right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column";
// set columns width
$first_column_width = 80;
$second_column_width = 80;
// get current vertical position
$current_y_position = $pdf->getY();
// write the first column
$pdf->writeHTMLCell($first_column_width, 0, 0, $current_y_position, $left_column, 1, 0, 0, true);
// write the second column
$pdf->writeHTMLCell($second_column_width, 0, 0, 0, $right_column, 1, 1, 0, true);
// reset pointer to the last page
$pdf->lastPage();
// ---------------------------------------------------------
//Close and output PDF document
$pdf->Output("example_007.pdf", "I");
//============================================================+
// END OF FILE
//============================================================+
// set font
$pdf->SetFont('times', '', 14);
// add a page
$pdf->AddPage();
// create columns content
$left_column = '<b>LEFT COLUMN</b> left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column left column';
$right_column = '<b>RIGHT COLUMN</b> right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column right column';
// writeHTMLCell($w, $h, $x, $y, $html='', $border=0, $ln=0, $fill=0, $reseth=true, $align='', $autopadding=true)
// get current vertical position
$y = $pdf->getY();
// set color for background
$pdf->SetFillColor(255, 255, 200);
// set color for text
$pdf->SetTextColor(0, 63, 127);
// write the first column
$pdf->writeHTMLCell(80, '', '', $y, $left_column, 1, 0, 1, true, 'J', true);
// set color for background
$pdf->SetFillColor(215, 235, 255);
// set color for text
$pdf->SetTextColor(127, 31, 0);
function loanPaperWorkPDF()
{
$this->loan->LoanNumber = $this->loaninfo['LoanNumber'];
$this->Address();
$this->LoanAgentString();
$this->preptypes = array('Sheet' => 'sheet', 'Packet' => 'packet', 'Microscope slide' => 'microscope slide', 'Spirit' => 'spirit jar', 'Cibachrome' => 'cibachrome', 'Photograph of specimen' => 'photograph', 'Type' => 'type');
$this->LoanSummaryString();
$this->loanPrepHeader = array('LoanNumber' => $this->loan->LoanNumber, 'LoanAgent' => $this->LoanAgents, 'ShipmentDate' => $this->loaninfo['ShipmentDate'], 'LoanPrepSummary' => $this->LoanSummaryString());
$pdf = new TCPDF();
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Niels Klazenga');
$pdf->SetTitle('MEL Label');
$pdf->SetSubject('MEL Label');
//set margins
$pdf->SetMargins(25, 37, 25);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, 15);
// remove default header/footer
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->setViewerPreferences(array('FitWindow' => true));
// set font
$pdf->SetFont('helvetica', '', 10);
// set cell padding
$pdf->setCellPaddings(0, 0, 0, 0);
// set cell margins
$pdf->setCellMargins(0, 0, 0, 0);
// start loan cover letter
$pdf->AddPage();
$image_file = base_url() . 'images/loans_paperwork_background.png';
$pdf->Image($image_file, 163, 0, 30, 0, 'PNG', '', 'T', true, 300, '', false, false, 0, false, false, false);
$pdf->MultiCell(120, 5, $this->loaninfo['ShipmentDate'], 0, 'L', 0, 1, 25, 15, true, false, true);
$pdf->MultiCell(120, 5, $this->loan->ShippedTo, 0, 'L', 0, 1, 25, 22, true, false, true);
$pdf->MultiCell(125, 5, '<span style="font-size:16pt;font-weight:bold">MEL loan ' . $this->loan->LoanNumber . '</span>', 0, 'L', 0, 1, 25, 65, true, false, true);
$pdf->MultiCell(130, 1, '<hr/>', 0, 'L', 0, 1, 22.5, $pdf->GetY() + 1, true, false, true);
$w = 30;
$y = $pdf->GetY() - 2;
$pdf->MultiCell($w, 5, 'For study by:', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(120 - $w, 5, $this->LoanAgents, 0, 'L', 0, 1, 30 + $w, $y, true, false, true);
$y = $pdf->GetY() + 1;
$pdf->MultiCell($w, 5, 'Description:', 0, 'L', 0, 1, 25, $y, true, false, true);
$description = $this->loaninfo['Description'];
if (strpos($description, '||')) {
$description = substr($description, 0, strpos($description, '||'));
}
$description = trim($description);
$pdf->MultiCell(120 - $w, 5, $description, 0, 'L', 0, 1, 30 + $w, $y, true, false, true);
$y = $pdf->GetY() + 1;
$pdf->MultiCell($w, 5, 'Quantity:', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(120 - $w, 5, $this->Quantity(), 0, 'L', 0, 1, 30 + $w, $y, true, false, true);
$y = $pdf->GetY() + 1;
$pdf->MultiCell($w, 5, 'Due date:', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(120 - $w, 5, $this->loaninfo['CurrentDueDate'], 0, 'L', 0, 1, 30 + $w, $y, true, false, true);
$y = $pdf->GetY() + 1;
$pdf->MultiCell($w, 5, 'Shipment details:', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(120 - $w, 5, $this->loaninfo['ShipmentMethod'], 0, 'L', 0, 1, 30 + $w, $y, true, false, true);
if ($this->loaninfo['TrackingLabels']) {
$y = $pdf->GetY() + 1;
$pdf->MultiCell($w, 5, 'Tracking label(s):', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(120 - $w, 5, $this->loaninfo['TrackingLabels'], 0, 'L', 0, 1, 30 + $w, $y, true, false, true);
}
$y = $pdf->GetY() + 1;
$pdf->MultiCell($w, 5, 'Loan conditions:', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(120 - $w, 5, 'See attached. ' . $this->loaninfo['SpecialConditions'], 0, 'L', 0, 1, 30 + $w, $y, true, false, true);
$pdf->MultiCell(130, 5, '<hr/>', 0, 'L', 0, 1, 22.5, $pdf->GetY() + 1, true, false, true);
$paragraphs = array();
$paragraphs[] = <<<EOD
Please verify the contents of the loan against the attached specimen list and acknowledge
receipt by returning the yellow copy of this form. Any damage in transit should be noted
on the yellow form.
EOD;
$paragraphs[] = <<<EOD
This loan should be returned to MEL by the date shown above. An extension may be granted
on request.
EOD;
if (strstr($this->LoanAgents, ' and ')) {
$c = 'comply';
} else {
$c = 'complies';
}
$paragraphs[] = <<<EOD
Please ensure that {$this->LoanAgents} {$c} with the enclosed loan conditions.
EOD;
$paragraphs[] = <<<EOD
Electronic data for the specimens in this loan is available on request. For queries relating
to loans, exchange or donations, please email MEL at herbmel@rbg.vic.gov.au.
EOD;
foreach ($paragraphs as $para) {
$pdf->Multicell(125, 5, $para, 0, 'J', 0, 1, 25, $pdf->GetY() + 1, true, false, true);
}
$pdf->MultiCell(125, 5, $this->loaninfo['ShippedBy'] . ' on behalf of the Collections Manager', 0, 'L', 0, 1, 25, $pdf->GetY() + 8, true, false, true);
$y = 231;
//$image_file = base_url() . 'images/scissors.png';
//$pdf->Image($image_file, 22, $y-2.5, 5, 5, 'PNG', '', 'T', false, 300, '', false, false, 0, false, false, false);
//$pdf->MultiCell(127, 5, '<hr/>', 0, 'L', 0, 1, 25.5, $y, true, false, true);
$pdf->MultiCell(130, 5, '<hr/>', 0, 'L', 0, 1, 22.5, $y, true, false, true);
$y = $pdf->GetY() - 1;
$pdf->MultiCell(45, 5, 'Number of parcels: ' . $this->loaninfo['NumberOfPackages'], 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(75, 5, 'Number of specimens: ' . $this->Quantity(), 0, 'L', 0, 1, 75, $y, true, false, true);
$pdf->MultiCell(125, 5, 'Material received in good condition.', 0, 'L', 0, 1, 25, $pdf->GetY() + 3, true, false, true);
$y = $pdf->GetY() + 3;
$pdf->MultiCell(25, 5, 'Comments: ', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(105, 5, '<hr/>', 0, 'L', 0, 1, 45, $y + 4, true, false, true);
$pdf->MultiCell(125, 5, '<hr/>', 0, 'L', 0, 1, 25, $pdf->GetY() + 1, true, false, true);
$pdf->MultiCell(125, 5, '<hr/>', 0, 'L', 0, 1, 25, $pdf->GetY() + 1, true, false, true);
$y = $pdf->GetY() + 1;
$pdf->MultiCell(35, 5, 'Receiving officer:', 0, 'L', 0, 1, 25, $y, true, false, true);
$pdf->MultiCell(60, 5, '<hr/>', 0, 'L', 0, 1, 53, $y + 4, true, false, true);
$pdf->MultiCell(15, 5, 'Date: ', 0, 'L', 0, 1, 115, $y, true, false, true);
$pdf->MultiCell(25, 5, '<hr/>', 0, 'L', 0, 1, 125, $y + 4, true, false, true);
$pdf->setY(0);
$x = 165;
$pdf->SetFont('helvetica', '', 7);
$letterh = <<<EOD
<div style="color:#999999">National Herbarium of Victoria (MEL)<br />Birdwood Avenue<br />
South Yarra<br />
Victoria 3141<br />
Australia
</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, 60, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">CITES<br />AU 026</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Telephone<br />(03) 9252 2300</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Facsimile<br />(03) 9252 2413</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Email<br />herbmel@rbg.vic.gov.au</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Web<br/ >www.rbg.vic.gov.au/science</div>
EOD;
$pdf->MultiCell(31, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">The Royal Botanic Gardens Board (Victoria)</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 111, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Patron<br />Dame Elisabeth Murdoch</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Incorporating:</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 5, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Royal Botanic Gardens Melbourne</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">National Herbarium of Victoria</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Royal Botanic Gardens Cranbourne</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
$letterh = <<<EOD
<div style="color:#999999">Australian Research Centre for Urban Ecology</div>
EOD;
$pdf->MultiCell(30, 5, $letterh, 0, 'L', 0, 1, $x, $pdf->getY() + 1, true, false, true);
// move pointer to last page
$pdf->lastPage();
// ---------------------------------------------------------
//Close and output PDF document
$pdf->Output('loan.pdf', 'I');
}
function writeDetalles(DataSource $dataSource, TCPDF $pdf, $tipo)
{
$blackAll = array('LTRB' => array('width' => 0.3, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0)));
$widthMarginLeft = 1;
$width1 = 20;
$width2 = 85;
$pdf->Ln();
$pdf->SetFontSize(7.5);
$pdf->SetFont('', 'B');
$height = 5;
$pdf->SetFillColor(255, 255, 255, true);
$pdf->setTextColor(0, 0, 0);
if ($tipo == 'adjudicado') {
$pdf->Cell($width2 - $width1 * 2, $height, 'Item', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
} else {
$pdf->Cell($width2, $height, 'Item', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
}
$pdf->Cell($width1, $height, 'Cantidad Ref.', $blackAll, 0, 'L', true, '', 1, false, 'T', 'C');
if ($tipo != 'borrador') {
$pdf->Cell($width1, $height, 'Precio Unitario Ref.', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
}
$pdf->Cell($width1, $height, 'Cantidad Ofert.', $blackAll, 0, 'L', true, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Precio Unitario Ofert.', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Total Ofert.', $blackAll, 0, 'C', true, '', 1, false, 'T', 'C');
if ($tipo == 'adjudicado') {
$pdf->Cell($width1, $height, 'Cantidad Adj.', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Total', $blackAll, 0, 'l', true, '', 1, false, 'T', 'C');
}
$pdf->Ln();
$pdf->SetFontSize(6.5);
foreach ($dataSource->getDataset() as $row) {
$pdf->SetFont('', '');
$xAntesMultiCell = $pdf->getX();
$yAntesMultiCell = $pdf->getY();
//$totalItem
if ($tipo == 'borrador') {
$pdf->MultiCell($width2, $height, $row['desc_solicitud_det'] . "\r\n" . ' - ' . $row['descripcion_sol'], 1, 'L', false, 1);
$yDespuesMultiCell = $pdf->getY();
$height = $yDespuesMultiCell - $yAntesMultiCell;
$pdf->setXY($xAntesMultiCell + $width2, $yAntesMultiCell);
$pdf->Cell($width1, $height, $row['cantidad_sol'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, '', 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, '', 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, '', 1, 0, 'R', false, '', 1, false, 'T', 'C');
} else {
if ($tipo == 'cotizado') {
$pdf->MultiCell($width2, $height, $row['desc_solicitud_det'] . "\r\n" . ' - ' . $row['descripcion_sol'], 1, 'L', false, 1);
$yDespuesMultiCell = $pdf->getY();
$height = $yDespuesMultiCell - $yAntesMultiCell;
$pdf->setXY($xAntesMultiCell + $width2, $yAntesMultiCell);
$pdf->Cell($width1, $height, $row['cantidad_sol'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario_sol'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, $row['cantidad_coti'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$totalItem = number_format($row['cantidad_coti'] * $row['precio_unitario'], 2);
$pdf->Cell($width1, $height, $totalItem, 1, 0, 'R', false, '', 1, false, 'T', 'C');
} else {
$pdf->MultiCell($width2 - $width1 * 2, $height, $row['desc_solicitud_det'] . "\r\n" . ' - ' . $row['descripcion_sol'], 1, 'L', false, 1);
$yDespuesMultiCell = $pdf->getY();
$height = $yDespuesMultiCell - $yAntesMultiCell;
$pdf->setXY($xAntesMultiCell + $width2 - $width1 * 2, $yAntesMultiCell);
$pdf->Cell($width1, $height, $row['cantidad_sol'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario_sol'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, $row['cantidad_coti'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, number_format($row['precio_unitario'], 2), 1, 0, 'R', false, '', 1, false, 'T', 'C');
$totalItem = number_format($row['cantidad_coti'] * $row['precio_unitario'], 2);
$pdf->Cell($width1, $height, $totalItem, 1, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, $row['cantidad_adju'], 1, 0, 'R', false, '', 1, false, 'T', 'C');
$totalAdj = number_format($row['cantidad_adju'] * $row['precio_unitario'], 2);
$pdf->Cell($width1, $height, $totalAdj, 1, 0, 'R', false, '', 1, false, 'T', 'C');
}
}
$pdf->Ln();
}
}
function writeDetalles(DataSource $dataSource, TCPDF $pdf)
{
$blackAll = array('LTRB' => array('width' => 0.3, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0)));
$blackSide = array('LR' => array('width' => 0.3, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0)));
$blackBottom = array('B' => array('width' => 0.3, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0)));
$blackTop = array('T' => array('width' => 0.3, 'cap' => 'butt', 'join' => 'miter', 'dash' => 0, 'color' => array(0, 0, 0)));
$widthMarginLeft = 1;
$width1 = 15;
$width2 = 25;
$width3 = 20;
$pdf->SetFontSize(7.5);
$pdf->SetFont('', 'B');
$height = 5;
$pdf->Ln();
foreach ($dataSource->getDataset() as $row) {
$pdf->setFont('', 'B');
$pdf->Cell($width2, $height, 'Código Partida', 0, 0, 'L', false, '', 0, false, 'T', 'C');
$pdf->Cell($width2, $height, 'Nombre Partida', 0, 0, 'L', false, '', 0, false, 'T', 'C');
$pdf->Cell($width2 * 3 + 10, $height, 'Centro de Costo', 0, 0, 'L', false, '', 0, false, 'T', 'C');
$pdf->Cell($width2, $height, '', 0, 0, 'R', false, '', 0, false, 'T', 'C');
$pdf->Cell($width2, $height, 'Disponibilidad', 0, 0, 'R', false, '', 0, false, 'T', 'C');
$pdf->Ln();
$pdf->setFont('', '');
$pdf->Cell($width2, $height, $row['groupeddata'][0]['codigo_partida'], 0, 0, 'L', false, '', 0, false, 'T', 'C');
$pdf->Cell($width2, $height, $row['groupeddata'][0]['nombre_partida'], 0, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width2 * 3 + 10, $height, $row['groupeddata'][0]['desc_centro_costo'], 0, 0, 'L', false, '', 1, false, 'T', 'C');
$xRef = $pdf->getX();
$yRef = $pdf->getY();
$pdf->Cell($width2, $height, $row['totalRef'], 0, 0, 'R', false, '', 0, false, 'T', 'C');
if ($row['disponible'] == true) {
$pdf->setTextColor(0, 0, 0);
$pdf->Cell($width2, $height, 'DISPONIBLE', 0, 0, 'R', false, '', 0, false, 'T', 'C');
} else {
$pdf->setTextColor(255, 0, 0);
$pdf->Cell($width2, $height, 'NO DISPONIBLE', 0, 0, 'R', false, '', 0, false, 'T', 'C');
}
$pdf->setTextColor(0, 0, 0);
//$pdf->Cell($width2, $height, ($row['disponible']==true)?'DISPONIBLE':'NO DISPONIBLE', 0, 0, 'R', false, '', 0, false, 'T', 'C');
$pdf->Ln();
$pdf->setFont('', 'B');
$pdf->Cell($width2 + $width1, $height, 'Concepto Gasto', $blackAll, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width2 + 25, $height, 'Descripcion', $blackAll, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, 'Cantidad', $blackAll, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, 'Precio Unitario', $blackAll, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, 'Precio Total', $blackAll, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, 'Precio Ges. Act.', $blackAll, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, 'Precio Ges. Sig.', $blackAll, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Ln();
$totalRef = 0;
$totalGa = 0;
$totalSg = 0;
$xEnd = 0;
$yEnd = 0;
foreach ($row['groupeddata'] as $solicitudDetalle) {
$pdf->setFont('', '');
$pdf->Cell($width2 + $width1, $height, $solicitudDetalle['desc_concepto_ingas'], $blackSide, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width2 + 25, $height, $solicitudDetalle['descripcion'], $blackSide, 0, 'L', false, '', 1, false, 'T', 'C');
$pdf->Cell($width1, $height, $solicitudDetalle['cantidad'], $blackSide, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, number_format($solicitudDetalle['precio_unitario'], 2), $blackSide, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, number_format($solicitudDetalle['precio_total'], 2), $blackSide, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, number_format($solicitudDetalle['precio_ga'], 2), $blackSide, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, number_format($solicitudDetalle['precio_sg'], 2), $blackSide, 0, 'R', false, '', 1, false, 'T', 'C');
$totalRef = $totalRef + $solicitudDetalle['precio_total'];
$totalGa = $totalGa + $solicitudDetalle['precio_ga'];
$totalSg = $totalSg + $solicitudDetalle['precio_sg'];
$pdf->Ln();
$xEnd = $pdf->getX();
$yEnd = $pdf->getY();
}
//$pdf->setXY($xRef,$yRef);
//$pdf->Cell($width2, $height, $totalRef, 0, 0, 'R', false, '', 0, false, 'T', 'C');
$pdf->setXY($xEnd, $yEnd);
$pdf->Cell(185, $height, '', $blackTop, 1, 'L', false, '', 0, false, 'T', 'C');
$pdf->setXY($xEnd, $yEnd);
$pdf->Cell($width1 * 2 + $width2 * 2 + $width3 + 25, $height, '', '0', 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, number_format($totalRef, 2), $blackAll, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, number_format($totalGa, 2), $blackAll, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Cell($width3, $height, number_format($totalSg, 2), $blackAll, 0, 'R', false, '', 1, false, 'T', 'C');
$pdf->Ln($height * 2);
}
}
function printLabel($labeldata, $props, $start = 0)
{
$numx = $props['numx'];
$numy = $props['numy'];
$labelheight = $props['dimensions']['labelheight'];
$labelwidht = $props['dimensions']['labelwidth'];
$labelheader_pos = $props['dimensions']['labelheader_pos'];
$barcode_pos = $props['dimensions']['barcode_pos'];
$barcodetext_pos = $props['dimensions']['barcodetext_pos'];
$labelbody_pos = $props['dimensions']['labelbody_pos'];
$labelfooter_pos = $props['dimensions']['labelfooter_pos'];
$numlabels = $numx * $numy;
if ($this->input->post('labeltype') == 6 || $this->input->post('labeltype') == 7 || $this->input->post('labeltype') == 13 || $this->input->post('labeltype') == 14) {
$dup = true;
} else {
$dup = false;
}
set_time_limit(600);
// create new PDF document
$pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Niels Klazenga');
$pdf->SetTitle('MEL Label');
$pdf->SetSubject('MEL Label');
//set margins
$pdf->SetMargins(5, 7.5, 5);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, 7.5);
// remove default header/footer
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
// ---------------------------------------------------------
// set font
$pdf->SetFont('times', '', 9);
// set cell padding
$pdf->setCellPaddings(0, 0, 0, 0);
// set cell margins
$pdf->setCellMargins(0, 0, 0, 0);
if (!$dup) {
$labelheader = '<p style="font-weight: bold"><span style="font-size: 11pt;">NATIONAL HERBARIUM OF VICTORIA (MEL)</span><br />
<span style="font-size: 11pt;">MELBOURNE, AUSTRALIA</span></p>';
} else {
$labelheader = '<p style="font-weight: bold"><span style="font-size: 30px;">Ex NATIONAL HERBARIUM OF VICTORIA (MEL)</span><br />
<span style="font-size: 11pt;">MELBOURNE, AUSTRALIA</span></p>';
}
$barcodestyle = array('position' => '', 'padding' => 0, 'align' => 'C', 'stretch' => true, 'cellfitalign' => '', 'border' => false, 'hpadding' => 'auto', 'vpadding' => 'auto', 'fgcolor' => array(0, 0, 0), 'bgcolor' => false, 'text' => false);
if ($start > 0) {
$pdf->AddPage();
}
for ($i = 0; $i < count($labeldata); $i++) {
$j = $i + $start;
$offset = $j % ($numx * $numy);
$x = $offset % $numx;
$y = floor($offset / $numx);
if ($j % $numlabels == 0) {
$pdf->AddPage();
}
$pdf->MultiCell($props['wheader'], 7.5, $labelheader, 0, 'C', 0, 1, $labelheader_pos['x'][$x], $labelheader_pos['y'][$y], true, false, true);
if (!$dup) {
$pdf->write1DBarcode($labeldata[$i]['melnumber'], 'C39', $barcode_pos['x'][$x], $barcode_pos['y'][$y], 55, 12, 0.1, $barcodestyle, 'N');
$pdf->MultiCell(55, 5, '<b>' . $labeldata[$i]['melnumber'] . '</b>', 0, 'C', 0, 1, $barcodetext_pos['x'][$x], $barcodetext_pos['y'][$y], true, false, true);
}
$pdf->MultiCell($props['whtml'], 5, $labeldata[$i]['html'], 0, 'L', 0, 1, $labelbody_pos['x'][$x], $labelbody_pos['y'][$y], true, 0, true, true, 0, 'T', false);
if ($props['footerpositionabsolute']) {
if ($dup) {
$pdf->MultiCell(90, 5, $labeldata[$i]['footer'], 0, 'L', 0, 1, $labelfooter_pos['x'][$x], $labelfooter_pos['y'][$y], true, 0, true, true, 0, 'T', false);
$pdf->write1DBarcode($labeldata[$i]['melnumber'], 'C39', $barcode_pos['x'][$x], $barcode_pos['y'][$y], 55, 12, 0.1, $barcodestyle, 'N');
$pdf->MultiCell(55, 5, '<b>' . $labeldata[$i]['melnumber'] . '</b>', 0, 'C', 0, 1, $barcodetext_pos['x'][$x], $barcodetext_pos['y'][$y], true, false, true);
} else {
$pdf->MultiCell(90, 5, $labeldata[$i]['footer'], 0, 'L', 0, 1, $labelfooter_pos['x'][$x], $labelfooter_pos['y'][$y] - 10, true, 0, true, true, 0, 'T', false);
}
} else {
$y = $pdf->getY() + 5;
if ($dup) {
$pdf->write1DBarcode($labeldata[$i]['melnumber'], 'C39', $barcode_pos['x'][$x], $y, 55, 12, 0.1, $barcodestyle, 'N');
$pdf->MultiCell(55, 5, '<b>' . $labeldata[$i]['melnumber'] . '</b>', 0, 'C', 0, 1, $barcodetext_pos['x'][$x], $y + 11, true, false, true);
$pdf->MultiCell(90, 5, $labeldata[$i]['footer'], 0, 'L', 0, 1, $labelfooter_pos['x'][$x], $y + 8.5, true, 0, true, true, 0, 'T', false);
} else {
$pdf->MultiCell(90, 5, $labeldata[$i]['footer'], 0, 'L', 0, 1, $labelfooter_pos['x'][$x], $y, true, 0, true, true, 0, 'T', false);
}
}
}
// move pointer to last page
$pdf->lastPage();
// ---------------------------------------------------------
//Close and output PDF document
$pdf->Output('mellabel.pdf', 'I');
}
public function print_pdf_link($dept, $grade, $name, $score)
{
ob_start();
ob_get_flush();
ob_get_clean();
// create new PDF document
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// remove default header/footer
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
$pdf->SetFont('msungstdlight', 'B', 23);
// add a page
$pdf->AddPage();
// output the HTML content
$x = $pdf->getX();
$y = $pdf->getY();
$pdf->SetFont('msungstdlight', 'B', 24);
/*
$dept = "體育";
$grp = "男子組";
$item = "100公尺";
$order_no = "第一名";
$score = "9.09秒";
*/
if (isset($grade) && $grade != "") {
$pdf->writeHTMLCell($w = 115, $h = 0, $x = '11', $y = '100', $dept, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'R', $autopadding = true);
$pdf->writeHTMLCell($w = 13, $h = 0, $x = '152', $y = '100', $grade, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'C', $autopadding = true);
$pdf->SetFont('msungstdlight', 'B', 20);
$pdf->writeHTMLCell($w = 70, $h = 0, $x = '94', $y = '205', $score, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
} else {
if (isset($name) && $name != "") {
$pdf->writeHTMLCell($w = 120, $h = 0, $x = '40', $y = '95', $dept, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'R', $autopadding = true);
$pdf->writeHTMLCell($w = 140, $h = 0, $x = '20', $y = '110', $name, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'R', $autopadding = true);
$pdf->SetFont('msungstdlight', 'B', 20);
$pdf->writeHTMLCell($w = 80, $h = 0, $x = '99', $y = '201', $score, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
} else {
if (isset($dept) && $dept != "") {
$pdf->writeHTMLCell($w = 120, $h = 0, $x = '40', $y = '98', $dept, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = 'R', $autopadding = true);
$pdf->SetFont('msungstdlight', 'B', 20);
$pdf->writeHTMLCell($w = 100, $h = 0, $x = '93', $y = '202', $score, $border = 0, $ln = 1, $fill = 0, $reseth = true, $align = '', $autopadding = true);
}
}
}
/*
$pdf->writeHTMLCell($w=130, $h=0, $x='29', $y='91', $dept, $border=0, $ln=1, $fill=0, $reseth=true, $align='C', $autopadding=true);
$pdf->writeHTMLCell($w=100, $h=0, $x='82', $y='142', $grp, $border=0, $ln=1, $fill=0, $reseth=true, $align='', $autopadding=true);
$pdf->writeHTMLCell($w=100, $h=0, $x='82', $y='155', $item, $border=0, $ln=1, $fill=0, $reseth=true, $align='', $autopadding=true);
$pdf->writeHTMLCell($w=100, $h=0, $x='82', $y='168', $order_no, $border=0, $ln=1, $fill=0, $reseth=true, $align='', $autopadding=true);
$pdf->writeHTMLCell($w=100, $h=0, $x='82', $y='181', $score, $border=0, $ln=1, $fill=0, $reseth=true, $align='', $autopadding=true);
*/
$pdf->SetFillColor(255, 255, 200);
$pdf->SetTextColor(0, 63, 127);
// reset pointer to the last page
$pdf->lastPage();
$pdf->Output('/var/www/sports/67/admin/print_cert/print_cert.pdf', 'F');
$response = '/sports/67/admin/print_cert/print_cert.pdf';
return $response;
}
