public function getCard()
{
if (!Auth::check()) {
return redirect("/");
}
$board = Board::with(['members'])->find(session()->get('Board'));
$cards = Card::with(['checklists', 'memberCard.member', 'comments.memberComment', 'preCard'])->where('Board_id', '=', session()->get('Board'))->orderBy('id', 'desc')->get();
$status = \App\Models\Status::all('id', 'name')->sortBy('id')->toArray();
//-- สร้างรูปแบบ ข้อมูล
$kanban = [];
$kanban['columns'] = [];
$num = 1;
foreach ($status as $s) {
// นำ card ใส่ status
$s['cards'] = [];
foreach ($cards as $card) {
if ($card->status_id == $num) {
$s['cards'][] = $card;
}
}
$kanban['columns'][] = $s;
$num++;
}
return $kanban;
}
public function getCurrentBoardCards()
{
$board = Board::with(['members'])->find(session()->get('idForGantt'));
return $board->cards()->with([])->get();
}
public function getDataMember()
{
if (!Auth::check()) {
return redirect("/");
}
$user = User::find(Auth::user()->id);
$board = Board::with([])->find(session()->get('Board'));
$data['user'] = $user;
$data['board'] = $board;
return $data;
}
