function set_bayar_pinjaman()
{
$data = array();
$id_jenis = rdb('inv_penjualan', 'ID_Jenis', 'ID_Jenis', "where NoUrut='" . $_POST['ID_Pinj'] . "' and Tahun='" . $_POST['ThnAsal'] . "'");
$debet = rdb("pinjaman_bayar", "Saldo", "(sum(Debet)-sum(Kredit)) as Saldo", "where ID_Pinjaman='" . $_POST['ID_Pinj'] . "' and Tahun='" . $_POST['ThnAsal'] . "' group by ID_Pinjaman");
//echo $debet."<br>";
$data['ID_Pinjaman'] = $_POST['ID_Pinj'];
$data['ID_Agt'] = $_POST['ID_Agt'];
$data['Tanggal'] = tglToSql($_POST['Tanggal']);
$data['Tahun'] = $_POST['Tahun'];
$data['Kredit'] = $_POST['Kredit'];
$data['Keterangan'] = $_POST['Keterangan'];
$data['saldo'] = (int) $debet - (int) $_POST['Kredit'];
$data['created_by'] = $this->session->userdata('userid');
$this->Admin_model->replace_data('pinjaman_bayar', $data);
//update lama cicilan jika masih ada sisa hutang
$cekSaldo = rdb("pinjaman_bayar", "Saldo", "(sum(Debet)-sum(Kredit)) as Saldo", "where ID_Pinjaman='" . $_POST['ID_Pinj'] . "' and Tahun='" . $_POST['ThnAsal'] . "'");
$lama = rdb("pinjaman", "lama_cicilan", "lama_cicilan", "where ID='" . $_POST['ID_Pinj'] . "' and Tahun='" . $_POST['ThnAsal'] . "'");
$cekSaldo == 0 ? $this->Admin_model->upd_data('pinjaman', "set stat_pinjaman='1'", "where ID='" . $_POST['ID_Pinj'] . "' and Tahun='" . $_POST['ThnAsal'] . "'") : $this->Admin_model->upd_data('pinjaman', "set lama_cicilan='" . ($lama + 1) . "'", "where ID='" . $_POST['ID_Pinj'] . "' and Tahun='" . $_POST['ThnAsal'] . "'");
//simpan kredit to table transaksi_temp / jurnal temporary
$datax['ID_Unit'] = rdb('jenis_simpanan', 'ID_Unit', 'ID_Unit', "where ID='" . $id_jenis . "'");
$datax['ID_Dept'] = '1';
//rdb('jenis_simpanan','ID_Dept','ID_Dept',"where ID='".$id_jenis."'");
$datax['ID_Klas'] = rdb('jenis_simpanan', 'ID_Klasifikasi', 'ID_Klasifikasi', "where ID='" . $id_jenis . "'");
$datax['ID_SubKlas'] = rdb('jenis_simpanan', 'ID_SubKlas', 'ID_SubKlas', "where ID='" . $id_jenis . "'");
$datax['ID_Perkiraan'] = rdb('perkiraan', 'ID', 'ID', "where ID_Agt='" . $_POST['ID_Agt'] . "' and ID_Simpanan='" . $id_jenis . "'");
$datax['Kredit'] = $_POST['Kredit'];
$datax['keterangan'] = $_POST['Keterangan'] . " a/n " . rdb('mst_anggota', 'Nama', 'Nama', "where ID='" . $_POST['ID_Agt'] . "'");
$datax['ID_Bulan'] = substr($_POST['Tanggal'], 3, 2);
$datax['Tahun'] = $_POST['Tahun'];
$datax['Tanggal'] = tglToSql($_POST['Tanggal']);
$datax['ID_CC'] = '7';
$datax['created_by'] = $this->session->userdata('userid');
$this->Admin_model->replace_data('transaksi_temp', $datax);
}
function lap_tagihan_kreditur()
{
$data = array();
$where = '';
$where = empty($_POST['sampai_tgl']) ? "where p.Tanggal='" . tglToSql($_POST['dari_tgl']) . "'" : "where p.Tanggal between '" . tglToSql($_POST['dari_tgl']) . "' and '" . tglToSql($_POST['sampai_tgl']) . "'";
$where .= $this->input->post('departemen') == '' ? '' : " and a.ID_Dept='" . $this->input->post('departemen') . "'";
$where .= $this->input->post('cicilan') == '' ? '' : " and b.Cicilan='" . $this->input->post('cicilan') . "'";
$where .= " and p.ID_Jenis='" . $this->input->post('jenis_beli') . "'";
$group = "group by concat(p.ID_Anggota)";
$ordby = "order by trim(a.Nama)";
$data['dari'] = $this->input->post('dari_tgl');
$data['sampai'] = $this->input->post('sampai_tgl') == '' ? $this->input->post('dari_tgl') : $this->input->post('sampai_tgl');
$data['Kategori'] = $this->input->post('departemen') == '' ? 'All' : rdb('mst_departemen', 'Departemen', 'Departemen', "where ID='" . $this->input->post('departemen') . "'");
$data['Jenis'] = $this->input->post('cicilan') == '' ? 'All' : $this->input->post('cicilan');
$data['judul'] = rdb('inv_penjualan_jenis', 'Jenis_Jual', 'Jenis_Jual', "where ID='" . $this->input->post('jenis_beli') . "'");
$data['temp_rec'] = $this->kasir_model->rekap_kreditur($where, $group, $ordby);
$this->zetro_auth->menu_id(array('trans_beli'));
$this->list_data($data);
$this->View("laporan/transaksi/lap_kreditur_tagihan_print");
}
function simpan_kas_keluar()
{
$data = array();
$datax = array();
$sal_kas = 0;
$tot_trans = 0;
$sal_kas = rdb('mst_kas_harian', 'saldo_kas', 'sum(sa_kas) as saldo_kas', "where tgl_kas='" . tglToSql($_POST['tgl_transaksi']) . "'");
$tot_trans = rdb('mst_kas_trans', 'jumlah', 'sum(jumlah) as jumlah', "where tgl_trans='" . tglToSql($_POST['tgl_transaksi']) . "'");
$data['id_kas'] = strtoupper($_POST['akun_transaksi']);
$data['id_trans'] = $_POST['no_transaksi'];
$data['jumlah'] = $_POST['harga_beli'];
$data['saldo_kas'] = $sal_kas - $tot_trans - $_POST['harga_beli'];
$data['uraian_trans'] = ucwords($_POST['ket_transaksi']);
$data['tgl_trans'] = tglToSql($_POST['tgl_transaksi']);
$data['created_by'] = $this->session->userdata('userid');
//update nomor transaski
$datax['nomor'] = $_POST['no_transaksi'];
$datax['jenis_transaksi'] = 'D';
//print_r($datax);
$this->Admin_model->replace_data('nomor_transaksi', $datax);
$this->Admin_model->replace_data('mst_kas_trans', $data);
//proses to jurnal
$this->no_transaksi($_POST['no_transaksi']);
$this->tanggal($_POST['tgl_transaksi']);
$this->JenisBayar('7');
$this->process_to_jurnal('0', $_POST['harga_beli'], ucwords($_POST['ket_transaksi']));
$this->list_kas_trans();
}
public function update_data_field($section, $table)
{
$data = array();
$jml = $this->zetro_manager->Count($section, $this->filename);
for ($i = 1; $i < $jml; $i++) {
$fld = explode(",", $this->zetro_manager->rContent($section, $i, $this->filename));
$fld2 = explode(" ", $fld[2]);
$fld2[0] == 'date' ? $result = tglToSql($this->input->post($fld[3])) : ($result = $this->input->post($fld[3]));
$data[$fld[3]] = $result;
}
$data["created_by"] = $this->session->userdata("userid");
$this->Admin_model->replace_data($table, $data);
}
function get_cash_flow($ID_CC, $dari, $sampai = '')
{
$sd = $sampai == '' ? $dari : $sampai;
$sql = "select k.ID_Calc,t.ID_CC,if(k.ID_Calc=1,sum(Kredit-Debet),sum(Debet-Kredit)) as Total \r\n\t\t\tfrom transaksi_temp as t\r\n\t\t\tleft join kas_sub as k\r\n\t\t\ton k.ID_CC=t.ID_CC\r\n\t\t\twhere t.Tanggal between '" . tglToSql($dari) . "' and '" . tglToSql($sd) . "'\r\n\t\t\tand t.ID_CC='{$ID_CC}'\r\n\t\t\tgroup by t.ID_CC";
//echo $sql;
$data = $this->db->query($sql);
return $data->result();
}
function print_rusak()
{
$data = array();
$dari = $this->input->post('dari_tgl');
$sampai = $this->input->post('sampai_tgl') == '' ? $dari : $this->input->post('sampai_tgl');
$where = $this->input->post('sampai_tgl') == '' ? "where Tanggal='" . tglToSql($dari) . "'" : "where Tanggal between '" . tglToSql($dari) . "' and '" . tglToSql($sampai) . "'";
$where .= " and ID_Jenis in('2','3')";
$where .= " order by Tanggal";
$data['dari'] = $dari;
$data['sampai'] = $sampai;
$data['temp_rec'] = $this->Admin_model->show_list('z_inv_pemakaian', $where);
$this->zetro_auth->menu_id(array('trans_beli'));
$this->list_data($data);
$this->View("laporan/transaksi/lap_mutasi_print");
}
function last_no_transaksi()
{
$data = array();
$where = empty($_POST['sampai_tgl']) ? "where Tanggal='" . tglToSql($_POST['dari_tgl']) . "'" : "where Tanggal between '" . tglToSql($_POST['dari_tgl']) . "' and '" . tglToSql($_POST['sampai_tgl']) . "'";
$where .= empty($_POST['id_anggota']) ? '' : " and a.Nama like '%" . $_POST['id_anggota'] . "%'";
$data = $this->report_model->get_no_trans($where);
foreach ($data as $r) {
echo "<option value='" . $r->NoUrut . "'>" . $r->NoUrut . "-" . $r->Nama . " [" . $r->Catatan . "]</option>";
}
}
public function update_data_field($section, $table, $field)
{
$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 = tglToSql($this->input->post($fld[3])) : ($result = $this->input->post($fld[3]));
$data[$fld[3]] = $result;
}
$data["created_by"] = $this->session->userdata("userid");
$this->Admin_model->simpan_update($table, $data, $field);
}
function print_shu()
{
$data['unit'] = $this->input->post('unite');
$data['periode'] = $this->input->post('tgl_start');
$data['akhir'] = $this->input->post('tgl_stop');
$data['users'] = $this->session->userdata('userid');
$periode = tglToSql($this->input->post('tgl_stop'));
$this->neraca_model->build_data($periode);
$this->zetro_auth->menu_id(array('trans_beli'));
$this->list_data($data);
$this->input->post('unite') == 3 ? $this->View("laporan/shu_print_gabungan") : $this->View("laporan/shu_print");
}
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);
}
function get_operasional()
{
$data = array();
$where = "where tgl_kas='" . tglToSql($this->input->post('dari_tgl')) . "'";
$where = $this->input->post('sampai_tgl') == '' ? $where : "where tgl_kas between '" . tglToSql($this->input->post('dari_tgl')) . "' and '" . tglToSql($this->input->post('sampai_tgl')) . "'";
$orderby = "order by tgl_trans";
//$data['where'] =str_replace('tgl_kas','tgl_trans',$where)." and jumlah!='0'";
$data['orderby'] = $orderby;
$data['dari'] = $this->input->post('dari_tgl');
$data['sampai'] = $this->input->post('sampai_tgl');
$data['temp_rec'] = $this->kasir_model->get_kas_awal($where);
$this->zetro_auth->menu_id(array('trans_beli'));
$this->list_data($data);
$this->View("laporan/transaksi/lap_operasional_print");
}
