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'); } }
<?php //$xx=new Kasir_Model; $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN PEMBELIAN BARANG"); $a->setSection($detail == '' ? 'rekapbeli' : 'detailbeli'); $a->setFilter(array(empty($sampai) ? $dari : $dari . " s/d " . $sampai, empty($id_jenis) ? '' : $id_jenis)); $a->setReferer(array('Periode', 'Jenis Pembayaran')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage($detail == '' ? "P" : "P", "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths($detail == '' ? array(10, 20, 22, 60, 30, 40) : array(10, 20, 20, 50, 22, 18, 25, 27)); // set align tiap kolom tabel transaksi $a->SetAligns($detail == '' ? array("C", "C", "C", "L", "R", "L") : array("R", "C", "C", "L", "R", "L", "R", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); $dataz = array(); $n = 0; $harga = 0; $hargaj = 0; $jml = 0; $hgb = 0; foreach ($temp_rec as $r) { $n++;
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'); } }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_master.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN KAS HARIAN"); $a->setSection("lapkas"); $a->setFilter(array($dari_tgl, $sampai_tgl)); $a->setReferer(array('Dari Tanggal', 'Sampai Tanggal')); $a->setFilename('asset/bin/zetro_master.frm'); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 78, 30, 30)); $a->SetAligns(array("C", "C", "L", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $kredit = 0; $debit = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl), $r->no_trans == '' ? $r->uraian : $r->uraian . " reff :" . $r->no_trans, number_format($r->kredit, 2), number_format($r->debit, 2))); //sub tlot $kredit = $kredit + $r->kredit; $debit = $debit + $r->debit; }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("TAGIHAN KREDIT"); $a->setSection("rekapjualkredit"); $a->setFilter(array($dari . " s/d " . $sampai, $Kategori, $Jenis)); $a->setReferer(array('Periode', 'Departement', 'Jumlah Cicilan')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 70, 60, 15, 30)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "L", "C", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama, rdb('mst_departemen', 'Departemen', 'Departemen', "where ID='" . $r->ID_Dept . "'"), $r->Cicilan, number_format($r->Total, 2)));
<?php $a = new reportProduct(); $zn = new zetro_manager(); //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN STOCK LIMIT"); //$a->setNama("Order by Minimal Stock"); $a->setFilter(array($nm_jenis, $nm_kategori, $nm_golongan)); $a->setReferer(array('Jenis Obat', 'Kategori Obat', 'Sub Kategori')); $a->setFilename('asset/bin/zetro_inv.frm'); $a->setSection("liststock_rpt"); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $width = ''; $jml_record = $zn->Count($a->getSection(), $a->getFilename()); for ($i = 1; $i <= $jml_record; $i++) { $d = explode(',', $zn->rContent($a->getSection(), $i, $a->getFilename())); $width .= $d[9] . ","; } $a->SetWidths(array(10, 20, 20, 25, 55, 20, 15, 25)); $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++;
<?php //$xx=new Kasir_Model; $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LIST PENJUALAN BARANG"); $a->setSection("detailbeli"); $a->setFilter(array($dari . " s/d " . $sampai)); $a->setReferer(array('Periode')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage($detail == '' ? "P" : "P", "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 20, 20, 50, 20, 18, 25, 30)); //$a->SetWidths(array(10,20,20,50,25,18,25,25,25)); // set align tiap kolom tabel transaksi $a->SetAligns(array("R", "C", "C", "L", "R", "L", "R", "R", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); $dataz = array(); $datax = array(); $n = 0; $harga = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) {
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("REKAP PENJUALAN " . strtoupper($judul)); $a->setSection($orient == 'P' ? "rekapjualtunai" : "detailjual"); $a->setFilter(array($dari . " s/d " . $sampai, $Kategori)); $a->setReferer(array('Periode', 'Kategori')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage($orient, "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 30, 60, 20, 18, 25, 25)); //$a->SetWidths(); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "L", "R", "L", "R", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; $corting = 0; foreach ($temp_rec as $r) {
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 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'); } }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_master.frm'; //$a->Header(); $a->setKriteria("faktur"); $a->setNama("Faktur Penjualan Tunai"); $a->setSection("faktur"); $a->setFilter($alamat); $a->setReferer($nm_nasabah); $a->setFilename('asset/bin/zetro_master.frm'); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 75, 30, 12, 30, 30)); $a->SetAligns(array("C", "L", "R", "C", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $kredit = 0; $debit = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->nm_barang, number_format($r->jml_transaksi, 2), $r->nm_satuan, number_format($r->harga_beli, 2), number_format($r->jml_transaksi * $r->harga_beli, 2))); //sub tlot $kredit = $kredit + $r->jml_transaksi * $r->harga_beli; //$debit =($debit+($r->debit)); }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_beli.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN PEJUALAN OBAT TERBANYAK"); $a->setSection("lapjuallist"); $a->setFilter(array($tanggal, $jenisobat, $nm_vendor)); $a->setReferer(array('Tanggal', 'Jenis Obat', 'Nama Dokter')); $a->setFilename('asset/bin/zetro_beli.frm'); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 65, 15, 25, 25, 30, 40, 45)); $a->SetAligns(array("C", "C", "L", "C", "R", "C", "R", "L", "L")); $a->SetFont('Arial', '', 9); $a->SetFont('Arial', 'B', 10); $a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl_transaksi), $r->nm_barang, $r->nm_satuan, $r->jml_transaksi, !empty($r->expired) ? tglfromSql($r->expired) : '', number_format($r->jml_transaksi * $r->harga_beli, 2), $r->nm_produsen, 'Ref.:' . $r->faktur_transaksi)); //sub tlot $harga = $harga + $r->jml_transaksi * $r->harga_beli;
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("DETAIL PENJUALAN " . strtoupper($judul)); $a->setSection("detailjual"); $a->setFilter(array($dari . " s/d " . $sampai, $Kategori)); $a->setReferer(array('Periode', 'Kategori')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage('L', "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 60, 20, 18, 25, 25, 40, 79)); //$a->SetWidths(); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "R", "L", "R", "R", "L", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++;
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_beli.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN REKAP SIMPANAN PER DEPARTEMEN"); $a->setSection("lapbelilist"); $a->setFilter(array($tanggal, $jenisobat, $nm_vendor)); $a->setReferer(array('Sampai Dengan')); $a->setFilename('asset/bin/zetro_beli.frm'); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 70, 15, 25, 25, 30, 40, 40)); $a->SetAligns(array("C", "C", "L", "C", "R", "C", "R", "L", "L")); $a->SetFont('Arial', 'B', 10); $a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl_transaksi), $r->nm_barang, $r->nm_satuan, $r->jml_transaksi, !empty($r->expired) ? tglfromSql($r->expired) : '', number_format($r->harga_beli, 2), $r->nm_produsen, 'Ref. :' . $r->faktur_transaksi)); //sub total harga_beli $harga = $harga + $r->harga_beli; }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_inv.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("INVENTORY COUNT SHEET"); $a->setSection("stokopname"); $a->setFilter(array($bln . " " . $thn)); $a->setReferer(array('Periode ')); $a->setFilename('asset/bin/zetro_inv.frm'); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetFont('Arial', 'B', 10); //$a->Ln(2); // set nama header tabel transaksi $a->SetWidths(array(10, 80, 20, 30, 30)); $a->SetAligns(array("C", "L", "C", "R", "R")); $a->SetFillColor(225, 225, 225); /* $kol=$zn->Count('stokopname',$nfile); $a->Cell(10,8,'No.',1,0,'C',true); for ($i=1;$i<=$kol;$i++){ $d=explode(',',$zn->rContent('stokopname',"$i",$nfile)); $a->Cell($d[9],8,$d[0],1,0,'C',true); } $a->Ln();*/
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'); } }
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"; } }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_akun.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN DETAIL TRANSAKSI"); $a->setFilename('asset/bin/zetro_akun.frm'); $a->setSection("addcontent"); $a->setReferer(array('Tanggal', 'Nomor Jurnal', 'Keterangan', 'Unit')); $a->setFilter(array($Tanggal, $NoJurnal, $Keterangan, $ID_Unit)); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 25, 90, 31, 31, 90)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "L", "R", "R", "L")); $a->SetFont('Arial', 'B', 10); //$a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $s_pokok = 0; $s_wajib = 0; $s_kusus = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Kode, $r->Perkiraan, number_format($r->Debet, 2), number_format($r->Kredit, 2), $r->Keterangan)); $s_pokok = $s_pokok + $r->Debet;
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_beli.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN PENJUALAN OBAT RESEP DOKTER"); $a->setSection("lapjuallist"); $a->setFilter(array($tanggal, $jenisobat, $nm_vendor)); $a->setReferer(array('Tanggal', 'Jenis Obat', 'Nama Dokter')); $a->setFilename('asset/bin/zetro_beli.frm'); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 65, 15, 25, 25, 30, 40, 45)); $a->SetAligns(array("C", "C", "L", "C", "R", "C", "R", "L", "L")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl_transaksi), $r->nm_barang, $r->nm_satuan, $r->jml_transaksi, !empty($r->expired) ? tglfromSql($r->expired) : '', number_format($r->jml_transaksi * $r->harga_beli, 2), $r->nm_produsen, 'Ref.:' . $r->faktur_transaksi)); //sub tlot $harga = $harga + $r->jml_transaksi * $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225);
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("REKAP PENJUALAN KREDIT"); $a->setSection("rekapjualkredit"); $a->setFilter(array($dari . " s/d " . $sampai, $Kategori, $Jenis)); $a->setReferer(array('Periode', 'Departement', 'Jumlah Cicilan')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 70, 60, 15, 30)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "L", "C", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama, rdb('mst_departemen', 'Departemen', 'Departemen', "where ID='" . $r->ID_Dept . "'"), $r->Cicilan, number_format($r->Total, 2)));
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'); } }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $pajake = $zn->rContent('Prefference', 'Pajak', 'asset/bin/zetro_config.dll'); $a->setKriteria("transkip"); $a->setNama("LAPORAN KAS MASUK"); $a->setSection("labarugi"); $a->setFilter(array($sampai == '' ? $dari : $dari . ' s/d ' . $sampai)); $a->setReferer(array('Periode')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 30, 30, 30, 25, 30)); $a->SetAligns(array("C", "C", "R", "R", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $ppn = 0; $tppn = 0; $opr = 0; $lab = 0; $kotor = 0;
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("PEMBELIAN PER VENDOR"); $a->setSection("belibyvendor"); $a->setFilter(array(empty($sampai) ? $dari : $dari . " s/d " . $sampai, $vendor)); $a->setReferer(array('Periode', 'Vendor Name')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage('P', "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 20, 20, 50, 25, 18, 30, 30, 69)); //$a->SetWidths(); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "C", "L", "R", "L", "R", "R", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++;
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'); } }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_master.frm'; //$a->Header(); $a->setKriteria("faktur"); $a->setNama("Faktur Penjualan "); $a->setSection("faktur"); $a->setFilter($Company); $a->setReferer($nm_nasabah); $a->setNoFaktur($faktur); $a->setDataset($tanggal); $a->setFilename('asset/bin/zetro_master.frm'); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 77, 25, 18, 30, 30)); $a->SetAligns(array("C", "L", "R", "C", "R", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $kredit = 0; $debit = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->Nama_Barang, number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2))); //sub tlot $kredit = $kredit + $r->Jumlah * $r->Harga;
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_beli.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN PENJUALAN MATERIAL"); $a->setSection("lapjuallist"); $a->setFilter(array($tanggal, $jenisobat, $nm_vendor)); $a->setReferer(array('Tanggal', 'Kategori', 'Nama Pelanggan')); $a->setFilename('asset/bin/zetro_beli.frm'); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 65, 15, 25, 25, 30, 40, 45)); $a->SetAligns(array("C", "C", "L", "C", "R", "C", "R", "L", "L")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl_transaksi), $r->nm_barang, $r->nm_satuan, $r->jml_transaksi, !empty($r->expired) ? tglfromSql($r->expired) : '', number_format($r->jml_transaksi * $r->harga_beli, 2), $r->nm_produsen, 'Ref.:' . $r->faktur_transaksi)); //sub tlot $harga = $harga + $r->jml_transaksi * $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225);
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'); } }
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_akun.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN JURNAL UMUM"); $a->setFilename('asset/bin/zetro_akun.frm'); $a->setSection("jurnal"); $a->setFilter(array($tanggal, $ID_Unit)); $a->setReferer(array('Periode', 'Unit')); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 25, 15, 25, 112, 32, 32, 25)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "C", "C", "L", "R", "R", "R", "R")); $a->SetFont('Arial', 'B', 10); //$a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $s_pokok = 0; $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;
<?php $a = new reportProduct(); $zn = new zetro_manager(); //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN STOCK OBAT"); $a->setFilter(array($nm_jenis, $nm_kategori, $nm_golongan)); $a->setReferer(array('Jenis Obat', 'Kategori Obat', 'Sub Kategori')); $a->setFilename('asset/bin/zetro_inv.frm'); $a->setSection("liststock_rpt"); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $width = ''; $jml_record = $zn->Count($a->getSection(), $a->getFilename()); for ($i = 1; $i <= $jml_record; $i++) { $d = explode(',', $zn->rContent($a->getSection(), $i, $a->getFilename())); $width .= $d[9] . ","; } $a->SetWidths(array(10, 20, 20, 25, 55, 20, 15, 25)); $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)));
<?php if (!defined('BASEPATH')) { exit('No direct script access allowed'); } $a = new reportProduct(); $TglLong = LongTgl($dari); $TglSamp = LongTgl($sampai); $a->setKriteria("neraca"); $a->setNama("LAPORAN ALIRAN KAS"); $a->setSection(""); $a->setFilter(array($sampai == '' ? $TglLong : $TglLong . " s/d " . $TglSamp)); $a->setReferer(array('Periode')); $a->setFilename('asset/bin/zetro_akun.frm'); $a->AliasNbPages(); //$a->AddPage("P","A4"); $a->AddPage('P', 'A4'); $a->SetFont('Arial', '', 10); $a->SetWidths(array(100, 30, 30)); // set lebar tiap kolom tabel transaksi $a->SetAligns(array("L", "R", "R")); // set align tiap kolom tabel transaksi $a->SetFont('Arial', 'B', 10); $data = array(); $n = 0; $ax = 0; $k = 0; $saldo = 0; $where = $sampai == '' ? "where tgl_kas='" . tgltoSql($dari) . "'" : "where tgl_kas between '" . tgltoSql($dari) . "' and '" . tgltoSql($sampai) . "'"; foreach ($temp_rec as $r) { $n++;