@php use Plugin\CulturePlugin\Models\CultureCategory; use Plugin\DevelopmentPlugin\Models\Development; use Plugin\NewPlugin\Models\NewCategory; use Plugin\ProjectPlugin\Models\ProjectCategory; use Plugin\ServiceDepartmentPlugin\Models\ServiceDepartment; $developments = Development::where('publish_status', 1)->orderBy('ordering', 'asc')->get(); $culture_categories = CultureCategory::select('plugin_cultures_categories.*') ->join('plugin_cultures', 'plugin_cultures.category_id', '=', 'plugin_cultures_categories.id') ->where('plugin_cultures_categories.publish_status', 1) ->where('plugin_cultures.publish_status', 1) ->orderBy('plugin_cultures_categories.ordering', 'asc') ->distinct() ->get(); $project_categories = ProjectCategory::select('plugin_projects_categories.*') ->join('plugin_projects', 'plugin_projects.category_id', '=', 'plugin_projects_categories.id') ->where('plugin_projects_categories.publish_status', 1) ->where('plugin_projects.publish_status', 1) ->orderBy('plugin_projects_categories.ordering', 'asc') ->distinct() ->get(); $services = ServiceDepartment::where('publish_status', 1)->get(); $news_categories = NewCategory::select('plugin_news_categories.*') ->join('plugin_news', 'plugin_news.category_id', '=', 'plugin_news_categories.id') ->where('plugin_news_categories.publish_status', 1) ->where('plugin_news.publish_status', 1) ->orderBy('plugin_news_categories.ordering', 'asc') ->distinct() ->get(); $front_locale = getFrontLocale(); @endphp