public function getFiltrarcompra(Request $request) { if (!$request->ajax()) { abort(403); } $datos = array(); $inputs = $request->all(); if (empty($inputs['search'])) { $compras = \App\Compra::select(\DB::raw('SQL_CALC_FOUND_ROWS *'), 'id')->where('id', '>', 0)->take($inputs['limit'])->skip($inputs['offset'])->orderBy('created_at', 'ASC')->get(); } else { $compras = \App\Compra::select(\DB::raw('SQL_CALC_FOUND_ROWS *'), 'id')->where('numfactura', 'LIKE', '%' . $inputs["search"] . '%')->take($inputs['limit'])->skip($inputs['offset'])->orderBy('created_at', 'ASC')->get(); } $cantidad = \DB::select(\DB::raw("SELECT FOUND_ROWS() AS total;")); $cantidad = $cantidad[0]->total; $n = 1; foreach ($compras as $compra) { $url = '<a href="' . route('compra.edit', $compra->id) . '" class="btn btn-xs btn-success"><i class="fa fa-btn fa-edit"></i>Editar</a>'; $datos[] = ['num' => $n++, 'numfactura' => $compra->numfactura, 'proveedor' => \App\Proveedor::where('id', $compra->id_proveedor)->first()->proveedor, 'total' => number_format($compra->total, 2, '.', ''), 'act' => $url]; } return \Response::json(['total' => $cantidad, 'rows' => $datos]); }