Proyectos de Subversion LeadersLinked - Services

Rev

Rev 681 | Rev 683 | Ir a la última revisión | | Comparar con el anterior | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 efrain 1
<?php
2
 
3
declare(strict_types=1);
4
 
5
namespace LeadersLinked\Controller;
6
 
7
use Laminas\Db\Adapter\AdapterInterface;
8
 
9
use Laminas\Mvc\Controller\AbstractActionController;
10
use Laminas\Log\LoggerInterface;
11
use Laminas\View\Model\ViewModel;
12
 
13
use LeadersLinked\Library\Functions;
14
use LeadersLinked\Mapper\UserMapper;
15
 
16
use LeadersLinked\Model\User;
17
 
18
use LeadersLinked\Mapper\UserBlockedMapper;
19
 
20
use LeadersLinked\Mapper\CompanyMapper;
21
use LeadersLinked\Mapper\CompanyUserMapper;
307 www 22
use LeadersLinked\Mapper\ConversationMapper;
23
use LeadersLinked\Mapper\MessageMapper;
24
use LeadersLinked\Model\Conversation;
1 efrain 25
use LeadersLinked\Library\Image;
26
use Laminas\View\Model\JsonModel;
307 www 27
use LeadersLinked\Form\InMail\SendForm;
28
use LeadersLinked\Model\Message;
29
use LeadersLinked\Model\VideoConvert;
30
use LeadersLinked\Mapper\VideoConvertMapper;
1 efrain 31
use Laminas\Mvc\I18n\Translator;
199 efrain 32
use LeadersLinked\Mapper\AbuseReportMapper;
33
use LeadersLinked\Model\AbuseReport;
345 www 34
use LeadersLinked\Library\Storage;
1 efrain 35
 
