1708 lines
50 KiB
PHP
1708 lines
50 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 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']);
|
|
}
|
|
|
|
}
|