/** * Process datatables re-order ajax request. * Used by 'Datatables' * @return \Illuminate\Http\JsonResponse */ public function sort(Request $request) { $sortArray = $request->get('sortable_'); if (is_null($sortArray)) { $data = ['status' => 'warning', 'statusText' => 'Geen update', 'responseText' => 'Er was geen wijziging!? (sortArray is null)']; return response()->json($data, 400); } try { $cnt = 0; foreach ($sortArray as $key => $sitemapId) { $sitemap = sitemap::find($sitemapId); $sitemap->timestamps = false; $sitemap->order_by_number = ++$cnt; $sitemap->save(); //- See more at: http://findnerd.com/list/view/Update-without-touching-timestamps-Laravel/10269/#sthash.8m6PWJpT.dpuf //Sitemap::where('id',$sitemapId)->update(['order_by_number'=>++$cnt]); } $data = ['status' => 'success', 'statusText' => 'Update is gelukt', 'responseText' => 'De volgorde is aangepast']; return response()->json($data, 200); } catch (\Exception $e) { $data = ['status' => 'danger', 'statusText' => 'Update is mislukt!', 'responseText' => '' . $e->getMessage() . '<br>line: (' . $e->getLine() . ')<bR>file: (' . $e->getFile() . ')']; return response()->json($data, 400); } return "sort"; }