Proyectos de Subversion LeadersLinked - Antes de SPA

Rev

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

Rev Autor Línea Nro. Línea
1 www 1
<?php
2
/**
3
 *
4
 * Controlador: Mis Perfiles
5
 *
6
 */
7
declare(strict_types=1);
8
 
9
namespace LeadersLinked\Controller;
10
 
11
use Laminas\Db\Adapter\AdapterInterface;
12
use Laminas\Cache\Storage\Adapter\AbstractAdapter;
13
use Laminas\Mvc\Controller\AbstractActionController;
14
use Laminas\Log\LoggerInterface;
15
use Laminas\View\Model\JsonModel;
16
 
17
use LeadersLinked\Library\Functions;
18
use LeadersLinked\Mapper\CompanyUserMapper;
19
use LeadersLinked\Form\Feed\CreateForm;
20
use LeadersLinked\Hydrator\ObjectPropertyHydrator;
21
use LeadersLinked\Model\Feed;
22
use LeadersLinked\Mapper\FeedMapper;
23
use LeadersLinked\Library\Image;
24
use LeadersLinked\Mapper\GroupMapper;
25
use LeadersLinked\Mapper\UserMapper;
26
use LeadersLinked\Mapper\CommentMapper;
27
use LeadersLinked\Mapper\ConnectionMapper;
28
use LeadersLinked\Mapper\CompanyFollowerMapper;
29
use LeadersLinked\Mapper\QueryMapper;
30
use Laminas\Paginator\Paginator;
31
use Laminas\Paginator\Adapter\DbSelect;
32
use LeadersLinked\Mapper\LikeMapper;
33
use LeadersLinked\Model\Like;
34
use LeadersLinked\Form\Feed\CommentForm;
35
use LeadersLinked\Model\Comment;
36
use LeadersLinked\Form\Feed\CreateGroupCompanyForm;
37
use LeadersLinked\Model\CompanyUser;
38
use LeadersLinked\Model\VideoConvert;
39
use LeadersLinked\Mapper\VideoConvertMapper;
40
use LeadersLinked\Mapper\CompanyMapper;
41
use LeadersLinked\Model\Company;
42
use LeadersLinked\Model\Group;
43
use LeadersLinked\Mapper\GroupMemberMapper;
44
use LeadersLinked\Model\GroupMember;
45
use LeadersLinked\Model\Notification;
46
use LeadersLinked\Mapper\NotificationMapper;
47
use LeadersLinked\Mapper\UserNotificationSettingMapper;
48
use LeadersLinked\Mapper\EmailTemplateMapper;
49
use LeadersLinked\Model\EmailTemplate;
50
use LeadersLinked\Library\QueueEmail;
51
 
52
 
53
class FeedController extends AbstractActionController
54
{
55
    /**
56
     *
57
     * @var AdapterInterface
58
     */
59
    private $adapter;
60
 
61
 
62
    /**
63
     *
64
     * @var AbstractAdapter
65
     */
66
    private $cache;
67
 
68
    /**
69
     *
70
     * @var  LoggerInterface
71
     */
72
    private $logger;
73
 
74
 
75
    /**
76
     *
77
     * @var array
78
     */
79
    private $config;
80
 
81
    /**
82
     *
83
     * @param AdapterInterface $adapter
84
     * @param AbstractAdapter $cache
85
     * @param LoggerInterface $logger
86
     * @param array $config
87
     */
88
    public function __construct($adapter, $cache , $logger,  $config)
89
    {
90
        $this->adapter      = $adapter;
91
        $this->cache        = $cache;
92
        $this->logger       = $logger;
93
        $this->config       = $config;
94
 
95
    }
96
 
97
    /**
98
     *
99
     * Generación del listado de perfiles
100
     * {@inheritDoc}
101
     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()
102
     */
103
    public function indexAction()
104
    {
105
 
106
        return new JsonModel([
107
            'success' => false,
108
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
109
        ]);
110
    }
111
 
112
    public function commentAction()
113
    {
114
        $id = $this->params()->fromRoute('id');
115
 
116
        $request = $this->getRequest();
117
        if($request->isPost()) {
118
            $feedMapper = FeedMapper::getInstance($this->adapter);
119
            $feed = $feedMapper->fetchOneByUuid($id);
120
            if(!$feed) {
121
                $response = [
122
                    'success' => false,
123
                    'data' => 'ERROR_POST_NOT_FOUND'
124
                ];
125
                return new JsonModel($response);
126
            }
127
 
128
            $dataPost = $request->getPost()->toArray();
129
            $form = new CommentForm();
130
            $form->setData($dataPost);
131
 
132
            if($form->isValid()) {
133
                $currentUserPlugin = $this->plugin('currentUserPlugin');
134
                $currentUser = $currentUserPlugin->getUser();
135
 
136
                $dataPost = (array) $form->getData();
137
 
138
                $comment = new Comment();
139
                $comment->comment = $dataPost['comment'];
140
                $comment->user_id = $currentUser->id;
141
                $comment->feed_id = $feed->id;
142
 
143
                $commentMapper = CommentMapper::getInstance($this->adapter);
144
                if($commentMapper->insert($comment)) {
145
 
146
 
147
                    if($feed->type == Feed::TYPE_UPDATE) {
148
                        $userMapper = UserMapper::getInstance($this->adapter);
149
                        $ownerFeed = $userMapper->fetchOne($feed->user_id);
150
 
151
                        $notification = new Notification();
152
                        $notification->type = Notification::TYPE_COMMENT_MY_FEED;
153
                        $notification->feed_id = $feed->id;
154
                        $notification->read     = Notification::NO;
155
                        $notification->user_id  = $ownerFeed->id;
156
                        $notification->message  = 'LABEL_COMMENT_MY_FEED';
157
                        $notification->url      = $this->url()->fromRoute('dashboard',['feed' => $feed->uuid]);
158
 
159
                        $notificationMapper = NotificationMapper::getInstance($this->adapter);
160
                        $notificationMapper->insert($notification);
161
 
162
                        $userNotificationMapper = UserNotificationSettingMapper::getInstance($this->adapter);
163
                        $userNotification = $userNotificationMapper->fetchOne($ownerFeed->id);
164
 
165
                        if($userNotification && $userNotification->comment_my_feed)
166
                        {
167
                            $emailTemplateMapper = EmailTemplateMapper::getInstance($this->adapter);
168
                            $emailTemplate = $emailTemplateMapper->fetchOne(EmailTemplate::ID_COMMENT_MY_FEED);
169
 
170
                            if($emailTemplate) {
171
                                $arrayCont = [
172
                                    'firstname'             => $currentUser->first_name,
173
                                    'lastname'              => $currentUser->last_name,
174
                                    'other_user_firstname'  => $ownerFeed->first_name,
175
                                    'other_user_lastname'   => $ownerFeed->last_name,
176
                                    'company_name'          => '',
177
                                    'group_name'            => '',
178
                                    'content'               => '',
179
                                    'code'                  => '',
180
                                    'link'                  => $this->url()->fromRoute('dashboard',['feed' => $feed->uuid], ['force_canonical' => true])
181
                                ];
182
 
183
                                $email = new QueueEmail($this->adapter);
184
                                $email->processEmailTemplate($emailTemplate, $arrayCont, $ownerFeed->email, trim($ownerFeed->first_name . ' ' . $ownerFeed->last_name));
185
                            }
186
                        }
187
                    }
188
 
189
                    $total_comments = $commentMapper->fetchCountCommentByFeedId($comment->feed_id);
190
 
191
                    $feed->total_comments = $total_comments;
192
                    $feedMapper->update($feed);
193
 
194
                    $response = [
195
                        'success'   => true,
196
                        'data'   => $this->renderComment($comment->id),
197
                        'total_comments' => $total_comments
198
                    ];
199
 
200
                    return new JsonModel($response);
201
 
202
                } else {
203
 
204
                    $response = [
205
                        'success'   => false,
206
                        'data'   => $commentMapper->getError()
207
                    ];
208
 
209
                    return new JsonModel($response);
210
                }
211
 
212
            } else {
213
                $message = '';;
214
                $form_messages = (array) $form->getMessages();
215
                foreach($form_messages  as $fieldname => $field_messages)
216
                {
217
                    foreach( $field_messages as $key => $value)
218
                    {
219
                        $message = $value;
220
                    }
221
                }
222
 
223
                $response = [
224
                    'success'   => false,
225
                    'data'   => $message
226
                ];
227
 
228
                return new JsonModel($response);
229
            }
230
 
231
 
232
        } else {
233
            $response = [
234
                'success' => false,
235
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
236
            ];
237
 
238
            return new JsonModel($response);
239
        }
240
 
241
 
242
    }
243
 
244
    public function shareAction()
245
    {
246
        $id = $this->params()->fromRoute('id');
247
 
248
        $request = $this->getRequest();
249
        if($request->isPost()) {
250
            $feedMapper = FeedMapper::getInstance($this->adapter);
251
            $feed = $feedMapper->fetchOneByUuid($id);
252
            if(!$feed) {
253
                $response = [
254
                    'success' => false,
255
                    'data' => 'ERROR_POST_NOT_FOUND'
256
                ];
257
                return new JsonModel($response);
258
            }
259
 
260
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
261
            $dataPost['company_id'] = $this->params()->fromRoute('company_id');
262
            $dataPost['group_id'] = $this->params()->fromRoute('group_id');
263
            $dataPost['shared_feed_id'] = $feed->id;
264
 
265
 
266
 
267
 
268
            $response = $this->postOrShareFeed($dataPost);
269
            if( $response ['success']) {
270
                $feedMapper->incTotalShared($feed->id);
271
                $total_shared = $feedMapper->fetchTotalShared($feed->id);
272
 
273
                $response['total_shared'] = $total_shared;
274
            }
275
 
276
 
277
            return new JsonModel($response);
278
 
279
        } else {
280
            $response = [
281
                'success' => false,
282
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
283
            ];
284
        }
285
 
286
        return new JsonModel($response);
287
    }
288
 
289
    public function commentDeleteAction()
290
    {
291
        $request = $this->getRequest();
292
        if($request->isPost()) {
293
            $currentUserPlugin = $this->plugin('currentUserPlugin');
294
            $currentUser = $currentUserPlugin->getUser();
295
 
296
            $feed_id = $this->params()->fromRoute('id');
297
            $comment = $this->params()->fromRoute('comment');
298
 
299
            $feedMapper = FeedMapper::getInstance($this->adapter);
300
            $feed = $feedMapper->fetchOneByUuid($feed_id);
301
 
302
            if($feed) {
303
 
304
                $commentMapper = CommentMapper::getInstance($this->adapter);
305
                $comment = $commentMapper->fetchOneByUuid($comment);
306
 
307
                if($comment && $comment->feed_id == $feed->id && $comment->user_id == $currentUser->id) {
308
 
309
                    $comment->status = Comment::STATUS_DELETED;
310
 
311
                    if($commentMapper->update($comment)) {
312
 
313
                        $total_comments = $commentMapper->fetchCountCommentByFeedId($comment->feed_id);
314
 
315
 
316
                        $feedMapper = FeedMapper::getInstance($this->adapter);
317
                        $feed = $feedMapper->fetchOne($comment->feed_id);
318
                        $feed->total_comments = $total_comments;
319
                        $feedMapper->update($feed);
320
 
321
 
322
 
323
 
324
 
325
                        $response = [
326
                            'success' => true,
327
                            'data' => 'LABEL_COMMENT_WAS_DELETED',
328
                            'total_comments' => $total_comments
329
                        ];
330
 
331
                    } else {
332
                        $response = [
333
                            'success' => false,
334
                            'data' => $commentMapper->getError()
335
                        ];
336
                    }
337
 
338
                } else {
339
                    $response = [
340
                        'success' => false,
341
                        'data' => 'ERROR_COMMENT_NOT_FOUND'
342
                    ];
343
                }
344
            } else {
345
                $response = [
346
                    'success' => false,
347
                    'data' => 'ERROR_COMMENT_NOT_FOUND'
348
                ];
349
            }
350
        } else {
351
            $response = [
352
                'success' => false,
353
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
354
            ];
355
        }
356
 
357
        return new JsonModel($response);
358
    }
359
 
360
    public function deleteAction()
361
    {
362
        $request = $this->getRequest();
363
        if($request->isPost()) {
364
            $currentUserPlugin = $this->plugin('currentUserPlugin');
365
            $currentUser = $currentUserPlugin->getUser();
366
 
367
            $feed_id =  $this->params()->fromRoute('id');
368
 
369
            $feedMapper = FeedMapper::getInstance($this->adapter);
370
            $feed = $feedMapper->fetchOneByUuid($feed_id);
371
 
372
            if($feed) {
373
 
374
                if($feed->user_id && $feed->user_id == $currentUser->id) {
375
 
376
                    return new JsonModel($this->deleteFeed($feed));
377
                } else if ($feed->group_id) {
378
 
379
                    $groupMapper = GroupMapper::getInstance($this->adapter);
380
                    $group = $groupMapper->fetchOne($feed->group_id);
381
                    if($group && $group->user_id == $currentUser->id) {
382
                        return new JsonModel($this->deleteFeed($feed));
383
                    }
384
 
385
                } else if ($feed->company_id) {
386
                    $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
387
                    $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($feed->company_id, $currentUser->id);
388
                    if($companyUser) {
389
                        if(in_array($companyUser->type, [CompanyUser::TYPE_OWNER, CompanyUser::TYPE_ADMINISTRATOR, CompanyUser::TYPE_MANAGER])) {
390
                            return new JsonModel($this->deleteFeed($feed));
391
                        }
392
                    }
393
                }
394
 
395
                $response = [
396
                    'success' => false,
397
                    'data' => ' ERROR_UNAUTHORIZED'
398
                ];
399
 
400
 
401
            } else {
402
                $response = [
403
                    'success' => false,
404
                    'data' => 'ERROR_FEED_NOT_FOUND'
405
                ];
406
            }
407
 
408
            return new JsonModel($response);
409
 
410
        } else {
411
            $response = [
412
                'success' => false,
413
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
414
            ];
415
        }
416
 
417
        return new JsonModel($response);
418
    }
419
 
420
    public function addAction()
421
    {
422
        $request = $this->getRequest();
423
        if($request->isPost()) {
424
            $dataPost = array_merge($request->getPost()->toArray(), $request->getFiles()->toArray());
425
            $dataPost['company_id'] = $this->params()->fromRoute('company_id');
426
            $dataPost['group_id'] = $this->params()->fromRoute('group_id');
427
            $response = $this->postOrShareFeed($dataPost);
428
 
429
 
430
            return new JsonModel($response);
431
 
432
        } else {
433
            $response = [
434
                'success' => false,
435
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
436
            ];
437
        }
438
 
439
        return new JsonModel($response);
440
    }
441
 
442
    public function postOrShareFeed($dataPost)
443
    {
444
        $currentUserPlugin = $this->plugin('currentUserPlugin');
445
        $currentUser = $currentUserPlugin->getUser();
446
 
447
        $companyId  = empty($dataPost['company_id']) ? '' : $dataPost['company_id'];
448
        $groupId    = empty($dataPost['group_id']) ? '' : $dataPost['group_id'];
449
 
450
 
451
        if($groupId || $companyId) {
452
            $form = new  CreateGroupCompanyForm($this->adapter);
453
        } else {
454
            $form = new  CreateForm($this->adapter);
455
        }
456
        $form->setData($dataPost);
457
        if($form->isValid()) {
458
 
412 geraldo 459
 
460
 
1 www 461
 
462
            $hydrator = new ObjectPropertyHydrator();
463
            $feed = new Feed();
464
            $hydrator->hydrate($dataPost, $feed);
465
 
466
            $company = null;
467
            $group = null;
468
 
469
            if($companyId) {
470
                $companyMapper = CompanyMapper::getInstance($this->adapter);
471
                $company = $companyMapper->fetchOneByUuid($companyId);
472
 
473
 
474
                if(!$company) {
475
                    return [
476
                        'success'   => false,
477
                        'data'   => 'ERROR_COMPANY_NOT_FOUND'
478
                    ];
479
                }
480
 
481
                if($company->status != Company::STATUS_ACTIVE) {
482
                    return [
483
                        'success'   => false,
484
                        'data'   => 'ERROR_COMPANY_IS_NOT_ACTIVE'
485
                    ];
486
                }
487
 
488
                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
489
                $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
490
 
491
                //print_r($companyUser); exit;
492
 
493
 
494
                if(!$companyUser || $companyUser->status != CompanyUser::STATUS_ACCEPTED) {
495
                    return [
496
                        'success'   => false,
497
                        'data'   => 'ERROR_UNAUTHORIZED'
498
                    ];
499
                }
500
 
501
            }
502
 
503
            if($groupId) {
504
                $groupMapper = GroupMapper::getInstance($this->adapter);
505
                $group = $groupMapper->fetchOneByUuid($groupId);
506
 
507
                if(!$group) {
508
                    return [
509
                        'success'   => false,
510
                        'data'   => 'ERROR_GROUP_NOT_FOUND'
511
                    ];
512
                }
513
 
514
                if($group->status != Group::STATUS_ACTIVE) {
515
                    return [
516
                        'success'   => false,
517
                        'data'   => 'ERROR_GROUP_IS_NOT_ACTIVE'
518
                    ];
519
                }
520
 
521
                $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
522
                $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
523
                if(!$groupMember || !in_array($groupMember->status, [GroupMember::STATUS_ACCEPTED, GroupMember::STATUS_AUTO_JOIN])) {
524
                    return [
525
                        'success'   => false,
526
                        'data'   => 'ERROR_UNAUTHORIZED'
527
                    ];
528
                }
529
            }
530
 
531
            $feed->company_id   = $company ? $company->id : null;
532
            $feed->group_id     = $group ? $group->id : null;
533
            $feed->user_id      = $currentUser->id;
413 geraldo 534
 
535
            if($companyId) {
536
                $feed->type = Feed::TYPE_COMPANY;
537
            } else if ($groupId) {
538
                $feed->type = Feed::TYPE_GROUP;
539
            } else {
540
                $feed->type = Feed::TYPE_UPDATE;
541
            }
542
 
543
            $posted_or_shared   = $dataPost['posted_or_shared'];
544
            if($posted_or_shared != Feed::POSTED && $posted_or_shared != Feed::SHARED) {
545
                return [
546
                    'success'   => false,
547
                    'data'      => 'ERROR_SUPPLY_VALID_SHARING_STATUS'
548
                ];
549
            }
550
            $feed->posted_or_shared = $posted_or_shared;
551
            $feedMapper = FeedMapper::getInstance($this->adapter);
1 www 552
 
553
            return [
554
                'success'   => false,
412 geraldo 555
               'data'   => $feed
1 www 556
            ];
557
        }
558
    }
559
 
560
    public function likeAction()
561
    {
562
        $id = $this->params()->fromRoute('id');
563
 
564
        $request = $this->getRequest();
565
        if($request->isPost()) {
566
            $currentUserPlugin = $this->plugin('currentUserPlugin');
567
            $currentUser = $currentUserPlugin->getUser();
568
 
569
            $feedMapper = FeedMapper::getInstance($this->adapter);
570
            $feed = $feedMapper->fetchOneByUuid($id);
571
            if(!$feed) {
572
                $response = [
573
                    'success' => false,
574
                    'data' => 'ERROR_POST_NOT_FOUND'
575
                ];
576
                return new JsonModel($response);
577
            }
578
 
579
            $likeMapper = LikeMapper::getInstance($this->adapter);
580
            $like = $likeMapper->fetchOneByFeedIdAndUserId($feed->id, $currentUser->id);
581
 
582
            if($like) {
583
                $response = [
584
                    'success' => false,
585
                    'data' => 'ERROR_DUPLICATE_ACTION'
586
                ];
587
                return new JsonModel($response);
588
            }
589
 
590
            $like = new Like();
591
            $like->user_id = $currentUser->id;
592
            $like->feed_id = $feed->id;
593
 
594
            if($likeMapper->insert($like))
595
            {
596
                if($feed->type == Feed::TYPE_UPDATE) {
597
 
598
 
599
                    $userMapper = UserMapper::getInstance($this->adapter);
600
                    $ownerFeed = $userMapper->fetchOne($feed->user_id);
601
 
602
                    $notification = new Notification();
603
                    $notification->type     = Notification::TYPE_LIKE_MY_FEED;
604
                    $notification->read     = Notification::NO;
605
                    $notification->user_id  = $ownerFeed->id;
606
                    $notification->feed_id = $feed->id;
607
                    $notification->message  = 'LABEL_LIKE_MY_FEED';
608
                    $notification->url      = $this->url()->fromRoute('dashboard',['feed' => $feed->uuid]);
609
 
610
                    $notificationMapper = NotificationMapper::getInstance($this->adapter);
611
                    $notificationMapper->insert($notification);
612
 
613
                    $userNotificationMapper = UserNotificationSettingMapper::getInstance($this->adapter);
614
                    $userNotification = $userNotificationMapper->fetchOne($ownerFeed->id);
615
 
616
                    if($userNotification && $userNotification->like_my_feed)
617
                    {
618
                        $emailTemplateMapper = EmailTemplateMapper::getInstance($this->adapter);
619
                        $emailTemplate = $emailTemplateMapper->fetchOne(EmailTemplate::ID_LIKE_MY_FEED);
620
 
621
                        if($emailTemplate) {
622
                            $arrayCont = [
623
                                'firstname'             => $currentUser->first_name,
624
                                'lastname'              => $currentUser->last_name,
625
                                'other_user_firstname'  => $ownerFeed->first_name,
626
                                'other_user_lastname'   => $ownerFeed->last_name,
627
                                'company_name'          => '',
628
                                'group_name'            => '',
629
                                'content'               => '',
630
                                'code'                  => '',
631
                                'link'                  => $this->url()->fromRoute('dashboard',['feed' => $feed->uuid], ['force_canonical' => true])
632
                            ];
633
 
634
                            $email = new QueueEmail($this->adapter);
635
                            $email->processEmailTemplate($emailTemplate, $arrayCont, $ownerFeed->email, trim($ownerFeed->first_name . ' ' . $ownerFeed->last_name));
636
                        }
637
                    }
638
 
639
                }
640
 
641
 
642
 
643
 
644
 
645
 
646
 
647
 
648
                $response = [
649
                    'success' =>true,
650
                ];
651
            } else {
652
                $response = [
653
                    'success' => false,
654
                    'data' => $likeMapper->getError()
655
                ];
656
            }
657
            return new JsonModel($response);
658
 
659
        }
660
 
661
        $response = [
662
            'success' => false,
663
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
664
        ];
665
        return new JsonModel($response);
666
    }
667
 
668
    public function unlikeAction()
669
    {
670
        $id = $this->params()->fromRoute('id');
671
 
672
        $request = $this->getRequest();
673
        if($request->isPost()) {
674
            $currentUserPlugin = $this->plugin('currentUserPlugin');
675
            $currentUser = $currentUserPlugin->getUser();
676
 
677
            $feedMapper = FeedMapper::getInstance($this->adapter);
678
            $feed = $feedMapper->fetchOneByUuid($id);
679
            if(!$feed) {
680
                $response = [
681
                    'success' => false,
682
                    'data' => 'ERROR_POST_NOT_FOUND'
683
                ];
684
                return new JsonModel($response);
685
            }
686
 
687
            $likeMapper = LikeMapper::getInstance($this->adapter);
688
            $like = $likeMapper->fetchOneByFeedIdAndUserId($feed->id, $currentUser->id);
689
 
690
            if(!$like) {
691
                $response = [
692
                    'success' => false,
693
                    'data' => 'ERROR_DUPLICATE_ACTION'
694
                ];
695
                return new JsonModel($response);
696
            }
697
 
698
            if($likeMapper->deleteByFeedIdAndUserId($feed->id, $currentUser->id))
699
            {
700
                $response = [
701
                    'success' =>true,
702
                ];
703
            } else {
704
                $response = [
705
                    'success' => false,
706
                    'data' => $likeMapper->getError()
707
                ];
708
            }
709
            return new JsonModel($response);
710
 
711
        }
712
 
713
        $response = [
714
            'success' => false,
715
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
716
        ];
717
        return new JsonModel($response);
718
    }
719
 
720
    public function timelineAction()
721
    {
722
        $currentUserPlugin = $this->plugin('currentUserPlugin');
723
        $currentUser = $currentUserPlugin->getUser();
724
 
725
 
726
        $type   = $this->params()->fromRoute('type');
727
        if($type == 'user') {
728
            $id = $currentUser->id;
729
        } else {
730
            $id     = $this->params()->fromRoute('id');
731
        }
732
 
733
 
734
 
735
        $request = $this->getRequest();
736
        if($request->isGet()) {
737
 
738
            $page = (int) $this->params()->fromQuery('page');
739
            if($type == 'user') {
740
                $connectionMapper = ConnectionMapper::getInstance($this->adapter);
741
                $records = $connectionMapper->fetchAllConnectionsByUser($id);
742
 
743
                $connectionIds = [0];
744
                foreach($records as $record)
745
                {
746
                    if($currentUser->id == $record->request_from) {
747
                        array_push($connectionIds, $record->request_to);
748
                    } else {
749
                        array_push($connectionIds, $record->request_from);
750
                    }
751
                }
752
                array_push($connectionIds, 1);
753
 
754
                $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
755
                $records = $companyFollowerMapper->fetchAllByFollowerId($currentUser->id);
756
 
757
                $companyIds = [0];
758
                foreach($records as $record)
759
                {
760
                    if(!in_array($record->company_id, $companyIds)) {
761
                        array_push($companyIds, $record->company_id);
762
                    }
763
                }
764
 
765
                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
766
                $companyUsers = $companyUserMapper->fetchAllByUserId($currentUser->id);
767
 
768
                foreach($companyUsers as $companyUser)
769
                {
770
                    if($companyUser->status == CompanyUser::STATUS_ACCEPTED) {
771
                        if(!in_array($companyUser->company_id, $companyIds)) {
772
                            array_push($companyIds, $companyUser->company_id);
773
                        }
774
                    }
775
                }
776
 
777
 
778
                $queryMapper = QueryMapper::getInstance($this->adapter);
779
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
780
                $select->columns(['id']);
781
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED)
782
                    ->AND->NEST
783
                    ->OR->NEST->equalTo('user_id',$id)->and->equalTo('type', Feed::TYPE_UPDATE)->UNNEST
784
                    ->OR->NEST->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_PUBLIC)->UNNEST
785
                    ->OR->NEST->in('user_id', $connectionIds)->and->equalTo('type', Feed::TYPE_UPDATE)->and->equalTo('shared_with', Feed::SHARE_WITH_CONNECTIONS)->UNNEST
786
                    ->OR->NEST->or->in('company_id', $companyIds)->and->equalTo('type', Feed::TYPE_COMPANY)->UNNEST
787
                    ->UNNEST;
788
                $select->order('added_on desc');
789
 
790
 
791
            }
792
            if($type == 'company') {
793
                $companyMapper = CompanyMapper::getInstance($this->adapter);
794
                $company = $companyMapper->fetchOneByUuid($id);
795
 
796
                if(!$company || $company->status != Company::STATUS_ACTIVE) {
797
                    $id = 0;
798
                } else {
799
                    $companyFollowerMapper = CompanyFollowerMapper::getInstance($this->adapter);
800
                    $companyFollower = $companyFollowerMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
801
                    if($companyFollower) {
802
                        $id = $company->id;
803
                    } else {
804
 
805
                        $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
806
                        $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
807
 
808
                        if(!$companyUser || $companyUser->status != CompanyUser::STATUS_ACCEPTED) {
809
                            $id = 0;
810
                        } else {
811
                            $id = $company->id;
812
                        }
813
 
814
                    }
815
 
816
                }
817
 
818
 
819
                $queryMapper = QueryMapper::getInstance($this->adapter);
820
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
821
                $select->columns(['id']);
822
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
823
                $select->where->equalTo('company_id',$id);
824
                $select->where->and->equalTo('type', Feed::TYPE_COMPANY);
825
                $select->order('added_on desc');
826
            }
827
            if($type == 'group') {
828
                $groupMapper = GroupMapper::getInstance($this->adapter);
829
                $group = $groupMapper->fetchOneByUuid($id);
830
                if(!$group || $group->status != Group::STATUS_ACTIVE) {
831
                    $id = 0;
832
                } else {
833
                    $groupMemberMapper = GroupMemberMapper::getInstance($this->adapter);
834
                    $groupMember = $groupMemberMapper->fetchOneByGroupIdAndUserId($group->id, $currentUser->id);
835
                    if($groupMember) {
836
                        $id = $groupMember->status == GroupMember::STATUS_ACCEPTED ? $group->id : 0;
837
 
838
                    } else {
839
                        $id = 0;
840
                    }
841
                }
842
 
843
                $queryMapper = QueryMapper::getInstance($this->adapter);
844
                $select = $queryMapper->getSql()->select(FeedMapper::_TABLE);
845
                $select->columns(['id']);
846
                $select->where->equalTo('status', Feed::STATUS_PUBLISHED);
847
                $select->where->equalTo('group_id',$id);
848
                $select->where->and->equalTo('type', Feed::TYPE_GROUP);
849
                $select->order('added_on desc');
850
            }
851
 
852
            $dbSelect = new DbSelect($select, $this->adapter);
853
            $paginator = new Paginator($dbSelect);
854
            $paginator->setCurrentPageNumber($page ? $page : 1);
855
            $paginator->setItemCountPerPage(10);
856
 
857
            $items = [];
858
            $feeds = $paginator->getCurrentItems();
859
            foreach($feeds as $feed)
860
            {
861
                $items[] = $this->renderFeed($feed->id);
862
            }
863
 
864
            $response = [
865
                'success' => true,
866
                'data' => [
867
                    'total' => [
868
                        'count' => $paginator->getTotalItemCount(),
869
                        'pages' => $paginator->getPages()->pageCount,
870
                    ],
871
                    'current' => [
872
                        'items'    => $items,
873
                        'page'     => $paginator->getCurrentPageNumber(),
874
                        'count'    => $paginator->getCurrentItemCount(),
875
                    ]
876
                ]
877
            ];
878
 
879
            return new JsonModel($response);
880
        }
881
 
882
        $response = [
883
            'success' => false,
884
            'data' => 'ERROR_METHOD_NOT_ALLOWED'
885
        ];
886
 
887
 
888
        return new JsonModel($response);
889
    }
890
 
891
    /**
892
     *
893
     * @param string $str
894
     * @return string
895
     */
896
    private function normalizeString ($str = '')
897
    {
898
        $basename  = substr($str, 0, strrpos($str, '.'));
899
        $basename  = str_replace('.', '-', $basename);
900
 
901
        $extension  = substr($str, strrpos($str, '.'));
902
 
903
        $str = $basename . $extension;
904
 
905
        $str = strip_tags($str);
906
        $str = preg_replace('/[\r\n\t ]+/', ' ', $str);
907
        $str = preg_replace('/[\"\*\/\:\<\>\?\'\|\,]+/', ' ', $str);
908
        $str = strtolower($str);
909
        $str = html_entity_decode( $str, ENT_QUOTES, "utf-8" );
910
        $str = htmlentities($str, ENT_QUOTES, "utf-8");
911
        $str = preg_replace("/(&)([a-z])([a-z]+;)/i", '$2', $str);
912
        $str = str_replace(' ', '-', $str);
913
        $str = rawurlencode($str);
914
        $str = str_replace('%', '-', $str);
915
        return trim(strtolower($str));
916
    }
