public static function getTranslationPublishArticles($parameters) { return Article::builder()->where('lang_id_355', $parameters['lang'])->where('publish_355', '<', date('U'))->where('status_id_355', 1)->orderBy('sorting_355')->orderBy('date_355', 'desc')->get(); }
public function apiCheckSlug() { $slug = $this->request->input('slug'); $query = Article::where('lang_id_355', $this->request->input('lang'))->where('slug_355', $slug); if ($this->request->input('id')) { $query->whereNotIn('id_355', [$this->request->input('id')]); } $nObjects = $query->count(); if ($nObjects > 0) { $suffix = 0; while ($nObjects > 0) { $suffix++; $slug = $this->request->input('slug') . '-' . $suffix; $nObjects = Article::where('lang_id_355', $this->request->input('lang'))->where('slug_355', $slug)->count(); } } return response()->json(['status' => 'success', 'slug' => $slug]); }