관리-도구
편집 파일: FrontController.php
<?php namespace App\Http\Controllers; use App\Models\Advertisement; use App\Models\Album; use App\Models\AlbumImages; use App\Models\Bullets; use App\Models\ChiarmanInterview; use App\Models\Downloads; use App\Models\IndexMenu; use App\Models\MediaUpdate; use App\Models\Membercategory; use App\Models\MemberPDF; use App\Models\Members; use App\Models\MembershipBenefits; use App\Models\Menu; use App\Models\MissionMessages; use App\Models\News; use App\Models\Partners; use App\Models\PopupNotices; use App\Models\projectVideo; use App\Models\RecentUpdate; use App\Models\ReportAnnual; use App\Models\ReportQuarterly; use App\Models\Setting; use App\Models\Slider; use App\Models\SubCategory; use App\Models\VideoTitle; // use GuzzleHttp\Psr7\Request; use Illuminate\Support\Facades\Storage; use Illuminate\Http\Request; use PHPUnit\Framework\MockObject\Stub\ReturnReference; class FrontController extends Controller { public function index() { $sliders = Slider::latest()->where('is_active', 1)->get(); $first_slider = Slider::latest()->where('is_active', 1)->first(); $news_index = News::latest()->where('news_blogs', 0)->take(4)->get(); $blogs_index = News::where('news_blogs', 0)->orderBy('view_count', 'DESC')->get(); $mission_vision = MissionMessages::first(); $setting = Setting::first(); $members = Members::orderBy('in_order', 'asc')->take(1)->get(); $albumForIndex = Album::latest()->take(7)->get(); $partners = Partners::latest()->take(8)->get(); $popupnotices = PopupNotices::where('status', 1)->get(); $features = Bullets::latest()->take(4)->get(); $member_benefit = MembershipBenefits::first(); $advertisement = Advertisement::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; // new from here $news = News::orderByDesc('created_at')->take(5)->get(); $recentUpdates = RecentUpdate::orderByDesc('created_at')->take(5)->get(); $mediaUpdates = MediaUpdate::orderByDesc('created_at')->take(5)->get(); $downloads = Downloads::orderByDesc('created_at')->take(5)->get(); $projectVideo = projectVideo::orderByDesc('created_at')->first(); $indexMenu = IndexMenu::first(); // return $downloads; $meta = [ 'meta_title' => $setting->meta_title ? $setting->meta_title : $setting->company_name['en'], 'meta_keyword' => $setting->meta_keywords ? $setting->meta_keywords : $setting->company_name['en'], 'meta_description' => $setting->meta_description ? $setting->meta_description : $description, 'meta_keyphrase' => $setting->meta_title ? $setting->meta_title : $setting->company_name['en'], 'og_image' => $setting->og_image ? Storage::disk('uploads')->url($setting->og_image) : Storage::disk('uploads')->url($setting->company_favicon), 'og_url' => route('index'), 'og_site_name' => $setting->company_name['en'], ]; return view('frontend.index', compact('indexMenu', 'projectVideo', 'mediaUpdates', 'downloads', 'recentUpdates', 'meta', 'sliders', 'advertisement', 'popupnotices', 'member_benefit', 'features', 'partners', 'albumForIndex', 'blogs_index', 'members', 'setting', 'mission_vision', 'first_slider', 'news_index')) ->with('news_data',$news); } public function searchItem(Request $request) { $searchNews = News::where('title', 'LIKE', '%'.$request->searchItem.'%')->get(); $searchGelleries = Album::where('album_title', 'LIKE', '%'.$request->searchItem.'%')->get(); $searchVideos = projectVideo::where('title', 'LIKE', '%'.$request->searchItem.'%')->get(); $searchMembers = Members::where('name', 'LIKE', '%'.$request->searchItem.'%')->get(); $searchDownloads = Downloads::where('file_name', 'LIKE', '%'.$request->searchItem.'%')->get(); $data = [ 'news'=> $searchNews, 'albums'=>$searchGelleries, 'videos'=>$searchVideos, 'members'=>$searchMembers, 'downloads'=>$searchDownloads, ]; // return $data; return view('frontend.search', $data); } public function membershipBenefit() { $membershipBenefit = MembershipBenefits::firstorFail(); $data = [ 'membershipBenefit' => $membershipBenefit, ]; return view('frontend.membership', $data); } public function pageSlug($slug) { if ($slug == "home") { return redirect()->route('index'); } if ($slug == "team") { // $members = Members::where('member_id', 18)->get(); // $members = Members::get $members = Members::orderBy('in_order', 'asc')->get(); $memberCategory = Membercategory::where('slug', "team")->first(); // return $memberCategory; $data = [ 'members'=>$members, 'memberCategory'=>$memberCategory ]; return view('frontend.team', $data); } else if($slug == "about" || $slug == "mission") { if($slug=='mission') { $data = Menu::where('category_slug','mission')->first(); $name="mission_vision"; $m=true; } else { $data = Menu::where('category_slug', $slug)->first(); dd($data); $m=false; } $setting = Setting::first(); $mission_vision = MissionMessages::first(); $member_benefit = MembershipBenefits::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $data->meta_title ? $data->meta_title : $data->name['en'], 'meta_keyword' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'meta_description' => $data->meta_description ? $data->meta_description : $description, 'meta_keyphrase' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'og_image' => asset($data->og_image ? $data->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; return view('frontend.aboutus', compact('name','m','data', 'meta', 'setting', 'member_benefit', 'mission_vision')); } else if($slug == "founder-message") { $mission_vision = MissionMessages::first(); $setting = Setting::first(); $about_part = strip_tags(getLangValue($mission_vision->founder_message)); $description = substr($about_part, 0 ,150). ".."; $meta = [ 'meta_title' => 'Founder Message', 'meta_keyword' => $setting->company_name['en'], 'meta_description' => $description, 'meta_keyphrase' => $setting->company_name['en'], 'og_image' => Storage::disk('uploads')->url($setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; $mission_vision = MissionMessages::first(); return view('frontend.message', compact('mission_vision', 'meta')); } else if($slug == "contact") { $data = Menu::where('category_slug', $slug)->first(); $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $data->meta_title ? $data->meta_title : $data->name['en'], 'meta_keyword' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'meta_description' => $data->meta_description ? $data->meta_description : $description, 'meta_keyphrase' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'og_image' => Storage::disk('uploads')->url($data->og_image ? $data->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; return view('frontend.contact', compact('setting', 'meta', 'data')); } else if($slug == "news") { $data = Menu::where('category_slug', $slug)->first(); $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $data->meta_title ? $data->meta_title : $data->name['en'], 'meta_keyword' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'meta_description' => $data->meta_description ? $data->meta_description : $description, 'meta_keyphrase' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'og_image' => Storage::disk('uploads')->url($data->og_image ? $data->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; $news = News::latest()->where('news_blogs', 0)->paginate(6); return view('frontend.news', compact('news', 'meta', 'data')); } elseif ($slug == "media") { $downloads = MediaUpdate::orderByDesc('created_at')->get(); $data = Menu::where('category_slug', $slug)->first(); return view('frontend.mediaList', compact('downloads', 'data')); }elseif ($slug == "chiarman") { $chiarmanInterviews = ChiarmanInterview::orderByDesc('Created_at')->get(); $data = Menu::where('category_slug', $slug)->first(); return view('frontend.chiarman', compact('chiarmanInterviews', 'data')); } else if($slug == "blogs") { $data = Menu::where('category_slug', $slug)->first(); $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $data->meta_title ? $data->meta_title : $data->name['en'], 'meta_keyword' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'meta_description' => $data->meta_description ? $data->meta_description : $description, 'meta_keyphrase' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'og_image' => Storage::disk('uploads')->url($data->og_image ? $data->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; $blogs = News::latest()->where('news_blogs', 1)->paginate(6); return view('frontend.blogs', compact('blogs', 'meta', 'data')); } else if($slug == "message") { $members = Members::orderBy('in_order', 'asc')->take(1)->get(); $mission_vision = MissionMessages::orderByDesc('created_at')->first(); $data = Menu::where('category_slug', $slug)->first(); return view('frontend.messages', compact('members', 'mission_vision', 'data')); } else if($slug == "gallery") { $data = Menu::where('category_slug', $slug)->first(); $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $data->meta_title ? $data->meta_title : $data->name['en'], 'meta_keyword' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'meta_description' => $data->meta_description ? $data->meta_description : $description, 'meta_keyphrase' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'og_image' => Storage::disk('uploads')->url($data->og_image ? $data->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; $albums = Album::latest()->get(); return view('frontend.gallery', compact('albums' , 'meta', 'data')); } else if ($slug == "videos") { $data = Menu::where('category_slug', $slug)->first(); $videoTitle = VideoTitle::orderByDesc('created_at')->first(); $projectVideos = projectVideo::orderByDesc('created_at')->get(); return view('frontend.videos', compact('projectVideos', 'videoTitle', 'data')); } elseif($slug == "quarterly-report") { $meta = Menu::where('category_slug', $slug)->first(); $quarterlyReports = ReportQuarterly::orderByDesc('created_at')->get(); return view('frontend.quarterlyreport', compact('meta', 'quarterlyReports')); } elseif ($slug == "annual-report") { $meta = Menu::where('category_slug', $slug)->first(); $annualReports = ReportAnnual::orderByDesc('created_at')->get(); return view('frontend.annualreport', compact('meta', 'annualReports')); } else if($slug == "downloads") { $data = Menu::where('category_slug', $slug)->first(); $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $data->meta_title ? $data->meta_title : $data->name['en'], 'meta_keyword' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'meta_description' => $data->meta_description ? $data->meta_description : $description, 'meta_keyphrase' => $data->meta_keywords ? $data->meta_keywords : $data->name['en'], 'og_image' => Storage::disk('uploads')->url($data->og_image ? $data->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; $albums = Album::latest()->get(); $downloads = Downloads::latest()->paginate(6); return view('frontend.downloads', compact('downloads', 'meta', 'data')); } elseif ($slug == "recent-update") { $data = Menu::where('slug', $slug)->first(); $recentUpdates = RecentUpdate::orderByDesc('created_at')->get(); return view('frontend.recentupdate', compact('data', 'recentUpdates')); } else { $album = Album::where('title_slug', $slug)->first(); $news = News::where('slug', $slug)->first(); $member_category = Membercategory::where('slug', $slug)->first(); $member_subcategory = SubCategory::where('slug', $slug)->first(); if ($album) { $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $album->meta_title ? $album->meta_title : $album->album_title['en'], 'meta_keyword' => $album->meta_keywords ? $album->meta_keywords : $album->album_title['en'], 'meta_description' => $album->meta_description ? $album->meta_description : $description, 'meta_keyphrase' => $album->meta_keywords ? $album->meta_keywords : $album->album_title['en'], 'og_image' => Storage::disk('uploads')->url($album->og_image ? $album->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; $albums = Album::latest()->get(); $album_images = AlbumImages::latest()->where('album_id', $album->id)->get(); return view('frontend.gallery_details', compact('album', 'album_images', 'meta',)); } else if($news) { $new_view = $news->view_count + 1; $news->update([ 'view_count' => $new_view ]); $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $news->meta_title ? $news->meta_title : $news->title['en'], 'meta_keyword' => $news->meta_keywords ? $news->meta_keywords : $news->title['en'], 'meta_description' => $news->meta_description ? $news->meta_description : $description, 'meta_keyphrase' => $news->meta_keywords ? $news->meta_keywords : $setting->company_name['en'], 'og_image' => Storage::disk('uploads')->url($news->og_image ? $news->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; return view('frontend.news_details', compact('news', 'meta')); } else if($member_category) { $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $member_category->meta_title ? $member_category->meta_title : $member_category->category_name['en'], 'meta_keyword' => $member_category->meta_keywords ? $member_category->meta_keywords : $member_category->category_name['en'], 'meta_description' => $member_category->meta_description ? $member_category->meta_description : $description, 'meta_keyphrase' => $member_category->meta_keywords ? $member_category->meta_keywords : $member_category->category_name['en'], 'og_image' => Storage::disk('uploads')->url($member_category->og_image ? $member_category->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; if($member_category->member_commities == 0) { $members = Members::orderBy('in_order', 'asc')->where('member_id', $member_category->id)->get(); $member_subcategory = null; $memberPDFs = MemberPDF::where('member_id', $member_category->id)->get(); if (count($memberPDFs) > 0) { $data = Menu::where('slug', 'members')->first(); return view('frontend.membersPDF', compact('memberPDFs', 'member_category', 'meta', 'member_subcategory', 'data')); } else { $data = Menu::where('slug', 'committees')->first(); return view('frontend.team_members', compact('members', 'member_category', 'meta', 'member_subcategory', 'data')); } } elseif($member_category->member_commities == 1) { $president = Members::orderBy('in_order', 'asc')->where('commitee_id', $member_category->id)->first(); if($president) { $members = Members::orderBy('in_order', 'asc')->where('commitee_id', $member_category->id)->where('id', '!=', $president->id)->get(); } else { $members = Members::orderBy('in_order', 'asc')->where('commitee_id', $member_category->id)->get(); } $member_subcategory = null; $memberPDFs = MemberPDF::where('committee_id', $member_category->id)->get(); if (count($memberPDFs) > 0) { $data = Menu::where('slug', 'members')->first(); return view('frontend.membersPDF', compact('memberPDFs', 'member_category', 'meta', 'member_subcategory', 'data')); } else { $data = Menu::where('slug', 'committees')->first(); return view('frontend.team_members', compact('members', 'member_category', 'meta', 'member_subcategory', 'president', 'data')); } } } else if($member_subcategory) { $setting = Setting::first(); $about_part = strip_tags(getLangValue($setting->aboutus)); $description = substr($about_part, 0 ,200). ".."; $meta = [ 'meta_title' => $member_subcategory->meta_title ? $member_subcategory->meta_title : $member_subcategory->sub_category_name['en'], 'meta_keyword' => $member_subcategory->meta_keywords ? $member_subcategory->meta_keywords : $member_subcategory->sub_category_name['en'], 'meta_description' => $member_subcategory->meta_description ? $member_subcategory->meta_description : $description, 'meta_keyphrase' => $member_subcategory->meta_keywords ? $member_subcategory->meta_keywords : $member_subcategory->sub_category_name['en'], 'og_image' => Storage::disk('uploads')->url($member_subcategory->og_image ? $member_subcategory->og_image : $setting->company_favicon), 'og_url' => route('pageSlug', $slug), 'og_site_name' => $setting->company_name['en'], ]; if($member_subcategory->category->member_commities == 0) { $members = Members::orderBy('in_order', 'asc')->where('member_subcategory_id', $member_subcategory->id)->get(); $member_category = null; $memberPDFs = MemberPDF::where('member_subcategory_id', $member_subcategory->id)->get(); if (count($memberPDFs) > 0) { $data = Menu::where('slug', 'members')->first(); return view('frontend.membersPDF', compact('memberPDFs', 'member_category', 'meta', 'member_subcategory')); } else { $data = Menu::where('slug', 'committees')->first(); return view('frontend.team_members', compact('members', 'member_subcategory', 'meta', 'member_category')); } } elseif($member_subcategory->category->member_commities == 1) { $commities = Members::orderBy('in_order', 'asc')->where('committee_subcategory_id', $member_subcategory->id)->get(); $member_category = null; $memberPDFs = MemberPDF::where('committee_subcategory_id', $member_subcategory->id)->get(); if (count($memberPDFs) > 0) { $data = Menu::where('slug', 'members')->first(); return view('frontend.membersPDF', compact('memberPDFs', 'member_category', 'meta', 'member_subcategory')); } else { $data = Menu::where('slug', 'committees')->first(); return view('frontend.committee_members', compact('commities', 'member_subcategory', 'meta', 'member_category')); } } } else { abort(404, 'Not Found'); } } } // Recent Changed public function generalPage($slug) { $menuContent = Menu::where('slug', $slug)->firstOrFail(); $data = [ 'menuContent' => $menuContent, ]; return view('frontend.generalPage', $data); } public function chiarmanInterviewDetail($slug) { // return $slug; $chiarmanInterview = ChiarmanInterview::where('slug', $slug)->firstOrFail(); return view('frontend.chiarmanDetail', compact('chiarmanInterview')); } }