<?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 ManageSetData extends CI_Controller
{
	function __construct()
	{
		parent::__construct();
		$this->load->model('ModelSetData', 'SetData');
		$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 Data
	public function index() {
		
		$datSetData	= $this->SetData->getDataSetData();
		$id	= $this->SetData->getIDSETDATA();
		$data = [
			'sidebar'	=> "set data",
			'navChild'	=> "",
			'setdata'	=> $datSetData,
			'id'		=> $id[0]['ID_SETDATA']
		];

		$this->load->view('proses/SetData', $data);
	}
	
	public function kodeSetData() {	
        $kk = $this->SetData->getKodeSetData();
        if (is_array($kk) || is_object($kk)) {
            foreach ($kk as $row) {
				if ($row['KODE'] == null) {
                    return "SD/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 = "SD/000000";
					$data = substr($data, 0, $panjang) . $str;
					return $data;
				}
            }
        }
    }
	
	public function saveawal() {	
		$method 			= $this->input->post('method');
		$id					= $this->input->post('id_setdata');
		$kode_setdata		= $this->kodeSetData();
		
		$input = [
			'KODE_SETDATA'		=> $kode_setdata
		];
		$action = $this->SetData->create('setdata', $input);
		$setdata = $this->SetData->getIDSETDATA();
		$id_setdata = $setdata[0]['ID_SETDATA'];
		$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->SetData->create('neraca', $neraca1110);
		$action = $this->SetData->create('neraca', $neraca1120);
		$action = $this->SetData->create('neraca', $neraca1130);
		$action = $this->SetData->create('neraca', $neraca1140);
		$action = $this->SetData->create('neraca', $neraca1150);
		$action = $this->SetData->create('neraca', $neraca1160);
		$action = $this->SetData->create('neraca', $neraca1170);
		$action = $this->SetData->create('neraca', $neraca1180);
		$action = $this->SetData->create('neraca', $neraca1210);
		$action = $this->SetData->create('neraca', $neraca1211);
		$action = $this->SetData->create('neraca', $neraca1220);
		$action = $this->SetData->create('neraca', $neraca1221);
		$action = $this->SetData->create('neraca', $neraca1230);
		$action = $this->SetData->create('neraca', $neraca1231);
		$action = $this->SetData->create('neraca', $neraca2110);
		$action = $this->SetData->create('neraca', $neraca2120);
		$action = $this->SetData->create('neraca', $neraca2130);
		$action = $this->SetData->create('neraca', $neraca2140);
		$action = $this->SetData->create('neraca', $neraca2150);
		$action = $this->SetData->create('neraca', $neraca3100);
		$action = $this->SetData->create('neraca', $neraca3200);
		$action = $this->SetData->create('neraca', $neraca3210);
		$action = $this->SetData->create('neraca', $neraca4110);
		$action = $this->SetData->create('neraca', $neraca4120);
		$action = $this->SetData->create('neraca', $neraca4130);
		$action = $this->SetData->create('neraca', $neraca5110);
		$action = $this->SetData->create('neraca', $neraca5120);
		$action = $this->SetData->create('neraca', $neraca5121);
		$action = $this->SetData->create('neraca', $neraca5122);
		$action = $this->SetData->create('neraca', $neraca5130);
		$action = $this->SetData->create('neraca', $neraca6101);
		$action = $this->SetData->create('neraca', $neraca6102);
		$action = $this->SetData->create('neraca', $neraca6103);
		$action = $this->SetData->create('neraca', $neraca6104);
		$action = $this->SetData->create('neraca', $neraca6105);
		$action = $this->SetData->create('neraca', $neraca6106);
		$action = $this->SetData->create('neraca', $neraca6107);
		$action = $this->SetData->create('neraca', $neraca6201);
		$action = $this->SetData->create('neraca', $neraca6202);
		$action = $this->SetData->create('neraca', $neraca6203);
		$action = $this->SetData->create('neraca', $neraca6204);
		$action = $this->SetData->create('neraca', $neraca6205);
		$action = $this->SetData->create('neraca', $neraca6206);
		$action = $this->SetData->create('neraca', $neraca6207);
		$action = $this->SetData->create('neraca', $neraca6208);
		$action = $this->SetData->create('neraca', $neraca6209);
		$action = $this->SetData->create('neraca', $neraca6210);
		$action = $this->SetData->create('neraca', $neraca6211);
		$action = $this->SetData->create('neraca', $neraca6212);
		$action = $this->SetData->create('neraca', $neraca6213);
		$action = $this->SetData->create('neraca', $neraca6214);
		$action = $this->SetData->create('neraca', $neraca6215);
		$action = $this->SetData->create('neraca', $neraca6216);
		$action = $this->SetData->create('neraca', $neraca6217);
		$action = $this->SetData->create('neraca', $neraca6218);
		$action = $this->SetData->create('neraca', $neraca6219);
		$action = $this->SetData->create('neraca', $neraca6220);
		$action = $this->SetData->create('neraca', $neraca6221);
		$action = $this->SetData->create('neraca', $neraca6222);
		$action = $this->SetData->create('neraca', $neraca6223);
		$action = $this->SetData->create('neraca', $neraca6224);
		$action = $this->SetData->create('neraca', $neraca6225);
		$action = $this->SetData->create('neraca', $neraca6226);
		$action = $this->SetData->create('neraca', $neraca6227);
		$action = $this->SetData->create('neraca', $neraca6228);
		$action = $this->SetData->create('neraca', $neraca6229);
		$action = $this->SetData->create('neraca', $neraca6230);
		$action = $this->SetData->create('neraca', $neraca6231);
		$action = $this->SetData->create('neraca', $neraca6232);
		$action = $this->SetData->create('neraca', $neraca6233);
		$action = $this->SetData->create('neraca', $neraca6234);
		$action = $this->SetData->create('neraca', $neraca6235);
		$action = $this->SetData->create('neraca', $neraca6236);
		$action = $this->SetData->create('neraca', $neraca6237);
		$action = $this->SetData->create('neraca', $neraca7100);
		$action = $this->SetData->create('neraca', $neraca7200);
		$action = $this->SetData->create('neraca', $neraca7300);
		$action = $this->SetData->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->SetData->create('totalneraca', $totalneraca01);
		$action = $this->SetData->create('totalneraca', $totalneraca02);
		$action = $this->SetData->create('totalneraca', $totalneraca03);
		$action = $this->SetData->create('totalneraca', $totalneraca04);
		$action = $this->SetData->create('totalneraca', $totalneraca05);
		$action = $this->SetData->create('totalneraca', $totalneraca06);
		$action = $this->SetData->create('totalneraca', $totalneraca07);
		$action = $this->SetData->create('totalneraca', $totalneraca08);
		$action = $this->SetData->create('totalneraca', $totalneraca09);
		$action = $this->SetData->create('totalneraca', $totalneraca10);
		$action = $this->SetData->create('totalneraca', $totalneraca11);
		$action = $this->SetData->create('totalneraca', $totalneraca12);
		$action = $this->SetData->create('totalneraca', $totalneraca13);
		$action = $this->SetData->create('totalneraca', $totalneraca14);
		
		if ($action) {
			$this->session->set_flashdata('flash', 'ditambah');
			redirect('ManageSetData');
		} else {
			$this->session->set_flashdata('flashgagal', 'ditambah');
			redirect('ManageSetData');
		}
		
	}
	
	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->SetData->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']);
		}
		
	}
	
	public function kunci() {
		$method 		= $this->input->post('method');
		$id_setdata		= $this->input->post('id_setdata');
		$kode_setdata	= $this->kodeSetData();
		
		//Get Data
		$dataset01 = $this->SetData->getNilai1110($id_setdata);
		$dataset02 = $this->SetData->getNilai1120($id_setdata);
		$dataset03 = $this->SetData->getNilai1130($id_setdata);
		$dataset04 = $this->SetData->getNilai1140($id_setdata);
		$dataset05 = $this->SetData->getNilai1150($id_setdata);
		$dataset06 = $this->SetData->getNilai1160($id_setdata);
		$dataset07 = $this->SetData->getNilai1170($id_setdata);
		$dataset08 = $this->SetData->getNilai1180($id_setdata);
		$dataset09 = $this->SetData->getNilai1210($id_setdata);
		$dataset10 = $this->SetData->getNilai1211($id_setdata);
		$dataset11 = $this->SetData->getNilai1220($id_setdata);
		$dataset12 = $this->SetData->getNilai1221($id_setdata);
		$dataset13 = $this->SetData->getNilai1230($id_setdata);
		$dataset14 = $this->SetData->getNilai1231($id_setdata);
		$dataset15 = $this->SetData->getNilai2110($id_setdata);
		$dataset16 = $this->SetData->getNilai2120($id_setdata);
		$dataset17 = $this->SetData->getNilai2130($id_setdata);
		$dataset18 = $this->SetData->getNilai2140($id_setdata);
		$dataset19 = $this->SetData->getNilai2150($id_setdata);
		$dataset20 = $this->SetData->getNilai3100($id_setdata);
		$dataset21 = $this->SetData->getNilai3200($id_setdata);
		$dataset22 = $this->SetData->getNilai3210($id_setdata);
		$dataset23 = $this->SetData->getNilai4110($id_setdata);
		$dataset24 = $this->SetData->getNilai4120($id_setdata);
		$dataset25 = $this->SetData->getNilai4130($id_setdata);
		$dataset26 = $this->SetData->getNilai5110($id_setdata);
		$dataset27 = $this->SetData->getNilai5120($id_setdata);
		$dataset28 = $this->SetData->getNilai5121($id_setdata);
		$dataset29 = $this->SetData->getNilai5122($id_setdata);
		$dataset30 = $this->SetData->getNilai5130($id_setdata);
		$dataset31 = $this->SetData->getNilai6101($id_setdata);
		$dataset32 = $this->SetData->getNilai6102($id_setdata);
		$dataset33 = $this->SetData->getNilai6103($id_setdata);
		$dataset34 = $this->SetData->getNilai6104($id_setdata);
		$dataset35 = $this->SetData->getNilai6105($id_setdata);
		$dataset36 = $this->SetData->getNilai6106($id_setdata);
		$dataset37 = $this->SetData->getNilai6107($id_setdata);
		$dataset38 = $this->SetData->getNilai6201($id_setdata);
		$dataset39 = $this->SetData->getNilai6202($id_setdata);
		$dataset40 = $this->SetData->getNilai6203($id_setdata);
		$dataset41 = $this->SetData->getNilai6204($id_setdata);
		$dataset42 = $this->SetData->getNilai6205($id_setdata);
		$dataset43 = $this->SetData->getNilai6206($id_setdata);
		$dataset44 = $this->SetData->getNilai6207($id_setdata);
		$dataset45 = $this->SetData->getNilai6208($id_setdata);
		$dataset46 = $this->SetData->getNilai6209($id_setdata);
		$dataset47 = $this->SetData->getNilai6210($id_setdata);
		$dataset48 = $this->SetData->getNilai6211($id_setdata);
		$dataset49 = $this->SetData->getNilai6212($id_setdata);
		$dataset50 = $this->SetData->getNilai6213($id_setdata);
		$dataset51 = $this->SetData->getNilai6214($id_setdata);
		$dataset52 = $this->SetData->getNilai6215($id_setdata);
		$dataset53 = $this->SetData->getNilai6216($id_setdata);
		$dataset54 = $this->SetData->getNilai6217($id_setdata);
		$dataset55 = $this->SetData->getNilai6218($id_setdata);
		$dataset56 = $this->SetData->getNilai6219($id_setdata);
		$dataset57 = $this->SetData->getNilai6220($id_setdata);
		$dataset58 = $this->SetData->getNilai6221($id_setdata);
		$dataset59 = $this->SetData->getNilai6222($id_setdata);
		$dataset60 = $this->SetData->getNilai6223($id_setdata);
		$dataset61 = $this->SetData->getNilai6224($id_setdata);
		$dataset62 = $this->SetData->getNilai6225($id_setdata);
		$dataset63 = $this->SetData->getNilai6226($id_setdata);
		$dataset64 = $this->SetData->getNilai6227($id_setdata);
		$dataset65 = $this->SetData->getNilai6228($id_setdata);
		$dataset66 = $this->SetData->getNilai6229($id_setdata);
		$dataset67 = $this->SetData->getNilai6230($id_setdata);
		$dataset68 = $this->SetData->getNilai6231($id_setdata);
		$dataset69 = $this->SetData->getNilai6233($id_setdata);
		$dataset70 = $this->SetData->getNilai6233($id_setdata);
		$dataset71 = $this->SetData->getNilai6234($id_setdata);
		$dataset72 = $this->SetData->getNilai6235($id_setdata);
		$dataset73 = $this->SetData->getNilai6236($id_setdata);
		$dataset74 = $this->SetData->getNilai6237($id_setdata);
		$dataset75 = $this->SetData->getNilai7100($id_setdata);
		$dataset76 = $this->SetData->getNilai7200($id_setdata);
		$dataset77 = $this->SetData->getNilai7300($id_setdata);
		$dataset78 = $this->SetData->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->SetData->getTotalAktivaLancar($id_setdata);
		$total02 = $this->SetData->getTotalAktivaTetap($id_setdata);
		$total03 = $this->SetData->getTotalAktiva($id_setdata);
		$total04 = $this->SetData->getTotalKewajibanLancar($id_setdata);
		$total05 = $this->SetData->getTotalModal($id_setdata);
		$total06 = $this->SetData->getTotalPasiva($id_setdata);
		$total07 = $this->SetData->getTotalPenjualan($id_setdata);
		$total08 = $this->SetData->getTotalHargaPokokJual($id_setdata);
		$total09 = $this->SetData->getTotalLabaKotor($id_setdata);
		$total10 = $this->SetData->getTotalBiaya($id_setdata);
		$total11 = $this->SetData->getTotalLabaUsaha($id_setdata);
		$total12 = $this->SetData->getTotalLuarUsaha($id_setdata);
		$total13 = $this->SetData->getTotalLabaBersihSebelumPajak($id_setdata);
		$total14 = $this->SetData->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->SetData->update('totalneraca', $update01, 'ID_TOTALNERACA', $total01);
		$action = $this->SetData->update('totalneraca', $update02, 'ID_TOTALNERACA', $total02);
		$action = $this->SetData->update('totalneraca', $update03, 'ID_TOTALNERACA', $total03);
		$action = $this->SetData->update('totalneraca', $update04, 'ID_TOTALNERACA', $total04);
		$action = $this->SetData->update('totalneraca', $update05, 'ID_TOTALNERACA', $total05);
		$action = $this->SetData->update('totalneraca', $update06, 'ID_TOTALNERACA', $total06);
		$action = $this->SetData->update('totalneraca', $update07, 'ID_TOTALNERACA', $total07);
		$action = $this->SetData->update('totalneraca', $update08, 'ID_TOTALNERACA', $total08);
		$action = $this->SetData->update('totalneraca', $update09, 'ID_TOTALNERACA', $total09);
		$action = $this->SetData->update('totalneraca', $update10, 'ID_TOTALNERACA', $total10);
		$action = $this->SetData->update('totalneraca', $update11, 'ID_TOTALNERACA', $total11);
		$action = $this->SetData->update('totalneraca', $update12, 'ID_TOTALNERACA', $total12);
		$action = $this->SetData->update('totalneraca', $update13, 'ID_TOTALNERACA', $total13);
		$action = $this->SetData->update('totalneraca', $update14, 'ID_TOTALNERACA', $total14);
		
		$update = [
			'STATUS_SETDATA'	=> '0'
		];
		$action = $this->SetData->update('setdata', $update, 'ID_SETDATA', $id_setdata);
		
		$input = [
			'KODE_SETDATA'		=> $kode_setdata
		];
		$action = $this->SetData->create('setdata', $input);
		$setdata = $this->SetData->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'	=> $dataset04
		];
		$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->SetData->create('neraca', $neraca1110);
		$action = $this->SetData->create('neraca', $neraca1120);
		$action = $this->SetData->create('neraca', $neraca1130);
		$action = $this->SetData->create('neraca', $neraca1140);
		$action = $this->SetData->create('neraca', $neraca1150);
		$action = $this->SetData->create('neraca', $neraca1160);
		$action = $this->SetData->create('neraca', $neraca1170);
		$action = $this->SetData->create('neraca', $neraca1180);
		$action = $this->SetData->create('neraca', $neraca1210);
		$action = $this->SetData->create('neraca', $neraca1211);
		$action = $this->SetData->create('neraca', $neraca1220);
		$action = $this->SetData->create('neraca', $neraca1221);
		$action = $this->SetData->create('neraca', $neraca1230);
		$action = $this->SetData->create('neraca', $neraca1231);
		$action = $this->SetData->create('neraca', $neraca2110);
		$action = $this->SetData->create('neraca', $neraca2120);
		$action = $this->SetData->create('neraca', $neraca2130);
		$action = $this->SetData->create('neraca', $neraca2140);
		$action = $this->SetData->create('neraca', $neraca2150);
		$action = $this->SetData->create('neraca', $neraca3100);
		$action = $this->SetData->create('neraca', $neraca3200);
		$action = $this->SetData->create('neraca', $neraca3210);
		$action = $this->SetData->create('neraca', $neraca4110);
		$action = $this->SetData->create('neraca', $neraca4120);
		$action = $this->SetData->create('neraca', $neraca4130);
		$action = $this->SetData->create('neraca', $neraca5110);
		$action = $this->SetData->create('neraca', $neraca5120);
		$action = $this->SetData->create('neraca', $neraca5121);
		$action = $this->SetData->create('neraca', $neraca5122);
		$action = $this->SetData->create('neraca', $neraca5130);
		$action = $this->SetData->create('neraca', $neraca6101);
		$action = $this->SetData->create('neraca', $neraca6102);
		$action = $this->SetData->create('neraca', $neraca6103);
		$action = $this->SetData->create('neraca', $neraca6104);
		$action = $this->SetData->create('neraca', $neraca6105);
		$action = $this->SetData->create('neraca', $neraca6106);
		$action = $this->SetData->create('neraca', $neraca6107);
		$action = $this->SetData->create('neraca', $neraca6201);
		$action = $this->SetData->create('neraca', $neraca6202);
		$action = $this->SetData->create('neraca', $neraca6203);
		$action = $this->SetData->create('neraca', $neraca6204);
		$action = $this->SetData->create('neraca', $neraca6205);
		$action = $this->SetData->create('neraca', $neraca6206);
		$action = $this->SetData->create('neraca', $neraca6207);
		$action = $this->SetData->create('neraca', $neraca6208);
		$action = $this->SetData->create('neraca', $neraca6209);
		$action = $this->SetData->create('neraca', $neraca6210);
		$action = $this->SetData->create('neraca', $neraca6211);
		$action = $this->SetData->create('neraca', $neraca6212);
		$action = $this->SetData->create('neraca', $neraca6213);
		$action = $this->SetData->create('neraca', $neraca6214);
		$action = $this->SetData->create('neraca', $neraca6215);
		$action = $this->SetData->create('neraca', $neraca6216);
		$action = $this->SetData->create('neraca', $neraca6217);
		$action = $this->SetData->create('neraca', $neraca6218);
		$action = $this->SetData->create('neraca', $neraca6219);
		$action = $this->SetData->create('neraca', $neraca6220);
		$action = $this->SetData->create('neraca', $neraca6221);
		$action = $this->SetData->create('neraca', $neraca6222);
		$action = $this->SetData->create('neraca', $neraca6223);
		$action = $this->SetData->create('neraca', $neraca6224);
		$action = $this->SetData->create('neraca', $neraca6225);
		$action = $this->SetData->create('neraca', $neraca6226);
		$action = $this->SetData->create('neraca', $neraca6227);
		$action = $this->SetData->create('neraca', $neraca6228);
		$action = $this->SetData->create('neraca', $neraca6229);
		$action = $this->SetData->create('neraca', $neraca6230);
		$action = $this->SetData->create('neraca', $neraca6231);
		$action = $this->SetData->create('neraca', $neraca6232);
		$action = $this->SetData->create('neraca', $neraca6233);
		$action = $this->SetData->create('neraca', $neraca6234);
		$action = $this->SetData->create('neraca', $neraca6235);
		$action = $this->SetData->create('neraca', $neraca6236);
		$action = $this->SetData->create('neraca', $neraca6237);
		$action = $this->SetData->create('neraca', $neraca7100);
		$action = $this->SetData->create('neraca', $neraca7200);
		$action = $this->SetData->create('neraca', $neraca7300);
		$action = $this->SetData->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->SetData->create('totalneraca', $totalneraca01);
		$action = $this->SetData->create('totalneraca', $totalneraca02);
		$action = $this->SetData->create('totalneraca', $totalneraca03);
		$action = $this->SetData->create('totalneraca', $totalneraca04);
		$action = $this->SetData->create('totalneraca', $totalneraca05);
		$action = $this->SetData->create('totalneraca', $totalneraca06);
		$action = $this->SetData->create('totalneraca', $totalneraca07);
		$action = $this->SetData->create('totalneraca', $totalneraca08);
		$action = $this->SetData->create('totalneraca', $totalneraca09);
		$action = $this->SetData->create('totalneraca', $totalneraca10);
		$action = $this->SetData->create('totalneraca', $totalneraca11);
		$action = $this->SetData->create('totalneraca', $totalneraca12);
		$action = $this->SetData->create('totalneraca', $totalneraca13);
		$action = $this->SetData->create('totalneraca', $totalneraca14);
		
		if ($action) {
			$this->session->set_flashdata('flash', 'dikunci');
			redirect('ManageSetData');
		} else {
			$this->session->set_flashdata('flashgagal', 'dikunci');
			redirect('ManageSetData');
		}
		
	}
	
	//Step Two, Ubah Neraca
	public function awalNeraca($id) {
        $neraca			=	$this->SetData->getDataNeracaAwal($id);
		$title			=	$this->SetData->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->SetData->getDataNeraca($id);
		$title			=	$this->SetData->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->SetData->getDataNeraca($id);
		$title			=	$this->SetData->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->SetData->getDataNeracaTotal($id);
		$title			=	$this->SetData->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);
    }
	
	
}