abel/shopee-apps
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
shopee-apps/application/delete/models/ModelSetKasbank.php
T
abel db327c0305 copy dari repo om Irfan
2026-06-13 16:02:07 +10:00

995 lines
38 KiB
PHP
Raw Permalink Blame History

<?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();
}
}
?>
Reference in New Issue View Git Blame Copy Permalink