Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/mcoil.corals.io/app/Providers/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace App\Providers;

use Illuminate\Pagination\Paginator;
use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\View;
use App\Shop\Counties\County;
use App\Shop\Products\Product;
use App\Shop\FillTanks\FillTank;
use App\Shop\ContactInfos\ContactInfo;
use App\Shop\TextBoxes\TextBox;
use Illuminate\Support\Facades\DB;
use App\Shop\GDPR\gdpr;
use App\Shop\GDPR\CookieListOption;
use App\Shop\GDPR\gdprButton;
use App\Shop\GDPR\CookieList;

class AppServiceProvider extends ServiceProvider {
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot() {
        Paginator::useBootstrap();
        Schema::defaultStringLength(191);
        $frontTopMenu = \App\Shop\MenuBars\MenuBar::where('type_menu', 'Top Menu')->where('status','active')->where('parent','Yes')->orderBy('position', 'ASC')->get(); 
        View::share('menu_name', $frontTopMenu);
		$frontFooterMenu = \App\Shop\MenuBars\MenuBar::where('type_menu', 'Footer Menu')->where('status','active')->where('parent','Yes')->orderBy('position', 'ASC')->get(); 
        View::share('footer_menu_name', $frontFooterMenu);
        $frontFooterMenuBottom = \App\Shop\MenuBars\MenuBar::where('type_menu', 'Footer Menu Bottom')->where('status','active')->where('parent','Yes')->orderBy('position', 'ASC')->get(); 
        View::share('footer_menu_bottom_name', $frontFooterMenuBottom);
        // Fetch the list of category navigation
        $frontCategoriesTopMenus = \App\Shop\MenuBars\MenuBar::where('type_menu', 'Product Categories Menu')->where('status','active')->where('parent','Yes')->orderBy('position', 'ASC')->get();
        View::share('frontCategoriesTopMenus', $frontCategoriesTopMenus);
        // Fetch the cookies popup
        $frontCookiesPopup = \App\Shop\MenuBars\MenuBar::where('type_menu', 'Cookies Popup Menu')->where('status','active')->where('parent','Yes')->orderBy('position', 'ASC')->get();
        View::share('front_cookies_popup_menu', $frontCookiesPopup);
        // Website settings (logo, favicon etc)
        $website_setting = DB::table('website_settings')->first();
        View::share('website_setting' , $website_setting);
        /// Sharing the county list in all views for quote form
        $county_list = County::orderBy('name', 'asc')->get();
        View::share('county_list',$county_list);
        /// Sharing the product list in all views for quote form
        $product_list = Product::where('status',1)->where('oil_type_status',1)->where('display_in_frontend',1)->orderBy('name', 'asc')->get();
        View::share('product_list',$product_list);
        $fill_tank_data = FillTank::find(1);
        if (!empty($fill_tank_data->price)) {
            View::share('fill_the_tank_price_admin',$fill_tank_data->price);
        }
		// Get the contact info
        $contact_info = ContactInfo::find(2);
        View::share('contact_info', $contact_info);
        // Fetch the botton buttons information
        $buttons = DB::table('buttons')->whereIn('id', [1, 2])->get();
        View::share('buttons', $buttons);
        // Get the textbox which will show text for - Prefer to talk to us directly? section
       	$callToActionTextBox = TextBox::find(20);
       	View::share('callToActionTextBox', $callToActionTextBox);
       	/* Website appearance details */
       	$websiteAppearanceDetails = DB::table('website_appearance_section as t1')
       	    ->join('website_appearance as t2', 't1.id', '=', 'section')
       		->pluck('t2.value', 't1.section_slug')
       		->all();
       	View::share('websiteAppearanceDetails', $websiteAppearanceDetails);
       	$shop_products = Product::where('status',1)->where('oil_type_status',2)->orderBy('name', 'asc')->get();
        View::share('shop_product_list',$shop_products);
        
        $cookiePopup = gdpr::first();
        View::share('cookiePopup' , $cookiePopup);
        $euContries = DB::table("eu_countries")->pluck('iso')->toArray();
        View::share('euContries' , $euContries);
        
        $cookieButtonAccept = gdprButton::where("button_type", "0")->first();
        $cookieButtonDecline = gdprButton::where("button_type", "1")->first();
        $cookieButtonSetting = gdprButton::where("button_type", "2")->first();
        $cookieButtonReadmore = gdprButton::where("button_type", "3")->first();
        View::share('cookieButtonAccept' , $cookieButtonAccept);
        View::share('cookieButtonDecline' , $cookieButtonDecline);
        View::share('cookieButtonSetting' , $cookieButtonSetting);
        View::share('cookieButtonReadmore' , $cookieButtonReadmore);
        
        $cookieListOption = CookieListOption::orderBy('sort_position','ASC')->groupBy("cookie_category")->get();
        View::share('cookieListOption' , $cookieListOption);
        
        $cookieListMain = CookieList::first();
        View::share('cookieListMain' , $cookieListMain);
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register() {
    }
}