Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 5531 Rev 5532
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);
1071
                        array_push($connectionIds, $record->request_from);
1072
            //         }
1072
                    }
1073
            //     }
1073
                }
1074
            //     array_push($connectionIds, 1);
1074
                array_push($connectionIds, 1);
1075
 
1075
 
1076
            //     $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
1076
                $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
1077
            //     $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
1077
                $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
1078
 
1078
 
1079
            //     $companyIds = [0];
1079
                $companyIds = [0];
1080
            //     foreach ($records as $record) {
1080
                foreach ($records as $record) {
1081
            //         if (!in_array($record->company_id, $companyIds)) {
1081
                    if (!in_array($record->company_id, $companyIds)) {
1082
            //             array_push($companyIds, $record->company_id);
1082
                        array_push($companyIds, $record->company_id);
1083
            //         }
1083
                    }
1084
            //     }
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) {
1089
                foreach ($companyUsers as $companyUser) {
1090
            //         if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
1090
                    if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
1091
            //             if (!in_array($companyUser->company_id, $companyIds)) {
1091
                        if (!in_array($companyUser->company_id, $companyIds)) {
1092
            //                 array_push($companyIds, $companyUser->company_id);
1092
                            array_push($companyIds, $companyUser->company_id);
1093
            //             }
1093
                        }
1094
            //         }
1094
                    }
1095
            //     }
1095
                }
1096
 
1096
 
1097
 
1097
 
1098
            //     $queryMapper = QueryMapper::getInstance($this->adapter);
1098
                $queryMapper = QueryMapper::getInstance($this->adapter);
1099
            //     $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
1099
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
1100
            //     $select->columns(['id']);
1100
                $select->columns(['id']);
1101
            //     $select->where->equalTo('network_id', $currentUser->network_id);
1101
                $select->where->equalTo('network_id', $currentUser->network_id);
1102
            //     $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
1102
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
1103
            //         ->AND->NEST
1103
                    ->AND->NEST
1104
            //         ->OR->NEST->equalTo('user_id', $id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
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
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
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');
1110
            // }
1110
            }
1111
            if ($type == 'company') {
1111
            if ($type == 'company') {
Línea 1112... Línea 1112...
1112
                $companyMapper = CompanyMapper::getInstance($this->adapter);
1112
                $companyMapper = CompanyMapper::getInstance($this->adapter);