Proyectos de Subversion LeadersLinked - Backend

<?php

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Mvc\Controller\AbstractActionController;

use Laminas\Log\LoggerInterface;

use Laminas\View\Model\ViewModel;

use Laminas\View\Model\JsonModel;

use LeadersLinked\Library\Functions;

use Laminas\Mvc\I18n\Translator;

use LeadersLinked\Mapper\DiscoveryContactInteractionMapper;

use LeadersLinked\Mapper\DiscoveryContactInteractionTypeMapper;

use LeadersLinked\Model\DiscoveryContactLog;

use LeadersLinked\Mapper\DiscoveryContactMapper;

use LeadersLinked\Mapper\QueryMapper;

use LeadersLinked\Mapper\UserMapper;

use Laminas\Paginator\Adapter\DbSelect;

use Laminas\Paginator\Paginator;

use LeadersLinked\Form\DiscoveryContact\InteractionForm;

use LeadersLinked\Model\DiscoveryContactInteraction;

use LeadersLinked\Mapper\DiscoveryContactLogMapper;

class DiscoveryContactInteractionController extends AbstractActionController

{

    /**

     *

     * @var \Laminas\Db\Adapter\AdapterInterface

     */

    private $adapter;

    /**

     *

     * @var \LeadersLinked\Cache\CacheInterface

     */

    private $cache;

    /**

     *

     * @var \Laminas\Log\LoggerInterface

     */

    private $logger;

    /**

     *

     * @var array

     */

    private $config;

    /**

     *

     * @var \Laminas\Mvc\I18n\Translator

     */

    private $translator;

    /**

     *

     * @param \Laminas\Db\Adapter\AdapterInterface $adapter

     * @param \LeadersLinked\Cache\CacheInterface $cache

     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger

     * @param array $config

     * @param \Laminas\Mvc\I18n\Translator $translator

     */

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

    {

        $this->adapter      = $adapter;

        $this->cache        = $cache;

        $this->logger       = $logger;

        $this->config       = $config;

        $this->translator   = $translator;

    }

    public function indexAction()

