public function cetak() { $tahun = $this->uri->segment(4); $thak = $tahun . '/' . $tahun + 1; $ruang = $this->uri->segment(5); $data = $this->db->query("SELECT * FROM mspcmb WHERE ThAjaran='" . $tahun . "' AND RUjian='" . $ruang . "'"); if ($data->num_rows() > 0) { //Instanciation of inherited class $pdf = new reportProduct(); $pdf->setKriteria("krs"); $pdf->setNama("DAFTAR HADIR TERTULIS " . $tahun); $pdf->Open(); $pdf->AliasNbPages(); $pdf->AddPage("P", "A4"); /* $A4[0]=210; $A4[1]=297; $F4[0]=210; $F4[1]=330; $Q[0]=216; $Q[1]=279; $pdf=new PDF('P','mm',$F4); $pdf->Open(); $pdf->AliasNbPages(); $pdf->AddPage(); */ $pdf->SetTitle('DAFTAR PESERTA PMB TAHUN AKADEMIK ' . $thak); $pdf->SetFont('arial', 'B', 12); $pdf->Cell(0, 5, 'DAFTAR HADIR UJIAN TERTULIS PMB', 0, 1, 'C'); $pdf->Cell(0, 5, 'TAHUN AKADEMIK ' . $thak, 0, 1, 'C'); $pdf->Ln(5); $pdf->SetFont('arial', '', 11); $pdf->Cell(171, 5, 'Jenjang : S2', 0, 0, 'L'); $pdf->SetLineWidth(0.3); $pdf->Cell(20, 5, ' R : ' . $ruang, 1, 1, 'C'); $pdf->Ln(1); $pdf->SetFont('arial', 'B', 11); $pdf->SetFillColor(229, 229, 229); $pdf->Cell(8, 10, 'No.', 1, 0, 'C', true); $pdf->Cell(18, 10, 'No Ujian', 1, 0, 'C', true); $pdf->Cell(85, 10, 'Nama', 1, 0, 'C', true); $pdf->Cell(80, 5, 'Tanda Tangan', 1, 1, 'C', true); $pdf->SetXY(121, 36); $pdf->SetFont('arial', '', 9); $pdf->Cell(40, 5, 'Peng.Agama', 1, 0, 'C', true); $pdf->Cell(40, 5, 'Peng.Umum', 1, 1, 'C', true); $pdf->Ln(1); $pdf->SetFont('arial', '', 11); $pdf->SetLineWidth(0.1); //$pdf->FancyTable($baris_data); /**awal **/ //$w=array(10,25,80,20,25,30); $w = array(8, 18, 85, 40, 40); $isi_data = $this->app_model->manualQuery("SELECT * FROM mspcmb \n\t\t\t\tWHERE ThAjaran='" . $tahun . "' \n\t\t\t\tAND RUjian='" . $ruang . "'"); $rec = $isi_data->result(); $n = 0; $fill = false; foreach ($rec as $r) { $pdf->SetFillColor(229, 229, 229); $n++; $pdf->Cell($w[0], 9, $n, 0, 0, 'C', $fill); $pdf->Cell($w[1], 9, $r->NoUjian, 0, 0, 'C', $fill); $pdf->Cell($w[2], 9, $r->Nama, 0, 0, 'L', $fill); $pdf->Cell($w[3], 9, '', 0, 0, 'C', $fill); $pdf->Cell($w[4], 9, '', 0, 0, 'L', $fill); $pdf->Ln(); } $pdf->Cell(array_sum($w), 0, '', 'T'); /** terakhir **/ $pdf->Ln(2); $pdf->Cell(0, 10, 'Serang, ____________________ 2012', 0, 1, 'R'); $pdf->SetFont('arial', '', 11); $pdf->Cell(95, 5, 'Peng. Agama', 'LTR', 0); $pdf->Cell(96, 5, '', 'LTR', 1); $pdf->Cell(95, 10, ' ', 'LR', 0); $pdf->Cell(96, 10, ' ', 'LR', 1); $pdf->Cell(95, 7, 'Pengawas I : __________________________', 'LBR', 0, 'C'); $pdf->Cell(96, 7, 'Pengawas II : __________________________', 'LBR', 1, 'C'); $pdf->Ln(3); $pdf->Cell(95, 5, 'Peng. Umum', 'LTR', 0); $pdf->Cell(96, 5, '', 'LTR', 1); $pdf->Cell(95, 10, ' ', 'LR', 0); $pdf->Cell(96, 10, ' ', 'LR', 1); $pdf->Cell(95, 7, 'Pengawas I : __________________________', 'LBR', 0, 'C'); $pdf->Cell(96, 7, 'Pengawas II : __________________________', 'LBR', 1, 'C'); //Second Page $pdf->AddPage(); $pdf->SetFont('arial', 'B', 12); $pdf->Cell(0, 5, 'DAFTAR HADIR UJIAN TERTULIS PMB', 0, 1, 'C'); $pdf->Cell(0, 5, 'TAHUN AKADEMIK ' . $thak, 0, 1, 'C'); $pdf->Ln(5); $pdf->SetFont('arial', '', 11); $pdf->Cell(171, 5, 'Jenjang : S2', 0, 0, 'L'); $pdf->SetLineWidth(0.3); $pdf->Cell(20, 5, ' R : ' . $ruang, 1, 1, 'C'); $pdf->Ln(1); $pdf->SetFont('arial', 'B', 11); $pdf->SetFillColor(229, 229, 229); $pdf->Cell(8, 10, 'No.', 1, 0, 'C', true); $pdf->Cell(18, 10, 'No Ujian', 1, 0, 'C', true); $pdf->Cell(85, 10, 'Nama', 1, 0, 'C', true); $pdf->Cell(80, 5, 'Tanda Tangan', 1, 1, 'C', true); $pdf->SetXY(121, 36); $pdf->SetFont('arial', '', 9); $pdf->Cell(40, 5, 'Bhs. Arab', 1, 0, 'C', true); $pdf->Cell(40, 5, 'Bhs. Inggris', 1, 1, 'C', true); $pdf->Ln(1); $pdf->SetFont('arial', '', 11); $pdf->SetLineWidth(0.1); //$pdf->FancyTable($baris_data); $w = array(8, 18, 85, 40, 40); //$pdf->SetFillColor(229,229,229); $isi_data = $this->app_model->manualQuery("SELECT * FROM mspcmb \n\t\t\t\tWHERE ThAjaran='" . $tahun . "' \n\t\t\t\tAND RUjian='" . $ruang . "'"); $rec = $isi_data->result(); $n = 0; $fill = false; foreach ($rec as $r) { $n++; $pdf->Cell($w[0], 9, $n, 0, 0, 'C', $fill); $pdf->Cell($w[1], 9, $r->NoUjian, 0, 0, 'C', $fill); $pdf->Cell($w[2], 9, $r->Nama, 0, 0, 'L', $fill); $pdf->Cell($w[3], 9, '', 0, 0, 'C', $fill); $pdf->Cell($w[4], 9, '', 0, 0, 'L', $fill); $pdf->Ln(); } $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(2); $pdf->Cell(0, 10, 'Serang, ____________________ 2012', 0, 1, 'R'); $pdf->SetFont('arial', '', 11); $pdf->Cell(95, 5, 'Bhs. Arab', 'LTR', 0); $pdf->Cell(96, 5, '', 'LTR', 1); $pdf->Cell(95, 10, ' ', 'LR', 0); $pdf->Cell(96, 10, ' ', 'LR', 1); $pdf->Cell(95, 7, 'Pengawas I : __________________________', 'LBR', 0, 'C'); $pdf->Cell(96, 7, 'Pengawas II : __________________________', 'LBR', 1, 'C'); $pdf->Ln(3); $pdf->Cell(95, 5, 'Bhs. Inggris', 'LTR', 0); $pdf->Cell(96, 5, '', 'LTR', 1); $pdf->Cell(95, 10, ' ', 'LR', 0); $pdf->Cell(96, 10, ' ', 'LR', 1); $pdf->Cell(95, 7, 'Pengawas I : __________________________', 'LBR', 0, 'C'); $pdf->Cell(96, 7, 'Pengawas II : __________________________', 'LBR', 1, 'C'); $pdf->Output(str_replace(' ', '_', strtoupper($tahun) . '_PCMB_RUANG-' . $ruang . '.pdf'), 'D'); } else { echo "Tidak Ada data"; } }