function paginationAction($id)
{
$totalpage = "";
//tinh xem minh co khoan bao nhieu page
$per_page = 3;
//tong so item tren mot trang
$record = count(News::getAll());
//tong so hang cua csdl
if ($record > $per_page) {
$totalpage = ceil($record / $per_page);
} else {
$totalpage = 1;
}
$start = ($id - 1) * $per_page;
//tinh so dong bat dau trong co so du lieu tu page nhap vao
$end_page = $totalpage - 1;
$html = "<div class='pagi'><ul>";
for ($i = 1; $i <= $totalpage; $i++) {
if ($id == $i) {
$html .= "<li class='current'><a href='/page/{$i}'> {$i} </a></li>";
} else {
$html .= "<li ><a href='/page/{$i}'> {$i} </a></li>";
}
}
$html .= '</ul></div>';
$data['news'] = News::getPaginate($start, $per_page);
$data['html'] = $html;
$data['tag'] = News::getAllTag();
return $this->render('news/mainpage.html.twig', $data);
}
public function updateAction($id)
{
if ($this->getPostData()) {
$news = $this->getPostData();
$news['img'] = "img/news/" . $_FILES['image']['name'];
$path = 'img/news/' . $_FILES['image']['name'];
// Đường dẫn chưa file upload
move_uploaded_file($_FILES['image']['tmp_name'], $path);
//end img upload
$news['slug'] = $this->app['slugify']->slugify($news['name']);
//xoa gia tri hien tai cua bang post_tag
News::deletePostTag($id);
News::add_tag($id, $news['tag']);
News::updateNews($id, $news);
return $this->redirect('viewnews');
}
$data = array();
$data['news'] = News::getById($id);
return $this->render('admin/updatenews.html.twig', $data);
}
function showList()
{
$this->beforeLogin();
$today = date('Y-m-d');
$yesterday = date('Y-m-d', strtotime('-1 day'));
$user = $_SESSION['user']['name'];
$subscribes = \App\Model\Subscribe::whereUser($user)->whereStatus(0)->get();
$subscribeIds = [];
foreach ($subscribes as $v) {
$subscribeIds[] = $v->source;
}
$newsListOfToday = \App\Model\News::where('gmt_create', '>', $today)->whereIn('source', $subscribeIds)->orderBy('id', 'desc')->get();
foreach ($newsListOfToday as &$v) {
$v->source = \App\Model\Source::whereId($v->source)->first();
}
$newsListOfYesterday = \App\Model\News::where('gmt_create', '>', $yesterday)->whereIn('source', $subscribeIds)->where('gmt_create', '<', $today)->orderBy('id', 'desc')->get();
foreach ($newsListOfYesterday as &$v) {
$v->source = \App\Model\Source::whereId($v->source)->first();
}
return view('home/index', ['newsListOfToday' => $newsListOfToday, 'newsListOfYesterday' => $newsListOfYesterday, 'today' => date('m-d'), 'yesterday' => date('m-d', strtotime('-1 day'))]);
}
/**
* Show detail of a news
* GET
*
* @param int $id
* @param string $title
* @return Response
*/
public function showNews($id, $title)
{
$blog = NewsManager::find($id);
return view('news.detail', compact('blog'));
}
/**
* Display a listing of the resource.
* Hiển thị bài viết có status =1 (sidebar-right)
* @return Response
*/
public function prd()
{
return Response::json(News::orderBy('id', 'desc')->where('news_status', '1')->get());
}
public function getPaginate($start, $limit)
{
return News::skip($start)->take($limit)->get();
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
// $news = News::find($id);
// if ($news) {
// $news->delete();
// } else {
// return abort(404);
// }
// return redirect('admin/news');
$news = News::find($id);
$news->delete();
}