Gossamer Forum: Products: Gossamer Links: Discussions: categories in 2 different boxes?

Jul 10, 2008, 3:55 AM

Knubbel

User (78 posts)

Jul 10, 2008, 3:55 AM

Post #1 of 6

Shortcut

categories in 2 different boxes?

Hello.

Is it possible to divide categories in 2 different boxes?

I have City-Categories and Shop-Categories.

Now I want divide them.

Shopping:
------------------------------
Shop Cat Shop Cat
Shop Cat Shop Cat
Shop Cat Shop Cat
-----------------------------

City:
----------------------------
City Cat City Cat
City Cat City Cat
City Cat City Cat
---------------------------

Jul 10, 2008, 4:23 AM

Andy

Veteran / Moderator (18441 posts)

Jul 10, 2008, 4:23 AM

Post #2 of 6

Shortcut

Re: [Knubbel] categories in 2 different boxes? In reply to

Hi,

Is this on the homepage, or category pages?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 10, 2008, 4:29 AM

Knubbel

User (78 posts)

Jul 10, 2008, 4:29 AM

Post #3 of 6

Shortcut

Re: [Andy] categories in 2 different boxes? In reply to

It is on the categories page.

I gave the categories a field in the database with a "Yes" and a "No".

Jul 10, 2008, 4:37 AM

Andy

Veteran / Moderator (18441 posts)

Jul 10, 2008, 4:37 AM

Post #4 of 6

Shortcut

Re: [Knubbel] categories in 2 different boxes? In reply to

Hi,

Well, it can be done with a global - but its a little tricky in terms of getting them in 2 columns (putting them in a single column is a piece of cake)

get_2_types_cats

Code:
sub { 

   my $tbl = $DB->Table('Category'); 
      $tbl->select_options('ORDER BY Name ASC'); 

   my (@loop,@loop2); 
   my $sth = $tbl->select( { FatherID => $_[0] }  ) || die $GT::SQL::error; 
   while (my $hit = $sth->fetchrow_hashref) { 
         $hit->{URL} = $CFG->{build_root_url} . '/' . $DB->table('Category')->as_url($hit->{Full_Name}) . '/' . $CFG->{build_index}; 
         if ($hit->{YourField} eq "Yes") {  
            push @loop, $hit; 
        } else { 
            push @loop2, $hit; 
        } 
  } 

 return { Category_Loop_1 => \@loop , Category_Loop_2 => \@loop2 } 

}

CHANGE THE BIT IF RED TO THE NAME YOU GAVE YOUR FIELD!

..call with this in category.html

Code:
<%get_2_types_cats($ID)%> 

<%if Category_Loop_1.length%> 
 <h2>Categories with "Yes"</h2> 
  <%loop Category_Loop_1%> 
   <%include subcategory.html%> 
 <%endloop%> 
<%endif%> 

<%if Category_Loop_2.length%> 
 <h2>Categories with "No"</h2> 
  <%loop Category_Loop_2%> 
   <%include subcategory.html%> 
 <%endloop%> 
<%endif%>

This will ONLY put them in a single column though - i.e

<h2>Categories with "Yes"</h2>
xx
xx
xx
xx
xx

<h2>Categories with "No"</h2>
xx
xx
xx
xx
xx

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 10, 2008, 5:10 AM

Knubbel

User (78 posts)

Jul 10, 2008, 5:10 AM

Post #5 of 6

Shortcut

Re: [Andy] categories in 2 different boxes? In reply to

It runs.

Very great!

I have changed:
my $tbl = $DB->Table('Category');

to:
my $tbl = $DB->table('Category');

Thanks.
Knubbel.

Jul 10, 2008, 5:13 AM

Andy

Veteran / Moderator (18441 posts)

Jul 10, 2008, 5:13 AM

Post #6 of 6

Shortcut

Re: [Knubbel] categories in 2 different boxes? In reply to

Hi,

Glad to hear it =)

Sorry about the typo - do that a lot when rushing through making globals - things like fetchrow_Hashref, ->Table ->Select etc - bit annoying sometimes - and don't always pick them up until they are tested <G>

Cheers

Andy (mod)
andy@ultranerds.co.uk