PHPackages                             chikolokoy08/dengine - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. chikolokoy08/dengine

ActiveLibrary[Utility & Helpers](/categories/utility)

chikolokoy08/dengine
====================

Dengine - Datatable Helper for Laravel. Built to have a better integration, data clean-up and optimisation of datatable server side data. This is an alternative server side processing implementation to match the \[DataTables\](https://datatables.net/manual/server-side) Library.

013PHP

Since Dec 22Pushed 2y ago1 watchersCompare

[ Source](https://github.com/chikolokoy08/dengine)[ Packagist](https://packagist.org/packages/chikolokoy08/dengine)[ RSS](/packages/chikolokoy08-dengine/feed)WikiDiscussions master Synced 3d ago

READMEChangelogDependenciesVersions (1)Used By (0)

Dengine - DataTable Helper for Laravel
======================================

[](#dengine---datatable-helper-for-laravel)

Built to have better integration, data clean-up, and optimization of DataTable server-side data. This is an alternative server-side processing implementation to match the [DataTables](https://datatables.net/manual/server-side) Library. Feel free to modify and improve any methods specific to your requirements.

Installation
------------

[](#installation)

Install using composer:

```
composer require chikolokoy08/dengine dev-master
```

```
composer require chikolokoy08/dengine
```

Laravel (optional)
------------------

[](#laravel-optional)

Add the service provider in `config/app.php`:

```
Chikolokoy08\Dengine\DengineServiceProvider::class
```

And add the Dengine alias to `config/app.php`:

```
'Dengine' => Chikolokoy08\Dengine\Facades\Dengine::class
```

Basic Instance
--------------

[](#basic-instance)

Start by creating a `Dengine` instance (or use the `Dengine` Facade if you are using Laravel):

```
use Chikolokoy08\Dengine\Dengine;

$dengine = new Dengine();
```

Usage On Eloquent
-----------------

[](#usage-on-eloquent)

```
public function getDatatableEvents(Request $request)
{
	try {
		$inputs = $request->all();
		$user_id = 1;

		$dengine = new Dengine();
		$dengine::parse($inputs);

		//MODEL INSTANCE
		$model = new \App\Models\Event();

		//TOTAL RECORDS QUERY
		$total = $model::where('user_id', $user_id)->where('target', 'like', '%'.$dengine::search_keyword().'%')->count();

		//QUERY WITH FULL PARAMETERS
		$query = $model::where('user_id', $user_id)->where('target', 'like', '%'.$dengine::search_keyword().'%')
			->skip($dengine::skip())
			->take($dengine::limit())
			->orderBy('column', $dengine::order_type())
			->get();

		//SETTER FOR TOTAL
		$dengine::recordsTotal($total);

		//PREPARING QUERY RESULT INTO DATATABLE JSON FORMAT
		$dengine::prepare($query->toArray());

		//RETURN AS JSON OBJECT
		return $dengine::make();

	} catch (Exception $e) {
		\Log::error($e);
	}
}
```

Usage On Active Records
-----------------------

[](#usage-on-active-records)

```
public function getDatatableEvents(Request $request)
{
	try {
		$inputs = $request->all();
		$user_id = 1;

		$dengine = new Dengine();
		$dengine::parse($inputs);

		//MODEL INSTANCE
		$model = new \App\Models\Event();
		$dtparams = $dengine::setParameters(['user_id' => $user_id]);

		//TOTAL RECORDS QUERY
		$total = count($model->eventQueryModel($dtparams));

		//Change $dtparams['get_total'] false
		$dtparams['get_total'] = false;

		//QUERY WITH FULL PARAMETERS
		$query = $model->eventQueryModel($dtparams);

		//SETTER FOR TOTAL
		$dengine::recordsTotal($total);

		//PREPARING QUERY RESULT INTO DATATABLE JSON FORMAT
		$dengine::prepare($query);

		//BONUS: YOU CAN FORMAT RETURNED DATA ACCORDING TO YOUR REQUIREMENTS BEFORE RETURNING AS JSON OBJECT
		$dengine::add_column('formatted_date', function($row) {
		    return date('d/m/Y', strtotime($row->date));
		});
		$dengine::add_column('user_display', function($row) use($user_id) {
		    return "This is user #{$user_id}";
		});

		//RETURN AS JSON OBJECT
		return $dengine::make();

	} catch (Exception $e) {
		\Log::error($e);
	}
}
```

Suggested Model Structure
-------------------------

[](#suggested-model-structure)

```
public function eventQueryModel($qp=[])
{
	try {
		$column_orderable 	= [ 'title', 'target', 'event_date'];
		$qp['column_text']	= $qp['column'] == '' ? $column_orderable[0] : $column_orderable[$qp['column']];
		$qp['take']           		= $qp['get_total'] == true || $qp['keyword'] != '' ? 5000000 : $qp['take'];
		$whereClauses     	= "t.user_id = {$qp['user_id']}";

		//IF KEYWORD IS NOT EMPTY
		if (!empty($qp['keyword'])) {
			$whereClauses .= " AND ( t.title LIKE '%$keyword%' OR t.target LIKE '%$keyword%' OR t.date LIKE '%$keyword%')";
		}

		$query = \DB::select("
		    SELECT
		        t.id,
		        t.user_id,
		        t.title,
		        t.target,
		        DATE_FORMAT(t.date, '%d %M %Y') as event_date
		    FROM
		        {$this->table} as t
		    WHERE
		        {$whereClauses}
		    GROUP BY t.id
		    ORDER BY {$qp['column_text']} {$qp['order_type']}
		    LIMIT {$qp['skip']}, {$qp['take']}
		");

		return $query;

	} catch (Exception $e) {
		\Log::error($e);
	}
}
```

Suggested Full Controller
-------------------------

[](#suggested-full-controller)

```
namespace App\Http\Controllers;

use Chikolokoy08\Dengine\Dengine;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;

class DatatableController extends Controller
{
    protected $dengine;

    public function __construct(Request $request)
    {
    	try {
	    	$this->dengine = new Dengine();
	    	$this->dengine::parse($request->all());
    	} catch (Exception $e) {
    		\Log::error($e);
    	}
    }

		public function getDatatableEvents(Request $request)
		{
			try {
				//MODEL INSTANCE
				$model = new \App\Models\Event();
				$dtparams = $this->dengine::setParameters(['user_id' => $user_id]);

				//TOTAL RECORDS QUERY
				$total = $model->eventQueryModel($dtparams);

				//Change $dtparams['get_total'] false
				$dtparams['get_total'] = false;

				//QUERY WITH FULL PARAMETERS
				$query = $model->eventQueryModel($dtparams);

				//SETTER FOR TOTAL
				$this->dengine::recordsTotal($total);

				//PREPARING QUERY RESULT INTO DATATABLE JSON FORMAT
				$this->dengine::prepare($query);

				//BONUS: YOU CAN FORMAT FETCHED DATA ACCORDING TO YOUR REQUIREMENTS BEFORE RETURNING AS JSON OBJECT
				$this->dengine::add_column('formatted_date', function($row) {
				    return date('d/m/Y', strtotime($row->date));
				});
				$this->dengine::add_column('user_display', function($row) use($user_id) {
				    return "This is user #{$user_id}";
				});
				$this->dengine::add_column('actions', function($row) use($user_id) {
				    return "Edit User";
				});

				//RETURN AS JSON OBJECT
				return $this->dengine::make();

			} catch (Exception $e) {
				\Log::error($e);
			}
		}
}
```

Returned JSON Format
--------------------

[](#returned-json-format)

```
	{
		"draw":"1",
		"recordsTotal":0,
		"recordsFiltered":0,
		"server_cols":"",
		"data":[]
	}
```

*Note, the version method is still in beta, so it might not return the correct result.*

License
-------

[](#license)

Datatable Engine Laravel is licensed under [The MIT License (MIT)](LICENSE).

\##Support

If you have questions just send an email at

###  Health Score

14

—

LowBetter than 2% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity5

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity20

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/9796f4cfbb31661b53284493fb72cb9b2c9ca1bee7ed4398f9bef4a4244091bb?d=identicon)[cmabugay@gmail.com](/maintainers/cmabugay@gmail.com)

---

Top Contributors

[![chikolokoy08](https://avatars.githubusercontent.com/u/4935154?v=4)](https://github.com/chikolokoy08 "chikolokoy08 (22 commits)")

### Embed Badge

![Health badge](/badges/chikolokoy08-dengine/health.svg)

```
[![Health](https://phpackages.com/badges/chikolokoy08-dengine/health.svg)](https://phpackages.com/packages/chikolokoy08-dengine)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)