Proyectos de Subversion LeadersLinked - Antes de SPA

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Cache\Storage\Adapter\AbstractAdapter;

use Laminas\Mvc\Controller\AbstractActionController;

use Laminas\Log\LoggerInterface;

use Laminas\View\Model\ViewModel;

use Laminas\View\Model\JsonModel;

use LeadersLinked\Model\Page;

use LeadersLinked\Mapper\NotificationMapper;

use LeadersLinked\Mapper\CompanyMapper;

use LeadersLinked\Mapper\CompanyUserMapper;

use LeadersLinked\Model\Company;

use LeadersLinked\Mapper\PageMapper;

use LeadersLinked\Mapper\MessageMapper;

use LeadersLinked\Mapper\UserMapper;

use LeadersLinked\Mapper\UserProfileMapper;

use LeadersLinked\Mapper\CompanyUserRoleMapper;

use LeadersLinked\Model\Role;

use LeadersLinked\Library\Functions;

use LeadersLinked\Mapper\ConnectionMapper;

use LeadersLinked\Mapper\LocationMapper;

use LeadersLinked\Mapper\PostMapper;

use LeadersLinked\Mapper\ProfileVisitMapper;

use LeadersLinked\Model\Post;

use LeadersLinked\Mapper\UtilMapper;

use LeadersLinked\Mapper\FeedMapper;

use LeadersLinked\Model\Feed;

use LeadersLinked\Model\User;

use LeadersLinked\Model\Connection;

use LeadersLinked\Mapper\NetworkMapper;

use Laminas\Mvc\I18n\Translator;

class HomeController extends AbstractActionController

{

    /**

     *

     * @var AdapterInterface

     */

    private $adapter;

    /**

     *

     * @var AbstractAdapter

     */

    private $cache;

    /**

     *

     * @var  LoggerInterface

     */

    private $logger;

    /**

     *

     * @var array

     */

    private $config;

    /**

     *

     * @param AdapterInterface $adapter

     * @param AbstractAdapter $cache

     * @param LoggerInterface $logger

     * @param array $config

     */

    public function __construct($adapter, $cache, $logger,  $config)

    {

        $this->adapter      = $adapter;

        $this->cache        = $cache;

        $this->logger       = $logger;

        $this->config       = $config;

    }

    public function indexAction()

    {

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

        if ($currentUserPlugin->hasIdentity()) {

            return $this->redirect()->toRoute('dashboard');

        } else {

            return $this->redirect()->toRoute('signin');

        }

    }

    public function privacyPolicyAction()

    {

        $pageCode = Page::PAGE_CODE_PRIVACY_POLICY;

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

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $pageMapper = PageMapper::getInstance($this->adapter);

        $page = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $currentNetwork->id);

        if (!$page) {

            $networkMapper = NetworkMapper::getInstance($this->adapter);

            $network = $networkMapper->fetchOneByDefault();

            $pageDefault = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $network->id);

