Proyectos de Subversion LeadersLinked - Services

<?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/messages', ['id' => $company->uuid]),

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

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

                        'delete_link' => $this->url()->fromRoute('inmail/message/delete', ['id' => $company->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/messages', ['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]),

                        ]);

                    }

                }

            }

        }

        $records = $conversationMapper->fetchAllByUserId($currentUser->id);

        foreach ($records as $record) {

            // 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/messages', ['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/messages/: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 messagesAction()

    {

        $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);

    }

}