Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function list_join($id_pelanggan)
- {
- //$this->db->select('tbl_pelanggan.*,tbl_order.*,tbl_produksi.status');
- //perbaiki metode select,.. ketik semua field yg akan ditampilkan dan kasi alias
- $this->db->from('tbl_pelanggan')
- ->join('tbl_order', 'tbl_order.id_pelanggan = tbl_pelanggan.id_pelanggan', 'left');
- ->join('tbl_produksi', 'tbl_produksi.id_pelanggan = tbl_pelanggan.id_pelanggan', 'left');
- $this->db->where('tbl_pelanggan.id_pelanggan', $id_pelanggan);
- $a = $this->db->get();
- return $a->result();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement