mudzlam

controll

Sep 14th, 2013
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.76 KB | None | 0 0
  1. function listData($limit = 10, $offset = 0){
  2.        
  3.         $this->db->select('
  4.         tbl_timeline.id_timeline,
  5.         tbl_timeline.no_polisi,
  6.         driver.nama_driver,
  7.         tbl_partner.name_partner,
  8.         tbl_partner_class.name_location,
  9.         tbl_timeline.tgl_uj,
  10.         tbl_timeline.jml_uj,
  11.         tbl_timeline.tgl_ido,
  12.         tbl_timeline.no_do,
  13.         tbl_timeline.jml_muatan
  14.         ');
  15.         $this->db->from('tbl_timeline');
  16.         $this->db->join('driver', 'tbl_timeline.id_driver = driver.id_driver');
  17.         $this->db->join('tbl_partner_class', 'tbl_timeline.id_class_partner = tbl_partner_class.id_class_partner');
  18.         $this->db->join('tbl_partner', 'tbl_partner.id_partner = tbl_partner_class.id_partner');
  19.         $this->db->order_by('id_timeline','asc');
  20.         return $this->db->get($this->tbl_timeline, $limit, $offset);
  21.  
  22.        
  23.     }
Advertisement
Add Comment
Please, Sign In to add comment