36
class InMailController extends AbstractActionController
37
{
38
    /**
39
     *
40
     * @var \Laminas\Db\Adapter\AdapterInterface
41
     */
42
    private $adapter;
582 ariadna 43
 
1 efrain 44
    /**
45
     *
46
     * @var \LeadersLinked\Cache\CacheInterface
47
     */
48
    private $cache;
582 ariadna 49
 
50
 
1 efrain 51
    /**
52
     *
53
     * @var \Laminas\Log\LoggerInterface
54
     */
55
    private $logger;
582 ariadna 56
 
1 efrain 57
    /**
58
     *
59
     * @var array
60
     */
61
    private $config;
582 ariadna 62
 
63
 
1 efrain 64
    /**
65
     *
66
     * @var \Laminas\Mvc\I18n\Translator
67
     */
68
    private $translator;
582 ariadna 69
 
70
 
1 efrain 71
    /**
72
     *
73
     * @param \Laminas\Db\Adapter\AdapterInterface $adapter
74
     * @param \LeadersLinked\Cache\CacheInterface $cache
75
     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger
76
     * @param array $config
77
     * @param \Laminas\Mvc\I18n\Translator $translator
78
     */
79
    public function __construct($adapter, $cache, $logger, $config, $translator)
80
    {
81
        $this->adapter      = $adapter;
82
        $this->cache        = $cache;
83
        $this->logger       = $logger;
84
        $this->config       = $config;
85
        $this->translator   = $translator;
86
    }
87
 
88
    /**
667 stevensc 89
     * Genera el listado de conversaciones del usuario actual
1 efrain 90
     *
667 stevensc 91
     * Endpoint: GET /inmail
1 efrain 92
     *
667 stevensc 93
     * Parámetros de ruta:
94
     * - id: UUID del usuario o empresa para seleccionar automáticamente (opcional)
95
     *
96
     * Respuesta exitosa:
1 efrain 97
     * [
667 stevensc 98
     *   success: true,
99
     *   data: [
100
     *     [
101
     *       uuid: UUID del usuario/empresa con quien se tiene la conversación,
102
     *       name: nombre del usuario/empresa,
103
     *       image: URL de la imagen del usuario/empresa,
104
     *       profile: URL del perfil del usuario/empresa,
105
     *       last_message: tiempo transcurrido del último mensaje,
307 www 106
     *       count_unread: cantidad de mensajes sin leer,
667 stevensc 107
     *       messages_link: URL para recuperar los mensajes,
108
     *       send_link: URL para enviar mensaje,
109
     *       selected: 0 = no seleccionado, 1 = seleccionado,
110
     *       delete_link: URL para eliminar la conversación
307 www 111
     *     ]
667 stevensc 112
     *   ]
113
     * ]
1 efrain 114
     *
667 stevensc 115
     * Respuesta de error:
116
     * [
117
     *   success: false,
118
     *   data: mensaje de error
119
     * ]
1 efrain 120
     *
121
     * @return \Laminas\View\Model\JsonModel
122
     */
123
    public function indexAction()
124
    {
125
        $request = $this->getRequest();
667 stevensc 126
 
127
        // Verificar que la petición sea GET
128
        if (!$request->isGet()) {
129
            return new JsonModel([
130
                'success' => false,
131
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
132
            ]);
133
        }
307 www 134
 
667 stevensc 135
        // Obtener el usuario actual autenticado
136
        $currentUserPlugin = $this->plugin('currentUserPlugin');
137
        $currentUser = $currentUserPlugin->getUser();
307 www 138
 
667 stevensc 139
        // Obtener la fecha actual de la base de datos para cálculos de tiempo
140
        $userMapper = UserMapper::getInstance($this->adapter);
141
        $now = $userMapper->getDatebaseNow();
1 efrain 142
 
667 stevensc 143
        // Obtener IDs de usuarios que el usuario actual ha bloqueado
144
        $userBlockedMapper = UserBlockedMapper::getInstance($this->adapter);
145
        $user_blocked_ids = $userBlockedMapper->fetchAllBlockedReturnIds($currentUser->id);
199 efrain 146
 
667 stevensc 147
        // Obtener IDs de usuarios que han bloqueado al usuario actual
148
        $user_blocked_me_ids = $userBlockedMapper->fetchAllUserBlockMeReturnIds($currentUser->id);
1 efrain 149
 
667 stevensc 150
        $conversationMapper = ConversationMapper::getInstance($this->adapter);
151
        $messageMapper = MessageMapper::getInstance($this->adapter);
152
        $conversations = [];
153
        $selected_user_id = 0;
307 www 154
 
667 stevensc 155
        $records = $conversationMapper->fetchAllByUserId($currentUser->id);
681 stevensc 156
 
157
        $id = $this->params()->fromRoute('id');
158
        if ($id) {
159
            $companyMapper = CompanyMapper::getInstance($this->adapter);
160
            $company = $companyMapper->fetchOneByUuid($id);
161
 
162
            if ($company) {
163
                // Buscar el propietario de la empresa
164
                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
165
                $companyUser = $companyUserMapper->fetchOwnerByCompanyId($company->id);
166
 
167
                // Verificar que no haya bloqueos entre usuarios
168
                if (!in_array($companyUser->user_id, $user_blocked_ids) &&
169
                    !in_array($companyUser->id, $user_blocked_me_ids)) {
170
 
171
                    $user = $userMapper->fetchOne($companyUser->user_id);
172
                    $selected_user_id = $user->id;
173
 
174
                    // Buscar conversación existente
175
                    $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);
176
 
177
                    // Calcular tiempo del último mensaje y mensajes no leídos
178
                    $timeElapsedString = '';
179
                    if ($conversation) {
180
                        $unread = $messageMapper->fetchCountUnreadMessagesByConversationIdAndReceiverId(
181
                            $conversation->id,
182
                            $currentUser->id
183
                        );
184
                        $lastMessage = $messageMapper->fetchLastUnreadMessagesByConversationIdAndReceiverId(
185
                            $conversation->id,
186
                            $currentUser->id
187
                        );
188
 
189
                        if ($lastMessage) {
190
                            $timeElapsedString = $this->timeAgo($lastMessage, $now);
191
                        }
192
                    } else {
193
                        $unread = 0;
194
                    }
195
 
196
                    // Agregar conversación de empresa a la lista
197
                    array_push($conversations, [
198
                        'uuid' => $company->uuid,
199
                        'name' => $company->name,
200
                        'image' => $this->url()->fromRoute('storage', [
201
                            'type' => 'company',
202
                            'code' => $company->uuid,
203
                            'filename' => $company->image
204
                        ], ['force_canonical' => true]),
205
                        'profile' => $this->url()->fromRoute('company/view', ['id' => $company->uuid]),
206
                        'last_message' => $timeElapsedString,
207
                        'count_unread' => $unread,
208
                        'selected' => 1, // Marcar como seleccionado
209
                    ]);
210
                }
211
            }
212
            else {
213
                $user = $userMapper->fetchOneByUuid($id);
214
                if ($user) {
215
                    // Verificar que no haya bloqueos entre usuarios
216
                    if (!in_array($user->id, $user_blocked_ids) &&
217
                        !in_array($user->id, $user_blocked_me_ids)) {
218
 
219
                        $timeElapsedString = '';
220
                        $selected_user_id = $user->id;
221
 
222
                        // Buscar conversación existente
223
                        $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);
224
 
225
                        if ($conversation) {
226
                            $unread = $messageMapper->fetchCountUnreadMessagesByConversationIdAndReceiverId(
227
                                $conversation->id,
228
                                $currentUser->id
229
                            );
230
                            $lastMessage = $messageMapper->fetchLastUnreadMessagesByConversationIdAndReceiverId(
231
                                $conversation->id,
232
                                $currentUser->id
233
                            );
234
 
235
                            if ($lastMessage) {
236
                                $timeElapsedString = $this->timeAgo($lastMessage, $now);
237
                            }
238
                        } else {
239
                            $unread = 0;
240
                        }
241
 
242
                        // Agregar conversación de usuario a la lista
243
                        array_push($conversations, [
244
                            'uuid' => $user->uuid,
245
                            'name' => trim($user->first_name . ' ' . $user->last_name),
246
                            'image' => $this->url()->fromRoute('storage', [
247
                                'type' => 'user',
248
                                'code' => $user->uuid,
249
                                'filename' => $user->image
250
                            ], ['force_canonical' => true]),
251
                            'profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
252
                            'last_message' => $timeElapsedString,
253
                            'count_unread' => $unread,
254
                            'selected' => 1, // Marcar como seleccionado
255
                        ]);
256
                    }
257
                }
258
            }
259
        }
