import_export\classes\BaseImport::content()

Complexity

Conditions	7
Paths	11

Size

Total Lines	74
Code Lines	44

Duplication

Lines	3
Ratio	4.05 %

Importance

Changes

0

<?php
    private function content($node, $key) {

        $parts = $this->parseCategoryName($node['cat']);
        $pathIds = $pathNames = [];
        $parentId = $line = 0;

$line is not used, you could remove the assignment.

        foreach ($parts as $part) {

            /* Find existing category */
            $binds = [
                      $part,
                      $this->languages,
                      $parentId,
                     ];
            //                $binds = array($part, $this->mainLanguages, $parentId);
            $result = $this->db->query(
                '
                SELECT SCategory.id AS CategoryId
                FROM `shop_category_i18n` AS SCategoryI18n
                RIGHT OUTER JOIN `shop_category` AS SCategory ON SCategory.id = SCategoryI18n.id
                WHERE SCategoryI18n.name = ? AND SCategoryI18n.locale = ? AND SCategory.parent_id = ?',
                $binds
            );
            if ($result) {
                $result = $result->row();
            } else {
                Logger::create()->set('Error $result in CategoryImport.php - IMPORT');
            }

            if (!($result instanceof \stdClass)) {
                /* Create new category */
                $lastPosition = $this->db->query('SELECT max(position) AS maxPos FROM `shop_category`')->row()->maxPos;
                $binds = [
                          'parent_id'     => $parentId,
                          'full_path_ids' => serialize($pathIds),
                          'active'        => 1,
                          'position'      => $lastPosition + 1,
                         ];

                $this->db->insert('shop_category', $binds);
                $newCategoryId = $this->db->insert_id();

                if ($newCategoryId) {
                    $route = [
                              'parent_url' => implode('/', array_map('translit_url', $pathNames)),
                              'url'        => translit_url($part),
                              'entity_id'  => $newCategoryId,
                              'type'       => Route::TYPE_SHOP_CATEGORY,
                             ];

                    $this->db->insert('route', $route);

                    $newRouteId = $this->db->insert_id();

                    $this->db->update('shop_category', ['route_id' => $newRouteId], ['id' => $newCategoryId]);
                }
                if (!$newCategoryId) {
                    Logger::create()->set('Error INSERT category or SELECT id new category in CategoryImport.php - IMPORT');
                }

                /* Add translation data for new category  */
                foreach ($this->allLanguages as $val) {
                    $this->db->insert('shop_category_i18n', ['id' => $newCategoryId, 'locale' => $val, 'name' => trim($part)]);
                }

                $this->content[$key]['CategoryId'] = $pathIds[] = $parentId = $newCategoryId;
                $this->content[$key]['CategoryIds'] = $pathIds;
            } else {
                $this->content[$key]['CategoryId'] = $pathIds[] = $parentId = $result->CategoryId;
                $this->content[$key]['CategoryIds'] = $pathIds;
            }
            $pathNames[] = $part;

        }
    }

}