public function indexHtml(Request $request) { $pid = $request->input('pid'); $cat_id = $request->input('cat_id'); $Tips = Tip::all(); if ($pid || $cat_id) { if ($pid) { $Tips = Tip::where('place_id', $pid); } if ($cat_id) { $Tips = Tip::where('cat_id', $cat_id); } $Tips = $Tips->get(); } foreach ($Tips as $tip) { $tip->name = User::find($tip->user_id)->name; $tip->username = User::find($tip->user_id)->username; $tip->answers = Tip::where('parent_id', $tip->id)->get(); foreach ($tip->answers as $i => $value) { $answer = $tip->answers[$i]; $answer->name = User::find($answer->user_id)->name; $answer->username = User::find($answer->user_id)->username; } } return view('places.index', ['tips' => $Tips]); }
public function tips() { $now = Carbon::now(); $tips = Tip::where('start', '<', $now)->where('end', '>', $now)->get(); return response()->json(['tips' => $tips]); }