一、初始化Object对象

$objectManager =  \Magento\Framework\App\ObjectManager::getInstance();    

//当前店铺 $storeManager = $objectManager->get('\Magento\Store\Model\StoreManagerInterface'); var_dump($storeManager->getStore()->getData());

//当前系统时区

$dateObj = $objectManager->get('\Magento\Framework\Stdlib\DateTime\TimezoneInterface'); 

$timezone = $dateObj->getConfigTimezone(); // Asia/Tokyo

 

一、直接操作数据库

    备注：用以下方式，可以防sql注入

    $query = $this->_connection->select()->from('eav_attribute')->where('attribute_id=?', $attributeId);

    $result = $this->_connection->fetchAll($query);

 

三、判断用户是否已登陆

$objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $customerSession = $objectManager->get('Magento\Customer\Model\Session'); if(!$customerSession->isLoggedIn()) {     //未登陆 }else{     //已登陆 }

 

四、类目和当前类目产品列表

protected $categoryFactory;

public function __construct (Action\Context $context, \Magento\Catalog\Model\CategoryFactory $categoryFactory) {

$this->categoryFactory = $categoryFactory;

parent::__construct($context);

}

protected function execute() {

//获取分类列表

$categoryCollection = $this->categoryFactory->create()->getCollection();

$categoryCollection->addFieldToSelect(['name']);

$categoryCollection->addAttributeToFilter('level', 2);

$categoryCollection->addAttributeToFilter('is_active', 1); //确保该分类是启用的

$categoryCollection->addAttributeToFilter('include_in_menu', 1);

$categoryCollection->setOrder('position','ASC');

foreach ($categoryCollection as $category){

echo $category->getId();//类目ID

$products = $this->_getProductList($category);//获取当前类目下的产品

}

}

/**获取当前类目下的产品**/

protected function _getProductList ($category) {

$productCollection = $category->getProductCollection();//获取该类目产品

$productCollection->addMinimalPrice()->addUrlRewrite();

$productCollection->addAttributeToSelect(['name', 'small_image',]);

$productCollection->addAttributeToFilter('visibility', array('neq' => 1));// 确保该产品是可见的

$productCollection->addAttributeToFilter('status', 1);// 确保该产品是启用的

$productCollection->setPageSize(20);// 限制该 collection 的结果

$productCollection->setOrder('position','ASC');//排序

//组装数据

$productsArr = [];

foreach ($productCollection as $product){

$data = $product->getData();

$productsArr['products'][] = $data;

}

return $productsArr;

}

 

五 、获取指定类目的产品

        $category = $this->categoryFactory->create()->load(51);

        //var_dump($category->getId());exit;

        $collection = $this->_productCollectionFactory->create();

        $collection->addAttributeToSelect('*');         //$collection->addAttributeToFilter('entity_id', 30);         $collection->addCategoryFilter($category);//获取         //$collection->setPageSize(3); // fetching only 3 products         foreach ($collection as $key => $pro) {             var_dump($pro->getId());         }

六、获取配置产品下的所有单品

七、产品

    1、例子一

    private $productRepository;

    public function __construct(\Magento\Catalog\Model\ProductRepository $productRepository) {

        $this->productRepository = $productRepository;     }

    public function execute()

    {

        $productId = $this->getRequest()->getParam('product_id');

        $product = $this->productRepository->getById($productId);

         $category_ids = $product->getCategoryIds(); //获取产品类目，array(0=>'2',1=>'10',2=>'20')

    }

    2、例子二

    public function _initProduct()

    {         $productId = (int)$this->getRequest()->getParam('product');         if ($productId) {             $storeId = $this->_objectManager->get(                 \Magento\Store\Model\StoreManagerInterface::class             )->getStore()->getId();             try {                 return $this->productRepository->getById($productId, false, $storeId);//             } catch (NoSuchEntityException $e) {                 return false;             }         }         return false;     }

    3、例子三

    protected $productFactory;

    public function __construct(         \Magento\Catalog\Model\ProductFactory $productFactory     ) {         $this->productFactory = $productFactory;     }     public function render(\Magento\Framework\DataObject $row)     {

        $product = $this->productFactory->create()->load($row->getProductId());

        return $product->getSku();     }

    例子4：get product by sku or id

    $productRepository = $this->_objectManager->get('\Magento\Catalog\Model\ProductRepository');

    $product = $productRepository->get($sku);//by sku

    $product = $productRepository->getById($productId);//by id