/**
* Add a new vote
* @param integer $id
* @param string $type
* @param integer $vote
* @return mixed
*/
public function actionVote($id, $type, $vote = 1)
{
if (!Yii::$app->user->isGuest) {
$voteModel = Vote::find()->where(['voteable_type' => $type, 'voteable_id' => $id, 'user_id' => Yii::$app->user->id])->one();
if (!isset($voteModel->id)) {
$voteModel = new Vote();
$voteModel->voteable_type = $type;
$voteModel->voteable_id = $id;
$voteModel->user_id = Yii::$app->user->id;
} elseif ($voteModel->vote == $vote) {
$out = ['success' => false, 'error' => 'User has already voted'];
echo Json::encode($out);
return;
}
$voteModel->vote = $vote;
if ($voteModel->save()) {
$rating = Vote::getRating($id, $type);
$out = ['success' => true, 'rating' => $rating];
} else {
$out = ['success' => false, 'error' => $voteModel->getErrors()];
}
} else {
$out = ['success' => false, 'error' => 'User is guest'];
}
echo Json::encode($out);
}
public function actionAdd()
{
$entity = Yii::$app->request->post('entity');
$id = (int) Yii::$app->request->post('id');
$vote = (int) Yii::$app->request->post('vote');
return json_encode(Vote::addVote($entity, $id, $vote));
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Vote::find();
$voteTable = Vote::tableName();
// set up query with relation to `user.username`
$user = Yii::$app->getModule("user")->model("User");
$userTable = $user::tableName();
$query->joinWith(['user' => function ($query) use($userTable) {
$query->from(['user' => $userTable]);
}]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
// enable sorting for the related columns
$addSortAttributes = ["user.username"];
foreach ($addSortAttributes as $addSortAttribute) {
$dataProvider->sort->attributes[$addSortAttribute] = ['asc' => [$addSortAttribute => SORT_ASC], 'desc' => [$addSortAttribute => SORT_DESC]];
}
if (!($this->load($params) && $this->validate())) {
return $dataProvider;
}
$query->andFilterWhere(["{$voteTable}.id" => $this->id, 'vote' => $this->vote, 'voteable_id' => $this->voteable_id, 'user_id' => $this->user_id, 'ip_address' => $this->ip_address]);
$createdTime = strtotime($this->created_at);
$startDay = date("Y-m-d 00:00:00", $createdTime);
$endDay = date("Y-m-d 00:00:00", $createdTime + 60 * 60 * 24);
if ($this->created_at) {
$query->andFilterWhere(['between', 'created_at', $startDay, $endDay]);
}
$query->andFilterWhere(['like', 'voteable_type', $this->voteable_type])->andFilterWhere(['like', 'user.username', $this->getAttribute('user.username')]);
return $dataProvider;
}
public function actionIndex()
{
\Yii::$app->response->format = Response::FORMAT_JSON;
$userId = \Yii::$app->user->id;
$id = \Yii::$app->request->get('id');
$type = \Yii::$app->request->get('type', 'article');
$action = \Yii::$app->request->get('action', 'up');
if ($type == 'article') {
$model = Article::find()->where(['id' => $id])->select('id,up,down')->one();
} else {
$model = Comment::find()->where(['id' => $id])->select('id,up,down')->one();
}
$vote = Vote::find()->where(['type_id' => $id, 'type' => $type, 'action' => $action, 'user_id' => $userId])->one();
if (empty($vote)) {
$model->{$action} += 1;
$model->save(false);
$vote = new Vote();
$params = ['type' => $type, 'action' => $action, 'type_id' => $id, 'user_id' => $userId];
$vote->attributes = $params;
$vote->save();
}
return ['up' => $model->up, 'down' => $model->down];
}
public static function addVote($entity, $id, $voteAdd)
{
$user = User::thisUser();
$vote = Vote::findOne(['entity' => $entity, 'entity_id' => $id, 'user_id' => $user->id]);
if (empty($vote)) {
$vote = new Vote();
$vote->entity = $entity;
$vote->entity_id = $id;
$vote->user_id = $user->id;
}
/** @var VoteModel $model */
$model = null;
if ($entity == self::ENTITY_ITEM) {
$model = Item::findOne($id);
if ($user->reputation < Item::MIN_REPUTATION_ITEM_VOTE) {
// Если только пользователь не отменяет свои дизлайки
if (!($vote->vote == self::VOTE_DOWN && $voteAdd == self::VOTE_DOWN)) {
return ['vote' => 0, 'count' => $model->getVoteCount(), 'error' => Lang::t('ajax', 'noReputationVote')];
}
}
} else {
if ($entity == self::ENTITY_EVENT) {
$model = Event::findOne($id);
if ($user->reputation < Event::MIN_REPUTATION_EVENT_VOTE) {
// Если только пользователь не отменяет свои дизлайки
if (!($vote->vote == self::VOTE_DOWN && $voteAdd == self::VOTE_DOWN)) {
return ['vote' => 0, 'count' => $model->getVoteCount(), 'error' => Lang::t('ajax', 'noReputationVote')];
}
}
} else {
if ($entity == self::ENTITY_SCHOOL) {
$model = School::findOne($id);
if ($user->reputation < School::MIN_REPUTATION_SCHOOL_VOTE) {
// Если только пользователь не отменяет свои дизлайки
if (!($vote->vote == self::VOTE_DOWN && $voteAdd == self::VOTE_DOWN)) {
return ['vote' => 0, 'count' => $model->getVoteCount(), 'error' => Lang::t('ajax', 'noReputationVote')];
}
}
} else {
if ($entity == self::ENTITY_COMMENT) {
$model = Comment::findOne($id);
if ($user->reputation < Comment::MIN_REPUTATION_COMMENT_VOTE) {
// Если только пользователь не отменяет свои дизлайки
if (!($vote->vote == self::VOTE_DOWN && $voteAdd == self::VOTE_DOWN)) {
return ['vote' => 0, 'count' => $model->getVoteCount(), 'error' => Lang::t('ajax', 'noReputationVote')];
}
}
}
}
}
}
if (!empty($model)) {
if ($vote->vote == self::VOTE_UP) {
if ($voteAdd == self::VOTE_UP) {
// убираем up
$vote->vote = self::VOTE_NONE;
$model->addVote(-1);
$model->addReputation(VoteModel::ADD_REPUTATION_CANCEL_UP);
} else {
// ставим down
$vote->vote = self::VOTE_DOWN;
$model->addVote(-2);
$model->addReputation(VoteModel::ADD_REPUTATION_CANCEL_UP);
$model->addReputation(VoteModel::ADD_REPUTATION_DOWN);
}
} elseif ($vote->vote == self::VOTE_DOWN) {
if ($voteAdd == self::VOTE_UP) {
// ставим up
$vote->vote = self::VOTE_UP;
$model->addVote(2);
$model->addReputation(VoteModel::ADD_REPUTATION_CANCEL_DOWN);
$model->addReputation(VoteModel::ADD_REPUTATION_UP);
} else {
// убираем down
$vote->vote = self::VOTE_NONE;
$model->addVote(1);
$model->addReputation(VoteModel::ADD_REPUTATION_CANCEL_DOWN);
}
} else {
if ($voteAdd == self::VOTE_UP) {
// ставим up
$vote->vote = self::VOTE_UP;
$model->addVote(1);
$model->addReputation(VoteModel::ADD_REPUTATION_UP);
} else {
// ставим down
$vote->vote = self::VOTE_DOWN;
$model->addVote(-1);
$model->addReputation(VoteModel::ADD_REPUTATION_DOWN);
}
}
}
if ($vote->save()) {
if (!empty($model)) {
$model->save();
}
}
return ['vote' => $vote->vote, 'count' => $model->getVoteCount()];
}
/**
* @param $entity
* @param $entityIds
*
* @return Vote[]
*/
public function getVotesByEntity($entity, $entityIds)
{
return Vote::findAll(['user_id' => $this->id, 'entity' => $entity, 'entity_id' => $entityIds]);
}
$this->params['breadcrumbs'][] = ['label' => 'Записи', 'url' => ['/post']];
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="post-view">
<h1><?php
echo $this->title;
?>
</h1>
<p>
<?php
echo Html::a('Просмотр', $model->getUrl(), ['class' => 'btn btn-success']);
?>
<?php
echo Html::a('Изменить', ['update', 'id' => $model->id], ['class' => 'btn btn-primary']);
?>
<?php
echo Html::a('Удалить', ['delete', 'id' => $model->id], ['class' => 'btn btn-danger', 'data' => ['confirm' => 'Вы уверены, что хотите удалить запись?', 'method' => 'post']]);
?>
<?php
echo Html::a('Добавить запись', ['create'], ['class' => 'btn btn-success']);
?>
</p>
<?php
echo DetailView::widget(['model' => $model, 'attributes' => ['id', ['label' => 'Автор', 'attribute' => 'user.username', 'value' => Html::a($model->user->username, ['module/user/admin/view/' . $model->user_id]), 'format' => 'html'], 'title:html', 'slug', ['attribute' => 'content', 'value' => $model->content, 'format' => 'html'], ['attribute' => 'content_category_id', 'value' => $model->getCategory()], ['label' => 'Изображение', 'value' => empty($image->filename) ? null : Html::img($image->getFileUrl()), 'format' => 'html'], 'source_title:html', 'source_url:url', 'created_at', 'updated_at', ['attribute' => 'is_index', 'value' => $model->is_index ? 'Да' : 'Нет'], ['attribute' => 'is_top', 'value' => $model->is_top ? 'Да' : 'Нет'], ['attribute' => 'is_pin', 'value' => $model->is_pin ? 'Да' : 'Нет'], ['attribute' => 'with_video', 'value' => $model->with_video ? 'Да' : 'Нет'], ['attribute' => 'with_photo', 'value' => $model->with_photo ? 'Да' : 'Нет'], ['attribute' => 'is_public', 'value' => $model->is_public ? 'Да' : 'Нет'], ['attribute' => 'allow_comment', 'value' => $model->allow_comment ? 'Да' : 'Нет'], ['attribute' => 'is_yandex_rss', 'value' => $model->is_yandex_rss ? 'Да' : 'Нет'], ['attribute' => 'is_vk_rss', 'value' => $model->is_vk_rss ? 'Да' : 'Нет'], ['attribute' => 'is_fb_rss', 'value' => $model->is_fb_rss ? 'Да' : 'Нет'], ['attribute' => 'is_tw_rss', 'value' => $model->is_tw_rss ? 'Да' : 'Нет'], ['label' => 'Количество комментариев', 'value' => $model->getCommentsCount()], 'cached_tag_list', ['label' => 'Рейтинг', 'value' => '<span class="label label-success">' . Vote::getVotes($model->id, Vote::VOTEABLE_POST, 1) . '</span> <span class="label label-danger">' . Vote::getVotes($model->id, Vote::VOTEABLE_POST, 0) . '</span>', 'format' => 'html']]]);
?>
</div>
/**
* Finds the Vote model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Vote the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Vote::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* Get user vote for comment
*
* @return integer
*/
public function getUserVote()
{
return Vote::getUserVote($this->id, Vote::VOTEABLE_COMMENT);
}
/**
* Get block with 3 blog posts, which are best by rating during last 3 months
* @return array Data
*/
public static function getBlogPostsByRating($cache = true)
{
if ($cache) {
$cacheBlock = CacheBlock::find()->where(['machine_name' => 'blogPostsByRating'])->one();
if (isset($cacheBlock)) {
return ['view' => '@frontend/views/blocks/cache_block', 'data' => ['content' => $cacheBlock->content]];
}
}
$connection = Yii::$app->db;
$blogsIDQuery = 'SELECT id
FROM posts
WHERE created_at > DATE_SUB(NOW(), INTERVAL 90 day) AND content_category_id = ' . Post::CATEGORY_BLOG;
//INNER JOIN votes ON post.id = votes.voteable_id AND votes.voteable_type = '.Vote::VOTEABLE_POST.'
$cmd = $connection->createCommand($blogsIDQuery);
$bestBlogs = $cmd->queryAll();
$ratingArray = [];
foreach ($bestBlogs as &$blog) {
$blog['rating'] = Vote::getRating($blog['id'], Vote::VOTEABLE_POST);
}
for ($i = 0; $i < count($bestBlogs) - 1; $i++) {
for ($j = $i + 1; $j < count($bestBlogs); $j++) {
if ($bestBlogs[$j]['rating'] > $bestBlogs[$i]['rating']) {
$temp = $bestBlogs[$j];
$bestBlogs[$j] = $bestBlogs[$i];
$bestBlogs[$i] = $temp;
}
}
}
$count = 3;
if (count($bestBlogs) < 3) {
$count = count($bestBlogs);
}
$best3Blogs = [];
for ($i = 0; $i < $count; $i++) {
$best3Blogs[] = $bestBlogs[$i]['id'];
}
$blogs = Post::findAll($best3Blogs);
$block = ['view' => '@frontend/views/blocks/blog_block_rating', 'data' => compact('blogs')];
if (!$cache) {
$view = new \yii\base\View();
return $view->renderFile($block['view'] . '.php', $block['data']);
}
return $block;
}
