public function show_data_field($section, $table, $where)
{
$data = array();
$jml = $this->zn->Count($section, $this->nfiles);
for ($i = 1; $i < $jml; $i++) {
$fld = explode(",", $this->zn->rContent($section, $i, $this->nfiles));
$fld[2] == 'date' ? $result = tglfromSql($this->Admin_model->show_single_field($table, $fld[3], $where)) : ($result = $this->Admin_model->show_single_field($table, $fld[3], $where));
$data[$fld[3]] = $result;
}
return $data;
}
$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();
$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)));
$hgb = $hgb + $r2->Harga_Beli * $r2->Jumlah;
}
//sub tlot
$a->SetFont('Arial', 'B', 9);
$a->SetFillColor(242, 239, 219);
$a->Cell(165, 8, "Sub Total", 1, 0, 'R', true);
$a->Cell(27, 8, number_format($hgb, 2), 1, 1, 'R', true);
}
}
//grand total
$harga = $harga + $r->Harga_Beli;
}
$a->SetFont('Arial', 'B', 9);
$a->SetFillColor(225, 225, 225);
$a->Cell($detail == '' ? 112 : 165, 8, "GRAND TOTAL", 1, 0, 'R', true);
function get_transaksi()
{
$data = array();
$ID_Dept = empty($_POST['ID_Dept']) ? '' : $_POST['ID_Dept'];
$ID_Aktif = empty($_POST['ID_Aktif']) ? '' : $_POST['ID_Aktif'];
$data = $this->member_model->get_transaksi($ID_Dept, $ID_Aktif);
$n = 0;
$t_debet = 0;
$t_kredit = 0;
foreach ($data as $r) {
$n++;
echo "<tr class='xx' align='center'>\r\n\t\t\t\t <td class='kotak'>{$n}</td>\r\n\t\t\t\t <td class='kotak'>" . tglfromSql(substr($r->Tanggal, 0, 10)) . "</td>\r\n\t\t\t\t <td class='kotak'>" . $r->Kode . "</td>\r\n\t\t\t\t <td class='kotak' align='left' nowrap>" . $r->Perkiraan . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Debet, 2) . "</td>\r\n\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Kredit, 2) . "</td>\r\n\t\t\t\t <td class='kotak' align='left' nowrap>" . $r->Keterangan . "</td>\r\n\t\t\t\t <td class='kotak'>";
echo $r->ID_Stat == '0' ? "<img title='hapus transaksi' src='" . base_url() . "asset/images/no.png' onclick=\"hapus('" . $r->ID . "');\">" : "<img title='sudah terjurnal' src='" . base_url() . "asset/images/5.png'>";
echo "</td>\r\n\t\t\t\t </tr>";
$t_debet = $t_debet + $r->Debet;
$t_kredit = $t_kredit + $r->Kredit;
}
echo "<tr class='list_genap'>\r\n\t\t\t <td class='kotak' colspan='4' align='right'>TOTAL</td>\r\n\t\t\t <td class='kotak' align='right'><b>" . number_format($t_debet, 2) . "</td>\r\n\t\t\t <td class='kotak' align='right'><b>" . number_format($t_kredit, 2) . "</td>\r\n\t\t\t <td class='kotak' align='right'></td>\r\n\t\t\t <td class='kotak' align='right'></td>\r\n\t\t\t </tr>";
}
function print_label()
{
$data = array();
$datax = array();
$kolom = 2;
$n = 0;
$nn = 0;
$datax['list'] = $this->Admin_model->show_list('labeling', "where pp_stat='Y' order by no_spb");
$data = $this->Admin_model->show_list('labeling', "where pp_stat='Y' order by no_spb");
//print_r($data->result_array());
foreach ($data->result_array() as $row) {
$nama_spb = '';
$no_spb = '';
$jw = '';
$jt_tmpo = '';
$nilai_spb = '';
$barang = '';
$nama_spb = substr(rdb('spb', 'nama_spb', 'nama_spb', "where no_spb='" . $row['no_spb'] . "'"), 0, 10);
$no_spb = substr($row['no_spb'], 0, 5);
$jw = $row['jw_spb'];
$jt_tmpo = tglfromSql($row['jt_spb']);
$nilai_spb = number_format($row['nilai_spb'], 0);
$barang = $row['id_barang'];
$datane = array($nama_spb, $no_spb, $jw, $jt_tmpo, $nilai_spb, $barang);
$this->print_slip($n, $datane);
$n++;
$this->Admin_model->upd_data("labeling", "set pp_stat='P'", "where no_spb='" . $row['no_spb'] . "'");
}
$n > 1 ? $z = $n % ($n / 2) : ($z = '');
$z == 1 || ($z = '') ? $zz = 1 : ($zz = 0);
$this->print_slip($n + $zz, '');
$this->print_slip($n + $zz + 1, '');
$this->load->view('master/print_label', $datax);
}
$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';
$a->Cell(93, 8, $r->Catatan . " " . $r->Alamat . " " . $r->Kota, 1, 1, "L", true);
$a->SetFont('Arial', '', 9);
$ID_P = " and p.ID_Anggota='" . $r->ID_Anggota . "' group by dt.ID_Jual";
$orderby .= ",p.Tanggal";
//$a->Cell(193,8,$where.' '.$ID_P.' '.$orderby,1,1,'L',true);
$dataz = $this->kasir_model->detail_trans_jual($where, $ID_P, $orderby);
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);
function vendor_detailed()
{
$data = array();
$n = 0;
$total = 0;
$ID = $_POST['id'];
$data = $this->purch_model->detail_trans_vendor("where p.ID_Pemasok='" . $ID . "' order by p.Tanggal limit 500");
foreach ($data as $r) {
$n++;
echo tr() . td($n, 'center') . td(tglfromSql($r->Tanggal)) . td($r->Nomor) . td($r->Nama_Barang) . td(number_format($r->Jumlah, 2), 'right') . td($r->Satuan) . td(number_format($r->Jumlah * $r->Harga_Beli, 2), 'right') . _tr();
$total = $total + $r->Jumlah * $r->Harga_Beli;
}
echo tr() . td('<b>Total</b>', 'right\' colspan=\'6', 'kotak list_genap') . td('<b>' . number_format($total, 2) . '</b>', 'right') . _tr();
}
//$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
<div class='contents'>
<div class="j_panel judul" style="width:20%">List DO</div>
<div class="pn_content">
<hr>
<?php
$zb = new zetro_listBuilder('asset/bin/zetro_form.cfg');
$zb->ListHeader('Invoice', '100%');
$no = 1;
foreach ($invoice->result_array() as $lst) {
echo "<tr class='xx' align='center' id='" . $lst['iddo'] . "'>\n\r\n\t\t\t\t\t\t <td class='kotak'>{$no}</td>\n\r\n\t\t\t\t\t\t <td class='kotak'>" . $lst['iddo'] . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='left'>" . rdb("customer", "nmcus", "nmcus", "where idcus='" . rdb("transaksi", "idcus", "idcus", "where iddo='" . $lst['iddo'] . "'") . "'") . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='left'>" . rdb("client", "nmclient", "nmclient", "where idclient='" . rdb("transaksi", "idclient", "idclient", "where iddo='" . $lst['iddo'] . "'") . "'") . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='center'>" . tglfromSql($lst['tgldo']) . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='center'>" . tglfromSql($lst["doc_date"]) . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak' align='left'>" . $lst['statusdo'] . "</td>\n\r\n\t\t\t\t\t\t <td class='kotak'>";
/*if($oto['e']=='Y'){$zb->event($lst['iddo'],'','process');//}*/
echo "<td></tr>";
$no++;
}
echo "</table>";
//<table align='center' width='100%'><tr><td>$paginator</td></tr></table>";
?>
</div>
</div>
$n = 0;
$hgb = 0;
$hargaj = 0;
$jml = 0;
foreach ($temp_rec as $r) {
$n++;
$nn = 0;
$harga = 0;
$corting = 0;
$a->SetFont('Arial', 'I', 9);
$a->SetFillColor(210, 210, 010);
$a->Cell(10, 8, $n, 1, 0, 'C', true);
$a->Cell(20, 8, tglfromSql($r->Tanggal), 1, 0, 'L', true);
$a->Cell(20, 8, $r->Nomor, 1, 0, 'L', true);
$a->Cell(70, 8, $r->Jenis_Jual . " " . $r->ID_Post . " - " . $r->Deskripsi, 1, 0, "L", true);
$a->Cell(70, 8, "Tanggal Jatuh Tempo : " . tglfromSql($r->Tgl_Cicilan), 1, 1, "L", true);
$a->SetFont('Arial', '', 9);
$ID = " and ID_Jual='" . $r->ID_Jual . "'";
$dataz = $this->kasir_model->detail_trans_jual($where, $ID, $orderby);
foreach ($dataz as $rr) {
$nn++;
$a->Row(array('', $nn, $rr->Kode, $rr->Nama_Barang, number_format($rr->Jumlah, 2), $r->Satuan, number_format($rr->Harga, 2), number_format($rr->Jumlah * $rr->Harga, 2)));
//sub tlot
$jml = $jml + $rr->Jumlah;
$hargaj = $hargaj + $rr->Harga;
$harga = $harga + $rr->Jumlah * $rr->Harga;
}
//potongan
$corting = rdb('inv_pembayaran', 'ppn', 'sum(ppn) as ppn', "where no_transaksi='" . $r->NoUrut . "' and year(doc_date)='" . $r->Tahun . "'");
if ($corting != 0) {
$a->SetFont('Arial', 'I', 10);
function _set_pinjaman($ID_Agt)
{
//penjualan selain tunai akan masuk table pinjaman
$data = array();
$jmlPinj = 0;
$jmlPinj = rdb('inv_pembayaran', 'total', "(total_bayar-jml_dibayar) as total", "where no_transaksi='" . $this->no_trans . "'");
$data['ID'] = $this->no_trans;
$data['ID_Agt'] = $ID_Agt;
$data['ID_Unit'] = rdb('jenis_simpanan', 'ID_Unit', 'ID_Unit', "where ID='" . $this->id_jenis . "'");
$data['Tanggal'] = tglToSql($this->tgl);
$data['Tahun'] = substr($this->tgl, 6, 4);
$data['jml_pinjaman'] = $jmlPinj;
//rdb('inv_penjualan','Total','Total',"where NoUrut='".$this->no_trans."' and Tanggal='".tglToSql($this->tgl)."'");
$data['cara_bayar'] = $this->id_jenis;
$data['mulai_bayar'] = rdb('inv_penjualan', 'Tgl_Cicilan', 'Tgl_Cicilan', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'");
$data['keterangan'] = rdb('jenis_simpanan', 'Jenis', 'Jenis', "where ID='" . $this->id_jenis . "'") . ' No: ' . rdb('inv_penjualan', 'ID_Post', "ID_Post", "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'") . "-" . rdb('inv_penjualan', 'Deskripsi', 'Deskripsi', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'") . '[ ' . tglfromSql(rdb('inv_penjualan', 'Tgl_Cicilan', 'Tgl_Cicilan', "where NoUrut='" . $this->no_trans . "' and Tanggal='" . tglToSql($this->tgl) . "'")) . ' ]';
$this->Admin_model->replace_data('pinjaman', $data);
}
$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 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
function perpanjang($no_spb, $pp_ke = 1, $showtgl = false, $bayar = false)
{
$jtspb = rdb('spb', 'tgl_spb', 'tgl_spb', "where no_spb='{$no_spb}'");
$nextjtspb = getNextDays($jtspb, $pp_ke * 30);
$nextjtspb2 = getNextDays($jtspb, ($pp_ke + 1) * 30);
$bataslelang = getNextDays($nextjtspb, 13);
$today = date('Y-m-d');
$stat = rdb('perpanjang_spb', 'pp_ke', 'pp_ke', "where no_spb='" . $no_spb . "' and pp_ke='{$pp_ke}'");
$action = rdb('perpanjang_spb', 'pp_stat', 'pp_stat', "where no_spb='" . $no_spb . "' and pp_ke='{$pp_ke}'");
$bayare = $bayar == true && $pp_ke > 1 ? rdb('perpanjang_spb', 'pp_stat', 'pp_stat', "where no_spb='" . $no_spb . "' and pp_ke='" . ($pp_ke - 1) . "'") : '';
$bunga = rdb('spb', 'taksir_spb', 'taksir_spb', "where no_spb='{$no_spb}'");
$bunga = $bunga * 10 / 100;
if ($stat == '') {
if (compare_date($today, $bataslelang) == true && compare_date($today, $nextjtspb) == false) {
return "<img class='aksi' src='" . base_url() . "/asset/images/icon-25.gif' width='20' height='20' title='Klik untuk process perpanjang' onclick=\"aksi_click('{$no_spb}','{$pp_ke}','{$bunga}')\";>";
} else {
return compare_date($nextjtspb2, $today) == false ? $bayar == true && $bayare == 'Y' || $pp_ke == '1' ? "<img src='" . base_url() . "/asset/images/checkout.gif' title='Click untuk transaksi bayar' onclick=\"aksi_click('{$no_spb}','{$pp_ke}','{$bunga}')\">" : false : "<img src='" . base_url() . "/asset/images/8.png' title='Tidak di perpanjang lanjut untuk process lelang'>";
}
} else {
if ($action == 'Y') {
return $showtgl == false ? "<img src='" . base_url() . "/asset/images/iconic.png' ondblclick=\"reset_upd('{$no_spb}','{$pp_ke}','');\" title='Telah di perpanjang " . $stat . " kali.\nTanggal Jatuh Tempo berikutnya :" . tglfromSql(getNextDays($jtspb, ($stat + 1) * 30)) . "'>" : ShortTgl($nextjtspb2);
} else {
if ($action == 'N') {
return "<img src='" . base_url() . "/asset/images/8.png' ondblclick=\"reset_upd('{$no_spb}','{$pp_ke}','Y');\" title='Tidak di perpanjang lanjut untuk process lelang'>";
} else {
if ($action == 'L') {
return "<img src='" . base_url() . "/asset/images/bullet.png' title='Lunas'>";
} else {
return false;
}
}
}
}
}
$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');
function get_transaksi()
{
$data = array();
$no_transaksi = $_POST['no_transaksi'];
$this->inv_model->tabel('detail_transaksi');
$data['tgl_transaksi'] = tglfromSql($this->Admin_model->show_single_field('detail_transaksi', 'tgl_transaksi', "where no_transaksi='{$no_transaksi}'"));
$data['faktur_transaksi'] = $this->Admin_model->show_single_field('detail_transaksi', 'faktur_transaksi', "where no_transaksi='{$no_transaksi}'");
$data['nm_nasabah'] = $this->Admin_model->show_single_field('detail_transaksi', 'nm_produsen', "where no_transaksi='{$no_transaksi}'");
echo json_encode($data);
}
link_js('jquery_print.js', 'application/views/admin/js');
link_js('zetro_number.js,lap_list_spb.js', 'asset/js,application/views/laporan/js');
$user_aktiv = $this->session->userdata("userid");
$blnj = "<select id='bulan' name='bulan'></select>";
$thnj = "<select id='thn' name='thn'></select>";
$img = "<img src='" . base_url() . "asset/images/printer.png' id='printing' title='Print Report' class='xx'>";
echo "<form id='frm1' name='frm1' action='' method='post'>";
panel_begin('Daftar SPB,Perpanjang SPB', '', "Filter by Bulan :," . $blnj . ",Tahun :," . $thnj . ", ", "{$img}");
panel_multi('daftarspb', 'block');
$zb = new zetro_listBuilder('asset/bin/zetro_form.cfg');
$zb->ListHeader('Spb', '100%', 'listTable');
$no = 0;
//($page+1);
foreach ($list->result_array() as $lst) {
$no++;
echo "<tr class='xx' id='" . $lst['no_spb'] . "' align='center'>\r\n\t\t <td class='kotak'>{$no}</td>\r\n\t \t <td class='kotak'>" . $lst['no_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['tgl_spb']) . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['nama_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['ktp_spb'] . "</td>\r\n\t\t <td class='kotak' align='left'>" . $lst['id_barang'] . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['taksir_spb'], 2) . "</td>\r\n\t\t <td class='kotak' align='right'>" . number_format($lst['nilai_spb'], 2) . "</td>\r\n\t\t <td class='kotak'>" . $lst['jw_spb'] . "</td>\r\n\t\t <td class='kotak'>" . tglfromSql($lst['jt_spb']) . "</td>";
$ppke = rdb("perpanjang_spb", "pp_ke", 'pp_ke', "where no_spb='" . $lst['no_spb'] . "'");
echo compare_date($lst['jt_spb'], date('Y-m-d')) ? "<td class='kotak' width='5%'>" . perpanjang($lst['no_spb'], $ppke) . "<td>" : "<td class='kotak' width='5%'> </td></tr>";
}
echo "</tbody></table>\n";
panel_multi_end();
panel_multi('perpanjangspb');
?>
<table id='listdata' style='border-collapse:collapse'>
<thead>
<tr class='header'>
<th class='kotak' rowspan='2' width='20%'>URAIAN</th>
<th class='kotak' colspan='2' width='12%'>PENJUALAN</th>
<th class='kotak' rowspan='2' width='10%'>NAMA NASABAH</th>
<th class='kotak' rowspan='2' width='10%'>TAKSIR</th>
<th class='kotak' rowspan='2' width='10%'>NILAI TAKSIR</th>
$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);
?>
function laporan_pembelian()
{
//process filter
$data = array();
$where = '';
$datax = array();
$n = 0;
empty($_POST['smp_tanggal']) ? $where = "where Tanggal='" . tgltoSql($_POST['dari_tanggal']) . "' and ID_Bayar IS NOT NULL" : ($where = "where (Tanggal between '" . tgltoSql($_POST['dari_tanggal']) . "' and '" . tgltoSql($_POST['smp_tanggal']) . "') and ID_Bayar IS NOT NULL");
//echo $where;
$data = $this->Admin_model->show_list('inv_pembelian', $where . " order by NoUrut");
foreach ($data as $r) {
$n++;
$x = 0;
echo tr('xx list_genap') . td($n . nbs(3), 'center') . td($r->Nomor, 'center') . td(tglfromSql($r->Tanggal), 'center') . td(strtoupper(rdb('inv_pemasok', 'Pemasok', 'Pemasok', "where ID='" . $r->ID_Pemasok . "'")), 'left\' colspan=\'3\'') . td(rdb('inv_pembelian_jenis', 'Jenis_Beli', 'Jenis_Beli', "where ID='" . $r->ID_Jenis . "'")) . td('<b>' . number_format($r->ID_Bayar, 2) . '</b>', 'right') . _tr();
$datax = $this->Admin_model->show_list('inv_pembelian_detail', "where ID_Beli='" . $r->ID . "'");
foreach ($datax as $row) {
$x++;
echo tr() . td(nbs(2) . $x, 'center') . td(rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $row->ID_Barang . "'") . nbs(5), 'right\' colspan=\'2\'') . td(nbs(2) . rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $row->ID_Barang . "'")) . td(rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . $row->ID_Satuan . "'")) . td(number_format($row->Jml_Faktur, 2), 'right') . td(number_format($row->Harga_Beli, 2), 'right') . td(number_format($row->Jml_Faktur * $row->Harga_Beli, 2), 'right') . _tr();
}
}
}
function get_no_jurnal($str, $limit)
{
$data = array();
$sql = "select * from jurnal where Nomor like '%{$str}%' order by NoUrut desc limit {$limit}";
$rs = mysql_query($sql) or die(mysql_error());
while ($rw = mysql_fetch_object($rs)) {
$data[] = array('data' => $rw->Nomor, 'description' => $rw->Keterangan, 'NoUrut' => $rw->NoUrut, 'ID_Bulan' => $rw->ID_Bulan, 'Tahun' => $rw->Tahun, 'ID' => $rw->ID, 'Nomor' => $rw->Nomor, 'Tahun' => $rw->Tahun, 'Tanggal' => tglfromSql($rw->Tanggal), 'ID_Unit' => rdb('unit_jurnal', 'Unit', 'Unit', "where ID='" . $rw->ID_Unit . "'"));
}
return $data;
}
function print_faktur()
{
$data = array();
$no_trans = $this->input->post('no_transaksi');
$data['nm_nasabah'] = rdb('mst_anggota', 'Nama', 'Nama', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'");
$data['alamat'] = rdb('mst_anggota', 'Alamat', 'Alamat', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'");
$data['telp'] = rdb('mst_anggota', 'Telepon', 'Telepon', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'");
$data['Company'] = rdb('mst_anggota', 'Catatan', 'Catatan', "where ID='" . rdb("inv_penjualan", 'ID_Anggota', 'ID_Anggota', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'") . "'");
$data['faktur'] = rdb("inv_penjualan", 'Nomor', 'Nomor', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'");
$data['tanggal'] = tglfromSql(rdb("inv_penjualan", 'Tanggal', 'Tanggal', "where NoUrut='{$no_trans}' and Tahun='" . date('Y') . "'"));
//$data['terbilang'] =$this->zetro_terbilang->terbilang(rdb("inv_penjualan",'Total','Total',"where NoUrut='$no_trans' and Tahun='".date('Y')."'"));
$data['temp_rec'] = $this->report_model->laporan_faktur($no_trans);
$this->zetro_auth->menu_id(array('trans_beli'));
$this->list_data($data);
$this->View("laporan/lap_" . $this->input->post('lap') . "_print");
}
// 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');
$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);
function BuildListData($pk = '', $nuberInFirstColumn = true)
{
$n = 0;
$flds = array();
//echo $this->sql;
$rs = mysql_query($this->sql) or die(mysql_error());
if (mysql_num_rows($rs)) {
$fldx = "";
while ($rw = mysql_fetch_array($rs)) {
$n++;
if ($this->statu == true) {
foreach ($this->fields as $fld) {
empty($flds[$fld]) ? $flds[$fld] = $rw[$fld] : ($flds[$fld] = $flds[$fld] + $rw[$fld]);
}
}
$pk == '' ? $id = $rw['id'] : ($id = $rw[$pk]);
echo "<tr class='xx' id='nm-" . str_replace(' ', '_', $id) . "'>\n";
echo $nuberInFirstColumn == true ? "<td class='kotak' align='center'>{$n}</td>\n" : "";
for ($i = 0; $i < count($this->data); $i++) {
$jenis = explode('.', $this->data[$i]);
$this->nom(str_replace(' ', '_', $id));
if ($jenis[1] == 't') {
echo "<td class='kotak' align='center'>" . tglfromSql($rw[$jenis[0]]) . "</td>\n";
} else {
if ($jenis[1] == 'd') {
echo "<td class='kotak' align='right'>" . number_format($rw[$jenis[0]], 2, '.', ',') . "</td>\n";
} else {
if ($jenis[1] == 'dn') {
echo $this->edit == 'y' ? "<td class='kotak' align='left' nowrap>" . $this->field_inline($i + 1, number_format($rw[$jenis[0]], 2)) . "</td>\n" : "<td class='kotak' align='right'>" . number_format($rw[$jenis[0]], 2, '.', ',') . "</td>\n";
} else {
echo !empty($this->kolom) && $this->kolom == $jenis[0] ? "<td class='kotak' align='left'>" . rdb($this->tabel, $this->field, '', "where " . $this->kolom . "='" . $rw[$jenis[0]] . "'") . "</td>\n" : "<td class='kotak' align='left'>" . $rw[$jenis[0]] . "</td>\n";
}
}
}
}
//add icon action eq; edit icon, delete icon, process icon
echo $this->aksi == true ? "<td class='kotak' align='center' >" . $this->event($this->section . '-' . str_replace(' ', '_', $id), '', $this->jenis) . "</td></tr>\n" : "</tr>\n";
}
} else {
//if data not found in database
echo "<tr class='xx'><td class='kotak' align='center'><img src='" . base_url() . "asset/images/16/warning_16.png'></td>\r\n\t\t\t\t<td class='kotak' colspan='" . (count($this->data) + 1) . "'>\r\n\t\t\t\tData not found in database...(0)</td></tr>";
}
//add sub total
if ($this->statu == true) {
$clm = explode(",", $this->kol);
echo "<tr class='xx j_info' align='right'>\r\n\t\t\t\t <td colspan='" . ($clm[0] - 1) . "' class='kotak'><b>TOTAL</b></td>";
// for ($z=0;$z<count($clm);$z++){
foreach ($flds as $z) {
echo !empty($flds) ? "<td class='kotak'>" . number_format($z, 2) . "</td>" : "<td class='kotak'>" . $z . "</td>";
}
$jmlkolom = $clm[0] + count($clm) - 1;
$totalkolom = count($this->data) + 1;
if ($totalkolom - $jmlkolom > 0) {
for ($n = 1; $n <= $totalkolom - $jmlkolom; $n++) {
echo "<td class='kotak'> </td>";
}
}
echo "</tr>";
}
}
function get_buku_besar()
{
$datax = array();
$saldo_awal = 0;
$data = array();
$n = 0;
$saldo = 0;
$t_kredit = 0;
$t_debet = 0;
$ip_temp = '';
$id_Calc = '';
$saldo_akhir = 0;
$akun = $_POST['Akun'];
$ID_Simp = $_POST['ID_SubKlas'];
$perkiraan = $_POST['ID_P'];
$mulai = tgltoSql($_POST['Start']);
$sampai = empty($_POST['Stop']) ? tgltoSql($_POST['Start']) : tgltoSql($_POST['Stop']);
//konversi ke id perkiraan
$toAkun = $ID_Simp != '4' && $ID_Simp != '17' && $ID_Simp != '18' && $ID_Simp != '19' && $ID_Simp != '28' ? $perkiraan : $this->akun_model->get_nomor_akun("where ID_Agt='{$perkiraan}' and id_subklas='{$ID_Simp}'");
//dapatkan data saldoawal
if (is_array($toAkun)) {
foreach ($toAkun as $t) {
$ip_temp = $t->ID;
$id_Calc = $t->ID_Calc;
}
} else {
$ip_temp = $toAkun;
$id_Calc = $this->Admin_model->show_single_field('perkiraan', 'id_calc', "where ID='{$ip_temp}'");
}
$datax = $this->akun_model->get_saldo_awal($ip_temp);
foreach ($datax as $sa) {
$saldo_awal = $sa->saldoawal;
}
echo "<tr class='xx list_genap'>\r\n\t\t\t <td class='kotak' align='center'>•••</td>\r\n\t\t\t <td class='kotak' colspan='3'>Saldo Awal</td>\r\n\t\t\t <td class='kotak'> </td>\r\n\t\t\t <td class='kotak'> </td>\r\n\t\t\t <td class='kotak' align='right'><b>" . number_format($saldo_awal, 2) . "</b></td>\r\n\t\t\t </tr>";
$saldo = $saldo_awal;
$data = $this->akun_model->buku_besar_byDate($ip_temp, $mulai, $sampai);
foreach ($data as $r) {
$n++;
$saldo = $id_Calc == 2 ? $saldo + $r->Kredit - $r->Debet : $saldo + $r->Debet - $r->Kredit;
echo "<tr class='xx'>\r\n\t\t\t\t\t <td class='kotak' align='center'>{$n}</td>\r\n\t\t\t\t\t <td class='kotak' align='center'>" . tglfromSql($r->Tanggal) . "</td>\r\n\t\t\t\t\t <td class='kotak'>" . $r->Nomor . "</td>\r\n\t\t\t\t\t <td class='kotak'>" . $r->Keterangan . "</td>\r\n\t\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Debet, 2) . "</td>\t\r\n\t\t\t\t\t <td class='kotak' align='right'>" . number_format($r->Kredit, 2) . "</td>\t\r\n\t\t\t\t\t <td class='kotak' align='right'>" . number_format($saldo, 2) . "</td>\r\n\t\t\t\t\t </tr>";
$t_kredit = $t_kredit + $r->Kredit;
$t_debet = $t_debet + $r->Debet;
}
$saldo_akhir = $id_Calc == 2 ? $saldo_awal + $t_kredit - $t_debet : $saldo_awal + $t_debet - $t_kredit;
if ($n >= 1) {
echo "<tr class='list_genap'>\r\n\t\t\t\t\t <td class='kotak'>•••</td>\r\n\t\t\t\t\t <td class='kotak' colspan='3'><b>Saldo Akhir</b>\r\n\t\t\t\t\t <td class='kotak' align='right'><b>" . number_format($t_debet, 2) . "</b></td>\r\n\t\t\t\t\t <td class='kotak' align='right'><b>" . number_format($t_kredit, 2) . "</b></td>\r\n\t\t\t\t\t <td class='kotak' align='right'><b>" . number_format($saldo_akhir, 2) . "</b></td>\r\n\t\t\t\t\t </tr>";
}
if ($n == 0) {
echo "<tr class='xx'>\r\n\t\t\t\t\t<td colspan='7' class='kotak'><b>• Belum ada data....</td>\r\n\t\t\t\t\t</tr>";
}
}
function show_detail_kreditur_jurnal()
{
$data = array();
$nx = 0;
$debet = 0;
$kredit = 0;
$ID_Agt = $_POST['ID_Agt'];
$data = $this->kasir_model->get_trans_jurnal($ID_Agt);
foreach ($data as $rx) {
$nx++;
echo tr() . td($nx, 'center') . td(tglfromSql($rx->Tanggal), 'center') . td($rx->Nomor) . td($rx->Keterangan) . td(number_format($rx->Debet, 2), 'right') . td(number_format($rx->Kredit, 2), 'right') . _tr();
$debet = $debet + $rx->Debet;
$kredit = $kredit + $rx->Kredit;
}
echo tr() . td('<b>Total</b>', 'right\' colspan=\'4', 'kotak list_genap') . td('<b>' . number_format($debet, 2) . '</b>', 'right', 'kotak list_genap') . td('<b>' . number_format($kredit, 2) . '</b>', 'right', 'kotak list_genap') . _tr() . tr() . td('<b>Balance</b>', 'right\' colspan=\'5', 'kotak list_ganjil') . td('<b>' . number_format((int) $debet - (int) $kredit, 2) . '</b>', 'right', 'kotak list_genap') . _tr();
}
function get_pemakaian()
{
$data = array();
$n = 0;
$dari = tglToSql($_POST['dari_tgl']);
$sampai = empty($_POST['sampai_tgl']) ? $dari : tglToSql($_POST['sampai_tgl']);
$where = empty($_POST['sampai_tgl']) ? "where Tanggal='" . $dari . "'" : "where Tanggal between '" . $dari . "' and '" . $sampai . "'";
$where .= " and ID_Jenis='" . $_POST['id_jenis'] . "'";
$where .= " order by Tanggal";
$data = $this->Admin_model->show_list('z_inv_pemakaian', $where);
foreach ($data as $r) {
$n++;
echo tr() . td($n, 'center') . td(tglfromSql($r->Tanggal), 'center') . td(rdb('inv_barang', 'Kode', 'Kode', "where ID='" . $r->ID_Barang . "'")) . td(rdb('inv_barang', 'Nama_Barang', 'Nama_Barang', "where ID='" . $r->ID_Barang . "'")) . td(rdb('inv_barang_satuan', 'Satuan', 'Satuan', "where ID='" . rdb('inv_barang', 'ID_Satuan', 'ID_Satuan', "where ID='" . $r->ID_Barang . "'") . "'")) . td(number_format($r->Jumlah, 2), 'right') . td(number_format($r->Harga, 2), 'right') . td(number_format($r->Jumlah * $r->Harga, 2), 'right') . td($r->Keterangan) . td(img_aksi($r->ID, true), 'center') . _tr();
}
}
function get_member_kredit()
{
$data = array();
$n = 0;
$where = $_POST['status'] == '' ? '' : "where p.stat_pinjaman='" . $_POST['status'] . "'";
$where = empty($_POST['cari']) ? $where : "where a.Nama like '" . $_POST['cari'] . "%'";
$orderby = " order by " . $_POST['orderby'];
$orderby .= empty($_POST['urutan']) ? '' : ' ' . $_POST['urutan'];
//echo $where;
$data = $this->member_model->get_data_pinjaman($where, $orderby);
foreach ($data as $r) {
$n++;
echo tr() . td($n, 'center') . td($r->Nama . ' [ <i> ' . $r->Catatan . ' </i> ] - ' . $r->NIP) . td(number_format($r->Debet, 2), 'right') . td(number_format($r->Kredit, 2), 'right') . td(number_format($r->Saldo, 2), 'right') . td(tglfromSql($r->mulai_bayar), 'center') . td($r->Kredit == '0' ? img_aksi($r->ID . '-' . $r->Tahun, true, 'del') : '') . _tr();
}
}
$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->Output('application/logs/' . $this->session->userdata('userid') . '_kas_keluar.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');
