<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class ModelSetKasbank extends CI_Model {
	public function create($table, $data, $batch = false)
    {
        if($batch === false){
            $insert = $this->db->insert($table, $data);
        }else{
            $insert = $this->db->insert_batch($table, $data);
        }
        return $insert;
    }

    public function update($table, $data, $pk, $id = null, $batch = false)
    {
        if($batch === false){
            $insert = $this->db->update($table, $data, array($pk => $id));
        }else{
            $insert = $this->db->update_batch($table, $data, $pk);
        }
        return $insert;
    }

    public function delete($table, $data, $pk)
    {
        $this->db->where_in($pk, $data);
        return $this->db->delete($table);
    }
	
	//Step One, Input Set Kasbank
	public function getDataSetKasbank($id = null){
        if ($id === null) {
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETKASBANK,"%d/%m/%Y")) AS WAKTU');
            $this->db->from('setkasbank a');
			$this->db->join('kas b','b.ID_KAS=a.KAS_ID','left');
			$this->db->join('bank c','c.ID_BANK=a.BANK_ID','left');
			$this->db->join('piutang_dagang d','d.ID_PDA=a.PDA_ID','left');
			$this->db->join('piutang_karyawan e','e.ID_PKAR=a.PKAR_ID','left');
			$this->db->join('piutang_pihakke3 f','f.ID_PPI=a.PPI_ID','left');
			$this->db->join('dp_pembelian g','g.ID_DPB=a.DPB_ID','left');
			$this->db->join('dp_pajak h','h.ID_DPP=a.DPP_ID','left');
			$this->db->join('hutang_dagang i','i.ID_HDA=a.HDA_ID','left');
			$this->db->join('hutang_bank j','j.ID_HBA=a.HBA_ID','left');
			$this->db->join('hutang_lain k','k.ID_HLA=a.HLA_ID','left');
			$this->db->join('dp_penjualan l','l.ID_DPJ=a.DPJ_ID','left');
			$this->db->group_by('a.ID_SETKASBANK');
        }else{
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETKASBANK,"%d/%m/%Y")) AS WAKTU');
            $this->db->from('setkasbank a');
			$this->db->join('kas b','b.ID_KAS=a.KAS_ID','left');
			$this->db->join('bank c','c.ID_BANK=a.BANK_ID','left');
			$this->db->join('piutang_dagang d','d.ID_PDA=a.PDA_ID','left');
			$this->db->join('piutang_karyawan e','e.ID_PKAR=a.PKAR_ID','left');
			$this->db->join('piutang_pihakke3 f','f.ID_PPI=a.PPI_ID','left');
			$this->db->join('dp_pembelian g','g.ID_DPB=a.DPB_ID','left');
			$this->db->join('dp_pajak h','h.ID_DPP=a.DPP_ID','left');
			$this->db->join('hutang_dagang i','i.ID_HDA=a.HDA_ID','left');
			$this->db->join('hutang_bank j','j.ID_HBA=a.HBA_ID','left');
			$this->db->join('hutang_lain k','k.ID_HLA=a.HLA_ID','left');
			$this->db->join('dp_penjualan l','l.ID_DPJ=a.DPJ_ID','left');
			$this->db->group_by('a.ID_SETKASBANK');
            $this->db->where(['a.ID_SETKASBANK' => $id]);
        }
        return $this->db->get()->result_array();
    }
	
	public function getKodeSetKasbank() {
        $this->db->select('MAX(KODE_SETDATA) AS KODE');
        $this->db->from('setkasbank');
        return $this->db->get()->result_array();
    }
	
	public function getIDSETKASBANK() {
        $this->db->select_max('ID_SETKASBANK');
        $this->db->from('setkasbank');
        return $this->db->get()->result_array();
    }
	
	//Step Two, Input Transaksi
	public function getDataNeracaAwal($id = null){
        if ($id === null) {
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETDATA,"%d/%m/%Y")) AS WAKTU,CONCAT("Rp ",FORMAT(b.NILAI_NERACA,2)) as NILAI');
            $this->db->from('setkasbank a');
			$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA','left');
			$this->db->join('perkiraan c','c.ID_PERKIRAAN=b.PERKIRAAN_ID','left');
			$this->db->group_by('b.ID_NERACA');
        }else{
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETDATA,"%d/%m/%Y")) AS WAKTU,CONCAT("Rp ",FORMAT(b.NILAI_NERACA,2)) as NILAI');
            $this->db->from('setkasbank a');
			$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA','left');
			$this->db->join('perkiraan c','c.ID_PERKIRAAN=b.PERKIRAAN_ID','left');
			$this->db->group_by('b.ID_NERACA');
            $this->db->where(['a.ID_SETDATA' => $id]);
			$this->db->where('b.ID_NERACA=9');
			$this->db->or_where('b.ID_NERACA=10');
			$this->db->or_where('b.ID_NERACA=11');
			$this->db->or_where('b.ID_NERACA=12');
			$this->db->or_where('b.ID_NERACA=13');
			$this->db->or_where('b.ID_NERACA=14');
			$this->db->or_where('b.ID_NERACA=20');
			$this->db->or_where('b.ID_NERACA=21');
        }
        return $this->db->get()->result_array();
    }
	
	public function getDataNeraca($id = null){
        if ($id === null) {
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETDATA,"%d/%m/%Y")) AS WAKTU,CONCAT("Rp ",FORMAT(b.NILAI_NERACA,2)) as NILAI');
            $this->db->from('setkasbank a');
			$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA','left');
			$this->db->join('perkiraan c','c.ID_PERKIRAAN=b.PERKIRAAN_ID','left');
			$this->db->group_by('b.ID_NERACA');
        }else{
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETDATA,"%d/%m/%Y")) AS WAKTU,CONCAT("Rp ",FORMAT(b.NILAI_NERACA,2)) as NILAI');
            $this->db->from('setkasbank a');
			$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA','left');
			$this->db->join('perkiraan c','c.ID_PERKIRAAN=b.PERKIRAAN_ID','left');
			$this->db->group_by('b.ID_NERACA');
            $this->db->where(['a.ID_SETDATA' => $id]);
        }
        return $this->db->get()->result_array();
    }
	
	public function getDataNeracaTotal($id = null){
        if ($id === null) {
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETDATA,"%d/%m/%Y")) AS WAKTU,CONCAT("Rp ",FORMAT(b.NILAI_TOTALNERACA,2)) as NILAI');
            $this->db->from('setkasbank a');
			$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA','left');
			$this->db->group_by('b.ID_TOTALNERACA');
        }else{
            $this->db->select('*,CONCAT(DATE_FORMAT(a.TGL_SETDATA,"%d/%m/%Y")) AS WAKTU,CONCAT("Rp ",FORMAT(b.NILAI_TOTALNERACA,2)) as NILAI');
            $this->db->from('setkasbank a');
			$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA','left');
			$this->db->group_by('b.ID_TOTALNERACA');
            $this->db->where(['a.ID_SETDATA' => $id]);
        }
        return $this->db->get()->result_array();
    }
	
	public function getTitleSD($id) {
        $this->db->select('KODE_SETDATA,CONCAT(DATE_FORMAT(TGL_SETDATA,"%d/%m/%Y")) AS WAKTU');
        $this->db->from('setkasbank');
        $this->db->where(['ID_SETDATA' => $id]);
        return $this->db->get()->result_array();
    }
	
	public function getNilai1110($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=1');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1120($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=2');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1130($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=3');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1140($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=4');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1150($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=5');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1160($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=6');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1170($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=7');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1180($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=8');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1210($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=9');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1211($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=10');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1220($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=11');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1221($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=12');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1230($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=13');
        return $this->db->get()->result_array();
    }
	
	public function getNilai1231($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=14');
        return $this->db->get()->result_array();
    }
	
	public function getNilai2110($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=15');
        return $this->db->get()->result_array();
    }
	
	public function getNilai2120($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=16');
        return $this->db->get()->result_array();
    }
	
	public function getNilai2130($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=17');
        return $this->db->get()->result_array();
    }
	
	public function getNilai2140($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=18');
        return $this->db->get()->result_array();
    }
	
	public function getNilai2150($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=19');
        return $this->db->get()->result_array();
    }
	
	public function getNilai3100($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=20');
        return $this->db->get()->result_array();
    }
	
	public function getNilai3200($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=21');
        return $this->db->get()->result_array();
    }
	
	public function getNilai3210($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=22');
        return $this->db->get()->result_array();
    }
	
	public function getNilai4110($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=23');
        return $this->db->get()->result_array();
    }
	
	public function getNilai4120($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=24');
        return $this->db->get()->result_array();
    }
	
	public function getNilai4130($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=25');
        return $this->db->get()->result_array();
    }
	
	public function getNilai5110($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=26');
        return $this->db->get()->result_array();
    }
	
	public function getNilai5120($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=27');
        return $this->db->get()->result_array();
    }
	
	public function getNilai5121($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=28');
        return $this->db->get()->result_array();
    }
	
	public function getNilai5122($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=29');
        return $this->db->get()->result_array();
    }
	
	public function getNilai5130($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=30');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6101($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=31');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6102($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=32');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6103($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=33');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6104($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=34');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6105($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=35');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6106($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=36');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6107($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=37');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6201($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=38');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6202($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=39');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6203($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=40');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6204($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=41');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6205($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=42');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6206($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=43');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6207($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=44');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6208($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=45');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6209($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=46');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6210($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=47');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6211($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=48');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6212($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=49');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6213($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=50');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6214($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=51');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6215($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=52');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6216($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=53');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6217($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=54');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6218($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=55');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6219($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=56');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6220($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=57');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6221($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=58');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6222($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=59');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6223($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=60');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6224($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=61');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6225($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=62');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6226($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=63');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6227($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=64');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6228($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=65');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6229($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=66');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6230($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=67');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6231($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=68');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6232($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=69');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6233($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=70');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6234($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=71');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6235($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=72');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6236($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=73');
        return $this->db->get()->result_array();
    }
	
	public function getNilai6237($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=74');
        return $this->db->get()->result_array();
    }
	
	public function getNilai7100($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=75');
        return $this->db->get()->result_array();
    }
	
	public function getNilai7200($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=76');
        return $this->db->get()->result_array();
    }
	
	public function getNilai7300($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=77');
        return $this->db->get()->result_array();
    }
	
	public function getNilai7400($id) {
        $this->db->select('b.NILAI_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.PERKIRAAN_ID=78');
        return $this->db->get()->result_array();
    }
	
	public function getTotalAktivaLancar($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Aktiva Lancar"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalAktivaTetap($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Aktiva Tetap"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalAktiva($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Total Aktiva"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalKewajibanLancar($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Kewajiban Lancar"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalModal($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Modal"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalPasiva($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Total Pasiva"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalPenjualan($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Total Penjualan"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalHargaPokokJual($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Harga Pokok Jual"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalLabaKotor($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Laba Kotor"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalBiaya($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Total Biaya"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalLabaUsaha($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Laba Usaha"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalLuarUsaha($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Luar Usaha"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalLabaBersihSebelumPajak($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Laba Bersih Sebelum Pajak"');
        return $this->db->get()->result_array();
    }
	
	public function getTotalLabaBersihSetelahPajak($id) {
        $this->db->select('b.NILAI_TOTALNERACA,b.ID_TOTALNERACA');
        $this->db->from('setkasbank a');
		$this->db->join('totalneraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['a.ID_SETDATA' => $id]);
		$this->db->where('b.NAMA_TOTALNERACA="Laba Bersih Setelah Pajak"');
        return $this->db->get()->result_array();
    }
	
	public function getIDNeracaLabaThnBerjalan($id) {
        $this->db->select('b.ID_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['b.SETDATA_ID' => $id]);
		$this->db->where('b.PERKIRAAN_ID=22');
        return $this->db->get()->result_array();
    }
	
	public function getIDNeracaPersediaan($id) {
        $this->db->select('b.ID_NERACA');
        $this->db->from('setkasbank a');
		$this->db->join('neraca b','b.SETDATA_ID=a.ID_SETDATA');
        $this->db->where(['b.SETDATA_ID' => $id]);
		$this->db->where('b.PERKIRAAN_ID=4');
        return $this->db->get()->result_array();
    }
	
	
}
?>