/** * Show the form for editing the specified pages. * * @param int $id * @return \Illuminate\View\View */ public function edit($id) { $pages = Pages::find($id); $sitelanguages = SiteLanguages::site_access()->join('sites', function ($join) { $join->on('sites.id', '=', 'sitelanguages.sites_id'); })->join('languages', 'languages.id', '=', 'sitelanguages.languages_id')->select('sitelanguages.id', \DB::raw(' CONCAT(sites.title, \'-\',languages.code) as site_language'))->get()->lists('site_language', 'id'); $category = Category::site_access()->join('sitelanguages', 'sitelanguages.id', '=', 'category.sitelanguages_id')->join('languages', 'languages.id', '=', 'sitelanguages.languages_id')->join('sites', 'sites.id', '=', 'sitelanguages.sites_id')->select('category.id', 'category.title')->get()->lists('title', 'id')->prepend('Please select', ''); return view('admin.pages.edit', compact('pages', 'sitelanguages', 'category')); }
/** * Get the validation rules that apply to the request. * * @return array */ public function rules() { if (isset(\Auth::user()->site_id)) { $sites_ids = SiteLanguages::site_access()->select(\DB::raw(' GROUP_CONCAT(id) as sites_ids'))->groupBy('sites_id')->get(); $site_access = 'in:' . $sites_ids[0]->sites_ids; } else { $site_access = ''; } return ['title' => 'required', 'slug' => 'required', 'text' => 'required', 'sitelanguages_id' => 'required|' . $site_access, 'meta_keywords' => 'required', 'meta_description' => 'required']; }
/** * Get the validation rules that apply to the request. * * @return array */ public function rules() { /** * check security in frontend site language for any users * * @return string */ if (isset(\Auth::user()->site_id)) { $sites_ids = SiteLanguages::site_access()->select(\DB::raw(' GROUP_CONCAT(id) as sites_ids'))->groupBy('sites_id')->get(); $site_access = 'in:' . $sites_ids[0]->sites_ids; } else { $site_access = ''; } return ['sitelanguages_id' => 'required|' . $site_access, 'slug' => 'required|unique:news,slug', 'text' => 'required', 'meta_keywords' => 'required']; }
/** * Show the form for editing the specified footermenus. * * @param int $id * @return \Illuminate\View\View */ public function edit($id) { $footermenus = FooterMenus::find($id); $sitelanguages = SiteLanguages::site_access()->join('sites', 'sites.id', '=', 'sitelanguages.sites_id')->join('languages', 'languages.id', '=', 'sitelanguages.languages_id')->select('sitelanguages.id', \DB::raw(' CONCAT(sites.title, \'-\',languages.code) as site_language'))->get()->lists('site_language', 'id'); return view('admin.footermenus.edit', compact('footermenus', 'sitelanguages')); }