WebSVN – LeadersLinked - Services – Diff – /module/LeadersLinked/src/Controller/HelperController.php

 declare(strict_types=1);
-namespace LeadersLinked\Controller;
-use Laminas\Db\Adapter\AdapterInterface;
 namespace LeadersLinked\Controller;
 use Laminas\Mvc\Controller\AbstractActionController;
-use Laminas\Log\LoggerInterface;
+use Laminas\Mvc\Controller\AbstractActionController;
-use Laminas\View\Model\JsonModel;
-use LeadersLinked\Mapper\CalendarEventMapper;
+use Laminas\View\Model\JsonModel;
-use LeadersLinked\Mapper\CompanyFollowerMapper;
+use LeadersLinked\Mapper\CalendarEventMapper;
-use LeadersLinked\Mapper\CompanyServiceMapper;
+use LeadersLinked\Mapper\CompanyFollowerMapper;
 use LeadersLinked\Mapper\JobDescriptionMapper;
 use LeadersLinked\Mapper\PerformanceEvaluationFormMapper;
 use LeadersLinked\Model\Group;
 use Laminas\Db\Sql\Expression;
 use LeadersLinked\Mapper\CompanyUserMapper;
 use LeadersLinked\Model\CompanyUser;
 use LeadersLinked\Model\UserType;
-use LeadersLinked\Mapper\CompanyMicrolearningCapsuleUserMapper;
+use LeadersLinked\Mapper\MicrolearningCapsuleUserMapper;
 use LeadersLinked\Model\Notification;
 use LeadersLinked\Mapper\NotificationMapper;
 use LeadersLinked\Mapper\EmailTemplateMapper;
 use LeadersLinked\Model\EmailTemplate;
 use LeadersLinked\Library\QueueEmail;
 use LeadersLinked\Mapper\FeedMapper;
 use LeadersLinked\Model\Feed;
 use LeadersLinked\Model\AbuseReport;
 use LeadersLinked\Form\AbuseReport\CreateForm;
 use LeadersLinked\Model\Post;
-use LeadersLinked\Mapper\MessageMapper;
-use LeadersLinked\Model\Message;
 use LeadersLinked\Mapper\CommentMapper;
 use LeadersLinked\Model\Comment;
-use LeadersLinked\Mapper\ChatMessageMapper;
-use LeadersLinked\Model\ChatMessage;
-use LeadersLinked\Mapper\ChatGroupMessageMapper;
-use LeadersLinked\Mapper\ChatGroupUserMessageMapper;
 use LeadersLinked\Mapper\AbuseReportMapper;
 use LeadersLinked\Mapper\UserBlockedMapper;
 use LeadersLinked\Model\UserBlocked;
+use LeadersLinked\Library\Storage;
 class HelperController extends AbstractActionController
+{
     /**
             /* Usuarios con que comparto capsulas */
             $capsule_user_ids = [];
-            $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+            $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
             $select->where->in('u.usertype_id', [UserType::ADMIN, UserType::USER]);
             $select->order(['first_name', 'last_name']);
+            //echo $select->getSqlString($this->adapter->platform); exit;
-            //echo $select->getSqlString($this->adapter->platform); exit;
+            $storage = Storage::getInstance($this->config);
             $records = $queryMapper->fetchAll($select);
             foreach ($records as $record) {
                 $connection = $connectionMapper->fetchOneByUserId1AndUserId2($currentUser->id, $record['id']);
                 $item = [
                     'id'    => $record['uuid'],
                     'name'  => trim($record['first_name'] . ' ' . $record['last_name']),
-                    'image' => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'user', 'filename' => $record['image']],['force_canonical' => true]),
+                    'image' => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
                     'profile'   => $this->url()->fromRoute('profile/view', ['id' => $record['uuid']]),
                     'relation' => $relation,
                     'link_cancel'   => '',
                     'link_request'  => '',
                 $select->where->in('id', $user_ids);
                 $select->where->equalTo('network_id', $currentUser->network_id);
                 $select->where->equalTo('status', User::STATUS_ACTIVE);
                 $select->order(['last_name ASC', 'first_name ASC']);
+                $storage = Storage::getInstance($this->config);
                 $records = $mapper->fetchAll($select);
                 foreach ($records as $record) {
                     array_push($items, [
                         'id'        => $record['uuid'],
                         'name'      => trim($record['first_name'] . ' ' . $record['last_name']),
-                        'image'     => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'user', 'filename' => $record['image']],['force_canonical' => true]),
+                        'image'     => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
                         'profile'   => $this->url()->fromRoute('profile/view', ['id' => $record['uuid']]),
                     ]);
