Viewing file:  DeviceController.php (1.66 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
namespace App\Http\Controllers\Admin;
use App\Http\Controllers\Controller;
use App\Models\Customer;
use App\Models\Device;
use Illuminate\Http\Request;
class DeviceController extends Controller
{
public function index(){
$data['customers'] = Customer::where('status','active')->select('id','first_name','last_name')->get();
return view('admin.device.index',$data);
}
public function getAll(Request $request){
$customer_id = $request->customer_id;
if($customer_id) {
$devices = Device::with('customer:id,first_name,last_name')->orderBy('created_at', 'DESC')->whereIn('customer_id', $customer_id)->get(['id','customer_id','name','status','created_at']);
} else {
$devices = Device::with('customer:id,first_name,last_name')->orderBy('created_at', 'DESC')->get(['id','customer_id','name','status','created_at']);
}
return datatables()->of($devices)
->addColumn('customer_name', function ($q) {
return $q->customer->full_name;
})
->addColumn('device_name', function ($q) {
return $q->name;
})
->addColumn('status', function ($q) {
if($q->status == 'active') {
return '<span class="text-sm badge bg-success">Online</span>';
} elseif($q->status == 'inactive') {
return '<span class="text-sm badge bg-danger">Offline</span>';
}
})
->addColumn('created_at', function ($q) {
return formatDate($q->created_at);
})
->rawColumns(['status'])
->toJson();
}
}
|