public function getGantt($id) { if (!Auth::check()) { return redirect("/"); } $memberOfBoard = Membermanagement::where('User_id', '=', Auth::user()->id)->where('Board_id', '=', $id)->get(); if (count($memberOfBoard) == 0) { return redirect("/"); } $Board = Board::all()->find($id); session::put("idForGantt", $id); $boardCards = Board::with(['members'])->find(session()->get('idForGantt')); $cards = $boardCards->cards()->with(['memberCard.member', 'comments'])->get(); return view('pages.gantt.ganttChart')->with('Board', $Board)->with('Card', $cards); }
public function delMember($id) { if (!Auth::check()) { return redirect("/"); } $memberID = \Input::get('memberID'); $member = Membermanagement::find($memberID); $member->active = 1; $member->save(); $board = Board::find($id); $boardManager = $board->manager_id; $MemMa = Membermanagement::where('User_id', '=', $boardManager)->where('Board_id', '=', $id)->get(); $cards = Card::where('MemberManagement_id', '=', $member->id)->get(); foreach ($cards as $card) { $card->MemberManagement_id = $MemMa[0]->id; $card->save(); } return redirect("member/{$id}"); }
public function hardDeleteBoard($id) { if (!Auth::check()) { return redirect("/"); } if (Auth::user()->Level_id == 1) { return redirect('/managementAccount'); } $data = Board::find($id); if (Auth::user()->id != $data->manager_id) { return redirect("/"); } $cards = Card::where('Board_id', '=', $id)->get(); $ids = []; foreach ($cards as $cards) { $ids[] = $cards['id']; } Checklist::whereIn('Card_id', $ids)->delete(); Comment::whereIn('Card_id', $ids)->delete(); Card::where('Board_id', '=', $id)->whereNotNull('child_id')->delete(); Card::where('Board_id', '=', $id)->delete(); Membermanagement::where('Board_id', '=', $id)->delete(); $data->delete(); return redirect('/home'); }