magento - 通过storeid,分类id，天数（几天内）得到产品

最新推荐文章于 2020-05-21 23:06:43 发布

TerryWater

最新推荐文章于 2020-05-21 23:06:43 发布

阅读量1k

点赞数

分类专栏： MAGENTO

本文链接：https://blog.csdn.net/terry_water/article/details/19340601

版权

MAGENTO 专栏收录该内容

186 篇文章 1 订阅

订阅专栏

//通过 $storeId,分类id，几天之前的数据。返回 $products

  public function getBestsellingProducts($storeId,$category_id,$days)
    {  
        $productCount = 4;
        $today = time();
        $last = $today - (60*60*24*$days);
    
        $from = date("Y-m-d", $last);
        $to = date("Y-m-d", $today);
         
        // get most viewed products for current category
        $products = Mage::getResourceModel('reports/product_collection')
                        ->addAttributeToSelect('*')     
                        ->addOrderedQty($from, $to)
                        ->setStoreId($storeId)
                        ->addCategoryFilter(Mage::getModel('catalog/category')->load($category_id))
                        ->addStoreFilter($storeId)                  
                        ->setOrder('ordered_qty', 'desc')
                        ->setPageSize($productCount);
         
        Mage::getSingleton('catalog/product_status')
                ->addVisibleFilterToCollection($products);
        Mage::getSingleton('catalog/product_visibility')
                ->addVisibleInCatalogFilterToCollection($products);
         
        return $products;
    }