Gossamer Forum: Products: Gossamer Links: Discussions: List of Categoies

Jan 12, 2011, 5:29 AM

nir

User (396 posts)

Jan 12, 2011, 5:29 AM

Post #1 of 5

Shortcut

List of Categoies

Can I send list of LinkID and get all the category that the LinkID submit in.
So if I send list like “222,333,444,555,111,12” I will get list of category.

Jan 12, 2011, 7:56 AM

Andy

Veteran / Moderator (18441 posts)

Jan 12, 2011, 7:56 AM

Post #2 of 5

Shortcut

Re: [nir] List of Categoies In reply to

You wanna submit a list of ID's, and then return ALL the categories those are listed in?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 13, 2011, 1:32 AM

nir

User (396 posts)

Jan 13, 2011, 1:32 AM

Post #3 of 5

Shortcut

Re: [Andy] List of Categoies In reply to

Yes

Jan 13, 2011, 1:43 AM

Andy

Veteran / Moderator (18441 posts)

Jan 13, 2011, 1:43 AM

Post #4 of 5

Shortcut

Re: [nir] List of Categoies In reply to

Should be pretty simple:

get_cats_for_links

Code:
sub { 

	my $link_ids; 
	foreach (split /,/, $_[0]) { 
		push @$link_ids, $_; 
	} 

	my $sth = $DB->table('CatLinks')->select( ['DISTINCT(CategoryID)'], GT::SQL::Condition->new('LinkID','IN',$link_ids) ) || die $GT::SQL::error; 
	my @categories; 
	while (my $cat_id = $sth->fetchrow) { 
		my $cat = $DB->table('Category')->get( { ID => $cat_ids } ); 
		   $cat->{URL} = $CFG->{build_root_url} . "/" . $DB->table('Category')->as_url( $cat->{Full_Name} ) . "/" . $CFG->{build_index}; 
		push @categories, $cat; 
	} 

	return { categorys_links_are_in_loop => \@categories }; 

}

..then call with:

Code:
<%get_cats_for_links('123,434,345,765')%> 
<%loop categorys_links_are_in_loop%> 
   <%include subcategory.html%> 
<%endloop%>

Untested, but should work Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 13, 2011, 2:18 AM

nir

User (396 posts)

Jan 13, 2011, 2:18 AM

Post #5 of 5

Shortcut

Re: [Andy] List of Categoies In reply to

Thanks, it's work