How to filter the nextmatch widget by category?

[Ki_Setargilop]

Hi there,

Please give me some light on how to filter the nextmatch widget when clicking on the item of category drop down box. I have already the list of the categories but when i clicked it nothing happens to the table. No filter occur.
Any help will be appreciated.

Thanks,
Gil

[ngegw]

Hi there,

Please give me some light on how to filter the nextmatch widget when
clicking on the item of category drop down box. I have already the list of
the categories but when i clicked it nothing happens to the table. No filter
occur.

Filtering is done in your get_rows function.
When called, $query parameter will have the selected ‘cat_id’ entry.

---

This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Ki_Setargilop]

I have already the cat_id=62 (for example) but still the table returns all rows, no filtering happens.

Please advise further. If possible, share me some code snippet.



Thanks,

Gil

 

[ngegw]

Actual usage depends on your SO backend. If your app is creating queries
itself, use that cat_id in your SQL query as appropriate.
If you are extending so_sql or so_sql_cf, your table needs a cat_id column;
filtering should be done automatically.

Either way, make the needed changes in the code so that your get_rows
function returns the appropriate data based on the filters passed in the
$query parameter.

[Randy_J_Houlahan_B.S]

in your index function $content[‘nm’] = array( ‘no_cat’ => False, // allows the cat selection in your index

…

	if ((int)$query['cat_id'])
	{
		$query['col_filter'][] = $this->bo->so->_cat_filter($query['cat_id']);
		unset($query['cat_id']);
	}

where

_cat_filter($query[‘cat_id’]); =

	function _cat_filter($cat_id,$cat_col_name='mat_cat_id')
	{
		if (!is_object($GLOBALS['egw']->categories))
		{
			$GLOBALS['egw']->categories = CreateObject('phpgwapi.categories');
		}
		foreach($GLOBALS['egw']->categories->return_all_children((int)$cat_id) as $cat)
		{//print_r($cat_id);die();
			$cat_filter[] = $this->db->concat("','",$cat_col_name,"','")." LIKE '%,$cat,%'";
		}
		return '('.implode(' OR ',$cat_filter).')';
	}

[Randy_J_Houlahan_B.S]

           if ((int)$query['cat_id']) 
            { 
                    $query['col_filter'][] = $this->bo->so->_cat_filter($query['cat_id']); 
                    unset($query['cat_id']); 
            } 

is in the get rows function …

query is used in the so_sql call to search

search(array($where),false,$query[‘order’]?$query[‘order’].’ ‘.$query[‘sort’]:’’,’’,’%’,false,‘OR’,(int)$query[‘start’],$query[‘col_filter’],$join,$need_full_no_count);