function struk_data_footer_kredit()
{
$data = array();
$bawah = "";
$nama = rdb('mst_anggota', 'Nama', 'Nama', "where ID='" . rdb('inv_penjualan', 'ID_Anggota', 'ID_Anggota', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . $this->tgl . "'") . "'");
$urut = rdb('mst_anggota', 'No_Agt', 'No_Agt', "where ID='" . rdb('inv_penjualan', 'ID_Anggota', 'ID_Anggota', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . $this->tgl . "'") . "'");
$alm = rdb('mst_anggota', 'Alamat', 'concat(Alamat," ",Kota) as Alamat', "where Nama='{$nama}'");
$ncby = rdb('inv_penjualan_jenis', 'Jenis_Jual', 'Jenis_Jual', "where ID='" . rdb('inv_penjualan', 'ID_Jenis', 'ID_Jenis', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . $this->tgl . "'") . "'");
$bank = rdb('inv_penjualan', 'Deskripsi', 'Deskripsi', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . $this->tgl . "'");
$rek = rdb('inv_penjualan', 'ID_Post', 'ID_Post', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . $this->tgl . "'");
$tgir = rdb('inv_penjualan', 'Tgl_Cicilan', 'Tgl_Cicilan', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . $this->tgl . "'");
$this->inv_model->tabel('inv_pembayaran');
$data = $this->inv_model->show_list_1where('no_transaksi', $this->no_trans);
foreach ($data->result() as $row) {
$bawah = str_repeat('-', 79) . newline() . sepasi(61 - strlen('Sub Total')) . 'Sub Total :' . sepasi(14 - strlen(number_format($row->total_belanja, 2))) . number_format($row->total_belanja, 2) . newline(2) . sepasi(61 - strlen('Corting')) . 'Corting :' . sepasi(14 - strlen(number_format($row->ppn, 2))) . number_format($row->ppn, 2) . newline() . sepasi(61) . str_repeat('-', 18) . '+' . newline() . sepasi(61 - strlen('Total')) . 'Total :' . sepasi(14 - strlen(number_format($row->total_bayar, 2))) . number_format($row->total_bayar, 2) . newline(2) . sepasi(61 - strlen('Uang Muka')) . 'Uang Muka :' . sepasi(14 - strlen(number_format($row->jml_dibayar, 2))) . number_format($row->jml_dibayar, 2) . newline(2) . sepasi(61) . str_repeat('-', 17) . '-' . newline() . sepasi(61 - strlen('Sisa')) . 'Sisa :' . sepasi(14 - strlen(number_format($row->kembalian, 2))) . number_format($row->kembalian, 2) . newline(2) . str_repeat('-', 79) . newline() . 'Pembayaran' . sepasi(14 - strlen('Pembayaran')) . ':' . $ncby . ' No. :' . $rek . ' ' . $bank . '[' . tglfromSql($tgir) . ']' . newline() . 'Nama Konsumen' . sepasi(14 - strlen('Nama Konsumen')) . ':' . $nama . ' [ ' . $urut . ' ]' . newline() . 'Alamat' . sepasi(14 - strlen('Alamat')) . ':' . $alm . newline(2);
}
return $bawah;
}
$valued = $d->Total;
$tot = $tot + $d->Total;
}
if ($row->ID_Calc == 1) {
$ax = $ax + $valued;
} else {
if ($row->ID_Calc == 2) {
$ax = $ax - $valued;
}
}
}
}
$a->Row(array(sepasi(5) . $row->Nama_SubKas, number_format((int) $valued, 2), ''), false);
}
$a->SetFont('Arial', 'B', 10);
$r->ID == 5 ? '' : $a->Row(array(sepasi(15) . 'Total ' . ucwords($r->Nama_Kas), $r->ID == 3 ? number_format((int) $ax, 2) : number_format((int) $tot, 2)), false);
$k = rdb('mst_kas_harian', 'saldo', 'sum(sa_kas) as saldo', $where . " group by tgl_kas");
$saldo = $k + $ax;
$r->ID == 5 ? $a->Row(array($r->Kode . '.' . $r->Nama_Kas, number_format((int) $saldo, 2)), false) : '';
}
$a->Output('application/logs/' . $this->session->userdata('userid') . '_cash_flow.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
