FrontAccounting forum — Adding Item Category Filter to the core

Re: Adding Item Category Filter to the core

2018-07-03T15:59:17Z

Good to know. The setting can be made in the $opts array (fifth argument):

stock_items_list('stock_id', null, false, false, array('where'=>'s.category_id='.$filter_cat));

Re: Adding Item Category Filter to the core

2018-07-03T14:49:19Z

As stated above proposed changes in list helpers functions are not necessary, so the patch will not be integrated. But, yes, using get_post() is encouraged in such a context.
J.

Re: Adding Item Category Filter to the core

2018-07-03T14:24:06Z

This is good to use when the customers has more categories and each one has more items.

But the feature has to be used in reports page mainly.

Rep306 - Inventory Purchasing Report has the items category, when the user select a category, we can shortlist the items in the list on the next drop down. So its good to use this feature.

And i have one more suggestion, if possible we can use the "get_post()" within the list function like this.

if (get_post('category') )
        $sql .= " AND s.category_id='" . get_post('category') . "'";

Re: Adding Item Category Filter to the core

2018-07-03T14:05:11Z

The patch contains only changes in stock_items list helpers, which are not necessary. You can have the same effect on the current FA version passing required filter in 'where' options, e.g.:

stock_items_list('stock_id', null, false, array('where'=>'s.categpry_id='.$filter_cat));

Janusz

Re: Adding Item Category Filter to the core

2018-07-03T08:11:55Z

Yes this is Necessary. We shall add this in the Core

Adding Item Category Filter to the core

2018-07-03T04:12:04Z

@braathwaate has provided an item category filter mod that can be included in the core.

The attachment has the diff file and the file set for the current core version.

@joe: want to include it into the core?