Closing a CRUD operation

[blondie63]

On my app i've added a Company Selector on Sidebar bottom area using https://cdnjs.com/libraries/select2/4.1.0-rc.0
I've a CompanyCrudController.php to manage selection

Everything works fine but if I change company when a CRUD operation is open it gives me this error:

404
Page not found.
No query results for model [App\Models\CompanySite] 2

Any idea how to avoid this?

[pxpm]

@blondie63 is your sidebar company selector inside a form element itself ? Are you submitting it with ajax or directing the user to the URL ?From the error it seems you are submitting the crud form and not the selector change one.

Cheers

[blondie63]

Hi @pxpm , thanks for your reply !

This my controller:

namespace App\Http\Controllers;

use App\Models\Company;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Session;

class CompanySelectorController extends Controller
{
    public function index(Request $request)
    {
        // Cerca le compagnie che corrispondono alla stringa di ricerca
        $search = $request->input('search');
        $limit = $request->input('limit', 10);
        $companies = [];

        if (backpack_user()->user_level_id === 1) {
            if (empty($search)) {
                // Se la stringa di ricerca è vuota, restituisci le prime 5 aziende
                $companies = Company::take(10)->get();
            } else {
                // Altrimenti, cerca le aziende che corrispondono alla stringa di ricerca
                $companies = Company::where('name', 'like', '%'.$search.'%')->limit($limit)->get();
            }
        } elseif (backpack_user()->user_level_id === 2) {
            $adminCompanies = backpack_user()->allCompanies();
            if ($adminCompanies->count() > 0) {
                if (empty($search)) {
                    $companies = $adminCompanies->take(10)->get();
                } else {
                    // Altrimenti, cerca le aziende che corrispondono alla stringa di ricerca
                    $companies = $adminCompanies->where('name', 'like', '%'.$search.'%')->limit($limit)->get();
                }
            }
        } else {
            $companies = [];
        }

        // Crea un array di risultati per Select2
        $results = [];
        if (count($companies) > 0) {
            foreach ($companies as $company) {
                $results[] = [
                    'id' => $company->id,
                    'name' => $company->name
                ];
            }
        }

        return response()->json($results);
    }

    public function store(Request $request)
    {
        // Gestisci la selezione della compagnia
        $companyId = $request->input('company_id');
        $company = Company::find($companyId);

        if ($company) {
            // Salva l'id dell'azienda nella sessione 'company'
            Session::put('company', $companyId);

            return response()->json(['success' => true]);
        } else {
            return response()->json(['success' => false, 'message' => trans('backpack::base.company_not_found')]); //TODO:
        }
    }
}

And this is my sidebar:

@php
    // Users roles
    const SUPERVISOR_LEVEL = 1;
    const COMPANY_AD_LEVEL = 2;
    const EMPLOYEE_LEVEL = 3;
    const CONSULTANT_LEVEL = 4;
    const REGISTERED_USER_LEVEL = 5;
    
    $company = \App\Models\Company::where('id', \Session::get('company'))->first();
@endphp

@if ((int) backpack_user()->user_level_id === 1)
    <li class="nav-title">{{ trans('backpack::base.user_level') }}</li>
    <li class='nav-item'>
        <a id="supervisor-link" class='nav-link' href="/admin/dashboard">
            <i class='nav-icon la la-eye'></i>{{ trans('backpack::base.supervisor') }}
        </a>
    </li>
    <li class='nav-item'>
        <a id="company-link" class='nav-link' href="/company/dashboard">
            <i class='nav-icon la la-building'></i>{{ trans('backpack::base.company') }}
        </a>
    </li>
@endif

{{-- !!! Supervisor sidebar !!! --}}
@if (Request::route()->getPrefix() === 'admin')
    @if ((int) backpack_user()->user_level_id === SUPERVISOR_LEVEL)
        @include('backpack::inc.role_sidebar.supervisor')

        @includeWhen(class_exists(\Backpack\DevTools\DevToolsServiceProvider::class),
            'backpack.devtools::buttons.sidebar_item')
    @endif
    {{-- !!! End Supervisor !!! --}}

    {{-- !!! Company sidebar !!! --}}