            if ($pageDefault) {

                $page = new Page();

                $page->network_id = $currentNetwork->id;

                $page->code = $pageDefault->code;

                $page->content = $pageDefault->content;

                $page->fixed = $pageDefault->fixed;

                $page->page_default_id = $pageDefault->id;

                $page->title = $pageDefault->title;

                $page->status = $pageDefault->status;

                $page->type = $pageDefault->type;

                $page->url = $pageDefault->url;

                $pageMapper->insert($page);

            }

        }

        $this->layout()->setTemplate('layout/layout.phtml');

        $viewModel = new ViewModel();

        $viewModel->setTemplate('leaders-linked/home/privacy-policy.phtml');

        $viewModel->setVariable('page', $page);

        return $viewModel;

    }

    public function cookiesAction()

    {

        $pageCode = Page::PAGE_CODE_COOKIES;

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

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $pageMapper = PageMapper::getInstance($this->adapter);

        $page = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $currentNetwork->id);

        if (!$page) {

            $networkMapper = NetworkMapper::getInstance($this->adapter);

            $network = $networkMapper->fetchOneByDefault();

            $pageDefault = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $network->id);

            if ($pageDefault) {

                $page = new Page();

                $page->network_id = $currentNetwork->id;

                $page->code = $pageDefault->code;

                $page->content = $pageDefault->content;

                $page->fixed = $pageDefault->fixed;

                $page->page_default_id = $pageDefault->id;

                $page->title = $pageDefault->title;

                $page->status = $pageDefault->status;

                $page->type = $pageDefault->type;

                $page->url = $pageDefault->url;

                $pageMapper->insert($page);

            }

        }

        $this->layout()->setTemplate('layout/layout.phtml');

        $viewModel = new ViewModel();

        $viewModel->setTemplate('leaders-linked/home/cookies.phtml');

        $viewModel->setVariable('page', $page);

        return $viewModel;

    }

    public function professionalismPolicyAction()

    {

        $pageCode = Page::PAGE_CODE_PROFESSIONALISM_POLICY;

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

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $pageMapper = PageMapper::getInstance($this->adapter);

        $page = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $currentNetwork->id);

        if (!$page) {

            $networkMapper = NetworkMapper::getInstance($this->adapter);

            $network = $networkMapper->fetchOneByDefault();

            $pageDefault = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $network->id);

            if ($pageDefault) {

                $page = new Page();

                $page->network_id = $currentNetwork->id;

                $page->code = $pageDefault->code;

                $page->content = $pageDefault->content;

                $page->fixed = $pageDefault->fixed;

                $page->page_default_id = $pageDefault->id;

                $page->title = $pageDefault->title;

                $page->status = $pageDefault->status;

                $page->type = $pageDefault->type;

                $page->url = $pageDefault->url;

                $pageMapper->insert($page);

            }

        }

        $this->layout()->setTemplate('layout/layout.phtml');

        $viewModel = new ViewModel();

        $viewModel->setTemplate('leaders-linked/home/professionalism-policy');

        $viewModel->setVariable('page', $page);

        return $viewModel;

    }

    public function termsAndConditionsAction()

    {

        $pageCode = Page::PAGE_CODE_TERMS_AND_CONDITIONS;

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

        $currentNetwork = $currentNetworkPlugin->getNetwork();

        $pageMapper = PageMapper::getInstance($this->adapter);

        $page = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $currentNetwork->id);

        if (!$page) {

            $networkMapper = NetworkMapper::getInstance($this->adapter);

            $network = $networkMapper->fetchOneByDefault();

            $pageDefault = $pageMapper->fetchOneByCodeAndNetworkId($pageCode, $network->id);

            if ($pageDefault) {

                $page = new Page();

                $page->network_id = $currentNetwork->id;

                $page->code = $pageDefault->code;

                $page->content = $pageDefault->content;

                $page->fixed = $pageDefault->fixed;

                $page->page_default_id = $pageDefault->id;

                $page->title = $pageDefault->title;

                $page->status = $pageDefault->status;

                $page->type = $pageDefault->type;

                $page->url = $pageDefault->url;

                $pageMapper->insert($page);

            }

        }

        $this->layout()->setTemplate('layout/layout.phtml');

        $viewModel = new ViewModel();

        $viewModel->setTemplate('leaders-linked/home/terms-and-conditions.phtml');

        $viewModel->setVariable('page', $page);

        return $viewModel;

    }

    public function checkSessionAction()

    {

        $request = $this->getRequest();

        if ($request->isGet()) {

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

            if (!$currentUserPlugin->hasIdentity()) {

                //$flashMessenger = $this->plugin('FlashMessenger');

                //$flashMessenger->addErrorMessage('ERROR_SESSION_NOT_FOUND');

                $response = [

                    'success' => false,

                    'data' => [

                        'message' =>  '', //ERROR_SESSION_NOT_FOUND',

                        'url' => $this->url()->fromRoute('signout')

                    ]

                ];

                return new JsonModel($response);

            }

            $currentUser = $currentUserPlugin->getUser();

            if ($currentUser->last_activity_on) {

                $last_activity_on = strtotime($currentUser->last_activity_on);

            } else {

                $last_activity_on = strtotime('-1 day');

            }

            $expiry_time = $last_activity_on + $this->config['leaderslinked.security.last_activity_expired'];

            if (time() > $expiry_time) {

                //$flashMessenger = $this->plugin('FlashMessenger');

                //$flashMessenger->addErrorMessage('ERROR_SESSION_EXPIRED');

                $response = [

                    'success' => false,

                    'data' => [

                        'message' => 'ERROR_SESSION_EXPIRED',

                        'url' => $this->url()->fromRoute('signout')

                    ]

                ];

            } else {

                $notificationMapper = NotificationMapper::getInstance($this->adapter);

                $total_notifications = $notificationMapper->fetchUnreadNotificationsCount($currentUser->id);

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

                $total_messages =  $messageMapper->fetchCountUnreadMessagesReceiverId($currentUser->id);

                $response = [

                    'success' => true,

                    'data' => [

                        'total_notifications' => $total_notifications,

                        'total_messages' => $total_messages

                    ]

                ];

            }

        } else {

            $response = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

        }

        return new JsonModel($response);

    }

    public function incTotalExternalSharedAction()

    {

        $request = $this->getRequest();

        if ($request->isPost()) {

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

            $currentUser = $currentUserPlugin->getUser();

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

            $currentNetwork = $currentNetworkPlugin->getNetwork();

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

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

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

            $timestamp  = intval($this->params()->fromRoute('timestamp'), 10);

            $rand       = intval($this->params()->fromRoute('rand'), 10);

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

            $checkpassword = '';

            $userCheck = '';

            if ($user && $timestamp > 0 && $rand > 0 && $password) {

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

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

                if ($userCheck) {

                    $checkpassword  = md5('user-' . $userCheck->uuid . '-' . $type . '-' . $code . '-timestamp-' . $timestamp . '-rand-' . $rand . '-share-key-' . $userCheck->share_key);

                }

            }

            if (empty($password) || $password != $checkpassword) {

                $data = [

                    'success' => false,

                    'data' => 'ERROR_UNAUTHORIZED'

                ];

                return new JsonModel($data);

            }

            if ($type == 'feed' && $code) {

                $feedMapper =  FeedMapper::getInstance($this->adapter);

                $feed = $feedMapper->fetchOneByUuidAnyStatus($code);

                if ($feed) {

                    if ($feed->network_id != $currentNetwork->id) {

                        $data = [

                            'success' => false,

                            'data' =>    'ERROR_UNAUTHORIZED'

                        ];

                        return new JsonModel($data);

                    }

                    if ($feedMapper->incTotalExternalShared($feed->id)) {

                        $total = $feedMapper->fetchTotalExternalShared($feed->id);

                        $this->logger->info('El usuario : ' . trim($currentUser->first_name . ' ' . $currentUser->last_name) . ' (' . $currentUser->email . ') compartio externamente el feed : ' . $feed->title);

                        $data = [

                            'success' => true,

                            'data' => $total,

                        ];

                        return new JsonModel($data);

                    } else {

                        $data = [

                            'success' => false,

                            'data' => $feedMapper->getError()

                        ];

                        return new JsonModel($data);

                    }

                } else {

                    $data = [

                        'success' => false,

                        'data' => 'ERROR_FEED_NOT_FOUND',

                    ];

                    return new JsonModel($data);

                }

            } else if ($type == 'post' && $code) {

                $postMapper = PostMapper::getInstance($this->adapter);

                $post = $postMapper->fetchOneByUuid($code);

                if ($post && $post->status == Post::STATUS_ACTIVE) {

                    if ($post->network_id != $currentNetwork->id) {

                        $data = [

                            'success' => false,

                            'data' =>    'ERROR_UNAUTHORIZED'

                        ];

                        return new JsonModel($data);

                    }

                    if ($postMapper->incTotalExternalShared($post->id)) {

                        $total = $postMapper->fetchTotalExternalShared($post->id);

                        $this->logger->info('El usuario : ' . trim($currentUser->first_name . ' ' . $currentUser->last_name) . ' (' . $currentUser->email . ') compartio externamente el post : ' . $post->title);

                        $data = [

                            'success' => true,

                            'data' => $total,

                        ];

                        return new JsonModel($data);

                    } else {

                        $data = [

                            'success' => false,

                            'data' => $postMapper->getError()

                        ];

                        return new JsonModel($data);

                    }

                } else {

                    $data = [

                        'success' => false,

                        'data' => 'ERROR_POST_NOT_FOUND'

                    ];

                    return new JsonModel($data);

                }

            }

        } else {

            $response = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($response);

        }

    }

    public function shareAction()

    {

        $request = $this->getRequest();

        if ($request->isGet()) {

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

            $currentUser = $currentUserPlugin->getUser();

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

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

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

            $timestamp  = intval($this->params()->fromRoute('timestamp'), 10);

            $rand       = intval($this->params()->fromRoute('rand'), 10);

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

            $checkpassword = '';

            $userCheck = '';

            if ($user && $timestamp > 0 && $rand > 0 && $password) {

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

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

                if ($userCheck) {

                    $checkpassword  = md5('user-' . $userCheck->uuid . '-' . $type . '-' . $code . '-timestamp-' . $timestamp . '-rand-' . $rand . '-share-key-' . $userCheck->share_key);

                }

            }

            if (empty($password) || $password != $checkpassword) {

                $data = [

                    'success' => false,

                    'data' => 'ERROR_UNAUTHORIZED'

                ];

                return new JsonModel($data);

            }

            /*

            $share_params = [

                'type' => $type,

                'code' => $code,

                'user' => $currentUser->uuid,

                'timestamp' => $timestamp,

                'rand' => $rand,

                'password' => $password,

            ];

            $share_increment_external_counter_url = $this->url()->fromRoute('share/increment-external-counter', $share_params  , ['force_canonical' => true]);

            */

            if (strpos(strtolower($_SERVER['REQUEST_SCHEME']), 'https') === false) {

                $base_share = 'http://' . $_SERVER['HTTP_HOST'];

            } else {

                $base_share = 'https://' . $_SERVER['HTTP_HOST'];

            }

            /*

            echo '<pre>';

            print_r($_SERVER);

            echo '</pre>';

            */

            $share_url          = $base_share . $_SERVER['REQUEST_URI'];

            $share_image        = $base_share . '/images/ll-logo.png';

            $share_title        = '';

            $share_description  = '';

            if ($type == 'feed' && $code) {

                $feedMapper =  FeedMapper::getInstance($this->adapter);

                $feed = $feedMapper->fetchOneByUuidAnyStatus($code);

                // if($feed && $feed->status == Feed::STATUS_PUBLISHED) {

                if ($feed) {

                    $share_title = $feed->title ? $feed->title : '';

                    if ($feed->posted_or_shared  == Feed::SHARED) {

                        $feed = $feedMapper->fetchOneAnyStatus($feed->shared_feed_id);

                        if ($feed->title) {

                            $share_title = $share_title  .  ' -  ' . $feed->title;

                        }

                    }

                    $share_description = str_replace('í', '', $feed->description);

                    $image_name = '';

                    if ($feed->file_type == Feed::FILE_TYPE_IMAGE) {

                        $image_name = $feed->file_name;

                    } else  if ($feed->file_image_preview) {

                        $image_name = $feed->file_image_preview;

                    }

                    if ($image_name) {

                        $source = $this->config['leaderslinked.fullpath.feed'] . $feed->uuid . DIRECTORY_SEPARATOR . $image_name;

                        $target_path = 'public' . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . 'feed' . DIRECTORY_SEPARATOR . $feed->uuid;

                        if (!file_exists($target_path)) {

                            mkdir($target_path, 0755, true);

                        }

                        $target = $target_path . DIRECTORY_SEPARATOR . $image_name;

                        if (!file_exists($target)) {

                            copy($source, $target);

                            $share_image =  $base_share . '/images/feed/' . $feed->uuid . '/' . $image_name;

                        } else {

                            $share_image =  $base_share . '/images/feed/' . $feed->uuid . '/' . $image_name;

                        }

                    }

                } else {

                    if ($currentUserPlugin->hasIdentity()) {

                        $this->layout()->setTemplate('layout/layout.phtml');

                    } else {

                        $this->layout()->setTemplate('layout/share.phtml');

                    }

                    $viewModel = new ViewModel();

                    $viewModel->setTemplate('leaders-linked/error/404.phtml');

                    return $viewModel;

                }

            } else if ($type == 'post' && $code) {

                $postMapper = PostMapper::getInstance($this->adapter);

                $post = $postMapper->fetchOneByUuid($code);

                if ($post && $post->status == Post::STATUS_ACTIVE) {

                    $share_title = $post->title;

                    $share_description = str_replace('í', '&laquo', '', $post->description);

                    if ($post->image) {

                        $source = $this->config['leaderslinked.fullpath.post'] . $post->uuid . DIRECTORY_SEPARATOR . $post->image;

                        $target_path = 'public' . DIRECTORY_SEPARATOR . 'images' . DIRECTORY_SEPARATOR . 'post' . DIRECTORY_SEPARATOR . $post->uuid;

                        if (!file_exists($target_path)) {

                            mkdir($target_path, 0755, true);

                        }

                        $target = $target_path . DIRECTORY_SEPARATOR . $post->image;

                        if (!file_exists($target)) {

                            copy($source, $target);

                            $share_image =  $base_share . '/images/post/' . $post->uuid . '/' . $post->image;

                        } else {

                            $share_image =  $base_share . '/images/post/' . $post->uuid . '/' . $post->image;

                        }

                    }

                } else {

                    if ($currentUserPlugin->hasIdentity()) {

                        $this->layout()->setTemplate('layout/layout.phtml');

                    } else {

                        $this->layout()->setTemplate('layout/share.phtml');

                    }

                    $viewModel = new ViewModel();

                    $viewModel->setTemplate('leaders-linked/error/404.phtml');

                    return $viewModel;

                }

            }

            /*

            echo '<pre>';

            print_r([ 'share_image' => $share_image,

                'share_url' => $share_url,

                'share_title' => strip_tags($share_title),

                'share_description' => strip_tags($share_description)]);  echo '</pre>';

            exit;

            */

            if ($currentUserPlugin->hasIdentity()) {

                $currentUser = $currentUserPlugin->getUser();

                if ($userCheck && $userCheck->status == User::STATUS_ACTIVE && $userCheck->id != $currentUser->id) {

                    $connectionMapper = ConnectionMapper::getInstance($this->adapter);

                    $connection = $connectionMapper->fetchOneByUserId1AndUserId2($currentUser->id, $userCheck->id);

                    if ($connection) {

                        if ($connection->status != Connection::STATUS_ACCEPTED) {

                            $connectionMapper->approve($connection);

                        }

                    } else {

                        $connection = new Connection();

                        $connection->request_from = $currentUser->id;

                        $connection->request_to = $userCheck->id;

                        $connection->status = Connection::STATUS_ACCEPTED;

                        $connectionMapper->insert($connection);

                    }

                }

                $this->layout()->setTemplate('layout/layout.phtml');

            } else {

                $this->cache->addItem('user_share_invitation', $user);

                $this->layout()->setTemplate('layout/share.phtml');

            }

            $viewModel = new ViewModel();

            $viewModel->setTemplate('leaders-linked/home/share.phtml');

            $viewModel->setVariables([

                'share_image' => $share_image,

                'share_url' => $share_url,

                'share_title' => strip_tags($share_title),

                'share_description' => str_replace(

                    [

                        '«',

                        'í',

                        '»',

                        'á',

                        'ü',

                        '- ',

                        ' ',

                        'é',

                        'ó',

                        'ú'

                    ],

                    '',

                    strip_tags($share_description)

                ),

                // 'share_increment_external_counter_url' => $share_increment_external_counter_url,

            ]);

            return $viewModel;

        } else {

            $response = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($response);

        }

    }

    public function languageAction()

    {

        $request = $this->getRequest();

        if ($request->isGet()) {

            $pathname = dirname(__DIR__);

            $filename = $pathname . DIRECTORY_SEPARATOR . 'i18n' . DIRECTORY_SEPARATOR . 'spanish.php';

            if(file_exists($filename)) {

                $arr =  include $filename;

                $arr = array_filter($arr, function($a)  {

                    return strpos($a, 'LABEL_') !== false;

                }, ARRAY_FILTER_USE_KEY);

                $data = [];

                foreach($arr as $key => $value)

                {

                    $key = str_replace('LABEL_', 'LANG_', $key);

                    $data[ $key ] = $value;

                }

                $response = [

                    'success' => true,

                    'data' => $data

                ];

                return new JsonModel($response);

            } else {

                $response = [

                    'success' => false,

                    'data' => 'ERROR_METHOD_NOT_ALLOWED'

                ];

                return new JsonModel($response);

            }

        } else {

            $response = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($response);

        }

    }

}