Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $("#btnExport2Excel").click(function(){
- // ambil value dari form search Datatables
- var filter = $('input[type="search"]').val();
- // Ini nanti digunakan sbg judul laporan di Excel
- var reportTitle = $('#reportTitle').text();
- reportTitle = reportTitle.trim();
- var fieldCaption = [];
- // looping sebanyak kolom di table untuk mengambil caption table header
- $('#tableList > thead > tr').each(function(){
- var $tds = $(this).find('th');
- for (var i = 0; i < $tds.length; i++) {
- fieldCaption.push($tds.eq(i).text());
- }
- });
- // data yang akan dikirimkan ke controller
- var data = {filter:filter, fieldCaption:fieldCaption, title:reportTitle};
- $.ajax({
- type: "POST",
- url: base_url+"export/excel",
- data: data,
- success: function(data){
- // data kembalian dari controller berupa data url yang akan dibuka untuk download file excel
- data = JSON.parse(data);
- window.open(data.file);
- }
- });
- });
Advertisement
Add Comment
Please, Sign In to add comment