Forum

Thread tagged as: Runway

perch_categories category filtering

I have a category set called 'products' with several categories and subcategories:

products/axles/
products/axles/non-drive-steer-axles/
products/axles/planetary-rigid-axles/
products/axles/planetary-rigid-tandem-axles/
products/axles/planetary-steer-axles/
products/axles/portal-axles/
products/axles/ta-series-axles/
products/brakes/
products/carriers/
products/carriers/carrier-modules/
products/carriers/core-free-carrier-assemblies/
products/components/
products/components/bearings/
products/components/gears/
products/components/electronics/
products/electric-solutions/
products/electric-solutions/axles/
products/suspensions-modules/
products/suspensions-modules/independent-suspensions/
products/suspensions-modules/wheel-end-modules/
products/transfer-cases/
products/transfer-cases/two-speed-transfer-cases/

I'm trying to put all of the subcategory slugs for a particular category into an array so I can loop through the collection items associated with the subcategories. This is what I've tried:

          $prod_cats = perch_categories([
            'category'=>'products/axles',
            'category-match'=>'all',
            'template'=>'_cat_slug.html',
            'skip-template'=>true,
          ]);
          print "<pre>";
          print_r($prod_cats);
          print "</pre>";

_cat_slug.html:

<perch:category id="catSlug" type="slug" for="catTitle" />

and this is the output:

How can I get only the subcategories from the 'products/axles' category? Ultimately, all I'm trying to do is list all collection items in the 'products/axles' category, separated by their subcategories. If there's a better way to do that, I'm all ears!

Diagnostics:

Diagnostics report
HEALTH CHECK

Perch Runway is up to date
PHP 5.6.14-1+deb.sury.org~trusty+1 is up to date
MySQL 5.5.46-0ubuntu0.14.04.2 is up to date
Image processing available
SUMMARY INFORMATION

Perch Runway: 2.8.31, PHP: 5.6.14-1+deb.sury.org~trusty+1, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $, with PDO
Server OS: Linux, apache2handler
Installed apps: content (2.8.31), assets (2.8.31), categories (2.8.31), perch_blog (5.0), perch_events (1.9.3), perch_forms (1.8.3)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_blog', 'perch_events', 'perch_forms', );
PERCH_LOGINPATH: /at-admin
PERCH_PATH: /var/www/public/axletech.dev/at-admin
PERCH_CORE: /var/www/public/axletech.dev/at-admin/core
PERCH_RESFILEPATH: /var/www/public/axletech.dev/at-admin/resources
Image manipulation: GD Imagick
PHP limits: Max upload 100M, Max POST 100M, Memory: 128M, Total max file upload: 100M
F1: 2edba60ed1f613d6dd804feb202456a2
Resource folder writeable: Yes
HTTP_HOST: axletech.dev
DOCUMENT_ROOT: /var/www/public/axletech.dev
REQUEST_URI: /at-admin/core/settings/diagnostics/
SCRIPT_NAME: /at-admin/core/settings/diagnostics/index.php

Shane Lenzen 18 points

5 years ago

Shane Lenzen 18 points

5 years ago

Tried this, too:

          $prod_cats = perch_categories([
            'filter'=>'catPath',
            'match'=>'contains',
            'value'=>'products/axles/',
            'template'=>'_cat_slug.html',
            'skip-template'=>true,
          ]);
          print "<pre>";
          print_r($prod_cats);
          print "</pre>";

But that output is:

Array
(
)

Not sure what I'm doing wrong.

Robert Ketter 103 points

5 years ago

Shane, I think you need to filter catDepth if all you want is sub-cats

Robert Ketter 103 points

5 years ago

Robert Ketter said:

Shane, I think you need to filter catDepth if all you want is sub-cats

rk

Oops, I think I gave wrong advice here after a quick search...

Robert Ketter 103 points

5 years ago

See if this answers your problem/question

