<?php

namespace Yajny\Controller;

use App\Http\Controllers\Controller;
use Yajny\Models\Faqs;
use Yajny\Models\FaqCategories;
use Illuminate\Pagination\Paginator ;
use DB;


class FaqsCtrl extends Controller
{
    
    public static function getfaqsCategory() {
        return FaqCategories::with('faqs')->get();
    }

    public static function getCategoryByFaq($faqCat) {
        // orderby Feilds to be Implemented
        return  FaqCategories::with('faqs')->where('slug', $faqCat)->first();
    }
    
    public static function getFaq($faq) {
        
        $faqs = [];
        $faqs['article'] = Faqs::where('slug', $faq)->first();
        $faqs['related_articles'] = Faqs::where('slug', '!=', $faq)->limit(4)->get();

        return $faqs;
    }

 
    public static function all_faq_cats() {
        return FaqCategories::all();
    }

    public static function search_faqs($searchText) {
        
       
          return Faqs::whereRaw('LOWER(title) LIKE ?','%'.$searchText.'%')
                            ->orwhereRaw('LOWER(content) LIKE ?', '%'.$searchText.'%')
                        ->paginate(10);
                       
    }
    
}