<?php

namespace App\Http\Controllers\Fo;

use App\Http\Controllers\Controller;
use App\Models\BusinessSector;
use App\Models\Employees;
use App\Models\GeneralConfig;

class OurTradeController extends Controller
{
    /**
     *
     * @return \Illuminate\Contracts\View\View|\Illuminate\Contracts\View\Factory
     */
    public function index()
    {
        $secteurs_simples   = BusinessSector::query()->orderBy('order', 'ASC')
            ->where('parent_id', null)->doesnthave('children')
            ->with('employees')->orderBy('order', 'ASC')->get();
        $secteurs_complexes = BusinessSector::query()->orderBy('order', 'ASC')
            ->where('parent_id', null)->has('children')
            ->with('employees', 'children.employees')->orderBy('order', 'ASC')->get();

        $nine_videos = Employees::query()->select('video', 'photo', 'firstname', 'lastname', 'job_title')
            ->whereNotNull('video')->inRandomOrder()->limit(9)->get();

        $generalConfig = GeneralConfig::current();

        return view('fo.ourtrade', compact('secteurs_simples', 'secteurs_complexes', 'nine_videos', 'generalConfig'));
    }
}