/**
* 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'));
}
/**
* @return \yii\db\ActiveQuery
*/
public function getLanguage()
{
return $this->hasOne(SiteLanguages::className(), ['language_id' => 'language_id']);
}
