zdirnecamlcs96/laravel-helpers

Laravel Helpers

Helpers for Laravel 8 project

Laravel	Version	Supported
8.*	v1.0^	✅
9.*	v2.0^	❓

How to Use

You may include the helper inside Controller.php. For more information, you can refer PHP Traits.

<?php

namespace App\Http\Controllers;

use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Routing\Controller as BaseController;
use Zdirnecamlcs96\Helpers\Traits\Helpers; // Import here

class Controller extends BaseController
{
    use AuthorizesRequests, DispatchesJobs, Helpers; // Use here

}

After install

Please remove ValidatesRequests Trait in LoginController, it will cause ambiguous error as this package overwrote the function inside the trait.

Contributing

Thank you for considering contributing. Since this is for private usage, please contact me for the contribution guide.

Laravel License

The Laravel framework is open-sourced software licensed under the MIT license.

laravel-helpers's Issues

[Performance] whereHas performance issue on datatable filtering

Issue:
Due to the SQL queries that generate from whereHas is using where exists.

Solution:
Use where in query instead. Include this https://github.com/biiiiiigmonster/hasin pacakge and use whereHasIn

[UX] Return more approximate results

Issue:
The matched results by default sorted by lastest. Should return more precise results

Solution:
Add ->sortByDesc(fn($item) => similar_text(strtolower($item->code), $search, $perc) ? $perc : 0) after get() or onvert it into query ->orderByRaw("MATCH(code) AGAINST(? IN BOOLEAN MODE) DESC", [$search]) but need to add FULLTEXT index for the column

UDF (levenshtein)
https://lucidar.me/en/web-dev/levenshtein-distance-in-mysql/