public function cetak() { $cek = $this->session->userdata('logged_in'); if (!empty($cek)) { $th_ak = $this->input->post('th_ak'); $prodi = $this->input->post('kd_prodi'); if (empty($th_ak)) { $this->session->set_flashdata('result_info', '<center>Tahun Akademik Tidak boleh kosong</center>'); redirect('lap_mahasiswa'); return false(); } $where = "WHERE status='Aktif' AND th_akademik='{$th_ak}' "; if (!empty($prodi)) { $where .= " AND kd_prodi='{$prodi}'"; } $q = $this->db->query("SELECT * FROM mahasiswa {$where} "); $r = $q->num_rows(); if ($r > 0) { $pdf = new reportProduct(); $pdf->setKriteria("cetak_laporan"); $pdf->setNama("CETAK LAPORAN"); $pdf->AliasNbPages(); $pdf->AddPage("L", "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 = 7; $pdf->SetFont('Times', 'B', 14); $pdf->SetX(6); $pdf->Cell(198, 4, $this->config->item('nama_instansi'), 0, 1, 'L'); $pdf->SetX(6); $pdf->SetFont('Times', '', 10); $pdf->Cell(198, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'L'); $pdf->Ln(5); //Column widths $pdf->SetFont('Arial', 'B', 14); $pdf->SetX(6); $pdf->Cell(290, 4, 'Laporan Mahasiswa', 0, 1, 'C'); $pdf->Ln(5); $w = array(10, 25, 30, 30, 80, 10, 30, 35, 25); //Header $pdf->SetFont('Arial', 'B', 10); $pdf->Cell($w[0], $h, 'No', 1, 0, 'C'); $pdf->Cell($w[1], $h, 'Th Akademik', 1, 0, 'C'); $pdf->Cell($w[2], $h, 'PRODI', 1, 0, 'C'); $pdf->Cell($w[3], $h, 'NIM', 1, 0, 'C'); $pdf->Cell($w[4], $h, 'NAMA', 1, 0, 'C'); $pdf->Cell($w[5], $h, 'L/P', 1, 0, 'C'); $pdf->Cell($w[6], $h, 'HP', 1, 0, 'C'); $pdf->Cell($w[7], $h, 'Kota', 1, 0, 'C'); $pdf->Cell($w[8], $h, 'Status', 1, 0, 'C'); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; foreach ($q->result() as $row) { $sing = $this->model_data->singkat_jurusan($row->kd_prodi); $pdf->Cell($w[0], $h, $no, 'LR', 0, 'C', $fill); $pdf->Cell($w[1], $h, $row->th_akademik, 'LR', 0, 'C', $fill); $pdf->Cell($w[2], $h, $row->kd_prodi . '(' . $sing . ')', 'LR', 0, 'C', $fill); $pdf->Cell($w[3], $h, $row->nim, 'LR', 0, 'C', $fill); $pdf->Cell($w[4], $h, $row->nama_mhs, 'LR', 0, 'L', $fill); $pdf->Cell($w[5], $h, $row->sex, 'LR', 0, 'C', $fill); $pdf->Cell($w[6], $h, $row->hp, 'LR', 0, 'L', $fill); $pdf->Cell($w[7], $h, $row->kota, 'LR', 0, 'L', $fill); $pdf->Cell($w[8], $h, $row->status, 'LR', 0, 'C', $fill); $pdf->Ln(); $fill = !$fill; $no++; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(10); $pdf->SetX(200); $pdf->Cell(100, $h, 'Serang, ' . $this->model_global->tgl_indo(date('Y-m-d')), 'C'); $pdf->Ln(20); $pdf->SetX(200); $pdf->Cell(100, $h, '___________________', 'C'); //} //} $pdf->Output('Lap_Mahasiswa.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('lap_mahasiswa'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
$s_wajib = 0; $s_kusus = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, tglfromSql($r->Tanggal), rdb('unit_jurnal', 'unit', 'unit', "where ID='" . $r->ID_Unit . "'"), $r->Nomor, $r->Ket, number_format($r->Debet, 2), number_format($r->Kredit, 2), number_format($r->Debet - $r->Kredit, 2))); $s_pokok = $s_pokok + $r->Debet; $s_wajib = $s_wajib + $r->Kredit; } /**/ $a->SetFont('Arial', 'B', 9); $a->SetFillColor(225, 225, 225); $a->Cell(187, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(32, 8, number_format($s_pokok, 2), 1, 0, 'R', true); $a->Cell(32, 8, number_format($s_wajib, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($s_pokok - $s_wajib, 2), 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_jurnal.pdf', 'F'); //show pdf output in frame $path = 'application/views/_laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _jurnal.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1"></iframe> <?php panel_end();
public function cetak() { $cek = $this->session->userdata('logged_in'); if (!empty($cek)) { $kd_prodi = $this->input->post('kd_prodi'); $smt = $this->input->post('smt'); $where = "WHERE aktif='Ya'"; if (!empty($kd_prodi)) { $where .= " AND kd_prodi='{$kd_prodi}'"; } if (!empty($smt)) { $where .= " AND smt='{$smt}'"; } $q = $this->db->query("SELECT * FROM mata_kuliah {$where} "); $r = $q->num_rows(); if ($r > 0) { $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 = 7; $pdf->SetFont('Times', 'B', 14); $pdf->SetX(6); $pdf->Cell(198, 4, $this->config->item('nama_instansi'), 0, 1, 'L'); $pdf->SetX(6); $pdf->SetFont('Times', '', 10); $pdf->Cell(198, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'L'); $pdf->Ln(5); //Column widths $pdf->SetFont('Arial', 'B', 14); $pdf->SetX(6); $pdf->Cell(210, 4, 'DAFTAR MATA KULIAH', 0, 1, 'C'); $pdf->Ln(5); $w = array(10, 30, 30, 100, 10, 10); //Header $pdf->SetFont('Arial', 'B', 10); $pdf->Cell($w[0], $h, 'No', 1, 0, 'C'); $pdf->Cell($w[1], $h, 'PRODI', 1, 0, 'C'); $pdf->Cell($w[2], $h, 'KODE', 1, 0, 'C'); $pdf->Cell($w[3], $h, 'NAMA MATA KULIAH', 1, 0, 'C'); $pdf->Cell($w[4], $h, 'SKS', 1, 0, 'C'); $pdf->Cell($w[5], $h, 'SMT', 1, 0, 'C'); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $t_sks = 0; foreach ($q->result() as $row) { $sing = $this->model_data->singkat_jurusan($row->kd_prodi); $pdf->Cell($w[0], $h, $no, 'LR', 0, 'C', $fill); $pdf->Cell($w[1], $h, $row->kd_prodi . '(' . $sing . ')', 'LR', 0, 'C', $fill); $pdf->Cell($w[2], $h, $row->kd_mk, 'LR', 0, 'C', $fill); $pdf->Cell($w[3], $h, $row->nama_mk, 'LR', 0, 'L', $fill); $pdf->Cell($w[4], $h, $row->sks, 'LR', 0, 'C', $fill); $pdf->Cell($w[5], $h, $row->smt, 'LR', 0, 'C', $fill); $pdf->Ln(); $fill = !$fill; $no++; $t_sks = $t_sks + $row->sks; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(); $pdf->Cell(170, $h, 'Total SKS', 0, 0, 'C'); $pdf->Cell(10, $h, $t_sks, 0, 0, 'C'); $pdf->Ln(10); $pdf->SetX(150); $pdf->Cell(100, $h, 'Serang, ' . $this->model_global->tgl_indo(date('Y-m-d')), 'C'); $pdf->Ln(20); $pdf->SetX(150); $pdf->Cell(100, $h, '___________________', 'C'); //} //} $pdf->Output('Lap_Mata_Kuliah.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('lap_mata_kuliah'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
$harga = $harga + round($kotor, -2); //($r->Jual-$r->Harga_Beli)); $hgb = $hgb + $opr; $hargaj = $hargaj + $lab; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(40, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($hgb, 2), 1, 0, 'R', true); $a->Cell(25, 8, number_format($tppn, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($hargaj, 2), 1, 1, 'R', true); /* $a->Cell(140,8,"SALDO",1,0,'R',true); $a->Cell(30,8,number_format(($harga-$hargaj),2),1,0,'R',true); */ $a->Output('application/logs/' . $this->session->userdata('userid') . '_laba_rugi.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _laba_rugi.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1"></iframe> <?php panel_end();
//sub tlot $a->SetFont('Arial', 'B', 9); $a->SetFillColor(242, 239, 219); $a->Cell(165, 8, "Sub Total", 1, 0, 'R', true); $a->Cell(27, 8, number_format($hgb, 2), 1, 1, 'R', true); } } //grand total $harga = $harga + $r->Harga_Beli; } $a->SetFont('Arial', 'B', 9); $a->SetFillColor(225, 225, 225); $a->Cell($detail == '' ? 112 : 165, 8, "GRAND TOTAL", 1, 0, 'R', true); $a->Cell($detail == '' ? 30 : 27, 8, number_format($harga, 2), 1, 0, 'R', true); $detail != '' ? '' : $a->Cell(40, 8, '', 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_rekap_pembelian.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _rekap_pembelian.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1" style="z-index:100"></iframe> <?php panel_end();
public function print_pdf() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'admin') { $tgl_awal = $this->session->userdata('tgl_awal'); $tgl_akhir = $this->session->userdata('tgl_akhir'); $pic = $this->session->userdata('pic'); $shift = $this->session->userdata('shift'); $kategori = $this->session->userdata('kategori'); if (!empty($pic)) { $pic_status = "AND a.pic='{$pic}'"; } else { $pic_status = ''; } if (!empty($shift)) { $shift_status = "AND a.shift='{$shift}'"; } else { $shift_status = ''; } if (!empty($kategori)) { $kategori_stat = "AND c.cat_target = '{$kategori}'"; } else { $kategori_stat = ''; } $query = "SELECT a.id_pck,a.tgl_input,b.nama_lengkap,a.shift,c.cat_target as kategori,a.lokasi,\r\n\t\t\ta.plan,a.actual,a.ar*100 as ar,truncate((a.ac)*100,2) as ac,a.inputer \r\n\t\t\tFROM pck_transaksi as a JOIN fg_users as b ON a.pic = b.username \r\n\t\t\tJOIN wip_keramik_kat as c ON a.kategori = c.id_wip \r\n\t\t\twhere tgl_input between '{$tgl_awal}' and '{$tgl_akhir}' {$pic_status} {$shift_status} {$kategori_stat}"; $q = $this->db->query($query); $r = $q->num_rows(); if ($r > 0) { $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('Mpod Schuzatcky'); $h = 7; $w = 190; $pdf->SetFont('Times', 'B', 18); $pdf->Cell($w, $h, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 14); $pdf->Cell($w, $h, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell($w, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(8); //Column widths $h = 5; $pdf->SetFont('Arial', 'B', 14); $pdf->Cell($w, $h, 'Laporan AR Packing', 0, 1, 'C'); $pdf->Cell($w, $h, $this->model_global->tgl_indo($tgl_awal) . ' - ' . $this->model_global->tgl_indo($tgl_akhir), 0, 1, 'C'); $pdf->Ln(5); $l = 12; $w = array(7, 26, 20, 13, 17, 18, 15, 15, 12, 20, 15, 12); //Header $pdf->SetFont('Arial', 'B', 7); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 8; $pdf->Cell($w[0], $h, 'No', 1, 0, 'C', $fill); $pdf->Cell($w[1], $h, 'Tanggal Input', 1, 0, 'C', $fill); $pdf->Cell($w[2], $h, 'PIC', 1, 0, 'C', $fill); $pdf->Cell($w[3], $h, 'Shift', 1, 0, 'C', $fill); $pdf->Cell($w[4], $h, 'Kategori', 1, 0, 'C', $fill); $pdf->Cell($w[5], $h, 'Lokasi', 1, 0, 'C', $fill); $pdf->Cell($w[6], $h, 'Plan (pcs)', 1, 0, 'C', $fill); $pdf->Cell($w[7], $h, 'Aktual (pcs)', 1, 0, 'C', $fill); $pdf->Cell($w[8], $h, 'AR (%)', 1, 0, 'C', $fill); $pdf->Cell($w[9], $h, 'Pencapaian (%)', 1, 0, 'C', $fill); $pdf->Cell($w[10], $h, 'Status', 1, 0, 'C', $fill); $pdf->Cell($w[11], $h, 'Inputer', 1, 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 7; $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; foreach ($q->result() as $row) { $tgl = $this->model_global->tgl_indo($row->tgl_input); $pdf->Cell($w[0], $h, $no, 1, 0, 'C'); $pdf->Cell($w[1], $h, $tgl, 1, 0, 'C'); $pdf->Cell($w[2], $h, $row->nama_lengkap, 1, 0, 'C'); $pdf->Cell($w[3], $h, $row->shift, 1, 0, 'C'); $pdf->Cell($w[4], $h, $row->kategori, 1, 0, 'C'); $pdf->Cell($w[5], $h, $row->lokasi, 1, 0, 'C'); $pdf->Cell($w[6], $h, $row->plan, 1, 0, 'C'); $pdf->Cell($w[7], $h, $row->actual, 1, 0, 'C'); $pdf->Cell($w[8], $h, $row->ar, 1, 0, 'C'); $pdf->Cell($w[9], $h, $row->ac, 1, 0, 'C'); $rencana = $row->ar; $hasil = $row->ac; if ($hasil = $rencana && $hasil > $rencana) { $status = "Tercapai"; } else { $status = "Gagal"; } $pdf->Cell($w[10], $h, $status, 1, 0, 'C'); $pdf->Cell($w[11], $h, $row->inputer, 1, 0, 'C'); $pdf->Ln(); $fill = !$fill; $no++; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(10); $h = 5; //$pdf->Cell(50,$h,'Menyetujui',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'Cicadas, ' . $this->model_global->tgl_indo(date('Y-m-d')), 0, 1, 'C'); //$pdf->Cell(50,$h,'Ketua Program Studi,',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'Packing,', 0, 1, 'C'); $pdf->Ln(20); //$pdf->Cell(50,$h,'_______________________',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, '_____________________', 0, 1, 'C'); //$pdf->Cell(50,$h,'NIP : ',0,0,'L'); $pdf->SetX(150); $pdf->Cell(100, $h, 'NIK :', 0, 1, 'L'); //} //} $pdf->Output('pck_transaksi_' . $tgl_awal . '-' . $tgl_akhir . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('c_lap_fg'); //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'); } }
public function print_pdf() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'admin') { $th_ak = $this->session->userdata('th_ak'); $smt = $this->session->userdata('smt'); $kd_prodi = $this->session->userdata('kd_prodi'); $query = "SELECT a.id_mutasi,a.th_akademik,a.semester,a.tgl_mutasi,a.nim,a.status,a.ket,\n\t\t\t\t\t\tb.nama_mhs,b.sex,b.kd_prodi\n\t\t\t\t\t\tFROM mutasi_mhs as a\n\t\t\t\t\t\tJOIN mahasiswa as b\n\t\t\t\t\t\tON a.nim=b.nim\n\t\t\t\t\tWHERE a.th_akademik='{$th_ak}' AND a.semester='{$smt}' AND b.kd_prodi='{$kd_prodi}'"; $q = $this->db->query($query); $r = $q->num_rows(); if ($r > 0) { $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 = 7; $w = 190; $pdf->SetFont('Times', 'B', 18); $pdf->Cell($w, $h, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 14); $pdf->Cell($w, $h, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell($w, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(8); //Column widths $h = 5; $pdf->SetFont('Arial', 'B', 14); $pdf->Cell($w, $h, 'MUTASI MAHASISWA', 0, 1, 'C'); $pdf->Cell($w, $h, $th_ak . ' - ' . strtoupper($smt), 0, 1, 'C'); $pdf->Ln(5); $l = 10; $w = array(10, 30, 80, 10, 40, 20); //Header $pdf->SetFont('Arial', 'B', 11); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 8; $pdf->Cell($w[0], $h, 'No', 1, 0, 'C', $fill); $pdf->Cell($w[1], $h, 'NIM', 1, 0, 'C', $fill); $pdf->Cell($w[2], $h, 'NAMA MAHASISWA', 1, 0, 'C', $fill); $pdf->Cell($w[3], $h, 'L/P', 1, 0, 'C', $fill); $pdf->Cell($w[4], $h, 'TANGGAL', 1, 0, 'C', $fill); $pdf->Cell($w[5], $h, 'STATUS', 1, 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 7; $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; foreach ($q->result() as $row) { $tgl = $this->model_global->tgl_indo($row->tgl_mutasi); $pdf->Cell($w[0], $h, $no, 1, 0, 'C'); $pdf->Cell($w[1], $h, $row->nim, 1, 0, 'C'); $pdf->Cell($w[2], $h, strtoupper($row->nama_mhs), 1, 0, 'L'); $pdf->Cell($w[3], $h, $row->sex, 1, 0, 'C'); $pdf->Cell($w[4], $h, $tgl, 1, 0, 'C'); $pdf->Cell($w[5], $h, $row->status, 1, 0, 'C'); $pdf->Ln(); $fill = !$fill; $no++; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(10); $h = 5; //$pdf->Cell(50,$h,'Menyetujui',0,0,'C'); $pdf->SetX(120); $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(120); $pdf->Cell(100, $h, 'Bagian Akademik,', 0, 1, 'C'); $pdf->Ln(20); //$pdf->Cell(50,$h,'_______________________',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, '_____________________', 0, 1, 'C'); //$pdf->Cell(50,$h,'NIP : ',0,0,'L'); $pdf->SetX(120); $pdf->Cell(100, $h, 'NIP :', 0, 1, 'L'); //} //} $pdf->Output('MUTASI_MAHASISWA_' . $th_ak . '_' . $smt . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('lap_mutasi_mhs'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
public function print_pdf() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'admin') { $tgl_awal = $this->session->userdata('tgl_awal'); $tgl_akhir = $this->session->userdata('tgl_akhir'); $pic = $this->session->userdata('pic'); $shift = $this->session->userdata('shift'); if (!empty($pic)) { $pic_status = "and b.sec_des = '{$pic}'"; } else { $pic_status = ''; } if (!empty($shift)) { $shift_status = "{$shift}"; } else { $shift_status = 'month'; } $query = "select distinct(b.sec_des) as sec_des, b.div_des , b.dep_des , a.periode,a.sond, sum(a.sondr) as sondr, sum(a.sonbdr) as sonbdr, \r\n(sum(a.sondr)-sum(a.sonbdr)) as ondor, a.sofd, sum(a.sofdr) as sofdr, sum(a.sofbdr) as sofbdr, \r\n(sum(a.sofdr)-sum(a.sofbdr)) as ofdor, ((sum(a.sondr)-sum(a.sonbdr))+(sum(a.sofdr)-sum(a.sofbdr))) as gt from ovt_transaksi a join dp_emp b on a.id = b.id\r\nwhere b.div_des <> '' AND b.dep_des <> '' AND b.sec_des <> '' AND b.div_des IN ('PRODUCTION & MAINTENANCE','QUALITY CONTROL','R & D & QUALITY CONTROL') \r\nAND a.periode between '{$tgl_awal}' and '{$tgl_akhir}' {$pic_status}\r\ngroup by {$shift_status}(a.periode), b.sec_des order by a.periode desc"; $q = $this->db->query($query); $r = $q->num_rows(); if ($r > 0) { $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('Mpod Schuzatcky'); $h = 7; $w = 190; $pdf->SetFont('Times', 'B', 14); $pdf->Cell($w, $h, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 10); $pdf->Cell($w, $h, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 6); $pdf->Cell($w, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(2); //Column widths $h = 5; $pdf->SetFont('Arial', 'B', 10); $pdf->Cell($w, $h, 'Laporan Rekap Overtime', 0, 1, 'C'); $pdf->SetFont('Arial', '', 8); $pdf->Cell($w, $h, $tgl_awal . ' - ' . $tgl_akhir, 0, 1, 'C'); $pdf->Ln(5); $l = 10; $w = array(4, 12, 30, 38, 48, 20, 20, 15); //Header $pdf->SetFont('Arial', 'B', 4); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 8; $pdf->Cell($w[0], $h, 'No', 1, 0, 'C', $fill); $pdf->Cell($w[1], $h, 'Periode', 1, 0, 'C', $fill); $pdf->Cell($w[2], $h, 'Divisi', 1, 0, 'C', $fill); $pdf->Cell($w[3], $h, 'Departemen', 1, 0, 'C', $fill); $pdf->Cell($w[4], $h, 'Section', 1, 0, 'C', $fill); $pdf->Cell($w[5], $h, 'Total Lembur (di Off Day)', 1, 0, 'C', $fill); $pdf->Cell($w[6], $h, 'Total Lembur (di On Day)', 1, 0, 'C', $fill); $pdf->Cell($w[7], $h, 'Grand Total', 1, 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 3; $pdf->SetFont('Arial', '', 4); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; foreach ($q->result() as $row) { $tgl = $this->model_global->tgl_indo($row->periode); $pdf->Cell($w[0], $h, $no, 1, 0, 'C'); $pdf->Cell($w[1], $h, $tgl, 1, 0, 'C'); $pdf->Cell($w[2], $h, $row->div_des, 1, 0, 'L'); $pdf->Cell($w[3], $h, $row->dep_des, 1, 0, 'L'); $pdf->Cell($w[4], $h, $row->sec_des, 1, 0, 'L'); $pdf->Cell($w[5], $h, $row->ofdor / 60 . ' jam', 1, 0, 'R'); $pdf->Cell($w[6], $h, $row->ondor / 60 . ' jam', 1, 0, 'R'); $pdf->Cell($w[7], $h, $row->gt / 60 . ' jam', 1, 0, 'R'); $pdf->Ln(); $fill = !$fill; $no++; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(5); $h = 5; //$pdf->Cell(50,$h,'Menyetujui',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'Cicadas, ' . $this->model_global->tgl_indo(date('Y-m-d')), 0, 1, 'C'); //$pdf->Cell(50,$h,'Ketua Program Studi,',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'Personalia,', 0, 1, 'C'); $pdf->Ln(10); //$pdf->Cell(50,$h,'_______________________',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, '_____________________', 0, 1, 'C'); //$pdf->Cell(50,$h,'NIP : ',0,0,'L'); $pdf->SetX(150); $pdf->Cell(100, $h, 'NIK :', 0, 1, 'L'); //} //} $pdf->Output('ovt_transaksi_' . $tgl_awal . '-' . $tgl_akhir . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('c_lap_ovt'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
} else { if ($row->ID_Calc == 2) { $ax = $ax - $valued; } } } } $a->Row(array(sepasi(5) . $row->Nama_SubKas, number_format((int) $valued, 2), ''), false); } $a->SetFont('Arial', 'B', 10); $r->ID == 5 ? '' : $a->Row(array(sepasi(15) . 'Total ' . ucwords($r->Nama_Kas), $r->ID == 3 ? number_format((int) $ax, 2) : number_format((int) $tot, 2)), false); $k = rdb('mst_kas_harian', 'saldo', 'sum(sa_kas) as saldo', $where . " group by tgl_kas"); $saldo = $k + $ax; $r->ID == 5 ? $a->Row(array($r->Kode . '.' . $r->Nama_Kas, number_format((int) $saldo, 2)), false) : ''; } $a->Output('application/logs/' . $this->session->userdata('userid') . '_cash_flow.pdf', 'F'); //show pdf output in frame $path = 'application/views/_laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _cash_flow.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1"></iframe> <?php panel_end();
$a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(7, 40, 25, 40, 35, 40, 22, 22, 18, 25)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "C", "L", "L", "L", "R", "R", "C", "C")); $a->SetFont('Arial', 'B', 10); $a->Ln(2); // set nama header tabel transaksi $a->SetFillColor(225, 225, 225); $a->Cell(7, 7, 'No.', 1, 0, 'C', true); $a->Cell(40, 7, 'NO. SPB', 1, 0, 'C', true); $a->Cell(25, 7, 'TGL SPB', 1, 0, 'C', true); $a->Cell(40, 7, 'NAMA PEMILIK', 1, 0, 'C', true); $a->Cell(35, 7, 'NO.KTP/SIM', 1, 0, 'C', true); $a->Cell(40, 7, 'JENIS BARANG', 1, 0, 'C', true); $a->Cell(22, 7, 'TAKSIR', 1, 0, 'C', true); $a->Cell(22, 7, 'NILAI TAKS', 1, 0, 'C', true); $a->Cell(18, 7, 'JK.WAKTU', 1, 0, 'C', true); $a->Cell(25, 7, 'JT TEMPO', 1, 0, 'C', true); $a->Ln(7); $a->SetFont('Arial', '', 10); $rec = $temp_rec->result(); $n = 0; foreach ($rec as $r) { $n++; $a->Row(array($n, $r->no_spb, tglfromSql($r->tgl_spb), $r->nama_spb, $r->ktp_spb, $r->id_barang, number_format($r->taksir_spb), number_format($r->nilai_spb), $r->jw_spb, tglfromSql($r->jt_spb))); //$a->Ln(5); } //print_r($a); $a->Output();
public function cetak() { $cek = $this->session->userdata('logged_in'); if (!empty($cek)) { $NoDaftar = $this->session->userdata('nim'); $NoUjian = $this->app_model->CariNoUjian($NoDaftar); $d['NoDaftar'] = $this->session->userdata('nim'); $d['NoUjian'] = $NoUjian; // ambil data dengan memanggil fungsi di model $data = $this->app_model->getSelectedData("mspcmb", $d); $num_rows = $data->num_rows(); if ($num_rows > 0) { // memanggil (instantiasi) class reportProduct di file print_rekap_helper.php $pdf = new reportProduct(); // anda dapat membuat report lainnya dalam satu file print_rekap_helper.php // dengan cukup mengubah setKriteria dan membuat kondisi (elseif) di file print_rekap_helper.php $pdf->setKriteria("transaksi"); // judul report $pdf->setNama("DATA TRANSAKSI UNTUK BARANG " . $NoDaftar); // buat halaman $pdf->AliasNbPages(); // Potrait ukuran A4 $pdf->AddPage("P", "A4"); foreach ($data->result() as $t) { //Instanciation of inherited class $thA = $t->ThAjaran; //$th = $thA.'/'.$thA+1; $A4[0] = 210; $A4[1] = 297; $Q[0] = 216; $Q[1] = 279; //$pdf=new PDF('P','mm',$A4); //$pdf->Open(); //$pdf->AliasNbPages(); //$pdf->AddPage(); $pdf->SetTitle('KARTU UJIAN CALOM MAHASISWA BARU' . $thA); $pdf->SetCreator('puskom.iainbanten.ac.id with fpdf'); $pdf->SetLineWidth(0.3); $pdf->SetXY(6, 6); $pdf->Cell(96, 120, '', 1, 0, 'C'); $pdf->Cell(6, 120, '', 0, 0, 'C'); $pdf->Cell(96, 120, '', 1, 1, 'C'); $pdf->Image(base_url() . 'asset/images/logo-iain2.jpg', 8, 8, 15, 15); $pdf->SetXY(6, 8); $pdf->SetFont('Times', 'B', 9); $pdf->Cell(96, 4, 'KARTU UJIAN', 0, 1, 'C'); $pdf->Ln(); $pdf->SetFont('Times', 'B', 8); $pdf->SetX(6); $pdf->Cell(96, 3, 'Penerimaan Calon Mahasiswa Baru (S1)', 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(96, 3, 'Institut Agama Islam Negeri', 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(96, 3, '"Sultan Maulana Hasanuddin" Banten', 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(96, 3, 'Tahun Akademik ' . $thA, 0, 1, 'C'); $pdf->Ln(10); $pdf->SetFont('Times', '', 8); $pdf->Cell(30, 5, 'Ruang Ujian', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->RUjian, 0, 1, 'L', false); $pdf->Cell(30, 5, 'Nomor Ujian', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->SetFont('Times', 'B', 8); $pdf->Cell(61, 5, $t->NoUjian, 0, 1, 'L', false); $pdf->SetFont('Times', '', 8); $pdf->Cell(30, 5, 'Nama', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Nama, 0, 1, 'L', false); $pdf->Cell(10, 5, 'Jurusan', 0, 0, 'L', false); $pdf->Cell(20, 5, 'PIL.1', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Jur1 . '-' . $this->app_model->cari_jurusan($t->Jur1), 0, 1, 'L', false); $pdf->Cell(10, 5, '', 0, 0, 'L', false); $pdf->Cell(20, 5, 'PIL.2', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Jur2 . '-' . $this->app_model->cari_jurusan($t->Jur2), 0, 1, 'L', false); $pdf->Cell(10, 5, '', 0, 0, 'L', false); $pdf->Cell(20, 5, 'PIL.3', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Jur3 . '-' . $this->app_model->cari_jurusan($t->Jur3), 0, 1, 'L', false); /* $pdf->Cell(10,5,'',0,0,'L',false); $pdf->Cell(20,5,'PIL.3',0,0,'L',false); $pdf->Cell(5,5,':',0,0,'C',false); $pdf->Cell(61,5,$Jur3,0,1,'L',false); */ $pdf->Ln(10); $pdf->Cell(40, 3, '', 0, 0); $pdf->Cell(56, 3, 'Serang, ' . $this->app_model->tgl_indo($t->TglDaftar), 0, 1, 'C'); $pdf->Cell(40, 3, '', 0, 0); $pdf->Cell(56, 3, 'Peserta,', 0, 1, 'C'); $pdf->Ln(20); $pdf->SetFont('', 'B'); $pdf->Cell(40, 2, '', 0, 0); $pdf->Cell(56, 2, $t->Nama, 0, 1, 'C'); $pdf->Cell(40, 2, '', 0, 0); $pdf->Cell(56, 2, '-------------------------------------', 0, 1, 'C'); $pdf->Cell(40, 2, '', 0, 0); $pdf->SetFont('', 'I'); $pdf->Cell(56, 2, 'Nama Jelas & Tanda Tangan', 0, 1, 'C'); /* $pdf->SetXY(12,77); $pdf->SetLineWidth(.1); $pdf->Cell(35,43,'Pas Foto 4 x 6',1,1,'C'); */ /* $config['image_library'] = 'gd2'; $config['source_image'] = './peserta/foto/'.$t->foto;//'/path/to/image/mypic.jpg'; //$config['create_thumb'] = TRUE; $config['maintain_ratio'] = TRUE; $config['width'] = 320; $config['height'] = 150; $this->load->library('image_lib', $config); $foto = $this->image_lib->resize(); */ $pdf->SetXY(12, 77); $foto = $t->foto; if (empty($foto)) { $pdf->SetLineWidth(0.1); $pdf->Cell(35, 43, 'Pas Foto 4 x 6', 1, 1, 'C'); } else { $pdf->Image(base_url() . 'peserta/foto/' . $foto); } $pdf->SetXY(108, 8); $pdf->SetFont('', 'B'); $pdf->Cell(96, 3, 'JADWAL UJIAN', 0, 1, 'C'); $pdf->Ln(4); $pdf->SetFont('Arial', 'B', 8); $pdf->SetX(108); $pdf->Cell(96, 3, 'TES TULIS', 0, 1, 'C'); $pdf->Ln(4); $pdf->SetFillColor(229, 229, 229); $pdf->SetFont('Helvetica', '', 7); $pdf->SetX(113); $pdf->Cell(84, 3, 'PROGRAM STRATA 1 (S1)', 0, 1, 'L'); $pdf->SetX(114); $pdf->SetFont('Helvetica', 'B', 7); $pdf->Cell(5, 5, 'No', 1, 0, 'C', true); $pdf->Cell(45, 5, 'Mata Ujian', 1, 0, 'C', true); $pdf->Cell(17, 5, 'Tanggal', 1, 0, 'C', true); $pdf->Cell(19, 5, 'Waktu', 1, 1, 'C', true); $pdf->SetX(114); $pdf->SetFont('Helvetica', '', 7); $pdf->Cell(5, 3, '1.', 'LR', 0, 'C'); $pdf->Cell(45, 3, 'Pengetahuan Agama (Tafsir, Hadits, ', 'LR', 0, 'L'); $pdf->Cell(17, 3, '30 Juli 2013', 'LR', 0, 'L'); $pdf->Cell(19, 3, '08.00 s/d 10.00', 'LR', 1, 'C'); $pdf->SetX(114); $pdf->Cell(5, 3, '', 'LR', 0, 'C'); $pdf->Cell(45, 3, 'Tauhid, Fiqh dan Sejarah ', 'LR', 0, 'L'); $pdf->Cell(17, 3, '', 'LR', 0, 'L'); $pdf->Cell(19, 3, '', 'LR', 1, 'C'); $pdf->SetX(114); $pdf->Cell(5, 3, '', 'LBR', 0, 'C'); $pdf->Cell(45, 3, 'Kebudayaan Islam)', 'LBR', 0, 'L'); $pdf->Cell(17, 3, '', 'LBR', 0, 'L'); $pdf->Cell(19, 3, '', 'LBR', 1, 'C'); $pdf->SetX(114); $pdf->Cell(5, 3, '2.', 'LR', 0, 'C'); $pdf->Cell(45, 3, 'Pengetahuan Umum (PPKn, Bhs. ', 'LR', 0, 'L'); $pdf->Cell(17, 3, '30 Juli 2013', 'LR', 0, 'L'); $pdf->Cell(19, 3, '10.30 s/d 12.30', 'LR', 1, 'C'); $pdf->SetX(114); $pdf->Cell(5, 3, '', 'LBR', 0, 'C'); $pdf->Cell(45, 3, 'Indonesia, IPS, IPA, dan Matematika) ', 'LBR', 0, 'L'); $pdf->Cell(17, 3, '', 'LBR', 0, 'L'); $pdf->Cell(19, 3, '', 'LBR', 1, 'C'); $pdf->SetX(114); $pdf->Cell(5, 3, '3.', 'LBR', 0, 'C'); $pdf->Cell(45, 3, 'Bahasa Arab', 'LBR', 0, 'L'); $pdf->Cell(17, 3, '31 Juli 2013', 'LBR', 0, 'L'); $pdf->Cell(19, 3, '08.00 s/d 10.00', 'LBR', 1, 'C'); $pdf->SetX(114); $pdf->Cell(5, 3, '4.', 'LBR', 0, 'C'); $pdf->Cell(45, 3, 'Bahasa Inggris', 'LBR', 0, 'L'); $pdf->Cell(17, 3, '31 Juli 2013', 'LBR', 0, 'L'); $pdf->Cell(19, 3, '10.30 s/d 12.30', 'LBR', 1, 'C'); $pdf->Ln(10); $pdf->SetX(108); $pdf->SetFont('Helvetica', 'B', 7); $pdf->Cell(96, 3, 'TES LISAN', 0, 1, 'C'); $pdf->Ln(4); $pdf->SetX(113); $pdf->SetFont('Helvetica', '', 7); $pdf->Cell(84, 3, 'PROGRAM STRATA 1 (S1)', 0, 1, 'L'); $pdf->SetFillColor(229, 229, 229); $pdf->SetX(114); $pdf->SetFont('Helvetica', 'B', 7); $pdf->Cell(5, 5, 'No', 1, 0, 'C', true); $pdf->Cell(45, 5, 'Mata Ujian', 1, 0, 'C', true); $pdf->Cell(17, 5, 'Tanggal', 1, 0, 'C', true); $pdf->Cell(19, 5, 'Waktu', 1, 1, 'C', true); $pdf->SetX(114); $pdf->SetFont('Helvetica', '', 7); $pdf->Cell(5, 3, '1.', 'LBR', 0, 'C'); $pdf->Cell(45, 3, "Baca Tulis Al-Qur'an", 'LBR', 0, 'L'); $pdf->Cell(17, 3, '01 Agst 2013', 'LBR', 0, 'L'); $pdf->Cell(19, 3, '09.00 s/d 11.00', 'LBR', 1, 'C'); $pdf->Ln(12); $pdf->SetX(114); $pdf->Cell(40, 3, '', 0, 0); $pdf->Cell(44, 3, 'Ketua Panitia PCMB 2013/2014', 0, 1, 'C'); $pdf->Ln(8); $pdf->SetX(114); $pdf->Cell(40, 3, '', 0, 0); $pdf->Cell(44, 3, 'Ttd,', 0, 1, 'C'); $pdf->Ln(8); $pdf->SetX(114); $pdf->SetFont('Helvetica', 'BU', 7); $pdf->Cell(40, 3, '', 0, 0); $pdf->Cell(44, 3, 'Drs. H. Nadjmuddin, MM', 0, 1, 'C'); $pdf->Ln(15); $pdf->SetX(0); $pdf->SetFont('Times', 'I', 7); $pdf->MultiCell(210, 4, '--------------------------------------------------------------------------------------------------------------------- potong di sini ---------------------------------------------------------------------------------------------------------------------'); $pdf->SetXY(6, 140); $pdf->SetLineWidth(0.3); $pdf->Cell(198, 120, '', 1, 1); //$pdf->Image('../../images/logo-iain2.jpg',8,142,20,20); $pdf->SetXY(6, 142); $pdf->SetFont('Times', 'B', 10); $pdf->Cell(198, 5, 'TANDA BUKTI PENDAFTARAN', 0, 1, 'C'); $pdf->Ln(2); $pdf->SetX(6); $pdf->Cell(198, 4, 'Penerimaan Calon Mahasiswa Baru', 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(198, 4, 'Institut Agama Islam Negeri "Sultan Maulana Hasanuddin" Banten', 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(198, 4, 'Tahun Akademik ' . $thA, 0, 1, 'C'); $pdf->SetLineWidth(0.2); $pdf->Line(8, 164, 200, 164); $pdf->Ln(10); $pdf->SetFont('Times', '', 10); $pdf->Cell(35, 5, 'Ruang Ujian', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->RUjian, 0, 1, 'L', false); $pdf->Cell(35, 5, 'Nomor Ujian', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->SetFont('Times', 'B', 10); $pdf->Cell(61, 5, $t->NoUjian, 0, 1, 'L', false); $pdf->SetFont('Times', '', 10); $pdf->Cell(35, 5, 'Nama', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Nama, 0, 1, 'L', false); $pdf->Cell(35, 5, 'Tempat/Tgl Lahir', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->TmptLhr . ", " . $this->app_model->tgl_indo($t->TglLhr), 0, 1, 'L', false); $pdf->Cell(35, 5, 'Asal Sekolah', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->AsalSek, 0, 1, 'L', false); $pdf->Cell(35, 5, 'Nama Asal Sekolah', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->NmAsalSek, 0, 1, 'L', false); $pdf->Cell(15, 5, 'Jurusan', 0, 0, 'L', false); $pdf->Cell(20, 5, 'PIL.1', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Jur1 . '-' . $this->app_model->cari_jurusan($t->Jur1), 0, 1, 'L', false); $pdf->Cell(15, 5, '', 0, 0, 'L', false); $pdf->Cell(20, 5, 'PIL.2', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Jur2 . '-' . $this->app_model->cari_jurusan($t->Jur2), 0, 1, 'L', false); $pdf->Cell(15, 5, '', 0, 0, 'L', false); $pdf->Cell(20, 5, 'PIL.3', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->Jur3 . '-' . $this->app_model->cari_jurusan($t->Jur3), 0, 1, 'L', false); $pdf->Ln(10); $pdf->Cell(140, 4, '', 0, 0); $pdf->Cell(56, 4, 'Serang, ' . $this->app_model->tgl_indo($t->TglDaftar), 0, 1, 'C'); $pdf->Cell(140, 4, '', 0, 0); $pdf->Cell(56, 4, 'Peserta,', 0, 1, 'C'); $pdf->Ln(15); $pdf->SetFont('', 'B'); $pdf->Cell(140, 2, '', 0, 0); $pdf->Cell(56, 2, $t->Nama, 0, 1, 'C'); $pdf->Cell(140, 2, '', 0, 0); $pdf->Cell(56, 2, '-------------------------------------', 0, 1, 'C'); $pdf->Cell(140, 2, '', 0, 0); $pdf->SetFont('', 'I'); $pdf->Cell(56, 2, 'Nama Jelas & Tanda Tangan', 0, 1, 'C'); } //$a->Output(); //$a->Image($file_foto,160,173,$new_w,$new_h); $pdf->Output('KARTU_UJIAN_S1_' . $NoDaftar . '.pdf', 'D'); } else { redirect('/peserta/home/selesai/'); //echo "data ewehan"; } exit; } else { redirect('/peserta/home/logout/'); } }
public function cetak() { $cek = $this->session->userdata('logged_in'); if (!empty($cek)) { $nisn = $this->uri->segment(4); //'123456';//$this->input->post('nim'); $d['nisn'] = $nisn; $thA = $this->config->item('thak'); // ambil data dengan memanggil fungsi di model $data = $this->app_model->getSelectedData("beli_formulir", $d); $num_rows = $data->num_rows(); if ($num_rows > 0) { $pdf = new reportProduct(); $pdf->setKriteria("transaksi"); $pdf->setNama("TANDA TERIMA PENDAFTARAN PCMB " . $nisn); $pdf->AliasNbPages(); $pdf->AddPage("P", "A4"); foreach ($data->result() as $t) { //Instanciation of inherited class //$thA = $t->ThAjaran; //$th = $thA.'/'.$thA+1; $A4[0] = 210; $A4[1] = 297; $Q[0] = 216; $Q[1] = 279; //$pdf=new PDF('P','mm',$A4); //$pdf->Open(); //$pdf->AliasNbPages(); //$pdf->AddPage(); $pdf->SetXY(6, 6); $pdf->SetLineWidth(0.3); $pdf->Cell(198, 100, '', 1, 1); //$pdf->Image('../../images/logo-iain2.jpg',8,142,20,20); $pdf->SetXY(6, 8); $pdf->SetFont('Times', 'B', 10); $pdf->Cell(198, 5, 'KWITANSI PEMBELIAN FORMULIR', 0, 1, 'C'); $pdf->Ln(2); $pdf->SetX(6); $pdf->Cell(198, 4, 'Penerimaan Calon Mahasiswa Baru', 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(198, 4, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(198, 4, 'Tahun Akademik ' . $thA, 0, 1, 'C'); $pdf->SetLineWidth(0.2); $pdf->Line(8, 30, 200, 30); $pdf->Ln(10); $pdf->SetFont('Times', '', 10); $pdf->Cell(35, 5, 'NISN', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->nisn, 0, 1, 'L', false); $pdf->SetFont('Times', '', 10); $pdf->Cell(35, 5, 'Nama', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->nama, 0, 1, 'L', false); $pdf->Cell(35, 5, 'No.HP', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->no_hp, 0, 1, 'L', false); $pdf->Cell(35, 5, 'PIN', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->pin, 0, 1, 'L', false); $pdf->Cell(35, 5, 'Biaya', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, 'Rp. ' . number_format($t->biaya) . '( Dua Ratus Ribu Rupiah )', 0, 1, 'L', false); $pdf->Ln(10); $pdf->Cell(140, 4, '', 0, 0); $pdf->Cell(56, 4, 'Serang, ' . $this->app_model->tgl_indo($t->tglbeli), 0, 1, 'C'); $pdf->Cell(140, 4, '', 0, 0); $pdf->Cell(56, 4, 'Petugas,', 0, 1, 'C'); $pdf->Ln(15); $pdf->SetFont('', 'B'); $pdf->Cell(140, 2, '', 0, 0); $pdf->Cell(56, 2, $t->petugas, 0, 1, 'C'); $pdf->Cell(140, 2, '', 0, 0); $pdf->Cell(56, 2, '-------------------------------------', 0, 1, 'C'); $pdf->Cell(140, 2, '', 0, 0); $pdf->SetFont('', 'I'); $pdf->Cell(56, 2, 'Nama Jelas & Tanda Tangan', 0, 1, 'C'); $pdf->Ln(10); $pdf->SetX(0); $pdf->SetFont('Times', 'I', 7); $pdf->MultiCell(210, 4, '--------------------------------------------------------------------------------------------------------------------- potong di sini ---------------------------------------------------------------------------------------------------------------------'); $pdf->SetXY(6, 120); $pdf->SetLineWidth(0.3); $pdf->Cell(198, 100, '', 1, 1); //$pdf->Image('../../images/logo-iain2.jpg',8,142,20,20); $pdf->SetXY(6, 122); $pdf->SetFont('Times', 'B', 10); $pdf->Cell(198, 5, 'KWITANSI PEMBELIAN FORMULIR', 0, 1, 'C'); $pdf->Ln(2); $pdf->SetX(6); $pdf->Cell(198, 4, 'Penerimaan Calon Mahasiswa Baru', 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(198, 4, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetX(6); $pdf->Cell(198, 4, 'Tahun Akademik ' . $thA, 0, 1, 'C'); $pdf->SetLineWidth(0.2); $pdf->Line(8, 144, 200, 144); $pdf->Ln(10); $pdf->SetFont('Times', '', 10); $pdf->Cell(35, 5, 'NISN', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->nisn, 0, 1, 'L', false); $pdf->SetFont('Times', '', 10); $pdf->Cell(35, 5, 'Nama', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->nama, 0, 1, 'L', false); $pdf->Cell(35, 5, 'No.HP', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->no_hp, 0, 1, 'L', false); $pdf->Cell(35, 5, 'PIN', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, $t->pin, 0, 1, 'L', false); $pdf->Cell(35, 5, 'Biaya', 0, 0, 'L', false); $pdf->Cell(5, 5, ':', 0, 0, 'C', false); $pdf->Cell(61, 5, 'Rp. ' . number_format($t->biaya) . '( Dua Ratus Ribu Rupiah )', 0, 1, 'L', false); $pdf->Ln(10); $pdf->Cell(140, 4, '', 0, 0); $pdf->Cell(56, 4, 'Serang, ' . $this->app_model->tgl_indo($t->tglbeli), 0, 1, 'C'); $pdf->Cell(140, 4, '', 0, 0); $pdf->Cell(56, 4, 'Petugas,', 0, 1, 'C'); $pdf->Ln(15); $pdf->SetFont('', 'B'); $pdf->Cell(140, 2, '', 0, 0); $pdf->Cell(56, 2, $t->petugas, 0, 1, 'C'); $pdf->Cell(140, 2, '', 0, 0); $pdf->Cell(56, 2, '-------------------------------------', 0, 1, 'C'); $pdf->Cell(140, 2, '', 0, 0); $pdf->SetFont('', 'I'); $pdf->Cell(56, 2, 'Nama Jelas & Tanda Tangan', 0, 1, 'C'); } //$a->Output(); //$a->Image($file_foto,160,173,$new_w,$new_h); $pdf->Output('KWITANSI_FORMULIR_' . $nisn . '.pdf', 'D'); } else { redirect('/administrator/home/selesai/'); //echo "data ewehan"; } exit; } else { redirect('/administrator/home/logout/'); } }
$d=explode(',',$zn->rContent('stokopname',"$i",$nfile)); $a->Cell($d[9],8,$d[0],1,0,'C',true); } $a->Ln();*/ $a->SetFont('Arial', '', 10); // $rec = $temp_rec->result(); $n = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama_Barang, $r->Satuan, '', '')); // } $a->Ln(5); $a->Cell(50, 8, 'Counting by', 0, 0, 'C'); $a->Ln(20); $a->Cell(50, 8, '(______________________)', 0, 0, 'C'); $a->Output('application/logs/' . $this->session->userdata('userid') . '_countsheet.pdf', 'F'); $path = 'application/views/_laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('lap_beli.js,jquery.fixedheader.js', $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _countsheet.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1"></iframe> <?php panel_end();
//$terima=(($dibayar-$tobayar)>0)?(int)$dibayar:(int)$tobayar; $a->Row(array($n, $r->Nomor, tglfromSql($r->Tanggal), number_format($r->tBayar, 2), number_format($r->diBayar + $terima, 2), rdb('inv_penjualan_jenis', 'Jenis_Jual', 'Jenis_Jual', "where ID='" . $r->ID_Jenis . "'") . $des)); //sub tlot $harga = $harga + $r->tBayar; $hargaj = $hargaj + ($r->diBayar + $terima); } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(55, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true); $a->Cell(75, 8, '', 1, 1, 'R', true); /* $a->Cell(140,8,"SALDO",1,0,'R',true); $a->Cell(30,8,number_format(($harga-$hargaj),2),1,0,'R',true); */ $a->Output('application/logs/' . $this->session->userdata('userid') . '_kas_masuk.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _kas_masuk.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1"></iframe> <?php panel_end();
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"; } }
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'); } }
$a->Row(array($n, tglfromSql($r->Tanggal), $r->Nomor, $r->Nama_Barang, number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga_Beli, 2), number_format($r->Jumlah * $r->Harga_Beli, 2), $r->Jenis_Beli . " - No. Faktur : " . $r->Nomor)); //sub tlot $jml = $jml + $r->Jumlah; $hargaj = $hargaj + $r->Harga_Beli; $harga = $harga + $r->Jumlah * $r->Harga_Beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(143, 8, "TOTAL", 1, 0, 'R', true); /* $a->Cell(20,8,number_format($jml,2),1,0,'R',true); $a->Cell(18,8,'',1,0,'C',true); */ $a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Cell(69, 8, '', 1, 0, 'C', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_detail_penjualan.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _detail_penjualan.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1"></iframe> <?php panel_end();
public function print_krs() { $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_lalu = $this->model_data->cari_ipk_lalu($semester, $nim); $max_sks = $this->model_global->max_sks($ip_lalu); $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(198, 4, 'KARTU RENCANA STUDI (KRS) 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 smt. Lalu ', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . $ip_lalu . ' Max ' . $max_sks . ' SKS', 0, 1, 'L'); $w = array(8, 60, 10, 15, 20, 20, 55); //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, 'Mata Kuliah', 'TB', 0, 'C', $fill); $pdf->Cell($w[2], $h, 'SKS', 'TB', 0, 'C', $fill); $pdf->Cell($w[3], $h, 'Hari', 'TB', 0, 'C', $fill); $pdf->Cell($w[4], $h, 'Pukul', 'TB', 0, 'C', $fill); $pdf->Cell($w[5], $h, 'Ruang', 'TB', 0, 'C', $fill); $pdf->Cell($w[6], $h, 'Dosen', 'TB', 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 7; $pdf->SetFont('helvetica', '', 8); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; foreach ($q->result() as $row) { $pdf->Cell($w[0], $h, $no, 0, 0, 'C', $fill); $pdf->Cell($w[1], $h, '[' . $row->kd_mk . '] ' . $row->nama_mk, 0, 0, 'L', $fill); $pdf->Cell($w[2], $h, $row->sks, 0, 0, 'C', $fill); $pdf->Cell($w[3], $h, $row->hari, 0, 0, 'C', $fill); $pdf->Cell($w[4], $h, $row->pukul, 0, 0, 'C', $fill); $pdf->Cell($w[5], $h, $row->ruang, 0, 0, 'C', $fill); $pdf->Cell($w[6], $h, $row->nm_dosen, 0, 0, 'L', $fill); $pdf->Ln(); //$fill = !$fill; $jmlsks = $jmlsks + $row->sks; $no++; } // Closing line $pdf->SetFont('courier', 'B', 11); $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $pdf->Cell(68, $h, 'Jumlah SKS :', 'TB', 0, 'R', $fill); $pdf->Cell(10, $h, $jmlsks, 'TB', 0, 'C', $fill); $pdf->Cell(110, $h, '', 'TB', 0, 'C', $fill); $pdf->SetFont('courier', '', 11); $pdf->Ln(10); $h = 5; $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->Output('KRS_' . $th_ak . '_' . $smt . '_' . $nim . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('krs'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
public function print_pdf() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'admin') { $jadwal = $this->session->userdata('id_jadwal'); $q = $this->db->query("SELECT * FROM krs WHERE id_jadwal='{$jadwal}' "); $r = $q->num_rows(); if ($r > 0) { foreach ($q->result() as $dt) { $th_ak = $dt->th_akademik; $smt = $dt->semester; $kd_dosen = $dt->kd_dosen; $nama_dosen = $dt->nm_dosen; $kd_mk = $dt->kd_mk; $nama_mk = $dt->nama_mk; $sks = $dt->sks; $hari = $dt->hari; $pukul = $dt->pukul; $ruang = $dt->ruang; } $pdf = new reportProduct(); $pdf->setKriteria("cetak_laporan"); $pdf->setNama("CETAK LAPORAN"); $pdf->AliasNbPages(); $pdf->AddPage("L", "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 = 7; $w = 290; $pdf->SetFont('Times', 'B', 18); $pdf->Cell($w, $h, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 14); $pdf->Cell($w, $h, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell($w, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(8); //Column widths $pdf->SetFont('Arial', 'B', 16); $pdf->Cell($w, $h, 'ABSENSI MAHASISWA', 0, 1, 'C'); $pdf->Cell($w, $h, $th_ak . ' - ' . strtoupper($smt), 0, 1, 'C'); $pdf->Ln(5); $h = 6; $pdf->SetFont('Arial', '', 12); $pdf->Cell(30, $h, 'Mata Kuliah', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . $kd_mk . '-' . $nama_mk, 0, 0, 'L'); $pdf->SetX(180); $pdf->Cell(35, $h, 'Hari / Pukul', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . $hari . ', ' . $pukul, 0, 1, 'L'); $pdf->SetFont('Arial', '', 12); $pdf->Cell(30, $h, 'Nama Dosen', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . $kd_dosen . '-' . strtoupper($nama_dosen), 0, 0, 'L'); $pdf->SetX(180); $pdf->Cell(35, $h, 'Ruang ', 0, 0, 'L'); $pdf->Cell(50, $h, ': ' . strtoupper($ruang), 0, 1, 'L'); $l = 10; $w = array(10, 30, 60, $l, $l, $l, $l, $l, $l, 15, $l, $l, $l, $l, $l, $l, 15, 25); //Header $pdf->SetFont('Arial', 'B', 11); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 8; $pdf->Cell($w[0], $h, 'No', 1, 0, 'C', $fill); $pdf->Cell($w[1], $h, 'NIM', 1, 0, 'C', $fill); $pdf->Cell($w[2], $h, 'NAMA MAHASISWA', 1, 0, 'C', $fill); $pdf->Cell($w[3], $h, '1', 1, 0, 'C', $fill); $pdf->Cell($w[4], $h, '2', 1, 0, 'C', $fill); $pdf->Cell($w[5], $h, '3', 1, 0, 'C', $fill); $pdf->Cell($w[6], $h, '4', 1, 0, 'C', $fill); $pdf->Cell($w[7], $h, '5', 1, 0, 'C', $fill); $pdf->Cell($w[8], $h, '6', 1, 0, 'C', $fill); $pdf->Cell($w[9], $h, 'UTS', 1, 0, 'C', $fill); $pdf->Cell($w[10], $h, '8', 1, 0, 'C', $fill); $pdf->Cell($w[11], $h, '9', 1, 0, 'C', $fill); $pdf->Cell($w[12], $h, '10', 1, 0, 'C', $fill); $pdf->Cell($w[13], $h, '11', 1, 0, 'C', $fill); $pdf->Cell($w[14], $h, '12', 1, 0, 'C', $fill); $pdf->Cell($w[15], $h, '13', 1, 0, 'C', $fill); $pdf->Cell($w[16], $h, 'UAS', 1, 0, 'C', $fill); $pdf->Cell($w[17], $h, 'KET', 1, 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 7; $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; foreach ($q->result() as $row) { $nama_mhs = $this->model_data->cari_nama_mhs($row->nim); $pdf->Cell($w[0], $h, $no, 1, 0, 'C'); $pdf->Cell($w[1], $h, $row->nim, 1, 0, 'C'); $pdf->Cell($w[2], $h, strtoupper($nama_mhs), 1, 0, 'L'); $pdf->Cell($w[3], $h, '', 1, 0, 'C'); $pdf->Cell($w[4], $h, '', 1, 0, 'C'); $pdf->Cell($w[5], $h, '', 1, 0, 'C'); $pdf->Cell($w[6], $h, '', 1, 0, 'C'); $pdf->Cell($w[7], $h, '', 1, 0, 'C'); $pdf->Cell($w[8], $h, '', 1, 0, 'C'); $pdf->Cell($w[9], $h, '', 1, 0, 'C'); $pdf->Cell($w[10], $h, '', 1, 0, 'C'); $pdf->Cell($w[11], $h, '', 1, 0, 'C'); $pdf->Cell($w[12], $h, '', 1, 0, 'C'); $pdf->Cell($w[13], $h, '', 1, 0, 'C'); $pdf->Cell($w[14], $h, '', 1, 0, 'C'); $pdf->Cell($w[15], $h, '', 1, 0, 'C'); $pdf->Cell($w[16], $h, '', 1, 0, 'C'); $pdf->Cell($w[17], $h, '', 1, 0, 'C'); $pdf->Ln(); $fill = !$fill; $no++; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(10); $h = 5; $pdf->Cell(50, $h, 'Menyetujui', 0, 0, 'C'); $pdf->SetX(160); $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(160); $pdf->Cell(100, $h, 'Dosen Pengampu,', 0, 1, 'C'); $pdf->Ln(20); $pdf->Cell(50, $h, '_______________________', 0, 0, 'C'); $pdf->SetX(160); $pdf->Cell(100, $h, $nama_dosen, 0, 1, 'C'); $pdf->Cell(50, $h, 'NIP : ', 0, 0, 'L'); $pdf->SetX(160); $pdf->Cell(100, $h, $kd_dosen, 0, 1, 'C'); //} //} $pdf->Output('ABSENSI_' . $th_ak . '_' . $smt . '_' . $kd_dosen . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('lap_absen'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
public function print_pdf() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'admin') { $tgl_awal = $this->session->userdata('tgl_awal'); $tgl_akhir = $this->session->userdata('tgl_akhir'); $pic = $this->session->userdata('pic'); $shift = $this->session->userdata('shift'); $jns_wip = $this->session->userdata('jns_wip'); if (!empty($pic)) { $pic_status = "AND a.pic='{$pic}'"; } else { $pic_status = ''; } if (!empty($shift)) { $shift_status = "AND a.shift='{$shift}'"; } else { $shift_status = ''; } if (!empty($jns_wip)) { $status_wip = "AND c.jns_wip = '{$jns_wip}'"; } else { $status_wip = ''; } $query = "SELECT a.tgl_input,b.nama_lengkap,a.shift,c.jns_wip,a.lokasi,a.pcs_wip,a.target,\r\n\t\t\t\t\t\ta.akurasi,a.inputer\r\n\t\t\t\t\t\tFROM wip_transaksi as a\r\n\t\t\t\t\t\tJOIN fg_users as b\r\n\t\t\t\t\t\tON a.pic=b.username\r\n\t\t\t\t\t\tJoin wip_keramik_kat as c\r\n\t\t\t\t\t\ton a.jns_wip = c.id_wip\r\n\t\t\t\t\tWHERE (a.tgl_input BETWEEN '{$tgl_awal}' AND '{$tgl_akhir}') {$pic_status} {$shift_status} {$status_wip}"; $q = $this->db->query($query); $r = $q->num_rows(); if ($r > 0) { $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('Mpod Schuzatcky'); $h = 7; $w = 190; $pdf->SetFont('Times', 'B', 18); $pdf->Cell($w, $h, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 14); $pdf->Cell($w, $h, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell($w, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(8); //Column widths $h = 5; $pdf->SetFont('Arial', 'B', 14); $pdf->Cell($w, $h, 'Laporan Rekap WIP Keramik', 0, 1, 'C'); $pdf->Cell($w, $h, $tgl_awal . ' - ' . $tgl_akhir, 0, 1, 'C'); $pdf->Ln(5); $l = 10; $w = array(8, 28, 20, 15, 25, 20, 15, 15, 15, 20); //Header $pdf->SetFont('Arial', 'B', 7); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 8; $pdf->Cell($w[0], $h, 'No', 1, 0, 'C', $fill); $pdf->Cell($w[1], $h, 'Tanggal Input', 1, 0, 'C', $fill); $pdf->Cell($w[2], $h, 'PIC', 1, 0, 'C', $fill); $pdf->Cell($w[3], $h, 'Shift', 1, 0, 'C', $fill); $pdf->Cell($w[4], $h, 'Jenis WIP', 1, 0, 'C', $fill); $pdf->Cell($w[5], $h, 'Lokasi', 1, 0, 'C', $fill); $pdf->Cell($w[6], $h, 'Total (pcs)', 1, 0, 'C', $fill); $pdf->Cell($w[7], $h, 'Target', 1, 0, 'C', $fill); $pdf->Cell($w[8], $h, 'Akurasi', 1, 0, 'C', $fill); $pdf->Cell($w[9], $h, 'Inputer', 1, 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 7; $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; foreach ($q->result() as $row) { $tgl = $this->model_global->tgl_indo($row->tgl_input); $pdf->Cell($w[0], $h, $no, 1, 0, 'C'); $pdf->Cell($w[1], $h, $tgl, 1, 0, 'C'); $pdf->Cell($w[2], $h, $row->nama_lengkap, 1, 0, 'C'); $pdf->Cell($w[3], $h, $row->shift, 1, 0, 'C'); $pdf->Cell($w[4], $h, $row->jns_wip, 1, 0, 'C'); $pdf->Cell($w[5], $h, $row->lokasi, 1, 0, 'C'); $pdf->Cell($w[6], $h, $row->pcs_wip, 1, 0, 'C'); $pdf->Cell($w[7], $h, $row->target, 1, 0, 'C'); $pdf->Cell($w[8], $h, $row->akurasi, 1, 0, 'C'); $pdf->Cell($w[9], $h, $row->inputer, 1, 0, 'C'); $pdf->Ln(); $fill = !$fill; $no++; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(10); $h = 5; //$pdf->Cell(50,$h,'Menyetujui',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'Cicadas, ' . $this->model_global->tgl_indo(date('Y-m-d')), 0, 1, 'C'); //$pdf->Cell(50,$h,'Ketua Program Studi,',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'WIP Keramik,', 0, 1, 'C'); $pdf->Ln(20); //$pdf->Cell(50,$h,'_______________________',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, '_____________________', 0, 1, 'C'); //$pdf->Cell(50,$h,'NIP : ',0,0,'L'); $pdf->SetX(150); $pdf->Cell(100, $h, 'NIK :', 0, 1, 'L'); //} //} $pdf->Output('wip_transaksi_' . $tgl_awal . '-' . $tgl_akhir . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('c_fg'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }
$a->SetAligns(array("C", "L", "L", "L", "L", "R", "C", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->nm_jenis, $r->nm_kategori, $r->nm_golongan, $r->nm_barang, number_format($r->stock, 2), $r->nm_satuan, number_format($r->harga_beli, 2))); //sub tlot $harga = $harga + $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(165, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true); $a->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F'); //show pdf output in frame $path = 'application/views/laporan'; $img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>"; link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js'); panel_begin('Print Preview', '', 'Back' . $img); ?> <iframe src="<?php echo base_url(); ?> application/logs/<?php echo $this->session->userdata('userid'); ?> _laporan_beli.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1"></iframe> <?php panel_end();
public function print_pdf() { $cek = $this->session->userdata('logged_in'); $level = $this->session->userdata('level'); if (!empty($cek) && $level == 'admin') { $tgl_awal = $this->session->userdata('tgl_awal'); $tgl_akhir = $this->session->userdata('tgl_akhir'); $pic = $this->session->userdata('pic'); $pengiriman = $this->session->userdata('pengiriman'); if (!empty($pic)) { $pic_status = "AND a.pic='{$pic}'"; } else { $pic_status = ''; } if (!empty($pengiriman)) { $pengiriman_status = "AND a.jenis='{$pengiriman}'"; } else { $pengiriman_status = ''; } $query = "SELECT a.tgl_input,b.nama_lengkap,a.jenis,a.plan,a.aktual,a.inputer, truncate((a.aktual/a.plan),2)*100 as ar\r\n\t\t\t\t\t\tFROM jc_trans as a JOIN fg_users as b\r\n\t\t\t\t\t\tON a.pic=b.username WHERE (a.tgl_input BETWEEN '{$tgl_awal}' AND '{$tgl_akhir}') \r\n\t\t\t\t\t {$pic_status} {$pengiriman_status} order by a.tgl_input desc"; $q = $this->db->query($query); $r = $q->num_rows(); if ($r > 0) { $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('Mpod Schuzatcky'); $h = 7; $w = 190; $pdf->SetFont('Times', 'B', 18); $pdf->Cell($w, $h, $this->config->item('nama_pendek'), 0, 1, 'C'); $pdf->SetFont('Times', 'B', 14); $pdf->Cell($w, $h, $this->config->item('nama_instansi'), 0, 1, 'C'); $pdf->SetFont('Times', '', 10); $pdf->Cell($w, 4, 'Alamat : ' . $this->config->item('alamat_instansi'), 0, 1, 'C'); $pdf->Ln(8); //Column widths $h = 5; $pdf->SetFont('Arial', 'B', 14); $pdf->Cell($w, $h, 'Laporan Rekap Cetak Jiggering Dan Casting', 0, 1, 'C'); $pdf->Cell($w, $h, $tgl_awal . ' - ' . $tgl_akhir, 0, 1, 'C'); $pdf->Ln(5); $l = 10; $w = array(10, 30, 30, 15, 25, 25, 25, 30); //Header $pdf->SetFont('Arial', 'B', 7); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = true; $h = 8; $pdf->Cell($w[0], $h, 'No', 1, 0, 'C', $fill); $pdf->Cell($w[1], $h, 'Tanggal Cetak', 1, 0, 'C', $fill); $pdf->Cell($w[2], $h, 'Planner', 1, 0, 'C', $fill); $pdf->Cell($w[3], $h, 'Jenis Cetak', 1, 0, 'C', $fill); $pdf->Cell($w[4], $h, 'Plan (pcs)', 1, 0, 'C', $fill); $pdf->Cell($w[5], $h, 'Aktual (pcs)', 1, 0, 'C', $fill); $pdf->Cell($w[6], $h, 'AR (%)', 1, 0, 'C', $fill); $pdf->Cell($w[7], $h, 'Inputer', 1, 0, 'C', $fill); $pdf->Ln(); //data //$pdf->SetFillColor(224,235,255); $h = 7; $pdf->SetFont('Arial', '', 9); $pdf->SetFillColor(204, 204, 204); $pdf->SetTextColor(0); $fill = false; $no = 1; $jmlsks = 0; foreach ($q->result() as $row) { $tgl = $this->model_global->tgl_indo($row->tgl_input); $pdf->Cell($w[0], $h, $no, 1, 0, 'C'); $pdf->Cell($w[1], $h, $tgl, 1, 0, 'C'); $pdf->Cell($w[2], $h, $row->nama_lengkap, 1, 0, 'C'); $pdf->Cell($w[3], $h, $row->jenis, 1, 0, 'C'); $pdf->Cell($w[4], $h, number_format($row->plan, 0, '.', '.'), 1, 0, 'R'); $pdf->Cell($w[5], $h, number_format($row->aktual, 0, '.', '.'), 1, 0, 'R'); $pdf->Cell($w[6], $h, number_format($row->ar, 0, '.', '.'), 1, 0, 'R'); $pdf->Cell($w[7], $h, $row->inputer, 1, 0, 'C'); $pdf->Ln(); $fill = !$fill; $no++; } // Closing line $pdf->Cell(array_sum($w), 0, '', 'T'); $pdf->Ln(10); $h = 5; //$pdf->Cell(50,$h,'Menyetujui',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'Cicadas, ' . $this->model_global->tgl_indo(date('Y-m-d')), 0, 1, 'C'); //$pdf->Cell(50,$h,'Ketua Program Studi,',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, 'Jiggering & Casting,', 0, 1, 'C'); $pdf->Ln(20); //$pdf->Cell(50,$h,'_______________________',0,0,'C'); $pdf->SetX(120); $pdf->Cell(100, $h, '_____________________', 0, 1, 'C'); //$pdf->Cell(50,$h,'NIP : ',0,0,'L'); $pdf->SetX(150); $pdf->Cell(100, $h, 'NIK :', 0, 1, 'L'); //} //} $pdf->Output('jc_transaksi_' . $tgl_awal . '-' . $tgl_akhir . '.pdf', 'D'); } else { $this->session->set_flashdata('result_info', '<center>Tidak Ada Data</center>'); redirect('c_jigcas'); //echo "Maaf Tidak ada data"; } } else { redirect('login', 'refresh'); } }