<?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 //$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 PENJUALAN OBAT RESEP DOKTER"); $a->setSection("lapjuallist"); $a->setFilter(array($tanggal, $jenisobat, $nm_vendor)); $a->setReferer(array('Tanggal', 'Jenis Obat', 'Nama Dokter')); $a->setFilename('asset/bin/zetro_beli.frm'); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 65, 15, 25, 25, 30, 40, 45)); $a->SetAligns(array("C", "C", "L", "C", "R", "C", "R", "L", "L")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl_transaksi), $r->nm_barang, $r->nm_satuan, $r->jml_transaksi, !empty($r->expired) ? tglfromSql($r->expired) : '', number_format($r->jml_transaksi * $r->harga_beli, 2), $r->nm_produsen, 'Ref.:' . $r->faktur_transaksi)); //sub tlot $harga = $harga + $r->jml_transaksi * $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225);
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_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;