public function loadCategory()
{
$categories = Category::all();
$articles = Article::all();
// link the category id and the its related articles
$articlesNumber = [];
foreach ($categories as $category) {
if (CategoriesController::getArticleNumber($category->id) != null) {
$articlesNumber[$category->id] = CategoriesController::getArticleNumber($category->id)[0]->article_number;
} else {
$articlesNumber[$category->id] = '0';
}
}
if (User::getCurrentUser() != null) {
$is_manager = User::getCurrentUser()->is_manager;
} else {
$is_manager = false;
}
return compact('categories', 'articles', 'articlesNumber', 'images', 'is_manager');
}
/**
* @param $id
* @return array
*/
public function loadCategoryWithId($id)
{
$categories = Category::all();
$category_list = Category::lists('name', 'id');
$article = Article::findOrFail($id);
$top_list_articles = Article::where('is_top', '=', 2)->get();
// link the category id and the its related articles
$articlesNumber = [];
foreach ($categories as $category) {
if (CategoriesController::getArticleNumber($category->id) != null) {
$articlesNumber[$category->id] = CategoriesController::getArticleNumber($category->id)[0]->article_number;
} else {
$articlesNumber[$category->id] = '0';
}
}
if (User::getCurrentUser() != null) {
$is_manager = User::getCurrentUser()->is_manager;
} else {
$is_manager = false;
}
//find image path
$images = HomeImage::where('article_id', '=', $id)->get();
$comments = CommentsController::show($id);
return compact('categories', 'category_list', 'article', 'top_list_articles', 'articlesNumber', 'is_manager', 'images', 'comments');
}
public function loadCategory()
{
$categories = Category::all();
$favorites_list = DB::table('favorite_articles')->join('articles', 'articles.id', '=', 'favorite_articles.article_id')->where('favorite_articles.user_id', '=', Auth::user()->id)->select('favorite_articles.*', 'articles.title')->get();
// link the category id and the its related articles
$articlesNumber = [];
foreach ($categories as $category) {
if (CategoriesController::getArticleNumber($category->id) != null) {
$articlesNumber[$category->id] = CategoriesController::getArticleNumber($category->id)[0]->article_number;
} else {
$articlesNumber[$category->id] = '0';
}
}
$is_manager = User::getCurrentUser()->is_manager;
return compact('categories', 'favorites_list', 'articlesNumber', 'is_manager');
}
