PHP Category::getResource方法代码示例

 /**
  * @param \Magento\Catalog\Model\Category $category
  * @param boolean $recursive
  * @return int[]
  */
 public function getChildrenIds(Category $category, $recursive = false)
 {
     $cacheKey = $category->getId() . '_' . (int) $recursive;
     if (!isset($this->childrenIds[$cacheKey])) {
         $connection = $category->getResource()->getReadConnection();
         $select = $connection->select()->from($category->getResource()->getEntityTable(), 'entity_id')->where($connection->quoteIdentifier('path') . ' LIKE :c_path');
         $bind = ['c_path' => $category->getPath() . '/%'];
         if (!$recursive) {
             $select->where($connection->quoteIdentifier('level') . ' <= :c_level');
             $bind['c_level'] = $category->getLevel() + 1;
         }
         $this->childrenIds[$cacheKey] = $connection->fetchCol($select, $bind);
     }
     return $this->childrenIds[$cacheKey];
 }

 /**
  * @param Category $category
  * @return void
  */
 public function processDelete(Category $category)
 {
     /** @var \Magento\Catalog\Model\ResourceModel\Category $resourceModel */
     $resourceModel = $category->getResource();
     /**
      * Update children count for all parent categories
      */
     $parentIds = $category->getParentIds();
     if ($parentIds) {
         $childDecrease = $category->getChildrenCount() + 1;
         // +1 is itself
         $data = ['children_count' => new \Zend_Db_Expr('children_count - ' . $childDecrease)];
         $where = ['entity_id IN(?)' => $parentIds];
         $resourceModel->getConnection()->update($resourceModel->getEntityTable(), $data, $where);
     }
 }

 /**
  * Retrieve category attributes
  *
  * @param string $attributeCode
  * @param int|array $categoryIds
  * @param int $storeId
  * @return array
  */
 protected function _getCategoryAttribute($attributeCode, $categoryIds, $storeId)
 {
     $linkField = $this->metadataPool->getMetadata(CategoryInterface::class)->getLinkField();
     $identifierFiled = $this->metadataPool->getMetadata(CategoryInterface::class)->getIdentifierField();
     $connection = $this->getConnection();
     if (!isset($this->_categoryAttributes[$attributeCode])) {
         $attribute = $this->_catalogCategory->getResource()->getAttribute($attributeCode);
         $this->_categoryAttributes[$attributeCode] = ['entity_type_id' => $attribute->getEntityTypeId(), 'attribute_id' => $attribute->getId(), 'table' => $attribute->getBackend()->getTable(), 'is_global' => $attribute->getIsGlobal(), 'is_static' => $attribute->isStatic()];
         unset($attribute);
     }
     if (!is_array($categoryIds)) {
         $categoryIds = [$categoryIds];
     }
     $attributeTable = $this->_categoryAttributes[$attributeCode]['table'];
     $select = $connection->select();
     $bind = [];
     if ($this->_categoryAttributes[$attributeCode]['is_static']) {
         $select->from($this->getTable('catalog_category_entity'), ['value' => $attributeCode, 'entity_id' => 'entity_id'])->where('entity_id IN(?)', $categoryIds);
     } elseif ($this->_categoryAttributes[$attributeCode]['is_global'] || $storeId == 0) {
         $select->from(['t1' => $this->getTable('catalog_category_entity')], [$identifierFiled])->joinLeft(['e' => $attributeTable], "t1.{$linkField} = e.{$linkField}", ['value'])->where("t1.{$identifierFiled} IN(?)", $categoryIds)->where('e.attribute_id = :attribute_id')->where('e.store_id = ?', 0);
         $bind['attribute_id'] = $this->_categoryAttributes[$attributeCode]['attribute_id'];
     } else {
         $valueExpr = $connection->getCheckSql('t2.value_id > 0', 't2.value', 't1.value');
         $select->from(['t1' => $attributeTable], [$identifierFiled => 'e.' . $identifierFiled, 'value' => $valueExpr])->joinLeft(['t2' => $attributeTable], "t1.{$linkField} = t2.{$linkField} AND t1.attribute_id = t2.attribute_id AND t2.store_id = :store_id", [])->joinLeft(['e' => $this->getTable('catalog_category_entity')], "e.{$linkField} = t1.{$linkField}", [])->where('t1.store_id = ?', 0)->where('t1.attribute_id = :attribute_id')->where("e.entity_id IN(?)", $categoryIds)->group('e.entity_id');
         $bind['attribute_id'] = $this->_categoryAttributes[$attributeCode]['attribute_id'];
         $bind['store_id'] = $storeId;
     }
     $rowSet = $connection->fetchAll($select, $bind);
     $attributes = [];
     foreach ($rowSet as $row) {
         $attributes[$row[$identifierFiled]] = $row['value'];
     }
     unset($rowSet);
     foreach ($categoryIds as $categoryId) {
         if (!isset($attributes[$categoryId])) {
             $attributes[$categoryId] = null;
         }
     }
     return $attributes;
 }

 /**
  * Retrieve category attributes
  *
  * @param string $attributeCode
  * @param int|array $categoryIds
  * @param int $storeId
  * @return array
  */
 protected function _getCategoryAttribute($attributeCode, $categoryIds, $storeId)
 {
     $adapter = $this->_getWriteAdapter();
     if (!isset($this->_categoryAttributes[$attributeCode])) {
         $attribute = $this->_catalogCategory->getResource()->getAttribute($attributeCode);
         $this->_categoryAttributes[$attributeCode] = ['entity_type_id' => $attribute->getEntityTypeId(), 'attribute_id' => $attribute->getId(), 'table' => $attribute->getBackend()->getTable(), 'is_global' => $attribute->getIsGlobal(), 'is_static' => $attribute->isStatic()];
         unset($attribute);
     }
     if (!is_array($categoryIds)) {
         $categoryIds = [$categoryIds];
     }
     $attributeTable = $this->_categoryAttributes[$attributeCode]['table'];
     $select = $adapter->select();
     $bind = [];
     if ($this->_categoryAttributes[$attributeCode]['is_static']) {
         $select->from($this->getTable('catalog_category_entity'), ['value' => $attributeCode, 'entity_id' => 'entity_id'])->where('entity_id IN(?)', $categoryIds);
     } elseif ($this->_categoryAttributes[$attributeCode]['is_global'] || $storeId == 0) {
         $select->from($attributeTable, ['entity_id', 'value'])->where('attribute_id = :attribute_id')->where('store_id = ?', 0)->where('entity_id IN(?)', $categoryIds);
         $bind['attribute_id'] = $this->_categoryAttributes[$attributeCode]['attribute_id'];
     } else {
         $valueExpr = $adapter->getCheckSql('t2.value_id > 0', 't2.value', 't1.value');
         $select->from(['t1' => $attributeTable], ['entity_id', 'value' => $valueExpr])->joinLeft(['t2' => $attributeTable], 't1.entity_id = t2.entity_id AND t1.attribute_id = t2.attribute_id AND t2.store_id = :store_id', [])->where('t1.store_id = ?', 0)->where('t1.attribute_id = :attribute_id')->where('t1.entity_id IN(?)', $categoryIds);
         $bind['attribute_id'] = $this->_categoryAttributes[$attributeCode]['attribute_id'];
         $bind['store_id'] = $storeId;
     }
     $rowSet = $adapter->fetchAll($select, $bind);
     $attributes = [];
     foreach ($rowSet as $row) {
         $attributes[$row['entity_id']] = $row['value'];
     }
     unset($rowSet);
     foreach ($categoryIds as $categoryId) {
         if (!isset($attributes[$categoryId])) {
             $attributes[$categoryId] = null;
         }
     }
     return $attributes;
 }

 public function getObject(Category $category)
 {
     /** @var $productCollection Mage_Catalog_Model_Resource_Product_Collection */
     $productCollection = $category->getProductCollection();
     $productCollection = $productCollection->addMinimalPrice();
     $category->setProductCount($productCollection->getSize());
     $transport = new DataObject();
     $this->eventManager->dispatch('algolia_category_index_before', ['category' => $category, 'custom_data' => $transport]);
     $customData = $transport->getData();
     $storeId = $category->getStoreId();
     $category->getUrlInstance()->setStore($storeId);
     $path = '';
     foreach ($category->getPathIds() as $categoryId) {
         if ($path != '') {
             $path .= ' / ';
         }
         $path .= $this->getCategoryName($categoryId, $storeId);
     }
     $image_url = null;
     try {
         $image_url = $category->getImageUrl();
     } catch (\Exception $e) {
         /* no image, no default: not fatal */
     }
     $data = ['objectID' => $category->getId(), 'name' => $category->getName(), 'path' => $path, 'level' => $category->getLevel(), 'url' => $category->getUrl(), 'include_in_menu' => $category->getIncludeInMenu(), '_tags' => ['category'], 'popularity' => 1, 'product_count' => $category->getProductCount()];
     if (!empty($image_url)) {
         $data['image_url'] = $image_url;
     }
     foreach ($this->config->getCategoryAdditionalAttributes($storeId) as $attribute) {
         $value = $category->getData($attribute['attribute']);
         $attribute_resource = $category->getResource()->getAttribute($attribute['attribute']);
         if ($attribute_resource) {
             $value = $attribute_resource->getFrontend()->getValue($category);
         }
         if (isset($data[$attribute['attribute']])) {
             $value = $data[$attribute['attribute']];
         }
         if ($value) {
             $data[$attribute['attribute']] = $value;
         }
     }
     $data = array_merge($data, $customData);
     foreach ($data as &$data0) {
         $data0 = $this->try_cast($data0);
     }
     return $data;
 }

 /**
  * Validate category process
  *
  * @param  Category $category
  * @return void
  * @throws \Magento\Framework\Model\Exception
  */
 protected function validateCategory(Category $category)
 {
     $useConfigFields = [];
     foreach ($this->useConfigFields as $field) {
         if (!$category->getData($field)) {
             $useConfigFields[] = $field;
         }
     }
     $category->setData('use_post_data_config', $useConfigFields);
     $validate = $category->validate();
     if ($validate !== true) {
         foreach ($validate as $code => $error) {
             if ($error === true) {
                 $attribute = $category->getResource()->getAttribute($code)->getFrontend()->getLabel();
                 throw new \Magento\Framework\Model\Exception(__('Attribute "%1" is required.', $attribute));
             } else {
                 throw new \Magento\Framework\Model\Exception($error);
             }
         }
     }
     $category->unsetData('use_post_data_config');
 }

 /**
  * {@inheritdoc}
  */
 public function getResource()
 {
     $pluginInfo = $this->pluginList->getNext($this->subjectType, 'getResource');
     if (!$pluginInfo) {
         return parent::getResource();
     } else {
         return $this->___callPlugins('getResource', func_get_args(), $pluginInfo);
     }
 }