kafyx-3 / laravel-datatables-export
CDN DataTables v2 + tombol Export (Copy, CSV, Excel, PDF, Print) untuk Laravel — tanpa jQuery, satu tag Blade di layout, langsung jalan.
Requires
- php: ^7.3|^8.0
- illuminate/support: ^6.0|^7.0|^8.0|^9.0|^10.0|^11.0|^12.0
Requires (Dev)
None
Suggests
None
Provides
None
Conflicts
None
Replaces
None
README
CDN DataTables v2 + jQuery + tombol Export (Copy, CSV, Excel, PDF, Print) untuk Laravel — satu tag Blade di layout, langsung jalan.
Apa ini?
Package ini membuatmu tidak perlu copy-paste CDN DataTables di setiap halaman. Cukup taruh <x-datatables-export::scripts /> sekali di layout — jQuery, DataTables, JSZip, PDFMake, dan semua plugin Buttons termuat otomatis.
Kamu tetap menulis $('#id').DataTable(...) sendiri, bebas konfigurasi apapun.
Sebelum pakai package ini:
<!-- Di setiap halaman, copy-paste ini semua --> <link rel="stylesheet" href="https://cdn.datatables.net/2.3.4/css/dataTables.dataTables.min.css"> <link rel="stylesheet" href="https://cdn.datatables.net/buttons/3.2.5/css/buttons.dataTables.min.css"> <script src="https://code.jquery.com/jquery-3.7.1.min.js"></script> <script src="https://cdn.datatables.net/2.3.4/js/dataTables.min.js"></script> <script src="https://cdn.datatables.net/buttons/3.2.5/js/dataTables.buttons.min.js"></script> <script src="https://cdn.datatables.net/buttons/3.2.5/js/buttons.html5.min.js"></script> <script src="https://cdn.datatables.net/buttons/3.2.5/js/buttons.print.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/pdfmake.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.2.7/vfs_fonts.js"></script>
Sesudah:
<x-datatables-export::scripts />
Requirement
| Komponen | Versi minimum |
|---|---|
| PHP | 7.3 |
| Laravel | 6.x |
| illuminate/support | ^6.0 |
Instalasi
composer require kafyx-3/laravel-datatables-export
Auto-discovery aktif di Laravel 5.5+. Tidak perlu daftar provider manual.
Via path lokal (development)
Tambahkan ke composer.json project Laravel kamu:
{
"repositories": [
{
"type": "path",
"url": "./packages/kafyx-3/laravel-datatables-export"
}
],
"require": {
"kafyx-3/laravel-datatables-export": "*"
}
}
composer update kafyx-3/laravel-datatables-export
Laravel 5.4 ke bawah — daftarkan manual
// config/app.php 'providers' => [ Kafyx3\DataTablesExport\DataTablesExportServiceProvider::class, ],
Quick Start
1. Di layout, taruh <x-datatables-export::scripts /> di <head> dan tambahkan dua stack sebelum </body>:
{{-- resources/views/layouts/app.blade.php --}} <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>@yield('title', 'App')</title> <x-datatables-export::scripts /> {{-- CSS DataTables termuat di sini --}} </head> <body> @yield('content') @stack('datatables-scripts') {{-- jQuery + DataTables JS muncul di sini --}} @stack('scripts') {{-- script inisialisasi halaman muncul di sini --}} </body> </html>
Penting:
@stack('datatables-scripts')harus ada sebelum@stack('scripts')agar jQuery sudah termuat saat script inisialisasi dijalankan.
2. Di halaman, buat tabel dan tulis script inisialisasi di @push('scripts'):
@extends('layouts.app') @section('content') <table id="tabelKu" class="table table-bordered table-striped"> <thead> <tr> <th>#</th> <th>Nama</th> <th>Email</th> </tr> </thead> <tbody> @foreach ($data as $item) <tr> <td>{{ $loop->iteration }}</td> <td>{{ $item->name }}</td> <td>{{ $item->email }}</td> </tr> @endforeach </tbody> </table> @endsection @push('scripts') <script> $(document).ready(function () { $('#tabelKu').DataTable({ layout: { topStart: { buttons: ['copy', 'csv', 'excel', 'pdf', 'print'] } } }); }); </script> @endpush
Cara Kerja
<x-datatables-export::scripts /> melakukan dua hal:
- CSS — langsung di-render di tempat tag dipasang (cocok di
<head>) - JS — di-push ke
@stack('datatables-scripts')via@pushOnce, tidak double-load walau ada beberapa tabel di satu halaman
Urutan load JS yang dijamin oleh package:
- jQuery 3.7.1
- DataTables core
- JSZip (dependency Excel)
- PDFMake + vfs_fonts (dependency PDF)
- Buttons core
- Buttons HTML5 (CSV, Excel, Copy)
- Buttons Print
<x-datatables-export::table /> hanya render <table> HTML. Tidak ada script inisialisasi yang otomatis diinjeksi. Kamu tulis $('#id').DataTable(...) sendiri di @push('scripts').
Referensi Props
<x-datatables-export::scripts />
Tidak ada props. Taruh sekali di <head> layout.
<x-datatables-export::table />
| Prop | Tipe | Default | Keterangan |
|---|---|---|---|
id |
string |
— (wajib) | ID unik elemen <table>. Harus unik per halaman. |
class |
string |
display |
Class CSS pada <table>. Bisa dikombinasi dengan Bootstrap, dll. |
<x-datatables-export::table>dan<table>biasa hasilnya identik di HTML — bebas pilih mana yang lebih nyaman.
Contoh
Tabel lengkap dengan Gambar + Aksi tidak ikut ekspor
@extends('layouts.app') @section('content') <div class="container mt-4"> <x-datatables-export::table id="tabelAlat" class="table table-bordered table-striped align-middle"> <thead> <tr> <th>#</th> <th>Nama Alat</th> <th>Gambar Alat</th> <th>Keterangan</th> <th>Kategori</th> <th>Stok</th> <th>Aksi</th> </tr> </thead> <tbody> @foreach ($alat as $a) <tr> <td>{{ $loop->iteration }}</td> <td>{{ $a->nama_alat }}</td> <td> @if ($a->gambar_alat) <img src="{{ asset('storage/' . $a->gambar_alat) }}" width="80"> @endif </td> <td>{{ $a->keterangan_alat }}</td> <td>{{ $a->kategori->nama_kategori }}</td> <td>{{ $a->stok }}</td> <td> <a href="{{ route('alat.edit', $a->id) }}" class="btn btn-sm btn-warning">Edit</a> <a href="{{ route('alat.destroy', $a->id) }}" class="btn btn-sm btn-danger">Delete</a> </td> </tr> @endforeach </tbody> </x-datatables-export::table> </div> @endsection @push('scripts') <script> $(document).ready(function () { // Kolom indeks 2 (Gambar) dan 6 (Aksi) tidak ikut ekspor $('#tabelAlat').DataTable({ layout: { topStart: { buttons: [ { extend: 'copy', exportOptions: { columns: [0, 1, 3, 4, 5] } }, { extend: 'csv', exportOptions: { columns: [0, 1, 3, 4, 5] } }, { extend: 'excel', exportOptions: { columns: [0, 1, 3, 4, 5] } }, { extend: 'pdf', exportOptions: { columns: [0, 1, 3, 4, 5] } }, { extend: 'print', exportOptions: { columns: [0, 1, 3, 4, 5] } } ] } } }); }); </script> @endpush
Custom judul dan nama file ekspor
$(document).ready(function () { $('#myTable').DataTable({ layout: { topStart: { buttons: [ { extend: 'excel', text: 'Download Excel', title: 'Laporan Data Pengguna', filename: 'laporan-pengguna', exportOptions: { columns: [0, 1, 2] } }, { extend: 'pdf', text: 'Download PDF', title: 'Laporan Data Pengguna', filename: 'laporan-pengguna', exportOptions: { columns: [0, 1, 2] } } ] } } }); });
Tombol di bawah tabel
$(document).ready(function () { $('#myTable').DataTable({ layout: { topStart: null, bottomStart: { buttons: ['excel', 'pdf', 'print'] } } }); });
Konfigurasi
Publish config
php artisan vendor:publish --tag=datatables-export-config
File akan muncul di config/datatables-export.php.
Publish views (opsional)
php artisan vendor:publish --tag=datatables-export-views
Views disalin ke resources/views/vendor/datatables-export/.
Semua opsi config
// config/datatables-export.php return [ 'datatables_version' => '2.3.4', 'buttons_version' => '3.2.5', 'jszip_version' => '3.10.1', 'pdfmake_version' => '0.2.7', 'cdn' => [ 'datatables_css' => 'https://cdn.datatables.net/{version}/css/dataTables.dataTables.min.css', 'buttons_css' => 'https://cdn.datatables.net/buttons/{buttons_version}/css/buttons.dataTables.min.css', 'jquery_js' => 'https://code.jquery.com/jquery-3.7.1.min.js', 'datatables_js' => 'https://cdn.datatables.net/{version}/js/dataTables.min.js', 'jszip_js' => 'https://cdnjs.cloudflare.com/ajax/libs/jszip/{jszip_version}/jszip.min.js', 'pdfmake_js' => 'https://cdnjs.cloudflare.com/ajax/libs/pdfmake/{pdfmake_version}/pdfmake.min.js', 'vfs_fonts_js' => 'https://cdnjs.cloudflare.com/ajax/libs/pdfmake/{pdfmake_version}/vfs_fonts.js', 'buttons_js' => 'https://cdn.datatables.net/buttons/{buttons_version}/js/dataTables.buttons.min.js', 'buttons_html5_js' => 'https://cdn.datatables.net/buttons/{buttons_version}/js/buttons.html5.min.js', 'buttons_print_js' => 'https://cdn.datatables.net/buttons/{buttons_version}/js/buttons.print.min.js', ], ];
Kompatibilitas Laravel
| Laravel | PHP | Blade Component | Auto-Discovery | Catatan |
|---|---|---|---|---|
| 12.x | 8.2+ | ✅ | ✅ | Full support |
| 11.x | 8.2+ | ✅ | ✅ | Full support |
| 10.x | 8.1+ | ✅ | ✅ | Full support |
| 9.x | 8.0+ | ✅ | ✅ | Full support |
| 8.x | 7.3+ | ✅ | ✅ | Full support |
| 7.x | 7.2.5+ | ✅ | ✅ | Full support |
| 6.x | 7.2+ | ❌ | ✅ | Gunakan @component atau publish views |
| 5.5–5.8 | 7.1+ | ❌ | ✅ | Gunakan @component atau publish views |
| 5.4 ke bawah | 7.0+ | ❌ | ❌ | Daftarkan provider manual di config/app.php |
Blade Component (
<x-...>) baru tersedia di Laravel 7+. Di Laravel 5–6 gunakan@component('datatables-export::components.table', ['id' => 'myTable']).
Changelog
v1.1.1
- Fix urutan load JS: CDN sekarang di-push ke stack
datatables-scriptsterpisah dariscripts, agar jQuery + DataTables selalu termuat sebelum script inisialisasi halaman
v1.1.0
- jQuery 3.7.1 otomatis dimuat via CDN — tidak perlu taruh script jQuery manual di layout
- Key
jquery_jsditambahkan ke configcdnuntuk kustomisasi versi/URL jQuery
v1.0.1
- Component
<x-datatables-export::table />tidak lagi auto-inject script inisialisasi — script ditulis sendiri oleh user untuk kebebasan konfigurasi penuh - JS CDN sekarang di-push via
@pushOnceke stack terpisah di layout, bukan di-render inline - Prop
buttonsdanexportColumnsdihapus dari componenttable, digantikan propclass
v1.0.0
- Rilis pertama
- Component
<x-datatables-export::scripts />: muat CDN DataTables v2 + Buttons + JSZip + PDFMake otomatis - Component
<x-datatables-export::table />: render<table>HTML murni dengan propiddanclass - Konfigurasi CDN versi dan URL dapat di-publish dan dikustomisasi via
config/datatables-export.php - Support Laravel 6–12, PHP 7.3+
License
MIT © kafyx-3