public function store($slug)
{
$store = Store::slug($slug)->get()->first();
return view('store')->with('store', $store)->with('categories', $store->getCategories()->get())->with('offers', Offer::join('categories', 'offers.category_id', '=', 'categories.id')->join('stores', 'stores.id', '=', 'categories.store_id')->select('categories.name as category', 'categories.cashback as cashback', 'offers.id as id', 'stores.slug as slug', 'offers.name as name', 'offers.link', 'offers.description as description', 'offers.expiry_date')->where('slug', $slug)->orderBy('expiry_date', 'desc')->active())->with('expired_offers', Offer::join('categories', 'offers.category_id', '=', 'categories.id')->join('stores', 'stores.id', '=', 'categories.store_id')->select('categories.name as category', 'categories.cashback as cashback', 'offers.id as id', 'stores.slug as slug', 'offers.name as name', 'offers.link', 'offers.description as description', 'offers.expiry_date')->where('slug', $slug)->orderBy('expiry_date', 'desc')->expired());
}
