private function reloadQuestions($id) { $questions = Question::where('product_id', $id)->orderBy('created_at', 'DESC')->get(); foreach ($questions as $question) { $question['texts'] = Text::with('user')->where('question_id', $question->id)->get(); foreach ($question->texts as $text) { $text['date'] = Date::parse($text->created_at)->diffForHumans(); } } return $questions; }
function index() { if (auth()->user()->role_id == 3) { $questions = Question::whereIn('product_id', function ($query) { $query->select('id')->from('products')->where('user_id', auth()->user()->id)->get(); })->orderBy('created_at', 'DESC')->get(); } else { $questions = Question::where('user_id', auth()->user()->id)->orderBy('created_at', 'DESC')->get(); } return view('back.questions', compact('questions')); }