f0bb80707a
Mirrors the frontend catch-up in 570f17e: a substantial amount of
finished-but-never-committed backend work had accumulated locally.
- New CustomField module: admin-managed field definitions per client,
reorderable, typed values stored per client (backing the frontend's
ClientCustomFieldCard + settings/fields page)
- History entries switch from a hardcoded type enum to a dynamic,
admin-managed HistoryType module (reorderable, backing
settings/history-types)
- New Import module: CSV client import (backing settings/import)
- Clients table gains soft deletes (deleted_at)
- Supporting factories, seeders, policies, and feature tests for all
of the above
All 63 backend tests pass locally before this commit.
35 lines
1 KiB
PHP
35 lines
1 KiB
PHP
<?php
|
|
|
|
namespace App\Modules\Search\Actions;
|
|
|
|
use App\Modules\Client\Models\Client;
|
|
use Illuminate\Database\Eloquent\Collection;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
final class SearchClientsAction
|
|
{
|
|
public function handle(string $query): Collection
|
|
{
|
|
if (DB::connection()->getDriverName() === 'sqlite') {
|
|
return Client::query()
|
|
->withCount('historyEntries')
|
|
->withMax('historyEntries', 'created_at')
|
|
->where(function ($q) use ($query) {
|
|
$q->where('name', 'like', "%{$query}%")
|
|
->orWhere('client_number', 'like', "%{$query}%");
|
|
})
|
|
->limit(50)
|
|
->get();
|
|
}
|
|
|
|
return Client::query()
|
|
->withCount('historyEntries')
|
|
->withMax('historyEntries', 'created_at')
|
|
->whereRaw(
|
|
'MATCH(client_number, name) AGAINST(? IN BOOLEAN MODE)',
|
|
[$query.'*']
|
|
)
|
|
->limit(50)
|
|
->get();
|
|
}
|
|
}
|