var table; $(document).ready(function() { ajaxcsrf(); table = $("#users").DataTable({ initComplete: function() { var api = this.api(); $("#users_filter input") .off(".DT") .on("keyup.DT", function(e) { api.search(this.value).draw(); }); }, dom: "<'row'<'col-sm-3'l><'col-sm-6 text-center'B><'col-sm-3'f>>" + "<'row'<'col-sm-12'tr>>" + "<'row'<'col-sm-5'i><'col-sm-7'p>>", buttons: [ { extend: "copy", exportOptions: { columns: [1, 2, 3, 4, 5, 6, 7] } }, { extend: "print", exportOptions: { columns: [1, 2, 3, 4, 5, 6, 7] } }, { extend: "excel", exportOptions: { columns: [1, 2, 3, 4, 5, 6, 7] } }, { extend: "pdf", exportOptions: { columns: [1, 2, 3, 4, 5, 6, 7] } } ], oLanguage: { sProcessing: "loading..." }, processing: true, serverSide: true, ajax: { url: base_url + "users/data/" + user_id, type: "POST" }, columns: [ { data: "id", orderable: false, searchable: false }, { data: "first_name" }, { data: "last_name" }, { data: "username" }, { data: "email" }, { data: "level" }, { data: "created_on" } ], columnDefs: [ { targets: 5, data: "level", render: function(data, type, row, meta) { return `
${data}
`; } }, { targets: 7, orderable: false, searchable: false, title: "Status", data: "active", render: function(data, type, row, meta) { if (data === "1") { return `
Active
`; } else { return `
Not Active
`; } } }, { targets: 8, data: "id", render: function(data, type, row, meta) { if (data === user_id) { return `
`; } else { return `
`; } } } ], order: [[1, "asc"]], rowId: function(a) { return a; }, rowCallback: function(row, data, iDisplayIndex) { var info = this.fnPagingInfo(); var page = info.iPage; var length = info.iLength; var index = page * length + (iDisplayIndex + 1); $("td:eq(0)", row).html(index); } }); table .buttons() .container() .appendTo("#users_wrapper .col-md-6:eq(0)"); $("#show_me").on("change", function() { let src = base_url + "users/data"; let url = $(this).prop("checked") === true ? src : src + "/" + user_id; table.ajax.url(url).load(); }); }); function hapus(id) { Swal({ title: "Anda yakin?", text: "Data akan dihapus.", type: "question", showCancelButton: true, confirmButtonColor: "#3085d6", cancelButtonColor: "#d33", confirmButtonText: "Hapus!" }).then(result => { if (result.value) { $.getJSON(base_url + "users/delete/" + id, function(data) { Swal({ title: data.status ? "Berhasil" : "Gagal", text: data.status ? "User berhasil dihapus" : "User gagal dihapus", type: data.status ? "success" : "error" }); reload_ajax(); }); } }); }