https://forum.grabaperch.com/forum/05-24-2016-perch-custom-to-grab-subcategories-not-parent

Shane Lenzen 18 points

5 years ago

Thanks Robert, but that doesn't help in my particular case. I need to loop through the subcategories so I can display the products separated by subcategory, something like:

<div class="productList">
    <h2>Subcat 1</h2>
    <ul>
        <li>Product 1</li>
        <li>Product 2</li>
        <li>Product 3</li>
    </ul>
    <h2>Subcat 2</h2>
    <ul>
        <li>Product 1</li>
        <li>Product 2</li>
    </ul>
</div>

...etc. It seems I can't use perch:if different="" because it has to be used within <perch:categories>. So, I figure I need to loop through the subcategories. The problem is, if you look at the array output from my first post, I can't seem to get perch_categories() to only output the subcats from 'products/axles'. Instead, it's showing all sets, categories and subcats (like products/brakes, markets, markets/mining, etc).

Drew McLellan 2638 points
Perch Support

5 years ago

You can't filter categories by category, as categories aren't categorised. Filter them by their path:

perch_categories([
    'filter' => 'catPath',
    'match' => 'contains',
    'value' => 'products/axles/?',
]);

Shane Lenzen 18 points

5 years ago

That question mark did it. Thanks Drew! FYI the docs for perch_categories() list 'category' as an option https://docs.grabaperch.com/docs/categories/page-functions/

Drew McLellan 2638 points
Perch Support

5 years ago

That's a general list of options that applies to any function based on the same infrastructure. I mean you technically could put categories in categories, but like wtf.

Shane Lenzen 18 points

5 years ago

mind blown

Shane Lenzen 18 points

5 years ago

Hi again. So this:

          $prod_cats = perch_categories([
            'filter'=>'catPath',
            'match'=>'contains',
            'value'=>'products/'.$currentURI[3].'/?',
            'skip-template'=>true,
          ]);
          print "<pre>";
          print_r($prod_cats);
          print "</pre>";

Gives me this:

Which is great! But when I try:

          $prod_cats = perch_categories([
            'filter'=>[
              [
                'filter'=>'catPath',
                'match'=>'contains',
                'value'=>'products/'.$currentURI[3].'/?',
              ],
              [
                'filter'=>'catDepth',
                'match'=>'gt',
                'value'=>1,
              ],
            ],
            'skip-template'=>true,
          ]);

The array is empty. Any idea why?

Drew McLellan 2638 points
Perch Support

5 years ago

catDepth isn't a value in the database. You'd need to do this;

perch_categories([
    'filter'=>[
          [
            'filter'=>'catPath',
            'match'=>'contains',
            'value'=>'products/t-shirts/?',
          ],
          [
            'filter'=>'LENGTH(catTreePosition) - LENGTH(REPLACE(catTreePosition, "-", ""))',
            'match'=>'eq',
            'value'=>2,
          ],
        ],
]);

Shane Lenzen 18 points

5 years ago

Well I definitely wouldn't have figured that out on my own. Thanks again!

Drew McLellan 2638 points
Perch Support

5 years ago

Turns out there's lots of stuff you can do, just nobody ever does.

Forum

perch_categories category filtering

Shane Lenzen 18 points

Shane Lenzen 18 points

Robert Ketter 103 points

Robert Ketter 103 points

Robert Ketter 103 points

Shane Lenzen 18 points

Drew McLellan 2638 points Perch Support

Shane Lenzen 18 points

Drew McLellan 2638 points Perch Support

Shane Lenzen 18 points

Shane Lenzen 18 points

Drew McLellan 2638 points Perch Support

Shane Lenzen 18 points

Drew McLellan 2638 points Perch Support

Drew McLellan 2638 points
Perch Support

Drew McLellan 2638 points
Perch Support

Drew McLellan 2638 points
Perch Support

Drew McLellan 2638 points
Perch Support