/**
  * Remove the specified device from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $kinddevices = KindDevice::find($id);
     if ($kinddevices != null) {
         $kinddevices->delete();
     }
     return json_encode("success");
 }
 /**
  * Export to excel list device
  * 
  * @return file excel
  */
 public function exportExcel()
 {
     Excel::create('List Device', function ($excel) {
         $excel->sheet('Sheetname', function ($sheet) {
             $sheet->setBorder('A1:K1', 'thin');
             $sheet->cells('A1:K1', function ($cells) {
                 $cells->setBackground('blue');
                 $cells->setFontColor('#FFFFFF');
                 $cells->setAlignment('center');
                 $cells->setValignment('middle');
                 $cells->setFontFamily('Times New Roman');
             });
             $sheet->setFontFamily('Times New Roman');
             $sheet->setWidth(array('A' => '10', 'B' => '20', 'C' => '20', 'D' => '20', 'E' => '20', 'F' => '20', 'G' => '40', 'H' => '20', 'I' => '30', 'J' => '20', 'K' => '20'));
             $data = [];
             /*HEADER EXCEL*/
             array_push($data, array('STT', 'NAME DEVICE', 'SERIAL DEVICE', 'RECEIVE DATE', 'STATUS'));
             /*CONTENT EXCEL*/
             $device = Device::all();
             $number = 0;
             foreach ($device as $key => $value) {
                 $device[$key]->device_name = KindDevice::find($value->kind_device_id)->device_name;
                 $device[$key]->status = StatusDevice::find($value->status_id)->status;
                 $device[$key]->employee_code = Employee::find($value->employee_id)->employee_code;
                 $number++;
                 array_push($data, array($number, $value->device_name, $value->serial_device, $value->receive_date, $value->status, $value->distribution));
             }
             $sheet->fromArray($data, null, 'A1', false, false);
         });
     })->download('xls');
 }
 /**
  * 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);
 }