Files
2026-06-13 16:02:07 +10:00

1356 lines
38 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 ManageBankMasuk extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->model('ModelBankMasuk', 'MBM');
$this->load->model('ModelBank', 'MB');
$this->load->model('ModelKendaraan', 'MK');
$this->load->model('ModelKas', 'MKas');
$this->load->model('ModelKaryawan', 'MKy');
$this->load->model('ModelNeraca', 'MN');
$this->load->model('ModelPajak', 'MP');
$this->load->model('ModelPelanggan', 'MPe');
$this->load->model('ModelSupplier', 'MS');
$this->load->model('ModelTp', 'MT');
$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);
}
public function index()
{
$datBankMasuk = $this->MBM->getDataBankMasuk();
$datBank = $this->MB->getDataBank();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'bankmasuk' => $datBankMasuk,
'bank' => $datBank
];
$this->load->view('proses/BankMasuk', $data);
}
public function save()
{
$method = $this->input->post('method');
$id = $this->input->post('id_bankmasuk');
$id_bank = $this->input->post('id_bank');
$debit_bankmasuk = $this->input->post('debit_bankmasuk');
$kode_bankmasuk = $this->kodeBankMasuk();
$input = [
'KODE_BANKMASUK' => $kode_bankmasuk,
'BANK_ID' => $id_bank,
'DEBIT_BANKMASUK' => $debit_bankmasuk,
'BLOCKCON' => '0'
];
$action = $this->MBM->create('bankmasuk', $input);
if ($action) {
$this->session->set_flashdata('flash', 'ditambah');
redirect('ManageBankMasuk');
} else {
$this->session->set_flashdata('flashgagal', 'ditambah');
redirect('ManageBankMasuk');
}
}
public function edit()
{
$method = $this->input->post('method');
$id_bankmasuk = $this->input->post('id_bankmasuk');
$id_bank = $this->input->post('id_banked');
$debit_bankmasuk = $this->input->post('debit_bankmasuked');
$update = [
'BANK_ID' => $id_bank,
'DEBIT_BANKMASUK' => $debit_bankmasuk
];
$update = $this->MBM->update('bankmasuk', $update, 'ID_BANKMASUK', $id_bankmasuk);
if ($update) {
$this->session->set_flashdata('flash', 'diedit');
redirect('ManageBankMasuk');
} else {
$this->session->set_flashdata('flashgagal', 'diedit');
redirect('ManageBankMasuk');
}
}
public function hapus()
{
$id = $this->input->post('id');
$actionbankmasuk = $this->MBM->delRelasi($id);
$action = $this->MBM->delete('bankmasuk',$id,'ID_BANKMASUK');
$this->session->set_flashdata('flash', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function tambahRelasi($id)
{
$relasi = $this->MBM->getBankMasukRelasi($id);
$title = $this->MBM->getKodeDebitBankMasuk($id);
$kredit = $this->MBM->getKreditTotal($id);
$neraca = $this->MN->getDataNeraca();
$neracabiaya = $this->MN->getDataNeracaBiaya();
$neracahutang = $this->MN->getDataNeracaHutang();
$neracapiutang = $this->MN->getDataNeracaPiutang();
$bank = $this->MB->getDataBank();
$kendaraan = $this->MK->getDataKendaraan();
$karyawan = $this->MKy->getDataKaryawan();
$tp = $this->MT->getDataTp();
$pelanggan = $this->MPe->getDataPelanggan();
$pajak = $this->MP->getDataPajak();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'relasi' => $relasi,
'id_bankmasuk' => $id,
'title1' => $title[0]['KODE_BANKMASUK'],
'title2' => $title[0]['DEBIT'],
'title3' => $title[0]['KREDIT'],
'neraca' => $neraca,
'nerbiaya' => $neracabiaya,
'nerhutang' => $neracahutang,
'nerpiutang' => $neracapiutang,
'bank' => $bank,
'kendaraan' => $kendaraan,
'karyawan' => $karyawan,
'tp' => $tp,
'pelanggan' => $pelanggan,
'pajak' => $pajak
];
$this->load->view('proses/Relasi', $data);
}
public function saverelasi()
{
$method = $this->input->post('method');
$id_relasi = $this->input->post('id');
$id_bankmasuk = $this->input->post('id_bankmasuk');
$type_relasi = $this->input->post('type_relasi');
$kode_relasi = $this->kodeRelasi();
$inputrelasi = [
'DEBIT_ID' => $id_bankmasuk,
'TYPE_RELASI' => $type_relasi,
'TYPE_KASBANK' => "Bank Masuk",
'KODE_RELASI' => $kode_relasi
];
$actionrelasi = $this->MBM->create('relasi', $inputrelasi);
if ($actionrelasi) {
$this->session->set_flashdata('flashtyperelasi', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashtyperelasigagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahbiaya()
{
$method = $this->input->post('method');
$id_relasi = $this->input->post('id_relasi');
$id_neraca = $this->input->post('id_neraca');
$kredit_relasi = $this->input->post('kredit_relasi');
$keterangan_relasi = $this->input->post('keterangan_relasi');
//Step Ambil Data Lama
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$nominalbaru = $nominal+$kredit_relasi;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
//Step Update Data
$inputrelasi = [
'NERACA_ID' => $id_neraca,
'KREDIT_RELASI' => $kredit_relasi,
'KETERANGAN_RELASI' => $keterangan_relasi
];
$actionrelasi = $this->MBM->update('relasi', $inputrelasi, 'ID_RELASI', $id_relasi);
if ($actionrelasi) {
$this->session->set_flashdata('flashrelasi', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashrelasigagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahhutang()
{
$method = $this->input->post('method');
$id_relasi = $this->input->post('id_relasi');
$id_neraca = $this->input->post('id_neraca');
$kredit_relasi = $this->input->post('kredit_relasi');
$keterangan_relasi = $this->input->post('keterangan_relasi');
//Step Ambil Data Lama
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$nominalbaru = $nominal+$kredit_relasi;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
//Step Update Data
$inputrelasi = [
'NERACA_ID' => $id_neraca,
'KREDIT_RELASI' => $kredit_relasi,
'KETERANGAN_RELASI' => $keterangan_relasi
];
$actionrelasi = $this->MBM->update('relasi', $inputrelasi, 'ID_RELASI', $id_relasi);
if ($actionrelasi) {
$this->session->set_flashdata('flashrelasi', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashrelasigagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahpiutang()
{
$method = $this->input->post('method');
$id_relasi = $this->input->post('id_relasi');
$id_neraca = $this->input->post('id_neraca');
$kredit_relasi = $this->input->post('kredit_relasi');
$keterangan_relasi = $this->input->post('keterangan_relasi');
//Step Ambil Data Lama
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$nominalbaru = $nominal+$kredit_relasi;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
//Step Update Data
$inputrelasi = [
'NERACA_ID' => $id_neraca,
'KREDIT_RELASI' => $kredit_relasi,
'KETERANGAN_RELASI' => $keterangan_relasi
];
$actionrelasi = $this->MBM->update('relasi', $inputrelasi, 'ID_RELASI', $id_relasi);
if ($actionrelasi) {
$this->session->set_flashdata('flashrelasi', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashrelasigagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editbiaya()
{
$method = $this->input->post('method');
$id_relasi = $this->input->post('id_relasi');
$id_neraca = $this->input->post('id_neracaed');
$kredit_relasi = $this->input->post('kredit_relasied');
$keterangan_relasi = $this->input->post('keterangan_relasied');
//Step Ambil Data Lama
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$kredit = $blockcon[0]['KREDIT_RELASI'];
$nominalbaru = $nominal-$kredit;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
$actionlink = $this->MBM->delLink($id_relasi);
//Step Ambil Data Baru
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$nominalbaru = $nominal+$kredit_relasi;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
$updaterelasi = [
'NERACA_ID' => $id_neraca,
'KREDIT_RELASI' => $kredit_relasi,
'KETERANGAN_RELASI' => $keterangan_relasi
];
$actionrelasi = $this->MBM->update('relasi', $updaterelasi, 'ID_RELASI', $id_relasi);
if ($actionrelasi) {
$this->session->set_flashdata('flashrelasi', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashrelasigagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function edithutang()
{
$method = $this->input->post('method');
$id_relasi = $this->input->post('id_relasi');
$id_neraca = $this->input->post('id_neracaed');
$kredit_relasi = $this->input->post('kredit_relasied');
$keterangan_relasi = $this->input->post('keterangan_relasied');
//Step Ambil Data Lama
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$kredit = $blockcon[0]['KREDIT_RELASI'];
$nominalbaru = $nominal-$kredit;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
$actionlink = $this->MBM->delLink($id_relasi);
//Step Ambil Data Baru
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$nominalbaru = $nominal+$kredit_relasi;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
$updaterelasi = [
'NERACA_ID' => $id_neraca,
'KREDIT_RELASI' => $kredit_relasi,
'KETERANGAN_RELASI' => $keterangan_relasi
];
$actionrelasi = $this->MBM->update('relasi', $updaterelasi, 'ID_RELASI', $id_relasi);
if ($actionrelasi) {
$this->session->set_flashdata('flashrelasi', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashrelasigagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editpiutang()
{
$method = $this->input->post('method');
$id_relasi = $this->input->post('id_relasi');
$id_neraca = $this->input->post('id_neracaed');
$kredit_relasi = $this->input->post('kredit_relasied');
$keterangan_relasi = $this->input->post('keterangan_relasied');
//Step Ambil Data Lama
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$kredit = $blockcon[0]['KREDIT_RELASI'];
$nominalbaru = $nominal-$kredit;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
$actionlink = $this->MBM->delLink($id_relasi);
//Step Ambil Data Baru
$blockcon = $this->MBM->getBlockconBankMasuk($id_relasi);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$nominalbaru = $nominal+$kredit_relasi;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
$updaterelasi = [
'NERACA_ID' => $id_neraca,
'KREDIT_RELASI' => $kredit_relasi,
'KETERANGAN_RELASI' => $keterangan_relasi
];
$actionrelasi = $this->MBM->update('relasi', $updaterelasi, 'ID_RELASI', $id_relasi);
if ($actionrelasi) {
$this->session->set_flashdata('flashrelasi', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashrelasigagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function hapusrelasi()
{
$id = $this->input->post('id');
//Step Ambil Data Lama
$blockcon = $this->MBM->getBlockconBankMasuk($id);
$id_bankmasuk = $blockcon[0]['ID_BANKMASUK'];
$nominal = $blockcon[0]['BLOCKCON'];
$kredit = $blockcon[0]['KREDIT_RELASI'];
$nominalbaru = $nominal-$kredit;
$updatebankmasuk = [
'BLOCKCON' => $nominalbaru
];
$actionbankmasuk = $this->MBM->update('bankmasuk', $updatebankmasuk, 'ID_BANKMASUK', $id_bankmasuk);
//Step Hapus Data
$actionrelasi = $this->MBM->delLink($id);
$action = $this->MBM->delete('relasi',$id,'ID_RELASI');
$this->session->set_flashdata('flashrelasi', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function tambahLink($id)
{
$link = $this->MBM->getRelasiLink($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$bank = $this->MB->getDataBank();
$karyawan = $this->MKy->getDataKaryawan();
$kas = $this->MKas->getDataKas();
$kendaraan = $this->MK->getDataKendaraan();
$pajak = $this->MP->getDataPajak();
$pelanggan = $this->MPe->getDataPelanggan();
$tp = $this->MT->getDataTp();
$supplier = $this->MS->getDataSupplier();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'bank' => $bank,
'karyawan' => $karyawan,
'kas' => $kas,
'kendaraan' => $kendaraan,
'pajak' => $pajak,
'pelanggan' => $pelanggan,
'tp' => $tp,
'supplier' => $supplier
];
$this->load->view('proses/Link', $data);
}
public function tambahLinkBank($id)
{
$link = $this->MBM->getRelasiLinkBank($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$bank = $this->MB->getDataBank();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'bank' => $bank
];
$this->load->view('proses/LinkBank', $data);
}
public function tambahLinkKaryawan($id)
{
$link = $this->MBM->getRelasiLinkKaryawan($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$karyawan = $this->MKy->getDataKaryawan();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'karyawan' => $karyawan
];
$this->load->view('proses/LinkKaryawan', $data);
}
public function tambahLinkKas($id)
{
$link = $this->MBM->getRelasiLinkKas($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$kas = $this->MKas->getDataKas();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'kas' => $kas
];
$this->load->view('proses/LinkKas', $data);
}
public function tambahLinkKendaraan($id)
{
$link = $this->MBM->getRelasiLinkKendaraan($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$kendaraan = $this->MK->getDataKendaraan();
$karyawan = $this->MKy->getDataKaryawan();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'kendaraan' => $kendaraan,
'karyawan' => $karyawan
];
$this->load->view('proses/LinkKendaraan', $data);
}
public function tambahLinkPajak($id)
{
$link = $this->MBM->getRelasiLinkPajak($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$pajak = $this->MP->getDataPajak();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'pajak' => $pajak
];
$this->load->view('proses/LinkPajak', $data);
}
public function tambahLinkPelanggan($id)
{
$link = $this->MBM->getRelasiLinkPelanggan($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$pelanggan = $this->MPe->getDataPelanggan();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'pelanggan' => $pelanggan
];
$this->load->view('proses/LinkPelanggan', $data);
}
public function tambahLinkPihakKe3($id)
{
$link = $this->MBM->getRelasiLinkPihakKe3($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$tp = $this->MT->getDataTp();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'tp' => $tp
];
$this->load->view('proses/LinkPihakKe3', $data);
}
public function tambahLinkSupplier($id)
{
$link = $this->MBM->getRelasiLinkSupplier($id);
$title = $this->MBM->getKodeKreditRelasi($id);
$supplier = $this->MS->getDataSupplier();
$data = [
'sidebar' => "menu accounting",
'navChild' => "",
'link' => $link,
'id_relasi' => $id,
'title1' => $title[0]['KODE_RELASI'],
'title2' => $title[0]['KREDIT'],
'title3' => $title[0]['TARGET1_ID'],
'supplier' => $supplier
];
$this->load->view('proses/LinkSupplier', $data);
}
public function savelink()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$type_link = $this->input->post('type_link');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TYPE_LINK' => $type_link,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashtypelink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashtypelinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahbank()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_bank = $this->input->post('id_bank');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_bank,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Bank",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahkaryawan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_karyawan = $this->input->post('id_karyawan');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_karyawan,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Karyawan",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahkas()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_kas = $this->input->post('id_kas');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_kas,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Kas",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahkendaraan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_kendaraan = $this->input->post('id_kendaraan');
$id_karyawan = $this->input->post('id_karyawan');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_kendaraan,
'TARGET2_ID' => $id_karyawan,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Kendaraan",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahpajak()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_pajak = $this->input->post('id_pajak');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_pajak,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Pajak",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahpelanggan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_pelanggan = $this->input->post('id_pelanggan');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_pelanggan,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Pelanggan",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahpihakke3()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_tp = $this->input->post('id_tp');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_tp,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Pihak Ke3",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function tambahsupplier()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id');
$id_relasi = $this->input->post('id_relasi');
$id_supplier = $this->input->post('id_supplier');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_supplier,
'KODE_LINK' => $kode_link,
'TYPE_LINK' => "Supplier",
];
$actionlink = $this->MBM->create('link', $inputlink);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linkbank()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_bank = $this->input->post('id_bank');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_bank,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linkkaryawan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_karyawan = $this->input->post('id_karyawan');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_karyawan,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linkkas()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_kas = $this->input->post('id_kas');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_kas,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linkkendaraan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_kendaraan = $this->input->post('id_kendaraan');
$id_karyawan = $this->input->post('id_karyawan');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_kendaraan,
'TARGET2_ID' => $id_karyawan,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linkpajak()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_pajak = $this->input->post('id_pajak');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_pajak,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linkpelanggan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_pelanggan = $this->input->post('id_pelanggan');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_pelanggan,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linkpihakke3()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_tp = $this->input->post('id_tp');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_tp,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function linksupplier()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_relasi = $this->input->post('id_relasi');
$id_supplier = $this->input->post('id_supplier');
$kode_link = $this->kodeLink();
$inputlink = [
'RELASI_ID' => $id_relasi,
'TARGET1_ID' => $id_supplier,
'KODE_LINK' => $kode_link
];
$actionlink = $this->MBM->update('link', $inputlink,'ID_LINK',$id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'ditambah');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editbank()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_bank = $this->input->post('id_banked');
$updatelink = [
'TARGET1_ID' => $id_bank
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editkaryawan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_karyawan = $this->input->post('id_karyawaned');
$updatelink = [
'TARGET1_ID' => $id_karyawan
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editkas()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_kas = $this->input->post('id_kased');
$updatelink = [
'TARGET1_ID' => $id_kas
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editkendaraan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_kendaraan = $this->input->post('id_kendaraaned');
$id_karyawan = $this->input->post('id_karyawaned');
$updatelink = [
'TARGET1_ID' => $id_kendaraan,
'TARGET2_ID' => $id_karyawan
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editpajak()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_pajak = $this->input->post('id_pajaked');
$updatelink = [
'TARGET1_ID' => $id_pajak
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editpelanggan()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_pelanggan = $this->input->post('id_pelangganed');
$updatelink = [
'TARGET1_ID' => $id_pelanggan
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editpihakke3()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_tp = $this->input->post('id_tped');
$updatelink = [
'TARGET1_ID' => $id_tp
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function editsupplier()
{
$method = $this->input->post('method');
$id_link = $this->input->post('id_link');
$id_supplier = $this->input->post('id_suppliered');
$updatelink = [
'TARGET1_ID' => $id_supplier
];
$actionlink = $this->MBM->update('link', $updatelink, 'ID_LINK', $id_link);
if ($actionlink) {
$this->session->set_flashdata('flashlink', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
} else {
$this->session->set_flashdata('flashlinkgagal', 'diedit');
redirect($_SERVER['HTTP_REFERER']);
}
}
public function hapuslink()
{
$id = $this->input->post('id');
//Step Hapus Data
$action = $this->MBM->delete('link',$id,'ID_LINK');
$this->session->set_flashdata('flashlink', 'dihapus');
redirect($_SERVER['HTTP_REFERER']);
}
public function kodeBankMasuk()
{
$kk = $this->MBM->getKodeBankMasuk();
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 kodeRelasi()
{
$kk = $this->MBM->getKodeRelasi();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "REL/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 = "REL/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function kodeLink()
{
$kk = $this->MBM->getKodeLink();
if (is_array($kk) || is_object($kk)) {
foreach ($kk as $row) {
if ($row['KODE'] == null) {
return "LIN/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 = "LIN/000000";
$data = substr($data, 0, $panjang) . $str;
return $data;
}
}
}
}
public function konfirmasi()
{
$method = $this->input->post('method');
$id_bankmasuk = $this->input->post('id_bankmasuk');
$update = [
'STATUS_BANKMASUK' => "KASBANK SUDAH PROSES"
];
$action = $this->MBM->update('bankmasuk', $update, 'ID_BANKMASUK', $id_bankmasuk);
if ($action) {
$this->session->set_flashdata('flash', 'dikonfirmasi');
redirect('ManageBankMasuk');
} else {
$this->session->set_flashdata('flashgagal', 'dikonfirmasi');
redirect('ManageBankMasuk');
}
}
}