667 stevensc 260
 
673 stevensc 261
        foreach ($records as $record) {
667 stevensc 262
            // Omitir conversaciones que ya fueron procesadas como seleccionadas
263
            if ($selected_user_id) {
264
                if ($record->sender_id == $currentUser->id && $record->receiver_id == $selected_user_id) {
265
                    continue;
1 efrain 266
                }
667 stevensc 267
                if ($record->receiver_id == $currentUser->id && $record->sender_id == $selected_user_id) {
268
                    continue;
582 ariadna 269
                }
667 stevensc 270
            }
1 efrain 271
 
667 stevensc 272
            if ($record->sender_id == $currentUser->id) {
273
                $user = $userMapper->fetchOne($record->receiver_id);
274
            }
275
            if ($record->receiver_id == $currentUser->id) {
276
                $user = $userMapper->fetchOne($record->sender_id);
277
 
278
                // Omitir usuarios bloqueados
279
                if (in_array($user->id, $user_blocked_ids) || in_array($user->id, $user_blocked_me_ids)) {
280
                    continue;
582 ariadna 281
                }
667 stevensc 282
            }
1 efrain 283
 
667 stevensc 284
            $timeElapsedString = '';
285
            $unread = $messageMapper->fetchCountUnreadMessagesByConversationIdAndReceiverId(
286
                $record->id,
287
                $currentUser->id
288
            );
289
            $lastMessage = $messageMapper->fetchLastMessagesByConversationIdAndReceiverId(
290
                $record->id,
291
                $currentUser->id
292
            );
1 efrain 293
 
667 stevensc 294
            if ($lastMessage) {
295
                $timeElapsedString = $this->timeAgo($lastMessage, $now);
582 ariadna 296
            }
1 efrain 297
 
667 stevensc 298
            array_push($conversations, [
299
                'uuid' => $user->uuid,
300
                'name' => trim($user->first_name . ' ' . $user->last_name),
301
                'image' => $this->url()->fromRoute('storage', [
302
                    'type' => 'user',
303
                    'code' => $user->uuid,
304
                    'filename' => $user->image
305
                ], ['force_canonical' => true]),
306
                'profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
307
                'last_message' => $timeElapsedString,
308
                'count_unread' => $unread,
309
                'selected' => 0, // No seleccionado
310
            ]);
311
        }
1 efrain 312
 
667 stevensc 313
        // Ordenar por: seleccionados primero, luego por fecha del último mensaje
314
        usort($conversations, function ($a, $b) {
315
            if ($a['selected'] == $b['selected']) {
316
                if ($a['last_message'] == $b['last_message']) {
317
                    return 0;
582 ariadna 318
                } else {
667 stevensc 319
                    return $a['last_message'] < $b['last_message'] ? -1 : 1;
582 ariadna 320
                }
667 stevensc 321
            } else {
322
                return $a['selected'] < $b['selected'] ? -1 : 1;
323
            }
324
        });
1 efrain 325
 
667 stevensc 326
        return new JsonModel([
327
            'success' => true,
328
            'data' => $conversations
329
        ]);
1 efrain 330
    }
307 www 331
 
332
    /**
666 stevensc 333
     * Recupera los mensajes de una conversación específica entre usuarios
334
     *
675 stevensc 335
     * Endpoint: GET /inmail/messages/:id
666 stevensc 336
     *
337
     * Parámetros de consulta:
338
     * - page: número de página para paginación (opcional, por defecto 0)
339
     *
340
     * Respuesta exitosa:
307 www 341
     * [
342
     *   success: true,
666 stevensc 343
     *   data: [
344
     *     [
345
     *       uuid: UUID del mensaje,
346
     *       sender_name: nombre del remitente,
347
     *       sender_image: URL de la imagen del remitente,
348
     *       sender_profile: URL del perfil del remitente,
349
     *       receiver_name: nombre del destinatario,
350
     *       receiver_image: URL de la imagen del destinatario,
351
     *       receiver_profile: URL del perfil del destinatario,
352
     *       side: 'left' (mensaje propio) | 'right' (mensaje recibido),
353
     *       message: contenido del mensaje,
354
     *       type: 'text' | 'image' | 'video' | 'document',
355
     *       filename: URL del archivo adjunto (si existe),
356
     *       date: tiempo transcurrido desde el envío,
357
     *       url_abuse_report: URL para reportar abuso (solo mensajes recibidos)
358
     *     ]
359
     *   ],
360
     *   pagination: información de paginación
361
     * ]
362
     *
363
     * Respuesta de error:
307 www 364
     * [
666 stevensc 365
     *   success: false,
366
     *   data: mensaje de error
307 www 367
     * ]
666 stevensc 368
     *
307 www 369
     * @return \Laminas\View\Model\JsonModel
370
     */
677 stevensc 371
    public function getMessagesAction()
1 efrain 372
    {
373
        $request = $this->getRequest();
666 stevensc 374
 
375
        // Verificar que la petición sea GET
376
        if (!$request->isGet()) {
377
            return new JsonModel([
378
                'success' => false,
379
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
380
            ]);
381
        }
382
 
383
        // Obtener parámetros de la petición
384
        $page = intval($this->params()->fromQuery('page', 0), 10);
385
        $id = $this->params()->fromRoute('id');
386
 
387
        // Validar que se proporcione el ID del usuario
388
        if (!$id) {
389
            return new JsonModel([
390
                'success' => false,
391
                'data' => 'ERROR_PARAMETERS_ARE_INVALID'
392
            ]);
393
        }
307 www 394
 
666 stevensc 395
        // Obtener el usuario actual autenticado
396
        $currentUserPlugin = $this->plugin('currentUserPlugin');
397
        $currentUser = $currentUserPlugin->getUser();
582 ariadna 398
 
666 stevensc 399
        // Obtener la fecha actual de la base de datos para cálculos de tiempo
400
        $userMapper = UserMapper::getInstance($this->adapter);
401
        $now = $userMapper->getDatebaseNow();
307 www 402
 
666 stevensc 403
        // Buscar el usuario destinatario por UUID
404
        $user = $userMapper->fetchOneByUuid($id);
405
        if (!$user) {
406
            return new JsonModel([
407
                'success' => false,
408
                'data' => 'ERROR_REQUEST_IS_INVALID'
409
            ]);
410
        }
307 www 411
 
666 stevensc 412
        // Obtener IDs de mensajes reportados por el usuario actual
413
        $abuseReportMapper = AbuseReportMapper::getInstance($this->adapter);
414
        $abuse_report_message_ids = $abuseReportMapper->fetchAllDataByUserReportingIdAndTypeReturnIds(
415
            $currentUser->id,
416
            AbuseReport::TYPE_INMAIL_MESSAGE
417
        );
307 www 418
 
666 stevensc 419
        $conversationMapper = ConversationMapper::getInstance($this->adapter);
420
        $messageMapper = MessageMapper::getInstance($this->adapter);
421
 
422
        // Buscar la conversación entre los dos usuarios
423
        $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);
424
 
425
        $messages = [];
426
 
427
        if ($conversation) {
428
            // Obtener mensajes paginados de la conversación
429
            $records = $messageMapper->getAllMessagesPaginatorByConversationId($conversation->id, $page);
582 ariadna 430
 
666 stevensc 431
            foreach ($records as $record) {
432
                // Calcular tiempo transcurrido desde el envío del mensaje
433
                $timeElapsedString = $this->timeAgo($record->added_on, $now);
307 www 434
 
666 stevensc 435
                if ($record->sender_id == $currentUser->id) {
436
                    array_push($messages, [
437
                        'uuid' => $record->uuid,
438
                        'sender_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
439
                        'sender_image' => $this->url()->fromRoute('storage', [
440
                            'type' => 'user',
441
                            'filename' => $currentUser->image,
442
                            'code' => $currentUser->uuid
443
                        ], ['force_canonical' => true]),
444
                        'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
445
                        'receiver_name' => trim($user->first_name . ' ' . $user->last_name),
446
                        'receiver_image' => $this->url()->fromRoute('storage', [
447
                            'type' => 'user',
448
                            'filename' => $user->image,
449
                            'code' => $user->uuid
450
                        ], ['force_canonical' => true]),
451
                        'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
452
                        'side' => 'left', // Mensaje propio (lado izquierdo)
453
                        'message' => $record->message,
454
                        'type' => $record->type,
455
                        'filename' => $record->filename ? $this->url()->fromRoute('storage', [
456
                            'type' => 'message',
457
                            'filename' => $record->filename,
458
                            'code' => $record->uuid
459
                        ], ['force_canonical' => true]) : '',
460
                        'date' => $timeElapsedString,
461
                        'url_abuse_report' => '', // No se puede reportar mensajes propios
462
                    ]);
463
                }
464
                else {
465
                    // Verificar si el mensaje ha sido reportado por abuso
466
                    if (in_array($record->id, $abuse_report_message_ids)) {
467
                        // Mensaje reportado - mostrar mensaje de contenido reportado
468
                        array_push($messages, [
469
                            'uuid' => $record->uuid,
470
                            'sender_name' => trim($user->first_name . ' ' . $user->last_name),
471
                            'sender_image' => $this->url()->fromRoute('storage', [
472
                                'type' => 'user',
473
                                'filename' => $user->image,
474
                                'code' => $user->uuid
475
                            ], ['force_canonical' => true]),
476
                            'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
477
                            'receiver_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
478
                            'receiver_image' => $this->url()->fromRoute('storage', [
479
                                'type' => 'user',
480
                                'filename' => $currentUser->image,
481
                                'code' => $user->uuid
482
                            ], ['force_canonical' => true]),
483
                            'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
484
                            'side' => 'right', // Mensaje recibido (lado derecho)
485
                            'message' => 'LABEL_ABUSE_CONTENT_REPORTED',
486
                            'type' => Message::TYPE_TEXT,
487
                            'filename' => '',
488
                            'date' => $timeElapsedString,
489
                            'url_abuse_report' => '', // Ya no se puede reportar
490
                        ]);
491
                    } else {
492
                        // Mensaje normal - generar URL para reportar abuso
493
                        $url_abuse_report = $this->url()->fromRoute('helpers/abuse-report', [
494
                            'type' => 'message',
495
                            'id' => $record->uuid
496
                        ], ['force_canonical' => true]);
582 ariadna 497
 
307 www 498
                        array_push($messages, [
499
                            'uuid' => $record->uuid,
666 stevensc 500
                            'sender_name' => trim($user->first_name . ' ' . $user->last_name),
501
                            'sender_image' => $this->url()->fromRoute('storage', [
502
                                'type' => 'user',
503
                                'filename' => $user->image,
504
                                'code' => $user->uuid
505
                            ], ['force_canonical' => true]),
506
                            'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
507
                            'receiver_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
508
                            'receiver_image' => $this->url()->fromRoute('storage', [
509
                                'type' => 'user',
510
                                'filename' => $currentUser->image,
511
                                'code' => $user->uuid
512
                            ], ['force_canonical' => true]),
513
                            'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
514
                            'side' => 'right', // Mensaje recibido (lado derecho)
307 www 515
                            'message' => $record->message,
516
                            'type' => $record->type,
666 stevensc 517
                            'filename' => $record->filename ? $this->url()->fromRoute('storage', [
518
                                'type' => 'message',
519
                                'filename' => $record->filename,
520
                                'code' => $record->uuid
521
                            ], ['force_canonical' => true]) : '',
307 www 522
                            'date' => $timeElapsedString,
666 stevensc 523
                            'url_abuse_report' => $url_abuse_report,
307 www 524
                        ]);
582 ariadna 525
 
666 stevensc 526
                        // Marcar el mensaje como leído
307 www 527
                        $messageMapper->markAsRead($record->id);
261 efrain 528
                    }
307 www 529
                }
1 efrain 530
            }
307 www 531
 
532
            return new JsonModel([
533
                'success' => true,
534
                'data' => $messages,
666 stevensc 535
                'pagination' => $records->getPages()
307 www 536
            ]);
1 efrain 537
        }
666 stevensc 538
 
539
        return new JsonModel([
540
            'success' => true,
541
            'data' => $messages,
542
            'pagination' => 1
543
        ]);
1 efrain 544
    }
307 www 545
 
546
    /**
589 ariadna 547
     * Envía un mensaje InMail a un usuario específico
307 www 548
     *
676 stevensc 549
     * Endpoint: POST /inmail/messages/send/:id
589 ariadna 550
     *
551
     * Parámetros requeridos:
552
     * - message: texto plano del mensaje
553
     *
554
     * Parámetros opcionales:
555
     * - file: archivo adjunto (jpg, jpeg, png, mp4, webm, mpeg, pdf)
556
     *
557
     * @return JsonModel
307 www 558
     */
559
    public function sendMessageAction()
1 efrain 560
    {
589 ariadna 561
        // Verificar que la petición sea POST
1 efrain 562
        $request = $this->getRequest();
589 ariadna 563
        if (!$request->isPost()) {
564
            return new JsonModel([
565
                'success' => false,
566
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
567
            ]);
568
        }
307 www 569
 
589 ariadna 570
        // Obtener el usuario actual
571
        $currentUserPlugin = $this->plugin('currentUserPlugin');
572
        $currentUser = $currentUserPlugin->getUser();
307 www 573
 
589 ariadna 574
        // Obtener la fecha actual de la base de datos
575
        $userMapper = UserMapper::getInstance($this->adapter);
576
        $now = $userMapper->getDatebaseNow();
582 ariadna 577
 
589 ariadna 578
        // Validar el ID del destinatario
579
        $id = $this->params()->fromRoute('id');
580
        if (!$id) {
581
            return new JsonModel([
582
                'success' => false,
583
                'data' => 'ERROR_PARAMETERS_ARE_INVALID'
584
            ]);
585
        }
307 www 586
 
589 ariadna 587
        // Buscar el usuario destinatario
588
        $user = $userMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);
589
        if (!$user) {
590
            return new JsonModel([
591
                'success' => false,
592
                'data' => 'ERROR_REQUEST_IS_INVALID'
593
            ]);
594
        }
307 www 595
 
589 ariadna 596
        // Combinar datos POST y archivos
597
        $data = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
307 www 598
 
589 ariadna 599
        // Si se envía un archivo sin error, usar su nombre como mensaje
600
        if (!empty($data['file']) && empty($data['file']['error'])) {
601
            $data['message'] = $data['file']['name'];
602
        }
307 www 603
 
589 ariadna 604
        // Validar los datos del formulario
605
        $form = new SendForm();
606
        $form->setData($data);
582 ariadna 607
 
589 ariadna 608
        if (!$form->isValid()) {
609
            // Si el formulario no es válido, devolver los errores
610
            $messages = [];
611
            $form_messages = (array) $form->getMessages();
612
            foreach ($form_messages as $fieldname => $field_messages) {
613
                $messages[$fieldname] = array_values($field_messages);
307 www 614
            }
589 ariadna 615
            return new JsonModel([
616
                'success' => false,
617
                'data' => $messages
618
            ]);
619
        }
582 ariadna 620
 
589 ariadna 621
        // Obtener los datos validados
622
        $dataPost = (array) $form->getData();
307 www 623
 
589 ariadna 624
        // Buscar o crear la conversación
625
        $conversationMapper = ConversationMapper::getInstance($this->adapter);
626
        $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);
307 www 627
 
589 ariadna 628
        if ($conversation) {
629
            // Actualizar estado de la conversación existente
630
            $conversation->receiver_status = Conversation::STATUS_NORMAL;
631
            $conversation->sender_status = Conversation::STATUS_NORMAL;
307 www 632
 
589 ariadna 633
            if (!$conversationMapper->update($conversation)) {
634
                return new JsonModel([
635
                    'success' => false,
636
                    'data' => $conversationMapper->getError()
637
                ]);
638
            }
639
        } else {
640
            // Crear nueva conversación
641
            $conversation = new Conversation();
642
            $conversation->sender_id = $currentUser->id;
643
            $conversation->sender_status = Conversation::STATUS_NORMAL;
644
            $conversation->receiver_id = $user->id;
645
            $conversation->receiver_status = Conversation::STATUS_NORMAL;
582 ariadna 646
 
589 ariadna 647
            if (!$conversationMapper->insert($conversation)) {
648
                return new JsonModel([
649
                    'success' => false,
650
                    'data' => $conversationMapper->getError()
651
                ]);
652
            }
653
        }
307 www 654
 
589 ariadna 655
        // Procesar archivo adjunto si existe
656
        $files = $this->getRequest()->getFiles()->toArray();
657
        $type = Message::TYPE_TEXT;
658
        $message_tmp_filename = '';
659
        $message_filename = '';
307 www 660
 
589 ariadna 661
        if (isset($files['file']) && empty($files['file']['error'])) {
662
            $message_tmp_filename = $files['file']['tmp_name'];
663
            $message_filename = \LeadersLinked\Library\Functions::normalizeStringFilename($files['file']['name']);
307 www 664
 
589 ariadna 665
            // Determinar el tipo de archivo
666
            $mime_type = mime_content_type($message_tmp_filename);
667
            if ($mime_type == 'image/jpg' || $mime_type == 'image/jpeg' || $mime_type == 'image/png') {
668
                $type = Storage::FILE_TYPE_IMAGE;
669
            } else if ($mime_type == 'video/webm' || $mime_type == 'video/mpeg' || $mime_type == 'video/mpg' || $mime_type == 'video/mp4') {
670
                $type = Storage::FILE_TYPE_VIDEO;
671
            } else if ($mime_type == 'application/pdf') {
672
                $type = Storage::FILE_TYPE_DOCUMENT;
673
            }
674
        }
