public function cetak() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'mahasiswa') { $nim = $this->session->userdata('username'); $q = $this->db->query("SELECT * FROM wisuda as a \n\t\t\t\t\t\t\t\t\tJOIN mahasiswa as b\n\t\t\t\t\t\t\t\t\tON a.nim=b.nim\n\t\t\t\t\t\t\t\t\tWHERE a.nim='{$nim}' "); $r = $q->num_rows(); if ($r > 0) { foreach ($q->result() as $dt) { $tgl_daftar = $this->model_global->tgl_indo($dt->tgl_daftar); $thak = $dt->th_akademik; $nama = $dt->nama_mhs; if ($dt->sex == 'L') { $sex = 'Laki-laki'; } else { $sex = 'Perempuan'; } $prodi = $dt->kd_prodi . '-' . $this->model_data->nama_jurusan($dt->kd_prodi); $tmpt_lhr = $dt->tempat_lahir; $tgl_lhr = $this->model_global->tgl_indo($dt->tanggal_lahir); $alamat = $dt->alamat; $tgl_sidang = $this->model_global->tgl_indo($dt->tgl_sidang); $skripsi = $dt->judul_skripsi; $ipk = $dt->ipk; } $pdf = new reportProduct(); $pdf->setKriteria("cetak_laporan"); $pdf->setNama("CETAK LAPORAN"); $pdf->AliasNbPages(); $pdf->AddPage("P", "A4"); //foreach($data->result() as $t){ $A4[0] = 210; $A4[1] = 297; $Q[0] = 216; $Q[1] = 279; $pdf->SetTitle('Laporan Aplikasi'); $pdf->SetCreator('Programmer IT with fpdf'); $h = 10; $pdf->SetFont('Times', 'B', 16); $pdf->image(base_url() . 'assets/img/logo-black.png', 95, 5, 20, 20); $pdf->Ln(15); $pdf->Cell(190, 8, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 14); $pdf->Cell(190, 5, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell(190, 5, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(10); //Column widths $pdf->SetFont('courier', 'B', 16); $pdf->Cell(190, 5, 'FORMULIR PENDAFTARAN WISUDA', 0, 1, 'C'); $pdf->Cell(190, 5, $thak, 0, 1, 'C'); $pdf->Ln(10); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 10; $wl = 50; $wr = 140; $pdf->SetFont('courier', '', 14); $pdf->Cell($wl, $h, 'Tanggal :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $tgl_daftar, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'NIM :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $nim, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'Nama Lengkap :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $nama, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'jenis Kelamin :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $sex, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'Tempat Lahir :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $tmpt_lhr, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'Tanggal Lahir :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $tgl_lhr, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'Alamat :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $alamat, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'Program Studi :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $prodi, 'TR', 1, 'L'); $pdf->Cell($wl, $h, 'Tanggal Sidang :', 'LTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $tgl_sidang, 'TR', 1, 'L'); $pdf->Cell(190, $h, 'Judul Skripsi :', 'LTR', 1, 'C', $fill); $fill = false; $pdf->MultiCell(190, 7, $skripsi, 'LTR', 1, 'L', $fill); $fill = true; $pdf->Cell($wl, $h, 'IPK :', 'LBTR', 0, 'R', $fill); $pdf->Cell($wr, $h, $ipk, 'BTR', 1, 'L'); $h = 7; $pdf->Ln(10); $pdf->SetX(100); $pdf->Cell(80, $h, 'Serang, ' . $this->model_global->tgl_indo(date('Y-m-d')), 0, 1, 'C'); $pdf->SetX(100); $pdf->Cell(80, $h, 'Mahasiswa yang bersangkutan,', 0, 1, 'C'); $pdf->Ln(20); $pdf->SetX(100); $pdf->Cell(80, $h, $nama, 0, 1, 'C'); $pdf->footer(); //} //} $pdf->Output('Pendaftaran_Wisuda_' . $nim . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('site_mahasiswa/wisuda'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
public function print_khs() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'mahasiswa') { $th_ak = $this->session->userdata('th_ak'); $smt = $this->session->userdata('smt'); $nim = $this->session->userdata('username'); $q = $this->db->query("SELECT * FROM krs WHERE th_akademik='{$th_ak}' AND semester='{$smt}' AND nim='{$nim}' "); $r = $q->num_rows(); if ($r > 0) { $nama = $this->model_data->cari_nama_mhs($nim); $kd_prodi = $this->model_data->cari_kd_prodi_mhs($nim); $prodi = $this->model_data->nama_jurusan($kd_prodi); $data_prodi = $this->model_data->cari_nama_ka_prodi($kd_prodi); $nama_ka_prodi = $data_prodi['nama']; $nik_ka_prodi = $data_prodi['nik']; $semester = $this->model_data->cari_smt_krs($th_ak, $smt, $nim); $ip = $this->model_data->cari_ipk($semester, $nim); $pdf = new reportProduct(); $pdf->setKriteria("cetak_laporan"); $pdf->setNama("CETAK LAPORAN"); $pdf->AliasNbPages(); $pdf->AddPage("P", "A4"); //foreach($data->result() as $t){ $A4[0] = 210; $A4[1] = 297; $Q[0] = 216; $Q[1] = 279; $pdf->SetTitle('Laporan Aplikasi'); $pdf->SetCreator('Programmer IT with fpdf'); $h = 10; $pdf->SetFont('Times', 'B', 16); $pdf->image(base_url() . 'assets/img/logo-black.png', 95, 5, 20, 20); $pdf->Ln(15); $pdf->Cell(190, 8, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 14); $pdf->Cell(190, 5, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell(190, 5, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(7); //Column widths $pdf->SetFont('courier', 'B', 14); $pdf->Cell(198, 4, 'KARTU HASIL STUDI (KHS) MAHASISWA', 0, 1, 'C'); $pdf->Ln(5); $h = 6; $pdf->SetFont('courier', '', 12); $pdf->Cell(30, $h, 'NIM', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . $nim, 0, 0, 'L'); $pdf->SetX(120); $pdf->Cell(35, $h, 'Tahun Akademik ', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . $th_ak, 0, 1, 'L'); $pdf->Cell(30, $h, 'Nama', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . strtoupper($nama), 0, 0, 'L'); $pdf->SetX(120); $pdf->Cell(35, $h, 'Semester ', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . strtoupper($smt) . '/' . $semester, 0, 1, 'L'); $pdf->Cell(30, $h, 'PRODI', 0, 0, 'L'); $pdf->Cell(50, $h, ': S1 - ' . $prodi, 0, 0, 'L'); $pdf->SetX(120); $pdf->Cell(35, $h, 'IP ', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . $ip, 0, 1, 'L'); $w = array(10, 20, 85, 10, 20, 20, 20); //Header $pdf->SetFont('courier', 'B', 10); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 8; $pdf->Cell($w[0], $h, 'No.', 'TB', 0, 'C', $fill); $pdf->Cell($w[1], $h, 'Kode', 'TB', 0, 'C', $fill); $pdf->Cell($w[2], $h, 'Mata Kuliah', 'TB', 0, 'C', $fill); $pdf->Cell($w[3], $h, 'SKS', 'TB', 0, 'C', $fill); $pdf->Cell($w[4], $h, 'N.Huruf', 'TB', 0, 'C', $fill); $pdf->Cell($w[5], $h, 'N.Angka', 'TB', 0, 'C', $fill); $pdf->Cell($w[6], $h, 'N.Bobot', 'TB', 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 7; $pdf->SetFont('courier', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; $jmlnilai = 0; foreach ($q->result() as $row) { $sks = $row->sks; $angka = $this->model_data->cari_nilai_angka($row->nilai_akhir); $akhir = $angka * $sks; $pdf->Cell($w[0], $h, $no, 0, 0, 'C', $fill); $pdf->Cell($w[1], $h, $row->kd_mk, 0, 0, 'C', $fill); $pdf->Cell($w[2], $h, $row->nama_mk, 0, 0, 'L', $fill); $pdf->Cell($w[3], $h, $row->sks, 0, 0, 'C', $fill); $pdf->Cell($w[4], $h, $row->nilai_akhir, 0, 0, 'C', $fill); $pdf->Cell($w[5], $h, $angka, 0, 0, 'C', $fill); $pdf->Cell($w[6], $h, $akhir, 0, 0, 'C', $fill); $pdf->Ln(); //$fill = !$fill; $jmlsks = $jmlsks + $row->sks; $jmlnilai = $jmlnilai + $akhir; $no++; } //$ip = $jmlnilai/$jmlsks; // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 6; $pdf->SetFont('courier', 'B', 9); $pdf->Cell(115, $h, 'J U M L A H :', 'T', 0, 'C', $fill); $pdf->Cell(10, $h, $jmlsks, 'T', 0, 'C', $fill); $pdf->Cell(40, $h, '', 'T', 0, 'C', $fill); $pdf->Cell(20, $h, $jmlnilai, 'T', 0, 'C', $fill); $pdf->Ln(); $pdf->Cell(115, $h, 'Indeks Prestasi (IP) :', 'TB', 0, 'C', $fill); $pdf->Cell(10, $h, '', 'TB', 0, 'C', $fill); $pdf->Cell(40, $h, number_format($ip, 2), 'TB', 0, 'C', $fill); $pdf->Cell(20, $h, '', 'TB', 0, 'C', $fill); $pdf->Ln(10); $h = 5; $pdf->SetFont('courier', '', 12); $pdf->Cell(50, $h, 'Menyetujui', 0, 0, 'C'); $pdf->SetX(110); $pdf->Cell(100, $h, 'Serang, ' . $this->model_global->tgl_indo(date('Y-m-d')), 0, 1, 'C'); $pdf->Cell(50, $h, 'Ketua Program Studi,', 0, 0, 'C'); $pdf->SetX(110); $pdf->Cell(100, $h, 'Mahasiswa', 0, 1, 'C'); $pdf->Ln(20); $pdf->Cell(50, $h, $nama_ka_prodi, 0, 0, 'C'); $pdf->SetX(110); $pdf->Cell(100, $h, $nama, 0, 1, 'C'); $pdf->Cell(50, $h, 'NIK : ' . $nik_ka_prodi, 0, 0, 'C'); $pdf->SetX(110); $pdf->Cell(100, $h, 'NIM :' . $nim, 0, 1, 'C'); $pdf->Ln(5); $h = 4; $pdf->SetFont('courier', 'B', 8); $pdf->Cell(100, $h, 'Catatan :', 0, 1, 'L'); $pdf->SetFont('courier', '', 8); $pdf->MultiCell(0, $h, 'Jumlah maksimum SKS yang dapat diambil pada semester berikutnya berdasarkan indeks prestasi (IP) adalah sebagai berikut :'); $pdf->Ln(); $pdf->Cell(20, $h, '3.00 - 4.00', 0, 0, 'L'); $pdf->Cell(50, $h, '= 24 SKS', 0, 0, 'L'); $pdf->Ln(); $pdf->Cell(20, $h, '2.50 - 2.99', 0, 0, 'L'); $pdf->Cell(50, $h, '= 22 SKS', 0, 0, 'L'); $pdf->Ln(); $pdf->Cell(20, $h, '2.00 - 2.49', 0, 0, 'L'); $pdf->Cell(50, $h, '= 20 SKS', 0, 0, 'L'); $pdf->Ln(); $pdf->Cell(20, $h, '1.50 - 1.99', 0, 0, 'L'); $pdf->Cell(50, $h, '= 16 SKS', 0, 0, 'L'); $pdf->Ln(); $pdf->Cell(20, $h, '1.00 - 1.49', 0, 0, 'L'); $pdf->Cell(50, $h, '= 14 SKS', 0, 0, 'L'); $pdf->Ln(); $pdf->Cell(20, $h, '0.00 - 0.99', 0, 0, 'L'); $pdf->Cell(50, $h, '= 12 SKS', 0, 0, 'L'); $pdf->footer(); //} //} $pdf->Output('KHS_' . $th_ak . '_' . $smt . '_' . $nim . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('khs'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }