2046 lines
62 KiB
PHP
2046 lines
62 KiB
PHP
<?php
|
|
|
|
use Restserver\Libraries\REST_Controller;
|
|
|
|
defined('BASEPATH') or exit('No direct script access allowed');
|
|
require APPPATH . 'libraries/REST_Controller.php';
|
|
require APPPATH . 'libraries/Format.php';
|
|
|
|
class ManageKeuangan extends CI_Controller
|
|
{
|
|
function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->load->model('ModelKeuangan', 'Keuangan');
|
|
$this->load->model('ModelBank', 'Bank');
|
|
$this->load->model('ModelKas', 'Kas');
|
|
$this->load->model('ModelKaryawan', 'Karyawan');
|
|
$this->load->model('ModelKendaraan', 'Kendaraan');
|
|
$this->load->model('ModelNeraca', 'Neraca');
|
|
$this->load->model('ModelPelanggan', 'Pelanggan');
|
|
$this->load->model('ModelPerkiraan', 'Perkiraan');
|
|
$this->load->model('ModelPihakke3', 'Pihakke3');
|
|
$this->load->model('ModelSupplier', 'Supplier');
|
|
$this->load->library(['datatables', 'form_validation']);
|
|
$this->form_validation->set_error_delimiters('', '');
|
|
}
|
|
public function output_json($data, $encode = true)
|
|
{
|
|
if ($encode) $data = json_encode($data);
|
|
$this->output->set_content_type('application/json')->set_output($data);
|
|
}
|
|
|
|
//Fungsi Kasbank
|
|
public function dataKasbank_Keuangan_A1_Awal() {
|
|
$set = 1;
|
|
$datKeuangan = $this->Keuangan->getData_Kasbank_Kas_Null();
|
|
$datKas = $this->Kas->getData_Kas();
|
|
$tgl = date('m/d/Y');
|
|
$datKasPcm = $this->Kas->getData_SaldoKas_byKAS_byTGL(1,$tgl);
|
|
$data = [
|
|
'sidebar' => "menu keuangan",
|
|
'navChild' => "",
|
|
'keuangan' => $datKeuangan,
|
|
'kas' => $datKas,
|
|
'debet_sk_pcm' => $datKasPcm[0]['DEBET'],
|
|
'kredit_sk_pcm' => $datKasPcm[0]['KREDIT'],
|
|
'total_sk_pcm' => $datKasPcm[0]['TOTAL'],
|
|
'tgl' => $tgl,
|
|
'set' => $set
|
|
];
|
|
$this->load->view('proses/KeuanganKasbank_Keuangan_A1', $data);
|
|
}
|
|
|
|
public function dataKasbank_Keuangan_A1_Buka() {
|
|
$set = 0;
|
|
$tgl = date('m/d/Y');
|
|
$tgl_now = date('m/01/Y');
|
|
$datKeuangan = $this->Keuangan->getData_Kasbank_Kas_0($tgl_now);
|
|
$datKasPcm = $this->Kas->getData_SaldoKas_byKAS_byTGL(1,$tgl);
|
|
$datKas = $this->Kas->getData_Kas();
|
|
$data = [
|
|
'sidebar' => "menu keuangan",
|
|
'navChild' => "",
|
|
'keuangan' => $datKeuangan,
|
|
'kas' => $datKas,
|
|
'debet_sk_pcm' => $datKasPcm[0]['DEBET'],
|
|
'kredit_sk_pcm' => $datKasPcm[0]['KREDIT'],
|
|
'total_sk_pcm' => $datKasPcm[0]['TOTAL'],
|
|
'tgl' => $tgl,
|
|
'set' => $set
|
|
];
|
|
$this->load->view('proses/KeuanganKasbank_Keuangan_A1', $data);
|
|
}
|
|
|
|
public function dataKasbank_Keuangan_B1_Awal() {
|
|
$datBank = $this->Bank->getData_Bank();
|
|
$kondisi = $this->input->post('kondisi');
|
|
$id_bank = $this->input->post('id_bank');
|
|
|
|
if ($kondisi==NULL OR $id_bank=="") {
|
|
$id_bank = NULL;
|
|
$kode_bank = "Belum terpilih*";
|
|
} else {
|
|
$datDataBank = $this->Bank->getData_Bank($id_bank);
|
|
$kode_bank = $datDataBank[0]['KODE_BANK'];
|
|
}
|
|
|
|
$datKeuangan = $this->Keuangan->getData_Kasbank_Bank_Null($id_bank);
|
|
$data = [
|
|
'sidebar' => "menu keuangan",
|
|
'navChild' => "",
|
|
'keuangan' => $datKeuangan,
|
|
'bank' => $datBank,
|
|
'kode_bank' => $kode_bank,
|
|
'id_bank' => $id_bank
|
|
];
|
|
$this->load->view('proses/KeuanganKasbank_Keuangan_B1', $data);
|
|
}
|
|
|
|
public function kodeKasMasuk() {
|
|
$kk = $this->Keuangan->getKodeKasMasuk();
|
|
$tgl = date('y/m');
|
|
if (is_array($kk) || is_object($kk)) {
|
|
foreach ($kk as $row) {
|
|
if ($row['KODE'] == null) {
|
|
return "BKM/".$tgl."/00001";
|
|
} else {
|
|
$str = (string) $row['KODE'];
|
|
$tgl_lama = substr($str, 4, -6);
|
|
if ($tgl_lama!=$tgl) {
|
|
return "BKM/".$tgl."/00001";
|
|
} else {
|
|
$panjang = 5;
|
|
$data = substr($str, 10, $panjang);
|
|
$ko = (int) $data + 1;
|
|
$str = (string) $ko;
|
|
$panjang = 15 - strlen($str);
|
|
$data = "BKM/".$tgl."/00000";
|
|
$data = substr($data, 0, $panjang) . $str;
|
|
return $data;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
public function kodeKasKeluar() {
|
|
$kk = $this->Keuangan->getKodeKasKeluar();
|
|
$tgl = date('y/m');
|
|
if (is_array($kk) || is_object($kk)) {
|
|
foreach ($kk as $row) {
|
|
if ($row['KODE'] == null) {
|
|
return "BKK/".$tgl."/00001";
|
|
} else {
|
|
$str = (string) $row['KODE'];
|
|
$tgl_lama = substr($str, 4, -6);
|
|
if ($tgl_lama!=$tgl) {
|
|
return "BKK/".$tgl."/00001";
|
|
} else {
|
|
$panjang = 5;
|
|
$data = substr($str, 10, $panjang);
|
|
$ko = (int) $data + 1;
|
|
$str = (string) $ko;
|
|
$panjang = 15 - strlen($str);
|
|
$data = "BKK/".$tgl."/00000";
|
|
$data = substr($data, 0, $panjang) . $str;
|
|
return $data;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
public function kodeBankMasuk() {
|
|
$kk = $this->Keuangan->getKodeBankMasuk();
|
|
$tgl = date('y/m');
|
|
if (is_array($kk) || is_object($kk)) {
|
|
foreach ($kk as $row) {
|
|
if ($row['KODE'] == null) {
|
|
return "BBM/".$tgl."/00001";
|
|
} else {
|
|
$str = (string) $row['KODE'];
|
|
$tgl_lama = substr($str, 4, -6);
|
|
if ($tgl_lama!=$tgl) {
|
|
return "BBM/".$tgl."/00001";
|
|
} else {
|
|
$panjang = 5;
|
|
$data = substr($str, 10, $panjang);
|
|
$ko = (int) $data + 1;
|
|
$str = (string) $ko;
|
|
$panjang = 15 - strlen($str);
|
|
$data = "BBM/".$tgl."/00000";
|
|
$data = substr($data, 0, $panjang) . $str;
|
|
return $data;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
public function kodeBankKeluar() {
|
|
$kk = $this->Keuangan->getKodeBankKeluar();
|
|
$tgl = date('y/m');
|
|
if (is_array($kk) || is_object($kk)) {
|
|
foreach ($kk as $row) {
|
|
if ($row['KODE'] == null) {
|
|
return "BBK/".$tgl."/00001";
|
|
} else {
|
|
$str = (string) $row['KODE'];
|
|
$tgl_lama = substr($str, 4, -6);
|
|
if ($tgl_lama!=$tgl) {
|
|
return "BBK/".$tgl."/00001";
|
|
} else {
|
|
$panjang = 5;
|
|
$data = substr($str, 10, $panjang);
|
|
$ko = (int) $data + 1;
|
|
$str = (string) $ko;
|
|
$panjang = 15 - strlen($str);
|
|
$data = "BBK/".$tgl."/00000";
|
|
$data = substr($data, 0, $panjang) . $str;
|
|
return $data;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
public function simpankasbank_KAB1() {
|
|
$method = $this->input->post('method');
|
|
$id_kb = $this->input->post('id');
|
|
$id_kas = $this->input->post('id_kas');
|
|
$id_bank = $this->input->post('id_bank');
|
|
$nilai_kb = $this->input->post('nilai_kb');
|
|
$jenis_kb = $this->input->post('jenis_kb');
|
|
$tgl_input = $this->input->post('tgl_input');
|
|
$tgl_kb = date('m/d/Y');
|
|
|
|
$check_nilai = is_numeric($nilai_kb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_kb = 0;
|
|
}
|
|
|
|
if ($nilai_kb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
if ($id_bank==NULL) {
|
|
if ($jenis_kb==1 OR $jenis_kb=="1") {
|
|
$kode_kb = $this->kodeKasMasuk();
|
|
} else if ($jenis_kb==0 OR $jenis_kb=="0") {
|
|
$kode_kb = $this->kodeKasKeluar();
|
|
}
|
|
$input = [
|
|
'KODE_KB' => $kode_kb,
|
|
'KAS_ID' => $id_kas,
|
|
'NILAI_KB' => $nilai_kb,
|
|
'TGL_KB' => $tgl_kb,
|
|
'TGL_INPUT' => $tgl_input,
|
|
'JENIS_KB' => $jenis_kb
|
|
];
|
|
$action = $this->Keuangan->create('kasbank', $input);
|
|
$id_kasbank = $this->Keuangan->getID_KasbankMax();
|
|
$id_kasbank = $id_kasbank[0]['ID_KB'];
|
|
if ($jenis_kb==1 OR $jenis_kb=="1") {
|
|
$input = [
|
|
'KAS_ID' => $id_kas,
|
|
'TGL_SK' => $tgl_kb,
|
|
'TGL_INPUT' => $tgl_input,
|
|
'DEBET_SK' => $nilai_kb,
|
|
'KREDIT_SK' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('saldo_kas', $input);
|
|
$id_sk = $this->Keuangan->getID_SaldoKasMax();
|
|
$id_sk = $id_sk[0]['ID_SK'];
|
|
$input = [
|
|
'KB_ID' => $id_kasbank,
|
|
'SK_ID' => $id_sk,
|
|
'PERKIRAAN_ID' => '1',
|
|
'DEBET_DKB' => $nilai_kb,
|
|
'KREDIT_DKB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_kas', $update, 'ID_SK', $id_sk);
|
|
} else if ($jenis_kb==0 OR $jenis_kb=="0") {
|
|
$input = [
|
|
'KAS_ID' => $id_kas,
|
|
'TGL_SK' => $tgl_kb,
|
|
'TGL_INPUT' => $tgl_input,
|
|
'DEBET_SK' => '0',
|
|
'KREDIT_SK' => $nilai_kb
|
|
];
|
|
$action = $this->Keuangan->create('saldo_kas', $input);
|
|
$id_sk = $this->Keuangan->getID_SaldoKasMax();
|
|
$id_sk = $id_sk[0]['ID_SK'];
|
|
$input = [
|
|
'KB_ID' => $id_kasbank,
|
|
'SK_ID' => $id_sk,
|
|
'PERKIRAAN_ID' => '1',
|
|
'DEBET_DKB' => '0',
|
|
'KREDIT_DKB' => $nilai_kb
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_kas', $update, 'ID_SK', $id_sk);
|
|
}
|
|
} else if ($id_kas==NULL) {
|
|
if ($jenis_kb==1 OR $jenis_kb=="1") {
|
|
$kode_kb = $this->kodeBankMasuk();
|
|
} else if ($jenis_kb==0 OR $jenis_kb=="0") {
|
|
$kode_kb = $this->kodeBankKeluar();
|
|
}
|
|
$input = [
|
|
'BANK_ID' => $id_bank,
|
|
'KODE_KB' => $kode_kb,
|
|
'NILAI_KB' => $nilai_kb,
|
|
'TGL_KB' => $tgl_kb,
|
|
'TGL_INPUT' => $tgl_input,
|
|
'JENIS_KB' => $jenis_kb
|
|
];
|
|
$action = $this->Keuangan->create('kasbank', $input);
|
|
$id_kasbank = $this->Keuangan->getID_KasbankMax();
|
|
$id_kasbank = $id_kasbank[0]['ID_KB'];
|
|
if ($jenis_kb==1 OR $jenis_kb=="1") {
|
|
$input = [
|
|
'BANK_ID' => $id_bank,
|
|
'TGL_SB' => $tgl_kb,
|
|
'TGL_INPUT' => $tgl_input,
|
|
'DEBET_SB' => $nilai_kb,
|
|
'KREDIT_SB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('saldo_bank', $input);
|
|
$id_sb = $this->Keuangan->getID_SaldoBankMax();
|
|
$id_sb = $id_sb[0]['ID_SB'];
|
|
$input = [
|
|
'KB_ID' => $id_kasbank,
|
|
'SB_ID' => $id_sb,
|
|
'PERKIRAAN_ID' => '2',
|
|
'DEBET_DKB' => $nilai_kb,
|
|
'KREDIT_DKB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_bank', $update, 'ID_SB', $id_sb);
|
|
} else if ($jenis_kb==0 OR $jenis_kb=="0") {
|
|
$input = [
|
|
'BANK_ID' => $id_bank,
|
|
'TGL_SB' => $tgl_kb,
|
|
'TGL_INPUT' => $tgl_input,
|
|
'DEBET_SB' => '0',
|
|
'KREDIT_SB' => $nilai_kb
|
|
];
|
|
$action = $this->Keuangan->create('saldo_bank', $input);
|
|
$id_sb = $this->Keuangan->getID_SaldoBankMax();
|
|
$id_sb = $id_sb[0]['ID_SB'];
|
|
$input = [
|
|
'KB_ID' => $id_kasbank,
|
|
'SB_ID' => $id_sb,
|
|
'PERKIRAAN_ID' => '2',
|
|
'DEBET_DKB' => '0',
|
|
'KREDIT_DKB' => $nilai_kb
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_bank', $update, 'ID_SB', $id_sb);
|
|
}
|
|
}
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function hapuskasbank_KAB1() {
|
|
$method = $this->input->post('method');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$tgl_now = date('m/01/Y');
|
|
|
|
$datDkb = $this->Keuangan->getData_DaftarKasbank_byKB_Kasmasuk($id_kb);
|
|
if (strtotime($tgl_now)>strtotime($datDkb[0]['TGL_KB'])) {
|
|
$this->session->set_flashdata('date_locked', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$countDkb = count($datDkb);
|
|
if ($countDkb>=2) {
|
|
$this->session->set_flashdata('data_used', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datDkbNew = $this->Keuangan->getData_DaftarKasbank_byID($datDkb[0]['ID_DKB']);
|
|
$action = $this->Keuangan->delete('saldo_kas', $datDkbNew[0]['SK_ID'], 'ID_SK');
|
|
$action = $this->Keuangan->delete('daftar_kasbank', $id_kb, 'KB_ID');
|
|
$action = $this->Keuangan->delete('kasbank', $id_kb, 'ID_KB');
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'dihapus');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'dihapus');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function dataKasbank_Keuangan_A2_Kasmasuk($id) {
|
|
$set = 1;
|
|
$datKeuangan = $this->Keuangan->getData_DaftarKasbank_byKB_Kasmasuk($id);
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_byID($id);
|
|
$datPda = $this->Keuangan->getData_PiutangDagang_forDKB();
|
|
$datBank = $this->Bank->getData_Bank_forDkb($datKasbank[0]['BANK_ID']);
|
|
$datPelanggan = $this->Pelanggan->getData_Pelanggan();
|
|
$datSupplier = $this->Supplier->getData_Supplier();
|
|
$datKaryawan = $this->Karyawan->getData_Karyawan();
|
|
$datKas = $this->Kas->getData_Kas_forDkb($datKasbank[0]['KAS_ID']);
|
|
$datPerkiraan = $this->Perkiraan->getData_Perkiraan_Lain();
|
|
$datPihakke3 = $this->Pihakke3->getData_PihakKe3();
|
|
if ($datKeuangan==FALSE) {
|
|
$debet_dkb = 0;
|
|
$kredit_dkb = 0;
|
|
} else {
|
|
$sumDaftarKasbank = $this->Keuangan->getSum_DaftarKasbank_byKB($id);
|
|
$debet_dkb = $sumDaftarKasbank[0]['DEBET'];
|
|
$kredit_dkb = $sumDaftarKasbank[0]['KREDIT'];
|
|
}
|
|
|
|
$data = [
|
|
'sidebar' => "menu keuangan",
|
|
'navChild' => "",
|
|
'keuangan' => $datKeuangan,
|
|
'pda' => $datPda,
|
|
'bank' => $datBank,
|
|
'supplier' => $datSupplier,
|
|
'pelanggan' => $datPelanggan,
|
|
'karyawan' => $datKaryawan,
|
|
'kas' => $datKas,
|
|
'perkiraan' => $datPerkiraan,
|
|
'pihakke3' => $datPihakke3,
|
|
'debet_dkb' => $debet_dkb,
|
|
'kredit_dkb' => $kredit_dkb,
|
|
'nilai' => $datKasbank[0]['NILAI'],
|
|
'nama_kas' => $datKasbank[0]['NAMA_KAS'],
|
|
'kode_kb' => $datKasbank[0]['KODE_KB'],
|
|
'id_kb' => $id,
|
|
'set' => $set
|
|
];
|
|
$this->load->view('proses/KeuanganKasbank_Keuangan_A2_Kasmasuk', $data);
|
|
}
|
|
|
|
public function dataKasbank_Keuangan_A2_Kasmasuk_View($id) {
|
|
$set = 0;
|
|
$datKeuangan = $this->Keuangan->getData_DaftarKasbank_byKB_Kasmasuk($id);
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_byID($id);
|
|
$datPda = $this->Keuangan->getData_PiutangDagang_forDKB();
|
|
$datBank = $this->Bank->getData_Bank_forDkb($datKasbank[0]['BANK_ID']);
|
|
$datPelanggan = $this->Pelanggan->getData_Pelanggan();
|
|
$datSupplier = $this->Supplier->getData_Supplier();
|
|
$datKaryawan = $this->Karyawan->getData_Karyawan();
|
|
$datKas = $this->Kas->getData_Kas_forDkb($datKasbank[0]['KAS_ID']);
|
|
$datPerkiraan = $this->Perkiraan->getData_Perkiraan_Lain();
|
|
$datPihakke3 = $this->Pihakke3->getData_PihakKe3();
|
|
if ($datKeuangan==FALSE) {
|
|
$debet_dkb = 0;
|
|
$kredit_dkb = 0;
|
|
} else {
|
|
$sumDaftarKasbank = $this->Keuangan->getSum_DaftarKasbank_byKB($id);
|
|
$debet_dkb = $sumDaftarKasbank[0]['DEBET'];
|
|
$kredit_dkb = $sumDaftarKasbank[0]['KREDIT'];
|
|
}
|
|
|
|
$data = [
|
|
'sidebar' => "menu keuangan",
|
|
'navChild' => "",
|
|
'keuangan' => $datKeuangan,
|
|
'pda' => $datPda,
|
|
'bank' => $datBank,
|
|
'supplier' => $datSupplier,
|
|
'pelanggan' => $datPelanggan,
|
|
'karyawan' => $datKaryawan,
|
|
'kas' => $datKas,
|
|
'perkiraan' => $datPerkiraan,
|
|
'pihakke3' => $datPihakke3,
|
|
'debet_dkb' => $debet_dkb,
|
|
'kredit_dkb' => $kredit_dkb,
|
|
'nilai' => $datKasbank[0]['NILAI'],
|
|
'nama_kas' => $datKasbank[0]['NAMA_KAS'],
|
|
'kode_kb' => $datKasbank[0]['KODE_KB'],
|
|
'id_kb' => $id,
|
|
'set' => $set
|
|
];
|
|
$this->load->view('proses/KeuanganKasbank_Keuangan_A2_Kasmasuk', $data);
|
|
}
|
|
|
|
public function simpankasmasuk_A2_SK() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_kas = $this->input->post('id_kas');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_kredit = $kredit_dkb+$nilai_dkb;
|
|
if ($total_kredit>$debet_dkb) {
|
|
$this->session->set_flashdata('kredit_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KAS_ID' => $id_kas,
|
|
'TGL_SK' => $tgl,
|
|
'TGL_INPUT' => $tgl,
|
|
'KREDIT_SK' => $nilai_dkb,
|
|
'DEBET_SK' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('saldo_kas', $input);
|
|
$id_sk = $this->Keuangan->getID_SaldoKasMax();
|
|
$id_sk = $id_sk[0]['ID_SK'];
|
|
|
|
$datKas = $this->Keuangan->getData_Kas_byID($id_kas);
|
|
$kode_kas = $datKas[0]['KODE_KAS'];
|
|
$ket_dkb = "Ayat Silang u/ $kode_kas";
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'KREDIT_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'DEBET_DKB' => '0',
|
|
'SK_ID' => $id_sk
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_kas', $update, 'ID_SK', $id_sk);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankasmasuk_A2_SB() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_bank = $this->input->post('id_bank');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_kredit = $kredit_dkb+$nilai_dkb;
|
|
if ($total_kredit>$debet_dkb) {
|
|
$this->session->set_flashdata('kredit_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'BANK_ID' => $id_bank,
|
|
'TGL_SB' => $tgl,
|
|
'TGL_INPUT' => $tgl,
|
|
'KREDIT_SB' => $nilai_dkb,
|
|
'DEBET_SB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('saldo_bank', $input);
|
|
$id_sb = $this->Keuangan->getID_SaldoBankMax();
|
|
$id_sb = $id_sb[0]['ID_SB'];
|
|
|
|
$datBank = $this->Keuangan->getData_Bank_byID($id_bank);
|
|
$kode_bank = $datBank[0]['KODE_BANK'];
|
|
$ket_dkb = "Ayat Silang u/ $kode_bank";
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'KREDIT_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'DEBET_DKB' => '0',
|
|
'SB_ID' => $id_sb
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_bank', $update, 'ID_SB', $id_sb);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankasmasuk_A2_DPJ() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_pelanggan = $this->input->post('id_pelanggan');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_kredit = $kredit_dkb+$nilai_dkb;
|
|
if ($total_kredit>$debet_dkb) {
|
|
$this->session->set_flashdata('kredit_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'PELANGGAN_ID' => $id_pelanggan,
|
|
'TGL_DPJ' => $tgl,
|
|
'KREDIT_DPJ' => $nilai_dkb,
|
|
'DEBET_DPJ' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('dp_penjualan', $input);
|
|
$id_dpj = $this->Keuangan->getID_DPPenjualanMax();
|
|
$id_dpj = $id_dpj[0]['ID_DPJ'];
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'KREDIT_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'DEBET_DKB' => '0',
|
|
'DPJ_ID' => $id_dpj
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('dp_penjualan', $update, 'ID_DPJ', $id_dpj);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankasmasuk_A2_PDA() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$inv_penjualan = $this->input->post('inv_penjualan');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_kredit = $kredit_dkb+$nilai_dkb;
|
|
if ($total_kredit>$debet_dkb) {
|
|
$this->session->set_flashdata('kredit_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datPenjualan = $this->Keuangan->getData_Penjualan_byINV($inv_penjualan);
|
|
if ($datPenjualan==FALSE) {
|
|
$this->session->set_flashdata('latest', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datPda = $this->Keuangan->getData_PiutangDagang_byPENJUALAN($datPenjualan[0]['ID_PENJUALAN']);
|
|
$debet_pda = $datPda[0]['DEBET'];
|
|
$kredit_pda = $datPda[0]['KREDIT'];
|
|
$totalKredit = $kredit_pda+$nilai_dkb;
|
|
if ($totalKredit>$debet_pda) {
|
|
$this->session->set_flashdata('piutang_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$kode_penjualan = $datPenjualan[0]['KODE_PENJUALAN'];
|
|
$ket_pda = "No Nota : $kode_penjualan";
|
|
$input = [
|
|
'PELANGGAN_ID' => $datPenjualan[0]['PELANGGAN_ID'],
|
|
'PENJUALAN_ID' => $datPenjualan[0]['ID_PENJUALAN'],
|
|
'TRANSAKSI_PDA' => '1',
|
|
'TGL_PDA' => $tgl,
|
|
'KODE_BUKTI' => $datKasbank[0]['KODE_KB'],
|
|
'KREDIT_PDA' => $nilai_dkb,
|
|
'DEBET_PDA' => '0',
|
|
'KET_PDA' => $ket_pda
|
|
];
|
|
$action = $this->Keuangan->create('piutang_dagang', $input);
|
|
$id_pda = $this->Keuangan->getID_PiutangDagangMax();
|
|
$id_pda = $id_pda[0]['ID_PDA'];
|
|
|
|
$ket_dkb = "Pembayaran Nota $inv_penjualan";
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'KREDIT_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'DEBET_DKB' => '0',
|
|
'PDA_ID' => $id_pda
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('piutang_dagang', $update, 'ID_PDA', $id_pda);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankasmasuk_A2_PKA() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_karyawan = $this->input->post('id_karyawan');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_kredit = $kredit_dkb+$nilai_dkb;
|
|
if ($total_kredit>$debet_dkb) {
|
|
$this->session->set_flashdata('kredit_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KARYAWAN_ID' => $id_karyawan,
|
|
'TGL_PKA' => $tgl,
|
|
'KREDIT_PKA' => $nilai_dkb,
|
|
'DEBET_PKA' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('piutang_karyawan', $input);
|
|
$id_pka = $this->Keuangan->getID_PiutangKaryawanMax();
|
|
$id_pka = $id_pka[0]['ID_PKA'];
|
|
|
|
if ($ket_dkb=="") {
|
|
$datKaryawan = $this->Keuangan->getData_Karyawan_byID($id_karyawan);
|
|
$nama_karyawan = $datKaryawan[0]['NAMA_KARYAWAN'];
|
|
$ket_dkb = "Atas Nama $nama_karyawan";
|
|
}
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'KREDIT_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'DEBET_DKB' => '0',
|
|
'PKA_ID' => $id_pka
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('piutang_karyawan', $update, 'ID_PKA', $id_pka);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankasmasuk_A2_PPK() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_pihakke3 = $this->input->post('id_pihakke3');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_kredit = $kredit_dkb+$nilai_dkb;
|
|
if ($total_kredit>$debet_dkb) {
|
|
$this->session->set_flashdata('kredit_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'PIHAKKE3_ID' => $id_pihakke3,
|
|
'TGL_PPK' => $tgl,
|
|
'KREDIT_PPK' => $nilai_dkb,
|
|
'DEBET_PPK' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('piutang_pihakke3', $input);
|
|
$id_ppk = $this->Keuangan->getID_PiutangPihakke3Max();
|
|
$id_ppk = $id_ppk[0]['ID_PPK'];
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'KREDIT_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'DEBET_DKB' => '0',
|
|
'PPK_ID' => $id_ppk
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('piutang_pihakke3', $update, 'ID_PPK', $id_ppk);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankasmasuk_A2_LAIN() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_kredit = $kredit_dkb+$nilai_dkb;
|
|
if ($total_kredit>$debet_dkb) {
|
|
$this->session->set_flashdata('kredit_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'KREDIT_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'DEBET_DKB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function hapuskasmasuk_A2() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id_dkb');
|
|
$tgl_now = date('m/01/Y');
|
|
|
|
$datDkb = $this->Keuangan->getData_DaftarKasbank_byID($id_dkb);
|
|
if ($datDkb==FALSE) {
|
|
$this->session->set_flashdata('latest', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($datDkb[0]['KB_ID']);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
if (strtotime($tgl_now)>strtotime($datKasbank[0]['TGL_KB'])) {
|
|
$this->session->set_flashdata('date_locked', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
if ($datDkb[0]['DPJ_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('dp_penjualan', $datDkb[0]['DPJ_ID'], 'ID_DPJ');
|
|
} else if ($datDkb[0]['PDA_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('piutang_dagang', $datDkb[0]['PDA_ID'], 'ID_PDA');
|
|
} else if ($datDkb[0]['PKA_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('piutang_karyawan', $datDkb[0]['PKA_ID'], 'ID_PKA');
|
|
} else if ($datDkb[0]['PPK_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('piutang_pihakke3', $datDkb[0]['PPK_ID'], 'ID_PPK');
|
|
} else if ($datDkb[0]['SB_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('saldo_bank', $datDkb[0]['SB_ID'], 'ID_SB');
|
|
} else if ($datDkb[0]['SK_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('saldo_kas', $datDkb[0]['SK_ID'], 'ID_SK');
|
|
}
|
|
|
|
$action = $this->Keuangan->delete('daftar_kasbank', $id_dkb, 'ID_DKB');
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'dihapus');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'dihapus');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function kuncikasmasuk_A2() {
|
|
$method = $this->input->post('method');
|
|
$id_kb = $this->input->post('id_kb');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$update = [
|
|
'STATUS_KB' => '0'
|
|
];
|
|
$action = $this->Keuangan->update('kasbank', $update, 'ID_KB', $id_kb);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('data_lock_all', 'dikunci');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'dikunci');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function bukakasmasuk_A2() {
|
|
$method = $this->input->post('method');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$tgl_now = date('m/01/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_0($tgl_now,$id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Buka');
|
|
}
|
|
|
|
if (strtotime($datKasbank[0]['TGL_KB'])<strtotime($tgl_now)) {
|
|
$this->session->set_flashdata('date_locked', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Buka');
|
|
}
|
|
|
|
$update = [
|
|
'STATUS_KB' => NULL
|
|
];
|
|
$action = $this->Keuangan->update('kasbank', $update, 'ID_KB', $id_kb);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('data_lock_all', 'dibuka');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Buka');
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'dibuka');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function dataKasbank_Keuangan_A2_Kaskeluar($id) {
|
|
$set = 1;
|
|
$datKeuangan = $this->Keuangan->getData_DaftarKasbank_byKB_Kaskeluar($id);
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_byID($id);
|
|
$datHda = $this->Keuangan->getData_HutangDagang_forDKB();
|
|
$datFee = $this->Keuangan->getData_Penjualan_forDKB();
|
|
$datBank = $this->Bank->getData_Bank_forDkb($datKasbank[0]['BANK_ID']);
|
|
$datSupplier = $this->Supplier->getData_Supplier();
|
|
$datKaryawan = $this->Karyawan->getData_Karyawan();
|
|
$datKas = $this->Kas->getData_Kas_forDkb($datKasbank[0]['KAS_ID']);
|
|
$datKendaraan = $this->Kendaraan->getData_Kendaraan();
|
|
$datPerkiraan = $this->Perkiraan->getData_Perkiraan_Lain();
|
|
$datPihakke3 = $this->Pihakke3->getData_PihakKe3();
|
|
if ($datKeuangan==FALSE) {
|
|
$debet_dkb = 0;
|
|
$kredit_dkb = 0;
|
|
} else {
|
|
$sumDaftarKasbank = $this->Keuangan->getSum_DaftarKasbank_byKB($id);
|
|
$debet_dkb = $sumDaftarKasbank[0]['DEBET'];
|
|
$kredit_dkb = $sumDaftarKasbank[0]['KREDIT'];
|
|
}
|
|
|
|
$data = [
|
|
'sidebar' => "menu keuangan",
|
|
'navChild' => "",
|
|
'keuangan' => $datKeuangan,
|
|
'hda' => $datHda,
|
|
'bank' => $datBank,
|
|
'fee' => $datFee,
|
|
'supplier' => $datSupplier,
|
|
'karyawan' => $datKaryawan,
|
|
'kas' => $datKas,
|
|
'kendaraan' => $datKendaraan,
|
|
'perkiraan' => $datPerkiraan,
|
|
'pihakke3' => $datPihakke3,
|
|
'debet_dkb' => $debet_dkb,
|
|
'kredit_dkb' => $kredit_dkb,
|
|
'nilai' => $datKasbank[0]['NILAI'],
|
|
'nama_kas' => $datKasbank[0]['NAMA_KAS'],
|
|
'kode_kb' => $datKasbank[0]['KODE_KB'],
|
|
'id_kb' => $id,
|
|
'set' => $set
|
|
];
|
|
$this->load->view('proses/KeuanganKasbank_Keuangan_A2_Kaskeluar', $data);
|
|
}
|
|
|
|
public function dataKasbank_Keuangan_A2_Kaskeluar_View($id) {
|
|
$set = 0;
|
|
$datKeuangan = $this->Keuangan->getData_DaftarKasbank_byKB_Kaskeluar($id);
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_byID($id);
|
|
$datHda = $this->Keuangan->getData_HutangDagang_forDKB();
|
|
$datFee = $this->Keuangan->getData_Penjualan_forDKB();
|
|
$datBank = $this->Bank->getData_Bank_forDkb($datKasbank[0]['BANK_ID']);
|
|
$datSupplier = $this->Supplier->getData_Supplier();
|
|
$datKaryawan = $this->Karyawan->getData_Karyawan();
|
|
$datKas = $this->Kas->getData_Kas_forDkb($datKasbank[0]['KAS_ID']);
|
|
$datKendaraan = $this->Kendaraan->getData_Kendaraan();
|
|
$datPerkiraan = $this->Perkiraan->getData_Perkiraan_Lain();
|
|
$datPihakke3 = $this->Pihakke3->getData_PihakKe3();
|
|
if ($datKeuangan==FALSE) {
|
|
$debet_dkb = 0;
|
|
$kredit_dkb = 0;
|
|
} else {
|
|
$sumDaftarKasbank = $this->Keuangan->getSum_DaftarKasbank_byKB($id);
|
|
$debet_dkb = $sumDaftarKasbank[0]['DEBET'];
|
|
$kredit_dkb = $sumDaftarKasbank[0]['KREDIT'];
|
|
}
|
|
|
|
$data = [
|
|
'sidebar' => "menu keuangan",
|
|
'navChild' => "",
|
|
'keuangan' => $datKeuangan,
|
|
'hda' => $datHda,
|
|
'bank' => $datBank,
|
|
'fee' => $datFee,
|
|
'supplier' => $datSupplier,
|
|
'karyawan' => $datKaryawan,
|
|
'kas' => $datKas,
|
|
'kendaraan' => $datKendaraan,
|
|
'perkiraan' => $datPerkiraan,
|
|
'pihakke3' => $datPihakke3,
|
|
'debet_dkb' => $debet_dkb,
|
|
'kredit_dkb' => $kredit_dkb,
|
|
'nilai' => $datKasbank[0]['NILAI'],
|
|
'nama_kas' => $datKasbank[0]['NAMA_KAS'],
|
|
'kode_kb' => $datKasbank[0]['KODE_KB'],
|
|
'id_kb' => $id,
|
|
'set' => $set
|
|
];
|
|
$this->load->view('proses/KeuanganKasbank_Keuangan_A2_Kaskeluar', $data);
|
|
}
|
|
|
|
public function simpankaskeluar_A2_BBE() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_kendaraan = $this->input->post('id_kendaraan');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KENDARAAN_ID' => $id_kendaraan,
|
|
'TGL_BBE' => $tgl,
|
|
'BIAYA_BBE' => $nilai_dkb
|
|
];
|
|
$action = $this->Keuangan->create('biaya_bensin', $input);
|
|
$id_bbe = $this->Keuangan->getID_BiayaBensinMax();
|
|
$id_bbe = $id_bbe[0]['ID_BBE'];
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'BBE_ID' => $id_bbe
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('biaya_bensin', $update, 'ID_BBE', $id_bbe);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_BFE() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$inv_penjualan = $this->input->post('inv_penjualan');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datPenjualan = $this->Keuangan->getData_Penjualan_byINV($inv_penjualan);
|
|
if ($datPenjualan==FALSE) {
|
|
$this->session->set_flashdata('latest', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datBiayaFee = $this->Keuangan->getData_BiayaFee_byPENJUALAN($datPenjualan[0]['ID_PENJUALAN']);
|
|
$totalFee = $datBiayaFee[0]['BIAYA']+$nilai_dkb;
|
|
if ($datPenjualan[0]['FEE_SO']<$totalFee) {
|
|
$this->session->set_flashdata('fee_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'PENJUALAN_ID' => $datPenjualan[0]['ID_PENJUALAN'],
|
|
'TGL_BFE' => $tgl,
|
|
'BIAYA_BFE' => $nilai_dkb
|
|
];
|
|
$action = $this->Keuangan->create('biaya_fee', $input);
|
|
$id_bfe = $this->Keuangan->getID_BiayaFeeMax();
|
|
$id_bfe = $id_bfe[0]['ID_BFE'];
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'BFE_ID' => $id_bfe
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('biaya_fee', $update, 'ID_BFE', $id_bfe);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_BSE() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_kendaraan = $this->input->post('id_kendaraan');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KENDARAAN_ID' => $id_kendaraan,
|
|
'TGL_BSE' => $tgl,
|
|
'BIAYA_BSE' => $nilai_dkb
|
|
];
|
|
$action = $this->Keuangan->create('biaya_servicekendaraan', $input);
|
|
$id_bse = $this->Keuangan->getID_BiayaServiceKendaraanMax();
|
|
$id_bse = $id_bse[0]['ID_BSE'];
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'BSE_ID' => $id_bse
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('biaya_servicekendaraan', $update, 'ID_BSE', $id_bse);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_SK() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_kas = $this->input->post('id_kas');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KAS_ID' => $id_kas,
|
|
'TGL_SK' => $tgl,
|
|
'TGL_INPUT' => $tgl,
|
|
'DEBET_SK' => $nilai_dkb,
|
|
'KREDIT_SK' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('saldo_kas', $input);
|
|
$id_sk = $this->Keuangan->getID_SaldoKasMax();
|
|
$id_sk = $id_sk[0]['ID_SK'];
|
|
|
|
$datKas = $this->Keuangan->getData_Kas_byID($id_kas);
|
|
$kode_kas = $datKas[0]['KODE_KAS'];
|
|
$ket_dkb = "Ayat Silang u/ $kode_kas";
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'SK_ID' => $id_sk
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_kas', $update, 'ID_SK', $id_sk);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_SB() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_bank = $this->input->post('id_bank');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'BANK_ID' => $id_bank,
|
|
'TGL_SB' => $tgl,
|
|
'TGL_INPUT' => $tgl,
|
|
'DEBET_SB' => $nilai_dkb,
|
|
'KREDIT_SB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('saldo_bank', $input);
|
|
$id_sb = $this->Keuangan->getID_SaldoBankMax();
|
|
$id_sb = $id_sb[0]['ID_SB'];
|
|
|
|
$datBank = $this->Keuangan->getData_Bank_byID($id_bank);
|
|
$kode_bank = $datBank[0]['KODE_BANK'];
|
|
$ket_dkb = "Ayat Silang u/ $kode_bank";
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'SB_ID' => $id_sb
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('saldo_bank', $update, 'ID_SB', $id_sb);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_DPB() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_supplier = $this->input->post('id_supplier');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'SUPPLIER_ID' => $id_supplier,
|
|
'TGL_DPB' => $tgl,
|
|
'DEBET_DPB' => $nilai_dkb,
|
|
'KREDIT_DPB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('dp_pembelian', $input);
|
|
$id_dpb = $this->Keuangan->getID_DPPembelianMax();
|
|
$id_dpb = $id_dpb[0]['ID_DPB'];
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'DPB_ID' => $id_dpb
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('dp_pembelian', $update, 'ID_DPB', $id_dpb);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_HDA() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$inv_pembelian = $this->input->post('inv_pembelian');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datPembelian = $this->Keuangan->getData_Pembelian_byINV($inv_pembelian);
|
|
if ($datPembelian==FALSE) {
|
|
$this->session->set_flashdata('latest', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datHda = $this->Keuangan->getData_HutangDagang_byPEMBELIAN($datPembelian[0]['ID_PEMBELIAN']);
|
|
$debet_hda = $datHda[0]['DEBET'];
|
|
$kredit_hda = $datHda[0]['KREDIT'];
|
|
$totalDebet = $debet_hda+$nilai_dkb;
|
|
if ($totalDebet>$kredit_hda) {
|
|
$this->session->set_flashdata('hutang_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$kode_pembelian = $datPembelian[0]['KODE_PEMBELIAN'];
|
|
$ket_hda = "No Nota : $kode_pembelian";
|
|
$input = [
|
|
'SUPPLIER_ID' => $datPembelian[0]['SUPPLIER_ID'],
|
|
'PEMBELIAN_ID' => $datPembelian[0]['ID_PEMBELIAN'],
|
|
'TRANSAKSI_HDA' => '1',
|
|
'TGL_HDA' => $tgl,
|
|
'KODE_BUKTI' => $datKasbank[0]['KODE_KB'],
|
|
'DEBET_HDA' => $nilai_dkb,
|
|
'KREDIT_HDA' => '0',
|
|
'KET_HDA' => $ket_hda
|
|
];
|
|
$action = $this->Keuangan->create('hutang_dagang', $input);
|
|
$id_hda = $this->Keuangan->getID_HutangDagangMax();
|
|
$id_hda = $id_hda[0]['ID_HDA'];
|
|
|
|
$ket_dkb = "Pembayaran Nota $inv_pembelian";
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'HDA_ID' => $id_hda
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('hutang_dagang', $update, 'ID_HDA', $id_hda);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_PKA() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_karyawan = $this->input->post('id_karyawan');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KARYAWAN_ID' => $id_karyawan,
|
|
'TGL_PKA' => $tgl,
|
|
'DEBET_PKA' => $nilai_dkb,
|
|
'KREDIT_PKA' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('piutang_karyawan', $input);
|
|
$id_pka = $this->Keuangan->getID_PiutangKaryawanMax();
|
|
$id_pka = $id_pka[0]['ID_PKA'];
|
|
|
|
if ($ket_dkb=="") {
|
|
$datKaryawan = $this->Keuangan->getData_Karyawan_byID($id_karyawan);
|
|
$nama_karyawan = $datKaryawan[0]['NAMA_KARYAWAN'];
|
|
$ket_dkb = "Atas Nama $nama_karyawan";
|
|
}
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'PKA_ID' => $id_pka
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('piutang_karyawan', $update, 'ID_PKA', $id_pka);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_PPK() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_pihakke3 = $this->input->post('id_pihakke3');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
$tgl = date('m/d/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'PIHAKKE3_ID' => $id_pihakke3,
|
|
'TGL_PPK' => $tgl,
|
|
'DEBET_PPK' => $nilai_dkb,
|
|
'KREDIT_PPK' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('piutang_pihakke3', $input);
|
|
$id_ppk = $this->Keuangan->getID_PiutangPihakke3Max();
|
|
$id_ppk = $id_ppk[0]['ID_PPK'];
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0',
|
|
'PPK_ID' => $id_ppk
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
$id_dkb = $this->Keuangan->getID_DaftarKasbankMax();
|
|
$id_dkb = $id_dkb[0]['ID_DKB'];
|
|
|
|
$update = [
|
|
'DKB_ID' => $id_dkb
|
|
];
|
|
$action = $this->Keuangan->update('piutang_pihakke3', $update, 'ID_PPK', $id_ppk);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function simpankaskeluar_A2_LAIN() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$id_perkiraan = $this->input->post('id_perkiraan');
|
|
$debet_dkb = $this->input->post('debet_dkb');
|
|
$kredit_dkb = $this->input->post('kredit_dkb');
|
|
$nilai_dkb = $this->input->post('nilai_dkb');
|
|
$ket_dkb = $this->input->post('ket_dkb');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$check_nilai = is_numeric($nilai_dkb);
|
|
if ($check_nilai==FALSE) {
|
|
$nilai_dkb = 0;
|
|
}
|
|
|
|
if ($nilai_dkb<=0) {
|
|
$this->session->set_flashdata('not_zero_negative', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$total_debet = $debet_dkb+$nilai_dkb;
|
|
if ($total_debet>$kredit_dkb) {
|
|
$this->session->set_flashdata('debet_error', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$input = [
|
|
'KB_ID' => $id_kb,
|
|
'PERKIRAAN_ID' => $id_perkiraan,
|
|
'DEBET_DKB' => $nilai_dkb,
|
|
'KET_DKB' => $ket_dkb,
|
|
'KREDIT_DKB' => '0'
|
|
];
|
|
$action = $this->Keuangan->create('daftar_kasbank', $input);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'ditambah');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function hapuskaskeluar_A2() {
|
|
$method = $this->input->post('method');
|
|
$id_dkb = $this->input->post('id_dkb');
|
|
$tgl_now = date('m/01/Y');
|
|
|
|
$datDkb = $this->Keuangan->getData_DaftarKasbank_byID($id_dkb);
|
|
if ($datDkb==FALSE) {
|
|
$this->session->set_flashdata('latest', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($datDkb[0]['KB_ID']);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
if (strtotime($tgl_now)>strtotime($datKasbank[0]['TGL_KB'])) {
|
|
$this->session->set_flashdata('date_locked', 'error');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
if ($datDkb[0]['DPB_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('dp_pembelian', $datDkb[0]['DPB_ID'], 'ID_DPB');
|
|
} else if ($datDkb[0]['HDA_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('hutang_dagang', $datDkb[0]['HDA_ID'], 'ID_HDA');
|
|
} else if ($datDkb[0]['PKA_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('piutang_karyawan', $datDkb[0]['PKA_ID'], 'ID_PKA');
|
|
} else if ($datDkb[0]['PPK_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('piutang_pihakke3', $datDkb[0]['PPK_ID'], 'ID_PPK');
|
|
} else if ($datDkb[0]['SB_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('saldo_bank', $datDkb[0]['SB_ID'], 'ID_SB');
|
|
} else if ($datDkb[0]['SK_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('saldo_kas', $datDkb[0]['SK_ID'], 'ID_SK');
|
|
} else if ($datDkb[0]['BBE_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('biaya_bensin', $datDkb[0]['BBE_ID'], 'ID_BBE');
|
|
} else if ($datDkb[0]['BFE_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('biaya_fee', $datDkb[0]['BFE_ID'], 'ID_BFE');
|
|
} else if ($datDkb[0]['BSE_ID']!=NULL) {
|
|
$action = $this->Keuangan->delete('biaya_servicekendaraan', $datDkb[0]['BSE_ID'], 'ID_BSE');
|
|
}
|
|
|
|
$action = $this->Keuangan->delete('daftar_kasbank', $id_dkb, 'ID_DKB');
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('success', 'dihapus');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'dihapus');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function kuncikaskeluar_A2() {
|
|
$method = $this->input->post('method');
|
|
$id_kb = $this->input->post('id_kb');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_Null($id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
}
|
|
|
|
$update = [
|
|
'STATUS_KB' => '0'
|
|
];
|
|
$action = $this->Keuangan->update('kasbank', $update, 'ID_KB', $id_kb);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('data_lock_all', 'dikunci');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Awal');
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'dikunci');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
public function bukakaskeluar_A2() {
|
|
$method = $this->input->post('method');
|
|
$id_kb = $this->input->post('id_kb');
|
|
$tgl_now = date('m/01/Y');
|
|
|
|
$datKasbank = $this->Keuangan->getData_Kasbank_Kas_0($tgl_now,$id_kb);
|
|
if ($datKasbank==FALSE) {
|
|
$this->session->set_flashdata('not_valid', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Buka');
|
|
}
|
|
|
|
if (strtotime($datKasbank[0]['TGL_KB'])<strtotime($tgl_now)) {
|
|
$this->session->set_flashdata('date_locked', 'error');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Buka');
|
|
}
|
|
|
|
$update = [
|
|
'STATUS_KB' => NULL
|
|
];
|
|
$action = $this->Keuangan->update('kasbank', $update, 'ID_KB', $id_kb);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('data_lock_all', 'dibuka');
|
|
redirect('ManageKeuangan/dataKasbank_Keuangan_A1_Buka');
|
|
} else {
|
|
$this->session->set_flashdata('failed', 'dibuka');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
}
|