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"); }