917
 
918
 
919
 
920
    /**
921
     *
922
     * @param int $feed_id
923
     * @return array
924
     */
925
    private function renderFeed($feed_id)
926
    {
927
        $currentUserPlugin = $this->plugin('currentUserPlugin');
928
        $currentUser = $currentUserPlugin->getUser();
929
 
930
        $acl = $this->getEvent()->getViewModel()->getVariable('acl');
931
 
932
        $userMapper = UserMapper::getInstance($this->adapter);
933
        $feedMapper = FeedMapper::getInstance($this->adapter);
934
        $feed = $feedMapper->fetchOne($feed_id);
935
 
936
 
937
        $likeMapper = LikeMapper::getInstance($this->adapter);
938
        $like = $likeMapper->fetchOneByFeedIdAndUserId($feed->id, $currentUser->id);
939
 
940
        $params = [
941
            'id' => $feed->uuid
942
        ];
943
        if($feed->company_id) {
944
            $companyMapper = CompanyMapper::getInstance($this->adapter);
945
            $company = $companyMapper->fetchOne($feed->company_id);
946
 
947
            $params['company_id'] = $company->uuid;
948
        } else {
949
            $company = null;
950
        }
951
        if($feed->group_id) {
952
            $groupMapper = GroupMapper::getInstance($this->adapter);
953
            $group = $groupMapper->fetchOne($feed->group_id);
954
 
955
            $params['group_id'] = $group->uuid;
956
        } else {
957
            $group = null;
958
        }
959
 
960
        $item = [
961
            'feed_unique' => uniqid(),
962
            'feed_uuid' => $feed->uuid,
963
            'feed_is_liked' => $like ? true : false,
964
            'feed_like_url' => $this->url()->fromRoute('feed/like',  $params),
965
            'feed_unlike_url' => $this->url()->fromRoute('feed/unlike',  $params),
966
            'feed_share_url' => $this->url()->fromRoute('feed/share',  $params),
967
            'feed_delete_url' =>  '',
968
            'feed_content_type' => $feed->file_type ? $feed->file_type : '',
969
        ];
970
 
971
        if($feed->posted_or_shared == Feed::POSTED) {
972
 
973
 
974
            if($feed->type == Feed::TYPE_COMPANY)
975
            {
976
                $companyMapper = CompanyMapper::getInstance($this->adapter);
977
                $company = $companyMapper->fetchOne($feed->company_id);
978
                $item['owner_url'] = $this->url()->fromRoute('company/view', ['id' => $company->uuid]);
979
                $item['owner_image'] = $this->url()->fromRoute('storage', ['code' => $company->uuid, 'type' => 'company', 'filename' => $company->image]);
980
                $item['owner_name'] = $company->name;
981
                /*
982
 
983
                $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);
984
                $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);
985
 
986
 
987
                if( $companyUser && $acl->isAllowed( $currentUser->usertype_id, 'my-company/feed' ) ) {
988
                    $item['feed_delete_url'] = $this->url()->fromRoute('feed/delete',  $params);
989
                }
990
                */
991
 
992
 
993
            } else if($feed->type == Feed::TYPE_GROUP)
994
            {
995
                $groupMapper = GroupMapper::getInstance($this->adapter);
996
                $group = $groupMapper->fetchOne($feed->group_id);
997
                $item['owner_url'] = '';
998
                $item['owner_image'] = $this->url()->fromRoute('storage', ['code' => $group->uuid, 'type' => 'group', 'filename' => $group->image]);
999
                $item['owner_name'] = $group->name;
1000
 
1001
                if($group->user_id == $currentUser->id) {
1002
                    $item['feed_delete_url'] = $this->url()->fromRoute('feed/delete',  $params);
1003
                }
1004
            } else {
1005
                $userMapper = UserMapper::getInstance($this->adapter);
1006
                $user = $userMapper->fetchOne($feed->user_id);
1007
 
1008
                $item['owner_url'] = $this->url()->fromRoute('profile/view', ['id' => $user->uuid]);
1009
                $item['owner_image'] = $this->url()->fromRoute('storage', ['code' => $user->uuid, 'type' => 'user', 'filename' => $user->image]);
1010
                $item['owner_name'] = $user->first_name . ' ' . $user->last_name;
1011
 
1012
                if($feed->user_id == $currentUser->id) {
1013
                    $item['feed_delete_url'] = $this->url()->fromRoute('feed/delete',  $params);
1014
                }
1015
 
1016
            }
1017
        } else {
1018
            if($feed->user_id == $currentUser->id) {
1019
                $item['feed_delete_url'] = $this->url()->fromRoute('feed/delete',  $params);
1020
            }
1021
        }
1022
 
1023
        $userMapper = UserMapper::getInstance($this->adapter);
1024
        $user = $userMapper->fetchOne($feed->user_id);
1025
 
1026
        if($feed->posted_or_shared == Feed::SHARED) {
1027
            $item['owner_url'] = $this->url()->fromRoute('profile/view', ['id' => $user->uuid]);
1028
            $item['owner_image'] = $this->url()->fromRoute('storage', ['code' => $user->uuid, 'type' => 'user', 'filename' => $user->image]);
1029
            $item['owner_name'] = $user->first_name . ' ' . $user->last_name;
1030
        }
1031
 
1032
        $item['owner_description'] = $feed->description;
1033
 
1034
        $item['owner_shared'] = $feed->total_shared;
1035
        $item['owner_comments'] = $feed->total_comments;
1036
 
1037
 
1038
        $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $feed->added_on);
