The followings are the available columns in table 'user_to_blog':
public function checkSelf()
{
$messages = [];
// count moderated users
$membersCnt = UserToBlog::model()->count('status = :status', [':status' => UserToBlog::STATUS_CONFIRMATION]);
if ($membersCnt) {
$messages[WebModule::CHECK_NOTICE][] = ['type' => WebModule::CHECK_NOTICE, 'message' => Yii::t('BlogModule.blog', '{count} new members of blog wait for confirmation!', ['{count}' => CHtml::link($membersCnt, ['/blog/userToBlogBackend/index', 'UserToBlog[status]' => UserToBlog::STATUS_CONFIRMATION, 'order' => 'id.desc'])])];
}
$postsCount = Post::model()->count('status = :status', [':status' => Post::STATUS_MODERATED]);
if ($postsCount) {
$messages[WebModule::CHECK_NOTICE][] = ['type' => WebModule::CHECK_NOTICE, 'message' => Yii::t('BlogModule.blog', '{count} new posts wait for moderation!', ['{count}' => CHtml::link($postsCount, ['/blog/postBackend/index', 'Post[status]' => Post::STATUS_MODERATED, 'order' => 'id.desc'])])];
}
return isset($messages[WebModule::CHECK_ERROR]) || isset($messages[WebModule::CHECK_NOTICE]) ? $messages : true;
}
/**
* Возвращает модель по указанному идентификатору
* Если модель не будет найдена - возникнет HTTP-исключение.
* @param integer идентификатор нужной модели
* @return UserToBlog $model
*/
public function loadModel($id)
{
$model = UserToBlog::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, Yii::t('BlogModule.blog', 'Requested page was not found!'));
}
return $model;
}
public function getMembersList()
{
$members = new UserToBlog('search');
$members->unsetAttributes();
$members->blog_id = $this->id;
return $members;
}
/**
* @return UserToBlog
*/
public function getMembersList()
{
$members = new UserToBlog('search');
$members->unsetAttributes();
$members->blog_id = $this->id;
$members->status = UserToBlog::STATUS_ACTIVE;
return $members;
}
public function actionMembers()
{
$data = Yii::app()->ls->createCommand('SELECT * FROM prefix_blog_user')->queryAll();
$transaction = Yii::app()->db->beginTransaction();
try {
UserToBlog::model()->deleteAll();
foreach ($data as $member) {
$model = new UserToBlog();
$model->user_id = $member['user_id'];
$model->blog_id = $member['blog_id'];
$model->save();
}
$transaction->commit();
} catch (Exception $e) {
$transaction->rollback();
CVarDumper::dump($e);
die;
}
}
public function run()
{
$models = UserToBlog::model()->with('blog')->findAll('user_id = :user_id', array(':user_id' => $this->userId));
$this->render($this->view, array('models' => $models));
}
