| Línea 1093... |
Línea 1093... |
| 1093 |
}
|
1093 |
}
|
| 1094 |
}
|
1094 |
}
|
| 1095 |
}
|
1095 |
}
|
| Línea 1096... |
Línea 1096... |
| 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') {
|