Admin category listing to show number of products

[havenswift-hosting]

It would be very useful to show a count of the number of products in each category - maybe between "Category Name" and "Translations" columns

[bhsmither]

In categories.index.php, suggest:

From:
      <td>{$LANG.settings.category_name}</td>
      <td>{$LANG.translate.title_translations}</td>
To:
      <td>{$LANG.settings.category_name}</td>
      <td>Prod P/A</td>
      <td>{$LANG.translate.title_translations}</td>
From:
        {$category.cat_name}
        {/if}
        </td>
        <td style="text-align:center" class="language_list">
To:
        {$category.cat_name}
        {/if}
        </td>
        <td style="text-align:center">{$category.pri_alt}</td>
        <td style="text-align:center" class="language_list">

In categories.index.inc.php, suggest:

Near line 445, from:
            $category['children'] = currentPage(null, array('parent' => $category['cat_id']));
            $category['translate'] = currentPage(null, array('action' => 'translate', 'cat_id' => $category['cat_id']));
            $category['edit']  = currentPage(null, array('action' => 'edit', 'cat_id' => $category['cat_id']));
To:
            $cat_sel = $GLOBALS['db']->select('CubeCart_category_index', array('primary'), array('cat_id' => $category['cat_id']));
            $category['pri_alt'] = (array_count_values(array_column($cat_sel, 'primary'))['1'] ?? '--').'/'.(array_count_values(array_column($cat_sel, 'primary'))['0'] ?? '--');
            $category['children'] = currentPage(null, array('parent' => $category['cat_id']));
            $category['translate'] = currentPage(null, array('action' => 'translate', 'cat_id' => $category['cat_id']));
            $category['edit']  = currentPage(null, array('action' => 'edit', 'cat_id' => $category['cat_id']));

The new column will show a number/number that represents the number of products where this category is the primary category, followed by the number of products that claim this category as an alternate category.

[abrookbanks]

This gives me an error.

categories.index.inc.php:443 - array_column(): Argument #1 ($array) must be of type array, bool given

Will see if I can fix it.

[bhsmither]

So $cat_sel is false because there is nothing in CubeCart_category_index having that 'cat_id'?

Did you create a category without having assigned any products to it yet? Ok, that's legit.

[bhsmither]

This is my fix, although I do not know why this wasn't noticed:

$cat_sel = $GLOBALS['db']->select('CubeCart_category_index', array('primary'), array('cat_id' => $category['cat_id'])) ?: array();

Gives $cat_sel an empty array if nothing found.

[abrookbanks]

Something still odd. This store has hundreds of products...

[abrookbanks]

Actually that's right! This shops mostly has products in the subcategory.

[abrookbanks]

Thanks.

[abrookbanks]

Should we just show the total? I find this confusing to look at.

[abrookbanks]

.. sorry for the message trail. Or show total but hover a title saying the primary/additional ratio.

[havenswift-hosting]

I also find this a bit confusing - I think just a simple count for products in that specific category would be clearer

[abrookbanks]

I also find this a bit confusing - I think just a simple count for products in that specific category would be clearer

Yes I agree. We can add a title tag for the split.

[abrookbanks]

Mouse pointer isn't in the screenshot but on hover of the count number we can break it down.

[bhsmither]

Is there a way to indicate additional info available via hover? Maybe append the white 'i' in blue circle icon?

[abrookbanks]

Does this look weird?

[abrookbanks]

IMO the ABBR tag looks better.

[abrookbanks]

On two lines it looks better still.

[abrookbanks]

I think this is good now. Thanks all.

[bhsmither]

The last edit I see is opening with <abbr> but closing with </span>.

[abrookbanks]

Thanks. I think the (i) looks bad personally. I've got vision problems at the moment so your QA is much appreciated.

[abrookbanks]

Maybe a count including all subfolders would be even better.🫣

[bhsmither]

Because I run a 4k monitor, these little dots (via <abbr>) are so barely visible - absolutely overlooked unless you know that they are there. Also, personally, the little dots under the number is not familiar to me - I do (did) not know what that means.

[bhsmither]

Might want to give some thought to incorporating the Search icon in the Actions column -- co-opt its tooltip.

[abrookbanks]

Probably the best overall solution.

[havenswift-hosting]

That is great thanks !