samedi 25 février 2017

Laravel - sorting table by column titles, results not being sorted

I am using Kyslik/column-sortable in my Laravel CRUD project for added sortable column headers.

the model:

use Sortable;
// 
public $sortable = ['id', 'name', 'email', 'created_at', 'updated_at'];

the view:

<table class="table table-hover">
     <thead>
         <tr>
             <th> @sortablelink('id','#') </th>
             <th> @sortablelink('name') </th>
             ...
          </tr>
     </thead>
     <tbody>
     </tbody>
</table>

and the controller:

public function index(Request $request)
{
    $keyword = $request->get('search');
    //dd($request);
    if (!empty($keyword)) {
        $customers = Customer::where('name', 'LIKE', "%$keyword%")
            ->orWhere('email', 'LIKE', "%$keyword%")
            ->sortable()
            ->paginate(config('settings.perPage'));
    } else {
        $customers = Customer::paginate(config('settings.perPage'));
    }

    return view('admin.customers.index', compact('customers'));
}

The view and the column header links show up and work exactly as expected, but the results aren't sorted at all... What am I missing?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire