function get_total_belanja($notrans, $tanggal)
{
$data = array();
$sql = "select sum(Jml_faktur*Harga_Beli) as total from inv_pembelian as p\r\n\t\t\t left join inv_pembelian_detail as pd\r\n\t\t\t on pd.ID_Beli=p.ID\r\n\t\t\t where p.NoUrut='{$notrans}' and p.Tanggal='" . tgltoSql($tanggal) . "'";
$data = $this->db->query($sql);
return $data->result();
}
function list_kas_trans()
{
$data = array();
$data = array();
$n = 0;
$tanggal = tgltoSql($_POST['tanggal']);
$data = $this->Admin_model->show_list('mst_kas_trans', "where tgl_trans='" . $tanggal . "' order by id_trans");
foreach ($data as $r) {
$n++;
echo tr() . td($n, 'center') . td($r->id_trans, 'center') . td(tglfromSql($r->tgl_trans), 'center') . td($r->id_kas) . td($r->uraian_trans) . td(number_format($r->jumlah, 2), 'right') . td(number_format($r->saldo_kas, 2), 'right') . _tr();
}
}
function process_to_jurnal($id_anggota, $total)
{
/* membuat data untuk diposting dalam jurnal
simpan penjualan barang secara kredit
inputnya adalah ID anggota yng melakukan pembelian secara kredit
dapatkan ID_Perkiraan dari table perkiraan based on ID_Anggota
extract data perkiraan menjadi klass, sub klass dan jenis simpanan dalam hal ini
jenis simpanan adalah barang [id:4]
data yang dihasilkan akan ditampung di table transaksi_temp
*/
$data = array();
$akun = '';
//get ID_perkiraan
$akun = rdb('perkiraan', 'ID', 'ID', "where ID_Agt='{$id_anggota}' and ID_Simpanan='4'");
if ($akun == '') {
//update database perkiraan
_update_perkiraan($id_anggota, '4');
}
$data['ID_Perkiraan'] = rdb('perkiraan', 'ID', 'ID', "where ID_Agt='{$id_anggota}' and ID_Simpanan='4'");
$data['ID_Unit'] = rdb('jenis_simpanan', 'ID_Unit', 'ID_Unit', "where ID='4'");
$data['ID_Klas'] = rdb('jenis_simpanan', 'ID_Klasifikasi', 'ID_Klasifikasi', "where ID='4'");
$data['ID_SubKlas'] = rdb('jenis_simpanan', 'ID_SubKlas', 'ID_SubKlas', "where ID='4'");
$data['ID_Dept'] = rdb('mst_anggota', 'ID_Dept', 'ID_Dept', "where ID='" . $id_anggota . "'");
$data['Debet'] = $total;
//rdb('inv_penjualan','Total','Total',"where ID_Anggota='".$id_anggota."' and NoUrut='".$this->no_trans."'");
$data['Keterangan'] = 'Kredit barang toko no. Faktur: ' . rdb('inv_penjualan', 'Nomor', 'Nomor', "where NoUrut='" . $this->no_trans . "'");
$data['tanggal'] = tgltoSql($this->tgl);
$data['ID_Bulan'] = substr($this->tgl, 3, 2);
$data['Tahun'] = substr($this->tgl, 6, 4);
$data['created_by'] = $this->session->userdata('userid');
//print_r($data);
$this->Admin_model->replace_data('transaksi_temp', $data);
}
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>";
}
}
$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->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) {
