public function ajax_tabel() { if (!$this->input->is_ajax_request()) { exit('No direct script access allowed'); } else { // panggil dulu library datatablesnya $this->load->library('datatables_ssp'); // atur nama tablenya disini $table = 'berita'; // Table's primary key $primaryKey = 'id_berita'; // Array of database columns which should be read and sent back to DataTables. // The `db` parameter represents the column name in the database, while the `dt` // parameter represents the DataTables column identifier. In this case simple // indexes $columns = array(array('db' => 'id_berita', 'dt' => 'DT_RowId'), array('db' => 'judul_berita', 'dt' => 'judul_berita'), array('db' => 'isi_berita', 'dt' => 'isi_berita'), array('db' => 'id_berita', 'dt' => 'id_berita'), array('db' => 'tanggal_berita', 'dt' => 'tanggal_berita', 'formatter' => function ($d) { return $this->DateToIndo($d); }), array('db' => 'gambar', 'dt' => 'gambar', 'formatter' => function ($d) { return '<img width="150px" height="100px" src="' . base_url('assets/images/') . "/" . $d . '">'; }), array('db' => 'status_terbit', 'dt' => 'status_terbit', 'formatter' => function ($d) { if ($d == "y") { return '<small class="label pull-right bg-green">Terbit</small>'; } else { return '<small class="label pull-left bg-red">Tidak Terbit</small><br><a href="' . site_url('admin/berita/trash') . '">view trash</a>'; } }), array('db' => 'id_berita', 'dt' => 'aksi', 'formatter' => function ($d) { return '<a href="' . site_url('admin/berita/editBerita/' . $d) . '">Edit</a> | <a href="' . site_url('admin/berita/hapus_berita/' . $d) . '">Delete</a>'; })); // SQL server connection information $sql_details = array('user' => 'root', 'pass' => '', 'db' => 'jst', 'host' => 'localhost'); echo json_encode(Datatables_ssp::simple($_GET, $sql_details, $table, $primaryKey, $columns)); } }
public function view_ajax() { if (!$this->input->is_ajax_request()) { exit('No direct script access allowed'); } else { //panggil library datatables $this->load->library('datatables_ssp'); //atur nama tablenya disini $table = 'view_outbox_' . $this->uri->segment(3); // Table's primary key $primaryKey = 'id_surat'; $columns = array(array('db' => 'id_surat', 'dt' => 'id_surat'), array('db' => 'created', 'dt' => 'created'), array('db' => 'tgl_masuk', 'dt' => 'tgl_masuk'), array('db' => 'tgl_surat', 'dt' => 'tgl_surat'), array('db' => 'no_surat', 'dt' => 'no_surat'), array('db' => 'perihal', 'dt' => 'perihal'), array('db' => 'tujuan', 'dt' => 'tujuan'), array('db' => 'nama_bagian', 'dt' => 'nama_bagian'), array('db' => 'ptt', 'dt' => 'ptt'), array('db' => 'deleted', 'dt' => 'deleted'), array('db' => 'request', 'dt' => 'request'), array('db' => 'ptt', 'dt' => 'ptt'), array('db' => 'nama_nip', 'dt' => 'nama_nip'), array('db' => 'creator', 'dt' => 'creator'), array('db' => 'user_name', 'dt' => 'user_name'), array('db' => 'pos', 'dt' => 'pos'), array('db' => 'pos', 'dt' => 'pos', 'formatter' => function ($d) { return $d == 1 ? 'pos' : 'langsung'; })); // MySQL connection information $sql_details = array('user' => $this->db->username, 'pass' => $this->db->password, 'db' => $this->db->database, 'host' => $this->db->hostname); echo json_encode(Datatables_ssp::simple($_GET, $sql_details, $table, $primaryKey, $columns)); } }
public function ajax_tabel() { if (!$this->input->is_ajax_request()) { exit('No direct script access allowed'); } else { // panggil dulu library datatablesnya $this->load->library('datatables_ssp'); // atur nama tablenya disini $table = 'berita'; // Table's primary key $primaryKey = 'id_berita'; // Array of database columns which should be read and sent back to DataTables. // The `db` parameter represents the column name in the database, while the `dt` // parameter represents the DataTables column identifier. In this case simple // indexes $columns = array(array('db' => 'id_berita', 'dt' => 'DT_RowId'), array('db' => 'judul_berita', 'dt' => 'judul_berita'), array('db' => 'isi_berita', 'dt' => 'isi_berita'), array('db' => 'tanggal_berita', 'dt' => 'tanggal_berita'), array('db' => 'gambar', 'dt' => 'gambar'), array('db' => 'status_terbit', 'dt' => 'status_terbit'), array('db' => 'id_berita', 'dt' => 'aksi', 'formatter' => function ($d) { return '<a href="' . site_url('kodepos/update/' . $d) . '">Edit</a> | <a href="' . site_url('kodepos/delete/' . $d) . '">Delete</a>'; })); // SQL server connection information $sql_details = array('user' => 'root', 'pass' => '', 'db' => 'jst', 'host' => 'localhost'); echo json_encode(Datatables_ssp::simple($_GET, $sql_details, $table, $primaryKey, $columns)); } }
public function ajax_tabel() { if (!$this->input->is_ajax_request()) { exit('No direct script access allowed'); } else { // panggil dulu library datatablesnya $this->load->library('datatables_ssp'); // atur nama tablenya disini $table = 'staf_pengajar'; // Table's primary key $primaryKey = 'id_staf'; // Array of database columns which should be read and sent back to DataTables. // The `db` parameter represents the column name in the database, while the `dt` // parameter represents the DataTables column identifier. In this case simple // indexes $columns = array(array('db' => 'id_staf', 'dt' => 'DT_RowId'), array('db' => 'nama_lengkap', 'dt' => 'nama_lengkap'), array('db' => 'alamat', 'dt' => 'alamat'), array('db' => 'tanggal_lahir', 'dt' => 'tanggal_lahir'), array('db' => 'bidang', 'dt' => 'bidang'), array('db' => 'deskripsi', 'dt' => 'deskripsi'), array('db' => 'id_staf', 'dt' => 'aksi', 'formatter' => function ($d) { return '<a href="' . site_url('admin/staf/edit_staf/' . $d) . '">Edit</a> | <a href="javascript:void()" onclick="hapus(' . "'" . $d . "'" . ')">Delete</a>'; })); // SQL server connection information $sql_details = array('user' => 'root', 'pass' => '', 'db' => 'jst', 'host' => 'localhost'); echo json_encode(Datatables_ssp::simple($_GET, $sql_details, $table, $primaryKey, $columns)); } }
function view_group_ajax() { $this->load->library('datatables_ssp'); //panggil library datatables $sql_details = array('user' => $this->db->username, 'pass' => $this->db->password, 'db' => $this->db->database, 'host' => $this->db->hostname); $table = 'ion_groups'; $primaryKey = 'id'; $columns = array(array('db' => 'id', 'dt' => 'id'), array('db' => 'name', 'dt' => 'name'), array('db' => 'description', 'dt' => 'description')); echo json_encode(Datatables_ssp::simple($_GET, $sql_details, $table, $primaryKey, $columns)); }