/** * Remove the specified operating system from storage. * * @param int $id * @return string */ public function destroy($id) { $operatingsystems = OperatingSystem::find($id); if ($operatingsystems != null) { $operatingsystems->delete(); } return json_encode("success"); }
/** * Run the database seeds. * * @return void */ public function run() { OperatingSystem::create(['name' => 'Windows Server 2012 R2']); OperatingSystem::create(['name' => 'Windows Server 2008 R2']); OperatingSystem::create(['name' => 'Windows Server 2003']); OperatingSystem::create(['name' => 'Linux']); OperatingSystem::create(['name' => 'Other']); }
/** * Showing device's information * * @param [int] $id * @return Response */ public function show($id) { $device = Device::find($id); $operatings = OperatingSystem::lists("os_name", "id"); $kinds = KindDevice::lists("device_name", "id"); $informations = InformationDevice::lists("contract_number", "id"); $status = StatusDevice::lists("status", "id"); return view('devices.editdevice', compact('device', 'status', 'informations', 'kinds', 'operatings')); }
/** * Filter info in overview device * @return void */ public function filter() { $type_id = Input::get('type_device'); $model_id = Input::get('model_device'); $kind_id = Input::get('kind_device'); $status_id = Input::get('status_device'); $os_id = Input::get('os_device'); $contract_id = Input::get('contract_number'); $position = Position::all(); $types = TypeDevice::all(); $models = ModelDevice::all(); $kinds = KindDevice::all(); $statuses = StatusDevice::all(); $os = OperatingSystem::all(); $contract = InformationDevice::all(); /*Thuc hien cau truy van de lay du lieu sau khi filter*/ $devices = Device::whereHas('kind_device', function ($query) use($type_id) { if ($type_id) { $query->whereHas('model_device', function ($query) use($type_id) { $query->whereHas('type_devices', function ($query) use($type_id) { $query->where('id', '=', $type_id); }); }); } })->whereHas('kind_device', function ($query) use($model_id) { if ($model_id) { $query->whereHas('model_device', function ($query) use($model_id) { $query->where('id', '=', $model_id); }); } })->whereHas('kind_device', function ($query) use($kind_id) { if ($kind_id) { $query->where('id', '=', $kind_id); } })->whereHas('status_devices', function ($query) use($status_id) { if ($status_id) { $query->where('id', '=', $status_id); } })->whereHas('operating_system', function ($query) use($os_id) { if ($os_id) { $query->where('id', '=', $os_id); } })->whereHas('infomation_device', function ($query) use($contract_id) { if ($contract_id) { $query->where('id', '=', $contract_id); } })->get(); foreach ($devices as $key => $value) { $value->device_name = $value->kind_device->device_name; $value->status = $value->status_devices->status; $employee = $value->employee; if ($employee) { $value->employee_code = $employee->employee_code; $value->fullname = $employee->lastname . " " . $employee->firstname; $value->employee_position = $employee->departments['name']; } else { $value->employee_code = ""; $value->fullname = ""; $value->employee_position = ""; } } echo json_encode($devices); }