} // set pdf viewer preferences $pdf->setViewerPreferences(array('Duplex' => 'DuplexFlipLongEdge')); //Doppelseitiger Druck in einem Befehl $pdf->SetBooklet(true, 15, 25); // start of creating the documents while ($meineSchueler = mysql_fetch_assoc($meineSchueler_tmp)) { $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 = '';
$plugin = "../../plugins/value_filter_" . $csf[$ff]['name'] . ".php"; if ($csf[$ff]['value_filter'] != "") { eval($csf[$ff]['value_filter']); } else { if (file_exists($plugin)) { include $plugin; } } $value = TidyList($value); $pdf->Cell($imagesize, ($refnumberfontsize + $leading) / 72, $value, 0, 2, 'L', 0, '', 1); } $bottomy = $pdf->GetY(); $bottomx = $pdf->GetX(); } else { if ($sheetstyle == "list") { $pdf->SetXY($currentx, $currenty); $pdf->Text($pdf->GetX() + $imagesize + 0.1, $pdf->GetY() + 0.2, $ref); $pdf->SetXY($currentx, $currenty); for ($ff = 0; $ff < count($config_sheetlist_fields); $ff++) { $value = ""; $value = str_replace("'", "\\'", $result[$n]['field' . $config_sheetlist_fields[$ff]]); $plugin = "../../plugins/value_filter_" . $csf[$ff]['name'] . ".php"; if ($csf[$ff]['value_filter'] != "") { eval($csf[$ff]['value_filter']); } else { if (file_exists($plugin)) { include $plugin; } } $value = TidyList($value); $pdf->Text($pdf->GetX() + $imagesize + 0.1, $pdf->GetY() + 0.2 * ($ff + 2), $value);
$pdf->Text(290 / 2 - $pdf->GetStringWidth('Lumiere Club') / 2, 15, 'Lumiere Club'); $pdf->SetFont('PT_Serif-Web-Bold', '', 30); $pdf->Text(290 / 2 - $pdf->GetStringWidth('Lippo Mall Kemang') / 2, 26, 'Lippo Mall Kemang'); $pdf->SetFont('Times', '', 12); $pdf->Text(290 / 2 - $pdf->GetStringWidth('Jl. Pangeran Antasari 36 Jakarta Selatan - 12150') / 2, 33, 'Jl. Pangeran Antasari 36 Jakarta Selatan - 12150'); //$pdf->setDrawColor(105,102,102); $pdf->Line(10, 36, 290 - 5, 36); $pdf->SetFont('Arial', '', 22); $pdf->Text(290 / 2 - $pdf->GetStringWidth('Report Data Upgrade Membership') / 2, 45, 'Report Data Upgrade Membership'); $awal = date('d F Y', strtotime($tgl1)); $akhir = date('d F Y', strtotime($tgl2)); $periode = "{$awal} to {$akhir}"; $pdf->SetFont('Arial', '', 14); $pdf->Text(290 / 2 - $pdf->GetStringWidth($periode) / 2, 54, $periode); //$pdf->Line(10, 10, 210-10, 10); $pdf->SetXY(10, 60); $pdf->SetFont('Helvetica', '', 12); $content = UpgradeMembership::model()->with(array('member', 'user'))->findAll(array('condition' => 'upgrade_date BETWEEN :date1 AND :date2', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2))); if ($content == null) { $pdf->SetFont('Helvetica', '', 48); $pdf->Text(290 / 2 - $pdf->GetStringWidth("No Data Found") / 2, 84, "No Data Found"); $pdf->Output(); Yii::app()->end(); } $total = count($content); $total_upgradeed_member_male = count(UpgradeMembership::model()->with(array('member'))->findAll(array('condition' => 'upgrade_date BETWEEN :date1 AND :date2 AND member.gender = :gender', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2, ':gender' => '0')))); $total_upgradeed_member_female = count(UpgradeMembership::model()->with(array('member'))->findAll(array('condition' => 'upgrade_date BETWEEN :date1 AND :date2 AND member.gender = :gender', 'params' => array(':date1' => $tgl1, ':date2' => $tgl2, ':gender' => '1')))); $pdf->SetFont('Arial', '', 16); $text_color = '0,0,0'; $back_color = '255,255,255'; $pdf->Text(10, 70, 'Summary');
// 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); } // --------------------------------------------------------- for ($i = 0; $i < $anzahlSchueler; $i++) { // set font $pdf->SetFont('times', '', 14); $pdf->setPrintHeader(true); // add a page $pdf->AddPage('P', 'A4'); //personenbezogene Kopfdaten $pdf->SetXY(20, 42); $pdf->Cell(45, 5, ucfirst(utf8_encode($nachname[$i])) . ', ' . ucfirst(utf8_encode($vorname[$i])), 0, 0, 'L', 0, '', 0, false, 'C', 'C'); //$pdf->Cell(35, 5, ucfirst(utf8_encode($vorname[$i])) , 0, 0, 'L', 0, '', 0, false, 'C', 'C'); $pdf->Cell(0, 5, $klassenbezeichner . ': ' . $kl, 0, 1, 'R', 0, '', 0, false, 'C', 'C'); //$pdf->SetY(35); //$pdf->Cell(0, 5, 'Schuljahr 2013/14' , 0, 0, 'L', 0, '', 0, false, 'C', 'C'); //$pdf->Cell(0, 5, 'Halbjahr' , 0, 1, 'R', 0, '', 0, false, 'C', 'C'); $ks = array(100, 5, 5, 5); //statisch,laenger als je noetig, da alle nach der ersten gleich lang;ks=kopfspalten //$pdf->SetXY(20,45); $pdf->SetFont('times', '', 9); $pdf->Cell($ks[0], 5, '', 0, 0, 'C', 0, '', 0, false, 'M', 'M'); $pdf->SetXY(122.5, 68); //alt 78 $pdf->StartTransform(); $pdf->Rotate(90);