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 LeadersLinked\Mapper\DiscoveryContactMapper;

use LeadersLinked\Mapper\QueryMapper;

use LeadersLinked\Mapper\DiscoveryContactLogMapper;

use LeadersLinked\Mapper\UserMapper;

use Laminas\Paginator\Adapter\DbSelect;

use Laminas\Paginator\Paginator;

class DiscoveryContactLogController 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' => DiscoveryContactLogMapper::_TABLE]);

            $select->columns(['activity', 'details', 'added_on']);

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

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

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

            if ($search) {

                $select->where->nest()

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

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

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

                    ->or->like('activity', '%' . $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'],

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

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

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

                ];

                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'

            ]);;

        }

    }

}