WebSVN – LeadersLinked - Backend – Diff – /module/LeadersLinked/src/Controller/MediaCategoryController.php

     /**
+     *
      * @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
         $this->translator   = $translator;
+    }
     public function indexAction()
-    {
+    {
         // Obtiene el plugin del usuario actual y la compañía
         $currentUserPlugin = $this->plugin('currentUserPlugin');
         $currentUser = $currentUserPlugin->getUser();
+        $currentCompany = $currentUserPlugin->getCompany();
         $currentCompany = $currentUserPlugin->getCompany();
+        // Obtiene la solicitud actual
         $request = $this->getRequest();
-        $request = $this->getRequest();
+        // Verifica si la solicitud es de tipo GET
         if ($request->isGet()) {
             // Obtiene los encabezados de la solicitud
             $headers  = $request->getHeaders();
             $headers  = $request->getHeaders();
             // Determina si la respuesta debe ser JSON
                         $isJson = strpos($raw, 'json');
+                    }
+                }
+            }
             // Si la respuesta debe ser JSON
+            if ($isJson) {
-            if ($isJson) {
+                // Obtiene y sanitiza los parámetros de la consulta
                 $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_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']));
                 $order_direction    = empty($order[0]['dir']) ? 'ASC' : Functions::sanitizeFilterString(filter_var($order[0]['dir']));
                 // Define los campos de ordenación
                 $fields =  ['name'];
                 $order_field = isset($fields[$order_field]) ? $fields[$order_field] : 'name';
                 if (!in_array($order_direction, ['ASC', 'DESC'])) {
-                if (!in_array($order_direction, ['ASC', 'DESC'])) {
+                    $order_direction = 'ASC';
+                }
                     $order_direction = 'ASC';
                 // Obtiene el mapeador de categorías de medios y los datos paginados
                 $mediaCategoryMapper = MediaCategoryMapper::getInstance($this->adapter);
-                $mediaCategoryMapper = MediaCategoryMapper::getInstance($this->adapter);
+                $paginator = $mediaCategoryMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
                 $paginator = $mediaCategoryMapper->fetchAllDataTableByCompanyId($currentCompany->id, $search, $page, $records_x_page, $order_field, $order_direction);
                     ];
                     array_push($items, $item);
+                }
                 // Devuelve un modelo JSON con los datos
                 return new JsonModel([
                     'success' => true,
                     'data' => [
                         'items' => $items,
                         'total' => $paginator->getTotalItemCount(),
+                    ]
+                ]);
-                ]);
+            } else {
-            } else {
+                // Si no es JSON, devuelve el formulario y la vista
                 $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;
                 return $viewModel;
         } else {
-        } else {
+            // Si la solicitud no es GET, devuelve un error
             return new JsonModel([
                 'success' => false,
             $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);
         if (!$mediaCategory) {
             $data = [
                 'success'   => false,
                 'data'   => 'ERROR_RECORD_NOT_FOUND'
             ];
             return new JsonModel($data);
+        }
-        if($mediaCategory->company_id != $currentCompany->id) {
+        if ($mediaCategory->company_id != $currentCompany->id) {
             return new JsonModel([
                 'success' => false,
                 'data' => 'ERROR_UNAUTHORIZED'
             ]);
+        }
         if ($request->isPost()) {
             $form = new  CategoryForm();
                 'data'   => 'ERROR_RECORD_NOT_FOUND'
             ];
             return new JsonModel($data);
         }
-        if($mediaCategory->company_id != $currentCompany->id) {
+        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) {
+            if ($total > 0) {
                 return new JsonModel([
                     'success' => false,
                     'data' => 'ERROR_SQL_CANNOT_DELETE_OR_UPDATE_A_PARENT_ROW'
                 ]);
             }
             $result = $mediaCategoryMapper->delete($mediaCategory);
             if ($result) {

Proyectos de Subversion LeadersLinked - Backend

(root)/module/LeadersLinked/src/Controller/MediaCategoryController.php – Rev 17002 → 17251