$pdf = new MYPDF('P', 'mm', 'A4', true, 'UTF-8', false);
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
$pdf->SetMargins(15, 10, 15);
$pdf->setPrintHeader(false);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
$pdf->AddPage();
foreach (tampilData($stmt) as $grid) {
$pdf->SetFont('helvetica', 'B', 9);
$pdf->setXY(15, $pdf->getY(), true);
$pdf->Cell(0, 0, 'SLIP KOMISI SALES', 0, 2, 'C', 0, '', '');
$pdf->SetFont('helvetica', '', 7);
$pdf->setXY(15, $pdf->getY(), true);
$pdf->Cell(0, 0, 'PT. LUXINDO RAYA', 0, 2, 'C', 0, '', '');
$pdf->SetFont('helvetica', 'B', 7);
$pdf->setXY(15, $pdf->getY(), true);
$pdf->MultiCell(15, 7, "NIS", 0, 'L', false, 0, '', '', false, 0, false, false, 7, 'M');
$pdf->MultiCell(5, 7, ":", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(100, 7, $grid['nis'], 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(18, 7, "Periode", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(5, 7, ":", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(45, 7, $begin . " s.d " . $end, 0, 'L', false, 1, '', '', false, 0, false, false, '', 'M');
$pdf->setXY(15, $pdf->getY() - 2, true);
$pdf->MultiCell(15, 7, "Nama", 0, 'L', false, 0, '', '', false, 0, false, false, 7, 'T');
$pdf->MultiCell(5, 7, ":", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(100, 7, $grid['nama'], 0, 'L', false, 0, '', '', false, 1, false, false, '', 'M');
$pdf->setXY(15, $pdf->getY() + 5, true);
$pdf->MultiCell(15, 7, "Cabang", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'T');
$pdf->MultiCell(5, 7, ":", 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(100, 7, $cabang . " - " . $dataCabang['nama_cabang'], 0, 'L', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->setXY(15, $pdf->getY() + 7);
$pdf->MultiCell(10, 7, "No", 'TB', 'C', false, 0, '', '', false, 0, false, false, 7, 'TB');
//set document information
$pdf->SetAuthor('DIRECCION DE PENSIONES');
$pdf->SetTitle('DEL MUNICIPIO DE OAXACA DE JUÁREZ OAX');
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(0, PDF_MARGIN_TOP, 0);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$resolution = array(216, 355);
$consultaTram = "SELECT idContrato, fecha, titular, nombre, importePrestamo, MontoRedocumentacion,sindicato,idSindicato FROM repAltasRedocumenta ORDER BY idSindicato ASC";
$consulta = mysql_query($consultaTram);
$pdf->AddPage('L', $resolution);
$pdf->SetFont('helvetica', '', 10);
$pdf->MultiCell(334, 20, 'RESUMEN DE ALTAS Y REDOCUMENTACION DE PRESTAMOS', 0, 'C', false, 1, 12, 20, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(334, 20, 'CONSULTA DEL ' . $fechadeInicio . ' AL ' . $fechadeFin, 0, 'C', false, 1, 12, 25, true, 0, true, true, 0, 'M', false);
//$pdf->MultiCell(200, 5, 'FECHA INICIAL: '.$fechadeInicio, 0, 'C', false, 0, 0, 25, true, 0, true, true, 0, 'M', false);
//$pdf->MultiCell(200, 5, 'FECHA FINAL: '.$fechadeFin, 0, 'C', false, 0, 155, 25, true, 0, true, true, 0, 'M', false);
//$pdf->setPageOrientation('L');
$Cont = 1;
$i = 40;
$pdf->SetAutoPageBreak(false, 0);
while ($resultado = mysql_fetch_array($consulta)) {
//if ($resultado['idSindicato'])
$pdf->MultiCell(10, 7, $Cont, 1, 'C', false, 1, 12, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(25, 7, $resultado['idContrato'], 0, 'C', false, 1, 19, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(70, 7, $resultado['fecha'], 0, 'C', false, 1, 30, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(90, 7, $resultado['titular'], 0, 'C', false, 1, 50, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(150, 7, $resultado['nombre'], 0, 'C', false, 1, 70, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(250, 7, '$' . number_format($resultado['importePrestamo'], 2, '.', ','), 0, 'C', false, 1, 80, $i, true, 0, true, true, 0, 'M', false);
$schueler_uid = $meineSchueler['usr_id'];
$schueler_vorname = $meineSchueler['firstname'];
$schueler_nachname = $meineSchueler['lastname'];
$pdf->SetFont('times', '', 14);
$pdf->setPrintHeader(true);
// add a page
$pdf->AddPage('P', 'A4');
//personenbezogene Kopfdaten
$pdf->SetXY(20, 42);
$pdf->Cell(45, 5, $schueler_nachname . ', ' . $schueler_vorname, 0, 0, 'L', 0, '', 0, false, 'C', 'C');
$pdf->Cell(0, 5, $klassenbezeichner . ': ' . $kl, 0, 1, 'R', 0, '', 0, false, 'C', 'C');
$pdf->Line(20, 47, 195, 47, $style2);
$pdf->SetFont('helvetica', '', 14);
$pdf->SetY(52);
$pdf->SetFont('helvetica', 'B', 14);
$pdf->MultiCell(0, 2, '', 0, 'L', 0, 1, '', '', true);
//als verticaler Abstand, mir fiel grad nichts besseres ein
$pdf->Cell(45, 5, 'Deine Lernziele im ' . $_SESSION['aktueller_term_name'], 0, 1, 'L', 0, '', 0, false, 'C', 'C');
$pdf->MultiCell(0, 1, '', 0, 'L', 0, 1, '', '', true);
//als verticaler Abstand, mir fiel grad nichts besseres ein
//Ausdrucken von Lernziel 1 und 2
$lz1_tmp = mysql_query("SELECT * FROM lernstand.lernziele WHERE uid = '" . $schueler_uid . "' AND lz_nr = '1' AND term = '" . $_SESSION['aktueller_term_nr'] . "'");
$lz2_tmp = mysql_query("SELECT * FROM lernstand.lernziele WHERE uid = '" . $schueler_uid . "' AND lz_nr = '2' AND term = '" . $_SESSION['aktueller_term_nr'] . "'");
$lz1 = '';
$lz2 = '';
if (mysql_num_rows($lz1_tmp) > 0) {
$lz1 = mysql_result($lz1_tmp, '0', 'lz_text');
}
if (mysql_num_rows($lz2_tmp) > 0) {
$lz2 = mysql_result($lz2_tmp, '0', 'lz_text');
}
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
//set auto page breaks
$pdf->SetAutoPageBreak(FALSE, PDF_MARGIN_BOTTOM);
//set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
//set some language-dependent strings
//$pdf->setLanguageArray($l);
// ---------------------------------------------------------
// first page
$pdf->AddPage();
$pdf->Line(20, 20, 190, 20);
$pdf->ImageEps('../extensions/exam_organization/images/upb_logo.ai', 30, 30, 13);
$pdf->SetFont('helvetica', '', 16);
$pdf->MultiCell(80, 3, gettext("exam results"), 0, 'C', 0, 0, 75, 25);
$pdf->SetFont('helvetica', 'B', 16);
$pdf->MultiCell(130, 3, $exam_name, 0, 'C', 0, 0, 50, 33);
$pdf->MultiCell(130, 3, $date . " (" . $semester . ")", 0, 'C', 0, 0, 50, 40);
$pdf->SetFont('helvetica', '', 10);
//$pdf->MultiCell(130, 2, "Prof. Dr. Reinhard Keil", 0, 'C', 0, 0, 50, 50);
$pdf->Line(20, 60, 190, 60);
$eoDatabase = exam_organization_database::getInstance();
$eoDatabase->calculateExamResults($course);
$participants = $eoDatabase->getParticipantsForTerm($examTerm);
$notPassed = 0;
//get exam key
$examObject = exam_organization_exam_object_data::getInstance($course);
$examKey = $examObject->getExamKey($examTerm);
$maxPoints = $examObject->getExamKeyMaxPoints($examTerm);
$summary = array("10" => array("mark" => "1,0", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["10"], "to" => $maxPoints), "13" => array("mark" => "1,3", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["13"], "to" => $examKey["10"] - 1), "17" => array("mark" => "1,7", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["17"], "to" => $examKey["13"] - 1), "20" => array("mark" => "2,0", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["20"], "to" => $examKey["17"] - 1), "23" => array("mark" => "2,3", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["23"], "to" => $examKey["20"] - 1), "27" => array("mark" => "2,7", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["27"], "to" => $examKey["23"] - 1), "30" => array("mark" => "3,0", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["30"], "to" => $examKey["27"] - 1), "33" => array("mark" => "3,3", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["33"], "to" => $examKey["30"] - 1), "37" => array("mark" => "3,7", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["37"], "to" => $examKey["33"] - 1), "40" => array("mark" => "4,0", "countBonus" => 0, "countNoBonus" => 0, "from" => $examKey["40"], "to" => $examKey["37"] - 1), "50" => array("mark" => "5,0", "countBonus" => 0, "countNoBonus" => 0, "from" => 0, "to" => $examKey["40"] - 1), "NT" => array("mark" => "NT", "countBonus" => 0, "countNoBonus" => 0, "from" => 0, "to" => 0), "BV" => array("mark" => "BV", "countBonus" => 0, "countNoBonus" => 0, "from" => 0, "to" => 0), "SICK" => array("mark" => "SICK", "countBonus" => 0, "countNoBonus" => 0, "from" => 0, "to" => 0));
$pdf->Image($image_file, 5, 0, 40, '', 'JPG', '', 'M', false, 300, '', false, false, 0, false, false, false);
$pdf->SetFont('helvetica', 'B', 17);
$pdf->setXY(45, 18, true);
$pdf->Cell(0, 13, 'PT. Luxindo Raya', 0, 2, 'L', 0, '', '', 'D', 'B');
$pdf->SetFont('helvetica', 'B', 10);
$pdf->setXY(45, 18, true);
$pdf->Cell(0, 0, 'LAPORAN PENJUALAN', 0, 2, 'L', 0, '', '');
$pdf->SetFont('helvetica', '', 9);
$pdf->Cell(0, 0, 'Cabang ' . $dataCabang['kode'] . ' - ' . $dataCabang['nama_cabang'], 0, 1, 'L', 0, '');
$pdf->Line(14, 30, 280, 30);
$pdf->SetFont('helvetica', '', 7);
$pdf->setXY(15, 40);
$pdf->Cell(0, 0, 'Periode ' . $begin . ' - ' . $end, 0, 2, 'L', 0, '', '');
$pdf->SetFont('helvetica', 'B', 7);
$pdf->setXY(15, 45);
$pdf->MultiCell(10, 7, "No", 'TB', 'C', false, 0, '', '', false, 0, false, false, 7, 'M');
$pdf->MultiCell(15, 7, "No SO", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(20, 7, "Tgl SO", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(30, 7, "No Seri", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(30, 7, "Nama Produk", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(15, 7, "Quantity", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(20, 7, "NIS", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(50, 7, "Nama Sales", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(50, 7, "Nama Qustomer", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(25, 7, "Telp", 'TB', 'C', false, 1, '', '', false, 0, false, false, '', 'M');
$pdf->SetFont('helvetica', '', 7);
$i = 1;
foreach (tampilData($stmt) as $grid) {
$pdf->setXY(15, 55 + 7 * ($i - 1));
if ($i % 2 == 0) {
$pdf->setFillColor(198, 200, 198);
//set document information
$pdf->SetAuthor('DIRECCION DE PENSIONES');
$pdf->SetTitle('DEL MUNICIPIO DE OAXACA DE JUÁREZ OAX');
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(0, PDF_MARGIN_TOP, 0);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$resolution = array(216, 355);
$consultaTram = "SELECT cveEmpleado, nombre, Titular1, Titular2, Titular3 FROM replistadofirmas ORDER BY cveEmpleado";
$consulta = mysql_query($consultaTram);
$pdf->AddPage();
$pdf->SetFont('helvetica', '', 9);
$pdf->MultiCell(178, 20, 'LISTADO GENERAL DE FIRMAS', 0, 'C', false, 1, 12, 20, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(178, 20, 'FECHA', 0, 'C', false, 1, 12, 25, true, 0, true, true, 0, 'M', false);
$Cont = 1;
$i = 40;
$pdf->SetAutoPageBreak(false, 0);
while ($resultado = mysql_fetch_array($consulta)) {
//if ($resultado['idSindicato'])
$pdf->MultiCell(10, 8.5, $Cont, 1, 'C', false, 1, 12, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(25, 8.5, $resultado['cveEmpleado'], 0, 'C', false, 1, 20, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(50, 8.5, $resultado['nombre'], 0, 'C', false, 1, 40, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(120, 8.5, $resultado['Titular1'], 0, 'C', false, 1, 50, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(180, 8.5, $resultado['Titular2'], 0, 'C', false, 1, 50, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(250, 8.5, $resultado['Titular3'], 0, 'C', false, 1, 50, $i, true, 0, true, true, 0, 'M', false);
$i = $i + 8.5;
if ($Cont % 28 == 0) {
$i = 40;
//set document information
$pdf->SetAuthor('DIRECCION DE PENSIONES');
$pdf->SetTitle('DEL MUNICIPIO DE OAXACA DE JUÁREZ OAX');
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(0, PDF_MARGIN_TOP, 0);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$resolution = array(216, 355);
$consultaTram = "SELECT idContrato,fecha,titular,nombre,saldoInicial,cargo,abono,saldoFinal,abonosHechos FROM repEdoCtaxperio2Desglosado";
$consulta = mysql_query($consultaTram);
$pdf->AddPage('L', $resolution);
$pdf->SetFont('helvetica', '', 10);
$pdf->MultiCell(334, 20, 'FECHA DE IMPRESION:' . $fecha_actual, 0, 'C', false, 1, 12, 20, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(200, 5, 'FECHA INICIAL: ' . $fechadeInicio, 0, 'C', false, 0, 0, 25, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(200, 5, 'FECHA FINAL: ' . $fechadeFin, 0, 'C', false, 0, 155, 25, true, 0, true, true, 0, 'M', false);
//$pdf->setPageOrientation('L');
$Cont = 1;
$i = 56;
$pdf->SetAutoPageBreak(false, 0);
while ($resultado = mysql_fetch_array($consulta)) {
$pdf->MultiCell(10, 8.5, $Cont, 1, 'C', false, 1, 12, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(25, 8.5, $resultado['idContrato'], 0, 'C', false, 1, 19, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(70, 8.5, $resultado['fecha'], 0, 'C', false, 1, 30, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(90, 8.5, $resultado['titular'], 0, 'C', false, 1, 50, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(150, 8.5, $resultado['nombre'], 0, 'C', false, 1, 70, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(230, 8.5, '$' . number_format($resultado['saldoInicial'], 2, '.', ','), 0, 'C', false, 1, 80, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(300, 8.5, '$' . number_format($resultado['cargo'], 2, '.', ','), 0, 'C', false, 1, 80, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(360, 8.5, '$' . number_format($resultado['abono'], 2, '.', ','), 0, 'C', false, 1, 80, $i, true, 0, true, true, 0, 'M', false);
$pdf->MultiCell(150,6,"TEXTO PRUEBA : 1234567890 : ABCDEFGHIJKLMNÑOPQRSTUVWXY", 0, 'L',0, 0,7, 30,true);
$pdf->SetFont('dejavuserif', '', 10);
$pdf->MultiCell(150,6,"TEXTO PRUEBA : 1234567890 : ABCDEFGHIJKLMNÑOPQRSTUVWXY", 0, 'L',0, 0,7, 35,true);
$pdf->SetFont('dejavuserifcondensed', '', 10);
$pdf->MultiCell(150,6,"TEXTO PRUEBA : 1234567890 : ABCDEFGHIJKLMNÑOPQRSTUVWXY", 0, 'L',0, 0,7, 40,true);
$pdf->SetFont('times', '', 10);
$pdf->MultiCell(150,6,"TEXTO PRUEBA : 1234567890 : ABCDEFGHIJKLMNÑOPQRSTUVWXY", 0, 'L',0, 0,7, 45,true);
*/
// Tipo de Letra
$pdf->SetFont('pdfahelvetica', '', 10);
// ---------------------------------------------------------
// Ayuda para MultiCell
// MultiCell(ancho de caja,alto de caja,texto, border, 'justificacion',0, 0,X,Y,true);
// ---------------------------------------------------------
// Cliente / Quien contrata el servicio.
$pdf->MultiCell(150, 6, $cliente, 1, 'L', 0, 0, 55, 48, true);
// Posicionamiento
$pdf->MultiCell(42, 6, "{$posFec} {$posHor}:{$posMin}", 1, 'L', 0, 0, 125, 38, true);
// Factura
$pdf->MultiCell(35, 6, $factura, 1, 'C', 0, 0, 170, 38, true);
// Origen
$pdf->MultiCell(60, 6, $ori, 1, 'C', 0, 0, 7, 61, true);
// Destino
$pdf->MultiCell(60, 6, $des, 1, 'C', 0, 0, 75, 61, true);
// Moviemiento
$pdf->MultiCell(60, 6, $mov, 1, 'C', 0, 0, 145, 61, true);
$pdf->SetFont('pdfahelvetica', '', 10);
// Remitente
$pdf->MultiCell(65, 6, $remitente, 1, 'C', 0, 0, 7, 77, true);
// Destinatario
$pdf->MultiCell(65, 6, $destinatario, 1, 'C', 0, 0, 75, 77, true);
for ($a = 1; $a <= $fachAnzahl; $a++) {
$pdf->Cell(15, 5, $fach[$a], 1, 2, 'C', 0, '', 3, false, 'T', 'C');
}
//reset(mysql_fetch_assoc($faecherTableHeader));
$pdf->Cell(15, 5, 'Eltern', 1, 1, 'C', 0, '', 0, false, 'T', 'C');
$pdf->StopTransform();
$kompBreite = 100 + ($fachAnzahl + 2) * 5;
$pdf->Ln();
$pdf->SetY(68);
for ($k = 0; $k < $fragenAnzahl; $k++) {
//$punkte = mysql_query("SELECT * FROM bewertung WHERE uid = '".$uid[$i]."' AND frage = '".$frageNr[$k]."'");
//erste Kompetenz
$pdf->SetX(20);
$pdf->SetFont('helvetica', 'b', '9');
if ($k == 0) {
$pdf->MultiCell($kompBreite, 5, 'Sachkompetenz', 'LRT', 'L', 0, 1, '', '', true);
}
$pdf->SetFont('times', '', '9');
$pdf->SetX(20);
//Erste Spalte mit Fragetexten
if ($frageNr[$k] !== '39' && $frageNr[$k] !== '71' && $frageNr[$k] !== '77' && $frageNr[$k] !== '78') {
$fragetextneu[$k] = 'Ich kann ' . $fragetext[$k];
} else {
$fragetextneu[$k] = $fragetext[$k];
}
$pdf->MultiCell($ks[0], 5, utf8_encode($fragetextneu[$k]), 'LRT', 'L', 0, 0, '', '', true);
//Zweite Spalte mit Selbsteinschaetzung der Schueler
$selbst = mysql_fetch_assoc(mysql_query("SELECT * FROM {$klst} WHERE uid = '" . $uid[$i] . "' "));
$pdf->MultiCell($ks[1], 5, $selbst[$frageNr[$k]], 'LTR', 'C', 0, 0, '', '', false);
//Punktebewertung der Lehrer
for ($f = 1; $f <= $fachAnzahl; $f++) {
$pdf->Image($image_file, 5, 0, 40, '', 'JPG', '', 'M', false, 300, '', false, false, 0, false, false, false);
$pdf->SetFont('helvetica', 'B', 17);
$pdf->setXY(45, 18, true);
$pdf->Cell(0, 13, 'PT. Luxindo Raya', 0, 2, 'L', 0, '', '', 'D', 'B');
$pdf->SetFont('helvetica', 'B', 10);
$pdf->setXY(45, 18, true);
$pdf->Cell(0, 0, 'LAPORAN KOMISI SALES', 0, 2, 'L', 0, '', '');
$pdf->SetFont('helvetica', '', 9);
$pdf->Cell(0, 0, 'Cabang ' . $dataCabang['kode'] . ' - ' . $dataCabang['nama_cabang'], 0, 1, 'L', 0, '');
$pdf->Line(14, 30, 195, 30);
$pdf->SetFont('helvetica', '', 7);
$pdf->setXY(15, 40);
$pdf->Cell(0, 0, 'Periode ' . $begin . ' - ' . $end, 0, 2, 'L', 0, '', '');
$pdf->SetFont('helvetica', 'B', 7);
$pdf->setXY(15, 45);
$pdf->MultiCell(10, 7, "No", 'TB', 'C', false, 0, '', '', false, 0, false, false, 7, 'M');
$pdf->MultiCell(30, 7, "NIS", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(60, 7, "Nama Sales", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(20, 7, "Jumlah SO", 'TB', 'C', false, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(30, 7, "Komisi", 'TB', 'C', false, 1, '', '', false, 0, false, false, '', 'M');
$pdf->SetFont('helvetica', '', 7);
$i = 1;
foreach (tampilData($stmt) as $grid) {
$pdf->setXY(15, 55 + 7 * ($i - 1));
if ($i % 2 == 0) {
$pdf->setFillColor(198, 200, 198);
} else {
$pdf->setFillColor(231, 232, 231);
}
$pdf->MultiCell(10, 7, $i, 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M');
$pdf->MultiCell(30, 7, $grid['nis'], 0, 'C', true, 0, '', '', false, 0, false, false, '', 'M');
//
// Setup the PDF basics
//
$pdf->SetCreator('Ciniki');
$pdf->SetAuthor($business_details['name']);
$pdf->SetTitle($conference['name']);
$pdf->SetSubject('');
$pdf->SetKeywords('');
// set margins
$pdf->SetMargins($pdf->left_margin, $pdf->top_margin + $pdf->header_height, $pdf->right_margin);
$pdf->SetHeaderMargin($pdf->top_margin);
// set font
$pdf->SetFont('times', 'BI', 10);
$pdf->SetCellPadding(2);
$pdf->SetFillColor(255);
$pdf->SetTextColor(0);
$pdf->SetDrawColor(51);
$pdf->SetLineWidth(0.15);
foreach ($presentations as $presentation) {
// add a page
$pdf->AddPage();
$pdf->SetFont('', 'B', 12);
$pdf->MultiCell(180, 1, $presentation['display_title'], 0, 'L');
$pdf->SetFont('', '', 11);
$pdf->MultiCell(180, 1, $presentation['field'], 0, 'L');
$pdf->SetFont('', '', 10);
$pdf->Ln();
$pdf->MultiCell(180, 8, $presentation['description'], 0, 'L');
}
return array('stat' => 'ok', 'presentations' => $presentations, 'conference' => $conference, 'pdf' => $pdf);
}
$pdf->Ln(5);
// set cell padding
$pdf->setCellPaddings(1, 1, 1, 1);
// set cell margins
$pdf->setCellMargins(0, 0, 0, 0);
// set font
$pdf->SetFont('freeserif', 'B', 14);
$txt = 'Отговори';
$pdf->Write(0, $txt, '', 0, 'C', true, 0, false, false, 0);
// set color for background
$pdf->SetFillColor(225, 225, 225);
// set font
$pdf->SetFont('freeserif', '', 12);
// Multicell test
$txt = '№';
$pdf->MultiCell(10, '', $txt, 1, 'C', 1, 0, '', '', true);
$txt = 'Отговор';
$pdf->MultiCell(140, '', $txt, 1, 'C', 1, 0, '', '', true);
$txt = 'Тип';
$pdf->MultiCell(30, '', $txt, 1, 'C', 1, 1, '', '', true);
// set color for background
$pdf->SetFillColor(255, 255, 255);
$number_answer = 1;
foreach ($answers as $answer_id) {
$answer = new Answer();
$answer->get_from_db($answer_id);
$txt = $number_answer;
$pdf->MultiCell(10, '', $txt, 1, 'C', 1, 0, '', '', true);
$txt = $answer->getValue();
$pdf->MultiCell(140, '', $txt, 1, 'C', 1, 0, '', '', true);
$txt = $answer->getType();
