Beispiel #1
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)));
Beispiel #2
0
<?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++;
Beispiel #3
0
<?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);
Beispiel #4
0
<?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_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;