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

4385 lines
162 KiB
PHP
Raw Permalink Blame History

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class ModelDashboard 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);
}
public function ceklogin()
{
$username = $this->session->userdata('username');
if ($username == null) {
redirect("login");
}
}
public function getData_Karyawan_status1_syncNULL_orderPANGGILAN(){
$this->db->select('*');
$this->db->from('karyawan');
$this->db->where('STATUS_KARYAWAN=1');
$this->db->where('SYNC is NULL');
$this->db->order_by('NAMA_PANGGILAN_KARYAWAN ASC');
return $this->db->get()->result_array();
}
public function getData_Karyawan_byUSERNAME($id){
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b','b.ID_JABATAN=a.JABATAN_ID');
$this->db->where(['a.USERNAME' => $id]);
return $this->db->get()->result_array();
}
public function getData_SetHakMaster_byKARYAWAN($id){
$this->db->select('*');
$this->db->from('set_hakmaster');
$this->db->where(['KARYAWAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Akun($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('akun');
$this->db->order_by('NAMA_AKUN ASC');
}else{
$this->db->select('*');
$this->db->from('akun');
$this->db->where(['ID_AKUN' => $id]);
$this->db->order_by('NAMA_AKUN ASC');
}
return $this->db->get()->result_array();
}
public function getData_Kontak_byAKUN($id){
$this->db->select('*');
$this->db->from('kontak a');
$this->db->join('akun b','b.ID_AKUN=a.AKUN_ID');
$this->db->where(['a.AKUN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SalesVisit_byAKUN($id){
$this->db->select('*');
$this->db->from('sales_visit a');
$this->db->join('akun b','b.ID_AKUN=a.AKUN_ID');
$this->db->where(['a.AKUN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Bank($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('bank');
} else {
$this->db->select('*');
$this->db->from('bank');
$this->db->where(['ID_BANK' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_SaldoBank_byBANK($id){
$this->db->select('*');
$this->db->from('saldo_bank');
$this->db->where(['BANK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kasbank_byBANK($id){
$this->db->select('*');
$this->db->from('kasbank');
$this->db->where(['BANK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Customer($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('customer');
$this->db->order_by('NAMA_CUSTOMER ASC');
} else {
$this->db->select('*');
$this->db->from('customer');
$this->db->where(['ID_CUSTOMER' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Customer_byALAMAT($alamat, $id=null){
$this->db->select('*');
$this->db->from('customer');
$this->db->where(['ALAMAT_CUSTOMER' => $alamat]);
if ($id!=null) {
$this->db->where('ID_CUSTOMER!=', $id);
}
return $this->db->get()->result_array();
}
public function getData_RekapPajak_byCUSTOMER($id){
$this->db->select('*');
$this->db->from('rekap_pajak');
$this->db->where(['CUSTOMER_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Jabatan($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('jabatan');
$this->db->order_by('NAMA_JABATAN ASC');
}else{
$this->db->select('*');
$this->db->from('jabatan');
$this->db->where(['ID_JABATAN' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Karyawan_byJABATAN($id){
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b','b.ID_JABATAN=a.JABATAN_ID');
$this->db->where(['a.JABATAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Jenis($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('jenis');
$this->db->order_by('NAMA_JENIS ASC');
} else {
$this->db->select('*');
$this->db->from('jenis');
$this->db->where(['ID_JENIS' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Jenis_0_1_2(){
$this->db->select('*');
$this->db->from('jenis');
$this->db->order_by('NAMA_JENIS ASC');
return $this->db->get()->result_array();
}
public function getData_Jenis_2(){
$this->db->select('*');
$this->db->from('jenis');
$this->db->where('TYPE_JENIS=2');
$this->db->order_by('NAMA_JENIS ASC');
return $this->db->get()->result_array();
}
public function getData_Barang_byJENIS($id){
$this->db->select('*');
$this->db->from('barang');
$this->db->where(['JENIS_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Karyawan($id = null) {
if ($id === null) {
$this->db->select('*, b.NAMA_JABATAN');
$this->db->from('karyawan a');
$this->db->join('jabatan b', 'b.ID_JABATAN=a.JABATAN_ID');
$this->db->where('a.ID_KARYAWAN!=1');
$this->db->where('a.STATUS_KARYAWAN=1');
$this->db->order_by('a.NAMA_PANGGILAN_KARYAWAN ASC');
} else {
$this->db->select('*, b.NAMA_JABATAN');
$this->db->from('karyawan a');
$this->db->join('jabatan b', 'b.ID_JABATAN=a.JABATAN_ID');
$this->db->where(['ID_KARYAWAN' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Absensi_byKARYAWAN($id) {
$this->db->select('*');
$this->db->from('absensi a');
$this->db->join('karyawan b', 'b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where(['a.KARYAWAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_AdministratorAll() {
$this->db->select('*, b.NAMA_JABATAN');
$this->db->from('karyawan a');
$this->db->join('jabatan b', 'b.ID_JABATAN=a.JABATAN_ID');
$this->db->where('b.NAMA_JABATAN="ADMINISTRATOR"');
return $this->db->get()->result_array();
}
public function getData_SalesOrder_byKARYAWAN($id) {
$this->db->select('*');
$this->db->from('sales_order a');
$this->db->join('karyawan b', 'b.ID_KARYAWAN=a.SALES_ID');
$this->db->where(['a.SALES_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_PiutangKaryawan_byKARYAWAN($id) {
$this->db->select('*');
$this->db->from('piutang_karyawan a');
$this->db->join('karyawan b', 'b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where(['a.KARYAWAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_QualityControl_byKARYAWAN($id) {
$this->db->select('*');
$this->db->from('quality_control a');
$this->db->join('karyawan b', 'b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where(['a.KARYAWAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kas($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('kas');
} else {
$this->db->select('*');
$this->db->from('kas');
$this->db->where(['ID_KAS' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Kasbank_byKAS($id){
$this->db->select('*');
$this->db->from('kasbank');
$this->db->where(['KAS_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SaldoKas_byKAS($id){
$this->db->select('*');
$this->db->from('saldo_kas');
$this->db->where(['KAS_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kelompok($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('kelompok');
$this->db->order_by('NAMA_KELOMPOK ASC');
} else {
$this->db->select('*');
$this->db->from('kelompok');
$this->db->where(['ID_KELOMPOK' => $id]);
$this->db->order_by('NAMA_KELOMPOK ASC');
}
return $this->db->get()->result_array();
}
public function getData_Pelanggan_byKELOMPOK($id){
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kelompok b','b.ID_KELOMPOK=a.KELOMPOK_ID');
$this->db->where(['a.KELOMPOK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kendaraan($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('kendaraan');
$this->db->order_by('TYPE_KENDARAAN ASC');
} else {
$this->db->select('*');
$this->db->from('kendaraan');
$this->db->where(['ID_KENDARAAN' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_BiayaBensin_byKENDARAAN($id){
$this->db->select('*');
$this->db->from('biaya_bensin');
$this->db->where(['KENDARAAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_BiayaServiceKendaraan_byKENDARAAN($id){
$this->db->select('*');
$this->db->from('biaya_servicekendaraan');
$this->db->where(['KENDARAAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kota($id = null) {
if ($id === null) {
$this->db->select('*');
$this->db->from('kota');
$this->db->order_by('NAMA_KOTA ASC');
} else {
$this->db->select('*');
$this->db->from('kota ');
$this->db->order_by('NAMA_KOTA ASC');
$this->db->where(['ID_KOTA' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Supplier_byKOTA($id) {
$this->db->select('*');
$this->db->from('supplier a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->where(['a.KOTA_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Pelanggan_byKOTA($id) {
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->where(['a.KOTA_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Pihakke3_byKOTA($id) {
$this->db->select('*');
$this->db->from('pihakke3 a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->where(['a.KOTA_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Merk($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('merk');
$this->db->order_by('NAMA_MERK ASC');
} else {
$this->db->select('*');
$this->db->from('merk');
$this->db->where(['ID_MERK' => $id]);
$this->db->order_by('NAMA_MERK ASC');
}
return $this->db->get()->result_array();
}
public function getData_Menu($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('menu');
$this->db->order_by('KODE_MENU ASC, NAMA_MENU ASC');
} else {
$this->db->select('*');
$this->db->from('menu');
$this->db->where(['ID_MENU' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Barang_byMERK($id){
$this->db->select('*');
$this->db->from('barang a');
$this->db->join('merk b','b.ID_MERK=a.MERK_ID');
$this->db->where(['a.MERK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SetHakMenu_byMENU($id){
$this->db->select('*');
$this->db->from('set_hakmenu a');
$this->db->join('menu b','b.ID_MENU=a.MENU_ID');
$this->db->where(['a.MENU_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Merk_byNAMA($id1, $id2=null){
if ($id2 == null) {
$this->db->select('*');
$this->db->from('merk');
$this->db->where(['NAMA_MERK' => $id1]);
} else {
$this->db->select('*');
$this->db->from('merk');
$this->db->where(['NAMA_MERK' => $id1]);
$this->db->where('ID_MERK!=', $id2);
}
return $this->db->get()->result_array();
}
public function getData_Menu_byNAMA($id1, $id2=null){
if ($id2 == null) {
$this->db->select('*');
$this->db->from('menu');
$this->db->where(['NAMA_MENU' => $id1]);
} else {
$this->db->select('*');
$this->db->from('menu');
$this->db->where(['NAMA_MENU' => $id1]);
$this->db->where('ID_MENU!=', $id2);
}
return $this->db->get()->result_array();
}
public function getData_Menu_byKODE_byNAMA($id1, $id2, $id3=null){
if ($id3 == null) {
$this->db->select('*');
$this->db->from('menu');
$this->db->where(['KODE_MENU' => $id1]);
$this->db->where(['NAMA_MENU' => $id2]);
} else {
$this->db->select('*');
$this->db->from('menu');
$this->db->where(['KODE_MENU' => $id1]);
$this->db->where(['NAMA_MENU' => $id2]);
$this->db->where('ID_MENU!=', $id3);
}
return $this->db->get()->result_array();
}
public function getData_Model($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('model');
$this->db->order_by('NAMA_MODEL ASC');
} else {
$this->db->select('*');
$this->db->from('model');
$this->db->where(['ID_MODEL' => $id]);
$this->db->order_by('NAMA_MODEL ASC');
}
return $this->db->get()->result_array();
}
public function getData_Barang_byMODEL($id){
$this->db->select('*');
$this->db->from('barang a');
$this->db->join('model b','b.ID_MODEL=a.MODEL_ID');
$this->db->where(['a.MODEL_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Model_byNAMA($id1, $id2=null){
if ($id2 == null) {
$this->db->select('*');
$this->db->from('model');
$this->db->where(['NAMA_MODEL' => $id1]);
} else {
$this->db->select('*');
$this->db->from('model');
$this->db->where(['NAMA_MODEL' => $id1]);
$this->db->where('ID_MODEL!=', $id2);
}
return $this->db->get()->result_array();
}
public function getData_Part($id = null){
if ($id === null) {
$this->db->select('*,FORMAT(b.HPP_HPAR,2) as HPP,DATE_FORMAT(b.TGL_HPAR,"%d/%m/%Y") as TANGGAL');
$this->db->from('part a');
$this->db->join('harga_part b','b.PART_ID=a.ID_PART','left');
$this->db->order_by('a.NAMA_PART ASC, b.ID_HPAR DESC');
} else {
$this->db->select('*,FORMAT(b.HPP_HPAR,2) as HPP');
$this->db->from('part a');
$this->db->join('harga_part b','b.PART_ID=a.ID_PART','left');
$this->db->order_by('a.NAMA_PART ASC, b.ID_HPAR DESC');
$this->db->where(['b.PART_ID' => $id]);
}
return $this->db->get()->result_array();
}
public function getID_PartMax() {
$this->db->select_max('ID_PART');
$this->db->from('part');
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_byPART($id){
$this->db->select('*');
$this->db->from('transaksi_stock a');
$this->db->join('harga_part b','b.ID_HPAR=a.HPAR_ID');
$this->db->where(['b.PART_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Perkiraan($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('perkiraan');
$this->db->group_by('ID_PERKIRAAN');
$this->db->order_by('KODE_PERKIRAAN');
} else {
$this->db->select('*');
$this->db->from('perkiraan');
$this->db->group_by('ID_PERKIRAAN');
$this->db->order_by('KODE_PERKIRAAN');
$this->db->where(['ID_PERKIRAAN' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_DaftarKasbank_byPERKIRAAN($id){
$this->db->select('*');
$this->db->from('daftar_kasbank a');
$this->db->join('perkiraan b','b.ID_PERKIRAAN=a.PERKIRAAN_ID');
$this->db->where(['a.PERKIRAAN_ID' => $id]);
$this->db->limit('25');
return $this->db->get()->result_array();
}
public function getData_DaftarJurnalMemo_byPERKIRAAN($id){
$this->db->select('*');
$this->db->from('daftar_jurnalmemo a');
$this->db->join('perkiraan b','b.ID_PERKIRAAN=a.PERKIRAAN_ID');
$this->db->where(['a.PERKIRAAN_ID' => $id]);
$this->db->limit('25');
return $this->db->get()->result_array();
}
public function getData_Corp($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('corp');
} else {
$this->db->select('*');
$this->db->from('corp');
$this->db->where(['ID_CORP' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_SalesOrder_byCORP($id){
$this->db->select('*');
$this->db->from('sales_order a');
$this->db->join('corp b','b.ID_CORP=a.CORP_ID');
$this->db->where(['a.CORP_ID' => $id]);
$this->db->limit('25');
return $this->db->get()->result_array();
}
public function getData_DpPajak_byCORP($id){
$this->db->select('*');
$this->db->from('dp_pajak a');
$this->db->join('corp b','b.ID_CORP=a.CORP_ID');
$this->db->where(['a.CORP_ID' => $id]);
$this->db->limit('25');
return $this->db->get()->result_array();
}
public function getData_RekapPajak_byCORP($id){
$this->db->select('*');
$this->db->from('rekap_pajak a');
$this->db->join('corp b','b.ID_CORP=a.CORP_ID');
$this->db->where(['a.CORP_ID' => $id]);
$this->db->limit('25');
return $this->db->get()->result_array();
}
public function getData_PihakKe3($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('pihakke3 a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
} else {
$this->db->select('*');
$this->db->from('pihakke3 a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->where(['a.ID_PIHAKKE3' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_PiutangPihakKe3_byPIHAKKE3($id){
$this->db->select('*');
$this->db->from('piutang_pihakke3 a');
$this->db->join('pihakke3 b','b.ID_PIHAKKE3=a.PIHAKKE3_ID');
$this->db->where(['a.PIHAKKE3_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Posisi($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('posisi');
$this->db->order_by('NAMA_POSISI ASC');
} else {
$this->db->select('*');
$this->db->from('posisi');
$this->db->where(['ID_POSISI' => $id]);
$this->db->order_by('NAMA_POSISI ASC');
}
return $this->db->get()->result_array();
}
public function getData_Kontak_byPOSISI($id){
$this->db->select('*');
$this->db->from('kontak a');
$this->db->join('posisi b','b.ID_POSISI=a.POSISI_ID');
$this->db->where(['a.POSISI_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Program($id = null) {
if ($id === null) {
$this->db->select('*');
$this->db->from('program');
$this->db->order_by('NAMA_PROGRAM ASC');
} else {
$this->db->select('*');
$this->db->from('program');
$this->db->where(['ID_PROGRAM' => $id]);
$this->db->order_by('NAMA_PROGRAM ASC');
}
return $this->db->get()->result_array();
}
public function getData_LinkKlaimProgram_byPROGRAM($id) {
$this->db->select('*');
$this->db->from('link_klaimprogram a');
$this->db->join('program b','b.ID_PROGRAM=a.PROGRAM_ID');
$this->db->where(['a.PROGRAM_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Program_byNAMA($id1, $id2=null){
if ($id2 == null) {
$this->db->select('*');
$this->db->from('program');
$this->db->where(['NAMA_PROGRAM' => $id1]);
} else {
$this->db->select('*');
$this->db->from('program');
$this->db->where(['NAMA_PROGRAM' => $id1]);
$this->db->where('ID_PROGRAM!=', $id2);
}
return $this->db->get()->result_array();
}
public function getData_ServiceCenter($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('servicecenter');
$this->db->order_by('NAMA_SERVICECENTER');
} else {
$this->db->select('*');
$this->db->from('servicecenter');
$this->db->where(['ID_SERVICECENTER' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_ServiceCenter_byNAMA($nama, $id=null){
$this->db->select('*');
$this->db->from('servicecenter');
$this->db->where(['NAMA_SERVICECENTER' => $nama]);
if ($id!=null) {
$this->db->where('ID_SERVICECENTER!=', $id);
}
return $this->db->get()->result_array();
}
public function getData_KlaimService_bySERVICECENTER($id){
$this->db->select('*');
$this->db->from('klaim_service');
$this->db->where(['SERVICECENTER_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_UnitService($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('unitservice a');
$this->db->join('jenis b','b.ID_JENIS=a.JENIS_ID');
$this->db->order_by('a.NAMA_UNITSERVICE');
} else {
$this->db->select('*');
$this->db->from('unitservice');
$this->db->where(['ID_UNITSERVICE' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_UnitProyek($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('unitproyek');
$this->db->order_by('NAMA_UNITPROYEK');
} else {
$this->db->select('*');
$this->db->from('unitproyek');
$this->db->where(['ID_UNITPROYEK' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Produk($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('produk');
$this->db->order_by('NAMA_PRODUK');
} else {
$this->db->select('*');
$this->db->from('produk');
$this->db->where(['ID_PRODUK' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_UnitService_byNAMA($nama, $id=null){
$this->db->select('*');
$this->db->from('unitservice');
$this->db->where(['NAMA_UNITSERVICE' => $nama]);
if ($id!=null) {
$this->db->where('ID_UNITSERVICE!=', $id);
}
return $this->db->get()->result_array();
}
public function getData_UnitProyek_byNAMA($nama, $id=null){
$this->db->select('*');
$this->db->from('unitproyek');
$this->db->where(['NAMA_UNITPROYEK' => $nama]);
if ($id!=null) {
$this->db->where('ID_UNITPROYEK!=', $id);
}
return $this->db->get()->result_array();
}
public function getData_Produk_byNAMA($nama, $id=null){
$this->db->select('*');
$this->db->from('produk');
$this->db->where(['NAMA_PRODUK' => $nama]);
if ($id!=null) {
$this->db->where('ID_PRODUK!=', $id);
}
return $this->db->get()->result_array();
}
public function getData_SnService_byUNITSERVICE($id){
$this->db->select('*');
$this->db->from('sn_service');
$this->db->where(['UNITSERVICE_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarAkuntansi_byUNITPROYEK($id){
$this->db->select('*');
$this->db->from('daftar_akuntansi');
$this->db->where(['UNITPROYEK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarAkuntansi_byPELANGGAN($id){
$this->db->select('*');
$this->db->from('daftar_akuntansi');
$this->db->where(['PELANGGAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_CreditNote_byPRODUK($id){
$this->db->select('*');
$this->db->from('creditnote');
$this->db->where(['PRODUK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarSjService_byUNITSERVICE_byFSS($id1, $id2){
$this->db->select('*');
$this->db->from('daftar_sjservice a');
$this->db->join('sn_service b','b.ID_SNS=a.SNS_ID');
$this->db->where(['a.UNITSERVICE_ID' => $id1]);
$this->db->where(['a.FSS_ID' => $id2]);
return $this->db->get()->result_array();
}
public function getData_DaftarSjService_byID($id){
$this->db->select('*');
$this->db->from('daftar_sjservice');
$this->db->where(['ID_DFSS' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnService_byPELANGGAN($id){
$this->db->select('*');
$this->db->from('sn_service a');
$this->db->join('service b','b.ID_SERVICE=a.SERVICE_ID');
$this->db->join('unitservice c','c.ID_UNITSERVICE=a.UNITSERVICE_ID');
$this->db->where(['b.PELANGGAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnService_byID($id){
$this->db->select('*');
$this->db->from('sn_service');
$this->db->where(['ID_SNS' => $id]);
return $this->db->get()->result_array();
}
public function getData_Jenis_BIAYANot0(){
$this->db->select('*');
$this->db->from('jenis');
$this->db->where('BIAYA_SERVICE!="0.00"');
return $this->db->get()->result_array();
}
public function getData_SetSupplier_byKARYAWAN($id) {
$this->db->select('*');
$this->db->from('set_supplier');
$this->db->where('KARYAWAN_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_Supplier_byNAMA_byKOTA($nama = null, $kota = null) {
$this->db->select('*');
$this->db->from('supplier a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
if ($nama != null) {
$this->db->like('a.NAMA_SUPPLIER', $nama, 'both');
}
if ($kota != 0) {
$this->db->where('a.KOTA_ID=', $kota);
}
$this->db->order_by('a.NAMA_SUPPLIER ASC, b.NAMA_KOTA ASC');
return $this->db->get()->result_array();
}
public function getData_Supplier_orderDESC_limit10(){
$this->db->select('*');
$this->db->from('supplier a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->order_by('a.ID_SUPPLIER DESC');
$this->db->limit('10');
return $this->db->get()->result_array();
}
public function getData_DaftarKlaimProgram_bySUPPLIER($id){
$this->db->select('*');
$this->db->from('daftar_klaimprogram a');
$this->db->join('supplier b','b.ID_SUPPLIER=a.SUPPLIER_ID','left');
$this->db->where(['a.SUPPLIER_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_DpPembelian_bySUPPLIER($id){
$this->db->select('*');
$this->db->from('dp_pembelian');
$this->db->where(['SUPPLIER_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_HutangDagang_bySUPPLIER($id){
$this->db->select('*');
$this->db->from('hutang_dagang a');
$this->db->join('supplier b','b.ID_SUPPLIER=a.SUPPLIER_ID','left');
$this->db->where(['a.SUPPLIER_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Pembelian_bySUPPLIER($id){
$this->db->select('*');
$this->db->from('pembelian a');
$this->db->join('supplier b','b.ID_SUPPLIER=a.SUPPLIER_ID','left');
$this->db->where(['a.SUPPLIER_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Pelanggan_orderDESC_limit10(){
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->order_by('a.ID_PELANGGAN DESC');
$this->db->limit('10');
return $this->db->get()->result_array();
}
public function getData_SetPelanggan_byKARYAWAN($id) {
$this->db->select('*');
$this->db->from('set_pelanggan');
$this->db->where('KARYAWAN_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_Pelanggan_byNAMA_byTYPE_byKOTA_byKELOMPOK($nama = null, $type = null, $kota = null, $kelompok = null) {
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->join('kelompok c','c.ID_KELOMPOK=a.KELOMPOK_ID','left');
if ($nama != null) {
$this->db->like('a.NAMA_PELANGGAN', $nama, 'both');
}
if ($type != 9) {
$this->db->where('a.TYPE_PELANGGAN=', $type);
}
if ($kota != 0) {
$this->db->where('a.KOTA_ID=', $kota);
}
if ($kelompok != 0) {
$this->db->where('a.KELOMPOK_ID=', $kelompok);
}
$this->db->order_by('a.TYPE_PELANGGAN ASC, a.NAMA_PELANGGAN ASC, b.NAMA_KOTA ASC');
$this->db->limit('100');
return $this->db->get()->result_array();
}
public function getData_Pelanggan_byNAMA_byTYPE_byKOTA_byKELOMPOK_forExcel($nama = null, $type = null, $kota = null, $kelompok = null) {
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->join('kelompok c','c.ID_KELOMPOK=a.KELOMPOK_ID','left');
if ($nama != null) {
$this->db->like('a.NAMA_PELANGGAN', $nama, 'both');
}
if ($type != 9) {
$this->db->where('a.TYPE_PELANGGAN=', $type);
}
if ($kota != 0) {
$this->db->where('a.KOTA_ID=', $kota);
}
if ($kelompok != 0) {
$this->db->where('a.KELOMPOK_ID=', $kelompok);
}
$this->db->order_by('a.TYPE_PELANGGAN ASC, a.NAMA_PELANGGAN ASC, b.NAMA_KOTA ASC');
return $this->db->get()->result_array();
}
public function getData_SalesOrder_byPELANGGAN($id) {
$this->db->select('*');
$this->db->from('sales_order');
$this->db->where(['PELANGGAN_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_HistoriSn_byPELANGGAN($id) {
$this->db->select('*');
$this->db->from('histori_sn');
$this->db->where(['PELANGGAN_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_PiutangDagang_byPELANGGAN($id) {
$this->db->select('*');
$this->db->from('piutang_dagang');
$this->db->where(['PELANGGAN_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_DpPenjualan_byPELANGGAN($id) {
$this->db->select('*');
$this->db->from('dp_penjualan');
$this->db->where(['PELANGGAN_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_Service_byPELANGGAN($id){
$this->db->select('*');
$this->db->from('service');
$this->db->where('PELANGGAN_ID=', $id);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_Pelanggan_byNAMA($id){
$this->db->select('*');
$this->db->from('pelanggan');
$this->db->where(['NAMA_PELANGGAN' => $id]);
return $this->db->get()->result_array();
}
public function getData_Pelanggan_byID($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID','left');
$this->db->join('kelompok c','c.ID_KELOMPOK=a.KELOMPOK_ID','left');
$this->db->order_by('a.NAMA_PELANGGAN ASC');
} else {
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID','left');
$this->db->join('kelompok c','c.ID_KELOMPOK=a.KELOMPOK_ID','left');
$this->db->join('sales_order d','d.PELANGGAN_ID=a.ID_PELANGGAN','left');
$this->db->join('penjualan e','e.SO_ID=d.ID_SO','left');
$this->db->order_by('a.TYPE_PELANGGAN ASC');
$this->db->group_by('a.ID_PELANGGAN');
$this->db->where(['a.ID_PELANGGAN' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Barang_orderDESC_limit10(){
$this->db->select('*');
$this->db->from('barang a');
$this->db->join('jenis b','b.ID_JENIS=a.JENIS_ID');
$this->db->order_by('a.ID_BARANG DESC');
$this->db->limit('10');
return $this->db->get()->result_array();
}
public function getData_SetBarang_byKARYAWAN($id) {
$this->db->select('*');
$this->db->from('set_barang');
$this->db->where('KARYAWAN_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_Barang_byKODE_byJENIS_byMERK_byMODEL_byPRODUK($kode = null, $jenis = null, $merk = null, $model = null, $produk = null) {
$this->db->select('*');
$this->db->from('barang a');
$this->db->join('jenis b','b.ID_JENIS=a.JENIS_ID');
$this->db->join('merk c','c.ID_MERK=a.MERK_ID');
$this->db->join('model d','d.ID_MODEL=a.MODEL_ID','left');
$this->db->join('produk e','e.ID_PRODUK=a.PRODUK_ID','left');
if ($kode != null) {
$this->db->like('a.KODE_BARANG', $kode, 'both');
}
if ($jenis != 0) {
$this->db->where('a.JENIS_ID=', $jenis);
}
if ($merk != 0) {
$this->db->where('a.MERK_ID=', $merk);
}
if ($model != 0) {
$this->db->where('a.MODEL_ID=', $model);
}
if ($produk != 0) {
$this->db->where('a.PRODUK_ID=', $produk);
}
$this->db->order_by('b.NAMA_JENIS ASC, a.KODE_BARANG ASC, a.NAMA_BARANG ASC');
$this->db->limit('100');
return $this->db->get()->result_array();
}
public function getData_Barang_byKODE($kode, $id=null){
$this->db->select('*');
$this->db->from('barang');
$this->db->where(['KODE_BARANG' => $kode]);
if ($id!=null) {
$this->db->where('ID_BARANG!=', $id);
}
return $this->db->get()->result_array();
}
public function getData_Barang_byNAMA($nama, $id=null){
$this->db->select('*');
$this->db->from('barang');
$this->db->where(['NAMA_BARANG' => $nama]);
if ($id!=null) {
$this->db->where('ID_BARANG!=', $id);
}
return $this->db->get()->result_array();
}
public function getID_BarangMax() {
$this->db->select_max('ID_BARANG');
$this->db->from('barang');
return $this->db->get()->result_array();
}
public function getData_Barang($id = null){
if ($id === null) {
$this->db->select('a.ID_BARANG,a.KODE_BARANG,a.NAMA_BARANG,a.JENIS_ID,b.NAMA_JENIS');
$this->db->from('barang a');
$this->db->join('jenis b','b.ID_JENIS=a.JENIS_ID');
$this->db->order_by('a.KODE_BARANG ASC');
}else{
$this->db->select('*');
$this->db->from('barang a');
$this->db->join('jenis b','b.ID_JENIS=a.JENIS_ID');
$this->db->where(['a.ID_BARANG' => $id]);
$this->db->group_by('a.ID_BARANG');
$this->db->order_by('b.NAMA_JENIS ASC,a.KODE_BARANG ASC');
}
return $this->db->get()->result_array();
}
public function getData_Jenis_byID($id){
$this->db->select('*');
$this->db->from('jenis');
$this->db->where(['ID_JENIS' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarBeli_byBARANG($id){
$this->db->select('*');
$this->db->from('daftar_beli');
$this->db->where(['BARANG_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_DaftarOrder_byBARANG($id){
$this->db->select('*');
$this->db->from('daftar_order');
$this->db->where(['BARANG_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_SnStock_byBARANG($id){
$this->db->select('*');
$this->db->from('sn_stock');
$this->db->where(['BARANG_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_byBARANG($id){
$this->db->select('*');
$this->db->from('transaksi_stock');
$this->db->where(['BARANG_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_Kontak($id = null){
if ($id === null) {
$this->db->select('*');
$this->db->from('kontak a');
$this->db->join('posisi b','b.ID_POSISI=a.POSISI_ID');
$this->db->join('akun c','c.ID_AKUN=a.AKUN_ID');
$this->db->order_by('c.NAMA_AKUN ASC, a.NAMA_KONTAK ASC');
} else {
$this->db->select('*');
$this->db->from('kontak a');
$this->db->join('posisi b','b.ID_POSISI=a.POSISI_ID');
$this->db->join('akun c','c.ID_AKUN=a.AKUN_ID');
$this->db->order_by('c.NAMA_AKUN ASC, a.NAMA_KONTAK ASC');
$this->db->where(['a.AKUN_ID' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_SalesVisit_byKONTAK($id){
$this->db->select('*');
$this->db->from('sales_visit');
$this->db->where(['KONTAK_ID' => $id]);
$this->db->limit('5');
return $this->db->get()->result_array();
}
public function getData_Kontak_byNAMA($id1, $id2=null){
if ($id2 == null) {
$this->db->select('*');
$this->db->from('kontak');
$this->db->where(['NAMA_KONTAK' => $id1]);
} else {
$this->db->select('*');
$this->db->from('kontak');
$this->db->where(['NAMA_KONTAK' => $id1]);
$this->db->where('ID_KONTAK!=', $id2);
}
return $this->db->get()->result_array();
}
public function getData_LogNotifikasi_byKARYAWAN_status0($id) {
$this->db->select('*,DATE_FORMAT(b.TGL_NOTIFIKASI,"%d/%m/%Y") as TANGGAL');
$this->db->from('log_notifikasi a');
$this->db->join('notifikasi b','b.ID_NOTIFIKASI=a.NOTIFIKASI_ID');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->where('a.STATUS=0');
$this->db->order_by('b.TGL_NOTIFIKASI');
return $this->db->get()->result_array();
}
public function addTempoDay($date, $day) {
$sum = strtotime(date("Y-m-d", strtotime("$date")) . " +$day days");
$dateTo=date('Y-m-d',$sum);
return $dateTo;
}
public function subTempoDay($date, $day) {
$sum = strtotime(date("Y-m-d", strtotime("$date")) . " -$day days");
$dateTo=date('Y-m-d',$sum);
return $dateTo;
}
public function getData_LogNotifikasi_byID($id) {
$this->db->select('*,DATE_FORMAT(b.TGL_NOTIFIKASI,"%d/%m/%Y") as TANGGAL');
$this->db->from('log_notifikasi a');
$this->db->join('notifikasi b','b.ID_NOTIFIKASI=a.NOTIFIKASI_ID');
$this->db->where('a.ID_LOG_NOTIFIKASI=', $id);
return $this->db->get()->result_array();
}
public function getData_LogNotifikasi_byKARYAWAN_allStatus($id) {
$this->db->select('*,DATE_FORMAT(b.TGL_NOTIFIKASI,"%d/%m/%Y") as TANGGAL');
$this->db->from('log_notifikasi a');
$this->db->join('notifikasi b','b.ID_NOTIFIKASI=a.NOTIFIKASI_ID');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->order_by('b.TGL_NOTIFIKASI');
return $this->db->get()->result_array();
}
public function getData_FormTandaTerima_byKARYAWAN_status0($id) {
$this->db->select('*');
$this->db->from('form_tandaterima a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID','left');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID','left');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID','left');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->where('a.STATUS_FTT=0');
return $this->db->get()->result_array();
}
public function getData_FormTTKosong_byKARYAWAN_status0($id) {
$this->db->select('*');
$this->db->from('form_ttkosong a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->where('a.STATUS_FTTK=0');
return $this->db->get()->result_array();
}
public function getData_FormSjService_byKARYAWAN_status0($id) {
$this->db->select('*');
$this->db->from('form_sjservice a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID','left');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->where('a.STATUS_FSS=0');
return $this->db->get()->result_array();
}
public function getData_FormNotaPembayaran_byKARYAWAN_status0($id) {
$this->db->select('*');
$this->db->from('form_notapembayaran a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID','left');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->where('a.STATUS_FNP=0');
return $this->db->get()->result_array();
}
public function getData_DpPenjualan_limit3Month_DKBNotNull() {
$tgl = date('Y-m-d');
$tgl_down = $this->subTempoDay($tgl, 90);
$this->db->select('*,FORMAT(a.KREDIT_DAK,2) as NILAI,DATE_FORMAT(b.TGL_AKUNTANSI,"%d/%m/%Y") as TANGGAL');
$this->db->from('daftar_akuntansi a');
$this->db->join('akuntansi b','b.ID_AKUNTANSI=a.AKUNTANSI_ID');
$this->db->join('pelanggan c','c.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->join('kota d','d.ID_KOTA=c.KOTA_ID');
$this->db->where('b.TGL_AKUNTANSI>=', $tgl_down);
$this->db->where('b.TGL_AKUNTANSI<=', $tgl);
$this->db->where('a.PERKIRAAN_ID=19');
$this->db->group_by('a.MAIN_DPJ');
$this->db->order_by('b.TGL_AKUNTANSI DESC, b.KODE_AKUNTANSI ASC');
return $this->db->get()->result_array();
}
public function getData_FormProforma_byKARYAWAN_status0($id) {
$this->db->select('*');
$this->db->from('form_proforma a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID','left');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->where('a.STATUS_FPF=0');
return $this->db->get()->result_array();
}
public function getData_FormNotaDp_byKARYAWAN_status0($id) {
$this->db->select('*');
$this->db->from('nota_bebas a');
//$this->db->join('daftar_akuntansi b','b.ID_DAK=a.DPJ_ID','left');
$this->db->join('pelanggan c','c.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota d','d.ID_KOTA=c.KOTA_ID','left');
$this->db->where('a.KARYAWAN_ID=', $id);
$this->db->where('a.STATUS_NB=0');
return $this->db->get()->result_array();
}
public function getData_FormProforma_byID($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TANGGAL');
$this->db->from('form_proforma a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID');
$this->db->where('a.ID_FPF=', $id);
return $this->db->get()->result_array();
}
public function getData_FormNotaDp_byID($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TANGGAL');
$this->db->from('form_notadp a');
$this->db->join('daftar_akuntansi b','b.ID_DAK=a.DPJ_ID');
$this->db->join('pelanggan c','c.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->join('kota d','d.ID_KOTA=c.KOTA_ID');
$this->db->where('a.ID_FND=', $id);
return $this->db->get()->result_array();
}
public function getKode_ProformaTMP() {
$this->db->select('MAX(KODE_FPF) AS KODE');
$this->db->from('form_proforma');
$this->db->like('KODE_FPF','PF/TMP', 'after');
return $this->db->get()->result_array();
}
public function getKode_ProformaDMT() {
$this->db->select('MAX(KODE_FPF) AS KODE');
$this->db->from('form_proforma');
$this->db->like('KODE_FPF','PF/DMT', 'after');
return $this->db->get()->result_array();
}
public function getKode_ProformaPCM() {
$this->db->select('MAX(KODE_FPF) AS KODE');
$this->db->from('form_proforma');
$this->db->like('KODE_FPF','PF/PCM', 'after');
return $this->db->get()->result_array();
}
public function getKode_ProformaSFT() {
$this->db->select('MAX(KODE_FPF) AS KODE');
$this->db->from('form_proforma');
$this->db->like('KODE_FPF','PF/SFT', 'after');
return $this->db->get()->result_array();
}
public function getKode_ProformaITP() {
$this->db->select('MAX(KODE_FPF) AS KODE');
$this->db->from('form_proforma');
$this->db->like('KODE_FPF','PF/ITP', 'after');
return $this->db->get()->result_array();
}
public function getKode_DPNotaTMP() {
$this->db->select('MAX(KODE_FND) AS KODE');
$this->db->from('form_notadp');
$this->db->like('KODE_FND','DP/TMP', 'after');
return $this->db->get()->result_array();
}
public function getKode_DPNotaDMT() {
$this->db->select('MAX(KODE_FND) AS KODE');
$this->db->from('form_notadp');
$this->db->like('KODE_FND','DP/DMT', 'after');
return $this->db->get()->result_array();
}
public function getKode_DPNotaPCM() {
$this->db->select('MAX(KODE_FND) AS KODE');
$this->db->from('form_notadp');
$this->db->like('KODE_FND','DP/PCM', 'after');
return $this->db->get()->result_array();
}
public function getKode_DPNotaSFT() {
$this->db->select('MAX(KODE_FND) AS KODE');
$this->db->from('form_notadp');
$this->db->like('KODE_FND','DP/SFT', 'after');
return $this->db->get()->result_array();
}
public function getKode_DPNotaITP() {
$this->db->select('MAX(KODE_FND) AS KODE');
$this->db->from('form_notadp');
$this->db->like('KODE_FND','DP/ITP', 'after');
return $this->db->get()->result_array();
}
public function getData_DaftarProforma_byFPF($id) {
$this->db->select('*,FORMAT(a.HARGA_DFPF,2) as HARGA,FORMAT((a.HARGA_DFPF*a.QTY_DFPF),2) as SUBTOTAL');
$this->db->from('daftar_proforma a');
$this->db->join('form_proforma b','b.ID_FPF=a.FPF_ID');
$this->db->where('a.FPF_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarNotaDp_byFND($id) {
$this->db->select('*,FORMAT(a.HARGA_DFND,2) as HARGA,FORMAT((a.HARGA_DFND*a.QTY_DFND),2) as SUBTOTAL');
$this->db->from('daftar_notadp a');
$this->db->join('form_notadp b','b.ID_FND=a.FND_ID');
$this->db->where('a.FND_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_Proyek_byID($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_PROYEK,"%d/%m/%Y") as TANGGAL');
$this->db->from('proyek a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.ID_PROYEK=', $id);
return $this->db->get()->result_array();
}
public function getData_Proyek_byKARYAWAN_statusNull($id) {
$this->db->select('*');
$this->db->from('proyek a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.SALES_ID=', $id);
$this->db->where('a.STATUS_PROYEK is NULL');
return $this->db->get()->result_array();
}
public function getData_Proyek_byPELANGGAN($id) {
$this->db->select('*');
$this->db->from('proyek a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.PELANGGAN_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_FormTandaTerima_status1_limit2Month_orderDESC() {
$tgl = date('Y-m-d');
$tgl_down = $this->subTempoDay($tgl, 60);
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_tandaterima a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID','left');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID','left');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID','left');
$this->db->join('kota e','e.ID_KOTA=d.KOTA_ID','left');
$this->db->join('karyawan f','f.ID_KARYAWAN=a.KARYAWAN_ID','left');
$this->db->where('a.STATUS_FTT=1');
$this->db->where('a.TGL_INPUT>=', $tgl_down);
$this->db->where('a.TGL_INPUT<=', $tgl);
$this->db->order_by('a.ID_FTT DESC');
return $this->db->get()->result_array();
}
public function getData_FormTTKosong_status1_limit2Month_orderDESC() {
$tgl = date('Y-m-d');
$tgl_down = $this->subTempoDay($tgl, 60);
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_ttkosong a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where('a.STATUS_FTTK=1');
$this->db->where('a.TGL_INPUT>=', $tgl_down);
$this->db->where('a.TGL_INPUT<=', $tgl);
$this->db->order_by('a.ID_FTTK DESC');
return $this->db->get()->result_array();
}
public function getData_FormNotaPembayaran_status1_limit2Month_orderDESC() {
$tgl = date('Y-m-d');
$tgl_down = $this->subTempoDay($tgl, 60);
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_notapembayaran a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID','left');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.KARYAWAN_ID','left');
$this->db->where('a.STATUS_FNP=1');
$this->db->where('a.TGL_INPUT>=', $tgl_down);
$this->db->where('a.TGL_INPUT<=', $tgl);
$this->db->order_by('a.ID_FNP DESC');
return $this->db->get()->result_array();
}
public function getData_FormProforma_status1_limit2Month_orderDESC() {
$tgl = date('Y-m-d');
$tgl_down = $this->subTempoDay($tgl, 60);
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT,d.NAMA_PANGGILAN_KARYAWAN as PEMBUAT,e.NAMA_PANGGILAN_KARYAWAN as PENGEDIT');
$this->db->from('form_proforma a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID','left');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.KARYAWAN_ID','left');
$this->db->join('karyawan e','e.ID_KARYAWAN=a.EDIT_ID','left');
$this->db->where('a.STATUS_FPF=1');
$this->db->where('a.TGL_INPUT>=', $tgl_down);
$this->db->where('a.TGL_INPUT<=', $tgl);
$this->db->order_by('a.ID_FPF DESC');
return $this->db->get()->result_array();
}
public function getData_FormNotaDp_status1_limit2Month_orderDESC() {
$tgl = date('Y-m-d');
$tgl_down = $this->subTempoDay($tgl, 60);
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT,e.NAMA_PANGGILAN_KARYAWAN as PEMBUAT,f.NAMA_PANGGILAN_KARYAWAN as PENGEDIT');
$this->db->from('form_notadp a');
$this->db->join('daftar_akuntansi b','b.ID_DAK=a.DPJ_ID','left');
$this->db->join('pelanggan c','c.ID_PELANGGAN=b.PELANGGAN_ID','left');
$this->db->join('kota d','d.ID_KOTA=c.KOTA_ID','left');
$this->db->join('karyawan e','e.ID_KARYAWAN=a.KARYAWAN_ID','left');
$this->db->join('karyawan f','f.ID_KARYAWAN=a.EDIT_ID','left');
$this->db->where('a.STATUS_FND=1');
$this->db->where('a.TGL_INPUT>=', $tgl_down);
$this->db->where('a.TGL_INPUT<=', $tgl);
$this->db->order_by('a.ID_FND DESC');
return $this->db->get()->result_array();
}
public function getData_FormSjService_status1_limit3Month_orderDESC($id) {
$tgl_now = date('Y-m-d');
$tgl_down = $this->subTempoDay($tgl_now, 90);
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_sjservice a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID','left');
$this->db->where('a.STATUS_FSS=1');
$this->db->where('a.TGL_INPUT<=', $tgl_now);
$this->db->where('a.TGL_INPUT>=', $tgl_down);
$this->db->order_by('a.ID_FSS DESC');
return $this->db->get()->result_array();
}
public function getData_FormTandaTerima_byID_status0($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_tandaterima a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID','left');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID','left');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID','left');
$this->db->where('a.ID_FTT=', $id);
$this->db->where('a.STATUS_FTT=0');
return $this->db->get()->result_array();
}
public function getData_FormTTKosong_byID_status0($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_ttkosong a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.ID_FTTK=', $id);
$this->db->where('a.STATUS_FTTK=0');
return $this->db->get()->result_array();
}
public function getData_FormTTKosong_byID_status1($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_ttkosong a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.ID_FTTK=', $id);
$this->db->where('a.STATUS_FTTK=1');
return $this->db->get()->result_array();
}
public function getData_FormNotaPembayaran_byID_status0($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_notapembayaran a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.ID_FNP=', $id);
$this->db->where('a.STATUS_FNP=0');
return $this->db->get()->result_array();
}
public function getData_FormProforma_byID_status0($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_proforma a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.ID_FPF=', $id);
$this->db->where('a.STATUS_FPF=0');
return $this->db->get()->result_array();
}
public function getData_FormProforma_byID_status1($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_proforma a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.ID_FPF=', $id);
$this->db->where('a.STATUS_FPF=1');
return $this->db->get()->result_array();
}
public function getData_FormNotaDp_byID_status0($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_notadp a');
$this->db->join('daftar_akuntansi b','b.ID_DAK=a.DPJ_ID');
$this->db->join('pelanggan c','c.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->where('a.ID_FND=', $id);
$this->db->where('a.STATUS_FND=0');
return $this->db->get()->result_array();
}
public function getData_FormNotaDp_byID_status1($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_notadp a');
$this->db->join('daftar_akuntansi b','b.ID_DAK=a.DPJ_ID');
$this->db->join('pelanggan c','c.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->where('a.ID_FND=', $id);
$this->db->where('a.STATUS_FND=1');
return $this->db->get()->result_array();
}
public function getData_FormNotaDp_byID_status3($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_notadp a');
$this->db->join('daftar_akuntansi b','b.ID_DAK=a.DPJ_ID');
$this->db->join('pelanggan c','c.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->where('a.ID_FND=', $id);
$this->db->where('a.STATUS_FND=3');
return $this->db->get()->result_array();
}
public function getData_FormNotaPembayaran_byID_status1($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_notapembayaran a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->where('a.ID_FNP=', $id);
$this->db->where('a.STATUS_FNP=1');
return $this->db->get()->result_array();
}
public function getData_FormSjService_byID_status0($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_sjservice a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->where('a.ID_FSS=', $id);
$this->db->where('a.STATUS_FSS=0');
return $this->db->get()->result_array();
}
public function getData_FormSjService_byID_status1($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_sjservice a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->where('a.ID_FSS=', $id);
$this->db->where('a.STATUS_FSS=1');
return $this->db->get()->result_array();
}
public function getData_FormTandaTerima_byID_status1($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_INPUT,"%d/%m/%Y") as TGLINPUT');
$this->db->from('form_tandaterima a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID','left');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID','left');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID','left');
$this->db->where('a.ID_FTT=', $id);
$this->db->where('a.STATUS_FTT=1');
return $this->db->get()->result_array();
}
public function getData_DaftarTandaTerima_byFTT($id) {
$this->db->select('*');
$this->db->from('daftar_tandaterima a');
$this->db->join('form_tandaterima b','b.ID_FTT=a.FTT_ID');
$this->db->where('a.FTT_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarTTKosong_byFTTK($id) {
$this->db->select('*');
$this->db->from('daftar_ttkosong a');
$this->db->join('form_ttkosong b','b.ID_FTTK=a.FTTK_ID');
$this->db->where('a.FTTK_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarTTKosong_byID($id) {
$this->db->select('*');
$this->db->from('daftar_ttkosong a');
$this->db->join('form_ttkosong b','b.ID_FTTK=a.FTTK_ID');
$this->db->where('a.ID_DFTTK=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarSjService_byFSS_groupUNITSERVICE($id) {
$this->db->select('*,COUNT(a.ID_DFSS) as COT');
$this->db->from('daftar_sjservice a');
$this->db->join('form_sjservice b','b.ID_FSS=a.FSS_ID');
$this->db->join('unitservice c','c.ID_UNITSERVICE=a.UNITSERVICE_ID');
$this->db->where('a.FSS_ID=', $id);
$this->db->group_by('a.UNITSERVICE_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarTandaTerima_byFTT_status1($id) {
$this->db->select('*');
$this->db->from('daftar_tandaterima a');
$this->db->join('form_tandaterima b','b.ID_FTT=a.FTT_ID');
$this->db->where('a.FTT_ID=', $id);
$this->db->where('a.STATUS_DFTT=1');
return $this->db->get()->result_array();
}
public function getData_DaftarTandaTerima_byID($id) {
$this->db->select('*');
$this->db->from('daftar_tandaterima a');
$this->db->join('form_tandaterima b','b.ID_FTT=a.FTT_ID');
$this->db->where('a.ID_DFTT=', $id);
return $this->db->get()->result_array();
}
public function getData_KolomTt() {
$this->db->select('*');
$this->db->from('kolom_tt');
return $this->db->get()->result_array();
}
public function getData_KolomTt_byFTT_jenis0($id) {
$this->db->select('*');
$this->db->from('kolom_tt a');
$this->db->join('daftar_tandaterima b','b.KTT_ID=a.ID_KTT');
$this->db->where('b.FTT_ID=', $id);
$this->db->where('a.JENIS_KTT=0');
return $this->db->get()->result_array();
}
public function getData_FormKaryawan_byKARYAWAN_statusNull($id) {
$this->db->select('*');
$this->db->from('form_karyawan');
$this->db->where('STATUS_FK is NULL AND KARYAWAN_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_FormFeePelanggan_tungguACC($id) {
$this->db->select('*,FORMAT(a.NILAI_FFP,2) as NILAI,DATE_FORMAT(a.TGL_FFP,"%d/%m/%Y") as TANGGAL');
$this->db->from('form_feepelanggan a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->join('penjualan c','c.ID_PENJUALAN=a.PENJUALAN_ID');
$this->db->join('sales_order d','d.ID_SO=c.SO_ID');
$this->db->join('pelanggan e','e.ID_PELANGGAN=d.PELANGGAN_ID');
$this->db->join('kota f','f.ID_KOTA=e.KOTA_ID');
if ($id==1 OR $id==5 OR $id==8 OR $id==15 OR $id==18 OR $id==34 OR $id==42 OR $id==50 OR $id==55) {
$this->db->where('a.STATUS_FFP=0');
} else if ($id==21) {
$this->db->where('a.STATUS_FFP=0 AND a.KARYAWAN_ID=28');
$this->db->or_where('a.STATUS_FFP=0 AND a.KARYAWAN_ID=30');
} else {
$this->db->where('a.STATUS_FFP=0 AND a.KARYAWAN_ID=', $id);
}
return $this->db->get()->result_array();
}
public function getData_FormKaryawan_tungguACC($id) {
$this->db->select('*,b.NAMA_PANGGILAN_KARYAWAN as NAMA_SALES,c.NAMA_PANGGILAN_KARYAWAN as NAMA_KARYAWAN,d.NAMA_PANGGILAN_KARYAWAN as NAMA_MENGETAHUI,
FORMAT(a.NILAI_FK,2) as NILAI,DATE_FORMAT(a.TGL_FK,"%d/%m/%Y") as TANGGAL');
$this->db->from('form_karyawan a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.SALES_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.MENGETAHUI_ID','left');
if ($id==1 OR $id==2 OR $id==4 OR $id==6 OR $id==15 OR $id==42 OR $id==50 OR $id==55) {
$this->db->where('a.STATUS_FK=0');
} else {
$this->db->where('a.STATUS_FK=0 AND a.KARYAWAN_ID=', $id);
$this->db->or_where('a.STATUS_FK=0 AND a.SALES_ID=', $id);
}
$this->db->order_by('a.STATUS_FK DESC, a.TGL_FK ASC');
return $this->db->get()->result_array();
}
public function getData_FormKaryawan_jenis3_status0_allCheck() {
$this->db->select('*,FORMAT(a.NILAI_FK,2) as NILAI,DATE_FORMAT(a.TGL_FK,"%d/%m/%Y") as TANGGAL');
$this->db->from('form_karyawan a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.SALES_ID');
$this->db->where('a.STATUS_FK=0');
$this->db->where('a.JENIS_FK=3');
$this->db->where('a.CONFIRM_FK_S is NOT NULL');
$this->db->where('a.CONFIRM_FK_O is NOT NULL');
$this->db->where('a.CONFIRM_FK_P is NOT NULL');
return $this->db->get()->result_array();
}
public function getData_FormTTKosong_byID($id) {
$this->db->select('*');
$this->db->from('form_ttkosong');
$this->db->where('ID_FTTK=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarFormKaryawan_jenis4() {
$this->db->select('*');
$this->db->from('daftar_formkaryawan');
$this->db->where('JENIS_DFFK=4');
return $this->db->get()->result_array();
}
public function getData_DaftarFormKaryawan_statusNull($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_DFFK,"%d/%m/%Y") as TANGGAL,FORMAT(a.NILAI_DFFK,2) as NILAI');
$this->db->from('daftar_formkaryawan a');
$this->db->join('form_karyawan b','b.ID_FK=a.FK_ID');
$this->db->where('a.FK_ID=', $id);
$this->db->where('b.STATUS_FK is NULL');
return $this->db->get()->result_array();
}
public function getData_DaftarFormKaryawan_status0($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_DFFK,"%d/%m/%Y") as TANGGAL,FORMAT(a.NILAI_DFFK,2) as NILAI');
$this->db->from('daftar_formkaryawan a');
$this->db->join('form_karyawan b','b.ID_FK=a.FK_ID');
$this->db->where('a.FK_ID=', $id);
$this->db->where('b.STATUS_FK=0');
return $this->db->get()->result_array();
}
public function getKode_FormSjService() {
$this->db->select('MAX(KODE_FSS) AS KODE');
$this->db->from('form_sjservice');
return $this->db->get()->result_array();
}
public function getData_DaftarSjService_byFSS_bySNS($id1, $id2) {
$this->db->select('*');
$this->db->from('daftar_sjservice a');
$this->db->join('sn_service b','b.ID_SNS=a.SNS_ID');
$this->db->where('a.FSS_ID=', $id1);
$this->db->where('a.SNS_ID=', $id2);
return $this->db->get()->result_array();
}
public function getData_Karyawan_allSales() {
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b','b.ID_JABATAN=a.JABATAN_ID');
$this->db->like('a.USERNAME','sugeng');
$this->db->or_like('b.NAMA_JABATAN','SALES');
$this->db->not_like('a.USERNAME','insentive');
$this->db->not_like('a.USERNAME','itp');
$this->db->not_like('a.USERNAME','none');
$this->db->order_by('a.NAMA_PANGGILAN_KARYAWAN ASC');
return $this->db->get()->result_array();
}
public function getData_Karyawan_allACC() {
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b','b.ID_JABATAN=a.JABATAN_ID');
$this->db->where('b.NAMA_JABATAN="ADMIN SALES"');
$this->db->or_where('b.NAMA_JABATAN="SALES"');
$this->db->or_where('b.NAMA_JABATAN="ADMINISTRATOR"');
$this->db->or_where('a.USERNAME="sugeng"');
$this->db->or_where('a.USERNAME="arifin"');
$this->db->or_where('a.USERNAME="lovita"');
$this->db->or_where('a.USERNAME="ayu"');
$this->db->or_where('a.USERNAME="venny"');
$this->db->or_where('a.USERNAME="ridwan"');
$this->db->order_by('a.NAMA_PANGGILAN_KARYAWAN ASC');
return $this->db->get()->result_array();
}
public function getData_Karyawan_ACCFormFee() {
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b','b.ID_JABATAN=a.JABATAN_ID');
$this->db->where('b.NAMA_JABATAN="ADMIN SALES"');
$this->db->or_where('b.NAMA_JABATAN="SALES"');
$this->db->or_where('b.NAMA_JABATAN="ADMINISTRATOR"');
$this->db->or_where('b.NAMA_JABATAN="ADMIN ITP"');
$this->db->or_where('b.NAMA_JABATAN="KEUANGAN"');
$this->db->or_where('b.NAMA_JABATAN="ADMIN KEUANGAN"');
$this->db->order_by('a.NAMA_PANGGILAN_KARYAWAN ASC');
return $this->db->get()->result_array();
}
public function getData_Karyawan_byID($id) { //Penjualan = [25, 67, 92]
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b','b.ID_JABATAN=a.JABATAN_ID');
$this->db->where('a.ID_KARYAWAN=', $id);
return $this->db->get()->result_array();
}
public function getData_Karyawan_allKaryawanOperasional() {
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b','b.ID_JABATAN=a.JABATAN_ID');
$this->db->where('a.STATUS_KARYAWAN=1');
$this->db->where('a.ID_KARYAWAN!=1');
$this->db->where('a.USERNAME!="sugeng"');
$this->db->where('a.USERNAME!="none"');
$this->db->where('a.USERNAME!="itp"');
$this->db->where('a.USERNAME!="service"');
$this->db->where('a.USERNAME!="insentive"');
$this->db->where('a.USERNAME!="hwely"');
$this->db->where('a.USERNAME!="louis"');
$this->db->order_by('a.NAMA_PANGGILAN_KARYAWAN ASC');
return $this->db->get()->result_array();
}
public function getKode_FormKaryawan() {
$this->db->select('MAX(KODE_FK) AS KODE');
$this->db->from('form_karyawan');
$this->db->like('KODE_FK','FK/', 'after');
return $this->db->get()->result_array();
}
public function getKode_FormFeePelanggan() {
$this->db->select('MAX(KODE_FFP) AS KODE');
$this->db->from('form_feepelanggan');
$this->db->like('KODE_FFP','FFP/', 'after');
return $this->db->get()->result_array();
}
public function getData_FormKaryawan_byID($id) {
$this->db->select('*');
$this->db->from('form_karyawan a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->join('jabatan c','c.ID_JABATAN=b.JABATAN_ID');
$this->db->where('a.ID_FK=', $id);
return $this->db->get()->result_array();
}
public function getData_FormKaryawan_jenis3_allData() {
$this->db->select('*');
$this->db->from('form_karyawan');
$this->db->where('JENIS_FK=3');
return $this->db->get()->result_array();
}
public function getData_FormFeePelanggan_byID($id) {
$this->db->select('*');
$this->db->from('form_feepelanggan a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->join('jabatan c','c.ID_JABATAN=b.JABATAN_ID');
$this->db->join('penjualan d','d.ID_PENJUALAN=a.PENJUALAN_ID');
$this->db->join('sales_order e','e.ID_SO=d.SO_ID');
$this->db->join('pelanggan f','f.ID_PELANGGAN=e.PELANGGAN_ID');
$this->db->where('a.ID_FFP=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarOrder_byPENJUALAN($id) {
$this->db->select('*,FORMAT(a.HARGA_DO,2) as SATUAN,FORMAT((a.HARGA_DO*a.QTY_DO),2) as SUBTOTAL');
$this->db->from('daftar_order a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('penjualan c','c.SO_ID=b.ID_SO');
$this->db->join('barang d','d.ID_BARANG=a.BARANG_ID');
$this->db->where('c.ID_PENJUALAN=', $id);
return $this->db->get()->result_array();
}
public function getSum_DaftarOrder_byPENJUALAN($id) {
$this->db->select('ROUND((SUM(a.HARGA_DO*a.QTY_DO)*((b.PPN_SO+100)/100)),0) as NETTO,(SUM(a.HARGA_DO*a.QTY_DO)*((b.PPN_SO)/100)) as PPN,
(SUM(a.HARGA_DO*a.QTY_DO)) as BRUTO');
$this->db->from('daftar_order a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('penjualan c','c.SO_ID=b.ID_SO');
$this->db->join('barang d','d.ID_BARANG=a.BARANG_ID');
$this->db->where('c.ID_PENJUALAN=', $id);
return $this->db->get()->result_array();
}
public function getSum_PiutangDagang_byPENJUALAN($id) {
$this->db->select('SUM(DEBET_PDA) as DEBET, SUM(KREDIT_PDA) as KREDIT, SUM(DEBET_PDA-KREDIT_PDA) as SISA');
$this->db->from('piutang_dagang');
$this->db->where('TRANSAKSI_PDA!=2');
$this->db->where('PENJUALAN_ID=', $id);
return $this->db->get()->result_array();
}
public function getSum_DaftarNotaDp_byFND($id) {
$this->db->select('SUM(QTY_DFND*HARGA_DFND) as TOTAL');
$this->db->from('daftar_notadp');
$this->db->where('FND_ID=', $id);
return $this->db->get()->result_array();
}
public function getSum_DaftarProforma_byFPF($id) {
$this->db->select('SUM(QTY_DFPF*HARGA_DFPF) as TOTAL');
$this->db->from('daftar_proforma');
$this->db->where('FPF_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarFormKaryawan_byFK($id) {
$this->db->select('*,DATE_FORMAT(a.TGL_DFFK,"%d/%m/%Y") as TANGGAL,FORMAT(a.NILAI_DFFK,2) as NILAI');
$this->db->from('daftar_formkaryawan a');
$this->db->join('form_karyawan b','b.ID_FK=a.FK_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=b.KARYAWAN_ID');
$this->db->join('jabatan d','d.ID_JABATAN=c.JABATAN_ID');
$this->db->where('a.FK_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarFormKaryawan_byID($id) {
$this->db->select('*');
$this->db->from('daftar_formkaryawan a');
$this->db->join('form_karyawan b','b.ID_FK=a.FK_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=b.KARYAWAN_ID');
$this->db->join('jabatan d','d.ID_JABATAN=c.JABATAN_ID');
$this->db->where('a.ID_DFFK=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarFormKaryawan_byFK_byTGL($id, $tgl, $notid = null) {
if ($notid==null) {
$this->db->select('*');
$this->db->from('daftar_formkaryawan');
$this->db->where('FK_ID=', $id);
$this->db->where('TGL_DFFK=', $tgl);
} else {
$this->db->select('*');
$this->db->from('daftar_formkaryawan');
$this->db->where('FK_ID=', $id);
$this->db->where('TGL_DFFK=', $tgl);
$this->db->where('ID_DFFK!=', $notid);
}
return $this->db->get()->result_array();
}
public function getData_JejakHarga_groupBARANG() {
$this->db->select('*');
$this->db->from('jejak_hargakatalog a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->group_by('a.BARANG_ID');
$this->db->order_by('a.BARANG_ID ASC');
return $this->db->get()->result_array();
}
public function getData_JejakHarga_byBARANG_orderDESC_limit1($id) {
$this->db->select('*,FORMAT(a.HPP_JHK,2) as HPP,FORMAT(a.DEALER_JHK,2) as DEALER,FORMAT(a.USER_JHK,2) as USER,DATE_FORMAT(a.TGL_JHK,"%d/%m/%Y") as TANGGAL');
$this->db->from('jejak_hargakatalog a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->where('a.BARANG_ID=', $id);
$this->db->order_by('a.ID_JHK DESC');
$this->db->limit('1');
return $this->db->get()->result_array();
}
public function getData_JejakHarga_byBARANG_orderDESC($id) {
$this->db->select('*,FORMAT(a.HPP_JHK,2) as HPP,FORMAT(a.DEALER_JHK,2) as DEALER,FORMAT(a.USER_JHK,2) as USER,DATE_FORMAT(a.TGL_JHK,"%d/%m/%Y") as TANGGAL');
$this->db->from('jejak_hargakatalog a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->where('a.BARANG_ID=', $id);
$this->db->order_by('a.ID_JHK DESC');
return $this->db->get()->result_array();
}
public function getData_Katalog_status0() {
$this->db->select('*,DATE_FORMAT(TGLAWAL_KATALOG,"%d/%m/%Y") as AWAL,DATE_FORMAT(TGLAKHIR_KATALOG,"%d/%m/%Y") as AKHIR');
$this->db->from('katalog_harga');
$this->db->where('STATUS_KATALOG=0');
$this->db->order_by('TGLAWAL_KATALOG DESC, ID_KATALOG DESC');
return $this->db->get()->result_array();
}
public function getData_Katalog_status1() {
$this->db->select('*,DATE_FORMAT(TGLAWAL_KATALOG,"%d/%m/%Y") as AWAL,DATE_FORMAT(TGLAKHIR_KATALOG,"%d/%m/%Y") as AKHIR');
$this->db->from('katalog_harga');
$this->db->where('STATUS_KATALOG=1');
$this->db->order_by('TGLAWAL_KATALOG DESC, ID_KATALOG DESC');
return $this->db->get()->result_array();
}
public function getData_Katalog_statusNULL_0() {
$this->db->select('*,DATE_FORMAT(TGLAWAL_KATALOG,"%d/%m/%Y") as AWAL,DATE_FORMAT(TGLAKHIR_KATALOG,"%d/%m/%Y") as AKHIR');
$this->db->from('katalog_harga');
$this->db->where('STATUS_KATALOG is NULL');
$this->db->or_where('STATUS_KATALOG=0');
$this->db->order_by('TGLAWAL_KATALOG DESC, ID_KATALOG DESC');
return $this->db->get()->result_array();
}
public function getData_DaftarKatalogHarga_byBARANG($id) {
$this->db->select('*,FORMAT(a.NILAI_DKH,2) as NILAI');
$this->db->from('daftar_katalogharga a');
$this->db->join('katalog_harga b','b.ID_KATALOG=a.KATALOG_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->where('b.STATUS_KATALOG=0');
$this->db->where('a.BARANG_ID=', $id);
return $this->db->get()->result_array();
}
public function getSum_DaftarKatalogHarga_byBARANG($id) {
$this->db->select('SUM(a.NILAI_DKH) as TOTAL');
$this->db->from('daftar_katalogharga a');
$this->db->join('katalog_harga b','b.ID_KATALOG=a.KATALOG_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->where('b.STATUS_KATALOG=0');
$this->db->where('a.BARANG_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarKatalogHarga_byKATALOG_status0($id) {
$this->db->select('*,FORMAT(a.NILAI_DKH,0) as NILAI');
$this->db->from('daftar_katalogharga a');
$this->db->join('katalog_harga b','b.ID_KATALOG=a.KATALOG_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->where('b.STATUS_KATALOG=0');
$this->db->where('a.KATALOG_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarKatalogHarga_byKATALOG($id) {
$this->db->select('*,FORMAT(a.NILAI_DKH,2) as NILAI');
$this->db->from('daftar_katalogharga a');
$this->db->join('katalog_harga b','b.ID_KATALOG=a.KATALOG_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->where('a.KATALOG_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarKatalogHarga_byKATALOG_byBARANG($id1, $id2) {
$this->db->select('*,FORMAT(a.NILAI_DKH,2) as NILAI');
$this->db->from('daftar_katalogharga a');
$this->db->join('katalog_harga b','b.ID_KATALOG=a.KATALOG_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->where('a.KATALOG_ID=', $id1);
$this->db->where('a.BARANG_ID=', $id2);
return $this->db->get()->result_array();
}
public function getData_DaftarKatalogHarga_byID($id) {
$this->db->select('*,FORMAT(a.NILAI_DKH,2) as NILAI');
$this->db->from('daftar_katalogharga a');
$this->db->join('katalog_harga b','b.ID_KATALOG=a.KATALOG_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->where('a.ID_DKH=', $id);
return $this->db->get()->result_array();
}
public function getData_Katalog_byID($id) {
$this->db->select('*,DATE_FORMAT(TGLAWAL_KATALOG,"%d/%m/%Y") as AWAL,DATE_FORMAT(TGLAKHIR_KATALOG,"%d/%m/%Y") as AKHIR');
$this->db->from('katalog_harga');
$this->db->where('ID_KATALOG=', $id);
return $this->db->get()->result_array();
}
public function getData_SnKlaimProgram_forHPP($id) {
$this->db->select('*');
$this->db->from('sn_klaimprogram a');
$this->db->join('daftar_klaimprogram b','b.ID_DKPR=a.DKPR_ID');
$this->db->where('a.STATUS_SNKPR is NULL');
$this->db->where('b.JENIS_DKPR=1');
$this->db->where('b.BARANG_ID=', $id);
return $this->db->get()->result_array();
}
public function getSum_LinkKlaimProgram_bySNKPR($id) {
$this->db->select('SUM(b.NILAI_PKPR) as TOTAL');
$this->db->from('link_klaimprogram a');
$this->db->join('potongan_klaimprogram b','b.ID_PKPR=a.PKPR_ID');
$this->db->where('a.SNKPR_ID=', $id);
$this->db->where('a.PROGRAM_ID!=1');
$this->db->group_by('a.SNKPR_ID');
return $this->db->get()->result_array();
}
public function getMin_DaftarKlaimProgram_byBARANG($id) {
$this->db->select('MIN(HARGA_DKPR) as MINIMUM');
$this->db->from('daftar_klaimprogram');
$this->db->where('BARANG_ID=', $id);
$this->db->where('JENIS_DKPR=1');
return $this->db->get()->result_array();
}
public function getData_JejakHarga_byID($id) {
$this->db->select('*');
$this->db->from('jejak_hargakatalog');
$this->db->where('ID_JHK=', $id);
return $this->db->get()->result_array();
}
public function getData_Barang_fromKlaimProgram() {
$this->db->select('*');
$this->db->from('daftar_klaimprogram a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->group_by('a.BARANG_ID');
$this->db->order_by('b.KODE_BARANG ASC');
return $this->db->get()->result_array();
}
public function getSum_DaftarFormKaryawan_byFK($id) {
$this->db->select('SUM(NILAI_DFFK) as TOTAL');
$this->db->from('daftar_formkaryawan');
$this->db->where('FK_ID=', $id);
return $this->db->get()->result_array();
}
public function getHasil_Lembur($jabatan, $awal ,$akhir, $jenis, $tgl = null) {
if ($jenis==1) {
//Pembeda perhitungan awal, divisi Keuangan dan lainnya
if (strpos($jabatan,"KEUANGAN")!==FALSE) {
$setawal = date('17:00');
} else {
$setawal = date('18:00');
}
//Check apakah hari Libur atau Tidak
$day = strtotime($tgl);
$day = date("D", $day);
if ($day=="Sat" OR $day=="Sun") {
$setawal = date('13:00');
}
//Eliminasi Jam yang tidak sesuai
if (strtotime($awal)>strtotime("07:00") AND strtotime($akhir)<strtotime("13:00")) {
if (strtotime($awal)<strtotime($setawal)){
$awal = $setawal;
}
}
//Ambil selisih dari akhir dikurangi awal
$selisih = strtotime($akhir) - strtotime($awal);
$jam = intval($selisih / 3600);
$jam = floor($jam);
//Koreksi jam tidak bisa 24:00
if ($akhir=="23:59") {
$jam = $jam + 1;
}
//Nilai Lembur
$lembur = $jam * 10000;
} else if ($jenis==2) {
//Ambil selisih dari akhir dikurangi awal
$selisih = strtotime($akhir) - strtotime($awal);
$jam = intval($selisih / 3600);
$jam = floor($jam);
//Koreksi jam tidak bisa 24:00
if ($akhir=="23:59") {
$jam = $jam + 1;
}
//Nilai Lembur
$lembur = $jam * 15000;
}
return $lembur;
}
public function getHasil_LuarKota($awal ,$akhir, $jenis, $inap) {
if ($jenis==3) {
$lembur = 30000;
//Eliminasi Jam berangkat Pagi
$setpagi = date('07:00');
if (strtotime($awal)<=strtotime($setpagi)){
$lembur = $lembur + 20000;
}
//Eliminasi Jam Luar Kota Lebih dari Jam 7 Malam
$setmalam1 = date('19:00');
if (strtotime($akhir)>=strtotime($setmalam1)){
$lembur = $lembur + 20000;
}
//Eliminasi Jam Luar Kota Lebih dari Jam 10 Malam
$setmalam2 = date('22:00');
if (strtotime($akhir)>=strtotime($setmalam2)){
$lembur = $lembur + 20000;
}
//Eliminasi Inap
if ($inap==1){
$lembur = $lembur + 20000;
}
} else if ($jenis==4) {
$lembur = 70000;
//Eliminasi Inap
if ($inap==1){
$lembur = $lembur + 20000;
}
}
return $lembur;
}
//Model Count
public function getCount_UjicobaSO_80(){
$this->db2->select('ID_SO');
$this->db2->from('sales_order');
return $this->db2->count_all_results();
}
public function getCount_Pembelian_0($level){
$this->db->select('ID_PEMBELIAN');
$this->db->from('pembelian');
$this->db->where('STATUS_PEMBELIAN=0');
if ($level == 0) {
$this->db->where('CORP_ID<=4');
} else if ($level == 1) {
$this->db->where('CORP_ID=5');
}
return $this->db->count_all_results();
}
public function getCount_Pembelian_1($level){
$tgl_now = date('Y-m-01');
$range = $this->subTempoMonth($tgl_now,2);
$this->db->select('ID_PEMBELIAN');
$this->db->from('pembelian');
$this->db->where('STATUS_PEMBELIAN=1');
$this->db->where('TGL_INVBELI is NOT NULL');
$this->db->where('TGL_PEMBELIAN>=', $range);
if ($level == 0) {
$this->db->where('CORP_ID<=4');
} else if ($level == 1) {
$this->db->where('CORP_ID=5');
}
return $this->db->count_all_results();
}
public function getCount_Pembelian_1_MonthNow($level){
$range = date('Y-m-01');
$this->db->select('ID_PEMBELIAN');
$this->db->from('pembelian');
$this->db->where('STATUS_PEMBELIAN=1');
$this->db->where('TGL_INVBELI is NOT NULL');
$this->db->where('TGL_PEMBELIAN>=', $range);
if ($level == 0) {
$this->db->where('CORP_ID<=4');
} else if ($level == 1) {
$this->db->where('CORP_ID=5');
}
return $this->db->count_all_results();
}
public function getCount_Pembelian_Null($level){
$this->db->select('ID_PEMBELIAN');
$this->db->from('pembelian');
$this->db->where('STATUS_PEMBELIAN is NULL');
if ($level == 0) {
$this->db->where('CORP_ID<=4');
} else if ($level == 1) {
$this->db->where('CORP_ID=5');
}
return $this->db->count_all_results();
}
public function getCount_SalesVisit_0($id_karyawan){
$this->db->select('ID_SAV');
$this->db->from('sales_visit');
$this->db->where('STATUS_SAV=0');
if ($id_karyawan == 1 OR $id_karyawan == 2 OR $id_karyawan == 50) {
} else {
$this->db->where('SALES_ID=', $id_karyawan);
}
return $this->db->count_all_results();
}
public function getCount_ReturPembelian_Null($id){
$this->db->select('ID_RB');
$this->db->from('retur_pembelian');
$this->db->where('STATUS_RB is NULL');
$this->db->where('ADMIN_ID=', $id);
return $this->db->count_all_results();
}
public function getCount_ReturPembelian_0(){
$this->db->select('ID_RB');
$this->db->from('retur_pembelian');
$this->db->where('STATUS_RB=0');
return $this->db->count_all_results();
}
public function getCount_Proyek_bySALES_statusNull($id=null){
$this->db->select('ID_PROYEK');
$this->db->from('proyek');
$this->db->where('STATUS_PROYEK is NULL');
if ($id!=null) {
$this->db->where('SALES_ID=', $id);
}
return $this->db->count_all_results();
}
public function getCount_Proyek_bySALES_statusNull_Rifka(){
$this->db->select('ID_PROYEK');
$this->db->from('proyek');
$this->db->where('SALES_ID=12 AND STATUS_PROYEK is NULL');
$this->db->or_where('SALES_ID=16 AND STATUS_PROYEK is NULL');
$this->db->or_where('SALES_ID=20 AND STATUS_PROYEK is NULL');
return $this->db->count_all_results();
}
public function getCount_RekapKuartal_bySALES_statusNULL0($id=null){
$this->db->select('ID_RQ');
$this->db->from('rekap_kuartal');
if ($id!=null) {
$this->db->where('STATUS_RQ is NULL AND SALES_ID=', $id);
$this->db->or_where('STATUS_RQ=0 AND SALES_ID=', $id);
} else {
$this->db->where('STATUS_RQ is NULL');
$this->db->or_where('STATUS_RQ=0');
}
return $this->db->count_all_results();
}
public function getCount_RekapKuartal_bySALES_status0(){
$this->db->select('ID_RQ');
$this->db->from('rekap_kuartal');
$this->db->where('STATUS_RQ=0');
return $this->db->count_all_results();
}
public function getCount_Kasbank_KasPcm_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID is NULL');
$this->db->where('KAS_ID=1');
return $this->db->count_all_results();
}
public function getCount_Kasbank_KasItp_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID is NULL');
$this->db->where('KAS_ID=2');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('KAS_ID is NULL');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_1_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=1');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_2_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=2');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_3_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=3');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_4_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=4');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_5_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=5');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_6_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=6');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_7_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=7');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_8_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=8');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_9_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=9');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_10_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=10');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_11_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=11');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_12_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=12');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_13_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=13');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_14_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=14');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_15_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=15');
return $this->db->count_all_results();
}
public function getCount_Kasbank_Bank_16_Null(){
$this->db->select('ID_KB');
$this->db->from('kasbank');
$this->db->where('STATUS_KB is NULL');
$this->db->where('BANK_ID=16');
return $this->db->count_all_results();
}
public function getCount_JurnalMemo(){
$this->db->select('ID_JM');
$this->db->from('jurnal_memo');
return $this->db->count_all_results();
}
public function getCount_DpPajak_PPH22() {
$this->db->select('a.ID_DPP');
$this->db->from('dp_pajak a');
$this->db->join('pajak_penghasilan b','b.ID_PPH=a.PPH_ID');
$this->db->join('daftar_rekappajak c','c.DPP_ID=a.ID_DPP','left');
$this->db->where('b.KODE_PPH=22');
$this->db->where('c.RPJ_ID is NULL');
return $this->db->count_all_results();
}
public function getCount_RekapPajak_PPH22_status1() {
$this->db->select('ID_RPJ');
$this->db->from('rekap_pajak');
$this->db->where('JENIS_RPJ=1');
$this->db->where('STATUS_RPJ=1');
return $this->db->count_all_results();
}
public function getCount_RekapPajak_PPH23_status1() {
$this->db->select('ID_RPJ');
$this->db->from('rekap_pajak');
$this->db->where('JENIS_RPJ=2');
$this->db->where('STATUS_RPJ=1');
return $this->db->count_all_results();
}
public function getCount_RekapPajak_PPN_status1() {
$this->db->select('ID_RPJ');
$this->db->from('rekap_pajak');
$this->db->where('JENIS_RPJ=3');
$this->db->where('STATUS_RPJ=1');
return $this->db->count_all_results();
}
public function getCount_DpPajak_PPH23() {
$this->db->select('a.ID_DPP');
$this->db->from('dp_pajak a');
$this->db->join('pajak_penghasilan b','b.ID_PPH=a.PPH_ID');
$this->db->join('daftar_rekappajak c','c.DPP_ID=a.ID_DPP','left');
$this->db->where('b.KODE_PPH=23');
$this->db->where('c.RPJ_ID is NULL');
return $this->db->count_all_results();
}
public function getCount_Penjualan_PPN() {
$this->db->select('a.ID_PENJUALAN');
$this->db->from('penjualan a');
$this->db->join('daftar_rekappajak b','b.PENJUALAN_ID=a.ID_PENJUALAN','left');
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('b.RPJ_ID is NULL');
$this->db->like('a.FP_PENJUALAN','02','after');
$this->db->or_like('a.FP_PENJUALAN','03','after');
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_SJPenjualan($level) {
$tgl_now = date('Y-m-01');
$this->db->select('a.ID_CD');
$this->db->from('cetak_dokumen a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->where('a.TGL_CD>=', $tgl_now);
$this->db->where('a.SJ_INV=0');
$this->db->where('a.PENJUALAN_ID is NOT NULL');
$this->db->not_like('a.KODE_BUKTI', '.');
if ($level == 0) {
$this->db->where('c.CORP_ID<=3');
} else if ($level == 1) {
$this->db->where('c.CORP_ID>=4');
}
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_SJKonsinyasi($level) {
$tgl_now = date('Y-m-01');
$this->db->select('a.ID_CD');
$this->db->from('cetak_dokumen a');
$this->db->join('konsinyasi b','b.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->where('b.JENIS_KONSINYASI=', $level);
$this->db->where('a.TGL_CD>=', $tgl_now);
$this->db->where('a.SJ_INV=0');
$this->db->where('a.KONSINYASI_ID is NOT NULL');
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_SJTarikKonsi($level) {
$tgl_now = date('Y-m-01');
$this->db->select('a.ID_CD');
$this->db->from('cetak_dokumen a');
$this->db->join('penarikan_konsi b','b.ID_PK=a.PK_ID');
$this->db->where('b.JENIS_PK=', $level);
$this->db->where('a.TGL_CD>=', $tgl_now);
$this->db->where('a.SJ_INV=0');
$this->db->where('a.PK_ID is NOT NULL');
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_SJMutasiBarang()
{
$this->db->select('ID_CD');
$this->db->from('cetak_dokumen');
$this->db->where('SJ_INV=0');
$this->db->where('MB_ID is NOT NULL');
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_SJPeminjaman()
{
$this->db->select('ID_CD');
$this->db->from('cetak_dokumen');
$this->db->where('SJ_INV=0');
$this->db->where('PEMINJAMAN_ID is NOT NULL');
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_SJPenarikanSewa()
{
$this->db->select('ID_CD');
$this->db->from('cetak_dokumen');
$this->db->where('SJ_INV=0');
$this->db->where('PS_ID is NOT NULL');
$this->db->where('STATUS_CD is NULL');
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_NotaPenjualan($level) {
$tgl_now = date('Y-m-01');
$this->db->select('a.ID_CD');
$this->db->from('cetak_dokumen a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->where('a.TGL_CD>=', $tgl_now);
$this->db->where('a.SJ_INV=1');
$this->db->where('a.PENJUALAN_ID is NOT NULL');
$this->db->not_like('a.KODE_BUKTI', '.');
if ($level == 0) {
$this->db->where('c.CORP_ID<=3');
} else if ($level == 1) {
$this->db->where('c.CORP_ID>=4');
}
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_ReturBeli($level) {
$tgl_now = date('Y-m-01');
$this->db->select('a.ID_CD');
$this->db->from('cetak_dokumen a');
$this->db->join('retur_pembelian b','b.ID_RB=a.RB_ID');
$this->db->join('pembelian c','c.ID_PEMBELIAN=b.PEMBELIAN_ID');
$this->db->where('a.TGL_CD>=', $tgl_now);
$this->db->where('a.SJ_INV=1');
$this->db->where('a.RB_ID is NOT NULL');
if ($level == 0) {
$this->db->where('c.CORP_ID<=4');
} else if ($level == 1) {
$this->db->where('c.CORP_ID=5');
}
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_Proforma($level, $id_karyawan, $jabatan) {
$tgl_now = date('Y-m-01');
$this->db->select('a.ID_CD');
$this->db->from('cetak_dokumen a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->where('a.TGL_CD>=', $tgl_now);
$this->db->where('a.SJ_INV=1');
$this->db->where('a.SO_ID is NOT NULL');
if ($level == 0) {
$this->db->where('b.CORP_ID<=3');
} else if ($level == 1) {
$this->db->where('b.CORP_ID>=4');
}
if ($id_karyawan==1 OR $jabatan=="KEUANGAN" OR $jabatan=="ADMIN KEUANGAN" OR $jabatan=="ADMIN ITP") {
} else {
$this->db->where('b.SALES_ID=', $id_karyawan);
}
return $this->db->count_all_results();
}
public function getCount_CetakDokumen_SJParsial($level) {
$tgl_now = date('Y-m-01');
$this->db->select('a.ID_CD');
$this->db->from('cetak_dokumen a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->where('a.TGL_CD>=', $tgl_now);
$this->db->where('a.SJ_INV=0');
$this->db->where('a.PENJUALAN_ID is NOT NULL');
$this->db->like('a.KODE_BUKTI', '.');
if ($level == 0) {
$this->db->where('c.CORP_ID<=3');
} else if ($level == 1) {
$this->db->where('c.CORP_ID>=4');
}
return $this->db->count_all_results();
}
public function getCount_Penjualan_1($level){
$tgl_now = date('Y-m-01');
$range = $this->subTempoMonth($tgl_now,2);
$this->db->select('a.ID_PENJUALAN');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
if ($level == 0) {
$this->db->where('b.CORP_ID<=3');
} else if ($level == 1) {
$this->db->where('b.CORP_ID>=4');
}
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('a.SJ_PENJUALAN is NOT NULL');
$this->db->where('a.TGL_PENJUALAN>=', $range);
return $this->db->count_all_results();
}
public function getCount_KomisiPenjualan_1(){
$tgl_now = date('Y-m-01');
$range = $this->subTempoMonth($tgl_now,2);
$this->db->select('a.ID_DO');
$this->db->from('daftar_order a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('penjualan c','c.SO_ID=b.ID_SO');
$this->db->where('c.STATUS_PENJUALAN=1');
$this->db->where('c.SJ_PENJUALAN is NOT NULL');
$this->db->where('c.TGL_PENJUALAN>=', $range);
return $this->db->count_all_results();
}
public function getCount_ReturPenjualan_0($level){
$this->db->select('a.ID_RJ');
$this->db->from('retur_penjualan a');
$this->db->join('daftar_returjual b','b.RJ_ID=a.ID_RJ','left');
$this->db->join('barang c','c.ID_BARANG=b.BARANG_ID','left');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID','left');
$this->db->join('penjualan e','e.ID_PENJUALAN=a.PENJUALAN_ID','left');
$this->db->join('sales_order f','f.ID_SO=e.SO_ID','left');
$this->db->join('pelanggan g','g.ID_PELANGGAN=f.PELANGGAN_ID','left');
$this->db->join('kota h','h.ID_KOTA=g.KOTA_ID','left');
$this->db->where('a.STATUS_RJ=0');
if ($level == 0) {
$this->db->where('f.CORP_ID<=3');
} else if ($level == 1) {
$this->db->where('f.CORP_ID>=4');
}
$this->db->group_by('a.ID_RJ');
return $this->db->count_all_results();
}
public function getCount_SalesOrder_Not1_Not5($id){
$tgl_now = date('Y-m-01');
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('KONSINYASI_ID is NULL');
$this->db->where('STATUS_SO!=1');
$this->db->where('STATUS_SO!=5');
$this->db->where('SALES_ID=', $id);
$this->db->where('TGL_SO>=', $tgl_now);
return $this->db->count_all_results();
}
public function getCount_SalesOrder_NotNull_Not1_Not2_Not3_Not5($level, $jabatan=null){
$this->db->select('ID_SO');
$this->db->from('sales_order');
if ($jabatan=="SUPPORT") {
$this->db->where('STATUS_SO is NOT NULL AND STATUS_SO!=1 AND STATUS_SO!=2 AND STATUS_SO!=3 AND STATUS_SO!=4 AND STATUS_SO!=5 AND STATUS_SO!=6');
} else {
$this->db->where('STATUS_SO is NOT NULL AND STATUS_SO!=1 AND STATUS_SO!=2 AND STATUS_SO!=3 AND STATUS_SO!=5');
}
if ($level == 0) {
$this->db->where('CORP_ID<=3');
} else if ($level == 1) {
$this->db->where('CORP_ID>=4');
}
return $this->db->count_all_results();
}
public function getCount_SalesOrder_Not5_KirimNull(){
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('STATUS_SO is NOT NULL');
$this->db->where('STATUS_SO!=5');
return $this->db->count_all_results();
}
public function getCount_SalesOrder_KirimNotNull(){
$tgl = date('Y-m-d');
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('TGL_KIRIM=', $tgl);
return $this->db->count_all_results();
}
public function getCount_SalesOrder_1_KirimNull($id=null){
if ($id==null) {
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('STATUS_SO=1');
} else {
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('STATUS_SO=1');
$this->db->where('SALES_ID=', $id);
}
return $this->db->count_all_results();
}
public function getCount_SalesOrder_1($id_karyawan) {
$limit = date('Y-01-01');
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('STATUS_SO=1');
$this->db->where('SALES_ID=', $id_karyawan);
$this->db->where('TGL_SO>=', $limit);
return $this->db->count_all_results();
}
public function getCount_SalesOrder_4(){
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('STATUS_SO=4');
return $this->db->count_all_results();
}
public function getCount_SalesOrder_Null($id){
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('STATUS_SO is NULL');
$this->db->where('CORP_ID<=3');
if ($id==1) {
} else {
$this->db->where(['SALES_ID' => $id]);
}
return $this->db->count_all_results();
}
public function getCount_SalesOrder_Null_0_2_3_4_6_7(){
$this->db->select('ID_SO');
$this->db->from('sales_order');
$this->db->where('STATUS_SO is NULL');
$this->db->or_where('STATUS_SO=0');
$this->db->or_where('STATUS_SO=2');
$this->db->or_where('STATUS_SO=3');
$this->db->or_where('STATUS_SO=4');
$this->db->or_where('STATUS_SO=6');
$this->db->or_where('STATUS_SO=7');
return $this->db->count_all_results();
}
public function getCount_SnStock_byBARANG($id) {
$this->db->select('a.ID_SNSTOCK');
$this->db->from('sn_stock a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->where(['a.BARANG_ID' => $id]);
$this->db->where('a.STATUS_SNSTOCK is NULL');
return $this->db->count_all_results();
}
public function getCount_Konsinyasi_Null_0(){
$this->db->select('ID_KONSINYASI');
$this->db->from('konsinyasi');
$this->db->where('STATUS_KONSINYASI is NULL');
$this->db->or_where('STATUS_KONSINYASI=0');
return $this->db->count_all_results();
}
public function getCount_Konsinyasi_0(){
$this->db->select('ID_KONSINYASI');
$this->db->from('konsinyasi');
$this->db->where('STATUS_KONSINYASI=0');
return $this->db->count_all_results();
}
public function getCount_Konsinyasi_statusNull($level){
$this->db->select('ID_KONSINYASI');
$this->db->from('konsinyasi');
$this->db->where('STATUS_KONSINYASI is NULL');
$this->db->where('JENIS_KONSINYASI=', $level);
return $this->db->count_all_results();
}
public function getCount_Operasional_Null_0(){
$this->db->select('ID_OPERASIONAL');
$this->db->from('operasional');
$this->db->where('STATUS_OPERASIONAL is NULL');
$this->db->or_where('STATUS_OPERASIONAL=0');
return $this->db->count_all_results();
}
public function getCount_Peminjaman_Null_0($level){
$this->db->select('ID_PEMINJAMAN');
$this->db->from('peminjaman');
$this->db->where('STATUS_PEMINJAMAN is NULL AND JENIS_PEMINJAMAN=', $level);
$this->db->or_where('STATUS_PEMINJAMAN=0 AND JENIS_PEMINJAMAN=', $level);
return $this->db->count_all_results();
}
public function getCount_Pending_Null($level){
$this->db->select('ID_PENDING');
$this->db->from('pending');
$this->db->where('STATUS_PENDING is NULL');
$this->db->where('JENIS_PENDING=', $level);
return $this->db->count_all_results();
}
public function getCount_Proyek_Null($id = null){
if ($id==null) {
$this->db->select('ID_PROYEK');
$this->db->from('proyek');
$this->db->where('STATUS_PROYEK is NULL');
} else {
$this->db->select('ID_PROYEK');
$this->db->from('proyek');
$this->db->where('SALES_ID=', $id);
$this->db->where('STATUS_PROYEK is NULL');
}
return $this->db->count_all_results();
}
public function getCount_ProyekPra_Null($id = null){
if ($id==null) {
$this->db->select('ID_PROYEK');
$this->db->from('proyek');
$this->db->where('STATUS_PROYEK is NULL');
$this->db->like('KODE_PROYEK','PRA');
} else {
$this->db->select('ID_PROYEK');
$this->db->from('proyek');
$this->db->where('SALES_ID=', $id);
$this->db->where('STATUS_PROYEK is NULL');
$this->db->like('KODE_PROYEK','PRA');
}
return $this->db->count_all_results();
}
public function getCount_Service_Null($id, $level){
$this->db->select('ID_SERVICE');
$this->db->from('service');
$this->db->where('STATUS_SERVICE is NULL');
$this->db->where('PEMBUAT_ID=', $id);
$this->db->where('JENIS_SERVICE=', $level);
return $this->db->count_all_results();
}
public function getCount_Service_0() {
$this->db->select('ID_SERVICE');
$this->db->from('service');
$this->db->where('STATUS_SERVICE=0');
return $this->db->count_all_results();
}
public function getCount_SnService_Null() {
$this->db->select('ID_SNS');
$this->db->from('sn_service');
$this->db->where('STATUS_SNS is NULL');
return $this->db->count_all_results();
}
public function getCount_SnService_2_TGLNull() {
$this->db->select('ID_SNS');
$this->db->from('sn_service');
$this->db->where('STATUS_SNS=2');
$this->db->where('TGL_SNS is NULL');
return $this->db->count_all_results();
}
public function getCount_SnService_allStatusPEL() {
$this->db->select('a.ID_SNS');
$this->db->from('sn_service a');
$this->db->join('service b','b.ID_SERVICE=a.SERVICE_ID');
$this->db->where('b.PELANGGAN_ID is NOT NULL');
$this->db->where('b.STATUS_SERVICE=1');
return $this->db->count_all_results();
}
public function getCount_KlaimService_statusNull() {
$this->db->select('ID_KSV');
$this->db->from('klaim_service');
$this->db->where('STATUS_KSV is NULL');
return $this->db->count_all_results();
}
public function getCount_MutasiBarang_0_byLEVEL($id){
$this->db->select('ID_MB');
$this->db->from('mutasi_barang');
$this->db->where('STATUS_MB=0');
if ($id == 0) {
$this->db->where('JENIS_MB=1');
} else if ($id == 1) {
$this->db->where('JENIS_MB=0');
}
return $this->db->count_all_results();
}
public function getCount_Sewa_Null_0(){
$this->db->select('ID_SEWA');
$this->db->from('sewa');
$this->db->where('STATUS_SEWA is NULL');
$this->db->or_where('STATUS_SEWA=0');
return $this->db->count_all_results();
}
public function getCount_SnKonsi_byPK_byBARANG($id1,$id2) {
$this->db->select('*');
$this->db->from('sn_konsi a');
$this->db->join('daftar_konsi b','b.ID_DFK=a.DFK_ID');
$this->db->where(['a.PK_ID' => $id1]);
$this->db->where(['b.BARANG_ID' => $id2]);
return $this->db->count_all_results();
}
public function getCount_SnSewa_byBARANG_Null_3($id) {
$this->db->select('a.ID_SNSW');
$this->db->from('sn_sewa a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->where(['a.BARANG_ID' => $id]);
$this->db->where('a.STATUS_SNSW is NULL');
$this->db->or_where('a.STATUS_SNSW=3');
return $this->db->count_all_results();
}
public function getCount_SnSewa_byPS_byBARANG($id1,$id2) {
$this->db->select('*');
$this->db->from('sn_sewa a');
$this->db->join('daftar_sewa b','b.ID_DFSW=a.DFSW_ID');
$this->db->where(['a.PS_ID' => $id1]);
$this->db->where(['b.BARANG_ID' => $id2]);
return $this->db->count_all_results();
}
public function getCount_SnStock_byBARANG_Null($id) {
$this->db->select('a.ID_SNSTOCK');
$this->db->from('sn_stock a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->where(['a.BARANG_ID' => $id]);
$this->db->where('a.STATUS_SNSTOCK is NULL');
return $this->db->count_all_results();
}
//Model getData
public function getData_DaftarKatalogHarga_byAWAL_byAKHIR($awal, $akhir) {
$this->db->select('*,DATE_FORMAT(b.TGLAWAL_KATALOG,"%d/%m/%Y") as AWAL,DATE_FORMAT(b.TGLAKHIR_KATALOG,"%d/%m/%Y") as AKHIR,FORMAT(a.NILAI_DKH,2) as NILAI');
$this->db->from('daftar_katalogharga a');
$this->db->join('katalog_harga b', 'b.ID_KATALOG=a.KATALOG_ID');
$this->db->join('barang c', 'c.ID_BARANG=a.BARANG_ID');
$this->db->where('b.TGLAWAL_KATALOG>=', $awal);
$this->db->where('b.TGLAKHIR_KATALOG<=', $akhir);
$this->db->order_by('b.ID_KATALOG ASC, c.NAMA_BARANG ASC');
return $this->db->get()->result_array();
}
public function getData_Absensi_byKARYAWAN_byTGL($id, $tgl, $username=null) {
$this->db->select('*,DATE_FORMAT(TGL_ABSENSI,"%d/%m/%Y") as TANGGAL');
$this->db->from('absensi');
$this->db->where(['TGL_ABSENSI' => $tgl]);
if ($username=="service") {
$this->db->where('KARYAWAN_ID=22');
} else {
$this->db->where(['KARYAWAN_ID' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Absensi_byKARYAWAN_byTGL_statusCuti($id, $tgl) {
$weekBefore = $this->addTempoDay($tgl, 7);
$this->db->select('*,DATE_FORMAT(TGL_ABSENSI,"%d/%m/%Y") as TANGGAL');
$this->db->from('absensi');
$this->db->where('TELAT=3');
$this->db->where('KARYAWAN_ID=', $id);
$this->db->where('TGL_ABSENSI>', $tgl);
$this->db->where('TGL_ABSENSI<=', $weekBefore);
$this->db->order_by('TGL_ABSENSI ASC');
$this->db->limit('1');
return $this->db->get()->result_array();
}
public function getData_Absensi_Didalam($id) {
$this->db->select('*,b.NAMA_PANGGILAN_KARYAWAN');
$this->db->from('absensi a');
$this->db->join('karyawan b', 'b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->join('jabatan c', 'c.ID_JABATAN=b.JABATAN_ID');
$this->db->where('b.STATUS_KARYAWAN=1');
$this->db->where('a.STATUS_ABSENSI<=2');
$this->db->where(['a.TGL_ABSENSI' => $id]);
$this->db->order_by('a.MASUK_ABSENSI ASC');
return $this->db->get()->result_array();
}
public function getData_Absensi_Diluar($id) {
$this->db->select('*,b.NAMA_PANGGILAN_KARYAWAN');
$this->db->from('absensi a');
$this->db->join('karyawan b', 'b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->join('jabatan c', 'c.ID_JABATAN=b.JABATAN_ID');
$this->db->where('b.STATUS_KARYAWAN=1');
$this->db->where('a.STATUS_ABSENSI>2');
$this->db->where(['a.TGL_ABSENSI' => $id]);
$this->db->order_by('a.MASUK_ABSENSI ASC');
return $this->db->get()->result_array();
}
public function getData_Karyawan_forLogin($username, $password) { //Pembelian = [2, 18]
$this->db->select('*');
$this->db->from('karyawan a');
$this->db->join('jabatan b', 'b.ID_JABATAN=a.JABATAN_ID');
$this->db->where('a.USERNAME=', $username);
$this->db->where('a.PASSWORD=', $password);
return $this->db->get()->result_array();
}
public function getData_SurveyKaryawan_byNAMA($nama)
{
$this->db->select('*');
$this->db->from('survey_karyawan');
$this->db->where('NAMA_SVK=', $nama);
$this->db->where('STATUS_SVK is NULL');
return $this->db->get()->result_array();
}
public function getData_SurveyKaryawan_NULL()
{
$this->db->select('*');
$this->db->from('survey_karyawan');
$this->db->where('STATUS_SVK is NULL');
return $this->db->get()->result_array();
}
public function getData_DaftarSurveyKaryawan_bySVK_byKARYAWAN($id, $karyawan)
{
$this->db->select('*');
$this->db->from('daftar_surveykaryawan');
$this->db->where('SVK_ID=', $id);
$this->db->where('KARYAWAN_ID=', $karyawan);
return $this->db->get()->result_array();
}
//Model getID
public function getID_KaryawanMax() {
$this->db->select_max('ID_KARYAWAN');
$this->db->from('karyawan');
return $this->db->get()->result_array();
}
public function getID_NotifikasiMax() {
$this->db->select_max('ID_NOTIFIKASI');
$this->db->from('notifikasi');
return $this->db->get()->result_array();
}
public function getID_FormTandaTerimaMax() {
$this->db->select_max('ID_FTT');
$this->db->from('form_tandaterima');
return $this->db->get()->result_array();
}
public function getID_FormTTKosongMax() {
$this->db->select_max('ID_FTTK');
$this->db->from('form_ttkosong');
return $this->db->get()->result_array();
}
public function getID_FormSjServiceMax() {
$this->db->select_max('ID_FSS');
$this->db->from('form_sjservice');
return $this->db->get()->result_array();
}
public function getID_SetdataMax() {
$this->db->select_max('ID_SETDATA');
$this->db->from('setdata');
return $this->db->get()->result_array();
}
//Model getSum
public function getSum_SalesOrder_bySales_Bruto($id_karyawan) {
$awal = date('Y-01-01');
$akhir = date('Y-12-31');
$this->db->select('CONCAT("Rp ",FORMAT(SUM(c.DEBET_PDA),2)) as TOTAL');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('piutang_dagang c','c.PENJUALAN_ID=a.ID_PENJUALAN');
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('a.TGL_PENJUALAN>=', $awal);
$this->db->where('a.TGL_PENJUALAN<=', $akhir);
$this->db->where('b.SALES_ID=', $id_karyawan);
return $this->db->get()->result_array();
}
public function getSum_SalesOrder_bySales_Komisi($id_karyawan, $tgl_awal, $tgl_akhir) {
$this->db->select('SUM(c.DEBET_PDA) as DEBET,SUM(c.KREDIT_PDA) as KREDIT,CONCAT("Rp ",FORMAT(SUM(c.KREDIT_PDA),2)) as TOTAL');
$this->db->from('sales_order a');
$this->db->join('penjualan b','b.SO_ID=a.ID_SO');
$this->db->join('piutang_dagang c','c.PENJUALAN_ID=b.ID_PENJUALAN');
$this->db->where('b.STATUS_PENJUALAN=1');
$this->db->where('b.TGL_PENJUALAN>=', $tgl_awal);
$this->db->where('b.TGL_PENJUALAN<=', $tgl_akhir);
$this->db->where('a.SALES_ID=', $id_karyawan);
$this->db->having('DEBET=KREDIT');
return $this->db->get()->result_array();
}
public function getSum_SalesOrder_bySales_Terbayar($id_karyawan) {
$awal = date('Y-01-01');
$akhir = date('Y-12-31');
$this->db->select('CONCAT("Rp ",FORMAT(SUM(c.KREDIT_PDA),2)) as TOTAL');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('piutang_dagang c','c.PENJUALAN_ID=a.ID_PENJUALAN');
$this->db->where('c.TRANSAKSI_PDA=1');
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('a.TGL_PENJUALAN>=', $awal);
$this->db->where('a.TGL_PENJUALAN<=', $akhir);
$this->db->where('b.SALES_ID=', $id_karyawan);
return $this->db->get()->result_array();
}
public function getSum_SalesOrder_bySales_BelumLunas($id_karyawan) {
$awal = date('Y-01-01');
$akhir = date('Y-12-31');
$this->db->select('CONCAT("Rp ",FORMAT(SUM(c.DEBET_PDA-c.KREDIT_PDA),2)) as TOTAL');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('piutang_dagang c','c.PENJUALAN_ID=a.ID_PENJUALAN');
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('a.TGL_PENJUALAN>=', $awal);
$this->db->where('a.TGL_PENJUALAN<=', $akhir);
$this->db->where('b.SALES_ID=', $id_karyawan);
return $this->db->get()->result_array();
}
public function getSum_SalesOrder_bySales_BelumLunasBefore($id_karyawan) {
$yearNow = date('Y');
$yearLast = $yearNow-1;
$awal = date("$yearLast-01-01");
$akhir = date("$yearLast-12-31");
$this->db->select('CONCAT("Rp ",FORMAT(SUM(c.DEBET_PDA-c.KREDIT_PDA),2)) as TOTAL');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('piutang_dagang c','c.PENJUALAN_ID=a.ID_PENJUALAN');
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('a.TGL_PENJUALAN>=', $awal);
$this->db->where('a.TGL_PENJUALAN<=', $akhir);
$this->db->where('b.SALES_ID=', $id_karyawan);
return $this->db->get()->result_array();
}
public function getSum_SalesOrder_bySales_Retur($id_karyawan) {
$awal = date('Y-01-01');
$akhir = date('Y-12-31');
$this->db->select('CONCAT("Rp ",FORMAT(SUM(c.KREDIT_PDA),2)) as TOTAL');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('piutang_dagang c','c.PENJUALAN_ID=a.ID_PENJUALAN');
$this->db->where('c.TRANSAKSI_PDA=2');
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('a.TGL_PENJUALAN>=', $awal);
$this->db->where('a.TGL_PENJUALAN<=', $akhir);
$this->db->where('b.SALES_ID=', $id_karyawan);
return $this->db->get()->result_array();
}
/////////////////////////////////////////////////////////////////////////////////
public function getSum_Penjualan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(c.QTY_DO*c.HARGA_DO),2)) as TOTAL,SUM(c.QTY_DO*c.HARGA_DO) as TOTALNERACA');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('daftar_order c','c.SO_ID=b.ID_SO');
$this->db->where('a.SO_ID is NOT NULL');
$this->db->where('a.TGL_PENJUALAN>="2022-07-01"');
$this->db->where('a.TGL_PENJUALAN<"2022-08-01"');
$this->db->where('a.STATUS_PENJUALAN=1');
return $this->db->get()->result_array();
}
public function getSum_ReturPenjualan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(b.QTY_DRJ*b.HARGA_DRJ),2)) as TOTAL,SUM(b.QTY_DRJ*b.HARGA_DRJ) as TOTALNERACA');
$this->db->from('retur_penjualan a');
$this->db->join('daftar_returjual b','b.RJ_ID=a.ID_RJ');
$this->db->where('a.TGL_RJ>="2022-07-01"');
$this->db->where('a.TGL_RJ<"2022-08-01"');
$this->db->where('a.STATUS_RJ=1');
return $this->db->get()->result_array();
}
public function getSum_PotonganDiskonPenjualan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=25');
return $this->db->get()->result_array();
}
public function getSum_PersediaanAwal_forNeraca($id) {
$this->db->select('*,CONCAT("Rp ",FORMAT(NILAI_NERACA,2)) as TOTAL');
$this->db->from('neraca');
$this->db->where('PERKIRAAN_ID=26');
$this->db->where(['SETDATA_ID' => $id]);
return $this->db->get()->result_array();
}
public function getSum_Pembelian_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(b.QTY_DB*b.HARGA_DB),2)) as TOTAL,SUM(b.QTY_DB*b.HARGA_DB) as TOTALNERACA');
$this->db->from('pembelian a');
$this->db->join('daftar_beli b','b.PEMBELIAN_ID=a.ID_PEMBELIAN');
$this->db->where('a.TGL_PEMBELIAN>="2022-07-01"');
$this->db->where('a.TGL_PEMBELIAN<"2022-08-01"');
$this->db->where('a.STATUS_PEMBELIAN=1');
return $this->db->get()->result_array();
}
public function getSum_ReturPembelian_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(b.QTY_DRB*b.HARGA_DRB),2)) as TOTAL,SUM(b.QTY_DRB*b.HARGA_DRB) as TOTALNERACA');
$this->db->from('retur_pembelian a');
$this->db->join('daftar_returbeli b','b.RB_ID=a.ID_RB');
$this->db->where('a.TGL_RB>="2022-07-01"');
$this->db->where('a.TGL_RB<"2022-08-01"');
$this->db->where('a.STATUS_RB=1');
return $this->db->get()->result_array();
}
public function getSum_PotonganDiskonPembelian_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=29');
return $this->db->get()->result_array();
}
public function getData_HargaAvg_groupBARANG_forNeraca() {
$tgl_now = date('m/01/Y');
$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('*');
$this->db->from('harga_avg');
$this->db->where('TGL_HAVG<"'.$tgl_next.'"');
$this->db->group_by('BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_HargaAvg_byBARANG_forNeraca($id) {
$this->db->select('*');
$this->db->from('harga_avg');
$this->db->where(['BARANG_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kuantiti_byID($id=null) {
if ($id==null) {
$this->db->select('ID_KUANTITI,GLOBAL_KUANTITI,HARGA_AVG');
$this->db->from('kuantiti');
$this->db->where('GLOBAL_KUANTITI>0');
} else {
$this->db->select('*');
$this->db->from('kuantiti');
$this->db->where('ID_KUANTITI=',$id);
}
return $this->db->get()->result_array();
}
public function getData_Kuantiti_forNeraca() {
$this->db->select('SUM(GLOBAL_KUANTITI*HARGA_AVG) as TOTAL');
$this->db->from('kuantiti');
return $this->db->get()->result_array();
}
public function getData_Setdata_byID($id) {
$this->db->select('*');
$this->db->from('setdata');
$this->db->where('ID_SETDATA=',$id);
return $this->db->get()->result_array();
}
public function getSum_BiayaOperasional_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=31');
return $this->db->get()->result_array();
}
public function getSum_BiayaPengiriman_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=32');
return $this->db->get()->result_array();
}
public function getSum_BiayaServiceKendaraan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=33');
return $this->db->get()->result_array();
}
public function getSum_BiayaBensin_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=34');
return $this->db->get()->result_array();
}
public function getSum_BiayaParkirUmum_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=35');
return $this->db->get()->result_array();
}
public function getSum_BiayaSparepart_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=36');
return $this->db->get()->result_array();
}
public function getSum_BiayaKebutuhanService_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=37');
return $this->db->get()->result_array();
}
public function getSum_BiayaGajiTHR_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=38');
return $this->db->get()->result_array();
}
public function getSum_BiayaPajakPPHPsl21_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=39');
return $this->db->get()->result_array();
}
public function getSum_BiayaIncentive_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=40');
return $this->db->get()->result_array();
}
public function getSum_BiayaPLN_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=41');
return $this->db->get()->result_array();
}
public function getSum_BiayaTelepon_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=42');
return $this->db->get()->result_array();
}
public function getSum_BiayaInternet_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=43');
return $this->db->get()->result_array();
}
public function getSum_BiayaPDAM_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=44');
return $this->db->get()->result_array();
}
public function getSum_BiayaServiceChargeManggaDua_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=45');
return $this->db->get()->result_array();
}
public function getSum_BiayaParkirKaryawan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=46');
return $this->db->get()->result_array();
}
public function getSum_BiayaKonsultanPajak_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=47');
return $this->db->get()->result_array();
}
public function getSum_BiayaATK_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=48');
return $this->db->get()->result_array();
}
public function getSum_BiayaMaterai_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=49');
return $this->db->get()->result_array();
}
public function getSum_BiayaFotocopy_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=50');
return $this->db->get()->result_array();
}
public function getSum_BiayaMajalahKomputer_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=51');
return $this->db->get()->result_array();
}
public function getSum_BiayaCetak_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=52');
return $this->db->get()->result_array();
}
public function getSum_BiayaSuratReferensi_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=53');
return $this->db->get()->result_array();
}
public function getSum_BiayaKebutuhanKantor_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=54');
return $this->db->get()->result_array();
}
public function getSum_BiayaServiceLuar_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=55');
return $this->db->get()->result_array();
}
public function getSum_BiayaTol_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=56');
return $this->db->get()->result_array();
}
public function getSum_BiayaServiceAC_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=57');
return $this->db->get()->result_array();
}
public function getSum_BiayaPajakKendaraan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=58');
return $this->db->get()->result_array();
}
public function getSum_BiayaSumbangan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=59');
return $this->db->get()->result_array();
}
public function getSum_BiayaEntertain_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=60');
return $this->db->get()->result_array();
}
public function getSum_BiayaBPJS_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=61');
return $this->db->get()->result_array();
}
public function getSum_BiayaAssKaryawan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=62');
return $this->db->get()->result_array();
}
public function getSum_BiayaTraining_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=63');
return $this->db->get()->result_array();
}
public function getSum_BiayaFee_byDKB_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=64');
return $this->db->get()->result_array();
}
public function getSum_BiayaFee_byDJM_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DJM-a.KREDIT_DJM),2)) as TOTAL,SUM(a.DEBET_DJM-a.KREDIT_DJM) as TOTALNERACA');
$this->db->from('daftar_jurnalmemo a');
$this->db->join('jurnal_memo b','b.ID_JM=a.JM_ID');
$this->db->where('b.TGL_JM>="2022-07-01"');
$this->db->where('b.TGL_JM<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=64');
return $this->db->get()->result_array();
}
public function getSum_BiayaDinasLuar_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=65');
return $this->db->get()->result_array();
}
public function getSum_BiayaPajakPPHPsl25_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=66');
return $this->db->get()->result_array();
}
public function getSum_BiayaPenyusutan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DJM-a.KREDIT_DJM),2)) as TOTAL,SUM(a.DEBET_DJM-a.KREDIT_DJM) as TOTALNERACA');
$this->db->from('daftar_jurnalmemo a');
$this->db->join('jurnal_memo b','b.ID_JM=a.JM_ID');
$this->db->where('b.TGL_JM>="2022-07-01"');
$this->db->where('b.TGL_JM<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=67');
return $this->db->get()->result_array();
}
public function getSum_BiayaKegiatanKaryawan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=68');
return $this->db->get()->result_array();
}
public function getSum_BiayaRekreasiKaryawan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=69');
return $this->db->get()->result_array();
}
public function getSum_BiayaPengeluaranProject_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=70');
return $this->db->get()->result_array();
}
public function getSum_BiayaBungaKredit_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=71');
return $this->db->get()->result_array();
}
public function getSum_BiayaKreditBank_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=72');
return $this->db->get()->result_array();
}
public function getSum_BiayaPerawatanPerbaikanGedung_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=73');
return $this->db->get()->result_array();
}
public function getSum_BiayaLainLain_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=74');
return $this->db->get()->result_array();
}
public function getSum_PendapatanDiluarUsaha_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=75');
return $this->db->get()->result_array();
}
public function getSum_PendapatanJasaGiro_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=76');
return $this->db->get()->result_array();
}
public function getSum_AdminBank_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=77');
return $this->db->get()->result_array();
}
public function getSum_PajakGiro_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DKB-a.KREDIT_DKB),2)) as TOTAL,SUM(a.DEBET_DKB-a.KREDIT_DKB) as TOTALNERACA');
$this->db->from('daftar_kasbank a');
$this->db->join('kasbank b','b.ID_KB=a.KB_ID');
$this->db->where('b.TGL_KB>="2022-07-01"');
$this->db->where('b.TGL_KB<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=78');
return $this->db->get()->result_array();
}
public function getSum_BiayaPajakPenghasilan_forNeraca() {
//$tgl_now = date('m/01/Y');
//$tgl_next = $this->addTempoMonth($tgl_now,1);
$this->db->select('CONCAT("Rp ",FORMAT(SUM(a.DEBET_DJM-a.KREDIT_DJM),2)) as TOTAL,SUM(a.DEBET_DJM-a.KREDIT_DJM) as TOTALNERACA');
$this->db->from('daftar_jurnalmemo a');
$this->db->join('jurnal_memo b','b.ID_JM=a.JM_ID');
$this->db->where('b.TGL_JM>="2022-07-01"');
$this->db->where('b.TGL_JM<"2022-08-01"');
$this->db->where('a.PERKIRAAN_ID=79');
return $this->db->get()->result_array();
}
public function subTempoMonth($date,$month) {
$sum = strtotime(date("Y-m-d", strtotime("$date")) . " -$month month");
$dateTo=date('Y-m-d',$sum);
return $dateTo;
}
//Manajemen Kuartal
public function getData_Kuartal_forManajemenKuartal($id_karyawan=null, $id_kuartal=null) {
if ($id_kuartal == null) {
$this->db->select('*');
$this->db->from('kuartal');
$this->db->order_by('STATUS_KUARTAL ASC');
} else {
$this->db->select('*,a.SO_ID as SOID, FORMAT(c.FEE_SO, 2) as FEE, DATE_FORMAT(c.TGL_SO,"%d/%m/%Y") as TANGGAL, g.ID_PROYEK as PRID');
$this->db->from('manajemen_kuartal a');
$this->db->join('kuartal b','b.ID_KUARTAL=a.KUARTAL_ID');
$this->db->join('sales_order c','c.ID_SO=a.SO_ID');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID');
$this->db->join('kota e','e.ID_KOTA=d.KOTA_ID');
$this->db->join('karyawan f','f.ID_KARYAWAN=c.SALES_ID');
$this->db->join('proyek g','g.SO_ID=c.ID_SO','left');
$this->db->order_by('c.TGL_SO ASC');
$this->db->where('a.KUARTAL_ID=', $id_kuartal);
$this->db->where('a.KARYAWAN_ID=', $id_karyawan);
}
return $this->db->get()->result_array();
}
public function getData_Kuartal_byID($id) {
$this->db->select('*');
$this->db->from('kuartal');
$this->db->where(['ID_KUARTAL' => $id]);
return $this->db->get()->result_array();
}
public function getData_SalesOrder_forManajemenKuartal($id_karyawan) {
$this->db->select('*,DATE_FORMAT(a.TGL_SO,"%d/%m/%Y") as TANGGAL');
$this->db->from('sales_order a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->join('penjualan c','c.SO_ID=a.ID_SO');
$this->db->join('manajemen_kuartal d','d.SO_ID=a.ID_SO','left');
$this->db->where('a.SALES_ID=', $id_karyawan);
$this->db->where('a.GP_SO=1');
$this->db->where('a.STATUS_SO=1');
$this->db->where('d.SO_ID IS NULL');
$this->db->group_by('a.ID_SO');
$this->db->order_by('a.TGL_SO ASC, a.KODE_SO ASC');
return $this->db->get()->result_array();
}
public function getData_ManajemenKuartal_byKuartal00($id_kuartal, $id_karyawan) {
$this->db->select('*,DATE_FORMAT(b.TGL_SO,"%d/%m/%Y") as TANGGAL');
$this->db->from('manajemen_kuartal a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('pelanggan c','c.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->join('kota d','d.ID_KOTA=c.KOTA_ID');
$this->db->join('karyawan e','e.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->join('penjualan f','f.SO_ID=b.ID_SO');
$this->db->where(['a.KUARTAL_ID' => $id_kuartal]);
$this->db->where(['a.KARYAWAN_ID' => $id_karyawan]);
$this->db->order_by('b.TGL_SO ASC, b.KODE_SO ASC');
return $this->db->get()->result_array();
}
public function getSum_DaftarOrder_bySO($id) { //Penjualan = [1]
$this->db->select('SUM(a.QTY_DO*a.HARGA_DO) as TOTAL');
$this->db->from('daftar_order a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->where(['a.SO_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_HargaAvg_byBARANG_forManajemenKuartal($id, $tanggal) {
$this->db->select('*');
$this->db->from('harga_avg');
$this->db->where(['BARANG_ID' => $id]);
$this->db->where('TGL_HAVG<=', $tanggal);
$this->db->order_by('ID_HAVG DESC');
return $this->db->get()->result_array();
}
public function getSum_HppProyek_bySO($id) {
$this->db->select('SUM(a.HARGA_HPR) as TOTAL');
$this->db->from('hpp_proyek a');
$this->db->join('proyek b','b.ID_PROYEK=a.PROYEK_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->where(['b.SO_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarOrder_bySO_forTotalA2($id) {
$this->db->select('*,CONCAT("Rp ",FORMAT(a.HARGA_DO,2)) as HARGA,CONCAT("Rp ",FORMAT(e.NILAI_HAVG,2)) as AVG,
CONCAT("Rp ",FORMAT(f.DEALER_HSRP,2)) as DEALER,CONCAT("Rp ",FORMAT(f.USER_HSRP,2)) as USER,a.BARANG_ID as AID');
$this->db->from('daftar_order a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID','left');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID','left');
$this->db->join('kuantiti d','d.ID_KUANTITI=a.BARANG_ID','left');
$this->db->join('harga_avg e','e.BARANG_ID=a.BARANG_ID','left');
$this->db->join('harga_srp f','f.BARANG_ID=a.BARANG_ID','left');
$this->db->join('pelanggan g','g.ID_PELANGGAN=b.PELANGGAN_ID','left');
$this->db->join('jenis h','h.ID_JENIS=c.JENIS_ID','left');
$this->db->where(['a.SO_ID' => $id]);
$this->db->group_by('a.ID_DO');
return $this->db->get()->result_array();
}
public function getSum_DaftarOrder_byID($id) {
$this->db->select('SUM(a.QTY_DO*a.HARGA_DO) as TOTAL,c.TYPE_JENIS');
$this->db->from('daftar_order a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->where(['a.ID_DO' => $id]);
return $this->db->get()->result_array();
}
public function getData_Penjualan_bySO($id) {
$this->db->select('*');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID','left');
$this->db->where(['a.SO_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Penjualan_byID($id) {
$this->db->select('*');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID','left');
$this->db->where(['a.ID_PENJUALAN' => $id]);
return $this->db->get()->result_array();
}
public function getData_Penjualan() {
$this->db->select('*');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('pelanggan c','c.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->order_by('a.INV_PENJUALAN ASC');
return $this->db->get()->result_array();
}
public function getData_Pelanggan_dataSERVICE() {
$this->db->select('*');
$this->db->from('service a');
$this->db->join('pelanggan b','b.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->join('kota c','c.ID_KOTA=b.KOTA_ID');
$this->db->group_by('a.PELANGGAN_ID');
$this->db->order_by('b.NAMA_PELANGGAN ASC');
return $this->db->get()->result_array();
}
public function getSum_PiutangDagang_byPENJUALAN_forManajemenKuartal($id) {
$this->db->select('SUM(DEBET_PDA-KREDIT_PDA) as TOTAL');
$this->db->from('piutang_dagang');
$this->db->where('TRANSAKSI_PDA!=2');
$this->db->where(['PENJUALAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_PiutangDagang_byPENJUALAN_forManajemenKuartal($id) {
$this->db->select('*');
$this->db->from('piutang_dagang');
$this->db->where('TRANSAKSI_PDA!=2');
$this->db->where(['PENJUALAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_PiutangDagang_byPENJUALAN($id) {
$this->db->select('*,DATE_FORMAT(TGL_PDA,"%d/%m/%Y") as TANGGAL,FORMAT(DEBET_PDA,2) as DEBET,FORMAT(KREDIT_PDA,2) as KREDIT');
$this->db->from('piutang_dagang');
$this->db->where(['PENJUALAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kasbank_byKODE($id) {
$this->db->select('*');
$this->db->from('kasbank');
$this->db->where(['KODE_KB' => $id]);
return $this->db->get()->result_array();
}
public function getData_JurnalMemo_byKODE($id) {
$this->db->select('*');
$this->db->from('jurnal_memo');
$this->db->where(['KODE_JM' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kuartal_byID_StatusKunci($id) {
$this->db->select('*,DATE_FORMAT(KUNCI_KUARTAL,"%d/%m/%Y") as TANGGAL');
$this->db->from('kuartal');
$this->db->where(['ID_KUARTAL' => $id]);
return $this->db->get()->result_array();
}
public function getData_ManajemenKuartal_bySO($id) {
$this->db->select('*');
$this->db->from('manajemen_kuartal');
$this->db->where(['SO_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_ManajemenKuartal_byID($id) {
$this->db->select('*');
$this->db->from('manajemen_kuartal');
$this->db->where(['ID_MK' => $id]);
return $this->db->get()->result_array();
}
public function getData_PiutangDagang_bySALES_forFormFee($id) {
$this->db->select('*,(SUM(a.DEBET_PDA-a.KREDIT_PDA)-c.FEE_SO) as TOTAL,DATE_FORMAT(c.TGL_SO,"%d/%m/%Y") as TANGGAL,FORMAT(c.FEE_SO,2) as FEE,
d.NAMA_PELANGGAN as NAMPEL,a.PENJUALAN_ID as PID');
$this->db->from('piutang_dagang a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID');
$this->db->join('form_karyawan e','e.PENJUALAN_ID=a.PENJUALAN_ID','left');
$this->db->where(['c.SALES_ID' => $id]);
$this->db->where('a.TRANSAKSI_PDA!=2');
$this->db->where('c.FEE_SO>0');
$this->db->where('e.ID_FK is NULL');
$this->db->where('b.TGL_PENJUALAN>"2022-12-31"');
$this->db->group_by('a.PENJUALAN_ID');
$this->db->order_by('c.KODE_SO DESC');
return $this->db->get()->result_array();
}
public function getData_PiutangDagang_bySALES_forFormFeePelanggan($id) {
$this->db->select('*,(SUM(a.DEBET_PDA-a.KREDIT_PDA)-c.FEE_SO) as TOTAL,DATE_FORMAT(c.TGL_SO,"%d/%m/%Y") as TANGGAL,FORMAT(c.FEE_SO,2) as FEE,
d.NAMA_PELANGGAN as NAMPEL,a.PENJUALAN_ID as PID');
$this->db->from('piutang_dagang a');
$this->db->join('penjualan b','b.ID_PENJUALAN=a.PENJUALAN_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID');
$this->db->join('form_feepelanggan e','e.PENJUALAN_ID=a.PENJUALAN_ID','left');
$this->db->where(['c.SALES_ID' => $id]);
$this->db->where('a.TRANSAKSI_PDA!=2');
$this->db->where('c.FEE_SO>0');
$this->db->where('e.ID_FFP is NULL');
$this->db->where('b.TGL_PENJUALAN>"2022-12-31"');
$this->db->group_by('a.PENJUALAN_ID');
$this->db->order_by('c.KODE_SO DESC');
return $this->db->get()->result_array();
}
public function getData_SalesOrder_forManajemenKuartal_khususBarang($id_kuartal, $id_karyawan) {
$this->db->select('a.KODE_SO, a.PPN_SO, b.INV_PENJUALAN, DATE_FORMAT(b.TGL_PENJUALAN,"%d/%m/%Y") as TANGGAL,FORMAT(SUM(h.QTY_DO*h.HARGA_DO),2) as DPP,
FORMAT(SUM((a.PPN_SO/100)*(h.QTY_DO*h.HARGA_DO)),2) as PPN,FORMAT(ROUND(SUM(((a.PPN_SO+100)/100)*(h.QTY_DO*h.HARGA_DO))),2) as TOTAL,
c.NAMA_PELANGGAN, d.NAMA_KOTA, FORMAT(a.FEE_SO,2) as FEESO');
$this->db->from('sales_order a');
$this->db->join('penjualan b','b.SO_ID=a.ID_SO');
$this->db->join('pelanggan c','c.ID_PELANGGAN=a.PELANGGAN_ID');
$this->db->join('kota d','d.ID_KOTA=c.KOTA_ID');
$this->db->join('manajemen_kuartal e','e.SO_ID=a.ID_SO');
$this->db->join('kuartal f','f.ID_KUARTAL=e.KUARTAL_ID');
$this->db->join('karyawan g','g.ID_KARYAWAN=e.KARYAWAN_ID');
$this->db->join('daftar_order h','h.SO_ID=a.ID_SO');
$this->db->where(['e.KARYAWAN_ID' => $id_karyawan]);
$this->db->where(['e.KUARTAL_ID' => $id_kuartal]);
$this->db->where('a.STATUS_SO=1');
$this->db->group_by('a.ID_SO');
return $this->db->get()->result_array();
}
public function getData_DaftarOrder_forManajemenKuartal($id_kuartal, $id_karyawan) {
$this->db->select('d.TGL_SO as TGL, b.KODE_BARANG, a.BARANG_ID, DATE_FORMAT(d.TGL_SO,"%d/%m/%Y") as TANGGAL, a.QTY_DO as QTY,
d.KODE_SO as KODEBUKTI, d.TGL_SO');
$this->db->from('daftar_order a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->join('sales_order d','d.ID_SO=a.SO_ID');
$this->db->join('manajemen_kuartal e','e.SO_ID=d.ID_SO');
$this->db->join('kuartal f','f.ID_KUARTAL=e.KUARTAL_ID');
$this->db->join('karyawan g','g.ID_KARYAWAN=e.KARYAWAN_ID');
$this->db->where(['e.KARYAWAN_ID' => $id_karyawan]);
$this->db->where(['e.KUARTAL_ID' => $id_kuartal]);
$this->db->where('c.TYPE_JENIS!=2');
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_forManajemenKuartal($id_kuartal, $id_karyawan) {
$this->db->select('a.TGL_IO as TGL, b.KODE_BARANG, a.BARANG_ID, DATE_FORMAT(a.TGL_IO,"%d/%m/%Y") as TANGGAL, a.QTY_IO as QTY,
a.KODE_BUKTI as KODEBUKTI,d.TGL_SO');
$this->db->from('transaksi_stock a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->join('sales_order d','d.ID_SO=a.SO_ID');
$this->db->join('manajemen_kuartal e','e.SO_ID=d.ID_SO');
$this->db->join('kuartal f','f.ID_KUARTAL=e.KUARTAL_ID');
$this->db->join('karyawan g','g.ID_KARYAWAN=e.KARYAWAN_ID');
$this->db->where(['e.KARYAWAN_ID' => $id_karyawan]);
$this->db->where(['e.KUARTAL_ID' => $id_kuartal]);
$this->db->where('a.JENIS_IO=0');
return $this->db->get()->result_array();
}
public function getData_HppProyek_forManajemenKuartal($id_kuartal, $id_karyawan) {
$this->db->select('*,FORMAT(a.HARGA_HPR,2) as HARGAHPR,DATE_FORMAT(c.TGL_SO,"%d/%m/%Y") as TANGGAL');
$this->db->from('hpp_proyek a');
$this->db->join('proyek b','b.ID_PROYEK=a.PROYEK_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->join('pelanggan d','d.ID_PELANGGAN=c.PELANGGAN_ID');
$this->db->join('kota e','e.ID_KOTA=d.KOTA_ID');
$this->db->join('daftar_kasbank f','f.ID_DKB=a.DKB_ID');
$this->db->join('manajemen_kuartal g','g.SO_ID=c.ID_SO');
$this->db->join('kuartal h','h.ID_KUARTAL=g.KUARTAL_ID');
$this->db->join('karyawan i','i.ID_KARYAWAN=g.KARYAWAN_ID');
$this->db->join('kasbank j','j.ID_KB=f.KB_ID');
$this->db->where(['g.KARYAWAN_ID' => $id_karyawan]);
$this->db->where(['g.KUARTAL_ID' => $id_kuartal]);
return $this->db->get()->result_array();
}
}
?>
Reference in New Issue View Git Blame Copy Permalink