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

2076 lines
83 KiB
PHP
Raw Permalink Blame History

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class ModelPersediaan 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 getData_HistoriKuantiti_byBARANG_orderDESC_limit1($id) { //RekapGp = [6, 12]
$this->db->select('*');
$this->db->from('histori_kuantiti');
$this->db->where('BARANG_ID=', $id);
$this->db->order_by('ID_HQ DESC');
$this->db->limit('1');
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_AllJenis_byGUDANG_Null($id) { //Persediaan = [1, 6]
$this->db->select('*,FORMAT(a.HARGA_IO,2) as HARGA');
$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('karyawan d','d.ID_KARYAWAN=a.GUDANG_ID');
$this->db->where('a.STATUS_IO is NULL');
$this->db->where('a.SO_ID is NULL');
$this->db->where(['a.GUDANG_ID' => $id]);
return $this->db->get()->result_array();
}
public function getBarang_TransaksiStock0($level) { //Persediaan = [1, 26, 53, 84, 98, 114]
if ($level == 0) {
$this->db->select('*,c.PCM_KUANTITI as QTY');
} else if ($level == 1) {
$this->db->select('*,c.ITP_KUANTITI as QTY');
}
$this->db->from('barang a');
$this->db->join('jenis b','b.ID_JENIS=a.JENIS_ID');
$this->db->join('kuantiti c','c.ID_KUANTITI=a.ID_BARANG');
$this->db->where('b.TYPE_JENIS!=2');
if ($level == 0) {
$this->db->where('c.PCM_KUANTITI!=0');
$this->db->order_by('c.PCM_KUANTITI DESC,b.NAMA_JENIS ASC,a.KODE_BARANG ASC');
} else if ($level == 1) {
$this->db->where('c.ITP_KUANTITI!=0');
$this->db->order_by('c.ITP_KUANTITI DESC,b.NAMA_JENIS ASC,a.KODE_BARANG ASC');
}
return $this->db->get()->result_array();
}
public function getBarang_TransaksiStock1() { //Persediaan = [1]
$this->db->select('*');
$this->db->from('barang a');
$this->db->join('jenis b','b.ID_JENIS=a.JENIS_ID','left');
$this->db->order_by('b.NAMA_JENIS ASC,a.KODE_BARANG ASC');
$this->db->where('b.TYPE_JENIS!=2');
return $this->db->get()->result_array();
}
public function getData_HargaPart_byPART() { //Persediaan = [1]
$this->db->select('*');
$this->db->from('harga_part a');
$this->db->join('part b','b.ID_PART=a.PART_ID');
$this->db->order_by('b.NAMA_PART ASC, a.ID_HPAR DESC');
return $this->db->get()->result_array();
}
public function getData_SalesOrder_byID($id=null) { //Persediaan = [1, 6, 97]
if ($id==null) {
$this->db->select('*,DATE_FORMAT(a.TGL_SO,"%d/%m/%Y") as TANGGAL');
$this->db->from('sales_order a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.SALES_ID');
$this->db->where('a.STATUS_SO=1');
} else {
$this->db->select('*');
$this->db->from('sales_order');
$this->db->where(['ID_SO' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Karyawan_byID($id=null) { //Persediaan = [1, 26, 30, 68, 77]
if ($id==null) {
$this->db->select('*');
$this->db->from('karyawan');
} else {
$this->db->select('*');
$this->db->from('karyawan');
$this->db->where(['ID_KARYAWAN' => $id]);
}
return $this->db->get()->result_array();
}
public function getQtyReal_TransaksiStock0($id) { //Persediaan = [1, 6, 7, 10, 11]
$this->db->select('a.ID_SNIO');
$this->db->from('sn_io a');
$this->db->join('transaksi_stock b','b.ID_IO=a.IO_ID');
$this->db->group_by('a.ID_SNIO');
$this->db->where(['a.IO_ID' => $id]);
$this->db->where('a.JENIS_SNIO=0');
return $this->db->count_all_results();
}
public function getQtyReal_TransaksiStock1($id) { //Persediaan = [1, 6, 12, 14, 15]
$this->db->select('a.ID_SNIO');
$this->db->from('sn_io a');
$this->db->join('transaksi_stock b','b.ID_IO=a.IO_ID');
$this->db->group_by('a.ID_SNIO');
$this->db->where(['a.IO_ID' => $id]);
$this->db->where('a.JENIS_SNIO=1');
return $this->db->count_all_results();
}
public function getData_Karyawan_forLogin($username, $password) { //Persediaan = [2, 20]
$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_Kuantiti_byID($id=null) { //Persediaan = [3, 4, 6, 27, 29, 46, 47, 54, 56, 67, 74, 76, 78, 86, 87, 94, 95, 96, 97, 100, 116, 118, 125, 133]
if ($id==null) {
$this->db->select('*');
$this->db->from('kuantiti');
} else {
$this->db->select('*');
$this->db->from('kuantiti');
$this->db->where(['ID_KUANTITI' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_HargaPart_byID($id) { //Persediaan = [3]
$this->db->select('*');
$this->db->from('harga_part');
$this->db->where(['ID_HPAR' => $id]);
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_Null($id) { //Persediaan = [4, 11, 14, 15]
$this->db->select('*');
$this->db->from('transaksi_stock');
$this->db->where(['ID_IO' => $id]);
$this->db->where('STATUS_IO is NULL');
return $this->db->get()->result_array();
}
public function getData_SnIo_byIO($id) { //Persediaan = [4]
$this->db->select('*');
$this->db->from('sn_io a');
$this->db->join('transaksi_stock b','b.ID_IO=a.IO_ID');
$this->db->where(['a.IO_ID' => $id]);
return $this->db->get()->result_array();
}
public function getKode_TransaksiStock() { //Persediaan = [5]
$this->db->select('MAX(KODE_BUKTI) AS KODE');
$this->db->from('transaksi_stock');
$this->db->like('KODE_BUKTI','KM', 'after');
return $this->db->get()->result_array();
}
public function getData_SnIo_byIO_0($id) { //Persediaan = [6, 8, 9]
$this->db->select('*');
$this->db->from('sn_io a');
$this->db->join('transaksi_stock b','b.ID_IO=a.IO_ID');
$this->db->join('barang c','c.ID_BARANG=b.BARANG_ID');
$this->db->where(['a.IO_ID' => $id]);
$this->db->where('a.JENIS_SNIO=0');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_AllStatus($id) { //Persediaan = [6, 11, 15, 29, 31, 36, 43, 56, 61, 67, 76, 78, 83, 108, 113, 123]
$this->db->select('*');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnIo_byIO_1($id) { //Persediaan = [6, 12, 13]
$this->db->select('*');
$this->db->from('sn_io a');
$this->db->join('transaksi_stock b','b.ID_IO=a.IO_ID');
$this->db->join('barang c','c.ID_BARANG=b.BARANG_ID');
$this->db->where(['a.IO_ID' => $id]);
$this->db->where('a.JENIS_SNIO=1');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_13($id) { //Persediaan = [6]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=13');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_Null($id) { //Persediaan = [6]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK is NULL');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_0($id) { //Persediaan = [6]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=0');
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_byID($id) { //Persediaan = [7, 10, 12]
$this->db->select('*');
$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->where(['a.ID_IO' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnStock_byBARANG_Null($id, $level) { //Persediaan = [7, 12, 32, 57, 79, 109, 119]
$this->db->select('*');
$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');
if ($level == 0) {
$this->db->where('a.GUDANG_SNSTOCK=1');
} else if ($level == 1) {
$this->db->where('a.GUDANG_SNSTOCK=2');
}
return $this->db->get()->result_array();
}
public function getData_SnStock_byBARANG_0($id, $level) { //Persediaan = [7, 12, 32, 57, 79, 109, 119]
$this->db->select('*');
$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=0');
if ($level == 0) {
$this->db->where('a.GUDANG_SNSTOCK=1');
} else if ($level == 1) {
$this->db->where('a.GUDANG_SNSTOCK=2');
}
return $this->db->get()->result_array();
}
public function getData_SnStock_SnIo_byNAMA_AllStatus($id) { //Persediaan = [10, 14]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('sn_io b','b.NAMA_SNIO=a.NAMA_SNSTOCK','left');
$this->db->where(['a.NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnIo_SnStock_byNAMA_0_13($id) { //Persediaan = [10]
$this->db->select('*');
$this->db->from('sn_io a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNIO','left');
$this->db->where(['a.NAMA_SNIO' => $id]);
$this->db->where('a.JENIS_SNIO=0');
$this->db->where('b.STATUS_SNSTOCK=13');
return $this->db->get()->result_array();
}
public function getData_SnIo_byID($id) { //Persediaan = [11, 15]
$this->db->select('*');
$this->db->from('sn_io');
$this->db->where(['ID_SNIO' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnBeli_byNAMA_AllStatus($id) { //Persediaan = [14]
$this->db->select('*');
$this->db->from('sn_beli');
$this->db->where(['NAMA_SNB' => $id]);
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_1($id=null) { //Persediaan = [16, 17]
if ($id==null) {
$tgl_now = date('Y-m-01');
$this->db->select('*,FORMAT(a.HARGA_IO,2) as HARGA,DATE_FORMAT(a.TGL_IO,"%d/%m/%Y") as TANGGAL');
$this->db->from('transaksi_stock a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->where('a.HARGA_IO=0');
$this->db->where('a.STATUS_IO=1');
$this->db->where('a.JENIS_IO=1');
$this->db->where('a.SETDATA_ID IS NULL');
$this->db->where('a.HPAR_ID IS NULL');
$this->db->where('a.TGL_IO>=', $tgl_now);
$this->db->order_by('a.TGL_IO ASC, b.KODE_BARANG ASC, a.KODE_BUKTI ASC');
} else {
$this->db->select('*,FORMAT(a.HARGA_IO,2) as HARGA,DATE_FORMAT(a.TGL_IO,"%d/%m/%Y") as TANGGAL');
$this->db->from('transaksi_stock a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=a.GUDANG_ID');
$this->db->where('a.STATUS_IO=1');
$this->db->where('a.JENIS_IO=1');
$this->db->where('a.SETDATA_ID IS NULL');
$this->db->where('a.ID_IO=', $id);
$this->db->order_by('a.TGL_IO ASC, b.KODE_BARANG ASC');
}
return $this->db->get()->result_array();
}
public function getData_HistoriKuantiti_byIO($id) { //Persediaan = [18]
$this->db->select('*');
$this->db->from('histori_kuantiti a');
$this->db->join('transaksi_stock b','b.ID_IO=a.IO_ID');
$this->db->where('a.IO_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_Operasional_Null($id=null) { //Persediaan = [19, 24, 27, 29]
if ($id==null) {
$this->db->select('*,DATE_FORMAT(a.TGL_OPERASIONAL,"%d/%m/%Y") as TANGGAL');
$this->db->from('operasional a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where('a.STATUS_OPERASIONAL is NULL');
} else {
$this->db->select('*');
$this->db->from('operasional a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where('a.STATUS_OPERASIONAL is NULL');
$this->db->where(['a.ID_OPERASIONAL' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Karyawan_Operasional() { //Persediaan = [19]
$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!=1');
$this->db->order_by('a.NAMA_KARYAWAN ASC');
return $this->db->get()->result_array();
}
public function getKode_Operasional() { //Persediaan = [21]
$this->db->select('MAX(KODE_OPERASIONAL) AS KODE');
$this->db->from('operasional');
return $this->db->get()->result_array();
}
public function getData_DaftarOperasional_byOPERASIONAL($id) { //Persediaan = [24, 25, 26, 27, 29, 30, 31]
$this->db->select('*');
$this->db->from('daftar_operasional a');
$this->db->join('operasional b','b.ID_OPERASIONAL=a.OPERASIONAL_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.OPERASIONAL_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Operasional_0($id=null) { //Persediaan = [25, 31]
if ($id==null) {
$this->db->select('*,DATE_FORMAT(a.TGL_OPERASIONAL,"%d/%m/%Y") as TANGGAL');
$this->db->from('operasional a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where('a.STATUS_OPERASIONAL=0');
$this->db->order_by('a.ID_OPERASIONAL DESC');
} else {
$this->db->select('*');
$this->db->from('operasional a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.KARYAWAN_ID');
$this->db->where('a.STATUS_OPERASIONAL=0');
$this->db->where(['a.ID_OPERASIONAL' => $id]);
}
return $this->db->get()->result_array();
}
public function getData_Operasional_byID($id) { //Persediaan = [26, 30]
$this->db->select('*');
$this->db->from('operasional');
$this->db->where(['ID_OPERASIONAL' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarOperasional_byID($id) { //Persediaan = [28, 32, 35, 36]
$this->db->select('*');
$this->db->from('daftar_operasional a');
$this->db->join('operasional b','b.ID_OPERASIONAL=a.OPERASIONAL_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.ID_DFO' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnOperasional_byDFO($id) { //Persediaan = [28, 29, 30, 31, 33, 34]
$this->db->select('*');
$this->db->from('sn_operasional a');
$this->db->join('daftar_operasional b','b.ID_DFO=a.DFO_ID');
$this->db->where(['a.DFO_ID' => $id]);
return $this->db->get()->result_array();
}
public function getQtyReal_DaftarOperasional($id) { //Persediaan = [29, 32, 35, 36]
$this->db->select('a.ID_SNO');
$this->db->from('sn_operasional a');
$this->db->join('daftar_operasional b','b.ID_DFO=a.DFO_ID');
$this->db->group_by('a.ID_SNO');
$this->db->where(['a.DFO_ID' => $id]);
return $this->db->count_all_results();
}
public function getData_SnStock_byNAMA_14($id) { //Persediaan = [29]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=14');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_15($id) { //Persediaan = [29]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=15');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_4($id) { //Persediaan = [31]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=4');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_16($id) { //Persediaan = [31]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=16');
return $this->db->get()->result_array();
}
public function getData_SnStock_SnOperasional_byNAMA_AllStatus($id) { //Persediaan = [35]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('sn_operasional b','b.NAMA_SNO=a.NAMA_SNSTOCK','left');
$this->db->where(['a.NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnOperasional_SnStock_byNAMA_14($id) { //Persediaan = [35]
$this->db->select('*');
$this->db->from('sn_operasional a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNO','left');
$this->db->where(['a.NAMA_SNO' => $id]);
$this->db->where('b.STATUS_SNSTOCK=14');
return $this->db->get()->result_array();
}
public function getData_SnOperasional_byID($id) { //Persediaan = [36]
$this->db->select('*');
$this->db->from('sn_operasional a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNO');
$this->db->where(['a.ID_SNO' => $id]);
return $this->db->get()->result_array();
}
public function getData_Penjualan_forPenggantian($level) { //Persediaan = [37]
$tgl_now = date('Y-m-01');
$tgl_now = $this->subTempoMonth($tgl_now, 1);
$this->db->select('*,DATE_FORMAT(a.TGL_PENJUALAN,"%d/%m/%Y") as TANGGAL');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=b.SALES_ID');
$this->db->join('pelanggan d','d.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->join('kota e','e.ID_KOTA=d.KOTA_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.TGL_PENJUALAN>="'.$tgl_now.'"');
return $this->db->get()->result_array();
}
public function subTempoMonth($date,$month) { //Persediaan = []
$sum = strtotime(date("Y-m-d", strtotime("$date")) . " -$month month");
$dateTo=date('Y-m-d',$sum);
return $dateTo;
}
public function getData_SnJual_forPenggantian($id) { //Persediaan = [38, 43]
$this->db->select('*,b.BARANG_ID as BID');
$this->db->from('sn_jual a');
$this->db->join('daftar_order b','b.ID_DO=a.DO_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->join('penjualan d','d.SO_ID=c.ID_SO');
$this->db->join('barang e','e.ID_BARANG=b.BARANG_ID');
$this->db->join('jenis f','f.ID_JENIS=e.JENIS_ID');
$this->db->join('sn_stock g','g.ID_SNSTOCK=a.SNSTOCK_GANTI','left');
$this->db->where(['d.ID_PENJUALAN' => $id]);
$this->db->where('a.STATUS_SNJ=1');
return $this->db->get()->result_array();
}
public function getData_SnJual_byPENJUALAN($id) { //Persediaan = [38]
$this->db->select('*');
$this->db->from('sn_jual a');
$this->db->join('daftar_order b','b.ID_DO=a.DO_ID');
$this->db->join('sales_order c','c.ID_SO=b.SO_ID');
$this->db->join('penjualan d','d.SO_ID=c.ID_SO');
$this->db->join('barang e','e.ID_BARANG=b.BARANG_ID');
$this->db->join('jenis f','f.ID_JENIS=e.JENIS_ID');
$this->db->join('sn_stock g','g.NAMA_SNSTOCK=a.NAMA_SNJ');
$this->db->where(['d.ID_PENJUALAN' => $id]);
$this->db->where('a.STATUS_SNJ is NULL');
$this->db->where('g.STATUS_SNSTOCK=1');
return $this->db->get()->result_array();
}
public function getData_SnStock_Null($level, $id_barang=null) { //Persediaan = [38, 44]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
if ($level == 0) {
$this->db->where('a.GUDANG_SNSTOCK=1');
} else if ($level == 1) {
$this->db->where('a.GUDANG_SNSTOCK=2');
}
if ($id_barang != null) {
$this->db->where('a.BARANG_ID=', $id_barang);
}
$this->db->where('a.STATUS_SNSTOCK is NULL');
$this->db->order_by('c.NAMA_JENIS ASC,b.KODE_BARANG ASC,a.NAMA_SNSTOCK ASC');
return $this->db->get()->result_array();
}
public function getData_SnStock_0($level, $id_barang=null) { //Persediaan = [38, 44]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
if ($level == 0) {
$this->db->where('a.GUDANG_SNSTOCK=1');
} else if ($level == 1) {
$this->db->where('a.GUDANG_SNSTOCK=2');
}
if ($id_barang != null) {
$this->db->where('a.BARANG_ID=', $id_barang);
}
$this->db->where('a.STATUS_SNSTOCK=0');
$this->db->order_by('c.NAMA_JENIS ASC,b.KODE_BARANG ASC,a.NAMA_SNSTOCK ASC');
return $this->db->get()->result_array();
}
public function getData_SalesOrder_byPENJUALAN($id) { //Persediaan = [38]
$this->db->select('*,DATE_FORMAT(a.TGL_SO,"%d/%m/%Y") as TANGGAL');
$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->where('b.ID_PENJUALAN=', $id);
return $this->db->get()->result_array();
}
public function getData_SnIo_byNAMA_1($id) { //Persediaan = [38]
$this->db->select('*');
$this->db->from('sn_io a');
$this->db->join('transaksi_stock b','b.ID_IO=a.IO_ID');
$this->db->join('barang c','c.ID_BARANG=b.BARANG_ID');
$this->db->where(['a.NAMA_SNIO' => $id]);
$this->db->where('a.JENIS_SNIO=1');
$this->db->where('b.JENIS_IO=1');
$this->db->where('b.STATUS_IO is NULL');
return $this->db->get()->result_array();
}
public function getData_Penjualan_byID_forPengantian($id) { //Persediaan = [39, 40, 41, 42, 43]
$tgl_now = date('Y-m-01');
$tgl_now = $this->subTempoMonth($tgl_now, 1);
$this->db->select('');
$this->db->from('penjualan a');
$this->db->join('sales_order b','b.ID_SO=a.SO_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=b.SALES_ID');
$this->db->join('pelanggan d','d.ID_PELANGGAN=b.PELANGGAN_ID');
$this->db->join('kota e','e.ID_KOTA=d.KOTA_ID');
$this->db->where('a.STATUS_PENJUALAN=1');
$this->db->where('a.TGL_PENJUALAN>="'.$tgl_now.'"');
$this->db->where(['a.ID_PENJUALAN' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnJual_byID($id) { //Persediaan = [39, 40, 41, 42]
$this->db->select('*');
$this->db->from('sn_jual a');
$this->db->join('daftar_order b','b.ID_DO=a.DO_ID');
$this->db->where(['a.ID_SNJ' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnJual_bySNSTOCK($id) { //Persediaan = [41]
$this->db->select('*');
$this->db->from('sn_jual');
$this->db->where(['SNSTOCK_GANTI' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnStock_byID($id) { //Persediaan = [41, 43, 47]
$this->db->select('*');
$this->db->from('sn_stock');
$this->db->where(['ID_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_HistoriSn_byKODEBUKTI_bySNSTOCK($id1, $id2) { //Persediaan = [43]
$this->db->select('*');
$this->db->from('histori_sn');
$this->db->where(['KODE_BUKTI' => $id1]);
$this->db->where(['SNSTOCK_ID' => $id2]);
return $this->db->get()->result_array();
}
public function getData_CetakDokumen_byPENJUALAN_forSJ($id) { //Persediaan = [43]
$this->db->select('*');
$this->db->from('cetak_dokumen');
$this->db->where(['PENJUALAN_ID' => $id]);
$this->db->where('SJ_INV=0');
return $this->db->get()->result_array();
}
public function getData_Kuantiti_Antik() { //Persediaan = [44]
$this->db->select('*');
$this->db->from('kuantiti a');
$this->db->join('barang b','b.ID_BARANG=a.ID_KUANTITI');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->where('a.ANTIK_KUANTITI!=0');
$this->db->order_by('c.NAMA_JENIS ASC, b.KODE_BARANG ASC');
return $this->db->get()->result_array();
}
public function getData_Kuantiti_Pcm_Non() { //Persediaan = [44]
$this->db->select('*');
$this->db->from('kuantiti a');
$this->db->join('barang b','b.ID_BARANG=a.ID_KUANTITI');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->where('a.PCM_KUANTITI!=0');
$this->db->where('c.TYPE_JENIS=0');
$this->db->order_by('c.NAMA_JENIS ASC, a.PCM_KUANTITI DESC');
return $this->db->get()->result_array();
}
public function getData_Kuantiti_Antik_Non() { //Persediaan = [44]
$this->db->select('*');
$this->db->from('kuantiti a');
$this->db->join('barang b','b.ID_BARANG=a.ID_KUANTITI');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->where('a.ANTIK_KUANTITI!=0');
$this->db->where('c.TYPE_JENIS=0');
$this->db->order_by('c.NAMA_JENIS ASC, a.ANTIK_KUANTITI DESC');
return $this->db->get()->result_array();
}
public function getData_SnStock_5() { //Persediaan = [44]
$this->db->select('*');
$this->db->from('sn_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->where('a.STATUS_SNSTOCK=5');
$this->db->order_by('c.NAMA_JENIS ASC,b.KODE_BARANG ASC,a.NAMA_SNSTOCK ASC');
return $this->db->get()->result_array();
}
public function getData_SnAntik_byBARANG($id) { //Persediaan = [44]
$this->db->select('a.NAMA_SNA');
$this->db->from('sn_antik a');
$this->db->join('stok_antik b','b.ID_SA=a.SA_ID');
$this->db->join('barang c','c.ID_BARANG=b.BARANG_ID');
$this->db->where('b.BARANG_ID=', $id);
return $this->db->get()->result_array();
}
public function getKode_StokAntik() { //Persediaan = [45]
$this->db->select('MAX(KODE_SA) AS KODE');
$this->db->from('stok_antik');
$this->db->like('KODE_SA','SA', 'after');
return $this->db->get()->result_array();
}
public function getID_SAMax() { //Persediaan = [47]
$this->db->select_max('ID_SA');
$this->db->from('stok_antik');
return $this->db->get()->result_array();
}
public function getData_Konsinyasi_Null($id = null, $level = null) { //Persediaan = [48, 52, 54, 56]
if ($id==null) {
$this->db->select('*,DATE_FORMAT(a.TGL_KONSINYASI,"%d/%m/%Y") as TANGGAL');
$this->db->from('konsinyasi a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.SALES_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('a.STATUS_KONSINYASI is NULL');
$this->db->where('a.JENIS_KONSINYASI=', $level);
} else {
$this->db->select('*');
$this->db->from('konsinyasi');
$this->db->where(['ID_KONSINYASI' => $id]);
$this->db->where('STATUS_KONSINYASI is NULL');
}
return $this->db->get()->result_array();
}
public function getData_SalesAll($id = null) { //Persediaan = [48, 84, 88]
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('b.NAMA_JABATAN!="GUDANG"');
$this->db->where('b.NAMA_JABATAN!="KEUANGAN"');
$this->db->where('b.NAMA_JABATAN!="UMUM"');
$this->db->where('b.NAMA_JABATAN!="SERVICE"');
$this->db->where('b.NAMA_JABATAN!="SUPPORT"');
$this->db->where('b.NAMA_JABATAN!="ADMIN GUDANG"');
$this->db->where('b.NAMA_JABATAN!="ADMIN KEUANGAN"');
$this->db->where('b.NAMA_JABATAN!="ADMIN UMUM"');
$this->db->order_by('a.NAMA_PANGGILAN_KARYAWAN');
} 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_Pelanggan_byID($id = null) { //Persediaan = [48, 53, 63, 68, 84, 88]
if ($id == null) {
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
} else {
$this->db->select('*');
$this->db->from('pelanggan a');
$this->db->join('kota b','b.ID_KOTA=a.KOTA_ID');
$this->db->where(['a.ID_PELANGGAN' => $id]);
}
return $this->db->get()->result_array();
}
public function getKode_Konsinyasi() { //Persediaan = [49]
$this->db->select('MAX(KODE_KONSINYASI) AS KODE');
$this->db->from('konsinyasi');
return $this->db->get()->result_array();
}
public function getData_Konsinyasi_byID($id) { //Persediaan = [51, 53]
$this->db->select('*,DATE_FORMAT(a.TGL_KONSINYASI,"%d/%m/%Y") as TANGGAL');
$this->db->from('konsinyasi 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_KONSINYASI' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarKonsi_byKONSINYASI($id) { //Persediaan = [52, 53, 54, 56]
$this->db->select('*');
$this->db->from('daftar_konsi a');
$this->db->join('konsinyasi b','b.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->join('kuantiti e','e.ID_KUANTITI=c.ID_BARANG');
$this->db->where(['a.KONSINYASI_ID' => $id]);
return $this->db->get()->result_array();
}
public function getQtyReal_DaftarKonsi($id) { //Persediaan = [53, 56, 57, 60, 61]
$this->db->select('a.ID_SNK');
$this->db->from('sn_konsi a');
$this->db->join('daftar_konsi b','b.ID_DFK=a.DFK_ID');
$this->db->group_by('a.ID_SNK');
$this->db->where(['a.DFK_ID' => $id]);
return $this->db->count_all_results();
}
public function getData_DaftarKonsi_byID($id) { //Persediaan = [55, 57, 60, 61]
$this->db->select('*');
$this->db->from('daftar_konsi a');
$this->db->join('konsinyasi b','b.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.ID_DFK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byDFK($id) { //Persediaan = [55, 56, 58, 59]
$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.DFK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_10($id) { //Persediaan = [56]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=10');
return $this->db->get()->result_array();
}
public function getData_SnStock_SnKonsi_byNAMA_AllStatus($id) { //Persediaan = [60]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('sn_konsi b','b.NAMA_SNK=a.NAMA_SNSTOCK','left');
$this->db->where(['a.NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnKonsi_SnStock_byNAMA_16($id) { //Persediaan = [60]
$this->db->select('*');
$this->db->from('sn_konsi a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNK','left');
$this->db->where(['a.NAMA_SNK' => $id]);
$this->db->where('b.STATUS_SNSTOCK=16');
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byID($id) { //Persediaan = [61, 65]
$this->db->select('*');
$this->db->from('sn_konsi a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNK');
$this->db->where(['a.ID_SNK' => $id]);
return $this->db->get()->result_array();
}
public function getData_Konsinyasi_groupPELANGGAN($level) { //Persediaan = [62]
$this->db->select('*');
$this->db->from('konsinyasi 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.JENIS_KONSINYASI=', $level);
$this->db->where('a.STATUS_KONSINYASI=1');
$this->db->order_by('b.NAMA_PELANGGAN ASC');
$this->db->group_by('a.PELANGGAN_ID');
return $this->db->get()->result_array();
}
public function getData_Konsinyasi_byPELANGGAN_status0($id) { //Persediaan = [62]
$this->db->select('*,SUM(a.QTY_DFK) as QTYDFK');
$this->db->from('daftar_konsi 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('konsinyasi d','d.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->join('kuantiti e','e.ID_KUANTITI=a.BARANG_ID');
$this->db->where('d.STATUS_KONSINYASI=0');
$this->db->where('d.PELANGGAN_ID=', $id);
$this->db->order_by('c.NAMA_JENIS ASC, b.NAMA_BARANG ASC');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_Konsinyasi_byPELANGGAN_status1($id) { //Persediaan = [62]
$this->db->select('*,SUM(a.QTY_DFK) as QTYDFK');
$this->db->from('daftar_konsi 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('konsinyasi d','d.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->join('kuantiti e','e.ID_KUANTITI=a.BARANG_ID');
$this->db->where('d.STATUS_KONSINYASI=1');
$this->db->where('d.PELANGGAN_ID=', $id);
$this->db->order_by('c.NAMA_JENIS ASC, b.NAMA_BARANG ASC');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_Konsinyasi_byPELANGGAN_allStatus($id) { //Persediaan = [62]
$this->db->select('*,SUM(a.QTY_DFK) as QTYDFK');
$this->db->from('daftar_konsi 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('konsinyasi d','d.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->join('kuantiti e','e.ID_KUANTITI=a.BARANG_ID');
$this->db->where('d.PELANGGAN_ID=', $id);
$this->db->order_by('c.NAMA_JENIS ASC, b.NAMA_BARANG ASC');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanKonsi_byBARANG_byPELANGGAN_status0($id1, $id2) { //Persediaan = [62, 65]
$this->db->select('*,SUM(a.QTY_DPK) as QTYDPK');
$this->db->from('daftar_penarikankonsi a');
$this->db->join('penarikan_konsi b','b.ID_PK=a.PK_ID');
$this->db->where(['a.BARANG_ID' => $id1]);
$this->db->where(['b.PELANGGAN_ID' => $id2]);
$this->db->where('b.STATUS_PK=0');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanKonsi_byBARANG_byPELANGGAN_status1($id1, $id2) { //Persediaan = [62, 65]
$this->db->select('*,SUM(a.QTY_DPK) as QTYDPK');
$this->db->from('daftar_penarikankonsi a');
$this->db->join('penarikan_konsi b','b.ID_PK=a.PK_ID');
$this->db->where(['a.BARANG_ID' => $id1]);
$this->db->where(['b.PELANGGAN_ID' => $id2]);
$this->db->where('b.STATUS_PK=1');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanLaku_byBARANG_byPELANGGAN_status0($id1, $id2) { //Persediaan = [62, 65]
$this->db->select('*,SUM(a.QTY_DPL) as QTYDPL');
$this->db->from('daftar_penarikanlaku a');
$this->db->join('penarikan_laku b','b.ID_PL=a.PL_ID');
$this->db->where(['a.BARANG_ID' => $id1]);
$this->db->where(['b.PELANGGAN_ID' => $id2]);
$this->db->where('b.STATUS_PL=0');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanLaku_byBARANG_byPELANGGAN_status1($id1, $id2) { //Persediaan = [62, 65]
$this->db->select('*,SUM(a.QTY_DPL) as QTYDPL');
$this->db->from('daftar_penarikanlaku a');
$this->db->join('penarikan_laku b','b.ID_PL=a.PL_ID');
$this->db->where(['a.BARANG_ID' => $id1]);
$this->db->where(['b.PELANGGAN_ID' => $id2]);
$this->db->where('b.STATUS_PL=1');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byPELANGGAN_AllNull($id) { //Persediaan = [63]
$this->db->select('*');
$this->db->from('sn_konsi a');
$this->db->join('daftar_konsi b','b.ID_DFK=a.DFK_ID');
$this->db->join('konsinyasi c','c.ID_KONSINYASI=b.KONSINYASI_ID');
$this->db->join('barang d','d.ID_BARANG=b.BARANG_ID');
$this->db->where(['c.PELANGGAN_ID' => $id]);
$this->db->where('a.PK_ID is NULL');
$this->db->where('a.PL_ID is NULL');
$this->db->where('a.STATUS_SNK is NULL');
return $this->db->get()->result_array();
}
public function getData_PenarikanKonsi_byPELANGGAN($id) { //Persediaan = [63]
$this->db->select('*,SUM(a.QTY_DPK) as QTYDPK,DATE_FORMAT(d.TGL_PK,"%d/%m/%Y") as TANGGAL');
$this->db->from('daftar_penarikankonsi 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('penarikan_konsi d','d.ID_PK=a.PK_ID');
$this->db->join('kuantiti e','e.ID_KUANTITI=a.BARANG_ID');
$this->db->where('d.STATUS_PK is NULL');
$this->db->where('d.PELANGGAN_ID=', $id);
$this->db->order_by('a.ID_DPK ASC');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byBARANG_byPELANGGAN_forPenarikan($id1, $id2) { //Persediaan = [63]
$this->db->select('*');
$this->db->from('sn_konsi a');
$this->db->join('daftar_konsi b','b.ID_DFK=a.DFK_ID');
$this->db->join('konsinyasi c','c.ID_KONSINYASI=b.KONSINYASI_ID');
$this->db->where(['b.BARANG_ID' => $id1]);
$this->db->where(['c.PELANGGAN_ID' => $id2]);
$this->db->where('a.PL_ID is NULL');
$this->db->where('c.STATUS_KONSINYASI=0');
$this->db->where('a.STATUS_SNK=0');
$this->db->where('a.PK_ID is NOT NULL');
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byBARANG_byPELANGGAN_forKonsinyasi($id1, $id2) { //Persediaan = [63]
$this->db->select('*');
$this->db->from('sn_konsi a');
$this->db->join('daftar_konsi b','b.ID_DFK=a.DFK_ID');
$this->db->join('konsinyasi c','c.ID_KONSINYASI=b.KONSINYASI_ID');
$this->db->where(['b.BARANG_ID' => $id1]);
$this->db->where(['c.PELANGGAN_ID' => $id2]);
$this->db->where('c.STATUS_KONSINYASI=0');
$this->db->where('a.STATUS_SNK is NULL');
$this->db->where('a.PL_ID is NULL');
$this->db->where('a.PK_ID is NULL');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanKonsi_byBARANG_byPELANGGAN_allStatus($id1, $id2) { //Persediaan = [63]
$this->db->select('*,SUM(a.QTY_DPK) as QTYDPK');
$this->db->from('daftar_penarikankonsi a');
$this->db->join('penarikan_konsi b','b.ID_PK=a.PK_ID');
$this->db->where(['a.BARANG_ID' => $id1]);
$this->db->where(['b.PELANGGAN_ID' => $id2]);
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanLaku_byBARANG_byPELANGGAN_allStatus($id1, $id2) { //Persediaan = [63]
$this->db->select('*,SUM(a.QTY_DPL) as QTYDPL');
$this->db->from('daftar_penarikanlaku a');
$this->db->join('penarikan_laku b','b.ID_PL=a.PL_ID');
$this->db->where(['a.BARANG_ID' => $id1]);
$this->db->where(['b.PELANGGAN_ID' => $id2]);
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getKode_PenarikanKonsi() { //Persediaan = [64]
$this->db->select('MAX(KODE_PK) AS KODE');
$this->db->from('penarikan_konsi');
return $this->db->get()->result_array();
}
public function getData_PenarikanKonsi_byPELANGGAN_orderDESC($id) { //Persediaan = [65, 67]
$this->db->select('*');
$this->db->from('penarikan_konsi');
$this->db->where(['PELANGGAN_ID' => $id]);
$this->db->order_by('ID_PK DESC');
$this->db->limit('1');
return $this->db->get()->result_array();
}
public function getData_PenarikanKonsi_byPELANGGAN_Null($id, $level) { //Persediaan = [65]
$this->db->select('*');
$this->db->from('penarikan_konsi');
$this->db->where(['PELANGGAN_ID' => $id]);
$this->db->where(['JENIS_PK' => $level]);
$this->db->where('STATUS_PK is NULL');
return $this->db->get()->result_array();
}
public function getID_PKMax() { //Persediaan = [65]
$this->db->select_max('ID_PK');
$this->db->from('penarikan_konsi');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanKonsi_byPK($id) { //Persediaan = [65, 67]
$this->db->select('*');
$this->db->from('daftar_penarikankonsi 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('penarikan_konsi d','d.ID_PK=a.PK_ID');
$this->db->where(['a.PK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byID_Null($id) { //Persediaan = [65]
$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.ID_SNK' => $id]);
$this->db->where('a.STATUS_SNK is NULL');
return $this->db->get()->result_array();
}
public function getData_DaftarKonsi_byPELANGGAN_jenis1_groupBARANG($id) { //Persediaan = [65]
$this->db->select('*,SUM(a.QTY_DFK) as QTY');
$this->db->from('daftar_konsi a');
$this->db->join('konsinyasi b','b.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['b.PELANGGAN_ID' => $id]);
$this->db->where('d.TYPE_JENIS=1');
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byPK_0($id) { //Persediaan = [65]
$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' => $id]);
$this->db->where('a.STATUS_SNK=0');
return $this->db->get()->result_array();
}
public function getData_Konsinyasi_byBARANG_byPELANGGAN($id1, $id2) { //Persediaan = [65]
$this->db->select('SUM(a.QTY_DFK) as QTYDFK');
$this->db->from('daftar_konsi 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('konsinyasi d','d.ID_KONSINYASI=a.KONSINYASI_ID');
$this->db->join('kuantiti e','e.ID_KUANTITI=a.BARANG_ID');
$this->db->where('d.STATUS_KONSINYASI=0');
$this->db->where('a.BARANG_ID=', $id1);
$this->db->where('d.PELANGGAN_ID=', $id2);
$this->db->group_by('a.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanKonsi_byPK_byBARANG($id1, $id2) { //Persediaan = [65]
$this->db->select('*');
$this->db->from('daftar_penarikankonsi 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('penarikan_konsi d','d.ID_PK=a.PK_ID');
$this->db->where(['a.PK_ID' => $id1]);
$this->db->where(['a.BARANG_ID' => $id2]);
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanKonsi_byPK_byBARANG_Null($id1, $id2) { //Persediaan = [65]
$this->db->select('*');
$this->db->from('daftar_penarikankonsi 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('penarikan_konsi d','d.ID_PK=a.PK_ID');
$this->db->where(['a.PK_ID' => $id1]);
$this->db->where(['a.BARANG_ID' => $id2]);
$this->db->where('d.STATUS_PK is NULL');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanKonsi_byID($id) { //Persediaan = [66]
$this->db->select('*');
$this->db->from('daftar_penarikankonsi 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('penarikan_konsi d','d.ID_PK=a.PK_ID');
$this->db->where(['a.ID_DPK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnKonsi_byPK_byBARANG($id1, $id2) { //Persediaan = [66, 67]
$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]);
$this->db->where('a.STATUS_SNK=0');
return $this->db->get()->result_array();
}
public function getData_Peminjaman_Null_0($level) { //Persediaan = [68]
$this->db->select('*,b.NAMA_PANGGILAN_KARYAWAN as PEMBERI,c.NAMA_PANGGILAN_KARYAWAN as PEMINJAM,
DATE_FORMAT(a.TGL_PEMINJAMAN,"%d/%m/%Y") as TANGGAL');
$this->db->from('peminjaman a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.PEMBERI_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=a.PEMINJAM_ID','left');
$this->db->join('pelanggan d','d.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota e','e.ID_KOTA=d.KOTA_ID','left');
$this->db->where('a.STATUS_PEMINJAMAN is NULL AND a.JENIS_PEMINJAMAN=', $level);
$this->db->or_where('a.STATUS_PEMINJAMAN=0 AND a.JENIS_PEMINJAMAN=', $level);
return $this->db->get()->result_array();
}
public function getKode_Peminjaman($level) { //Persediaan = [69]
$this->db->select('MAX(KODE_PEMINJAMAN) AS KODE');
$this->db->from('peminjaman');
if ($level == 0) {
$this->db->like('KODE_PEMINJAMAN','PIN/PCM', 'after');
} else if ($level == 1) {
$this->db->like('KODE_PEMINJAMAN','PIN/ITP', 'after');
}
return $this->db->get()->result_array();
}
public function getData_Peminjaman_Null($id) { //Persediaan = [72, 74, 76]
$this->db->select('*');
$this->db->from('peminjaman');
$this->db->where(['ID_PEMINJAMAN' => $id]);
$this->db->where('STATUS_PEMINJAMAN is NULL');
return $this->db->get()->result_array();
}
public function getData_DaftarPinjam_byPEMINJAMAN($id) { //Persediaan = [72, 73, 74, 76, 77, 78]
$this->db->select('*');
$this->db->from('daftar_pinjam a');
$this->db->join('peminjaman b','b.ID_PEMINJAMAN=a.PEMINJAMAN_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.PEMINJAMAN_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Peminjaman_byID($id) { //Persediaan = [73, 77]
$this->db->select('*');
$this->db->from('peminjaman a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.PEMINJAM_ID','left');
$this->db->join('pelanggan c','c.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->where(['a.ID_PEMINJAMAN' => $id]);
return $this->db->get()->result_array();
}
public function getQtyReal_DaftarPinjam($id) { //Persediaan = [73, 76, 79, 82, 83]
$this->db->select('a.ID_SNP');
$this->db->from('sn_pinjam a');
$this->db->join('daftar_pinjam b','b.ID_DFP=a.DFP_ID');
$this->db->group_by('a.ID_SNP');
$this->db->where(['a.DFP_ID' => $id]);
return $this->db->count_all_results();
}
public function getData_DaftarPinjam_byID($id) { //Persediaan = [75, 79, 82, 83]
$this->db->select('*');
$this->db->from('daftar_pinjam a');
$this->db->join('peminjaman b','b.ID_PEMINJAMAN=a.PEMINJAMAN_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.ID_DFP' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnPinjam_byDFP($id) { //Persediaan = [75, 76, 77, 78, 80, 81]
$this->db->select('*');
$this->db->from('sn_pinjam a');
$this->db->join('daftar_pinjam b','b.ID_DFP=a.DFP_ID');
$this->db->where(['a.DFP_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_6($id) { //Persediaan = [76]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=6');
return $this->db->get()->result_array();
}
public function getData_Peminjaman_0($id) { //Persediaan = [78]
$this->db->select('*');
$this->db->from('peminjaman');
$this->db->where(['ID_PEMINJAMAN' => $id]);
$this->db->where('STATUS_PEMINJAMAN=0');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_5($id) { //Persediaan = [78]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=5');
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_7($id) { //Persediaan = [78]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=7');
return $this->db->get()->result_array();
}
public function getData_SnStock_SnPinjam_byNAMA_AllStatus($id) { //Persediaan = [82]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('sn_pinjam b','b.NAMA_SNP=a.NAMA_SNSTOCK','left');
$this->db->where(['a.NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnPinjam_SnStock_byNAMA_15($id) { //Persediaan = [82]
$this->db->select('*');
$this->db->from('sn_pinjam a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNP','left');
$this->db->where(['a.NAMA_SNP' => $id]);
$this->db->where('b.STATUS_SNSTOCK=15');
return $this->db->get()->result_array();
}
public function getData_SnPinjam_byID($id) { //Persediaan = [83]
$this->db->select('*');
$this->db->from('sn_pinjam a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNP');
$this->db->where(['a.ID_SNP' => $id]);
return $this->db->get()->result_array();
}
public function getData_Pending_Null($id = null, $level = null) { //Persediaan = [84, 87]
if ($id === null) {
$this->db->select('*,DATE_FORMAT(a.TGL_PENDING,"%d/%m/%Y") as TANGGAL');
$this->db->from('pending a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID','left');
$this->db->join('kuantiti c','c.ID_KUANTITI=b.ID_BARANG','left');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.SALES_ID','left');
$this->db->join('pelanggan e','e.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota f','f.ID_KOTA=e.KOTA_ID','left');
$this->db->join('jenis g','g.ID_JENIS=b.JENIS_ID','left');
$this->db->where('a.STATUS_PENDING is NULL');
$this->db->where('a.JENIS_PENDING=', $level);
}else{
$this->db->select('*');
$this->db->from('pending');
$this->db->where(['ID_PENDING' => $id]);
$this->db->where('STATUS_PENDING is NULL');
}
return $this->db->get()->result_array();
}
public function getData_Pending_0($id = null, $level = null) { //Persediaan = [84, 87]
if ($id === null) {
$this->db->select('*,DATE_FORMAT(a.TGL_PENDING,"%d/%m/%Y") as TANGGAL');
$this->db->from('pending a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID','left');
$this->db->join('kuantiti c','c.ID_KUANTITI=b.ID_BARANG','left');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.SALES_ID','left');
$this->db->join('pelanggan e','e.ID_PELANGGAN=a.PELANGGAN_ID','left');
$this->db->join('kota f','f.ID_KOTA=e.KOTA_ID','left');
$this->db->join('jenis g','g.ID_JENIS=b.JENIS_ID','left');
$this->db->where('a.STATUS_PENDING=0');
$this->db->where('a.JENIS_PENDING=', $level);
}else{
$this->db->select('*');
$this->db->from('pending');
$this->db->where(['ID_PENDING' => $id]);
$this->db->where('STATUS_PENDING=0');
}
return $this->db->get()->result_array();
}
public function getKode_Pending() { //Persediaan = [85]
$this->db->select('MAX(KODE_PENDING) AS KODE');
$this->db->from('pending');
return $this->db->get()->result_array();
}
public function addTempoDay($date,$day) { //Persediaan = [86]
$sum = strtotime(date("Y-m-d", strtotime("$date")) . " +$day days");
$dateTo=date('Y-m-d',$sum);
return $dateTo;
}
public function getData_Proyek_forSales_Null($id) { //Persediaan = [88]
$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->join('kota c','c.ID_KOTA=b.KOTA_ID');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.SALES_ID');
$this->db->where('a.STATUS_PROYEK is NULL');
$this->db->where(['a.SALES_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Proyek_Null($id=null) { //Persediaan = [88, 94, 95, 96, 97]
if ($id==null) {
$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->join('kota c','c.ID_KOTA=b.KOTA_ID');
$this->db->join('karyawan d','d.ID_KARYAWAN=a.SALES_ID');
$this->db->where('a.STATUS_PROYEK is NULL');
} else {
$this->db->select('*');
$this->db->from('proyek 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.SALES_ID');
$this->db->where('a.STATUS_PROYEK is NULL');
$this->db->where(['a.ID_PROYEK' => $id]);
}
return $this->db->get()->result_array();
}
public function getKode_Proyek() { //Persediaan = [89]
$this->db->select('MAX(KODE_PROYEK) AS KODE');
$this->db->from('proyek');
return $this->db->get()->result_array();
}
public function getData_Proyek_byPO($id) { //Persediaan = [90, 91]
$this->db->select('*');
$this->db->from('proyek');
$this->db->where('PO_PROYEK=', $id);
return $this->db->get()->result_array();
}
public function getData_Proyek_byID($id) { //Persediaan = [91, 92, 93]
$this->db->select('*');
$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_DaftarProyek_byPROYEK($id) { //Persediaan = [92, 93, 97]
$this->db->select('*');
$this->db->from('daftar_proyek a');
$this->db->join('proyek b','b.ID_PROYEK=a.PROYEK_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.PROYEK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SlipManual_byProyek_forCheck($id) { //Persediaan = [92]
$this->db->select('*');
$this->db->from('slip_manual');
$this->db->where(['PROYEK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_TransaksiStock_byPROYEK($id) { //Persediaan = [92]
$this->db->select('*');
$this->db->from('transaksi_stock');
$this->db->where(['PROYEK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_HppProyek_byPROYEK($id) { //Persediaan = [93]
$this->db->select('*,FORMAT(a.HARGA_HPR,2) as HARGA,DATE_FORMAT(a.TGL_HPR,"%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('daftar_kasbank c','c.ID_DKB=a.DKB_ID');
$this->db->where(['a.PROYEK_ID' => $id]);
$this->db->order_by('a.ID_HPR DESC');
return $this->db->get()->result_array();
}
public function getSum_HppProyek_byPROYEK($id) { //Persediaan = [93]
$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->where(['a.PROYEK_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Kuantiti_Pcm_All() { //Persediaan = [93]
$this->db->select('*');
$this->db->from('kuantiti a');
$this->db->join('barang b','b.ID_BARANG=a.ID_KUANTITI');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->where('a.PCM_KUANTITI!=0');
$this->db->where('c.TYPE_JENIS!=2');
$this->db->order_by('c.NAMA_JENIS ASC, a.PCM_KUANTITI DESC');
return $this->db->get()->result_array();
}
public function getData_SalesOrder_forProyek() { //Persediaan = [93]
$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('kota c','c.ID_KOTA=b.KOTA_ID');
$this->db->where('a.STATUS_SO=0');
$this->db->order_by('a.ID_SO DESC');
return $this->db->get()->result_array();
}
public function getData_HistoriKuantiti_byBARANG_MasukLebih0($id) { //Persediaan = [93]
$this->db->select('*,DATE_FORMAT(a.TGL_HQ,"%d/%m/%Y") as TANGGAL');
$this->db->from('histori_kuantiti 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->order_by('a.ID_HQ ASC');
$this->db->where(['a.BARANG_ID' => $id]);
$this->db->where('a.MASUK_HQ>0');
return $this->db->get()->result_array();
}
public function getSum_HistoriKuantiti_byBARANG_byHQ($id_barang, $id_hq) { //Persediaan = [93]
$this->db->select('SUM(a.MASUK_HQ-a.KELUAR_HQ) as TOTAL, SUM(a.KELUAR_HQ) as KELUAR');
$this->db->from('histori_kuantiti 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.BARANG_ID' => $id_barang]);
$this->db->where('a.ID_HQ<=', $id_hq);
return $this->db->get()->result_array();
}
public function getData_HistoriKuantiti_limitHQ($id_barang, $id_hq) { //Persediaan = [93]
$this->db->select('*,DATE_FORMAT(a.TGL_HQ,"%d/%m/%Y") as TANGGAL');
$this->db->from('histori_kuantiti 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.BARANG_ID' => $id_barang]);
$this->db->where('a.ID_HQ<', $id_hq);
$this->db->where('a.MASUK_HQ>0');
$this->db->order_by('a.ID_HQ DESC');
$this->db->limit('1');
return $this->db->get()->result_array();
}
public function getSum_HistoriKuantiti_byBARANG_byHQ1_byHQ2($id_barang, $id_hq1, $id_hq2) { //Persediaan = [93]
$this->db->select('SUM(a.KELUAR_HQ) as KELUAR');
$this->db->from('histori_kuantiti 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.BARANG_ID' => $id_barang]);
$this->db->where('a.ID_HQ<=', $id_hq1);
$this->db->where('a.ID_HQ>=', $id_hq2);
return $this->db->get()->result_array();
}
public function getCount_SnProyek_byDPR($id){ //Persediaan = [98]
$this->db->select('ID_SNPR');
$this->db->from('sn_proyek');
$this->db->where('DPR_ID=', $id);
return $this->db->count_all_results();
}
public function getData_DaftarProyek_byBARANG($id1, $id2) { //Persediaan = [94]
$this->db->select('*');
$this->db->from('daftar_proyek a');
$this->db->join('proyek b','b.ID_PROYEK=a.PROYEK_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.BARANG_ID' => $id1]);
$this->db->where(['a.PROYEK_ID' => $id2]);
return $this->db->get()->result_array();
}
public function getData_DaftarProyek_byID($id) { //Persediaan = [95, 96]
$this->db->select('*');
$this->db->from('daftar_proyek a');
$this->db->join('proyek b','b.ID_PROYEK=a.PROYEK_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.ID_DPR' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarService_byKARYAWAN_Null($id) { //Persediaan = [98]
$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL');
$this->db->from('daftar_service a');
$this->db->join('service b','b.ID_SERVICE=a.SERVICE_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=b.PEMBUAT_ID');
$this->db->join('barang d','d.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis e','e.ID_JENIS=d.JENIS_ID');
$this->db->where('b.STATUS_SERVICE is NULL');
$this->db->where('b.PEMBUAT_ID=', $id);
return $this->db->get()->result_array();
}
public function getCount_Service_byKARYAWAN_0($id){ //Persediaan = [98]
$this->db->select('ID_SERVICE');
$this->db->from('service');
$this->db->where('STATUS_SERVICE=0');
$this->db->where('PEMBUAT_ID=', $id);
return $this->db->count_all_results();
}
public function getData_Service_byKARYAWAN_Null($id) { //Persediaan = [100]
$this->db->select('*');
$this->db->from('service');
$this->db->where('STATUS_SERVICE is NULL');
$this->db->where('PEMBUAT_ID=', $id);
return $this->db->get()->result_array();
}
public function getID_ServiceMax() { //Persediaan = [100]
$this->db->select_max('ID_SERVICE');
$this->db->from('service');
return $this->db->get()->result_array();
}
public function getKode_Service() { //Persediaan = [99]
$this->db->select('MAX(KODE_SERVICE) AS KODE');
$this->db->from('service');
$this->db->like('KODE_SERVICE','SRV', 'after');
return $this->db->get()->result_array();
}
public function getData_Service_Null($id=null) { //Persediaan = [103, 108]
if ($id==null) {
$this->db->select('*,b.NAMA_KARYAWAN as GUDANG,c.NAMA_KARYAWAN as PENERIMA');
$this->db->from('service a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.GUDANG_ID_1');
$this->db->join('karyawan c','c.ID_KARYAWAN=a.PENERIMA_ID');
$this->db->where('a.STATUS_SERVICE is NULL');
} else {
$this->db->select('*');
$this->db->from('service');
$this->db->where(['ID_SERVICE' => $id]);
$this->db->where('STATUS_SERVICE is NULL');
}
return $this->db->get()->result_array();
}
public function getData_DaftarService_bySERVICE($id) { //Persediaan = [100, 101, 108]
$this->db->select('*');
$this->db->from('daftar_service a');
$this->db->join('service b','b.ID_SERVICE=a.SERVICE_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.SERVICE_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_Barang_byID($id) { //Persediaan = [100, 135]
$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]);
return $this->db->get()->result_array();
}
public function getData_SnService_bySERVICE($id) { //Persediaan = [98]
$this->db->select('*,DATE_FORMAT(a.TGL_SNS,"%d/%m/%Y") as TANGGAL');
$this->db->from('sn_service a');
$this->db->join('daftar_service b','b.ID_DFS=a.DFS_ID');
$this->db->join('barang c','c.ID_BARANG=b.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->join('service e','e.ID_SERVICE=a.SERVICE_ID');
$this->db->where(['b.SERVICE_ID' => $id]);
return $this->db->get()->result_array();
}
public function getQtyReal_DaftarService($id) { //Persediaan = [108, 109, 112, 113]
$this->db->select('a.ID_SNS');
$this->db->from('sn_service a');
$this->db->join('daftar_service b','b.ID_DFS=a.DFS_ID');
$this->db->group_by('a.ID_SNS');
$this->db->where(['a.DFS_ID' => $id]);
return $this->db->count_all_results();
}
public function getData_DaftarService_byID($id) { //Persediaan = [101, 109, 112, 113]
$this->db->select('*');
$this->db->from('daftar_service a');
$this->db->join('service b','b.ID_SERVICE=a.SERVICE_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.ID_DFS' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnService_byDFS($id) { //Persediaan = [101, 108, 110, 111]
$this->db->select('*');
$this->db->from('sn_service a');
$this->db->join('daftar_service b','b.ID_DFS=a.DFS_ID');
$this->db->where(['a.DFS_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnService_byID($id) { //Persediaan = [102, 103, 113, 129]
$this->db->select('*');
$this->db->from('sn_service a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNS');
$this->db->where(['a.ID_SNS' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_17($id) { //Persediaan = [103]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=17');
return $this->db->get()->result_array();
}
public function getData_SnStock_SnService_byNAMA_AllStatus($id) { //Persediaan = [112]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('sn_service b','b.NAMA_SNS=a.NAMA_SNSTOCK','left');
$this->db->where(['a.NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnService_SnStock_byNAMA_17($id) { //Persediaan = [112]
$this->db->select('*');
$this->db->from('sn_service a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNS','left');
$this->db->where(['a.NAMA_SNS' => $id]);
$this->db->where('b.STATUS_SNSTOCK=17');
return $this->db->get()->result_array();
}
public function getData_DaftarMutasiBarang_byKARYAWAN_Null($id) { //Persediaan = [114]
$this->db->select('*,DATE_FORMAT(b.TGL_MB,"%d/%m/%Y") as TANGGAL');
$this->db->from('daftar_mutasibarang a');
$this->db->join('mutasi_barang b','b.ID_MB=a.MB_ID');
$this->db->join('karyawan c','c.ID_KARYAWAN=b.ADMIN_ID');
$this->db->join('barang d','d.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis e','e.ID_JENIS=d.JENIS_ID');
$this->db->where('b.STATUS_MB is NULL');
$this->db->where('b.ADMIN_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_MutasiBarang_0_byJENIS($id) { //Persediaan = [114]
$this->db->select('*,DATE_FORMAT(a.TGL_MB,"%d/%m/%Y") as TANGGAL');
$this->db->from('mutasi_barang a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.ADMIN_ID');
$this->db->where(['a.JENIS_MB' => $id]);
$this->db->where('a.STATUS_MB=0');
return $this->db->get()->result_array();
}
public function getQtyReal_DaftarMutasiBarang($id) { //Persediaan = [114, 118, 119, 122, 123]
$this->db->select('a.ID_SNMB');
$this->db->from('sn_mutasibarang a');
$this->db->join('daftar_mutasibarang b','b.ID_DMB=a.DMB_ID');
$this->db->group_by('a.ID_SNMB');
$this->db->where(['a.DMB_ID' => $id]);
return $this->db->count_all_results();
}
public function getKode_MutasiBarang($level) { //Persediaan = [115]
$this->db->select('MAX(KODE_MB) AS KODE');
$this->db->from('mutasi_barang');
if ($level == 0) {
$this->db->like('KODE_MB','MB/PCM', 'after');
} else if ($level == 1) {
$this->db->like('KODE_MB','MB/ITP', 'after');
}
return $this->db->get()->result_array();
}
public function getData_MutasiBarang_byKARYAWAN_Null($id) { //Persediaan = [116]
$this->db->select('*');
$this->db->from('mutasi_barang');
$this->db->where('STATUS_MB is NULL');
$this->db->where('ADMIN_ID=', $id);
return $this->db->get()->result_array();
}
public function getID_MutasiBarangMax() { //Persediaan = [116]
$this->db->select_max('ID_MB');
$this->db->from('mutasi_barang');
return $this->db->get()->result_array();
}
public function getData_DaftarMutasiBarang_byMB($id) { //Persediaan = [116, 117, 118, 124, 125, 126]
$this->db->select('*');
$this->db->from('daftar_mutasibarang a');
$this->db->join('mutasi_barang b','b.ID_MB=a.MB_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.MB_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarMutasiBarang_byID($id) { //Persediaan = [117, 119, 122, 123]
$this->db->select('*');
$this->db->from('daftar_mutasibarang a');
$this->db->join('mutasi_barang b','b.ID_MB=a.MB_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where(['a.ID_DMB' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnMutasiBarang_byDMB($id) { //Persediaan = [117, 118, 120, 121, 124, 125, 126]
$this->db->select('*');
$this->db->from('sn_mutasibarang a');
$this->db->join('daftar_mutasibarang b','b.ID_DMB=a.DMB_ID');
$this->db->where(['a.DMB_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_MutasiBarang_Null($id) { //Persediaan = [118]
$this->db->select('*');
$this->db->from('mutasi_barang');
$this->db->where(['ID_MB' => $id]);
$this->db->where('STATUS_MB is NULL');
return $this->db->get()->result_array();
}
public function getData_SnMutasiBarang_SnStock_byNAMA_17($id) { //Persediaan = [118, 122]
$this->db->select('*');
$this->db->from('sn_mutasibarang a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNMB','left');
$this->db->where(['a.NAMA_SNMB' => $id]);
$this->db->where('b.STATUS_SNSTOCK=17');
return $this->db->get()->result_array();
}
public function getData_SnStock_SnMutasiBarang_byNAMA_AllStatus($id) { //Persediaan = [122, 125]
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('sn_mutasibarang b','b.NAMA_SNMB=a.NAMA_SNSTOCK','left');
$this->db->where(['a.NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnMutasiBarang_byID($id) { //Persediaan = [123]
$this->db->select('*');
$this->db->from('sn_mutasibarang a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNMB');
$this->db->where(['a.ID_SNMB' => $id]);
return $this->db->get()->result_array();
}
public function getData_MutasiBarang_byID($id) { //Persediaan = [124, 125, 126]
$this->db->select('*,DATE_FORMAT(a.TGL_MB,"%d/%m/%Y") as TANGGAL');
$this->db->from('mutasi_barang a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.ADMIN_ID');
$this->db->where(['a.ID_MB' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_18($id) { //Persediaan = [125]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=18');
return $this->db->get()->result_array();
}
public function getID_TransaksiStockMax() { //Persediaan = [Terbaru]
$this->db->select_max('ID_IO');
$this->db->from('transaksi_stock');
return $this->db->get()->result_array();
}
public function getData_SnProyek_byDPR($id) { //Persediaan = [93]
$this->db->select('*');
$this->db->from('sn_proyek a');
$this->db->join('daftar_proyek b','b.ID_DPR=a.DPR_ID');
$this->db->join('barang c','c.ID_BARANG=b.BARANG_ID');
$this->db->where(['a.DPR_ID' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_19($id) { //RekapGp = [12]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=19');
return $this->db->get()->result_array();
}
public function getData_SnStock_SnProyek_byNAMA_AllStatus($id) { //Persediaan = []
$this->db->select('*');
$this->db->from('sn_stock a');
$this->db->join('sn_proyek b','b.NAMA_SNPR=a.NAMA_SNSTOCK','left');
$this->db->where(['a.NAMA_SNSTOCK' => $id]);
return $this->db->get()->result_array();
}
public function getData_SnProyek_SnStock_byNAMA_19($id) { //Persediaan = []
$this->db->select('*');
$this->db->from('sn_proyek a');
$this->db->join('sn_stock b','b.NAMA_SNSTOCK=a.NAMA_SNPR','left');
$this->db->where(['a.NAMA_SNPR' => $id]);
$this->db->where('b.STATUS_SNSTOCK=19');
return $this->db->get()->result_array();
}
public function getData_SnProyek_byID($id) { //Persediaan = []
$this->db->select('*');
$this->db->from('sn_proyek');
$this->db->where(['ID_SNPR' => $id]);
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanService_statusNull_byKARYAWAN($id) { // Persediaan [127]
$this->db->select('*,DATE_FORMAT(b.TGL_PSV,"%d/%m/%Y") as TANGGAL');
$this->db->from('daftar_penarikanservice a');
$this->db->join('penarikan_service b', 'b.ID_PSV=a.PSV_ID');
$this->db->join('karyawan c', 'c.ID_KARYAWAN=b.PENGAMBIL_ID');
$this->db->join('barang d', 'd.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis e', 'e.ID_JENIS=d.JENIS_ID');
$this->db->where('b.STATUS_PSV is NULL');
$this->db->where('b.PENGAMBIL_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_SnService_SnsStatus2_SnstockStatus7_psvNull($level) { // Persediaan [127]
$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL');
$this->db->from('sn_service a');
$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
$this->db->join('daftar_service c', 'c.ID_DFS=a.DFS_ID');
$this->db->join('barang d', 'd.ID_BARANG=c.BARANG_ID');
$this->db->join('sn_stock e', 'e.NAMA_SNSTOCK=a.NAMA_SNS');
$this->db->where('a.STATUS_SNS=2');
$this->db->where('a.PSV_ID is NULL');
$this->db->where('e.STATUS_SNSTOCK=7');
if ($level==0) {
$this->db->where('e.GUDANG_SNSTOCK=1');
} else if ($level==1) {
$this->db->where('e.GUDANG_SNSTOCK=2');
}
$this->db->order_by('d.KODE_BARANG ASC, a.NAMA_SNS ASC');
return $this->db->get()->result_array();
}
public function getData_NonSnService_groupBARANG() { // Persediaan [127, 134]
$this->db->select('*,SUM(a.MASUK_NONSNS-a.KELUAR_NONSNS) as TOTAL');
$this->db->from('nonsn_service a');
$this->db->join('barang b','b.ID_BARANG=a.BARANG_ID');
$this->db->group_by('a.BARANG_ID');
$this->db->order_by('TOTAL DESC,b.KODE_BARANG ASC');
return $this->db->get()->result_array();
}
public function getData_SnService_byPSV_byBARANG($id1, $id2) { // Persediaan [127, 129, 132, 133]
$this->db->select('*');
$this->db->from('sn_service a');
$this->db->join('daftar_service b','b.ID_DFS=a.DFS_ID');
$this->db->where('a.PSV_ID=', $id1);
$this->db->where('b.BARANG_ID=', $id2);
return $this->db->get()->result_array();
}
public function getKode_PenarikanService() { //Persediaan = [128]
$this->db->select('MAX(KODE_PSV) AS KODE');
$this->db->from('penarikan_service');
$this->db->like('KODE_PSV','PSV', 'after');
return $this->db->get()->result_array();
}
public function getData_PenarikanService_byKARYAWAN_statusNull($id) { // Persediaan [129, 130, 133]
$this->db->select('*');
$this->db->from('penarikan_service');
$this->db->where('PENGAMBIL_ID=', $id);
$this->db->where('STATUS_PSV is NULL');
return $this->db->get()->result_array();
}
public function getID_PenarikanServiceMax() { // Persediaan [129, 130]
$this->db->select_max('ID_PSV');
$this->db->from('penarikan_service');
return $this->db->get()->result_array();
}
public function getData_SnService_byPSV_groupBARANG($id) { // Persediaan [129]
$this->db->select('*');
$this->db->from('sn_service a');
$this->db->join('daftar_service b','b.ID_DFS=a.DFS_ID');
$this->db->where('a.PSV_ID=', $id);
$this->db->group_by('b.BARANG_ID');
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanService_byPSV_byBARANG($id1, $id2) { // Persediaan [129, 130]
$this->db->select('*');
$this->db->from('daftar_penarikanservice');
$this->db->where('PSV_ID=', $id1);
$this->db->where('BARANG_ID=', $id2);
return $this->db->get()->result_array();
}
public function getSum_NonSnService_byBARANG($id) { // Persediaan [130, 131, 133]
$this->db->select('SUM(MASUK_NONSNS-KELUAR_NONSNS) as TOTAL');
$this->db->from('nonsn_service');
$this->db->where('BARANG_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanService_byID($id) { // Persediaan [131, 132]
$this->db->select('*');
$this->db->from('daftar_penarikanservice a');
$this->db->join('penarikan_service b','b.ID_PSV=a.PSV_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where('a.ID_DPSV=', $id);
return $this->db->get()->result_array();
}
public function getData_DaftarPenarikanService_byPSV($id) { // Persediaan [133]
$this->db->select('*');
$this->db->from('daftar_penarikanservice a');
$this->db->join('penarikan_service b','b.ID_PSV=a.PSV_ID');
$this->db->join('barang c','c.ID_BARANG=a.BARANG_ID');
$this->db->join('jenis d','d.ID_JENIS=c.JENIS_ID');
$this->db->where('a.PSV_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_SnStock_byNAMA_9($id) { //Persediaan = [133]
$this->db->select('ID_SNSTOCK');
$this->db->from('sn_stock');
$this->db->where(['NAMA_SNSTOCK' => $id]);
$this->db->where('STATUS_SNSTOCK=9');
return $this->db->get()->result_array();
}
public function getData_SnService_allStatus_InternalOnly() { // Persediaan [134]
$this->db->select('*,DATE_FORMAT(b.TGL_SERVICE,"%d/%m/%Y") as TANGGAL,DATE_FORMAT(a.TGL_SNS,"%d/%m/%Y") as TANGGALAMBIL,
f.NAMA_PANGGILAN_KARYAWAN as PEMBUAT,j.NAMA_PANGGILAN_KARYAWAN as PENGAMBIL');
$this->db->from('sn_service a');
$this->db->join('service b', 'b.ID_SERVICE=a.SERVICE_ID');
$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('unitservice e', 'e.ID_UNITSERVICE=a.UNITSERVICE_ID','left');
$this->db->join('karyawan f', 'f.ID_KARYAWAN=b.PEMBUAT_ID','left');
$this->db->join('daftar_service g', 'g.ID_DFS=a.DFS_ID','left');
$this->db->join('barang h', 'h.ID_BARANG=g.BARANG_ID','left');
$this->db->join('penarikan_service i', 'i.ID_PSV=a.PSV_ID','left');
$this->db->join('karyawan j', 'j.ID_KARYAWAN=i.PENGAMBIL_ID','left');
$this->db->where('b.PELANGGAN_ID is NULL');
return $this->db->get()->result_array();
}
public function getData_NonSnService_byBARANG($id) { // Persediaan [135]
$this->db->select('*,DATE_FORMAT(a.TGL_NONSNS,"%d/%m/%Y") as TANGGAL');
$this->db->from('nonsn_service a');
$this->db->join('karyawan b','b.ID_KARYAWAN=a.PENERIMA_ID');
$this->db->where('a.BARANG_ID=', $id);
return $this->db->get()->result_array();
}
public function getData_Jenis_Not2($id = null) { // Persediaan = [136]
if ($id === null) {
$this->db->select('*');
$this->db->from('jenis');
$this->db->where('TYPE_JENIS!=2');
$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_StokKuantiti($all, $jenis_gudang = null, $id_jenis = null){ // Persediaan = [136]
if ($jenis_gudang == null AND $all == "0") {
$this->db->select('*');
$this->db->from('kuantiti a');
$this->db->join('barang b','b.ID_BARANG=a.ID_KUANTITI');
$this->db->order_by('b.KODE_BARANG ASC');
$this->db->where('a.ID_KUANTITI is NULL');
$this->db->where('a.GLOBAL_KUANTITI>0');
} else if ($all == 1) {
$this->db->select('*');
$this->db->from('kuantiti a');
$this->db->join('barang b','b.ID_BARANG=a.ID_KUANTITI');
$this->db->order_by('b.KODE_BARANG ASC');
$this->db->where('a.GLOBAL_KUANTITI>0');
} else {
if ($jenis_gudang=="1") {
$this->db->select('a.GLOBAL_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.GLOBAL_KUANTITI>0');
} else if ($jenis_gudang=="2") {
$this->db->select('a.PCM_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.PCM_KUANTITI>0');
} else if ($jenis_gudang=="3") {
$this->db->select('a.KONSINYASI_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.KONSINYASI_KUANTITI>0');
} else if ($jenis_gudang=="4") {
$this->db->select('a.PEMINJAMAN_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.PEMINJAMAN_KUANTITI>0');
} else if ($jenis_gudang=="5") {
$this->db->select('a.PENDING_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.PENDING_KUANTITI>0');
} else if ($jenis_gudang=="6") {
$this->db->select('a.ANTIK_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.ANTIK_KUANTITI>0');
} else if ($jenis_gudang=="7") {
$this->db->select('a.PROYEK_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.PROYEK_KUANTITI>0');
} else if ($jenis_gudang=="8") {
$this->db->select('a.SERVICE_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.SERVICE_KUANTITI>0');
} else if ($jenis_gudang=="9") {
$this->db->select('a.ITP_KUANTITI as QTY,CONCAT("Rp ",FORMAT(a.HARGA_AVG,2)) as AVG,b.*,c.NAMA_JENIS');
$this->db->where('a.ITP_KUANTITI>0');
}
$this->db->from('kuantiti a');
$this->db->join('barang b','b.ID_BARANG=a.ID_KUANTITI');
$this->db->join('jenis c','c.ID_JENIS=b.JENIS_ID');
$this->db->order_by('c.NAMA_JENIS ASC, b.KODE_BARANG ASC');
if ($id_jenis!=NULL) {
$this->db->where('b.JENIS_ID=', $id_jenis);
}
}
return $this->db->get()->result_array();
}
}
?>
Reference in New Issue View Git Blame Copy Permalink