public function actionUserInfo()
{
UserInfo::updateAll(['thanks_count' => 0, 'like_count' => 0, 'hate_count' => 0]);
$meta = UserMeta::find()->all();
foreach ($meta as $key => $value) {
if (in_array($value->type, ['thanks', 'like', 'hate'])) {
switch ($value->target_type) {
case 'topic':
case 'post':
$this->stdout("同步文章操作……\n");
$topic = Topic::findOne($value->target_id);
if (UserInfo::updateAllCounters([$value->type . '_count' => 1], ['user_id' => $topic->user_id])) {
$this->stdout("同步评论成功`(*∩_∩*)′\n");
} else {
$this->stdout("同步评论失败::>_<::\n");
}
break;
case 'comment':
$this->stdout("同步评论操作……\n");
$comment = PostComment::findOne($value->target_id);
if (UserInfo::updateAllCounters([$value->type . '_count' => 1], ['user_id' => $comment->user_id])) {
$this->stdout("同步评论成功`(*∩_∩*)′\n");
} else {
$this->stdout("同步评论失败::>_<:: \n");
}
break;
default:
# code...
break;
}
}
}
return;
}
public function actionSync()
{
UserInfo::updateAll(['thanks_count' => 0, 'like_count' => 0, 'hate_count' => 0]);
$meta = UserMeta::find()->all();
foreach ($meta as $key => $value) {
if (in_array($value->type, ['thanks', 'like', 'hate'])) {
switch ($value->target_type) {
case 'topic':
case 'post':
echo '同步文章操作</br>';
$topic = Topic::findOne($value->target_id);
UserInfo::updateAllCounters([$value->type . '_count' => 1], ['user_id' => $topic->user_id]);
break;
case 'comment':
echo '同步评论操作</br>';
$comment = PostComment::findOne($value->target_id);
UserInfo::updateAllCounters([$value->type . '_count' => 1], ['user_id' => $comment->user_id]);
break;
default:
# code...
break;
}
}
}
return;
}
/**
* 最新收藏
* @param string $username
* @return string
* @throws NotFoundHttpException
*/
public function actionFavorite($username = '')
{
$user = $this->user($username);
$dataProvider = new ActiveDataProvider(['query' => UserMeta::find()->where(['user_id' => $user->id, 'type' => 'favorite', 'target_type' => 'topic'])->orderBy(['created_at' => SORT_DESC])]);
return $this->render('show', ['user' => $user, 'dataProvider' => $dataProvider]);
}
/**
* @param $userId
* @param $type
* @param string $targetType
* @return ActiveDataProvider
*/
protected function userMeta($userId, $type, $targetType = 'topic')
{
return new ActiveDataProvider(['query' => UserMeta::find()->where(['user_id' => $userId, 'type' => $type, 'target_type' => $targetType])->orderBy(['created_at' => SORT_DESC])]);
}
