Proyectos de Subversion LeadersLinked - Services

Rev

Rev 666 | Rev 675 | Ir a la última revisión | Autoría | Comparar con el anterior | Ultima modificación | Ver Log | 

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Mvc\Controller\AbstractActionController;
use Laminas\Log\LoggerInterface;
use Laminas\View\Model\ViewModel;

use LeadersLinked\Library\Functions;
use LeadersLinked\Mapper\UserMapper;

use LeadersLinked\Model\User;

use LeadersLinked\Mapper\UserBlockedMapper;

use LeadersLinked\Mapper\CompanyMapper;
use LeadersLinked\Mapper\CompanyUserMapper;
use LeadersLinked\Mapper\ConversationMapper;
use LeadersLinked\Mapper\MessageMapper;
use LeadersLinked\Model\Conversation;
use LeadersLinked\Library\Image;
use Laminas\View\Model\JsonModel;
use LeadersLinked\Form\InMail\SendForm;
use LeadersLinked\Model\Message;
use LeadersLinked\Model\VideoConvert;
use LeadersLinked\Mapper\VideoConvertMapper;
use Laminas\Mvc\I18n\Translator;
use LeadersLinked\Mapper\AbuseReportMapper;
use LeadersLinked\Model\AbuseReport;
use LeadersLinked\Library\Storage;

class InMailController extends AbstractActionController
{
    /**
     *
     * @var \Laminas\Db\Adapter\AdapterInterface
     */
    private $adapter;

    /**
     *
     * @var \LeadersLinked\Cache\CacheInterface
     */
    private $cache;


    /**
     *
     * @var \Laminas\Log\LoggerInterface
     */
    private $logger;

    /**
     *
     * @var array
     */
    private $config;


    /**
     *
     * @var \Laminas\Mvc\I18n\Translator
     */
    private $translator;


    /**
     *
     * @param \Laminas\Db\Adapter\AdapterInterface $adapter
     * @param \LeadersLinked\Cache\CacheInterface $cache
     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger
     * @param array $config
     * @param \Laminas\Mvc\I18n\Translator $translator
     */
    public function __construct($adapter, $cache, $logger, $config, $translator)
    {
        $this->adapter      = $adapter;
        $this->cache        = $cache;
        $this->logger       = $logger;
        $this->config       = $config;
        $this->translator   = $translator;
    }

    /**
     * Genera el listado de conversaciones del usuario actual
     * 
     * Endpoint: GET /inmail
     * 
     * Parámetros de ruta:
     * - id: UUID del usuario o empresa para seleccionar automáticamente (opcional)
     * 
     * Respuesta exitosa:
     * [
     *   success: true,
     *   data: [
     *     [
     *       uuid: UUID del usuario/empresa con quien se tiene la conversación,
     *       name: nombre del usuario/empresa,
     *       image: URL de la imagen del usuario/empresa,
     *       profile: URL del perfil del usuario/empresa,
     *       last_message: tiempo transcurrido del último mensaje,
     *       count_unread: cantidad de mensajes sin leer,
     *       messages_link: URL para recuperar los mensajes,
     *       send_link: URL para enviar mensaje,
     *       selected: 0 = no seleccionado, 1 = seleccionado,
     *       delete_link: URL para eliminar la conversación
     *     ]
     *   ]
     * ]
     * 
     * Respuesta de error:
     * [
     *   success: false,
     *   data: mensaje de error
     * ]
     * 
     * @return \Laminas\View\Model\JsonModel
     */
    public function indexAction()
    {
        $request = $this->getRequest();
        
        // Verificar que la petición sea GET
        if (!$request->isGet()) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }

        // ========================================
        // INICIALIZACIÓN Y OBTENCIÓN DE DATOS BÁSICOS
        // ========================================
        
        // Obtener el usuario actual autenticado
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();

        // Obtener la fecha actual de la base de datos para cálculos de tiempo
        $userMapper = UserMapper::getInstance($this->adapter);
        $now = $userMapper->getDatebaseNow();

