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