dilum/puppy-data-table

Lightweight Laravel DataTable with Yajra-like features and a vanilla JS frontend

1.0.0 2025-08-26 12:14 UTC

Requires

• php: ^7.3|^8.0
• illuminate/support: ^8.0|^9.0
• maatwebsite/excel: ^3.1

Requires (Dev)

• orchestra/testbench: ^8.0|^9.0

MIT

README

A lightweight Laravel backend DataTable package that makes it easy to build paginated, searchable, and sortable API responses for your frontend tables. Unlike heavy alternatives, Puppy DataTable is simple, fast, and dependency-free.

🚀 Features

• ✅ Lightweight – no jQuery or heavy frontend dependencies
• ✅ Works with any Eloquent model or query builder
• ✅ Built-in support for search, sort, and pagination
• ✅ Add custom computed columns easily
• ✅ API-friendly JSON responses

📝 Front-End Package

https://www.npmjs.com/package/puppy-data-table

📦 Installation

Require the package via Composer:

composer require dilum/puppy-datatable

⚡ Usage Example

Controller Example

use Dilum\PuppyDataTable\DataTable;
use App\Models\User;
use Illuminate\Http\Request;

class UserController extends Controller
{
    public function index(Request $request)
    {
        return DataTable::of(User::query())
            ->searchable(['name', 'email'])
            ->addColumn('full_name', function ($user) {
                return trim($user->first_name . ' ' . $user->last_name);
            })
            ->editColumn('mobile_number', function ($user) {
                return $user->c_code . $user->mobile_number;
            })
            ->orderColumn('created_at', function ($query, $dir) {
                $query->orderBy('created_at', $dir);
            })
            ->toResponse($request);
    }
}

📤 Example API Response

{
  "data": [
    {"id":1, "name":"John", "email":"[e-mail]", "full_name":"John Doe"},
    {"id":2, "name":"Jane", "email":"[e-mail]", "full_name":"Jane Smith"}
  ],
  "meta": {
    "total": 50,
    "page": 1,
    "per_page": 10
  }
}

🛠️ Methods

Method	Description
of($query)	Bind the DataTable to an Eloquent query or query builder
searchable(array)	Define which columns are searchable
addColumn($key, $callback)	Add custom computed column
editColumn($key, $callback)	Edit custom computed column
orderColumn($key, $callback)	Define custom ordering for a column
toResponse($request)	Return API-ready JSON response

🎯 Example with Custom Columns

return DataTable::of(User::query())
    ->searchable(['name', 'email'])
    ->addColumn('status', function ($user) {
        return $user->is_active ? 'Active' : 'Inactive';
    })
    ->toResponse(request());

📄 License

MIT License – free for personal and commercial use.