Filtering in the back end

[actioncs]

Hi Jan

I am using a very large number of categories. I know there is a "fill out yourself" filter but it would be very useful ( and quicker ) to have a filter with a drop down filtering menu like Joomla has for articles etc. ie giving access to the category tree. Unless there is a tool for doing this and I cannot see it.

many thanks

Wayne

[Jan]

Hi, I don't understand correctly what you mean. Which view you mean?

[actioncs]

It's in the "Phoca Gallery Categories ". It would be useful to filter by parent categories and different sub category levels below them via a drop down, similar to the filter on the "Phoca Gallery Images ".

I have fifty or so categories but most are sub categories and sub sub categories even sub sub sub categories.
I know there is a filter input field but some categories are very long to type in.

eg On the Land>>2010 Rodeo championship>>Bull Riding Finals 20.10.2010

I hope you see what i mean ?

I's not a big issue and I might seem a bit lazy but it would help with workflow.

Many thanks

Wayne

[Jan]

Hi, there was the select box for displaying only specific category, the problem is, categories are stored in tree, so there were some unexpected problems with this filtering and it produces outcomes which can be confusing for users, this is why it was removed from there. So I think this needs to be customized to fit exactly your needs

Jan

[dethisandthat]

I noticed when a filter word is given, the SQL actually returned the correct dataset but in the function _categoryTree, those dataset is eliminated. Instead of trying to play around the recursive function _categoryTree, I let the SQL to retrieve all categories regardless of the filter word and looping through the array to filter base on the filter word.

Below is my code changes:

Phoca Gallery version 2.7.4
File: \Joomla\administrator\components\com_phocagallery\models\phocagallerycs.php

Code: Select all

	function _buildContentWhere() {
		blah blah

		//~ we want to retrieve all datas then later filter the element by $search using code
		//~ if ($search) {
			//~ $where[] = 'LOWER(a.title) LIKE '.$this->_db->Quote('%'.$search.'%');
		//~ }
		if ( $filter_state ) {

Code: Select all

	function getData() {
		global $mainframe;
		if (empty($this->_data)) {
			blah blah

			$this->_data = $this->_categoryTree($this->_data, $tree, 0, $text, -1);

			//added begin
			$search= $mainframe->getUserStateFromRequest( $this->_context.'.search', 'search', '', 'string' );
			$search= JString::strtolower( $search );

			//filter the result with $search text
			$this->_data = $this->filterArray($this->_data, $search);
			//added end
			return $this->_data;

add the function filterArray inside the phocagallerycs.php

Code: Select all

    //~ return a copy of $collection which is filtered by $filterText
    function filterArray($collection, $filterText) {
        if ($filterText=='') {
            return $collection;
        }
        foreach($collection as $key=>$value){
            if (stripos($value->title, $filterText)===FALSE)
                  unset($collection[$key]);
            }
        return $collection;
    }

[Jan]

Hi, thank you for this guide, I will take a look at it.

Jan

[apictapx]

Have a situation with more than 700 categories and search function was important.
Thanks, dethisandthat. Made some updates in code for version 3.2.6 and Search filter became to work for categories with any level.

[Jan]

Ok, will be great to get info about the changes.

Jan