Skip to content

Instantly share code, notes, and snippets.

@Muetze42
Last active November 10, 2021 09:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Muetze42/77f6577cd539377cd4ec4605e3a2e4ce to your computer and use it in GitHub Desktop.
Save Muetze42/77f6577cd539377cd4ec4605e3a2e4ce to your computer and use it in GitHub Desktop.
Laravel Nova: indexQuery Default order
<?php
/**
* The column by which to sort as default
*
* @var string
*/
public static string $defaultSort = '';
/**
* Sort ascending or descending as default
*
* @var string
*/
public static string $defaultOrder = 'asc';
/**
* Build an "index" query for the given resource.
*
* @param NovaRequest $request
* @param Builder $query
* @return Builder
*/
public static function indexQuery(NovaRequest $request, $query): Builder
{
if (static::$defaultSort && empty($request->get('orderBy'))) {
$query->getQuery()->orders = [];
return $query->orderBy(static::$defaultSort, static::$defaultOrder);
}
return $query;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment