Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev 5529 Rev 5530
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' || $type == 'company' || $type == 'group') {
 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) {
 - 
 
1069 
                        array_push($connectionIds, $record->request_to);
 1068 
                if ($currentUser->id == $record->request_from) {
- 
 
 1069 
                    array_push($connectionIds, $record->request_to);
1070 
                    } else {
 1070 
                } else {
Línea 1071... Línea 1071...
1071 
                        array_push($connectionIds, $record->request_from);
 1071 
                    array_push($connectionIds, $record->request_from);
1072 
                    }
 1072 
                }
Línea 1073... Línea 1073...
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);
 - 
 
1078 
 
 1077 
            $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
- 
 
 1078 
 
Línea 1079... Línea 1079...
1079 
                $companyIds = [0];
 1079 
            $companyIds = [0];
1080 
                foreach ($records as $record) {
 1080 
            foreach ($records as $record) {
Línea 1081... Línea 1081...
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 
 
 - 
 
1086 
                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
 1085 
 
1087 
                $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
 1086 
            $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
- 
 
 1087 
            $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
Línea 1088... Línea 1088...
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
Línea 1104... Línea 1104...
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
- 
 
 1107 
                ->OR->NEST->or->in('company_id', $companyIds)->and->equalTo('type', Feed::TYPE_COMPANY)->UNNEST
- 
 
 1108 
                ->UNNEST;
- 
 
 1109 
            $select->order('added_on desc');
- 
 
 1110 
        }
1106 
                    ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
 1111 
        if ($type == 'company') {
1107 
                    ->OR->NEST->or->in('company_id', $companyIds)->and->equalTo('type', Feed::TYPE_COMPANY)->UNNEST
 - 
 
1108 
                    ->UNNEST;
 - 
 
1109 
                $select->order('added_on desc');
 - 
 
1110 
            }
 - 
 
1111 
            //if ($type == 'company') {
 - 
 
Línea 1112... Línea 1112...
1112 
                $companyMapper = CompanyMapper::getInstance($this->adapter);
 1112 
            $companyMapper = CompanyMapper::getInstance($this->adapter);
1113 
                $company = $companyMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
 1113 
            $company = $companyMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
Línea 1114... Línea 1114...
1114 
 
 1114 
 
1115 
                if (!$company || $company->status != Company::STATUS_ACTIVE) {
 1115 
            if (!$company || $company->status != Company::STATUS_ACTIVE) {
1116 
                    $id = 0;
 1116 
                $id = 0;
1117 
                } else {
 1117 
            } else {
1118 
                    $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
 - 
 
1119 
                    $companyFollower = $companyFollowerMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
 1118 
                $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
1120 
                    if ($companyFollower) {
 1119 
                $companyFollower = $companyFollowerMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
- 
 
 1120 
                if ($companyFollower) {
Línea 1121... Línea 1121...
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 
 
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 
                }
Línea 1133... Línea 1133...
1133 
                }
 1133 
            }
Línea 1134... Línea 1134...
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);
Línea 1138... Línea 1138...
1138 
                $select->columns(['id']);
 1138 
            $select->columns(['id']);
1139 
                $select->where->equalTo('network_id', $currentUser->network_id);
 1139 
            $select->where->equalTo('network_id', $currentUser->network_id);
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);
Línea 1142... Línea 1142...
1142 
                $select->where->and->equalTo('type', Feed::TYPE_COMPANY);
 1142 
            $select->where->and->equalTo('type', Feed::TYPE_COMPANY);
1143 
                $select->order('added_on desc');
 - 
 
1144 
           // }
 1143 
            $select->order('added_on desc');
1145 
            //if ($type == 'group') {
 1144 
        }
1146 
                $groupMapper = GroupMapper::getInstance($this->adapter);
 - 
 
1147 
                $group = $groupMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
 - 
 
1148 
 
 - 
 
1149 
                $id = 0;
 - 
 
1150 
 
 - 
 
1151 
                if ($group && $group->status == Group::STATUS_ACTIVE) {
 - 
 
1152 
                    $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
 - 
 
1153 
                    $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
 - 
 
1154 
                    if ($groupMember) {
 - 
 
1155 
 
 1145 
        if ($type == 'group') {
Línea 1156... Línea 1146...
1156 
 
 1146 
            $groupMapper = GroupMapper::getInstance($this->adapter);
- 
 
 1147 
            $group = $groupMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
1157 
                        if (
 1148 
 
- 
 
 1149 
            $id = 0;
- 
 
 1150 
 
1158 
                            $groupMember->status == GroupMember::STATUS_ACCEPTED ||
 1151 
            if ($group && $group->status == Group::STATUS_ACTIVE) {
- 
 
 1152 
                $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
1159 
                            $groupMember->status == GroupMember::STATUS_AUTO_JOIN
 1153 
                $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
- 
 
 1154 
                if ($groupMember) {
Línea -... Línea 1155...
- 
 
 1155 
 
1160 
                        ) {
 1156 
 
- 
 
 1157 
                    if (
- 
 
 1158 
                        $groupMember->status == GroupMember::STATUS_ACCEPTED ||
Línea -... Línea 1159...
- 
 
 1159 
                        $groupMember->status == GroupMember::STATUS_AUTO_JOIN
Línea 1161... Línea -...
1161 
 
 - 
 
Línea -... Línea 1160...
- 
 
 1160 
                    ) {
Línea 1162... Línea -...
1162 
                            $id =  $groupMember->group_id;
 - 
 
1163 
                        }
 - 
 
Línea 1164... Línea -...
1164 
                    }
 - 
 
1165 
                }
 - 
 
1166 
 
 1161 
 
1167 
                $queryMapper = QueryMapper::getInstance($this->adapter);
 1162 
                        $id =  $groupMember->group_id;
Línea -... Línea 1163...
- 
 
 1163 
                    }
- 
 
 1164 
                }
- 
 
 1165 
            }
- 
 
 1166 
 
- 
 
 1167 
            $queryMapper = QueryMapper::getInstance($this->adapter);
1168 
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
 1168 
            $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
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);
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);
 - 
 
1180 
            $paginator->setItemCountPerPage(10);
 1179 
        $paginator->setCurrentPageNumber($page ? $page : 1);
1181 
 
 1180 
        $paginator->setItemCountPerPage(10);
- 
 
 1181 
 
Línea 1182... Línea 1182...
1182 
            $items = [];
 1182 
        $items = [];
1183 
 
 1183 
 
Línea 1184... Línea 1184...
1184 
 
 1184 
 
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