File: /var/www/html/sarvodayahospital/app/Http/Controllers/HospitalController.php
<?php
namespace App\Http\Controllers;
use App\Models\CMSPage;
use App\Models\Hospital;
use Artesaos\SEOTools\Facades\OpenGraph;
use Artesaos\SEOTools\Facades\SEOMeta;
use Illuminate\Support\Facades\DB;
class HospitalController extends Controller
{
public function index()
{
$seo = [];
$hospitals = Hospital::query()->orderBy('Weight', 'asc')->get();
$cmsPage = CMSPage::query()
->where('Slug', request()->path())
->firstOrFail();
if ($cmsPage) {
$seo = $cmsPage->seoComponent()->first();
}
return view('pages.hospital', compact('hospitals', 'seo'));
}
public function show($slug)
{
$seo = [];
$hospital = Hospital::query()
->with(['doctors' => function($query) {
$query->take(6);
}, 'specialities' => function($qry) {
$qry->take(6);
}, 'technologies', 'seoComponent'])
->where('Slug', $slug)
->firstOrFail();
if ($hospital) {
$seo = $hospital->seoComponent()->first();
}
return view('pages.single-hospital', compact('hospital', 'seo'));
}
}