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\ConversationMapper;

use LeadersLinked\Mapper\MessageMapper;

use LeadersLinked\Model\Conversation;

use Laminas\View\Model\JsonModel;

use LeadersLinked\Form\InMail\SendForm;

use LeadersLinked\Model\Message;

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;

    }

    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'

            ]);

        }

        // 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();

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

        $storage = Storage::getInstance($this->config, $this->adapter);

        $conversationMapper = ConversationMapper::getInstance($this->adapter);

        $messageMapper = MessageMapper::getInstance($this->adapter);

        $conversations = [];

        $selected_user_id = 0;

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

        $id = $this->params()->fromRoute('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;

                }

            }

            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;

                }

            }

            $timeElapsedString = '';

            $unread = $messageMapper->fetchCountUnreadMessagesByConversationIdAndReceiverId(

                $record->id,

                $currentUser->id

            );

            $lastMessage = $messageMapper->fetchLastMessagesByConversationIdAndReceiverId(

                $record->id,

                $currentUser->id

            );

            if ($lastMessage) {

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

            }

            array_push($conversations, [

                'uuid' => $user->uuid,

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

                'image' => $storage->getUserImage($user),

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

                'last_message' => $timeElapsedString,

                'count_unread' => $unread,

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

                'selected' => 0,

            ]);

        }

        // 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;

            }

        });

        return new JsonModel([

            'success' => true,

            'data' => $conversations

        ]);

    }

    public function getMessagesAction()

    {

        $request = $this->getRequest();

        if (!$request->isGet()) {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

        $page = intval($this->params()->fromQuery('page', 0), 10);

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

        if (!$uuid) {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_PARAMETERS_ARE_INVALID'

            ]);

        }

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $userMapper = UserMapper::getInstance($this->adapter);

        $now = $userMapper->getDatebaseNow();

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

        if (!$user) {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_REQUEST_IS_INVALID'

            ]);

        }

        $abuseReportMapper = AbuseReportMapper::getInstance($this->adapter);

        $abuse_report_message_ids = $abuseReportMapper->fetchAllDataByUserReportingIdAndTypeReturnIds(

            $currentUser->id,

            AbuseReport::TYPE_INMAIL_MESSAGE

        );

        $conversationMapper = ConversationMapper::getInstance($this->adapter);

        $messageMapper = MessageMapper::getInstance($this->adapter);

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

        $messages = [];

        if ($conversation) {

            $records = $messageMapper->getAllMessagesPaginatorByConversationId($conversation->id, $page);

            foreach ($records as $record) {

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

                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',

                        '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

                    ]);

                }

                else {

                    if (in_array($record->id, $abuse_report_message_ids)) {

                        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',

                            'message' => 'LABEL_ABUSE_CONTENT_REPORTED',

                            'type' => Message::TYPE_TEXT,

                            'filename' => '',

                            'date' => $timeElapsedString,

                            'url_abuse_report' => '', // Ya no se puede reportar

                        ]);

                    } else {

                        $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',

                            '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,

                        ]);

                        $messageMapper->markAsRead($record->id);

                    }

                }

            }

            return new JsonModel([

                'success' => true,

                'data' => $messages,

                'pagination' => $records->getPages()

            ]);

        }

        return new JsonModel([

            'success' => true,

            'data' => $messages,

            'pagination' => 1

        ]);

    }

    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

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

        if (!$uuid) {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_PARAMETERS_ARE_INVALID'

            ]);

        }

        // Buscar el usuario destinatario

        $user = $userMapper->fetchOneByUuidAndNetworkId($uuid, $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),

            ]

        ]);

    }

    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 deleteMessageAction()

    {

        $request = $this->getRequest();

        if ($request->isPost()) {

            $currentUserPlugin = $this->plugin('currentUserPlugin');

            $currentUser = $currentUserPlugin->getUser();

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

            if (!$uuid) {

                return new JsonModel([

                    'success' => false,

                    'data' => 'ERROR_PARAMETERS_ARE_INVALID'

                ]);

            }

            $userMapper = UserMapper::getInstance($this->adapter);

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

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

    }

}