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');
}
