Search by

data-table / kimsang

seng-kimsang

Reusable Laravel DataTable helper

Package info

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

pkg:composer/data-table/kimsang

Security

Advisories: 0

Aikido package health analysis

Transparency log

Statistics

Installs: 687

Dependents: 0

Suggesters: 0

Stars: 0

Open Issues: 0

v1.2.7 2026-08-14 02:06 UTC

Requires

  • php: >=8.1

Requires (Dev)

None

Suggests

None

Provides

None

Conflicts

None

Replaces

None

MIT 2533ef61d18e08a8951b458420122486ce6774e7

Published on Packagist.org on 2026-08-14 02:12 UTC

This package is auto-updated.

Last update: 2026-09-14 02:20:52 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