Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 5530 Rev 5531
Línea 1055... Línea 1055...
1055 
        }
 1055 
        }
Línea 1056... Línea 1056...
1056 
 
 1056 
 
1057 
 
 1057 
 
Línea 1058... Línea 1058...
1058 
 
 1058 
 
1059 
        $request = $this->getRequest();
 1059 
        $request = $this->getRequest();
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 
            //     }
- 
 
 1085 
 
- 
 
 1086 
            //     $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
- 
 
 1087 
            //     $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
- 
 
 1088 
 
- 
 
 1089 
            //     foreach ($companyUsers as $companyUser) {
- 
 
 1090 
            //         if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
- 
 
 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
- 
 
 1108 
            //         ->UNNEST;
- 
 
 1109 
            //     $select->order('added_on desc');
Línea 1084... Línea -...
1084 
            }
 - 
 
1085 
 
 - 
 
1086 
            $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
 - 
 
1087 
            $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
 - 
 
1088 
 
 - 
 
1089 
            foreach ($companyUsers as $companyUser) {
 - 
 
1090 
                if ($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
 - 
 
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
 - 
 
1108 
                ->UNNEST;
 - 
 
1109 
            $select->order('added_on desc');
 - 
 
1110 
        }
 1110 
            // }
1111 
        if ($type == 'company') {
 1111 
            if ($type == 'company') {
1112 
            $companyMapper = CompanyMapper::getInstance($this->adapter);
 - 
 
1113 
            $company = $companyMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
 - 
 
1114 
 
 - 
 
1115 
            if (!$company || $company->status != Company::STATUS_ACTIVE) {
 - 
 
1116 
                $id = 0;
 - 
 
1117 
            } else {
 1112 
                $companyMapper = CompanyMapper::getInstance($this->adapter);
- 
 
 1113 
                $company = $companyMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
- 
 
 1114 
 
- 
 
 1115 
                if (!$company || $company->status != Company::STATUS_ACTIVE) {
- 
 
 1116 
                    $id = 0;
- 
 
 1117 
                } else {
Línea 1118... Línea 1118...
1118 
                $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
 1118 
                    $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
1119 
                $companyFollower = $companyFollowerMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
 1119 
                    $companyFollower = $companyFollowerMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
Línea 1120... Línea 1120...
1120 
                if ($companyFollower) {
 1120 
                    if ($companyFollower) {
1121 
                    $id = $company->id;
 1121 
                        $id = $company->id;
1122 
                } else {
 1122 
                    } else {
1123 
 
 1123 
 
- 
 
 1124 
                        $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
1124 
                    $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
 1125 
                        $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
1125 
                    $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
 1126 
 
1126 
 
 - 
 
Línea 1127... Línea 1127...
1127 
                    if (!$companyUser || $companyUser->status != CompanyUser::STATUS_ACCEPTED) {
 1127 
                        if (!$companyUser || $companyUser->status != CompanyUser::STATUS_ACCEPTED) {
1128 
                        $id = 0;
 1128 
                            $id = 0;
1129 
                    } else {
 1129 
                        } else {
1130 
                        $id = $company->id;
 1130 
                            $id = $company->id;
1131 
                    }
 1131 
                        }
1132 
                }
 1132 
                    }
1133 
            }
 1133 
                }
1134 
 
 1134 
 
1135 
 
 1135 
 
1136 
            $queryMapper = QueryMapper::getInstance($this->adapter);
 1136 
                $queryMapper = QueryMapper::getInstance($this->adapter);
1137 
            $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
 1137 
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
1138 
            $select->columns(['id']);
 1138 
                $select->columns(['id']);
Línea 1139... Línea 1139...
1139 
            $select->where->equalTo('network_id', $currentUser->network_id);
 1139 
                $select->where->equalTo('network_id', $currentUser->network_id);
Línea 1140... Línea 1140...
1140 
            $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
 1140 
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
1141 
            $select->where->equalTo('company_id', $id);
 1141 
                $select->where->equalTo('company_id', $id);
1142 
            $select->where->and->equalTo('type', Feed::TYPE_COMPANY);
 1142 
                $select->where->and->equalTo('type', Feed::TYPE_COMPANY);
1143 
            $select->order('added_on desc');
 1143 
                $select->order('added_on desc');
Línea 1144... Línea 1144...
1144 
        }
 1144 
            }
1145 
        if ($type == 'group') {
 1145 
            if ($type == 'group') {
1146 
            $groupMapper = GroupMapper::getInstance($this->adapter);
 1146 
                $groupMapper = GroupMapper::getInstance($this->adapter);
1147 
            $group = $groupMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
 1147 
                $group = $groupMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
Línea 1148... Línea 1148...
1148 
 
 1148 
 
- 
 
 1149 
                $id = 0;
1149 
            $id = 0;
 1150 
 
1150 
 
 1151 
                if ($group && $group->status == Group::STATUS_ACTIVE) {
1151 
            if ($group && $group->status == Group::STATUS_ACTIVE) {
 - 
 
Línea 1152... Línea 1152...
1152 
                $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
 1152 
                    $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
1153 
                $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
 1153 
                    $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
1154 
                if ($groupMember) {
 1154 
                    if ($groupMember) {
1155 
 
 1155 
 
1156 
 
 1156 
 
1157 
                    if (
 1157 
                        if (
1158 
                        $groupMember->status == GroupMember::STATUS_ACCEPTED ||
 1158 
                            $groupMember->status == GroupMember::STATUS_ACCEPTED ||
1159 
                        $groupMember->status == GroupMember::STATUS_AUTO_JOIN
 1159 
                            $groupMember->status == GroupMember::STATUS_AUTO_JOIN
1160 
                    ) {
 1160 
                        ) {
Línea 1161... Línea 1161...
1161 
 
 1161 
 
1162 
                        $id =  $groupMember->group_id;
 1162 
                            $id =  $groupMember->group_id;
1163 
                    }
 1163 
                        }
1164 
                }
 1164 
                    }
Línea 1165... Línea 1165...
1165 
            }
 1165 
                }
Línea 1166... Línea 1166...
1166 
 
 1166 
 
Línea 1167... Línea 1167...
1167 
            $queryMapper = QueryMapper::getInstance($this->adapter);
 1167 
                $queryMapper = QueryMapper::getInstance($this->adapter);
1168 
            $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
 1168 
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
Línea 1169... Línea 1169...
1169 
            $select->columns(['id']);
 1169 
                $select->columns(['id']);
1170 
            $select->where->equalTo('network_id', $currentUser->network_id);
 1170 
                $select->where->equalTo('network_id', $currentUser->network_id);
1171 
            $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
 1171 
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
1172 
            $select->where->equalTo('group_id', $id);
 1172 
                $select->where->equalTo('group_id', $id);
Línea 1173... Línea 1173...
1173 
            $select->where->and->equalTo('type', Feed::TYPE_GROUP);
 1173 
                $select->where->and->equalTo('type', Feed::TYPE_GROUP);
1174 
            $select->order('added_on desc');
 1174 
                $select->order('added_on desc');
1175 
        }
 1175 
            }
1176 
 
 1176 
 
1177 
        $dbSelect = new DbSelect($select, $this->adapter);
 1177 
            $dbSelect = new DbSelect($select, $this->adapter);
1178 
        $paginator = new Paginator($dbSelect);
 1178 
            $paginator = new Paginator($dbSelect);
1179 
        $paginator->setCurrentPageNumber($page ? $page : 1);
 1179 
            $paginator->setCurrentPageNumber($page ? $page : 1);
1180 
        $paginator->setItemCountPerPage(10);
 1180 
            $paginator->setItemCountPerPage(10);
1181 
 
 1181 
 
1182 
        $items = [];
 1182 
            $items = [];
1183 
 
 1183 
 
- 
 
 1184 
 
1184 
 
 1185 
            if ($feedHighlighted) {
1185 
        if ($feedHighlighted) {
 1186 
 
1186 
 
 - 
 
Línea 1187... Línea 1187...
1187 
 
 1187 
 
1188 
            $items[] = $this->renderFeed($feedHighlighted, $now, $feedHighlighted);
 1188 
                $items[] = $this->renderFeed($feedHighlighted, $now, $feedHighlighted);
Línea 1189... Línea 1189...
1189 
        }
 1189 
            }
Línea 1256... Línea 1256...
1256 
                ];
 1256 
                ];
1257 
            }*/
 1257 
            }*/
Línea 1258... Línea 1258...
1258 
 
 1258 
 
1259 
 
 1259 
 
Línea 1260... Línea 1260...
1260 
 
 1260 
 
1261 
        return new JsonModel($response);
 1261 
            return new JsonModel($response);
1262 
        //}
 1262 
        }
1263 
 
 1263