Línea 27... |
Línea 27... |
27 |
use LeadersLinked\Model\UserType;
|
27 |
use LeadersLinked\Model\UserType;
|
28 |
use LeadersLinked\Model\CompanyUser;
|
28 |
use LeadersLinked\Model\CompanyUser;
|
29 |
use LeadersLinked\Mapper\GroupMemberMapper;
|
29 |
use LeadersLinked\Mapper\GroupMemberMapper;
|
30 |
use LeadersLinked\Model\GroupMember;
|
30 |
use LeadersLinked\Model\GroupMember;
|
31 |
use LeadersLinked\Mapper\CompanyUserMapper;
|
31 |
use LeadersLinked\Mapper\CompanyUserMapper;
|
32 |
use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
|
32 |
use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
|
33 |
use LeadersLinked\Model\Notification;
|
33 |
use LeadersLinked\Model\Notification;
|
34 |
use LeadersLinked\Mapper\NotificationMapper;
|
34 |
use LeadersLinked\Mapper\NotificationMapper;
|
35 |
use LeadersLinked\Mapper\UserNotificationSettingMapper;
|
35 |
use LeadersLinked\Mapper\UserNotificationSettingMapper;
|
36 |
use LeadersLinked\Mapper\EmailTemplateMapper;
|
36 |
use LeadersLinked\Mapper\EmailTemplateMapper;
|
37 |
use LeadersLinked\Model\EmailTemplate;
|
37 |
use LeadersLinked\Model\EmailTemplate;
|
38 |
use LeadersLinked\Library\QueueEmail;
|
38 |
use LeadersLinked\Library\QueueEmail;
|
39 |
use LeadersLinked\Model\Network;
|
39 |
use LeadersLinked\Model\Network;
|
40 |
use LeadersLinked\Library\Functions;
|
40 |
use LeadersLinked\Library\Functions;
|
41 |
use LeadersLinked\Cache\CacheInterface;
|
41 |
use LeadersLinked\Cache\CacheInterface;
|
42 |
use Laminas\Mvc\I18n\Translator;
|
42 |
use Laminas\Mvc\I18n\Translator;
|
- |
|
43 |
use LeadersLinked\Library\Storage;
|
Línea 43... |
Línea 44... |
43 |
|
44 |
|
44 |
class ConnectionController extends AbstractActionController
|
45 |
class ConnectionController extends AbstractActionController
|
45 |
{
|
46 |
{
|
46 |
/**
|
47 |
/**
|
Línea 158... |
Línea 159... |
158 |
$dbSelect = new DbSelect($select, $this->adapter);
|
159 |
$dbSelect = new DbSelect($select, $this->adapter);
|
159 |
$paginator = new Paginator($dbSelect);
|
160 |
$paginator = new Paginator($dbSelect);
|
160 |
$paginator->setCurrentPageNumber($page ? $page : 1);
|
161 |
$paginator->setCurrentPageNumber($page ? $page : 1);
|
161 |
$paginator->setItemCountPerPage(10);
|
162 |
$paginator->setItemCountPerPage(10);
|
Línea -... |
Línea 163... |
- |
|
163 |
|
Línea 162... |
Línea 164... |
162 |
|
164 |
$storage = Storage::getInstance($this->config);
|
163 |
|
165 |
|
164 |
$records = $paginator->getCurrentItems();
|
166 |
$records = $paginator->getCurrentItems();
|
165 |
$items = [];
|
167 |
$items = [];
|
Línea 170... |
Línea 172... |
170 |
|
172 |
|
171 |
|
173 |
|
172 |
|
174 |
|
173 |
$item = [
|
175 |
$item = [
|
174 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
176 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
Línea 175... |
Línea 177... |
175 |
'image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $record['uuid'], 'filename' => $record['image'] ],['force_canonical' => true]),
|
177 |
'image' => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
|
Línea 252... |
Línea 254... |
252 |
if($search) {
|
254 |
if($search) {
|
253 |
$select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
|
255 |
$select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
|
254 |
}
|
256 |
}
|
255 |
$select->order('first_name ASC, last_name ASC');
|
257 |
$select->order('first_name ASC, last_name ASC');
|
Línea -... |
Línea 258... |
- |
|
258 |
|
256 |
|
259 |
$storage = Storage::getInstance($this->config);
|
257 |
$records = $queryMapper->fetchAll($select);
|
260 |
$records = $queryMapper->fetchAll($select);
|
258 |
$items = [];
|
261 |
$items = [];
|
259 |
foreach($records as $record)
|
262 |
foreach($records as $record)
|
260 |
{
|
263 |
{
|
261 |
$item = [
|
264 |
$item = [
|
262 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
265 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
263 |
'image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $record['uuid'], 'filename' => $record['image'] ],['force_canonical' => true]),
|
266 |
'image' => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
|
264 |
'link_view' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]),
|
267 |
'link_view' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]),
|
265 |
'link_delete' => $this->url()->fromRoute('connection/delete', ['id' => $record['uuid'] ]),
|
268 |
'link_delete' => $this->url()->fromRoute('connection/delete', ['id' => $record['uuid'] ]),
|
Línea 266... |
Línea 269... |
266 |
];
|
269 |
];
|
Línea 313... |
Línea 316... |
313 |
if($search) {
|
316 |
if($search) {
|
314 |
$select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
|
317 |
$select->where->NEST->like('first_name', '%' . $search . '%')->or->like('last_name', '%' . $search . '%')->UNNEST;
|
315 |
}
|
318 |
}
|
316 |
$select->order('first_name ASC, last_name ASC');
|
319 |
$select->order('first_name ASC, last_name ASC');
|
Línea -... |
Línea 320... |
- |
|
320 |
|
317 |
|
321 |
$storage = Storage::getInstance($this->config);
|
318 |
$records = $queryMapper->fetchAll($select);
|
322 |
$records = $queryMapper->fetchAll($select);
|
319 |
$items = [];
|
323 |
$items = [];
|
320 |
foreach($records as $record)
|
324 |
foreach($records as $record)
|
321 |
{
|
325 |
{
|
322 |
$item = [
|
326 |
$item = [
|
323 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
327 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
324 |
'image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $record['uuid'], 'filename' => $record['image'] ],['force_canonical' => true]),
|
328 |
'image' => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
|
325 |
'link_view' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]),
|
329 |
'link_view' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]),
|
326 |
'link_approve' => $this->url()->fromRoute('connection/approve', ['id' => $record['uuid'] ]),
|
330 |
'link_approve' => $this->url()->fromRoute('connection/approve', ['id' => $record['uuid'] ]),
|
Línea 327... |
Línea 331... |
327 |
'link_reject' => $this->url()->fromRoute('connection/reject', ['id' => $record['uuid'] ]),
|
331 |
'link_reject' => $this->url()->fromRoute('connection/reject', ['id' => $record['uuid'] ]),
|
Línea 951... |
Línea 955... |
951 |
}
|
955 |
}
|
952 |
$select->order('first_name ASC, last_name ASC');
|
956 |
$select->order('first_name ASC, last_name ASC');
|
Línea 953... |
Línea 957... |
953 |
|
957 |
|
Línea 954... |
Línea -... |
954 |
//echo $select->getSqlString($this->adapter->platform); exit;
|
- |
|
- |
|
958 |
//echo $select->getSqlString($this->adapter->platform); exit;
|
955 |
|
959 |
|
956 |
|
960 |
$storage = Storage::getInstance($this->config);
|
957 |
$records = $queryMapper->fetchAll($select);
|
961 |
$records = $queryMapper->fetchAll($select);
|
958 |
$items = [];
|
962 |
$items = [];
|
Línea 959... |
Línea 963... |
959 |
foreach($records as $record)
|
963 |
foreach($records as $record)
|
960 |
{
|
964 |
{
|
Línea 961... |
Línea 965... |
961 |
|
965 |
|
962 |
$userBlocked = $userBlockedMapper->fetchOneByUserIdAndBlockedId($record['id'], $currentUser->id);
|
966 |
$userBlocked = $userBlockedMapper->fetchOneByUserIdAndBlockedId($record['id'], $currentUser->id);
|
963 |
$link_view = $userBlocked ? '' : $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]);
|
967 |
$link_view = $userBlocked ? '' : $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]);
|
964 |
|
968 |
|
965 |
$item = [
|
969 |
$item = [
|
966 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
970 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
Línea 967... |
Línea 971... |
967 |
'image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $record['uuid'], 'filename' => $record['image'] ],['force_canonical' => true]),
|
971 |
'image' => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
|
Línea 1082... |
Línea 1086... |
1082 |
|
1086 |
|
Línea 1083... |
Línea 1087... |
1083 |
$group_member_ids = $group_member_ids ? $group_member_ids : [0];
|
1087 |
$group_member_ids = $group_member_ids ? $group_member_ids : [0];
|
1084 |
|
1088 |
|
1085 |
/* Usuarios con que comparto capsulas */
|
1089 |
/* Usuarios con que comparto capsulas */
|
Línea 1086... |
Línea 1090... |
1086 |
$capsule_user_ids = [];
|
1090 |
$capsule_user_ids = [];
|
1087 |
$capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
|
1091 |
$capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
|
1088 |
|
1092 |
|
1089 |
$company_ids = [];
|
1093 |
$company_ids = [];
|
Línea 1152... |
Línea 1156... |
1152 |
$paginator->setItemCountPerPage(12);
|
1156 |
$paginator->setItemCountPerPage(12);
|
Línea 1153... |
Línea 1157... |
1153 |
|
1157 |
|
1154 |
|
1158 |
|
- |
|
1159 |
$items = [];
|
Línea 1155... |
Línea 1160... |
1155 |
$items = [];
|
1160 |
$records = $paginator->getCurrentItems();
|
1156 |
$records = $paginator->getCurrentItems();
|
1161 |
$storage = Storage::getInstance($this->config);
|
1157 |
|
1162 |
|
Línea 1175... |
Línea 1180... |
1175 |
array_push($relation, 'LABEL_RELATION_TYPE_CAPSULE_USER');
|
1180 |
array_push($relation, 'LABEL_RELATION_TYPE_CAPSULE_USER');
|
1176 |
}
|
1181 |
}
|
Línea 1177... |
Línea 1182... |
1177 |
|
1182 |
|
1178 |
$item = [
|
1183 |
$item = [
|
1179 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
1184 |
'name' => trim($record['first_name'] . ' ' . $record['last_name']),
|
1180 |
'image' => $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $record['uuid'], 'filename' => $record['image'] ],['force_canonical' => true]),
|
1185 |
'image' => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
|
1181 |
'link_view' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]),
|
1186 |
'link_view' => $this->url()->fromRoute('profile/view', ['id' => $record['uuid'] ]),
|
1182 |
'link_inmail' => $this->url()->fromRoute('inmail', ['id' => $record['uuid'] ]),
|
1187 |
'link_inmail' => $this->url()->fromRoute('inmail', ['id' => $record['uuid'] ]),
|
1183 |
'relation' => $relation,
|
1188 |
'relation' => $relation,
|
1184 |
'link_cancel' => '',
|
1189 |
'link_cancel' => '',
|