/** * Remove the specified resource from storage. * @param type int $id * @param type Department $department * @param type Group_assign_department $group_assign_department * @return type Response */ public function destroy($id, Department $department, Group_assign_department $group_assign_department) { try { /* Becouse of foreign key we delete group_assign_department first */ $group_assign_department = $group_assign_department->where('department_id', $id); $group_assign_department->delete(); $departments = $department->whereId($id)->first(); /* Check the function is Success or Fail */ if ($departments->delete() == true) { return redirect('departments')->with('success', 'Department Deleted sucessfully'); } else { return redirect('departments')->with('fails', 'Department can not Delete'); } } catch (Exception $e) { return redirect('departments')->with('fails', 'Department can not Delete'); } }
/** * Remove the specified resource from storage. * @param type int $id * @param type Department $department * @param type Group_assign_department $group_assign_department * @return type Response */ public function destroy($id, Department $department, Group_assign_department $group_assign_department, System $system, Tickets $tickets) { // try { $system = $system->where('id', '=', '1')->first(); if ($system->department == $id) { return redirect('departments')->with('fails', 'You cannot delete default department'); } else { $tickets = DB::table('tickets')->where('dept_id', '=', $id)->update(['dept_id' => $system->department]); if ($tickets > 0) { if ($tickets > 1) { $text_tickets = "Tickets"; } else { $text_tickets = "Ticket"; } $ticket = '<li>' . $tickets . ' ' . $text_tickets . ' have been moved to default department</li>'; } else { $ticket = ""; } $users = DB::table('users')->where('primary_dpt', '=', $id)->update(['primary_dpt' => $system->department]); if ($users > 0) { if ($users > 1) { $text_user = "******"; } else { $text_user = "******"; } $user = '******' . $users . ' ' . $text_user . ' have been moved to default department</li>'; } else { $user = ""; } $emails = DB::table('emails')->where('department', '=', $id)->update(['department' => $system->department]); if ($emails > 0) { if ($emails > 1) { $text_emails = "Emails"; } else { $text_emails = "Email"; } $email = '<li>' . $emails . ' System ' . $text_emails . ' have been moved to default department</li>'; } else { $email = ""; } $helptopic = DB::table('help_topic')->where('department', '=', $id)->update(['department' => null], ['status' => '1']); if ($helptopic > 0) { $helptopic = '<li>The associated helptopic has been deactivated</li>'; } else { $helptopic = ""; } $message = $ticket . $user . $email . $helptopic; /* Becouse of foreign key we delete group_assign_department first */ $group_assign_department = $group_assign_department->where('department_id', $id); $group_assign_department->delete(); $departments = $department->whereId($id)->first(); /* Check the function is Success or Fail */ if ($departments->delete() == true) { return redirect('departments')->with('success', 'Department Deleted sucessfully' . $message); } else { return redirect('departments')->with('fails', 'Department can not Delete'); } } }