$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->Row(array($n, $r->Nama_Barang, $r->Satuan, '', ''));
//
}
$a->Ln(5);
$a->Cell(50, 8, 'Counting by', 0, 0, 'C');
$a->Ln(20);
$a->Cell(50, 8, '(______________________)', 0, 0, 'C');
$a->Output('application/logs/' . $this->session->userdata('userid') . '_countsheet.pdf', 'F');
$path = 'application/views/_laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('lap_beli.js,jquery.fixedheader.js', $path . '/js,asset/js');
panel_begin('Print Preview', '', 'Back' . $img);
?>
<iframe src="<?php
echo base_url();
?>
$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++;
$opr = rdb('mst_kas_trans', 'jumlah', 'sum(jumlah) as jumlah', "where tgl_trans='" . $r->Tanggal . "' group by tgl_trans");
$kotor = $pajak == 'ok' ? $r->Jual - $r->Harga_Beli - ($r->Jual - $r->Harga_Beli) * $pajake : $r->Jual - $r->Harga_Beli;
$ppn = $pajak == 'ok' ? $kotor * 10 / 100 : 0;
$lab = $kotor - $opr - $ppn;
$a->Row(array($n, tglfromSql($r->Tanggal), number_format(round($kotor, -2), 2), number_format((int) $opr, 2), number_format($ppn, 2), number_format($lab, 2)));
//sub tlot
$tppn = $tppn + $ppn;
$harga = $harga + round($kotor, -2);
//($r->Jual-$r->Harga_Beli));
$hgb = $hgb + $opr;
$hargaj = $hargaj + $lab;
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(40, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true);
$a->Cell(30, 8, number_format($hgb, 2), 1, 0, 'R', true);
$a->Cell(25, 8, number_format($tppn, 2), 1, 0, 'R', true);
$a->Cell(30, 8, number_format($hargaj, 2), 1, 1, 'R', true);
/* $a->Cell(140,8,"SALDO",1,0,'R',true);
$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->SetFont('Arial', 'B', 9);
$a->SetFillColor(225, 225, 225);
$a->Cell(187, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(32, 8, number_format($s_pokok, 2), 1, 0, 'R', true);
$a->Cell(32, 8, number_format($s_wajib, 2), 1, 0, 'R', true);
$a->Cell(25, 8, number_format($s_pokok - $s_wajib, 2), 1, 0, 'R', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_jurnal.pdf', 'F');
//show pdf output in frame
$path = 'application/views/_laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
$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));
} else {
if ($detail == 'detail') {
//laproan detail pembelian
$a->SetFont('Arial', 'B', 9);
$a->SetFillColor(210, 210, 010);
$a->Cell(10, 8, $n, 1, 0, 'C', true);
$a->Cell(90, 8, $r->Nama, 1, 0, 'L', true);
$a->Cell(65, 8, $r->Catatan . " " . $r->Alamat . " " . $r->Kota, 1, 0, "L", true);
$a->Cell(27, 8, '', 1, 1, 'R', true);
$a->SetFont('Arial', '', 9);
$ID_P = " and p.ID_Pemasok='" . $r->ID_Pemasok . "'";
$dataz = $this->kasir_model->detail_trans_beli($where, $ID_P, $orderby);
foreach ($dataz as $r2) {
$nn++;
$a->Row(array($nn, tglfromSql($r2->Tanggal), $r2->Nomor, ucwords($r2->Nama_Barang), number_format($r2->Jumlah, 2), $r2->Satuan, number_format($r2->Harga_Beli, 2), number_format($r2->Harga_Beli * $r2->Jumlah, 2)));
// 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');
//show pdf output in frame
$path = 'application/views/laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
panel_begin('Print Preview', '', 'Back' . $img);
?>
<iframe src="<?php
echo base_url();
?>
application/logs/<?php
echo $this->session->userdata('userid');
?>
_mutasi.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1" style="z-index:100"></iframe>
$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->Cell(110, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($kredit, 2), 1, 0, 'R', true);
$a->Cell(30, 8, number_format($debit, 2), 1, 0, 'R', true);
$a->ln();
$a->Cell(140, 8, "Saldo Kas", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($kredit - $debit, 2), 1, 0, 'R', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
//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->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(155, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_rekap_penjualan.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
panel_begin('Print Preview', '', 'Back' . $img);
?>
<iframe src="<?php
$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->SetFont('Arial', '', 10);
foreach ($data as $row) {
$valued = 0;
if ($row->ID_CC == 0) {
$valued = rdb('mst_kas_harian', 'saldo', 'sum(sa_kas) as saldo', $where . " group by tgl_kas");
$tot = rdb('mst_kas_harian', 'saldo', 'sum(sa_kas) as saldo', $where . " group by tgl_kas");
} else {
if ($row->ID_CC != 4) {
$datax = $this->report_model->get_cash_flow($row->ID_CC, $dari, $sampai);
foreach ($datax as $d) {
$valued = $d->Total;
$tot = $tot + $d->Total;
}
if ($row->ID_Calc == 1) {
//$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) . "'");
//$tobayar=rdb('inv_pembayaran','total_bayar','sum(total_bayar) as total_bayar',"where /*no_transaksi='".$r->NoUrut."' and*/ date(doc_date)='".$r->Tanggal."' and ID_Jenis='".$r->ID_Jenis."' group by concat(ID_Jenis,date(doc_date))");
//$terima=(($dibayar-$tobayar)>0)?(int)$dibayar:(int)$tobayar;
$a->Row(array($n, $r->Nomor, tglfromSql($r->Tanggal), number_format($r->tBayar, 2), number_format($r->diBayar + $terima, 2), rdb('inv_penjualan_jenis', 'Jenis_Jual', 'Jenis_Jual', "where ID='" . $r->ID_Jenis . "'") . $des));
//sub tlot
$harga = $harga + $r->tBayar;
$hargaj = $hargaj + ($r->diBayar + $terima);
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(55, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true);
$a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true);
$a->Cell(75, 8, '', 1, 1, 'R', true);
/* $a->Cell(140,8,"SALDO",1,0,'R',true);
$a->Cell(30,8,number_format(($harga-$hargaj),2),1,0,'R',true);
*/
$a->Output('application/logs/' . $this->session->userdata('userid') . '_kas_masuk.pdf', 'F');
//show pdf output in frame
// 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->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
panel_begin('Print Preview', '', 'Back' . $img);
?>
<iframe src="<?php
$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;
$hgb = 0;
$hargaj = 0;
$jml = 0;
foreach ($temp_rec as $r) {
$n++;
$a->Row(array($n, tglfromSql($r->Tanggal), rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $r->ID_Barang . "'"), rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $r->ID_Barang . "'"), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . rdb('inv_barang', 'ID_Satuan', 'ID_Satuan', "where ID='" . $r->ID_Barang . "'") . "'"), number_format($r->Jumlah, 2), number_format($r->Harga, 2), number_format($r->Jumlah * $r->Harga, 2), $r->Keterangan));
//sub tlot
$jml = $jml + $r->Jumlah;
$harga = $harga + $r->Harga;
$hargaj = $hargaj + $r->Harga * $r->Jumlah;
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(140, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(20, 8, number_format($jml, 2), 1, 0, 'R', true);
$a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true);
$a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true);
$a->Cell(60, 8, '', 1, 0, 'R', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_mutasi.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
// 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;
$jml = 0;
foreach ($temp_rec as $r) {
$n++;
(int) $r->stock <= $r->minstok ? $a->Row(array($n, strtoupper($r->Kode), $r->Nama_Barang, number_format($r->minstok, 0), number_format($r->stock, 0), rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . $r->ID_Satuan . "'"))) : '';
}
$a->Output('application/logs/' . $this->session->userdata('userid') . '_mutasi.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
panel_begin('Print Preview', '', 'Back' . $img);
?>
<iframe src="<?php
echo base_url();
?>
application/logs/<?php
echo $this->session->userdata('userid');
?>
_mutasi.pdf" height="100%" width="100%" frameborder="0" allowtransparency="1" style="z-index:100"></iframe>
$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->Cell(25, 7, 'JT TEMPO', 1, 0, 'C', true);
$a->Ln(7);
$a->SetFont('Arial', '', 10);
$rec = $temp_rec->result();
$n = 0;
foreach ($rec as $r) {
$n++;
$a->Row(array($n, $r->no_spb, tglfromSql($r->tgl_spb), $r->nama_spb, $r->ktp_spb, $r->id_barang, number_format($r->taksir_spb), number_format($r->nilai_spb), $r->jw_spb, tglfromSql($r->jt_spb)));
//$a->Ln(5);
}
//print_r($a);
$a->Output();
$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');
$a->Cell(22, 8, tglfromSql($r->tgl_kas), 1, 0, 'C');
$a->Cell(108, 8, 'Saldo Awal ' . tglfromSql($r->tgl_kas), 1, 0, 'L');
$a->Cell(30, 8, number_format($r->sa_kas, 2), 1, 1, 'R');
$a->SetFont('Arial', '', 9);
$where = "where tgl_trans='" . $r->tgl_kas . "' and jumlah!='0'";
$datax = $this->kasir_model->operasional($where, $orderby);
foreach ($datax as $row) {
$x++;
$a->Row(array('', $x, $row->uraian_trans, number_format($row->jumlah, 2), ''));
$hgb = $hgb + $row->jumlah;
}
$a->SetFont('Arial', 'I', 9);
$a->Cell(32, 8, '', 1, 0, 'C');
$a->Cell(108, 8, 'Saldo Akhir ' . tglfromSql($r->tgl_kas), 1, 0, 'L');
$a->Cell(30, 8, number_format($r->sa_kas - $hgb, 2), 1, 1, 'R');
}
/* $a->SetFont('Arial','B',10);
$a->SetFillColor(225,225,225);
$a->Cell(110,8,"TOTAL",1,0,'R',true);
$a->Cell(30,8,number_format($harga,2),1,0,'R',true);
$a->Cell(30,8,number_format($hargaj,2),1,1,'R',true);
$a->Cell(140,8,"SALDO",1,0,'R',true);
$a->Cell(30,8,number_format(($harga-$hargaj),2),1,0,'R',true);
*/
$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);
$a->Cell(85, 8, '', 1, 0, 'R', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
panel_begin('Print Preview', '', 'Back' . $img);
?>
// 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
$jml = $jml + $r->Jumlah;
$hargaj = $hargaj + $r->Harga;
$harga = $harga + $r->Jumlah * $r->Harga;
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(108, 8, "TOTAL", 1, 0, 'R', true);
/* $a->Cell(20,8,number_format($jml,2),1,0,'R',true);
$a->Cell(18,8,'',1,0,'C',true);
*/
$a->Cell(25, 8, number_format($hargaj, 2), 1, 0, 'R', true);
$a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true);
$a->Cell(119, 8, '', 1, 0, 'C', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_detail_penjualan.pdf', 'F');
foreach ($dataz as $r2) {
$nn++;
$x = 0;
$a->SetFont('Arial', 'I', 9);
$a->SetFillColor(247, 240, 213);
$a->Cell(10, 8, $nn, 1, 0, 'R', true);
$a->cell(20, 8, tglfromSql($r2->Tanggal), 1, 0, 'C', true);
$a->cell(20, 8, $r2->Nomor, 1, 0, 'C', true);
$a->Cell(70, 8, $r2->ID_Jenis == '1' || $r2->ID_Jenis == '5' ? $r2->Jenis_Jual : $r2->Jenis_Jual . " : " . $r2->ID_Post . " - " . $r2->Deskripsi, 1, 0, "L", true);
$a->Cell(73, 8, $r2->ID_Jenis == '1' || $r2->ID_Jenis == '5' ? "" : "Jatuh Tempo Tanggal : " . tglfromSql($r2->Tgl_Cicilan), 1, 1, 'L', true);
$a->SetFont('Arial', '', 9);
$Grp = " and p.ID_Anggota='" . $r2->ID_Anggota . "' and dt.ID_Jual='" . $r2->ID_Jual . "'";
$dataz = $this->kasir_model->detail_trans_jual($where, $Grp, $orderby);
foreach ($dataz as $rr2) {
$x++;
$a->Row(array('', $x, $rr2->Kode, ucwords($rr2->Nama_Barang), number_format($rr2->Jumlah, 2), $r2->Satuan, number_format($rr2->Harga, 2), number_format($rr2->Harga * $rr2->Jumlah, 2)));
$hgb = $r2->ID_Jenis == '5' ? $hgb - $rr2->Harga * $rr2->Jumlah : $hgb + $rr2->Harga * $rr2->Jumlah;
}
}
//sub tlot
$hargaj = rdb('inv_pembayaran', 'ppn', 'sum(ppn) as ppn', "where no_transaksi='" . $r->NoUrut . "' and year(doc_date)='" . $r->Tahun . "'");
$harga = $harga + ($hgb - $hargaj);
if ($hargaj != 0) {
$a->SetFont('Arial', 'I', 10);
$a->SetFillColor(242, 239, 219);
$a->Cell(163, 8, "Potongan", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($hargaj, 2), 1, 1, 'R', true);
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(242, 239, 219);
$a->Cell(163, 8, "Sub Total", 1, 0, 'R', true);
$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->MultiCell(187, $h, '', 1, 0, 'L');
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(157, 8, "Sub Total", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($kredit, 2), 1, 1, 'R', true);
$a->Cell(157, 8, "PPN 10%", 1, 0, 'R', true);
$a->Cell(30, 8, number_format(round($kredit * 10 / 100, 0), 2), 1, 1, 'R', true);
$a->Cell(157, 8, "Total", 1, 0, 'R', true);
// 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
$jml = $jml + $r->Jumlah;
$hargaj = $hargaj + $r->Harga_Beli;
$harga = $harga + $r->Jumlah * $r->Harga_Beli;
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(143, 8, "TOTAL", 1, 0, 'R', true);
/* $a->Cell(20,8,number_format($jml,2),1,0,'R',true);
$a->Cell(18,8,'',1,0,'C',true);
*/
$a->Cell(30, 8, number_format($hargaj, 2), 1, 0, 'R', true);
$a->Cell(30, 8, number_format($harga, 2), 1, 0, 'R', true);
$a->Cell(69, 8, '', 1, 0, 'C', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_detail_penjualan.pdf', 'F');
$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));
//sub tlot
$corting = rdb('inv_pembayaran', 'ppn', 'sum(ppn) as ppn', "where no_transaksi='" . $r->NoUrut . "' and year(doc_date)='" . $r->Tahun . "'");
$jml = $jml + $r->Jumlah;
$hargaj = $hargaj + $r->Harga;
$harga = $harga + ($r->Jumlah * $r->Harga - $corting);
}
if ($corting != 0) {
$a->SetFont('Arial', 'I', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(100, 8, "Potongan", 1, 0, 'R', true);
$a->Cell(20, 8, '', 1, 0, 'R', true);
$a->Cell(18, 8, '', 1, 0, 'C', true);
$a->Cell(25, 8, '', 1, 0, 'R', true);
$a->Cell(25, 8, number_format($corting, 2), 1, 1, 'R', true);
}
$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);
$a->MultiCell(190, $h, '', 1, 0, 'L');
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(160, 8, "Sub Total", 1, 0, 'R', true);
$a->Cell(30, 8, number_format($kredit, 2), 1, 1, 'R', true);
$a->Cell(160, 8, "PPN 10%", 1, 0, 'R', true);
$a->Cell(30, 8, number_format(round($kredit * 10 / 100, 0), 2), 1, 1, 'R', true);
$a->Cell(160, 8, "Total", 1, 0, 'R', true);
$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;
}
/**/
$a->SetFont('Arial', 'B', 9);
$a->SetFillColor(225, 225, 225);
$a->Cell(125, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(31, 8, number_format($s_pokok, 2), 1, 0, 'R', true);
$a->Cell(31, 8, number_format($s_wajib, 2), 1, 0, 'R', true);
$a->Cell(90, 8, '', 1, 0, 'R', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_jurnal.pdf', 'F');
//show pdf output in frame
$path = 'application/views/_laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
// 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->Output('application/logs/' . $this->session->userdata('userid') . '_laporan_beli.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
$img = " <img src='" . base_url() . "asset/images/back.png' onclick='js:window.history.back();' style='cursor:pointer' title='click for select other filter data'>";
link_js('auto_sugest.js,lap_beli.js,jquery.fixedheader.js', 'asset/js,' . $path . '/js,asset/js');
panel_begin('Print Preview', '', 'Back' . $img);
?>
<iframe src="<?php
//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;
$harga = $harga + $r->Kredit;
$hargaj = $hargaj + $r->Saldo;
}
$a->SetFont('Arial', 'B', 10);
$a->SetFillColor(225, 225, 225);
$a->Cell(100, 8, "TOTAL", 1, 0, 'R', true);
$a->Cell(25, 8, number_format($jml, 2), 1, 0, 'R', true);
$a->Cell(25, 8, number_format($harga, 2), 1, 0, 'R', true);
$a->Cell(25, 8, number_format($hargaj, 2), 1, 0, 'R', true);
$a->Cell(18, 8, '', 1, 0, 'R', true);
$a->Output('application/logs/' . $this->session->userdata('userid') . '_rekap_tagihan.pdf', 'F');
//show pdf output in frame
$path = 'application/views/laporan';