1039
        $item['owner_time_elapse'] = Functions::timeElapsedString( $dt->getTimestamp());
1040
 
1041
        if($feed->file_type == Feed::FILE_TYPE_IMAGE) {
1042
            $item['owner_file_image'] = $this->url()->fromRoute('storage', ['code' => $feed->uuid, 'type' => 'feed', 'filename' => $feed->file_name]);
1043
 
1044
        }
1045
        if($feed->file_type == Feed::FILE_TYPE_DOCUMENT) {
1046
            $item['owner_file_document'] = $this->url()->fromRoute('storage', ['code' => $feed->uuid, 'type' => 'feed', 'filename' => $feed->file_name]);
1047
        }
1048
        if($feed->file_type == Feed::FILE_TYPE_VIDEO) {
1049
            $item['owner_file_image_preview'] = $this->url()->fromRoute('storage', ['code' => $feed->uuid, 'type' => 'feed', 'filename' => $feed->file_image_preview]);
1050
            $item['owner_file_video'] = $this->url()->fromRoute('storage', ['code' => $feed->uuid, 'type' => 'feed', 'filename' => $feed->file_name]);
1051
        }
1052
 
1053
        if($feed->posted_or_shared == Feed::SHARED) {
1054
 
1055
 
1056
            $sharedFeed = $feedMapper->fetchOne($feed->shared_feed_id);
1057
            $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $sharedFeed->added_on);
