<?php


namespace Komma\Navigation;
use Illuminate\Support\Facades\DB;


class NavigationRepository {

    /**
     * Load the Facilities for in a menu (Not Used)
     *
     * @return array
     */
    public function facilities(){
        $facilities = DB::table('facilities')
            ->leftJoin('facility_translations', 'facilities.id', '=', 'facility_translations.facility_id')
            ->select([
                'facility_translations.name'
            ])
            ->whereNotNull('facility_translations.name')
            ->get();

        $facilitiesArray=[];

        foreach($facilities as $facility){
            $facilitiesArray[] = $facility->name;
        }
        return $facilitiesArray;
    }


    /**
     * Load the Partners for in a menu (Not Used)
     *
     * @return array
     */
    public function partners(){
        $partners = DB::table('partners')
            ->leftJoin('partner_translations', 'partners.id', '=', 'partner_translations.partner_id')
            ->select([
                'partner_translations.name'
            ])
            ->whereNotNull('partner_translations.name')
            ->get();

        $partnersArray=[];

        foreach($partners as $partner){
            $partnersArray[] = $partner->name;
        }
        return $partnersArray;
    }

}