Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

Rev 5522 | Rev 5524 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 5522 Rev 5523
Línea 1058... Línea 1058...
1058 
 
 1058 
 
1059 
        $request = $this->getRequest();
 1059 
        $request = $this->getRequest();
Línea 1060... Línea 1060...
1060 
        if ($request->isGet()) {
 1060 
        if ($request->isGet()) {
1061 
 
 1061 
 
1062 
            $page = (int) $this->params()->fromQuery('page');
 1062 
            $page = (int) $this->params()->fromQuery('page');
1063 
            if ($type == 'user') {
 1063 
            //if ($type == 'user') {
1064 
                $connectionMapper = ConnectionMapper::getInstance($this->adapter);
 1064 
            $connectionMapper = ConnectionMapper::getInstance($this->adapter);
1065 
                $records = $connectionMapper->fetchAllConnectionsByUser($id);
 1065 
            $records = $connectionMapper->fetchAllConnectionsByUser($id);
1066 
                $connectionIds = [0];
 1066 
            $connectionIds = [0];
1067 
                foreach ($records as $record) {
 1067 
            foreach ($records as $record) {
1068 
                    if ($currentUser->id == $record->request_from) {
 1068 
                if ($currentUser->id == $record->request_from) {
1069 
                        array_push($connectionIds, $record->request_to);
 1069 
                    array_push($connectionIds, $record->request_to);
1070 
                    } else {
 1070 
                } else {
- 
 
 1071 
                    array_push($connectionIds, $record->request_from);
- 
 
 1072 
                }
- 
 
 1073 
            }
- 
 
 1074 
            array_push($connectionIds, 1);
- 
 
 1075 
 
- 
 
 1076 
            $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
- 
 
 1077 
            $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
- 
 
 1078 
 
- 
 
 1079 
            $companyIds = [0];
- 
 
 1080 
            foreach ($records as $record) {
1071 
                        array_push($connectionIds, $record->request_from);
 1081 
                if (!in_array($record->company_id, $companyIds)) {
1072 
                    }
 1082 
                    array_push($companyIds, $record->company_id);
Línea 1073... Línea 1083...
1073 
                }
 1083 
                }
1074 
                array_push($connectionIds, 1);
 1084 
            }
Línea 1075... Línea -...
1075 
 
 - 
 
1076 
                // $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
 - 
 
1077 
                // $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
 - 
 
1078 
 
 - 
 
1079 
                // $companyIds = [0];
 - 
 
1080 
                // foreach ($records as $record) {
 - 
 
1081 
                //     if (!in_array($record->company_id, $companyIds)) {
 - 
 
1082 
                //         array_push($companyIds, $record->company_id);
 - 
 
1083 
                //     }
 - 
 
1084 
                // }
 - 
 
1085 
 
 1085 
 
1086 
                // $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
 1086 
            $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
1087 
                // $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
 1087 
            $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
1088 
 
 1088 
 
1089 
                // foreach ($companyUsers as $companyUser) {
 - 
 
1090 
                //     if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
 1089 
            foreach ($companyUsers as $companyUser) {
1091 
                //         if (!in_array($companyUser->company_id, $companyIds)) {
 1090 
                if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
1092 
                //             array_push($companyIds, $companyUser->company_id);
 - 
 
1093 
                //         }
 - 
 
1094 
                //     }
 - 
 
1095 
                // }
 - 
 
1096 
 
 - 
 
1097 
 
 - 
 
1098 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 - 
 
1099 
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
 - 
 
1100 
                $select->columns(['id']);
 - 
 
1101 
                $select->where->equalTo('network_id', $currentUser->network_id);
 - 
 
1102 
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
 - 
 
1103 
                    ->AND->NEST
 - 
 
1104 
                    ->OR->NEST->equalTo('user_id', $id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
 - 
 
1105 
                    ->OR->NEST->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_PUBLIC)->UNNEST
 - 
 
1106 
                    ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
 1091 
                    if (!in_array($companyUser->company_id, $companyIds)) {
- 
 
 1092 
                        array_push($companyIds, $companyUser->company_id);
- 
 
 1093 
                    }
- 
 
 1094 
                }
- 
 
 1095 
            }
- 
 
 1096 
 
- 
 
 1097 
 
- 
 
 1098 
            $queryMapper = QueryMapper::getInstance($this->adapter);
- 
 
 1099 
            $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
- 
 
 1100 
            $select->columns(['id']);
- 
 
 1101 
            $select->where->equalTo('network_id', $currentUser->network_id);
- 
 
 1102 
            $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
- 
 
 1103 
                ->AND->NEST
- 
 
 1104 
                ->OR->NEST->equalTo('user_id', $id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
- 
 
 1105 
                ->OR->NEST->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_PUBLIC)->UNNEST
- 
 
 1106 
                ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
1107 
                    ->OR->NEST->or->in('company_id', $companyIds)->and->equalTo('type', Feed::TYPE_COMPANY)->UNNEST
 1107 
                ->OR->NEST->or->in('company_id', $companyIds)->and->equalTo('type', Feed::TYPE_COMPANY)->UNNEST
1108 
                    ->UNNEST;
 1108 
                ->UNNEST;
1109 
                $select->order('added_on desc');
 1109 
            $select->order('added_on desc');
Línea 1110... Línea 1110...
1110 
            }
 1110 
            //}