<?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_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();*/
<?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 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("STOCK BARANG"); $a->setSection("stocklist"); $a->setFilter(array($kategori)); $a->setReferer(array('Kategori')); $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,25,60,20,15,25)); $a->SetWidths(array(10, 28, 52, 25, 15, 20, 20, 15)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "L", "L", "R", "L", "R", "L")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0;
<?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(); $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 //$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++;
<?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_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 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++;
<?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;
<?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;
<?php $a = new reportProduct(); $zn = new zetro_manager(); //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN STOCK OBAT\n Detail Expired Date"); $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_expr"); $a->AliasNbPages(); $a->AddPage("L", "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, 25, 35, 75, 20, 18, 22, 30)); $a->SetAligns(array("C", "L", "L", "L", "L", "R", "C", "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, tglfromSql($r->expired), number_format($r->stock * $r->harga_beli, 2)));
<?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("LAPORAN BARANG YANG HARUS DI BELI"); $a->setSection("stocklimit"); $a->setFilter(array($kategori)); $a->setReferer(array('Kategori')); $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,25,60,20,15,25)); $a->SetWidths(array(10, 30, 60, 25, 25, 30)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "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;
<?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("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) {
<?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++;
<?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_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_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(); //$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 $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_member.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("TAGIHAN PELANGGAN"); $a->setSection("TagihanKreditPdf"); $a->setFilter(array($status)); $a->setReferer(array('Status Tagihan')); $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, 90, 25, 25, 25, 18)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "R", "R", "R", "C")); $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 . ' [ ' . $r->Catatan . ' ]', number_format($r->Debet, 2), number_format($r->Kredit, 2), number_format($r->Saldo, 2), tglfromSql($r->mulai_bayar)));