    {

        $request = $this->getRequest();

        if($request->isGet()) {

            $request = $this->getRequest();

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

            if(!$uuid) {

                $data = [

                    'success'   => false,

                    'data'   => 'ERROR_INVALID_PARAMETER'

                ];

                return new JsonModel($data);

            }

            $discoveryContactMapper = DiscoveryContactMapper::getInstance($this->adapter);

            $discoveryContact = $discoveryContactMapper->fetchOneByUuid($uuid);

            if(!$discoveryContact) {

                $data = [

                    'success'   => false,

                    'data'   => 'ERROR_RECORD_NOT_FOUND'

                ];

                return new JsonModel($data);

            }

            $search = $this->params()->fromQuery('search');

            $search = empty($search['value']) ? '' : Functions::sanitizeFilterString($search['value']);

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

            $records_x_page     = intval($this->params()->fromQuery('length', 10), 10);

            $queryMapper = QueryMapper::getInstance($this->adapter);

            $select = $queryMapper->getSql()->select();

            $select->from([ 'tb1' => DiscoveryContactInteractionMapper::_TABLE ]);

            $select->columns(['uuid', 'notes', 'added_on']);

            $select->join(['tb2' => DiscoveryContactInteractionTypeMapper::_TABLE], 'tb2.id = tb1.interaction_type_id', ['name']);

            $select->join(['tb3' => UserMapper::_TABLE], 'tb1.user_id = tb3.id', ['first_name' , 'last_name', 'email']);

            $select->where->equalTo('tb1.company_id', $discoveryContact->company_id);

            $select->where->equalTo('tb1.contact_id', $discoveryContact->id);

            if($search) {

                $select->where->nest()

                ->like('first_name', '%' . $search . '%')

                ->or->like('last_name', '%' . $search . '%')

                ->or->like('email', '%' . $search . '%')

                ->or->like('name', '%' . $search . '%')

                ->unnest();

            }

            $select->order('added_on DESC');

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

            $adapter = new DbSelect($select, $queryMapper->getSql());

            $paginator = new Paginator($adapter);

            $paginator->setItemCountPerPage($records_x_page);

            $paginator->setCurrentPageNumber($page);

            $items = [];

            $records = $paginator->getCurrentItems();

            foreach($records as $record)

            {

                $dt = \DateTime::createFromFormat('Y-m-d H:i:s', $record['added_on'] );

                $item = [

                    'first_name' => $record['first_name'],

                    'last_name' => $record['last_name'],

                    'email' => $record['email'],

                    'name' => $record['name'],

                    'notes' => $record['notes'],

                    'added_on' => $dt->format('d/m/Y H:i a'),

                    'link_delete' => $this->url()->fromRoute('discovery-contacts/interactions/delete', ['id' => $discoveryContact->uuid, 'interaction' => $record['uuid'] ]),

                ];

                array_push($items, $item);

            }

            $total_items = $paginator->getTotalItemCount();

            if($total_items <= 10) {

                $total_pages = 1;

            } else {

                $total_pages = (  $total_items / 10);

                if(($total_pages * 10) <  $total_items) {

                    $total_pages++;

                }

            }

            return new JsonModel([

                'success' => true,

                'data' => [

                    'current' => [

                        'items' => $items,

                        'page' => $paginator->getCurrentPageNumber()

                    ],

                    'total' => [

                        'items' => $total_items,

                        'pages' => $total_pages

                    ],

                ]

            ]);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);;

        }

    }

    public function addAction()

    {

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

        $currentUser = $currentUserPlugin->getUser();

        $currentCompany = $currentUserPlugin->getCompany();

        $request = $this->getRequest();

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

        if(!$uuid) {

            $data = [

                'success'   => false,

                'data'   => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $discoveryContactMapper = DiscoveryContactMapper::getInstance($this->adapter);

        $discoveryContact = $discoveryContactMapper->fetchOneByUuid($uuid);

        if(!$discoveryContact) {

            $data = [

                'success'   => false,

                'data'   => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($discoveryContact->company_id != $currentCompany->id) {

            return new JsonModel([

                'success'   => false,

                'data'   => 'ERROR_UNAUTHORIZED'

            ]);

        }

        $request = $this->getRequest();

        if($request->isPost()) {

            $form = new InteractionForm($this->adapter, $currentCompany->id);

            $dataPost = $request->getPost()->toArray();

            $form->setData($dataPost);

            if($form->isValid()) {

                $dataPost = (array) $form->getData();

                $notes = $dataPost['notes'];

                $interaction_type_id = $dataPost['interaction_type_id'];

                $discoveryContactInteractionTypeMapper = DiscoveryContactInteractionTypeMapper::getInstance($this->adapter);

                $discoveryContactInteractionType = $discoveryContactInteractionTypeMapper->fetchOneByUuid($interaction_type_id);

                $discoveryContactInteraction = new DiscoveryContactInteraction();

                $discoveryContactInteraction->user_id = $currentUser->id;

                $discoveryContactInteraction->company_id  = $discoveryContact->company_id;

                $discoveryContactInteraction->contact_id  = $discoveryContact->id;

                $discoveryContactInteraction->interaction_type_id =  $discoveryContactInteractionType->id;

                $discoveryContactInteraction->notes = $notes;

                $discoveryContactInteractionMapper = DiscoveryContactInteractionMapper::getInstance($this->adapter);

                $result = $discoveryContactInteractionMapper->insert($discoveryContactInteraction);

                if($result) {

                    $this->logger->info('Se agrego la interacción del relevamiento de contacto : ' . $discoveryContact->first_name . ' ' . $discoveryContact->last_name . '(' . $discoveryContact->corporate_email . ')', ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                    $discoveryContactLog = new DiscoveryContactLog();

                    $discoveryContactLog->company_id    = $discoveryContact->company_id;

                    $discoveryContactLog->contact_id    = $discoveryContact->id;

                    $discoveryContactLog->user_id       = $currentUser->id;

                    $discoveryContactLog->activity      = 'LABEL_RECORD_INTERACTION_ADDED';

                    $discoveryContactLog->details       = 'LABEL_TYPE : ' . $discoveryContactInteractionType->name  . PHP_EOL .

                        'LABEL_NOTES : ' . $notes . PHP_EOL;

                    $discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);

                    $discoveryContactLogMapper->insert($discoveryContactLog);

                    $data = [

                        'success'   => true,

                        'data'   => 'LABEL_RECORD_ADDED'

                    ];

                } else {

                    $data = [

                        'success'   => false,

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

                    ];

                }

                return new JsonModel($data);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach($form_messages  as $fieldname => $field_messages)

                {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success'   => false,

                    'data'   => $messages

                ]);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

    public function deleteAction()

    {

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

        $currentUser = $currentUserPlugin->getUser();

        $currentCompany = $currentUserPlugin->getCompany();

        $request = $this->getRequest();

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

        if(!$uuid) {

            $data = [

                'success'   => false,

                'data'   => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $discoveryContactMapper = DiscoveryContactMapper::getInstance($this->adapter);

        $discoveryContact = $discoveryContactMapper->fetchOneByUuid($uuid);

        if(!$discoveryContact) {

            $data = [

                'success'   => false,

                'data'   => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($discoveryContact->company_id != $currentCompany->id) {

            return new JsonModel([

                'success'   => false,

                'data'   => 'ERROR_UNAUTHORIZED'

            ]);

        }

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

        $discoveryContactInteractionMapper = DiscoveryContactInteractionMapper::getInstance($this->adapter);

        $discoveryContactInteraction = $discoveryContactInteractionMapper->fetchOneByUuid($uuid);

        if(!$discoveryContactInteraction) {

            $data = [

                'success'   => false,

                'data'   => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($discoveryContact->id != $discoveryContactInteraction->contact_id) {

            return new JsonModel([

                'success'   => false,

                'data'   => 'ERROR_UNAUTHORIZED'

            ]);

        }

        if($request->isPost()) {

            $discoveryContactInteractionTypeMapper = DiscoveryContactInteractionTypeMapper::getInstance($this->adapter);

            $discoveryContactInteractionType = $discoveryContactInteractionTypeMapper->fetchOne($discoveryContactInteraction->interaction_type_id);

            $result = $discoveryContactInteractionMapper->delete($discoveryContactInteraction);

            if($result) {

                $this->logger->info('Se borro la interacción del relevamiento de contacto ' . $discoveryContact->first_name . ' ' . $discoveryContact->last_name . '(' . $discoveryContact->corporate_email . ')', ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                $discoveryContactLog = new DiscoveryContactLog();

                $discoveryContactLog->company_id    = $discoveryContact->company_id;

                $discoveryContactLog->contact_id    = $discoveryContact->id;

                $discoveryContactLog->user_id       = $currentUser->id;

                $discoveryContactLog->activity      = 'LABEL_RECORD_INTERACTION_DELETED';

                $discoveryContactLog->details       = 'LABEL_TYPE : ' . $discoveryContactInteractionType->name  . PHP_EOL .

                'LABEL_NOTES : ' . $discoveryContactInteraction->notes . PHP_EOL;

                $discoveryContactLogMapper = DiscoveryContactLogMapper::getInstance($this->adapter);

                $discoveryContactLogMapper->insert($discoveryContactLog);

                $data = [

                    'success' => true,

                    'data' => 'LABEL_RECORD_DELETED'

                ];

            } else {

                $data = [

                    'success'   => false,

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

                ];

                return new JsonModel($data);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

}