DatatablesSortable.php 432 B

123456789101112131415161718192021
  1. <?php
  2. namespace App\Traits;
  3. trait DatatablesSortable
  4. {
  5. public function sortByColumn($order, $columns, $query)
  6. {
  7. // order is an array like [{"column":"11","dir":"asc"}]
  8. if ($order) {
  9. $order = $order[0];
  10. $column = $columns[$order['column']]['data'];
  11. $direction = $order['dir'];
  12. $query->orderBy($column, $direction);
  13. }
  14. return $query;
  15. }
  16. }