public function actionIndex($tab = null) { $allUsers = $pages = null; $itemsProvider = new CArrayDataProvider(array()); $this->setActiveMenu('my_mailbox'); $return = Messages::getAllContactUsers(Yii::app()->user->id); if ($return) { $allUsers = $return['allUsers']; $pages = $return['pages']; if (count($allUsers)) { $itemsProvider = new CArrayDataProvider($allUsers, array('pagination' => array('pageSize' => param('userPaginationPageSize', 20)))); } } switch ($tab) { case "inbox": $messages = Messages::model()->findAll('id_userTo=:toUser AND is_deleted<>:isDeleted', [':toUser' => Yii::app()->user->id, ':isDeleted' => Messages::MESSAGE_ACTIVE]); break; case "outbox": $messages = Messages::model()->findAll('id_userFrom=:fromUser AND is_deleted<>:isDeleted', [':fromUser' => Yii::app()->user->id, ':isDeleted' => Messages::MESSAGE_ACTIVE]); break; case "admin": $sql = "select * from bt_messages WHERE is_deleted<>" . Messages::MESSAGE_ACTIVE . "\n AND EXISTS(select null FROM bt_users WHERE id=id_userFrom\n AND role IN('admin','moderator'))"; $messages = Messages::model()->findBySql($sql); break; default: $messages = Messages::model()->findAll('id_userTo=:toUser AND is_deleted<>:isDeleted', [':toUser' => Yii::app()->user->id, ':isDeleted' => Messages::MESSAGE_ACTIVE]); break; } $this->render('index', array('allUsers' => $allUsers, 'pages' => $pages, 'itemsProvider' => $itemsProvider, 'messages' => $messages)); }
public function actionAdmin() { $allUsers = $pages = null; $itemsProvider = new CArrayDataProvider(array()); $return = Messages::getAllContactUsers(Yii::app()->user->id); if ($return) { $allUsers = $return['allUsers']; $pages = $return['pages']; if (count($allUsers)) { $itemsProvider = new CArrayDataProvider($allUsers, array('pagination' => array('pageSize' => param('adminPaginationPageSize', 20)))); } } $this->render('admin', array('allUsers' => $allUsers, 'pages' => $pages, 'itemsProvider' => $itemsProvider)); }