1603 lines
50 KiB
PHP
1603 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 ManageSetKasbank extends CI_Controller
|
|
{
|
|
function __construct()
|
|
{
|
|
parent::__construct();
|
|
$this->load->model('ModelSetKasbank', 'SetKasbank');
|
|
$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, Create Set Kasbank
|
|
public function index() {
|
|
|
|
$datSetKasbank = $this->SetKasbank->getDataSetKasbank();
|
|
$id = $this->SetKasbank->getIDSETKASBANK();
|
|
$data = [
|
|
'sidebar' => "set data",
|
|
'navChild' => "",
|
|
'setkasbank' => $datSetKasbank,
|
|
'id' => $id[0]['ID_SETKASBANK']
|
|
];
|
|
|
|
$this->load->view('proses/SetKasbank', $data);
|
|
}
|
|
|
|
public function kodeSetKasbank() {
|
|
$kk = $this->SetKasbank->getKodeSetKasbank();
|
|
if (is_array($kk) || is_object($kk)) {
|
|
foreach ($kk as $row) {
|
|
if ($row['KODE'] == null) {
|
|
return "SK/000001";
|
|
} else {
|
|
$str = (string) $row['KODE'];
|
|
$panjang = 6;
|
|
$data = substr($str, 3, $panjang);
|
|
|
|
$ko = (int) $data + 1;
|
|
$str = (string) $ko;
|
|
|
|
$panjang = 9 - strlen($str);
|
|
$data = "SK/000000";
|
|
$data = substr($data, 0, $panjang) . $str;
|
|
return $data;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
public function saveawal() {
|
|
$method = $this->input->post('method');
|
|
$id = $this->input->post('id_setkasbank');
|
|
$kode_setkasbank = $this->kodeSetKasbank();
|
|
|
|
$input = [
|
|
'KODE_SETKASBANK' => $kode_setkasbank
|
|
];
|
|
$action = $this->SetKasbank->create('setkasbank', $input);
|
|
$setkasbank = $this->SetKasbank->getIDSETKASBANK();
|
|
$id_setkasbank = $setkasbank[0]['ID_SETKASBANK'];
|
|
|
|
|
|
$neraca1110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '1',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '2',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '3',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1140 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '4',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1150 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '5',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1160 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '6',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1170 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '7',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1180 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '8',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1210 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '9',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1211 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '10',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1220 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '11',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1221 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '12',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1230 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '13',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca1231 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '14',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca2110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '15',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca2120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '16',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca2130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '17',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca2140 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '18',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca2150 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '19',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca3100 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '20',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca3200 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '21',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca3210 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '22',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca4110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '23',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca4120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '24',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca4130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '25',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '26',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '27',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5121 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '28',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5122 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '29',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '30',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6101 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '31',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6102 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '32',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6103 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '33',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6104 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '34',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6105 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '35',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6106 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '36',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6107 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '37',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6201 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '38',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6202 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '39',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6203 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '40',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6204 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '41',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6205 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '42',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6206 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '43',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6207 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '44',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6208 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '45',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6209 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '46',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6210 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '47',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6211 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '48',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6212 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '49',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6213 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '50',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6214 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '51',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6215 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '52',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6216 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '53',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6217 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '54',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6218 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '55',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6219 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '56',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6220 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '57',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6221 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '58',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6222 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '59',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6223 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '60',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6224 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '61',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6225 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '62',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6226 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '63',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6227 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '64',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6228 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '65',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6229 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '66',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6230 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '67',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6231 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '68',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6232 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '69',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6233 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '70',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6234 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '71',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6235 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '72',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6236 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '73',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6237 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '74',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7100 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '75',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7200 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '76',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7300 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '77',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7400 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '78',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
|
|
$action = $this->SetKasbank->create('neraca', $neraca1110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1140);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1150);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1160);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1170);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1180);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1210);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1211);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1220);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1221);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1230);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1231);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2140);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2150);
|
|
$action = $this->SetKasbank->create('neraca', $neraca3100);
|
|
$action = $this->SetKasbank->create('neraca', $neraca3200);
|
|
$action = $this->SetKasbank->create('neraca', $neraca3210);
|
|
$action = $this->SetKasbank->create('neraca', $neraca4110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca4120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca4130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5121);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5122);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6101);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6102);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6103);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6104);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6105);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6106);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6107);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6201);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6202);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6203);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6204);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6205);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6206);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6207);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6208);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6209);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6210);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6211);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6212);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6213);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6214);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6215);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6216);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6217);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6218);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6219);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6220);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6221);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6222);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6223);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6224);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6225);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6226);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6227);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6228);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6229);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6230);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6231);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6232);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6233);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6234);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6235);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6236);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6237);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7100);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7200);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7300);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7400);
|
|
|
|
$totalneraca01 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Aktiva Lancar",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca02 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Aktiva Tetap",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca03 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Aktiva",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca04 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Kewajiban Lancar",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca05 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Modal",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca06 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Pasiva",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca07 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Penjualan",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca08 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Harga Pokok Jual",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca09 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Kotor",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca10 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Biaya",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca11 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Usaha",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca12 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Luar Usaha",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca13 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Bersih Sebelum Pajak",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca14 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Bersih Setelah Pajak",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca01);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca02);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca03);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca04);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca05);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca06);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca07);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca08);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca09);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca10);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca11);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca12);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca13);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca14);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('flash', 'ditambah');
|
|
redirect('ManageSetKasbank');
|
|
} else {
|
|
$this->session->set_flashdata('flashgagal', 'ditambah');
|
|
redirect('ManageSetKasbank');
|
|
}
|
|
|
|
}
|
|
|
|
public function kunci() {
|
|
$method = $this->input->post('method');
|
|
$id_setdata = $this->input->post('id_setdata');
|
|
$kode_setdata = $this->kodeSetKasbank();
|
|
|
|
//Get Data
|
|
$dataset01 = $this->SetKasbank->getNilai1110($id_setdata);
|
|
$dataset02 = $this->SetKasbank->getNilai1120($id_setdata);
|
|
$dataset03 = $this->SetKasbank->getNilai1130($id_setdata);
|
|
$dataset04 = $this->SetKasbank->getNilai1140($id_setdata);
|
|
$dataset05 = $this->SetKasbank->getNilai1150($id_setdata);
|
|
$dataset06 = $this->SetKasbank->getNilai1160($id_setdata);
|
|
$dataset07 = $this->SetKasbank->getNilai1170($id_setdata);
|
|
$dataset08 = $this->SetKasbank->getNilai1180($id_setdata);
|
|
$dataset09 = $this->SetKasbank->getNilai1210($id_setdata);
|
|
$dataset10 = $this->SetKasbank->getNilai1211($id_setdata);
|
|
$dataset11 = $this->SetKasbank->getNilai1220($id_setdata);
|
|
$dataset12 = $this->SetKasbank->getNilai1221($id_setdata);
|
|
$dataset13 = $this->SetKasbank->getNilai1230($id_setdata);
|
|
$dataset14 = $this->SetKasbank->getNilai1231($id_setdata);
|
|
$dataset15 = $this->SetKasbank->getNilai2110($id_setdata);
|
|
$dataset16 = $this->SetKasbank->getNilai2120($id_setdata);
|
|
$dataset17 = $this->SetKasbank->getNilai2130($id_setdata);
|
|
$dataset18 = $this->SetKasbank->getNilai2140($id_setdata);
|
|
$dataset19 = $this->SetKasbank->getNilai2150($id_setdata);
|
|
$dataset20 = $this->SetKasbank->getNilai3100($id_setdata);
|
|
$dataset21 = $this->SetKasbank->getNilai3200($id_setdata);
|
|
$dataset22 = $this->SetKasbank->getNilai3210($id_setdata);
|
|
$dataset23 = $this->SetKasbank->getNilai4110($id_setdata);
|
|
$dataset24 = $this->SetKasbank->getNilai4120($id_setdata);
|
|
$dataset25 = $this->SetKasbank->getNilai4130($id_setdata);
|
|
$dataset26 = $this->SetKasbank->getNilai5110($id_setdata);
|
|
$dataset27 = $this->SetKasbank->getNilai5120($id_setdata);
|
|
$dataset28 = $this->SetKasbank->getNilai5121($id_setdata);
|
|
$dataset29 = $this->SetKasbank->getNilai5122($id_setdata);
|
|
$dataset30 = $this->SetKasbank->getNilai5130($id_setdata);
|
|
$dataset31 = $this->SetKasbank->getNilai6101($id_setdata);
|
|
$dataset32 = $this->SetKasbank->getNilai6102($id_setdata);
|
|
$dataset33 = $this->SetKasbank->getNilai6103($id_setdata);
|
|
$dataset34 = $this->SetKasbank->getNilai6104($id_setdata);
|
|
$dataset35 = $this->SetKasbank->getNilai6105($id_setdata);
|
|
$dataset36 = $this->SetKasbank->getNilai6106($id_setdata);
|
|
$dataset37 = $this->SetKasbank->getNilai6107($id_setdata);
|
|
$dataset38 = $this->SetKasbank->getNilai6201($id_setdata);
|
|
$dataset39 = $this->SetKasbank->getNilai6202($id_setdata);
|
|
$dataset40 = $this->SetKasbank->getNilai6203($id_setdata);
|
|
$dataset41 = $this->SetKasbank->getNilai6204($id_setdata);
|
|
$dataset42 = $this->SetKasbank->getNilai6205($id_setdata);
|
|
$dataset43 = $this->SetKasbank->getNilai6206($id_setdata);
|
|
$dataset44 = $this->SetKasbank->getNilai6207($id_setdata);
|
|
$dataset45 = $this->SetKasbank->getNilai6208($id_setdata);
|
|
$dataset46 = $this->SetKasbank->getNilai6209($id_setdata);
|
|
$dataset47 = $this->SetKasbank->getNilai6210($id_setdata);
|
|
$dataset48 = $this->SetKasbank->getNilai6211($id_setdata);
|
|
$dataset49 = $this->SetKasbank->getNilai6212($id_setdata);
|
|
$dataset50 = $this->SetKasbank->getNilai6213($id_setdata);
|
|
$dataset51 = $this->SetKasbank->getNilai6214($id_setdata);
|
|
$dataset52 = $this->SetKasbank->getNilai6215($id_setdata);
|
|
$dataset53 = $this->SetKasbank->getNilai6216($id_setdata);
|
|
$dataset54 = $this->SetKasbank->getNilai6217($id_setdata);
|
|
$dataset55 = $this->SetKasbank->getNilai6218($id_setdata);
|
|
$dataset56 = $this->SetKasbank->getNilai6219($id_setdata);
|
|
$dataset57 = $this->SetKasbank->getNilai6220($id_setdata);
|
|
$dataset58 = $this->SetKasbank->getNilai6221($id_setdata);
|
|
$dataset59 = $this->SetKasbank->getNilai6222($id_setdata);
|
|
$dataset60 = $this->SetKasbank->getNilai6223($id_setdata);
|
|
$dataset61 = $this->SetKasbank->getNilai6224($id_setdata);
|
|
$dataset62 = $this->SetKasbank->getNilai6225($id_setdata);
|
|
$dataset63 = $this->SetKasbank->getNilai6226($id_setdata);
|
|
$dataset64 = $this->SetKasbank->getNilai6227($id_setdata);
|
|
$dataset65 = $this->SetKasbank->getNilai6228($id_setdata);
|
|
$dataset66 = $this->SetKasbank->getNilai6229($id_setdata);
|
|
$dataset67 = $this->SetKasbank->getNilai6230($id_setdata);
|
|
$dataset68 = $this->SetKasbank->getNilai6231($id_setdata);
|
|
$dataset69 = $this->SetKasbank->getNilai6233($id_setdata);
|
|
$dataset70 = $this->SetKasbank->getNilai6233($id_setdata);
|
|
$dataset71 = $this->SetKasbank->getNilai6234($id_setdata);
|
|
$dataset72 = $this->SetKasbank->getNilai6235($id_setdata);
|
|
$dataset73 = $this->SetKasbank->getNilai6236($id_setdata);
|
|
$dataset74 = $this->SetKasbank->getNilai6237($id_setdata);
|
|
$dataset75 = $this->SetKasbank->getNilai7100($id_setdata);
|
|
$dataset76 = $this->SetKasbank->getNilai7200($id_setdata);
|
|
$dataset77 = $this->SetKasbank->getNilai7300($id_setdata);
|
|
$dataset78 = $this->SetKasbank->getNilai7400($id_setdata);
|
|
|
|
//Set Data
|
|
$dataset01 = $dataset01[0]['NILAI_NERACA'];
|
|
$dataset02 = $dataset02[0]['NILAI_NERACA'];
|
|
$dataset03 = $dataset03[0]['NILAI_NERACA'];
|
|
$dataset04 = $dataset04[0]['NILAI_NERACA'];
|
|
$dataset05 = $dataset05[0]['NILAI_NERACA'];
|
|
$dataset06 = $dataset06[0]['NILAI_NERACA'];
|
|
$dataset07 = $dataset07[0]['NILAI_NERACA'];
|
|
$dataset08 = $dataset08[0]['NILAI_NERACA'];
|
|
$dataset09 = $dataset09[0]['NILAI_NERACA'];
|
|
$dataset10 = $dataset10[0]['NILAI_NERACA'];
|
|
$dataset11 = $dataset11[0]['NILAI_NERACA'];
|
|
$dataset12 = $dataset12[0]['NILAI_NERACA'];
|
|
$dataset13 = $dataset13[0]['NILAI_NERACA'];
|
|
$dataset14 = $dataset14[0]['NILAI_NERACA'];
|
|
$dataset15 = $dataset15[0]['NILAI_NERACA'];
|
|
$dataset16 = $dataset16[0]['NILAI_NERACA'];
|
|
$dataset17 = $dataset17[0]['NILAI_NERACA'];
|
|
$dataset18 = $dataset18[0]['NILAI_NERACA'];
|
|
$dataset19 = $dataset19[0]['NILAI_NERACA'];
|
|
$dataset20 = $dataset20[0]['NILAI_NERACA'];
|
|
$dataset21 = $dataset21[0]['NILAI_NERACA'];
|
|
$dataset22 = $dataset22[0]['NILAI_NERACA'];
|
|
$dataset23 = $dataset23[0]['NILAI_NERACA'];
|
|
$dataset24 = $dataset24[0]['NILAI_NERACA'];
|
|
$dataset25 = $dataset25[0]['NILAI_NERACA'];
|
|
$dataset26 = $dataset26[0]['NILAI_NERACA'];
|
|
$dataset27 = $dataset27[0]['NILAI_NERACA'];
|
|
$dataset28 = $dataset28[0]['NILAI_NERACA'];
|
|
$dataset29 = $dataset29[0]['NILAI_NERACA'];
|
|
$dataset30 = $dataset30[0]['NILAI_NERACA'];
|
|
$dataset31 = $dataset31[0]['NILAI_NERACA'];
|
|
$dataset32 = $dataset32[0]['NILAI_NERACA'];
|
|
$dataset33 = $dataset33[0]['NILAI_NERACA'];
|
|
$dataset34 = $dataset34[0]['NILAI_NERACA'];
|
|
$dataset35 = $dataset35[0]['NILAI_NERACA'];
|
|
$dataset36 = $dataset36[0]['NILAI_NERACA'];
|
|
$dataset37 = $dataset37[0]['NILAI_NERACA'];
|
|
$dataset38 = $dataset38[0]['NILAI_NERACA'];
|
|
$dataset39 = $dataset39[0]['NILAI_NERACA'];
|
|
$dataset40 = $dataset40[0]['NILAI_NERACA'];
|
|
$dataset41 = $dataset41[0]['NILAI_NERACA'];
|
|
$dataset42 = $dataset42[0]['NILAI_NERACA'];
|
|
$dataset43 = $dataset43[0]['NILAI_NERACA'];
|
|
$dataset44 = $dataset44[0]['NILAI_NERACA'];
|
|
$dataset45 = $dataset45[0]['NILAI_NERACA'];
|
|
$dataset46 = $dataset46[0]['NILAI_NERACA'];
|
|
$dataset47 = $dataset47[0]['NILAI_NERACA'];
|
|
$dataset48 = $dataset48[0]['NILAI_NERACA'];
|
|
$dataset49 = $dataset49[0]['NILAI_NERACA'];
|
|
$dataset50 = $dataset50[0]['NILAI_NERACA'];
|
|
$dataset51 = $dataset51[0]['NILAI_NERACA'];
|
|
$dataset52 = $dataset52[0]['NILAI_NERACA'];
|
|
$dataset53 = $dataset53[0]['NILAI_NERACA'];
|
|
$dataset54 = $dataset54[0]['NILAI_NERACA'];
|
|
$dataset55 = $dataset55[0]['NILAI_NERACA'];
|
|
$dataset56 = $dataset56[0]['NILAI_NERACA'];
|
|
$dataset57 = $dataset57[0]['NILAI_NERACA'];
|
|
$dataset58 = $dataset58[0]['NILAI_NERACA'];
|
|
$dataset59 = $dataset59[0]['NILAI_NERACA'];
|
|
$dataset60 = $dataset60[0]['NILAI_NERACA'];
|
|
$dataset61 = $dataset61[0]['NILAI_NERACA'];
|
|
$dataset62 = $dataset62[0]['NILAI_NERACA'];
|
|
$dataset63 = $dataset63[0]['NILAI_NERACA'];
|
|
$dataset64 = $dataset64[0]['NILAI_NERACA'];
|
|
$dataset65 = $dataset65[0]['NILAI_NERACA'];
|
|
$dataset66 = $dataset66[0]['NILAI_NERACA'];
|
|
$dataset67 = $dataset67[0]['NILAI_NERACA'];
|
|
$dataset68 = $dataset68[0]['NILAI_NERACA'];
|
|
$dataset69 = $dataset69[0]['NILAI_NERACA'];
|
|
$dataset70 = $dataset70[0]['NILAI_NERACA'];
|
|
$dataset71 = $dataset71[0]['NILAI_NERACA'];
|
|
$dataset72 = $dataset72[0]['NILAI_NERACA'];
|
|
$dataset73 = $dataset73[0]['NILAI_NERACA'];
|
|
$dataset74 = $dataset74[0]['NILAI_NERACA'];
|
|
$dataset75 = $dataset75[0]['NILAI_NERACA'];
|
|
$dataset76 = $dataset76[0]['NILAI_NERACA'];
|
|
$dataset77 = $dataset77[0]['NILAI_NERACA'];
|
|
$dataset78 = $dataset78[0]['NILAI_NERACA'];
|
|
|
|
$total01 = $this->SetKasbank->getTotalAktivaLancar($id_setdata);
|
|
$total02 = $this->SetKasbank->getTotalAktivaTetap($id_setdata);
|
|
$total03 = $this->SetKasbank->getTotalAktiva($id_setdata);
|
|
$total04 = $this->SetKasbank->getTotalKewajibanLancar($id_setdata);
|
|
$total05 = $this->SetKasbank->getTotalModal($id_setdata);
|
|
$total06 = $this->SetKasbank->getTotalPasiva($id_setdata);
|
|
$total07 = $this->SetKasbank->getTotalPenjualan($id_setdata);
|
|
$total08 = $this->SetKasbank->getTotalHargaPokokJual($id_setdata);
|
|
$total09 = $this->SetKasbank->getTotalLabaKotor($id_setdata);
|
|
$total10 = $this->SetKasbank->getTotalBiaya($id_setdata);
|
|
$total11 = $this->SetKasbank->getTotalLabaUsaha($id_setdata);
|
|
$total12 = $this->SetKasbank->getTotalLuarUsaha($id_setdata);
|
|
$total13 = $this->SetKasbank->getTotalLabaBersihSebelumPajak($id_setdata);
|
|
$total14 = $this->SetKasbank->getTotalLabaBersihSetelahPajak($id_setdata);
|
|
|
|
$total01 = $total01[0]['ID_TOTALNERACA'];
|
|
$total02 = $total02[0]['ID_TOTALNERACA'];
|
|
$total03 = $total03[0]['ID_TOTALNERACA'];
|
|
$total04 = $total04[0]['ID_TOTALNERACA'];
|
|
$total05 = $total05[0]['ID_TOTALNERACA'];
|
|
$total06 = $total06[0]['ID_TOTALNERACA'];
|
|
$total07 = $total07[0]['ID_TOTALNERACA'];
|
|
$total08 = $total08[0]['ID_TOTALNERACA'];
|
|
$total09 = $total09[0]['ID_TOTALNERACA'];
|
|
$total10 = $total10[0]['ID_TOTALNERACA'];
|
|
$total11 = $total11[0]['ID_TOTALNERACA'];
|
|
$total12 = $total12[0]['ID_TOTALNERACA'];
|
|
$total13 = $total13[0]['ID_TOTALNERACA'];
|
|
$total14 = $total14[0]['ID_TOTALNERACA'];
|
|
|
|
$aktivalancar = $dataset01+$dataset02+$dataset03+$dataset04+$dataset05+$dataset06+$dataset07+$dataset08;
|
|
$aktivatetap = $dataset09+$dataset10+$dataset11+$dataset12+$dataset13+$dataset14;
|
|
$totalaktiva = $aktivalancar+$aktivatetap;
|
|
$kewajibanlancar = $dataset15+$dataset16+$dataset17+$dataset18+$dataset19;
|
|
$modal = $dataset20+$dataset21+$dataset22;
|
|
$totalpasiva = $kewajibanlancar+$modal;
|
|
$totalpenjualan = $dataset23-$dataset24-$dataset25;
|
|
$hargapokokjual = $dataset26+$dataset27-$dataset28-$dataset29-$dataset30;
|
|
$labakotor = $totalpenjualan-$hargapokokjual;
|
|
$totalbiaya1 = $dataset31+$dataset32+$dataset33+$dataset34+$dataset35+$dataset36+$dataset37+$dataset38+$dataset39+$dataset40;
|
|
$totalbiaya2 = $dataset41+$dataset42+$dataset43+$dataset44+$dataset45+$dataset46+$dataset47+$dataset48+$dataset49+$dataset50;
|
|
$totalbiaya3 = $dataset51+$dataset52+$dataset53+$dataset54+$dataset55+$dataset56+$dataset57+$dataset58+$dataset59+$dataset60;
|
|
$totalbiaya4 = $dataset61+$dataset62+$dataset63+$dataset64+$dataset65+$dataset66+$dataset67+$dataset68+$dataset69+$dataset70;
|
|
$totalbiaya5 = $dataset71+$dataset72+$dataset73+$dataset74;
|
|
$totalbiaya = $totalbiaya1+$totalbiaya2+$totalbiaya3+$totalbiaya4+$totalbiaya5;
|
|
$labausaha = $labakotor-$totalbiaya;
|
|
$luarusaha = $dataset75+$dataset76-$dataset77;
|
|
$lababersihbefore = $labausaha+$luarusaha;
|
|
$lababersihafter = $lababersihbefore-$dataset78;
|
|
$akumulasi = $lababersihafter+$dataset21;
|
|
|
|
$update01 = [
|
|
'NILAI_TOTALNERACA' => $aktivalancar
|
|
];
|
|
$update02 = [
|
|
'NILAI_TOTALNERACA' => $aktivatetap
|
|
];
|
|
$update03 = [
|
|
'NILAI_TOTALNERACA' => $totalaktiva
|
|
];
|
|
$update04 = [
|
|
'NILAI_TOTALNERACA' => $kewajibanlancar
|
|
];
|
|
$update05 = [
|
|
'NILAI_TOTALNERACA' => $modal
|
|
];
|
|
$update06 = [
|
|
'NILAI_TOTALNERACA' => $totalpasiva
|
|
];
|
|
$update07 = [
|
|
'NILAI_TOTALNERACA' => $totalpenjualan
|
|
];
|
|
$update08 = [
|
|
'NILAI_TOTALNERACA' => $hargapokokjual
|
|
];
|
|
$update09 = [
|
|
'NILAI_TOTALNERACA' => $labakotor
|
|
];
|
|
$update10 = [
|
|
'NILAI_TOTALNERACA' => $totalbiaya
|
|
];
|
|
$update11 = [
|
|
'NILAI_TOTALNERACA' => $labausaha
|
|
];
|
|
$update12 = [
|
|
'NILAI_TOTALNERACA' => $luarusaha
|
|
];
|
|
$update13 = [
|
|
'NILAI_TOTALNERACA' => $lababersihbefore
|
|
];
|
|
$update14 = [
|
|
'NILAI_TOTALNERACA' => $lababersihafter
|
|
];
|
|
|
|
$action = $this->SetKasbank->update('totalneraca', $update01, 'ID_TOTALNERACA', $total01);
|
|
$action = $this->SetKasbank->update('totalneraca', $update02, 'ID_TOTALNERACA', $total02);
|
|
$action = $this->SetKasbank->update('totalneraca', $update03, 'ID_TOTALNERACA', $total03);
|
|
$action = $this->SetKasbank->update('totalneraca', $update04, 'ID_TOTALNERACA', $total04);
|
|
$action = $this->SetKasbank->update('totalneraca', $update05, 'ID_TOTALNERACA', $total05);
|
|
$action = $this->SetKasbank->update('totalneraca', $update06, 'ID_TOTALNERACA', $total06);
|
|
$action = $this->SetKasbank->update('totalneraca', $update07, 'ID_TOTALNERACA', $total07);
|
|
$action = $this->SetKasbank->update('totalneraca', $update08, 'ID_TOTALNERACA', $total08);
|
|
$action = $this->SetKasbank->update('totalneraca', $update09, 'ID_TOTALNERACA', $total09);
|
|
$action = $this->SetKasbank->update('totalneraca', $update10, 'ID_TOTALNERACA', $total10);
|
|
$action = $this->SetKasbank->update('totalneraca', $update11, 'ID_TOTALNERACA', $total11);
|
|
$action = $this->SetKasbank->update('totalneraca', $update12, 'ID_TOTALNERACA', $total12);
|
|
$action = $this->SetKasbank->update('totalneraca', $update13, 'ID_TOTALNERACA', $total13);
|
|
$action = $this->SetKasbank->update('totalneraca', $update14, 'ID_TOTALNERACA', $total14);
|
|
|
|
$update = [
|
|
'STATUS_SETDATA' => '0'
|
|
];
|
|
$action = $this->SetKasbank->update('setdata', $update, 'ID_SETDATA', $id_setdata);
|
|
|
|
$input = [
|
|
'KODE_SETDATA' => $kode_setdata
|
|
];
|
|
$action = $this->SetKasbank->create('setdata', $input);
|
|
$setdata = $this->SetKasbank->getIDSETDATA();
|
|
$id_setdata = $setdata[0]['ID_SETDATA'];
|
|
|
|
$neraca1110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '1',
|
|
'NILAI_NERACA' => $dataset01
|
|
];
|
|
$neraca1120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '2',
|
|
'NILAI_NERACA' => $dataset02
|
|
];
|
|
$neraca1130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '3',
|
|
'NILAI_NERACA' => $dataset03
|
|
];
|
|
$neraca1140 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '4',
|
|
'NILAI_NERACA' => $dataset04
|
|
];
|
|
$neraca1150 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '5',
|
|
'NILAI_NERACA' => $dataset05
|
|
];
|
|
$neraca1160 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '6',
|
|
'NILAI_NERACA' => $dataset06
|
|
];
|
|
$neraca1170 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '7',
|
|
'NILAI_NERACA' => $dataset07
|
|
];
|
|
$neraca1180 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '8',
|
|
'NILAI_NERACA' => $dataset08
|
|
];
|
|
$neraca1210 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '9',
|
|
'NILAI_NERACA' => $dataset09
|
|
];
|
|
$neraca1211 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '10',
|
|
'NILAI_NERACA' => $dataset10
|
|
];
|
|
$neraca1220 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '11',
|
|
'NILAI_NERACA' => $dataset11
|
|
];
|
|
$neraca1221 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '12',
|
|
'NILAI_NERACA' => $dataset12
|
|
];
|
|
$neraca1230 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '13',
|
|
'NILAI_NERACA' => $dataset13
|
|
];
|
|
$neraca1231 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '14',
|
|
'NILAI_NERACA' => $dataset14
|
|
];
|
|
$neraca2110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '15',
|
|
'NILAI_NERACA' => $dataset15
|
|
];
|
|
$neraca2120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '16',
|
|
'NILAI_NERACA' => $dataset16
|
|
];
|
|
$neraca2130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '17',
|
|
'NILAI_NERACA' => $dataset17
|
|
];
|
|
$neraca2140 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '18',
|
|
'NILAI_NERACA' => $dataset18
|
|
];
|
|
$neraca2150 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '19',
|
|
'NILAI_NERACA' => $dataset19
|
|
];
|
|
$neraca3100 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '20',
|
|
'NILAI_NERACA' => $dataset20
|
|
];
|
|
$neraca3200 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '21',
|
|
'NILAI_NERACA' => $akumulasi
|
|
];
|
|
$neraca3210 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '22',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca4110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '23',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca4120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '24',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca4130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '25',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5110 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '26',
|
|
'NILAI_NERACA' => $dataset04
|
|
];
|
|
$neraca5120 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '27',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5121 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '28',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5122 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '29',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca5130 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '30',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6101 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '31',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6102 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '32',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6103 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '33',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6104 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '34',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6105 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '35',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6106 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '36',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6107 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '37',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6201 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '38',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6202 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '39',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6203 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '40',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6204 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '41',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6205 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '42',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6206 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '43',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6207 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '44',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6208 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '45',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6209 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '46',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6210 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '47',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6211 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '48',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6212 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '49',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6213 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '50',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6214 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '51',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6215 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '52',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6216 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '53',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6217 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '54',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6218 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '55',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6219 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '56',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6220 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '57',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6221 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '58',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6222 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '59',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6223 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '60',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6224 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '61',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6225 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '62',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6226 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '63',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6227 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '64',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6228 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '65',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6229 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '66',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6230 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '67',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6231 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '68',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6232 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '69',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6233 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '70',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6234 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '71',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6235 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '72',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6236 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '73',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca6237 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '74',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7100 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '75',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7200 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '76',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7300 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '77',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
$neraca7400 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'PERKIRAAN_ID' => '78',
|
|
'NILAI_NERACA' => '0'
|
|
];
|
|
|
|
$action = $this->SetKasbank->create('neraca', $neraca1110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1140);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1150);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1160);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1170);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1180);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1210);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1211);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1220);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1221);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1230);
|
|
$action = $this->SetKasbank->create('neraca', $neraca1231);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2140);
|
|
$action = $this->SetKasbank->create('neraca', $neraca2150);
|
|
$action = $this->SetKasbank->create('neraca', $neraca3100);
|
|
$action = $this->SetKasbank->create('neraca', $neraca3200);
|
|
$action = $this->SetKasbank->create('neraca', $neraca3210);
|
|
$action = $this->SetKasbank->create('neraca', $neraca4110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca4120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca4130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5110);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5120);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5121);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5122);
|
|
$action = $this->SetKasbank->create('neraca', $neraca5130);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6101);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6102);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6103);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6104);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6105);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6106);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6107);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6201);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6202);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6203);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6204);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6205);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6206);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6207);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6208);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6209);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6210);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6211);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6212);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6213);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6214);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6215);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6216);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6217);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6218);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6219);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6220);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6221);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6222);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6223);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6224);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6225);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6226);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6227);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6228);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6229);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6230);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6231);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6232);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6233);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6234);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6235);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6236);
|
|
$action = $this->SetKasbank->create('neraca', $neraca6237);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7100);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7200);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7300);
|
|
$action = $this->SetKasbank->create('neraca', $neraca7400);
|
|
|
|
$totalneraca01 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Aktiva Lancar",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca02 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Aktiva Tetap",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca03 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Aktiva",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca04 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Kewajiban Lancar",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca05 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Modal",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca06 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Pasiva",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca07 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Penjualan",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca08 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Harga Pokok Jual",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca09 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Kotor",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca10 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Total Biaya",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca11 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Usaha",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca12 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Luar Usaha",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca13 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Bersih Sebelum Pajak",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$totalneraca14 = [
|
|
'SETDATA_ID' => $id_setdata,
|
|
'NAMA_TOTALNERACA' => "Laba Bersih Setelah Pajak",
|
|
'NILAI_TOTALNERACA' => '0'
|
|
];
|
|
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca01);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca02);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca03);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca04);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca05);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca06);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca07);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca08);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca09);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca10);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca11);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca12);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca13);
|
|
$action = $this->SetKasbank->create('totalneraca', $totalneraca14);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('flash', 'dikunci');
|
|
redirect('ManageSetKasbank');
|
|
} else {
|
|
$this->session->set_flashdata('flashgagal', 'dikunci');
|
|
redirect('ManageSetKasbank');
|
|
}
|
|
|
|
}
|
|
|
|
//Step Two, Ubah Neraca
|
|
public function awalNeraca($id) {
|
|
$neraca = $this->SetKasbank->getDataNeracaAwal($id);
|
|
$title = $this->SetKasbank->getTitleSD($id);
|
|
$data = [
|
|
'sidebar' => "set data",
|
|
'navChild' => "",
|
|
'neraca' => $neraca,
|
|
'id_setdata' => $id,
|
|
'title1' => $title[0]['KODE_SETDATA'],
|
|
'title2' => $title[0]['WAKTU']
|
|
];
|
|
|
|
$this->load->view('proses/NeracaAwal', $data);
|
|
}
|
|
|
|
public function setNeraca($id) {
|
|
$neraca = $this->SetKasbank->getDataNeraca($id);
|
|
$title = $this->SetKasbank->getTitleSD($id);
|
|
$data = [
|
|
'sidebar' => "set data",
|
|
'navChild' => "",
|
|
'neraca' => $neraca,
|
|
'id_setdata' => $id,
|
|
'title1' => $title[0]['KODE_SETDATA'],
|
|
'title2' => $title[0]['WAKTU']
|
|
];
|
|
|
|
$this->load->view('proses/NeracaSet', $data);
|
|
}
|
|
|
|
public function viewNeraca($id) {
|
|
$neraca = $this->SetKasbank->getDataNeraca($id);
|
|
$title = $this->SetKasbank->getTitleSD($id);
|
|
$data = [
|
|
'sidebar' => "set data",
|
|
'navChild' => "",
|
|
'neraca' => $neraca,
|
|
'id_setdata' => $id,
|
|
'title1' => $title[0]['KODE_SETDATA'],
|
|
'title2' => $title[0]['WAKTU']
|
|
];
|
|
|
|
$this->load->view('proses/NeracaView', $data);
|
|
}
|
|
|
|
public function viewTotalNeraca($id) {
|
|
$neraca = $this->SetKasbank->getDataNeracaTotal($id);
|
|
$title = $this->SetKasbank->getTitleSD($id);
|
|
$data = [
|
|
'sidebar' => "set data",
|
|
'navChild' => "",
|
|
'neraca' => $neraca,
|
|
'id_setdata' => $id,
|
|
'title1' => $title[0]['KODE_SETDATA'],
|
|
'title2' => $title[0]['WAKTU']
|
|
];
|
|
|
|
$this->load->view('proses/NeracaTotalView', $data);
|
|
}
|
|
|
|
public function edit() {
|
|
$method = $this->input->post('method');
|
|
$id_neraca = $this->input->post('id_neraca');
|
|
$nilai_neraca = $this->input->post('nilai_neracaed');
|
|
|
|
$update = [
|
|
'NILAI_NERACA' => $nilai_neraca
|
|
];
|
|
|
|
$action = $this->SetKasbank->update('neraca', $update, 'ID_NERACA',$id_neraca);
|
|
|
|
if ($action) {
|
|
$this->session->set_flashdata('flash', 'dilakukan');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
} else {
|
|
$this->session->set_flashdata('flashgagal', 'dilakukan');
|
|
redirect($_SERVER['HTTP_REFERER']);
|
|
}
|
|
|
|
}
|
|
|
|
|
|
}
|