Proyectos de Subversion LeadersLinked - Services

        $id = $this->params()->fromRoute('id');

        if ($id) {

            $companyMapper = CompanyMapper::getInstance($this->adapter);

            $company = $companyMapper->fetchOneByUuid($id);

            if ($company) {

                // Buscar el propietario de la empresa

                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);

                $companyUser = $companyUserMapper->fetchOwnerByCompanyId($company->id);

                // Verificar que no haya bloqueos entre usuarios

                if (!in_array($companyUser->user_id, $user_blocked_ids) && 

                    !in_array($companyUser->id, $user_blocked_me_ids)) {

                    $user = $userMapper->fetchOne($companyUser->user_id);

                    $selected_user_id = $user->id;

                    // Buscar conversación existente

                    $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);

                    // Calcular tiempo del último mensaje y mensajes no leídos

                    $timeElapsedString = '';

                    if ($conversation) {

                        $unread = $messageMapper->fetchCountUnreadMessagesByConversationIdAndReceiverId(

                            $conversation->id, 

                            $currentUser->id

                        );

                        $lastMessage = $messageMapper->fetchLastUnreadMessagesByConversationIdAndReceiverId(

                            $conversation->id, 

                            $currentUser->id

                        );

                        if ($lastMessage) {

                            $timeElapsedString = $this->timeAgo($lastMessage, $now);

                        }

                    } else {

                        $unread = 0;

                    }

                    // Agregar conversación de empresa a la lista

                    array_push($conversations, [

                        'uuid' => $company->uuid,

                        'name' => $company->name,

                        'image' => $this->url()->fromRoute('storage', [

                            'type' => 'company', 

                            'code' => $company->uuid, 

                            'filename' => $company->image

                        ], ['force_canonical' => true]),

                        'profile' => $this->url()->fromRoute('company/view', ['id' => $company->uuid]),

                        'last_message' => $timeElapsedString,

                        'count_unread' => $unread,

                        'messages_link' => $this->url()->fromRoute('inmail/messages', ['id' => $company->uuid]),

                        'send_link' => $this->url()->fromRoute('inmail/messages/send', ['id' => $company->uuid]),

                        'selected' => 1, // Marcar como seleccionado

                        'delete_link' => $this->url()->fromRoute('inmail/messages/delete', ['id' => $company->uuid]),

                    ]);

                }

            } 

            else {

                $user = $userMapper->fetchOneByUuid($id);

                if ($user) {

                    // Verificar que no haya bloqueos entre usuarios

                    if (!in_array($user->id, $user_blocked_ids) && 

                        !in_array($user->id, $user_blocked_me_ids)) {

                        $timeElapsedString = '';

                        $selected_user_id = $user->id;

                        // Buscar conversación existente

                        $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);

                        if ($conversation) {

                            $unread = $messageMapper->fetchCountUnreadMessagesByConversationIdAndReceiverId(

                                $conversation->id, 

                                $currentUser->id

                            );

                            $lastMessage = $messageMapper->fetchLastUnreadMessagesByConversationIdAndReceiverId(

                                $conversation->id, 

                                $currentUser->id

                            );

                            if ($lastMessage) {

                                $timeElapsedString = $this->timeAgo($lastMessage, $now);

                            }

                        } else {

                            $unread = 0;

                        }

                        // Agregar conversación de usuario a la lista

                        array_push($conversations, [

                            'uuid' => $user->uuid,

                            'name' => trim($user->first_name . ' ' . $user->last_name),

                            'image' => $this->url()->fromRoute('storage', [

                                'type' => 'user', 

                                'code' => $user->uuid, 

                                'filename' => $user->image

                            ], ['force_canonical' => true]),

                            'profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),

                            'last_message' => $timeElapsedString,

                            'count_unread' => $unread,

                            'messages_link' => $this->url()->fromRoute('inmail/messages', ['id' => $user->uuid]),

                            'send_link' => $this->url()->fromRoute('inmail/messages/send', ['id' => $user->uuid]),

                            'selected' => 1, // Marcar como seleccionado

                            'delete_link' => $this->url()->fromRoute('inmail/messages/delete', ['id' => $user->uuid]),

                        ]);

                    }

                }

            }

        }