public function GET_member_qna_info($member_id) { $grade_qs = DB::select(' SELECT COALESCE(SUM(V.grade),0) grade FROM qna_questions Q JOIN qna_votes V ON V.votable_id = Q.id AND V.votable_type = ? WHERE writer_id = ? AND Q.deleted_at IS NULL ', [Question::class, $member_id]); $grade_qs = sizeof($grade_qs) == 0 ? 0 : $grade_qs[0]->grade; $grade_as = DB::select(' SELECT COALESCE(SUM(V.grade),0) grade FROM qna_answers A JOIN qna_votes V ON V.votable_id = A.id AND V.votable_type = ? WHERE writer_id = ? AND A.deleted_at IS NULL ', [Answer::class, $member_id]); $grade_as = sizeof($grade_as) == 0 ? 0 : $grade_as[0]->grade; $grade_cs = DB::select(' SELECT COALESCE(SUM(V.grade),0) grade FROM qna_comments C JOIN qna_votes V ON V.votable_id = C.id AND V.votable_type = ? WHERE writer_id = ? AND C.deleted_at IS NULL ', [Comment::class, $member_id]); $grade_cs = sizeof($grade_cs) == 0 ? 0 : $grade_cs[0]->grade; $qs = Question::where('writer_id', $member_id)->with('viewCounts')->with('comments.writer')->with('writer.socials')->with('answers.writer')->with('answers.comments.writer')->orderBy('id', 'desc')->paginate(10); return view('ncells::qna.pages.member_qna', ['member_id' => $member_id, 'grade_qs' => $grade_qs, 'grade_as' => $grade_as, 'grade_cs' => $grade_cs, 'qs' => $qs]); }
public function GET_qna_trashes() { $qs = Question::onlyTrashed()->orderBy('id', 'desc')->paginate(10); return view('ncells::qna.pages.admin.qna_trashes', ['qs' => $qs]); }
public function get_list() { $qs = Question::with('viewCounts')->with('votes')->with('comments.writer')->with('writer.socials')->with('answers.writer')->with('answers.comments.writer')->orderBy('id', 'desc')->paginate(10); return view('ncells::qna.pages.list', ['qs' => $qs]); }