public function actionNews()
{
for ($i = 1; $i <= 10; $i++) {
$model = new News();
$model->attributes = ['name' => 'Bài viết số ' . $i, 'title' => 'Title cua bai viet so ' . $i, 'slug' => 'bai-viet-so-' . $i, 'images' => '3.png', 'type_id' => rand(1, 100), 'user_id' => '1', 'created_at' => time(), 'updated_at' => time()];
$model->save();
}
}
public function actionSave_news()
{
$news = new News();
$news->title = $_POST['title'];
$news->content = $_POST['content'];
$news->createTime = date('Y-m-d H:i:s');
$news->tag = 'unnecessary';
$news->save();
echo 1;
}
public function actionIndex($page = 1)
{
$NewsModel = new News();
$Query = $NewsModel->select();
$totalNewsNumber = $Query->count();
$Pagination = new Pages($totalNewsNumber, 20);
$Pagination->setCurrent($page);
$News = $Query->offset($Pagination->offset())->limit($Pagination->resultsOnPage())->get();
$this->render('index', ['totalNewsNumber' => $totalNewsNumber, 'News' => $News, 'Pagination' => $Pagination, 'newsOnPage' => 10], !Application::$i->Input->isAjax());
}
protected function actionCreate()
{
try {
$article = new News();
$article->fill([]);
$article->save();
} catch (MultiException $e) {
$this->view->errors = $e;
}
echo $this->view->render(__DIR__ . '/../templates/update.php');
}
public function cart($slug, News $news, Request $request)
{
$this->data['records'] = $news->getBySlug($slug);
$id_data = $news->getBySlug($slug);
$id_news_comment = $id_data->id;
//Ід новини
$this->data['newsComments'] = $news->newsComments($id_news_comment);
$this->data['newsCommentsCount'] = $news->newsCommentsCount($id_news_comment);
\DB::table('news')->WHERE('id', '=', $id_news_comment)->increment('count_views_news');
// рахуємо кулькість переглядів новини
if ($request->ajax()) {
return response()->json(view('news.ajaxPaginate.Cart', $this->data)->render());
}
return view('news.cart', $this->data);
}
protected function actionDelete()
{
$id = $_GET['id'] ?? false;
$this->redirectIf('/admin/news/index', false === $id);
$article = \App\Models\News::findByID($id);
$this->redirectIf('/admin/news/index', $article->delete());
}
/**
* Действие для вывода одной новости по id
*/
protected function actionOne()
{
if (false == ($this->view->article = \App\Models\News::findOneById($_GET['id']))) {
throw new Exception404('Новость не найдена', 404);
}
$this->view->display(__DIR__ . '/../Templates/News/One.php');
}
public function actionIndex($kinds = 'all')
{
$sort = new Sort(['attributes' => ['theme' => ['asc' => ['theme' => SORT_ASC], 'desc' => ['theme' => SORT_DESC], 'default' => SORT_ASC, 'label' => '主题'], 'author' => ['asc' => ['author' => SORT_ASC], 'desc' => ['author' => SORT_DESC], 'default' => SORT_DESC, 'label' => '作者'], 'reply' => ['asc' => ['reply' => SORT_ASC], 'desc' => ['reply' => SORT_DESC], 'default' => SORT_DESC, 'label' => '回复'], 'updated_at' => ['asc' => ['updated_at' => SORT_ASC], 'desc' => ['updated_at' => SORT_DESC], 'default' => SORT_DESC, 'label' => '最后更新'], 'plike' => ['asc' => ['plike' => SORT_ASC], 'desc' => ['plike' => SORT_DESC], 'default' => SORT_DESC, 'label' => '赞'], 'kinds' => ['asc' => ['kinds' => SORT_ASC], 'desc' => ['kinds' => SORT_DESC], 'default' => SORT_ASC, 'label' => '类别']], 'defaultOrder' => ['updated_at' => SORT_DESC]]);
if ($kinds === 'all') {
$query = Forum::find();
} elseif ($kinds === 'tucao') {
$query = Forum::find()->where(array('kinds' => 'tucao'));
} elseif ($kinds === 'tactic') {
$query = Forum::find()->where(array('kinds' => 'tactic'));
} elseif ($kinds === 'rule') {
$query = Forum::find()->where(array('kinds' => 'rule'));
} elseif ($kinds === 'bug') {
$query = Forum::find()->where(array('kinds' => 'bug'));
} elseif ($kinds === 'team') {
$query = Forum::find()->where(array('kinds' => 'team'));
} elseif ($kinds === 'myposts') {
//我发的帖子
$query = Forum::find()->where(array('author' => Yii::$app->user->identity->username));
} elseif ($kinds === 'myreplies') {
//我回复的帖子
$queryid = DetailForum::find()->select(['fatherindex'])->where(array('author' => Yii::$app->user->identity->username));
$query = Forum::find()->where(array('id' => $queryid));
} else {
$query = Forum::find();
}
$pagination = new Pagination(['defaultPageSize' => 10, 'totalCount' => $query->count()]);
$forums = $query->orderBy($sort->orders)->offset($pagination->offset)->limit($pagination->limit)->all();
//用来置顶2个点赞量最高的
$sort1 = new Sort(['attributes' => ['plike' => ['asc' => ['plike' => SORT_ASC], 'desc' => ['plike' => SORT_DESC], 'default' => SORT_DESC, 'label' => '赞']], 'defaultOrder' => ['plike' => SORT_DESC]]);
$topquery = Forum::find()->orderBy($sort1->orders)->limit(2)->all();
//用来置顶2个点赞量最高的
$news = News::find()->orderBy('addedat')->all();
return $this->render('index', ['new' => $news[0], 'forums' => $forums, 'pagination' => $pagination, 'sort' => $sort, 'topquery' => $topquery]);
}
public static function gridForAdmins(&$filter, &$grid)
{
$filter = \DataFilter::source(News::with('createdBy', 'approvedBy', 'status'));
//->where('status_id', '<>', 1)
$filter->add('title', 'Title', 'text');
$filter->add('content', 'Content', 'text');
$filter->add('createdBy.name', 'created_by', 'text');
$filter->add('approvedBy.name', 'approved_by', 'text');
$filter->add('updated_at', 'Last update date', 'daterange')->format('m/d/Y', 'en');
$filter->add('created_at', 'Create date', 'daterange')->format('m/d/Y', 'en');
$filter->submit('search');
$filter->reset('reset');
$filter->build();
$grid = DataGrid::source($filter);
$grid->attributes(array("class" => "table table-striped"));
$grid->add('title', 'Title', true);
$grid->add('updated_at|strtotime|date[m/d/Y]', 'Last update date', true);
$grid->add('created_at|strtotime|date[m/d/Y]', 'Create date', true);
$grid->add('content|strip_tags|substr[0,20]', 'Content');
$grid->add('createdBy.name', 'created_by');
$grid->add('approvedBy.name', 'approved_by');
$grid->add('status.title', 'Status');
$grid->add('view', 'View')->cell(function ($value, $row) {
return '<a class="btn btn-responsive" href="' . url('admin-news/view') . "/" . $row->id . '"><i class="glyphicon glyphicon-eye-open"></i></a>';
});
$grid->add('status.id', 'Approve')->cell(function ($value, $row) {
if ($value == 2) {
return '<a class="btn btn-success btn-responsive" href="' . url('admin-news/approve') . "/" . $row->id . '"><i class="glyphicon glyphicon-ok"></i> Approve</a>';
}
return '';
});
$grid->orderBy('id', 'desc');
$grid->paginate(10);
}
public function actionFindByColumn()
{
$item = News::findByColumn('title', 'Hello');
$view = new View();
$view->item = $item;
$view->display('findByColumn.php');
}
public function actionIndex()
{
$newsSearch = new NewsSearch();
$dataProvider = $newsSearch->search(Yii::$app->request->get());
$statuses = News::getStatuses();
return $this->render('index', ['newsSearch' => $newsSearch, 'dataProvider' => $dataProvider, 'statuses' => $statuses]);
}
public function actionView($id)
{
//Ищем запись по id
$new = News::findOne($id);
//Отправляем представлению
return $this->render('view', ['new' => $new]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params, $cat)
{
if (Yii::$app->user->isGuest) {
$isAdmin = false;
} else {
if (Yii::$app->user->identity->role == 1) {
$isAdmin = true;
} else {
$isAdmin = false;
}
}
if ($isAdmin) {
$query = News::find();
} else {
$query = News::find()->where(['cat' => $cat]);
}
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['news_id' => $this->news_id, 'create_time' => $this->create_time, 'update_time' => $this->update_time, 'cat' => $this->cat, 'clickcnt' => $this->clickcnt]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'content', $this->content]);
return $dataProvider;
}
public function actionArticle()
{
$id = $_GET['id'];
$article = News::find()->where(["id" => $id])->one();
// echo $id;
return $this->render('article', ['article' => $article]);
}
protected function actionOne()
{
$id = (int) $_GET['id'];
$this->view->article = \App\Models\News::findById($id);
$this->view->title .= $this->view->article->title;
$this->view->display(__DIR__ . '/../Views/article.php');
}
public function actionUpdate()
{
if (isset($_POST['submit'])) {
if (empty($_POST['title']) || empty($_POST['text'])) {
echo 'Title or text could not be empty';
echo '<br><a href="/home2/admin">Back to admin panel</a>';
exit;
}
$article = News::GetOne($_POST['id']);
$article->title = $_POST['title'];
$article->text = $_POST['text'];
if (true === $article->Save()) {
echo 'Article was updated';
echo '<br><a href="/home2/admin">Back to admin panel</a>';
exit;
} else {
echo 'Error updateing database';
echo '<br><a href="/home2/admin">Back to admin panel</a>';
exit;
}
}
if (!isset($_GET['id'])) {
echo 'Could not found the article';
echo '<br><a href="/home2/admin">Back to admin panel</a>';
exit;
}
$view = new ViewConstuctor();
$view->article = News::GetOne($_GET['id']);
$view->Display('Admin/Update');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('news')->delete();
for ($i = 0; $i < 100; $i++) {
News::create(['title' => 'Title ' . $i, 'meta_description' => 'meta desc ' . $i, 'views' => '1000', 'content' => 'Body ' . $i, 'user_id' => 1]);
}
}
public function actionIndex()
{
$news = News::find()->orderBy('createTime desc')->limit(3)->all();
// var_dump($news);
//echo $news[0]->title;
return $this->render('index', ['news' => $news]);
}
/**
* Displays homepage.
*
* @return mixed
*/
public function actionIndex()
{
$query = News::find();
$pagination = new Pagination(['defaultPageSize' => 4, 'totalCount' => $query->count()]);
$news = $query->orderBy(['id' => SORT_DESC])->offset($pagination->offset)->limit($pagination->limit)->all();
return $this->render('index', ['news' => $news, 'pagination' => $pagination]);
}
/**
* 创建
*
* @param array $input
* @return News
* @throws GeneralException
*/
public function create(array $input)
{
if ($id = News::create($input)) {
return $id;
}
throw new GeneralException('There was a problem creating this news. Please try again.');
}
public function actionView()
{
$id = Yii::$app->request->get('id');
$model = Teachers::findOne(['id' => $id]);
$trainWind = News::getImgRecommendNewsByCategory(11, 12);
return $this->render('view', ['data' => $model, 'trainWind' => $trainWind]);
}
public function run()
{
// query
$news = News::find()->orderBy('date_news DESC')->limit(5)->all();
// render view
return $this->render('news', ['news' => $news]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$newses = [['title' => 'МИД Британии: Совет Безопасности ООН обсудит ответные меры на запуск ракеты КНДР', 'text' => 'КНДР в воскресенье запустила баллистическую ракету с космодрома "Сохэ". Глава МИД Великобритании назвал запуск "провокационным" и отметил, что Совет Безопасности ООН согласует коллективный ответ на испытания.'], ['title' => 'Китай обеспокоен возможным размещением ПРО США в Южной Корее', 'text' => 'Во внешнеполитическом ведомстве КНР подчеркнули, что позиция Китая по вопросу ПРО последовательна и ясна. Там отметили, что все страны, стремясь обеспечить свою безопасность, должны иметь в виду интересы в сфере безопасности других стран.']];
foreach ($newses as $news) {
\App\Models\News::create($news);
}
}
public function execute($user, $item, $params)
{
$user_role = Users::findOne($user)->authAssignments->item_name;
if (isset($params['news'])) {
$news_status = $params['news']->status;
$news_category = $params['news']->category_id;
$relCat = !is_null(RelationCategories::findOne(['user_id' => $user, 'category_id' => $news_category]));
if ($user_role == 'moderator' && $relCat && isset($params['action']) && $params['action'] == 'view') {
return true;
}
if ($news_status == News::MODER_NEWS) {
if ($user_role == 'moderator') {
return $relCat;
}
}
if ($news_status == News::SMODER_NEWS) {
if ($user_role == 'super_moderator') {
return true;
}
}
} elseif (isset($params['question'])) {
if ($user_role == 'moderator') {
$news = News::findOne($params['question']->news_id);
if (!is_null($news)) {
if ($news->status == News::MODER_NEWS && !is_null(RelationCategories::findOne(['user_id' => $user, 'category_id' => $news->category_id]))) {
return true;
}
}
}
}
return false;
}
public function actionFormDeletenews()
{
$id = $_GET['id'];
$news = NewsModel::getOneById($id);
$view = new View();
$view->item = $news;
$view->display('admin/deletenews.php');
}
public function actionIndex()
{
$season = Season::findBySql('SELECT * FROM season WHERE invisible = 0 AND (unit1 != "" OR unit2 != "" OR unit3 != "" OR unit4 != "")')->all();
$news = News::find()->where(['type' => '1'])->orderBy('id DESC')->one();
$event = News::find()->where(['type' => '2'])->orderBy('id DESC')->one();
$msgs = Chatmain::find()->orderBy('id DESC')->limit(50)->all();
return $this->render('index', ['season' => $season, 'news' => $news, 'event' => $event, 'msgs' => $msgs]);
}
public function actionFormSendEmail()
{
$id = $_GET['id'];
$news = NewsModel::getOneById($id);
$view = new View();
$view->item = $news;
$view->display('news/FormSendEmail.php');
}
/**
* Show dashboard
*
* @return Response
*/
public function index()
{
$faculty = Faculty::count();
$researchGroup = ResearchGroup::count();
$researchArea = ResearchArea::count();
$news = News::count();
return view('admin.pages.dashboard', compact('faculty', 'researchGroup', 'researchArea', 'news'));
}
/**
* использование генератора
* @throws \App\Exceptions\Err404
*/
protected function actionIndex()
{
$this->view->news = \App\Models\News::findAllUseGen();
if (!$this->view->news) {
throw new \App\Exceptions\Err404('Новости не найдены ');
}
$this->view->displayTwig('index.twig', ['news' => $this->view->news]);
}
public function actionNews($news_id)
{
$news = News::find()->where(['id' => $news_id, 'is_published' => 1])->asArray()->one();
if ($news) {
$news['categories'] = CategoryRelations::get_news_categories_names($news['id']);
return $this->render('news', compact('news'));
}
}
