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