|
Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/laciasmara.com/public_html/shop/application/models/ |
Upload File : |
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class Transfer_stock_detail_m extends MY_Model
{
protected $_table_name = 'transfer_stock_detail';
protected $_primary_key = 'id_transfer_stock_detail';
protected $_order_by = 'id_transfer_stock_detail';
function __construct()
{
parent::__construct();
}
public function get_transfer_stock_detail_data()
{
// Ambil data transfer_stock_detail dan urutkan berdasarkan id_transfer_stock_detail secara descending
$this->db->from('transfer_stock_detail');
$this->db->where_not_in('warehouse_id', [3, 7, 8, 9]);
$this->db->where_not_in('warehouse_id_target', [3, 7, 8, 9]);
$this->db->order_by('id_transfer_stock_detail', 'DESC');
$query = $this->db->get();
return $query->result();
}
function get_transfer_stock_detail($id_transfer_stock)
{
$this->db->select('*');
$this->db->from('transfer_stock_detail');
$this->db->where('id_transfer_stock', $id_transfer_stock);
$this->db->order_by('id_transfer_stock_detail', 'asc');
$query = $this->db->get();
return $query->result();
}
public function get_transfer_stock_detail_1($id)
{
$this->db->where('id_transfer_stock', $id);
$this->db->limit(1);
return $this->db->get('transfer_stock_detail')->row();
}
}