@elseif (Request::route()->getPrefix() === 'company')
    {{-- Supervisor routes --}}
    @if ((int) backpack_user()->user_level_id === SUPERVISOR_LEVEL)
        @include('backpack::inc.role_sidebar.company_supervisor')
    @endif

    {{-- Ad companies routes --}}
    @if ((int) backpack_user()->user_level_id === COMPANY_AD_LEVEL)
        @include('backpack::inc.role_sidebar.company_admin')
    @endif

    {{-- Employee routes --}}
    @if ((int) backpack_user()->user_level_id === EMPLOYEE_LEVEL)
        @include('backpack::inc.role_sidebar.employee')
    @endif

    {{-- Consultant routes --}}
    @if ((int) backpack_user()->user_level_id === CONSULTANT_LEVEL)
        @include('backpack::inc.role_sidebar.consultant')
    @endif

    {{-- Registered User routes --}}
    @if ((int) backpack_user()->user_level_id === REGISTERED_USER_LEVEL)
        @include('backpack::inc.role_sidebar.registered_user')
    @endif

@endif
{{-- !!! End Company !!! --}}

{{-- Company selector --}}
@if ((int) backpack_user()->user_level_id === SUPERVISOR_LEVEL || (int) backpack_user()->user_level_id === COMPANY_AD_LEVEL)
    @if (Request::route()->getPrefix() === 'company')
        <li class="nav-title">{{ trans('backpack::base.select_company') }}</li>
        <li class='nav-item p-2'> <select style="width: 100%" id="company-selector" name="company_id"></select></li>
    @endif
@endif

@push('after_scripts')
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js"></script>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css" rel="stylesheet" />

    <script>
        $(document).ready(function() {
            $('.select2').select2({
                language: '{{ app()->getLocale() }}',
                languagePath: '/packages/select2/dist/js/i18n/'
            });
        });
        document.addEventListener("DOMContentLoaded", function() {
            // Seleziona i link utilizzando gli ID
            const supervisorLink = document.getElementById('supervisor-link');
            const companyLink = document.getElementById('company-link');

            // Mostra il link corretto in base alla URL corrente
            if (window.location.pathname.startsWith('/admin')) {
                if(supervisorLink) supervisorLink.style.display = 'block';
                if(companyLink) companyLink.style.display = 'none';
            } else if (window.location.pathname.startsWith('/company')) {
                if(companyLink) companyLink.style.display = 'block';
                if(supervisorLink) supervisorLink.style.display = 'none';
            }

            // Aggiungi l'evento click ai link
            if(supervisorLink) {
                supervisorLink.addEventListener('click', (event) => {
                    event.preventDefault(); // Impedisce il reindirizzamento predefinito
                    supervisorLink.style.display = 'none'; // Nascondi il link del supervisore
                    if(companyLink) companyLink.style.display = 'block'; // Mostra il link della compagnia
                    window.location.href = "/company/dashboard"; // Reindirizza alla nuova URL
                });
            }

            if(companyLink) {
                companyLink.addEventListener('click', (event) => {
                    event.preventDefault(); // Impedisce il reindirizzamento predefinito
                    companyLink.style.display = 'none'; // Nascondi il link della compagnia
                    if(supervisorLink) supervisorLink.style.display = 'block'; // Mostra il link del supervisore
                    window.location.href = "/"; // Reindirizza alla nuova URL
                });
            }
        });
    </script>
@endpush

What you think ?

[pxpm]

 $(document).ready(function() {
            $('.select2').select2({
                language: '{{ app()->getLocale() }}',
                languagePath: '/packages/select2/dist/js/i18n/'
            });
        });

This is the culprit for the reported issue with other select2 on page.
You can't target the select2 using the .select2 class that's used by all other select2.
You can add another class .company-selector and use it to create the select2.

Cheers

[jcastroa87]

Due to no activity, I will close this issue, but please feel free to re-open or create a new one if needed.

Cheers.