$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) { $n++; $nn = 0; $hgb = 0;
//$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();*/ $a->SetFont('Arial', '', 10); // $rec = $temp_rec->result(); $n = 0; foreach ($temp_rec as $r) { $n++;
$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); $a->Cell(162, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true);
$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; $jml = 0; foreach ($temp_rec as $r) { $n++; $a->Row(array($n, strtoupper($r->Kode), ucwords(strtolower($r->Nama_Barang)), rdb('inv_barang_kategori', 'Kategori', 'Kategori', "where ID='" . $r->ID_Kategori . "'"), number_format($r->stock, 0), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . $r->ID_Satuan . "'"), number_format($r->harga_beli, 2), $r->Status)); } $a->Output('application/logs/' . $this->session->userdata('userid') . '_mutasi.pdf', 'F');
$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; $s_wajib = $s_wajib + $r->Kredit;
$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))); //sub tlot $harga = $harga + $r->Total;
$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++; $nn = 0; if ($detail == '') { $a->Row(array($n, tglfromSql($r->Tanggal), $r->Nomor, ucwords($r->Nama), number_format($r->Harga_Beli, 2), $r->Jenis_Beli));
$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++; $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), $r->Nama, $r->Jenis_Jual . " - No. Faktur : " . $r->Nomor)); //sub tlot
$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)); } if ($n < 15) { $h = 6 * (15 - $n);
$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; $des = $r->Deskripsi != '' ? " No.: " . $r->ID_Post . " " . $r->Deskripsi . " [ " . tglfromSql($r->Tgl_Cicilan) . " ]" : ''; $terima = rdb('pinjaman_bayar', 'totalbayar', 'sum(kredit) as totalbayar', "where id_pinjaman='" . $r->NoUrut . "' and year(tanggal)='" . substr($r->Tanggal, 0, 4) . "'");
$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; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225);
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++; $tot = 0; $r->ID == 5 ? '' : $a->Row(array($r->Kode . '.' . $r->Nama_Kas), false); $data = $this->report_model->lap_sub_cash($r->ID);
$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))); //sub tlot $harga = $harga + $r->stock * $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(225, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true);
//$a->Header(); $a->setKriteria("transkip"); $a->setNama("Laporan SPB Bulanan"); $a->AliasNbPages(); $a->AddPage("L", "A4"); //$data=$temp_rec->row(); $a->Ln(2); // spasi enter $a->SetFont('Arial', 'B', 12); // set font,size,dan properti (B=Bold) $a->Cell(0, 4, 'Bulan : ' . $bln, 0, 1, 'L'); $a->Cell(0, 4, 'Tahun : ' . $thn, 0, 1, 'L'); $a->Ln(2); $a->SetFont('Arial', '', 10); // set lebar tiap kolom tabel transaksi $a->SetWidths(array(7, 40, 25, 40, 35, 40, 22, 22, 18, 25)); // set align tiap kolom tabel transaksi $a->SetAligns(array("C", "L", "C", "L", "L", "L", "R", "R", "C", "C")); $a->SetFont('Arial', 'B', 10); $a->Ln(2); // set nama header tabel transaksi $a->SetFillColor(225, 225, 225); $a->Cell(7, 7, 'No.', 1, 0, 'C', true); $a->Cell(40, 7, 'NO. SPB', 1, 0, 'C', true); $a->Cell(25, 7, 'TGL SPB', 1, 0, 'C', true); $a->Cell(40, 7, 'NAMA PEMILIK', 1, 0, 'C', true); $a->Cell(35, 7, 'NO.KTP/SIM', 1, 0, 'C', true); $a->Cell(40, 7, 'JENIS BARANG', 1, 0, 'C', true); $a->Cell(22, 7, 'TAKSIR', 1, 0, 'C', true); $a->Cell(22, 7, 'NILAI TAKS', 1, 0, 'C', true); $a->Cell(18, 7, 'JK.WAKTU', 1, 0, 'C', true);
$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; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225);
$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) { $n++; $orient == 'P' ? $a->Row(array($n, rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $r->ID_Barang . "'"), ucwords(rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $r->ID_Barang . "'")), number_format($r->Jumlah, 2), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . rdb('inv_barang', 'ID_Satuan', 'ID_Satuan', "where ID='" . $r->ID_Barang . "'") . "'"), number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2))) : $a->Row(array($n, ucwords($r->Nama_Barang), number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2), $r->Nama, $r->Jenis_Jual . " - " . $r->Nomor));
$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++; $a->Row(array($n, tglfromSql($r->Tanggal), $r->Nomor, $r->Nama_Barang, number_format($r->Jumlah, 2), $r->Satuan, number_format($r->Harga_Beli, 2), number_format($r->Jumlah * $r->Harga_Beli, 2), $r->Jenis_Beli . " - No. Faktur : " . $r->Nomor)); //sub tlot
$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; $s_wajib = $s_wajib + $r->Kredit;
$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; //$debit =($debit+($r->debit)); } if ($n < 15) { $h = 6 * (15 - $n);
$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; // print_r($temp_rec); foreach ($temp_rec as $r) { $n++;
$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))); //sub tlot $harga = $harga + $r->harga_beli; } $a->SetFont('Arial', 'B', 10); $a->SetFillColor(225, 225, 225); $a->Cell(165, 8, "TOTAL", 1, 0, 'R', true); $a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true);
$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))); //sub tlot $jml = $jml + $r->Debet;