data-table/kimsang

Reusable Laravel DataTable helper

Maintainers

Package info

github.com/seng-kimsang/data-table-helper

pkg:composer/data-table/kimsang

Statistics

Installs: 194

Dependents: 0

Suggesters: 0

Stars: 0

Open Issues: 0

Security

Advisories: 0

Aikido package health analysis

v1.2.6 2026-03-08 07:42 UTC

Requires

  • php: >=8.1

MIT 386d3d2c2ef68e9867fed990dc533a7f436c18e8

This package is auto-updated.

Last update: 2026-04-08 08:02:40 UTC

README

A reusable Laravel DataTable helper package designed for searching, sorting, and pagination, with PostgreSQL-safe global search, integer compatibility, and operator-based filtering.

This package is built for real-world admin panels, API backends, and frontend data tables.

✨ Features

  • ✅ Laravel 10 & 11 compatible
  • ✅ PostgreSQL-safe (ILIKE, reserved keyword handling)
  • ✅ Works with string & integer columns
  • ✅ Operator-based global search
  • ✅ Safe parameter binding (SQL injection protected)
  • ✅ Supports Eloquent Model, Builder, or Model instance
  • ✅ Ready for Composer & Packagist

Search Application Logic

The applySearch method applies search conditions dynamically based on a specified operator. It supports both text and numeric columns by safely casting values to text when necessary and performs case-insensitive matching using PostgreSQL ILIKE.

This approach allows a single global search to work across mixed column types while remaining safe and performant.

📦 Installation

composer require data-table/kimsang