<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_neraca.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("TAGIHAN KREDIT"); $a->setSection("rekapjualkredit"); $a->setFilter(array($dari . " s/d " . $sampai, $Kategori, $Jenis)); $a->setReferer(array('Periode', 'Departement', 'Jumlah Cicilan')); $a->setFilename($nfile); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); //echo $a->getColWidth(); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 70, 60, 15, 30)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "L", "C", "R")); $a->SetFont('Arial', 'B', 10); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; $hgb = 0; $hargaj = 0; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Nama, rdb('mst_departemen', 'Departemen', 'Departemen', "where ID='" . $r->ID_Dept . "'"), $r->Cicilan, number_format($r->Total, 2)));
<?php $a = new reportProduct(); $zn = new zetro_manager(); $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_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("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_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 //$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_beli.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN PENJUALAN MATERIAL"); $a->setSection("lapjuallist"); $a->setFilter(array($tanggal, $jenisobat, $nm_vendor)); $a->setReferer(array('Tanggal', 'Kategori', 'Nama Pelanggan')); $a->setFilename('asset/bin/zetro_beli.frm'); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $a->SetWidths(array(10, 22, 65, 15, 25, 25, 30, 40, 45)); $a->SetAligns(array("C", "C", "L", "C", "R", "C", "R", "L", "L")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, tglfromSql($r->tgl_transaksi), $r->nm_barang, $r->nm_satuan, $r->jml_transaksi, !empty($r->expired) ? tglfromSql($r->expired) : '', number_format($r->jml_transaksi * $r->harga_beli, 2), $r->nm_produsen, 'Ref.:' . $r->faktur_transaksi)); //sub tlot $harga = $harga + $r->jml_transaksi * $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225);
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_master.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN ALIRAN KAS"); $a->setSection("lapkas"); $a->setFilter(array($dari)); $a->setReferer(array('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; $harga = 0; $hargaj = 0; $datax = array(); foreach ($temp_rec as $r) { $hgb = 0; $n++; $x = 0; $a->SetFont('Arial', 'BI', 9); $a->Cell(10, 8, $n, 1, 0, 'C');
<?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_akun.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN DETAIL TRANSAKSI"); $a->setFilename('asset/bin/zetro_akun.frm'); $a->setSection("addcontent"); $a->setReferer(array('Tanggal', 'Nomor Jurnal', 'Keterangan', 'Unit')); $a->setFilter(array($Tanggal, $NoJurnal, $Keterangan, $ID_Unit)); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 25, 90, 31, 31, 90)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "L", "R", "R", "L")); $a->SetFont('Arial', 'B', 10); //$a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $s_pokok = 0; $s_wajib = 0; $s_kusus = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, $r->Kode, $r->Perkiraan, number_format($r->Debet, 2), number_format($r->Kredit, 2), $r->Keterangan)); $s_pokok = $s_pokok + $r->Debet;
<?php $a = new reportProduct(); $zn = new zetro_manager(); $nfile = 'asset/bin/zetro_beli.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN 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("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;
<?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 //$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_akun.frm'; //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN JURNAL UMUM"); $a->setFilename('asset/bin/zetro_akun.frm'); $a->setSection("jurnal"); $a->setFilter(array($tanggal, $ID_Unit)); $a->setReferer(array('Periode', 'Unit')); $a->AliasNbPages(); $a->AddPage("L", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(10, 25, 15, 25, 112, 32, 32, 25)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "C", "C", "C", "L", "R", "R", "R", "R")); $a->SetFont('Arial', 'B', 10); //$a->Ln(1); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $s_pokok = 0; $s_wajib = 0; $s_kusus = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, tglfromSql($r->Tanggal), rdb('unit_jurnal', 'unit', 'unit', "where ID='" . $r->ID_Unit . "'"), $r->Nomor, $r->Ket, number_format($r->Debet, 2), number_format($r->Kredit, 2), number_format($r->Debet - $r->Kredit, 2))); $s_pokok = $s_pokok + $r->Debet;
<?php $a = new reportProduct(); $zn = new zetro_manager(); //$a->Header(); $a->setKriteria("transkip"); $a->setNama("LAPORAN STOCK OBAT"); $a->setFilter(array($nm_jenis, $nm_kategori, $nm_golongan)); $a->setReferer(array('Jenis Obat', 'Kategori Obat', 'Sub Kategori')); $a->setFilename('asset/bin/zetro_inv.frm'); $a->setSection("liststock_rpt"); $a->AliasNbPages(); $a->AddPage("P", "A4"); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi // set align tiap kolom tabel transaksi $width = ''; $jml_record = $zn->Count($a->getSection(), $a->getFilename()); for ($i = 1; $i <= $jml_record; $i++) { $d = explode(',', $zn->rContent($a->getSection(), $i, $a->getFilename())); $width .= $d[9] . ","; } $a->SetWidths(array(10, 20, 20, 25, 55, 20, 15, 25)); $a->SetAligns(array("C", "L", "L", "L", "L", "R", "C", "R")); $a->SetFont('Arial', '', 9); //$rec = $temp_rec->result(); $n = 0; $harga = 0; foreach ($temp_rec->result_object() as $r) { $n++; $a->Row(array($n, $r->nm_jenis, $r->nm_kategori, $r->nm_golongan, $r->nm_barang, number_format($r->stock, 2), $r->nm_satuan, number_format($r->harga_beli, 2)));
<?php $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)));