<?php

namespace App\Modules\Company;

use App\Models\Experience;
use App\Models\Expertise;
use App\Models\WorkAreas;
use App\Models\Access;
use App\Models\Role;

class FormData {
    public function expertises()
    {
        $expertises = Expertise::select(
            'expertises.id',
            'expertises.name')
            ->orderBy('name', 'asc')
            ->get();
        return response()->json($expertises);
    }

    public function experiences()
    {
        $experiences = Experience::select(
            'experiences.id',
            'experiences.name')
            ->orderBy('name', 'asc')
            ->get();
        return response()->json($experiences);
    }

    public function areas_of_work()
    {
        $work_areas = WorkAreas::select(
            'work_areas.id',
            'work_areas.name')
            ->orderBy('name', 'asc')
            ->get();
        return response()->json($work_areas);
    }

    public function roles()
    {
        $roles = Role::select(
            'roles.id',
            'roles.name')
            ->whereNotIn('roles.id', [6]) // 6 = Job Seeker
            ->with('access:role_id,page')
            ->get();
        return response()->json($roles);
    }

    public function access()
    {
        $access = Access::select(
            'access.id',
            'access.page')
            ->get();
        return response()->json($access);
    }
}