abel/shopee-apps
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
shopee-apps/application/delete/controllers/ManageBankKeluar.php
T
abel db327c0305 copy dari repo om Irfan
2026-06-13 16:02:07 +10:00

1708 lines
50 KiB
PHP
Raw Permalink Blame History

<?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 ManageBankKeluar extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->model('ModelBankKeluar', 'BankKeluar');
$this->load->model('ModelBank', 'Bank');
$this->load->model('ModelKendaraan', 'Kendaraan');
$this->load->model('ModelKas', 'Kas');
$this->load->model('ModelKaryawan', 'Karyawan');
$this->load->model('ModelPerkiraan', 'Perkiraan');
$this->load->model('ModelPajak', 'Pajak');
$this->load->model('ModelPelanggan', 'Pelanggan');
$this->load->model('ModelSupplier', 'Supplier');
$this->load->model('ModelPihakKe3', 'PihakKe3');
$this->load->model('ModelHutangDagang', 'Hda');
$this->load->model('ModelHutangPajak', 'Hpa');
$this->load->model('ModelHutangBank', 'Hba');
$this->load->model('ModelHutangLain', 'Hla');
$this->load->model('ModelBiayaFee', 'Bf');
$this->load->model('ModelBiayaPengiriman', 'Bp');
$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);
}
//Step One, Input Bank Keluar
public function index() {
$datBankKeluar = $this->BankKeluar->getDataBankKeluar();
$datBank = $this->Bank->getDataBankDetail();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'bankkeluar'=> $datBankKeluar,
'bank' => $datBank
];
$this->load->view('proses/BankKeluar', $data);
}
public function kodeBankKeluar() {
$kk = $this->BankKeluar->getKodeBankKeluar();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "BBK/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "BBK/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function save() {
$method = $this->input->post('method');
$id = $this->input->post('id_bankkeluar');
$id_bank = $this->input->post('id_bank');
$kredit_bankkeluar = $this->input->post('kredit_bankkeluar');
$kode_bankkeluar = $this->kodeBankKeluar();
$input = [
'KODE_BANKKELUAR' => $kode_bankkeluar,
'BANK_ID' => $id_bank,
'KREDIT_BANKKELUAR' => $kredit_bankkeluar,
'DEBIT_BANKKELUAR' => '0'
];
$action = $this->BankKeluar->create('bankkeluar', $input);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect('ManageBankKeluar');
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect('ManageBankKeluar');
}
}
public function edit() {
$method = $this->input->post('method');
$id_bankkeluar = $this->input->post('id_bankkeluar');
$id_bank = $this->input->post('id_banked');
$kredit_bankkeluar = $this->input->post('kredit_bankkeluared');
$update = [
'BANK_ID' => $id_bank,
'KREDIT_BANKKELUAR' => $kredit_bankkeluar
];
$action = $this->BankKeluar->update('bankkeluar', $update, 'ID_BANKKELUAR', $id_bankkeluar);
if ($action) {
$this->session->set_flashdata('flash', 'diedit');
redirect('ManageBankKeluar');
} else {
$this->session->set_flashdata('flashgagal', 'diedit');
redirect('ManageBankKeluar');
}
}
public function hapus() {
$id = $this->input->post('id');
$action = $this->BankKeluar->hapusKasbankBK($id);
$action = $this->BankKeluar->delete('bankkeluar',$id,'ID_BANKKELUAR');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function konfirmasi() {
$method = $this->input->post('method');
$id_bankkeluar = $this->input->post('id_bankkeluar');
//Proses Konfirmasi + Update Saldo Bank
$databank = $this->BankKeluar->getDataBankKeluar($id_bankkeluar);
$saldo = $databank[0]['SALDO_BANK'];
$nominal = $databank[0]['KREDIT_BANKKELUAR'];
$id_bank = $databank[0]['BANK_ID'];
$saldo_bank = $saldo-$nominal;
$update = [
'SALDO_BANK' => $saldo_bank
];
$action = $this->BankKeluar->update('bank', $update, 'ID_BANK', $id_bank);
$update = [
'STATUS_BANKKELUAR' => '0'
];
$action = $this->BankKeluar->update('bankkeluar', $update, 'ID_BANKKELUAR', $id_bankkeluar);
if ($action) {
$this->session->set_flashdata('flash', 'dikonfirmasi');
redirect('ManageBankKeluar');
} else {
$this->session->set_flashdata('flashgagal', 'dikonfirmasi');
redirect('ManageBankKeluar');
}
}
//Step Two, Input Transaksi
public function tambahTransaksi($id) {
$transaksi = $this->BankKeluar->getDataKasbankBK($id);
$title = $this->BankKeluar->getTitleBK($id);
$perkiraan = $this->Perkiraan->getDataPerkiraan();
$bank = $this->Bank->getDataBankDetail();
$kas = $this->Kas->getDataKasDetail();
$supplier = $this->Supplier->getDataSupplier();
$kendaraan = $this->Kendaraan->getDataKendaraan();
$karyawan = $this->Karyawan->getDataKaryawan();
$pihakke3 = $this->PihakKe3->getDataPihakKe3();
$pelanggan = $this->Pelanggan->getDataPelanggan();
$pajak = $this->Pajak->getDataPajak();
$hda = $this->Hda->getDataHutangDagangDetail();
$hpa = $this->Hpa->getDataHutangPajakDetail();
$hba = $this->Hba->getDataHutangBankDetail();
$hla = $this->Hla->getDataHutangLainDetail();
$bp = $this->Bp->getDataBiayaPengirimanDetail();
$bf = $this->Bf->getDataBiayaFeeDetail();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'transaksi' => $transaksi,
'id_bankkeluar' => $id,
'title1' => $title[0]['KODE_BANKKELUAR'],
'title2' => $title[0]['DEBIT'],
'title3' => $title[0]['KREDIT'],
'perkiraan' => $perkiraan,
'bank' => $bank,
'kas' => $kas,
'kendaraan' => $kendaraan,
'karyawan' => $karyawan,
'supplier' => $supplier,
'pihakke3' => $pihakke3,
'pelanggan' => $pelanggan,
'pajak' => $pajak,
'hda' => $hda,
'hpa' => $hpa,
'hba' => $hba,
'hla' => $hla,
'bp' => $bp,
'bf' => $bf
];
$this->load->view('proses/KasbankBK', $data);
}
public function kodeKasbankBK() {
$kk = $this->BankKeluar->getKodeKasbankBK();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "KBBK/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "KBBK/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function savetransaksi() {
//Step Input Transaksi
$method = $this->input->post('method');
$id_kbbk = $this->input->post('id');
$id_bankkeluar = $this->input->post('id_bankkeluar');
$id_perkiraan = $this->input->post('id_perkiraan');
$nominal_kbbk = $this->input->post('nominal_kbbk');
$ket_kbbk = $this->input->post('ket_kbbk');
$kode_kbbk = $this->kodeKasbankBK();
$input = [
'BANKKELUAR_ID' => $id_bankkeluar,
'PERKIRAAN_ID' => $id_perkiraan,
'NOMINAL_KBBK' => $nominal_kbbk,
'KET_KBBK' => $ket_kbbk,
'KODE_KBBK' => $kode_kbbk
];
$action = $this->BankKeluar->create('kasbank_bk', $input);
//Step Ambil Data Lama
$id_kbbk = $this->BankKeluar->getID_KBBK();
$datadebit = $this->BankKeluar->getDebitData($id_kbbk[0]['KODE']);
$id_bankkeluar = $datadebit[0]['ID_BANKKELUAR'];
$nominal = $datadebit[0]['DEBIT_BANKKELUAR'];
$debit_bankkeluar = $nominal+$nominal_kbbk;
$update = [
'DEBIT_BANKKELUAR' => $debit_bankkeluar
];
$action = $this->BankKeluar->update('bankkeluar', $update, 'ID_BANKKELUAR', $id_bankkeluar);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function edittransaksi() {
//Step Edit Transaksi
$method = $this->input->post('method');
$id_kbbk = $this->input->post('id_kbbk');
$id_bankkeluar = $this->input->post('id_bankkeluar');
$id_perkiraan = $this->input->post('id_perkiraaned');
$nominal_kbbk = $this->input->post('nominal_kbbked');
$ket_kbbk = $this->input->post('ket_kbbked');
//Step Ambil Data Lama
$datadebit = $this->BankKeluar->getDebitData($id_kbbk);
$nominal = $datadebit[0]['DEBIT_BANKKELUAR'];
$nominallama = $datadebit[0]['NOMINAL_KBBK'];
$nominalbaru = $nominal-$nominallama;
$update = [
'DEBIT_BANKKELUAR' => $nominalbaru
];
$action = $this->BankKeluar->update('bankkeluar', $update, 'ID_BANKKELUAR', $id_bankkeluar);
//Step Update Debit Bank Keluar
$update = [
'PERKIRAAN_ID' => $id_perkiraan,
'NOMINAL_KBBK' => $nominal_kbbk,
'KET_KBBK' => $ket_kbbk
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
//Step Update Bank Keluar
$datadebit = $this->BankKeluar->getDebitData($id_kbbk);
$nominal = $datadebit[0]['DEBIT_BANKKELUAR'];
$nominalbaru = $nominal+$nominal_kbbk;
$update = [
'DEBIT_BANKKELUAR' => $nominalbaru
];
$action = $this->BankKeluar->update('bankkeluar', $update, 'ID_BANKKELUAR', $id_bankkeluar);
if ($action) {
$this->session->set_flashdata('flash', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function hapustransaksi() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$datadebit = $this->BankKeluar->getDebitData($id);
$id_bankkeluar = $datadebit[0]['ID_BANKKELUAR'];
$nominal = $datadebit[0]['DEBIT_BANKKELUAR'];
$debit = $datadebit[0]['NOMINAL_KBBK'];
$nominalbaru = $nominal-$debit;
$update = [
'DEBIT_BANKKELUAR' => $nominalbaru
];
$action = $this->BankKeluar->update('bankkeluar', $update, 'ID_BANKKELUAR', $id_bankkeluar);
//Step Hapus Data
$action = $this->BankKeluar->delete('kasbank_bk',$id,'ID_KBBK');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
//Step Three, Input Detail
//Substep Three, Transaksi Sekali Jalan
public function kodeDetailKAS() {
$kk = $this->BankKeluar->getKodeDetailKAS();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "KAS/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "KAS/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailkas() {
//Step Input Detail KAS
$method = $this->input->post('method');
$id_dkas = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_kas = $this->input->post('id_kas');
$kode_dkas = $this->kodeDetailKAS();
if ($id_kas==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$debit_dkas = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'DEBIT_DKAS' => $debit_dkas,
'KAS_ID' => $id_kas,
'KODE_DKAS' => $kode_dkas,
'KODE_BUKTI' => $kode_bukti
];
$action = $this->BankKeluar->create('detail_kas', $input);
$kas = $this->BankKeluar->getSaldoKAS($id_kas);
$saldo = $kas[0]['SALDO_KAS'] + $debit_dkas ;
$update = [
'SALDO_KAS' => $saldo
];
$action = $this->BankKeluar->update('kas', $update, 'ID_KAS', $id_kas);
$id_dkas = $this->BankKeluar->getIDDKAS();
$update = [
'DKAS_ID' => $id_dkas[0]['ID_DKAS']
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetkas() {
$id = $this->input->post('id');
//Step Reset Saldo KAS
$id_dkas = $this->BankKeluar->getDataKBBK($id);
$debit_kbbk = $id_dkas[0]['NOMINAL_KBBK'];
$id_dkas = $id_dkas[0]['DKAS_ID'];
$kas = $this->BankKeluar->getDataKAS($id_dkas);
$id_kas = $kas[0]['ID_KAS'];
$saldo = $kas[0]['SALDO_KAS'];
$saldo = $saldo-$debit_kbbk;
$update = [
'SALDO_KAS' => $saldo
];
$action = $this->BankKeluar->update('kas', $update, 'ID_KAS', $id_kas);
//Step Ambil Data Lama
$id_dkas = $this->BankKeluar->getDKASID($id);
$id_dkas = $id_dkas[0]['DKAS_ID'];
$update = [
'DKAS_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_kas',$id_dkas,'ID_DKAS');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDetailBANK() {
$kk = $this->BankKeluar->getKodeDetailBANK();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "BANK/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "BANK/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailbank() {
//Step Input Detail BANK
$method = $this->input->post('method');
$id_dbank = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_bank = $this->input->post('id_bank');
$kode_dbank = $this->kodeDetailBANK();
if ($id_bank==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$debit_dbank = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'DEBIT_DBANK' => $debit_dbank,
'BANK_ID' => $id_bank,
'KODE_DBANK' => $kode_dbank,
'KODE_BUKTI' => $kode_bukti
];
$action = $this->BankKeluar->create('detail_bank', $input);
$bank = $this->BankKeluar->getSaldoBANK($id_bank);
$saldo = $bank[0]['SALDO_BANK'] + $debit_dbank ;
$update = [
'SALDO_BANK' => $saldo
];
$action = $this->BankKeluar->update('bank', $update, 'ID_BANK', $id_bank);
$id_dbank = $this->BankKeluar->getIDDBANK();
$update = [
'DBANK_ID' => $id_dbank[0]['ID_DBANK']
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetbank() {
$id = $this->input->post('id');
//Step Reset Saldo BANK
$id_dbank = $this->BankKeluar->getDataKBBK($id);
$debit_kbbk = $id_dbank[0]['NOMINAL_KBBK'];
$id_dbank = $id_dbank[0]['DBANK_ID'];
$bank = $this->BankKeluar->getDataBANK($id_dbank);
$id_bank = $bank[0]['ID_BANK'];
$saldo = $bank[0]['SALDO_BANK'];
$saldo = $saldo-$debit_kbbk;
$update = [
'SALDO_BANK' => $saldo
];
$action = $this->BankKeluar->update('bank', $update, 'ID_BANK', $id_bank);
//Step Ambil Data Lama
$id_dbank = $this->BankKeluar->getDBANKID($id);
$id_dbank = $id_dbank[0]['DBANK_ID'];
$update = [
'DBANK_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_bank',$id_dbank,'ID_DBANK');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDPB() {
$kk = $this->BankKeluar->getKodeDPB();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DPB/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "DPB/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detaildpb() {
//Step Input Detail DP Pembelian
$method = $this->input->post('method');
$id_dpb = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_supplier = $this->input->post('id_supplier');
$kode_dpb = $this->kodeDPB();
if ($id_supplier==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$kredit_dpb = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'NOMINAL_DPB' => $kredit_dpb,
'SUPPLIER_ID' => $id_supplier,
'KODE_DPB' => $kode_dpb,
'KODE_BUKTI' => $kode_bukti,
'BLOCKCON' => '0'
];
$action = $this->BankKeluar->create('dp_pembelian', $input);
$supplier = $this->BankKeluar->getSaldoDPB($id_supplier);
$saldo = $supplier[0]['SALDO_SUPPLIER'] + $kredit_dpb ;
$update = [
'SALDO_SUPPLIER' => $saldo
];
$action = $this->BankKeluar->update('supplier', $update, 'ID_SUPPLIER', $id_supplier);
$id_dpb = $this->BankKeluar->getIDDPB();
$update = [
'DPB_ID' => $id_dpb[0]['ID_DPB']
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdpb() {
$id = $this->input->post('id');
//Step Reset Saldo DP Pembelian
$id_dpb = $this->BankKeluar->getDataKBBK($id);
$debit_kbbk = $id_dpb[0]['NOMINAL_KBBK'];
$id_dpb = $id_dpb[0]['DPB_ID'];
$supplier = $this->BankKeluar->getDataSUP($id_dpb);
$id_supplier = $supplier[0]['ID_SUPPLIER'];
$saldo = $supplier[0]['SALDO_SUPPLIER'];
$saldo = $saldo-$debit_kbbk;
$update = [
'SALDO_SUPPLIER' => $saldo
];
$action = $this->BankKeluar->update('supplier', $update, 'ID_SUPPLIER', $id_supplier);
//Step Ambil Data Lama
$id_dpb = $this->BankKeluar->getDPBID($id);
$id_dpb = $id_dpb[0]['DPB_ID'];
$update = [
'DPB_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('dp_pembelian',$id_dpb,'ID_DPB');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDPP() {
$kk = $this->BankKeluar->getKodeDPP();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DPP/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "DPP/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detaildpp() {
//Step Input Detail DP Pajak
$method = $this->input->post('method');
$id_dpp = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_pajak = $this->input->post('id_pajak');
$kode_dpp = $this->kodeDPP();
if ($id_pajak==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$kredit_dpp = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'NOMINAL_DPP' => $kredit_dpp,
'PAJAK_ID' => $id_pajak,
'KODE_DPP' => $kode_dpp,
'KODE_BUKTI' => $kode_bukti,
'BLOCKCON' => '0'
];
$action = $this->BankKeluar->create('dp_pajak', $input);
$pajak = $this->BankKeluar->getSaldoDPP($id_pajak);
$saldo = $pajak[0]['SALDO_PAJAK'] + $kredit_dpp ;
$update = [
'SALDO_PAJAK' => $saldo
];
$action = $this->BankKeluar->update('pajak', $update, 'ID_PAJAK', $id_pajak);
$id_dpp = $this->BankKeluar->getIDDPP();
$update = [
'DPP_ID' => $id_dpp[0]['ID_DPP']
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdpp() {
$id = $this->input->post('id');
//Step Reset Saldo DP Pajak
$id_dpp = $this->BankKeluar->getDataKBBK($id);
$debit_kbbk = $id_dpp[0]['NOMINAL_KBBK'];
$id_dpp = $id_dpp[0]['DPP_ID'];
$pajak = $this->BankKeluar->getDataPAJ($id_dpp);
$id_pajak = $pajak[0]['ID_PAJAK'];
$saldo = $pajak[0]['SALDO_PAJAK'];
$saldo = $saldo-$debit_kbbk;
$update = [
'SALDO_PAJAK' => $saldo
];
$action = $this->BankKeluar->update('pajak', $update, 'ID_PAJAK', $id_pajak);
//Step Ambil Data Lama
$id_dpp = $this->BankKeluar->getDPPID($id);
$id_dpp = $id_dpp[0]['DPP_ID'];
$update = [
'DPP_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('dp_pajak',$id_dpp,'ID_DPP');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
//Substep Three, Create Data Hutang/Piutang
public function kodePiutangKARYAWAN() {
$kk = $this->BankKeluar->getKodePiutangKARYAWAN();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "PKAR/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "PKAR/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailpkar() {
//Step Input Detail Piutang KARYAWAN
$method = $this->input->post('method');
$id_pkar = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_karyawan = $this->input->post('id_karyawan');
$kode_pkar = $this->kodePiutangKARYAWAN();
if ($id_karyawan==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_pkar = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'NOMINAL_PKAR' => $nominal_pkar,
'KARYAWAN_ID' => $id_karyawan,
'KODE_PKAR' => $kode_pkar,
'KODE_BUKTI' => $kode_bukti,
'BLOCKCON' => '0'
];
$action = $this->BankKeluar->create('piutang_karyawan', $input);
$karyawan = $this->BankKeluar->getPiutangKARYAWAN($id_karyawan);
$hutang = $karyawan[0]['HUTANG_KARYAWAN'] + $nominal_pkar ;
$update = [
'HUTANG_KARYAWAN' => $hutang
];
$action = $this->BankKeluar->update('karyawan', $update, 'ID_KARYAWAN', $id_karyawan);
$id_pkar = $this->BankKeluar->getIDPKAR();
$update = [
'PKAR_ID' => $id_pkar[0]['ID_PKAR']
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetpkar() {
$id = $this->input->post('id');
//Step Reset Piutang KARYAWAN
$karyawan = $this->BankKeluar->getDataKBBK($id);
$nominal_kbbk = $karyawan[0]['NOMINAL_KBBK'];
$id_pkar = $karyawan[0]['PKAR_ID'];
$karyawan = $this->BankKeluar->getDataPKAR($id_pkar);
$id_karyawan = $karyawan[0]['ID_KARYAWAN'];
$hutang = $karyawan[0]['HUTANG_KARYAWAN'];
$hutang = $hutang-$nominal_kbbk;
$update = [
'HUTANG_KARYAWAN' => $hutang
];
$action = $this->BankKeluar->update('karyawan', $update, 'ID_KARYAWAN', $id_karyawan);
//Step Ambil Data Lama
$id_pkar = $this->BankKeluar->getPKARID($id);
$id_pkar = $id_pkar[0]['PKAR_ID'];
$update = [
'PKAR_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('piutang_karyawan',$id_pkar,'ID_PKAR');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodePiutangPIHAKKE3() {
$kk = $this->BankKeluar->getKodePiutangPIHAKKE3();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "PPI/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "PPI/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailppi() {
//Step Input Detail Piutang PIHAKKE3
$method = $this->input->post('method');
$id_ppi = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_pihakke3 = $this->input->post('id_pihakke3');
$kode_ppi = $this->kodePiutangPIHAKKE3();
if ($id_pihakke3==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_ppi = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'NOMINAL_PPI' => $nominal_ppi,
'PIHAKKE3_ID' => $id_pihakke3,
'KODE_PPI' => $kode_ppi,
'KODE_BUKTI' => $kode_bukti,
'BLOCKCON' => '0'
];
$action = $this->BankKeluar->create('piutang_pihakke3', $input);
$pihakke3 = $this->BankKeluar->getPiutangPIHAKKE3($id_pihakke3);
$hutang = $pihakke3[0]['HUTANG_PIHAKKE3'] + $nominal_ppi ;
$update = [
'HUTANG_PIHAKKE3' => $hutang
];
$action = $this->BankKeluar->update('pihakke3', $update, 'ID_PIHAKKE3', $id_pihakke3);
$id_ppi = $this->BankKeluar->getIDPPI();
$update = [
'PPI_ID' => $id_ppi[0]['ID_PPI']
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetppi() {
$id = $this->input->post('id');
//Step Reset Piutang PPI
$pihakke3 = $this->BankKeluar->getDataKBBK($id);
$nominal_kbbk = $pihakke3[0]['NOMINAL_KBBK'];
$id_ppi = $pihakke3[0]['PPI_ID'];
$pihakke3 = $this->BankKeluar->getDataPPI($id_ppi);
$id_pihakke3 = $pihakke3[0]['ID_PIHAKKE3'];
$hutang = $pihakke3[0]['HUTANG_PIHAKKE3'];
$hutang = $hutang-$nominal_kbbk;
$update = [
'HUTANG_PIHAKKE3' => $hutang
];
$action = $this->BankKeluar->update('pihakke3', $update, 'ID_PIHAKKE3', $id_pihakke3);
//Step Ambil Data Lama
$id_ppi = $this->BankKeluar->getPPIID($id);
$id_ppi = $id_ppi[0]['PPI_ID'];
$update = [
'PPI_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('piutang_pihakke3',$id_ppi,'ID_PPI');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
//Substep Three, Angsuran Hutang/Piutang
public function kodeDetailHDA() {
$kk = $this->BankKeluar->getKodeDetailHDA();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DHDA/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "DHDA/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailhda() {
//Step Input Detail Hutang Dagang/Supplier
$method = $this->input->post('method');
$id_dhda = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_hda = $this->input->post('id_hda');
$kode_dhda = $this->kodeDetailHDA();
if ($id_hda==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_hda = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DHDA' => $kode_dhda,
'KODE_BUKTI' => $kode_bukti,
'HDA_ID' => $id_hda,
'KREDIT_DHDA' => $nominal_hda
];
$action = $this->BankKeluar->create('detail_hda', $input);
$id_dhda = $this->BankKeluar->getIDDHDA();
$id_dhda = $id_dhda[0]['ID_DHDA'];
$update = [
'DHDA_ID' => $id_dhda
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
$blockcon = $this->BankKeluar->getBlockconHDA($id_hda);
$blockcon = $blockcon[0]['BLOCKCON']+$nominal_hda;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_dagang', $update, 'ID_HDA', $id_hda);
$piutang = $this->BankKeluar->getDataHDA($id_dhda);
$id_supplier = $piutang[0]['ID_SUPPLIER'];
$piutang_supplier = $piutang[0]['PIUTANG_SUPPLIER']-$nominal_hda;
$update = [
'PIUTANG_SUPPLIER' => $piutang_supplier
];
$action = $this->BankKeluar->update('supplier', $update, 'ID_SUPPLIER', $id_supplier);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdhda() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dhda = $this->BankKeluar->getDHDAID($id);
$id_dhda = $id_dhda[0]['DHDA_ID'];
$hda = $this->BankKeluar->getDataHDA($id_dhda);
$id_hda = $hda[0]['ID_HDA'];
$id_supplier = $hda[0]['ID_SUPPLIER'];
$blockcon = $hda[0]['BLOCKCON'];
$kredit_dhda = $hda[0]['KREDIT_DHDA'];
$piutang_supplier = $hda[0]['PIUTANG_SUPPLIER'];
//Step Reset Hutang Dagang/Supplier
$blockcon = $blockcon-$kredit_dhda;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_dagang', $update, 'ID_HDA', $id_hda);
$piutang = $piutang_supplier+$kredit_dhda;
$update = [
'PIUTANG_SUPPLIER' => $piutang
];
$action = $this->BankKeluar->update('supplier', $update, 'ID_SUPPLIER', $id_supplier);
$update = [
'DHDA_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_hda',$id_dhda,'ID_DHDA');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDetailHPA() {
$kk = $this->BankKeluar->getKodeDetailHPA();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DHPA/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "DHPA/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailhpa() {
//Step Input Detail Hutang Pajak
$method = $this->input->post('method');
$id_dhpa = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_hpa = $this->input->post('id_hpa');
$kode_dhpa = $this->kodeDetailHPA();
if ($id_hpa==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_hpa = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DHPA' => $kode_dhpa,
'KODE_BUKTI' => $kode_bukti,
'HPA_ID' => $id_hpa,
'KREDIT_DHPA' => $nominal_hpa
];
$action = $this->BankKeluar->create('detail_hpa', $input);
$id_dhpa = $this->BankKeluar->getIDDHPA();
$id_dhpa = $id_dhpa[0]['ID_DHPA'];
$update = [
'DHPA_ID' => $id_dhpa
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
$blockcon = $this->BankKeluar->getBlockconHPA($id_hpa);
$blockcon = $blockcon[0]['BLOCKCON']+$nominal_hpa;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_pajak', $update, 'ID_HPA', $id_hpa);
$hutang = $this->BankKeluar->getDataHPA($id_dhpa);
$id_pajak = $hutang[0]['ID_PAJAK'];
$hutang_pajak = $hutang[0]['HUTANG_PAJAK']-$nominal_hpa;
$update = [
'HUTANG_PAJAK' => $hutang_pajak
];
$action = $this->BankKeluar->update('pajak', $update, 'ID_PAJAK', $id_pajak);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdhpa() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dhpa = $this->BankKeluar->getDHPAID($id);
$id_dhpa = $id_dhpa[0]['DHPA_ID'];
$hpa = $this->BankKeluar->getDataHPA($id_dhpa);
$id_hpa = $hpa[0]['ID_HPA'];
$id_pajak = $hpa[0]['ID_PAJAK'];
$blockcon = $hpa[0]['BLOCKCON'];
$kredit_dhpa = $hpa[0]['KREDIT_DHPA'];
$hutang_pajak = $hpa[0]['HUTANG_PAJAK'];
//Step Reset Hutang Pajak
$blockcon = $blockcon-$kredit_dhpa;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_pajak', $update, 'ID_HPA', $id_hpa);
$hutang = $hutang_pajak+$kredit_dhpa;
$update = [
'HUTANG_PAJAK' => $hutang
];
$action = $this->BankKeluar->update('pajak', $update, 'ID_PAJAK', $id_pajak);
$update = [
'DHPA_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_hpa',$id_dhpa,'ID_DHPA');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDetailHBA() {
$kk = $this->BankKeluar->getKodeDetailHBA();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DHBA/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "DHBA/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailhba() {
//Step Input Detail Hutang Bank
$method = $this->input->post('method');
$id_dhba = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_hba = $this->input->post('id_hba');
$kode_dhba = $this->kodeDetailHBA();
if ($id_hba==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_hba = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DHBA' => $kode_dhba,
'KODE_BUKTI' => $kode_bukti,
'HBA_ID' => $id_hba,
'KREDIT_DHBA' => $nominal_hba
];
$action = $this->BankKeluar->create('detail_hba', $input);
$id_dhba = $this->BankKeluar->getIDDHBA();
$id_dhba = $id_dhba[0]['ID_DHBA'];
$update = [
'DHBA_ID' => $id_dhba
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
$blockcon = $this->BankKeluar->getBlockconHBA($id_hba);
$blockcon = $blockcon[0]['BLOCKCON']+$nominal_hba;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_bank', $update, 'ID_HBA', $id_hba);
$hutang = $this->BankKeluar->getDataHBA($id_dhba);
$id_bank = $hutang[0]['ID_BANK'];
$hutang_bank = $hutang[0]['HUTANG_BANK']-$nominal_hba;
$saldo_bank = $hutang[0]['SALDO_BANK']-$nominal_hba;
$update = [
'HUTANG_BANK' => $hutang_bank,
'SALDO_BANK' => $saldo_bank
];
$action = $this->BankKeluar->update('bank', $update, 'ID_BANK', $id_bank);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdhba() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dhba = $this->BankKeluar->getDHBAID($id);
$id_dhba = $id_dhba[0]['DHBA_ID'];
$hba = $this->BankKeluar->getDataHBA($id_dhba);
$id_hba = $hba[0]['ID_HBA'];
$id_bank = $hba[0]['ID_BANK'];
$blockcon = $hba[0]['BLOCKCON'];
$kredit_dhba = $hba[0]['KREDIT_DHBA'];
$hutang_bank = $hba[0]['HUTANG_BANK'];
$saldo_bank = $hba[0]['SALDO_BANK'];
//Step Reset Hutang Bank
$blockcon = $blockcon-$kredit_dhba;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_bank', $update, 'ID_HBA', $id_hba);
$hutang = $hutang_bank+$kredit_dhba;
$saldo = $saldo_bank+$kredit_dhba;
$update = [
'HUTANG_BANK' => $hutang,
'SALDO_BANK' => $saldo
];
$action = $this->BankKeluar->update('bank', $update, 'ID_BANK', $id_bank);
$update = [
'DHBA_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_hba',$id_dhba,'ID_DHBA');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDetailHLA() {
$kk = $this->BankKeluar->getKodeDetailHLA();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DHLA/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "DHLA/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailhla() {
//Step Input Detail Hutang Lain
$method = $this->input->post('method');
$id_dhla = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_hla = $this->input->post('id_hla');
$kode_dhla = $this->kodeDetailHLA();
if ($id_hla==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_hla = $kbbk[0]['NOMINAL_KBBK'];
$kode_bukti = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DHLA' => $kode_dhla,
'KODE_BUKTI' => $kode_bukti,
'HLA_ID' => $id_hla,
'KREDIT_DHLA' => $nominal_hla
];
$action = $this->BankKeluar->create('detail_hla', $input);
$id_dhla = $this->BankKeluar->getIDDHLA();
$id_dhla = $id_dhla[0]['ID_DHLA'];
$update = [
'DHLA_ID' => $id_dhla
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
$blockcon = $this->BankKeluar->getBlockconHLA($id_hla);
$blockcon = $blockcon[0]['BLOCKCON']+$nominal_hla;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_lain', $update, 'ID_HLA', $id_hla);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdhla() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dhla = $this->BankKeluar->getDHLAID($id);
$id_dhla = $id_dhla[0]['DHLA_ID'];
$hla = $this->BankKeluar->getDataHLA($id_dhla);
$id_hla = $hla[0]['ID_HLA'];
$blockcon = $hla[0]['BLOCKCON'];
$kredit_dhla = $hla[0]['KREDIT_DHLA'];
//Step Reset Hutang Lain
$blockcon = $blockcon-$kredit_dhla;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('hutang_lain', $update, 'ID_HLA', $id_hla);
$update = [
'DHLA_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_hla',$id_dhla,'ID_DHLA');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
//Substep Three, Link Biaya
public function kodeDetailBF() {
$kk = $this->BankKeluar->getKodeDetailBF();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DBF/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "DBF/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailbf() {
//Step Input Detail Biaya Fee
$method = $this->input->post('method');
$id_dbf = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_bf = $this->input->post('id_bf');
$kode_dbf = $this->kodeDetailBF();
if ($id_bf==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$kredit_dbf = $kbbk[0]['NOMINAL_KBBK'];
$bukti_kredit = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DBF' => $kode_dbf,
'KODE_BUKTI' => $bukti_kredit,
'BF_ID' => $id_bf,
'KREDIT_DBF' => $kredit_dbf,
];
$action = $this->BankKeluar->create('detail_bf', $input);
$id_dbf = $this->BankKeluar->getIDDBF();
$id_dbf = $id_dbf[0]['ID_DBF'];
$update = [
'DBF_ID' => $id_dbf
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
$blockcon = $this->BankKeluar->getBlockconBF($id_bf);
$blockcon = $blockcon[0]['BLOCKCON']+$kredit_dbf;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('biaya_fee', $update, 'ID_BF', $id_bf);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdbf() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dbf = $this->BankKeluar->getDBFID($id);
$id_dbf = $id_dbf[0]['DBF_ID'];
$bf = $this->BankKeluar->getDataBF($id_dbf);
$id_bf = $bf[0]['ID_BF'];
$blockcon = $bf[0]['BLOCKCON'];
$kredit_dbf = $bf[0]['KREDIT_DBF'];
//Step Reset Biaya Pengiriman
$blockcon = $blockcon-$kredit_dbf;
$update = [
'BLOCKCON' => $blockcon
];
$action = $this->BankKeluar->update('biaya_fee', $update, 'ID_BF', $id_bf);
$update = [
'DBF_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_bf',$id_dbf,'ID_DBF');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDetailBP() {
$kk = $this->BankKeluar->getKodeDetailBP();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DBP/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "DBP/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailbp() {
//Step Input Detail Biaya Pengiriman
$method = $this->input->post('method');
$id_dbp = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_bp = $this->input->post('id_bp');
$kode_dbp = $this->kodeDetailBP();
if ($id_bp==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$kredit_dbp = $kbbk[0]['NOMINAL_KBBK'];
$bukti_kredit = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DBP' => $kode_dbp,
'BUKTI_KREDIT' => $bukti_kredit,
'BP_ID' => $id_bp,
'KREDIT_DBP' => $kredit_dbp,
];
$action = $this->BankKeluar->create('detail_bp', $input);
$id_dbp = $this->BankKeluar->getIDDBP();
$id_dbp = $id_dbp[0]['ID_DBP'];
$update = [
'DBP_ID' => $id_dbp
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
$blockkre = $this->BankKeluar->getBlockkreBP($id_bp);
$blockkre = $blockkre[0]['BLOCKKRE_BP']+$kredit_dbp;
$update = [
'BLOCKKRE_BP' => $blockkre
];
$action = $this->BankKeluar->update('biaya_pengiriman', $update, 'ID_BP', $id_bp);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdbp() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dbp = $this->BankKeluar->getDBPID($id);
$id_dbp = $id_dbp[0]['DBP_ID'];
$bp = $this->BankKeluar->getDataBP($id_dbp);
$id_bp = $bp[0]['ID_BP'];
$blockkre = $bp[0]['BLOCKKRE_BP'];
$kredit_dbp = $bp[0]['KREDIT_DBP'];
//Step Reset Biaya Pengiriman
$blockkre = $blockkre-$kredit_dbp;
$update = [
'BLOCKKRE_BP' => $blockkre
];
$action = $this->BankKeluar->update('biaya_pengiriman', $update, 'ID_BP', $id_bp);
$update = [
'DBP_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_bp',$id_dbp,'ID_DBP');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDetailBB() {
$kk = $this->BankKeluar->getKodeDetailBB();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DBB/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 4, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 10 - strlen($str);
$data = "DBB/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailbb() {
//Step Input Detail Biaya Bensin
$method = $this->input->post('method');
$id_dbb = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_karyawan = $this->input->post('id_karyawan');
$id_kendaraan = $this->input->post('id_kendaraan');
$kode_dbb = $this->kodeDetailBB();
if ($id_karyawan==="" OR $id_kendaraan==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_dbb = $kbbk[0]['NOMINAL_KBBK'];
$bukti_biaya = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DBB' => $kode_dbb,
'KODE_BUKTI' => $bukti_biaya,
'KENDARAAN_ID' => $id_kendaraan,
'KARYAWAN_ID' => $id_karyawan,
'NOMINAL_DBB' => $nominal_dbb
];
$action = $this->BankKeluar->create('detail_bb', $input);
$id_dbb = $this->BankKeluar->getIDDBB();
$id_dbb = $id_dbb[0]['ID_DBB'];
$update = [
'DBB_ID' => $id_dbb
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdbb() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dbb = $this->BankKeluar->getDBBID($id);
$id_dbb = $id_dbb[0]['DBB_ID'];
//Step Reset Biaya Bensin
$update = [
'DBB_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_bb',$id_dbb,'ID_DBB');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeDetailBSK() {
$kk = $this->BankKeluar->getKodeDetailBSK();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "DBSK/000001";
} else {
$str = (string) $row['KODE'];
$panjang = 6;
$data = substr($str, 5, $panjang);
$ko = (int) $data + 1;
$str = (string) $ko;
$panjang = 11 - strlen($str);
$data = "DBSK/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function detailbsk() {
//Step Input Detail Biaya Service Kendaraan
$method = $this->input->post('method');
$id_dbsk = $this->input->post('id');
$id_kbbk = $this->input->post('id_kbbk');
$id_kendaraan = $this->input->post('id_kendaraan');
$kode_dbsk = $this->kodeDetailBSK();
if ($id_kendaraan==="") {
redirect($_SERVER['HTTP_REFERER']);
}
$kbbk = $this->BankKeluar->getDataKBBK($id_kbbk);
$nominal_dbsk = $kbbk[0]['NOMINAL_KBBK'];
$bukti_biaya = $kbbk[0]['KODE_KBBK'];
$input = [
'KODE_DBSK' => $kode_dbsk,
'KODE_BUKTI' => $bukti_biaya,
'KENDARAAN_ID' => $id_kendaraan,
'NOMINAL_DBSK' => $nominal_dbsk
];
$action = $this->BankKeluar->create('detail_bsk', $input);
$id_dbsk = $this->BankKeluar->getIDDBSK();
$id_dbsk = $id_dbsk[0]['ID_DBSK'];
$update = [
'DBSK_ID' => $id_dbsk
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK',$id_kbbk);
if ($action) {
redirect($_SERVER['HTTP_REFERER']);
} else {
redirect($_SERVER['HTTP_REFERER']);
}
}
public function resetdbsk() {
$id = $this->input->post('id');
//Step Ambil Data Lama
$id_dbsk = $this->BankKeluar->getDBSKID($id);
$id_dbsk = $id_dbsk[0]['DBSK_ID'];
//Step Reset Biaya Bensin
$update = [
'DBSK_ID' => NULL
];
$action = $this->BankKeluar->update('kasbank_bk', $update, 'ID_KBBK', $id);
//Step Hapus Data
$action = $this->BankKeluar->delete('detail_bsk',$id_dbsk,'ID_DBSK');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
}
Reference in New Issue View Git Blame Copy Permalink