| Línea 48... |
Línea 48... |
| 48 |
use LeadersLinked\Mapper\CompanyMapper;
|
48 |
use LeadersLinked\Mapper\CompanyMapper;
|
| 49 |
use LeadersLinked\Model\Company;
|
49 |
use LeadersLinked\Model\Company;
|
| 50 |
use LeadersLinked\Model\Connection;
|
50 |
use LeadersLinked\Model\Connection;
|
| 51 |
use LeadersLinked\Model\Service;
|
51 |
use LeadersLinked\Model\Service;
|
| 52 |
use LeadersLinked\Mapper\DailyPulseEmojiMapper;
|
52 |
use LeadersLinked\Mapper\DailyPulseEmojiMapper;
|
| - |
|
53 |
use LeadersLinked\Mapper\UserProfileMapper;
|
| Línea 53... |
Línea 54... |
| 53 |
|
54 |
|
| 54 |
class HelperController extends AbstractActionController
|
55 |
class HelperController extends AbstractActionController
|
| 55 |
{
|
56 |
{
|
| 56 |
/**
|
57 |
/**
|
| Línea 234... |
Línea 235... |
| 234 |
$items = [];
|
235 |
$items = [];
|
| 235 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
236 |
$queryMapper = QueryMapper::getInstance($this->adapter);
|
| 236 |
$select = $queryMapper->getSql()->select();
|
237 |
$select = $queryMapper->getSql()->select();
|
| 237 |
$select->columns(['id', 'uuid', 'first_name', 'last_name', 'image']);
|
238 |
$select->columns(['id', 'uuid', 'first_name', 'last_name', 'image']);
|
| 238 |
$select->from(['u' => UserMapper::_TABLE]);
|
239 |
$select->from(['u' => UserMapper::_TABLE]);
|
| - |
|
240 |
$select->join(['up' => UserProfileMapper::_TABLE], 'up.user_id = u.id ', ['description']);
|
| 239 |
$select->where->equalTo('network_id', $currentUser->network_id);
|
241 |
$select->where->equalTo('network_id', $currentUser->network_id);
|
| 240 |
$select->where->in('u.id', $other_users);
|
242 |
$select->where->in('u.id', $other_users);
|
| 241 |
$select->where->notIn('u.id', $first_degree_connections_ids);
|
243 |
$select->where->notIn('u.id', $first_degree_connections_ids);
|
| 242 |
$select->where->notEqualTo('u.id', $currentUser->id);
|
244 |
$select->where->notEqualTo('u.id', $currentUser->id);
|
| 243 |
$select->where->equalTo('u.status', User::STATUS_ACTIVE);
|
245 |
$select->where->equalTo('u.status', User::STATUS_ACTIVE);
|
| Línea 272... |
Línea 274... |
| 272 |
'image' => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'user', 'filename' => $record['image']]),
|
274 |
'image' => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'user', 'filename' => $record['image']]),
|
| 273 |
'profile' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid']]),
|
275 |
'profile' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid']]),
|
| 274 |
'relation' => $relation,
|
276 |
'relation' => $relation,
|
| 275 |
'link_cancel' => '',
|
277 |
'link_cancel' => '',
|
| 276 |
'link_request' => '',
|
278 |
'link_request' => '',
|
| - |
|
279 |
'user_profile' => $record,
|
| 277 |
];
|
280 |
];
|
| Línea 278... |
Línea 281... |
| 278 |
|
281 |
|
| 279 |
if ($connection) {
|
282 |
if ($connection) {
|
| 280 |
switch ($connection->status) {
|
283 |
switch ($connection->status) {
|