/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $search = (object) array(); $search->from = $request->input('searchFrom') ? $request->input('searchFrom') : Carbon::today()->subMonth()->format('Y-m-d'); $search->to = $request->input('searchTo') ? $request->input('searchTo') : Carbon::today()->addMonth()->format('Y-m-d'); if ($request->input('searchName') && $request->input('searchName') != '') { $search->name = $request->input('searchName'); } if ($request->input('searchCategory') && $request->input('searchCategory') != '') { $search->category = $request->input('searchCategory'); } if ($request->input('searchStatus') && $request->input('searchStatus') != '') { $search->status = $request->input('searchStatus'); } $contents = Content::orderBy('created_at'); if (Auth::user()->types === 'author') { $contents->where('user_id', Auth::user()->id); } if (isset($search->name)) { $contents->where('name', 'like', '%' . spaceToLike($search->name) . '%'); } if (isset($search->category)) { $contents->where('category_id', $search->category); } if (isset($search->status)) { $contents->where('status', $search->status); } if (isset($search->from) && isset($search->to)) { $contents->where('created_at', '>=', $search->from); $contents->where('created_at', '<=', $search->to); } $contents = $contents->paginate(config('app.admin.content.per_page'))->appends(['searchName' => $request->input('searchName'), 'searchCategory' => $request->input('searchCategory'), 'searchStatus' => $request->input('searchStatus'), 'searchFrom' => $request->input('searchFrom'), 'searchTo' => $request->input('searchTo')]); return view('admin/content', ['search' => $search, 'contents' => $contents, 'categories' => Category::all()->sortBy('order')]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $keyword = $request->input('keyword') ? $request->input('keyword') : ''; $adsCatgs = []; if ($request->input('keyword')) { $adsCatgs = AdsCatg::where('name', 'LIKE', '%' . spaceToLike($request->input('keyword')) . '%')->orderBy('order')->get(); } else { $adsCatgs = AdsCatg::orderBy('order')->get(); } return view('admin.category.advertise', ['adsCatgs' => $adsCatgs, 'keyword' => $keyword]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $keyword = $request->input('keyword') ? $request->input('keyword') : ''; $channels = []; if ($request->input('keyword')) { $channels = Channel::where('name', 'LIKE', '%' . spaceToLike($request->input('keyword')) . '%')->orderBy('order')->get(); } else { $channels = Channel::orderBy('order')->get(); } return view('admin.category.webboard', ['channels' => $channels, 'keyword' => $keyword]); }
public function searchContent(Request $request) { $contents = Content::where('name', 'like', '%' . spaceToLike($request->input('key_word')) . '%')->paginate(config('app.frontEnd.content.per_page')); return view('searchContent', ['adsCategories' => AdsCatg::all(), 'category_menus' => Category::all(), 'contents' => $contents, 'keyword' => $request->input('key_word'), 'user' => Auth::user()]); }