使用简单可配置的Magento分层导航过滤器

1 回答

• -1

  您必须通过在core / Mage目录中复制核心文件来自定义核心文件 .

  假设您必须改变尺寸和颜色 .

  打开文件 app\code\core\Mage\Catalog\Model\Layer.php

  在以下代码之后： -

  $collection
    ->addAttributeToSelect(
      Mage::getSingleton('catalog/config')->getProductAttributes()
    )
    ->addMinimalPrice()
    ->addFinalPrice()
    ->addTaxPercents()
    ->addUrlRewrite($this->getCurrentCategory()->getId());
  

  您必须为所选属性自定义它： -

  例如 ：-

  if(isset($_GET['size']))
      {
          $query = 'SELECT value FROM aw_layerednavigation_filter_option_eav WHERE name="title" AND option_id IN ( '.$_GET['size'].' )';
          $results = $readConnection->fetchAll($query);
          $sizeLabels = array();
          foreach($results as $_r){
              $size_labels[] = $_r['value'];
          }
  
          $query = 'SELECT parent_id FROM advance_filter WHERE size IN ( '.implode(",",$size_labels).' ) AND qty > 0';
  
          $results = $readConnection->fetchAll($query);
          foreach($results as $_r){
              $size_prod_Ids[] = $_r['parent_id'];
          }   
      }
      $color_prod_Ids = array();
      if(isset($_GET['color']))
      {
          $query = 'SELECT value FROM aw_layerednavigation_filter_option_eav WHERE name="title" AND option_id IN ( '.$_GET['color'].' )';
          $results = $readConnection->fetchAll($query);
          $color_labels = array();
          foreach($results as $_r){
              $color_labels[] = strtoupper($_r['value']);
          }
  
          $query = 'SELECT parent_id FROM advance_filter WHERE color IN ( "'.implode(",",$color_labels).'" ) AND qty > 0';
  
          $results = $readConnection->fetchAll($query);
          foreach($results as $_r){
              $color_prod_Ids[] = $_r['parent_id'];
          }
      }
      $productIds = array_merge($size_prod_Ids,$color_prod_Ids);
      if(count($productIds) > 0){
          $collection->addAttributeToFilter('entity_id', array('in' => array_unique($productIds)));
      }
  

  希望这会有所帮助.. !!

  回复于 2024-04-24T09:48:57+08:00