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\MediaCategoryMapper;
use LeadersLinked\Form\Media\CategoryForm;
use LeadersLinked\Model\MediaCategory;
use LeadersLinked\Hydrator\ObjectPropertyHydrator;


class MediaCategoryController 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();

        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();

        if (!$currentUser) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_USER_NOT_FOUND'
            ]);
        }

        if (!$currentCompany) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_COMPANY_NOT_FOUND'
            ]);
        }

        if ($currentCompany->id != 1) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_UNAUTHORIZED'
            ]);
        }

        if (!$request->isGet()) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ]);
        }

        $headers  = $request->getHeaders();
        $isJson = false;

        if ($headers->has('Accept')) {
            $accept = $headers->get('Accept');
            $prioritized = $accept->getPrioritized();

            foreach ($prioritized as $key => $value) {
                $raw = trim($value->getRaw());

                if (!$isJson) {
                    $isJson = strpos($raw, 'json');
                }
            }
        }


        if ($isJson) {
            $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);
            $order =  $this->params()->fromQuery('order', []);
            $order_field        = empty($order[0]['column']) ? 99 :  intval($order[0]['column'], 10);
            $order_direction    = empty($order[0]['dir']) ? 'ASC' : Functions::sanitizeFilterString(filter_var($order[0]['dir']));

            $fields =  ['name'];
            $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';

            if (!in_array($order_direction, ['ASC', 'DESC'])) {
                $order_direction = 'ASC';
            }

            $mediaCategoryMapper = MediaCategoryMapper::getInstance($this->adapter);

            try {
                $paginator = $mediaCategoryMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
            } catch (\Exception $e) {
                $this->logger->err('Error in indexAction: ' . $e->getMessage());
                return new JsonModel([
                    'success' => false,
                    'data' => $e->getMessage()
                ]);
            }

            $items = [];
            $records = $paginator->getCurrentItems();
            foreach ($records as $record) {
                $item = [
                    'name' => $record->name,
                    'actions' => [
                        'link_edit' => $this->url()->fromRoute('media/categories/edit', ['id' => $record->uuid]),
                        'link_delete' => $this->url()->fromRoute('media/categories/delete', ['id' => $record->uuid])
                    ],
                ];

                array_push($items, $item);
            }

            return new JsonModel([
                'success' => true,
                'data' => [
                    'items' => $items,
                    'total' => $paginator->getTotalItemCount(),
                ]
            ]);
        }

        $form = new CategoryForm();
        $this->layout()->setTemplate('layout/layout-backend');
        $viewModel = new ViewModel();
        $viewModel->setTemplate('leaders-linked/media/categories.phtml');
        $viewModel->setVariable('form', $form);

        return $viewModel;
    }

    public function addAction()
    {
        $currentUserPlugin = $this->plugin('currentUserPlugin');
        $currentUser = $currentUserPlugin->getUser();
        $currentCompany = $currentUserPlugin->getCompany();

        $request = $this->getRequest();
        if ($request->isPost()) {
            $form = new  CategoryForm();
            $dataPost = $request->getPost()->toArray();

            $form->setData($dataPost);

            if ($form->isValid()) {
                $dataPost = (array) $form->getData();

                $hydrator = new ObjectPropertyHydrator();
                $mediaCategory = new MediaCategory();
                $mediaCategory->company_id = $currentCompany->id;
                $hydrator->hydrate($dataPost, $mediaCategory);




                $mediaCategoryMapper = MediaCategoryMapper::getInstance($this->adapter);
                $result = $mediaCategoryMapper->insert($mediaCategory);

                if ($result) {
                    $this->logger->info('Se agrego la categoría de media ' . $mediaCategory->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                    $data = [
                        'success'   => true,
                        'data'   => 'LABEL_RECORD_ADDED'
                    ];
                } else {
                    $data = [
                        'success'   => false,
                        'data'      => $mediaCategoryMapper->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 editAction()
    {
        $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);
        }

        $mediaCategoryMapper = MediaCategoryMapper::getInstance($this->adapter);
        $mediaCategory = $mediaCategoryMapper->fetchOneByUuid($uuid);
        if (!$mediaCategory) {
            $data = [
                'success'   => false,
                'data'   => 'ERROR_RECORD_NOT_FOUND'
            ];

            return new JsonModel($data);
        }

        if ($mediaCategory->company_id != $currentCompany->id) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_UNAUTHORIZED'
            ]);
        }


        if ($request->isPost()) {
            $form = new  CategoryForm();
            $dataPost = $request->getPost()->toArray();

            $form->setData($dataPost);

            if ($form->isValid()) {
                $dataPost = (array) $form->getData();

                $hydrator = new ObjectPropertyHydrator();
                $hydrator->hydrate($dataPost, $mediaCategory);
                $result = $mediaCategoryMapper->update($mediaCategory);

                if ($result) {
                    $this->logger->info('Se actualizo la categoría de media ' . $mediaCategory->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                    $data = [
                        'success' => true,
                        'data' => 'LABEL_RECORD_UPDATED'
                    ];
                } else {
                    $data = [
                        'success'   => false,
                        'data'      => $mediaCategoryMapper->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 if ($request->isGet()) {
            $hydrator = new ObjectPropertyHydrator();

            $data = [
                'success' => true,
                'data' => $hydrator->extract($mediaCategory)
            ];

            return new JsonModel($data);
        } 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);
        }

        $mediaCategoryMapper = MediaCategoryMapper::getInstance($this->adapter);
        $mediaCategory = $mediaCategoryMapper->fetchOneByUuid($uuid);
        if (!$mediaCategory) {
            $data = [
                'success'   => false,
                'data'   => 'ERROR_RECORD_NOT_FOUND'
            ];

            return new JsonModel($data);
        }


        if ($mediaCategory->company_id != $currentCompany->id) {
            return new JsonModel([
                'success' => false,
                'data' => 'ERROR_UNAUTHORIZED'
            ]);
        }


        if ($request->isPost()) {

            $mediaFileMapper = \LeadersLinked\Mapper\MediaFileMapper::getInstance($this->adapter);
            $total = $mediaFileMapper->fetchTotalCountByCategoryid($mediaCategory->id);

            if ($total > 0) {
                return new JsonModel([
                    'success' => false,
                    'data' => 'ERROR_SQL_CANNOT_DELETE_OR_UPDATE_A_PARENT_ROW'
                ]);
            }



            $result = $mediaCategoryMapper->delete($mediaCategory);
            if ($result) {
                $this->logger->info('Se borro la categoría de media ' . $mediaCategory->name, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                $data = [
                    'success' => true,
                    'data' => 'LABEL_RECORD_DELETED'
                ];
            } else {

                $data = [
                    'success'   => false,
                    'data'      => $mediaCategoryMapper->getError()
                ];

                return new JsonModel($data);
            }
        } else {
            $data = [
                'success' => false,
                'data' => 'ERROR_METHOD_NOT_ALLOWED'
            ];

            return new JsonModel($data);
        }

        return new JsonModel($data);
    }
}