Sid Gifari File Manager Pro v10.0.3

✏️ Editing: FrontendCompanyPageController.php Writable

<?php

namespace App\Http\Controllers\Frontend;

use App\Models\City;
use App\Models\State;
use App\Models\Company;
use App\Models\Country;
use App\Models\IndustryType;
use Illuminate\Http\Request;
use App\Models\OrganizationType;
use App\Http\Controllers\Controller;

class FrontendCompanyPageController extends Controller
{
  function index(Request $request) {
    $countries = Country::all();
    $selectedStates = null;
    $selectedCities = null;

$query = Company::query();
    $query->where(['profile_completion'=>1, 'visibility'=>1]);
    if($request->has('search') && $request->filled('search')) {
      $query->where('name', 'like', '%'.$request->search.'%');
    }
    if($request->has('country') && $request->filled('country')) {
      $query->where('country', 'like', '%'.$request->country.'%');
      $selectedStates = State::where('country_id', $request->country)->get();
    }
    if($request->has('state') && $request->filled('state')) {
      $query->where('state', 'like', '%'.$request->state.'%');
      $selectedCities = City::where('state_id', $request->state)->get();
    }
    if($request->has('city') && $request->filled('city')) {
      $query->where('city', 'like', '%'.$request->city.'%');
    }
    if($request->has('industry') && $request->filled('industry')) {
      $query->whereHas('industryType', function($qry) use($request) {
        $qry->where('slug', $request->industry);
      });
    }

$companies = $query->paginate(21); //get();
    $industryTypes = IndustryType::withCount('companies')->get();
    $organizations = OrganizationType::all();

return view('frontend.pages.company-index', compact('companies','countries','selectedStates','selectedCities','industryTypes','organizations'));
  }

function show(string $slug) {
    $company = Company::where(['profile_completion'=>1, 'visibility'=>1, 'slug' => $slug])->firstOrFail();
    return view('frontend.pages.company-details', compact('company'));
  }
}

📁 File Manager Pro

📁 File Manager Pro