public function searchfaq(Request $request)
{
$input = $request->all();
$query = $input['search'];
$faqs = Faq::where('question', 'LIKE', '%' . $query . '%')->get();
return view('faqs-search')->with('faqs', $faqs)->with('query', $query);
}
public function search(Request $request)
{
$keyword = $request->get('nombre');
if (trim(urldecode($keyword)) == '') {
return response()->json([], 200);
}
$results = Faq::where('question', 'LIKE', '%' . $keyword . '%')->orderBy('question')->take(3)->get(['id', 'question', 'answer']);
return response()->json([$results]);
}
public function update($id, Request $request)
{
$faq = Faq::where('id', '=', $id)->first();
if ($faq->validate($request->all())) {
$faq->update($request->all());
return redirect(route('listar-faq'));
} else {
return redirect(route('editar-faq'))->withInput()->withErrors($faq->errors());
}
}
public function getFaq($keyword)
{
$results = Faq::where('question', 'like', '%' . $keyword . '%')->get();
if (count($results) == 0) {
$tag = Tag::where('name', 'like', '%' . $keyword . '%')->first();
if ($tag) {
$tagname = $tag->name;
$results = Faq::whereHas('tags', function ($q) use($tagname) {
$q->where('name', '=', $tagname);
})->get();
}
return $results;
} else {
return $results;
}
}
public function search(Request $request)
{
$this->validate($request, ['search' => 'required|String']);
$search = $request->search;
Session::put('search', $search);
$now = Carbon::now();
$random_art = Art::where('sold', 0)->where('ending', '>', $now)->where(function ($query) use($search) {
$query->where('title', 'like', '%' . $search . '%')->orWhere('description', 'like', '%' . $search . '%');
})->paginate(8);
$faqs = Faq::where('question', 'like', '%' . $search . '%')->orWhere('awnser', 'like', '%' . $search . '%')->orWhere('tags', 'like', '%' . $search . '%')->get();
$picture = $this->getPicture($random_art);
$duration = $this->getDuration($random_art, $now);
$VoS = 'searchFilter';
$title = 'Search';
$onePiece = $this->onePiece();
$path = $search;
return View('art.overview', compact('random_art', 'VoS', 'duration', 'picture', 'title', 'faqs', 'onePiece', 'path'));
}
public function getAll($where = [])
{
$faq_get = \App\Faq::where($where);
return $faq_get->get();
}
public function faq()
{
$faqs = \App\Faq::where('active', '1')->get();
return view('faq', ['page' => 'faq', 'faqs' => $faqs]);
}