307 www 675
 
589 ariadna 676
        // Crear y guardar el mensaje
677
        $message = new Message();
678
        $message->conversation_id = $conversation->id;
679
        $message->read = Message::NO;
680
        $message->message = $type == Message::TYPE_TEXT ? $dataPost['message'] : '';
681
        $message->receiver_id = $user->id;
682
        $message->receiver_status = Message::STATUS_NORMAL;
683
        $message->sender_id = $currentUser->id;
684
        $message->sender_status = Message::STATUS_NORMAL;
685
        $message->type = $type;
307 www 686
 
589 ariadna 687
        $messageMapper = MessageMapper::getInstance($this->adapter);
688
        if (!$messageMapper->insert($message)) {
689
            return new JsonModel([
690
                'success' => false,
691
                'data' => $messageMapper->getError()
692
            ]);
693
        }
307 www 694
 
589 ariadna 695
        // Procesar archivo adjunto si existe
696
        if ($message_filename) {
697
            $storage = new Storage();
698
            $storage->setAdapter($this->adapter);
699
            $storage->setLogger($this->logger);
700
            $storage->setTranslator($this->translator);
307 www 701
 
589 ariadna 702
            if (!$storage->uploadMessageFile($message_tmp_filename, $message_filename, $message->uuid)) {
703
                return new JsonModel([
704
                    'success' => false,
705
                    'data' => $storage->getError()
706
                ]);
707
            }
307 www 708
 
589 ariadna 709
            $message->filename = $message_filename;
710
            if (!$messageMapper->update($message)) {
1 efrain 711
                return new JsonModel([
589 ariadna 712
                    'success' => false,
713
                    'data' => $messageMapper->getError()
1 efrain 714
                ]);
715
            }
716
        }
589 ariadna 717
 
718
        // Preparar respuesta exitosa
719
        $filename = '';
720
        if ($message->filename) {
721
            $filename = $this->url()->fromRoute('storage', [
722
                'type' => 'message',
723
                'filename' => $message->filename,
724
                'code' => $message->uuid
725
            ], ['force_canonical' => true]);
726
        }
727
 
728
        // Actualizar última actividad del usuario
729
        $userMapper->updateLastActivity($currentUser->id);
730
 
731
        // Devolver respuesta exitosa con datos del mensaje
732
        return new JsonModel([
733
            'success' => true,
734
            'data' => [
735
                'sender_name' => trim($currentUser->first_name . ' ' . $currentUser->last_name),
736
                'sender_image' => $this->url()->fromRoute('storage', [
737
                    'type' => 'user',
738
                    'filename' => $currentUser->image,
739
                    'code' => $currentUser->uuid
740
                ], ['force_canonical' => true]),
741
                'sender_profile' => $this->url()->fromRoute('profile/view', ['id' => $currentUser->uuid]),
742
                'receiver_name' => trim($user->first_name . ' ' . $user->last_name),
743
                'receiver_image' => $this->url()->fromRoute('storage', [
744
                    'type' => 'user',
745
                    'filename' => $user->image,
746
                    'code' => $user->uuid
747
                ], ['force_canonical' => true]),
748
                'receiver_profile' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
749
                'side' => 'left',
750
                'message' => $message->message,
751
                'type' => $message->type,
752
                'filename' => $filename,
753
                'date' => $this->timeAgo($now, $now),
754
            ]
755
        ]);
1 efrain 756
    }
307 www 757
 
758
    /**
759
     *
760
     * @param string $timestamp
761
     * @param string $now
762
     * @return string
763
     */
764
    private function timeAgo($timestamp, $now = '')