1058
 
1059
 
1060
            $item['shared_description'] = $sharedFeed->description;
1061
            $item['shared_time_elapse'] = Functions::timeElapsedString( $dt->getTimestamp());
1062
 
1063
            if($sharedFeed->file_type == Feed::FILE_TYPE_IMAGE) {
1064
                $item['shared_file_image'] = $this->url()->fromRoute('storage', ['code' => $sharedFeed->uuid, 'type' => 'feed', 'filename' => $sharedFeed->file_name]);
1065
 
1066
            }
1067
            if($sharedFeed->file_type == Feed::FILE_TYPE_DOCUMENT) {
1068
                $item['shared_file_document'] = $this->url()->fromRoute('storage', ['code' => $sharedFeed->uuid, 'type' => 'feed', 'filename' => $sharedFeed->file_name]);
1069
            }
1070
            if($sharedFeed->file_type == Feed::FILE_TYPE_VIDEO) {
1071
                $item['shared_file_image_preview'] = $this->url()->fromRoute('storage', ['code' => $sharedFeed->uuid, 'type' => 'feed', 'filename' => $sharedFeed->file_image_preview]);
1072
                $item['shared_file_video'] = $this->url()->fromRoute('storage', ['code' => $sharedFeed->uuid, 'type' => 'feed', 'filename' => $sharedFeed->file_name]);
1073
            }
