public function overview() { $total = Article::count(); $star = Article::where('star_ind', '1')->count(); $read = Article::where('status', 'read')->count(); $unread = $total - $read; return response()->json(compact('total', 'star', 'read', 'unread')); }
public function index() { $article_count = Article::count(); $category_count = Category::count(); $tag_count = Tag::count(); $user_count = User::count(); return view('admin.console', compact('article_count', 'category_count', 'tag_count', 'user_count')); }
public function index() { $userCount = User::count(); $articleCount = Article::count(); $tagCount = Tag::count(); $imageCount = Image::count(); return view('admin.index', compact('userCount', 'articleCount', 'imageCount', 'tagCount')); }
public function index() { $title = "Dashboard"; $article = Article::count(); $articlecategory = ArticleCategory::count(); $users = User::count(); $photo = Photo::count(); $photoalbum = PhotoAlbum::count(); return view('admin.dashboard.index', compact('title', 'article', 'articlecategory', 'photo', 'photoalbum', 'users')); }
private function composeDashboard() { view()->composer('admin.index', function ($view) { $numArticle = \App\Article::count(); $numCategory = \App\Category::count(); $numTag = \App\Tag::count(); $numProject = \App\Project::count(); $numMessage = \App\Message::count(); $view->with(compact('numArticle', 'numCategory', 'numTag', 'numProject', 'numMessage')); }); }
public function index() { $title = "Dashboard"; $news = Article::count(); $newscategory = ArticleCategory::count(); $users = User::count(); $photo = Photo::count(); $photoalbum = PhotoAlbum::count(); $video = Video::count(); $videoalbum = VideoAlbum::count(); return view('backend.dashboard.index', compact('title', 'news', 'newscategory', 'video', 'videoalbum', 'photo', 'photoalbum', 'users')); }
public function Home(Request $request) { $page = (int) ($request->get('p', '1') > 0 ? $request->get('p', '1') : 1); $isPageMax = false; $articles = Article::orderBy('publish_at', 'desc')->orderBy('id', 'desc')->skip(($page - 1) * 10)->take(10)->get(); if (count($articles) == 0 && $page > 1) { $pagemax = ceil(Article::count() / 10); return Redirect::route('adminArticles', array('p' => $pagemax)); } $nextArticles = Article::orderBy('publish_at', 'desc')->orderBy('id', 'desc')->skip($page * 10)->take(1)->get(); if (count($nextArticles) == 0) { $isPageMax = true; } return view('admin.articles.home', compact('page', 'isPageMax', 'articles')); }
public function getFever() { /* Fever API needs strings for category_id and feed_id's */ //static for now $email = 'username'; $pass = '******'; $api_key = md5($email . ':' . $pass); //always return status 1: password and username correct $status = '1'; //latest api version is 3 $arr = ['api_version' => '3', 'auth' => $status]; //last refreshed is current system time $time = ['last_refreshed_on_time' => strtotime('now')]; $arr = array_merge($arr, $time); //when argument is groups, retrieve list with categories and id's if (isset($_GET['groups'])) { $groups = []; $Categories = Category::orderBy('category_order', 'asc')->get(); if (!empty($Categories)) { foreach ($Categories as $Category) { array_push($groups, ['id' => (string) $Category->id, 'title' => $Category->name]); } } $response_arr['groups'] = $groups; $arr = array_merge($arr, $response_arr); } //when argument is feeds, retrieve list with feeds and id's if (isset($_GET['feeds'])) { $feeds = []; $Feeds = Feed::orderBy('feed_name', 'asc')->get(); if (!empty($Feeds)) { foreach ($Feeds as $Feed) { array_push($feeds, ['id' => (int) $Feed->id, 'favicon_id' => (int) $Feed->id, 'title' => $Feed->feed_name, 'url' => $Feed->url, 'site_url' => $Feed->url, 'is_spark' => '0', 'last_updated_on_time' => strtotime($Feed->updated_at)]); } } $response_arr['feeds'] = $feeds; $arr = array_merge($arr, $response_arr); } //when argument is groups or feeds, also return feed id's linked to category id's if (isset($_GET['groups']) || isset($_GET['feeds'])) { $feeds_groups = []; //The array is composed with a group_id and feed_ids containing a string/comma-separated list of positive integers $Categories = Category::orderBy('category_order', 'asc')->get(); if (!empty($Categories)) { foreach ($Categories as $key => $Category) { $feeds_groups[$key]['group_id'] = (int) $Category->id; $Feeds = Category::find($Category->id)->feeds; if (!empty($Feeds)) { $feed_ids = []; foreach ($Feeds as $Feed) { array_push($feed_ids, $Feed->id); } $feeds_groups[$key]['feed_ids'] = implode(',', $feed_ids); } } } $response_arr['feeds_groups'] = $feeds_groups; $arr = array_merge($arr, $response_arr); } //return list with all unread article id's if (isset($_GET['unread_item_ids'])) { $unread_item_ids = []; $Articles = Article::where('status', 'unread')->orderBy('id', 'asc')->get(); if (!empty($Articles)) { foreach ($Articles as $Article) { array_push($unread_item_ids, $Article->id); } } //string/comma-separated list of positive integers instead of array $stack = implode(',', $unread_item_ids); $unreaditems = ['unread_item_ids' => $stack]; $arr = array_merge($arr, $unreaditems); } //return string/comma-separated list with id's from read and starred articles if (isset($_GET['saved_item_ids'])) { $saved_item_ids = []; $Articles = Article::where('star_ind', '1')->orderBy('id', 'asc')->get(); if (!empty($Articles)) { foreach ($Articles as $Article) { array_push($saved_item_ids, $Article->id); } } //string/comma-separated list of positive integers instead of array $stack = implode(',', $saved_item_ids); $saveditems = ['saved_item_ids' => $stack]; $arr = array_merge($arr, $saveditems); } //when argument is items, return 50 articles at a time if (isset($_GET['items'])) { $total_items = []; $total_items['total_items'] = Article::count(); $arr = array_merge($arr, $total_items); $items = []; //request specific items, a maximum of 50 specific items requested by comma-separated argument if (isset($_GET['with_ids'])) { //list with id's is comma-separated, so transform to array $ArrayIds = explode(',', $_REQUEST['with_ids']); //create empty array to store Article results $Articles = []; if (!empty($ArrayIds)) { foreach ($ArrayIds as $ArrayId) { $Article = Article::find($ArrayId); array_push($Articles, $Article); } } //request 50 additional items using the highest id of locally cached items } elseif (isset($_REQUEST['since_id'])) { $Articles = Article::where('id', '>', $_REQUEST['since_id'])->orderBy('id', 'asc')->take(50)->get(); //request 50 previous items using the lowest id of locally cached items } elseif (isset($_REQUEST['max_id'])) { $Articles = Article::where('id', '<', $_REQUEST['max_id'])->orderBy('id', 'asc')->take(50)->get(); //if no argument is given provide total_items and up to 50 items } else { $Articles = Article::take(50)->orderBy('id', 'asc')->get(); } if (!empty($Articles)) { foreach ($Articles as $Article) { array_push($items, ['id' => (int) $Article->id, 'feed_id' => (int) $Article->feed_id, 'title' => $Article->subject, 'author' => $Article->author, 'html' => $Article->content, 'url' => $Article->url, 'is_saved' => (int) $Article->star_ind, 'is_read' => $Article->status == 'read' ? 1 : 0, 'created_on_time' => strtotime($Article->published)]); } } $response_arr['items'] = $items; $arr = array_merge($arr, $response_arr); } //when argument is links, don't return anything at this moment if (isset($_GET['links'])) { $links = []; $response_arr['links'] = $links; $arr = array_merge($arr, $response_arr); } //when argument is groups, retrieve list with categories and id's if (isset($_GET['favicons'])) { $favicons = []; $Feeds = Feed::orderBy('feed_name', 'asc')->get(); if (!empty($Feeds)) { foreach ($Feeds as $Feed) { if (empty($Feed->favicon)) { //TODO: replace with Laravel's URL functionality $faviconurl = (isset($_SERVER['HTTPS']) ? 'https' : 'http') . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $faviconurl = substr($faviconurl, 0, strpos($faviconurl, 'index.php/api')) . 'img/rss-default.png'; } else { $faviconurl = $Feed->favicon; } array_push($favicons, ['id' => (int) $Feed->id, 'title' => $faviconurl]); } $response_arr['favicons'] = $favicons; $arr = array_merge($arr, $response_arr); } } //return fever response return response()->json($arr); }
/** * 获取文章列表 -- ajax * * @param * * @author wen.zhou@bioon.com * * @date 2015-10-25 11:45:44 * * @return */ public function getApiarticlelist() { /*获取参数*/ $draw = request('draw', 1); $start = request('start', 0); $length = request('length', 10); $search = request('search.value', ''); /*获取菜单*/ $obj_article = new Article(); $count = $obj_article->count(); /*搜索*/ if (!empty($search)) { $obj_article = $obj_article::where('name', 'like', '%{$search}%'); } /*条数*/ if ($length != -1) { $obj_article = $obj_article->offset($start)->limit($length); } $result_articles = $obj_article->get(); $articles = $result_articles->toArray(); foreach ($result_articles as $key => $result_article) { $articles[$key]['update'] = $this->current_user->can('update.articles'); $articles[$key]['delete'] = $this->current_user->can('delete.articles'); } $returnData = ["draw" => $draw, "recordsTotal" => $count, "recordsFiltered" => $count, 'data' => $articles]; return response()->json($returnData); }
public function index() { $count = ['articles' => Article::count(), 'registrants' => Registrant::count(), 'users' => User::count(), 'messages' => Message::count()]; return view('admin.dashboard', compact('count')); }
public function panel() { $articles = Article::orderBy('created_at', 'desc')->get(); $count = Article::count(); return view('admin', ['articles' => $articles, 'count' => $count]); }