765
    {
582 ariadna 766
 
307 www 767
        if ($now) {
768
            $datetime1 = \DateTime::createFromFormat('Y-m-d H:i:s', $now);
1 efrain 769
        } else {
307 www 770
            $now = date('Y-m-d H:i:s');
771
            $datetime1 = date_create($now);
1 efrain 772
        }
307 www 773
        $datetime2 = date_create($timestamp);
582 ariadna 774
 
307 www 775
        $diff = date_diff($datetime1, $datetime2);
776
        $timemsg = '';
777
        if ($diff->y > 0) {
582 ariadna 778
            $timemsg = $diff->y . ' ' . ($diff->y > 1 ? $this->translator->translate('LABEL_YEARS_SMALL')  : $this->translator->translate('LABEL_YEAR_SMALL'));
307 www 779
        } else if ($diff->m > 0) {
582 ariadna 780
            $timemsg = $diff->m  . ' ' . ($diff->m > 1 ? $this->translator->translate('LABEL_MONTHS_SMALL')  : $this->translator->translate('LABEL_MONTH_SMALL'));
307 www 781
        } else if ($diff->d > 0) {
582 ariadna 782
            $timemsg = $diff->d . ' ' . ($diff->d > 1 ? $this->translator->translate('LABEL_DAYS_SMALL')  : $this->translator->translate('LABEL_DAY_SMALL'));
307 www 783
        } else if ($diff->h > 0) {
582 ariadna 784
            $timemsg = $diff->h  . ' ' . ($diff->h > 1 ? $this->translator->translate('LABEL_HOURS_SMALL')  : $this->translator->translate('LABEL_HOUR_SMALL'));
307 www 785
        } else if ($diff->i > 0) {
582 ariadna 786
            $timemsg = $diff->i  . ' ' . ($diff->i > 1 ? $this->translator->translate('LABEL_MINUTES_SMALL')  : $this->translator->translate('LABEL_MINUTE_SMALL'));
307 www 787
        } else if ($diff->s > 0) {
582 ariadna 788
            $timemsg = $diff->s  . ' ' . ($diff->s > 1 ? $this->translator->translate('LABEL_SECONDS_SMALL')  : $this->translator->translate('LABEL_SECOND_SMALL'));
307 www 789
        }
790
        if (!$timemsg) {
582 ariadna 791
            $timemsg = $this->translator->translate('LABEL_NOW');
307 www 792
        } else {
582 ariadna 793
            $timemsg = $this->translator->translate('LABEL_AGO_SMALL') . ' ' . $timemsg . '';
307 www 794
        }
795
        return $timemsg;
1 efrain 796
    }
307 www 797
 
798
    public function deleteAction()
1 efrain 799
    {
800
        $request = $this->getRequest();
801
        if ($request->isPost()) {
802
            $currentUserPlugin = $this->plugin('currentUserPlugin');
803
            $currentUser = $currentUserPlugin->getUser();
582 ariadna 804
 
1 efrain 805
            $id = $this->params()->fromRoute('id');
806
            if (!$id) {
807
                return new JsonModel([
808
                    'success' => false,
809
                    'data' => 'ERROR_PARAMETERS_ARE_INVALID'
810
                ]);
811
            }
582 ariadna 812
 
307 www 813
            $userMapper = UserMapper::getInstance($this->adapter);
814
            $user = $userMapper->fetchOneByUuid($id);
1 efrain 815
            if (!$user) {
816
                return new JsonModel([
817
                    'success' => false,
818
                    'data' => 'ERROR_REQUEST_IS_INVALID'
819
                ]);
820
            }
582 ariadna 821
 
307 www 822
            $conversationMapper = ConversationMapper::getInstance($this->adapter);
823
            $conversation = $conversationMapper->fetchOneByUserId1AndUserId2($currentUser->id, $user->id);
582 ariadna 824
 
825
 
307 www 826
            if ($conversation) {
582 ariadna 827
 
307 www 828
                if ($conversation->sender_id == $currentUser->id && $conversation->receiver_id == $user->id) {
829
                    $conversation->sender_status = Conversation::STATUS_DELETED;
830
                    if ($conversationMapper->update($conversation)) {
831
                        $response = [
832
                            'success' => true,
833
                            'data' => 'LABEL_CONVERSATION_WAS_DELETED'
834
                        ];
835
                    } else {
582 ariadna 836
 
837
 
307 www 838
                        $response = [
839
                            'success' => false,
840
                            'data' => $conversationMapper->getError()
841
                        ];
291 www 842
                    }
307 www 843
                }
582 ariadna 844
 
307 www 845
                if ($conversation->receiver_id == $currentUser->id && $conversation->sender_id == $user->id) {
846
                    $conversation->receiver_status = Conversation::STATUS_DELETED;
847
                    if ($conversationMapper->update($conversation)) {
848
                        $response = [
849
                            'success' => true,
850
                            'data' => 'LABEL_CONVERSATION_WAS_DELETED'
851
                        ];
291 www 852
                    } else {
582 ariadna 853
 
854
 
307 www 855
                        $response = [
856
                            'success' => false,
857
                            'data' => $conversationMapper->getError()
858
                        ];
1 efrain 859
                    }
860
                }
582 ariadna 861
 
307 www 862
                return new JsonModel($response);
1 efrain 863
            } else {
307 www 864
                $response = [
865
                    'success' => false,
866
                    'data' => 'ERROR_CONVERSATION_NOT_FOUND'
867
                ];
1 efrain 868
            }
582 ariadna 869
 
307 www 870
            return new JsonModel($response);
1 efrain 871
        } else {
307 www 872
            $response = [
1 efrain 873
                'success' => false,
874
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
307 www 875
            ];
1 efrain 876
        }
582 ariadna 877
 
307 www 878
        return new JsonModel($response);
1 efrain 879
    }
880
}