| Línea 1105... |
Línea 1105... |
| 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 |
|
| - |
|
1111 |
$groupMapper = GroupMapper::getInstance($this->adapter);
|
| - |
|
1112 |
$group = $groupMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
|
| - |
|
1113 |
|
| - |
|
1114 |
$id = 0;
|
| - |
|
1115 |
|
| - |
|
1116 |
if ($group && $group->status == Group::STATUS_ACTIVE) {
|
| - |
|
1117 |
$groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
|
| - |
|
1118 |
$groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
|
| - |
|
1119 |
if ($groupMember) {
|
| - |
|
1120 |
|
| - |
|
1121 |
|
| - |
|
1122 |
if (
|
| - |
|
1123 |
$groupMember->status == GroupMember::STATUS_ACCEPTED ||
|
| - |
|
1124 |
$groupMember->status == GroupMember::STATUS_AUTO_JOIN
|
| - |
|
1125 |
) {
|
| - |
|
1126 |
|
| - |
|
1127 |
$id = $groupMember->group_id;
|
| - |
|
1128 |
}
|
| - |
|
1129 |
}
|
| - |
|
1130 |
}
|
| - |
|
1131 |
|
| - |
|
1132 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
| - |
|
1133 |
$select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
|
| - |
|
1134 |
$select->columns(['id']);
|
| - |
|
1135 |
$select->where->equalTo('network_id', $currentUser->network_id);
|
| - |
|
1136 |
$select->where->equalTo('status', Feed::STATUS_PUBLISHED);
|
| - |
|
1137 |
$select->where->equalTo('group_id', $id);
|
| - |
|
1138 |
$select->where->and->equalTo('type', Feed::TYPE_GROUP);
|
| - |
|
1139 |
$select->order('added_on desc');
|
| 1110 |
}
|
1140 |
}
|
| 1111 |
if ($type == 'company') {
|
1141 |
if ($type == 'company') {
|
| 1112 |
$companyMapper = CompanyMapper::getInstance($this->adapter);
|
1142 |
$companyMapper = CompanyMapper::getInstance($this->adapter);
|
| 1113 |
$company = $companyMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
|
1143 |
$company = $companyMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
|