+                }
             $company = $companyMapper->fetchOneByUuidAndNetworkId($company_uuid, $currentUser->network_id);
             $items = [];
-            if ($company && $company->status == Company::STATUS_ACTIVE) {
-                //print_r($company);
+            if ($company && $company->status == Company::STATUS_ACTIVE) {
                 $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
                 $records = $companyFollowerMapper->fetchAllByCompanyId($company->id);
                 $ids = [];
                 foreach ($records as $record) {
                     if (!in_array($record->follower_id, $ids)) {
-                        array_push($ids, $record->follower_id);
-                    }
-                }
                         array_push($ids, $record->follower_id);
                 //print_r($records);
+                }
                     $select->order(['last_name', 'first_name']);
+                    //echo $select->getSqlString($this->adapter->platform); exit;
                     //echo $select->getSqlString($this->adapter->platform); exit;
                     $storage = Storage::getInstance($this->config);
                     $records = $mapper->fetchAll($select);
                     foreach ($records as $record) {
                         array_push($items, [
                             'id'        => $record['uuid'],
                             'name'      => trim($record['first_name'] . ' ' . $record['last_name']),
                 $select->order(['name']);
+                //echo $select->getSqlString($this->adapter->platform); exit;
-                //echo $select->getSqlString($this->adapter->platform); exit;
+                $storage = Storage::getInstance($this->config);
                 $records = $mapper->fetchAll($select);
                 foreach ($records as $record) {
                     array_push($items, [
                         'id'        => $record['uuid'],
                         'name'      => trim($record['name']),
-                        'image'     => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'company', 'filename' => $record['image']],['force_canonical' => true]),
+                        'image'     => $storage->getCompanyImageForCodeAndFilename($record['uuid'], $record['image']),
                         'profile'   => $this->url()->fromRoute('company/view', ['id' => $record['uuid']]),
                 $select->order(['last_name', 'first_name']);
+                //echo $select->getSqlString($this->adapter->platform);
                 //echo $select->getSqlString($this->adapter->platform);
+                    }
                     array_push($items, [
                         'id'        => $record['uuid'],
                         'name'      => trim($record['first_name'] . ' ' . $record['last_name']),
-                        'image'     => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'user', 'filename' => $record['image']],['force_canonical' => true]),
+                        'image'     => $storage->getUserImageForCodeAndFilename($record['uuid'], $record['image']),
                         'profile'   => $this->url()->fromRoute('profile/view', ['id' => $record['uuid']]),
                         'actions'   => $actions,
             $group_member_ids = $group_member_ids ? $group_member_ids : [0];
             /* Usuarios con que comparto capsulas */
             $capsule_user_ids = [];
-            $capsuleUserMapper = CompanyMicrolearningCapsuleUserMapper::getInstance($this->adapter);
+            $capsuleUserMapper = MicrolearningCapsuleUserMapper::getInstance($this->adapter);
             $company_ids = [];
+                }
             });
+            $items = [];
-            $items = [];
+            $storage = Storage::getInstance($this->config);
             foreach ($records as $record) {
                 array_push($items, [
                     'id'        => $record['uuid'],
                     'name'      => trim($record['name']),
-                    'image'     => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'group', 'filename' => $record['image']],['force_canonical' => true],['force_canonical' => true]),
+                    'image'     => $storage->getGroupImageForCodeAndFilename($record['uuid'],  $record['image']),
             $items = [];
             $postMapper = PostMapper::getInstance($this->adapter);
+            $posts = $postMapper->fetchAllActiveByNetworkId($currentUser->network_id);
-            $posts = $postMapper->fetchAllActiveByNetworkId($currentUser->network_id);
             $storage = Storage::getInstance($this->config);
-            //print_r($posts);
+            $path = $storage->getPathPost();
             foreach ($posts as $post) {
                 $dt = \DateTime::createFromFormat('Y-m-d', $post->date);
                 array_push($items, [
-                    'image' => $this->url()->fromRoute('storage', ['code' => $post->uuid, 'type' => 'post', 'filename' => $post->image],['force_canonical' => true]),
+                    'image' => $storage->getGenericImage($path, $post->uuid, $post->image),
                     'date' => $dt->format('d/m/Y'),
                     'title' => $post->title,
             $currentUser = $currentUserPlugin->getUser();
             $search = Functions::sanitizeFilterString($this->params()->fromQuery('search'));
+            if (strlen($search) >= 3) {
-            if (strlen($search) >= 3) {
+                $abuseReportIds = [$currentUser->id];
+                $records_x_page = 10;
+                $page = intval($this->params()->fromQuery('page', 0), 10);
                 $page = $page > 0 ? $page : 1;
+                $userMapper = UserMapper::getInstance($this->adapter);
-                $userMapper = UserMapper::getInstance($this->adapter);
+                $paginator  = $userMapper->fetchAllSuggestPaginateByNetworkIdAndSearchAndNotAbuseReport(
-                $records  = $userMapper->fetchAllSuggestByNetworkIdAndSearch($currentUser->network_id, $search);
+                    $currentUser->network_id, $search, $records_x_page, $page, $abuseReportIds );
-                $users = [];
+                $items = [];
-                foreach ($records as $record) {
+                foreach ( $paginator as $record) {
                     if ($currentUser->id == $record->id) {
                         continue;
                     }
-                    array_push($users, [
+                    array_push($items, [
+                        'uuid' => $record->uuid,
-                        'value' => $record->uuid,
+                        'contact' => trim($record->first_name . ' ' . $record->last_name) . ' (' . $record->email . ')',
-                        'text' => trim($record->first_name . ' ' . $record->last_name) . ' (' . $record->email . ')'
+                        'send_link' => $this->url()->fromRoute('inmail/message/send',[ 'id' => $record->uuid ], ['force_canonical' => true]),
                     ]);
-                    ]);
+                }
+                $response = [
+                    'success' => true,
+                    'data' => [
+                        'total' => [
+                            'count' => $paginator->getTotalItemCount(),
+                            'pages' => $paginator->getPages()->pageCount,
+                        ],
+                        'current' => [
-                }
+                            'items'    => $items,
+                            'page'     => $paginator->getCurrentPageNumber(),
+                            'count'    => $paginator->getCurrentItemCount(),
+                        ]
                 return new JsonModel([
-                    'success' => true,
+                ];
                     'data' => $users
-                ]);
+                return new JsonModel($response);
             $select->where->equalTo('g.user_id', $currentUser->id);
             $select->order('name ASC');
             $items = [];
-            $items = [];
+            $storage = Storage::getInstance($this->config);
             $records = $queryMapper->fetchAll($select);
             foreach ($records as $record) {
                 array_push($items, [
                     'id'        => $record['uuid'],
                     'name'      => trim($record['name']),
-                    'image'     => $this->url()->fromRoute('storage', ['code' => $record['uuid'], 'type' => 'group', 'filename' => $record['image']],['force_canonical' => true]),
+                    'image'     => $storage->getGroupImageForCodeAndFilename($record['uuid'], $record['image']),
                     if (!$page || empty($page['route']) || !$acl->isAllowed($currentUser->usertype_id, $page['route'])) {
                         continue;
+                    }
                     $childs = [];
+                    $ajax = false;
+                    if ($page['route'] == 'company' && $network->default == Network::DEFAULT_NO) {
                     $ajax = false;
-                    if ($page['route'] == 'company' && $network->default == Network::DEFAULT_NO) {
+                        if ($link_company) {
+                            $ajax = true;
+                            $page['route'] = $this->url()->fromRoute($link_company['route'], ['id' => $link_company['id']]);
+                            $childs = [
+                                'label' => 'Acceder',
+                                'href' => $page['route'],
+                                'ajax' => $ajax,
+                                'childs' => []
+                            ];
                         if ($link_company) {
                             $page['route'] = $this->url()->fromRoute($link_company['route'], ['id' => $link_company['id']]);
                             $ajax = true;
                         } else {
                             continue;
+                        }
+                    }
                     $option = [
                         'label' => $page['label'],
                         'href' => $page['route'],
+                        'img' => empty($page['class']) ? '' : $page['class'],
+                        'ajax' => $ajax ? 1 : 0,
+                        'childs' => $childs,
+                    ];
+                    if ($page['route'] == 'company' && $network->default == Network::DEFAULT_NO) {
+                        if ($link_company) {
+                            array_push($option['childs'], );
                         'img' => empty($page['class']) ? '' : $page['class'],
                         'ajax' => $ajax ? 1 : 0,
                         'childs' => [],
                     ];
+                    }
                     array_push($menu, $option);
+                }
-                }
+                $storage = Storage::getInstance($this->config);
-                $image = $this->url()->fromRoute('storage', ['type' => 'user', 'code' => $currentUser->uuid, 'filename' => $currentUser->image],['force_canonical' => true]);
+                $image = $storage->getUserImage($currentUser);
+                $isChatPage = $this->getEvent()->getViewModel()->getVariable('is_chat');
+                $routeCheckSession = $this->url()->fromRoute('check-session');
+                $routeAbuseReport = $this->url()->fromRoute('abuse-report');
+                $storage = Storage::getInstance($this->config);
+                $path = $storage->getPathNetwork();
-                $isChatPage = $this->getEvent()->getViewModel()->getVariable('is_chat');
+                if($network->navbar) {
-                $routeCheckSession = $this->url()->fromRoute('check-session');
+                    $navbar = $storage->getGenericImage($path, $network->uuid, $network->navbar);
-                $routeAbuseReport = $this->url()->fromRoute('abuse-report');
+                } else {
                     $navbar = '';
                     'image'                 => $image,
                     'fullName'              => $fullname,
                     'country'               => $country,
                     'visits'                => $visits,
                     'connections'           => $connections,
-                    'logoForNavbar'         => 'https://' . $network->main_hostname . '/storage-network/type/navbar',
+                    'logoForNavbar'         => $navbar,
                     'defaultNetwork'        => $network->default,
-                    //'linkKnowledgeArea'     => $link_knowledge_area == 1,
-                    //'routeKnowledgeArea'    => $route_knowledge_area,
-                    //'linkMyCoach'           => $link_my_coach == 1,
-                    //'routeMyCoach'          => $route_my_coach,
                ]);
                     $abuseReport->user_reported_id  = $comment->user_id;
                     $abuseReport->type              = AbuseReport::TYPE_COMMENT;
-                    break;
+                    break;
                     /*
                 case 'message' :
                     $messageMapper = MessageMapper::getInstance($this->adapter);
                     $abuseReport->related_id        = $message->id;
                     $abuseReport->user_reported_id  = $message->sender_id;
                     $abuseReport->type              = AbuseReport::TYPE_INMAIL_MESSAGE;
                     break;
                 case 'chat-message' :
                     $messageMapper = ChatMessageMapper::getInstance($this->adapter);
                     $message = $messageMapper->fetchOneByUuid($id);
                     $abuseReport->related_id        = $message->id;
                     $abuseReport->user_reported_id  = $message->from_id;
                     $abuseReport->type              = AbuseReport::TYPE_CHAT_USER_MESSAGE;
                     break;
                 case 'chat-group-message' :
                     $messageMapper = ChatGroupMessageMapper::getInstance($this->adapter);
                     $message = $messageMapper->fetchOne($id);
                     $abuseReport->related_id        = $message->id;
                     $abuseReport->user_reported_id  = $message->sender_id;
                     $abuseReport->type              = AbuseReport::TYPE_CHAT_USER_MESSAGE;
-                    break;
+                    break; */

Proyectos de Subversion LeadersLinked - Services

(root)/module/LeadersLinked/src/Controller/HelperController.php – Rev 203 → 269