PHP reportProductの例

コード例 #1

ファイル: lap_jual_print_vendor.php プロジェクト: asad345100/pos-ci

<?php

$a = new reportProduct();
$zn = new zetro_manager();
$nfile = 'asset/bin/zetro_neraca.frm';
//$a->Header();
$a->setKriteria("transkip");
$a->setNama("PENJUALAN PER PERLANGGAN");
$a->setSection("detailbeli");
$a->setFilter(array(empty($dari) ? 'All' : $dari . " s/d " . $sampai, empty($vendor) ? 'All' : $vendor));
$a->setReferer(array('Periode', 'Nama Pelanggan'));
$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, 20, 18, 25, 30));
//$a->SetWidths();
// set align tiap kolom tabel transaksi
$a->SetAligns(array("C", "C", "C", "L", "R", "L", "R", "R"));
$a->SetFont('Arial', '', 9);
//$rec = $temp_rec->result();
$n = 0;
$hgb = 0;
$hargaj = 0;
$jml = 0;
foreach ($temp_rec as $r) {
    $n++;
    $nn = 0;
    $harga = 0;

コード例 #2

ファイル: lap_beli_print.php プロジェクト: asad345100/pos-ci

<?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++;

コード例 #3

ファイル: c_lap_pck.php プロジェクト: pthsi/dap

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

コード例 #4

ファイル: lap_kas_print.php プロジェクト: asad345100/pos-ci

<?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;
}

コード例 #5

ファイル: lap_kreditur_tagihan_print.php プロジェクト: asad345100/pos-ci

<?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)));

コード例 #6

ファイル: cetak_absen_tulis.php プロジェクト: alfandy10011/host

 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";
     }
 }

コード例 #7

ファイル: lap_jual_print_detail.php プロジェクト: asad345100/pos-ci

<?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) {

コード例 #8

ファイル: lap_detaill_print.php プロジェクト: asad345100/pos-ci

<?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++;

コード例 #9

ファイル: wisuda.php プロジェクト: suryo/mysiakad

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

コード例 #10

ファイル: lap_kas_print.php プロジェクト: asad345100/pos-ci

<?php

$a = new reportProduct();
$zn = new zetro_manager();
$nfile = 'asset/bin/zetro_neraca.frm';
//$a->Header();
$a->setKriteria("transkip");
$a->setNama("LAPORAN KAS MASUK");
$a->setSection("kasmasuk");
$a->setFilter(array($sampai == '' ? $dari : $dari . ' s/d ' . $sampai, $id_jenis));
$a->setReferer(array('Periode', 'Jenis Pembayaran'));
$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, 25, 20, 30, 30, 75));
$a->SetAligns(array("C", "C", "C", "R", "R", "L"));
$a->SetFont('Arial', '', 9);
//$rec = $temp_rec->result();
$n = 0;
$harga = 0;
$hgb = 0;
$hargaj = 0;
$terima = 0;
foreach ($temp_rec as $r) {
    $n++;
    $dibayar = 0;
    $tobayar = 0;
    $terima = 0;

コード例 #11

ファイル: lap_beli_print.php プロジェクト: asad345100/pos-ci

<?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;
}

コード例 #12

ファイル: khs.php プロジェクト: suryo/mysiakad

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

コード例 #13

ファイル: cash_flow_print.php プロジェクト: asad345100/pos-ci

<?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++;

コード例 #14

ファイル: c_lap_ovt.php プロジェクト: pthsi/dap

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

コード例 #15

ファイル: jurnal_umum_print.php プロジェクト: asad345100/pos-ci

<?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;

コード例 #16

ファイル: lap_faktur_print.php プロジェクト: asad345100/pos-ci

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

コード例 #17

ファイル: countsheet_print.php プロジェクト: asad345100/pos-ci

<?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();*/

コード例 #18

ファイル: lap_jual_print.php プロジェクト: asad345100/pos-ci

<?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) {

コード例 #19

ファイル: lap_resep_print.php プロジェクト: asad345100/pos-ci

<?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);

コード例 #20

ファイル: isi_krs.php プロジェクト: suryo/mysiakad

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

コード例 #21

ファイル: lap_mutasi_mhs.php プロジェクト: suryo/mysiakad

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

コード例 #22

ファイル: c_lap_wip.php プロジェクト: pthsi/dap

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

コード例 #23

ファイル: lap_beli_print_vendor.php プロジェクト: asad345100/pos-ci

<?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++;

コード例 #24

ファイル: jurnal_detail_print.php プロジェクト: asad345100/pos-ci

<?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;

コード例 #25

ファイル: lap_faktur_print.php プロジェクト: asad345100/pos-ci

<?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;

コード例 #26

ファイル: lap_laba_rugi_print.php プロジェクト: asad345100/pos-ci

<?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;

コード例 #27

ファイル: lap_absen.php プロジェクト: suryo/mysiakad

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

コード例 #28

ファイル: lap_mahasiswa.php プロジェクト: suryo/mysiakad

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

コード例 #29

ファイル: lap_stock_print.php プロジェクト: asad345100/pos-ci

<?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)));

コード例 #30

ファイル: lap_mutasi_print.php プロジェクト: asad345100/pos-ci

<?php

if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}
$a = new reportProduct();
$zn = new zetro_manager();
$nfile = 'asset/bin/zetro_neraca.frm';
//$a->Header();
$a->setKriteria("transkip");
$a->setNama("REKAP PEMAKAIAN BARANG");
$a->setSection("pemakaian");
$a->setFilter(array($dari . " s/d " . $sampai));
$a->setReferer(array('Periode'));
$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,25,60,20,15,25));
$lebar = width_kol_pdf('pemakaian', $nfile);
echo $lebar;
$a->SetWidths(array(10, 20, 30, 60, 20, 20, 25, 30, 60));
// set align tiap kolom tabel transaksi
$a->SetAligns(array("C", "C", "C", "L", "L", "R", "R", "R", "L"));
$a->SetFont('Arial', 'B', 10);
$a->SetFont('Arial', '', 9);
//$rec = $temp_rec->result();
$n = 0;
$harga = 0;