        // ========================================
        // OBTENCIÓN DE USUARIOS BLOQUEADOS
        // ========================================
        
        // Obtener IDs de usuarios que el usuario actual ha bloqueado
        $userBlockedMapper = UserBlockedMapper::getInstance($this->adapter);
        $user_blocked_ids = $userBlockedMapper->fetchAllBlockedReturnIds($currentUser->id);

        // Obtener IDs de usuarios que han bloqueado al usuario actual
        $user_blocked_me_ids = $userBlockedMapper->fetchAllUserBlockMeReturnIds($currentUser->id);

        // ========================================
        // INICIALIZACIÓN DE MAPPER Y VARIABLES
        // ========================================
        
        $conversationMapper = ConversationMapper::getInstance($this->adapter);
        $messageMapper = MessageMapper::getInstance($this->adapter);
        $conversations = [];
        $selected_user_id = 0;

        // ========================================
        // PROCESAMIENTO DE USUARIO/EMPRESA SELECCIONADO
        // ========================================
        
        $id = $this->params()->fromRoute('id');
        if ($id) {
            // ========================================
            // BÚSQUEDA COMO EMPRESA PRIMERO
            // ========================================
            
            $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/message/list', ['id' => $user->uuid]),
                        'send_link' => $this->url()->fromRoute('inmail/message/send', ['id' => $user->uuid]),
                        'selected' => 1, // Marcar como seleccionado
                        'delete_link' => $this->url()->fromRoute('inmail/message/delete', ['id' => $user->uuid]),
                    ]);
                }
            } 
            // ========================================
            // BÚSQUEDA COMO USUARIO INDIVIDUAL
            // ========================================
            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/message/list', ['id' => $user->uuid]),
                            'send_link' => $this->url()->fromRoute('inmail/message/send', ['id' => $user->uuid]),
                            'selected' => 1, // Marcar como seleccionado
                            'delete_link' => $this->url()->fromRoute('inmail/message/delete', ['id' => $user->uuid]),
                        ]);
                    }
                }
            }
        }

        // ========================================
        // OBTENCIÓN DE TODAS LAS CONVERSACIONES EXISTENTES
        // ========================================
        
        $records = $conversationMapper->fetchAllByUserId($currentUser->id);
        
        foreach ($records as $record) {
            // ========================================
            // FILTRADO DE CONVERSACIONES YA PROCESADAS
            // ========================================
            
            // Omitir conversaciones que ya fueron procesadas como seleccionadas
            if ($selected_user_id) {
                if ($record->sender_id == $currentUser->id && $record->receiver_id == $selected_user_id) {
                    continue;
                }
                if ($record->receiver_id == $currentUser->id && $record->sender_id == $selected_user_id) {
                    continue;
                }
            }

            // ========================================
            // DETERMINACIÓN DEL OTRO USUARIO EN LA CONVERSACIÓN
            // ========================================
            
            if ($record->sender_id == $currentUser->id) {
                $user = $userMapper->fetchOne($record->receiver_id);
            }
            if ($record->receiver_id == $currentUser->id) {
                $user = $userMapper->fetchOne($record->sender_id);

                // Omitir usuarios bloqueados
                if (in_array($user->id, $user_blocked_ids) || in_array($user->id, $user_blocked_me_ids)) {
                    continue;
                }
            }

            // ========================================
            // CÁLCULO DE TIEMPO Y MENSAJES NO LEÍDOS
            // ========================================
            
            $timeElapsedString = '';
            $unread = $messageMapper->fetchCountUnreadMessagesByConversationIdAndReceiverId(
                $record->id, 
                $currentUser->id
            );
            $lastMessage = $messageMapper->fetchLastMessagesByConversationIdAndReceiverId(
                $record->id, 
                $currentUser->id
            );

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

            // ========================================
            // AGREGAR CONVERSACIÓN 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/message/list', ['id' => $user->uuid]),
                'send_link' => $this->url()->fromRoute('inmail/message/send', ['id' => $user->uuid]),
                'selected' => 0, // No seleccionado
                'delete_link' => $this->url()->fromRoute('inmail/message/delete', ['id' => $user->uuid]),
            ]);
        }

        // ========================================
        // ORDENAMIENTO DE CONVERSACIONES
        // ========================================
        
        // Ordenar por: seleccionados primero, luego por fecha del último mensaje
        usort($conversations, function ($a, $b) {
            if ($a['selected'] == $b['selected']) {
                if ($a['last_message'] == $b['last_message']) {
                    return 0;
                } else {
                    return $a['last_message'] < $b['last_message'] ? -1 : 1;
                }
            } else {
                return $a['selected'] < $b['selected'] ? -1 : 1;
            }
        });

        // ========================================
        // RESPUESTA FINAL
        // ========================================
        
        return new JsonModel([
            'success' => true,
            'data' => $conversations
        ]);
    }

    /**
     * Recupera los mensajes de una conversación específica entre usuarios
     * 
     * Endpoint: GET /inmail/message/:id
     * 
     * Parámetros de consulta:
     * - page: número de página para paginación (opcional, por defecto 0)
     * 
     * Respuesta exitosa:
     * [
     *   success: true,
     *   data: [
     *     [
     *       uuid: UUID del mensaje,
     *       sender_name: nombre del remitente,
     *       sender_image: URL de la imagen del remitente,
     *       sender_profile: URL del perfil del remitente,
     *       receiver_name: nombre del destinatario,
     *       receiver_image: URL de la imagen del destinatario,
     *       receiver_profile: URL del perfil del destinatario,
     *       side: 'left' (mensaje propio) | 'right' (mensaje recibido),
     *       message: contenido del mensaje,
     *       type: 'text' | 'image' | 'video' | 'document',
     *       filename: URL del archivo adjunto (si existe),
     *       date: tiempo transcurrido desde el envío,
     *       url_abuse_report: URL para reportar abuso (solo mensajes recibidos)
     *     ]
     *   ],
     *   pagination: información de paginación
     * ]
     * 
     * Respuesta de error:
     * [
     *   success: false,
     *   data: mensaje de error
     * ]
     * 
     * @return \Laminas\View\Model\JsonModel
     */
    public function messageAction()
    {
        $request = $this->getRequest();
        
        // Verificar que la petición sea GET
        if (!$request->isGet()) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }

        // ========================================
        // INICIALIZACIÓN Y VALIDACIÓN DE PARÁMETROS
        // ========================================
        
        // Obtener parámetros de la petición
        $page = intval($this->params()->fromQuery('page', 0), 10);
        $id = $this->params()->fromRoute('id');
        
        // Validar que se proporcione el ID del usuario
        if (!$id) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_PARAMETERS_ARE_INVALID'
            ]);
        }

        // Obtener el usuario actual autenticado
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();

        // Obtener la fecha actual de la base de datos para cálculos de tiempo
        $userMapper = UserMapper::getInstance($this->adapter);
        $now = $userMapper->getDatebaseNow();

        // ========================================
        // VALIDACIÓN DEL USUARIO DESTINATARIO
        // ========================================
        
        // Buscar el usuario destinatario por UUID
        $user = $userMapper->fetchOneByUuid($id);
        if (!$user) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_REQUEST_IS_INVALID'
            ]);
        }

        // ========================================
        // OBTENCIÓN DE REPORTES DE ABUSO
        // ========================================
        
        // Obtener IDs de mensajes reportados por el usuario actual
        $abuseReportMapper = AbuseReportMapper::getInstance($this->adapter);
        $abuse_report_message_ids = $abuseReportMapper->fetchAllDataByUserReportingIdAndTypeReturnIds(
            $currentUser->id, 
            AbuseReport::TYPE_INMAIL_MESSAGE
        );

        // ========================================
        // BÚSQUEDA DE LA CONVERSACIÓN
        // ========================================
        
        $conversationMapper = ConversationMapper::getInstance($this->adapter);
        $messageMapper = MessageMapper::getInstance($this->adapter);
        
        // Buscar la conversación entre los dos usuarios
        $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);
        
        $messages = [];
        
        // ========================================
        // PROCESAMIENTO DE MENSAJES
        // ========================================
        
        if ($conversation) {
            // Obtener mensajes paginados de la conversación
            $records = $messageMapper->getAllMessagesPaginatorByConversationId($conversation->id, $page);

            foreach ($records as $record) {
                // Calcular tiempo transcurrido desde el envío del mensaje
                $timeElapsedString = $this->timeAgo($record->added_on, $now);

                // ========================================
                // MENSAJES ENVIADOS POR EL USUARIO ACTUAL
                // ========================================
                
                if ($record->sender_id == $currentUser->id) {
                    array_push($messages, [
                        'uuid' => $record->uuid,
                        'sender_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
                        'sender_image' => $this->url()->fromRoute('storage', [
                            'type' => 'user', 
                            'filename' => $currentUser->image, 
                            'code' => $currentUser->uuid
                        ], ['force_canonical' => true]),
                        'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
                        'receiver_name' => trim($user->first_name . ' ' . $user->last_name),
                        'receiver_image' => $this->url()->fromRoute('storage', [
                            'type' => 'user', 
                            'filename' => $user->image, 
                            'code' => $user->uuid
                        ], ['force_canonical' => true]),
                        'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
                        'side' => 'left', // Mensaje propio (lado izquierdo)
                        'message' => $record->message,
                        'type' => $record->type,
                        'filename' => $record->filename ? $this->url()->fromRoute('storage', [
                            'type' => 'message', 
                            'filename' => $record->filename, 
                            'code' => $record->uuid
                        ], ['force_canonical' => true]) : '',
                        'date' => $timeElapsedString,
                        'url_abuse_report' => '', // No se puede reportar mensajes propios
                    ]);
                } 
                // ========================================
                // MENSAJES RECIBIDOS DEL OTRO USUARIO
                // ========================================
                else {
                    // Verificar si el mensaje ha sido reportado por abuso
                    if (in_array($record->id, $abuse_report_message_ids)) {
                        // Mensaje reportado - mostrar mensaje de contenido reportado
                        array_push($messages, [
                            'uuid' => $record->uuid,
                            'sender_name' => trim($user->first_name . ' ' . $user->last_name),
                            'sender_image' => $this->url()->fromRoute('storage', [
                                'type' => 'user', 
                                'filename' => $user->image, 
                                'code' => $user->uuid
                            ], ['force_canonical' => true]),
                            'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
                            'receiver_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
                            'receiver_image' => $this->url()->fromRoute('storage', [
                                'type' => 'user', 
                                'filename' => $currentUser->image, 
                                'code' => $user->uuid
                            ], ['force_canonical' => true]),
                            'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
                            'side' => 'right', // Mensaje recibido (lado derecho)
                            'message' => 'LABEL_ABUSE_CONTENT_REPORTED',
                            'type' => Message::TYPE_TEXT,
                            'filename' => '',
                            'date' => $timeElapsedString,
                            'url_abuse_report' => '', // Ya no se puede reportar
                        ]);
                    } else {
                        // Mensaje normal - generar URL para reportar abuso
                        $url_abuse_report = $this->url()->fromRoute('helpers/abuse-report', [
                            'type' => 'message', 
                            'id' => $record->uuid
                        ], ['force_canonical' => true]);

                        array_push($messages, [
                            'uuid' => $record->uuid,
                            'sender_name' => trim($user->first_name . ' ' . $user->last_name),
                            'sender_image' => $this->url()->fromRoute('storage', [
                                'type' => 'user', 
                                'filename' => $user->image, 
                                'code' => $user->uuid
                            ], ['force_canonical' => true]),
                            'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
                            'receiver_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
                            'receiver_image' => $this->url()->fromRoute('storage', [
                                'type' => 'user', 
                                'filename' => $currentUser->image, 
                                'code' => $user->uuid
                            ], ['force_canonical' => true]),
                            'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
                            'side' => 'right', // Mensaje recibido (lado derecho)
                            'message' => $record->message,
                            'type' => $record->type,
                            'filename' => $record->filename ? $this->url()->fromRoute('storage', [
                                'type' => 'message', 
                                'filename' => $record->filename, 
                                'code' => $record->uuid
                            ], ['force_canonical' => true]) : '',
                            'date' => $timeElapsedString,
                            'url_abuse_report' => $url_abuse_report,
                        ]);

                        // Marcar el mensaje como leído
                        $messageMapper->markAsRead($record->id);
                    }
                }
            }

            // ========================================
            // RESPUESTA CON MENSAJES Y PAGINACIÓN
            // ========================================
            
            return new JsonModel([
                'success' => true,
                'data' => $messages,
                'pagination' => $records->getPages()
            ]);
        }

        // ========================================
        // RESPUESTA CUANDO NO EXISTE CONVERSACIÓN
        // ========================================
        
        return new JsonModel([
            'success' => true,
            'data' => $messages,
            'pagination' => 1
        ]);
    }

    /**
     * Envía un mensaje InMail a un usuario específico
     * 
     * Endpoint: POST /inmail/message/send/:id
     * 
     * Parámetros requeridos:
     * - message: texto plano del mensaje
     * 
     * Parámetros opcionales:
     * - file: archivo adjunto (jpg, jpeg, png, mp4, webm, mpeg, pdf)
     * 
     * @return JsonModel
     */
    public function sendMessageAction()
    {
        // Verificar que la petición sea POST
        $request = $this->getRequest();
        if (!$request->isPost()) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }

        // Obtener el usuario actual
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();

        // Obtener la fecha actual de la base de datos
        $userMapper = UserMapper::getInstance($this->adapter);
        $now = $userMapper->getDatebaseNow();

        // Validar el ID del destinatario
        $id = $this->params()->fromRoute('id');
        if (!$id) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_PARAMETERS_ARE_INVALID'
            ]);
        }

        // Buscar el usuario destinatario
        $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
        if (!$user) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_REQUEST_IS_INVALID'
            ]);
        }

        // Combinar datos POST y archivos
        $data = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());

        // Si se envía un archivo sin error, usar su nombre como mensaje
        if (!empty($data['file']) && empty($data['file']['error'])) {
            $data['message'] = $data['file']['name'];
        }

        // Validar los datos del formulario
        $form = new SendForm();
        $form->setData($data);

        if (!$form->isValid()) {
            // Si el formulario no es válido, devolver los errores
            $messages = [];
            $form_messages = (array) $form->getMessages();
            foreach ($form_messages as $fieldname => $field_messages) {
                $messages[$fieldname] = array_values($field_messages);
            }
            return new JsonModel([
                'success' => false,
                'data' => $messages
            ]);
        }

        // Obtener los datos validados
        $dataPost = (array) $form->getData();

        // Buscar o crear la conversación
        $conversationMapper = ConversationMapper::getInstance($this->adapter);
        $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);

        if ($conversation) {
            // Actualizar estado de la conversación existente
            $conversation->receiver_status = Conversation::STATUS_NORMAL;
            $conversation->sender_status = Conversation::STATUS_NORMAL;

            if (!$conversationMapper->update($conversation)) {
                return new JsonModel([
                    'success' => false,
                    'data' => $conversationMapper->getError()
                ]);
            }
        } else {
            // Crear nueva conversación
            $conversation = new Conversation();
            $conversation->sender_id = $currentUser->id;
            $conversation->sender_status = Conversation::STATUS_NORMAL;
            $conversation->receiver_id = $user->id;
            $conversation->receiver_status = Conversation::STATUS_NORMAL;

            if (!$conversationMapper->insert($conversation)) {
                return new JsonModel([
                    'success' => false,
                    'data' => $conversationMapper->getError()
                ]);
            }
        }

        // Procesar archivo adjunto si existe
        $files = $this->getRequest()->getFiles()->toArray();
        $type = Message::TYPE_TEXT;
        $message_tmp_filename = '';
        $message_filename = '';

        if (isset($files['file']) && empty($files['file']['error'])) {
            $message_tmp_filename = $files['file']['tmp_name'];
            $message_filename = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);

            // Determinar el tipo de archivo
            $mime_type = mime_content_type($message_tmp_filename);
            if ($mime_type == 'image/jpg' || $mime_type == 'image/jpeg' || $mime_type == 'image/png') {
                $type = Storage::FILE_TYPE_IMAGE;
            } else if ($mime_type == 'video/webm' || $mime_type == 'video/mpeg' || $mime_type == 'video/mpg' || $mime_type == 'video/mp4') {
                $type = Storage::FILE_TYPE_VIDEO;
            } else if ($mime_type == 'application/pdf') {
                $type = Storage::FILE_TYPE_DOCUMENT;
            }
        }

        // Crear y guardar el mensaje
        $message = new Message();
        $message->conversation_id = $conversation->id;
        $message->read = Message::NO;
        $message->message = $type == Message::TYPE_TEXT ? $dataPost['message'] : '';
        $message->receiver_id = $user->id;
        $message->receiver_status = Message::STATUS_NORMAL;
        $message->sender_id = $currentUser->id;
        $message->sender_status = Message::STATUS_NORMAL;
        $message->type = $type;

        $messageMapper = MessageMapper::getInstance($this->adapter);
        if (!$messageMapper->insert($message)) {
            return new JsonModel([
                'success' => false,
                'data' => $messageMapper->getError()
            ]);
        }

        // Procesar archivo adjunto si existe
        if ($message_filename) {
            $storage = new Storage();
            $storage->setAdapter($this->adapter);
            $storage->setLogger($this->logger);
            $storage->setTranslator($this->translator);

            if (!$storage->uploadMessageFile($message_tmp_filename, $message_filename, $message->uuid)) {
                return new JsonModel([
                    'success' => false,
                    'data' => $storage->getError()
                ]);
            }

            $message->filename = $message_filename;
            if (!$messageMapper->update($message)) {
                return new JsonModel([
                    'success' => false,
                    'data' => $messageMapper->getError()
                ]);
            }
        }

        // Preparar respuesta exitosa
        $filename = '';
        if ($message->filename) {
            $filename = $this->url()->fromRoute('storage', [
                'type' => 'message',
                'filename' => $message->filename,
                'code' => $message->uuid
            ], ['force_canonical' => true]);
        }

        // Actualizar última actividad del usuario
        $userMapper->updateLastActivity($currentUser->id);

        // Devolver respuesta exitosa con datos del mensaje
        return new JsonModel([
            'success' => true,
            'data' => [
                'sender_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
                'sender_image' => $this->url()->fromRoute('storage', [
                    'type' => 'user',
                    'filename' => $currentUser->image,
                    'code' => $currentUser->uuid
                ], ['force_canonical' => true]),
                'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
                'receiver_name' => trim($user->first_name . ' ' . $user->last_name),
                'receiver_image' => $this->url()->fromRoute('storage', [
                    'type' => 'user',
                    'filename' => $user->image,
                    'code' => $user->uuid
                ], ['force_canonical' => true]),
                'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
                'side' => 'left',
                'message' => $message->message,
                'type' => $message->type,
                'filename' => $filename,
                'date' => $this->timeAgo($now, $now),
            ]
        ]);
    }



    /**
     *
     * @param string $timestamp
     * @param string $now
     * @return string
     */
    private function timeAgo($timestamp, $now = '')
    {

        if ($now) {
            $datetime1 = \DateTime::createFromFormat('Y-m-d H:i:s', $now);
        } else {
            $now = date('Y-m-d H:i:s');
            $datetime1 = date_create($now);
        }
        $datetime2 = date_create($timestamp);

        $diff = date_diff($datetime1, $datetime2);
        $timemsg = '';
        if ($diff->y > 0) {
            $timemsg = $diff->y . ' ' . ($diff->y > 1 ? $this->translator->translate('LABEL_YEARS_SMALL')  : $this->translator->translate('LABEL_YEAR_SMALL'));
        } else if ($diff->m > 0) {
            $timemsg = $diff->m  . ' ' . ($diff->m > 1 ? $this->translator->translate('LABEL_MONTHS_SMALL')  : $this->translator->translate('LABEL_MONTH_SMALL'));
        } else if ($diff->d > 0) {
            $timemsg = $diff->d . ' ' . ($diff->d > 1 ? $this->translator->translate('LABEL_DAYS_SMALL')  : $this->translator->translate('LABEL_DAY_SMALL'));
        } else if ($diff->h > 0) {
            $timemsg = $diff->h  . ' ' . ($diff->h > 1 ? $this->translator->translate('LABEL_HOURS_SMALL')  : $this->translator->translate('LABEL_HOUR_SMALL'));
        } else if ($diff->i > 0) {
            $timemsg = $diff->i  . ' ' . ($diff->i > 1 ? $this->translator->translate('LABEL_MINUTES_SMALL')  : $this->translator->translate('LABEL_MINUTE_SMALL'));
        } else if ($diff->s > 0) {
            $timemsg = $diff->s  . ' ' . ($diff->s > 1 ? $this->translator->translate('LABEL_SECONDS_SMALL')  : $this->translator->translate('LABEL_SECOND_SMALL'));
        }
        if (!$timemsg) {
            $timemsg = $this->translator->translate('LABEL_NOW');
        } else {
            $timemsg = $this->translator->translate('LABEL_AGO_SMALL') . ' ' . $timemsg . '';
        }
        return $timemsg;
    }


    public function deleteAction()
    {
        $request = $this->getRequest();
        if ($request->isPost()) {
            $currentUserPlugin = $this->plugin('currentUserPlugin');
            $currentUser = $currentUserPlugin->getUser();

            $id = $this->params()->fromRoute('id');
            if (!$id) {
                return new JsonModel([
                    'success' => false,
                    'data' => 'ERROR_PARAMETERS_ARE_INVALID'
                ]);
            }

            $userMapper = UserMapper::getInstance($this->adapter);
            $user = $userMapper->fetchOneByUuid($id);
            if (!$user) {
                return new JsonModel([
                    'success' => false,
                    'data' => 'ERROR_REQUEST_IS_INVALID'
                ]);
            }

            $conversationMapper = ConversationMapper::getInstance($this->adapter);
            $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);


            if ($conversation) {

                if ($conversation->sender_id == $currentUser->id && $conversation->receiver_id == $user->id) {
                    $conversation->sender_status = Conversation::STATUS_DELETED;
                    if ($conversationMapper->update($conversation)) {
                        $response = [
                            'success' => true,
                            'data' => 'LABEL_CONVERSATION_WAS_DELETED'
                        ];
                    } else {


                        $response = [
                            'success' => false,
                            'data' => $conversationMapper->getError()
                        ];
                    }
                }

                if ($conversation->receiver_id == $currentUser->id && $conversation->sender_id == $user->id) {
                    $conversation->receiver_status = Conversation::STATUS_DELETED;
                    if ($conversationMapper->update($conversation)) {
                        $response = [
                            'success' => true,
                            'data' => 'LABEL_CONVERSATION_WAS_DELETED'
                        ];
                    } else {


                        $response = [
                            'success' => false,
                            'data' => $conversationMapper->getError()
                        ];
                    }
                }

                return new JsonModel($response);
            } else {
                $response = [
                    'success' => false,
                    'data' => 'ERROR_CONVERSATION_NOT_FOUND'
                ];
            }

            return new JsonModel($response);
        } else {
            $response = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];
        }

        return new JsonModel($response);
    }
}