芝麻web文件管理V1.00
编辑当前文件:/home/digitalh/www/app/Http/Controllers/Frontend/ServiceController.php
first(); // Retrieve models $header_info_style1 = HeaderInfo::where('language_id', $language->id)->where('style', 'style1')->first(); $socials = Social::where('status', 1)->get(); $header_image_style1 = HeaderImage::where('style', 'style1')->first(); $external_url = ExternalUrl::where('language_id', $language->id)->first(); $contact_info_widget_style1 = ContactInfoWidget::where('language_id', $language->id)->where('style', 'style1')->first(); $menus = Menu::with('submenus') ->where('language_id', $language->id) ->where('status', 'published') ->orderBy('order', 'asc') ->get(); $service = Service::where('services.service_slug', '=', $service_slug) ->first(); if (!isset($service)) { abort(404); } if (isset($service)) { $service_content = ServiceContent::where('service_id', $service->id)->first(); $service_info = ServiceInfo::where('service_id', $service->id)->first(); $service_feature_section = ServiceFeatureSection::where('service_id', $service->id)->first(); $service_features = ServiceFeature::where('service_id', $service->id) ->orderBy('order', 'asc') ->get(); } $recent_services = Service::join("service_categories", 'service_categories.id', '=', 'services.category_id') ->where('service_categories.language_id', $language->id) ->where('service_categories.status', 1) ->where('services.status', 'published') ->orderBy('services.order', 'desc') ->take(3) ->get(); $footer_image_style1 = FooterImage::where('style', 'style1')->first(); $site_info = SiteInfo::where('language_id', $language->id)->first(); $footers = Footer::join("footer_categories", 'footer_categories.id', '=', 'footers.category_id') ->where('footer_categories.language_id', $language->id) ->where('footer_categories.status', 1) ->where('footers.status', 'published') ->orderBy('footers.id', 'asc') ->get(); $footer_categories = FooterCategory::where('language_id', $language->id) ->where('footer_categories.status', 1) ->orderBy('order', 'asc') ->get(); return view('frontend.service.show', compact('preloader', 'favicon', 'seo', 'google_analytic', 'tawk_to', 'bottom_button_widget', 'side_button_widget', 'color_option', 'breadcrumb_image', 'font', 'draft_view', 'socials', 'external_url', 'contact_info_widget_style1', 'menus', 'service', 'service_content', 'service_info', 'service_feature_section', 'service_features', 'recent_services', 'header_info_style1', 'header_image_style1', 'footer_image_style1', 'site_info', 'footers', 'footer_categories', 'page_builder')); } /** * Display the specified resource. * * @param string $category_name * @return \Illuminate\Http\Response */ public function category_index ($category_name = null) { // Default values $service_limit = 6; // Get site language $language = getSiteLanguage(); // Get common model list($preloader, $favicon, $seo, $google_analytic, $tawk_to, $bottom_button_widget, $side_button_widget, $color_option, $breadcrumb_image, $font, $draft_view) = getCommonModel($language); $page_builder = PageBuilder::where('page_name', 'service-category-index')->first(); $service_index = PageBuilder::where('page_name', 'service-index')->first(); // Retrieve models $header_info_style1 = HeaderInfo::where('language_id', $language->id)->where('style', 'style1')->first(); $socials = Social::where('status', 1)->get(); $header_image_style1 = HeaderImage::where('style', 'style1')->first(); $external_url = ExternalUrl::where('language_id', $language->id)->first(); $contact_info_widget_style1 = ContactInfoWidget::where('language_id', $language->id)->where('style', 'style1')->first(); $menus = Menu::with('submenus') ->where('language_id', $language->id) ->where('status', 'published') ->orderBy('order', 'asc') ->get(); $service_section_paginate_style = ServiceSection::where('language_id', $language->id)->first(); if (isset($service_section_paginate_style)) { $service_limit = $service_section_paginate_style->paginate_item; } $services_paginate_style = Service::join("service_categories",'service_categories.id', '=', 'services.category_id') ->where('service_categories.language_id', $language->id) ->where('style', 'style1') ->where('service_categories.service_category_slug', '=', $category_name) ->where('service_categories.status', 1) ->where('services.status', 'published') ->orderBy('services.id', 'desc') ->paginate($service_limit); $category = ServiceCategory::where('language_id', $language->id) ->where('service_category_slug', '=', $category_name)->first(); if (count($services_paginate_style) < 1) { abort(404); } $service_count_categories = Service::select(DB::raw('count(*) as category_count, category_id')) ->where('language_id', $language->id) ->where('services.status', 'published') ->groupBy('category_id') ->get(); $footer_image_style1 = FooterImage::where('style', 'style1')->first(); $site_info = SiteInfo::where('language_id', $language->id)->first(); $footers = Footer::join("footer_categories", 'footer_categories.id', '=', 'footers.category_id') ->where('footer_categories.language_id', $language->id) ->where('footer_categories.status', 1) ->where('footers.status', 'published') ->orderBy('footers.id', 'asc') ->get(); $footer_categories = FooterCategory::where('language_id', $language->id) ->where('footer_categories.status', 1) ->orderBy('order', 'asc') ->get(); return view('frontend.service.category-index', compact('preloader', 'favicon', 'seo', 'google_analytic', 'tawk_to', 'bottom_button_widget', 'side_button_widget', 'color_option', 'breadcrumb_image', 'font', 'draft_view', 'socials', 'external_url', 'contact_info_widget_style1', 'menus', 'service_count_categories', 'services_paginate_style', 'category', 'header_info_style1', 'header_image_style1', 'footer_image_style1', 'site_info', 'footers', 'footer_categories', 'service_index', 'page_builder')); } }