CodeIgniter 3 – Membuat Datatables Server Side

11 Comments

1. 

   Suyud

   30 May 2023 at 15:50

   Reply

   mas saya masih bingung pemberian nama file php kok ada 2 yang namanya sama jadi salah satu saya beri nama lain
   mohon pencerahan trims Kera Ngalam

   • 

     mylitenotes Post author

     30 May 2023 at 17:40

     Reply

     yang satu sebagai controller, satu lagi sebagai view. Bokeh aja diganti nama filenya, yang penting pemanggilan controller atau view disesuaikan dengan nama filenya

2. 

   Suyud

   30 May 2023 at 15:51

   Reply

   yang barusan komen

3. 

   yuslan

   4 June 2023 at 09:43

   Reply

   di kolom search data, jika ketik sesuatu muncul pesan ini Gan.
   DataTables warning: table id=list_data – Ajax error. For more information about this error, please see http://datatables.net/tn/7

   • 

     mylitenotes Post author

     5 June 2023 at 03:39

     Reply

     Biasanya ada field tabel yang salah pemanggilan. Coba inspect element kemudian lihat pada tab network, nanti dapat di lihat errornya dimana.

     • 

       yuslan

       6 June 2023 at 11:13

       Reply

       iya gan.. load datanya juga sangat lama. apakah harus perbaiki struktur rabelnya kali ya?

     • 

       yuslan

       6 June 2023 at 12:38

       Reply

       ‘asc’);

       private function _get_datatables_query()
       {
       $this->db->select(‘a.id, a.nik, a.nama_perangkat as perangkat, a.tgl_lahir, a.jk, a.pendidikan, a.jabatan, a.sk, a.tgl_diangkat, a.tgl_akhir, a.nomor_hp, a.email, a.agama, b.nama as provinsi, c.nama as kabupaten, d.nama as kecamatan, e.nama as desa’);
       $this->db->from(‘tbl_perangkat_desa as a’);
       $this->db->join(‘wilayah_provinsi as b’, ‘a.provinsi_id = b.id’);
       $this->db->join(‘wilayah_kabupaten as c’, ‘a.kabupaten_id = c.id’);
       $this->db->join(‘wilayah_kecamatan as d’, ‘a.kecamatan_id = d.id’);
       $this->db->join(‘wilayah_desa as e’, ‘a.desa_id = e.id’);

       $i = 0;

       foreach ($this->column_search as $item) {
       if ($_POST[‘search’][‘value’]) {
       if ($i === 0) {
       $this->db->group_start();
       $this->db->like($item, $_POST[‘search’][‘value’]);
       } else {
       $this->db->or_like($item, $_POST[‘search’][‘value’]);
       }

       if (count($this->column_search) – 1 == $i)
       $this->db->group_end();
       }
       $i++;
       }

       if (isset($_POST[‘order’])) {
       $order_column = $this->column_order[$_POST[‘order’][‘0’][‘column’]];
       $order_dir = $_POST[‘order’][‘0’][‘dir’];
       $this->db->order_by($order_column, $order_dir);
       } else {
       $order_column = key($this->order);
       $order_dir = $this->order[key($this->order)];
       $this->db->order_by($order_column, $order_dir);
       }
       }

       function get_datatables()
       {
       $this->_get_datatables_query();
       if ($_POST[“length”] != -1) {
       $this->db->limit($_POST[‘length’], $_POST[‘start’]);
       }
       $query = $this->db->get();
       return $query->result();
       }

       public function count_filtered()
       {
       $this->_get_datatables_query();
       $query = $this->db->get();
       return $query->num_rows();
       }

       public function count_all()
       {
       $this->db->from(‘tbl_perangkat_desa’);
       return $this->db->count_all_results();
       }
       }

       • 

         yuslan

         6 June 2023 at 12:38

         Reply

         ‘asc’);

         • 

           yuslan

           6 June 2023 at 12:39

           var $column_order = array(‘id’, ‘provinsi’, ‘kabupaten’, ‘kecamatan’, ‘desa’, ‘nik’, ‘perangkat’, ‘tgl_lahir’, ‘jk’, ‘pendidikan’, ‘jabatan’, ‘sk’, ‘tgl_diangkat’, ‘tgl_akhir’, ‘nomor_hp’, ’email’, ‘agama’);
           var $column_search = array(‘id’, ‘provinsi’, ‘kabupaten’, ‘kecamatan’, ‘desa’, ‘nik’, ‘perangkat’, ‘tgl_lahir’, ‘jk’, ‘pendidikan’, ‘jabatan’, ‘sk’, ‘tgl_diangkat’, ‘tgl_akhir’, ‘nomor_hp’, ’email’, ‘agama’);
           var $order = array(‘id’ => ‘asc’);

     • 

       yuslan

       6 June 2023 at 12:41

       Reply

       statusnya tertulis pending gan

4. 

   yuslan

   6 June 2023 at 12:36

   Reply

   berikut modelnya gan
   ‘asc’);

   private function _get_datatables_query()
   {
   $this->db->select(‘a.id, a.nik, a.nama_perangkat as perangkat, a.tgl_lahir, a.jk, a.pendidikan, a.jabatan, a.sk, a.tgl_diangkat, a.tgl_akhir, a.nomor_hp, a.email, a.agama, b.nama as provinsi, c.nama as kabupaten, d.nama as kecamatan, e.nama as desa’);
   $this->db->from(‘tbl_perangkat_desa as a’);
   $this->db->join(‘wilayah_provinsi as b’, ‘a.provinsi_id = b.id’);
   $this->db->join(‘wilayah_kabupaten as c’, ‘a.kabupaten_id = c.id’);
   $this->db->join(‘wilayah_kecamatan as d’, ‘a.kecamatan_id = d.id’);
   $this->db->join(‘wilayah_desa as e’, ‘a.desa_id = e.id’);

   $i = 0;

   foreach ($this->column_search as $item) {
   if ($_POST[‘search’][‘value’]) {
   if ($i === 0) {
   $this->db->group_start();
   $this->db->like($item, $_POST[‘search’][‘value’]);
   } else {
   $this->db->or_like($item, $_POST[‘search’][‘value’]);
   }

   if (count($this->column_search) – 1 == $i)
   $this->db->group_end();
   }
   $i++;
   }

   if (isset($_POST[‘order’])) {
   $order_column = $this->column_order[$_POST[‘order’][‘0’][‘column’]];
   $order_dir = $_POST[‘order’][‘0’][‘dir’];
   $this->db->order_by($order_column, $order_dir);
   } else {
   $order_column = key($this->order);
   $order_dir = $this->order[key($this->order)];
   $this->db->order_by($order_column, $order_dir);
   }
   }

   function get_datatables()
   {
   $this->_get_datatables_query();
   if ($_POST[“length”] != -1) {
   $this->db->limit($_POST[‘length’], $_POST[‘start’]);
   }
   $query = $this->db->get();
   return $query->result();
   }

   public function count_filtered()
   {
   $this->_get_datatables_query();
   $query = $this->db->get();
   return $query->num_rows();
   }

   public function count_all()
   {
   $this->db->from(‘tbl_perangkat_desa’);
   return $this->db->count_all_results();
   }
   }

   /* End of file ModelName.php */