Ejemplo n.º 1
0
 /**
  * @return Role - assigned to User.
  */
 public function getRole()
 {
     $roleTable = CoreTables::TABLE_ROLE;
     $siteTable = CoreTables::TABLE_SITE;
     $siteMemberTable = CoreTables::TABLE_SITE_MEMBER;
     return Role::find()->leftJoin($siteMemberTable, "{$siteMemberTable}.roleId = {$roleTable}.id")->leftJoin($siteTable, "{$siteTable}.id = {$siteMemberTable}.siteId")->where("{$siteMemberTable}.userId=:id AND {$siteTable}.name=:name", [':id' => $this->id, ':name' => Yii::$app->cmgCore->getSiteName()]);
 }