Looking to hire Laravel developers? Try LaraJobs

laravel-datatables-export maintained by kafyx-3

Author
Last update
2026/11/18 16:11 (dev-main)
License
Links
Downloads
0

Comments
comments powered by Disqus

kafyx-3/laravel-datatables-export

CDN DataTables v2 + jQuery + tombol Export (Copy, CSV, Excel, PDF, Print) untuk Laravel — satu tag Blade di layout, langsung jalan.

Latest Version on Packagist Total Downloads Laravel PHP License


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:

  1. jQuery 3.7.1
  2. DataTables core
  3. JSZip (dependency Excel)
  4. PDFMake + vfs_fonts (dependency PDF)
  5. Buttons core
  6. Buttons HTML5 (CSV, Excel, Copy)
  7. 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-scripts terpisah dari scripts, 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_js ditambahkan ke config cdn untuk 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 @pushOnce ke stack terpisah di layout, bukan di-render inline
  • Prop buttons dan exportColumns dihapus dari component table, digantikan prop class

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 prop id dan class
  • 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