1074
 
1075
            $item['shared_content_type'] = $sharedFeed->file_type ? $sharedFeed->file_type : '';
1076
 
1077
            if($feed->company_id)
1078
            {
1079
 
1080
                $companyMapper = CompanyMapper::getInstance($this->adapter);
1081
                $sharedCompany = $companyMapper->fetchOne($feed->company_id);
1082
                $item['shared_url'] = $this->url()->fromRoute('company/view', ['id' => $sharedCompany->uuid]);
1083
                $item['shared_image'] = $this->url()->fromRoute('storage', ['code' => $sharedCompany->uuid, 'type' => 'company', 'filename' => $sharedCompany->image]);
1084
                $item['shared_name'] = $sharedCompany->name;
1085
            } else if($feed->group_id)
1086
            {
1087
                $groupMapper = GroupMapper::getInstance($this->adapter);
1088
                $sharedGroup = $groupMapper->fetchOne($feed->group_id);
1089
                $item['shared_url'] = '';
1090
                $item['shared_image'] = $this->url()->fromRoute('storage', ['code' => $sharedGroup->uuid, 'type' => 'group', 'filename' =>  $sharedGroup->image]);
1091
                $item['shared_name'] = $sharedGroup->name;
1092
            } else {
1093
 
1094
                $sharedUser = $userMapper->fetchOne($sharedFeed->user_id);
1095
                $item['shared_url'] = $this->url()->fromRoute('profile/view', ['id' => $sharedUser->uuid]);
1096
                $item['shared_image'] = $this->url()->fromRoute('storage', ['code' => $sharedUser->uuid, 'type' => 'user', 'filename' => $sharedUser->image]);
1097
                $item['shared_name'] = $sharedUser->first_name . ' ' . $sharedUser->last_name;
1098
            }
