ac_datagrid_pro : Datagrid JavaScript sans dépendance NEW

// Une seule méthode publique, dispatch selon l'action reçue
public function handle(Request $request): JsonResponse
{
    return match($request->input('action')) {
        'load'    => $this->load($request),
        'insert'  => $this->insert($request),
        'update'  => $this->update($request),
        'delete'  => $this->delete($request),
        'options' => $this->options($request),
    };
}

// Chargement paginé, Eloquent standard
private function load(Request $request): JsonResponse
{
    $query = Praticien::query()
        ->select('p.id', 'p.nom', 'p.prenom', 'm.libelle as metier', ...)
        ->from('demo_praticiens as p')
        ->join('demo_metiers as m', 'm.id_metier', '=', 'p.id_metier');

    // Recherche globale
    if ($search = $request->input('search')) {
        $query->where(fn($q) => $q
            ->where('p.nom', 'like', "%$search%")
            ->orWhere('m.libelle', 'like', "%$search%"));
    }

    // Tri multi-colonnes (Shift+clic sur les en-têtes)
    foreach ($request->input('sort', []) as $s) {
        $query->orderBy($colMap[$s['column']], $s['direction']);
    }

    return response()->json([
        'status'   => 'ok',
        'data'     => $query->offset(($page-1) * $perPage)->limit($perPage)->get(),
        'total'    => $query->count(),
        'page'     => $page,
        'per_page' => $perPage,
    ]);
}