WebSVN – LeadersLinked - Antes de SPA – Diff – /module/LeadersLinked/src/Controller/FeedController.php

         $type   = $this->params()->fromRoute('type');
-        if ($type == 'user') {
-            $id = $currentUser->id;
-        } else {
+        if ($type == 'user') {
+            $id = $currentUser->id;
+        }
+        // } else {
-            $id     = $this->params()->fromRoute('id');
+        //     $id     = $this->params()->fromRoute('id');
         // }
         $request = $this->getRequest();
         if ($request->isGet()) {
             $page = (int) $this->params()->fromQuery('page');
-            //if ($type == 'user') {
+            if ($type == 'user') {
-            $connectionMapper = ConnectionMapper::getInstance($this->adapter);
+                $connectionMapper = ConnectionMapper::getInstance($this->adapter);
-            $records = $connectionMapper->fetchAllConnectionsByUser($id);
+                $records = $connectionMapper->fetchAllConnectionsByUser($id);
-            $connectionIds = [0];
+                $connectionIds = [0];
-            foreach ($records as $record) {
+                foreach ($records as $record) {
-                if ($currentUser->id == $record->request_from) {
+                    if ($currentUser->id == $record->request_from) {
-                    array_push($connectionIds, $record->request_to);
+                        array_push($connectionIds, $record->request_to);
+                    } else {
-                } else {
+                        array_push($connectionIds, $record->request_from);
-                    array_push($connectionIds, $record->request_from);
-                }
+                    }
-            }
+                }
-            array_push($connectionIds, 1);
+                array_push($connectionIds, 1);
-            $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
+                $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
-            $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
+                $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
+                $companyIds = [0];
-            $companyIds = [0];
+                foreach ($records as $record) {
-            foreach ($records as $record) {
-                if (!in_array($record->company_id, $companyIds)) {
+                    if (!in_array($record->company_id, $companyIds)) {
-                    array_push($companyIds, $record->company_id);
+                        array_push($companyIds, $record->company_id);
-                }
+                    }
-            }
+                }
-            $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
+                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
+                $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
             $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
                 foreach ($companyUsers as $companyUser) {
-            foreach ($companyUsers as $companyUser) {
-                if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
+                    if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
-                    if (!in_array($companyUser->company_id, $companyIds)) {
+                        if (!in_array($companyUser->company_id, $companyIds)) {
-                        array_push($companyIds, $companyUser->company_id);
+                            array_push($companyIds, $companyUser->company_id);
-                    }
+                        }
-                }
+                    }
-            }
+                }
-            $queryMapper = QueryMapper::getInstance($this->adapter);
+                $queryMapper = QueryMapper::getInstance($this->adapter);
-            $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
+                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
-            $select->columns(['id']);
+                $select->columns(['id']);
-            $select->where->equalTo('network_id', $currentUser->network_id);
+                $select->where->equalTo('network_id', $currentUser->network_id);
-            $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
+                $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
-                ->AND->NEST
+                    ->AND->NEST
-                ->OR->NEST->equalTo('user_id', $id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
+                    ->OR->NEST->equalTo('user_id', $id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
-                ->OR->NEST->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_PUBLIC)->UNNEST
+                    ->OR->NEST->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_PUBLIC)->UNNEST
-                ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
+                    ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
                 $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
                 $select->where->equalTo('company_id', $id);
                 $select->where->and->equalTo('type', Feed::TYPE_COMPANY);
                 $select->order('added_on desc');
+            }
-            //if ($type == 'group') {
+            if ($type == 'group') {
-            $groupMapper = GroupMapper::getInstance($this->adapter);
+                $groupMapper = GroupMapper::getInstance($this->adapter);
-            $group = $groupMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
+                $group = $groupMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
-            $id = 0;
+                $id = 0;
-            if ($group && $group->status == Group::STATUS_ACTIVE) {
+                if ($group && $group->status == Group::STATUS_ACTIVE) {
-                $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
+                    $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
-                $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
+                    $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
-                if ($groupMember) {
+                    if ($groupMember) {
-                    if (
+                        if (
+                            $groupMember->status == GroupMember::STATUS_ACCEPTED ||
-                        $groupMember->status == GroupMember::STATUS_ACCEPTED ||
+                            $groupMember->status == GroupMember::STATUS_AUTO_JOIN
-                        $groupMember->status == GroupMember::STATUS_AUTO_JOIN
+                        ) {
-                    ) {
-                        $id =  $groupMember->group_id;
+                            $id =  $groupMember->group_id;
-                    }
+                        }
-                }
+                    }
-            }
+                }
-            $queryMapper = QueryMapper::getInstance($this->adapter);
+                $queryMapper = QueryMapper::getInstance($this->adapter);
-            $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
+                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
-            $select->columns(['id']);
+                $select->columns(['id']);
-            $select->where->equalTo('network_id', $currentUser->network_id);
+                $select->where->equalTo('network_id', $currentUser->network_id);
-            $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
+                $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
-            $select->where->equalTo('group_id', $id);
+                $select->where->equalTo('group_id', $id);
-            $select->where->and->equalTo('type', Feed::TYPE_GROUP);
+                $select->where->and->equalTo('type', Feed::TYPE_GROUP);

Proyectos de Subversion LeadersLinked - Antes de SPA

(root)/module/LeadersLinked/src/Controller/FeedController.php – Rev 5524 → 5525