1099
 
1100
        }
1101
 
1102
        $commentMapper = CommentMapper::getInstance($this->adapter);
1103
        $records = $commentMapper->fetchAllPublishedByFeedId($feed->id);
1104
 
1105
        $comments = [];
1106
        foreach($records as $record)
1107
        {
1108
            $user = $userMapper->fetchOne($record->user_id);
1109
            $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $record->added_on);
1110
 
1111
            if($record->user_id == $currentUser->id) {
1112
                $link_delete = $this->url()->fromRoute('feed/comment/delete',['id' => $feed->uuid, 'comment' => $record->uuid]);
1113
            } else {
1114
                $link_delete = '';
1115
            }
1116
 
1117
            array_push($comments, [
1118
                'unique' => uniqid(),
1119
                'user_url' => $this->url()->fromRoute('profile/view', ['id' => $user->uuid]),
1120
                'user_name' => $user->first_name . ' ' . $user->last_name,
1121
                'user_image' => $this->url()->fromRoute('storage', ['type' => 'user',  'code' => $user->uuid, 'filename' =>  $user->image ]),
1122
                'time_elapsed' => Functions::timeElapsedString($dt->getTimestamp()),
1123
                'comment' => $record->comment,
1124
                'link_delete' => $link_delete
1125
            ]);
1126
        }
1127
        $item['comment_add_url'] = $this->url()->fromRoute('feed/comment', ['id' => $feed->uuid]);
1128
        $item['comments'] = $comments;
1129
 
1130
        return $item;
1131
    }
1132
 
1133
    /**
1134
     *
1135
     * @param int $comment_id
1136
     * @return array
1137
     */
1138
    private function renderComment($comment_id)
1139
    {
1140
        $item = [];
1141
 
1142
        $commentMapper = CommentMapper::getInstance($this->adapter);
1143
        $record = $commentMapper->fetchOne($comment_id);
1144
 
1145
        $feedMapper = FeedMapper::getInstance($this->adapter);
1146
        $feed = $feedMapper->fetchOne($record->feed_id);
1147
 
1148
        if($record) {
1149
            $userMapper = UserMapper::getInstance($this->adapter);
1150
 
1151
            $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $record->added_on);
1152
 
1153
 
1154
            $user = $userMapper->fetchOne($record->user_id);
1155
 
1156
            $item['unique'] = uniqid();
1157
            $item['user_image'] = $this->url()->fromRoute('storage', ['type' => 'user',  'code' => $user->uuid, 'filename' =>  $user->image ]);
1158
            $item['user_url'] = $this->url()->fromRoute('profile', ['id' => $user->uuid]);
1159
            $item['user_name'] = $user->first_name . ' ' . $user->last_name;
1160
            $item['time_elapsed'] = Functions::timeElapsedString($dt->getTimestamp());
1161
            $item['comment'] = $record->comment;
1162
            $item['link_delete'] = $this->url()->fromRoute('feed/comment/delete',['id' => $feed->uuid, 'comment' => $record->uuid ]);
1163
        }
1164
        return $item;
1165
    }
1166
 
1167
    /**
1168
     *
1169
     * @param string $path
1170
     * @return boolean
1171
     */
1172
    private function deletePath($path)
1173
    {
1174
        try {
1175
            if (is_dir($path)){
1176
                if ($dh = opendir($path)) {
1177
                    while (($file = readdir($dh)) !== false)
1178
                    {
1179
                        if($file == '.' || $file == '..') {
1180
                            continue;
1181
                        }
1182
                        unlink($path . DIRECTORY_SEPARATOR . $file);
1183
                    }
1184
                    closedir($dh);
1185
                }
1186
 
1187
                rmdir($path);
1188
            }
1189
            return true;
1190
        }
1191
        catch (\Throwable $e)
1192
        {
1193
            error_log($e->getTraceAsString());
1194
            return false;
1195
        }
1196
    }
1197
 
1198
 
1199
    /**
1200
     *
1201
     * @param Feed $feed
1202
     * @return array
1203
     */
1204
    private function deleteFeed($feed)
1205
    {
1206
        $feedMapper = FeedMapper::getInstance($this->adapter);
1207
        $feed->status = Feed::STATUS_DELETED;
1208
        if($feedMapper->update($feed)) {
1209
            $response = [
1210
                'success' => true,
1211
                'data' => 'LABEL_FEED_WAS_DELETED'
1212
            ];
1213
 
1214
        } else {
1215
            $response = [
1216
                'success' => false,
1217
                'data' => $feedMapper->getError()
1218
            ];
1219
        }
1220
 
1221
 
1222
        /*$commentMapper = CommentMapper::getInstance($this->adapter);
1223
        if($commentMapper->deleteAllByFeedId($feed->id)) {
1224
            if($feedMapper->delete($feed->id)) {
1225
                $target_path = $this->config['leaderslinked.fullpath.feed'] . DIRECTORY_SEPARATOR . $feed->id;
1226
                if(file_exists($target_path)) {
1227
                    $this->deletePath($target_path);
1228
                }
1229
 
1230
                $response = [
1231
                    'success' => true,
1232
                    'data' => 'LABEL_FEED_WAS_DELETED'
1233
                ];
1234
 
1235
            } else {
1236
                $response = [
1237
                    'success' => false,
1238
                    'data' => $feedMapper->getError()
1239
                ];
1240
            }
1241
        } else {
1242
            $response = [
1243
                'success' => false,
1244
                'data' => $commentMapper->getError()
1245
            ];
1246
 
1247
        }*/
1248
 
1249
        return $response;
1250
    }
1251
 
1252
 
1253
}