function detail($title_none = NULL)
{
$cat_news_url = $this->uri->segment(1);
$cat_news = new Newscatalogue();
$cat_news->where(array('name_none' => $cat_news_url))->get();
if (!$cat_news->exists()) {
show_404();
}
$dis['cat_news'] = $cat_news;
$cat = $this->uri->segment(2);
$category = new Newscatalogue();
$category->where(array('name_none' => $cat, 'parentcat_id' => $cat_news->id))->get();
if (!$category->exists()) {
show_404();
}
$dis['category'] = $category;
$title_none = geturlfromuri($this->uri->segment(3));
$news = new Article();
$news->where(array('title_none' => $title_none, 'newscatalogue_id' => $category->id));
$news->get();
if (!$news->exists()) {
redirect(base_url() . $this->uri->segment(1, '') . '/' . $this->uri->segment(2, ''));
die;
}
$dis['news'] = $news;
$tag = $news->tag;
$dis['tag'] = explode(',', $tag);
$news->view_count = $news->view_count + 1;
$news->save();
//related news
$related_news = new Article();
$related_news->where('recycle', 0);
$related_news->where('newscatalogue_id', $news->newscatalogue_id);
$related_news->where("id !=", $news->id);
$related_news->order_by('created', 'DESC');
$related_news->get_paged(0, 15, TRUE);
$dis['related_news'] = $related_news;
$arrayCateNewsId = array();
foreach ($this->guideCate as $row) {
$arrayCateNewsId[] = $row->id;
}
$arrayCateNewsId = array();
foreach ($this->guideCate as $row) {
$arrayCateNewsId[] = $row->id;
}
// get news view most
$newViewMost = new Article();
$newViewMost->where('recycle', 0);
$newViewMost->where_in('newscatalogue_id', $arrayCateNewsId);
$newViewMost->order_by('view_count', 'desc');
$newViewMost->get(5);
$dis['newViewMost'] = $newViewMost;
// get news view most
$newView = new Article();
$newView->where('recycle', 0);
$newView->where_in('newscatalogue_id', $arrayCateNewsId);
$newView->order_by('created', 'desc');
$newView->get(5);
$dis['newView'] = $newView;
$this->page_title = $news->{'title_vietnamese'} . ' | SotayNhadat.vn';
$this->page_description = $news->short_vietnamese;
$this->page_keyword = $news->tag;
$this->url = base_url() . substr($this->uri->uri_string, 1, strlen($this->uri->uri_string));
$this->isRobotFollow = 1;
$dis['base_url'] = base_url();
$dis['view'] = 'front/guides/news_de';
$this->viewfront($dis);
}
function detail($title_none = NULL)
{
$title_none = $this->uri->segment(3);
$arrTitle = explode('.', $title_none);
if ($arrTitle[1] == '' || $arrTitle[1] != 'html') {
redirect('');
}
$title_none = $arrTitle[0];
$news = new Article();
$news->where('title_none', $title_none);
$news->get();
//print_r($this->db->last_query());exit();
if (!$news->exists()) {
show_404();
}
$dis['news'] = $news;
//related news
$related_news = new Article();
$related_news->where('recycle', 0);
$related_news->where('newscatalogue_id', $news->newscatalogue_id);
$related_news->where("id !=", $news->id);
$related_news->order_by('created', 'DESC');
$related_news->get_paged(0, 10, TRUE);
$dis['related_news'] = $related_news;
$category = new Newscatalogue($news->newscatalogue_id);
$dis['category'] = $category;
$this->page_title = $news->{'title_vietnamese'};
$this->page_description = $news->short_vietnamese;
$this->page_keyword = $news->tag;
$dis['base_url'] = base_url();
$dis['link'] = base_url() . $_SERVER['REQUEST_URI'];
$dis['view'] = 'front/services/news_de';
$this->viewfront($dis);
}
function detail($url)
{
$urlcat = $this->uri->segment(1);
$category = new Newscatalogue();
$category->where(array('recycle' => 0, 'name_none' => $urlcat))->get();
if (!$category->exists()) {
show_404();
}
$dis['category'] = $category;
$url = geturlfromuri($this->uri->segment(2));
$news = new Article();
$news->where(array('title_none' => $url, 'recycle' => 0));
$news->get();
if (!$news->exists()) {
show_404();
}
$dis['news'] = $news;
$this->page_title = $news->title_vietnamese;
$this->page_description = $news->short_vietnamese;
$this->page_keyword = $news->tag;
//related news
$related_news = new Article();
$related_news->where('recycle', 0);
$related_news->where('newscatalogue_id', $news->newscatalogue_id);
$related_news->where("id !=", $news->id);
$related_news->order_by('created', 'DESC');
$related_news->get_paged(0, 10, TRUE);
$dis['related_news'] = $related_news;
$dis['base_url'] = base_url();
$dis['view'] = 'front/newsother/news_de';
$this->viewfront($dis);
}
function getNewsByCategory($categoryID)
{
$CI =& get_instance();
$cat_news = new Article();
$cat_news->where(array('recycle' => 0));
$cat_news->where('newscatalogue_id', $categoryID);
$cat_news->order_by('created', 'desc');
$cat_news->get(4);
return $cat_news;
}
/**
* Show article
* @param string $slug Article abbreviated name
* @return response
*/
public function show($slug)
{
$article = Article::where('slug', $slug)->where('post_status', 'open')->first();
is_null($article) and App::abort(404);
$categories = Category::orderBy('sort_order')->get();
return View::make('article.show')->with(compact('article', 'categories'));
}
/**
* 提交评论
* @param string $slug 文章缩略名
* @return response
*/
public function postBlogComment($slug)
{
// 获取评论内容
$content = e(Input::get('content'));
// 字数检查
if (mb_strlen($content) < 3) {
return Redirect::back()->withInput()->withErrors($this->messages->add('content', '评论不得少于3个字符。'));
}
// 查找对应文章
$article = Article::where('slug', $slug)->first();
// 创建文章评论
$comment = new Comment();
$comment->content = $content;
$comment->article_id = $article->id;
$comment->user_id = Auth::user()->id;
if ($comment->save()) {
// 创建成功
// 更新评论数
$article->comments_count = $article->comments->count();
$article->save();
// 返回成功信息
return Redirect::back()->with('success', '评论成功。');
} else {
// 创建失败
return Redirect::back()->withInput()->with('error', '评论失败。');
}
}
public function getIndex($page = 1)
{
$newses = \Article::where('status', '=', '1')->where('category', '=', '3')->where('open_at', '<=', date('Y-m-d'))->orderBy('sort', 'desc')->orderBy('created_at', 'desc')->skip(0)->take(10)->get(array('id', 'title', 'open_at'));
if ($newses === null) {
$newses = array();
}
return \View::make('aesthetics.index.index', array('newses' => &$newses));
}
public static function boot()
{
parent::boot();
//删除时先删除相关文档、单页
self::deleting(function (User $user) {
Article::where('uid', '=', $user->id)->delete();
Page::where('uid', '=', $user->id)->delete();
});
}
public function get_index($authorname)
{
$user = User::where('username', '=', $authorname)->first();
//get the article limit size
$articles = Article::where('author_id', '=', $user->id)->paginate(Setting::find(2)->value);
$dbquery = $articles;
$articles = cmsHelper::bakeArticleForViewers($articles->results);
return View::make('visitor.index', array("articles" => $articles, 'dbquery' => $dbquery, 'message' => 'Showing all articles by ' . $user->displayname));
}
public function searcharticles(Request $request)
{
if ($request->ajax()) {
if ($request->has('articlestat')) {
$searcharticles = Article::where('stat', '=', $request->input('articlestat'))->get();
$scontent = view(athr . '.searcharticles', ['allarticles' => $searcharticles])->render();
return response()->json($scontent);
}
}
}
function article_unique_title($str)
{
$this->form_validation->set_message('article_unique_title', 'Es existier bereits ein Artikel mit diesem Titel.');
$article = new Article();
$article->where('title', $str)->get();
if ($article->exists()) {
return FALSE;
}
return TRUE;
}
function index($category_id = FALSE)
{
$articles = new Article();
if ($category_id) {
$category = new Category($category_id);
$articles->where("category_id in (select id from categories where lft >= " . $category->lft . " and rgt <= " . $category->rgt . " and module = '" . $category->module . "')");
}
$data['articles'] = $articles->order_by('id', 'desc')->get_page(limit());
$this->template->append_metadata(js_lightbox());
$this->template->build('admin/article_index', $data);
}
public function getIndex()
{
$boards = \Board::where('status', '=', '1')->orderBy('created_at', 'desc')->skip(0)->take(10)->get(array('id', 'name', 'topic', 'count_num', \DB::raw("date_format(created_at,'%Y-%m-%d') as d")));
if ($boards === null) {
$boards = array();
}
$newses = \Article::where('status', '=', '1')->where('category', '=', '3')->where('open_at', '<=', date('Y-m-d'))->orderBy('sort', 'desc')->orderBy('open_at', 'desc')->orderBy('created_at', 'desc')->skip(0)->take(10)->get(array('id', 'title', 'open_at'));
if ($newses === null) {
$newses = array();
}
return \View::make('aesthetics.index.index', array('boards' => &$boards, 'newses' => &$newses));
}
public function post_view()
{
$deletedIds = Input::get('delete');
$search = Input::get('search');
$i = 0;
if (isset($deletedIds)) {
foreach ($deletedIds as $delete) {
Article::where('id', '=', $delete)->first()->delete() && ++$i;
}
return Redirect::to('/admin/articles/view')->with('message', $i . " article(s) deleted");
}
if (strlen($search) > 1) {
return Redirect::to('/admin/articles/view?filterby=search&value=' . $search);
}
Input::flush();
return Redirect::to('/admin/articles/view')->with('message', ' [no action performed]');
}
/**
* Return a string with the feed data
*
* @return string
*/
protected function buildRssData()
{
$now = Carbon::now();
$feed = new Feed();
$channel = new Channel();
$channel->title(config('blog.title'))->description(config('blog.description'))->url(url())->language('en')->copyright('Copyright (c) ' . config('blog.author'))->lastBuildDate($now->timestamp)->appendTo($feed);
$articles = Article::where('published_date', '<=', $now)->orderBy('published_date', 'desc')->take(config('blog.rss_size'))->get();
foreach ($articles as $article) {
$item = new Item();
$item->title($article->title)->tumnail_url($article->thumnail_url)->url($article->url())->pubDate($article->published_date->timestamp)->guid($article->url(), true)->appendTo($channel);
}
$feed = (string) $feed;
// Replace a couple items to make the feed more compliant
$feed = str_replace('<rss version="2.0">', '<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">', $feed);
$feed = str_replace('<channel>', '<channel>' . "\n" . ' <atom:link href="' . url('/rss') . '" rel="self" type="application/rss+xml" />', $feed);
return $feed;
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($full_permalink, $id)
{
$article = Article::where('full_permalink', '=', $full_permalink)->firstOrFail();
$image = ArticleImage::findOrFail($id);
$data = \Input::all();
$data['blog_article_id'] = $article->id;
$data['featured'] = \Input::has('featured') ? true : false;
$data['active'] = \Input::has('active') ? true : false;
$validator = \Validator::make($data, $this->rules);
if ($validator->fails()) {
return \Redirect::back()->withErrors($validator)->withInput();
}
if ($image->update($data)) {
$data = ['article' => $article, 'image' => $image];
return \View::make('blog::partials.image', $data);
}
}
public function showWelcome()
{
$gethealth = Category::where('category', 'Health')->first()->id;
$getEntertainment = Category::where('category', 'Entertainment')->first()->id;
$entertainmentArticles = Article::where('category_id', $getEntertainment)->orderBy('created_at', 'DESC')->get();
$healthArticles = Article::where('category_id', $gethealth)->orderBy('created_at', 'DESC')->get();
$getlifstyle = Category::where('category', 'Lifestyle')->first()->id;
$latestArticles = Article::orderBy('created_at', 'DESC')->take(10)->get();
$articles = Article::where('category_id', $getlifstyle)->orderBy('created_at', 'DESC')->take(10)->get();
$entertainmentHeader = $entertainmentArticles->take(1);
$eArticles = $entertainmentArticles->take(4)->slice(1);
$slides = $latestArticles->take(4);
$related = $articles->take(2);
$small = $articles->slice(2)->take(6);
$gethealthArticle = $healthArticles->take(1);
$smallHealthArticles = $healthArticles->take(4)->slice(1);
return View::make('home')->with('slides', $slides)->with('latestArticles', $latestArticles)->with('related', $related)->with('articles', $articles)->with('small', $small)->with('gethealthArticle', $gethealthArticle)->with('smallHealthArticles', $smallHealthArticles)->with('entertainmentHeader', $entertainmentHeader)->with('eArticles', $eArticles);
}
public function joinArticle()
{
if (!Sentry::check()) {
return Response::json(array('errCode' => 10, 'message' => '请登录'));
}
$user = Sentry::getUser();
// $user = User::find(1);
//分页
$per_page = Input::get('per_page');
$page = Input::get('page');
$article_joins = ArticleJoin::where('user_id', '=', $user->id)->orderBy('created_at', 'desc')->get();
//总页数
$total = ceil(count($article_joins) / $per_page);
//参与话题
$article_joins = StaticController::page($per_page, $page, $article_joins);
if ($article_joins == false) {
return Response::json(array('errCode' => 0, 'message' => '没有参与话题', 'articles' => array(), 'total' => 0));
}
//根据用户参与的话题取到官方话题
$articles = array();
foreach ($article_joins as $article_join) {
$article = Article::where('id', '=', $article_join->article_id)->first();
array_push($articles, $article);
}
//去掉重复值
array_unique($articles);
//取到每个话题的图片和首段文字
foreach ($articles as $article) {
$article_url = ArticlePart::where('article_id', '=', $article->id)->where('type', '=', 'url')->orderBy('id', 'asc')->first();
if (isset($article_url)) {
$article->img = StaticController::imageWH($article_url->content);
}
$article_text = ArticlePart::where('article_id', '=', $article->id)->where('type', '=', 'text')->orderBy('id', 'asc')->first();
if (isset($article_text)) {
$article->content = $article_text->content;
}
}
return Response::json(array('errCode' => 0, 'message' => '返回参与话题的内容！', 'articles' => $articles, 'total' => $total));
}
public function hotArticle()
{
$per_page = Input::get('per_page');
$page = Input::get('page');
$time = time();
$articles = Article::where('hot_offical', '!=', 0)->orderBy('focus_num', 'desc')->with(['parts' => function ($query) {
$query->orderBy('created_at', 'asc');
}])->get();
if (count($articles) == 0) {
return Response::json(array('errCode' => 0, 'message' => '返回热门话题', 'articles' => array(), 'total' => 0));
}
// dd(count($articles));
foreach ($articles as $article) {
$parts = $article->parts;
foreach ($parts as $part) {
if ($part->type == 'text') {
$article->text = $part->content;
}
if (isset($article->text)) {
break;
}
}
foreach ($parts as $part) {
if ($part->type == 'url') {
// dd($part->content);
$article->img = StaticController::imageWH($part->content);
}
if (isset($article->img)) {
break;
}
}
unset($article->parts);
}
//总页数
$total = ceil(count($articles) / $per_page);
//文章
$articles = StaticController::page($per_page, $page, $articles);
return Response::json(array('errCode' => 0, 'message' => '返回热门话题', 'articles' => $articles, 'total' => $total));
// $time = time();
// $articles = DB::table('articles')->where('hot_offical','!=',0)->orderBy('focus_num', 'desc')->get();
// // 总页数
// $total = ceil(count($articles)/$per_page);
// //文章
// $articles = StaticController::page($per_page, $page, $articles);
// if( $articles )
// { foreach( $articles as $article)
// {
// $article_url = ArticlePart::where('article_id', '=', $article->id)
// ->where('type','=', 'url')->first();
// if(isset($article_url))
// {
// $article->img = StaticController::imageWH($article_url->content);
// }
// $article_text = ArticlePart::where('article_id', '=', $article->id)
// ->where('type','=', 'text')->first();
// if(isset($article_text))
// {
// $article->text = $article_text->content;
// }
// }
// // return Response::json(array('errCode'=>(time()-$time), 'message'=>'返回热门话题','articles'=>$articles,'total'=>$total));
// }
// return Response::json(array('errCode'=>(time()-$time), 'message'=>'返回热门话题','articles'=>$articles,'total'=>$total));
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($full_permalink)
{
$category = Category::where('full_permalink', '=', $full_permalink)->firstOrFail();
$data = \Input::all();
$data['active'] = \Input::has('active') ? true : false;
$rules = $this->rules;
if ($category->permalink == 'articles') {
unset($rules['permalink']);
} else {
$rules['blog_category_id'] = 'required|not_in:' . $category->id;
$rules['permalink'] = 'required|unique:blog_categories,permalink,' . $category->id . ',id,blog_category_id,' . $data['blog_category_id'] . ',deleted_at,NULL|unique:blog_articles,permalink,' . $category->id . ',id,blog_category_id, ' . $data['blog_category_id'] . ',deleted_at,NULL';
}
$validator = \Validator::make($data, $rules);
if ($validator->fails()) {
return \Redirect::route('article.category.edit', $full_permalink)->withErrors($validator)->withInput();
}
$category_id = $category->blog_category_id;
if ($category->update($data)) {
//if the category has moved
if (isset($data['blog_category_id']) && $category_id != $data['blog_category_id']) {
$category->order = Category::where('blog_category_id', '=', $category->blog_category_id)->count();
$category->save();
$categories = Category::where('blog_category_id', '=', $category->blog_category_id)->orderBy('order', 'asc')->get();
$i = 1;
foreach ($categories as $category) {
$category->order = $i;
$i++;
$category->save();
}
$articles = Article::where('blog_category_id', '=', $category->blog_category_id)->orderBy('order', 'asc')->get();
$i = 1;
foreach ($articles as $article) {
$article->order = $i;
$i++;
$article->save();
}
}
//Update images
foreach ($this->image_labels as $key => $image_label) {
if (\Input::has($image_label)) {
$data = array('order' => $key + 1, 'src' => \Input::get($image_label), 'featured' => $image_label == 'featured_responsive_filemanager_url' ? true : false);
$image = $category->images()->where('order', '=', $key + 1)->first();
if ($image) {
$image->update($data);
} else {
$image = new CategoryImage($data);
$category->images()->save($image);
}
}
}
\Session::flash('message', 'Category successfully updated!');
return \Redirect::to('articles');
}
}
?>
</p>
</a>
</div>
</div>
<?php
}
}
?>
</div>
<!-- end cotphainoibat-->
</div>
<?php
foreach ($this->newsCate as $row) {
$news = new Article();
$news->where(array('recycle' => 0, 'newscatalogue_id' => $row->id));
$news->order_by('id', 'desc');
$news->get(5);
$newsFirst = $news->limit(1);
?>
<!--tin con 1 -->
<div class="tinthitruong">
<p style="font-size:16px; font-weight:bold; color:#FFFFFF; margin-left:12px; margin-top:8px;">
<a style="color: #FFF;" href="<?php
echo $base_url . 'tin-tuc/' . $row->name_none;
?>
">
<?php
echo $row->name_vietnamese;
?>
</a>
/**
* Reorder items
*
* @param items list
* @return items from @param
*/
public function getReorder(ReorderRequest $request)
{
$list = $request->list;
$items = explode(",", $list);
$order = 1;
foreach ($items as $value) {
if ($value != '') {
Article::where('id', '=', $value)->update(array('position' => $order));
$order++;
}
}
return $list;
}
function getProject()
{
//$type = new Estatetype($this->input->post('typeId'));
//$category = new Estatecatalogue($type->estatecatalogue_id);
$o = new Article();
$o->where('recycle', 0);
$o->where('estatecity_id', $this->input->post('provincesId'));
$o->order_by('title_vietnamese', 'asc');
$o->get();
$option = '<option value="">Chọn Dự án</option>';
foreach ($o as $row) {
if ($row->id == $this->input->post('priceSelected')) {
$option .= '<option selected="selected" value=' . $row->id . '>' . $row->title_vietnamese . '</option>';
} else {
$option .= '<option value=' . $row->id . '>' . $row->title_vietnamese . '</option>';
}
}
echo $option;
die;
}
private function arrange_position_home()
{
$o = new Article();
$o->where('home_hot', 1);
$o->order_by('home_hot_position', 'asc');
$o->get();
$c = $o->count();
$i = 1;
foreach ($o as $row) {
$i++;
$row->home_hot_position = $i;
$row->save();
}
}
static function getAllArticlesByCategoryUrl($cateogoryUrl, &$message, $orderby = "id")
{
$category = Category::where('curl', '=', $cateogoryUrl)->first();
$articles = array();
$articles = Article::where('category_id', '=', $category->id);
if (is_null($category->parent_id)) {
$parentCategory = $category->InnerCategory()->get();
foreach ($parentCategory as $temp) {
$articles = $articles->or_where('category_id', '=', $temp->id);
}
}
//If user is not admin, show only his articles
if (Auth::user()->type != 1) {
$articles = $articles->where('author_id', '=', Auth::user()->id);
}
$message = "Showing all Articles of Category named " . $category->getCategoryFullName();
return $articles;
}
function isolate_list_by_cat($catalogue_id = 0, $offset = 0, $limit = 20)
{
$newscatalogue = new newscatalogue($catalogue_id);
$news = new article();
$news->where('newscatalogue_id', $catalogue_id);
$news->where(array('recycle' => 0));
$news->order_by('id', 'desc');
$news->get_paged($offset, $limit, TRUE);
$total = count($news);
setPagination($this->admin . 'cnews/isolate_list_by_cat/' . $catalogue_id, $news->paged->total_rows, $limit, 5);
if (!$newscatalogue->exists()) {
show_404();
}
$dis['base_url'] = base_url();
$dis['view'] = 'news/isolate_list';
$dis['news'] = $news;
$dis['title_table'] = "Trang hiện tại:" . $news->paged->current_page . '/' . $news->paged->total_pages;
$dis['title'] = "Tin danh mục \"{$newscatalogue->name_vietnamese}\"";
$n = new Article();
$n->where('newscatalogue_id', $catalogue_id);
$n->where(array('recycle' => 1));
$count_recycle = $n->count();
$dis['nav_menu'] = array(array("type" => "add", "text" => "Thêm tin mới", "link" => "{$this->admin_url}cnews/isolate_edit/" . $catalogue_id, "onclick" => ""));
if ($this->logged_in_user->adminrole->id == 1) {
array_push($dis['nav_menu'], array("type" => "recycle", "text" => "Thùng rác <span style='color:red'>(" . $count_recycle . ") </span>", "link" => "{$this->admin_url}cnews/list_recycle_by_cat/" . $catalogue_id, "onclick" => ""));
}
$this->session->set_userdata(array(config_item('session_admin') . 'menu_current' => $newscatalogue->navigation));
if (empty($newscatalogue->menu_active)) {
$dis['menu_active'] = $newscatalogue->name_vietnamese;
} else {
$dis['menu_active'] = $newscatalogue->menu_active;
}
$this->viewadmin($dis);
}
function helpCenter()
{
$news = new Article();
$news->where('newscatalogue_id', 65);
$news->order_by('id', 'desc');
$news->get_iterated();
$dis['news'] = $news;
$this->page_title = "Trợ giúp - " . $this->page_title;
$dis['base_url'] = base_url();
$dis['view'] = 'helpCenter';
$this->viewfront($dis);
}
<?php
// Home page
Route::get('/', array('as' => 'home', function () {
return View::make('site::index')->with('entry', Page::where('slug', 'welcome')->first());
}));
// Article list
Route::get('blog', array('as' => 'article.list', function () {
return View::make('site::articles')->with('entries', Article::orderBy('created_at', 'desc')->get());
}));
// Single article
Route::get('blog/{slug}', array('as' => 'article', function ($slug) {
$article = Article::where('slug', $slug)->first();
if (!$article) {
App::abort(404, 'Article not found');
}
return View::make('site::article')->with('entry', $article);
}));
// Single page
Route::get('{slug}', array('as' => 'page', function ($slug) {
$page = Page::where('slug', $slug)->first();
if (!$page) {
App::abort(404, 'Page not found');
}
return View::make('site::page')->with('entry', $page);
}))->where('slug', '^((?!admin).)*$');
// 404 Page
App::missing(function ($exception) {
return Response::view('site::404', array(), 404);
});
</li>
<li>
<a href="{{ route('timeline') }}"><i class="fa fa-angle-right"></i> 我的时光印记</a>
</li>
<li>
<a href="{{ route('account.settings') }}"><i class="fa fa-angle-right"></i> 前往偏好设置</a>
</li>
</ul>
</div>
{{-- /Categories Widget --}}
{{-- Text Widget --}}
<div class="widget">
<?php
$announce_category = Category::where('cat_status', 'open')->where('name', '站内简讯')->first();
$announce = Article::where('post_status', 'open')->where('category_id', $announce_category->id)->orderBy('created_at', 'desc')->first();
?>
@if($announce)
<div class="widget-title">
<h4><a href="{{ route('article.category'), $announce_category->id }}">站内简讯</a></h4>
</div>
<p>{{ $announce->excerpt }}</p>
@else
<div class="widget-title">
<h4>站内简讯</h4>
</div>
<p>
暂无站内简讯
</p>
@endif
</div>
public function getMenuItems($category_id)
{
return Article::where('category_id', $category_id)->where('active', true)->where('menu_item', true)->whereNull('deleted_at')->whereRaw('(live_at <= now() or live_at is null)')->whereRaw('(down_at >= now() or down_at is null)')->get();
}