Proyectos de Subversion LeadersLinked - Antes de SPA

            $userBlockedMapper = UserBlockedMapper::getInstance($this->adapter);

            $userBlocked = $userBlockedMapper->fetchOneByUserIdAndBlockedId($group->user_id, $currentUser->id);

            if($userBlocked) {

                $flashMessenger->addErrorMessage('ERROR_UNAUTHORIZED');

                return $this->redirect()->toRoute('dashboard');

            }

            $userMapper = UserMapper::getInstance($this->adapter);

            $ownerGroup = $userMapper->fetchOne($group->user_id);

            $values = [

                Group::ACCESSIBILITY_AUTO_JOIN => 'LABEL_AUTO_JOIN',

                Group::ACCESSIBILITY_REQUEST_TO_JOIN => 'LABEL_REQUEST_TO_JOIN',

                Group::ACCESSIBILITY_ADMIN_WILL_ADD => 'LABEL_ADMIN_WILL_ADD',

            ];

            $accessibility = $values[$group->accessibility];

            $values = [

                Group::PRIVACY_IS_PRIVATE => 'LABEL_PRIVATE',

                Group::PRIVACY_IS_PUBLIC => 'LABEL_PUBLIC'

            ];

            $privacy = $values[$group->privacy];

            $industryMapper = IndustryMapper::getInstance($this->adapter);

            $record = $industryMapper->fetchOne($group->industry_id);

            $industry = $record->name;

            $groupTypeMapper = GroupTypeMapper::getInstance($this->adapter);

            $record = $groupTypeMapper->fetchOne($group->type_id);

            $group_type = $record->name;

            $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);

            $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $group->user_id);

            if($groupMember) {

                if($groupMember->status != GroupMember::STATUS_ACCEPTED) {

                    $groupMember->status = $groupMember::STATUS_ACCEPTED;

                    $groupMemberMapper->update($groupMember);

                }

            } else {

                $groupMember = new GroupMember();

                $groupMember->user_id = $group->user_id;

                $groupMember->group_id = $group->id;

                $groupMember->status = GroupMember::STATUS_ACCEPTED;

                $groupMemberMapper->insert($groupMember);

            }

            $total_members = $groupMemberMapper->fetchTotalByGroupId($group->id);

            $member = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);

            $show_feeds = false;

            if($member) {

                if($member->status == GroupMember::STATUS_ACCEPTED || $member->status == GroupMember::STATUS_AUTO_JOIN) {

                    $show_feeds = true;

                }

            }

            $queryMapper = QueryMapper::getInstance($this->adapter);

            $select = $queryMapper->getSql()->select();

            $select->columns(['user_id' => 'id',  'user_uuid' => 'uuid', 'first_name','last_name', 'image']);

            $select->from(['u' => UserMapper::_TABLE]);

            $select->join(['tgm' => GroupMemberMapper::_TABLE], 'tgm.user_id = u.id',[]);

            $select->join(['up' => UserProfileMapper::_TABLE], 'up.user_id = u.id',['user_profile_id' => 'id', 'user_profile_uuid' => 'uuid']);

            $select->where->equalTo('u.status', User::STATUS_ACTIVE);

            $select->where->equalTo('tgm.status',GroupMember::STATUS_ACCEPTED);

            // echo $select->getSqlString($this->adapter->platform); exit;

            $members = [];

            $records = $queryMapper->fetchAll($select);

            foreach($records as $record)

            {

                $userBlocked = $userBlockedMapper->fetchOneByUserIdAndBlockedId($record['user_id'], $currentUser->id);

                array_push($members, [

                    'name' => trim($record['first_name'] . ' ' . $record['last_name']),

                    'image' => $this->url()->fromRoute('storage', ['code' => $record['user_uuid'], 'type' => 'user', 'filename' => $record['image'] ]),

                    'link_profile' => $userBlocked ? '' : $this->url()->fromRoute('profile/view',['id' => $record['user_profile_uuid'] ])

                ]);

            }

            $data = [

                'total_members'         => $total_members,

                'accessibility'         => $accessibility ,

                'privacy'               => $privacy,

                'industry'              => $industry,

                'group_id'              => $group->id,

                'group_type'            => $group_type,

                'group_uuid'            => $group->uuid,

                'name'                  => trim($group->name),

                'image'                 => $group->image,

                'cover'                 => $group->cover,

                'overview'              => $group->description,

                'website'               => $group->website,